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

Line 4564: v_address_line_1 hr_locations.address_line_1%TYPE;

4560: f_zip varchar2(20) := NULL;
4561: f_zip_extension varchar2(4) := NULL;
4562: v_index number(5);
4563: --
4564: v_address_line_1 hr_locations.address_line_1%TYPE;
4565: v_address_line_2 hr_locations.address_line_2%TYPE;
4566: v_address_line_3 hr_locations.address_line_3%TYPE;
4567: v_town_or_city hr_locations.town_or_city%TYPE;
4568: v_region_2 hr_locations.region_2%TYPE;

Line 4565: v_address_line_2 hr_locations.address_line_2%TYPE;

4561: f_zip_extension varchar2(4) := NULL;
4562: v_index number(5);
4563: --
4564: v_address_line_1 hr_locations.address_line_1%TYPE;
4565: v_address_line_2 hr_locations.address_line_2%TYPE;
4566: v_address_line_3 hr_locations.address_line_3%TYPE;
4567: v_town_or_city hr_locations.town_or_city%TYPE;
4568: v_region_2 hr_locations.region_2%TYPE;
4569: v_region_1 hr_locations.region_1%TYPE;

Line 4566: v_address_line_3 hr_locations.address_line_3%TYPE;

4562: v_index number(5);
4563: --
4564: v_address_line_1 hr_locations.address_line_1%TYPE;
4565: v_address_line_2 hr_locations.address_line_2%TYPE;
4566: v_address_line_3 hr_locations.address_line_3%TYPE;
4567: v_town_or_city hr_locations.town_or_city%TYPE;
4568: v_region_2 hr_locations.region_2%TYPE;
4569: v_region_1 hr_locations.region_1%TYPE;
4570: v_style hr_locations.style%TYPE;

Line 4567: v_town_or_city hr_locations.town_or_city%TYPE;

4563: --
4564: v_address_line_1 hr_locations.address_line_1%TYPE;
4565: v_address_line_2 hr_locations.address_line_2%TYPE;
4566: v_address_line_3 hr_locations.address_line_3%TYPE;
4567: v_town_or_city hr_locations.town_or_city%TYPE;
4568: v_region_2 hr_locations.region_2%TYPE;
4569: v_region_1 hr_locations.region_1%TYPE;
4570: v_style hr_locations.style%TYPE;
4571: v_postal_code hr_locations.postal_code%TYPE;

Line 4568: v_region_2 hr_locations.region_2%TYPE;

4564: v_address_line_1 hr_locations.address_line_1%TYPE;
4565: v_address_line_2 hr_locations.address_line_2%TYPE;
4566: v_address_line_3 hr_locations.address_line_3%TYPE;
4567: v_town_or_city hr_locations.town_or_city%TYPE;
4568: v_region_2 hr_locations.region_2%TYPE;
4569: v_region_1 hr_locations.region_1%TYPE;
4570: v_style hr_locations.style%TYPE;
4571: v_postal_code hr_locations.postal_code%TYPE;
4572: --

Line 4569: v_region_1 hr_locations.region_1%TYPE;

4565: v_address_line_2 hr_locations.address_line_2%TYPE;
4566: v_address_line_3 hr_locations.address_line_3%TYPE;
4567: v_town_or_city hr_locations.town_or_city%TYPE;
4568: v_region_2 hr_locations.region_2%TYPE;
4569: v_region_1 hr_locations.region_1%TYPE;
4570: v_style hr_locations.style%TYPE;
4571: v_postal_code hr_locations.postal_code%TYPE;
4572: --
4573: cursor get_location_record is

Line 4570: v_style hr_locations.style%TYPE;

4566: v_address_line_3 hr_locations.address_line_3%TYPE;
4567: v_town_or_city hr_locations.town_or_city%TYPE;
4568: v_region_2 hr_locations.region_2%TYPE;
4569: v_region_1 hr_locations.region_1%TYPE;
4570: v_style hr_locations.style%TYPE;
4571: v_postal_code hr_locations.postal_code%TYPE;
4572: --
4573: cursor get_location_record is
4574: select address_line_1, address_line_2, address_line_3,

Line 4571: v_postal_code hr_locations.postal_code%TYPE;

4567: v_town_or_city hr_locations.town_or_city%TYPE;
4568: v_region_2 hr_locations.region_2%TYPE;
4569: v_region_1 hr_locations.region_1%TYPE;
4570: v_style hr_locations.style%TYPE;
4571: v_postal_code hr_locations.postal_code%TYPE;
4572: --
4573: cursor get_location_record is
4574: select address_line_1, address_line_2, address_line_3,
4575: town_or_city, region_1, region_2, postal_code ,style

Line 4576: from hr_locations

4572: --
4573: cursor get_location_record is
4574: select address_line_1, address_line_2, address_line_3,
4575: town_or_city, region_1, region_2, postal_code ,style
4576: from hr_locations
4577: where location_id = p_location_id;
4578: --
4579: begin
4580: --

Line 4693: v_address_line_1 hr_locations.address_line_1%TYPE;

