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.AP_VENDOR_PUB_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 3525: l_tax_classification_code ZX_PARTY_TAX_PROFILE.TAX_CLASSIFICATION_CODE%TYPE ; --B 9202909

3521: l_url_contact_point_id NUMBER; --B 7831956
3522:
3523: l_offset_tax_flag VARCHAR2(1) ; --B 9202909
3524: l_auto_tax_calc_flag VARCHAR2(1) ; --B 9202909
3525: l_tax_classification_code ZX_PARTY_TAX_PROFILE.TAX_CLASSIFICATION_CODE%TYPE ; --B 9202909
3526: l_party_id NUMBER ; --B 9202909
3527: L_PARTY_TAX_PROFILE_ID zx_party_tax_profile.party_tax_profile_id%type; -- B 9202909
3528: l_return_status VARCHAR2(50); -- B 9202909
3529:

Line 3527: L_PARTY_TAX_PROFILE_ID zx_party_tax_profile.party_tax_profile_id%type; -- B 9202909

3523: l_offset_tax_flag VARCHAR2(1) ; --B 9202909
3524: l_auto_tax_calc_flag VARCHAR2(1) ; --B 9202909
3525: l_tax_classification_code ZX_PARTY_TAX_PROFILE.TAX_CLASSIFICATION_CODE%TYPE ; --B 9202909
3526: l_party_id NUMBER ; --B 9202909
3527: L_PARTY_TAX_PROFILE_ID zx_party_tax_profile.party_tax_profile_id%type; -- B 9202909
3528: l_return_status VARCHAR2(50); -- B 9202909
3529:
3530: BEGIN
3531: -- Standard Start of API savepoint

Line 3901: FROM ZX_PARTY_TAX_PROFILE

3897: SELECT PROCESS_FOR_APPLICABILITY_FLAG, ALLOW_OFFSET_TAX_FLAG, TAX_CLASSIFICATION_CODE,
3898: PARTY_TAX_PROFILE_ID
3899: INTO l_auto_tax_calc_flag,l_offset_tax_flag, l_tax_classification_code,
3900: L_PARTY_TAX_PROFILE_ID
3901: FROM ZX_PARTY_TAX_PROFILE
3902: WHERE PARTY_ID = l_party_id
3903: AND PARTY_TYPE_CODE = 'THIRD_PARTY'
3904: AND ROWNUM = 1;
3905:

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

3905:
3906: EXCEPTION
3907: WHEN OTHERS THEN
3908: L_PARTY_TAX_PROFILE_ID := NULL;
3909: l_debug_info := 'No data returned from ZX_PARTY_TAX_PROFILE for party_id = '||l_party_id;
3910: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3911: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3912: END IF;
3913: END;

Line 3929: ZX_PARTY_TAX_PROFILE_PKG.update_row (

3925: or l_tax_classification_code is not null) THEN -- Bug#7642742
3926:
3927: IF L_PARTY_TAX_PROFILE_ID IS NOT NULL THEN
3928:
3929: ZX_PARTY_TAX_PROFILE_PKG.update_row (
3930: P_PARTY_TAX_PROFILE_ID => L_PARTY_TAX_PROFILE_ID,
3931: P_COLLECTING_AUTHORITY_FLAG => null,
3932: P_PROVIDER_TYPE_CODE => null,
3933: P_CREATE_AWT_DISTS_TYPE_CODE => null,

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

3976: P_COUNTRY_CODE => null
3977: );
3978:
3979: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3980: l_debug_info := 'ZX_PARTY_TAX_PROFILE_PKG.update_row';
3981: l_debug_info := l_debug_info||' Return status : '||l_return_status;
3982: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3983: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
3984: END IF;

Line 7837: l_tax_classification_code ZX_PARTY_TAX_PROFILE.TAX_CLASSIFICATION_CODE%TYPE;

7833:
7834: l_ext_payee_rec IBY_DISBURSEMENT_SETUP_PUB.EXTERNAL_PAYEE_REC_TYPE;
7835:
7836: -- Bug#7506443 start
7837: l_tax_classification_code ZX_PARTY_TAX_PROFILE.TAX_CLASSIFICATION_CODE%TYPE;
7838: l_pymt_method_code iby_external_payees_all.default_payment_method_code%TYPE;
7839: l_inactive_date iby_external_payees_all.Inactive_Date%TYPE;
7840: l_Exclusive_Pay_Flag IBY_EXTERNAL_PAYEES_ALL.exclusive_payment_flag%TYPE;
7841: -- Debug Bug 8769088 start

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

