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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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: /*
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: || '+-?*'
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)
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)
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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'
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:
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: || '+-?*'