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 HZ_LOCATIONS

Line 27: , address1 HZ_LOCATIONS.address1%TYPE

23: );
24:
25: type tcaAddrRecTyp IS RECORD (
26: address_name HZ_PARTY_SITES.party_site_name%TYPE
27: , address1 HZ_LOCATIONS.address1%TYPE
28: , address2 HZ_LOCATIONS.address2%TYPE
29: , city HZ_LOCATIONS.city%TYPE
30: , state HZ_LOCATIONS.state%TYPE
31: , province HZ_LOCATIONS.province%TYPE

Line 28: , address2 HZ_LOCATIONS.address2%TYPE

24:
25: type tcaAddrRecTyp IS RECORD (
26: address_name HZ_PARTY_SITES.party_site_name%TYPE
27: , address1 HZ_LOCATIONS.address1%TYPE
28: , address2 HZ_LOCATIONS.address2%TYPE
29: , city HZ_LOCATIONS.city%TYPE
30: , state HZ_LOCATIONS.state%TYPE
31: , province HZ_LOCATIONS.province%TYPE
32: , zip HZ_LOCATIONS.postal_plus4_code%TYPE

Line 29: , city HZ_LOCATIONS.city%TYPE

25: type tcaAddrRecTyp IS RECORD (
26: address_name HZ_PARTY_SITES.party_site_name%TYPE
27: , address1 HZ_LOCATIONS.address1%TYPE
28: , address2 HZ_LOCATIONS.address2%TYPE
29: , city HZ_LOCATIONS.city%TYPE
30: , state HZ_LOCATIONS.state%TYPE
31: , province HZ_LOCATIONS.province%TYPE
32: , zip HZ_LOCATIONS.postal_plus4_code%TYPE
33: , postal_code HZ_LOCATIONS.postal_code%TYPE

Line 30: , state HZ_LOCATIONS.state%TYPE

26: address_name HZ_PARTY_SITES.party_site_name%TYPE
27: , address1 HZ_LOCATIONS.address1%TYPE
28: , address2 HZ_LOCATIONS.address2%TYPE
29: , city HZ_LOCATIONS.city%TYPE
30: , state HZ_LOCATIONS.state%TYPE
31: , province HZ_LOCATIONS.province%TYPE
32: , zip HZ_LOCATIONS.postal_plus4_code%TYPE
33: , postal_code HZ_LOCATIONS.postal_code%TYPE
34: , country HZ_LOCATIONS.country%TYPE

Line 31: , province HZ_LOCATIONS.province%TYPE

27: , address1 HZ_LOCATIONS.address1%TYPE
28: , address2 HZ_LOCATIONS.address2%TYPE
29: , city HZ_LOCATIONS.city%TYPE
30: , state HZ_LOCATIONS.state%TYPE
31: , province HZ_LOCATIONS.province%TYPE
32: , zip HZ_LOCATIONS.postal_plus4_code%TYPE
33: , postal_code HZ_LOCATIONS.postal_code%TYPE
34: , country HZ_LOCATIONS.country%TYPE
35: , county HZ_LOCATIONS.county%TYPE

Line 32: , zip HZ_LOCATIONS.postal_plus4_code%TYPE

28: , address2 HZ_LOCATIONS.address2%TYPE
29: , city HZ_LOCATIONS.city%TYPE
30: , state HZ_LOCATIONS.state%TYPE
31: , province HZ_LOCATIONS.province%TYPE
32: , zip HZ_LOCATIONS.postal_plus4_code%TYPE
33: , postal_code HZ_LOCATIONS.postal_code%TYPE
34: , country HZ_LOCATIONS.country%TYPE
35: , county HZ_LOCATIONS.county%TYPE
36: , over_sea_flag HZ_LOCATIONS.overseas_address_flag%TYPE

Line 33: , postal_code HZ_LOCATIONS.postal_code%TYPE

29: , city HZ_LOCATIONS.city%TYPE
30: , state HZ_LOCATIONS.state%TYPE
31: , province HZ_LOCATIONS.province%TYPE
32: , zip HZ_LOCATIONS.postal_plus4_code%TYPE
33: , postal_code HZ_LOCATIONS.postal_code%TYPE
34: , country HZ_LOCATIONS.country%TYPE
35: , county HZ_LOCATIONS.county%TYPE
36: , over_sea_flag HZ_LOCATIONS.overseas_address_flag%TYPE
37: , bill_to_site_flag VARCHAR2(1)

Line 34: , country HZ_LOCATIONS.country%TYPE

30: , state HZ_LOCATIONS.state%TYPE
31: , province HZ_LOCATIONS.province%TYPE
32: , zip HZ_LOCATIONS.postal_plus4_code%TYPE
33: , postal_code HZ_LOCATIONS.postal_code%TYPE
34: , country HZ_LOCATIONS.country%TYPE
35: , county HZ_LOCATIONS.county%TYPE
36: , over_sea_flag HZ_LOCATIONS.overseas_address_flag%TYPE
37: , bill_to_site_flag VARCHAR2(1)
38: , ship_to_site_flag VARCHAR2(1)

Line 35: , county HZ_LOCATIONS.county%TYPE

31: , province HZ_LOCATIONS.province%TYPE
32: , zip HZ_LOCATIONS.postal_plus4_code%TYPE
33: , postal_code HZ_LOCATIONS.postal_code%TYPE
34: , country HZ_LOCATIONS.country%TYPE
35: , county HZ_LOCATIONS.county%TYPE
36: , over_sea_flag HZ_LOCATIONS.overseas_address_flag%TYPE
37: , bill_to_site_flag VARCHAR2(1)
38: , ship_to_site_flag VARCHAR2(1)
39: , mail_to_site_flag VARCHAR2(1));

Line 36: , over_sea_flag HZ_LOCATIONS.overseas_address_flag%TYPE

32: , zip HZ_LOCATIONS.postal_plus4_code%TYPE
33: , postal_code HZ_LOCATIONS.postal_code%TYPE
34: , country HZ_LOCATIONS.country%TYPE
35: , county HZ_LOCATIONS.county%TYPE
36: , over_sea_flag HZ_LOCATIONS.overseas_address_flag%TYPE
37: , bill_to_site_flag VARCHAR2(1)
38: , ship_to_site_flag VARCHAR2(1)
39: , mail_to_site_flag VARCHAR2(1));
40: