DBA Data[Home] [Help]

APPS.INV_LOT_SERIAL_DATE_EVENT_PKG dependencies on WF_EVENT

Line 328: wf_event.addparametertolist ('ORGANIZATION_CODE'

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

Line 332: wf_event.addparametertolist ('ORGANIZATION_ID'

328: wf_event.addparametertolist ('ORGANIZATION_CODE'
329: , l_lot_rec.organization_code
330: , l_parameter_list
331: );
332: wf_event.addparametertolist ('ORGANIZATION_ID'
333: , p_organization_id
334: , l_parameter_list
335: );
336: wf_event.addparametertolist ('ITEM_NUMBER'

Line 336: wf_event.addparametertolist ('ITEM_NUMBER'

332: wf_event.addparametertolist ('ORGANIZATION_ID'
333: , p_organization_id
334: , l_parameter_list
335: );
336: wf_event.addparametertolist ('ITEM_NUMBER'
337: , l_lot_rec.concatenated_segments
338: , l_parameter_list
339: );
340: wf_event.addparametertolist ('ITEM_ID'

Line 340: wf_event.addparametertolist ('ITEM_ID'

336: wf_event.addparametertolist ('ITEM_NUMBER'
337: , l_lot_rec.concatenated_segments
338: , l_parameter_list
339: );
340: wf_event.addparametertolist ('ITEM_ID'
341: , l_lot_rec.inventory_item_id
342: , l_parameter_list
343: );
344: wf_event.addparametertolist ('ITEM_CATEGORY'

Line 344: wf_event.addparametertolist ('ITEM_CATEGORY'

340: wf_event.addparametertolist ('ITEM_ID'
341: , l_lot_rec.inventory_item_id
342: , l_parameter_list
343: );
344: wf_event.addparametertolist ('ITEM_CATEGORY'
345: , l_item_catg_rec.category_concat_segs
346: , l_parameter_list
347: );
348: wf_event.addparametertolist ('CATEGORY_ID'

Line 348: wf_event.addparametertolist ('CATEGORY_ID'

344: wf_event.addparametertolist ('ITEM_CATEGORY'
345: , l_item_catg_rec.category_concat_segs
346: , l_parameter_list
347: );
348: wf_event.addparametertolist ('CATEGORY_ID'
349: , l_item_catg_rec.category_id
350: , l_parameter_list
351: );
352: wf_event.addparametertolist ('QUERY_FOR'

Line 352: wf_event.addparametertolist ('QUERY_FOR'

348: wf_event.addparametertolist ('CATEGORY_ID'
349: , l_item_catg_rec.category_id
350: , l_parameter_list
351: );
352: wf_event.addparametertolist ('QUERY_FOR'
353: , p_query_for
354: , l_parameter_list
355: );
356: wf_event.addparametertolist ('LOT_NUMBER'

Line 356: wf_event.addparametertolist ('LOT_NUMBER'

352: wf_event.addparametertolist ('QUERY_FOR'
353: , p_query_for
354: , l_parameter_list
355: );
356: wf_event.addparametertolist ('LOT_NUMBER'
357: , l_lot_rec.lot_number
358: , l_parameter_list
359: );
360: wf_event.addparametertolist ('SERIAL_NUMBER'

Line 360: wf_event.addparametertolist ('SERIAL_NUMBER'

356: wf_event.addparametertolist ('LOT_NUMBER'
357: , l_lot_rec.lot_number
358: , l_parameter_list
359: );
360: wf_event.addparametertolist ('SERIAL_NUMBER'
361: , NULL
362: , l_parameter_list
363: );
364: wf_event.addparametertolist ('DATE_CONTEXT'

Line 364: wf_event.addparametertolist ('DATE_CONTEXT'

360: wf_event.addparametertolist ('SERIAL_NUMBER'
361: , NULL
362: , l_parameter_list
363: );
364: wf_event.addparametertolist ('DATE_CONTEXT'
365: , l_attr_ctxt
366: , l_parameter_list
367: );
368: wf_event.addparametertolist ('DATE_TYPE'

Line 368: wf_event.addparametertolist ('DATE_TYPE'

364: wf_event.addparametertolist ('DATE_CONTEXT'
365: , l_attr_ctxt
366: , l_parameter_list
367: );
368: wf_event.addparametertolist ('DATE_TYPE'
369: , p_date_type
370: , l_parameter_list
371: );
372: wf_event.addparametertolist ('USER_DATE_TYPE'

Line 372: wf_event.addparametertolist ('USER_DATE_TYPE'

368: wf_event.addparametertolist ('DATE_TYPE'
369: , p_date_type
370: , l_parameter_list
371: );
372: wf_event.addparametertolist ('USER_DATE_TYPE'
373: , l_user_column_name
374: , l_parameter_list
375: );
376: wf_event.addparametertolist ('DATE_VALUE'

Line 376: wf_event.addparametertolist ('DATE_VALUE'

372: wf_event.addparametertolist ('USER_DATE_TYPE'
373: , l_user_column_name
374: , l_parameter_list
375: );
376: wf_event.addparametertolist ('DATE_VALUE'
377: , l_lot_rec.date_column
378: , l_parameter_list
379: );
380: wf_event.addparametertolist ('ACTION_CODE'

Line 380: wf_event.addparametertolist ('ACTION_CODE'

376: wf_event.addparametertolist ('DATE_VALUE'
377: , l_lot_rec.date_column
378: , l_parameter_list
379: );
380: wf_event.addparametertolist ('ACTION_CODE'
381: , l_expiration_action_code
382: , l_parameter_list
383: );
384: wf_event.addparametertolist ('SERIAL_STATUS'

Line 384: wf_event.addparametertolist ('SERIAL_STATUS'

380: wf_event.addparametertolist ('ACTION_CODE'
381: , l_expiration_action_code
382: , l_parameter_list
383: );
384: wf_event.addparametertolist ('SERIAL_STATUS'
385: , NULL
386: , l_parameter_list
387: );
388: wf_event.addparametertolist ('ONHAND_QTY_UOM'

Line 388: wf_event.addparametertolist ('ONHAND_QTY_UOM'

384: wf_event.addparametertolist ('SERIAL_STATUS'
385: , NULL
386: , l_parameter_list
387: );
388: wf_event.addparametertolist ('ONHAND_QTY_UOM'
389: , l_onhand_qty_uom
390: , l_parameter_list
391: );
392: wf_event.addparametertolist ('TRANSACTION_ID'

Line 392: wf_event.addparametertolist ('TRANSACTION_ID'

388: wf_event.addparametertolist ('ONHAND_QTY_UOM'
389: , l_onhand_qty_uom
390: , l_parameter_list
391: );
392: wf_event.addparametertolist ('TRANSACTION_ID'
393: , l_lot_rec.gen_object_id
394: , l_parameter_list
395: );
396: /*

Line 426: wf_event.RAISE

422: || l_lot_rec.date_column
423: );
424:
425: l_user_id := FND_GLOBAL.USER_ID;
426: wf_event.RAISE
427: (p_event_name => 'oracle.apps.inv.Date.Notification'
428: , p_parameters => l_parameter_list
429: , p_event_key => TO_CHAR (p_organization_id)
430: || '+-?*'

Line 453: wf_event.RAISE

449: AND NVL (l_item_info_rec.process_quality_enabled_flag, 'N') = 'Y'
450: AND p_date_type = 'EXPIRATION_DATE' THEN
451: -- Raise oracle.apps.gmi.lotexpirydate.update and oracle.apps.gmi.lotretestdate.update
452: -- instead of oracle.apps.gmd.lotexpiry and oracle.apps.gmd.lotretest
453: wf_event.RAISE
454: (p_event_name => 'oracle.apps.gmi.lotexpirydate.update'
455: , p_event_key => TO_CHAR (p_organization_id)
456: || '-'
457: || TO_CHAR (l_lot_rec.inventory_item_id)

Line 463: wf_event.RAISE

459: || l_lot_rec.lot_number);
460: ELSIF l_item_info_rec.process_enabled_flag = 'Y'
461: AND NVL (l_item_info_rec.process_quality_enabled_flag, 'N') = 'Y'
462: AND p_date_type = 'RETEST_DATE' THEN
463: wf_event.RAISE
464: (p_event_name => 'oracle.apps.gmi.lotretestdate.update'
465: , p_event_key => TO_CHAR (p_organization_id)
466: || '-'
467: || TO_CHAR (l_lot_rec.inventory_item_id)

Line 599: wf_event.addparametertolist ('ORGANIZATION_CODE'

595: END IF;
596: END IF;
597:
598: IF l_catg_rec_found THEN
599: wf_event.addparametertolist ('ORGANIZATION_CODE'
600: , l_serial_rec.organization_code
601: , l_parameter_list
602: );
603: wf_event.addparametertolist ('ORGANIZATION_ID'

Line 603: wf_event.addparametertolist ('ORGANIZATION_ID'

599: wf_event.addparametertolist ('ORGANIZATION_CODE'
600: , l_serial_rec.organization_code
601: , l_parameter_list
602: );
603: wf_event.addparametertolist ('ORGANIZATION_ID'
604: , p_organization_id
605: , l_parameter_list
606: );
607: wf_event.addparametertolist ('ITEM_NUMBER'

Line 607: wf_event.addparametertolist ('ITEM_NUMBER'

603: wf_event.addparametertolist ('ORGANIZATION_ID'
604: , p_organization_id
605: , l_parameter_list
606: );
607: wf_event.addparametertolist ('ITEM_NUMBER'
608: , l_serial_rec.concatenated_segments
609: , l_parameter_list
610: );
611: wf_event.addparametertolist ('ITEM_ID'

Line 611: wf_event.addparametertolist ('ITEM_ID'

607: wf_event.addparametertolist ('ITEM_NUMBER'
608: , l_serial_rec.concatenated_segments
609: , l_parameter_list
610: );
611: wf_event.addparametertolist ('ITEM_ID'
612: , l_serial_rec.inventory_item_id
613: , l_parameter_list
614: );
615: wf_event.addparametertolist ('ITEM_CATEGORY'

Line 615: wf_event.addparametertolist ('ITEM_CATEGORY'

611: wf_event.addparametertolist ('ITEM_ID'
612: , l_serial_rec.inventory_item_id
613: , l_parameter_list
614: );
615: wf_event.addparametertolist ('ITEM_CATEGORY'
616: , l_item_catg_rec.category_concat_segs
617: , l_parameter_list
618: );
619: wf_event.addparametertolist ('CATEGORY_ID'

Line 619: wf_event.addparametertolist ('CATEGORY_ID'

615: wf_event.addparametertolist ('ITEM_CATEGORY'
616: , l_item_catg_rec.category_concat_segs
617: , l_parameter_list
618: );
619: wf_event.addparametertolist ('CATEGORY_ID'
620: , l_item_catg_rec.category_id
621: , l_parameter_list
622: );
623: wf_event.addparametertolist ('QUERY_FOR'

Line 623: wf_event.addparametertolist ('QUERY_FOR'

619: wf_event.addparametertolist ('CATEGORY_ID'
620: , l_item_catg_rec.category_id
621: , l_parameter_list
622: );
623: wf_event.addparametertolist ('QUERY_FOR'
624: , p_query_for
625: , l_parameter_list
626: );
627: wf_event.addparametertolist ('LOT_NUMBER'

Line 627: wf_event.addparametertolist ('LOT_NUMBER'

623: wf_event.addparametertolist ('QUERY_FOR'
624: , p_query_for
625: , l_parameter_list
626: );
627: wf_event.addparametertolist ('LOT_NUMBER'
628: , NULL
629: , l_parameter_list
630: );
631: wf_event.addparametertolist ('SERIAL_NUMBER'

Line 631: wf_event.addparametertolist ('SERIAL_NUMBER'

627: wf_event.addparametertolist ('LOT_NUMBER'
628: , NULL
629: , l_parameter_list
630: );
631: wf_event.addparametertolist ('SERIAL_NUMBER'
632: , l_serial_rec.serial_number
633: , l_parameter_list
634: );
635: wf_event.addparametertolist ('DATE_CONTEXT'

Line 635: wf_event.addparametertolist ('DATE_CONTEXT'

631: wf_event.addparametertolist ('SERIAL_NUMBER'
632: , l_serial_rec.serial_number
633: , l_parameter_list
634: );
635: wf_event.addparametertolist ('DATE_CONTEXT'
636: , l_attr_ctxt
637: , l_parameter_list
638: );
639: wf_event.addparametertolist ('DATE_TYPE'

Line 639: wf_event.addparametertolist ('DATE_TYPE'

635: wf_event.addparametertolist ('DATE_CONTEXT'
636: , l_attr_ctxt
637: , l_parameter_list
638: );
639: wf_event.addparametertolist ('DATE_TYPE'
640: , p_date_type
641: , l_parameter_list
642: );
643: wf_event.addparametertolist ('USER_DATE_TYPE'

Line 643: wf_event.addparametertolist ('USER_DATE_TYPE'

639: wf_event.addparametertolist ('DATE_TYPE'
640: , p_date_type
641: , l_parameter_list
642: );
643: wf_event.addparametertolist ('USER_DATE_TYPE'
644: , l_user_column_name
645: , l_parameter_list
646: );
647: wf_event.addparametertolist ('DATE_VALUE'

Line 647: wf_event.addparametertolist ('DATE_VALUE'

643: wf_event.addparametertolist ('USER_DATE_TYPE'
644: , l_user_column_name
645: , l_parameter_list
646: );
647: wf_event.addparametertolist ('DATE_VALUE'
648: , l_serial_rec.date_column
649: , l_parameter_list
650: );
651: wf_event.addparametertolist ('ACTION_CODE'

Line 651: wf_event.addparametertolist ('ACTION_CODE'

647: wf_event.addparametertolist ('DATE_VALUE'
648: , l_serial_rec.date_column
649: , l_parameter_list
650: );
651: wf_event.addparametertolist ('ACTION_CODE'
652: , NULL
653: , l_parameter_list
654: );
655: wf_event.addparametertolist ('SERIAL_STATUS'

Line 655: wf_event.addparametertolist ('SERIAL_STATUS'

651: wf_event.addparametertolist ('ACTION_CODE'
652: , NULL
653: , l_parameter_list
654: );
655: wf_event.addparametertolist ('SERIAL_STATUS'
656: , l_serial_rec.serial_status
657: , l_parameter_list
658: );
659: wf_event.addparametertolist ('ONHAND_QTY_UOM'

Line 659: wf_event.addparametertolist ('ONHAND_QTY_UOM'

655: wf_event.addparametertolist ('SERIAL_STATUS'
656: , l_serial_rec.serial_status
657: , l_parameter_list
658: );
659: wf_event.addparametertolist ('ONHAND_QTY_UOM'
660: , NULL
661: , l_parameter_list
662: );
663: wf_event.addparametertolist ('TRANSACTION_ID'

Line 663: wf_event.addparametertolist ('TRANSACTION_ID'

659: wf_event.addparametertolist ('ONHAND_QTY_UOM'
660: , NULL
661: , l_parameter_list
662: );
663: wf_event.addparametertolist ('TRANSACTION_ID'
664: , l_serial_rec.gen_object_id
665: , l_parameter_list
666: );
667:

Line 680: wf_event.RAISE

676: || ' '
677: || l_serial_rec.date_column
678: );
679:
680: wf_event.RAISE
681: (p_event_name => 'oracle.apps.inv.Date.Notification'
682: , p_parameters => l_parameter_list
683: , p_event_key => TO_CHAR (p_organization_id)
684: || '+-?*'