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

Line 49: , p_Serial_Number_Tbl In Inv_Reservation_Global.Serial_Number_Tbl_Type

45: , p_pick_slip_number IN NUMBER
46: , p_lpn_id IN NUMBER
47: , p_project_id IN NUMBER Default NULL
48: , p_task_id IN NUMBER Default NULL
49: , p_Serial_Number_Tbl In Inv_Reservation_Global.Serial_Number_Tbl_Type
50: , p_ship_ready_flag IN NUMBER
51: , p_CrossDock_Flag In Varchar2 Default null
52: , p_attribute_category IN VARCHAR2 DEFAULT NULL
53: , p_attribute1 IN VARCHAR2 DEFAULT NULL

Line 78: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

74: ) IS
75: l_api_version_number CONSTANT NUMBER := 1.0;
76: l_api_name CONSTANT VARCHAR2(30) := 'Create_Reservation';
77: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
78: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
79: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;
80: BEGIN
81: -- Standard call to check for call compatibility
82: IF NOT fnd_api.compatible_api_call(l_api_version_number

Line 79: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;

75: l_api_version_number CONSTANT NUMBER := 1.0;
76: l_api_name CONSTANT VARCHAR2(30) := 'Create_Reservation';
77: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
78: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
79: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;
80: BEGIN
81: -- Standard call to check for call compatibility
82: IF NOT fnd_api.compatible_api_call(l_api_version_number
83: , p_api_version_number

Line 284: l_Dummy_Serial_Number_Tbl Inv_Reservation_Global.Serial_Number_Tbl_Type ;

280: l_api_version_number CONSTANT NUMBER := 1.0;
281: l_api_name CONSTANT VARCHAR2(30) := 'Create_Reservation';
282: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
283: l_secondary_quantity_reserved NUMBER;
284: l_Dummy_Serial_Number_Tbl Inv_Reservation_Global.Serial_Number_Tbl_Type ;
285:
286: BEGIN
287: -- Standard call to check for call compatibility
288: IF NOT fnd_api.compatible_api_call(l_api_version_number

Line 471: , p_From_Serial_Number_Tbl In Inv_Reservation_Global.Serial_Number_Tbl_Type

467: , p_from_pick_slip_number IN NUMBER
468: , p_from_lpn_id IN NUMBER
469: , p_from_project_id IN NUMBER Default Null
470: , p_from_task_id IN NUMBER Default Null
471: , p_From_Serial_Number_Tbl In Inv_Reservation_Global.Serial_Number_Tbl_Type
472: , p_from_ship_ready_flag IN NUMBER
473: , p_From_CrossDock_Flag In Varchar2 Default Null
474: , p_from_attribute_category IN VARCHAR2 DEFAULT NULL
475: , p_from_attribute1 IN VARCHAR2 DEFAULT NULL

Line 519: , p_To_Serial_Number_Tbl In Inv_Reservation_Global.Serial_Number_Tbl_Type

515: , p_to_pick_slip_number IN NUMBER
516: , p_to_lpn_id IN NUMBER
517: , p_to_project_id IN NUMBER Default Null
518: , p_to_task_id IN NUMBER Default Null
519: , p_To_Serial_Number_Tbl In Inv_Reservation_Global.Serial_Number_Tbl_Type
520: , p_to_ship_ready_flag IN NUMBER
521: , p_To_CrossDock_Flag In Varchar2 Default Null
522: , p_to_attribute_category IN VARCHAR2 DEFAULT NULL
523: , p_to_attribute1 IN VARCHAR2 DEFAULT NULL

Line 543: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

539: ) IS
540: l_api_version_number CONSTANT NUMBER := 1.0;
541: l_api_name CONSTANT VARCHAR2(30) := 'Update_Reservation';
542: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
543: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
544: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
545: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;
546: BEGIN
547:

Line 544: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

540: l_api_version_number CONSTANT NUMBER := 1.0;
541: l_api_name CONSTANT VARCHAR2(30) := 'Update_Reservation';
542: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
543: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
544: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
545: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;
546: BEGIN
547:
548: -- Standard call to check for call compatibility

Line 545: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;

541: l_api_name CONSTANT VARCHAR2(30) := 'Update_Reservation';
542: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
543: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
544: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
545: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;
546: BEGIN
547:
548: -- Standard call to check for call compatibility
549: IF NOT fnd_api.compatible_api_call(l_api_version_number

Line 788: , p_Serial_Number_Tbl In Inv_Reservation_Global.Serial_Number_Tbl_Type

784: , p_lot_number IN VARCHAR2
785: , p_lot_number_id IN NUMBER
786: , p_pick_slip_number IN NUMBER
787: , p_lpn_id IN NUMBER
788: , p_Serial_Number_Tbl In Inv_Reservation_Global.Serial_Number_Tbl_Type
789: , p_ship_ready_flag IN NUMBER
790: , p_CrossDock_Flag In Varchar2 Default Null
791: , p_attribute_category IN VARCHAR2 DEFAULT NULL
792: , p_attribute1 IN VARCHAR2 DEFAULT NULL

Line 812: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

808: ) IS
809: l_api_version_number CONSTANT NUMBER := 1.0;
810: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Reservation';
811: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
812: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
813: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;
814: BEGIN
815: -- Standard call to check for call compatibility
816: IF NOT fnd_api.compatible_api_call(l_api_version_number

Line 813: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;

809: l_api_version_number CONSTANT NUMBER := 1.0;
810: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Reservation';
811: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
812: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
813: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;
814: BEGIN
815: -- Standard call to check for call compatibility
816: IF NOT fnd_api.compatible_api_call(l_api_version_number
817: , p_api_version_number

Line 1028: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1024: ) IS
1025: l_api_version_number CONSTANT NUMBER := 1.0;
1026: l_api_name CONSTANT VARCHAR2(30) := 'Transfer_Supply';
1027: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1028: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1029: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1030: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;
1031: BEGIN
1032:

Line 1029: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1025: l_api_version_number CONSTANT NUMBER := 1.0;
1026: l_api_name CONSTANT VARCHAR2(30) := 'Transfer_Supply';
1027: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1028: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1029: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1030: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;
1031: BEGIN
1032:
1033: -- Standard call to check for call compatibility

Line 1030: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;

1026: l_api_name CONSTANT VARCHAR2(30) := 'Transfer_Supply';
1027: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1028: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1029: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1030: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;
1031: BEGIN
1032:
1033: -- Standard call to check for call compatibility
1034: IF NOT fnd_api.compatible_api_call(l_api_version_number

Line 1269: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1265: ) IS
1266: l_api_version_number CONSTANT NUMBER := 1.0;
1267: l_api_name CONSTANT VARCHAR2(30) := 'Transfer_Demand';
1268: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1269: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1270: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1271: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;
1272: l_fulfill_base VARCHAR2(1) := 'P';
1273: BEGIN

Line 1270: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1266: l_api_version_number CONSTANT NUMBER := 1.0;
1267: l_api_name CONSTANT VARCHAR2(30) := 'Transfer_Demand';
1268: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1269: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1270: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1271: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;
1272: l_fulfill_base VARCHAR2(1) := 'P';
1273: BEGIN
1274:

Line 1271: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;

1267: l_api_name CONSTANT VARCHAR2(30) := 'Transfer_Demand';
1268: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1269: l_orig_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1270: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1271: l_dummy_serial_number inv_reservation_global.serial_number_tbl_type;
1272: l_fulfill_base VARCHAR2(1) := 'P';
1273: BEGIN
1274:
1275: -- Standard call to check for call compatibility

Line 1453: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type

1449: , p_lock_records IN VARCHAR2 DEFAULT fnd_api.g_false
1450: , p_sort_by_req_date IN NUMBER
1451: , p_cancel_order_mode IN NUMBER
1452: , x_mtl_reservation_tbl
1453: OUT NOCOPY inv_reservation_global.mtl_reservation_tbl_type
1454: , x_mtl_reservation_tbl_count OUT NOCOPY NUMBER
1455: , x_error_code OUT NOCOPY NUMBER
1456: ) IS
1457: l_api_version_number CONSTANT NUMBER := 1.0;

Line 1460: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1456: ) IS
1457: l_api_version_number CONSTANT NUMBER := 1.0;
1458: l_api_name CONSTANT VARCHAR2(30) := 'Query_Reservation';
1459: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1460: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1461: BEGIN
1462: -- Standard call to check for call compatibility
1463: IF NOT fnd_api.compatible_api_call(l_api_version_number
1464: , p_api_version_number

Line 1599: if p_demand_type_id in (inv_reservation_global.g_source_type_oe,

1595: IF fnd_api.to_boolean(p_init_msg_lst) THEN
1596: fnd_msg_pub.initialize;
1597: END IF;
1598:
1599: if p_demand_type_id in (inv_reservation_global.g_source_type_oe,
1600: inv_reservation_global.g_source_type_internal_ord,
1601: inv_reservation_global.g_source_type_rma) then
1602:
1603: -- Fetch row from oe_order_lines

Line 1600: inv_reservation_global.g_source_type_internal_ord,

1596: fnd_msg_pub.initialize;
1597: END IF;
1598:
1599: if p_demand_type_id in (inv_reservation_global.g_source_type_oe,
1600: inv_reservation_global.g_source_type_internal_ord,
1601: inv_reservation_global.g_source_type_rma) then
1602:
1603: -- Fetch row from oe_order_lines
1604: --l_line_rec := OE_Line_Util.Query_Row(p_line_id => p_demand_line_id);

Line 1601: inv_reservation_global.g_source_type_rma) then

1597: END IF;
1598:
1599: if p_demand_type_id in (inv_reservation_global.g_source_type_oe,
1600: inv_reservation_global.g_source_type_internal_ord,
1601: inv_reservation_global.g_source_type_rma) then
1602:
1603: -- Fetch row from oe_order_lines
1604: --l_line_rec := OE_Line_Util.Query_Row(p_line_id => p_demand_line_id);
1605: -- Because oe_lines_util.query_row was changed to private, so we need to