93: AND ROWNUM < 2;
94:
95:
96: -- Set event parameters
97: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_entity_number, l_cln_ch_parameters); --l_entity_number holds delivery number. p_delivery_number holds shipping document number in wsh_transactions_history
98:
99: WF_EVENT.AddParameterToList('TRADING_PARTNER_TYPE', p_tp_type, l_cln_ch_parameters);
100: WF_EVENT.AddParameterToList('TRADING_PARTNER_ID', p_tp_id, l_cln_ch_parameters);
101: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', p_tp_site_id, l_cln_ch_parameters);
95:
96: -- Set event parameters
97: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_entity_number, l_cln_ch_parameters); --l_entity_number holds delivery number. p_delivery_number holds shipping document number in wsh_transactions_history
98:
99: WF_EVENT.AddParameterToList('TRADING_PARTNER_TYPE', p_tp_type, l_cln_ch_parameters);
100: WF_EVENT.AddParameterToList('TRADING_PARTNER_ID', p_tp_id, l_cln_ch_parameters);
101: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', p_tp_site_id, l_cln_ch_parameters);
102: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', p_doc_dir, l_cln_ch_parameters);
103: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_TYPE', p_txn_type, l_cln_ch_parameters);
96: -- Set event parameters
97: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_entity_number, l_cln_ch_parameters); --l_entity_number holds delivery number. p_delivery_number holds shipping document number in wsh_transactions_history
98:
99: WF_EVENT.AddParameterToList('TRADING_PARTNER_TYPE', p_tp_type, l_cln_ch_parameters);
100: WF_EVENT.AddParameterToList('TRADING_PARTNER_ID', p_tp_id, l_cln_ch_parameters);
101: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', p_tp_site_id, l_cln_ch_parameters);
102: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', p_doc_dir, l_cln_ch_parameters);
103: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_TYPE', p_txn_type, l_cln_ch_parameters);
104: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_SUBTYPE', p_txn_subtype, l_cln_ch_parameters);
97: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_entity_number, l_cln_ch_parameters); --l_entity_number holds delivery number. p_delivery_number holds shipping document number in wsh_transactions_history
98:
99: WF_EVENT.AddParameterToList('TRADING_PARTNER_TYPE', p_tp_type, l_cln_ch_parameters);
100: WF_EVENT.AddParameterToList('TRADING_PARTNER_ID', p_tp_id, l_cln_ch_parameters);
101: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', p_tp_site_id, l_cln_ch_parameters);
102: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', p_doc_dir, l_cln_ch_parameters);
103: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_TYPE', p_txn_type, l_cln_ch_parameters);
104: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_SUBTYPE', p_txn_subtype, l_cln_ch_parameters);
105: WF_EVENT.AddParameterToList('XMLG_DOCUMENT_ID', p_xmlg_doc_id, l_cln_ch_parameters);
98:
99: WF_EVENT.AddParameterToList('TRADING_PARTNER_TYPE', p_tp_type, l_cln_ch_parameters);
100: WF_EVENT.AddParameterToList('TRADING_PARTNER_ID', p_tp_id, l_cln_ch_parameters);
101: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', p_tp_site_id, l_cln_ch_parameters);
102: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', p_doc_dir, l_cln_ch_parameters);
103: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_TYPE', p_txn_type, l_cln_ch_parameters);
104: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_SUBTYPE', p_txn_subtype, l_cln_ch_parameters);
105: WF_EVENT.AddParameterToList('XMLG_DOCUMENT_ID', p_xmlg_doc_id, l_cln_ch_parameters);
106:
99: WF_EVENT.AddParameterToList('TRADING_PARTNER_TYPE', p_tp_type, l_cln_ch_parameters);
100: WF_EVENT.AddParameterToList('TRADING_PARTNER_ID', p_tp_id, l_cln_ch_parameters);
101: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', p_tp_site_id, l_cln_ch_parameters);
102: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', p_doc_dir, l_cln_ch_parameters);
103: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_TYPE', p_txn_type, l_cln_ch_parameters);
104: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_SUBTYPE', p_txn_subtype, l_cln_ch_parameters);
105: WF_EVENT.AddParameterToList('XMLG_DOCUMENT_ID', p_xmlg_doc_id, l_cln_ch_parameters);
106:
107: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE', to_char(p_doc_creation_date, 'YYYY-MM-DD HH24:MI:SS'), l_cln_ch_parameters);
100: WF_EVENT.AddParameterToList('TRADING_PARTNER_ID', p_tp_id, l_cln_ch_parameters);
101: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', p_tp_site_id, l_cln_ch_parameters);
102: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', p_doc_dir, l_cln_ch_parameters);
103: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_TYPE', p_txn_type, l_cln_ch_parameters);
104: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_SUBTYPE', p_txn_subtype, l_cln_ch_parameters);
105: WF_EVENT.AddParameterToList('XMLG_DOCUMENT_ID', p_xmlg_doc_id, l_cln_ch_parameters);
106:
107: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE', to_char(p_doc_creation_date, 'YYYY-MM-DD HH24:MI:SS'), l_cln_ch_parameters);
108: WF_EVENT.AddParameterToList('REFERENCE_ID', p_appl_ref_id, l_cln_ch_parameters);
101: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', p_tp_site_id, l_cln_ch_parameters);
102: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', p_doc_dir, l_cln_ch_parameters);
103: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_TYPE', p_txn_type, l_cln_ch_parameters);
104: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_SUBTYPE', p_txn_subtype, l_cln_ch_parameters);
105: WF_EVENT.AddParameterToList('XMLG_DOCUMENT_ID', p_xmlg_doc_id, l_cln_ch_parameters);
106:
107: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE', to_char(p_doc_creation_date, 'YYYY-MM-DD HH24:MI:SS'), l_cln_ch_parameters);
108: WF_EVENT.AddParameterToList('REFERENCE_ID', p_appl_ref_id, l_cln_ch_parameters);
109: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER', p_int_ctl_num, l_cln_ch_parameters);
103: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_TYPE', p_txn_type, l_cln_ch_parameters);
104: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_SUBTYPE', p_txn_subtype, l_cln_ch_parameters);
105: WF_EVENT.AddParameterToList('XMLG_DOCUMENT_ID', p_xmlg_doc_id, l_cln_ch_parameters);
106:
107: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE', to_char(p_doc_creation_date, 'YYYY-MM-DD HH24:MI:SS'), l_cln_ch_parameters);
108: WF_EVENT.AddParameterToList('REFERENCE_ID', p_appl_ref_id, l_cln_ch_parameters);
109: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER', p_int_ctl_num, l_cln_ch_parameters);
110:
111: -- Raise create collaboration event
104: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_SUBTYPE', p_txn_subtype, l_cln_ch_parameters);
105: WF_EVENT.AddParameterToList('XMLG_DOCUMENT_ID', p_xmlg_doc_id, l_cln_ch_parameters);
106:
107: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE', to_char(p_doc_creation_date, 'YYYY-MM-DD HH24:MI:SS'), l_cln_ch_parameters);
108: WF_EVENT.AddParameterToList('REFERENCE_ID', p_appl_ref_id, l_cln_ch_parameters);
109: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER', p_int_ctl_num, l_cln_ch_parameters);
110:
111: -- Raise create collaboration event
112: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.create',
105: WF_EVENT.AddParameterToList('XMLG_DOCUMENT_ID', p_xmlg_doc_id, l_cln_ch_parameters);
106:
107: WF_EVENT.AddParameterToList('DOCUMENT_CREATION_DATE', to_char(p_doc_creation_date, 'YYYY-MM-DD HH24:MI:SS'), l_cln_ch_parameters);
108: WF_EVENT.AddParameterToList('REFERENCE_ID', p_appl_ref_id, l_cln_ch_parameters);
109: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER', p_int_ctl_num, l_cln_ch_parameters);
110:
111: -- Raise create collaboration event
112: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.create',
113: l_event_key, NULL, l_cln_ch_parameters, NULL);
108: WF_EVENT.AddParameterToList('REFERENCE_ID', p_appl_ref_id, l_cln_ch_parameters);
109: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER', p_int_ctl_num, l_cln_ch_parameters);
110:
111: -- Raise create collaboration event
112: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.create',
113: l_event_key, NULL, l_cln_ch_parameters, NULL);
114:
115: IF (l_Debug_Level <= 1) THEN
116: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.create raised', 1);
222:
223: l_cln_ch_parameters := wf_parameter_list_t();
224:
225: -- Set event parameters
226: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER', p_int_ctrl_num, l_cln_ch_parameters);
227: WF_EVENT.AddParameterToList('REFERENCE_ID', p_appl_ref_id, l_cln_ch_parameters);
228: WF_EVENT.AddParameterToList('TRADING_PARTNER_TYPE', p_tp_type, l_cln_ch_parameters);
229: WF_EVENT.AddParameterToList('TRADING_PARTNER_ID', p_tp_id, l_cln_ch_parameters);
230: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', p_tp_site_id, l_cln_ch_parameters);
223: l_cln_ch_parameters := wf_parameter_list_t();
224:
225: -- Set event parameters
226: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER', p_int_ctrl_num, l_cln_ch_parameters);
227: WF_EVENT.AddParameterToList('REFERENCE_ID', p_appl_ref_id, l_cln_ch_parameters);
228: WF_EVENT.AddParameterToList('TRADING_PARTNER_TYPE', p_tp_type, l_cln_ch_parameters);
229: WF_EVENT.AddParameterToList('TRADING_PARTNER_ID', p_tp_id, l_cln_ch_parameters);
230: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', p_tp_site_id, l_cln_ch_parameters);
231: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', p_doc_dir, l_cln_ch_parameters);
224:
225: -- Set event parameters
226: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER', p_int_ctrl_num, l_cln_ch_parameters);
227: WF_EVENT.AddParameterToList('REFERENCE_ID', p_appl_ref_id, l_cln_ch_parameters);
228: WF_EVENT.AddParameterToList('TRADING_PARTNER_TYPE', p_tp_type, l_cln_ch_parameters);
229: WF_EVENT.AddParameterToList('TRADING_PARTNER_ID', p_tp_id, l_cln_ch_parameters);
230: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', p_tp_site_id, l_cln_ch_parameters);
231: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', p_doc_dir, l_cln_ch_parameters);
232: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_TYPE', p_txn_type, l_cln_ch_parameters);
225: -- Set event parameters
226: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER', p_int_ctrl_num, l_cln_ch_parameters);
227: WF_EVENT.AddParameterToList('REFERENCE_ID', p_appl_ref_id, l_cln_ch_parameters);
228: WF_EVENT.AddParameterToList('TRADING_PARTNER_TYPE', p_tp_type, l_cln_ch_parameters);
229: WF_EVENT.AddParameterToList('TRADING_PARTNER_ID', p_tp_id, l_cln_ch_parameters);
230: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', p_tp_site_id, l_cln_ch_parameters);
231: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', p_doc_dir, l_cln_ch_parameters);
232: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_TYPE', p_txn_type, l_cln_ch_parameters);
233: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_SUBTYPE', p_txn_subtype, l_cln_ch_parameters);
226: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER', p_int_ctrl_num, l_cln_ch_parameters);
227: WF_EVENT.AddParameterToList('REFERENCE_ID', p_appl_ref_id, l_cln_ch_parameters);
228: WF_EVENT.AddParameterToList('TRADING_PARTNER_TYPE', p_tp_type, l_cln_ch_parameters);
229: WF_EVENT.AddParameterToList('TRADING_PARTNER_ID', p_tp_id, l_cln_ch_parameters);
230: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', p_tp_site_id, l_cln_ch_parameters);
231: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', p_doc_dir, l_cln_ch_parameters);
232: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_TYPE', p_txn_type, l_cln_ch_parameters);
233: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_SUBTYPE', p_txn_subtype, l_cln_ch_parameters);
234: WF_EVENT.AddParameterToList('XMLG_DOCUMENT_ID', p_xmlg_doc_id, l_cln_ch_parameters);
227: WF_EVENT.AddParameterToList('REFERENCE_ID', p_appl_ref_id, l_cln_ch_parameters);
228: WF_EVENT.AddParameterToList('TRADING_PARTNER_TYPE', p_tp_type, l_cln_ch_parameters);
229: WF_EVENT.AddParameterToList('TRADING_PARTNER_ID', p_tp_id, l_cln_ch_parameters);
230: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', p_tp_site_id, l_cln_ch_parameters);
231: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', p_doc_dir, l_cln_ch_parameters);
232: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_TYPE', p_txn_type, l_cln_ch_parameters);
233: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_SUBTYPE', p_txn_subtype, l_cln_ch_parameters);
234: WF_EVENT.AddParameterToList('XMLG_DOCUMENT_ID', p_xmlg_doc_id, l_cln_ch_parameters);
235: -- WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', p_delivery_number, l_cln_ch_parameters);
228: WF_EVENT.AddParameterToList('TRADING_PARTNER_TYPE', p_tp_type, l_cln_ch_parameters);
229: WF_EVENT.AddParameterToList('TRADING_PARTNER_ID', p_tp_id, l_cln_ch_parameters);
230: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', p_tp_site_id, l_cln_ch_parameters);
231: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', p_doc_dir, l_cln_ch_parameters);
232: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_TYPE', p_txn_type, l_cln_ch_parameters);
233: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_SUBTYPE', p_txn_subtype, l_cln_ch_parameters);
234: WF_EVENT.AddParameterToList('XMLG_DOCUMENT_ID', p_xmlg_doc_id, l_cln_ch_parameters);
235: -- WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', p_delivery_number, l_cln_ch_parameters);
236: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_msg_text, l_cln_ch_parameters);
229: WF_EVENT.AddParameterToList('TRADING_PARTNER_ID', p_tp_id, l_cln_ch_parameters);
230: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', p_tp_site_id, l_cln_ch_parameters);
231: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', p_doc_dir, l_cln_ch_parameters);
232: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_TYPE', p_txn_type, l_cln_ch_parameters);
233: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_SUBTYPE', p_txn_subtype, l_cln_ch_parameters);
234: WF_EVENT.AddParameterToList('XMLG_DOCUMENT_ID', p_xmlg_doc_id, l_cln_ch_parameters);
235: -- WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', p_delivery_number, l_cln_ch_parameters);
236: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_msg_text, l_cln_ch_parameters);
237:
230: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', p_tp_site_id, l_cln_ch_parameters);
231: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', p_doc_dir, l_cln_ch_parameters);
232: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_TYPE', p_txn_type, l_cln_ch_parameters);
233: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_SUBTYPE', p_txn_subtype, l_cln_ch_parameters);
234: WF_EVENT.AddParameterToList('XMLG_DOCUMENT_ID', p_xmlg_doc_id, l_cln_ch_parameters);
235: -- WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', p_delivery_number, l_cln_ch_parameters);
236: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_msg_text, l_cln_ch_parameters);
237:
238: -- Raise update collaboration event
231: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', p_doc_dir, l_cln_ch_parameters);
232: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_TYPE', p_txn_type, l_cln_ch_parameters);
233: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_SUBTYPE', p_txn_subtype, l_cln_ch_parameters);
234: WF_EVENT.AddParameterToList('XMLG_DOCUMENT_ID', p_xmlg_doc_id, l_cln_ch_parameters);
235: -- WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', p_delivery_number, l_cln_ch_parameters);
236: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_msg_text, l_cln_ch_parameters);
237:
238: -- Raise update collaboration event
239: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',
232: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_TYPE', p_txn_type, l_cln_ch_parameters);
233: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_SUBTYPE', p_txn_subtype, l_cln_ch_parameters);
234: WF_EVENT.AddParameterToList('XMLG_DOCUMENT_ID', p_xmlg_doc_id, l_cln_ch_parameters);
235: -- WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', p_delivery_number, l_cln_ch_parameters);
236: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_msg_text, l_cln_ch_parameters);
237:
238: -- Raise update collaboration event
239: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',
240: l_event_key, NULL, l_cln_ch_parameters, NULL);
235: -- WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', p_delivery_number, l_cln_ch_parameters);
236: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_msg_text, l_cln_ch_parameters);
237:
238: -- Raise update collaboration event
239: WF_EVENT.Raise('oracle.apps.cln.ch.collaboration.update',
240: l_event_key, NULL, l_cln_ch_parameters, NULL);
241: cln_debug_pub.Add('Workflow event- oracle.apps.cln.ch.collaboration.update raised', 1);
242:
243: IF (l_Debug_Level <= 2) THEN