---

create or replace package body xxwh_sap_domestic_invoice_pkg is

    function fn(p in varchar2) return varchar2 is begin return sys_context('USERENV', 'CURRENT_SCHEMA') || '.' || $$plsql_unit || '.' || p; end fn;

    procedure postProcessPO(po_batch_id varchar2)
    is
    begin
        execute immediate
        '
            update
                SAP_DOMESTIC_INVOICE_PIPO_PIPO_EC t
            set
                "##origin_name" = xxmdg.mdgUtils.systemOriginInstance(t.system_mandant, ''' || xxwh_sap_domestic_invoice_pkg.LOAD_SOURCE || ''')
            where
                t.ETL_TRANSFER_TRANSACTION_ID = :a
        ' using in po_batch_id;      
    end postProcessPO;
end xxwh_sap_domestic_invoice_pkg;
/