208: IF (l_Debug_Level <= 1) THEN
209: cln_debug_pub.Add('---------- SETTING WORKFLOW PARAMETERS---------', 1);
210: END IF;
211:
212: WF_EVENT.AddParameterToList('INV_ORGANIZATION',p_inv_org,l_cln_inv_parameters);
213: WF_EVENT.AddParameterToList('TP_HEADER_ID',p_inv_user,l_cln_inv_parameters);
214: WF_EVENT.AddParameterToList('INV_DIS_AVAILABLE',p_diposition_available,l_cln_inv_parameters);
215: WF_EVENT.AddParameterToList('INV_DIS_BLOCKED',p_diposition_blocked,l_cln_inv_parameters);
216: WF_EVENT.AddParameterToList('INV_DIS_ALLOCATED',p_diposition_allocated,l_cln_inv_parameters);
209: cln_debug_pub.Add('---------- SETTING WORKFLOW PARAMETERS---------', 1);
210: END IF;
211:
212: WF_EVENT.AddParameterToList('INV_ORGANIZATION',p_inv_org,l_cln_inv_parameters);
213: WF_EVENT.AddParameterToList('TP_HEADER_ID',p_inv_user,l_cln_inv_parameters);
214: WF_EVENT.AddParameterToList('INV_DIS_AVAILABLE',p_diposition_available,l_cln_inv_parameters);
215: WF_EVENT.AddParameterToList('INV_DIS_BLOCKED',p_diposition_blocked,l_cln_inv_parameters);
216: WF_EVENT.AddParameterToList('INV_DIS_ALLOCATED',p_diposition_allocated,l_cln_inv_parameters);
217: WF_EVENT.AddParameterToList('SUB_INV',p_sub_inv,l_cln_inv_parameters);
210: END IF;
211:
212: WF_EVENT.AddParameterToList('INV_ORGANIZATION',p_inv_org,l_cln_inv_parameters);
213: WF_EVENT.AddParameterToList('TP_HEADER_ID',p_inv_user,l_cln_inv_parameters);
214: WF_EVENT.AddParameterToList('INV_DIS_AVAILABLE',p_diposition_available,l_cln_inv_parameters);
215: WF_EVENT.AddParameterToList('INV_DIS_BLOCKED',p_diposition_blocked,l_cln_inv_parameters);
216: WF_EVENT.AddParameterToList('INV_DIS_ALLOCATED',p_diposition_allocated,l_cln_inv_parameters);
217: WF_EVENT.AddParameterToList('SUB_INV',p_sub_inv,l_cln_inv_parameters);
218: WF_EVENT.AddParameterToList('LOT_NUMBER', p_lot_number, l_cln_inv_parameters);
211:
212: WF_EVENT.AddParameterToList('INV_ORGANIZATION',p_inv_org,l_cln_inv_parameters);
213: WF_EVENT.AddParameterToList('TP_HEADER_ID',p_inv_user,l_cln_inv_parameters);
214: WF_EVENT.AddParameterToList('INV_DIS_AVAILABLE',p_diposition_available,l_cln_inv_parameters);
215: WF_EVENT.AddParameterToList('INV_DIS_BLOCKED',p_diposition_blocked,l_cln_inv_parameters);
216: WF_EVENT.AddParameterToList('INV_DIS_ALLOCATED',p_diposition_allocated,l_cln_inv_parameters);
217: WF_EVENT.AddParameterToList('SUB_INV',p_sub_inv,l_cln_inv_parameters);
218: WF_EVENT.AddParameterToList('LOT_NUMBER', p_lot_number, l_cln_inv_parameters);
219: WF_EVENT.AddParameterToList('ITEM_CATEGORY', p_item_category, l_cln_inv_parameters);
212: WF_EVENT.AddParameterToList('INV_ORGANIZATION',p_inv_org,l_cln_inv_parameters);
213: WF_EVENT.AddParameterToList('TP_HEADER_ID',p_inv_user,l_cln_inv_parameters);
214: WF_EVENT.AddParameterToList('INV_DIS_AVAILABLE',p_diposition_available,l_cln_inv_parameters);
215: WF_EVENT.AddParameterToList('INV_DIS_BLOCKED',p_diposition_blocked,l_cln_inv_parameters);
216: WF_EVENT.AddParameterToList('INV_DIS_ALLOCATED',p_diposition_allocated,l_cln_inv_parameters);
217: WF_EVENT.AddParameterToList('SUB_INV',p_sub_inv,l_cln_inv_parameters);
218: WF_EVENT.AddParameterToList('LOT_NUMBER', p_lot_number, l_cln_inv_parameters);
219: WF_EVENT.AddParameterToList('ITEM_CATEGORY', p_item_category, l_cln_inv_parameters);
220: WF_EVENT.AddParameterToList('ITEM_NUMBER_FROM', p_item_number_from, l_cln_inv_parameters);
213: WF_EVENT.AddParameterToList('TP_HEADER_ID',p_inv_user,l_cln_inv_parameters);
214: WF_EVENT.AddParameterToList('INV_DIS_AVAILABLE',p_diposition_available,l_cln_inv_parameters);
215: WF_EVENT.AddParameterToList('INV_DIS_BLOCKED',p_diposition_blocked,l_cln_inv_parameters);
216: WF_EVENT.AddParameterToList('INV_DIS_ALLOCATED',p_diposition_allocated,l_cln_inv_parameters);
217: WF_EVENT.AddParameterToList('SUB_INV',p_sub_inv,l_cln_inv_parameters);
218: WF_EVENT.AddParameterToList('LOT_NUMBER', p_lot_number, l_cln_inv_parameters);
219: WF_EVENT.AddParameterToList('ITEM_CATEGORY', p_item_category, l_cln_inv_parameters);
220: WF_EVENT.AddParameterToList('ITEM_NUMBER_FROM', p_item_number_from, l_cln_inv_parameters);
221: WF_EVENT.AddParameterToList('ITEM_NUMBER_TO', p_item_number_to, l_cln_inv_parameters);
214: WF_EVENT.AddParameterToList('INV_DIS_AVAILABLE',p_diposition_available,l_cln_inv_parameters);
215: WF_EVENT.AddParameterToList('INV_DIS_BLOCKED',p_diposition_blocked,l_cln_inv_parameters);
216: WF_EVENT.AddParameterToList('INV_DIS_ALLOCATED',p_diposition_allocated,l_cln_inv_parameters);
217: WF_EVENT.AddParameterToList('SUB_INV',p_sub_inv,l_cln_inv_parameters);
218: WF_EVENT.AddParameterToList('LOT_NUMBER', p_lot_number, l_cln_inv_parameters);
219: WF_EVENT.AddParameterToList('ITEM_CATEGORY', p_item_category, l_cln_inv_parameters);
220: WF_EVENT.AddParameterToList('ITEM_NUMBER_FROM', p_item_number_from, l_cln_inv_parameters);
221: WF_EVENT.AddParameterToList('ITEM_NUMBER_TO', p_item_number_to, l_cln_inv_parameters);
222: WF_EVENT.AddParameterToList('ITEM_REV_NUMBER_FROM',p_item_revision_from,l_cln_inv_parameters);
215: WF_EVENT.AddParameterToList('INV_DIS_BLOCKED',p_diposition_blocked,l_cln_inv_parameters);
216: WF_EVENT.AddParameterToList('INV_DIS_ALLOCATED',p_diposition_allocated,l_cln_inv_parameters);
217: WF_EVENT.AddParameterToList('SUB_INV',p_sub_inv,l_cln_inv_parameters);
218: WF_EVENT.AddParameterToList('LOT_NUMBER', p_lot_number, l_cln_inv_parameters);
219: WF_EVENT.AddParameterToList('ITEM_CATEGORY', p_item_category, l_cln_inv_parameters);
220: WF_EVENT.AddParameterToList('ITEM_NUMBER_FROM', p_item_number_from, l_cln_inv_parameters);
221: WF_EVENT.AddParameterToList('ITEM_NUMBER_TO', p_item_number_to, l_cln_inv_parameters);
222: WF_EVENT.AddParameterToList('ITEM_REV_NUMBER_FROM',p_item_revision_from,l_cln_inv_parameters);
223: WF_EVENT.AddParameterToList('ITEM_REV_NUMBER_TO',p_item_revision_to,l_cln_inv_parameters);
216: WF_EVENT.AddParameterToList('INV_DIS_ALLOCATED',p_diposition_allocated,l_cln_inv_parameters);
217: WF_EVENT.AddParameterToList('SUB_INV',p_sub_inv,l_cln_inv_parameters);
218: WF_EVENT.AddParameterToList('LOT_NUMBER', p_lot_number, l_cln_inv_parameters);
219: WF_EVENT.AddParameterToList('ITEM_CATEGORY', p_item_category, l_cln_inv_parameters);
220: WF_EVENT.AddParameterToList('ITEM_NUMBER_FROM', p_item_number_from, l_cln_inv_parameters);
221: WF_EVENT.AddParameterToList('ITEM_NUMBER_TO', p_item_number_to, l_cln_inv_parameters);
222: WF_EVENT.AddParameterToList('ITEM_REV_NUMBER_FROM',p_item_revision_from,l_cln_inv_parameters);
223: WF_EVENT.AddParameterToList('ITEM_REV_NUMBER_TO',p_item_revision_to,l_cln_inv_parameters);
224: WF_EVENT.AddParameterToList('TRADING_PARTNER_TYPE',l_tr_partner_type,l_cln_inv_parameters);
217: WF_EVENT.AddParameterToList('SUB_INV',p_sub_inv,l_cln_inv_parameters);
218: WF_EVENT.AddParameterToList('LOT_NUMBER', p_lot_number, l_cln_inv_parameters);
219: WF_EVENT.AddParameterToList('ITEM_CATEGORY', p_item_category, l_cln_inv_parameters);
220: WF_EVENT.AddParameterToList('ITEM_NUMBER_FROM', p_item_number_from, l_cln_inv_parameters);
221: WF_EVENT.AddParameterToList('ITEM_NUMBER_TO', p_item_number_to, l_cln_inv_parameters);
222: WF_EVENT.AddParameterToList('ITEM_REV_NUMBER_FROM',p_item_revision_from,l_cln_inv_parameters);
223: WF_EVENT.AddParameterToList('ITEM_REV_NUMBER_TO',p_item_revision_to,l_cln_inv_parameters);
224: WF_EVENT.AddParameterToList('TRADING_PARTNER_TYPE',l_tr_partner_type,l_cln_inv_parameters);
225: WF_EVENT.AddParameterToList('TRADING_PARTNER_ID', l_tr_partner_id,l_cln_inv_parameters);
218: WF_EVENT.AddParameterToList('LOT_NUMBER', p_lot_number, l_cln_inv_parameters);
219: WF_EVENT.AddParameterToList('ITEM_CATEGORY', p_item_category, l_cln_inv_parameters);
220: WF_EVENT.AddParameterToList('ITEM_NUMBER_FROM', p_item_number_from, l_cln_inv_parameters);
221: WF_EVENT.AddParameterToList('ITEM_NUMBER_TO', p_item_number_to, l_cln_inv_parameters);
222: WF_EVENT.AddParameterToList('ITEM_REV_NUMBER_FROM',p_item_revision_from,l_cln_inv_parameters);
223: WF_EVENT.AddParameterToList('ITEM_REV_NUMBER_TO',p_item_revision_to,l_cln_inv_parameters);
224: WF_EVENT.AddParameterToList('TRADING_PARTNER_TYPE',l_tr_partner_type,l_cln_inv_parameters);
225: WF_EVENT.AddParameterToList('TRADING_PARTNER_ID', l_tr_partner_id,l_cln_inv_parameters);
226: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', l_tr_partner_site,l_cln_inv_parameters);
219: WF_EVENT.AddParameterToList('ITEM_CATEGORY', p_item_category, l_cln_inv_parameters);
220: WF_EVENT.AddParameterToList('ITEM_NUMBER_FROM', p_item_number_from, l_cln_inv_parameters);
221: WF_EVENT.AddParameterToList('ITEM_NUMBER_TO', p_item_number_to, l_cln_inv_parameters);
222: WF_EVENT.AddParameterToList('ITEM_REV_NUMBER_FROM',p_item_revision_from,l_cln_inv_parameters);
223: WF_EVENT.AddParameterToList('ITEM_REV_NUMBER_TO',p_item_revision_to,l_cln_inv_parameters);
224: WF_EVENT.AddParameterToList('TRADING_PARTNER_TYPE',l_tr_partner_type,l_cln_inv_parameters);
225: WF_EVENT.AddParameterToList('TRADING_PARTNER_ID', l_tr_partner_id,l_cln_inv_parameters);
226: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', l_tr_partner_site,l_cln_inv_parameters);
227: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_doc_number,l_cln_inv_parameters);
220: WF_EVENT.AddParameterToList('ITEM_NUMBER_FROM', p_item_number_from, l_cln_inv_parameters);
221: WF_EVENT.AddParameterToList('ITEM_NUMBER_TO', p_item_number_to, l_cln_inv_parameters);
222: WF_EVENT.AddParameterToList('ITEM_REV_NUMBER_FROM',p_item_revision_from,l_cln_inv_parameters);
223: WF_EVENT.AddParameterToList('ITEM_REV_NUMBER_TO',p_item_revision_to,l_cln_inv_parameters);
224: WF_EVENT.AddParameterToList('TRADING_PARTNER_TYPE',l_tr_partner_type,l_cln_inv_parameters);
225: WF_EVENT.AddParameterToList('TRADING_PARTNER_ID', l_tr_partner_id,l_cln_inv_parameters);
226: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', l_tr_partner_site,l_cln_inv_parameters);
227: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_doc_number,l_cln_inv_parameters);
228: WF_EVENT.AddParameterToList('XMLG_DOCUMENT_ID', l_xmlg_document_id,l_cln_inv_parameters);
221: WF_EVENT.AddParameterToList('ITEM_NUMBER_TO', p_item_number_to, l_cln_inv_parameters);
222: WF_EVENT.AddParameterToList('ITEM_REV_NUMBER_FROM',p_item_revision_from,l_cln_inv_parameters);
223: WF_EVENT.AddParameterToList('ITEM_REV_NUMBER_TO',p_item_revision_to,l_cln_inv_parameters);
224: WF_EVENT.AddParameterToList('TRADING_PARTNER_TYPE',l_tr_partner_type,l_cln_inv_parameters);
225: WF_EVENT.AddParameterToList('TRADING_PARTNER_ID', l_tr_partner_id,l_cln_inv_parameters);
226: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', l_tr_partner_site,l_cln_inv_parameters);
227: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_doc_number,l_cln_inv_parameters);
228: WF_EVENT.AddParameterToList('XMLG_DOCUMENT_ID', l_xmlg_document_id,l_cln_inv_parameters);
229: WF_EVENT.AddParameterToList('TRADING_PARTNER_NAME', l_party_name,l_cln_inv_parameters);
222: WF_EVENT.AddParameterToList('ITEM_REV_NUMBER_FROM',p_item_revision_from,l_cln_inv_parameters);
223: WF_EVENT.AddParameterToList('ITEM_REV_NUMBER_TO',p_item_revision_to,l_cln_inv_parameters);
224: WF_EVENT.AddParameterToList('TRADING_PARTNER_TYPE',l_tr_partner_type,l_cln_inv_parameters);
225: WF_EVENT.AddParameterToList('TRADING_PARTNER_ID', l_tr_partner_id,l_cln_inv_parameters);
226: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', l_tr_partner_site,l_cln_inv_parameters);
227: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_doc_number,l_cln_inv_parameters);
228: WF_EVENT.AddParameterToList('XMLG_DOCUMENT_ID', l_xmlg_document_id,l_cln_inv_parameters);
229: WF_EVENT.AddParameterToList('TRADING_PARTNER_NAME', l_party_name,l_cln_inv_parameters);
230: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_TYPE', 'CLN',l_cln_inv_parameters);
223: WF_EVENT.AddParameterToList('ITEM_REV_NUMBER_TO',p_item_revision_to,l_cln_inv_parameters);
224: WF_EVENT.AddParameterToList('TRADING_PARTNER_TYPE',l_tr_partner_type,l_cln_inv_parameters);
225: WF_EVENT.AddParameterToList('TRADING_PARTNER_ID', l_tr_partner_id,l_cln_inv_parameters);
226: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', l_tr_partner_site,l_cln_inv_parameters);
227: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_doc_number,l_cln_inv_parameters);
228: WF_EVENT.AddParameterToList('XMLG_DOCUMENT_ID', l_xmlg_document_id,l_cln_inv_parameters);
229: WF_EVENT.AddParameterToList('TRADING_PARTNER_NAME', l_party_name,l_cln_inv_parameters);
230: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_TYPE', 'CLN',l_cln_inv_parameters);
231: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_SUBTYPE', 'INVRT',l_cln_inv_parameters);
224: WF_EVENT.AddParameterToList('TRADING_PARTNER_TYPE',l_tr_partner_type,l_cln_inv_parameters);
225: WF_EVENT.AddParameterToList('TRADING_PARTNER_ID', l_tr_partner_id,l_cln_inv_parameters);
226: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', l_tr_partner_site,l_cln_inv_parameters);
227: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_doc_number,l_cln_inv_parameters);
228: WF_EVENT.AddParameterToList('XMLG_DOCUMENT_ID', l_xmlg_document_id,l_cln_inv_parameters);
229: WF_EVENT.AddParameterToList('TRADING_PARTNER_NAME', l_party_name,l_cln_inv_parameters);
230: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_TYPE', 'CLN',l_cln_inv_parameters);
231: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_SUBTYPE', 'INVRT',l_cln_inv_parameters);
232: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'OUT',l_cln_inv_parameters);
225: WF_EVENT.AddParameterToList('TRADING_PARTNER_ID', l_tr_partner_id,l_cln_inv_parameters);
226: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', l_tr_partner_site,l_cln_inv_parameters);
227: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_doc_number,l_cln_inv_parameters);
228: WF_EVENT.AddParameterToList('XMLG_DOCUMENT_ID', l_xmlg_document_id,l_cln_inv_parameters);
229: WF_EVENT.AddParameterToList('TRADING_PARTNER_NAME', l_party_name,l_cln_inv_parameters);
230: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_TYPE', 'CLN',l_cln_inv_parameters);
231: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_SUBTYPE', 'INVRT',l_cln_inv_parameters);
232: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'OUT',l_cln_inv_parameters);
233:
226: WF_EVENT.AddParameterToList('TRADING_PARTNER_SITE', l_tr_partner_site,l_cln_inv_parameters);
227: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_doc_number,l_cln_inv_parameters);
228: WF_EVENT.AddParameterToList('XMLG_DOCUMENT_ID', l_xmlg_document_id,l_cln_inv_parameters);
229: WF_EVENT.AddParameterToList('TRADING_PARTNER_NAME', l_party_name,l_cln_inv_parameters);
230: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_TYPE', 'CLN',l_cln_inv_parameters);
231: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_SUBTYPE', 'INVRT',l_cln_inv_parameters);
232: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'OUT',l_cln_inv_parameters);
233:
234:
227: WF_EVENT.AddParameterToList('DOCUMENT_NO', l_doc_number,l_cln_inv_parameters);
228: WF_EVENT.AddParameterToList('XMLG_DOCUMENT_ID', l_xmlg_document_id,l_cln_inv_parameters);
229: WF_EVENT.AddParameterToList('TRADING_PARTNER_NAME', l_party_name,l_cln_inv_parameters);
230: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_TYPE', 'CLN',l_cln_inv_parameters);
231: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_SUBTYPE', 'INVRT',l_cln_inv_parameters);
232: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'OUT',l_cln_inv_parameters);
233:
234:
235: IF (l_Debug_Level <= 1) THEN
228: WF_EVENT.AddParameterToList('XMLG_DOCUMENT_ID', l_xmlg_document_id,l_cln_inv_parameters);
229: WF_EVENT.AddParameterToList('TRADING_PARTNER_NAME', l_party_name,l_cln_inv_parameters);
230: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_TYPE', 'CLN',l_cln_inv_parameters);
231: WF_EVENT.AddParameterToList('XMLG_INTERNAL_TXN_SUBTYPE', 'INVRT',l_cln_inv_parameters);
232: WF_EVENT.AddParameterToList('DOCUMENT_DIRECTION', 'OUT',l_cln_inv_parameters);
233:
234:
235: IF (l_Debug_Level <= 1) THEN
236: cln_debug_pub.Add('======== PARAMETERS DEFAULTED ======== ',1);
252: IF (l_Debug_Level <= 1) THEN
253: cln_debug_pub.Add('Workflow event- oracle.apps.cln.inv.genreport', 1);
254: END IF;
255:
256: WF_EVENT.Raise('oracle.apps.cln.inv.genreport',l_event_key, NULL, l_cln_inv_parameters, NULL);
257:
258: x_retcode := 0;
259: x_errbuf := 'Successful';
260: