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 ARP_NOTES_PKG.insert_p(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 ARP_NOTES_PKG.update_p(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