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.

[Home] [Help]

APPS.PER_NEW_HIRE_PKG dependencies on HR_LOCATIONS

Line 1966: v_address_line_1 hr_locations.address_line_1%TYPE;

1962: f_zip varchar2(20) := NULL;
1963: f_zip_extension varchar2(4) := NULL;
1964: v_index number(5);
1965: --
1966: v_address_line_1 hr_locations.address_line_1%TYPE;
1967: v_address_line_2 hr_locations.address_line_2%TYPE;
1968: v_address_line_3 hr_locations.address_line_3%TYPE;
1969: v_town_or_city hr_locations.town_or_city%TYPE;
1970: v_region_2 hr_locations.region_2%TYPE;

Line 1967: v_address_line_2 hr_locations.address_line_2%TYPE;

1963: f_zip_extension varchar2(4) := NULL;
1964: v_index number(5);
1965: --
1966: v_address_line_1 hr_locations.address_line_1%TYPE;
1967: v_address_line_2 hr_locations.address_line_2%TYPE;
1968: v_address_line_3 hr_locations.address_line_3%TYPE;
1969: v_town_or_city hr_locations.town_or_city%TYPE;
1970: v_region_2 hr_locations.region_2%TYPE;
1971: v_region_1 hr_locations.region_1%TYPE;

Line 1968: v_address_line_3 hr_locations.address_line_3%TYPE;

1964: v_index number(5);
1965: --
1966: v_address_line_1 hr_locations.address_line_1%TYPE;
1967: v_address_line_2 hr_locations.address_line_2%TYPE;
1968: v_address_line_3 hr_locations.address_line_3%TYPE;
1969: v_town_or_city hr_locations.town_or_city%TYPE;
1970: v_region_2 hr_locations.region_2%TYPE;
1971: v_region_1 hr_locations.region_1%TYPE;
1972: v_style hr_locations.style%TYPE;

Line 1969: v_town_or_city hr_locations.town_or_city%TYPE;

1965: --
1966: v_address_line_1 hr_locations.address_line_1%TYPE;
1967: v_address_line_2 hr_locations.address_line_2%TYPE;
1968: v_address_line_3 hr_locations.address_line_3%TYPE;
1969: v_town_or_city hr_locations.town_or_city%TYPE;
1970: v_region_2 hr_locations.region_2%TYPE;
1971: v_region_1 hr_locations.region_1%TYPE;
1972: v_style hr_locations.style%TYPE;
1973: v_postal_code hr_locations.postal_code%TYPE;

Line 1970: v_region_2 hr_locations.region_2%TYPE;

1966: v_address_line_1 hr_locations.address_line_1%TYPE;
1967: v_address_line_2 hr_locations.address_line_2%TYPE;
1968: v_address_line_3 hr_locations.address_line_3%TYPE;
1969: v_town_or_city hr_locations.town_or_city%TYPE;
1970: v_region_2 hr_locations.region_2%TYPE;
1971: v_region_1 hr_locations.region_1%TYPE;
1972: v_style hr_locations.style%TYPE;
1973: v_postal_code hr_locations.postal_code%TYPE;
1974: --

Line 1971: v_region_1 hr_locations.region_1%TYPE;

1967: v_address_line_2 hr_locations.address_line_2%TYPE;
1968: v_address_line_3 hr_locations.address_line_3%TYPE;
1969: v_town_or_city hr_locations.town_or_city%TYPE;
1970: v_region_2 hr_locations.region_2%TYPE;
1971: v_region_1 hr_locations.region_1%TYPE;
1972: v_style hr_locations.style%TYPE;
1973: v_postal_code hr_locations.postal_code%TYPE;
1974: --
1975: cursor get_location_record is

Line 1972: v_style hr_locations.style%TYPE;

1968: v_address_line_3 hr_locations.address_line_3%TYPE;
1969: v_town_or_city hr_locations.town_or_city%TYPE;
1970: v_region_2 hr_locations.region_2%TYPE;
1971: v_region_1 hr_locations.region_1%TYPE;
1972: v_style hr_locations.style%TYPE;
1973: v_postal_code hr_locations.postal_code%TYPE;
1974: --
1975: cursor get_location_record is
1976: select address_line_1, address_line_2, address_line_3,

Line 1973: v_postal_code hr_locations.postal_code%TYPE;

1969: v_town_or_city hr_locations.town_or_city%TYPE;
1970: v_region_2 hr_locations.region_2%TYPE;
1971: v_region_1 hr_locations.region_1%TYPE;
1972: v_style hr_locations.style%TYPE;
1973: v_postal_code hr_locations.postal_code%TYPE;
1974: --
1975: cursor get_location_record is
1976: select address_line_1, address_line_2, address_line_3,
1977: town_or_city, region_1, region_2, postal_code ,style

Line 1978: from hr_locations

1974: --
1975: cursor get_location_record is
1976: select address_line_1, address_line_2, address_line_3,
1977: town_or_city, region_1, region_2, postal_code ,style
1978: from hr_locations
1979: where location_id = p_location_id;
1980: --
1981: begin
1982: --

Line 2095: v_address_line_1 hr_locations.address_line_1%TYPE;

