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,
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
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,
19 last_updated_by,
20 creation_date,
21 last_update_login,
22 request_id,
23 program_application_id,
24 created_by,
25 last_update_date,
26 program_id,
27 program_update_date,
28 wh_update_date,
29 attribute_category,
30 attribute1,
31 attribute2,
32 attribute3,
33 attribute4,
34 attribute5,
35 attribute6,
36 attribute7,
37 attribute8,
38 attribute9,
39 attribute10,
40 attribute11,
41 attribute12,
42 attribute13,
43 attribute14,
44 attribute15,
45 attribute16,
46 attribute17,
47 attribute18,
48 attribute19,
49 attribute20,
50 attribute21,
51 attribute22,
52 attribute23,
53 attribute24,
54 global_attribute_category,
55 global_attribute1,
56 global_attribute2,
57 global_attribute4,
58 global_attribute3,
59 global_attribute5,
60 global_attribute6,
61 global_attribute7,
62 global_attribute8,
63 global_attribute9,
64 global_attribute10,
65 global_attribute11,
66 global_attribute12,
67 global_attribute13,
68 global_attribute14,
69 global_attribute15,
70 global_attribute16,
71 global_attribute17,
72 global_attribute18,
73 global_attribute19,
74 global_attribute20,
75 orig_system_reference,
76 sic_code,
77 hq_branch_ind,
78 customer_key,
79 tax_reference,
80 jgzz_fiscal_code,
81 duns_number,
82 tax_name,
83 person_pre_name_adjunct,
84 person_first_name,
85 person_middle_name,
86 person_last_name,
87 person_name_suffix,
88 person_title,
89 person_academic_title,
90 person_previous_last_name,
91 known_as,
92 person_iden_type,
93 person_identifier,
94 group_type,
95 country,
96 address1,
97 address2,
98 address3,
99 address4,
100 city,
101 postal_code,
102 state,
103 province,
104 status,
105 county,
106 sic_code_type,
107 total_num_of_orders,
108 total_ordered_amount,
109 last_ordered_date,
110 url,
111 email_address,
112 do_not_mail_flag,
113 analysis_fy,
114 fiscal_yearend_month,
115 employees_total,
116 curr_fy_potential_revenue,
117 next_fy_potential_revenue,
118 year_established,
119 gsa_indicator_flag,
120 mission_statement,
121 organization_name_phonetic,
122 person_first_name_phonetic,
123 person_last_name_phonetic,
124 language_name,
125 category_code,
126 reference_use_flag,
127 third_party_flag,
128 competitor_flag,
129 salutation,
130 known_as2,
131 known_as3,
132 known_as4,
133 known_as5,
134 duns_number_c,
135 object_version_number,
136 created_by_module,
137 application_id,
138 primary_phone_contact_pt_id,
139 primary_phone_purpose,
140 primary_phone_line_type,
141 primary_phone_country_code,
142 primary_phone_area_code,
143 primary_phone_number,
144 primary_phone_extension,
145 certification_level,
146 cert_reason_code,
147 preferred_contact_method,
148 home_country,
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;
158
159 EXCEPTION
160 WHEN no_data_found THEN
161 x_return_status := fnd_api.g_ret_sts_error;
162 x_msg_data := SQLCODE || SQLERRM;
163 x_msg_count := 1;
164 WHEN OTHERS THEN
165 x_return_status := fnd_api.g_ret_sts_unexp_error;
166 x_msg_data := SQLCODE || SQLERRM;
167 x_msg_count := 1;
168
169 END get_hz_party_bo;
170
171 END pos_hz_party_bo_pkg;
|
|
|