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;
  • February 5, 2019 | 17 views
  • Comments