2091: f_zip varchar2(20) := NULL;
2092: f_zip_extension varchar2(4) := NULL;
2093: v_index number(5);
2094: --
2095: v_address_line_1 hr_locations.address_line_1%TYPE;
2096: v_address_line_2 hr_locations.address_line_2%TYPE;
2097: v_address_line_3 hr_locations.address_line_3%TYPE;
2098: v_town_or_city hr_locations.town_or_city%TYPE;
2099: v_region_2 hr_locations.region_2%TYPE;

Line 2096: v_address_line_2 hr_locations.address_line_2%TYPE;

2092: f_zip_extension varchar2(4) := NULL;
2093: v_index number(5);
2094: --
2095: v_address_line_1 hr_locations.address_line_1%TYPE;
2096: v_address_line_2 hr_locations.address_line_2%TYPE;
2097: v_address_line_3 hr_locations.address_line_3%TYPE;
2098: v_town_or_city hr_locations.town_or_city%TYPE;
2099: v_region_2 hr_locations.region_2%TYPE;
2100: v_region_1 hr_locations.region_1%TYPE;

Line 2097: v_address_line_3 hr_locations.address_line_3%TYPE;

2093: v_index number(5);
2094: --
2095: v_address_line_1 hr_locations.address_line_1%TYPE;
2096: v_address_line_2 hr_locations.address_line_2%TYPE;
2097: v_address_line_3 hr_locations.address_line_3%TYPE;
2098: v_town_or_city hr_locations.town_or_city%TYPE;
2099: v_region_2 hr_locations.region_2%TYPE;
2100: v_region_1 hr_locations.region_1%TYPE;
2101: v_postal_code hr_locations.postal_code%TYPE;

Line 2098: v_town_or_city hr_locations.town_or_city%TYPE;

2094: --
2095: v_address_line_1 hr_locations.address_line_1%TYPE;
2096: v_address_line_2 hr_locations.address_line_2%TYPE;
2097: v_address_line_3 hr_locations.address_line_3%TYPE;
2098: v_town_or_city hr_locations.town_or_city%TYPE;
2099: v_region_2 hr_locations.region_2%TYPE;
2100: v_region_1 hr_locations.region_1%TYPE;
2101: v_postal_code hr_locations.postal_code%TYPE;
2102: v_country hr_locations.country%TYPE;

Line 2099: v_region_2 hr_locations.region_2%TYPE;

2095: v_address_line_1 hr_locations.address_line_1%TYPE;
2096: v_address_line_2 hr_locations.address_line_2%TYPE;
2097: v_address_line_3 hr_locations.address_line_3%TYPE;
2098: v_town_or_city hr_locations.town_or_city%TYPE;
2099: v_region_2 hr_locations.region_2%TYPE;
2100: v_region_1 hr_locations.region_1%TYPE;
2101: v_postal_code hr_locations.postal_code%TYPE;
2102: v_country hr_locations.country%TYPE;
2103: v_style hr_locations.style%TYPE;

Line 2100: v_region_1 hr_locations.region_1%TYPE;

2096: v_address_line_2 hr_locations.address_line_2%TYPE;
2097: v_address_line_3 hr_locations.address_line_3%TYPE;
2098: v_town_or_city hr_locations.town_or_city%TYPE;
2099: v_region_2 hr_locations.region_2%TYPE;
2100: v_region_1 hr_locations.region_1%TYPE;
2101: v_postal_code hr_locations.postal_code%TYPE;
2102: v_country hr_locations.country%TYPE;
2103: v_style hr_locations.style%TYPE;
2104: --

Line 2101: v_postal_code hr_locations.postal_code%TYPE;

2097: v_address_line_3 hr_locations.address_line_3%TYPE;
2098: v_town_or_city hr_locations.town_or_city%TYPE;
2099: v_region_2 hr_locations.region_2%TYPE;
2100: v_region_1 hr_locations.region_1%TYPE;
2101: v_postal_code hr_locations.postal_code%TYPE;
2102: v_country hr_locations.country%TYPE;
2103: v_style hr_locations.style%TYPE;
2104: --
2105: cursor get_location_record is

Line 2102: v_country hr_locations.country%TYPE;

2098: v_town_or_city hr_locations.town_or_city%TYPE;
2099: v_region_2 hr_locations.region_2%TYPE;
2100: v_region_1 hr_locations.region_1%TYPE;
2101: v_postal_code hr_locations.postal_code%TYPE;
2102: v_country hr_locations.country%TYPE;
2103: v_style hr_locations.style%TYPE;
2104: --
2105: cursor get_location_record is
2106: select address_line_1, address_line_2, address_line_3,

Line 2103: v_style hr_locations.style%TYPE;

2099: v_region_2 hr_locations.region_2%TYPE;
2100: v_region_1 hr_locations.region_1%TYPE;
2101: v_postal_code hr_locations.postal_code%TYPE;
2102: v_country hr_locations.country%TYPE;
2103: v_style hr_locations.style%TYPE;
2104: --
2105: cursor get_location_record is
2106: select address_line_1, address_line_2, address_line_3,
2107: town_or_city, region_1, region_2, postal_code

Line 2109: from hr_locations

2105: cursor get_location_record is
2106: select address_line_1, address_line_2, address_line_3,
2107: town_or_city, region_1, region_2, postal_code
2108: ,country,style
2109: from hr_locations
2110: where location_id = p_location_id;
2111: --
2112: begin
2113: --