DBA Data[Home] [Help]

APPS.WMS_UT_PKG dependencies on INV_RESERVATION_GLOBAL

Line 38: g_reservations inv_reservation_global.mtl_reservation_tbl_type;

34:
35:
36: g_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
37: g_trolin_tbl_clear INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
38: g_reservations inv_reservation_global.mtl_reservation_tbl_type;
39: g_reservations_clear inv_reservation_global.mtl_reservation_tbl_type;
40: g_demand_tbl demand_tbl_type;
41: g_demand_tbl_clear demand_tbl_type;
42: g_rsvs_tbl rsvinfo_tbl_type;

Line 39: g_reservations_clear inv_reservation_global.mtl_reservation_tbl_type;

35:
36: g_trolin_tbl INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
37: g_trolin_tbl_clear INV_MOVE_ORDER_PUB.Trolin_Tbl_Type;
38: g_reservations inv_reservation_global.mtl_reservation_tbl_type;
39: g_reservations_clear inv_reservation_global.mtl_reservation_tbl_type;
40: g_demand_tbl demand_tbl_type;
41: g_demand_tbl_clear demand_tbl_type;
42: g_rsvs_tbl rsvinfo_tbl_type;
43: g_link_mo_dem numtabtype;

Line 941: l_reserved_serials inv_reservation_global.serial_number_tbl_type;

937: -- SERIAL :

Line 942: l_rsvs_serials inv_reservation_global.serial_number_tbl_type;

938: l_rsvs_lst arrchartabtype150;
939: l_rsvs_ser_lst arrchartabtype150;
940: l_rsvs_label VARCHAR2(150);
941: l_reserved_serials inv_reservation_global.serial_number_tbl_type;
942: l_rsvs_serials inv_reservation_global.serial_number_tbl_type;
943: l_new_reservation inv_reservation_global.mtl_reservation_rec_type;
944:
945: l_dem_label_index NUMBER;
946:

Line 943: l_new_reservation inv_reservation_global.mtl_reservation_rec_type;

939: l_rsvs_ser_lst arrchartabtype150;
940: l_rsvs_label VARCHAR2(150);
941: l_reserved_serials inv_reservation_global.serial_number_tbl_type;
942: l_rsvs_serials inv_reservation_global.serial_number_tbl_type;
943: l_new_reservation inv_reservation_global.mtl_reservation_rec_type;
944:
945: l_dem_label_index NUMBER;
946:
947: l_return_status VARCHAR(10);

Line 973: l_demand_source_type_id := inv_reservation_global.g_source_type_inv;

969: l_rsv_label := l_rsvs_lst(i)(1);
970: l_dem_label_index := get_demand_label_index(l_rsv_label);
971: print_debug('Demand Label : ' || l_rsv_label || ' ID:'||l_dem_label_index || ' i = ' || i);
972: IF l_dem_label_index = 0 THEN
973: l_demand_source_type_id := inv_reservation_global.g_source_type_inv;
974: l_demand_source_header_id := NULL;
975: l_demand_source_line_id := NULL;
976: l_demand_source_name := g_testname || '_' || p_runid;
977: ELSE

Line 1019: l_new_reservation.supply_source_type_id := inv_reservation_global.g_source_type_inv;

1015: l_new_reservation.reservation_quantity := NULL;
1016: l_new_reservation.autodetail_group_id := NULL;
1017: l_new_reservation.external_source_code := NULL;
1018: l_new_reservation.external_source_line_id := NULL;
1019: l_new_reservation.supply_source_type_id := inv_reservation_global.g_source_type_inv;
1020: l_new_reservation.supply_source_header_id := NULL;
1021: l_new_reservation.supply_source_line_id := NULL;
1022: l_new_reservation.supply_source_name := NULL;
1023: l_new_reservation.supply_source_line_detail := NULL;

Line 1220: l_update_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1216: l_msg_count NUMBER;
1217: l_msg_data VARCHAR2(200);
1218: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1219:
1220: l_update_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1221: l_reservations inv_reservation_global.mtl_reservation_tbl_type;
1222: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1223: l_qty_succ_reserved NUMBER;
1224: l_reservation_id NUMBER;

Line 1221: l_reservations inv_reservation_global.mtl_reservation_tbl_type;

1217: l_msg_data VARCHAR2(200);
1218: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1219:
1220: l_update_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1221: l_reservations inv_reservation_global.mtl_reservation_tbl_type;
1222: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1223: l_qty_succ_reserved NUMBER;
1224: l_reservation_id NUMBER;
1225: l_ix NUMBER;

Line 1222: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

1218: l_commit VARCHAR2(1) := FND_API.G_FALSE;
1219:
1220: l_update_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1221: l_reservations inv_reservation_global.mtl_reservation_tbl_type;
1222: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1223: l_qty_succ_reserved NUMBER;
1224: l_reservation_id NUMBER;
1225: l_ix NUMBER;
1226: l_inventory_item_id NUMBER;

Line 1388: g_demand_tbl(l_dem_indx).demand_source_type_id := inv_reservation_global.g_source_type_inv;

1384: SET txn_source_line_id = l_trolin_tbl(l_ix).line_id
1385: WHERE line_id = l_trolin_tbl(l_ix).line_id;
1386:
1387: IF l_mo_orders(l_ix)(1) IS NOT NULL THEN
1388: g_demand_tbl(l_dem_indx).demand_source_type_id := inv_reservation_global.g_source_type_inv;
1389: g_demand_tbl(l_dem_indx).demand_source_name := l_mo_orders(l_ix)(1);
1390: END IF;
1391: g_demand_tbl(l_dem_indx).mo_line_id := l_trolin_tbl(l_ix).line_id;
1392:

Line 2061: l_demand_rsvs_ordered inv_reservation_global.mtl_reservation_tbl_type;

2057: l_simulation_id number;
2058: l_start DATE;
2059: l_rule_param arrchartabtype150;
2060:
2061: l_demand_rsvs_ordered inv_reservation_global.mtl_reservation_tbl_type;
2062: l_rsv_qty_available NUMBER;
2063:
2064: l_rsv_qty2_available NUMBER; --BUG#7377744 Added a secondary quantity available to reserve to make it consistent with process_reservations call
2065: l_demand_info wsh_inv_delivery_details_v%ROWTYPE;

Line 2090: , p_demand_source_type => inv_reservation_global.g_source_type_inv

2086: , p_suggest_serial => 'N'
2087: , p_mo_line_rec => g_trolin_tbl(i)
2088: , p_demand_source_header_id => NULL
2089: , p_demand_source_line_id => NULL
2090: , p_demand_source_type => inv_reservation_global.g_source_type_inv
2091: , p_demand_source_name => g_trolin_tbl(i).line_id
2092: , p_suggestions => l_wtt_tbl);
2093:
2094: /* End Calling API */