4689: f_zip varchar2(20) := NULL;
4690: f_zip_extension varchar2(4) := NULL;
4691: v_index number(5);
4692: --
4693: v_address_line_1 hr_locations.address_line_1%TYPE;
4694: v_address_line_2 hr_locations.address_line_2%TYPE;
4695: v_address_line_3 hr_locations.address_line_3%TYPE;
4696: v_town_or_city hr_locations.town_or_city%TYPE;
4697: v_region_2 hr_locations.region_2%TYPE;

Line 4694: v_address_line_2 hr_locations.address_line_2%TYPE;

4690: f_zip_extension varchar2(4) := NULL;
4691: v_index number(5);
4692: --
4693: v_address_line_1 hr_locations.address_line_1%TYPE;
4694: v_address_line_2 hr_locations.address_line_2%TYPE;
4695: v_address_line_3 hr_locations.address_line_3%TYPE;
4696: v_town_or_city hr_locations.town_or_city%TYPE;
4697: v_region_2 hr_locations.region_2%TYPE;
4698: v_region_1 hr_locations.region_1%TYPE;

Line 4695: v_address_line_3 hr_locations.address_line_3%TYPE;

4691: v_index number(5);
4692: --
4693: v_address_line_1 hr_locations.address_line_1%TYPE;
4694: v_address_line_2 hr_locations.address_line_2%TYPE;
4695: v_address_line_3 hr_locations.address_line_3%TYPE;
4696: v_town_or_city hr_locations.town_or_city%TYPE;
4697: v_region_2 hr_locations.region_2%TYPE;
4698: v_region_1 hr_locations.region_1%TYPE;
4699: v_postal_code hr_locations.postal_code%TYPE;

Line 4696: v_town_or_city hr_locations.town_or_city%TYPE;

4692: --
4693: v_address_line_1 hr_locations.address_line_1%TYPE;
4694: v_address_line_2 hr_locations.address_line_2%TYPE;
4695: v_address_line_3 hr_locations.address_line_3%TYPE;
4696: v_town_or_city hr_locations.town_or_city%TYPE;
4697: v_region_2 hr_locations.region_2%TYPE;
4698: v_region_1 hr_locations.region_1%TYPE;
4699: v_postal_code hr_locations.postal_code%TYPE;
4700: v_country hr_locations.country%TYPE;

Line 4697: v_region_2 hr_locations.region_2%TYPE;

4693: v_address_line_1 hr_locations.address_line_1%TYPE;
4694: v_address_line_2 hr_locations.address_line_2%TYPE;
4695: v_address_line_3 hr_locations.address_line_3%TYPE;
4696: v_town_or_city hr_locations.town_or_city%TYPE;
4697: v_region_2 hr_locations.region_2%TYPE;
4698: v_region_1 hr_locations.region_1%TYPE;
4699: v_postal_code hr_locations.postal_code%TYPE;
4700: v_country hr_locations.country%TYPE;
4701: v_style hr_locations.style%TYPE;

Line 4698: v_region_1 hr_locations.region_1%TYPE;

4694: v_address_line_2 hr_locations.address_line_2%TYPE;
4695: v_address_line_3 hr_locations.address_line_3%TYPE;
4696: v_town_or_city hr_locations.town_or_city%TYPE;
4697: v_region_2 hr_locations.region_2%TYPE;
4698: v_region_1 hr_locations.region_1%TYPE;
4699: v_postal_code hr_locations.postal_code%TYPE;
4700: v_country hr_locations.country%TYPE;
4701: v_style hr_locations.style%TYPE;
4702: --

Line 4699: v_postal_code hr_locations.postal_code%TYPE;

4695: v_address_line_3 hr_locations.address_line_3%TYPE;
4696: v_town_or_city hr_locations.town_or_city%TYPE;
4697: v_region_2 hr_locations.region_2%TYPE;
4698: v_region_1 hr_locations.region_1%TYPE;
4699: v_postal_code hr_locations.postal_code%TYPE;
4700: v_country hr_locations.country%TYPE;
4701: v_style hr_locations.style%TYPE;
4702: --
4703: cursor get_location_record is

Line 4700: v_country hr_locations.country%TYPE;

4696: v_town_or_city hr_locations.town_or_city%TYPE;
4697: v_region_2 hr_locations.region_2%TYPE;
4698: v_region_1 hr_locations.region_1%TYPE;
4699: v_postal_code hr_locations.postal_code%TYPE;
4700: v_country hr_locations.country%TYPE;
4701: v_style hr_locations.style%TYPE;
4702: --
4703: cursor get_location_record is
4704: select address_line_1, address_line_2, address_line_3,

Line 4701: v_style hr_locations.style%TYPE;

4697: v_region_2 hr_locations.region_2%TYPE;
4698: v_region_1 hr_locations.region_1%TYPE;
4699: v_postal_code hr_locations.postal_code%TYPE;
4700: v_country hr_locations.country%TYPE;
4701: v_style hr_locations.style%TYPE;
4702: --
4703: cursor get_location_record is
4704: select address_line_1, address_line_2, address_line_3,
4705: town_or_city, region_1, region_2, postal_code

Line 4707: from hr_locations

4703: cursor get_location_record is
4704: select address_line_1, address_line_2, address_line_3,
4705: town_or_city, region_1, region_2, postal_code
4706: ,country,style
4707: from hr_locations
4708: where location_id = p_location_id;
4709: --
4710: begin
4711: --