APPS.PV_LOCATOR dependencies on HZ_LOCATIONS

Line 10: LOCATION_ID HZ_LOCATIONS.LOCATION_ID%TYPE,

6: TYPE party_address_rec_type IS RECORD
7: (
8: PARTY_RELATION_ID HZ_PARTIES.PARTY_ID%TYPE,
9: PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE,
10: LOCATION_ID HZ_LOCATIONS.LOCATION_ID%TYPE,
11: ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE,
12: ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE,
13: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,
14: CITY HZ_LOCATIONS.CITY%TYPE,

Line 11: ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE,

7: (
8: PARTY_RELATION_ID HZ_PARTIES.PARTY_ID%TYPE,
9: PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE,
10: LOCATION_ID HZ_LOCATIONS.LOCATION_ID%TYPE,
11: ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE,
12: ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE,
13: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,
14: CITY HZ_LOCATIONS.CITY%TYPE,
15: STATE HZ_LOCATIONS.STATE%TYPE,

Line 12: ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE,

8: PARTY_RELATION_ID HZ_PARTIES.PARTY_ID%TYPE,
9: PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE,
10: LOCATION_ID HZ_LOCATIONS.LOCATION_ID%TYPE,
11: ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE,
12: ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE,
13: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,
14: CITY HZ_LOCATIONS.CITY%TYPE,
15: STATE HZ_LOCATIONS.STATE%TYPE,
16: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,

Line 13: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,

9: PARTY_NAME HZ_PARTIES.PARTY_NAME%TYPE,
10: LOCATION_ID HZ_LOCATIONS.LOCATION_ID%TYPE,
11: ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE,
12: ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE,
13: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,
14: CITY HZ_LOCATIONS.CITY%TYPE,
15: STATE HZ_LOCATIONS.STATE%TYPE,
16: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
17: POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE,

Line 14: CITY HZ_LOCATIONS.CITY%TYPE,

10: LOCATION_ID HZ_LOCATIONS.LOCATION_ID%TYPE,
11: ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE,
12: ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE,
13: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,
14: CITY HZ_LOCATIONS.CITY%TYPE,
15: STATE HZ_LOCATIONS.STATE%TYPE,
16: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
17: POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE,
18: DISTANCE NUMBER,

Line 15: STATE HZ_LOCATIONS.STATE%TYPE,

11: ADDRESS_LINE1 HZ_LOCATIONS.ADDRESS1%TYPE,
12: ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE,
13: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,
14: CITY HZ_LOCATIONS.CITY%TYPE,
15: STATE HZ_LOCATIONS.STATE%TYPE,
16: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
17: POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE,
18: DISTANCE NUMBER,
19: DISTANCE_UNIT VARCHAR2(10)

Line 16: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,

12: ADDRESS_LINE2 HZ_LOCATIONS.ADDRESS2%TYPE,
13: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,
14: CITY HZ_LOCATIONS.CITY%TYPE,
15: STATE HZ_LOCATIONS.STATE%TYPE,
16: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
17: POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE,
18: DISTANCE NUMBER,
19: DISTANCE_UNIT VARCHAR2(10)
20: );

Line 17: POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE,

13: ADDRESS_LINE3 HZ_LOCATIONS.ADDRESS3%TYPE,
14: CITY HZ_LOCATIONS.CITY%TYPE,
15: STATE HZ_LOCATIONS.STATE%TYPE,
16: COUNTRY HZ_LOCATIONS.COUNTRY%TYPE,
17: POSTAL_CODE HZ_LOCATIONS.POSTAL_CODE%TYPE,
18: DISTANCE NUMBER,
19: DISTANCE_UNIT VARCHAR2(10)
20: );
21:

Line 122: ,p_customer_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE

118: p_api_version IN NUMBER
119: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
120: ,p_commit IN VARCHAR2 := FND_API.g_false
121: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
122: ,p_customer_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE
123: ,p_customer_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE
124: ,p_customer_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE
125: ,p_customer_city IN HZ_LOCATIONS.CITY%TYPE
126: ,p_customer_state IN HZ_LOCATIONS.STATE%TYPE

Line 123: ,p_customer_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE

119: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
120: ,p_commit IN VARCHAR2 := FND_API.g_false
121: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
122: ,p_customer_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE
123: ,p_customer_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE
124: ,p_customer_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE
125: ,p_customer_city IN HZ_LOCATIONS.CITY%TYPE
126: ,p_customer_state IN HZ_LOCATIONS.STATE%TYPE
127: ,p_customer_country IN HZ_LOCATIONS.COUNTRY%TYPE

Line 124: ,p_customer_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE

120: ,p_commit IN VARCHAR2 := FND_API.g_false
121: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
122: ,p_customer_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE
123: ,p_customer_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE
124: ,p_customer_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE
125: ,p_customer_city IN HZ_LOCATIONS.CITY%TYPE
126: ,p_customer_state IN HZ_LOCATIONS.STATE%TYPE
127: ,p_customer_country IN HZ_LOCATIONS.COUNTRY%TYPE
128: ,p_customer_postalcode IN HZ_LOCATIONS.POSTAL_CODE%TYPE

Line 125: ,p_customer_city IN HZ_LOCATIONS.CITY%TYPE

121: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
122: ,p_customer_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE
123: ,p_customer_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE
124: ,p_customer_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE
125: ,p_customer_city IN HZ_LOCATIONS.CITY%TYPE
126: ,p_customer_state IN HZ_LOCATIONS.STATE%TYPE
127: ,p_customer_country IN HZ_LOCATIONS.COUNTRY%TYPE
128: ,p_customer_postalcode IN HZ_LOCATIONS.POSTAL_CODE%TYPE
129: ,p_customer_lattitude IN VARCHAR2

Line 126: ,p_customer_state IN HZ_LOCATIONS.STATE%TYPE

122: ,p_customer_address1 IN HZ_LOCATIONS.ADDRESS1%TYPE
123: ,p_customer_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE
124: ,p_customer_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE
125: ,p_customer_city IN HZ_LOCATIONS.CITY%TYPE
126: ,p_customer_state IN HZ_LOCATIONS.STATE%TYPE
127: ,p_customer_country IN HZ_LOCATIONS.COUNTRY%TYPE
128: ,p_customer_postalcode IN HZ_LOCATIONS.POSTAL_CODE%TYPE
129: ,p_customer_lattitude IN VARCHAR2
130: ,p_customer_longitude IN VARCHAR2

Line 127: ,p_customer_country IN HZ_LOCATIONS.COUNTRY%TYPE

123: ,p_customer_address2 IN HZ_LOCATIONS.ADDRESS2%TYPE
124: ,p_customer_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE
125: ,p_customer_city IN HZ_LOCATIONS.CITY%TYPE
126: ,p_customer_state IN HZ_LOCATIONS.STATE%TYPE
127: ,p_customer_country IN HZ_LOCATIONS.COUNTRY%TYPE
128: ,p_customer_postalcode IN HZ_LOCATIONS.POSTAL_CODE%TYPE
129: ,p_customer_lattitude IN VARCHAR2
130: ,p_customer_longitude IN VARCHAR2
131: ,p_max_no_partners IN NUMBER

Line 128: ,p_customer_postalcode IN HZ_LOCATIONS.POSTAL_CODE%TYPE

124: ,p_customer_address3 IN HZ_LOCATIONS.ADDRESS3%TYPE
125: ,p_customer_city IN HZ_LOCATIONS.CITY%TYPE
126: ,p_customer_state IN HZ_LOCATIONS.STATE%TYPE
127: ,p_customer_country IN HZ_LOCATIONS.COUNTRY%TYPE
128: ,p_customer_postalcode IN HZ_LOCATIONS.POSTAL_CODE%TYPE
129: ,p_customer_lattitude IN VARCHAR2
130: ,p_customer_longitude IN VARCHAR2
131: ,p_max_no_partners IN NUMBER
132: ,p_distance IN NUMBER