[Home] [Help]
1: PACKAGE BODY pos_supplier_bo_pkg AS
2: /* $Header: POSSPBOB.pls 120.2.12020000.3 2013/04/08 21:15:30 riren ship $ */
3: PROCEDURE assign_organization(p_hz_organization_bo IN hz_organization_bo,
4: p_pos_organization_bo OUT NOCOPY pos_organization_bo) AS
5:
6: l_contact_objs pos_org_contact_bo_tbl := pos_org_contact_bo_tbl();
7: l_contact_objs_temp hz_org_contact_bo_tbl := hz_org_contact_bo_tbl();
11: l_organization pos_organization_bo;
12:
13: BEGIN
14:
15: l_contact_objs_temp := p_hz_organization_bo.contact_objs;
16: IF l_contact_objs_temp.count > 0 THEN -- Bug 14162504: Check if the collection is empty.
17: FOR i IN l_contact_objs_temp.first .. l_contact_objs_temp.last LOOP
18: l_contact_objs.extend(1);
19: l_party_site_temp :=l_contact_objs_temp(i).party_site_objs;
143: l_party_site_objs_1.delete;
144: END LOOP;
145: END IF;
146:
147: IF p_hz_organization_bo.party_site_objs.count > 0 THEN -- Bug 14699689: Check if the collection is empty.
148: FOR j IN p_hz_organization_bo.party_site_objs.first..p_hz_organization_bo.party_site_objs.last LOOP
149: l_party_site_objs_2.extend(1);
150: l_party_site_objs_2(j) := pos_party_site_bo(p_hz_organization_bo.party_site_objs(j).action_type,
151: p_hz_organization_bo.party_site_objs(j).common_obj_id,
144: END LOOP;
145: END IF;
146:
147: IF p_hz_organization_bo.party_site_objs.count > 0 THEN -- Bug 14699689: Check if the collection is empty.
148: FOR j IN p_hz_organization_bo.party_site_objs.first..p_hz_organization_bo.party_site_objs.last LOOP
149: l_party_site_objs_2.extend(1);
150: l_party_site_objs_2(j) := pos_party_site_bo(p_hz_organization_bo.party_site_objs(j).action_type,
151: p_hz_organization_bo.party_site_objs(j).common_obj_id,
152: p_hz_organization_bo.party_site_objs(j).party_site_id,
146:
147: IF p_hz_organization_bo.party_site_objs.count > 0 THEN -- Bug 14699689: Check if the collection is empty.
148: FOR j IN p_hz_organization_bo.party_site_objs.first..p_hz_organization_bo.party_site_objs.last LOOP
149: l_party_site_objs_2.extend(1);
150: l_party_site_objs_2(j) := pos_party_site_bo(p_hz_organization_bo.party_site_objs(j).action_type,
151: p_hz_organization_bo.party_site_objs(j).common_obj_id,
152: p_hz_organization_bo.party_site_objs(j).party_site_id,
153: p_hz_organization_bo.party_site_objs(j).orig_system,
154: p_hz_organization_bo.party_site_objs(j).orig_system_reference,
147: IF p_hz_organization_bo.party_site_objs.count > 0 THEN -- Bug 14699689: Check if the collection is empty.
148: FOR j IN p_hz_organization_bo.party_site_objs.first..p_hz_organization_bo.party_site_objs.last LOOP
149: l_party_site_objs_2.extend(1);
150: l_party_site_objs_2(j) := pos_party_site_bo(p_hz_organization_bo.party_site_objs(j).action_type,
151: p_hz_organization_bo.party_site_objs(j).common_obj_id,
152: p_hz_organization_bo.party_site_objs(j).party_site_id,
153: p_hz_organization_bo.party_site_objs(j).orig_system,
154: p_hz_organization_bo.party_site_objs(j).orig_system_reference,
155: p_hz_organization_bo.party_site_objs(j).parent_object_type,
148: FOR j IN p_hz_organization_bo.party_site_objs.first..p_hz_organization_bo.party_site_objs.last LOOP
149: l_party_site_objs_2.extend(1);
150: l_party_site_objs_2(j) := pos_party_site_bo(p_hz_organization_bo.party_site_objs(j).action_type,
151: p_hz_organization_bo.party_site_objs(j).common_obj_id,
152: p_hz_organization_bo.party_site_objs(j).party_site_id,
153: p_hz_organization_bo.party_site_objs(j).orig_system,
154: p_hz_organization_bo.party_site_objs(j).orig_system_reference,
155: p_hz_organization_bo.party_site_objs(j).parent_object_type,
156: p_hz_organization_bo.party_site_objs(j).parent_object_id,
149: l_party_site_objs_2.extend(1);
150: l_party_site_objs_2(j) := pos_party_site_bo(p_hz_organization_bo.party_site_objs(j).action_type,
151: p_hz_organization_bo.party_site_objs(j).common_obj_id,
152: p_hz_organization_bo.party_site_objs(j).party_site_id,
153: p_hz_organization_bo.party_site_objs(j).orig_system,
154: p_hz_organization_bo.party_site_objs(j).orig_system_reference,
155: p_hz_organization_bo.party_site_objs(j).parent_object_type,
156: p_hz_organization_bo.party_site_objs(j).parent_object_id,
157: p_hz_organization_bo.party_site_objs(j).party_site_number,
150: l_party_site_objs_2(j) := pos_party_site_bo(p_hz_organization_bo.party_site_objs(j).action_type,
151: p_hz_organization_bo.party_site_objs(j).common_obj_id,
152: p_hz_organization_bo.party_site_objs(j).party_site_id,
153: p_hz_organization_bo.party_site_objs(j).orig_system,
154: p_hz_organization_bo.party_site_objs(j).orig_system_reference,
155: p_hz_organization_bo.party_site_objs(j).parent_object_type,
156: p_hz_organization_bo.party_site_objs(j).parent_object_id,
157: p_hz_organization_bo.party_site_objs(j).party_site_number,
158: p_hz_organization_bo.party_site_objs(j).mailstop,
151: p_hz_organization_bo.party_site_objs(j).common_obj_id,
152: p_hz_organization_bo.party_site_objs(j).party_site_id,
153: p_hz_organization_bo.party_site_objs(j).orig_system,
154: p_hz_organization_bo.party_site_objs(j).orig_system_reference,
155: p_hz_organization_bo.party_site_objs(j).parent_object_type,
156: p_hz_organization_bo.party_site_objs(j).parent_object_id,
157: p_hz_organization_bo.party_site_objs(j).party_site_number,
158: p_hz_organization_bo.party_site_objs(j).mailstop,
159: p_hz_organization_bo.party_site_objs(j).identifying_address_flag,
152: p_hz_organization_bo.party_site_objs(j).party_site_id,
153: p_hz_organization_bo.party_site_objs(j).orig_system,
154: p_hz_organization_bo.party_site_objs(j).orig_system_reference,
155: p_hz_organization_bo.party_site_objs(j).parent_object_type,
156: p_hz_organization_bo.party_site_objs(j).parent_object_id,
157: p_hz_organization_bo.party_site_objs(j).party_site_number,
158: p_hz_organization_bo.party_site_objs(j).mailstop,
159: p_hz_organization_bo.party_site_objs(j).identifying_address_flag,
160: p_hz_organization_bo.party_site_objs(j).status,
153: p_hz_organization_bo.party_site_objs(j).orig_system,
154: p_hz_organization_bo.party_site_objs(j).orig_system_reference,
155: p_hz_organization_bo.party_site_objs(j).parent_object_type,
156: p_hz_organization_bo.party_site_objs(j).parent_object_id,
157: p_hz_organization_bo.party_site_objs(j).party_site_number,
158: p_hz_organization_bo.party_site_objs(j).mailstop,
159: p_hz_organization_bo.party_site_objs(j).identifying_address_flag,
160: p_hz_organization_bo.party_site_objs(j).status,
161: p_hz_organization_bo.party_site_objs(j).party_site_name,
154: p_hz_organization_bo.party_site_objs(j).orig_system_reference,
155: p_hz_organization_bo.party_site_objs(j).parent_object_type,
156: p_hz_organization_bo.party_site_objs(j).parent_object_id,
157: p_hz_organization_bo.party_site_objs(j).party_site_number,
158: p_hz_organization_bo.party_site_objs(j).mailstop,
159: p_hz_organization_bo.party_site_objs(j).identifying_address_flag,
160: p_hz_organization_bo.party_site_objs(j).status,
161: p_hz_organization_bo.party_site_objs(j).party_site_name,
162: p_hz_organization_bo.party_site_objs(j).attribute_category,
155: p_hz_organization_bo.party_site_objs(j).parent_object_type,
156: p_hz_organization_bo.party_site_objs(j).parent_object_id,
157: p_hz_organization_bo.party_site_objs(j).party_site_number,
158: p_hz_organization_bo.party_site_objs(j).mailstop,
159: p_hz_organization_bo.party_site_objs(j).identifying_address_flag,
160: p_hz_organization_bo.party_site_objs(j).status,
161: p_hz_organization_bo.party_site_objs(j).party_site_name,
162: p_hz_organization_bo.party_site_objs(j).attribute_category,
163: p_hz_organization_bo.party_site_objs(j).attribute1,
156: p_hz_organization_bo.party_site_objs(j).parent_object_id,
157: p_hz_organization_bo.party_site_objs(j).party_site_number,
158: p_hz_organization_bo.party_site_objs(j).mailstop,
159: p_hz_organization_bo.party_site_objs(j).identifying_address_flag,
160: p_hz_organization_bo.party_site_objs(j).status,
161: p_hz_organization_bo.party_site_objs(j).party_site_name,
162: p_hz_organization_bo.party_site_objs(j).attribute_category,
163: p_hz_organization_bo.party_site_objs(j).attribute1,
164: p_hz_organization_bo.party_site_objs(j).attribute2,
157: p_hz_organization_bo.party_site_objs(j).party_site_number,
158: p_hz_organization_bo.party_site_objs(j).mailstop,
159: p_hz_organization_bo.party_site_objs(j).identifying_address_flag,
160: p_hz_organization_bo.party_site_objs(j).status,
161: p_hz_organization_bo.party_site_objs(j).party_site_name,
162: p_hz_organization_bo.party_site_objs(j).attribute_category,
163: p_hz_organization_bo.party_site_objs(j).attribute1,
164: p_hz_organization_bo.party_site_objs(j).attribute2,
165: p_hz_organization_bo.party_site_objs(j).attribute3,
158: p_hz_organization_bo.party_site_objs(j).mailstop,
159: p_hz_organization_bo.party_site_objs(j).identifying_address_flag,
160: p_hz_organization_bo.party_site_objs(j).status,
161: p_hz_organization_bo.party_site_objs(j).party_site_name,
162: p_hz_organization_bo.party_site_objs(j).attribute_category,
163: p_hz_organization_bo.party_site_objs(j).attribute1,
164: p_hz_organization_bo.party_site_objs(j).attribute2,
165: p_hz_organization_bo.party_site_objs(j).attribute3,
166: p_hz_organization_bo.party_site_objs(j).attribute4,
159: p_hz_organization_bo.party_site_objs(j).identifying_address_flag,
160: p_hz_organization_bo.party_site_objs(j).status,
161: p_hz_organization_bo.party_site_objs(j).party_site_name,
162: p_hz_organization_bo.party_site_objs(j).attribute_category,
163: p_hz_organization_bo.party_site_objs(j).attribute1,
164: p_hz_organization_bo.party_site_objs(j).attribute2,
165: p_hz_organization_bo.party_site_objs(j).attribute3,
166: p_hz_organization_bo.party_site_objs(j).attribute4,
167: p_hz_organization_bo.party_site_objs(j).attribute5,
160: p_hz_organization_bo.party_site_objs(j).status,
161: p_hz_organization_bo.party_site_objs(j).party_site_name,
162: p_hz_organization_bo.party_site_objs(j).attribute_category,
163: p_hz_organization_bo.party_site_objs(j).attribute1,
164: p_hz_organization_bo.party_site_objs(j).attribute2,
165: p_hz_organization_bo.party_site_objs(j).attribute3,
166: p_hz_organization_bo.party_site_objs(j).attribute4,
167: p_hz_organization_bo.party_site_objs(j).attribute5,
168: p_hz_organization_bo.party_site_objs(j).attribute6,
161: p_hz_organization_bo.party_site_objs(j).party_site_name,
162: p_hz_organization_bo.party_site_objs(j).attribute_category,
163: p_hz_organization_bo.party_site_objs(j).attribute1,
164: p_hz_organization_bo.party_site_objs(j).attribute2,
165: p_hz_organization_bo.party_site_objs(j).attribute3,
166: p_hz_organization_bo.party_site_objs(j).attribute4,
167: p_hz_organization_bo.party_site_objs(j).attribute5,
168: p_hz_organization_bo.party_site_objs(j).attribute6,
169: p_hz_organization_bo.party_site_objs(j).attribute7,
162: p_hz_organization_bo.party_site_objs(j).attribute_category,
163: p_hz_organization_bo.party_site_objs(j).attribute1,
164: p_hz_organization_bo.party_site_objs(j).attribute2,
165: p_hz_organization_bo.party_site_objs(j).attribute3,
166: p_hz_organization_bo.party_site_objs(j).attribute4,
167: p_hz_organization_bo.party_site_objs(j).attribute5,
168: p_hz_organization_bo.party_site_objs(j).attribute6,
169: p_hz_organization_bo.party_site_objs(j).attribute7,
170: p_hz_organization_bo.party_site_objs(j).attribute8,
163: p_hz_organization_bo.party_site_objs(j).attribute1,
164: p_hz_organization_bo.party_site_objs(j).attribute2,
165: p_hz_organization_bo.party_site_objs(j).attribute3,
166: p_hz_organization_bo.party_site_objs(j).attribute4,
167: p_hz_organization_bo.party_site_objs(j).attribute5,
168: p_hz_organization_bo.party_site_objs(j).attribute6,
169: p_hz_organization_bo.party_site_objs(j).attribute7,
170: p_hz_organization_bo.party_site_objs(j).attribute8,
171: p_hz_organization_bo.party_site_objs(j).attribute9,
164: p_hz_organization_bo.party_site_objs(j).attribute2,
165: p_hz_organization_bo.party_site_objs(j).attribute3,
166: p_hz_organization_bo.party_site_objs(j).attribute4,
167: p_hz_organization_bo.party_site_objs(j).attribute5,
168: p_hz_organization_bo.party_site_objs(j).attribute6,
169: p_hz_organization_bo.party_site_objs(j).attribute7,
170: p_hz_organization_bo.party_site_objs(j).attribute8,
171: p_hz_organization_bo.party_site_objs(j).attribute9,
172: p_hz_organization_bo.party_site_objs(j).attribute10,
165: p_hz_organization_bo.party_site_objs(j).attribute3,
166: p_hz_organization_bo.party_site_objs(j).attribute4,
167: p_hz_organization_bo.party_site_objs(j).attribute5,
168: p_hz_organization_bo.party_site_objs(j).attribute6,
169: p_hz_organization_bo.party_site_objs(j).attribute7,
170: p_hz_organization_bo.party_site_objs(j).attribute8,
171: p_hz_organization_bo.party_site_objs(j).attribute9,
172: p_hz_organization_bo.party_site_objs(j).attribute10,
173: p_hz_organization_bo.party_site_objs(j).attribute11,
166: p_hz_organization_bo.party_site_objs(j).attribute4,
167: p_hz_organization_bo.party_site_objs(j).attribute5,
168: p_hz_organization_bo.party_site_objs(j).attribute6,
169: p_hz_organization_bo.party_site_objs(j).attribute7,
170: p_hz_organization_bo.party_site_objs(j).attribute8,
171: p_hz_organization_bo.party_site_objs(j).attribute9,
172: p_hz_organization_bo.party_site_objs(j).attribute10,
173: p_hz_organization_bo.party_site_objs(j).attribute11,
174: p_hz_organization_bo.party_site_objs(j).attribute12,
167: p_hz_organization_bo.party_site_objs(j).attribute5,
168: p_hz_organization_bo.party_site_objs(j).attribute6,
169: p_hz_organization_bo.party_site_objs(j).attribute7,
170: p_hz_organization_bo.party_site_objs(j).attribute8,
171: p_hz_organization_bo.party_site_objs(j).attribute9,
172: p_hz_organization_bo.party_site_objs(j).attribute10,
173: p_hz_organization_bo.party_site_objs(j).attribute11,
174: p_hz_organization_bo.party_site_objs(j).attribute12,
175: p_hz_organization_bo.party_site_objs(j).attribute13,
168: p_hz_organization_bo.party_site_objs(j).attribute6,
169: p_hz_organization_bo.party_site_objs(j).attribute7,
170: p_hz_organization_bo.party_site_objs(j).attribute8,
171: p_hz_organization_bo.party_site_objs(j).attribute9,
172: p_hz_organization_bo.party_site_objs(j).attribute10,
173: p_hz_organization_bo.party_site_objs(j).attribute11,
174: p_hz_organization_bo.party_site_objs(j).attribute12,
175: p_hz_organization_bo.party_site_objs(j).attribute13,
176: p_hz_organization_bo.party_site_objs(j).attribute14,
169: p_hz_organization_bo.party_site_objs(j).attribute7,
170: p_hz_organization_bo.party_site_objs(j).attribute8,
171: p_hz_organization_bo.party_site_objs(j).attribute9,
172: p_hz_organization_bo.party_site_objs(j).attribute10,
173: p_hz_organization_bo.party_site_objs(j).attribute11,
174: p_hz_organization_bo.party_site_objs(j).attribute12,
175: p_hz_organization_bo.party_site_objs(j).attribute13,
176: p_hz_organization_bo.party_site_objs(j).attribute14,
177: p_hz_organization_bo.party_site_objs(j).attribute15,
170: p_hz_organization_bo.party_site_objs(j).attribute8,
171: p_hz_organization_bo.party_site_objs(j).attribute9,
172: p_hz_organization_bo.party_site_objs(j).attribute10,
173: p_hz_organization_bo.party_site_objs(j).attribute11,
174: p_hz_organization_bo.party_site_objs(j).attribute12,
175: p_hz_organization_bo.party_site_objs(j).attribute13,
176: p_hz_organization_bo.party_site_objs(j).attribute14,
177: p_hz_organization_bo.party_site_objs(j).attribute15,
178: p_hz_organization_bo.party_site_objs(j).attribute16,
171: p_hz_organization_bo.party_site_objs(j).attribute9,
172: p_hz_organization_bo.party_site_objs(j).attribute10,
173: p_hz_organization_bo.party_site_objs(j).attribute11,
174: p_hz_organization_bo.party_site_objs(j).attribute12,
175: p_hz_organization_bo.party_site_objs(j).attribute13,
176: p_hz_organization_bo.party_site_objs(j).attribute14,
177: p_hz_organization_bo.party_site_objs(j).attribute15,
178: p_hz_organization_bo.party_site_objs(j).attribute16,
179: p_hz_organization_bo.party_site_objs(j).attribute17,
172: p_hz_organization_bo.party_site_objs(j).attribute10,
173: p_hz_organization_bo.party_site_objs(j).attribute11,
174: p_hz_organization_bo.party_site_objs(j).attribute12,
175: p_hz_organization_bo.party_site_objs(j).attribute13,
176: p_hz_organization_bo.party_site_objs(j).attribute14,
177: p_hz_organization_bo.party_site_objs(j).attribute15,
178: p_hz_organization_bo.party_site_objs(j).attribute16,
179: p_hz_organization_bo.party_site_objs(j).attribute17,
180: p_hz_organization_bo.party_site_objs(j).attribute18,
173: p_hz_organization_bo.party_site_objs(j).attribute11,
174: p_hz_organization_bo.party_site_objs(j).attribute12,
175: p_hz_organization_bo.party_site_objs(j).attribute13,
176: p_hz_organization_bo.party_site_objs(j).attribute14,
177: p_hz_organization_bo.party_site_objs(j).attribute15,
178: p_hz_organization_bo.party_site_objs(j).attribute16,
179: p_hz_organization_bo.party_site_objs(j).attribute17,
180: p_hz_organization_bo.party_site_objs(j).attribute18,
181: p_hz_organization_bo.party_site_objs(j).attribute19,
174: p_hz_organization_bo.party_site_objs(j).attribute12,
175: p_hz_organization_bo.party_site_objs(j).attribute13,
176: p_hz_organization_bo.party_site_objs(j).attribute14,
177: p_hz_organization_bo.party_site_objs(j).attribute15,
178: p_hz_organization_bo.party_site_objs(j).attribute16,
179: p_hz_organization_bo.party_site_objs(j).attribute17,
180: p_hz_organization_bo.party_site_objs(j).attribute18,
181: p_hz_organization_bo.party_site_objs(j).attribute19,
182: p_hz_organization_bo.party_site_objs(j).attribute20,
175: p_hz_organization_bo.party_site_objs(j).attribute13,
176: p_hz_organization_bo.party_site_objs(j).attribute14,
177: p_hz_organization_bo.party_site_objs(j).attribute15,
178: p_hz_organization_bo.party_site_objs(j).attribute16,
179: p_hz_organization_bo.party_site_objs(j).attribute17,
180: p_hz_organization_bo.party_site_objs(j).attribute18,
181: p_hz_organization_bo.party_site_objs(j).attribute19,
182: p_hz_organization_bo.party_site_objs(j).attribute20,
183: p_hz_organization_bo.party_site_objs(j).language,
176: p_hz_organization_bo.party_site_objs(j).attribute14,
177: p_hz_organization_bo.party_site_objs(j).attribute15,
178: p_hz_organization_bo.party_site_objs(j).attribute16,
179: p_hz_organization_bo.party_site_objs(j).attribute17,
180: p_hz_organization_bo.party_site_objs(j).attribute18,
181: p_hz_organization_bo.party_site_objs(j).attribute19,
182: p_hz_organization_bo.party_site_objs(j).attribute20,
183: p_hz_organization_bo.party_site_objs(j).language,
184: p_hz_organization_bo.party_site_objs(j).addressee,
177: p_hz_organization_bo.party_site_objs(j).attribute15,
178: p_hz_organization_bo.party_site_objs(j).attribute16,
179: p_hz_organization_bo.party_site_objs(j).attribute17,
180: p_hz_organization_bo.party_site_objs(j).attribute18,
181: p_hz_organization_bo.party_site_objs(j).attribute19,
182: p_hz_organization_bo.party_site_objs(j).attribute20,
183: p_hz_organization_bo.party_site_objs(j).language,
184: p_hz_organization_bo.party_site_objs(j).addressee,
185: p_hz_organization_bo.party_site_objs(j).program_update_date,
178: p_hz_organization_bo.party_site_objs(j).attribute16,
179: p_hz_organization_bo.party_site_objs(j).attribute17,
180: p_hz_organization_bo.party_site_objs(j).attribute18,
181: p_hz_organization_bo.party_site_objs(j).attribute19,
182: p_hz_organization_bo.party_site_objs(j).attribute20,
183: p_hz_organization_bo.party_site_objs(j).language,
184: p_hz_organization_bo.party_site_objs(j).addressee,
185: p_hz_organization_bo.party_site_objs(j).program_update_date,
186: p_hz_organization_bo.party_site_objs(j).created_by_module,
179: p_hz_organization_bo.party_site_objs(j).attribute17,
180: p_hz_organization_bo.party_site_objs(j).attribute18,
181: p_hz_organization_bo.party_site_objs(j).attribute19,
182: p_hz_organization_bo.party_site_objs(j).attribute20,
183: p_hz_organization_bo.party_site_objs(j).language,
184: p_hz_organization_bo.party_site_objs(j).addressee,
185: p_hz_organization_bo.party_site_objs(j).program_update_date,
186: p_hz_organization_bo.party_site_objs(j).created_by_module,
187: p_hz_organization_bo.party_site_objs(j).created_by_name,
180: p_hz_organization_bo.party_site_objs(j).attribute18,
181: p_hz_organization_bo.party_site_objs(j).attribute19,
182: p_hz_organization_bo.party_site_objs(j).attribute20,
183: p_hz_organization_bo.party_site_objs(j).language,
184: p_hz_organization_bo.party_site_objs(j).addressee,
185: p_hz_organization_bo.party_site_objs(j).program_update_date,
186: p_hz_organization_bo.party_site_objs(j).created_by_module,
187: p_hz_organization_bo.party_site_objs(j).created_by_name,
188: p_hz_organization_bo.party_site_objs(j).creation_date,
181: p_hz_organization_bo.party_site_objs(j).attribute19,
182: p_hz_organization_bo.party_site_objs(j).attribute20,
183: p_hz_organization_bo.party_site_objs(j).language,
184: p_hz_organization_bo.party_site_objs(j).addressee,
185: p_hz_organization_bo.party_site_objs(j).program_update_date,
186: p_hz_organization_bo.party_site_objs(j).created_by_module,
187: p_hz_organization_bo.party_site_objs(j).created_by_name,
188: p_hz_organization_bo.party_site_objs(j).creation_date,
189: p_hz_organization_bo.party_site_objs(j).last_update_date,
182: p_hz_organization_bo.party_site_objs(j).attribute20,
183: p_hz_organization_bo.party_site_objs(j).language,
184: p_hz_organization_bo.party_site_objs(j).addressee,
185: p_hz_organization_bo.party_site_objs(j).program_update_date,
186: p_hz_organization_bo.party_site_objs(j).created_by_module,
187: p_hz_organization_bo.party_site_objs(j).created_by_name,
188: p_hz_organization_bo.party_site_objs(j).creation_date,
189: p_hz_organization_bo.party_site_objs(j).last_update_date,
190: p_hz_organization_bo.party_site_objs(j).last_updated_by_name,
183: p_hz_organization_bo.party_site_objs(j).language,
184: p_hz_organization_bo.party_site_objs(j).addressee,
185: p_hz_organization_bo.party_site_objs(j).program_update_date,
186: p_hz_organization_bo.party_site_objs(j).created_by_module,
187: p_hz_organization_bo.party_site_objs(j).created_by_name,
188: p_hz_organization_bo.party_site_objs(j).creation_date,
189: p_hz_organization_bo.party_site_objs(j).last_update_date,
190: p_hz_organization_bo.party_site_objs(j).last_updated_by_name,
191: p_hz_organization_bo.party_site_objs(j).actual_content_source,
184: p_hz_organization_bo.party_site_objs(j).addressee,
185: p_hz_organization_bo.party_site_objs(j).program_update_date,
186: p_hz_organization_bo.party_site_objs(j).created_by_module,
187: p_hz_organization_bo.party_site_objs(j).created_by_name,
188: p_hz_organization_bo.party_site_objs(j).creation_date,
189: p_hz_organization_bo.party_site_objs(j).last_update_date,
190: p_hz_organization_bo.party_site_objs(j).last_updated_by_name,
191: p_hz_organization_bo.party_site_objs(j).actual_content_source,
192: p_hz_organization_bo.party_site_objs(j).global_location_number,
185: p_hz_organization_bo.party_site_objs(j).program_update_date,
186: p_hz_organization_bo.party_site_objs(j).created_by_module,
187: p_hz_organization_bo.party_site_objs(j).created_by_name,
188: p_hz_organization_bo.party_site_objs(j).creation_date,
189: p_hz_organization_bo.party_site_objs(j).last_update_date,
190: p_hz_organization_bo.party_site_objs(j).last_updated_by_name,
191: p_hz_organization_bo.party_site_objs(j).actual_content_source,
192: p_hz_organization_bo.party_site_objs(j).global_location_number,
193: p_hz_organization_bo.party_site_objs(j).orig_sys_objs,
186: p_hz_organization_bo.party_site_objs(j).created_by_module,
187: p_hz_organization_bo.party_site_objs(j).created_by_name,
188: p_hz_organization_bo.party_site_objs(j).creation_date,
189: p_hz_organization_bo.party_site_objs(j).last_update_date,
190: p_hz_organization_bo.party_site_objs(j).last_updated_by_name,
191: p_hz_organization_bo.party_site_objs(j).actual_content_source,
192: p_hz_organization_bo.party_site_objs(j).global_location_number,
193: p_hz_organization_bo.party_site_objs(j).orig_sys_objs,
194: p_hz_organization_bo.party_site_objs(j).ext_attributes_objs,
187: p_hz_organization_bo.party_site_objs(j).created_by_name,
188: p_hz_organization_bo.party_site_objs(j).creation_date,
189: p_hz_organization_bo.party_site_objs(j).last_update_date,
190: p_hz_organization_bo.party_site_objs(j).last_updated_by_name,
191: p_hz_organization_bo.party_site_objs(j).actual_content_source,
192: p_hz_organization_bo.party_site_objs(j).global_location_number,
193: p_hz_organization_bo.party_site_objs(j).orig_sys_objs,
194: p_hz_organization_bo.party_site_objs(j).ext_attributes_objs,
195: p_hz_organization_bo.party_site_objs(j).location_obj,
188: p_hz_organization_bo.party_site_objs(j).creation_date,
189: p_hz_organization_bo.party_site_objs(j).last_update_date,
190: p_hz_organization_bo.party_site_objs(j).last_updated_by_name,
191: p_hz_organization_bo.party_site_objs(j).actual_content_source,
192: p_hz_organization_bo.party_site_objs(j).global_location_number,
193: p_hz_organization_bo.party_site_objs(j).orig_sys_objs,
194: p_hz_organization_bo.party_site_objs(j).ext_attributes_objs,
195: p_hz_organization_bo.party_site_objs(j).location_obj,
196: p_hz_organization_bo.party_site_objs(j).party_site_use_objs,
189: p_hz_organization_bo.party_site_objs(j).last_update_date,
190: p_hz_organization_bo.party_site_objs(j).last_updated_by_name,
191: p_hz_organization_bo.party_site_objs(j).actual_content_source,
192: p_hz_organization_bo.party_site_objs(j).global_location_number,
193: p_hz_organization_bo.party_site_objs(j).orig_sys_objs,
194: p_hz_organization_bo.party_site_objs(j).ext_attributes_objs,
195: p_hz_organization_bo.party_site_objs(j).location_obj,
196: p_hz_organization_bo.party_site_objs(j).party_site_use_objs,
197: p_hz_organization_bo.party_site_objs(j).phone_objs,
190: p_hz_organization_bo.party_site_objs(j).last_updated_by_name,
191: p_hz_organization_bo.party_site_objs(j).actual_content_source,
192: p_hz_organization_bo.party_site_objs(j).global_location_number,
193: p_hz_organization_bo.party_site_objs(j).orig_sys_objs,
194: p_hz_organization_bo.party_site_objs(j).ext_attributes_objs,
195: p_hz_organization_bo.party_site_objs(j).location_obj,
196: p_hz_organization_bo.party_site_objs(j).party_site_use_objs,
197: p_hz_organization_bo.party_site_objs(j).phone_objs,
198: p_hz_organization_bo.party_site_objs(j).telex_objs,
191: p_hz_organization_bo.party_site_objs(j).actual_content_source,
192: p_hz_organization_bo.party_site_objs(j).global_location_number,
193: p_hz_organization_bo.party_site_objs(j).orig_sys_objs,
194: p_hz_organization_bo.party_site_objs(j).ext_attributes_objs,
195: p_hz_organization_bo.party_site_objs(j).location_obj,
196: p_hz_organization_bo.party_site_objs(j).party_site_use_objs,
197: p_hz_organization_bo.party_site_objs(j).phone_objs,
198: p_hz_organization_bo.party_site_objs(j).telex_objs,
199: p_hz_organization_bo.party_site_objs(j).email_objs,
192: p_hz_organization_bo.party_site_objs(j).global_location_number,
193: p_hz_organization_bo.party_site_objs(j).orig_sys_objs,
194: p_hz_organization_bo.party_site_objs(j).ext_attributes_objs,
195: p_hz_organization_bo.party_site_objs(j).location_obj,
196: p_hz_organization_bo.party_site_objs(j).party_site_use_objs,
197: p_hz_organization_bo.party_site_objs(j).phone_objs,
198: p_hz_organization_bo.party_site_objs(j).telex_objs,
199: p_hz_organization_bo.party_site_objs(j).email_objs,
200: p_hz_organization_bo.party_site_objs(j).web_objs,
193: p_hz_organization_bo.party_site_objs(j).orig_sys_objs,
194: p_hz_organization_bo.party_site_objs(j).ext_attributes_objs,
195: p_hz_organization_bo.party_site_objs(j).location_obj,
196: p_hz_organization_bo.party_site_objs(j).party_site_use_objs,
197: p_hz_organization_bo.party_site_objs(j).phone_objs,
198: p_hz_organization_bo.party_site_objs(j).telex_objs,
199: p_hz_organization_bo.party_site_objs(j).email_objs,
200: p_hz_organization_bo.party_site_objs(j).web_objs,
201: p_hz_organization_bo.party_site_objs(j).contact_pref_objs);
194: p_hz_organization_bo.party_site_objs(j).ext_attributes_objs,
195: p_hz_organization_bo.party_site_objs(j).location_obj,
196: p_hz_organization_bo.party_site_objs(j).party_site_use_objs,
197: p_hz_organization_bo.party_site_objs(j).phone_objs,
198: p_hz_organization_bo.party_site_objs(j).telex_objs,
199: p_hz_organization_bo.party_site_objs(j).email_objs,
200: p_hz_organization_bo.party_site_objs(j).web_objs,
201: p_hz_organization_bo.party_site_objs(j).contact_pref_objs);
202:
195: p_hz_organization_bo.party_site_objs(j).location_obj,
196: p_hz_organization_bo.party_site_objs(j).party_site_use_objs,
197: p_hz_organization_bo.party_site_objs(j).phone_objs,
198: p_hz_organization_bo.party_site_objs(j).telex_objs,
199: p_hz_organization_bo.party_site_objs(j).email_objs,
200: p_hz_organization_bo.party_site_objs(j).web_objs,
201: p_hz_organization_bo.party_site_objs(j).contact_pref_objs);
202:
203: END LOOP;
196: p_hz_organization_bo.party_site_objs(j).party_site_use_objs,
197: p_hz_organization_bo.party_site_objs(j).phone_objs,
198: p_hz_organization_bo.party_site_objs(j).telex_objs,
199: p_hz_organization_bo.party_site_objs(j).email_objs,
200: p_hz_organization_bo.party_site_objs(j).web_objs,
201: p_hz_organization_bo.party_site_objs(j).contact_pref_objs);
202:
203: END LOOP;
204: END IF;
197: p_hz_organization_bo.party_site_objs(j).phone_objs,
198: p_hz_organization_bo.party_site_objs(j).telex_objs,
199: p_hz_organization_bo.party_site_objs(j).email_objs,
200: p_hz_organization_bo.party_site_objs(j).web_objs,
201: p_hz_organization_bo.party_site_objs(j).contact_pref_objs);
202:
203: END LOOP;
204: END IF;
205: p_pos_organization_bo := pos_organization_bo(p_hz_organization_bo.action_type,
201: p_hz_organization_bo.party_site_objs(j).contact_pref_objs);
202:
203: END LOOP;
204: END IF;
205: p_pos_organization_bo := pos_organization_bo(p_hz_organization_bo.action_type,
206: p_hz_organization_bo.common_obj_id,
207: p_hz_organization_bo.organization_id,
208: p_hz_organization_bo.orig_system,
209: p_hz_organization_bo.orig_system_reference,
202:
203: END LOOP;
204: END IF;
205: p_pos_organization_bo := pos_organization_bo(p_hz_organization_bo.action_type,
206: p_hz_organization_bo.common_obj_id,
207: p_hz_organization_bo.organization_id,
208: p_hz_organization_bo.orig_system,
209: p_hz_organization_bo.orig_system_reference,
210: p_hz_organization_bo.party_number,
203: END LOOP;
204: END IF;
205: p_pos_organization_bo := pos_organization_bo(p_hz_organization_bo.action_type,
206: p_hz_organization_bo.common_obj_id,
207: p_hz_organization_bo.organization_id,
208: p_hz_organization_bo.orig_system,
209: p_hz_organization_bo.orig_system_reference,
210: p_hz_organization_bo.party_number,
211: p_hz_organization_bo.validated_flag,
204: END IF;
205: p_pos_organization_bo := pos_organization_bo(p_hz_organization_bo.action_type,
206: p_hz_organization_bo.common_obj_id,
207: p_hz_organization_bo.organization_id,
208: p_hz_organization_bo.orig_system,
209: p_hz_organization_bo.orig_system_reference,
210: p_hz_organization_bo.party_number,
211: p_hz_organization_bo.validated_flag,
212: p_hz_organization_bo.status,
205: p_pos_organization_bo := pos_organization_bo(p_hz_organization_bo.action_type,
206: p_hz_organization_bo.common_obj_id,
207: p_hz_organization_bo.organization_id,
208: p_hz_organization_bo.orig_system,
209: p_hz_organization_bo.orig_system_reference,
210: p_hz_organization_bo.party_number,
211: p_hz_organization_bo.validated_flag,
212: p_hz_organization_bo.status,
213: p_hz_organization_bo.category_code,
206: p_hz_organization_bo.common_obj_id,
207: p_hz_organization_bo.organization_id,
208: p_hz_organization_bo.orig_system,
209: p_hz_organization_bo.orig_system_reference,
210: p_hz_organization_bo.party_number,
211: p_hz_organization_bo.validated_flag,
212: p_hz_organization_bo.status,
213: p_hz_organization_bo.category_code,
214: p_hz_organization_bo.salutation,
207: p_hz_organization_bo.organization_id,
208: p_hz_organization_bo.orig_system,
209: p_hz_organization_bo.orig_system_reference,
210: p_hz_organization_bo.party_number,
211: p_hz_organization_bo.validated_flag,
212: p_hz_organization_bo.status,
213: p_hz_organization_bo.category_code,
214: p_hz_organization_bo.salutation,
215: p_hz_organization_bo.attribute_category,
208: p_hz_organization_bo.orig_system,
209: p_hz_organization_bo.orig_system_reference,
210: p_hz_organization_bo.party_number,
211: p_hz_organization_bo.validated_flag,
212: p_hz_organization_bo.status,
213: p_hz_organization_bo.category_code,
214: p_hz_organization_bo.salutation,
215: p_hz_organization_bo.attribute_category,
216: p_hz_organization_bo.attribute1,
209: p_hz_organization_bo.orig_system_reference,
210: p_hz_organization_bo.party_number,
211: p_hz_organization_bo.validated_flag,
212: p_hz_organization_bo.status,
213: p_hz_organization_bo.category_code,
214: p_hz_organization_bo.salutation,
215: p_hz_organization_bo.attribute_category,
216: p_hz_organization_bo.attribute1,
217: p_hz_organization_bo.attribute2,
210: p_hz_organization_bo.party_number,
211: p_hz_organization_bo.validated_flag,
212: p_hz_organization_bo.status,
213: p_hz_organization_bo.category_code,
214: p_hz_organization_bo.salutation,
215: p_hz_organization_bo.attribute_category,
216: p_hz_organization_bo.attribute1,
217: p_hz_organization_bo.attribute2,
218: p_hz_organization_bo.attribute3,
211: p_hz_organization_bo.validated_flag,
212: p_hz_organization_bo.status,
213: p_hz_organization_bo.category_code,
214: p_hz_organization_bo.salutation,
215: p_hz_organization_bo.attribute_category,
216: p_hz_organization_bo.attribute1,
217: p_hz_organization_bo.attribute2,
218: p_hz_organization_bo.attribute3,
219: p_hz_organization_bo.attribute4,
212: p_hz_organization_bo.status,
213: p_hz_organization_bo.category_code,
214: p_hz_organization_bo.salutation,
215: p_hz_organization_bo.attribute_category,
216: p_hz_organization_bo.attribute1,
217: p_hz_organization_bo.attribute2,
218: p_hz_organization_bo.attribute3,
219: p_hz_organization_bo.attribute4,
220: p_hz_organization_bo.attribute5,
213: p_hz_organization_bo.category_code,
214: p_hz_organization_bo.salutation,
215: p_hz_organization_bo.attribute_category,
216: p_hz_organization_bo.attribute1,
217: p_hz_organization_bo.attribute2,
218: p_hz_organization_bo.attribute3,
219: p_hz_organization_bo.attribute4,
220: p_hz_organization_bo.attribute5,
221: p_hz_organization_bo.attribute6,
214: p_hz_organization_bo.salutation,
215: p_hz_organization_bo.attribute_category,
216: p_hz_organization_bo.attribute1,
217: p_hz_organization_bo.attribute2,
218: p_hz_organization_bo.attribute3,
219: p_hz_organization_bo.attribute4,
220: p_hz_organization_bo.attribute5,
221: p_hz_organization_bo.attribute6,
222: p_hz_organization_bo.attribute7,
215: p_hz_organization_bo.attribute_category,
216: p_hz_organization_bo.attribute1,
217: p_hz_organization_bo.attribute2,
218: p_hz_organization_bo.attribute3,
219: p_hz_organization_bo.attribute4,
220: p_hz_organization_bo.attribute5,
221: p_hz_organization_bo.attribute6,
222: p_hz_organization_bo.attribute7,
223: p_hz_organization_bo.attribute8,
216: p_hz_organization_bo.attribute1,
217: p_hz_organization_bo.attribute2,
218: p_hz_organization_bo.attribute3,
219: p_hz_organization_bo.attribute4,
220: p_hz_organization_bo.attribute5,
221: p_hz_organization_bo.attribute6,
222: p_hz_organization_bo.attribute7,
223: p_hz_organization_bo.attribute8,
224: p_hz_organization_bo.attribute9,
217: p_hz_organization_bo.attribute2,
218: p_hz_organization_bo.attribute3,
219: p_hz_organization_bo.attribute4,
220: p_hz_organization_bo.attribute5,
221: p_hz_organization_bo.attribute6,
222: p_hz_organization_bo.attribute7,
223: p_hz_organization_bo.attribute8,
224: p_hz_organization_bo.attribute9,
225: p_hz_organization_bo.attribute10,
218: p_hz_organization_bo.attribute3,
219: p_hz_organization_bo.attribute4,
220: p_hz_organization_bo.attribute5,
221: p_hz_organization_bo.attribute6,
222: p_hz_organization_bo.attribute7,
223: p_hz_organization_bo.attribute8,
224: p_hz_organization_bo.attribute9,
225: p_hz_organization_bo.attribute10,
226: p_hz_organization_bo.attribute11,
219: p_hz_organization_bo.attribute4,
220: p_hz_organization_bo.attribute5,
221: p_hz_organization_bo.attribute6,
222: p_hz_organization_bo.attribute7,
223: p_hz_organization_bo.attribute8,
224: p_hz_organization_bo.attribute9,
225: p_hz_organization_bo.attribute10,
226: p_hz_organization_bo.attribute11,
227: p_hz_organization_bo.attribute12,
220: p_hz_organization_bo.attribute5,
221: p_hz_organization_bo.attribute6,
222: p_hz_organization_bo.attribute7,
223: p_hz_organization_bo.attribute8,
224: p_hz_organization_bo.attribute9,
225: p_hz_organization_bo.attribute10,
226: p_hz_organization_bo.attribute11,
227: p_hz_organization_bo.attribute12,
228: p_hz_organization_bo.attribute13,
221: p_hz_organization_bo.attribute6,
222: p_hz_organization_bo.attribute7,
223: p_hz_organization_bo.attribute8,
224: p_hz_organization_bo.attribute9,
225: p_hz_organization_bo.attribute10,
226: p_hz_organization_bo.attribute11,
227: p_hz_organization_bo.attribute12,
228: p_hz_organization_bo.attribute13,
229: p_hz_organization_bo.attribute14,
222: p_hz_organization_bo.attribute7,
223: p_hz_organization_bo.attribute8,
224: p_hz_organization_bo.attribute9,
225: p_hz_organization_bo.attribute10,
226: p_hz_organization_bo.attribute11,
227: p_hz_organization_bo.attribute12,
228: p_hz_organization_bo.attribute13,
229: p_hz_organization_bo.attribute14,
230: p_hz_organization_bo.attribute15,
223: p_hz_organization_bo.attribute8,
224: p_hz_organization_bo.attribute9,
225: p_hz_organization_bo.attribute10,
226: p_hz_organization_bo.attribute11,
227: p_hz_organization_bo.attribute12,
228: p_hz_organization_bo.attribute13,
229: p_hz_organization_bo.attribute14,
230: p_hz_organization_bo.attribute15,
231: p_hz_organization_bo.attribute16,
224: p_hz_organization_bo.attribute9,
225: p_hz_organization_bo.attribute10,
226: p_hz_organization_bo.attribute11,
227: p_hz_organization_bo.attribute12,
228: p_hz_organization_bo.attribute13,
229: p_hz_organization_bo.attribute14,
230: p_hz_organization_bo.attribute15,
231: p_hz_organization_bo.attribute16,
232: p_hz_organization_bo.attribute17,
225: p_hz_organization_bo.attribute10,
226: p_hz_organization_bo.attribute11,
227: p_hz_organization_bo.attribute12,
228: p_hz_organization_bo.attribute13,
229: p_hz_organization_bo.attribute14,
230: p_hz_organization_bo.attribute15,
231: p_hz_organization_bo.attribute16,
232: p_hz_organization_bo.attribute17,
233: p_hz_organization_bo.attribute18,
226: p_hz_organization_bo.attribute11,
227: p_hz_organization_bo.attribute12,
228: p_hz_organization_bo.attribute13,
229: p_hz_organization_bo.attribute14,
230: p_hz_organization_bo.attribute15,
231: p_hz_organization_bo.attribute16,
232: p_hz_organization_bo.attribute17,
233: p_hz_organization_bo.attribute18,
234: p_hz_organization_bo.attribute19,
227: p_hz_organization_bo.attribute12,
228: p_hz_organization_bo.attribute13,
229: p_hz_organization_bo.attribute14,
230: p_hz_organization_bo.attribute15,
231: p_hz_organization_bo.attribute16,
232: p_hz_organization_bo.attribute17,
233: p_hz_organization_bo.attribute18,
234: p_hz_organization_bo.attribute19,
235: p_hz_organization_bo.attribute20,
228: p_hz_organization_bo.attribute13,
229: p_hz_organization_bo.attribute14,
230: p_hz_organization_bo.attribute15,
231: p_hz_organization_bo.attribute16,
232: p_hz_organization_bo.attribute17,
233: p_hz_organization_bo.attribute18,
234: p_hz_organization_bo.attribute19,
235: p_hz_organization_bo.attribute20,
236: p_hz_organization_bo.attribute21,
229: p_hz_organization_bo.attribute14,
230: p_hz_organization_bo.attribute15,
231: p_hz_organization_bo.attribute16,
232: p_hz_organization_bo.attribute17,
233: p_hz_organization_bo.attribute18,
234: p_hz_organization_bo.attribute19,
235: p_hz_organization_bo.attribute20,
236: p_hz_organization_bo.attribute21,
237: p_hz_organization_bo.attribute22,
230: p_hz_organization_bo.attribute15,
231: p_hz_organization_bo.attribute16,
232: p_hz_organization_bo.attribute17,
233: p_hz_organization_bo.attribute18,
234: p_hz_organization_bo.attribute19,
235: p_hz_organization_bo.attribute20,
236: p_hz_organization_bo.attribute21,
237: p_hz_organization_bo.attribute22,
238: p_hz_organization_bo.attribute23,
231: p_hz_organization_bo.attribute16,
232: p_hz_organization_bo.attribute17,
233: p_hz_organization_bo.attribute18,
234: p_hz_organization_bo.attribute19,
235: p_hz_organization_bo.attribute20,
236: p_hz_organization_bo.attribute21,
237: p_hz_organization_bo.attribute22,
238: p_hz_organization_bo.attribute23,
239: p_hz_organization_bo.attribute24,
232: p_hz_organization_bo.attribute17,
233: p_hz_organization_bo.attribute18,
234: p_hz_organization_bo.attribute19,
235: p_hz_organization_bo.attribute20,
236: p_hz_organization_bo.attribute21,
237: p_hz_organization_bo.attribute22,
238: p_hz_organization_bo.attribute23,
239: p_hz_organization_bo.attribute24,
240: p_hz_organization_bo.organization_name,
233: p_hz_organization_bo.attribute18,
234: p_hz_organization_bo.attribute19,
235: p_hz_organization_bo.attribute20,
236: p_hz_organization_bo.attribute21,
237: p_hz_organization_bo.attribute22,
238: p_hz_organization_bo.attribute23,
239: p_hz_organization_bo.attribute24,
240: p_hz_organization_bo.organization_name,
241: p_hz_organization_bo.duns_number_c,
234: p_hz_organization_bo.attribute19,
235: p_hz_organization_bo.attribute20,
236: p_hz_organization_bo.attribute21,
237: p_hz_organization_bo.attribute22,
238: p_hz_organization_bo.attribute23,
239: p_hz_organization_bo.attribute24,
240: p_hz_organization_bo.organization_name,
241: p_hz_organization_bo.duns_number_c,
242: p_hz_organization_bo.enquiry_duns,
235: p_hz_organization_bo.attribute20,
236: p_hz_organization_bo.attribute21,
237: p_hz_organization_bo.attribute22,
238: p_hz_organization_bo.attribute23,
239: p_hz_organization_bo.attribute24,
240: p_hz_organization_bo.organization_name,
241: p_hz_organization_bo.duns_number_c,
242: p_hz_organization_bo.enquiry_duns,
243: p_hz_organization_bo.ceo_name,
236: p_hz_organization_bo.attribute21,
237: p_hz_organization_bo.attribute22,
238: p_hz_organization_bo.attribute23,
239: p_hz_organization_bo.attribute24,
240: p_hz_organization_bo.organization_name,
241: p_hz_organization_bo.duns_number_c,
242: p_hz_organization_bo.enquiry_duns,
243: p_hz_organization_bo.ceo_name,
244: p_hz_organization_bo.ceo_title,
237: p_hz_organization_bo.attribute22,
238: p_hz_organization_bo.attribute23,
239: p_hz_organization_bo.attribute24,
240: p_hz_organization_bo.organization_name,
241: p_hz_organization_bo.duns_number_c,
242: p_hz_organization_bo.enquiry_duns,
243: p_hz_organization_bo.ceo_name,
244: p_hz_organization_bo.ceo_title,
245: p_hz_organization_bo.principal_name,
238: p_hz_organization_bo.attribute23,
239: p_hz_organization_bo.attribute24,
240: p_hz_organization_bo.organization_name,
241: p_hz_organization_bo.duns_number_c,
242: p_hz_organization_bo.enquiry_duns,
243: p_hz_organization_bo.ceo_name,
244: p_hz_organization_bo.ceo_title,
245: p_hz_organization_bo.principal_name,
246: p_hz_organization_bo.principal_title,
239: p_hz_organization_bo.attribute24,
240: p_hz_organization_bo.organization_name,
241: p_hz_organization_bo.duns_number_c,
242: p_hz_organization_bo.enquiry_duns,
243: p_hz_organization_bo.ceo_name,
244: p_hz_organization_bo.ceo_title,
245: p_hz_organization_bo.principal_name,
246: p_hz_organization_bo.principal_title,
247: p_hz_organization_bo.legal_status,
240: p_hz_organization_bo.organization_name,
241: p_hz_organization_bo.duns_number_c,
242: p_hz_organization_bo.enquiry_duns,
243: p_hz_organization_bo.ceo_name,
244: p_hz_organization_bo.ceo_title,
245: p_hz_organization_bo.principal_name,
246: p_hz_organization_bo.principal_title,
247: p_hz_organization_bo.legal_status,
248: p_hz_organization_bo.control_yr,
241: p_hz_organization_bo.duns_number_c,
242: p_hz_organization_bo.enquiry_duns,
243: p_hz_organization_bo.ceo_name,
244: p_hz_organization_bo.ceo_title,
245: p_hz_organization_bo.principal_name,
246: p_hz_organization_bo.principal_title,
247: p_hz_organization_bo.legal_status,
248: p_hz_organization_bo.control_yr,
249: p_hz_organization_bo.employees_total,
242: p_hz_organization_bo.enquiry_duns,
243: p_hz_organization_bo.ceo_name,
244: p_hz_organization_bo.ceo_title,
245: p_hz_organization_bo.principal_name,
246: p_hz_organization_bo.principal_title,
247: p_hz_organization_bo.legal_status,
248: p_hz_organization_bo.control_yr,
249: p_hz_organization_bo.employees_total,
250: p_hz_organization_bo.hq_branch_ind,
243: p_hz_organization_bo.ceo_name,
244: p_hz_organization_bo.ceo_title,
245: p_hz_organization_bo.principal_name,
246: p_hz_organization_bo.principal_title,
247: p_hz_organization_bo.legal_status,
248: p_hz_organization_bo.control_yr,
249: p_hz_organization_bo.employees_total,
250: p_hz_organization_bo.hq_branch_ind,
251: p_hz_organization_bo.branch_flag,
244: p_hz_organization_bo.ceo_title,
245: p_hz_organization_bo.principal_name,
246: p_hz_organization_bo.principal_title,
247: p_hz_organization_bo.legal_status,
248: p_hz_organization_bo.control_yr,
249: p_hz_organization_bo.employees_total,
250: p_hz_organization_bo.hq_branch_ind,
251: p_hz_organization_bo.branch_flag,
252: p_hz_organization_bo.oob_ind,
245: p_hz_organization_bo.principal_name,
246: p_hz_organization_bo.principal_title,
247: p_hz_organization_bo.legal_status,
248: p_hz_organization_bo.control_yr,
249: p_hz_organization_bo.employees_total,
250: p_hz_organization_bo.hq_branch_ind,
251: p_hz_organization_bo.branch_flag,
252: p_hz_organization_bo.oob_ind,
253: p_hz_organization_bo.line_of_business,
246: p_hz_organization_bo.principal_title,
247: p_hz_organization_bo.legal_status,
248: p_hz_organization_bo.control_yr,
249: p_hz_organization_bo.employees_total,
250: p_hz_organization_bo.hq_branch_ind,
251: p_hz_organization_bo.branch_flag,
252: p_hz_organization_bo.oob_ind,
253: p_hz_organization_bo.line_of_business,
254: p_hz_organization_bo.cong_dist_code,
247: p_hz_organization_bo.legal_status,
248: p_hz_organization_bo.control_yr,
249: p_hz_organization_bo.employees_total,
250: p_hz_organization_bo.hq_branch_ind,
251: p_hz_organization_bo.branch_flag,
252: p_hz_organization_bo.oob_ind,
253: p_hz_organization_bo.line_of_business,
254: p_hz_organization_bo.cong_dist_code,
255: p_hz_organization_bo.sic_code,
248: p_hz_organization_bo.control_yr,
249: p_hz_organization_bo.employees_total,
250: p_hz_organization_bo.hq_branch_ind,
251: p_hz_organization_bo.branch_flag,
252: p_hz_organization_bo.oob_ind,
253: p_hz_organization_bo.line_of_business,
254: p_hz_organization_bo.cong_dist_code,
255: p_hz_organization_bo.sic_code,
256: p_hz_organization_bo.import_ind,
249: p_hz_organization_bo.employees_total,
250: p_hz_organization_bo.hq_branch_ind,
251: p_hz_organization_bo.branch_flag,
252: p_hz_organization_bo.oob_ind,
253: p_hz_organization_bo.line_of_business,
254: p_hz_organization_bo.cong_dist_code,
255: p_hz_organization_bo.sic_code,
256: p_hz_organization_bo.import_ind,
257: p_hz_organization_bo.export_ind,
250: p_hz_organization_bo.hq_branch_ind,
251: p_hz_organization_bo.branch_flag,
252: p_hz_organization_bo.oob_ind,
253: p_hz_organization_bo.line_of_business,
254: p_hz_organization_bo.cong_dist_code,
255: p_hz_organization_bo.sic_code,
256: p_hz_organization_bo.import_ind,
257: p_hz_organization_bo.export_ind,
258: p_hz_organization_bo.labor_surplus_ind,
251: p_hz_organization_bo.branch_flag,
252: p_hz_organization_bo.oob_ind,
253: p_hz_organization_bo.line_of_business,
254: p_hz_organization_bo.cong_dist_code,
255: p_hz_organization_bo.sic_code,
256: p_hz_organization_bo.import_ind,
257: p_hz_organization_bo.export_ind,
258: p_hz_organization_bo.labor_surplus_ind,
259: p_hz_organization_bo.debarment_ind,
252: p_hz_organization_bo.oob_ind,
253: p_hz_organization_bo.line_of_business,
254: p_hz_organization_bo.cong_dist_code,
255: p_hz_organization_bo.sic_code,
256: p_hz_organization_bo.import_ind,
257: p_hz_organization_bo.export_ind,
258: p_hz_organization_bo.labor_surplus_ind,
259: p_hz_organization_bo.debarment_ind,
260: p_hz_organization_bo.minority_owned_ind,
253: p_hz_organization_bo.line_of_business,
254: p_hz_organization_bo.cong_dist_code,
255: p_hz_organization_bo.sic_code,
256: p_hz_organization_bo.import_ind,
257: p_hz_organization_bo.export_ind,
258: p_hz_organization_bo.labor_surplus_ind,
259: p_hz_organization_bo.debarment_ind,
260: p_hz_organization_bo.minority_owned_ind,
261: p_hz_organization_bo.minority_owned_type,
254: p_hz_organization_bo.cong_dist_code,
255: p_hz_organization_bo.sic_code,
256: p_hz_organization_bo.import_ind,
257: p_hz_organization_bo.export_ind,
258: p_hz_organization_bo.labor_surplus_ind,
259: p_hz_organization_bo.debarment_ind,
260: p_hz_organization_bo.minority_owned_ind,
261: p_hz_organization_bo.minority_owned_type,
262: p_hz_organization_bo.woman_owned_ind,
255: p_hz_organization_bo.sic_code,
256: p_hz_organization_bo.import_ind,
257: p_hz_organization_bo.export_ind,
258: p_hz_organization_bo.labor_surplus_ind,
259: p_hz_organization_bo.debarment_ind,
260: p_hz_organization_bo.minority_owned_ind,
261: p_hz_organization_bo.minority_owned_type,
262: p_hz_organization_bo.woman_owned_ind,
263: p_hz_organization_bo.disadv_8a_ind,
256: p_hz_organization_bo.import_ind,
257: p_hz_organization_bo.export_ind,
258: p_hz_organization_bo.labor_surplus_ind,
259: p_hz_organization_bo.debarment_ind,
260: p_hz_organization_bo.minority_owned_ind,
261: p_hz_organization_bo.minority_owned_type,
262: p_hz_organization_bo.woman_owned_ind,
263: p_hz_organization_bo.disadv_8a_ind,
264: p_hz_organization_bo.small_bus_ind,
257: p_hz_organization_bo.export_ind,
258: p_hz_organization_bo.labor_surplus_ind,
259: p_hz_organization_bo.debarment_ind,
260: p_hz_organization_bo.minority_owned_ind,
261: p_hz_organization_bo.minority_owned_type,
262: p_hz_organization_bo.woman_owned_ind,
263: p_hz_organization_bo.disadv_8a_ind,
264: p_hz_organization_bo.small_bus_ind,
265: p_hz_organization_bo.rent_own_ind,
258: p_hz_organization_bo.labor_surplus_ind,
259: p_hz_organization_bo.debarment_ind,
260: p_hz_organization_bo.minority_owned_ind,
261: p_hz_organization_bo.minority_owned_type,
262: p_hz_organization_bo.woman_owned_ind,
263: p_hz_organization_bo.disadv_8a_ind,
264: p_hz_organization_bo.small_bus_ind,
265: p_hz_organization_bo.rent_own_ind,
266: p_hz_organization_bo.debarments_count,
259: p_hz_organization_bo.debarment_ind,
260: p_hz_organization_bo.minority_owned_ind,
261: p_hz_organization_bo.minority_owned_type,
262: p_hz_organization_bo.woman_owned_ind,
263: p_hz_organization_bo.disadv_8a_ind,
264: p_hz_organization_bo.small_bus_ind,
265: p_hz_organization_bo.rent_own_ind,
266: p_hz_organization_bo.debarments_count,
267: p_hz_organization_bo.debarments_date,
260: p_hz_organization_bo.minority_owned_ind,
261: p_hz_organization_bo.minority_owned_type,
262: p_hz_organization_bo.woman_owned_ind,
263: p_hz_organization_bo.disadv_8a_ind,
264: p_hz_organization_bo.small_bus_ind,
265: p_hz_organization_bo.rent_own_ind,
266: p_hz_organization_bo.debarments_count,
267: p_hz_organization_bo.debarments_date,
268: p_hz_organization_bo.failure_score,
261: p_hz_organization_bo.minority_owned_type,
262: p_hz_organization_bo.woman_owned_ind,
263: p_hz_organization_bo.disadv_8a_ind,
264: p_hz_organization_bo.small_bus_ind,
265: p_hz_organization_bo.rent_own_ind,
266: p_hz_organization_bo.debarments_count,
267: p_hz_organization_bo.debarments_date,
268: p_hz_organization_bo.failure_score,
269: p_hz_organization_bo.failure_score_natnl_per,
262: p_hz_organization_bo.woman_owned_ind,
263: p_hz_organization_bo.disadv_8a_ind,
264: p_hz_organization_bo.small_bus_ind,
265: p_hz_organization_bo.rent_own_ind,
266: p_hz_organization_bo.debarments_count,
267: p_hz_organization_bo.debarments_date,
268: p_hz_organization_bo.failure_score,
269: p_hz_organization_bo.failure_score_natnl_per,
270: p_hz_organization_bo.failure_score_override_code,
263: p_hz_organization_bo.disadv_8a_ind,
264: p_hz_organization_bo.small_bus_ind,
265: p_hz_organization_bo.rent_own_ind,
266: p_hz_organization_bo.debarments_count,
267: p_hz_organization_bo.debarments_date,
268: p_hz_organization_bo.failure_score,
269: p_hz_organization_bo.failure_score_natnl_per,
270: p_hz_organization_bo.failure_score_override_code,
271: p_hz_organization_bo.failure_score_commentary,
264: p_hz_organization_bo.small_bus_ind,
265: p_hz_organization_bo.rent_own_ind,
266: p_hz_organization_bo.debarments_count,
267: p_hz_organization_bo.debarments_date,
268: p_hz_organization_bo.failure_score,
269: p_hz_organization_bo.failure_score_natnl_per,
270: p_hz_organization_bo.failure_score_override_code,
271: p_hz_organization_bo.failure_score_commentary,
272: p_hz_organization_bo.global_failure_score,
265: p_hz_organization_bo.rent_own_ind,
266: p_hz_organization_bo.debarments_count,
267: p_hz_organization_bo.debarments_date,
268: p_hz_organization_bo.failure_score,
269: p_hz_organization_bo.failure_score_natnl_per,
270: p_hz_organization_bo.failure_score_override_code,
271: p_hz_organization_bo.failure_score_commentary,
272: p_hz_organization_bo.global_failure_score,
273: p_hz_organization_bo.db_rating,
266: p_hz_organization_bo.debarments_count,
267: p_hz_organization_bo.debarments_date,
268: p_hz_organization_bo.failure_score,
269: p_hz_organization_bo.failure_score_natnl_per,
270: p_hz_organization_bo.failure_score_override_code,
271: p_hz_organization_bo.failure_score_commentary,
272: p_hz_organization_bo.global_failure_score,
273: p_hz_organization_bo.db_rating,
274: p_hz_organization_bo.credit_score,
267: p_hz_organization_bo.debarments_date,
268: p_hz_organization_bo.failure_score,
269: p_hz_organization_bo.failure_score_natnl_per,
270: p_hz_organization_bo.failure_score_override_code,
271: p_hz_organization_bo.failure_score_commentary,
272: p_hz_organization_bo.global_failure_score,
273: p_hz_organization_bo.db_rating,
274: p_hz_organization_bo.credit_score,
275: p_hz_organization_bo.credit_score_commentary,
268: p_hz_organization_bo.failure_score,
269: p_hz_organization_bo.failure_score_natnl_per,
270: p_hz_organization_bo.failure_score_override_code,
271: p_hz_organization_bo.failure_score_commentary,
272: p_hz_organization_bo.global_failure_score,
273: p_hz_organization_bo.db_rating,
274: p_hz_organization_bo.credit_score,
275: p_hz_organization_bo.credit_score_commentary,
276: p_hz_organization_bo.paydex_score,
269: p_hz_organization_bo.failure_score_natnl_per,
270: p_hz_organization_bo.failure_score_override_code,
271: p_hz_organization_bo.failure_score_commentary,
272: p_hz_organization_bo.global_failure_score,
273: p_hz_organization_bo.db_rating,
274: p_hz_organization_bo.credit_score,
275: p_hz_organization_bo.credit_score_commentary,
276: p_hz_organization_bo.paydex_score,
277: p_hz_organization_bo.paydex_three_months_ago,
270: p_hz_organization_bo.failure_score_override_code,
271: p_hz_organization_bo.failure_score_commentary,
272: p_hz_organization_bo.global_failure_score,
273: p_hz_organization_bo.db_rating,
274: p_hz_organization_bo.credit_score,
275: p_hz_organization_bo.credit_score_commentary,
276: p_hz_organization_bo.paydex_score,
277: p_hz_organization_bo.paydex_three_months_ago,
278: p_hz_organization_bo.paydex_norm,
271: p_hz_organization_bo.failure_score_commentary,
272: p_hz_organization_bo.global_failure_score,
273: p_hz_organization_bo.db_rating,
274: p_hz_organization_bo.credit_score,
275: p_hz_organization_bo.credit_score_commentary,
276: p_hz_organization_bo.paydex_score,
277: p_hz_organization_bo.paydex_three_months_ago,
278: p_hz_organization_bo.paydex_norm,
279: p_hz_organization_bo.best_time_contact_begin,
272: p_hz_organization_bo.global_failure_score,
273: p_hz_organization_bo.db_rating,
274: p_hz_organization_bo.credit_score,
275: p_hz_organization_bo.credit_score_commentary,
276: p_hz_organization_bo.paydex_score,
277: p_hz_organization_bo.paydex_three_months_ago,
278: p_hz_organization_bo.paydex_norm,
279: p_hz_organization_bo.best_time_contact_begin,
280: p_hz_organization_bo.best_time_contact_end,
273: p_hz_organization_bo.db_rating,
274: p_hz_organization_bo.credit_score,
275: p_hz_organization_bo.credit_score_commentary,
276: p_hz_organization_bo.paydex_score,
277: p_hz_organization_bo.paydex_three_months_ago,
278: p_hz_organization_bo.paydex_norm,
279: p_hz_organization_bo.best_time_contact_begin,
280: p_hz_organization_bo.best_time_contact_end,
281: p_hz_organization_bo.organization_name_phonetic,
274: p_hz_organization_bo.credit_score,
275: p_hz_organization_bo.credit_score_commentary,
276: p_hz_organization_bo.paydex_score,
277: p_hz_organization_bo.paydex_three_months_ago,
278: p_hz_organization_bo.paydex_norm,
279: p_hz_organization_bo.best_time_contact_begin,
280: p_hz_organization_bo.best_time_contact_end,
281: p_hz_organization_bo.organization_name_phonetic,
282: p_hz_organization_bo.tax_reference,
275: p_hz_organization_bo.credit_score_commentary,
276: p_hz_organization_bo.paydex_score,
277: p_hz_organization_bo.paydex_three_months_ago,
278: p_hz_organization_bo.paydex_norm,
279: p_hz_organization_bo.best_time_contact_begin,
280: p_hz_organization_bo.best_time_contact_end,
281: p_hz_organization_bo.organization_name_phonetic,
282: p_hz_organization_bo.tax_reference,
283: p_hz_organization_bo.gsa_indicator_flag,
276: p_hz_organization_bo.paydex_score,
277: p_hz_organization_bo.paydex_three_months_ago,
278: p_hz_organization_bo.paydex_norm,
279: p_hz_organization_bo.best_time_contact_begin,
280: p_hz_organization_bo.best_time_contact_end,
281: p_hz_organization_bo.organization_name_phonetic,
282: p_hz_organization_bo.tax_reference,
283: p_hz_organization_bo.gsa_indicator_flag,
284: p_hz_organization_bo.jgzz_fiscal_code,
277: p_hz_organization_bo.paydex_three_months_ago,
278: p_hz_organization_bo.paydex_norm,
279: p_hz_organization_bo.best_time_contact_begin,
280: p_hz_organization_bo.best_time_contact_end,
281: p_hz_organization_bo.organization_name_phonetic,
282: p_hz_organization_bo.tax_reference,
283: p_hz_organization_bo.gsa_indicator_flag,
284: p_hz_organization_bo.jgzz_fiscal_code,
285: p_hz_organization_bo.analysis_fy,
278: p_hz_organization_bo.paydex_norm,
279: p_hz_organization_bo.best_time_contact_begin,
280: p_hz_organization_bo.best_time_contact_end,
281: p_hz_organization_bo.organization_name_phonetic,
282: p_hz_organization_bo.tax_reference,
283: p_hz_organization_bo.gsa_indicator_flag,
284: p_hz_organization_bo.jgzz_fiscal_code,
285: p_hz_organization_bo.analysis_fy,
286: p_hz_organization_bo.fiscal_yearend_month,
279: p_hz_organization_bo.best_time_contact_begin,
280: p_hz_organization_bo.best_time_contact_end,
281: p_hz_organization_bo.organization_name_phonetic,
282: p_hz_organization_bo.tax_reference,
283: p_hz_organization_bo.gsa_indicator_flag,
284: p_hz_organization_bo.jgzz_fiscal_code,
285: p_hz_organization_bo.analysis_fy,
286: p_hz_organization_bo.fiscal_yearend_month,
287: p_hz_organization_bo.curr_fy_potential_revenue,
280: p_hz_organization_bo.best_time_contact_end,
281: p_hz_organization_bo.organization_name_phonetic,
282: p_hz_organization_bo.tax_reference,
283: p_hz_organization_bo.gsa_indicator_flag,
284: p_hz_organization_bo.jgzz_fiscal_code,
285: p_hz_organization_bo.analysis_fy,
286: p_hz_organization_bo.fiscal_yearend_month,
287: p_hz_organization_bo.curr_fy_potential_revenue,
288: p_hz_organization_bo.next_fy_potential_revenue,
281: p_hz_organization_bo.organization_name_phonetic,
282: p_hz_organization_bo.tax_reference,
283: p_hz_organization_bo.gsa_indicator_flag,
284: p_hz_organization_bo.jgzz_fiscal_code,
285: p_hz_organization_bo.analysis_fy,
286: p_hz_organization_bo.fiscal_yearend_month,
287: p_hz_organization_bo.curr_fy_potential_revenue,
288: p_hz_organization_bo.next_fy_potential_revenue,
289: p_hz_organization_bo.year_established,
282: p_hz_organization_bo.tax_reference,
283: p_hz_organization_bo.gsa_indicator_flag,
284: p_hz_organization_bo.jgzz_fiscal_code,
285: p_hz_organization_bo.analysis_fy,
286: p_hz_organization_bo.fiscal_yearend_month,
287: p_hz_organization_bo.curr_fy_potential_revenue,
288: p_hz_organization_bo.next_fy_potential_revenue,
289: p_hz_organization_bo.year_established,
290: p_hz_organization_bo.mission_statement,
283: p_hz_organization_bo.gsa_indicator_flag,
284: p_hz_organization_bo.jgzz_fiscal_code,
285: p_hz_organization_bo.analysis_fy,
286: p_hz_organization_bo.fiscal_yearend_month,
287: p_hz_organization_bo.curr_fy_potential_revenue,
288: p_hz_organization_bo.next_fy_potential_revenue,
289: p_hz_organization_bo.year_established,
290: p_hz_organization_bo.mission_statement,
291: p_hz_organization_bo.organization_type,
284: p_hz_organization_bo.jgzz_fiscal_code,
285: p_hz_organization_bo.analysis_fy,
286: p_hz_organization_bo.fiscal_yearend_month,
287: p_hz_organization_bo.curr_fy_potential_revenue,
288: p_hz_organization_bo.next_fy_potential_revenue,
289: p_hz_organization_bo.year_established,
290: p_hz_organization_bo.mission_statement,
291: p_hz_organization_bo.organization_type,
292: p_hz_organization_bo.business_scope,
285: p_hz_organization_bo.analysis_fy,
286: p_hz_organization_bo.fiscal_yearend_month,
287: p_hz_organization_bo.curr_fy_potential_revenue,
288: p_hz_organization_bo.next_fy_potential_revenue,
289: p_hz_organization_bo.year_established,
290: p_hz_organization_bo.mission_statement,
291: p_hz_organization_bo.organization_type,
292: p_hz_organization_bo.business_scope,
293: p_hz_organization_bo.corporation_class,
286: p_hz_organization_bo.fiscal_yearend_month,
287: p_hz_organization_bo.curr_fy_potential_revenue,
288: p_hz_organization_bo.next_fy_potential_revenue,
289: p_hz_organization_bo.year_established,
290: p_hz_organization_bo.mission_statement,
291: p_hz_organization_bo.organization_type,
292: p_hz_organization_bo.business_scope,
293: p_hz_organization_bo.corporation_class,
294: p_hz_organization_bo.known_as,
287: p_hz_organization_bo.curr_fy_potential_revenue,
288: p_hz_organization_bo.next_fy_potential_revenue,
289: p_hz_organization_bo.year_established,
290: p_hz_organization_bo.mission_statement,
291: p_hz_organization_bo.organization_type,
292: p_hz_organization_bo.business_scope,
293: p_hz_organization_bo.corporation_class,
294: p_hz_organization_bo.known_as,
295: p_hz_organization_bo.known_as2,
288: p_hz_organization_bo.next_fy_potential_revenue,
289: p_hz_organization_bo.year_established,
290: p_hz_organization_bo.mission_statement,
291: p_hz_organization_bo.organization_type,
292: p_hz_organization_bo.business_scope,
293: p_hz_organization_bo.corporation_class,
294: p_hz_organization_bo.known_as,
295: p_hz_organization_bo.known_as2,
296: p_hz_organization_bo.known_as3,
289: p_hz_organization_bo.year_established,
290: p_hz_organization_bo.mission_statement,
291: p_hz_organization_bo.organization_type,
292: p_hz_organization_bo.business_scope,
293: p_hz_organization_bo.corporation_class,
294: p_hz_organization_bo.known_as,
295: p_hz_organization_bo.known_as2,
296: p_hz_organization_bo.known_as3,
297: p_hz_organization_bo.known_as4,
290: p_hz_organization_bo.mission_statement,
291: p_hz_organization_bo.organization_type,
292: p_hz_organization_bo.business_scope,
293: p_hz_organization_bo.corporation_class,
294: p_hz_organization_bo.known_as,
295: p_hz_organization_bo.known_as2,
296: p_hz_organization_bo.known_as3,
297: p_hz_organization_bo.known_as4,
298: p_hz_organization_bo.known_as5,
291: p_hz_organization_bo.organization_type,
292: p_hz_organization_bo.business_scope,
293: p_hz_organization_bo.corporation_class,
294: p_hz_organization_bo.known_as,
295: p_hz_organization_bo.known_as2,
296: p_hz_organization_bo.known_as3,
297: p_hz_organization_bo.known_as4,
298: p_hz_organization_bo.known_as5,
299: p_hz_organization_bo.local_bus_iden_type,
292: p_hz_organization_bo.business_scope,
293: p_hz_organization_bo.corporation_class,
294: p_hz_organization_bo.known_as,
295: p_hz_organization_bo.known_as2,
296: p_hz_organization_bo.known_as3,
297: p_hz_organization_bo.known_as4,
298: p_hz_organization_bo.known_as5,
299: p_hz_organization_bo.local_bus_iden_type,
300: p_hz_organization_bo.local_bus_identifier,
293: p_hz_organization_bo.corporation_class,
294: p_hz_organization_bo.known_as,
295: p_hz_organization_bo.known_as2,
296: p_hz_organization_bo.known_as3,
297: p_hz_organization_bo.known_as4,
298: p_hz_organization_bo.known_as5,
299: p_hz_organization_bo.local_bus_iden_type,
300: p_hz_organization_bo.local_bus_identifier,
301: p_hz_organization_bo.pref_functional_currency,
294: p_hz_organization_bo.known_as,
295: p_hz_organization_bo.known_as2,
296: p_hz_organization_bo.known_as3,
297: p_hz_organization_bo.known_as4,
298: p_hz_organization_bo.known_as5,
299: p_hz_organization_bo.local_bus_iden_type,
300: p_hz_organization_bo.local_bus_identifier,
301: p_hz_organization_bo.pref_functional_currency,
302: p_hz_organization_bo.registration_type,
295: p_hz_organization_bo.known_as2,
296: p_hz_organization_bo.known_as3,
297: p_hz_organization_bo.known_as4,
298: p_hz_organization_bo.known_as5,
299: p_hz_organization_bo.local_bus_iden_type,
300: p_hz_organization_bo.local_bus_identifier,
301: p_hz_organization_bo.pref_functional_currency,
302: p_hz_organization_bo.registration_type,
303: p_hz_organization_bo.total_employees_text,
296: p_hz_organization_bo.known_as3,
297: p_hz_organization_bo.known_as4,
298: p_hz_organization_bo.known_as5,
299: p_hz_organization_bo.local_bus_iden_type,
300: p_hz_organization_bo.local_bus_identifier,
301: p_hz_organization_bo.pref_functional_currency,
302: p_hz_organization_bo.registration_type,
303: p_hz_organization_bo.total_employees_text,
304: p_hz_organization_bo.total_employees_ind,
297: p_hz_organization_bo.known_as4,
298: p_hz_organization_bo.known_as5,
299: p_hz_organization_bo.local_bus_iden_type,
300: p_hz_organization_bo.local_bus_identifier,
301: p_hz_organization_bo.pref_functional_currency,
302: p_hz_organization_bo.registration_type,
303: p_hz_organization_bo.total_employees_text,
304: p_hz_organization_bo.total_employees_ind,
305: p_hz_organization_bo.total_emp_est_ind,
298: p_hz_organization_bo.known_as5,
299: p_hz_organization_bo.local_bus_iden_type,
300: p_hz_organization_bo.local_bus_identifier,
301: p_hz_organization_bo.pref_functional_currency,
302: p_hz_organization_bo.registration_type,
303: p_hz_organization_bo.total_employees_text,
304: p_hz_organization_bo.total_employees_ind,
305: p_hz_organization_bo.total_emp_est_ind,
306: p_hz_organization_bo.total_emp_min_ind,
299: p_hz_organization_bo.local_bus_iden_type,
300: p_hz_organization_bo.local_bus_identifier,
301: p_hz_organization_bo.pref_functional_currency,
302: p_hz_organization_bo.registration_type,
303: p_hz_organization_bo.total_employees_text,
304: p_hz_organization_bo.total_employees_ind,
305: p_hz_organization_bo.total_emp_est_ind,
306: p_hz_organization_bo.total_emp_min_ind,
307: p_hz_organization_bo.parent_sub_ind,
300: p_hz_organization_bo.local_bus_identifier,
301: p_hz_organization_bo.pref_functional_currency,
302: p_hz_organization_bo.registration_type,
303: p_hz_organization_bo.total_employees_text,
304: p_hz_organization_bo.total_employees_ind,
305: p_hz_organization_bo.total_emp_est_ind,
306: p_hz_organization_bo.total_emp_min_ind,
307: p_hz_organization_bo.parent_sub_ind,
308: p_hz_organization_bo.incorp_year,
301: p_hz_organization_bo.pref_functional_currency,
302: p_hz_organization_bo.registration_type,
303: p_hz_organization_bo.total_employees_text,
304: p_hz_organization_bo.total_employees_ind,
305: p_hz_organization_bo.total_emp_est_ind,
306: p_hz_organization_bo.total_emp_min_ind,
307: p_hz_organization_bo.parent_sub_ind,
308: p_hz_organization_bo.incorp_year,
309: p_hz_organization_bo.sic_code_type,
302: p_hz_organization_bo.registration_type,
303: p_hz_organization_bo.total_employees_text,
304: p_hz_organization_bo.total_employees_ind,
305: p_hz_organization_bo.total_emp_est_ind,
306: p_hz_organization_bo.total_emp_min_ind,
307: p_hz_organization_bo.parent_sub_ind,
308: p_hz_organization_bo.incorp_year,
309: p_hz_organization_bo.sic_code_type,
310: p_hz_organization_bo.public_private_owner_flag,
303: p_hz_organization_bo.total_employees_text,
304: p_hz_organization_bo.total_employees_ind,
305: p_hz_organization_bo.total_emp_est_ind,
306: p_hz_organization_bo.total_emp_min_ind,
307: p_hz_organization_bo.parent_sub_ind,
308: p_hz_organization_bo.incorp_year,
309: p_hz_organization_bo.sic_code_type,
310: p_hz_organization_bo.public_private_owner_flag,
311: p_hz_organization_bo.internal_flag,
304: p_hz_organization_bo.total_employees_ind,
305: p_hz_organization_bo.total_emp_est_ind,
306: p_hz_organization_bo.total_emp_min_ind,
307: p_hz_organization_bo.parent_sub_ind,
308: p_hz_organization_bo.incorp_year,
309: p_hz_organization_bo.sic_code_type,
310: p_hz_organization_bo.public_private_owner_flag,
311: p_hz_organization_bo.internal_flag,
312: p_hz_organization_bo.local_activity_code_type,
305: p_hz_organization_bo.total_emp_est_ind,
306: p_hz_organization_bo.total_emp_min_ind,
307: p_hz_organization_bo.parent_sub_ind,
308: p_hz_organization_bo.incorp_year,
309: p_hz_organization_bo.sic_code_type,
310: p_hz_organization_bo.public_private_owner_flag,
311: p_hz_organization_bo.internal_flag,
312: p_hz_organization_bo.local_activity_code_type,
313: p_hz_organization_bo.local_activity_code,
306: p_hz_organization_bo.total_emp_min_ind,
307: p_hz_organization_bo.parent_sub_ind,
308: p_hz_organization_bo.incorp_year,
309: p_hz_organization_bo.sic_code_type,
310: p_hz_organization_bo.public_private_owner_flag,
311: p_hz_organization_bo.internal_flag,
312: p_hz_organization_bo.local_activity_code_type,
313: p_hz_organization_bo.local_activity_code,
314: p_hz_organization_bo.emp_at_primary_adr,
307: p_hz_organization_bo.parent_sub_ind,
308: p_hz_organization_bo.incorp_year,
309: p_hz_organization_bo.sic_code_type,
310: p_hz_organization_bo.public_private_owner_flag,
311: p_hz_organization_bo.internal_flag,
312: p_hz_organization_bo.local_activity_code_type,
313: p_hz_organization_bo.local_activity_code,
314: p_hz_organization_bo.emp_at_primary_adr,
315: p_hz_organization_bo.emp_at_primary_adr_text,
308: p_hz_organization_bo.incorp_year,
309: p_hz_organization_bo.sic_code_type,
310: p_hz_organization_bo.public_private_owner_flag,
311: p_hz_organization_bo.internal_flag,
312: p_hz_organization_bo.local_activity_code_type,
313: p_hz_organization_bo.local_activity_code,
314: p_hz_organization_bo.emp_at_primary_adr,
315: p_hz_organization_bo.emp_at_primary_adr_text,
316: p_hz_organization_bo.emp_at_primary_adr_est_ind,
309: p_hz_organization_bo.sic_code_type,
310: p_hz_organization_bo.public_private_owner_flag,
311: p_hz_organization_bo.internal_flag,
312: p_hz_organization_bo.local_activity_code_type,
313: p_hz_organization_bo.local_activity_code,
314: p_hz_organization_bo.emp_at_primary_adr,
315: p_hz_organization_bo.emp_at_primary_adr_text,
316: p_hz_organization_bo.emp_at_primary_adr_est_ind,
317: p_hz_organization_bo.emp_at_primary_adr_min_ind,
310: p_hz_organization_bo.public_private_owner_flag,
311: p_hz_organization_bo.internal_flag,
312: p_hz_organization_bo.local_activity_code_type,
313: p_hz_organization_bo.local_activity_code,
314: p_hz_organization_bo.emp_at_primary_adr,
315: p_hz_organization_bo.emp_at_primary_adr_text,
316: p_hz_organization_bo.emp_at_primary_adr_est_ind,
317: p_hz_organization_bo.emp_at_primary_adr_min_ind,
318: p_hz_organization_bo.high_credit,
311: p_hz_organization_bo.internal_flag,
312: p_hz_organization_bo.local_activity_code_type,
313: p_hz_organization_bo.local_activity_code,
314: p_hz_organization_bo.emp_at_primary_adr,
315: p_hz_organization_bo.emp_at_primary_adr_text,
316: p_hz_organization_bo.emp_at_primary_adr_est_ind,
317: p_hz_organization_bo.emp_at_primary_adr_min_ind,
318: p_hz_organization_bo.high_credit,
319: p_hz_organization_bo.avg_high_credit,
312: p_hz_organization_bo.local_activity_code_type,
313: p_hz_organization_bo.local_activity_code,
314: p_hz_organization_bo.emp_at_primary_adr,
315: p_hz_organization_bo.emp_at_primary_adr_text,
316: p_hz_organization_bo.emp_at_primary_adr_est_ind,
317: p_hz_organization_bo.emp_at_primary_adr_min_ind,
318: p_hz_organization_bo.high_credit,
319: p_hz_organization_bo.avg_high_credit,
320: p_hz_organization_bo.total_payments,
313: p_hz_organization_bo.local_activity_code,
314: p_hz_organization_bo.emp_at_primary_adr,
315: p_hz_organization_bo.emp_at_primary_adr_text,
316: p_hz_organization_bo.emp_at_primary_adr_est_ind,
317: p_hz_organization_bo.emp_at_primary_adr_min_ind,
318: p_hz_organization_bo.high_credit,
319: p_hz_organization_bo.avg_high_credit,
320: p_hz_organization_bo.total_payments,
321: p_hz_organization_bo.credit_score_class,
314: p_hz_organization_bo.emp_at_primary_adr,
315: p_hz_organization_bo.emp_at_primary_adr_text,
316: p_hz_organization_bo.emp_at_primary_adr_est_ind,
317: p_hz_organization_bo.emp_at_primary_adr_min_ind,
318: p_hz_organization_bo.high_credit,
319: p_hz_organization_bo.avg_high_credit,
320: p_hz_organization_bo.total_payments,
321: p_hz_organization_bo.credit_score_class,
322: p_hz_organization_bo.credit_score_natl_percentile,
315: p_hz_organization_bo.emp_at_primary_adr_text,
316: p_hz_organization_bo.emp_at_primary_adr_est_ind,
317: p_hz_organization_bo.emp_at_primary_adr_min_ind,
318: p_hz_organization_bo.high_credit,
319: p_hz_organization_bo.avg_high_credit,
320: p_hz_organization_bo.total_payments,
321: p_hz_organization_bo.credit_score_class,
322: p_hz_organization_bo.credit_score_natl_percentile,
323: p_hz_organization_bo.credit_score_incd_default,
316: p_hz_organization_bo.emp_at_primary_adr_est_ind,
317: p_hz_organization_bo.emp_at_primary_adr_min_ind,
318: p_hz_organization_bo.high_credit,
319: p_hz_organization_bo.avg_high_credit,
320: p_hz_organization_bo.total_payments,
321: p_hz_organization_bo.credit_score_class,
322: p_hz_organization_bo.credit_score_natl_percentile,
323: p_hz_organization_bo.credit_score_incd_default,
324: p_hz_organization_bo.credit_score_age,
317: p_hz_organization_bo.emp_at_primary_adr_min_ind,
318: p_hz_organization_bo.high_credit,
319: p_hz_organization_bo.avg_high_credit,
320: p_hz_organization_bo.total_payments,
321: p_hz_organization_bo.credit_score_class,
322: p_hz_organization_bo.credit_score_natl_percentile,
323: p_hz_organization_bo.credit_score_incd_default,
324: p_hz_organization_bo.credit_score_age,
325: p_hz_organization_bo.credit_score_date,
318: p_hz_organization_bo.high_credit,
319: p_hz_organization_bo.avg_high_credit,
320: p_hz_organization_bo.total_payments,
321: p_hz_organization_bo.credit_score_class,
322: p_hz_organization_bo.credit_score_natl_percentile,
323: p_hz_organization_bo.credit_score_incd_default,
324: p_hz_organization_bo.credit_score_age,
325: p_hz_organization_bo.credit_score_date,
326: p_hz_organization_bo.credit_score_commentary2,
319: p_hz_organization_bo.avg_high_credit,
320: p_hz_organization_bo.total_payments,
321: p_hz_organization_bo.credit_score_class,
322: p_hz_organization_bo.credit_score_natl_percentile,
323: p_hz_organization_bo.credit_score_incd_default,
324: p_hz_organization_bo.credit_score_age,
325: p_hz_organization_bo.credit_score_date,
326: p_hz_organization_bo.credit_score_commentary2,
327: p_hz_organization_bo.credit_score_commentary3,
320: p_hz_organization_bo.total_payments,
321: p_hz_organization_bo.credit_score_class,
322: p_hz_organization_bo.credit_score_natl_percentile,
323: p_hz_organization_bo.credit_score_incd_default,
324: p_hz_organization_bo.credit_score_age,
325: p_hz_organization_bo.credit_score_date,
326: p_hz_organization_bo.credit_score_commentary2,
327: p_hz_organization_bo.credit_score_commentary3,
328: p_hz_organization_bo.credit_score_commentary4,
321: p_hz_organization_bo.credit_score_class,
322: p_hz_organization_bo.credit_score_natl_percentile,
323: p_hz_organization_bo.credit_score_incd_default,
324: p_hz_organization_bo.credit_score_age,
325: p_hz_organization_bo.credit_score_date,
326: p_hz_organization_bo.credit_score_commentary2,
327: p_hz_organization_bo.credit_score_commentary3,
328: p_hz_organization_bo.credit_score_commentary4,
329: p_hz_organization_bo.credit_score_commentary5,
322: p_hz_organization_bo.credit_score_natl_percentile,
323: p_hz_organization_bo.credit_score_incd_default,
324: p_hz_organization_bo.credit_score_age,
325: p_hz_organization_bo.credit_score_date,
326: p_hz_organization_bo.credit_score_commentary2,
327: p_hz_organization_bo.credit_score_commentary3,
328: p_hz_organization_bo.credit_score_commentary4,
329: p_hz_organization_bo.credit_score_commentary5,
330: p_hz_organization_bo.credit_score_commentary6,
323: p_hz_organization_bo.credit_score_incd_default,
324: p_hz_organization_bo.credit_score_age,
325: p_hz_organization_bo.credit_score_date,
326: p_hz_organization_bo.credit_score_commentary2,
327: p_hz_organization_bo.credit_score_commentary3,
328: p_hz_organization_bo.credit_score_commentary4,
329: p_hz_organization_bo.credit_score_commentary5,
330: p_hz_organization_bo.credit_score_commentary6,
331: p_hz_organization_bo.credit_score_commentary7,
324: p_hz_organization_bo.credit_score_age,
325: p_hz_organization_bo.credit_score_date,
326: p_hz_organization_bo.credit_score_commentary2,
327: p_hz_organization_bo.credit_score_commentary3,
328: p_hz_organization_bo.credit_score_commentary4,
329: p_hz_organization_bo.credit_score_commentary5,
330: p_hz_organization_bo.credit_score_commentary6,
331: p_hz_organization_bo.credit_score_commentary7,
332: p_hz_organization_bo.credit_score_commentary8,
325: p_hz_organization_bo.credit_score_date,
326: p_hz_organization_bo.credit_score_commentary2,
327: p_hz_organization_bo.credit_score_commentary3,
328: p_hz_organization_bo.credit_score_commentary4,
329: p_hz_organization_bo.credit_score_commentary5,
330: p_hz_organization_bo.credit_score_commentary6,
331: p_hz_organization_bo.credit_score_commentary7,
332: p_hz_organization_bo.credit_score_commentary8,
333: p_hz_organization_bo.credit_score_commentary9,
326: p_hz_organization_bo.credit_score_commentary2,
327: p_hz_organization_bo.credit_score_commentary3,
328: p_hz_organization_bo.credit_score_commentary4,
329: p_hz_organization_bo.credit_score_commentary5,
330: p_hz_organization_bo.credit_score_commentary6,
331: p_hz_organization_bo.credit_score_commentary7,
332: p_hz_organization_bo.credit_score_commentary8,
333: p_hz_organization_bo.credit_score_commentary9,
334: p_hz_organization_bo.credit_score_commentary10,
327: p_hz_organization_bo.credit_score_commentary3,
328: p_hz_organization_bo.credit_score_commentary4,
329: p_hz_organization_bo.credit_score_commentary5,
330: p_hz_organization_bo.credit_score_commentary6,
331: p_hz_organization_bo.credit_score_commentary7,
332: p_hz_organization_bo.credit_score_commentary8,
333: p_hz_organization_bo.credit_score_commentary9,
334: p_hz_organization_bo.credit_score_commentary10,
335: p_hz_organization_bo.failure_score_class,
328: p_hz_organization_bo.credit_score_commentary4,
329: p_hz_organization_bo.credit_score_commentary5,
330: p_hz_organization_bo.credit_score_commentary6,
331: p_hz_organization_bo.credit_score_commentary7,
332: p_hz_organization_bo.credit_score_commentary8,
333: p_hz_organization_bo.credit_score_commentary9,
334: p_hz_organization_bo.credit_score_commentary10,
335: p_hz_organization_bo.failure_score_class,
336: p_hz_organization_bo.failure_score_incd_default,
329: p_hz_organization_bo.credit_score_commentary5,
330: p_hz_organization_bo.credit_score_commentary6,
331: p_hz_organization_bo.credit_score_commentary7,
332: p_hz_organization_bo.credit_score_commentary8,
333: p_hz_organization_bo.credit_score_commentary9,
334: p_hz_organization_bo.credit_score_commentary10,
335: p_hz_organization_bo.failure_score_class,
336: p_hz_organization_bo.failure_score_incd_default,
337: p_hz_organization_bo.failure_score_age,
330: p_hz_organization_bo.credit_score_commentary6,
331: p_hz_organization_bo.credit_score_commentary7,
332: p_hz_organization_bo.credit_score_commentary8,
333: p_hz_organization_bo.credit_score_commentary9,
334: p_hz_organization_bo.credit_score_commentary10,
335: p_hz_organization_bo.failure_score_class,
336: p_hz_organization_bo.failure_score_incd_default,
337: p_hz_organization_bo.failure_score_age,
338: p_hz_organization_bo.failure_score_date,
331: p_hz_organization_bo.credit_score_commentary7,
332: p_hz_organization_bo.credit_score_commentary8,
333: p_hz_organization_bo.credit_score_commentary9,
334: p_hz_organization_bo.credit_score_commentary10,
335: p_hz_organization_bo.failure_score_class,
336: p_hz_organization_bo.failure_score_incd_default,
337: p_hz_organization_bo.failure_score_age,
338: p_hz_organization_bo.failure_score_date,
339: p_hz_organization_bo.failure_score_commentary2,
332: p_hz_organization_bo.credit_score_commentary8,
333: p_hz_organization_bo.credit_score_commentary9,
334: p_hz_organization_bo.credit_score_commentary10,
335: p_hz_organization_bo.failure_score_class,
336: p_hz_organization_bo.failure_score_incd_default,
337: p_hz_organization_bo.failure_score_age,
338: p_hz_organization_bo.failure_score_date,
339: p_hz_organization_bo.failure_score_commentary2,
340: p_hz_organization_bo.failure_score_commentary3,
333: p_hz_organization_bo.credit_score_commentary9,
334: p_hz_organization_bo.credit_score_commentary10,
335: p_hz_organization_bo.failure_score_class,
336: p_hz_organization_bo.failure_score_incd_default,
337: p_hz_organization_bo.failure_score_age,
338: p_hz_organization_bo.failure_score_date,
339: p_hz_organization_bo.failure_score_commentary2,
340: p_hz_organization_bo.failure_score_commentary3,
341: p_hz_organization_bo.failure_score_commentary4,
334: p_hz_organization_bo.credit_score_commentary10,
335: p_hz_organization_bo.failure_score_class,
336: p_hz_organization_bo.failure_score_incd_default,
337: p_hz_organization_bo.failure_score_age,
338: p_hz_organization_bo.failure_score_date,
339: p_hz_organization_bo.failure_score_commentary2,
340: p_hz_organization_bo.failure_score_commentary3,
341: p_hz_organization_bo.failure_score_commentary4,
342: p_hz_organization_bo.failure_score_commentary5,
335: p_hz_organization_bo.failure_score_class,
336: p_hz_organization_bo.failure_score_incd_default,
337: p_hz_organization_bo.failure_score_age,
338: p_hz_organization_bo.failure_score_date,
339: p_hz_organization_bo.failure_score_commentary2,
340: p_hz_organization_bo.failure_score_commentary3,
341: p_hz_organization_bo.failure_score_commentary4,
342: p_hz_organization_bo.failure_score_commentary5,
343: p_hz_organization_bo.failure_score_commentary6,
336: p_hz_organization_bo.failure_score_incd_default,
337: p_hz_organization_bo.failure_score_age,
338: p_hz_organization_bo.failure_score_date,
339: p_hz_organization_bo.failure_score_commentary2,
340: p_hz_organization_bo.failure_score_commentary3,
341: p_hz_organization_bo.failure_score_commentary4,
342: p_hz_organization_bo.failure_score_commentary5,
343: p_hz_organization_bo.failure_score_commentary6,
344: p_hz_organization_bo.failure_score_commentary7,
337: p_hz_organization_bo.failure_score_age,
338: p_hz_organization_bo.failure_score_date,
339: p_hz_organization_bo.failure_score_commentary2,
340: p_hz_organization_bo.failure_score_commentary3,
341: p_hz_organization_bo.failure_score_commentary4,
342: p_hz_organization_bo.failure_score_commentary5,
343: p_hz_organization_bo.failure_score_commentary6,
344: p_hz_organization_bo.failure_score_commentary7,
345: p_hz_organization_bo.failure_score_commentary8,
338: p_hz_organization_bo.failure_score_date,
339: p_hz_organization_bo.failure_score_commentary2,
340: p_hz_organization_bo.failure_score_commentary3,
341: p_hz_organization_bo.failure_score_commentary4,
342: p_hz_organization_bo.failure_score_commentary5,
343: p_hz_organization_bo.failure_score_commentary6,
344: p_hz_organization_bo.failure_score_commentary7,
345: p_hz_organization_bo.failure_score_commentary8,
346: p_hz_organization_bo.failure_score_commentary9,
339: p_hz_organization_bo.failure_score_commentary2,
340: p_hz_organization_bo.failure_score_commentary3,
341: p_hz_organization_bo.failure_score_commentary4,
342: p_hz_organization_bo.failure_score_commentary5,
343: p_hz_organization_bo.failure_score_commentary6,
344: p_hz_organization_bo.failure_score_commentary7,
345: p_hz_organization_bo.failure_score_commentary8,
346: p_hz_organization_bo.failure_score_commentary9,
347: p_hz_organization_bo.failure_score_commentary10,
340: p_hz_organization_bo.failure_score_commentary3,
341: p_hz_organization_bo.failure_score_commentary4,
342: p_hz_organization_bo.failure_score_commentary5,
343: p_hz_organization_bo.failure_score_commentary6,
344: p_hz_organization_bo.failure_score_commentary7,
345: p_hz_organization_bo.failure_score_commentary8,
346: p_hz_organization_bo.failure_score_commentary9,
347: p_hz_organization_bo.failure_score_commentary10,
348: p_hz_organization_bo.maximum_credit_recommend,
341: p_hz_organization_bo.failure_score_commentary4,
342: p_hz_organization_bo.failure_score_commentary5,
343: p_hz_organization_bo.failure_score_commentary6,
344: p_hz_organization_bo.failure_score_commentary7,
345: p_hz_organization_bo.failure_score_commentary8,
346: p_hz_organization_bo.failure_score_commentary9,
347: p_hz_organization_bo.failure_score_commentary10,
348: p_hz_organization_bo.maximum_credit_recommend,
349: p_hz_organization_bo.maximum_credit_currency_code,
342: p_hz_organization_bo.failure_score_commentary5,
343: p_hz_organization_bo.failure_score_commentary6,
344: p_hz_organization_bo.failure_score_commentary7,
345: p_hz_organization_bo.failure_score_commentary8,
346: p_hz_organization_bo.failure_score_commentary9,
347: p_hz_organization_bo.failure_score_commentary10,
348: p_hz_organization_bo.maximum_credit_recommend,
349: p_hz_organization_bo.maximum_credit_currency_code,
350: p_hz_organization_bo.displayed_duns_party_id,
343: p_hz_organization_bo.failure_score_commentary6,
344: p_hz_organization_bo.failure_score_commentary7,
345: p_hz_organization_bo.failure_score_commentary8,
346: p_hz_organization_bo.failure_score_commentary9,
347: p_hz_organization_bo.failure_score_commentary10,
348: p_hz_organization_bo.maximum_credit_recommend,
349: p_hz_organization_bo.maximum_credit_currency_code,
350: p_hz_organization_bo.displayed_duns_party_id,
351: p_hz_organization_bo.program_update_date,
344: p_hz_organization_bo.failure_score_commentary7,
345: p_hz_organization_bo.failure_score_commentary8,
346: p_hz_organization_bo.failure_score_commentary9,
347: p_hz_organization_bo.failure_score_commentary10,
348: p_hz_organization_bo.maximum_credit_recommend,
349: p_hz_organization_bo.maximum_credit_currency_code,
350: p_hz_organization_bo.displayed_duns_party_id,
351: p_hz_organization_bo.program_update_date,
352: p_hz_organization_bo.created_by_module,
345: p_hz_organization_bo.failure_score_commentary8,
346: p_hz_organization_bo.failure_score_commentary9,
347: p_hz_organization_bo.failure_score_commentary10,
348: p_hz_organization_bo.maximum_credit_recommend,
349: p_hz_organization_bo.maximum_credit_currency_code,
350: p_hz_organization_bo.displayed_duns_party_id,
351: p_hz_organization_bo.program_update_date,
352: p_hz_organization_bo.created_by_module,
353: p_hz_organization_bo.created_by_name,
346: p_hz_organization_bo.failure_score_commentary9,
347: p_hz_organization_bo.failure_score_commentary10,
348: p_hz_organization_bo.maximum_credit_recommend,
349: p_hz_organization_bo.maximum_credit_currency_code,
350: p_hz_organization_bo.displayed_duns_party_id,
351: p_hz_organization_bo.program_update_date,
352: p_hz_organization_bo.created_by_module,
353: p_hz_organization_bo.created_by_name,
354: p_hz_organization_bo.creation_date,
347: p_hz_organization_bo.failure_score_commentary10,
348: p_hz_organization_bo.maximum_credit_recommend,
349: p_hz_organization_bo.maximum_credit_currency_code,
350: p_hz_organization_bo.displayed_duns_party_id,
351: p_hz_organization_bo.program_update_date,
352: p_hz_organization_bo.created_by_module,
353: p_hz_organization_bo.created_by_name,
354: p_hz_organization_bo.creation_date,
355: p_hz_organization_bo.last_update_date,
348: p_hz_organization_bo.maximum_credit_recommend,
349: p_hz_organization_bo.maximum_credit_currency_code,
350: p_hz_organization_bo.displayed_duns_party_id,
351: p_hz_organization_bo.program_update_date,
352: p_hz_organization_bo.created_by_module,
353: p_hz_organization_bo.created_by_name,
354: p_hz_organization_bo.creation_date,
355: p_hz_organization_bo.last_update_date,
356: p_hz_organization_bo.last_updated_by_name,
349: p_hz_organization_bo.maximum_credit_currency_code,
350: p_hz_organization_bo.displayed_duns_party_id,
351: p_hz_organization_bo.program_update_date,
352: p_hz_organization_bo.created_by_module,
353: p_hz_organization_bo.created_by_name,
354: p_hz_organization_bo.creation_date,
355: p_hz_organization_bo.last_update_date,
356: p_hz_organization_bo.last_updated_by_name,
357: p_hz_organization_bo.do_not_confuse_with,
350: p_hz_organization_bo.displayed_duns_party_id,
351: p_hz_organization_bo.program_update_date,
352: p_hz_organization_bo.created_by_module,
353: p_hz_organization_bo.created_by_name,
354: p_hz_organization_bo.creation_date,
355: p_hz_organization_bo.last_update_date,
356: p_hz_organization_bo.last_updated_by_name,
357: p_hz_organization_bo.do_not_confuse_with,
358: p_hz_organization_bo.actual_content_source,
351: p_hz_organization_bo.program_update_date,
352: p_hz_organization_bo.created_by_module,
353: p_hz_organization_bo.created_by_name,
354: p_hz_organization_bo.creation_date,
355: p_hz_organization_bo.last_update_date,
356: p_hz_organization_bo.last_updated_by_name,
357: p_hz_organization_bo.do_not_confuse_with,
358: p_hz_organization_bo.actual_content_source,
359: p_hz_organization_bo.orig_sys_objs,
352: p_hz_organization_bo.created_by_module,
353: p_hz_organization_bo.created_by_name,
354: p_hz_organization_bo.creation_date,
355: p_hz_organization_bo.last_update_date,
356: p_hz_organization_bo.last_updated_by_name,
357: p_hz_organization_bo.do_not_confuse_with,
358: p_hz_organization_bo.actual_content_source,
359: p_hz_organization_bo.orig_sys_objs,
360: p_hz_organization_bo.ext_attributes_objs,
353: p_hz_organization_bo.created_by_name,
354: p_hz_organization_bo.creation_date,
355: p_hz_organization_bo.last_update_date,
356: p_hz_organization_bo.last_updated_by_name,
357: p_hz_organization_bo.do_not_confuse_with,
358: p_hz_organization_bo.actual_content_source,
359: p_hz_organization_bo.orig_sys_objs,
360: p_hz_organization_bo.ext_attributes_objs,
361: l_contact_objs,
354: p_hz_organization_bo.creation_date,
355: p_hz_organization_bo.last_update_date,
356: p_hz_organization_bo.last_updated_by_name,
357: p_hz_organization_bo.do_not_confuse_with,
358: p_hz_organization_bo.actual_content_source,
359: p_hz_organization_bo.orig_sys_objs,
360: p_hz_organization_bo.ext_attributes_objs,
361: l_contact_objs,
362: l_party_site_objs_2,
355: p_hz_organization_bo.last_update_date,
356: p_hz_organization_bo.last_updated_by_name,
357: p_hz_organization_bo.do_not_confuse_with,
358: p_hz_organization_bo.actual_content_source,
359: p_hz_organization_bo.orig_sys_objs,
360: p_hz_organization_bo.ext_attributes_objs,
361: l_contact_objs,
362: l_party_site_objs_2,
363: p_hz_organization_bo.preference_objs,
356: p_hz_organization_bo.last_updated_by_name,
357: p_hz_organization_bo.do_not_confuse_with,
358: p_hz_organization_bo.actual_content_source,
359: p_hz_organization_bo.orig_sys_objs,
360: p_hz_organization_bo.ext_attributes_objs,
361: l_contact_objs,
362: l_party_site_objs_2,
363: p_hz_organization_bo.preference_objs,
364: p_hz_organization_bo.phone_objs,
359: p_hz_organization_bo.orig_sys_objs,
360: p_hz_organization_bo.ext_attributes_objs,
361: l_contact_objs,
362: l_party_site_objs_2,
363: p_hz_organization_bo.preference_objs,
364: p_hz_organization_bo.phone_objs,
365: p_hz_organization_bo.telex_objs,
366: p_hz_organization_bo.email_objs,
367: p_hz_organization_bo.web_objs,
360: p_hz_organization_bo.ext_attributes_objs,
361: l_contact_objs,
362: l_party_site_objs_2,
363: p_hz_organization_bo.preference_objs,
364: p_hz_organization_bo.phone_objs,
365: p_hz_organization_bo.telex_objs,
366: p_hz_organization_bo.email_objs,
367: p_hz_organization_bo.web_objs,
368: p_hz_organization_bo.edi_objs,
361: l_contact_objs,
362: l_party_site_objs_2,
363: p_hz_organization_bo.preference_objs,
364: p_hz_organization_bo.phone_objs,
365: p_hz_organization_bo.telex_objs,
366: p_hz_organization_bo.email_objs,
367: p_hz_organization_bo.web_objs,
368: p_hz_organization_bo.edi_objs,
369: p_hz_organization_bo.eft_objs,
362: l_party_site_objs_2,
363: p_hz_organization_bo.preference_objs,
364: p_hz_organization_bo.phone_objs,
365: p_hz_organization_bo.telex_objs,
366: p_hz_organization_bo.email_objs,
367: p_hz_organization_bo.web_objs,
368: p_hz_organization_bo.edi_objs,
369: p_hz_organization_bo.eft_objs,
370: p_hz_organization_bo.relationship_objs,
363: p_hz_organization_bo.preference_objs,
364: p_hz_organization_bo.phone_objs,
365: p_hz_organization_bo.telex_objs,
366: p_hz_organization_bo.email_objs,
367: p_hz_organization_bo.web_objs,
368: p_hz_organization_bo.edi_objs,
369: p_hz_organization_bo.eft_objs,
370: p_hz_organization_bo.relationship_objs,
371: p_hz_organization_bo.class_objs,
364: p_hz_organization_bo.phone_objs,
365: p_hz_organization_bo.telex_objs,
366: p_hz_organization_bo.email_objs,
367: p_hz_organization_bo.web_objs,
368: p_hz_organization_bo.edi_objs,
369: p_hz_organization_bo.eft_objs,
370: p_hz_organization_bo.relationship_objs,
371: p_hz_organization_bo.class_objs,
372: p_hz_organization_bo.financial_report_objs,
365: p_hz_organization_bo.telex_objs,
366: p_hz_organization_bo.email_objs,
367: p_hz_organization_bo.web_objs,
368: p_hz_organization_bo.edi_objs,
369: p_hz_organization_bo.eft_objs,
370: p_hz_organization_bo.relationship_objs,
371: p_hz_organization_bo.class_objs,
372: p_hz_organization_bo.financial_report_objs,
373: p_hz_organization_bo.credit_rating_objs,
366: p_hz_organization_bo.email_objs,
367: p_hz_organization_bo.web_objs,
368: p_hz_organization_bo.edi_objs,
369: p_hz_organization_bo.eft_objs,
370: p_hz_organization_bo.relationship_objs,
371: p_hz_organization_bo.class_objs,
372: p_hz_organization_bo.financial_report_objs,
373: p_hz_organization_bo.credit_rating_objs,
374: p_hz_organization_bo.certification_objs,
367: p_hz_organization_bo.web_objs,
368: p_hz_organization_bo.edi_objs,
369: p_hz_organization_bo.eft_objs,
370: p_hz_organization_bo.relationship_objs,
371: p_hz_organization_bo.class_objs,
372: p_hz_organization_bo.financial_report_objs,
373: p_hz_organization_bo.credit_rating_objs,
374: p_hz_organization_bo.certification_objs,
375: p_hz_organization_bo.financial_prof_objs,
368: p_hz_organization_bo.edi_objs,
369: p_hz_organization_bo.eft_objs,
370: p_hz_organization_bo.relationship_objs,
371: p_hz_organization_bo.class_objs,
372: p_hz_organization_bo.financial_report_objs,
373: p_hz_organization_bo.credit_rating_objs,
374: p_hz_organization_bo.certification_objs,
375: p_hz_organization_bo.financial_prof_objs,
376: p_hz_organization_bo.contact_pref_objs,
369: p_hz_organization_bo.eft_objs,
370: p_hz_organization_bo.relationship_objs,
371: p_hz_organization_bo.class_objs,
372: p_hz_organization_bo.financial_report_objs,
373: p_hz_organization_bo.credit_rating_objs,
374: p_hz_organization_bo.certification_objs,
375: p_hz_organization_bo.financial_prof_objs,
376: p_hz_organization_bo.contact_pref_objs,
377: p_hz_organization_bo.party_usage_objs);
370: p_hz_organization_bo.relationship_objs,
371: p_hz_organization_bo.class_objs,
372: p_hz_organization_bo.financial_report_objs,
373: p_hz_organization_bo.credit_rating_objs,
374: p_hz_organization_bo.certification_objs,
375: p_hz_organization_bo.financial_prof_objs,
376: p_hz_organization_bo.contact_pref_objs,
377: p_hz_organization_bo.party_usage_objs);
378:
371: p_hz_organization_bo.class_objs,
372: p_hz_organization_bo.financial_report_objs,
373: p_hz_organization_bo.credit_rating_objs,
374: p_hz_organization_bo.certification_objs,
375: p_hz_organization_bo.financial_prof_objs,
376: p_hz_organization_bo.contact_pref_objs,
377: p_hz_organization_bo.party_usage_objs);
378:
379: EXCEPTION
372: p_hz_organization_bo.financial_report_objs,
373: p_hz_organization_bo.credit_rating_objs,
374: p_hz_organization_bo.certification_objs,
375: p_hz_organization_bo.financial_prof_objs,
376: p_hz_organization_bo.contact_pref_objs,
377: p_hz_organization_bo.party_usage_objs);
378:
379: EXCEPTION
380: WHEN OTHERS THEN
373: p_hz_organization_bo.credit_rating_objs,
374: p_hz_organization_bo.certification_objs,
375: p_hz_organization_bo.financial_prof_objs,
376: p_hz_organization_bo.contact_pref_objs,
377: p_hz_organization_bo.party_usage_objs);
378:
379: EXCEPTION
380: WHEN OTHERS THEN
381: fnd_file.put_line(fnd_file.log,'exception detected in assign_organization.');
423: x_pos_bank_payment_bo_tbl pos_bank_payment_bo_tbl;
424: x_pos_bank_account_bo_tbl pos_bank_account_bo_tbl;
425: x_pos_bank_payee_bo_tbl pos_bank_payee_bo_tbl;
426: x_pos_tax_report_bo_tbl pos_tax_report_bo_tbl;
427: x_hz_organization_bo hz_organization_bo;
428: x_pos_organization_bo pos_organization_bo;
429: x_hz_org_contact_bo_tbl hz_org_contact_bo_tbl;
430: x_hz_locations_bo_tbl pos_hz_location_bo_tbl;
431: x_hz_party_bo pos_hz_party_bo;
536:
537: -- End Bug 12795884
538:
539: --organization
540: hz_organization_bo_pub.get_organization_bo(p_init_msg_list,
541: l_party_id,
542: p_orig_system,
543: p_orig_system_reference,
544: x_hz_organization_bo,
540: hz_organization_bo_pub.get_organization_bo(p_init_msg_list,
541: l_party_id,
542: p_orig_system,
543: p_orig_system_reference,
544: x_hz_organization_bo,
545: x_return_status,
546: x_msg_count,
547: x_msg_data);
548:
693: x_pos_supplier_bo.p_pos_tax_report_bo_tbl := x_pos_tax_report_bo_tbl;
694: x_pos_supplier_bo.p_pos_hz_party_bo := x_hz_party_bo;
695: x_pos_supplier_bo.p_pos_hz_party_site_bo_tbl := x_pos_hz_party_site_bo_tbl;
696:
697: assign_organization(x_hz_organization_bo,x_pos_supplier_bo.p_hz_organization_bo);
698:
699: x_pos_supplier_bo.p_hz_locations_bo := x_hz_locations_bo_tbl;
700: x_pos_supplier_bo.party_id := l_party_id;
701:
863: --Populate organization data
864: /* pos_supplier_bo_dep_pkg.get_organization_bo(p_init_msg_list,
865: p_party_id,
866: NULL,
867: x_hz_organization_bo,
868: x_return_status,
869: x_msg_count,
870: x_msg_data);*/
871: