Tuesday, February 5, 2019

API to update the attribute in AR invoice

API to update the attribute in AR invoice:
 Please find the below script for update the attribute in AR Invoice:

DECLARE 

CURSOR c_ers_num is select trx_number,interface_header_attribute15 from ra_customer_trx_all where trx_number in(select distinct trx_number from XX_AR_CM_APPLY);

BEGIN
for i in c_ers_num loop

update ra_customer_trx_all set interface_header_attribute15=i.interface_header_attribute15 where (trx_number=i.trx_number||'A'
 OR trx_number=i.trx_number||'B' OR trx_number=i.trx_number||'C')
and interface_header_attribute15='Y' and org_id=396;

DBMS_OUTPUT.PUT_LINE('Cursor Invoice#, '||i.trx_number||'A'||' ,Base Invoice Updated Count#, '||sql%rowcount||' ,Cursor DFF val'||i.interface_header_attribute15);
end loop;
COMMIT;

END;

No comments:

Post a Comment