7868: l_party_site_num VARCHAR2(1); -- Bug 6823885
7869: l_addr_val_status VARCHAR2(255); -- bug9128869
7870: l_addr_warn_msg VARCHAR2(2000); -- bug9128869
7871:
7872: L_PARTY_TAX_PROFILE_ID zx_party_tax_profile.party_tax_profile_id%type; -- Bug 7207314
7873: l_return_status VARCHAR2(2000); --Bug 7207314
7874: -- changes for Bug#7506443 start
7875: /* Bug 12582862 Cursors separated for retrieving external payee details and payment method */
7876: Cursor get_iby_dtls_csr(p_prty_id NUMBER) is

Line 7922: L_Zic_tax_classification_code ZX_PARTY_TAX_PROFILE.TAX_CLASSIFICATION_CODE%TYPE;

7918: L_INCLUSIVE_TAX_FLAG VARCHAR2(1) ; /* B 9530837 */
7919: /* Bug11664523 start */
7920: Zic_end_date_Active Date;
7921: Zic_start_date_active Date;
7922: L_Zic_tax_classification_code ZX_PARTY_TAX_PROFILE.TAX_CLASSIFICATION_CODE%TYPE;
7923: VAT_CODE_EXCEPTION EXCEPTION;
7924: /* Bug11664523 end */
7925:
7926: l_employee_id ap_suppliers.employee_id%type; --bug 12835899

Line 8727: FROM ZX_PARTY_TAX_PROFILE

8723: ,ROUNDING_LEVEL_CODE ,ROUNDING_RULE_CODE ,INCLUSIVE_TAX_FLAG /* B 9530837 */
8724: INTO l_auto_tax_calc_flag,l_offset_tax_flag,
8725: l_tax_classification_code -- Bug#7506443
8726: ,L_ROUNDING_LEVEL_CODE ,L_ROUNDING_RULE_CODE ,L_INCLUSIVE_TAX_FLAG /* B 9530837 */
8727: FROM ZX_PARTY_TAX_PROFILE
8728: WHERE PARTY_ID = l_party_id
8729: AND PARTY_TYPE_CODE = 'THIRD_PARTY'
8730: AND ROWNUM = 1;
8731: EXCEPTION

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

8729: AND PARTY_TYPE_CODE = 'THIRD_PARTY'
8730: AND ROWNUM = 1;
8731: EXCEPTION
8732: WHEN OTHERS THEN
8733: l_debug_info := 'No data returned from ZX_PARTY_TAX_PROFILE for party_id = '||l_party_id;
8734: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8735: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
8736: END IF;
8737: END;

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

8813: /* end B 9530837 */
8814:
8815:
8816:
8817: -- Start Bug 7207314. Update Tax Registration Number in ZX_PARTY_TAX_PROFILE
8818: -- VAT Registration Number is not stored at site level or HZ Party Site.
8819: -- This info is maintained by ZX Party Profile as 3rd party site tax profile.
8820:
8821: IF (l_vendor_site_rec.vat_registration_num is not null

Line 8835: FROM ZX_PARTY_TAX_PROFILE

8831: FND_API.G_RET_STS_SUCCESS)) ) THEN
8832:
8833: BEGIN
8834: SELECT PARTY_TAX_PROFILE_ID INTO L_PARTY_TAX_PROFILE_ID
8835: FROM ZX_PARTY_TAX_PROFILE
8836: WHERE PARTY_ID = l_party_site_id
8837: AND PARTY_TYPE_CODE = 'THIRD_PARTY_SITE'
8838: AND ROWNUM = 1;
8839: EXCEPTION

Line 8845: ZX_PARTY_TAX_PROFILE_PKG.update_row (

8841: L_PARTY_TAX_PROFILE_ID := NULL;
8842: END;
8843:
8844: IF L_PARTY_TAX_PROFILE_ID IS NOT NULL THEN
8845: ZX_PARTY_TAX_PROFILE_PKG.update_row (
8846: P_PARTY_TAX_PROFILE_ID => L_PARTY_TAX_PROFILE_ID,
8847: P_COLLECTING_AUTHORITY_FLAG => null,
8848: P_PROVIDER_TYPE_CODE => null,
8849: P_CREATE_AWT_DISTS_TYPE_CODE => null,

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

8894: P_REGISTRATION_TYPE_CODE => null,
8895: P_COUNTRY_CODE => null
8896: );
8897: IF l_return_status <> fnd_api.g_ret_sts_success THEN
8898: l_debug_info := 'ZX_PARTY_TAX_PROFILE_PKG.update_row';
8899: l_debug_info := l_debug_info||' Return status : '||l_return_status;
8900: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
8901: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
8902: END IF;