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.JAI_RCV_RGM_CLAIMS_PKG dependencies on HR_LOCATIONS_ALL

Line 13: p_location_id OUT NOCOPY hr_locations_all.location_id%TYPE,

9: CORRECT_RTV CONSTANT VARCHAR2(30) := 'CORRECT-RTV';
10:
11: PROCEDURE get_location(
12: p_transaction_id IN rcv_transactions.transaction_id%TYPE,
13: p_location_id OUT NOCOPY hr_locations_all.location_id%TYPE,
14: p_process_status OUT NOCOPY VARCHAR2,
15: p_process_message OUT NOCOPY VARCHAR2)
16: IS
17: CURSOR c_dlry_subinventory(cp_shipment_line_id IN NUMBER,

Line 39: FROM hr_locations_all

35:
36: CURSOR c_inv_org_linked_to_location(cp_location_id IN NUMBER)
37: IS
38: SELECT nvl(inventory_organization_id, -99999) inventory_organization_id
39: FROM hr_locations_all
40: WHERE location_id = cp_location_id;
41:
42: r_trx c_trx%ROWTYPE;
43: r_parent_trx c_trx%ROWTYPE;

Line 1747: p_location_id IN hr_locations_all.location_id%TYPE DEFAULT NULL,

1743: PROCEDURE process_claim(
1744: p_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE,
1745: p_regime_regno IN VARCHAR2 DEFAULT NULL,
1746: p_organization_id IN hr_all_organization_units.organization_id%TYPE DEFAULT NULL,
1747: p_location_id IN hr_locations_all.location_id%TYPE DEFAULT NULL,
1748: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
1749: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
1750: p_batch_id IN JAI_RCV_RGM_LINES.BATCH_NUM%TYPE DEFAULT NULL,
1751: p_force IN VARCHAR2 DEFAULT NULL,

Line 2255: p_location_id IN hr_locations_all.location_id%TYPE DEFAULT NULL,

2251: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
2252: p_batch_id IN jai_rcv_rgm_lines.batch_num%TYPE DEFAULT NULL,
2253: p_regime_regno IN VARCHAR2 DEFAULT NULL,
2254: p_organization_id IN hr_all_organization_units.organization_id%TYPE DEFAULT NULL,
2255: p_location_id IN hr_locations_all.location_id%TYPE DEFAULT NULL,
2256: p_process_status OUT NOCOPY VARCHAR2,
2257: p_process_message OUT NOCOPY VARCHAR2,
2258: p_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE DEFAULT NULL )
2259: IS

Line 2679: p_location_id IN hr_locations_all.location_id%TYPE DEFAULT NULL,

2675: retcode OUT NOCOPY VARCHAR2,
2676: p_regime_id IN JAI_RGM_DEFINITIONS.regime_id%TYPE,
2677: p_regime_regno IN VARCHAR2 DEFAULT NULL,
2678: p_organization_id IN hr_all_organization_units.organization_id%TYPE DEFAULT NULL,
2679: p_location_id IN hr_locations_all.location_id%TYPE DEFAULT NULL,
2680: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
2681: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
2682: p_batch_id IN JAI_RCV_RGM_LINES.BATCH_NUM%TYPE DEFAULT NULL,
2683: p_force IN VARCHAR2 DEFAULT NULL,