[Home] [Help]
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: | srpuri FP Bug 7422975 Added the condition to convert the transaction |
22: | quantity to the secondary only when the secondary uom code is not null |
23: | srpuri FP Bug 8343517 Modified procedure |
93: From mtl_reservations
94: Where supply_source_line_id = p_batch_line_id
95: and supply_source_type_id = 5
96: -- and demand_source_type_id = inv_reservation_global.g_source_type_oe
97: and demand_source_type_id IN (inv_reservation_global.g_source_type_oe, gme_common_pvt.g_txn_source_type) -- Bug 13630492
98: and reservation_quantity<>0
99: ;
100:
101: Cursor get_batch_line (p_batch_id IN NUMBER) IS
630: IF g_debug <= gme_debug.g_log_procedure THEN
631: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : raising business event ');
632: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Notify CSR : session_id '|| l_session_id );
633: End if;
634: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
635: p_event_key => l_session_id,
636: p_parameters => l_parameter_list);
637:
638: IF(l_last_updated_by <> l_created_by) THEN
652: , p_organization_id => l_organization_id
653: , p_action_code => l_action_code );
654: */
655: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);
656: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
657: p_event_key => l_session_id,
658: p_parameters => l_parameter_list);
659: END IF;
660: /* check to see when FPO converts to batches, the CSR for each new batch will get a notification*/
688: */
689: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
690: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
691: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
692: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
693: p_event_key => l_session_id,
694: p_parameters => l_parameter_list);
695:
696: IF(l_last_updated_by <> l_created_by) THEN
710: , p_organization_id => l_organization_id
711: , p_action_code => l_action_code );
712: */
713: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);
714: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
715: p_event_key => l_session_id,
716: p_parameters => l_parameter_list);
717: END IF;
718: END IF;
744: */
745: wf_event.AddParameterToList('APPROVER',l_last_updated_by ,l_parameter_list);
746: wf_event.AddParameterToList('SO_LINE_ID',l_so_line_id ,l_parameter_list);
747: wf_event.AddParameterToList('SO_HEADER_ID',l_so_header_id ,l_parameter_list);
748: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
749: p_event_key => l_session_id,
750: p_parameters => l_parameter_list);
751:
752: IF(l_last_updated_by <> l_created_by) THEN
766: , p_organization_id => l_organization_id
767: , p_action_code => l_action_code );
768: */
769: wf_event.AddParameterToList('APPROVER',l_created_by ,l_parameter_list);
770: wf_event.raise(p_event_name => gme_common_pvt.G_BATCH_RESERVATIONS,
771: p_event_key => l_session_id,
772: p_parameters => l_parameter_list);
773: END IF;
774: END IF;
807: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
808: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
809: l_rsv_rec_inq inv_reservation_global.mtl_reservation_rec_type;
810: l_mmt_rec mtl_material_transactions%ROWTYPE;
811: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
812: l_rsv_count NUMBER;
813: l_rsv_id NUMBER;
814: l_error_code NUMBER;
815: l_qty_to_transfer NUMBER := 0;