eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_DIRECT_SHIP_PVT dependencies on INV_RESERVATION_GLOBAL

Line 4593: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;

4589: x_msg_data OUT NOCOPY VARCHAR2)
4590: RETURN DELIVERY_DETAIL_TAB IS
4591:
4592: --Local Variables
4593: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;
4594: l_delivery_detail_tab DELIVERY_DETAIL_TAB;
4595: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
4596: l_mtl_reservation_tbl_count NUMBER;
4597: l_detail_tab WSH_UTIL_CORE.ID_TAB_TYPE;

Line 4595: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

4591:
4592: --Local Variables
4593: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;
4594: l_delivery_detail_tab DELIVERY_DETAIL_TAB;
4595: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
4596: l_mtl_reservation_tbl_count NUMBER;
4597: l_detail_tab WSH_UTIL_CORE.ID_TAB_TYPE;
4598: l_return_status VARCHAR2(1);
4599: l_msg_data VARCHAR2(3000);

Line 4636: l_reservation_record.supply_source_type_id := inv_reservation_global.g_source_type_inv;

4632:
4633: l_reservation_record.demand_source_header_id := p_mso_id;
4634: l_reservation_record.demand_source_line_id := p_source_line_id;
4635: l_reservation_record.lpn_id := p_lpn_id;
4636: l_reservation_record.supply_source_type_id := inv_reservation_global.g_source_type_inv;
4637:
4638: IF (l_debug = 1) THEN
4639: DEBUG('Before call to reservation for LPN ID'||p_lpn_id, 'Overship Staged Lines');
4640: END IF;

Line 5022: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;

5018: l_new_delivery_detail_id NUMBER;
5019: l_dummy_num_var NUMBER;
5020:
5021: /* For query reservations */
5022: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;
5023: l_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type; -- bug 4306508
5024: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
5025: l_mtl_reservation_tbl_count NUMBER;
5026: l_reservation_exists_flag VARCHAR2(1);

Line 5023: l_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type; -- bug 4306508

5019: l_dummy_num_var NUMBER;
5020:
5021: /* For query reservations */
5022: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;
5023: l_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type; -- bug 4306508
5024: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
5025: l_mtl_reservation_tbl_count NUMBER;
5026: l_reservation_exists_flag VARCHAR2(1);
5027: l_reserved_lpn NUMBER;

Line 5024: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

5020:
5021: /* For query reservations */
5022: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;
5023: l_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type; -- bug 4306508
5024: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
5025: l_mtl_reservation_tbl_count NUMBER;
5026: l_reservation_exists_flag VARCHAR2(1);
5027: l_reserved_lpn NUMBER;
5028: l_return_status VARCHAR2(1);

Line 5032: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

5028: l_return_status VARCHAR2(1);
5029: l_msg_count NUMBER;
5030: l_msg_data VARCHAR2(20000);
5031: l_error_code NUMBER;
5032: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
5033: l_outer_lpn outer_lpn%ROWTYPE;
5034: l_inner_lpn inner_lpn%ROWTYPE;
5035: l_mso_id NUMBER;
5036: l_outermost_lpn_id NUMBER;

Line 8258: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;

8254: , ont_pricing_qty_source VARCHAR2(30)
8255: );
8256: l_lpn_content_cur_rec l_lpn_content_cur_rec_typ;
8257:
8258: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;
8259: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;
8260:
8261: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type; --bug#5262108
8262: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type; --bug#5262108

Line 8259: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;

8255: );
8256: l_lpn_content_cur_rec l_lpn_content_cur_rec_typ;
8257:
8258: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;
8259: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;
8260:
8261: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type; --bug#5262108
8262: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type; --bug#5262108
8263: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type; --bug#5262108

Line 8261: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type; --bug#5262108

8257:
8258: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;
8259: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;
8260:
8261: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type; --bug#5262108
8262: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type; --bug#5262108
8263: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type; --bug#5262108
8264:
8265: l_processed_lines_tab processed_lines_tab;

Line 8262: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type; --bug#5262108

8258: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;
8259: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;
8260:
8261: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type; --bug#5262108
8262: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type; --bug#5262108
8263: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type; --bug#5262108
8264:
8265: l_processed_lines_tab processed_lines_tab;
8266: l_order_line_rec order_line_rec;

Line 8263: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type; --bug#5262108

8259: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;
8260:
8261: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type; --bug#5262108
8262: l_new_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type; --bug#5262108
8263: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type; --bug#5262108
8264:
8265: l_processed_lines_tab processed_lines_tab;
8266: l_order_line_rec order_line_rec;
8267: l_start_index NUMBER := 1;

Line 8689: l_qry_reservation_record.supply_source_type_id := inv_reservation_global.g_source_type_inv;

8685: l_qry_reservation_record.inventory_item_id := g_lpn_contents_tab(c_index).inventory_item_id;
8686: l_qry_reservation_record.revision := g_lpn_contents_tab(c_index).revision;
8687: l_qry_reservation_record.lot_number := g_lpn_contents_tab(c_index).lot_number;
8688: l_qry_reservation_record.lpn_id := g_lpn_contents_tab(c_index).lpn_id;
8689: l_qry_reservation_record.supply_source_type_id := inv_reservation_global.g_source_type_inv;
8690: l_mtl_reservation_tab.DELETE;
8691: inv_reservation_pub.query_reservation(
8692: p_api_version_number => 1.0
8693: , p_init_msg_lst => fnd_api.g_false

Line 9236: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;

9232: , x_msg_count OUT NOCOPY NUMBER
9233: , x_msg_data OUT NOCOPY VARCHAR2
9234: ) IS
9235: -- for query reservation
9236: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;
9237: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;
9238: l_mtl_reservation_tab_temp inv_reservation_global.mtl_reservation_tbl_type;
9239: l_mtl_reservation_tab_count NUMBER;
9240: l_mtl_resv_tab_count_temp NUMBER;

Line 9237: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;

9233: , x_msg_data OUT NOCOPY VARCHAR2
9234: ) IS
9235: -- for query reservation
9236: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;
9237: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;
9238: l_mtl_reservation_tab_temp inv_reservation_global.mtl_reservation_tbl_type;
9239: l_mtl_reservation_tab_count NUMBER;
9240: l_mtl_resv_tab_count_temp NUMBER;
9241: l_return_status VARCHAR2(10);

Line 9238: l_mtl_reservation_tab_temp inv_reservation_global.mtl_reservation_tbl_type;

9234: ) IS
9235: -- for query reservation
9236: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;
9237: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;
9238: l_mtl_reservation_tab_temp inv_reservation_global.mtl_reservation_tbl_type;
9239: l_mtl_reservation_tab_count NUMBER;
9240: l_mtl_resv_tab_count_temp NUMBER;
9241: l_return_status VARCHAR2(10);
9242: l_msg_count NUMBER;

Line 9246: l_resv_rec inv_reservation_global.mtl_reservation_rec_type;

9242: l_msg_count NUMBER;
9243: l_msg_data VARCHAR2(20000);
9244: l_error_code NUMBER;
9245: -- genaral
9246: l_resv_rec inv_reservation_global.mtl_reservation_rec_type;
9247: l_demand_source_header_id NUMBER;
9248: l_order_source_id NUMBER;
9249: l_demand_source_type_id NUMBER;
9250: l_quantity_reserved NUMBER := 0;

Line 9271: l_old_resv_rec inv_reservation_global.mtl_reservation_rec_type;

9267: l_qr NUMBER;
9268: l_qs NUMBER;
9269: l_atr NUMBER;
9270: -- For transfer reservation
9271: l_old_resv_rec inv_reservation_global.mtl_reservation_rec_type;
9272: l_new_resv_rec inv_reservation_global.mtl_reservation_rec_type;
9273: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
9274: l_new_rsv_id NUMBER;
9275: l_current_rsv_rem_qty NUMBER;

Line 9272: l_new_resv_rec inv_reservation_global.mtl_reservation_rec_type;

9268: l_qs NUMBER;
9269: l_atr NUMBER;
9270: -- For transfer reservation
9271: l_old_resv_rec inv_reservation_global.mtl_reservation_rec_type;
9272: l_new_resv_rec inv_reservation_global.mtl_reservation_rec_type;
9273: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
9274: l_new_rsv_id NUMBER;
9275: l_current_rsv_rem_qty NUMBER;
9276: -- For create_reservation

Line 9273: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

9269: l_atr NUMBER;
9270: -- For transfer reservation
9271: l_old_resv_rec inv_reservation_global.mtl_reservation_rec_type;
9272: l_new_resv_rec inv_reservation_global.mtl_reservation_rec_type;
9273: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
9274: l_new_rsv_id NUMBER;
9275: l_current_rsv_rem_qty NUMBER;
9276: -- For create_reservation
9277: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;

Line 9277: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;

9273: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
9274: l_new_rsv_id NUMBER;
9275: l_current_rsv_rem_qty NUMBER;
9276: -- For create_reservation
9277: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;
9278: l_quantity_reserved_tmp NUMBER;
9279: l_reservation_id NUMBER;
9280: -- For Update reservation
9281: l_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;

Line 9281: l_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;

9277: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;
9278: l_quantity_reserved_tmp NUMBER;
9279: l_reservation_id NUMBER;
9280: -- For Update reservation
9281: l_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
9282: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
9283: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
9284: l_chk_resv_qty NUMBER;
9285: l_resv_id NUMBER;

Line 9282: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;

9278: l_quantity_reserved_tmp NUMBER;
9279: l_reservation_id NUMBER;
9280: -- For Update reservation
9281: l_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
9282: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
9283: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
9284: l_chk_resv_qty NUMBER;
9285: l_resv_id NUMBER;
9286: l_other_resv_qty NUMBER;

Line 9283: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;

9279: l_reservation_id NUMBER;
9280: -- For Update reservation
9281: l_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
9282: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
9283: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
9284: l_chk_resv_qty NUMBER;
9285: l_resv_id NUMBER;
9286: l_other_resv_qty NUMBER;
9287: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

Line 9429: l_qry_reservation_record.supply_source_type_id := inv_reservation_global.g_source_type_inv;

9425: -- query reservations for header_id, line_id
9426: l_demand_source_header_id := inv_salesorder.get_salesorder_for_oeheader(p_order_header_id);
9427: l_qry_reservation_record.demand_source_header_id := l_demand_source_header_id;
9428: l_qry_reservation_record.demand_source_line_id := p_order_line_id;
9429: l_qry_reservation_record.supply_source_type_id := inv_reservation_global.g_source_type_inv;
9430:
9431: IF (l_debug = 1) THEN
9432: DEBUG('Before call to query reservation', 'Prpcess_Line');
9433: END IF;

Line 10490: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;

10486: WHERE outermost_lpn_id = p_lpn_id
10487: AND organization_id = p_org_id;
10488:
10489: -- query reservations
10490: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;
10491: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;
10492: l_mtl_reservation_tab_count NUMBER;
10493: l_lpn_ids_tab number_table;
10494: l_return_status VARCHAR2(3);

Line 10491: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;

10487: AND organization_id = p_org_id;
10488:
10489: -- query reservations
10490: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;
10491: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;
10492: l_mtl_reservation_tab_count NUMBER;
10493: l_lpn_ids_tab number_table;
10494: l_return_status VARCHAR2(3);
10495: l_msg_count NUMBER;

Line 10525: l_qry_reservation_record.supply_source_type_id := inv_reservation_global.g_source_type_inv;

10521: -- for each line in WDS from p_lpn_id
10522: FOR l_wds_cur IN wds_cur LOOP
10523: l_qry_reservation_record.demand_source_line_id := l_wds_cur.order_line_id;
10524: l_qry_reservation_record.demand_source_header_id := inv_salesorder.get_salesorder_for_oeheader(l_wds_cur.order_header_id);
10525: l_qry_reservation_record.supply_source_type_id := inv_reservation_global.g_source_type_inv;
10526:
10527: IF (l_debug = 1) THEN
10528: DEBUG('Before call to query reservation', 'Load_LPN');
10529: END IF;

