eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POS_SUPPLIER_TAX_PROF_BO_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 10: * @param x_zx_party_tax_profile_bo_tbl The tax profile bo

6: * @param p_init_msg_list The Initialization message list
7: * @param p_party_id The party_id
8: * @param p_orig_system The Orig System
9: * @param p_orig_system_reference The Orig System Reference
10: * @param x_zx_party_tax_profile_bo_tbl The tax profile bo
11: * @param x_return_status The return status
12: * @param x_msg_count The message count
13: * @param x_msg_data The message data
14: * @rep:scope public

Line 24: x_zx_party_tax_profile_bo_tbl OUT NOCOPY pos_tax_profile_bo_tbl,

20: p_init_msg_list IN VARCHAR2 DEFAULT NULL,
21: p_party_id IN NUMBER,
22: p_orig_system IN VARCHAR2,
23: p_orig_system_reference IN VARCHAR2,
24: x_zx_party_tax_profile_bo_tbl OUT NOCOPY pos_tax_profile_bo_tbl,
25: x_return_status OUT NOCOPY VARCHAR2,
26: x_msg_count OUT NOCOPY NUMBER,
27: x_msg_data OUT NOCOPY VARCHAR2) IS
28:

Line 98: FROM zx_party_tax_profile

94: country_code,
95: merged_to_ptp_id,
96: merged_status_code) BULK COLLECT
97: INTO l_ap_supplier_tax_prof_bo_tbl
98: FROM zx_party_tax_profile
99: WHERE party_id = l_party_id;
100:
101: x_zx_party_tax_profile_bo_tbl := l_ap_supplier_tax_prof_bo_tbl;
102: EXCEPTION

Line 101: x_zx_party_tax_profile_bo_tbl := l_ap_supplier_tax_prof_bo_tbl;

97: INTO l_ap_supplier_tax_prof_bo_tbl
98: FROM zx_party_tax_profile
99: WHERE party_id = l_party_id;
100:
101: x_zx_party_tax_profile_bo_tbl := l_ap_supplier_tax_prof_bo_tbl;
102: EXCEPTION
103: WHEN fnd_api.g_exc_error THEN
104:
105: x_return_status := fnd_api.g_ret_sts_error;

Line 147: FROM zx_party_tax_profile

143: -- Check if the Tax Profile Id exists
144: BEGIN
145: SELECT party_tax_profile_id
146: INTO x_party_tax_profile_id
147: FROM zx_party_tax_profile
148: WHERE party_id = p_party_id
149: AND party_type_code = 'THIRD_PARTY';
150:
151: RETURN;

Line 254: * @param x_zx_party_tax_profile_bo_tbl The tax profile bo

