7/22/2019 API to Create New AR Notes

1/1

API to create new AR Notes----------------------------ARP_NOTES_PKG.insert_p----------------------

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;