APPS.CLN_3A9_CANCELPO_PKG dependencies on DUAL

Line 64: SELECT cln_generic_s.nextval INTO l_cln_event_key FROM dual;

60: ELSE
61: RETURN;
62: END IF;
63:
64: SELECT cln_generic_s.nextval INTO l_cln_event_key FROM dual;
65:
66: -- Set Event Name, Event Key and Event Message Parameters.
67: WF_EVENT.AddParameterToList('oracle.apps.cln.po.cancelpo', 'EVENT_NAME', l_cln_not_parameters);
68: WF_EVENT.AddParameterToList(l_cln_event_key, 'EVNT_KEY', l_cln_not_parameters);

Line 197: SELECT cln_generic_s.nextval INTO l_cln_event_key FROM dual;

193: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTYID', l_party_id);
194: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARTYSIDEID', l_party_site_id);
195:
196: -- Set the event key
197: SELECT cln_generic_s.nextval INTO l_cln_event_key FROM dual;
198: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'CLNEVENTKEY', l_cln_event_key);
199:
200: -- Set the XML Gateway Document ID
201: SELECT cln_generic_s.nextval INTO l_xmlg_doc_id FROM dual;

Line 201: SELECT cln_generic_s.nextval INTO l_xmlg_doc_id FROM dual;

197: SELECT cln_generic_s.nextval INTO l_cln_event_key FROM dual;
198: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'CLNEVENTKEY', l_cln_event_key);
199:
200: -- Set the XML Gateway Document ID
201: SELECT cln_generic_s.nextval INTO l_xmlg_doc_id FROM dual;
202: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'XMLGDOCUMENTID', l_xmlg_doc_id);
203:
204: -- Set Transaction Type and Subtype
205: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'TRANSACTIONTYPE', 'CLN');