To insert notes into AR transaction kindly used ARP_NOTES_PKG.insert_p API.
This API will take record variable as input parameter. we need to assigned value to it as shown in below given script.
================================================
DECLARE
l_notes_rec ar_notes%rowtype;
begin
--apps initialize
mo_global.init('AR');
mo_global.set_policy_context('S', '204');
--
l_notes_rec.customer_trx_id := 1545557; -- Customer_trx_id
l_notes_rec.note_type := 'MAINTAIN';
l_notes_rec.text := 'Test for AR note';
l_notes_rec.customer_call_topic_id := NULL;
l_notes_rec.call_action_id := NULL;
l_notes_rec.customer_call_id := NULL;
-- call API to insert note
ARP_NOTES_PKG.insert_p(l_notes_rec);
--
commit;
dbms_output.put_line('Note inserted reference note id : ' || l_notes_rec.note_id);
END;
==================================================
screenshot for AR invoice workbench transaction notes.
This API will take record variable as input parameter. we need to assigned value to it as shown in below given script.
================================================
DECLARE
l_notes_rec ar_notes%rowtype;
begin
--apps initialize
mo_global.init('AR');
mo_global.set_policy_context('S', '204');
--
l_notes_rec.customer_trx_id := 1545557; -- Customer_trx_id
l_notes_rec.note_type := 'MAINTAIN';
l_notes_rec.text := 'Test for AR note';
l_notes_rec.customer_call_topic_id := NULL;
l_notes_rec.call_action_id := NULL;
l_notes_rec.customer_call_id := NULL;
-- call API to insert note
ARP_NOTES_PKG.insert_p(l_notes_rec);
--
commit;
dbms_output.put_line('Note inserted reference note id : ' || l_notes_rec.note_id);
END;
==================================================
screenshot for AR invoice workbench transaction notes.
===================================================
One can query this record from backend by using below given query.
select * from ar_notes_v
where customer_trx_id=1545557;
===================================================
No comments:
Post a Comment