APPS.IBY_ADDRESS_PKG dependencies on HZ_LOCATIONS

Line 14: procedure createAddress( i_address1 hz_locations.address1%type,

10: ** i_state, i_country, i_postalcode.
11: ** Out : io_addressid.
12: **
13: */
14: procedure createAddress( i_address1 hz_locations.address1%type,
15: i_address2 hz_locations.address2%type,
16: i_address3 hz_locations.address3%type,
17: i_city hz_locations.city%type,
18: i_county hz_locations.county%type,

Line 15: i_address2 hz_locations.address2%type,

11: ** Out : io_addressid.
12: **
13: */
14: procedure createAddress( i_address1 hz_locations.address1%type,
15: i_address2 hz_locations.address2%type,
16: i_address3 hz_locations.address3%type,
17: i_city hz_locations.city%type,
18: i_county hz_locations.county%type,
19: i_state hz_locations.state%type,

Line 16: i_address3 hz_locations.address3%type,

12: **
13: */
14: procedure createAddress( i_address1 hz_locations.address1%type,
15: i_address2 hz_locations.address2%type,
16: i_address3 hz_locations.address3%type,
17: i_city hz_locations.city%type,
18: i_county hz_locations.county%type,
19: i_state hz_locations.state%type,
20: i_country hz_locations.country%type,

Line 17: i_city hz_locations.city%type,

13: */
14: procedure createAddress( i_address1 hz_locations.address1%type,
15: i_address2 hz_locations.address2%type,
16: i_address3 hz_locations.address3%type,
17: i_city hz_locations.city%type,
18: i_county hz_locations.county%type,
19: i_state hz_locations.state%type,
20: i_country hz_locations.country%type,
21: i_postalcode hz_locations.postal_code%type,

Line 18: i_county hz_locations.county%type,

14: procedure createAddress( i_address1 hz_locations.address1%type,
15: i_address2 hz_locations.address2%type,
16: i_address3 hz_locations.address3%type,
17: i_city hz_locations.city%type,
18: i_county hz_locations.county%type,
19: i_state hz_locations.state%type,
20: i_country hz_locations.country%type,
21: i_postalcode hz_locations.postal_code%type,
22: o_addressid out nocopy hz_locations.location_id%type)

Line 19: i_state hz_locations.state%type,

15: i_address2 hz_locations.address2%type,
16: i_address3 hz_locations.address3%type,
17: i_city hz_locations.city%type,
18: i_county hz_locations.county%type,
19: i_state hz_locations.state%type,
20: i_country hz_locations.country%type,
21: i_postalcode hz_locations.postal_code%type,
22: o_addressid out nocopy hz_locations.location_id%type)
23: is

Line 20: i_country hz_locations.country%type,

16: i_address3 hz_locations.address3%type,
17: i_city hz_locations.city%type,
18: i_county hz_locations.county%type,
19: i_state hz_locations.state%type,
20: i_country hz_locations.country%type,
21: i_postalcode hz_locations.postal_code%type,
22: o_addressid out nocopy hz_locations.location_id%type)
23: is
24:

Line 21: i_postalcode hz_locations.postal_code%type,

17: i_city hz_locations.city%type,
18: i_county hz_locations.county%type,
19: i_state hz_locations.state%type,
20: i_country hz_locations.country%type,
21: i_postalcode hz_locations.postal_code%type,
22: o_addressid out nocopy hz_locations.location_id%type)
23: is
24:
25: p_api_version NUMBER := 1;

Line 22: o_addressid out nocopy hz_locations.location_id%type)

18: i_county hz_locations.county%type,
19: i_state hz_locations.state%type,
20: i_country hz_locations.country%type,
21: i_postalcode hz_locations.postal_code%type,
22: o_addressid out nocopy hz_locations.location_id%type)
23: is
24:
25: p_api_version NUMBER := 1;
26: p_init_msg_list VARCHAR2(1) := fnd_api.G_TRUE;

Line 101: ** Purpose: modifies the entry in the hz_locations table that matches addressid

97: o_addressid := l_location_id;
98: end createAddress;
99: /*
100: ** Function: modAddress
101: ** Purpose: modifies the entry in the hz_locations table that matches addressid
102: ** passed with the values specified.
103: ** Parameters:
104: **
105: ** In : i_addressid, i_address1, i_address2, i_address3, i_city,

Line 110: procedure modAddress(i_addressid hz_locations.location_id%type,

106: ** i_county, i_state, i_country, i_postalcode.
107: ** Out : None.
108: **
109: */
110: procedure modAddress(i_addressid hz_locations.location_id%type,
111: i_address1 hz_locations.address1%type,
112: i_address2 hz_locations.address2%type,
113: i_address3 hz_locations.address3%type,
114: i_city hz_locations.city%type,

Line 111: i_address1 hz_locations.address1%type,

107: ** Out : None.
108: **
109: */
110: procedure modAddress(i_addressid hz_locations.location_id%type,
111: i_address1 hz_locations.address1%type,
112: i_address2 hz_locations.address2%type,
113: i_address3 hz_locations.address3%type,
114: i_city hz_locations.city%type,
115: i_county hz_locations.county%type,

Line 112: i_address2 hz_locations.address2%type,

108: **
109: */
110: procedure modAddress(i_addressid hz_locations.location_id%type,
111: i_address1 hz_locations.address1%type,
112: i_address2 hz_locations.address2%type,
113: i_address3 hz_locations.address3%type,
114: i_city hz_locations.city%type,
115: i_county hz_locations.county%type,
116: i_state hz_locations.state%type,

Line 113: i_address3 hz_locations.address3%type,

109: */
110: procedure modAddress(i_addressid hz_locations.location_id%type,
111: i_address1 hz_locations.address1%type,
112: i_address2 hz_locations.address2%type,
113: i_address3 hz_locations.address3%type,
114: i_city hz_locations.city%type,
115: i_county hz_locations.county%type,
116: i_state hz_locations.state%type,
117: i_country hz_locations.country%type,

Line 114: i_city hz_locations.city%type,

110: procedure modAddress(i_addressid hz_locations.location_id%type,
111: i_address1 hz_locations.address1%type,
112: i_address2 hz_locations.address2%type,
113: i_address3 hz_locations.address3%type,
114: i_city hz_locations.city%type,
115: i_county hz_locations.county%type,
116: i_state hz_locations.state%type,
117: i_country hz_locations.country%type,
118: i_postalcode hz_locations.postal_code%type)

Line 115: i_county hz_locations.county%type,

111: i_address1 hz_locations.address1%type,
112: i_address2 hz_locations.address2%type,
113: i_address3 hz_locations.address3%type,
114: i_city hz_locations.city%type,
115: i_county hz_locations.county%type,
116: i_state hz_locations.state%type,
117: i_country hz_locations.country%type,
118: i_postalcode hz_locations.postal_code%type)
119: is

Line 116: i_state hz_locations.state%type,

112: i_address2 hz_locations.address2%type,
113: i_address3 hz_locations.address3%type,
114: i_city hz_locations.city%type,
115: i_county hz_locations.county%type,
116: i_state hz_locations.state%type,
117: i_country hz_locations.country%type,
118: i_postalcode hz_locations.postal_code%type)
119: is
120: p_api_version NUMBER := 1;

Line 117: i_country hz_locations.country%type,

113: i_address3 hz_locations.address3%type,
114: i_city hz_locations.city%type,
115: i_county hz_locations.county%type,
116: i_state hz_locations.state%type,
117: i_country hz_locations.country%type,
118: i_postalcode hz_locations.postal_code%type)
119: is
120: p_api_version NUMBER := 1;
121: p_init_msg_list VARCHAR2(1) := fnd_api.G_TRUE;

Line 118: i_postalcode hz_locations.postal_code%type)

114: i_city hz_locations.city%type,
115: i_county hz_locations.county%type,
116: i_state hz_locations.state%type,
117: i_country hz_locations.country%type,
118: i_postalcode hz_locations.postal_code%type)
119: is
120: p_api_version NUMBER := 1;
121: p_init_msg_list VARCHAR2(1) := fnd_api.G_TRUE;
122: p_commit VARCHAR2(1) := fnd_api.G_FALSE;

Line 156: from hz_locations

152: -- for the OVN. we are assuming that no body has changed the
153: -- hz_location record since the user for our transaction read
154: -- the record. otherwise the change will simply be overwritten
155: select last_update_date, object_version_number into p_last_update_date, l_ovn
156: from hz_locations
157: where location_id = l_hz_location_v2_rec.location_id;
158:
159: hz_location_v2pub.update_location(
160: p_location_rec => l_hz_location_v2_rec,