250: /*#
251: * Use this routine to create tax profile BO
252: * @param p_api_version The api version
253: * @param p_init_msg_list The Initialization message list
254: * @param x_zx_party_tax_profile_bo_tbl The tax profile bo
255: * @param p_party_id The party_id
256: * @param p_orig_system The Orig System
257: * @param p_orig_system_reference The Orig System Reference
258: * @param x_return_status The return status

Line 269: x_zx_party_tax_profile_bo_tbl IN pos_tax_profile_bo_tbl,

265: * @rep:catagory BUSSINESS_ENTITY AP_SUPPLIER
266: */
267: PROCEDURE create_supp_tax_profile(p_api_version IN NUMBER DEFAULT NULL,
268: p_init_msg_list IN VARCHAR2 DEFAULT NULL,
269: x_zx_party_tax_profile_bo_tbl IN pos_tax_profile_bo_tbl,
270: p_party_id IN NUMBER,
271: p_orig_system IN VARCHAR2,
272: p_orig_system_reference IN VARCHAR2,
273: p_create_update_flag IN VARCHAR2,

Line 294: FOR i IN x_zx_party_tax_profile_bo_tbl.first .. x_zx_party_tax_profile_bo_tbl.last LOOP

290: p_orig_system_reference);
291: ELSE
292: l_party_id := p_party_id;
293: END IF;
294: FOR i IN x_zx_party_tax_profile_bo_tbl.first .. x_zx_party_tax_profile_bo_tbl.last LOOP
295: -- Call Validate_Tax_profile to validate the Tax Profiledata
296: validate_tax_profile(p_party_id => l_party_id,
297: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,
298: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,

Line 297: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,

293: END IF;
294: FOR i IN x_zx_party_tax_profile_bo_tbl.first .. x_zx_party_tax_profile_bo_tbl.last LOOP
295: -- Call Validate_Tax_profile to validate the Tax Profiledata
296: validate_tax_profile(p_party_id => l_party_id,
297: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,
298: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,
299: p_registration_type_code => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,
300: p_country_code => x_zx_party_tax_profile_bo_tbl(i).country_code,
301: x_return_status => l_return_status,

Line 298: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,

294: FOR i IN x_zx_party_tax_profile_bo_tbl.first .. x_zx_party_tax_profile_bo_tbl.last LOOP
295: -- Call Validate_Tax_profile to validate the Tax Profiledata
296: validate_tax_profile(p_party_id => l_party_id,
297: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,
298: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,
299: p_registration_type_code => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,
300: p_country_code => x_zx_party_tax_profile_bo_tbl(i).country_code,
301: x_return_status => l_return_status,
302: x_msg_count => l_msg_count,

Line 299: p_registration_type_code => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,

295: -- Call Validate_Tax_profile to validate the Tax Profiledata
296: validate_tax_profile(p_party_id => l_party_id,
297: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,
298: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,
299: p_registration_type_code => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,
300: p_country_code => x_zx_party_tax_profile_bo_tbl(i).country_code,
301: x_return_status => l_return_status,
302: x_msg_count => l_msg_count,
303: x_msg_data => l_msg_data,

Line 300: p_country_code => x_zx_party_tax_profile_bo_tbl(i).country_code,

296: validate_tax_profile(p_party_id => l_party_id,
297: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,
298: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,
299: p_registration_type_code => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,
300: p_country_code => x_zx_party_tax_profile_bo_tbl(i).country_code,
301: x_return_status => l_return_status,
302: x_msg_count => l_msg_count,
303: x_msg_data => l_msg_data,
304: x_tax_prof_valid => l_tax_prof_valid,

Line 312: zx_party_tax_profile_pkg.insert_row(p_allow_awt_flag => x_zx_party_tax_profile_bo_tbl(i).allow_awt_flag,

308: IF p_create_update_flag = 'C' THEN
309: IF (l_tax_prof_valid = 'Y') THEN
310:
311: -- Insert
312: zx_party_tax_profile_pkg.insert_row(p_allow_awt_flag => x_zx_party_tax_profile_bo_tbl(i).allow_awt_flag,
313: p_allow_offset_tax_flag => x_zx_party_tax_profile_bo_tbl(i).allow_offset_tax_flag,
314: p_attribute_category => x_zx_party_tax_profile_bo_tbl(i).attribute_category,
315: p_attribute1 => x_zx_party_tax_profile_bo_tbl(i).attribute1,
316: p_attribute10 => x_zx_party_tax_profile_bo_tbl(i).attribute10,

Line 313: p_allow_offset_tax_flag => x_zx_party_tax_profile_bo_tbl(i).allow_offset_tax_flag,

309: IF (l_tax_prof_valid = 'Y') THEN
310:
311: -- Insert
312: zx_party_tax_profile_pkg.insert_row(p_allow_awt_flag => x_zx_party_tax_profile_bo_tbl(i).allow_awt_flag,
313: p_allow_offset_tax_flag => x_zx_party_tax_profile_bo_tbl(i).allow_offset_tax_flag,
314: p_attribute_category => x_zx_party_tax_profile_bo_tbl(i).attribute_category,
315: p_attribute1 => x_zx_party_tax_profile_bo_tbl(i).attribute1,
316: p_attribute10 => x_zx_party_tax_profile_bo_tbl(i).attribute10,
317: p_attribute11 => x_zx_party_tax_profile_bo_tbl(i).attribute11,

Line 314: p_attribute_category => x_zx_party_tax_profile_bo_tbl(i).attribute_category,

310:
311: -- Insert
312: zx_party_tax_profile_pkg.insert_row(p_allow_awt_flag => x_zx_party_tax_profile_bo_tbl(i).allow_awt_flag,
313: p_allow_offset_tax_flag => x_zx_party_tax_profile_bo_tbl(i).allow_offset_tax_flag,
314: p_attribute_category => x_zx_party_tax_profile_bo_tbl(i).attribute_category,
315: p_attribute1 => x_zx_party_tax_profile_bo_tbl(i).attribute1,
316: p_attribute10 => x_zx_party_tax_profile_bo_tbl(i).attribute10,
317: p_attribute11 => x_zx_party_tax_profile_bo_tbl(i).attribute11,
318: p_attribute12 => x_zx_party_tax_profile_bo_tbl(i).attribute12,

Line 315: p_attribute1 => x_zx_party_tax_profile_bo_tbl(i).attribute1,

311: -- Insert
312: zx_party_tax_profile_pkg.insert_row(p_allow_awt_flag => x_zx_party_tax_profile_bo_tbl(i).allow_awt_flag,
313: p_allow_offset_tax_flag => x_zx_party_tax_profile_bo_tbl(i).allow_offset_tax_flag,
314: p_attribute_category => x_zx_party_tax_profile_bo_tbl(i).attribute_category,
315: p_attribute1 => x_zx_party_tax_profile_bo_tbl(i).attribute1,
316: p_attribute10 => x_zx_party_tax_profile_bo_tbl(i).attribute10,
317: p_attribute11 => x_zx_party_tax_profile_bo_tbl(i).attribute11,
318: p_attribute12 => x_zx_party_tax_profile_bo_tbl(i).attribute12,
319: p_attribute13 => x_zx_party_tax_profile_bo_tbl(i).attribute13,

Line 316: p_attribute10 => x_zx_party_tax_profile_bo_tbl(i).attribute10,

312: zx_party_tax_profile_pkg.insert_row(p_allow_awt_flag => x_zx_party_tax_profile_bo_tbl(i).allow_awt_flag,
313: p_allow_offset_tax_flag => x_zx_party_tax_profile_bo_tbl(i).allow_offset_tax_flag,
314: p_attribute_category => x_zx_party_tax_profile_bo_tbl(i).attribute_category,
315: p_attribute1 => x_zx_party_tax_profile_bo_tbl(i).attribute1,
316: p_attribute10 => x_zx_party_tax_profile_bo_tbl(i).attribute10,
317: p_attribute11 => x_zx_party_tax_profile_bo_tbl(i).attribute11,
318: p_attribute12 => x_zx_party_tax_profile_bo_tbl(i).attribute12,
319: p_attribute13 => x_zx_party_tax_profile_bo_tbl(i).attribute13,
320: p_attribute14 => x_zx_party_tax_profile_bo_tbl(i).attribute14,

Line 317: p_attribute11 => x_zx_party_tax_profile_bo_tbl(i).attribute11,

313: p_allow_offset_tax_flag => x_zx_party_tax_profile_bo_tbl(i).allow_offset_tax_flag,
314: p_attribute_category => x_zx_party_tax_profile_bo_tbl(i).attribute_category,
315: p_attribute1 => x_zx_party_tax_profile_bo_tbl(i).attribute1,
316: p_attribute10 => x_zx_party_tax_profile_bo_tbl(i).attribute10,
317: p_attribute11 => x_zx_party_tax_profile_bo_tbl(i).attribute11,
318: p_attribute12 => x_zx_party_tax_profile_bo_tbl(i).attribute12,
319: p_attribute13 => x_zx_party_tax_profile_bo_tbl(i).attribute13,
320: p_attribute14 => x_zx_party_tax_profile_bo_tbl(i).attribute14,
321: p_attribute15 => x_zx_party_tax_profile_bo_tbl(i).attribute15,

Line 318: p_attribute12 => x_zx_party_tax_profile_bo_tbl(i).attribute12,

314: p_attribute_category => x_zx_party_tax_profile_bo_tbl(i).attribute_category,
315: p_attribute1 => x_zx_party_tax_profile_bo_tbl(i).attribute1,
316: p_attribute10 => x_zx_party_tax_profile_bo_tbl(i).attribute10,
317: p_attribute11 => x_zx_party_tax_profile_bo_tbl(i).attribute11,
318: p_attribute12 => x_zx_party_tax_profile_bo_tbl(i).attribute12,
319: p_attribute13 => x_zx_party_tax_profile_bo_tbl(i).attribute13,
320: p_attribute14 => x_zx_party_tax_profile_bo_tbl(i).attribute14,
321: p_attribute15 => x_zx_party_tax_profile_bo_tbl(i).attribute15,
322: p_attribute2 => x_zx_party_tax_profile_bo_tbl(i).attribute2,

Line 319: p_attribute13 => x_zx_party_tax_profile_bo_tbl(i).attribute13,

315: p_attribute1 => x_zx_party_tax_profile_bo_tbl(i).attribute1,
316: p_attribute10 => x_zx_party_tax_profile_bo_tbl(i).attribute10,
317: p_attribute11 => x_zx_party_tax_profile_bo_tbl(i).attribute11,
318: p_attribute12 => x_zx_party_tax_profile_bo_tbl(i).attribute12,
319: p_attribute13 => x_zx_party_tax_profile_bo_tbl(i).attribute13,
320: p_attribute14 => x_zx_party_tax_profile_bo_tbl(i).attribute14,
321: p_attribute15 => x_zx_party_tax_profile_bo_tbl(i).attribute15,
322: p_attribute2 => x_zx_party_tax_profile_bo_tbl(i).attribute2,
323: p_attribute3 => x_zx_party_tax_profile_bo_tbl(i).attribute3,

Line 320: p_attribute14 => x_zx_party_tax_profile_bo_tbl(i).attribute14,

316: p_attribute10 => x_zx_party_tax_profile_bo_tbl(i).attribute10,
317: p_attribute11 => x_zx_party_tax_profile_bo_tbl(i).attribute11,
318: p_attribute12 => x_zx_party_tax_profile_bo_tbl(i).attribute12,
319: p_attribute13 => x_zx_party_tax_profile_bo_tbl(i).attribute13,
320: p_attribute14 => x_zx_party_tax_profile_bo_tbl(i).attribute14,
321: p_attribute15 => x_zx_party_tax_profile_bo_tbl(i).attribute15,
322: p_attribute2 => x_zx_party_tax_profile_bo_tbl(i).attribute2,
323: p_attribute3 => x_zx_party_tax_profile_bo_tbl(i).attribute3,
324: p_attribute4 => x_zx_party_tax_profile_bo_tbl(i).attribute4,

Line 321: p_attribute15 => x_zx_party_tax_profile_bo_tbl(i).attribute15,

317: p_attribute11 => x_zx_party_tax_profile_bo_tbl(i).attribute11,
318: p_attribute12 => x_zx_party_tax_profile_bo_tbl(i).attribute12,
319: p_attribute13 => x_zx_party_tax_profile_bo_tbl(i).attribute13,
320: p_attribute14 => x_zx_party_tax_profile_bo_tbl(i).attribute14,
321: p_attribute15 => x_zx_party_tax_profile_bo_tbl(i).attribute15,
322: p_attribute2 => x_zx_party_tax_profile_bo_tbl(i).attribute2,
323: p_attribute3 => x_zx_party_tax_profile_bo_tbl(i).attribute3,
324: p_attribute4 => x_zx_party_tax_profile_bo_tbl(i).attribute4,
325: p_attribute5 => x_zx_party_tax_profile_bo_tbl(i).attribute5,

Line 322: p_attribute2 => x_zx_party_tax_profile_bo_tbl(i).attribute2,

318: p_attribute12 => x_zx_party_tax_profile_bo_tbl(i).attribute12,
319: p_attribute13 => x_zx_party_tax_profile_bo_tbl(i).attribute13,
320: p_attribute14 => x_zx_party_tax_profile_bo_tbl(i).attribute14,
321: p_attribute15 => x_zx_party_tax_profile_bo_tbl(i).attribute15,
322: p_attribute2 => x_zx_party_tax_profile_bo_tbl(i).attribute2,
323: p_attribute3 => x_zx_party_tax_profile_bo_tbl(i).attribute3,
324: p_attribute4 => x_zx_party_tax_profile_bo_tbl(i).attribute4,
325: p_attribute5 => x_zx_party_tax_profile_bo_tbl(i).attribute5,
326: p_attribute6 => x_zx_party_tax_profile_bo_tbl(i).attribute6,

Line 323: p_attribute3 => x_zx_party_tax_profile_bo_tbl(i).attribute3,

319: p_attribute13 => x_zx_party_tax_profile_bo_tbl(i).attribute13,
320: p_attribute14 => x_zx_party_tax_profile_bo_tbl(i).attribute14,
321: p_attribute15 => x_zx_party_tax_profile_bo_tbl(i).attribute15,
322: p_attribute2 => x_zx_party_tax_profile_bo_tbl(i).attribute2,
323: p_attribute3 => x_zx_party_tax_profile_bo_tbl(i).attribute3,
324: p_attribute4 => x_zx_party_tax_profile_bo_tbl(i).attribute4,
325: p_attribute5 => x_zx_party_tax_profile_bo_tbl(i).attribute5,
326: p_attribute6 => x_zx_party_tax_profile_bo_tbl(i).attribute6,
327: p_attribute7 => x_zx_party_tax_profile_bo_tbl(i).attribute7,

Line 324: p_attribute4 => x_zx_party_tax_profile_bo_tbl(i).attribute4,

320: p_attribute14 => x_zx_party_tax_profile_bo_tbl(i).attribute14,
321: p_attribute15 => x_zx_party_tax_profile_bo_tbl(i).attribute15,
322: p_attribute2 => x_zx_party_tax_profile_bo_tbl(i).attribute2,
323: p_attribute3 => x_zx_party_tax_profile_bo_tbl(i).attribute3,
324: p_attribute4 => x_zx_party_tax_profile_bo_tbl(i).attribute4,
325: p_attribute5 => x_zx_party_tax_profile_bo_tbl(i).attribute5,
326: p_attribute6 => x_zx_party_tax_profile_bo_tbl(i).attribute6,
327: p_attribute7 => x_zx_party_tax_profile_bo_tbl(i).attribute7,
328: p_attribute8 => x_zx_party_tax_profile_bo_tbl(i).attribute8,

Line 325: p_attribute5 => x_zx_party_tax_profile_bo_tbl(i).attribute5,

321: p_attribute15 => x_zx_party_tax_profile_bo_tbl(i).attribute15,
322: p_attribute2 => x_zx_party_tax_profile_bo_tbl(i).attribute2,
323: p_attribute3 => x_zx_party_tax_profile_bo_tbl(i).attribute3,
324: p_attribute4 => x_zx_party_tax_profile_bo_tbl(i).attribute4,
325: p_attribute5 => x_zx_party_tax_profile_bo_tbl(i).attribute5,
326: p_attribute6 => x_zx_party_tax_profile_bo_tbl(i).attribute6,
327: p_attribute7 => x_zx_party_tax_profile_bo_tbl(i).attribute7,
328: p_attribute8 => x_zx_party_tax_profile_bo_tbl(i).attribute8,
329: p_attribute9 => x_zx_party_tax_profile_bo_tbl(i).attribute9,

Line 326: p_attribute6 => x_zx_party_tax_profile_bo_tbl(i).attribute6,

322: p_attribute2 => x_zx_party_tax_profile_bo_tbl(i).attribute2,
323: p_attribute3 => x_zx_party_tax_profile_bo_tbl(i).attribute3,
324: p_attribute4 => x_zx_party_tax_profile_bo_tbl(i).attribute4,
325: p_attribute5 => x_zx_party_tax_profile_bo_tbl(i).attribute5,
326: p_attribute6 => x_zx_party_tax_profile_bo_tbl(i).attribute6,
327: p_attribute7 => x_zx_party_tax_profile_bo_tbl(i).attribute7,
328: p_attribute8 => x_zx_party_tax_profile_bo_tbl(i).attribute8,
329: p_attribute9 => x_zx_party_tax_profile_bo_tbl(i).attribute9,
330: p_collecting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).collecting_authority_flag,

Line 327: p_attribute7 => x_zx_party_tax_profile_bo_tbl(i).attribute7,

323: p_attribute3 => x_zx_party_tax_profile_bo_tbl(i).attribute3,
324: p_attribute4 => x_zx_party_tax_profile_bo_tbl(i).attribute4,
325: p_attribute5 => x_zx_party_tax_profile_bo_tbl(i).attribute5,
326: p_attribute6 => x_zx_party_tax_profile_bo_tbl(i).attribute6,
327: p_attribute7 => x_zx_party_tax_profile_bo_tbl(i).attribute7,
328: p_attribute8 => x_zx_party_tax_profile_bo_tbl(i).attribute8,
329: p_attribute9 => x_zx_party_tax_profile_bo_tbl(i).attribute9,
330: p_collecting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).collecting_authority_flag,
331: p_country_code => x_zx_party_tax_profile_bo_tbl(i).country_code,

Line 328: p_attribute8 => x_zx_party_tax_profile_bo_tbl(i).attribute8,

324: p_attribute4 => x_zx_party_tax_profile_bo_tbl(i).attribute4,
325: p_attribute5 => x_zx_party_tax_profile_bo_tbl(i).attribute5,
326: p_attribute6 => x_zx_party_tax_profile_bo_tbl(i).attribute6,
327: p_attribute7 => x_zx_party_tax_profile_bo_tbl(i).attribute7,
328: p_attribute8 => x_zx_party_tax_profile_bo_tbl(i).attribute8,
329: p_attribute9 => x_zx_party_tax_profile_bo_tbl(i).attribute9,
330: p_collecting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).collecting_authority_flag,
331: p_country_code => x_zx_party_tax_profile_bo_tbl(i).country_code,
332: p_create_awt_dists_type_code => x_zx_party_tax_profile_bo_tbl(i).create_awt_dists_type_code,

Line 329: p_attribute9 => x_zx_party_tax_profile_bo_tbl(i).attribute9,

325: p_attribute5 => x_zx_party_tax_profile_bo_tbl(i).attribute5,
326: p_attribute6 => x_zx_party_tax_profile_bo_tbl(i).attribute6,
327: p_attribute7 => x_zx_party_tax_profile_bo_tbl(i).attribute7,
328: p_attribute8 => x_zx_party_tax_profile_bo_tbl(i).attribute8,
329: p_attribute9 => x_zx_party_tax_profile_bo_tbl(i).attribute9,
330: p_collecting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).collecting_authority_flag,
331: p_country_code => x_zx_party_tax_profile_bo_tbl(i).country_code,
332: p_create_awt_dists_type_code => x_zx_party_tax_profile_bo_tbl(i).create_awt_dists_type_code,
333: p_create_awt_invoices_type_cod => x_zx_party_tax_profile_bo_tbl(i).create_awt_invoices_type_code,

Line 330: p_collecting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).collecting_authority_flag,

326: p_attribute6 => x_zx_party_tax_profile_bo_tbl(i).attribute6,
327: p_attribute7 => x_zx_party_tax_profile_bo_tbl(i).attribute7,
328: p_attribute8 => x_zx_party_tax_profile_bo_tbl(i).attribute8,
329: p_attribute9 => x_zx_party_tax_profile_bo_tbl(i).attribute9,
330: p_collecting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).collecting_authority_flag,
331: p_country_code => x_zx_party_tax_profile_bo_tbl(i).country_code,
332: p_create_awt_dists_type_code => x_zx_party_tax_profile_bo_tbl(i).create_awt_dists_type_code,
333: p_create_awt_invoices_type_cod => x_zx_party_tax_profile_bo_tbl(i).create_awt_invoices_type_code,
334: p_customer_flag => x_zx_party_tax_profile_bo_tbl(i).customer_flag,

Line 331: p_country_code => x_zx_party_tax_profile_bo_tbl(i).country_code,

327: p_attribute7 => x_zx_party_tax_profile_bo_tbl(i).attribute7,
328: p_attribute8 => x_zx_party_tax_profile_bo_tbl(i).attribute8,
329: p_attribute9 => x_zx_party_tax_profile_bo_tbl(i).attribute9,
330: p_collecting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).collecting_authority_flag,
331: p_country_code => x_zx_party_tax_profile_bo_tbl(i).country_code,
332: p_create_awt_dists_type_code => x_zx_party_tax_profile_bo_tbl(i).create_awt_dists_type_code,
333: p_create_awt_invoices_type_cod => x_zx_party_tax_profile_bo_tbl(i).create_awt_invoices_type_code,
334: p_customer_flag => x_zx_party_tax_profile_bo_tbl(i).customer_flag,
335: p_effective_from_use_le => x_zx_party_tax_profile_bo_tbl(i).effective_from_use_le,

Line 332: p_create_awt_dists_type_code => x_zx_party_tax_profile_bo_tbl(i).create_awt_dists_type_code,

328: p_attribute8 => x_zx_party_tax_profile_bo_tbl(i).attribute8,
329: p_attribute9 => x_zx_party_tax_profile_bo_tbl(i).attribute9,
330: p_collecting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).collecting_authority_flag,
331: p_country_code => x_zx_party_tax_profile_bo_tbl(i).country_code,
332: p_create_awt_dists_type_code => x_zx_party_tax_profile_bo_tbl(i).create_awt_dists_type_code,
333: p_create_awt_invoices_type_cod => x_zx_party_tax_profile_bo_tbl(i).create_awt_invoices_type_code,
334: p_customer_flag => x_zx_party_tax_profile_bo_tbl(i).customer_flag,
335: p_effective_from_use_le => x_zx_party_tax_profile_bo_tbl(i).effective_from_use_le,
336: p_first_party_le_flag => x_zx_party_tax_profile_bo_tbl(i).first_party_le_flag,

Line 333: p_create_awt_invoices_type_cod => x_zx_party_tax_profile_bo_tbl(i).create_awt_invoices_type_code,

329: p_attribute9 => x_zx_party_tax_profile_bo_tbl(i).attribute9,
330: p_collecting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).collecting_authority_flag,
331: p_country_code => x_zx_party_tax_profile_bo_tbl(i).country_code,
332: p_create_awt_dists_type_code => x_zx_party_tax_profile_bo_tbl(i).create_awt_dists_type_code,
333: p_create_awt_invoices_type_cod => x_zx_party_tax_profile_bo_tbl(i).create_awt_invoices_type_code,
334: p_customer_flag => x_zx_party_tax_profile_bo_tbl(i).customer_flag,
335: p_effective_from_use_le => x_zx_party_tax_profile_bo_tbl(i).effective_from_use_le,
336: p_first_party_le_flag => x_zx_party_tax_profile_bo_tbl(i).first_party_le_flag,
337: p_inclusive_tax_flag => x_zx_party_tax_profile_bo_tbl(i).inclusive_tax_flag,

Line 334: p_customer_flag => x_zx_party_tax_profile_bo_tbl(i).customer_flag,

330: p_collecting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).collecting_authority_flag,
331: p_country_code => x_zx_party_tax_profile_bo_tbl(i).country_code,
332: p_create_awt_dists_type_code => x_zx_party_tax_profile_bo_tbl(i).create_awt_dists_type_code,
333: p_create_awt_invoices_type_cod => x_zx_party_tax_profile_bo_tbl(i).create_awt_invoices_type_code,
334: p_customer_flag => x_zx_party_tax_profile_bo_tbl(i).customer_flag,
335: p_effective_from_use_le => x_zx_party_tax_profile_bo_tbl(i).effective_from_use_le,
336: p_first_party_le_flag => x_zx_party_tax_profile_bo_tbl(i).first_party_le_flag,
337: p_inclusive_tax_flag => x_zx_party_tax_profile_bo_tbl(i).inclusive_tax_flag,
338: p_legal_establishment_flag => x_zx_party_tax_profile_bo_tbl(i).legal_establishment_flag,

Line 335: p_effective_from_use_le => x_zx_party_tax_profile_bo_tbl(i).effective_from_use_le,

331: p_country_code => x_zx_party_tax_profile_bo_tbl(i).country_code,
332: p_create_awt_dists_type_code => x_zx_party_tax_profile_bo_tbl(i).create_awt_dists_type_code,
333: p_create_awt_invoices_type_cod => x_zx_party_tax_profile_bo_tbl(i).create_awt_invoices_type_code,
334: p_customer_flag => x_zx_party_tax_profile_bo_tbl(i).customer_flag,
335: p_effective_from_use_le => x_zx_party_tax_profile_bo_tbl(i).effective_from_use_le,
336: p_first_party_le_flag => x_zx_party_tax_profile_bo_tbl(i).first_party_le_flag,
337: p_inclusive_tax_flag => x_zx_party_tax_profile_bo_tbl(i).inclusive_tax_flag,
338: p_legal_establishment_flag => x_zx_party_tax_profile_bo_tbl(i).legal_establishment_flag,
339: p_party_id => x_zx_party_tax_profile_bo_tbl(i).party_id,

Line 336: p_first_party_le_flag => x_zx_party_tax_profile_bo_tbl(i).first_party_le_flag,

332: p_create_awt_dists_type_code => x_zx_party_tax_profile_bo_tbl(i).create_awt_dists_type_code,
333: p_create_awt_invoices_type_cod => x_zx_party_tax_profile_bo_tbl(i).create_awt_invoices_type_code,
334: p_customer_flag => x_zx_party_tax_profile_bo_tbl(i).customer_flag,
335: p_effective_from_use_le => x_zx_party_tax_profile_bo_tbl(i).effective_from_use_le,
336: p_first_party_le_flag => x_zx_party_tax_profile_bo_tbl(i).first_party_le_flag,
337: p_inclusive_tax_flag => x_zx_party_tax_profile_bo_tbl(i).inclusive_tax_flag,
338: p_legal_establishment_flag => x_zx_party_tax_profile_bo_tbl(i).legal_establishment_flag,
339: p_party_id => x_zx_party_tax_profile_bo_tbl(i).party_id,
340: p_party_type_code => x_zx_party_tax_profile_bo_tbl(i).party_type_code,

Line 337: p_inclusive_tax_flag => x_zx_party_tax_profile_bo_tbl(i).inclusive_tax_flag,

333: p_create_awt_invoices_type_cod => x_zx_party_tax_profile_bo_tbl(i).create_awt_invoices_type_code,
334: p_customer_flag => x_zx_party_tax_profile_bo_tbl(i).customer_flag,
335: p_effective_from_use_le => x_zx_party_tax_profile_bo_tbl(i).effective_from_use_le,
336: p_first_party_le_flag => x_zx_party_tax_profile_bo_tbl(i).first_party_le_flag,
337: p_inclusive_tax_flag => x_zx_party_tax_profile_bo_tbl(i).inclusive_tax_flag,
338: p_legal_establishment_flag => x_zx_party_tax_profile_bo_tbl(i).legal_establishment_flag,
339: p_party_id => x_zx_party_tax_profile_bo_tbl(i).party_id,
340: p_party_type_code => x_zx_party_tax_profile_bo_tbl(i).party_type_code,
341: p_process_for_applicability_fl => x_zx_party_tax_profile_bo_tbl(i).process_for_applicability_flag,

Line 338: p_legal_establishment_flag => x_zx_party_tax_profile_bo_tbl(i).legal_establishment_flag,

334: p_customer_flag => x_zx_party_tax_profile_bo_tbl(i).customer_flag,
335: p_effective_from_use_le => x_zx_party_tax_profile_bo_tbl(i).effective_from_use_le,
336: p_first_party_le_flag => x_zx_party_tax_profile_bo_tbl(i).first_party_le_flag,
337: p_inclusive_tax_flag => x_zx_party_tax_profile_bo_tbl(i).inclusive_tax_flag,
338: p_legal_establishment_flag => x_zx_party_tax_profile_bo_tbl(i).legal_establishment_flag,
339: p_party_id => x_zx_party_tax_profile_bo_tbl(i).party_id,
340: p_party_type_code => x_zx_party_tax_profile_bo_tbl(i).party_type_code,
341: p_process_for_applicability_fl => x_zx_party_tax_profile_bo_tbl(i).process_for_applicability_flag,
342: p_program_login_id => x_zx_party_tax_profile_bo_tbl(i).program_application_id,

Line 339: p_party_id => x_zx_party_tax_profile_bo_tbl(i).party_id,

335: p_effective_from_use_le => x_zx_party_tax_profile_bo_tbl(i).effective_from_use_le,
336: p_first_party_le_flag => x_zx_party_tax_profile_bo_tbl(i).first_party_le_flag,
337: p_inclusive_tax_flag => x_zx_party_tax_profile_bo_tbl(i).inclusive_tax_flag,
338: p_legal_establishment_flag => x_zx_party_tax_profile_bo_tbl(i).legal_establishment_flag,
339: p_party_id => x_zx_party_tax_profile_bo_tbl(i).party_id,
340: p_party_type_code => x_zx_party_tax_profile_bo_tbl(i).party_type_code,
341: p_process_for_applicability_fl => x_zx_party_tax_profile_bo_tbl(i).process_for_applicability_flag,
342: p_program_login_id => x_zx_party_tax_profile_bo_tbl(i).program_application_id,
343: p_provider_type_code => x_zx_party_tax_profile_bo_tbl(i).provider_type_code,

Line 340: p_party_type_code => x_zx_party_tax_profile_bo_tbl(i).party_type_code,

336: p_first_party_le_flag => x_zx_party_tax_profile_bo_tbl(i).first_party_le_flag,
337: p_inclusive_tax_flag => x_zx_party_tax_profile_bo_tbl(i).inclusive_tax_flag,
338: p_legal_establishment_flag => x_zx_party_tax_profile_bo_tbl(i).legal_establishment_flag,
339: p_party_id => x_zx_party_tax_profile_bo_tbl(i).party_id,
340: p_party_type_code => x_zx_party_tax_profile_bo_tbl(i).party_type_code,
341: p_process_for_applicability_fl => x_zx_party_tax_profile_bo_tbl(i).process_for_applicability_flag,
342: p_program_login_id => x_zx_party_tax_profile_bo_tbl(i).program_application_id,
343: p_provider_type_code => x_zx_party_tax_profile_bo_tbl(i).provider_type_code,
344: p_record_type_code => x_zx_party_tax_profile_bo_tbl(i).record_type_code,

Line 341: p_process_for_applicability_fl => x_zx_party_tax_profile_bo_tbl(i).process_for_applicability_flag,

337: p_inclusive_tax_flag => x_zx_party_tax_profile_bo_tbl(i).inclusive_tax_flag,
338: p_legal_establishment_flag => x_zx_party_tax_profile_bo_tbl(i).legal_establishment_flag,
339: p_party_id => x_zx_party_tax_profile_bo_tbl(i).party_id,
340: p_party_type_code => x_zx_party_tax_profile_bo_tbl(i).party_type_code,
341: p_process_for_applicability_fl => x_zx_party_tax_profile_bo_tbl(i).process_for_applicability_flag,
342: p_program_login_id => x_zx_party_tax_profile_bo_tbl(i).program_application_id,
343: p_provider_type_code => x_zx_party_tax_profile_bo_tbl(i).provider_type_code,
344: p_record_type_code => x_zx_party_tax_profile_bo_tbl(i).record_type_code,
345: p_registration_type_code => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,

Line 342: p_program_login_id => x_zx_party_tax_profile_bo_tbl(i).program_application_id,

338: p_legal_establishment_flag => x_zx_party_tax_profile_bo_tbl(i).legal_establishment_flag,
339: p_party_id => x_zx_party_tax_profile_bo_tbl(i).party_id,
340: p_party_type_code => x_zx_party_tax_profile_bo_tbl(i).party_type_code,
341: p_process_for_applicability_fl => x_zx_party_tax_profile_bo_tbl(i).process_for_applicability_flag,
342: p_program_login_id => x_zx_party_tax_profile_bo_tbl(i).program_application_id,
343: p_provider_type_code => x_zx_party_tax_profile_bo_tbl(i).provider_type_code,
344: p_record_type_code => x_zx_party_tax_profile_bo_tbl(i).record_type_code,
345: p_registration_type_code => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,
346: p_rep_registration_number => x_zx_party_tax_profile_bo_tbl(i).rep_registration_number,

Line 343: p_provider_type_code => x_zx_party_tax_profile_bo_tbl(i).provider_type_code,

339: p_party_id => x_zx_party_tax_profile_bo_tbl(i).party_id,
340: p_party_type_code => x_zx_party_tax_profile_bo_tbl(i).party_type_code,
341: p_process_for_applicability_fl => x_zx_party_tax_profile_bo_tbl(i).process_for_applicability_flag,
342: p_program_login_id => x_zx_party_tax_profile_bo_tbl(i).program_application_id,
343: p_provider_type_code => x_zx_party_tax_profile_bo_tbl(i).provider_type_code,
344: p_record_type_code => x_zx_party_tax_profile_bo_tbl(i).record_type_code,
345: p_registration_type_code => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,
346: p_rep_registration_number => x_zx_party_tax_profile_bo_tbl(i).rep_registration_number,
347: p_reporting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).reporting_authority_flag,

