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

Line 118: l_query_rec inv_reservation_global.mtl_reservation_rec_type;

114: l_increase_secondary NUMBER; -- INVCONV
115: l_return_status VARCHAR2(1);
116: l_msg_count NUMBER;
117: l_msg_data VARCHAR2(240);
118: l_query_rec inv_reservation_global.mtl_reservation_rec_type;
119: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
120: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
121: l_rsv_count NUMBER;
122: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

Line 119: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

115: l_return_status VARCHAR2(1);
116: l_msg_count NUMBER;
117: l_msg_data VARCHAR2(240);
118: l_query_rec inv_reservation_global.mtl_reservation_rec_type;
119: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
120: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
121: l_rsv_count NUMBER;
122: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
123: l_error_code NUMBER;

Line 120: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

116: l_msg_count NUMBER;
117: l_msg_data VARCHAR2(240);
118: l_query_rec inv_reservation_global.mtl_reservation_rec_type;
119: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
120: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
121: l_rsv_count NUMBER;
122: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
123: l_error_code NUMBER;
124: l_primary_uom_code VARCHAR2(3);

Line 122: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

118: l_query_rec inv_reservation_global.mtl_reservation_rec_type;
119: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
120: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
121: l_rsv_count NUMBER;
122: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
123: l_error_code NUMBER;
124: l_primary_uom_code VARCHAR2(3);
125: l_secondary_uom_code VARCHAR2(3); -- INVCONV
126: l_tracking_quantity_ind VARCHAR2(30); -- INVCONV

Line 702: l_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;

698: l_rsv_rec.reservation_quantity := l_quantity;
699: l_rsv_rec.autodetail_group_id := NULL;
700: l_rsv_rec.external_source_code := NULL;
701: l_rsv_rec.external_source_line_id := NULL;
702: l_rsv_rec.supply_source_type_id := inv_reservation_global.g_source_type_inv;
703: l_rsv_rec.supply_source_header_id := NULL;
704: l_rsv_rec.supply_source_line_id := NULL;
705: l_rsv_rec.supply_source_name := NULL;
706: l_rsv_rec.supply_source_line_detail := NULL;

Line 858: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

854: AND mr.lpn_id=p_lpn_id
855: AND mr.reservation_id=v_reservation_id
856: AND (msn.lpn_id IS NULL OR msn.lpn_id = p_lpn_id); -- lpn may be unpack...
857:
858: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
859: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
860: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
861: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
862: l_mtl_reservation_tbl_count NUMBER;

Line 859: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

855: AND mr.reservation_id=v_reservation_id
856: AND (msn.lpn_id IS NULL OR msn.lpn_id = p_lpn_id); -- lpn may be unpack...
857:
858: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
859: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
860: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
861: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
862: l_mtl_reservation_tbl_count NUMBER;
863: l_error_code NUMBER;

Line 860: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

856: AND (msn.lpn_id IS NULL OR msn.lpn_id = p_lpn_id); -- lpn may be unpack...
857:
858: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
859: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
860: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
861: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
862: l_mtl_reservation_tbl_count NUMBER;
863: l_error_code NUMBER;
864:

Line 861: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

857:
858: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
859: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
860: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
861: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
862: l_mtl_reservation_tbl_count NUMBER;
863: l_error_code NUMBER;
864:
865: BEGIN

Line 1091: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;

1087: AND mr.lpn_id=p_lpn_id
1088: AND mr.reservation_id=v_reservation_id
1089: AND (msn.lpn_id IS NULL OR msn.lpn_id = p_lpn_id); -- lpn may be unpack...
1090:
1091: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1092: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1093: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1094: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
1095: l_mtl_reservation_tbl_count NUMBER;

Line 1092: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1088: AND mr.reservation_id=v_reservation_id
1089: AND (msn.lpn_id IS NULL OR msn.lpn_id = p_lpn_id); -- lpn may be unpack...
1090:
1091: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1092: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1093: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1094: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
1095: l_mtl_reservation_tbl_count NUMBER;
1096: l_error_code NUMBER;

Line 1093: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

1089: AND (msn.lpn_id IS NULL OR msn.lpn_id = p_lpn_id); -- lpn may be unpack...
1090:
1091: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1092: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1093: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1094: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
1095: l_mtl_reservation_tbl_count NUMBER;
1096: l_error_code NUMBER;
1097:

Line 1094: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;

1090:
1091: l_serial_number_tbl inv_reservation_global.serial_number_tbl_type;
1092: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1093: l_to_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
1094: l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
1095: l_mtl_reservation_tbl_count NUMBER;
1096: l_error_code NUMBER;
1097:
1098: