[Home] [Help]
5983: -- Check if the Tax Profile Id exists
5984: BEGIN
5985: SELECT party_tax_profile_id
5986: INTO x_party_tax_profile_id
5987: FROM zx_party_tax_profile
5988: WHERE party_id = p_tax_profile_rec.party_id
5989: AND party_type_code = 'THIRD_PARTY';
5990:
5991: RETURN;
6216: IF (l_tax_prof_valid = 'Y') THEN
6217:
6218: IF (p_tax_profile_rec.insert_update_flag = 'U') THEN
6219: fnd_file.put_line(fnd_file.log, ' Updating Tax profile');
6220: zx_party_tax_profile_pkg.update_row(p_party_tax_profile_id => l_party_tax_profile_id,
6221: p_collecting_authority_flag => NULL,
6222: p_provider_type_code => NULL,
6223: p_create_awt_dists_type_code => NULL,
6224: p_create_awt_invoices_type_cod => NULL,
6268: x_tax_profile_id := l_party_tax_profile_id;
6269: ELSE
6270: -- Insert
6271: fnd_file.put_line(fnd_file.log, ' Creating Tax profile');
6272: zx_party_tax_profile_pkg.insert_row(p_collecting_authority_flag => NULL,
6273: p_provider_type_code => NULL,
6274: p_create_awt_dists_type_code => NULL,
6275: p_create_awt_invoices_type_cod => NULL,
6276: p_tax_classification_code => NULL,
6321: --
6322: IF (l_return_status = 'S') THEN
6323: SELECT party_tax_profile_id
6324: INTO l_party_tax_profile_id
6325: FROM zx_party_tax_profile
6326: WHERE party_id = p_tax_profile_rec.party_id
6327: AND party_type_code = 'THIRD_PARTY';
6328:
6329: x_tax_profile_id := l_party_tax_profile_id;
6658: fnd_file.put_line(fnd_file.log, ' Getting tax authority party id');
6659: BEGIN
6660: SELECT prof.party_id
6661: INTO l_tax_authority_party_id
6662: FROM zx_party_tax_profile prof,
6663: hz_parties hp
6664: WHERE hp.party_id = prof.party_id
6665: AND prof.party_type_code = 'TAX_AUTHORITY'
6666: AND hp.party_name = p_tax_reg_rec.tax_authority_name;
7127:
7128: IF (l_valid = 'Y') THEN
7129:
7130: hz_code_assignments_pkg.insert_row(x_code_assignment_id => l_code_assignment_id,
7131: x_owner_table_name => 'ZX_PARTY_TAX_PROFILE',
7132: x_owner_table_id => p_fiscal_class_rec.tax_profile_id,
7133: x_owner_table_key_1 => NULL,
7134: x_owner_table_key_2 => NULL,
7135: x_owner_table_key_3 => NULL,
7234: ROWID
7235: INTO l_code_assignment_id,
7236: l_rowid
7237: FROM hz_code_assignments
7238: WHERE owner_table_name = 'ZX_PARTY_TAX_PROFILE'
7239: AND owner_table_id = p_fiscal_class_rec.tax_profile_id
7240: AND class_category = l_classification_type;
7241:
7242: EXCEPTION
7247: END;
7248:
7249: hz_code_assignments_pkg.update_row(x_rowid => l_rowid,
7250: x_code_assignment_id => l_code_assignment_id,
7251: x_owner_table_name => 'ZX_PARTY_TAX_PROFILE',
7252: x_owner_table_id => p_fiscal_class_rec.tax_profile_id,
7253: x_owner_table_key_1 => NULL,
7254: x_owner_table_key_2 => NULL,
7255: x_owner_table_key_3 => NULL,
7576: IF (l_tax_profile_rec_tab(cntr).insert_update_flag IS NULL) THEN
7577: BEGIN
7578: SELECT 'U'
7579: INTO l_tax_profile_rec_tab(cntr).insert_update_flag
7580: FROM zx_party_tax_profile
7581: WHERE party_id = l_tax_profile_rec_tab(cntr).party_id
7582: AND party_type_code = 'THIRD_PARTY';
7583:
7584: EXCEPTION
7699: IF (l_tax_reg_rec_tab(cntr).tax_profile_id IS NULL) THEN
7700: BEGIN
7701: SELECT party_tax_profile_id
7702: INTO l_tax_profile_id
7703: FROM zx_party_tax_profile
7704: WHERE party_id = l_party_id
7705: AND party_type_code = 'THIRD_PARTY';
7706:
7707: l_tax_reg_rec_tab(cntr).tax_profile_id := l_tax_profile_id;
7870: IF (l_fiscal_class_rec_tab(cntr).tax_profile_id IS NULL) THEN
7871: BEGIN
7872: SELECT party_tax_profile_id
7873: INTO l_tax_profile_id
7874: FROM zx_party_tax_profile
7875: WHERE party_id = l_party_id
7876: AND party_type_code = 'THIRD_PARTY';
7877:
7878: l_fiscal_class_rec_tab(cntr).tax_profile_id := l_tax_profile_id;
7927:
7928: SELECT 'U'
7929: INTO l_fiscal_class_rec_tab(cntr).insert_update_flag
7930: FROM hz_code_assignments
7931: WHERE owner_table_name = 'ZX_PARTY_TAX_PROFILE'
7932: AND owner_table_id = l_fiscal_class_rec_tab(cntr)
7933: .tax_profile_id
7934: AND class_category = l_classification_type;
7935: