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.HR_US_PYZIPCHK dependencies on PER_ADDRESSES

Line 7: -- HR_LOCATIONS_ALL and PER_ADDRESSES tables.

3: --
4: --
5: -- This procedure is used to flag out and shows the details
6: -- of the addresses which have invalid zip codes in both
7: -- HR_LOCATIONS_ALL and PER_ADDRESSES tables.
8: -- This script holds procedures and functions that are
9: -- used to display all the invalid existing addresses in the hr_location_all
10: -- and per_addresses. It produces a report of all the addresses which
11: -- contain invlid zip code. This is done by calling the inval_addr

Line 10: -- and per_addresses. It produces a report of all the addresses which

6: -- of the addresses which have invalid zip codes in both
7: -- HR_LOCATIONS_ALL and PER_ADDRESSES tables.
8: -- This script holds procedures and functions that are
9: -- used to display all the invalid existing addresses in the hr_location_all
10: -- and per_addresses. It produces a report of all the addresses which
11: -- contain invlid zip code. This is done by calling the inval_addr
12: -- function.
13: --
14: PROCEDURE inval_per_addr ( p_address_id in number,

Line 184: from per_addresses per

180: per.region_1,
181: per.region_2,
182: per.town_or_city,
183: per.postal_code
184: from per_addresses per
185: where per.style in ('US','CA') or per.country in ('US','CA') ;--Added for Bug#8982883
186:
187: --
188: cursor hrzipcur is

Line 217: address_id per_addresses.address_id%TYPE,

213:
214:
215: type peraddrow is record
216: (
217: address_id per_addresses.address_id%TYPE,
218: region_1 per_addresses.region_1%TYPE,
219: region_2 per_addresses.region_2%TYPE,
220: town_or_city per_addresses.town_or_city%TYPE,
221: postal_code per_addresses.postal_code%TYPE

Line 218: region_1 per_addresses.region_1%TYPE,

214:
215: type peraddrow is record
216: (
217: address_id per_addresses.address_id%TYPE,
218: region_1 per_addresses.region_1%TYPE,
219: region_2 per_addresses.region_2%TYPE,
220: town_or_city per_addresses.town_or_city%TYPE,
221: postal_code per_addresses.postal_code%TYPE
222:

Line 219: region_2 per_addresses.region_2%TYPE,

215: type peraddrow is record
216: (
217: address_id per_addresses.address_id%TYPE,
218: region_1 per_addresses.region_1%TYPE,
219: region_2 per_addresses.region_2%TYPE,
220: town_or_city per_addresses.town_or_city%TYPE,
221: postal_code per_addresses.postal_code%TYPE
222:
223: /* Commented to change the type of the variables

Line 220: town_or_city per_addresses.town_or_city%TYPE,

216: (
217: address_id per_addresses.address_id%TYPE,
218: region_1 per_addresses.region_1%TYPE,
219: region_2 per_addresses.region_2%TYPE,
220: town_or_city per_addresses.town_or_city%TYPE,
221: postal_code per_addresses.postal_code%TYPE
222:
223: /* Commented to change the type of the variables
224: address_id number(15),

Line 221: postal_code per_addresses.postal_code%TYPE

217: address_id per_addresses.address_id%TYPE,
218: region_1 per_addresses.region_1%TYPE,
219: region_2 per_addresses.region_2%TYPE,
220: town_or_city per_addresses.town_or_city%TYPE,
221: postal_code per_addresses.postal_code%TYPE
222:
223: /* Commented to change the type of the variables
224: address_id number(15),
225: region_1 varchar2(70),