DBA Data[Home] [Help]

APPS.POS_ASN_NOTIF dependencies on PO_WF_ITEMKEY_S

Line 26: SELECT po_wf_itemkey_s.nextval INTO l_seq_val FROM dual;

22: l_supplier_displayname VARCHAR2(360);
23:
24: BEGIN
25:
26: SELECT po_wf_itemkey_s.nextval INTO l_seq_val FROM dual;
27: l_item_key := 'POSASNNB_' || p_shipment_num || '_' || to_char(l_seq_val);
28:
29: if (p_notif_type = 'CANCEL') then
30: wf_engine.createProcess( ItemType => l_item_type,

Line 107: SELECT po_wf_itemkey_s.nextval INTO l_seq_val FROM dual;

103: l_buyer_user_displayname VARCHAR2(360);
104:
105: BEGIN
106:
107: SELECT po_wf_itemkey_s.nextval INTO l_seq_val FROM dual;
108: l_item_key := 'WCAPPRV_' || p_wc_num || '_' || to_char(l_seq_val);
109:
110:
111: wf_engine.createProcess