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_ADD_UTIL_PKG dependencies on HR_LOCATIONS

Line 10: address_name HR_LOCATIONS.location_code%TYPE

6:
7: HZ_FAIL_EXCEPTION EXCEPTION;
8:
9: type hrAddrRecTyp IS RECORD (
10: address_name HR_LOCATIONS.location_code%TYPE
11: , address1 HR_LOCATIONS.address_line_1%TYPE
12: , address2 HR_LOCATIONS.address_line_2%TYPE
13: , city HR_LOCATIONS.town_or_city%TYPE
14: , state HR_LOCATIONS.region_2%TYPE

Line 11: , address1 HR_LOCATIONS.address_line_1%TYPE

7: HZ_FAIL_EXCEPTION EXCEPTION;
8:
9: type hrAddrRecTyp IS RECORD (
10: address_name HR_LOCATIONS.location_code%TYPE
11: , address1 HR_LOCATIONS.address_line_1%TYPE
12: , address2 HR_LOCATIONS.address_line_2%TYPE
13: , city HR_LOCATIONS.town_or_city%TYPE
14: , state HR_LOCATIONS.region_2%TYPE
15: , province HR_LOCATIONS.region_3%TYPE

Line 12: , address2 HR_LOCATIONS.address_line_2%TYPE

8:
9: type hrAddrRecTyp IS RECORD (
10: address_name HR_LOCATIONS.location_code%TYPE
11: , address1 HR_LOCATIONS.address_line_1%TYPE
12: , address2 HR_LOCATIONS.address_line_2%TYPE
13: , city HR_LOCATIONS.town_or_city%TYPE
14: , state HR_LOCATIONS.region_2%TYPE
15: , province HR_LOCATIONS.region_3%TYPE
16: , zip HR_LOCATIONS.postal_code%TYPE

Line 13: , city HR_LOCATIONS.town_or_city%TYPE

9: type hrAddrRecTyp IS RECORD (
10: address_name HR_LOCATIONS.location_code%TYPE
11: , address1 HR_LOCATIONS.address_line_1%TYPE
12: , address2 HR_LOCATIONS.address_line_2%TYPE
13: , city HR_LOCATIONS.town_or_city%TYPE
14: , state HR_LOCATIONS.region_2%TYPE
15: , province HR_LOCATIONS.region_3%TYPE
16: , zip HR_LOCATIONS.postal_code%TYPE
17: , postal_code HR_LOCATIONS.postal_code%TYPE

Line 14: , state HR_LOCATIONS.region_2%TYPE

10: address_name HR_LOCATIONS.location_code%TYPE
11: , address1 HR_LOCATIONS.address_line_1%TYPE
12: , address2 HR_LOCATIONS.address_line_2%TYPE
13: , city HR_LOCATIONS.town_or_city%TYPE
14: , state HR_LOCATIONS.region_2%TYPE
15: , province HR_LOCATIONS.region_3%TYPE
16: , zip HR_LOCATIONS.postal_code%TYPE
17: , postal_code HR_LOCATIONS.postal_code%TYPE
18: , country HR_LOCATIONS.country%TYPE

Line 15: , province HR_LOCATIONS.region_3%TYPE

11: , address1 HR_LOCATIONS.address_line_1%TYPE
12: , address2 HR_LOCATIONS.address_line_2%TYPE
13: , city HR_LOCATIONS.town_or_city%TYPE
14: , state HR_LOCATIONS.region_2%TYPE
15: , province HR_LOCATIONS.region_3%TYPE
16: , zip HR_LOCATIONS.postal_code%TYPE
17: , postal_code HR_LOCATIONS.postal_code%TYPE
18: , country HR_LOCATIONS.country%TYPE
19: , county HR_LOCATIONS.region_1%TYPE

Line 16: , zip HR_LOCATIONS.postal_code%TYPE

12: , address2 HR_LOCATIONS.address_line_2%TYPE
13: , city HR_LOCATIONS.town_or_city%TYPE
14: , state HR_LOCATIONS.region_2%TYPE
15: , province HR_LOCATIONS.region_3%TYPE
16: , zip HR_LOCATIONS.postal_code%TYPE
17: , postal_code HR_LOCATIONS.postal_code%TYPE
18: , country HR_LOCATIONS.country%TYPE
19: , county HR_LOCATIONS.region_1%TYPE
20: , bill_to_site_flag HR_LOCATIONS.bill_to_site_flag%TYPE

Line 17: , postal_code HR_LOCATIONS.postal_code%TYPE

13: , city HR_LOCATIONS.town_or_city%TYPE
14: , state HR_LOCATIONS.region_2%TYPE
15: , province HR_LOCATIONS.region_3%TYPE
16: , zip HR_LOCATIONS.postal_code%TYPE
17: , postal_code HR_LOCATIONS.postal_code%TYPE
18: , country HR_LOCATIONS.country%TYPE
19: , county HR_LOCATIONS.region_1%TYPE
20: , bill_to_site_flag HR_LOCATIONS.bill_to_site_flag%TYPE
21: , ship_to_site_flag HR_LOCATIONS.ship_to_site_flag%TYPE

Line 18: , country HR_LOCATIONS.country%TYPE

14: , state HR_LOCATIONS.region_2%TYPE
15: , province HR_LOCATIONS.region_3%TYPE
16: , zip HR_LOCATIONS.postal_code%TYPE
17: , postal_code HR_LOCATIONS.postal_code%TYPE
18: , country HR_LOCATIONS.country%TYPE
19: , county HR_LOCATIONS.region_1%TYPE
20: , bill_to_site_flag HR_LOCATIONS.bill_to_site_flag%TYPE
21: , ship_to_site_flag HR_LOCATIONS.ship_to_site_flag%TYPE
22: , mail_to_site_flag HR_LOCATIONS.receiving_site_flag%TYPE

Line 19: , county HR_LOCATIONS.region_1%TYPE

15: , province HR_LOCATIONS.region_3%TYPE
16: , zip HR_LOCATIONS.postal_code%TYPE
17: , postal_code HR_LOCATIONS.postal_code%TYPE
18: , country HR_LOCATIONS.country%TYPE
19: , county HR_LOCATIONS.region_1%TYPE
20: , bill_to_site_flag HR_LOCATIONS.bill_to_site_flag%TYPE
21: , ship_to_site_flag HR_LOCATIONS.ship_to_site_flag%TYPE
22: , mail_to_site_flag HR_LOCATIONS.receiving_site_flag%TYPE
23: );

Line 20: , bill_to_site_flag HR_LOCATIONS.bill_to_site_flag%TYPE

16: , zip HR_LOCATIONS.postal_code%TYPE
17: , postal_code HR_LOCATIONS.postal_code%TYPE
18: , country HR_LOCATIONS.country%TYPE
19: , county HR_LOCATIONS.region_1%TYPE
20: , bill_to_site_flag HR_LOCATIONS.bill_to_site_flag%TYPE
21: , ship_to_site_flag HR_LOCATIONS.ship_to_site_flag%TYPE
22: , mail_to_site_flag HR_LOCATIONS.receiving_site_flag%TYPE
23: );
24:

Line 21: , ship_to_site_flag HR_LOCATIONS.ship_to_site_flag%TYPE

17: , postal_code HR_LOCATIONS.postal_code%TYPE
18: , country HR_LOCATIONS.country%TYPE
19: , county HR_LOCATIONS.region_1%TYPE
20: , bill_to_site_flag HR_LOCATIONS.bill_to_site_flag%TYPE
21: , ship_to_site_flag HR_LOCATIONS.ship_to_site_flag%TYPE
22: , mail_to_site_flag HR_LOCATIONS.receiving_site_flag%TYPE
23: );
24:
25: type tcaAddrRecTyp IS RECORD (

Line 22: , mail_to_site_flag HR_LOCATIONS.receiving_site_flag%TYPE

18: , country HR_LOCATIONS.country%TYPE
19: , county HR_LOCATIONS.region_1%TYPE
20: , bill_to_site_flag HR_LOCATIONS.bill_to_site_flag%TYPE
21: , ship_to_site_flag HR_LOCATIONS.ship_to_site_flag%TYPE
22: , mail_to_site_flag HR_LOCATIONS.receiving_site_flag%TYPE
23: );
24:
25: type tcaAddrRecTyp IS RECORD (
26: address_name HZ_PARTY_SITES.party_site_name%TYPE