eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_ITEM_EVENTS_PVT dependencies on EGO_WF_WRAPPER_PVT

Line 194: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_AML_CHANGE_EVENT' AND

190: /*Bug 6407303 Added the attribute to get whether teh master attribute is modified */
191:
192: BEGIN
193: CASE
194: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_AML_CHANGE_EVENT' AND
195: EGO_WF_WRAPPER_PVT.Get_PostAml_Change_Event = FND_API.g_true
196: THEN
197: EXECUTE IMMEDIATE
198: 'BEGIN '||

Line 195: EGO_WF_WRAPPER_PVT.Get_PostAml_Change_Event = FND_API.g_true

191:
192: BEGIN
193: CASE
194: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_AML_CHANGE_EVENT' AND
195: EGO_WF_WRAPPER_PVT.Get_PostAml_Change_Event = FND_API.g_true
196: THEN
197: EXECUTE IMMEDIATE
198: 'BEGIN '||
199: ' EGO_WF_WRAPPER_PVT.Raise_AML_Event( '||

Line 199: ' EGO_WF_WRAPPER_PVT.Raise_AML_Event( '||

195: EGO_WF_WRAPPER_PVT.Get_PostAml_Change_Event = FND_API.g_true
196: THEN
197: EXECUTE IMMEDIATE
198: 'BEGIN '||
199: ' EGO_WF_WRAPPER_PVT.Raise_AML_Event( '||
200: ' p_event_name => EGO_WF_WRAPPER_PVT.G_AML_CHANGE_EVENT '||
201: ' ,p_dml_type => :p_dml_type '||
202: ' ,p_Inventory_Item_Id => :p_inventory_item_id '||
203: ' ,p_Organization_Id => :p_organization_id '||

Line 200: ' p_event_name => EGO_WF_WRAPPER_PVT.G_AML_CHANGE_EVENT '||

196: THEN
197: EXECUTE IMMEDIATE
198: 'BEGIN '||
199: ' EGO_WF_WRAPPER_PVT.Raise_AML_Event( '||
200: ' p_event_name => EGO_WF_WRAPPER_PVT.G_AML_CHANGE_EVENT '||
201: ' ,p_dml_type => :p_dml_type '||
202: ' ,p_Inventory_Item_Id => :p_inventory_item_id '||
203: ' ,p_Organization_Id => :p_organization_id '||
204: ' ,p_Manufacturer_Id => :p_manufacturer_id '||

Line 216: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_ITEM_APPROVED_EVENT' THEN

212: IN p_manufacturer_id,
213: IN p_mfg_part_num,
214: OUT l_msg_data,
215: OUT l_ret_status;
216: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_ITEM_APPROVED_EVENT' THEN
217: EXECUTE IMMEDIATE
218: 'BEGIN '||
219: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||
220: ' p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_APPROVED_EVENT '||

Line 219: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||

215: OUT l_ret_status;
216: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_ITEM_APPROVED_EVENT' THEN
217: EXECUTE IMMEDIATE
218: 'BEGIN '||
219: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||
220: ' p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_APPROVED_EVENT '||
221: ' ,p_Inventory_Item_Id => :p_inventory_item_id '||
222: ' ,p_Organization_Id => :p_organization_id '||
223: ' ,x_msg_data => :l_msg_data '||

Line 220: ' p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_APPROVED_EVENT '||

216: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_ITEM_APPROVED_EVENT' THEN
217: EXECUTE IMMEDIATE
218: 'BEGIN '||
219: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||
220: ' p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_APPROVED_EVENT '||
221: ' ,p_Inventory_Item_Id => :p_inventory_item_id '||
222: ' ,p_Organization_Id => :p_organization_id '||
223: ' ,x_msg_data => :l_msg_data '||
224: ' ,x_return_status => :l_ret_status); '||

Line 231: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_REV_CHANGE_EVENT' AND

227: IN p_organization_id,
228: OUT l_msg_data,
229: OUT l_ret_status;
230:
231: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_REV_CHANGE_EVENT' AND
232: EGO_WF_WRAPPER_PVT.Get_Rev_Change_Bus_Event = FND_API.g_true
233: THEN
234: IF p_request_id IS NOT NULL THEN
235: OPEN c_raise_revision_event(p_request_id, p_xset_id);

Line 232: EGO_WF_WRAPPER_PVT.Get_Rev_Change_Bus_Event = FND_API.g_true

228: OUT l_msg_data,
229: OUT l_ret_status;
230:
231: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_REV_CHANGE_EVENT' AND
232: EGO_WF_WRAPPER_PVT.Get_Rev_Change_Bus_Event = FND_API.g_true
233: THEN
234: IF p_request_id IS NOT NULL THEN
235: OPEN c_raise_revision_event(p_request_id, p_xset_id);
236: FETCH c_raise_revision_event INTO l_raise_event;

Line 242: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||

238: END IF;
239: IF p_request_id IS NULL OR l_raise_event = 'x' THEN
240: EXECUTE IMMEDIATE
241: 'BEGIN '||
242: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||
243: ' p_event_name => EGO_WF_WRAPPER_PVT.G_REV_CHANGE_EVENT '||
244: ' ,p_dml_type => :p_dml_type '||
245: ' ,p_Inventory_Item_Id => :p_inventory_item_id '||
246: ' ,p_Organization_Id => :p_organization_id '||

Line 243: ' p_event_name => EGO_WF_WRAPPER_PVT.G_REV_CHANGE_EVENT '||

239: IF p_request_id IS NULL OR l_raise_event = 'x' THEN
240: EXECUTE IMMEDIATE
241: 'BEGIN '||
242: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||
243: ' p_event_name => EGO_WF_WRAPPER_PVT.G_REV_CHANGE_EVENT '||
244: ' ,p_dml_type => :p_dml_type '||
245: ' ,p_Inventory_Item_Id => :p_inventory_item_id '||
246: ' ,p_Organization_Id => :p_organization_id '||
247: ' ,p_Revision_id => :p_revision_id '||

Line 260: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_ITEM_UPDATE_EVENT' THEN

