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.PON_OA_UTIL_PKG dependencies on HR_LOCATIONS

Line 1331: v_address_name hr_locations.location_code%TYPE;

1327: p_language IN VARCHAR2) RETURN VARCHAR2
1328:
1329: IS
1330:
1331: v_address_name hr_locations.location_code%TYPE;
1332: v_address_1 hr_locations.address_line_1%TYPE;
1333: v_address_2 hr_locations.address_line_2%TYPE;
1334: v_address_3 hr_locations.address_line_3%TYPE;
1335: v_city hr_locations.town_or_city%TYPE;

Line 1332: v_address_1 hr_locations.address_line_1%TYPE;

1328:
1329: IS
1330:
1331: v_address_name hr_locations.location_code%TYPE;
1332: v_address_1 hr_locations.address_line_1%TYPE;
1333: v_address_2 hr_locations.address_line_2%TYPE;
1334: v_address_3 hr_locations.address_line_3%TYPE;
1335: v_city hr_locations.town_or_city%TYPE;
1336: v_state hr_locations.region_2%TYPE;

Line 1333: v_address_2 hr_locations.address_line_2%TYPE;

1329: IS
1330:
1331: v_address_name hr_locations.location_code%TYPE;
1332: v_address_1 hr_locations.address_line_1%TYPE;
1333: v_address_2 hr_locations.address_line_2%TYPE;
1334: v_address_3 hr_locations.address_line_3%TYPE;
1335: v_city hr_locations.town_or_city%TYPE;
1336: v_state hr_locations.region_2%TYPE;
1337: v_province_or_region hr_locations.region_3%TYPE;

Line 1334: v_address_3 hr_locations.address_line_3%TYPE;

1330:
1331: v_address_name hr_locations.location_code%TYPE;
1332: v_address_1 hr_locations.address_line_1%TYPE;
1333: v_address_2 hr_locations.address_line_2%TYPE;
1334: v_address_3 hr_locations.address_line_3%TYPE;
1335: v_city hr_locations.town_or_city%TYPE;
1336: v_state hr_locations.region_2%TYPE;
1337: v_province_or_region hr_locations.region_3%TYPE;
1338: v_zip_code hr_locations.postal_code%TYPE;

Line 1335: v_city hr_locations.town_or_city%TYPE;

1331: v_address_name hr_locations.location_code%TYPE;
1332: v_address_1 hr_locations.address_line_1%TYPE;
1333: v_address_2 hr_locations.address_line_2%TYPE;
1334: v_address_3 hr_locations.address_line_3%TYPE;
1335: v_city hr_locations.town_or_city%TYPE;
1336: v_state hr_locations.region_2%TYPE;
1337: v_province_or_region hr_locations.region_3%TYPE;
1338: v_zip_code hr_locations.postal_code%TYPE;
1339: v_postal_code hr_locations.postal_code%TYPE;

Line 1336: v_state hr_locations.region_2%TYPE;

1332: v_address_1 hr_locations.address_line_1%TYPE;
1333: v_address_2 hr_locations.address_line_2%TYPE;
1334: v_address_3 hr_locations.address_line_3%TYPE;
1335: v_city hr_locations.town_or_city%TYPE;
1336: v_state hr_locations.region_2%TYPE;
1337: v_province_or_region hr_locations.region_3%TYPE;
1338: v_zip_code hr_locations.postal_code%TYPE;
1339: v_postal_code hr_locations.postal_code%TYPE;
1340: v_country hr_locations.country%TYPE;

Line 1337: v_province_or_region hr_locations.region_3%TYPE;

1333: v_address_2 hr_locations.address_line_2%TYPE;
1334: v_address_3 hr_locations.address_line_3%TYPE;
1335: v_city hr_locations.town_or_city%TYPE;
1336: v_state hr_locations.region_2%TYPE;
1337: v_province_or_region hr_locations.region_3%TYPE;
1338: v_zip_code hr_locations.postal_code%TYPE;
1339: v_postal_code hr_locations.postal_code%TYPE;
1340: v_country hr_locations.country%TYPE;
1341: v_county hr_locations.region_1%TYPE;

Line 1338: v_zip_code hr_locations.postal_code%TYPE;

1334: v_address_3 hr_locations.address_line_3%TYPE;
1335: v_city hr_locations.town_or_city%TYPE;
1336: v_state hr_locations.region_2%TYPE;
1337: v_province_or_region hr_locations.region_3%TYPE;
1338: v_zip_code hr_locations.postal_code%TYPE;
1339: v_postal_code hr_locations.postal_code%TYPE;
1340: v_country hr_locations.country%TYPE;
1341: v_county hr_locations.region_1%TYPE;
1342: v_territory_name fnd_territories_tl.territory_short_name%TYPE;

Line 1339: v_postal_code hr_locations.postal_code%TYPE;

1335: v_city hr_locations.town_or_city%TYPE;
1336: v_state hr_locations.region_2%TYPE;
1337: v_province_or_region hr_locations.region_3%TYPE;
1338: v_zip_code hr_locations.postal_code%TYPE;
1339: v_postal_code hr_locations.postal_code%TYPE;
1340: v_country hr_locations.country%TYPE;
1341: v_county hr_locations.region_1%TYPE;
1342: v_territory_name fnd_territories_tl.territory_short_name%TYPE;
1343: v_return_string VARCHAR2(1000);

Line 1340: v_country hr_locations.country%TYPE;

1336: v_state hr_locations.region_2%TYPE;
1337: v_province_or_region hr_locations.region_3%TYPE;
1338: v_zip_code hr_locations.postal_code%TYPE;
1339: v_postal_code hr_locations.postal_code%TYPE;
1340: v_country hr_locations.country%TYPE;
1341: v_county hr_locations.region_1%TYPE;
1342: v_territory_name fnd_territories_tl.territory_short_name%TYPE;
1343: v_return_string VARCHAR2(1000);
1344:

Line 1341: v_county hr_locations.region_1%TYPE;

1337: v_province_or_region hr_locations.region_3%TYPE;
1338: v_zip_code hr_locations.postal_code%TYPE;
1339: v_postal_code hr_locations.postal_code%TYPE;
1340: v_country hr_locations.country%TYPE;
1341: v_county hr_locations.region_1%TYPE;
1342: v_territory_name fnd_territories_tl.territory_short_name%TYPE;
1343: v_return_string VARCHAR2(1000);
1344:
1345: BEGIN

Line 1371: FROM hr_locations hl

1367: v_zip_code,
1368: v_postal_code,
1369: v_country,
1370: v_county
1371: FROM hr_locations hl
1372: WHERE hl.location_id = p_location_id;
1373:
1374: BEGIN
1375: SELECT