DBA Data[Home] [Help]

APPS.INV_LOT_SERIAL_DATE_EVENT_PKG dependencies on WF_EVENT

Line 331: wf_event.addparametertolist ('ORGANIZATION_CODE'

327: || TO_CHAR (l_lot_rec.secondary_transaction_quantity)
328: || ' '
329: || l_lot_rec.secondary_uom_code;
330:
331: wf_event.addparametertolist ('ORGANIZATION_CODE'
332: , l_lot_rec.organization_code
333: , l_parameter_list
334: );
335: wf_event.addparametertolist ('ORGANIZATION_ID'

Line 335: wf_event.addparametertolist ('ORGANIZATION_ID'

331: wf_event.addparametertolist ('ORGANIZATION_CODE'
332: , l_lot_rec.organization_code
333: , l_parameter_list
334: );
335: wf_event.addparametertolist ('ORGANIZATION_ID'
336: , p_organization_id
337: , l_parameter_list
338: );
339: wf_event.addparametertolist ('ITEM_NUMBER'

Line 339: wf_event.addparametertolist ('ITEM_NUMBER'

335: wf_event.addparametertolist ('ORGANIZATION_ID'
336: , p_organization_id
337: , l_parameter_list
338: );
339: wf_event.addparametertolist ('ITEM_NUMBER'
340: , l_lot_rec.concatenated_segments
341: , l_parameter_list
342: );
343: wf_event.addparametertolist ('ITEM_ID'

Line 343: wf_event.addparametertolist ('ITEM_ID'

339: wf_event.addparametertolist ('ITEM_NUMBER'
340: , l_lot_rec.concatenated_segments
341: , l_parameter_list
342: );
343: wf_event.addparametertolist ('ITEM_ID'
344: , l_lot_rec.inventory_item_id
345: , l_parameter_list
346: );
347: wf_event.addparametertolist ('ITEM_CATEGORY'

Line 347: wf_event.addparametertolist ('ITEM_CATEGORY'

343: wf_event.addparametertolist ('ITEM_ID'
344: , l_lot_rec.inventory_item_id
345: , l_parameter_list
346: );
347: wf_event.addparametertolist ('ITEM_CATEGORY'
348: , l_item_catg_rec.category_concat_segs
349: , l_parameter_list
350: );
351: wf_event.addparametertolist ('CATEGORY_ID'

Line 351: wf_event.addparametertolist ('CATEGORY_ID'

347: wf_event.addparametertolist ('ITEM_CATEGORY'
348: , l_item_catg_rec.category_concat_segs
349: , l_parameter_list
350: );
351: wf_event.addparametertolist ('CATEGORY_ID'
352: , l_item_catg_rec.category_id
353: , l_parameter_list
354: );
355: wf_event.addparametertolist ('QUERY_FOR'

Line 355: wf_event.addparametertolist ('QUERY_FOR'

351: wf_event.addparametertolist ('CATEGORY_ID'
352: , l_item_catg_rec.category_id
353: , l_parameter_list
354: );
355: wf_event.addparametertolist ('QUERY_FOR'
356: , p_query_for
357: , l_parameter_list
358: );
359: wf_event.addparametertolist ('LOT_NUMBER'

Line 359: wf_event.addparametertolist ('LOT_NUMBER'

355: wf_event.addparametertolist ('QUERY_FOR'
356: , p_query_for
357: , l_parameter_list
358: );
359: wf_event.addparametertolist ('LOT_NUMBER'
360: , l_lot_rec.lot_number
361: , l_parameter_list
362: );
363: wf_event.addparametertolist ('SERIAL_NUMBER'

Line 363: wf_event.addparametertolist ('SERIAL_NUMBER'

359: wf_event.addparametertolist ('LOT_NUMBER'
360: , l_lot_rec.lot_number
361: , l_parameter_list
362: );
363: wf_event.addparametertolist ('SERIAL_NUMBER'
364: , NULL
365: , l_parameter_list
366: );
367: wf_event.addparametertolist ('DATE_CONTEXT'

Line 367: wf_event.addparametertolist ('DATE_CONTEXT'

363: wf_event.addparametertolist ('SERIAL_NUMBER'
364: , NULL
365: , l_parameter_list
366: );
367: wf_event.addparametertolist ('DATE_CONTEXT'
368: , l_attr_ctxt
369: , l_parameter_list
370: );
371: wf_event.addparametertolist ('DATE_TYPE'

Line 371: wf_event.addparametertolist ('DATE_TYPE'

367: wf_event.addparametertolist ('DATE_CONTEXT'
368: , l_attr_ctxt
369: , l_parameter_list
370: );
371: wf_event.addparametertolist ('DATE_TYPE'
372: , p_date_type
373: , l_parameter_list
374: );
375: wf_event.addparametertolist ('USER_DATE_TYPE'

Line 375: wf_event.addparametertolist ('USER_DATE_TYPE'

371: wf_event.addparametertolist ('DATE_TYPE'
372: , p_date_type
373: , l_parameter_list
374: );
375: wf_event.addparametertolist ('USER_DATE_TYPE'
376: , l_user_column_name
377: , l_parameter_list
378: );
379: wf_event.addparametertolist ('DATE_VALUE'

Line 379: wf_event.addparametertolist ('DATE_VALUE'

375: wf_event.addparametertolist ('USER_DATE_TYPE'
376: , l_user_column_name
377: , l_parameter_list
378: );
379: wf_event.addparametertolist ('DATE_VALUE'
380: , l_lot_rec.date_column
381: , l_parameter_list
382: );
383: wf_event.addparametertolist ('ACTION_CODE'

Line 383: wf_event.addparametertolist ('ACTION_CODE'

379: wf_event.addparametertolist ('DATE_VALUE'
380: , l_lot_rec.date_column
381: , l_parameter_list
382: );
383: wf_event.addparametertolist ('ACTION_CODE'
384: , l_expiration_action_code
385: , l_parameter_list
386: );
387: wf_event.addparametertolist ('SERIAL_STATUS'

Line 387: wf_event.addparametertolist ('SERIAL_STATUS'

383: wf_event.addparametertolist ('ACTION_CODE'
384: , l_expiration_action_code
385: , l_parameter_list
386: );
387: wf_event.addparametertolist ('SERIAL_STATUS'
388: , NULL
389: , l_parameter_list
390: );
391: wf_event.addparametertolist ('ONHAND_QTY_UOM'

Line 391: wf_event.addparametertolist ('ONHAND_QTY_UOM'

387: wf_event.addparametertolist ('SERIAL_STATUS'
388: , NULL
389: , l_parameter_list
390: );
391: wf_event.addparametertolist ('ONHAND_QTY_UOM'
392: , l_onhand_qty_uom
393: , l_parameter_list
394: );
395: wf_event.addparametertolist ('TRANSACTION_ID'

Line 395: wf_event.addparametertolist ('TRANSACTION_ID'

391: wf_event.addparametertolist ('ONHAND_QTY_UOM'
392: , l_onhand_qty_uom
393: , l_parameter_list
394: );
395: wf_event.addparametertolist ('TRANSACTION_ID'
396: , l_lot_rec.gen_object_id
397: , l_parameter_list
398: );
399: /*

Line 433: wf_event.RAISE

429: );
430:
431:
432: l_user_id := FND_GLOBAL.USER_ID;
433: wf_event.RAISE
434: (p_event_name => 'oracle.apps.inv.Date.Notification'
435: , p_parameters => l_parameter_list
436: , p_event_key => TO_CHAR (p_organization_id)
437: || '+-?*'

Line 465: wf_event.RAISE

461:
462: IF p_date_type = 'EXPIRATION_DATE' THEN
463: -- Raise oracle.apps.gmi.lotexpirydate.update and oracle.apps.gmi.lotretestdate.update
464: -- instead of oracle.apps.gmd.lotexpiry and oracle.apps.gmd.lotretest
465: wf_event.RAISE
466: (p_event_name => 'oracle.apps.gmi.lotexpirydate.update'
467: , p_event_key => TO_CHAR (p_organization_id)
468: || '-'
469: || TO_CHAR (l_lot_rec.inventory_item_id)

Line 475: wf_event.RAISE

471: || l_lot_rec.lot_number
472: || '-'
473: ||l_date_notification_s);
474: ELSIF p_date_type = 'RETEST_DATE' THEN
475: wf_event.RAISE
476: (p_event_name => 'oracle.apps.gmi.lotretestdate.update'
477: , p_event_key => TO_CHAR (p_organization_id)
478: || '-'
479: || TO_CHAR (l_lot_rec.inventory_item_id)

Line 615: wf_event.addparametertolist ('ORGANIZATION_CODE'

611: END IF;
612: END IF;
613:
614: IF l_catg_rec_found THEN
615: wf_event.addparametertolist ('ORGANIZATION_CODE'
616: , l_serial_rec.organization_code
617: , l_parameter_list
618: );
619: wf_event.addparametertolist ('ORGANIZATION_ID'

Line 619: wf_event.addparametertolist ('ORGANIZATION_ID'

615: wf_event.addparametertolist ('ORGANIZATION_CODE'
616: , l_serial_rec.organization_code
617: , l_parameter_list
618: );
619: wf_event.addparametertolist ('ORGANIZATION_ID'
620: , p_organization_id
621: , l_parameter_list
622: );
623: wf_event.addparametertolist ('ITEM_NUMBER'

Line 623: wf_event.addparametertolist ('ITEM_NUMBER'

619: wf_event.addparametertolist ('ORGANIZATION_ID'
620: , p_organization_id
621: , l_parameter_list
622: );
623: wf_event.addparametertolist ('ITEM_NUMBER'
624: , l_serial_rec.concatenated_segments
625: , l_parameter_list
626: );
627: wf_event.addparametertolist ('ITEM_ID'

Line 627: wf_event.addparametertolist ('ITEM_ID'

623: wf_event.addparametertolist ('ITEM_NUMBER'
624: , l_serial_rec.concatenated_segments
625: , l_parameter_list
626: );
627: wf_event.addparametertolist ('ITEM_ID'
628: , l_serial_rec.inventory_item_id
629: , l_parameter_list
630: );
631: wf_event.addparametertolist ('ITEM_CATEGORY'

Line 631: wf_event.addparametertolist ('ITEM_CATEGORY'

627: wf_event.addparametertolist ('ITEM_ID'
628: , l_serial_rec.inventory_item_id
629: , l_parameter_list
630: );
631: wf_event.addparametertolist ('ITEM_CATEGORY'
632: , l_item_catg_rec.category_concat_segs
633: , l_parameter_list
634: );
635: wf_event.addparametertolist ('CATEGORY_ID'

Line 635: wf_event.addparametertolist ('CATEGORY_ID'

631: wf_event.addparametertolist ('ITEM_CATEGORY'
632: , l_item_catg_rec.category_concat_segs
633: , l_parameter_list
634: );
635: wf_event.addparametertolist ('CATEGORY_ID'
636: , l_item_catg_rec.category_id
637: , l_parameter_list
638: );
639: wf_event.addparametertolist ('QUERY_FOR'

Line 639: wf_event.addparametertolist ('QUERY_FOR'

635: wf_event.addparametertolist ('CATEGORY_ID'
636: , l_item_catg_rec.category_id
637: , l_parameter_list
638: );
639: wf_event.addparametertolist ('QUERY_FOR'
640: , p_query_for
641: , l_parameter_list
642: );
643: wf_event.addparametertolist ('LOT_NUMBER'

Line 643: wf_event.addparametertolist ('LOT_NUMBER'

639: wf_event.addparametertolist ('QUERY_FOR'
640: , p_query_for
641: , l_parameter_list
642: );
643: wf_event.addparametertolist ('LOT_NUMBER'
644: , NULL
645: , l_parameter_list
646: );
647: wf_event.addparametertolist ('SERIAL_NUMBER'

Line 647: wf_event.addparametertolist ('SERIAL_NUMBER'

643: wf_event.addparametertolist ('LOT_NUMBER'
644: , NULL
645: , l_parameter_list
646: );
647: wf_event.addparametertolist ('SERIAL_NUMBER'
648: , l_serial_rec.serial_number
649: , l_parameter_list
650: );
651: wf_event.addparametertolist ('DATE_CONTEXT'

Line 651: wf_event.addparametertolist ('DATE_CONTEXT'

647: wf_event.addparametertolist ('SERIAL_NUMBER'
648: , l_serial_rec.serial_number
649: , l_parameter_list
650: );
651: wf_event.addparametertolist ('DATE_CONTEXT'
652: , l_attr_ctxt
653: , l_parameter_list
654: );
655: wf_event.addparametertolist ('DATE_TYPE'

Line 655: wf_event.addparametertolist ('DATE_TYPE'

651: wf_event.addparametertolist ('DATE_CONTEXT'
652: , l_attr_ctxt
653: , l_parameter_list
654: );
655: wf_event.addparametertolist ('DATE_TYPE'
656: , p_date_type
657: , l_parameter_list
658: );
659: wf_event.addparametertolist ('USER_DATE_TYPE'

Line 659: wf_event.addparametertolist ('USER_DATE_TYPE'

655: wf_event.addparametertolist ('DATE_TYPE'
656: , p_date_type
657: , l_parameter_list
658: );
659: wf_event.addparametertolist ('USER_DATE_TYPE'
660: , l_user_column_name
661: , l_parameter_list
662: );
663: wf_event.addparametertolist ('DATE_VALUE'

Line 663: wf_event.addparametertolist ('DATE_VALUE'

659: wf_event.addparametertolist ('USER_DATE_TYPE'
660: , l_user_column_name
661: , l_parameter_list
662: );
663: wf_event.addparametertolist ('DATE_VALUE'
664: , l_serial_rec.date_column
665: , l_parameter_list
666: );
667: wf_event.addparametertolist ('ACTION_CODE'

Line 667: wf_event.addparametertolist ('ACTION_CODE'

663: wf_event.addparametertolist ('DATE_VALUE'
664: , l_serial_rec.date_column
665: , l_parameter_list
666: );
667: wf_event.addparametertolist ('ACTION_CODE'
668: , NULL
669: , l_parameter_list
670: );
671: wf_event.addparametertolist ('SERIAL_STATUS'

Line 671: wf_event.addparametertolist ('SERIAL_STATUS'

667: wf_event.addparametertolist ('ACTION_CODE'
668: , NULL
669: , l_parameter_list
670: );
671: wf_event.addparametertolist ('SERIAL_STATUS'
672: , l_serial_rec.serial_status
673: , l_parameter_list
674: );
675: wf_event.addparametertolist ('ONHAND_QTY_UOM'

Line 675: wf_event.addparametertolist ('ONHAND_QTY_UOM'

671: wf_event.addparametertolist ('SERIAL_STATUS'
672: , l_serial_rec.serial_status
673: , l_parameter_list
674: );
675: wf_event.addparametertolist ('ONHAND_QTY_UOM'
676: , NULL
677: , l_parameter_list
678: );
679: wf_event.addparametertolist ('TRANSACTION_ID'

Line 679: wf_event.addparametertolist ('TRANSACTION_ID'

675: wf_event.addparametertolist ('ONHAND_QTY_UOM'
676: , NULL
677: , l_parameter_list
678: );
679: wf_event.addparametertolist ('TRANSACTION_ID'
680: , l_serial_rec.gen_object_id
681: , l_parameter_list
682: );
683:

Line 698: wf_event.RAISE

694: || ' '
695: || l_date_notification_s
696: );
697:
698: wf_event.RAISE
699: (p_event_name => 'oracle.apps.inv.Date.Notification'
700: , p_parameters => l_parameter_list
701: , p_event_key => TO_CHAR (p_organization_id)
702: || '+-?*'