APPS.GME_MAKE_TO_ORDER_PVT dependencies on INV_RESERVATION_GLOBAL

Line 79: l_rsv_rec INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;

75: l_item_rec MTL_SYSTEM_ITEMS_B%ROWTYPE;
76: l_so_batch_rsv_rec GML_BATCH_OM_UTIL.gme_om_reservation_rec;
77: l_pending_product_lots_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;
78: l_out_pending_product_lots_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;
79: l_rsv_rec INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;
80: l_in_serial_num INV_RESERVATION_GLOBAL.serial_number_tbl_type;
81: l_out_serial_num INV_RESERVATION_GLOBAL.serial_number_tbl_type;
82: l_exception_material_tbl GME_COMMON_PVT.exceptions_tab;
83: l_rsv_tbl GME_COMMON_PVT.reservations_tab;

Line 80: l_in_serial_num INV_RESERVATION_GLOBAL.serial_number_tbl_type;

76: l_so_batch_rsv_rec GML_BATCH_OM_UTIL.gme_om_reservation_rec;
77: l_pending_product_lots_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;
78: l_out_pending_product_lots_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;
79: l_rsv_rec INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;
80: l_in_serial_num INV_RESERVATION_GLOBAL.serial_number_tbl_type;
81: l_out_serial_num INV_RESERVATION_GLOBAL.serial_number_tbl_type;
82: l_exception_material_tbl GME_COMMON_PVT.exceptions_tab;
83: l_rsv_tbl GME_COMMON_PVT.reservations_tab;
84: l_rsv_row_rec MTL_RESERVATIONS%ROWTYPE;

Line 81: l_out_serial_num INV_RESERVATION_GLOBAL.serial_number_tbl_type;

77: l_pending_product_lots_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;
78: l_out_pending_product_lots_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;
79: l_rsv_rec INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;
80: l_in_serial_num INV_RESERVATION_GLOBAL.serial_number_tbl_type;
81: l_out_serial_num INV_RESERVATION_GLOBAL.serial_number_tbl_type;
82: l_exception_material_tbl GME_COMMON_PVT.exceptions_tab;
83: l_rsv_tbl GME_COMMON_PVT.reservations_tab;
84: l_rsv_row_rec MTL_RESERVATIONS%ROWTYPE;
85: l_in_assignments_rec GME_MTO_RULE_ASSIGNMENTS%ROWTYPE;

Line 145: WHERE demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe

141:
142: CURSOR cur_inv_reservations (p_line_id IN NUMBER) IS
143: SELECT mr.*
144: FROM mtl_reservations mr
145: WHERE demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
146: AND supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_inv
147: AND demand_source_line_id = p_line_id
148: ORDER BY mr.reservation_id;
149:

Line 146: AND supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_inv

142: CURSOR cur_inv_reservations (p_line_id IN NUMBER) IS
143: SELECT mr.*
144: FROM mtl_reservations mr
145: WHERE demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
146: AND supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_inv
147: AND demand_source_line_id = p_line_id
148: ORDER BY mr.reservation_id;
149:
150: CURSOR cur_prod_reservations (p_line_id IN NUMBER) IS

Line 153: WHERE demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe

149:
150: CURSOR cur_prod_reservations (p_line_id IN NUMBER) IS
151: SELECT count(1)
152: FROM mtl_reservations mr
153: WHERE demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
154: AND supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_wip
155: AND demand_source_line_id = p_line_id
156: ORDER BY mr.reservation_id;
157:

Line 154: AND supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_wip

150: CURSOR cur_prod_reservations (p_line_id IN NUMBER) IS
151: SELECT count(1)
152: FROM mtl_reservations mr
153: WHERE demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
154: AND supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_wip
155: AND demand_source_line_id = p_line_id
156: ORDER BY mr.reservation_id;
157:
158: CURSOR cur_item(p_organization_id IN NUMBER, p_inventory_item_id IN NUMBER) IS

Line 432: WHERE demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe

428: begin
429: SELECT sum(mr.primary_reservation_quantity),primary_uom_code
430: into l_total_primary_rsv_qty, l_primary_uom_code
431: FROM mtl_reservations mr
432: WHERE demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
433: AND supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_inv
434: AND demand_source_line_id = l_so_line_rec.line_id
435: GROUP BY mr.primary_uom_code;
436: /* Deduct the reserved quantity from the ordered_quantity

Line 433: AND supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_inv

429: SELECT sum(mr.primary_reservation_quantity),primary_uom_code
430: into l_total_primary_rsv_qty, l_primary_uom_code
431: FROM mtl_reservations mr
432: WHERE demand_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_oe
433: AND supply_source_type_id = INV_RESERVATION_GLOBAL.g_source_type_inv
434: AND demand_source_line_id = l_so_line_rec.line_id
435: GROUP BY mr.primary_uom_code;
436: /* Deduct the reserved quantity from the ordered_quantity
437: * ========================================================= */

Line 497: , p_demand_source_type_id => inv_reservation_global.g_source_type_oe

493: , p_is_lot_control => l_is_lot_control
494: , p_is_serial_control => l_is_serial_control
495: , p_asset_sub_only => FALSE
496: , p_include_suggestion => TRUE
497: , p_demand_source_type_id => inv_reservation_global.g_source_type_oe
498: , p_demand_source_header_id => l_so_line_rec.header_id
499: , p_demand_source_line_id => l_so_line_rec.line_id
500: , p_demand_source_name => NULL
501: , p_demand_source_delivery => NULL

Line 854: l_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_wip;

850: l_rsv_rec.reservation_uom_id := NULL;
851: l_rsv_rec.ship_ready_flag := NULL;
852: l_rsv_rec.detailed_quantity := NULL;
853: l_rsv_rec.secondary_detailed_quantity := NULL;
854: l_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_wip;
855: l_rsv_rec.supply_source_header_id := l_out_batch_header_rec.batch_id;
856: l_rsv_rec.supply_source_line_id := l_material_detail_rec.material_detail_id;
857:
858: IF (g_debug <= gme_debug.g_log_statement) THEN