DBA Data[Home] [Help]

APPS.ZX_PARTY_TAX_PROFILE_PKG dependencies on ZX_PARTY_TAX_PROFILE_S

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

161:
162: begin
163: --Initialise x_return_status variable
164: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
165: select ZX_PARTY_TAX_PROFILE_S.nextval into L_PARTY_TAX_PROFILE_ID from dual;
166:
167: -- commenting out for bug 10236399
168: -- BEGIN
169: -- Check created module name

Line 486: update ZX_PARTY_TAX_PROFILE set

482: L_EFFECTIVE_FROM_USE_LE := NULL;
483: END IF;
484: --Update only when there is no error
485: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
486: update ZX_PARTY_TAX_PROFILE set
487: COLLECTING_AUTHORITY_FLAG = DECODE( P_COLLECTING_AUTHORITY_FLAG, NULL, COLLECTING_AUTHORITY_FLAG, P_COLLECTING_AUTHORITY_FLAG ),
488: PROVIDER_TYPE_CODE = DECODE( P_PROVIDER_TYPE_CODE, NULL, PROVIDER_TYPE_CODE, P_PROVIDER_TYPE_CODE ),
489: CREATE_AWT_DISTS_TYPE_CODE = DECODE( P_CREATE_AWT_DISTS_TYPE_CODE, NULL, CREATE_AWT_DISTS_TYPE_CODE, P_CREATE_AWT_DISTS_TYPE_CODE ),
490: CREATE_AWT_INVOICES_TYPE_CODE = DECODE( P_CREATE_AWT_INVOICES_TYPE_COD, NULL, CREATE_AWT_INVOICES_TYPE_CODE, P_CREATE_AWT_INVOICES_TYPE_COD ),