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