---

declare

  l_critarias sys.odciVarchar2List :=

      sys.odciVarchar2List(
       'vesselLoadItem_id',
       'vesselLoadItem_vesselLoadId',
       'vesselLoadItem_prepartyId',
       'vesselLoadItem_portId',
       'vesselLoadItem_portName',
       'vesselLoadItem_portDescription',
       'vesselLoadItem_incotermsId',
       'vesselLoadItem_incotermsName',
       'vesselLoadItem_incotermsCode',
       'vesselLoadItem_volume',
       'vesselLoadItem_toleranceId',
       'vesselLoadItem_toleranceName',
       'vesselLoadItem_countryId',
       'vesselLoadItem_countryName',
       'vesselLoadItem_countryAlpha2Code',
       'vesselLoadItem_client',
       'vesselLoadItem_version',
       'vesselLoadItem_createdBy',
       'vesselLoadItem_createdDate',
       'vesselLoadItem_lastModifiedBy',
       'vesselLoadItem_lastModifiedDate',
       'vesselLoadItem_deletedBy',
       'vesselLoadItem_deletedDate',
       'vesselLoad_trackId',
       'vesselLoad_trackName',
       'vesselLoad_tbnNum',
       'vesselLoad_terminalId',
       'vesselLoad_terminalCode',
       'vesselLoad_terminalName',
       'vesselLoad_vesselName',
       'vesselLoad_planningLoadingStartDate',
       'vesselLoad_planningLoadingEndDate',
       'vesselLoad_planningLaycanStartDate',
       'vesselLoad_planningLaycanEndDate',
       'vesselLoadStatus',
       'vesselLoad_transportTypeId',
       'vesselLoad_transportTypeName',
       'vesselLoad_vesselId',
       'vesselLoad_vesselImo',
       'vesselLoad_actualLoadingStartDate',
       'vesselLoad_actualLoadingEndDate',
       'vesselLoad_actualLaycanStartDate',
       'vesselLoad_actualLaycanEndDate',
       'vesselLoad_billOfLoadingDate',
       'vesselLoad_comment',
       'vesselLoad_totalVolume',
       'vesselLoad_freightOrder',
       'vesselLoad_version',
       'preparty_comment',  
       'preparty_commercialToleranceId',
       'preparty_commercialToleranceName',
       'preparty_countryId',
       'preparty_countryName',
       'preparty_countryAlpha2Code',
       'preparty_externalId',
       'preparty_client',
       'preparty_incotermsId',
       'preparty_incotermsName',
       'preparty_incotermsCode',
       'preparty_isArchived',
       'preparty_isSold',
       'preparty_loadingPortId',
       'preparty_loadingPortName',
       'preparty_loadingPortDescription',
       'preparty_ppioMonthId',
       'preparty_ppioMonthName',
       'preparty_productId',
       'preparty_productName',
       'preparty_productOriginPlantId',
       'preparty_productOriginPlantName',
       'preparty_productOriginPlantCode',
       'preparty_productOriginPlantManufacturerNormal',
       'preparty_productPackageId',
       'preparty_productPackageName',
       'preparty_productPackageCode',
       'preparty_productNormalId',
       'preparty_productNormalName',
       'preparty_salesChannel',
       'preparty_shipmentEndDate',
       'preparty_shipmentStartDate',
       'preparty_unloadingPortId',
       'preparty_unloadingPortName',
       'preparty_unloadingPortDescription',
       'preparty_version',
       'preparty_volume',
       'mdmProduct_mdmProductId',
       'mdmProduct_shortName',
       'mdmProduct_fullName',
       'mdmProduct_originId',
       'mdmProduct_productOriginPlantName',
       'mdmProduct_productOriginPlantCode',
       'mdmProduct_productOriginPlantManufacturerNormal',
       'mdmProduct_productPackageId',
       'mdmProduct_productPackageName',
       'mdmProduct_productPackageCode',
       'mdmProduct_fkuom',
       'mdmProduct_sapCode',
       'mdmProduct_spossId',
       'mdmProduct_externalId',
       'mdmProduct_mdmStatus',
       'mdmProduct_mdmSentDate',
       'mdmProduct_productId',
       'mdmProduct_version',
       'mdmProduct_id',
       'vesselLoad_terminalPortId',
       'vesselLoad_terminalPortName',
       'vesselLoad_terminalPortDescription'
      ); 

begin

  etl.registerChangesDocument(

    p_document_name         => 'ECAPS_CP_VESSEL_PLAN_EC_ODS',                  -- Parent document
    p_key_list              => sys.odciVarchar2List('vesselLoadItem_id'),    -- Document id combintion
    p_criterias             => l_critarias,                   -- List of columns for change detection
    p_destination_document  => null,                          -- Changes document name. Null for default (default null)
    p_destination_storage   => null,                          -- Changedstorage (table) name. null dor default (defautl null),
    p_initial_upload        => true,                          -- Upload p_document_name => p_destination_document on storage creation as initial changes (defaulkt true)
    p_periodic_group        => 'STD'                          -- Periodic group for actual changes actiovation (default 'STD')

  );

end;

/