DBA Data[Home] [Help]

APPS.GME_SUPPLY_RES_PVT dependencies on WF_EVENT

Line 20: | WF event names such as 'oracle.apps.gme...' |

16: | HISTORY |
17: | Aug-18-2003 Liping Gao Created |
18: | Archana Mundhe Bug 5763818 Modified the code to use constants |
19: | that are added to gme_common_pvt instead of using the hardcoded |
20: | WF event names such as 'oracle.apps.gme...' |
21: +=========================================================================+
22: API Name : GME_SUPPLY_RES_PVT
23: Type : Private
24: Function : This package contains Private procedures used for change management

Line 604: wf_event.AddParameterToList('SESSION_ID', l_session_id,l_parameter_list);

600: , p_organization_id => l_organization_id
601: , p_action_code => l_action_code );
602: */
603: wf_log_pkg.wf_debug_flag:=TRUE;
604: wf_event.AddParameterToList('SESSION_ID', l_session_id,l_parameter_list);
605: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
606: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
607: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
608: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);

Line 605: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);

601: , p_action_code => l_action_code );
602: */
603: wf_log_pkg.wf_debug_flag:=TRUE;
604: wf_event.AddParameterToList('SESSION_ID', l_session_id,l_parameter_list);
605: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
606: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
607: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
608: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);
609: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);

Line 606: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);

602: */
603: wf_log_pkg.wf_debug_flag:=TRUE;
604: wf_event.AddParameterToList('SESSION_ID', l_session_id,l_parameter_list);
605: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
606: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
607: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
608: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);
609: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);
610: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);

Line 607: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);

603: wf_log_pkg.wf_debug_flag:=TRUE;
604: wf_event.AddParameterToList('SESSION_ID', l_session_id,l_parameter_list);
605: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
606: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
607: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
608: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);
609: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);
610: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);
611: wf_event.AddParameterToList('ORGANIZATION_ID',l_organization_id ,l_parameter_list);

Line 608: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);

604: wf_event.AddParameterToList('SESSION_ID', l_session_id,l_parameter_list);
605: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
606: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
607: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
608: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);
609: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);
610: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);
611: wf_event.AddParameterToList('ORGANIZATION_ID',l_organization_id ,l_parameter_list);
612: wf_event.AddParameterToList('ACTION_CODE',l_action_code ,l_parameter_list);

Line 609: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);

605: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
606: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
607: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
608: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);
609: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);
610: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);
611: wf_event.AddParameterToList('ORGANIZATION_ID',l_organization_id ,l_parameter_list);
612: wf_event.AddParameterToList('ACTION_CODE',l_action_code ,l_parameter_list);
613: wf_event.AddParameterToList('LOT_NO',l_lot_number,l_parameter_list);

Line 610: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);

606: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
607: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
608: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);
609: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);
610: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);
611: wf_event.AddParameterToList('ORGANIZATION_ID',l_organization_id ,l_parameter_list);
612: wf_event.AddParameterToList('ACTION_CODE',l_action_code ,l_parameter_list);
613: wf_event.AddParameterToList('LOT_NO',l_lot_number,l_parameter_list);
614: IF g_debug <= gme_debug.g_log_procedure THEN

Line 611: wf_event.AddParameterToList('ORGANIZATION_ID',l_organization_id ,l_parameter_list);

607: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
608: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);
609: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);
610: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);
611: wf_event.AddParameterToList('ORGANIZATION_ID',l_organization_id ,l_parameter_list);
612: wf_event.AddParameterToList('ACTION_CODE',l_action_code ,l_parameter_list);
613: wf_event.AddParameterToList('LOT_NO',l_lot_number,l_parameter_list);
614: IF g_debug <= gme_debug.g_log_procedure THEN
615: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : raising business event ');

Line 612: wf_event.AddParameterToList('ACTION_CODE',l_action_code ,l_parameter_list);

608: wf_event.AddParameterToList('BATCH_ID',l_batch_id ,l_parameter_list);
609: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);
610: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);
611: wf_event.AddParameterToList('ORGANIZATION_ID',l_organization_id ,l_parameter_list);
612: wf_event.AddParameterToList('ACTION_CODE',l_action_code ,l_parameter_list);
613: wf_event.AddParameterToList('LOT_NO',l_lot_number,l_parameter_list);
614: IF g_debug <= gme_debug.g_log_procedure THEN
615: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : raising business event ');
616: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : session_id '|| l_session_id );

Line 613: wf_event.AddParameterToList('LOT_NO',l_lot_number,l_parameter_list);

609: wf_event.AddParameterToList('BATCH_LINE_ID',p_batch_line_id ,l_parameter_list);
610: wf_event.AddParameterToList('FPO_ID',p_fpo_id ,l_parameter_list);
611: wf_event.AddParameterToList('ORGANIZATION_ID',l_organization_id ,l_parameter_list);
612: wf_event.AddParameterToList('ACTION_CODE',l_action_code ,l_parameter_list);
613: wf_event.AddParameterToList('LOT_NO',l_lot_number,l_parameter_list);
614: IF g_debug <= gme_debug.g_log_procedure THEN
615: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : raising business event ');
616: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : session_id '|| l_session_id );
617: End if;

Line 618: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,

614: IF g_debug <= gme_debug.g_log_procedure THEN
615: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : raising business event ');
616: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : session_id '|| l_session_id );
617: End if;
618: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
619: p_event_key => l_session_id,
620: p_parameters => l_parameter_list);
621:
622: IF(l_last_updated_by <> l_created_by) THEN

Line 639: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);

635: , p_fpo_id => NULL
636: , p_organization_id => l_organization_id
637: , p_action_code => l_action_code );
638: */
639: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);
640: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
641: p_event_key => l_session_id,
642: p_parameters => l_parameter_list);
643: END IF;

Line 640: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,

636: , p_organization_id => l_organization_id
637: , p_action_code => l_action_code );
638: */
639: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);
640: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
641: p_event_key => l_session_id,
642: p_parameters => l_parameter_list);
643: END IF;
644: /* check to see when FPO converts to batches, the CSR for each new batch will get a notification*/

Line 673: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);

669: , p_fpo_id => NULL
670: , p_organization_id => l_organization_id
671: , p_action_code => l_action_code );
672: */
673: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
674: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
675: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
676: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
677: p_event_key => l_session_id,

Line 674: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);

670: , p_organization_id => l_organization_id
671: , p_action_code => l_action_code );
672: */
673: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
674: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
675: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
676: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
677: p_event_key => l_session_id,
678: p_parameters => l_parameter_list);

Line 675: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);

671: , p_action_code => l_action_code );
672: */
673: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
674: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
675: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
676: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
677: p_event_key => l_session_id,
678: p_parameters => l_parameter_list);
679:

Line 676: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,

672: */
673: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
674: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
675: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
676: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
677: p_event_key => l_session_id,
678: p_parameters => l_parameter_list);
679:
680: IF(l_last_updated_by <> l_created_by) THEN

Line 697: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);

693: , p_fpo_id => NULL
694: , p_organization_id => l_organization_id
695: , p_action_code => l_action_code );
696: */
697: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);
698: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
699: p_event_key => l_session_id,
700: p_parameters => l_parameter_list);
701: END IF;

Line 698: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,

694: , p_organization_id => l_organization_id
695: , p_action_code => l_action_code );
696: */
697: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);
698: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
699: p_event_key => l_session_id,
700: p_parameters => l_parameter_list);
701: END IF;
702: END IF;

Line 729: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);

725: , p_fpo_id => NULL
726: , p_organization_id => l_organization_id
727: , p_action_code => l_action_code );
728: */
729: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
730: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
731: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
732: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
733: p_event_key => l_session_id,

Line 730: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);

726: , p_organization_id => l_organization_id
727: , p_action_code => l_action_code );
728: */
729: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
730: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
731: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
732: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
733: p_event_key => l_session_id,
734: p_parameters => l_parameter_list);

Line 731: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);

727: , p_action_code => l_action_code );
728: */
729: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
730: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
731: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
732: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
733: p_event_key => l_session_id,
734: p_parameters => l_parameter_list);
735:

Line 732: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,

728: */
729: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
730: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
731: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
732: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
733: p_event_key => l_session_id,
734: p_parameters => l_parameter_list);
735:
736: IF(l_last_updated_by <> l_created_by) THEN

Line 753: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);

749: , p_fpo_id => NULL
750: , p_organization_id => l_organization_id
751: , p_action_code => l_action_code );
752: */
753: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);
754: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
755: p_event_key => l_session_id,
756: p_parameters => l_parameter_list);
757: END IF;

Line 754: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,

750: , p_organization_id => l_organization_id
751: , p_action_code => l_action_code );
752: */
753: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);
754: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
755: p_event_key => l_session_id,
756: p_parameters => l_parameter_list);
757: END IF;
758: END IF;