APPS.ZX_PARTY_TAX_PROFILE_PKG dependencies on ZX_PARTY_TAX_PROFILE_S

Line 58: select ZX_PARTY_TAX_PROFILE_S.nextval into L_PARTY_TAX_PROFILE_ID from dual;

54: WHERE PARTY_TAX_PROFILE_ID = L_PARTY_TAX_PROFILE_ID;
55: begin
56: --Initialise x_return_status variable
57: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
58: select ZX_PARTY_TAX_PROFILE_S.nextval into L_PARTY_TAX_PROFILE_ID from dual;
59: --Perform validations before inserting data
60: --AllowOffsetTax and SetforSelfAssessment flag would be mutually exclusive
61: BEGIN
62: -- Check created module name

Line 260: select ZX_PARTY_TAX_PROFILE_S.nextval into L_PARTY_TAX_PROFILE_ID from dual;

256: WHERE PARTY_TAX_PROFILE_ID = L_PARTY_TAX_PROFILE_ID;
257: begin
258: --Initialise x_return_status variable
259: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
260: select ZX_PARTY_TAX_PROFILE_S.nextval into L_PARTY_TAX_PROFILE_ID from dual;
261: BEGIN
262: -- Check created module name
263: select nvl(substr(created_by_module,1,3),'ZX') created_by_module
264: into L_CREATED_BY_MODULE

Line 475: update ZX_PARTY_TAX_PROFILE set

471: L_EFFECTIVE_FROM_USE_LE := NULL;
472: END IF;
473: --Update only when there is no error
474: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
475: update ZX_PARTY_TAX_PROFILE set
476: COLLECTING_AUTHORITY_FLAG = DECODE( P_COLLECTING_AUTHORITY_FLAG, NULL, COLLECTING_AUTHORITY_FLAG, P_COLLECTING_AUTHORITY_FLAG ),
477: PROVIDER_TYPE_CODE = DECODE( P_PROVIDER_TYPE_CODE, NULL, PROVIDER_TYPE_CODE, P_PROVIDER_TYPE_CODE ),
478: CREATE_AWT_DISTS_TYPE_CODE = DECODE( P_CREATE_AWT_DISTS_TYPE_CODE, NULL, CREATE_AWT_DISTS_TYPE_CODE, P_CREATE_AWT_DISTS_TYPE_CODE ),
479: CREATE_AWT_INVOICES_TYPE_CODE = DECODE( P_CREATE_AWT_INVOICES_TYPE_COD, NULL, CREATE_AWT_INVOICES_TYPE_CODE, P_CREATE_AWT_INVOICES_TYPE_COD ),

Line 599: update ZX_PARTY_TAX_PROFILE set

595: L_EFFECTIVE_FROM_USE_LE := NULL;
596: END IF;
597: --Update only when there is no error
598: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
599: update ZX_PARTY_TAX_PROFILE set
600: COLLECTING_AUTHORITY_FLAG = DECODE( P_COLLECTING_AUTHORITY_FLAG, NULL, COLLECTING_AUTHORITY_FLAG, P_COLLECTING_AUTHORITY_FLAG ),
601: PROVIDER_TYPE_CODE = DECODE( P_PROVIDER_TYPE_CODE, NULL, PROVIDER_TYPE_CODE, P_PROVIDER_TYPE_CODE ),
602: CREATE_AWT_DISTS_TYPE_CODE = DECODE( P_CREATE_AWT_DISTS_TYPE_CODE, NULL, CREATE_AWT_DISTS_TYPE_CODE, P_CREATE_AWT_DISTS_TYPE_CODE ),
603: CREATE_AWT_INVOICES_TYPE_CODE = DECODE( P_CREATE_AWT_INVOICES_TYPE_COD, NULL, CREATE_AWT_INVOICES_TYPE_CODE, P_CREATE_AWT_INVOICES_TYPE_COD ),