APPS.ZX_REGISTRATIONS_PKG dependencies on ZX_REGISTRATIONS_S

Line 59: L_SELF_ASSESS_FLAG ZX_REGISTRATIONS.SELF_ASSESS_FLAG%TYPE;

55: L_DEF_REGISTRATION_ID ZX_REGISTRATIONS.REGISTRATION_ID%TYPE;
56: L_REG_ID ZX_REGISTRATIONS.REGISTRATION_ID%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);

Line 218: select ZX_REGISTRATIONS_S.nextval into L_REGISTRATION_ID from dual;

214: CLOSE default_reg_cur;
215: END IF;--end P_DEFAULT_REGISTRATION_FLAG
216: --Insert only when there is no error
217: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
218: select ZX_REGISTRATIONS_S.nextval into L_REGISTRATION_ID from dual;
219: insert into ZX_REGISTRATIONS (
220: REQUEST_ID,
221: ATTRIBUTE1,
222: ATTRIBUTE2,

Line 528: update ZX_REGISTRATIONS set

524: CLOSE default_reg_cur;
525: END IF;--end P_DEFAULT_REGISTRATION_FLAG
526: --Update only when there is no error
527: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
528: update ZX_REGISTRATIONS set
529: REQUEST_ID = DECODE( P_REQUEST_ID, NULL, REQUEST_ID, P_REQUEST_ID ),
530: ATTRIBUTE1 = DECODE( P_ATTRIBUTE1, NULL, ATTRIBUTE1, P_ATTRIBUTE1 ),
531: ATTRIBUTE2 = DECODE( P_ATTRIBUTE2, NULL, ATTRIBUTE2, P_ATTRIBUTE2 ),
532: ATTRIBUTE3 = DECODE( P_ATTRIBUTE3, NULL, ATTRIBUTE3, P_ATTRIBUTE3 ),