Line 344: p_record_type_code => x_zx_party_tax_profile_bo_tbl(i).record_type_code,

340: p_party_type_code => x_zx_party_tax_profile_bo_tbl(i).party_type_code,
341: p_process_for_applicability_fl => x_zx_party_tax_profile_bo_tbl(i).process_for_applicability_flag,
342: p_program_login_id => x_zx_party_tax_profile_bo_tbl(i).program_application_id,
343: p_provider_type_code => x_zx_party_tax_profile_bo_tbl(i).provider_type_code,
344: p_record_type_code => x_zx_party_tax_profile_bo_tbl(i).record_type_code,
345: p_registration_type_code => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,
346: p_rep_registration_number => x_zx_party_tax_profile_bo_tbl(i).rep_registration_number,
347: p_reporting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).reporting_authority_flag,
348: p_request_id => x_zx_party_tax_profile_bo_tbl(i).request_id,

Line 345: p_registration_type_code => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,

341: p_process_for_applicability_fl => x_zx_party_tax_profile_bo_tbl(i).process_for_applicability_flag,
342: p_program_login_id => x_zx_party_tax_profile_bo_tbl(i).program_application_id,
343: p_provider_type_code => x_zx_party_tax_profile_bo_tbl(i).provider_type_code,
344: p_record_type_code => x_zx_party_tax_profile_bo_tbl(i).record_type_code,
345: p_registration_type_code => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,
346: p_rep_registration_number => x_zx_party_tax_profile_bo_tbl(i).rep_registration_number,
347: p_reporting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).reporting_authority_flag,
348: p_request_id => x_zx_party_tax_profile_bo_tbl(i).request_id,
349: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,

Line 346: p_rep_registration_number => x_zx_party_tax_profile_bo_tbl(i).rep_registration_number,

342: p_program_login_id => x_zx_party_tax_profile_bo_tbl(i).program_application_id,
343: p_provider_type_code => x_zx_party_tax_profile_bo_tbl(i).provider_type_code,
344: p_record_type_code => x_zx_party_tax_profile_bo_tbl(i).record_type_code,
345: p_registration_type_code => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,
346: p_rep_registration_number => x_zx_party_tax_profile_bo_tbl(i).rep_registration_number,
347: p_reporting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).reporting_authority_flag,
348: p_request_id => x_zx_party_tax_profile_bo_tbl(i).request_id,
349: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,
350: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,

Line 347: p_reporting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).reporting_authority_flag,

343: p_provider_type_code => x_zx_party_tax_profile_bo_tbl(i).provider_type_code,
344: p_record_type_code => x_zx_party_tax_profile_bo_tbl(i).record_type_code,
345: p_registration_type_code => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,
346: p_rep_registration_number => x_zx_party_tax_profile_bo_tbl(i).rep_registration_number,
347: p_reporting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).reporting_authority_flag,
348: p_request_id => x_zx_party_tax_profile_bo_tbl(i).request_id,
349: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,
350: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,
351: p_self_assess_flag => x_zx_party_tax_profile_bo_tbl(i).self_assess_flag,

Line 348: p_request_id => x_zx_party_tax_profile_bo_tbl(i).request_id,

344: p_record_type_code => x_zx_party_tax_profile_bo_tbl(i).record_type_code,
345: p_registration_type_code => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,
346: p_rep_registration_number => x_zx_party_tax_profile_bo_tbl(i).rep_registration_number,
347: p_reporting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).reporting_authority_flag,
348: p_request_id => x_zx_party_tax_profile_bo_tbl(i).request_id,
349: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,
350: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,
351: p_self_assess_flag => x_zx_party_tax_profile_bo_tbl(i).self_assess_flag,
352: p_site_flag => x_zx_party_tax_profile_bo_tbl(i).site_flag,

Line 349: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,

345: p_registration_type_code => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,
346: p_rep_registration_number => x_zx_party_tax_profile_bo_tbl(i).rep_registration_number,
347: p_reporting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).reporting_authority_flag,
348: p_request_id => x_zx_party_tax_profile_bo_tbl(i).request_id,
349: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,
350: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,
351: p_self_assess_flag => x_zx_party_tax_profile_bo_tbl(i).self_assess_flag,
352: p_site_flag => x_zx_party_tax_profile_bo_tbl(i).site_flag,
353: p_supplier_flag => x_zx_party_tax_profile_bo_tbl(i).supplier_flag,

Line 350: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,

346: p_rep_registration_number => x_zx_party_tax_profile_bo_tbl(i).rep_registration_number,
347: p_reporting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).reporting_authority_flag,
348: p_request_id => x_zx_party_tax_profile_bo_tbl(i).request_id,
349: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,
350: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,
351: p_self_assess_flag => x_zx_party_tax_profile_bo_tbl(i).self_assess_flag,
352: p_site_flag => x_zx_party_tax_profile_bo_tbl(i).site_flag,
353: p_supplier_flag => x_zx_party_tax_profile_bo_tbl(i).supplier_flag,
354: p_tax_classification_code => x_zx_party_tax_profile_bo_tbl(i).tax_classification_code,

Line 351: p_self_assess_flag => x_zx_party_tax_profile_bo_tbl(i).self_assess_flag,

347: p_reporting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).reporting_authority_flag,
348: p_request_id => x_zx_party_tax_profile_bo_tbl(i).request_id,
349: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,
350: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,
351: p_self_assess_flag => x_zx_party_tax_profile_bo_tbl(i).self_assess_flag,
352: p_site_flag => x_zx_party_tax_profile_bo_tbl(i).site_flag,
353: p_supplier_flag => x_zx_party_tax_profile_bo_tbl(i).supplier_flag,
354: p_tax_classification_code => x_zx_party_tax_profile_bo_tbl(i).tax_classification_code,
355: p_use_le_as_subscriber_flag => x_zx_party_tax_profile_bo_tbl(i).use_le_as_subscriber_flag,

Line 352: p_site_flag => x_zx_party_tax_profile_bo_tbl(i).site_flag,

348: p_request_id => x_zx_party_tax_profile_bo_tbl(i).request_id,
349: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,
350: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,
351: p_self_assess_flag => x_zx_party_tax_profile_bo_tbl(i).self_assess_flag,
352: p_site_flag => x_zx_party_tax_profile_bo_tbl(i).site_flag,
353: p_supplier_flag => x_zx_party_tax_profile_bo_tbl(i).supplier_flag,
354: p_tax_classification_code => x_zx_party_tax_profile_bo_tbl(i).tax_classification_code,
355: p_use_le_as_subscriber_flag => x_zx_party_tax_profile_bo_tbl(i).use_le_as_subscriber_flag,
356: p_withholding_start_date => x_zx_party_tax_profile_bo_tbl(i).withholding_start_date,

Line 353: p_supplier_flag => x_zx_party_tax_profile_bo_tbl(i).supplier_flag,

349: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,
350: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,
351: p_self_assess_flag => x_zx_party_tax_profile_bo_tbl(i).self_assess_flag,
352: p_site_flag => x_zx_party_tax_profile_bo_tbl(i).site_flag,
353: p_supplier_flag => x_zx_party_tax_profile_bo_tbl(i).supplier_flag,
354: p_tax_classification_code => x_zx_party_tax_profile_bo_tbl(i).tax_classification_code,
355: p_use_le_as_subscriber_flag => x_zx_party_tax_profile_bo_tbl(i).use_le_as_subscriber_flag,
356: p_withholding_start_date => x_zx_party_tax_profile_bo_tbl(i).withholding_start_date,
357: x_return_status => l_return_status);

Line 354: p_tax_classification_code => x_zx_party_tax_profile_bo_tbl(i).tax_classification_code,

350: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,
351: p_self_assess_flag => x_zx_party_tax_profile_bo_tbl(i).self_assess_flag,
352: p_site_flag => x_zx_party_tax_profile_bo_tbl(i).site_flag,
353: p_supplier_flag => x_zx_party_tax_profile_bo_tbl(i).supplier_flag,
354: p_tax_classification_code => x_zx_party_tax_profile_bo_tbl(i).tax_classification_code,
355: p_use_le_as_subscriber_flag => x_zx_party_tax_profile_bo_tbl(i).use_le_as_subscriber_flag,
356: p_withholding_start_date => x_zx_party_tax_profile_bo_tbl(i).withholding_start_date,
357: x_return_status => l_return_status);
358:

Line 355: p_use_le_as_subscriber_flag => x_zx_party_tax_profile_bo_tbl(i).use_le_as_subscriber_flag,

351: p_self_assess_flag => x_zx_party_tax_profile_bo_tbl(i).self_assess_flag,
352: p_site_flag => x_zx_party_tax_profile_bo_tbl(i).site_flag,
353: p_supplier_flag => x_zx_party_tax_profile_bo_tbl(i).supplier_flag,
354: p_tax_classification_code => x_zx_party_tax_profile_bo_tbl(i).tax_classification_code,
355: p_use_le_as_subscriber_flag => x_zx_party_tax_profile_bo_tbl(i).use_le_as_subscriber_flag,
356: p_withholding_start_date => x_zx_party_tax_profile_bo_tbl(i).withholding_start_date,
357: x_return_status => l_return_status);
358:
359: -- The ZX API doesn't return the Tax Profile Id that has been created

Line 356: p_withholding_start_date => x_zx_party_tax_profile_bo_tbl(i).withholding_start_date,

352: p_site_flag => x_zx_party_tax_profile_bo_tbl(i).site_flag,
353: p_supplier_flag => x_zx_party_tax_profile_bo_tbl(i).supplier_flag,
354: p_tax_classification_code => x_zx_party_tax_profile_bo_tbl(i).tax_classification_code,
355: p_use_le_as_subscriber_flag => x_zx_party_tax_profile_bo_tbl(i).use_le_as_subscriber_flag,
356: p_withholding_start_date => x_zx_party_tax_profile_bo_tbl(i).withholding_start_date,
357: x_return_status => l_return_status);
358:
359: -- The ZX API doesn't return the Tax Profile Id that has been created
360: -- So re-querying the Tax profile Id using the party Id and the party Type

Line 365: FROM zx_party_tax_profile

361: --
362: IF (l_return_status = 'S') THEN
363: SELECT party_tax_profile_id
364: INTO l_party_tax_profile_id
365: FROM zx_party_tax_profile
366: WHERE party_id = l_party_id
367: AND party_type_code = 'THIRD_PARTY';
368:
369: x_tax_profile_id := l_party_tax_profile_id;

Line 385: zx_party_tax_profile_pkg.update_row(p_allow_awt_flag => x_zx_party_tax_profile_bo_tbl(i).allow_awt_flag,

381:
382: ELSIF p_create_update_flag = 'U' THEN
383: IF (l_tax_prof_valid = 'Y') THEN
384:
385: zx_party_tax_profile_pkg.update_row(p_allow_awt_flag => x_zx_party_tax_profile_bo_tbl(i).allow_awt_flag,
386: p_allow_offset_tax_flag => x_zx_party_tax_profile_bo_tbl(i).allow_offset_tax_flag,
387: p_attribute_category => x_zx_party_tax_profile_bo_tbl(i).attribute_category,
388: p_attribute1 => x_zx_party_tax_profile_bo_tbl(i).attribute1,
389: p_attribute10 => x_zx_party_tax_profile_bo_tbl(i).attribute10,

Line 386: p_allow_offset_tax_flag => x_zx_party_tax_profile_bo_tbl(i).allow_offset_tax_flag,

382: ELSIF p_create_update_flag = 'U' THEN
383: IF (l_tax_prof_valid = 'Y') THEN
384:
385: zx_party_tax_profile_pkg.update_row(p_allow_awt_flag => x_zx_party_tax_profile_bo_tbl(i).allow_awt_flag,
386: p_allow_offset_tax_flag => x_zx_party_tax_profile_bo_tbl(i).allow_offset_tax_flag,
387: p_attribute_category => x_zx_party_tax_profile_bo_tbl(i).attribute_category,
388: p_attribute1 => x_zx_party_tax_profile_bo_tbl(i).attribute1,
389: p_attribute10 => x_zx_party_tax_profile_bo_tbl(i).attribute10,
390: p_attribute11 => x_zx_party_tax_profile_bo_tbl(i).attribute11,

Line 387: p_attribute_category => x_zx_party_tax_profile_bo_tbl(i).attribute_category,

383: IF (l_tax_prof_valid = 'Y') THEN
384:
385: zx_party_tax_profile_pkg.update_row(p_allow_awt_flag => x_zx_party_tax_profile_bo_tbl(i).allow_awt_flag,
386: p_allow_offset_tax_flag => x_zx_party_tax_profile_bo_tbl(i).allow_offset_tax_flag,
387: p_attribute_category => x_zx_party_tax_profile_bo_tbl(i).attribute_category,
388: p_attribute1 => x_zx_party_tax_profile_bo_tbl(i).attribute1,
389: p_attribute10 => x_zx_party_tax_profile_bo_tbl(i).attribute10,
390: p_attribute11 => x_zx_party_tax_profile_bo_tbl(i).attribute11,
391: p_attribute12 => x_zx_party_tax_profile_bo_tbl(i).attribute12,

Line 388: p_attribute1 => x_zx_party_tax_profile_bo_tbl(i).attribute1,

384:
385: zx_party_tax_profile_pkg.update_row(p_allow_awt_flag => x_zx_party_tax_profile_bo_tbl(i).allow_awt_flag,
386: p_allow_offset_tax_flag => x_zx_party_tax_profile_bo_tbl(i).allow_offset_tax_flag,
387: p_attribute_category => x_zx_party_tax_profile_bo_tbl(i).attribute_category,
388: p_attribute1 => x_zx_party_tax_profile_bo_tbl(i).attribute1,
389: p_attribute10 => x_zx_party_tax_profile_bo_tbl(i).attribute10,
390: p_attribute11 => x_zx_party_tax_profile_bo_tbl(i).attribute11,
391: p_attribute12 => x_zx_party_tax_profile_bo_tbl(i).attribute12,
392: p_attribute13 => x_zx_party_tax_profile_bo_tbl(i).attribute13,

Line 389: p_attribute10 => x_zx_party_tax_profile_bo_tbl(i).attribute10,

385: zx_party_tax_profile_pkg.update_row(p_allow_awt_flag => x_zx_party_tax_profile_bo_tbl(i).allow_awt_flag,
386: p_allow_offset_tax_flag => x_zx_party_tax_profile_bo_tbl(i).allow_offset_tax_flag,
387: p_attribute_category => x_zx_party_tax_profile_bo_tbl(i).attribute_category,
388: p_attribute1 => x_zx_party_tax_profile_bo_tbl(i).attribute1,
389: p_attribute10 => x_zx_party_tax_profile_bo_tbl(i).attribute10,
390: p_attribute11 => x_zx_party_tax_profile_bo_tbl(i).attribute11,
391: p_attribute12 => x_zx_party_tax_profile_bo_tbl(i).attribute12,
392: p_attribute13 => x_zx_party_tax_profile_bo_tbl(i).attribute13,
393: p_attribute14 => x_zx_party_tax_profile_bo_tbl(i).attribute14,

Line 390: p_attribute11 => x_zx_party_tax_profile_bo_tbl(i).attribute11,

386: p_allow_offset_tax_flag => x_zx_party_tax_profile_bo_tbl(i).allow_offset_tax_flag,
387: p_attribute_category => x_zx_party_tax_profile_bo_tbl(i).attribute_category,
388: p_attribute1 => x_zx_party_tax_profile_bo_tbl(i).attribute1,
389: p_attribute10 => x_zx_party_tax_profile_bo_tbl(i).attribute10,
390: p_attribute11 => x_zx_party_tax_profile_bo_tbl(i).attribute11,
391: p_attribute12 => x_zx_party_tax_profile_bo_tbl(i).attribute12,
392: p_attribute13 => x_zx_party_tax_profile_bo_tbl(i).attribute13,
393: p_attribute14 => x_zx_party_tax_profile_bo_tbl(i).attribute14,
394: p_attribute15 => x_zx_party_tax_profile_bo_tbl(i).attribute15,

Line 391: p_attribute12 => x_zx_party_tax_profile_bo_tbl(i).attribute12,

387: p_attribute_category => x_zx_party_tax_profile_bo_tbl(i).attribute_category,
388: p_attribute1 => x_zx_party_tax_profile_bo_tbl(i).attribute1,
389: p_attribute10 => x_zx_party_tax_profile_bo_tbl(i).attribute10,
390: p_attribute11 => x_zx_party_tax_profile_bo_tbl(i).attribute11,
391: p_attribute12 => x_zx_party_tax_profile_bo_tbl(i).attribute12,
392: p_attribute13 => x_zx_party_tax_profile_bo_tbl(i).attribute13,
393: p_attribute14 => x_zx_party_tax_profile_bo_tbl(i).attribute14,
394: p_attribute15 => x_zx_party_tax_profile_bo_tbl(i).attribute15,
395: p_attribute2 => x_zx_party_tax_profile_bo_tbl(i).attribute2,

Line 392: p_attribute13 => x_zx_party_tax_profile_bo_tbl(i).attribute13,

388: p_attribute1 => x_zx_party_tax_profile_bo_tbl(i).attribute1,
389: p_attribute10 => x_zx_party_tax_profile_bo_tbl(i).attribute10,
390: p_attribute11 => x_zx_party_tax_profile_bo_tbl(i).attribute11,
391: p_attribute12 => x_zx_party_tax_profile_bo_tbl(i).attribute12,
392: p_attribute13 => x_zx_party_tax_profile_bo_tbl(i).attribute13,
393: p_attribute14 => x_zx_party_tax_profile_bo_tbl(i).attribute14,
394: p_attribute15 => x_zx_party_tax_profile_bo_tbl(i).attribute15,
395: p_attribute2 => x_zx_party_tax_profile_bo_tbl(i).attribute2,
396: p_attribute3 => x_zx_party_tax_profile_bo_tbl(i).attribute3,

Line 393: p_attribute14 => x_zx_party_tax_profile_bo_tbl(i).attribute14,

389: p_attribute10 => x_zx_party_tax_profile_bo_tbl(i).attribute10,
390: p_attribute11 => x_zx_party_tax_profile_bo_tbl(i).attribute11,
391: p_attribute12 => x_zx_party_tax_profile_bo_tbl(i).attribute12,
392: p_attribute13 => x_zx_party_tax_profile_bo_tbl(i).attribute13,
393: p_attribute14 => x_zx_party_tax_profile_bo_tbl(i).attribute14,
394: p_attribute15 => x_zx_party_tax_profile_bo_tbl(i).attribute15,
395: p_attribute2 => x_zx_party_tax_profile_bo_tbl(i).attribute2,
396: p_attribute3 => x_zx_party_tax_profile_bo_tbl(i).attribute3,
397: p_attribute4 => x_zx_party_tax_profile_bo_tbl(i).attribute4,

Line 394: p_attribute15 => x_zx_party_tax_profile_bo_tbl(i).attribute15,

390: p_attribute11 => x_zx_party_tax_profile_bo_tbl(i).attribute11,
391: p_attribute12 => x_zx_party_tax_profile_bo_tbl(i).attribute12,
392: p_attribute13 => x_zx_party_tax_profile_bo_tbl(i).attribute13,
393: p_attribute14 => x_zx_party_tax_profile_bo_tbl(i).attribute14,
394: p_attribute15 => x_zx_party_tax_profile_bo_tbl(i).attribute15,
395: p_attribute2 => x_zx_party_tax_profile_bo_tbl(i).attribute2,
396: p_attribute3 => x_zx_party_tax_profile_bo_tbl(i).attribute3,
397: p_attribute4 => x_zx_party_tax_profile_bo_tbl(i).attribute4,
398: p_attribute5 => x_zx_party_tax_profile_bo_tbl(i).attribute5,

Line 395: p_attribute2 => x_zx_party_tax_profile_bo_tbl(i).attribute2,

391: p_attribute12 => x_zx_party_tax_profile_bo_tbl(i).attribute12,
392: p_attribute13 => x_zx_party_tax_profile_bo_tbl(i).attribute13,
393: p_attribute14 => x_zx_party_tax_profile_bo_tbl(i).attribute14,
394: p_attribute15 => x_zx_party_tax_profile_bo_tbl(i).attribute15,
395: p_attribute2 => x_zx_party_tax_profile_bo_tbl(i).attribute2,
396: p_attribute3 => x_zx_party_tax_profile_bo_tbl(i).attribute3,
397: p_attribute4 => x_zx_party_tax_profile_bo_tbl(i).attribute4,
398: p_attribute5 => x_zx_party_tax_profile_bo_tbl(i).attribute5,
399: p_attribute6 => x_zx_party_tax_profile_bo_tbl(i).attribute6,

Line 396: p_attribute3 => x_zx_party_tax_profile_bo_tbl(i).attribute3,

392: p_attribute13 => x_zx_party_tax_profile_bo_tbl(i).attribute13,
393: p_attribute14 => x_zx_party_tax_profile_bo_tbl(i).attribute14,
394: p_attribute15 => x_zx_party_tax_profile_bo_tbl(i).attribute15,
395: p_attribute2 => x_zx_party_tax_profile_bo_tbl(i).attribute2,
396: p_attribute3 => x_zx_party_tax_profile_bo_tbl(i).attribute3,
397: p_attribute4 => x_zx_party_tax_profile_bo_tbl(i).attribute4,
398: p_attribute5 => x_zx_party_tax_profile_bo_tbl(i).attribute5,
399: p_attribute6 => x_zx_party_tax_profile_bo_tbl(i).attribute6,
400: p_attribute7 => x_zx_party_tax_profile_bo_tbl(i).attribute7,

Line 397: p_attribute4 => x_zx_party_tax_profile_bo_tbl(i).attribute4,

393: p_attribute14 => x_zx_party_tax_profile_bo_tbl(i).attribute14,
394: p_attribute15 => x_zx_party_tax_profile_bo_tbl(i).attribute15,
395: p_attribute2 => x_zx_party_tax_profile_bo_tbl(i).attribute2,
396: p_attribute3 => x_zx_party_tax_profile_bo_tbl(i).attribute3,
397: p_attribute4 => x_zx_party_tax_profile_bo_tbl(i).attribute4,
398: p_attribute5 => x_zx_party_tax_profile_bo_tbl(i).attribute5,
399: p_attribute6 => x_zx_party_tax_profile_bo_tbl(i).attribute6,
400: p_attribute7 => x_zx_party_tax_profile_bo_tbl(i).attribute7,
401: p_attribute8 => x_zx_party_tax_profile_bo_tbl(i).attribute8,

Line 398: p_attribute5 => x_zx_party_tax_profile_bo_tbl(i).attribute5,

394: p_attribute15 => x_zx_party_tax_profile_bo_tbl(i).attribute15,
395: p_attribute2 => x_zx_party_tax_profile_bo_tbl(i).attribute2,
396: p_attribute3 => x_zx_party_tax_profile_bo_tbl(i).attribute3,
397: p_attribute4 => x_zx_party_tax_profile_bo_tbl(i).attribute4,
398: p_attribute5 => x_zx_party_tax_profile_bo_tbl(i).attribute5,
399: p_attribute6 => x_zx_party_tax_profile_bo_tbl(i).attribute6,
400: p_attribute7 => x_zx_party_tax_profile_bo_tbl(i).attribute7,
401: p_attribute8 => x_zx_party_tax_profile_bo_tbl(i).attribute8,
402: p_attribute9 => x_zx_party_tax_profile_bo_tbl(i).attribute9,

Line 399: p_attribute6 => x_zx_party_tax_profile_bo_tbl(i).attribute6,

395: p_attribute2 => x_zx_party_tax_profile_bo_tbl(i).attribute2,
396: p_attribute3 => x_zx_party_tax_profile_bo_tbl(i).attribute3,
397: p_attribute4 => x_zx_party_tax_profile_bo_tbl(i).attribute4,
398: p_attribute5 => x_zx_party_tax_profile_bo_tbl(i).attribute5,
399: p_attribute6 => x_zx_party_tax_profile_bo_tbl(i).attribute6,
400: p_attribute7 => x_zx_party_tax_profile_bo_tbl(i).attribute7,
401: p_attribute8 => x_zx_party_tax_profile_bo_tbl(i).attribute8,
402: p_attribute9 => x_zx_party_tax_profile_bo_tbl(i).attribute9,
403: p_collecting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).collecting_authority_flag,

Line 400: p_attribute7 => x_zx_party_tax_profile_bo_tbl(i).attribute7,

396: p_attribute3 => x_zx_party_tax_profile_bo_tbl(i).attribute3,
397: p_attribute4 => x_zx_party_tax_profile_bo_tbl(i).attribute4,
398: p_attribute5 => x_zx_party_tax_profile_bo_tbl(i).attribute5,
399: p_attribute6 => x_zx_party_tax_profile_bo_tbl(i).attribute6,
400: p_attribute7 => x_zx_party_tax_profile_bo_tbl(i).attribute7,
401: p_attribute8 => x_zx_party_tax_profile_bo_tbl(i).attribute8,
402: p_attribute9 => x_zx_party_tax_profile_bo_tbl(i).attribute9,
403: p_collecting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).collecting_authority_flag,
404: p_country_code => x_zx_party_tax_profile_bo_tbl(i).country_code,

Line 401: p_attribute8 => x_zx_party_tax_profile_bo_tbl(i).attribute8,

397: p_attribute4 => x_zx_party_tax_profile_bo_tbl(i).attribute4,
398: p_attribute5 => x_zx_party_tax_profile_bo_tbl(i).attribute5,
399: p_attribute6 => x_zx_party_tax_profile_bo_tbl(i).attribute6,
400: p_attribute7 => x_zx_party_tax_profile_bo_tbl(i).attribute7,
401: p_attribute8 => x_zx_party_tax_profile_bo_tbl(i).attribute8,
402: p_attribute9 => x_zx_party_tax_profile_bo_tbl(i).attribute9,
403: p_collecting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).collecting_authority_flag,
404: p_country_code => x_zx_party_tax_profile_bo_tbl(i).country_code,
405: p_create_awt_dists_type_code => x_zx_party_tax_profile_bo_tbl(i).create_awt_dists_type_code,

Line 402: p_attribute9 => x_zx_party_tax_profile_bo_tbl(i).attribute9,

398: p_attribute5 => x_zx_party_tax_profile_bo_tbl(i).attribute5,
399: p_attribute6 => x_zx_party_tax_profile_bo_tbl(i).attribute6,
400: p_attribute7 => x_zx_party_tax_profile_bo_tbl(i).attribute7,
401: p_attribute8 => x_zx_party_tax_profile_bo_tbl(i).attribute8,
402: p_attribute9 => x_zx_party_tax_profile_bo_tbl(i).attribute9,
403: p_collecting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).collecting_authority_flag,
404: p_country_code => x_zx_party_tax_profile_bo_tbl(i).country_code,
405: p_create_awt_dists_type_code => x_zx_party_tax_profile_bo_tbl(i).create_awt_dists_type_code,
406: p_create_awt_invoices_type_cod => x_zx_party_tax_profile_bo_tbl(i).create_awt_invoices_type_code,

Line 403: p_collecting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).collecting_authority_flag,

399: p_attribute6 => x_zx_party_tax_profile_bo_tbl(i).attribute6,
400: p_attribute7 => x_zx_party_tax_profile_bo_tbl(i).attribute7,
401: p_attribute8 => x_zx_party_tax_profile_bo_tbl(i).attribute8,
402: p_attribute9 => x_zx_party_tax_profile_bo_tbl(i).attribute9,
403: p_collecting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).collecting_authority_flag,
404: p_country_code => x_zx_party_tax_profile_bo_tbl(i).country_code,
405: p_create_awt_dists_type_code => x_zx_party_tax_profile_bo_tbl(i).create_awt_dists_type_code,
406: p_create_awt_invoices_type_cod => x_zx_party_tax_profile_bo_tbl(i).create_awt_invoices_type_code,
407: p_customer_flag => x_zx_party_tax_profile_bo_tbl(i).customer_flag,

Line 404: p_country_code => x_zx_party_tax_profile_bo_tbl(i).country_code,

400: p_attribute7 => x_zx_party_tax_profile_bo_tbl(i).attribute7,
401: p_attribute8 => x_zx_party_tax_profile_bo_tbl(i).attribute8,
402: p_attribute9 => x_zx_party_tax_profile_bo_tbl(i).attribute9,
403: p_collecting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).collecting_authority_flag,
404: p_country_code => x_zx_party_tax_profile_bo_tbl(i).country_code,
405: p_create_awt_dists_type_code => x_zx_party_tax_profile_bo_tbl(i).create_awt_dists_type_code,
406: p_create_awt_invoices_type_cod => x_zx_party_tax_profile_bo_tbl(i).create_awt_invoices_type_code,
407: p_customer_flag => x_zx_party_tax_profile_bo_tbl(i).customer_flag,
408: p_effective_from_use_le => x_zx_party_tax_profile_bo_tbl(i).effective_from_use_le,

Line 405: p_create_awt_dists_type_code => x_zx_party_tax_profile_bo_tbl(i).create_awt_dists_type_code,

401: p_attribute8 => x_zx_party_tax_profile_bo_tbl(i).attribute8,
402: p_attribute9 => x_zx_party_tax_profile_bo_tbl(i).attribute9,
403: p_collecting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).collecting_authority_flag,
404: p_country_code => x_zx_party_tax_profile_bo_tbl(i).country_code,
405: p_create_awt_dists_type_code => x_zx_party_tax_profile_bo_tbl(i).create_awt_dists_type_code,
406: p_create_awt_invoices_type_cod => x_zx_party_tax_profile_bo_tbl(i).create_awt_invoices_type_code,
407: p_customer_flag => x_zx_party_tax_profile_bo_tbl(i).customer_flag,
408: p_effective_from_use_le => x_zx_party_tax_profile_bo_tbl(i).effective_from_use_le,
409: p_first_party_le_flag => x_zx_party_tax_profile_bo_tbl(i).first_party_le_flag,

Line 406: p_create_awt_invoices_type_cod => x_zx_party_tax_profile_bo_tbl(i).create_awt_invoices_type_code,

402: p_attribute9 => x_zx_party_tax_profile_bo_tbl(i).attribute9,
403: p_collecting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).collecting_authority_flag,
404: p_country_code => x_zx_party_tax_profile_bo_tbl(i).country_code,
405: p_create_awt_dists_type_code => x_zx_party_tax_profile_bo_tbl(i).create_awt_dists_type_code,
406: p_create_awt_invoices_type_cod => x_zx_party_tax_profile_bo_tbl(i).create_awt_invoices_type_code,
407: p_customer_flag => x_zx_party_tax_profile_bo_tbl(i).customer_flag,
408: p_effective_from_use_le => x_zx_party_tax_profile_bo_tbl(i).effective_from_use_le,
409: p_first_party_le_flag => x_zx_party_tax_profile_bo_tbl(i).first_party_le_flag,
410: p_inclusive_tax_flag => x_zx_party_tax_profile_bo_tbl(i).inclusive_tax_flag,

