[Home] [Help]
1: PACKAGE BODY pos_hz_location_bo_pkg AS
2: /* $Header: POSSPLOCB.pls 120.1 2010/11/25 12:10:26 puppulur noship $ */
3: /*#
4: * Use this routine to get hz locations bo
5: * @param p_api_version The version of API
18: p_init_msg_list IN VARCHAR2 DEFAULT NULL,
19: p_party_id IN NUMBER,
20: p_orig_system IN VARCHAR2,
21: p_orig_system_reference IN VARCHAR2,
22: x_hz_location_bo OUT NOCOPY pos_hz_location_bo_tbl,
23: x_return_status OUT NOCOPY VARCHAR2,
24: x_msg_count OUT NOCOPY NUMBER,
25: x_msg_data OUT NOCOPY VARCHAR2) IS
26:
23: x_return_status OUT NOCOPY VARCHAR2,
24: x_msg_count OUT NOCOPY NUMBER,
25: x_msg_data OUT NOCOPY VARCHAR2) IS
26:
27: l_pos_hz_location_bo pos_hz_location_bo_tbl;
28:
29: BEGIN
30:
31: SELECT pos_hz_location_bo(hz.location_id,
27: l_pos_hz_location_bo pos_hz_location_bo_tbl;
28:
29: BEGIN
30:
31: SELECT pos_hz_location_bo(hz.location_id,
32: hz.last_update_date,
33: hz.last_updated_by,
34: hz.creation_date,
35: hz.created_by,
141: hz.validation_status_code,
142: hz.date_validated,
143: hz.do_not_validate_flag,
144: NULL)
145: BULK COLLECT INTO l_pos_hz_location_bo
146: FROM hz_locations hz,
147: ap_suppliers ap,
148: ap_supplier_sites_all ss
149: WHERE ap.party_id = p_party_id
149: WHERE ap.party_id = p_party_id
150: AND ss.vendor_id = ap.vendor_id
151: AND hz.location_id = ss.location_id;
152:
153: x_hz_location_bo := l_pos_hz_location_bo;
154:
155: EXCEPTION
156: WHEN fnd_api.g_exc_error THEN
157:
188: PROCEDURE create_hz_location_bo(p_api_version IN NUMBER DEFAULT NULL,
189: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
190: p_orig_system IN VARCHAR2,
191: p_orig_system_reference IN VARCHAR2,
192: p_hz_location_bo IN pos_hz_location_bo,
193: p_create_update_flag IN VARCHAR2,
194: x_location_id OUT NOCOPY NUMBER,
195: x_object_version_number OUT NOCOPY NUMBER,
196: x_return_status OUT NOCOPY VARCHAR2,
350: fnd_msg_pub.count_and_get(p_count => x_msg_count,
351: p_data => x_msg_data);
352: END update_hz_location_bo;
353: */
354: END pos_hz_location_bo_pkg;