DBA Data[Home] [Help]

APPS.GME_SUPPLY_RES_PVT dependencies on GME_COMMON_PVT

Line 19: | that are added to gme_common_pvt instead of using the hardcoded |

15: | |
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

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 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 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 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 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 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;

Line 795: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;

791: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
792: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
793: l_rsv_rec_inq inv_reservation_global.mtl_reservation_rec_type;
794: l_mmt_rec mtl_material_transactions%ROWTYPE;
795: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
796: l_rsv_count NUMBER;
797: l_rsv_id NUMBER;
798: l_error_code NUMBER;
799: l_qty_to_transfer NUMBER := 0;