DBA Data[Home] [Help]

APPS.IBY_ADDRESS_PKG dependencies on HZ_LOCATION_V2PUB

Line 28: l_hz_location_v2_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;

24:
25: p_api_version NUMBER := 1;
26: p_init_msg_list VARCHAR2(1) := fnd_api.G_TRUE;
27: p_commit VARCHAR2(1) := fnd_api.G_FALSE;
28: l_hz_location_v2_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
29: --location_rec hz_location_pub.location_rec_type;
30: l_location_id number;
31: msg_txt varchar2(2000);
32: l_return_status varchar2(100);

Line 52: hz_location_v2pub.create_location(

48: l_hz_location_v2_rec.created_by_module := 'IBY';
49:
50: --dbms_output.put_line('Before hz_location.create ');
51:
52: hz_location_v2pub.create_location(
53: p_location_rec => l_hz_location_v2_rec,
54: x_location_id => l_location_id,
55: x_return_status => l_return_status,
56: x_msg_count => l_msg_count,

Line 124: l_hz_location_v2_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;

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;
123: -- location_rec hz_location_pub.location_rec_type;
124: l_hz_location_v2_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
125: l_ovn NUMBER;
126: l_location_id number;
127: msg_txt varchar2(2000);
128: l_return_status varchar2(100);

Line 159: hz_location_v2pub.update_location(

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,
161: p_object_version_number => l_ovn,
162: x_return_status => l_return_status,
163: x_msg_count => l_msg_count,