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.OE_ORDER_SCH_UTIL dependencies on INV_RESERVATION_GLOBAL

Line 3567: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

3563: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
3564: l_out_atp_tbl OE_ATP.atp_tbl_type;
3565: mrp_msg_data VARCHAR2(200);
3566:
3567: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
3568: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
3569: l_quantity_reserved NUMBER;
3570: l_qty_to_reserve NUMBER;
3571: l_quantity2_reserved NUMBER; -- INVCONV

Line 3568: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

3564: l_out_atp_tbl OE_ATP.atp_tbl_type;
3565: mrp_msg_data VARCHAR2(200);
3566:
3567: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
3568: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
3569: l_quantity_reserved NUMBER;
3570: l_qty_to_reserve NUMBER;
3571: l_quantity2_reserved NUMBER; -- INVCONV
3572: l_qty2_to_reserve NUMBER; -- INVCONV

Line 3970: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

3966: l_atp_period MRP_ATP_PUB.ATP_Period_Typ;
3967: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
3968: l_out_atp_tbl OE_ATP.atp_tbl_type;
3969: mrp_msg_data VARCHAR2(200);
3970: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
3971: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
3972: l_qty_to_unreserve NUMBER;
3973: l_rsv_id NUMBER;
3974:

Line 3971: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

3967: l_atp_details MRP_ATP_PUB.ATP_Details_Typ;
3968: l_out_atp_tbl OE_ATP.atp_tbl_type;
3969: mrp_msg_data VARCHAR2(200);
3970: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
3971: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
3972: l_qty_to_unreserve NUMBER;
3973: l_rsv_id NUMBER;
3974:
3975: l_qty2_to_unreserve NUMBER; -- INVCONV

Line 4123: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

4119: l_action VARCHAR2(30);
4120: l_old_status VARCHAR2(30);
4121: l_msg_count NUMBER;
4122: l_msg_data VARCHAR2(2000);
4123: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
4124: l_query_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
4125: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
4126: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
4127: l_quantity_reserved NUMBER;

Line 4124: l_query_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

4120: l_old_status VARCHAR2(30);
4121: l_msg_count NUMBER;
4122: l_msg_data VARCHAR2(2000);
4123: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
4124: l_query_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
4125: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
4126: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
4127: l_quantity_reserved NUMBER;
4128: l_rsv_id NUMBER;

Line 4125: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

4121: l_msg_count NUMBER;
4122: l_msg_data VARCHAR2(2000);
4123: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
4124: l_query_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
4125: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
4126: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
4127: l_quantity_reserved NUMBER;
4128: l_rsv_id NUMBER;
4129: l_qty_unreserved NUMBER := 0;

Line 4126: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

4122: l_msg_data VARCHAR2(2000);
4123: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
4124: l_query_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
4125: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
4126: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
4127: l_quantity_reserved NUMBER;
4128: l_rsv_id NUMBER;
4129: l_qty_unreserved NUMBER := 0;
4130: l_qty_reserved NUMBER;

Line 6597: We pass the constant INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE

6593: Procedure Name : Load_INV_Request
6594: Description : This procedure loads the INV's record structure which
6595: we will pass to INV for reservation purpose.
6596: We need to pass to INV the idenfier for OM demand.
6597: We pass the constant INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE
6598: for all OM Order Lines except Internal Orders.
6599: For Internal Orders we pass
6600: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD
6601: as the identifier.

Line 6600: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD

6596: We need to pass to INV the idenfier for OM demand.
6597: We pass the constant INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE
6598: for all OM Order Lines except Internal Orders.
6599: For Internal Orders we pass
6600: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD
6601: as the identifier.
6602: ----------------------------------------------------------------------------- */
6603: Procedure Load_INV_Request
6604: ( p_line_rec IN Oe_Order_Pub.Line_Rec_Type

Line 6607: , x_reservation_rec OUT NOCOPY /* file.sql.39 change */ Inv_Reservation_Global.Mtl_Reservation_Rec_Type)

6603: Procedure Load_INV_Request
6604: ( p_line_rec IN Oe_Order_Pub.Line_Rec_Type
6605: , p_quantity_to_reserve IN NUMBER
6606: , p_quantity2_to_reserve IN NUMBER -- INVCONV
6607: , x_reservation_rec OUT NOCOPY /* file.sql.39 change */ Inv_Reservation_Global.Mtl_Reservation_Rec_Type)
6608: IS
6609: l_rsv Inv_Reservation_Global.Mtl_Reservation_Rec_Type;
6610: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
6611: l_sales_order_id NUMBER;

Line 6609: l_rsv Inv_Reservation_Global.Mtl_Reservation_Rec_Type;

6605: , p_quantity_to_reserve IN NUMBER
6606: , p_quantity2_to_reserve IN NUMBER -- INVCONV
6607: , x_reservation_rec OUT NOCOPY /* file.sql.39 change */ Inv_Reservation_Global.Mtl_Reservation_Rec_Type)
6608: IS
6609: l_rsv Inv_Reservation_Global.Mtl_Reservation_Rec_Type;
6610: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
6611: l_sales_order_id NUMBER;
6612: l_subinventory VARCHAR2(10);
6613: --

Line 6632: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD;

6628: -- This is an internal order line. We need to give
6629: -- a different demand source type for these lines.
6630:
6631: l_rsv.demand_source_type_id :=
6632: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD;
6633: -- intenal order
6634:
6635: ELSE
6636:

Line 6638: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- order entry

6634:
6635: ELSE
6636:
6637: l_rsv.demand_source_type_id :=
6638: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- order entry
6639:
6640: END IF;
6641:
6642: l_rsv.demand_source_name := NULL;

Line 6672: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INV;

6668: l_rsv.external_source_code := NULL;
6669: l_rsv.external_source_line_id := NULL;
6670:
6671: l_rsv.supply_source_type_id :=
6672: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INV;
6673:
6674: l_rsv.supply_source_header_id := NULL;
6675: l_rsv.supply_source_line_id := NULL;
6676: l_rsv.supply_source_name := NULL;

Line 6831: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

6827: , p_quantity2_to_unreserve IN NUMBER -- INVCONV
6828: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
6829: IS
6830: l_line_rec OE_ORDER_PUB.line_rec_type;
6831: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
6832: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;
6833: l_msg_count NUMBER;
6834: l_msg_data VARCHAR2(240);
6835: l_rsv_id NUMBER;

Line 6832: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;

6828: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
6829: IS
6830: l_line_rec OE_ORDER_PUB.line_rec_type;
6831: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
6832: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;
6833: l_msg_count NUMBER;
6834: l_msg_data VARCHAR2(240);
6835: l_rsv_id NUMBER;
6836: l_return_status VARCHAR2(1);

Line 6837: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

6833: l_msg_count NUMBER;
6834: l_msg_data VARCHAR2(240);
6835: l_rsv_id NUMBER;
6836: l_return_status VARCHAR2(1);
6837: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
6838: l_count NUMBER;
6839: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
6840: l_qty_to_unreserve NUMBER;
6841: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');

Line 6839: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

6835: l_rsv_id NUMBER;
6836: l_return_status VARCHAR2(1);
6837: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
6838: l_count NUMBER;
6839: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
6840: l_qty_to_unreserve NUMBER;
6841: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
6842: l_sales_order_id NUMBER;
6843: l_x_error_code NUMBER;

Line 6877: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD;

6873: -- This is an internal order line. We need to give
6874: -- a different demand source type for these lines.
6875:
6876: l_rsv_rec.demand_source_type_id :=
6877: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD;
6878: -- intenal order
6879:
6880: ELSE
6881:

Line 6883: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- order entry

6879:
6880: ELSE
6881:
6882: l_rsv_rec.demand_source_type_id :=
6883: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- order entry
6884:
6885: END IF;
6886:
6887: -- Get demand_source_header_id from mtl_sales_orders

Line 6909: , p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES

6905: , x_return_status => l_return_status
6906: , x_msg_count => l_msg_count
6907: , x_msg_data => l_msg_data
6908: , p_query_input => l_rsv_rec
6909: , p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES
6910: , x_mtl_reservation_tbl => l_rsv_tbl
6911: , x_mtl_reservation_tbl_count => l_count
6912: , x_error_code => l_x_error_code
6913: , p_lock_records => l_lock_records

Line 8652: l_query_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

8648: l_qty2_to_retain NUMBER;
8649:
8650:
8651: -- Reservation API variables
8652: l_query_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
8653: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
8654: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;
8655: l_msg_count NUMBER;
8656: l_msg_data VARCHAR2(240);

Line 8653: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

8649:
8650:
8651: -- Reservation API variables
8652: l_query_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
8653: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
8654: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;
8655: l_msg_count NUMBER;
8656: l_msg_data VARCHAR2(240);
8657: l_rsv_id NUMBER;

Line 8654: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;

8650:
8651: -- Reservation API variables
8652: l_query_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
8653: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
8654: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;
8655: l_msg_count NUMBER;
8656: l_msg_data VARCHAR2(240);
8657: l_rsv_id NUMBER;
8658: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

Line 8658: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

8654: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;
8655: l_msg_count NUMBER;
8656: l_msg_data VARCHAR2(240);
8657: l_rsv_id NUMBER;
8658: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
8659: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
8660: l_qty_reserved NUMBER;
8661: -- INVCONV
8662: l_qty2_reserved NUMBER;

Line 8659: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

8655: l_msg_count NUMBER;
8656: l_msg_data VARCHAR2(240);
8657: l_rsv_id NUMBER;
8658: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
8659: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
8660: l_qty_reserved NUMBER;
8661: -- INVCONV
8662: l_qty2_reserved NUMBER;
8663:

Line 9395: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

9391: l_x_error_code NUMBER;
9392: l_lock_records VARCHAR2(1);
9393: l_sort_by_req_date NUMBER;
9394:
9395: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
9396: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;
9397: l_msg_count NUMBER;
9398: l_msg_data VARCHAR2(240);
9399: l_rsv_id NUMBER;

Line 9396: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;

9392: l_lock_records VARCHAR2(1);
9393: l_sort_by_req_date NUMBER;
9394:
9395: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
9396: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;
9397: l_msg_count NUMBER;
9398: l_msg_data VARCHAR2(240);
9399: l_rsv_id NUMBER;
9400: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

Line 9400: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

9396: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;
9397: l_msg_count NUMBER;
9398: l_msg_data VARCHAR2(240);
9399: l_rsv_id NUMBER;
9400: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
9401: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
9402:
9403: l_buffer VARCHAR2(2000);
9404: l_ship_from_org_id NUMBER;

Line 9401: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

9397: l_msg_count NUMBER;
9398: l_msg_data VARCHAR2(240);
9399: l_rsv_id NUMBER;
9400: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
9401: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
9402:
9403: l_buffer VARCHAR2(2000);
9404: l_ship_from_org_id NUMBER;
9405:

Line 10282: l_failed_rsv_temp_tbl INV_RESERVATION_GLOBAL.mtl_failed_rsv_tbl_type;

10278: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2) IS
10279: l_return_status VARCHAR2(100);
10280: l_msg_count NUMBER;
10281: l_msg_data VARCHAR2(500);
10282: l_failed_rsv_temp_tbl INV_RESERVATION_GLOBAL.mtl_failed_rsv_tbl_type;
10283: --
10284: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
10285: --
10286: Begin