256: IN p_request_id,
257: OUT l_msg_data,
258: OUT l_ret_status;
259: END IF;
260: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_ITEM_UPDATE_EVENT' THEN
261: -- Populate Item and Orgnanization Information
262: get_Org_Info(
263: p_organization_id => p_organization_id
264: ,x_organization_code => l_organization_code

Line 275: ' EGO_WF_WRAPPER_PVT.Raise_Item_Create_Update_Event( '||

271: -- Populate Item and Orgnanization Information
272:
273: EXECUTE IMMEDIATE
274: 'BEGIN '||
275: ' EGO_WF_WRAPPER_PVT.Raise_Item_Create_Update_Event( '||
276: ' p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_UPDATE_EVENT '||
277: ' ,p_request_id => :p_request_id '||
278: ' ,p_Organization_Id => :p_organization_id '||
279: ' ,p_organization_code => :l_organization_code '||

Line 276: ' p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_UPDATE_EVENT '||

272:
273: EXECUTE IMMEDIATE
274: 'BEGIN '||
275: ' EGO_WF_WRAPPER_PVT.Raise_Item_Create_Update_Event( '||
276: ' p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_UPDATE_EVENT '||
277: ' ,p_request_id => :p_request_id '||
278: ' ,p_Organization_Id => :p_organization_id '||
279: ' ,p_organization_code => :l_organization_code '||
280: ' ,p_Inventory_Item_Id => :p_inventory_item_id '||

Line 297: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_ITEM_CREATE_EVENT' THEN

293: IN l_is_master_attr_modified, /* Added for bug 6407303*/
294: OUT l_msg_data,
295: OUT l_ret_status;
296: INV_ITEM_PVT.Set_Is_Master_Attr_Modified('N'); /*Added for bug 6407303*/
297: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_ITEM_CREATE_EVENT' THEN
298: -- Populate Item and Orgnanization Information
299: get_Org_Info(
300: p_organization_id => p_organization_id
301: ,x_organization_code => l_organization_code

Line 312: ' EGO_WF_WRAPPER_PVT.Raise_Item_Create_Update_Event( '||

308: -- Populate Item and Orgnanization Information
309:
310: EXECUTE IMMEDIATE
311: 'BEGIN '||
312: ' EGO_WF_WRAPPER_PVT.Raise_Item_Create_Update_Event( '||
313: ' p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_CREATE_EVENT '||
314: ' ,p_request_id => :p_request_id '||
315: ' ,p_Organization_Id => :p_organization_id '||
316: ' ,p_organization_code => :l_organization_code '||

Line 313: ' p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_CREATE_EVENT '||

309:
310: EXECUTE IMMEDIATE
311: 'BEGIN '||
312: ' EGO_WF_WRAPPER_PVT.Raise_Item_Create_Update_Event( '||
313: ' p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_CREATE_EVENT '||
314: ' ,p_request_id => :p_request_id '||
315: ' ,p_Organization_Id => :p_organization_id '||
316: ' ,p_organization_code => :l_organization_code '||
317: ' ,p_Inventory_Item_Id => :p_inventory_item_id '||

Line 331: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_ITEM_CAT_ASSIGN_EVENT' AND

327: IN l_item_number,
328: IN l_item_description,
329: OUT l_msg_data,
330: OUT l_ret_status;
331: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_ITEM_CAT_ASSIGN_EVENT' AND
332: EGO_WF_WRAPPER_PVT.Get_Category_Assign_Bus_Event = FND_API.g_true
333: THEN
334: IF p_request_id IS NOT NULL THEN
335: OPEN c_raise_item_categories_event(p_request_id, p_xset_id );

Line 332: EGO_WF_WRAPPER_PVT.Get_Category_Assign_Bus_Event = FND_API.g_true

328: IN l_item_description,
329: OUT l_msg_data,
330: OUT l_ret_status;
331: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_ITEM_CAT_ASSIGN_EVENT' AND
332: EGO_WF_WRAPPER_PVT.Get_Category_Assign_Bus_Event = FND_API.g_true
333: THEN
334: IF p_request_id IS NOT NULL THEN
335: OPEN c_raise_item_categories_event(p_request_id, p_xset_id );
336: FETCH c_raise_item_categories_event INTO l_raise_event;

Line 342: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||

338: END IF;
339: IF p_request_id IS NULL OR l_raise_event = 'x' THEN
340: EXECUTE IMMEDIATE
341: 'BEGIN '||
342: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||
343: ' p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_CAT_ASSIGN_EVENT '||
344: ' ,p_dml_type => :p_dml_type '||
345: ' ,p_request_id => :p_request_id '||
346: ' ,p_Inventory_Item_Id => :p_inventory_item_id '||

Line 343: ' p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_CAT_ASSIGN_EVENT '||

339: IF p_request_id IS NULL OR l_raise_event = 'x' THEN
340: EXECUTE IMMEDIATE
341: 'BEGIN '||
342: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||
343: ' p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_CAT_ASSIGN_EVENT '||
344: ' ,p_dml_type => :p_dml_type '||
345: ' ,p_request_id => :p_request_id '||
346: ' ,p_Inventory_Item_Id => :p_inventory_item_id '||
347: ' ,p_Organization_Id => :p_organization_id '||

Line 362: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_PRE_ATTR_CHANGE_EVENT' THEN

358: IN p_category_id,
359: OUT l_msg_data,
360: OUT l_ret_status;
361: END IF;
362: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_PRE_ATTR_CHANGE_EVENT' THEN
363: NULL;
364: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_GTIN_ATTR_CHANGE_EVENT' THEN
365: NULL;
366:

Line 364: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_GTIN_ATTR_CHANGE_EVENT' THEN

360: OUT l_ret_status;
361: END IF;
362: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_PRE_ATTR_CHANGE_EVENT' THEN
363: NULL;
364: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_GTIN_ATTR_CHANGE_EVENT' THEN
365: NULL;
366:
367: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_Xref_CHANGE_EVENT' THEN
368: EXECUTE IMMEDIATE

Line 367: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_Xref_CHANGE_EVENT' THEN

363: NULL;
364: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_GTIN_ATTR_CHANGE_EVENT' THEN
365: NULL;
366:
367: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_Xref_CHANGE_EVENT' THEN
368: EXECUTE IMMEDIATE
369: 'BEGIN '||
370: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||
371: ' p_event_name => EGO_WF_WRAPPER_PVT.G_Xref_CHANGE_EVENT '||

Line 370: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||

366:
367: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_Xref_CHANGE_EVENT' THEN
368: EXECUTE IMMEDIATE
369: 'BEGIN '||
370: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||
371: ' p_event_name => EGO_WF_WRAPPER_PVT.G_Xref_CHANGE_EVENT '||
372: ' ,p_dml_type => :p_dml_type '||
373: ' ,p_Inventory_Item_Id => :p_inventory_item_id '||
374: ' ,p_Organization_Id => :p_organization_id '||

Line 371: ' p_event_name => EGO_WF_WRAPPER_PVT.G_Xref_CHANGE_EVENT '||

367: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_Xref_CHANGE_EVENT' THEN
368: EXECUTE IMMEDIATE
369: 'BEGIN '||
370: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||
371: ' p_event_name => EGO_WF_WRAPPER_PVT.G_Xref_CHANGE_EVENT '||
372: ' ,p_dml_type => :p_dml_type '||
373: ' ,p_Inventory_Item_Id => :p_inventory_item_id '||
374: ' ,p_Organization_Id => :p_organization_id '||
375: ' ,p_cross_reference_type => :p_cross_reference_type '||

Line 387: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_CUST_ITEM_XREF_CHANGE_EVENT' THEN

383: IN p_cross_reference_type,
384: IN p_cross_reference,
385: OUT l_msg_data,
386: OUT l_ret_status;
387: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_CUST_ITEM_XREF_CHANGE_EVENT' THEN
388: NULL;
389: /* Commenting the call to hide the event
390: EXECUTE IMMEDIATE
391: 'BEGIN '||

Line 392: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||

388: NULL;
389: /* Commenting the call to hide the event
390: EXECUTE IMMEDIATE
391: 'BEGIN '||
392: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||
393: ' p_event_name => EGO_WF_WRAPPER_PVT.G_CUST_ITEM_XREF_CHANGE_EVENT '||
394: ' ,p_dml_type => :p_dml_type '||
395: ' ,p_Inventory_Item_Id => :p_inventory_item_id '||
396: ' ,p_Organization_Id => :p_organization_id '||

Line 393: ' p_event_name => EGO_WF_WRAPPER_PVT.G_CUST_ITEM_XREF_CHANGE_EVENT '||

389: /* Commenting the call to hide the event
390: EXECUTE IMMEDIATE
391: 'BEGIN '||
392: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||
393: ' p_event_name => EGO_WF_WRAPPER_PVT.G_CUST_ITEM_XREF_CHANGE_EVENT '||
394: ' ,p_dml_type => :p_dml_type '||
395: ' ,p_Inventory_Item_Id => :p_inventory_item_id '||
396: ' ,p_Organization_Id => :p_organization_id '||
397: ' ,p_customer_item_id => :p_customer_item_id '||

Line 409: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_REL_ITEM_CHANGE_EVENT' THEN

405: OUT l_msg_data,
406: OUT l_ret_status;
407: */
408:
409: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_REL_ITEM_CHANGE_EVENT' THEN
410: NULL;
411: /* Commenting the call to hide the event
412: EXECUTE IMMEDIATE
413: 'BEGIN '||

Line 414: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||

410: NULL;
411: /* Commenting the call to hide the event
412: EXECUTE IMMEDIATE
413: 'BEGIN '||
414: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||
415: ' p_event_name => EGO_WF_WRAPPER_PVT.G_REL_ITEM_CHANGE_EVENT '||
416: ' ,p_dml_type => :p_dml_type '||
417: ' ,p_Inventory_Item_Id => :p_inventory_item_id '||
418: ' ,p_Organization_Id => :p_organization_id '||

Line 415: ' p_event_name => EGO_WF_WRAPPER_PVT.G_REL_ITEM_CHANGE_EVENT '||

411: /* Commenting the call to hide the event
412: EXECUTE IMMEDIATE
413: 'BEGIN '||
414: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||
415: ' p_event_name => EGO_WF_WRAPPER_PVT.G_REL_ITEM_CHANGE_EVENT '||
416: ' ,p_dml_type => :p_dml_type '||
417: ' ,p_Inventory_Item_Id => :p_inventory_item_id '||
418: ' ,p_Organization_Id => :p_organization_id '||
419: ' ,p_related_item_id => :p_related_item_id '||

Line 433: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_ITEM_ROLE_CHANGE_EVENT' THEN

429: OUT l_msg_data,
430: OUT l_ret_status;
431: */
432:
433: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_ITEM_ROLE_CHANGE_EVENT' THEN
434: EXECUTE IMMEDIATE
435: 'BEGIN '||
436: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||
437: ' p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_ROLE_CHANGE_EVENT '||

Line 436: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||

432:
433: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_ITEM_ROLE_CHANGE_EVENT' THEN
434: EXECUTE IMMEDIATE
435: 'BEGIN '||
436: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||
437: ' p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_ROLE_CHANGE_EVENT '||
438: ' ,p_dml_type => :p_dml_type '||
439: ' ,p_Inventory_Item_Id => :p_inventory_item_id '||
440: ' ,p_Organization_Id => :p_organization_id '||

Line 437: ' p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_ROLE_CHANGE_EVENT '||

433: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_ITEM_ROLE_CHANGE_EVENT' THEN
434: EXECUTE IMMEDIATE
435: 'BEGIN '||
436: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||
437: ' p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_ROLE_CHANGE_EVENT '||
438: ' ,p_dml_type => :p_dml_type '||
439: ' ,p_Inventory_Item_Id => :p_inventory_item_id '||
440: ' ,p_Organization_Id => :p_organization_id '||
441: ' ,p_role_id => :p_role_id '||

Line 457: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_VALID_CAT_CHANGE_EVENT' THEN

453: IN p_party_id,
454: IN p_start_date,
455: OUT l_msg_data,
456: OUT l_ret_status;
457: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_VALID_CAT_CHANGE_EVENT' THEN
458: EXECUTE IMMEDIATE
459: 'BEGIN '||
460: ' EGO_WF_WRAPPER_PVT.Raise_Categories_Event( '||
461: ' p_event_name => EGO_WF_WRAPPER_PVT.G_VALID_CHANGE_EVENT '||

Line 460: ' EGO_WF_WRAPPER_PVT.Raise_Categories_Event( '||

456: OUT l_ret_status;
457: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_VALID_CAT_CHANGE_EVENT' THEN
458: EXECUTE IMMEDIATE
459: 'BEGIN '||
460: ' EGO_WF_WRAPPER_PVT.Raise_Categories_Event( '||
461: ' p_event_name => EGO_WF_WRAPPER_PVT.G_VALID_CHANGE_EVENT '||
462: ' ,p_dml_type => :p_dml_type '||
463: ' ,p_category_set_id => :p_category_set_id '||
464: ' ,p_category_id => :p_category_id '||

Line 461: ' p_event_name => EGO_WF_WRAPPER_PVT.G_VALID_CHANGE_EVENT '||

457: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_VALID_CAT_CHANGE_EVENT' THEN
458: EXECUTE IMMEDIATE
459: 'BEGIN '||
460: ' EGO_WF_WRAPPER_PVT.Raise_Categories_Event( '||
461: ' p_event_name => EGO_WF_WRAPPER_PVT.G_VALID_CHANGE_EVENT '||
462: ' ,p_dml_type => :p_dml_type '||
463: ' ,p_category_set_id => :p_category_set_id '||
464: ' ,p_category_id => :p_category_id '||
465: ' ,x_msg_data => :l_msg_data '||

Line 473: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_CAT_CATEGORY_CHANGE_EVENT' THEN

469: IN p_category_set_id,
470: IN p_category_id,
471: OUT l_msg_data,
472: OUT l_ret_status;
473: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_CAT_CATEGORY_CHANGE_EVENT' THEN
474: -- Populate Category Information
475: get_category_info(
476: p_category_id => p_category_id
477: ,x_category_name => l_category_name);

Line 482: ' EGO_WF_WRAPPER_PVT.Raise_Categories_Event( '||

478: -- Populate Category Information
479:
480: EXECUTE IMMEDIATE
481: 'BEGIN '||
482: ' EGO_WF_WRAPPER_PVT.Raise_Categories_Event( '||
483: ' p_event_name => EGO_WF_WRAPPER_PVT.G_CAT_CATEGORY_CHANGE_EVENT '||
484: ' ,p_dml_type => :p_dml_type '||
485: ' ,p_category_name => :l_category_name '||
486: ' ,p_category_id => :p_category_id '||

Line 483: ' p_event_name => EGO_WF_WRAPPER_PVT.G_CAT_CATEGORY_CHANGE_EVENT '||

479:
480: EXECUTE IMMEDIATE
481: 'BEGIN '||
482: ' EGO_WF_WRAPPER_PVT.Raise_Categories_Event( '||
483: ' p_event_name => EGO_WF_WRAPPER_PVT.G_CAT_CATEGORY_CHANGE_EVENT '||
484: ' ,p_dml_type => :p_dml_type '||
485: ' ,p_category_name => :l_category_name '||
486: ' ,p_category_id => :p_category_id '||
487: ' ,x_msg_data => :l_msg_data '||

Line 495: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_ITEM_BULKLOAD_EVENT' AND

491: IN l_category_name,
492: IN p_category_id,
493: OUT l_msg_data,
494: OUT l_ret_status;
495: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_ITEM_BULKLOAD_EVENT' AND
496: EGO_WF_WRAPPER_PVT.Get_Item_Bulkload_Bus_Event = FND_API.g_true
497: THEN
498: OPEN c_raise_item_change_event(p_request_id, p_xset_id);
499: FETCH c_raise_item_change_event INTO l_raise_event;

Line 496: EGO_WF_WRAPPER_PVT.Get_Item_Bulkload_Bus_Event = FND_API.g_true

492: IN p_category_id,
493: OUT l_msg_data,
494: OUT l_ret_status;
495: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_ITEM_BULKLOAD_EVENT' AND
496: EGO_WF_WRAPPER_PVT.Get_Item_Bulkload_Bus_Event = FND_API.g_true
497: THEN
498: OPEN c_raise_item_change_event(p_request_id, p_xset_id);
499: FETCH c_raise_item_change_event INTO l_raise_event;
500: close c_raise_item_change_event;

Line 504: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||

500: close c_raise_item_change_event;
501: IF l_raise_event = 'x' THEN
502: EXECUTE IMMEDIATE
503: 'BEGIN '||
504: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||
505: ' p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_BULKLOAD_EVENT '||
506: ' ,p_request_id => :p_request_id '||
507: ' ,x_msg_data => :l_msg_data '||
508: ' ,x_return_status => :l_ret_status); '||

Line 505: ' p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_BULKLOAD_EVENT '||

501: IF l_raise_event = 'x' THEN
502: EXECUTE IMMEDIATE
503: 'BEGIN '||
504: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||
505: ' p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_BULKLOAD_EVENT '||
506: ' ,p_request_id => :p_request_id '||
507: ' ,x_msg_data => :l_msg_data '||
508: ' ,x_return_status => :l_ret_status); '||
509: 'END;'