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

Line 1332: l_qry_res_rec INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;

1328: l_insp_status NUMBER;
1329: l_status NUMBER;
1330:
1331: /* New vars needed for deleting reservations*/
1332: l_qry_res_rec INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
1333: l_res_rec_to_delete INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
1334: l_src_doc_code VARCHAR2(10);
1335: l_dem_src_type_id NUMBER;
1336: l_mtl_reservation_tbl INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;

Line 1333: l_res_rec_to_delete INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;

1329: l_status NUMBER;
1330:
1331: /* New vars needed for deleting reservations*/
1332: l_qry_res_rec INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
1333: l_res_rec_to_delete INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
1334: l_src_doc_code VARCHAR2(10);
1335: l_dem_src_type_id NUMBER;
1336: l_mtl_reservation_tbl INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;
1337: l_mtl_reservation_tbl_count NUMBER;

Line 1336: l_mtl_reservation_tbl INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;

1332: l_qry_res_rec INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
1333: l_res_rec_to_delete INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
1334: l_src_doc_code VARCHAR2(10);
1335: l_dem_src_type_id NUMBER;
1336: l_mtl_reservation_tbl INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;
1337: l_mtl_reservation_tbl_count NUMBER;
1338: l_dummy_sn INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE;
1339: l_error_code NUMBER;
1340: l_res_lpn_id NUMBER;

Line 1338: l_dummy_sn INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE;

1334: l_src_doc_code VARCHAR2(10);
1335: l_dem_src_type_id NUMBER;
1336: l_mtl_reservation_tbl INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;
1337: l_mtl_reservation_tbl_count NUMBER;
1338: l_dummy_sn INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE;
1339: l_error_code NUMBER;
1340: l_res_lpn_id NUMBER;
1341: l_unreserve_qty NUMBER;
1342: l_express_return VARCHAR2(1);

Line 3270: l_reservation_record INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;

3266: ) IS
3267:
3268: /* Reservation Data Structures */
3269: l_mtl_reservation_tbl_count NUMBER;
3270: l_reservation_record INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
3271: l_qry_reservation_record INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
3272: l_upd_reservation_record INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
3273: l_upd_reservation_tbl INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;
3274: l_upd_reservation_tbl_cnt NUMBER := 0;

Line 3271: l_qry_reservation_record INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;

3267:
3268: /* Reservation Data Structures */
3269: l_mtl_reservation_tbl_count NUMBER;
3270: l_reservation_record INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
3271: l_qry_reservation_record INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
3272: l_upd_reservation_record INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
3273: l_upd_reservation_tbl INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;
3274: l_upd_reservation_tbl_cnt NUMBER := 0;
3275: l_dummy_sn INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE;

Line 3272: l_upd_reservation_record INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;

3268: /* Reservation Data Structures */
3269: l_mtl_reservation_tbl_count NUMBER;
3270: l_reservation_record INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
3271: l_qry_reservation_record INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
3272: l_upd_reservation_record INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
3273: l_upd_reservation_tbl INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;
3274: l_upd_reservation_tbl_cnt NUMBER := 0;
3275: l_dummy_sn INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE;
3276: l_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE; --Lot Number

Line 3273: l_upd_reservation_tbl INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;

3269: l_mtl_reservation_tbl_count NUMBER;
3270: l_reservation_record INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
3271: l_qry_reservation_record INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
3272: l_upd_reservation_record INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
3273: l_upd_reservation_tbl INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;
3274: l_upd_reservation_tbl_cnt NUMBER := 0;
3275: l_dummy_sn INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE;
3276: l_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE; --Lot Number
3277: l_uom_code VARCHAR2(3); --UOM Code

Line 3275: l_dummy_sn INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE;

3271: l_qry_reservation_record INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
3272: l_upd_reservation_record INV_RESERVATION_GLOBAL.MTL_RESERVATION_REC_TYPE;
3273: l_upd_reservation_tbl INV_RESERVATION_GLOBAL.MTL_RESERVATION_TBL_TYPE;
3274: l_upd_reservation_tbl_cnt NUMBER := 0;
3275: l_dummy_sn INV_RESERVATION_GLOBAL.SERIAL_NUMBER_TBL_TYPE;
3276: l_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE; --Lot Number
3277: l_uom_code VARCHAR2(3); --UOM Code
3278: l_quantity_reserved NUMBER; --Quantity that was reserved
3279: l_reservation_id NUMBER; --Reservation Id