API: ARP_NOTES_PKG

API: ARP_NOTES_PKG.insert_p to create new AR Notes

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

DECLARE   v_notes_rec ar_notes%rowtype; begin   --Set the org_id for apps 11i   --fnd_client_info.set_org_context('204');     -- set org_id for apps R12   mo_global.init('AR');   mo_global.set_policy_context('S','204');     -- to initialize the variables   v_notes_rec.note_type              := 'MAINTAIN';   v_notes_rec.customer_trx_id        := 759812;   v_notes_rec.text                   := 'AR Notes API Demo form erpSchools.com';   v_notes_rec.customer_call_topic_id := NULL;   v_notes_rec.call_action_id         := NULL;   v_notes_rec.customer_call_id       := NULL;     -- call API   <strong>ARP_NOTES_PKG.insert_p</strong>(v_notes_rec);   commit;   dbms_output.put_line(' Note_id is: ' ||v_notes_rec.note_id); END;

API: ARP_NOTES_PKG.update_p to updated existing AR Notes

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

SET serveroutput ON; DECLARE   v_notes_rec ar_notes%rowtype;   l_note_id NUMBER; BEGIN   -- set the org_id   mo_global.init('AR');   mo_global.set_policy_context('S','204');   --fnd_client_info.set_org_context('204');   -- to initialize the variables   v_notes_rec.note_type              := 'MAINTAIN';   v_notes_rec.customer_trx_id        := 759812;   v_notes_rec.text                   := 'AR Notes API Demo form erpSchools.com (updated)';   v_notes_rec.customer_call_topic_id := NULL;   v_notes_rec.call_action_id         := NULL;   v_notes_rec.customer_call_id       := NULL;   --v_notes_rec.note_id           := l_note_id;   v_notes_rec.last_updated_by   := 1318;   v_notes_rec.last_update_date  := sysdate;   v_notes_rec.last_update_login := 1318;   v_notes_rec.created_by        := 1318;   v_notes_rec.creation_date     := sysdate;   l_note_id                     := 147464; -- note_id     -- call API   <strong>ARP_NOTES_PKG.update_p</strong>(v_notes_rec, l_note_id );   COMMIT;   dbms_output.put_line(' Notes updated successfully'); END;

Few SQL Queries related to this API

1	SELECT * FROM ar_notes WHERE customer_trx_id = 759812; 1 SELECT * FROM ra_customer_trx_all rc WHERE trx_number = '10037843' ; 1 SELECT * FROM hr_organization_units WHERE Name = 'Vision Operations';

Verify from Applications
Navigation: Receivables, Vision Operations > Transactions > Transactions
Query your transaction and go to “Notes” tab