APPS.ZX_REGISTRATIONS_PKG dependencies on ZX_PARTY_TAX_PROFILE

Line 62: L_PARTY_TYPE_CODE ZX_PARTY_TAX_PROFILE.PARTY_TYPE_CODE%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);
66: x_error_buffer VARCHAR2(80);

Line 81: from ZX_PARTY_TAX_PROFILE

77: --Inclusive_tax_flag, ROUNDING_RULE_CODE and self_assess_flag for tax registrations are defaulted primary from party tax profile.
78: BEGIN
79: select INCLUSIVE_TAX_FLAG, SELF_ASSESS_FLAG, ROUNDING_RULE_CODE, PARTY_TYPE_CODE
80: INTO L_INCLUSIVE_TAX_FLAG, L_SELF_ASSESS_FLAG, L_ROUNDING_RULE_CODE, L_PARTY_TYPE_CODE
81: from ZX_PARTY_TAX_PROFILE
82: where PARTY_TAX_PROFILE_ID = P_PARTY_TAX_PROFILE_ID;
83: EXCEPTION WHEN NO_DATA_FOUND THEN
84: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
85: arp_util_tax.debug('Error: "No Party created in ZX_PARTY_TAX_PROFILE for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

Line 85: arp_util_tax.debug('Error: "No Party created in ZX_PARTY_TAX_PROFILE for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);

81: from ZX_PARTY_TAX_PROFILE
82: where PARTY_TAX_PROFILE_ID = P_PARTY_TAX_PROFILE_ID;
83: EXCEPTION WHEN NO_DATA_FOUND THEN
84: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
85: arp_util_tax.debug('Error: "No Party created in ZX_PARTY_TAX_PROFILE for the Registration with Regime : " ' || P_TAX_REGIME_CODE || ' and Tax: ' ||P_TAX || ' and Jurisdiction: ' || P_TAX_JURISDICTION_CODE);
86: END;
87: --Effective From cannot be null
88: IF P_EFFECTIVE_FROM IS NULL THEN
89: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 205: UPDATE ZX_PARTY_TAX_PROFILE

201: FETCH default_reg_cur INTO L_DEF_REGISTRATION_ID;
202: --If this is the only defaulted registration then update PTP
203: IF (default_reg_cur%notfound) AND (X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS) then
204: --Update PTP
205: UPDATE ZX_PARTY_TAX_PROFILE
206: SET Rep_Registration_Number = P_REGISTRATION_NUMBER,
207: Object_Version_Number = Object_Version_Number + 1
208: WHERE PARTY_TAX_PROFILE_ID = P_PARTY_TAX_PROFILE_ID
209: ;

Line 516: UPDATE ZX_PARTY_TAX_PROFILE SET Rep_Registration_Number = P_REGISTRATION_NUMBER,

512: FETCH default_reg_cur INTO L_DEF_REGISTRATION_ID;
513: --If this is the only defaulted registration then update PTP
514: IF (default_reg_cur%notfound) AND (X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS) then
515: --Update PTP
516: UPDATE ZX_PARTY_TAX_PROFILE SET Rep_Registration_Number = P_REGISTRATION_NUMBER,
517: Object_Version_Number = Object_Version_Number + 1
518: WHERE PARTY_TAX_PROFILE_ID = P_PARTY_TAX_PROFILE_ID;
519:
520: ELSE