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 196: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_AML_CHANGE_EVENT' AND

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

Line 197: EGO_WF_WRAPPER_PVT.Get_PostAml_Change_Event = FND_API.g_true

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

Line 201: ' EGO_WF_WRAPPER_PVT.Raise_AML_Event( '||

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

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

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

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

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

Line 221: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||

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

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

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

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

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

Line 234: EGO_WF_WRAPPER_PVT.Get_Rev_Change_Bus_Event = FND_API.g_true

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

Line 244: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||

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

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

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

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

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

Line 277: ' EGO_WF_WRAPPER_PVT.Raise_Item_Create_Update_Event( '||

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

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

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

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

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

Line 314: ' EGO_WF_WRAPPER_PVT.Raise_Item_Create_Update_Event( '||

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

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

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

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

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

Line 334: EGO_WF_WRAPPER_PVT.Get_Category_Assign_Bus_Event = FND_API.g_true

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

Line 344: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||

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

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

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

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

362: IN p_old_category_id,--add 8310065 with base bug 8351807
363: OUT l_msg_data,
364: OUT l_ret_status;
365: END IF;
366: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_PRE_ATTR_CHANGE_EVENT' THEN
367: NULL;
368: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_GTIN_ATTR_CHANGE_EVENT' THEN
369: NULL;
370:

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

364: OUT l_ret_status;
365: END IF;
366: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_PRE_ATTR_CHANGE_EVENT' THEN
367: NULL;
368: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_GTIN_ATTR_CHANGE_EVENT' THEN
369: NULL;
370:
371: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_Xref_CHANGE_EVENT' THEN
372: EXECUTE IMMEDIATE

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

367: NULL;
368: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_GTIN_ATTR_CHANGE_EVENT' THEN
369: NULL;
370:
371: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_Xref_CHANGE_EVENT' THEN
372: EXECUTE IMMEDIATE
373: 'BEGIN '||
374: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||
375: ' p_event_name => EGO_WF_WRAPPER_PVT.G_Xref_CHANGE_EVENT '||

Line 374: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||

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

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

371: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_Xref_CHANGE_EVENT' THEN
372: EXECUTE IMMEDIATE
373: 'BEGIN '||
374: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||
375: ' p_event_name => EGO_WF_WRAPPER_PVT.G_Xref_CHANGE_EVENT '||
376: ' ,p_dml_type => :p_dml_type '||
377: ' ,p_Inventory_Item_Id => :p_inventory_item_id '||
378: ' ,p_Organization_Id => :p_organization_id '||
379: ' ,p_cross_reference_type => :p_cross_reference_type '||

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

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

Line 396: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||

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

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

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

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

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

Line 418: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||

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

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

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

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

433: OUT l_msg_data,
434: OUT l_ret_status;
435: */
436:
437: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_ITEM_ROLE_CHANGE_EVENT' THEN
438: EXECUTE IMMEDIATE
439: 'BEGIN '||
440: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||
441: ' p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_ROLE_CHANGE_EVENT '||

Line 440: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||

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

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

437: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_ITEM_ROLE_CHANGE_EVENT' THEN
438: EXECUTE IMMEDIATE
439: 'BEGIN '||
440: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||
441: ' p_event_name => EGO_WF_WRAPPER_PVT.G_ITEM_ROLE_CHANGE_EVENT '||
442: ' ,p_dml_type => :p_dml_type '||
443: ' ,p_Inventory_Item_Id => :p_inventory_item_id '||
444: ' ,p_Organization_Id => :p_organization_id '||
445: ' ,p_role_id => :p_role_id '||

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

457: IN p_party_id,
458: IN p_start_date,
459: OUT l_msg_data,
460: OUT l_ret_status;
461: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_VALID_CAT_CHANGE_EVENT' THEN
462: EXECUTE IMMEDIATE
463: 'BEGIN '||
464: ' EGO_WF_WRAPPER_PVT.Raise_Categories_Event( '||
465: ' p_event_name => EGO_WF_WRAPPER_PVT.G_VALID_CHANGE_EVENT '||

Line 464: ' EGO_WF_WRAPPER_PVT.Raise_Categories_Event( '||

460: OUT l_ret_status;
461: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_VALID_CAT_CHANGE_EVENT' THEN
462: EXECUTE IMMEDIATE
463: 'BEGIN '||
464: ' EGO_WF_WRAPPER_PVT.Raise_Categories_Event( '||
465: ' p_event_name => EGO_WF_WRAPPER_PVT.G_VALID_CHANGE_EVENT '||
466: ' ,p_dml_type => :p_dml_type '||
467: ' ,p_category_set_id => :p_category_set_id '||
468: ' ,p_category_id => :p_category_id '||

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

461: WHEN p_event_name = 'EGO_WF_WRAPPER_PVT.G_VALID_CAT_CHANGE_EVENT' THEN
462: EXECUTE IMMEDIATE
463: 'BEGIN '||
464: ' EGO_WF_WRAPPER_PVT.Raise_Categories_Event( '||
465: ' p_event_name => EGO_WF_WRAPPER_PVT.G_VALID_CHANGE_EVENT '||
466: ' ,p_dml_type => :p_dml_type '||
467: ' ,p_category_set_id => :p_category_set_id '||
468: ' ,p_category_id => :p_category_id '||
469: ' ,x_msg_data => :l_msg_data '||

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

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

Line 486: ' EGO_WF_WRAPPER_PVT.Raise_Categories_Event( '||

482: -- Populate Category Information
483:
484: EXECUTE IMMEDIATE
485: 'BEGIN '||
486: ' EGO_WF_WRAPPER_PVT.Raise_Categories_Event( '||
487: ' p_event_name => EGO_WF_WRAPPER_PVT.G_CAT_CATEGORY_CHANGE_EVENT '||
488: ' ,p_dml_type => :p_dml_type '||
489: ' ,p_category_name => :l_category_name '||
490: ' ,p_category_id => :p_category_id '||

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

483:
484: EXECUTE IMMEDIATE
485: 'BEGIN '||
486: ' EGO_WF_WRAPPER_PVT.Raise_Categories_Event( '||
487: ' p_event_name => EGO_WF_WRAPPER_PVT.G_CAT_CATEGORY_CHANGE_EVENT '||
488: ' ,p_dml_type => :p_dml_type '||
489: ' ,p_category_name => :l_category_name '||
490: ' ,p_category_id => :p_category_id '||
491: ' ,x_msg_data => :l_msg_data '||

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

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

Line 500: EGO_WF_WRAPPER_PVT.Get_Item_Bulkload_Bus_Event = FND_API.g_true

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

Line 508: ' EGO_WF_WRAPPER_PVT.Raise_Item_Event( '||

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

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

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