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 843: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

839:
840: IS
841: l_msg_count NUMBER;
842: l_msg_data VARCHAR2(2000);
843: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
844: l_quantity_reserved NUMBER;
845: l_quantity2_reserved NUMBER; -- INVCONV
846: l_rsv_id NUMBER;
847: l_reservable_type NUMBER;

Line 848: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

844: l_quantity_reserved NUMBER;
845: l_quantity2_reserved NUMBER; -- INVCONV
846: l_rsv_id NUMBER;
847: l_reservable_type NUMBER;
848: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
849: l_buffer VARCHAR2(2000);
850:
851: l_substitute_flag BOOLEAN; -- Added for ER 6110708
852:

Line 1078: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1074: ,p_quantity2_to_unreserve IN NUMBER DEFAULT NULL -- INVCONV
1075: ,x_return_status OUT NOCOPY VARCHAR2)
1076:
1077: IS
1078: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1079: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;
1080: l_msg_count NUMBER;
1081: l_msg_data VARCHAR2(240);
1082: l_rsv_id NUMBER;

Line 1079: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;

1075: ,x_return_status OUT NOCOPY VARCHAR2)
1076:
1077: IS
1078: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1079: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;
1080: l_msg_count NUMBER;
1081: l_msg_data VARCHAR2(240);
1082: l_rsv_id NUMBER;
1083: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

Line 1083: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

1079: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;
1080: l_msg_count NUMBER;
1081: l_msg_data VARCHAR2(240);
1082: l_rsv_id NUMBER;
1083: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1084: l_count NUMBER;
1085: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1086: l_qty_to_unreserve NUMBER;
1087: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');

Line 1085: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

1081: l_msg_data VARCHAR2(240);
1082: l_rsv_id NUMBER;
1083: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
1084: l_count NUMBER;
1085: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
1086: l_qty_to_unreserve NUMBER;
1087: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
1088: l_sales_order_id NUMBER;
1089: l_x_error_code NUMBER;

Line 6994: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;

6990: l_qty2_to_unreserve NUMBER;
6991:
6992:
6993:
6994: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
6995: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
6996: l_sales_order_id NUMBER;
6997: l_x_error_code NUMBER;
6998: l_lock_records VARCHAR2(1);

Line 6995: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

6991:
6992:
6993:
6994: l_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
6995: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
6996: l_sales_order_id NUMBER;
6997: l_x_error_code NUMBER;
6998: l_lock_records VARCHAR2(1);
6999: l_sort_by_req_date NUMBER ;

Line 7003: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

6999: l_sort_by_req_date NUMBER ;
7000: l_count NUMBER;
7001: l_msg_count NUMBER;
7002: l_msg_data VARCHAR2(2000);
7003: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
7004: l_buffer VARCHAR2(2000);
7005: l_rsv_update BOOLEAN :=FALSE;
7006: --
7007: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 7644: We pass the constant INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE

7640: Procedure Name : Load_INV_Request
7641: Description : This procedure loads the INV's record structure which
7642: we will pass to INV for reservation purpose.
7643: We need to pass to INV the idenfier for OM demand.
7644: We pass the constant INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE
7645: for all OM Order Lines except Internal Orders.
7646: For Internal Orders we pass
7647: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD
7648: as the identifier.

Line 7647: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD

7643: We need to pass to INV the idenfier for OM demand.
7644: We pass the constant INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE
7645: for all OM Order Lines except Internal Orders.
7646: For Internal Orders we pass
7647: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD
7648: as the identifier.
7649: ----------------------------------------------------------------------------- */
7650: Procedure Load_INV_Request
7651: ( p_line_rec IN Oe_Order_Pub.Line_Rec_Type

Line 7654: , x_reservation_rec OUT NOCOPY Inv_Reservation_Global.Mtl_Reservation_Rec_Type)

7650: Procedure Load_INV_Request
7651: ( p_line_rec IN Oe_Order_Pub.Line_Rec_Type
7652: , p_quantity_to_reserve IN NUMBER
7653: , p_quantity2_to_reserve IN NUMBER DEFAULT NULL
7654: , x_reservation_rec OUT NOCOPY Inv_Reservation_Global.Mtl_Reservation_Rec_Type)
7655:
7656: IS
7657: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
7658: l_sales_order_id NUMBER;

Line 7682: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD;

7678: -- This is an internal order line. We need to give
7679: -- a different demand sourc2e type for these lines.
7680:
7681: x_reservation_rec.demand_source_type_id :=
7682: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD;
7683: -- intenal order
7684:
7685: ELSE
7686:

Line 7688: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- order entry

7684:
7685: ELSE
7686:
7687: x_reservation_rec.demand_source_type_id :=
7688: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- order entry
7689:
7690: END IF;
7691:
7692:

Line 7712: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INV;

