---

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    t."hash" = cast(
                                rawtohex(
                                  standard_hash(
                                    t."##origin_name" || '' || '' || t."billingDocument" || '' || '' || t."billingDocumentItem",
                                    ''SHA256''
                                  )
                                )
                                as varchar2(256 char)
                              )
            where  t.ETL_TRANSFER_TRANSACTION_ID = :a
        ' using in po_batch_id;
    end postProcessPO;
end xxwh_sap_domestic_invoice_pkg;
/