Line 10721: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;

10717: l_old_total_lpn_qty NUMBER := g_total_lpn_quantity;
10718: l_loaded_lines_rec loaded_lines%ROWTYPE;
10719: l_lpn_cont_rec lpn_content_rec;
10720: -- for query reservation
10721: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;
10722: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;
10723: l_mtl_resv_tab_count NUMBER;
10724: -- general
10725: l_order_line_id NUMBER;

Line 10722: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;

10718: l_loaded_lines_rec loaded_lines%ROWTYPE;
10719: l_lpn_cont_rec lpn_content_rec;
10720: -- for query reservation
10721: l_qry_reservation_record inv_reservation_global.mtl_reservation_rec_type;
10722: l_mtl_reservation_tab inv_reservation_global.mtl_reservation_tbl_type;
10723: l_mtl_resv_tab_count NUMBER;
10724: -- general
10725: l_order_line_id NUMBER;
10726: l_order_header_id NUMBER;

Line 10736: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;

10732: l_minmaxinoutrectype wsh_integration.minmaxinoutrectype; */
10733: l_max_shippable_quantity NUMBER;
10734: l_total_resvd_qty NUMBER;
10735: -- For create_reservation
10736: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;
10737: l_quantity_reserved_tmp NUMBER;
10738: l_reservation_id NUMBER;
10739: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
10740: l_demand_source_header_id NUMBER;

Line 10739: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

10735: -- For create_reservation
10736: l_reservation_record inv_reservation_global.mtl_reservation_rec_type;
10737: l_quantity_reserved_tmp NUMBER;
10738: l_reservation_id NUMBER;
10739: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
10740: l_demand_source_header_id NUMBER;
10741: l_demand_source_type_id NUMBER;
10742: l_order_source_id NUMBER;
10743: -- For Update reservation

Line 10744: l_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;

10740: l_demand_source_header_id NUMBER;
10741: l_demand_source_type_id NUMBER;
10742: l_order_source_id NUMBER;
10743: -- For Update reservation
10744: l_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
10745: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
10746: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
10747: l_chk_resv_qty NUMBER;
10748: l_resv_id NUMBER;

Line 10745: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;

10741: l_demand_source_type_id NUMBER;
10742: l_order_source_id NUMBER;
10743: -- For Update reservation
10744: l_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
10745: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
10746: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
10747: l_chk_resv_qty NUMBER;
10748: l_resv_id NUMBER;
10749: l_qty_updt_resv NUMBER;

Line 10746: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;

10742: l_order_source_id NUMBER;
10743: -- For Update reservation
10744: l_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
10745: l_old_upd_resv_rec inv_reservation_global.mtl_reservation_rec_type;
10746: l_upd_dummy_sn inv_reservation_global.serial_number_tbl_type;
10747: l_chk_resv_qty NUMBER;
10748: l_resv_id NUMBER;
10749: l_qty_updt_resv NUMBER;
10750: l_qty_overship NUMBER;

Line 10798: l_qry_reservation_record.supply_source_type_id := inv_reservation_global.g_source_type_inv;

10794: l_qry_reservation_record.lpn_id := l_lpn_cont_rec.lpn_id;
10795: l_qry_reservation_record.inventory_item_id := l_lpn_cont_rec.inventory_item_id;
10796: l_qry_reservation_record.revision := l_lpn_cont_rec.revision;
10797: l_qry_reservation_record.lot_number := l_lpn_cont_rec.lot_number;
10798: l_qry_reservation_record.supply_source_type_id := inv_reservation_global.g_source_type_inv;
10799:
10800: IF (l_debug = 1) THEN
10801: DEBUG('Before call to query reservation', 'Perform_Overship_Distribution');
10802: END IF;