APPS.AP_VENDOR_PUB_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 7029: l_tax_classification_code ZX_PARTY_TAX_PROFILE.TAX_CLASSIFICATION_CODE%TYPE;

7025:
7026: l_ext_payee_rec IBY_DISBURSEMENT_SETUP_PUB.EXTERNAL_PAYEE_REC_TYPE;
7027:
7028: -- Bug#7506443 start
7029: l_tax_classification_code ZX_PARTY_TAX_PROFILE.TAX_CLASSIFICATION_CODE%TYPE;
7030: l_pymt_method_code iby_external_payees_all.default_payment_method_code%TYPE;
7031: l_inactive_date iby_external_payees_all.Inactive_Date%TYPE;
7032: l_primary_flag iby_ext_party_pmt_mthds.primary_flag%TYPE;
7033: l_Exclusive_Pay_Flag IBY_EXTERNAL_PAYEES_ALL.exclusive_payment_flag%TYPE;

Line 7046: L_PARTY_TAX_PROFILE_ID zx_party_tax_profile.party_tax_profile_id%type; -- Bug 7207314

7042: -- BUG 6739544 End
7043:
7044: l_party_site_num VARCHAR2(1); -- Bug 6823885
7045:
7046: L_PARTY_TAX_PROFILE_ID zx_party_tax_profile.party_tax_profile_id%type; -- Bug 7207314
7047: l_return_status VARCHAR2(2000); --Bug 7207314
7048: -- changes for Bug#7506443 start
7049: Cursor get_iby_dtls_csr(p_prty_id NUMBER) is
7050: SELECT pmtmthdAssignmentseo.Payment_Method_Code,

Line 7621: FROM ZX_PARTY_TAX_PROFILE

7617: SELECT PROCESS_FOR_APPLICABILITY_FLAG, ALLOW_OFFSET_TAX_FLAG
7618: , TAX_CLASSIFICATION_CODE -- Bug#7506443
7619: INTO l_auto_tax_calc_flag,l_offset_tax_flag,
7620: l_tax_classification_code -- Bug#7506443
7621: FROM ZX_PARTY_TAX_PROFILE
7622: WHERE PARTY_ID = l_party_id
7623: AND PARTY_TYPE_CODE = 'THIRD_PARTY'
7624: AND ROWNUM = 1;
7625: EXCEPTION

Line 7627: l_debug_info := 'No data returned from ZX_PARTY_TAX_PROFILE for party_id = '||l_party_id;

7623: AND PARTY_TYPE_CODE = 'THIRD_PARTY'
7624: AND ROWNUM = 1;
7625: EXCEPTION
7626: WHEN OTHERS THEN
7627: l_debug_info := 'No data returned from ZX_PARTY_TAX_PROFILE for party_id = '||l_party_id;
7628: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7629: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
7630: END IF;
7631: END;

Line 7646: -- Start Bug 7207314. Update Tax Registration Number in ZX_PARTY_TAX_PROFILE

7642: -- Bug#7642742 end
7643:
7644:
7645:
7646: -- Start Bug 7207314. Update Tax Registration Number in ZX_PARTY_TAX_PROFILE
7647: -- VAT Registration Number is not stored at site level or HZ Party Site.
7648: -- This info is maintained by ZX Party Profile as 3rd party site tax profile.
7649:
7650: IF (l_vendor_site_rec.vat_registration_num is not null

Line 7660: FROM ZX_PARTY_TAX_PROFILE

7656: FND_API.G_RET_STS_SUCCESS)) ) THEN
7657:
7658: BEGIN
7659: SELECT PARTY_TAX_PROFILE_ID INTO L_PARTY_TAX_PROFILE_ID
7660: FROM ZX_PARTY_TAX_PROFILE
7661: WHERE PARTY_ID = l_party_site_id
7662: AND PARTY_TYPE_CODE = 'THIRD_PARTY_SITE'
7663: AND ROWNUM = 1;
7664: EXCEPTION

Line 7670: ZX_PARTY_TAX_PROFILE_PKG.update_row (

7666: L_PARTY_TAX_PROFILE_ID := NULL;
7667: END;
7668:
7669: IF L_PARTY_TAX_PROFILE_ID IS NOT NULL THEN
7670: ZX_PARTY_TAX_PROFILE_PKG.update_row (
7671: P_PARTY_TAX_PROFILE_ID => L_PARTY_TAX_PROFILE_ID,
7672: P_COLLECTING_AUTHORITY_FLAG => null,
7673: P_PROVIDER_TYPE_CODE => null,
7674: P_CREATE_AWT_DISTS_TYPE_CODE => null,

Line 7720: l_debug_info := 'ZX_PARTY_TAX_PROFILE_PKG.update_row';

7716: P_REGISTRATION_TYPE_CODE => null,
7717: P_COUNTRY_CODE => null
7718: );
7719: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7720: l_debug_info := 'ZX_PARTY_TAX_PROFILE_PKG.update_row';
7721: l_debug_info := l_debug_info||' Return status : '||l_return_status;
7722: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
7723: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
7724: END IF;