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 PER_ADDRESSES

Line 4833: -- address_record per_addresses%rowtype;

4829: f_zip varchar2(20) := NULL;
4830: f_zip_extension varchar2(4) := NULL;
4831: v_index number(5);
4832: --
4833: -- address_record per_addresses%rowtype;
4834: --
4835: v_address_line1 per_addresses.address_line1%TYPE;
4836: v_address_line2 per_addresses.address_line2%TYPE;
4837: v_address_line3 per_addresses.address_line3%TYPE;

Line 4835: v_address_line1 per_addresses.address_line1%TYPE;

4831: v_index number(5);
4832: --
4833: -- address_record per_addresses%rowtype;
4834: --
4835: v_address_line1 per_addresses.address_line1%TYPE;
4836: v_address_line2 per_addresses.address_line2%TYPE;
4837: v_address_line3 per_addresses.address_line3%TYPE;
4838: v_town_or_city per_addresses.town_or_city%TYPE;
4839: v_region_2 per_addresses.region_2%TYPE;

Line 4836: v_address_line2 per_addresses.address_line2%TYPE;

4832: --
4833: -- address_record per_addresses%rowtype;
4834: --
4835: v_address_line1 per_addresses.address_line1%TYPE;
4836: v_address_line2 per_addresses.address_line2%TYPE;
4837: v_address_line3 per_addresses.address_line3%TYPE;
4838: v_town_or_city per_addresses.town_or_city%TYPE;
4839: v_region_2 per_addresses.region_2%TYPE;
4840: v_region_1 per_addresses.region_1%TYPE;

Line 4837: v_address_line3 per_addresses.address_line3%TYPE;

4833: -- address_record per_addresses%rowtype;
4834: --
4835: v_address_line1 per_addresses.address_line1%TYPE;
4836: v_address_line2 per_addresses.address_line2%TYPE;
4837: v_address_line3 per_addresses.address_line3%TYPE;
4838: v_town_or_city per_addresses.town_or_city%TYPE;
4839: v_region_2 per_addresses.region_2%TYPE;
4840: v_region_1 per_addresses.region_1%TYPE;
4841: v_postal_code per_addresses.postal_code%TYPE;

Line 4838: v_town_or_city per_addresses.town_or_city%TYPE;

4834: --
4835: v_address_line1 per_addresses.address_line1%TYPE;
4836: v_address_line2 per_addresses.address_line2%TYPE;
4837: v_address_line3 per_addresses.address_line3%TYPE;
4838: v_town_or_city per_addresses.town_or_city%TYPE;
4839: v_region_2 per_addresses.region_2%TYPE;
4840: v_region_1 per_addresses.region_1%TYPE;
4841: v_postal_code per_addresses.postal_code%TYPE;
4842: v_country per_addresses.country%TYPE;

Line 4839: v_region_2 per_addresses.region_2%TYPE;

4835: v_address_line1 per_addresses.address_line1%TYPE;
4836: v_address_line2 per_addresses.address_line2%TYPE;
4837: v_address_line3 per_addresses.address_line3%TYPE;
4838: v_town_or_city per_addresses.town_or_city%TYPE;
4839: v_region_2 per_addresses.region_2%TYPE;
4840: v_region_1 per_addresses.region_1%TYPE;
4841: v_postal_code per_addresses.postal_code%TYPE;
4842: v_country per_addresses.country%TYPE;
4843: v_style per_addresses.style%TYPE;

Line 4840: v_region_1 per_addresses.region_1%TYPE;

4836: v_address_line2 per_addresses.address_line2%TYPE;
4837: v_address_line3 per_addresses.address_line3%TYPE;
4838: v_town_or_city per_addresses.town_or_city%TYPE;
4839: v_region_2 per_addresses.region_2%TYPE;
4840: v_region_1 per_addresses.region_1%TYPE;
4841: v_postal_code per_addresses.postal_code%TYPE;
4842: v_country per_addresses.country%TYPE;
4843: v_style per_addresses.style%TYPE;
4844: --

