Загрузка данных


declare
  l_criterias sys.odciVarchar2List := sys.odciVarchar2List(
 'purchaseRequisition',
 'purchaseRequisitionItem',
 'changedOn',
 'createdBy',
 'creationIdIndicator',
 'deletionIndicator',
 'materialId',
 'purchaseAgreement',
 'purchaseAgreementItem',
 'purchaseOrder',
 'purchaseOrderITem',
 'plantId',
 'currency',
 'deliveryDate',
 'documentType',
 'processStatuss',
 'purchaseDocumentCategory',
 'purchaseGroup',
 'requestedQuantity',
 'releaseDate',
 'releaseIndicator',
 'releaseStrategy',
 'storageLocation',
 'unitOfMeasure',
 'valuationPrice',
 'systemMandant'        
  );
  l_key_list sys.odciVarchar2List := sys.odciVarchar2List(
    'purchaseRequisition','purchaseRequisitionItem'
  );
begin
  etl.registerChangesDocument(
    p_document_name         => SAP_EBAN_PURCHASE_REQUISITIONS_PKG.DOCUMENT_NAME,
    p_key_list              => l_key_list,
    p_criterias             => l_criterias,
    p_periodic_group        => 'STD'
  );
end;
/