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_SCHEDULE_UTIL dependencies on INV_RESERVATION_GLOBAL

Line 868: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

864:
865: IS
866: l_msg_count NUMBER;
867: l_msg_data VARCHAR2(2000);
868: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
869: l_quantity_reserved NUMBER;
870: l_quantity2_reserved NUMBER; -- INVCONV
871: l_rsv_id NUMBER;
872: l_reservable_type NUMBER;

Line 873: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

869: l_quantity_reserved NUMBER;
870: l_quantity2_reserved NUMBER; -- INVCONV
871: l_rsv_id NUMBER;
872: l_reservable_type NUMBER;
873: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
874: l_buffer VARCHAR2(2000);
875:
876: l_substitute_flag BOOLEAN; -- Added for ER 6110708
877:

Line 1125: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1121: ,p_quantity2_to_unreserve IN NUMBER DEFAULT NULL -- INVCONV
1122: ,x_return_status OUT NOCOPY VARCHAR2)
1123:
1124: IS
1125: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1126: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;
1127: l_msg_count NUMBER;
1128: l_msg_data VARCHAR2(240);
1129: l_rsv_id NUMBER;

Line 1126: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;

1122: ,x_return_status OUT NOCOPY VARCHAR2)
1123:
1124: IS
1125: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1126: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;
1127: l_msg_count NUMBER;
1128: l_msg_data VARCHAR2(240);
1129: l_rsv_id NUMBER;
1130: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

Line 1130: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

1126: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;
1127: l_msg_count NUMBER;
1128: l_msg_data VARCHAR2(240);
1129: l_rsv_id NUMBER;
1130: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1131: l_count NUMBER;
1132: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1133: l_qty_to_unreserve NUMBER;
1134: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');

Line 1132: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

1128: l_msg_data VARCHAR2(240);
1129: l_rsv_id NUMBER;
1130: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1131: l_count NUMBER;
1132: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1133: l_qty_to_unreserve NUMBER;
1134: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
1135: l_sales_order_id NUMBER;
1136: l_x_error_code NUMBER;

Line 8282: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

8278: l_qty2_to_unreserve NUMBER;
8279:
8280:
8281:
8282: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
8283: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
8284: l_sales_order_id NUMBER;
8285: l_x_error_code NUMBER;
8286: l_lock_records VARCHAR2(1);

Line 8283: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

8279:
8280:
8281:
8282: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
8283: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
8284: l_sales_order_id NUMBER;
8285: l_x_error_code NUMBER;
8286: l_lock_records VARCHAR2(1);
8287: l_sort_by_req_date NUMBER ;

Line 8291: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

8287: l_sort_by_req_date NUMBER ;
8288: l_count NUMBER;
8289: l_msg_count NUMBER;
8290: l_msg_data VARCHAR2(2000);
8291: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
8292: l_buffer VARCHAR2(2000);
8293: l_rsv_update BOOLEAN :=FALSE;
8294: --
8295: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 8986: We pass the constant INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE

8982: Procedure Name : Load_INV_Request
8983: Description : This procedure loads the INV's record structure which
8984: we will pass to INV for reservation purpose.
8985: We need to pass to INV the idenfier for OM demand.
8986: We pass the constant INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE
8987: for all OM Order Lines except Internal Orders.
8988: For Internal Orders we pass
8989: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD
8990: as the identifier.

Line 8989: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD

8985: We need to pass to INV the idenfier for OM demand.
8986: We pass the constant INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE
8987: for all OM Order Lines except Internal Orders.
8988: For Internal Orders we pass
8989: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD
8990: as the identifier.
8991: ----------------------------------------------------------------------------- */
8992: Procedure Load_INV_Request
8993: ( p_line_rec IN Oe_Order_Pub.Line_Rec_Type

Line 8996: , x_reservation_rec OUT NOCOPY Inv_Reservation_Global.Mtl_Reservation_Rec_Type)

8992: Procedure Load_INV_Request
8993: ( p_line_rec IN Oe_Order_Pub.Line_Rec_Type
8994: , p_quantity_to_reserve IN NUMBER
8995: , p_quantity2_to_reserve IN NUMBER DEFAULT NULL
8996: , x_reservation_rec OUT NOCOPY Inv_Reservation_Global.Mtl_Reservation_Rec_Type)
8997:
8998: IS
8999: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
9000: l_sales_order_id NUMBER;

Line 9024: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD;

9020: -- This is an internal order line. We need to give
9021: -- a different demand sourc2e type for these lines.
9022:
9023: x_reservation_rec.demand_source_type_id :=
9024: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD;
9025: -- intenal order
9026:
9027: ELSE
9028:

Line 9030: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- order entry

9026:
9027: ELSE
9028:
9029: x_reservation_rec.demand_source_type_id :=
9030: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- order entry
9031:
9032: END IF;
9033:
9034:

Line 9054: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INV;

9050: x_reservation_rec.demand_source_line_id := p_line_rec.line_id;
9051: x_reservation_rec.reservation_uom_code := p_line_rec.order_quantity_uom;
9052: x_reservation_rec.reservation_quantity := p_quantity_to_reserve;
9053: x_reservation_rec.supply_source_type_id :=
9054: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INV;
9055: x_reservation_rec.subinventory_code := l_subinventory;
9056: /* OPM 02/JUN/00 send process attributes into the reservation -- INVCONV - no longer using attributes
9057: =============================================================
9058: x_reservation_rec.attribute1 := p_line_rec.preferred_grade;

Line 14679: ( p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

14675: Description : This API calls Inventory's APIs to Transfer_reservation.
14676: --------------------------------------------------------------------- */
14677:
14678: Procedure Transfer_reservation
14679: ( p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
14680: ,p_quantity_to_transfer IN NUMBER
14681: ,p_quantity2_to_transfer IN NUMBER DEFAULT 0
14682: ,p_line_to_transfer IN NUMBER
14683: ,x_return_status OUT NOCOPY VARCHAR2)

Line 14686: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

14682: ,p_line_to_transfer IN NUMBER
14683: ,x_return_status OUT NOCOPY VARCHAR2)
14684:
14685: IS
14686: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
14687: l_msg_count NUMBER;
14688: l_msg_data VARCHAR2(240);
14689: l_rsv_id NUMBER;
14690: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

Line 14690: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

14686: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
14687: l_msg_count NUMBER;
14688: l_msg_data VARCHAR2(240);
14689: l_rsv_id NUMBER;
14690: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
14691: l_buffer VARCHAR2(2000);
14692:
14693: --
14694: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 15627: l_query_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

15623: K NUMBER;
15624: J NUMBER;
15625: l_reserved_quantity NUMBER;
15626: l_msg_count NUMBER;
15627: l_query_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
15628: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
15629: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
15630: l_msg_data VARCHAR2(240);
15631: l_count NUMBER;

Line 15628: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

15624: J NUMBER;
15625: l_reserved_quantity NUMBER;
15626: l_msg_count NUMBER;
15627: l_query_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
15628: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
15629: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
15630: l_msg_data VARCHAR2(240);
15631: l_count NUMBER;
15632: l_available_qty NUMBER := 0;

Line 15629: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

15625: l_reserved_quantity NUMBER;
15626: l_msg_count NUMBER;
15627: l_query_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
15628: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
15629: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
15630: l_msg_data VARCHAR2(240);
15631: l_count NUMBER;
15632: l_available_qty NUMBER := 0;
15633: --- 2346233 --

Line 16663: l_failed_rsv_temp_tbl INV_RESERVATION_GLOBAL.mtl_failed_rsv_tbl_type;

16659:
16660: l_return_status VARCHAR2(100);
16661: l_msg_count NUMBER;
16662: l_msg_data VARCHAR2(500);
16663: l_failed_rsv_temp_tbl INV_RESERVATION_GLOBAL.mtl_failed_rsv_tbl_type;
16664: --
16665: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
16666: --
16667: Begin

Line 16964: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

16960: ,p_quantity2_to_unreserve IN NUMBER -- INVCONV
16961: ,p_old_ship_from_org_id IN NUMBER DEFAULT NULL -- 5024936
16962: ,x_return_status OUT NOCOPY VARCHAR2)
16963: IS
16964: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
16965: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;
16966: l_msg_count NUMBER;
16967: l_msg_data VARCHAR2(240);
16968: l_rsv_id NUMBER;

Line 16965: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;

16961: ,p_old_ship_from_org_id IN NUMBER DEFAULT NULL -- 5024936
16962: ,x_return_status OUT NOCOPY VARCHAR2)
16963: IS
16964: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
16965: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;
16966: l_msg_count NUMBER;
16967: l_msg_data VARCHAR2(240);
16968: l_rsv_id NUMBER;
16969: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

Line 16969: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

16965: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;
16966: l_msg_count NUMBER;
16967: l_msg_data VARCHAR2(240);
16968: l_rsv_id NUMBER;
16969: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
16970: l_count NUMBER;
16971: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
16972: l_qty_to_unreserve NUMBER;
16973: l_qty2_to_unreserve NUMBER := p_quantity2_to_unreserve; --ER#14763609

Line 16971: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

16967: l_msg_data VARCHAR2(240);
16968: l_rsv_id NUMBER;
16969: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
16970: l_count NUMBER;
16971: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
16972: l_qty_to_unreserve NUMBER;
16973: l_qty2_to_unreserve NUMBER := p_quantity2_to_unreserve; --ER#14763609
16974: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
16975: l_sales_order_id NUMBER;

Line 17020: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD;

17016: -- This is an internal order line. We need to give
17017: -- a different demand source type for these lines.
17018:
17019: l_rsv_rec.demand_source_type_id :=
17020: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD;
17021: -- intenal order
17022: ELSE
17023: l_rsv_rec.demand_source_type_id :=
17024: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE;

Line 17024: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE;

17020: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD;
17021: -- intenal order
17022: ELSE
17023: l_rsv_rec.demand_source_type_id :=
17024: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE;
17025: -- order entry
17026: END IF;
17027:
17028:

Line 17054: , p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES

17050: inv_reservation_pub.query_reservation
17051: ( p_api_version_number => 1.0
17052: , p_init_msg_lst => fnd_api.g_true
17053: , p_query_input => l_rsv_rec
17054: , p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES
17055: , p_lock_records => l_lock_records
17056: , p_sort_by_req_date => l_sort_by_req_date
17057: , x_mtl_reservation_tbl => l_rsv_tbl
17058: , x_mtl_reservation_tbl_count => l_count

Line 18762: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

18758: IS
18759: l_return_status VARCHAR2(1);
18760: l_msg_count NUMBER;
18761: l_msg_data VARCHAR2(2000);
18762: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
18763: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
18764: l_count NUMBER;
18765: l_x_error_code NUMBER;
18766: l_lock_records VARCHAR2(1);

Line 18763: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

18759: l_return_status VARCHAR2(1);
18760: l_msg_count NUMBER;
18761: l_msg_data VARCHAR2(2000);
18762: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
18763: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
18764: l_count NUMBER;
18765: l_x_error_code NUMBER;
18766: l_lock_records VARCHAR2(1);
18767: l_sort_by_req_date NUMBER;