Line 4841: v_postal_code per_addresses.postal_code%TYPE;

4837: v_address_line3 per_addresses.address_line3%TYPE;
4838: v_town_or_city per_addresses.town_or_city%TYPE;
4839: v_region_2 per_addresses.region_2%TYPE;
4840: v_region_1 per_addresses.region_1%TYPE;
4841: v_postal_code per_addresses.postal_code%TYPE;
4842: v_country per_addresses.country%TYPE;
4843: v_style per_addresses.style%TYPE;
4844: --
4845: cursor get_address_record is

Line 4842: v_country per_addresses.country%TYPE;

4838: v_town_or_city per_addresses.town_or_city%TYPE;
4839: v_region_2 per_addresses.region_2%TYPE;
4840: v_region_1 per_addresses.region_1%TYPE;
4841: v_postal_code per_addresses.postal_code%TYPE;
4842: v_country per_addresses.country%TYPE;
4843: v_style per_addresses.style%TYPE;
4844: --
4845: cursor get_address_record is
4846: select address_line1, address_line2, address_line3,

Line 4843: v_style per_addresses.style%TYPE;

4839: v_region_2 per_addresses.region_2%TYPE;
4840: v_region_1 per_addresses.region_1%TYPE;
4841: v_postal_code per_addresses.postal_code%TYPE;
4842: v_country per_addresses.country%TYPE;
4843: v_style per_addresses.style%TYPE;
4844: --
4845: cursor get_address_record is
4846: select address_line1, address_line2, address_line3,
4847: town_or_city, region_1, region_2, postal_code

Line 4849: from per_addresses

4845: cursor get_address_record is
4846: select address_line1, address_line2, address_line3,
4847: town_or_city, region_1, region_2, postal_code
4848: ,style
4849: from per_addresses
4850: where person_id = p_person_id
4851: and primary_flag = 'Y'
4852: and nvl(date_to, sysdate) >= sysdate;
4853: --

Line 4963: -- address_record per_addresses%rowtype;

4959: f_zip varchar2(20) := NULL;
4960: f_zip_extension varchar2(4) := NULL;
4961: v_index number(5);
4962: --
4963: -- address_record per_addresses%rowtype;
4964: --
4965: v_address_line1 per_addresses.address_line1%TYPE;
4966: v_address_line2 per_addresses.address_line2%TYPE;
4967: v_address_line3 per_addresses.address_line3%TYPE;

Line 4965: v_address_line1 per_addresses.address_line1%TYPE;

4961: v_index number(5);
4962: --
4963: -- address_record per_addresses%rowtype;
4964: --
4965: v_address_line1 per_addresses.address_line1%TYPE;
4966: v_address_line2 per_addresses.address_line2%TYPE;
4967: v_address_line3 per_addresses.address_line3%TYPE;
4968: v_town_or_city per_addresses.town_or_city%TYPE;
4969: v_region_2 per_addresses.region_2%TYPE;

Line 4966: v_address_line2 per_addresses.address_line2%TYPE;

4962: --
4963: -- address_record per_addresses%rowtype;
4964: --
4965: v_address_line1 per_addresses.address_line1%TYPE;
4966: v_address_line2 per_addresses.address_line2%TYPE;
4967: v_address_line3 per_addresses.address_line3%TYPE;
4968: v_town_or_city per_addresses.town_or_city%TYPE;
4969: v_region_2 per_addresses.region_2%TYPE;
4970: v_region_1 per_addresses.region_1%TYPE;

Line 4967: v_address_line3 per_addresses.address_line3%TYPE;

4963: -- address_record per_addresses%rowtype;
4964: --
4965: v_address_line1 per_addresses.address_line1%TYPE;
4966: v_address_line2 per_addresses.address_line2%TYPE;
4967: v_address_line3 per_addresses.address_line3%TYPE;
4968: v_town_or_city per_addresses.town_or_city%TYPE;
4969: v_region_2 per_addresses.region_2%TYPE;
4970: v_region_1 per_addresses.region_1%TYPE;
4971: v_postal_code per_addresses.postal_code%TYPE;

Line 4968: v_town_or_city per_addresses.town_or_city%TYPE;

4964: --
4965: v_address_line1 per_addresses.address_line1%TYPE;
4966: v_address_line2 per_addresses.address_line2%TYPE;
4967: v_address_line3 per_addresses.address_line3%TYPE;
4968: v_town_or_city per_addresses.town_or_city%TYPE;
4969: v_region_2 per_addresses.region_2%TYPE;
4970: v_region_1 per_addresses.region_1%TYPE;
4971: v_postal_code per_addresses.postal_code%TYPE;
4972: v_country per_addresses.country%TYPE;

Line 4969: v_region_2 per_addresses.region_2%TYPE;

4965: v_address_line1 per_addresses.address_line1%TYPE;
4966: v_address_line2 per_addresses.address_line2%TYPE;
4967: v_address_line3 per_addresses.address_line3%TYPE;
4968: v_town_or_city per_addresses.town_or_city%TYPE;
4969: v_region_2 per_addresses.region_2%TYPE;
4970: v_region_1 per_addresses.region_1%TYPE;
4971: v_postal_code per_addresses.postal_code%TYPE;
4972: v_country per_addresses.country%TYPE;
4973: v_style per_addresses.style%TYPE;

Line 4970: v_region_1 per_addresses.region_1%TYPE;

4966: v_address_line2 per_addresses.address_line2%TYPE;
4967: v_address_line3 per_addresses.address_line3%TYPE;
4968: v_town_or_city per_addresses.town_or_city%TYPE;
4969: v_region_2 per_addresses.region_2%TYPE;
4970: v_region_1 per_addresses.region_1%TYPE;
4971: v_postal_code per_addresses.postal_code%TYPE;
4972: v_country per_addresses.country%TYPE;
4973: v_style per_addresses.style%TYPE;
4974: --

Line 4971: v_postal_code per_addresses.postal_code%TYPE;

4967: v_address_line3 per_addresses.address_line3%TYPE;
4968: v_town_or_city per_addresses.town_or_city%TYPE;
4969: v_region_2 per_addresses.region_2%TYPE;
4970: v_region_1 per_addresses.region_1%TYPE;
4971: v_postal_code per_addresses.postal_code%TYPE;
4972: v_country per_addresses.country%TYPE;
4973: v_style per_addresses.style%TYPE;
4974: --
4975: cursor get_address_record is

Line 4972: v_country per_addresses.country%TYPE;

4968: v_town_or_city per_addresses.town_or_city%TYPE;
4969: v_region_2 per_addresses.region_2%TYPE;
4970: v_region_1 per_addresses.region_1%TYPE;
4971: v_postal_code per_addresses.postal_code%TYPE;
4972: v_country per_addresses.country%TYPE;
4973: v_style per_addresses.style%TYPE;
4974: --
4975: cursor get_address_record is
4976: select address_line1, address_line2, address_line3,

Line 4973: v_style per_addresses.style%TYPE;

4969: v_region_2 per_addresses.region_2%TYPE;
4970: v_region_1 per_addresses.region_1%TYPE;
4971: v_postal_code per_addresses.postal_code%TYPE;
4972: v_country per_addresses.country%TYPE;
4973: v_style per_addresses.style%TYPE;
4974: --
4975: cursor get_address_record is
4976: select address_line1, address_line2, address_line3,
4977: town_or_city, region_1, region_2

Line 4979: from per_addresses

4975: cursor get_address_record is
4976: select address_line1, address_line2, address_line3,
4977: town_or_city, region_1, region_2
4978: , postal_code ,country ,style
4979: from per_addresses
4980: where person_id = p_person_id
4981: and primary_flag = 'Y'
4982: and nvl(date_to, sysdate) >= sysdate;
4983: --