Line 407: p_customer_flag => x_zx_party_tax_profile_bo_tbl(i).customer_flag,

403: p_collecting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).collecting_authority_flag,
404: p_country_code => x_zx_party_tax_profile_bo_tbl(i).country_code,
405: p_create_awt_dists_type_code => x_zx_party_tax_profile_bo_tbl(i).create_awt_dists_type_code,
406: p_create_awt_invoices_type_cod => x_zx_party_tax_profile_bo_tbl(i).create_awt_invoices_type_code,
407: p_customer_flag => x_zx_party_tax_profile_bo_tbl(i).customer_flag,
408: p_effective_from_use_le => x_zx_party_tax_profile_bo_tbl(i).effective_from_use_le,
409: p_first_party_le_flag => x_zx_party_tax_profile_bo_tbl(i).first_party_le_flag,
410: p_inclusive_tax_flag => x_zx_party_tax_profile_bo_tbl(i).inclusive_tax_flag,
411: p_legal_establishment_flag => x_zx_party_tax_profile_bo_tbl(i).legal_establishment_flag,

Line 408: p_effective_from_use_le => x_zx_party_tax_profile_bo_tbl(i).effective_from_use_le,

404: p_country_code => x_zx_party_tax_profile_bo_tbl(i).country_code,
405: p_create_awt_dists_type_code => x_zx_party_tax_profile_bo_tbl(i).create_awt_dists_type_code,
406: p_create_awt_invoices_type_cod => x_zx_party_tax_profile_bo_tbl(i).create_awt_invoices_type_code,
407: p_customer_flag => x_zx_party_tax_profile_bo_tbl(i).customer_flag,
408: p_effective_from_use_le => x_zx_party_tax_profile_bo_tbl(i).effective_from_use_le,
409: p_first_party_le_flag => x_zx_party_tax_profile_bo_tbl(i).first_party_le_flag,
410: p_inclusive_tax_flag => x_zx_party_tax_profile_bo_tbl(i).inclusive_tax_flag,
411: p_legal_establishment_flag => x_zx_party_tax_profile_bo_tbl(i).legal_establishment_flag,
412: p_party_id => x_zx_party_tax_profile_bo_tbl(i).party_id,

Line 409: p_first_party_le_flag => x_zx_party_tax_profile_bo_tbl(i).first_party_le_flag,

405: p_create_awt_dists_type_code => x_zx_party_tax_profile_bo_tbl(i).create_awt_dists_type_code,
406: p_create_awt_invoices_type_cod => x_zx_party_tax_profile_bo_tbl(i).create_awt_invoices_type_code,
407: p_customer_flag => x_zx_party_tax_profile_bo_tbl(i).customer_flag,
408: p_effective_from_use_le => x_zx_party_tax_profile_bo_tbl(i).effective_from_use_le,
409: p_first_party_le_flag => x_zx_party_tax_profile_bo_tbl(i).first_party_le_flag,
410: p_inclusive_tax_flag => x_zx_party_tax_profile_bo_tbl(i).inclusive_tax_flag,
411: p_legal_establishment_flag => x_zx_party_tax_profile_bo_tbl(i).legal_establishment_flag,
412: p_party_id => x_zx_party_tax_profile_bo_tbl(i).party_id,
413: p_party_type_code => x_zx_party_tax_profile_bo_tbl(i).party_type_code,

Line 410: p_inclusive_tax_flag => x_zx_party_tax_profile_bo_tbl(i).inclusive_tax_flag,

406: p_create_awt_invoices_type_cod => x_zx_party_tax_profile_bo_tbl(i).create_awt_invoices_type_code,
407: p_customer_flag => x_zx_party_tax_profile_bo_tbl(i).customer_flag,
408: p_effective_from_use_le => x_zx_party_tax_profile_bo_tbl(i).effective_from_use_le,
409: p_first_party_le_flag => x_zx_party_tax_profile_bo_tbl(i).first_party_le_flag,
410: p_inclusive_tax_flag => x_zx_party_tax_profile_bo_tbl(i).inclusive_tax_flag,
411: p_legal_establishment_flag => x_zx_party_tax_profile_bo_tbl(i).legal_establishment_flag,
412: p_party_id => x_zx_party_tax_profile_bo_tbl(i).party_id,
413: p_party_type_code => x_zx_party_tax_profile_bo_tbl(i).party_type_code,
414: p_process_for_applicability_fl => x_zx_party_tax_profile_bo_tbl(i).process_for_applicability_flag,

Line 411: p_legal_establishment_flag => x_zx_party_tax_profile_bo_tbl(i).legal_establishment_flag,

407: p_customer_flag => x_zx_party_tax_profile_bo_tbl(i).customer_flag,
408: p_effective_from_use_le => x_zx_party_tax_profile_bo_tbl(i).effective_from_use_le,
409: p_first_party_le_flag => x_zx_party_tax_profile_bo_tbl(i).first_party_le_flag,
410: p_inclusive_tax_flag => x_zx_party_tax_profile_bo_tbl(i).inclusive_tax_flag,
411: p_legal_establishment_flag => x_zx_party_tax_profile_bo_tbl(i).legal_establishment_flag,
412: p_party_id => x_zx_party_tax_profile_bo_tbl(i).party_id,
413: p_party_type_code => x_zx_party_tax_profile_bo_tbl(i).party_type_code,
414: p_process_for_applicability_fl => x_zx_party_tax_profile_bo_tbl(i).process_for_applicability_flag,
415: p_program_login_id => x_zx_party_tax_profile_bo_tbl(i).program_application_id,

Line 412: p_party_id => x_zx_party_tax_profile_bo_tbl(i).party_id,

408: p_effective_from_use_le => x_zx_party_tax_profile_bo_tbl(i).effective_from_use_le,
409: p_first_party_le_flag => x_zx_party_tax_profile_bo_tbl(i).first_party_le_flag,
410: p_inclusive_tax_flag => x_zx_party_tax_profile_bo_tbl(i).inclusive_tax_flag,
411: p_legal_establishment_flag => x_zx_party_tax_profile_bo_tbl(i).legal_establishment_flag,
412: p_party_id => x_zx_party_tax_profile_bo_tbl(i).party_id,
413: p_party_type_code => x_zx_party_tax_profile_bo_tbl(i).party_type_code,
414: p_process_for_applicability_fl => x_zx_party_tax_profile_bo_tbl(i).process_for_applicability_flag,
415: p_program_login_id => x_zx_party_tax_profile_bo_tbl(i).program_application_id,
416: p_provider_type_code => x_zx_party_tax_profile_bo_tbl(i).provider_type_code,

Line 413: p_party_type_code => x_zx_party_tax_profile_bo_tbl(i).party_type_code,

409: p_first_party_le_flag => x_zx_party_tax_profile_bo_tbl(i).first_party_le_flag,
410: p_inclusive_tax_flag => x_zx_party_tax_profile_bo_tbl(i).inclusive_tax_flag,
411: p_legal_establishment_flag => x_zx_party_tax_profile_bo_tbl(i).legal_establishment_flag,
412: p_party_id => x_zx_party_tax_profile_bo_tbl(i).party_id,
413: p_party_type_code => x_zx_party_tax_profile_bo_tbl(i).party_type_code,
414: p_process_for_applicability_fl => x_zx_party_tax_profile_bo_tbl(i).process_for_applicability_flag,
415: p_program_login_id => x_zx_party_tax_profile_bo_tbl(i).program_application_id,
416: p_provider_type_code => x_zx_party_tax_profile_bo_tbl(i).provider_type_code,
417: p_record_type_code => x_zx_party_tax_profile_bo_tbl(i).record_type_code,

Line 414: p_process_for_applicability_fl => x_zx_party_tax_profile_bo_tbl(i).process_for_applicability_flag,

410: p_inclusive_tax_flag => x_zx_party_tax_profile_bo_tbl(i).inclusive_tax_flag,
411: p_legal_establishment_flag => x_zx_party_tax_profile_bo_tbl(i).legal_establishment_flag,
412: p_party_id => x_zx_party_tax_profile_bo_tbl(i).party_id,
413: p_party_type_code => x_zx_party_tax_profile_bo_tbl(i).party_type_code,
414: p_process_for_applicability_fl => x_zx_party_tax_profile_bo_tbl(i).process_for_applicability_flag,
415: p_program_login_id => x_zx_party_tax_profile_bo_tbl(i).program_application_id,
416: p_provider_type_code => x_zx_party_tax_profile_bo_tbl(i).provider_type_code,
417: p_record_type_code => x_zx_party_tax_profile_bo_tbl(i).record_type_code,
418: p_registration_type_code => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,

Line 415: p_program_login_id => x_zx_party_tax_profile_bo_tbl(i).program_application_id,

411: p_legal_establishment_flag => x_zx_party_tax_profile_bo_tbl(i).legal_establishment_flag,
412: p_party_id => x_zx_party_tax_profile_bo_tbl(i).party_id,
413: p_party_type_code => x_zx_party_tax_profile_bo_tbl(i).party_type_code,
414: p_process_for_applicability_fl => x_zx_party_tax_profile_bo_tbl(i).process_for_applicability_flag,
415: p_program_login_id => x_zx_party_tax_profile_bo_tbl(i).program_application_id,
416: p_provider_type_code => x_zx_party_tax_profile_bo_tbl(i).provider_type_code,
417: p_record_type_code => x_zx_party_tax_profile_bo_tbl(i).record_type_code,
418: p_registration_type_code => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,
419: p_rep_registration_number => x_zx_party_tax_profile_bo_tbl(i).rep_registration_number,

Line 416: p_provider_type_code => x_zx_party_tax_profile_bo_tbl(i).provider_type_code,

412: p_party_id => x_zx_party_tax_profile_bo_tbl(i).party_id,
413: p_party_type_code => x_zx_party_tax_profile_bo_tbl(i).party_type_code,
414: p_process_for_applicability_fl => x_zx_party_tax_profile_bo_tbl(i).process_for_applicability_flag,
415: p_program_login_id => x_zx_party_tax_profile_bo_tbl(i).program_application_id,
416: p_provider_type_code => x_zx_party_tax_profile_bo_tbl(i).provider_type_code,
417: p_record_type_code => x_zx_party_tax_profile_bo_tbl(i).record_type_code,
418: p_registration_type_code => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,
419: p_rep_registration_number => x_zx_party_tax_profile_bo_tbl(i).rep_registration_number,
420: p_reporting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).reporting_authority_flag,

Line 417: p_record_type_code => x_zx_party_tax_profile_bo_tbl(i).record_type_code,

413: p_party_type_code => x_zx_party_tax_profile_bo_tbl(i).party_type_code,
414: p_process_for_applicability_fl => x_zx_party_tax_profile_bo_tbl(i).process_for_applicability_flag,
415: p_program_login_id => x_zx_party_tax_profile_bo_tbl(i).program_application_id,
416: p_provider_type_code => x_zx_party_tax_profile_bo_tbl(i).provider_type_code,
417: p_record_type_code => x_zx_party_tax_profile_bo_tbl(i).record_type_code,
418: p_registration_type_code => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,
419: p_rep_registration_number => x_zx_party_tax_profile_bo_tbl(i).rep_registration_number,
420: p_reporting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).reporting_authority_flag,
421: p_request_id => x_zx_party_tax_profile_bo_tbl(i).request_id,

