DBA Data[Home] [Help]

APPS.ZX_REGISTRATIONS_PKG dependencies on ZX_REGIMES_B

Line 61: L_COUNTRY_CODE ZX_REGIMES_B.COUNTRY_CODE%TYPE;

57: L_REG_ID1 ZX_REGISTRATIONS.REGISTRATION_ID%TYPE;
58: L_INCLUSIVE_TAX_FLAG ZX_REGISTRATIONS.INCLUSIVE_TAX_FLAG%TYPE;
59: L_SELF_ASSESS_FLAG ZX_REGISTRATIONS.SELF_ASSESS_FLAG%TYPE;
60: L_ROUNDING_RULE_CODE ZX_REGISTRATIONS.ROUNDING_RULE_CODE%TYPE;
61: L_COUNTRY_CODE ZX_REGIMES_B.COUNTRY_CODE%TYPE;
62: L_PARTY_TYPE_CODE ZX_PARTY_TAX_PROFILE.PARTY_TYPE_CODE%TYPE;
63: x_party_type_token VARCHAR2(1000);
64: x_party_name_token VARCHAR2(5000);
65: x_party_site_name_token VARCHAR2(5000);

Line 166: FROM ZX_REGIMES_B

162: BEGIN
163: BEGIN
164: SELECT COUNTRY_CODE
165: INTO L_COUNTRY_CODE
166: FROM ZX_REGIMES_B
167: WHERE TAX_REGIME_CODE = P_TAX_REGIME_CODE;
168: EXCEPTION WHEN NO_DATA_FOUND THEN
169: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
170: arp_util_tax.debug('Error: "No CountryCOde exists in ZX_REGIMES_B for the Registration with Regime : "

Line 170: arp_util_tax.debug('Error: "No CountryCOde exists in ZX_REGIMES_B for the Registration with Regime : "

166: FROM ZX_REGIMES_B
167: WHERE TAX_REGIME_CODE = P_TAX_REGIME_CODE;
168: EXCEPTION WHEN NO_DATA_FOUND THEN
169: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
170: arp_util_tax.debug('Error: "No CountryCOde exists in ZX_REGIMES_B for the Registration with Regime : "
171: ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
172: END;
173: /*
174: ZX_TRN_VALIDATION_PKG.VALIDATE_TRN