1: PACKAGE BODY pos_hz_party_bo_pkg AS
2: /* $Header: POSSPPAB.pls 120.1 2010/11/25 12:11:15 puppulur noship $ */
3: PROCEDURE get_hz_party_bo(p_api_version IN NUMBER DEFAULT NULL,
4: p_init_msg_list IN VARCHAR2 DEFAULT NULL,
5: p_party_id IN NUMBER,
2: /* $Header: POSSPPAB.pls 120.1 2010/11/25 12:11:15 puppulur noship $ */
3: PROCEDURE get_hz_party_bo(p_api_version IN NUMBER DEFAULT NULL,
4: p_init_msg_list IN VARCHAR2 DEFAULT NULL,
5: p_party_id IN NUMBER,
6: x_hz_party_bo OUT NOCOPY pos_hz_party_bo,
7: x_return_status OUT NOCOPY VARCHAR2,
8: x_msg_count OUT NOCOPY NUMBER,
9: x_msg_data OUT NOCOPY VARCHAR2) IS
10:
7: x_return_status OUT NOCOPY VARCHAR2,
8: x_msg_count OUT NOCOPY NUMBER,
9: x_msg_data OUT NOCOPY VARCHAR2) IS
10:
11: l_pos_hz_party_bo pos_hz_party_bo;
12:
13: BEGIN
14: SELECT pos_hz_party_bo(party_id,
15: party_number,
10:
11: l_pos_hz_party_bo pos_hz_party_bo;
12:
13: BEGIN
14: SELECT pos_hz_party_bo(party_id,
15: party_number,
16: party_name,
17: party_type,
18: validated_flag,
149: person_bo_version,
150: org_bo_version,
151: person_cust_bo_version,
152: org_cust_bo_version)
153: INTO l_pos_hz_party_bo
154: FROM hz_parties
155: WHERE party_id = p_party_id;
156:
157: x_hz_party_bo := l_pos_hz_party_bo;
153: INTO l_pos_hz_party_bo
154: FROM hz_parties
155: WHERE party_id = p_party_id;
156:
157: x_hz_party_bo := l_pos_hz_party_bo;
158:
159: EXCEPTION
160: WHEN no_data_found THEN
161: x_return_status := fnd_api.g_ret_sts_error;
167: x_msg_count := 1;
168:
169: END get_hz_party_bo;
170:
171: END pos_hz_party_bo_pkg;