7708: x_reservation_rec.demand_source_line_id := p_line_rec.line_id;
7709: x_reservation_rec.reservation_uom_code := p_line_rec.order_quantity_uom;
7710: x_reservation_rec.reservation_quantity := p_quantity_to_reserve;
7711: x_reservation_rec.supply_source_type_id :=
7712: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INV;
7713: x_reservation_rec.subinventory_code := l_subinventory;
7714: /* OPM 02/JUN/00 send process attributes into the reservation -- INVCONV - no longer using attributes
7715: =============================================================
7716: x_reservation_rec.attribute1 := p_line_rec.preferred_grade;

Line 12836: ( p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

12832: Description : This API calls Inventory's APIs to Transfer_reservation.
12833: --------------------------------------------------------------------- */
12834:
12835: Procedure Transfer_reservation
12836: ( p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type
12837: ,p_quantity_to_transfer IN NUMBER
12838: ,p_quantity2_to_transfer IN NUMBER DEFAULT 0
12839: ,p_line_to_transfer IN NUMBER
12840: ,x_return_status OUT NOCOPY VARCHAR2)

Line 12843: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

12839: ,p_line_to_transfer IN NUMBER
12840: ,x_return_status OUT NOCOPY VARCHAR2)
12841:
12842: IS
12843: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
12844: l_msg_count NUMBER;
12845: l_msg_data VARCHAR2(240);
12846: l_rsv_id NUMBER;
12847: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

Line 12847: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

12843: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
12844: l_msg_count NUMBER;
12845: l_msg_data VARCHAR2(240);
12846: l_rsv_id NUMBER;
12847: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
12848: l_buffer VARCHAR2(2000);
12849:
12850: --
12851: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 13321: l_query_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

13317: K NUMBER;
13318: J NUMBER;
13319: l_reserved_quantity NUMBER;
13320: l_msg_count NUMBER;
13321: l_query_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
13322: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
13323: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
13324: l_msg_data VARCHAR2(240);
13325: l_count NUMBER;

Line 13322: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

13318: J NUMBER;
13319: l_reserved_quantity NUMBER;
13320: l_msg_count NUMBER;
13321: l_query_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
13322: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
13323: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
13324: l_msg_data VARCHAR2(240);
13325: l_count NUMBER;
13326: l_available_qty NUMBER := 0;

Line 13323: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

13319: l_reserved_quantity NUMBER;
13320: l_msg_count NUMBER;
13321: l_query_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
13322: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
13323: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
13324: l_msg_data VARCHAR2(240);
13325: l_count NUMBER;
13326: l_available_qty NUMBER := 0;
13327: --- 2346233 --

Line 14188: l_failed_rsv_temp_tbl INV_RESERVATION_GLOBAL.mtl_failed_rsv_tbl_type;

14184:
14185: l_return_status VARCHAR2(100);
14186: l_msg_count NUMBER;
14187: l_msg_data VARCHAR2(500);
14188: l_failed_rsv_temp_tbl INV_RESERVATION_GLOBAL.mtl_failed_rsv_tbl_type;
14189: --
14190: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
14191: --
14192: Begin

Line 14489: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

14485: ,p_quantity2_to_unreserve IN NUMBER -- INVCONV
14486: ,p_old_ship_from_org_id IN NUMBER DEFAULT NULL -- 5024936
14487: ,x_return_status OUT NOCOPY VARCHAR2)
14488: IS
14489: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
14490: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;
14491: l_msg_count NUMBER;
14492: l_msg_data VARCHAR2(240);
14493: l_rsv_id NUMBER;

Line 14490: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;

14486: ,p_old_ship_from_org_id IN NUMBER DEFAULT NULL -- 5024936
14487: ,x_return_status OUT NOCOPY VARCHAR2)
14488: IS
14489: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
14490: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;
14491: l_msg_count NUMBER;
14492: l_msg_data VARCHAR2(240);
14493: l_rsv_id NUMBER;
14494: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

Line 14494: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

14490: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;
14491: l_msg_count NUMBER;
14492: l_msg_data VARCHAR2(240);
14493: l_rsv_id NUMBER;
14494: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
14495: l_count NUMBER;
14496: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
14497: l_qty_to_unreserve NUMBER;
14498: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');

Line 14496: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

14492: l_msg_data VARCHAR2(240);
14493: l_rsv_id NUMBER;
14494: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
14495: l_count NUMBER;
14496: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
14497: l_qty_to_unreserve NUMBER;
14498: l_source_code VARCHAR2(40) := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
14499: l_sales_order_id NUMBER;
14500: l_x_error_code NUMBER;

Line 14533: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD;

14529: -- This is an internal order line. We need to give
14530: -- a different demand source type for these lines.
14531:
14532: l_rsv_rec.demand_source_type_id :=
14533: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD;
14534: -- intenal order
14535: ELSE
14536: l_rsv_rec.demand_source_type_id :=
14537: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE;

Line 14537: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE;

14533: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD;
14534: -- intenal order
14535: ELSE
14536: l_rsv_rec.demand_source_type_id :=
14537: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE;
14538: -- order entry
14539: END IF;
14540:
14541:

Line 14567: , p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES

14563: inv_reservation_pub.query_reservation
14564: ( p_api_version_number => 1.0
14565: , p_init_msg_lst => fnd_api.g_true
14566: , p_query_input => l_rsv_rec
14567: , p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES
14568: , p_lock_records => l_lock_records
14569: , p_sort_by_req_date => l_sort_by_req_date
14570: , x_mtl_reservation_tbl => l_rsv_tbl
14571: , x_mtl_reservation_tbl_count => l_count