Line 418: p_registration_type_code => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,

414: p_process_for_applicability_fl => x_zx_party_tax_profile_bo_tbl(i).process_for_applicability_flag,
415: p_program_login_id => x_zx_party_tax_profile_bo_tbl(i).program_application_id,
416: p_provider_type_code => x_zx_party_tax_profile_bo_tbl(i).provider_type_code,
417: p_record_type_code => x_zx_party_tax_profile_bo_tbl(i).record_type_code,
418: p_registration_type_code => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,
419: p_rep_registration_number => x_zx_party_tax_profile_bo_tbl(i).rep_registration_number,
420: p_reporting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).reporting_authority_flag,
421: p_request_id => x_zx_party_tax_profile_bo_tbl(i).request_id,
422: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,

Line 419: p_rep_registration_number => x_zx_party_tax_profile_bo_tbl(i).rep_registration_number,

415: p_program_login_id => x_zx_party_tax_profile_bo_tbl(i).program_application_id,
416: p_provider_type_code => x_zx_party_tax_profile_bo_tbl(i).provider_type_code,
417: p_record_type_code => x_zx_party_tax_profile_bo_tbl(i).record_type_code,
418: p_registration_type_code => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,
419: p_rep_registration_number => x_zx_party_tax_profile_bo_tbl(i).rep_registration_number,
420: p_reporting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).reporting_authority_flag,
421: p_request_id => x_zx_party_tax_profile_bo_tbl(i).request_id,
422: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,
423: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,

Line 420: p_reporting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).reporting_authority_flag,

416: p_provider_type_code => x_zx_party_tax_profile_bo_tbl(i).provider_type_code,
417: p_record_type_code => x_zx_party_tax_profile_bo_tbl(i).record_type_code,
418: p_registration_type_code => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,
419: p_rep_registration_number => x_zx_party_tax_profile_bo_tbl(i).rep_registration_number,
420: p_reporting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).reporting_authority_flag,
421: p_request_id => x_zx_party_tax_profile_bo_tbl(i).request_id,
422: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,
423: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,
424: p_self_assess_flag => x_zx_party_tax_profile_bo_tbl(i).self_assess_flag,

Line 421: p_request_id => x_zx_party_tax_profile_bo_tbl(i).request_id,

417: p_record_type_code => x_zx_party_tax_profile_bo_tbl(i).record_type_code,
418: p_registration_type_code => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,
419: p_rep_registration_number => x_zx_party_tax_profile_bo_tbl(i).rep_registration_number,
420: p_reporting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).reporting_authority_flag,
421: p_request_id => x_zx_party_tax_profile_bo_tbl(i).request_id,
422: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,
423: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,
424: p_self_assess_flag => x_zx_party_tax_profile_bo_tbl(i).self_assess_flag,
425: p_site_flag => x_zx_party_tax_profile_bo_tbl(i).site_flag,

Line 422: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,

418: p_registration_type_code => x_zx_party_tax_profile_bo_tbl(i).registration_type_code,
419: p_rep_registration_number => x_zx_party_tax_profile_bo_tbl(i).rep_registration_number,
420: p_reporting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).reporting_authority_flag,
421: p_request_id => x_zx_party_tax_profile_bo_tbl(i).request_id,
422: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,
423: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,
424: p_self_assess_flag => x_zx_party_tax_profile_bo_tbl(i).self_assess_flag,
425: p_site_flag => x_zx_party_tax_profile_bo_tbl(i).site_flag,
426: p_supplier_flag => x_zx_party_tax_profile_bo_tbl(i).supplier_flag,

Line 423: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,

419: p_rep_registration_number => x_zx_party_tax_profile_bo_tbl(i).rep_registration_number,
420: p_reporting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).reporting_authority_flag,
421: p_request_id => x_zx_party_tax_profile_bo_tbl(i).request_id,
422: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,
423: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,
424: p_self_assess_flag => x_zx_party_tax_profile_bo_tbl(i).self_assess_flag,
425: p_site_flag => x_zx_party_tax_profile_bo_tbl(i).site_flag,
426: p_supplier_flag => x_zx_party_tax_profile_bo_tbl(i).supplier_flag,
427: p_tax_classification_code => x_zx_party_tax_profile_bo_tbl(i).tax_classification_code,

Line 424: p_self_assess_flag => x_zx_party_tax_profile_bo_tbl(i).self_assess_flag,

420: p_reporting_authority_flag => x_zx_party_tax_profile_bo_tbl(i).reporting_authority_flag,
421: p_request_id => x_zx_party_tax_profile_bo_tbl(i).request_id,
422: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,
423: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,
424: p_self_assess_flag => x_zx_party_tax_profile_bo_tbl(i).self_assess_flag,
425: p_site_flag => x_zx_party_tax_profile_bo_tbl(i).site_flag,
426: p_supplier_flag => x_zx_party_tax_profile_bo_tbl(i).supplier_flag,
427: p_tax_classification_code => x_zx_party_tax_profile_bo_tbl(i).tax_classification_code,
428: p_use_le_as_subscriber_flag => x_zx_party_tax_profile_bo_tbl(i).use_le_as_subscriber_flag,

Line 425: p_site_flag => x_zx_party_tax_profile_bo_tbl(i).site_flag,

421: p_request_id => x_zx_party_tax_profile_bo_tbl(i).request_id,
422: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,
423: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,
424: p_self_assess_flag => x_zx_party_tax_profile_bo_tbl(i).self_assess_flag,
425: p_site_flag => x_zx_party_tax_profile_bo_tbl(i).site_flag,
426: p_supplier_flag => x_zx_party_tax_profile_bo_tbl(i).supplier_flag,
427: p_tax_classification_code => x_zx_party_tax_profile_bo_tbl(i).tax_classification_code,
428: p_use_le_as_subscriber_flag => x_zx_party_tax_profile_bo_tbl(i).use_le_as_subscriber_flag,
429: p_withholding_start_date => x_zx_party_tax_profile_bo_tbl(i).withholding_start_date,

Line 426: p_supplier_flag => x_zx_party_tax_profile_bo_tbl(i).supplier_flag,

422: p_rounding_level_code => x_zx_party_tax_profile_bo_tbl(i).rounding_level_code,
423: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,
424: p_self_assess_flag => x_zx_party_tax_profile_bo_tbl(i).self_assess_flag,
425: p_site_flag => x_zx_party_tax_profile_bo_tbl(i).site_flag,
426: p_supplier_flag => x_zx_party_tax_profile_bo_tbl(i).supplier_flag,
427: p_tax_classification_code => x_zx_party_tax_profile_bo_tbl(i).tax_classification_code,
428: p_use_le_as_subscriber_flag => x_zx_party_tax_profile_bo_tbl(i).use_le_as_subscriber_flag,
429: p_withholding_start_date => x_zx_party_tax_profile_bo_tbl(i).withholding_start_date,
430: p_party_tax_profile_id => x_zx_party_tax_profile_bo_tbl(i).party_tax_profile_id,

Line 427: p_tax_classification_code => x_zx_party_tax_profile_bo_tbl(i).tax_classification_code,

423: p_rounding_rule_code => x_zx_party_tax_profile_bo_tbl(i).rounding_rule_code,
424: p_self_assess_flag => x_zx_party_tax_profile_bo_tbl(i).self_assess_flag,
425: p_site_flag => x_zx_party_tax_profile_bo_tbl(i).site_flag,
426: p_supplier_flag => x_zx_party_tax_profile_bo_tbl(i).supplier_flag,
427: p_tax_classification_code => x_zx_party_tax_profile_bo_tbl(i).tax_classification_code,
428: p_use_le_as_subscriber_flag => x_zx_party_tax_profile_bo_tbl(i).use_le_as_subscriber_flag,
429: p_withholding_start_date => x_zx_party_tax_profile_bo_tbl(i).withholding_start_date,
430: p_party_tax_profile_id => x_zx_party_tax_profile_bo_tbl(i).party_tax_profile_id,
431: x_return_status => l_return_status);

Line 428: p_use_le_as_subscriber_flag => x_zx_party_tax_profile_bo_tbl(i).use_le_as_subscriber_flag,

424: p_self_assess_flag => x_zx_party_tax_profile_bo_tbl(i).self_assess_flag,
425: p_site_flag => x_zx_party_tax_profile_bo_tbl(i).site_flag,
426: p_supplier_flag => x_zx_party_tax_profile_bo_tbl(i).supplier_flag,
427: p_tax_classification_code => x_zx_party_tax_profile_bo_tbl(i).tax_classification_code,
428: p_use_le_as_subscriber_flag => x_zx_party_tax_profile_bo_tbl(i).use_le_as_subscriber_flag,
429: p_withholding_start_date => x_zx_party_tax_profile_bo_tbl(i).withholding_start_date,
430: p_party_tax_profile_id => x_zx_party_tax_profile_bo_tbl(i).party_tax_profile_id,
431: x_return_status => l_return_status);
432:

Line 429: p_withholding_start_date => x_zx_party_tax_profile_bo_tbl(i).withholding_start_date,

425: p_site_flag => x_zx_party_tax_profile_bo_tbl(i).site_flag,
426: p_supplier_flag => x_zx_party_tax_profile_bo_tbl(i).supplier_flag,
427: p_tax_classification_code => x_zx_party_tax_profile_bo_tbl(i).tax_classification_code,
428: p_use_le_as_subscriber_flag => x_zx_party_tax_profile_bo_tbl(i).use_le_as_subscriber_flag,
429: p_withholding_start_date => x_zx_party_tax_profile_bo_tbl(i).withholding_start_date,
430: p_party_tax_profile_id => x_zx_party_tax_profile_bo_tbl(i).party_tax_profile_id,
431: x_return_status => l_return_status);
432:
433: IF (l_return_status <> 'S') THEN

Line 430: p_party_tax_profile_id => x_zx_party_tax_profile_bo_tbl(i).party_tax_profile_id,

426: p_supplier_flag => x_zx_party_tax_profile_bo_tbl(i).supplier_flag,
427: p_tax_classification_code => x_zx_party_tax_profile_bo_tbl(i).tax_classification_code,
428: p_use_le_as_subscriber_flag => x_zx_party_tax_profile_bo_tbl(i).use_le_as_subscriber_flag,
429: p_withholding_start_date => x_zx_party_tax_profile_bo_tbl(i).withholding_start_date,
430: p_party_tax_profile_id => x_zx_party_tax_profile_bo_tbl(i).party_tax_profile_id,
431: x_return_status => l_return_status);
432:
433: IF (l_return_status <> 'S') THEN
434: x_return_status := l_return_status;

Line 509: zx_party_tax_profile_pkg.update_row(p_party_tax_profile_id => l_party_tax_profile_id,

505: x_country_code => l_country_code);
506:
507: IF (l_tax_prof_valid = 'Y') THEN
508:
509: zx_party_tax_profile_pkg.update_row(p_party_tax_profile_id => l_party_tax_profile_id,
510: p_collecting_authority_flag => NULL,
511: p_provider_type_code => NULL,
512: p_create_awt_dists_type_code => NULL,
513: p_create_awt_invoices_type_cod => NULL,