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.ARP_TRX_DEFAULTS_3 dependencies on HZ_LOCATIONS

Line 6: address1 hz_locations.address1%type,

2: /* $Header: ARTUDF3S.pls 120.9.12010000.1 2008/07/24 16:57:53 appldev ship $ */
3:
4: TYPE address_rec_type IS RECORD (
5: cust_acct_site_id NUMBER,
6: address1 hz_locations.address1%type,
7: address2 hz_locations.address2%type,
8: address3 hz_locations.address3%type,
9: address4 hz_locations.address4%type,
10: city hz_locations.city%type,

Line 7: address2 hz_locations.address2%type,

3:
4: TYPE address_rec_type IS RECORD (
5: cust_acct_site_id NUMBER,
6: address1 hz_locations.address1%type,
7: address2 hz_locations.address2%type,
8: address3 hz_locations.address3%type,
9: address4 hz_locations.address4%type,
10: city hz_locations.city%type,
11: state hz_locations.state%type,

Line 8: address3 hz_locations.address3%type,

4: TYPE address_rec_type IS RECORD (
5: cust_acct_site_id NUMBER,
6: address1 hz_locations.address1%type,
7: address2 hz_locations.address2%type,
8: address3 hz_locations.address3%type,
9: address4 hz_locations.address4%type,
10: city hz_locations.city%type,
11: state hz_locations.state%type,
12: province hz_locations.province%type,

Line 9: address4 hz_locations.address4%type,

5: cust_acct_site_id NUMBER,
6: address1 hz_locations.address1%type,
7: address2 hz_locations.address2%type,
8: address3 hz_locations.address3%type,
9: address4 hz_locations.address4%type,
10: city hz_locations.city%type,
11: state hz_locations.state%type,
12: province hz_locations.province%type,
13: postal_code hz_locations.postal_code%type,

Line 10: city hz_locations.city%type,

6: address1 hz_locations.address1%type,
7: address2 hz_locations.address2%type,
8: address3 hz_locations.address3%type,
9: address4 hz_locations.address4%type,
10: city hz_locations.city%type,
11: state hz_locations.state%type,
12: province hz_locations.province%type,
13: postal_code hz_locations.postal_code%type,
14: country fnd_territories_vl.territory_short_name%type -- hz_locations.city%type

Line 11: state hz_locations.state%type,

7: address2 hz_locations.address2%type,
8: address3 hz_locations.address3%type,
9: address4 hz_locations.address4%type,
10: city hz_locations.city%type,
11: state hz_locations.state%type,
12: province hz_locations.province%type,
13: postal_code hz_locations.postal_code%type,
14: country fnd_territories_vl.territory_short_name%type -- hz_locations.city%type
15: );

Line 12: province hz_locations.province%type,

8: address3 hz_locations.address3%type,
9: address4 hz_locations.address4%type,
10: city hz_locations.city%type,
11: state hz_locations.state%type,
12: province hz_locations.province%type,
13: postal_code hz_locations.postal_code%type,
14: country fnd_territories_vl.territory_short_name%type -- hz_locations.city%type
15: );
16:

Line 13: postal_code hz_locations.postal_code%type,

9: address4 hz_locations.address4%type,
10: city hz_locations.city%type,
11: state hz_locations.state%type,
12: province hz_locations.province%type,
13: postal_code hz_locations.postal_code%type,
14: country fnd_territories_vl.territory_short_name%type -- hz_locations.city%type
15: );
16:
17: PROCEDURE get_default_remit_to(

Line 14: country fnd_territories_vl.territory_short_name%type -- hz_locations.city%type

10: city hz_locations.city%type,
11: state hz_locations.state%type,
12: province hz_locations.province%type,
13: postal_code hz_locations.postal_code%type,
14: country fnd_territories_vl.territory_short_name%type -- hz_locations.city%type
15: );
16:
17: PROCEDURE get_default_remit_to(
18: p_remit_to_address_id OUT NOCOPY

Line 25: hz_locations.state%type,

21: );
22:
23: PROCEDURE get_remit_to_address(
24: p_match_state IN
25: hz_locations.state%type,
26: p_match_country IN
27: hz_locations.country%type,
28: p_match_postal_code IN
29: hz_locations.postal_code%type,

Line 27: hz_locations.country%type,

23: PROCEDURE get_remit_to_address(
24: p_match_state IN
25: hz_locations.state%type,
26: p_match_country IN
27: hz_locations.country%type,
28: p_match_postal_code IN
29: hz_locations.postal_code%type,
30: p_match_address_id IN
31: NUMBER,

Line 29: hz_locations.postal_code%type,

25: hz_locations.state%type,
26: p_match_country IN
27: hz_locations.country%type,
28: p_match_postal_code IN
29: hz_locations.postal_code%type,
30: p_match_address_id IN
31: NUMBER,
32: p_match_site_use_id IN
33: NUMBER,

Line 41: p_state IN hz_locations.state%type,

37: address_rec_type
38: );
39:
40: PROCEDURE get_remit_to_default(
41: p_state IN hz_locations.state%type,
42: p_postal_code IN hz_locations.postal_code%type,
43: p_country IN hz_locations.country%type,
44: p_address_id OUT NOCOPY NUMBER,
45: p_address1 OUT NOCOPY hz_locations.address1%type,

Line 42: p_postal_code IN hz_locations.postal_code%type,

38: );
39:
40: PROCEDURE get_remit_to_default(
41: p_state IN hz_locations.state%type,
42: p_postal_code IN hz_locations.postal_code%type,
43: p_country IN hz_locations.country%type,
44: p_address_id OUT NOCOPY NUMBER,
45: p_address1 OUT NOCOPY hz_locations.address1%type,
46: p_address2 OUT NOCOPY hz_locations.address2%type,

Line 43: p_country IN hz_locations.country%type,

39:
40: PROCEDURE get_remit_to_default(
41: p_state IN hz_locations.state%type,
42: p_postal_code IN hz_locations.postal_code%type,
43: p_country IN hz_locations.country%type,
44: p_address_id OUT NOCOPY NUMBER,
45: p_address1 OUT NOCOPY hz_locations.address1%type,
46: p_address2 OUT NOCOPY hz_locations.address2%type,
47: p_address3 OUT NOCOPY varchar2,

Line 45: p_address1 OUT NOCOPY hz_locations.address1%type,

41: p_state IN hz_locations.state%type,
42: p_postal_code IN hz_locations.postal_code%type,
43: p_country IN hz_locations.country%type,
44: p_address_id OUT NOCOPY NUMBER,
45: p_address1 OUT NOCOPY hz_locations.address1%type,
46: p_address2 OUT NOCOPY hz_locations.address2%type,
47: p_address3 OUT NOCOPY varchar2,
48: p_concatenated_address OUT NOCOPY varchar2
49: );

Line 46: p_address2 OUT NOCOPY hz_locations.address2%type,

42: p_postal_code IN hz_locations.postal_code%type,
43: p_country IN hz_locations.country%type,
44: p_address_id OUT NOCOPY NUMBER,
45: p_address1 OUT NOCOPY hz_locations.address1%type,
46: p_address2 OUT NOCOPY hz_locations.address2%type,
47: p_address3 OUT NOCOPY varchar2,
48: p_concatenated_address OUT NOCOPY varchar2
49: );
50: