DBA Data[Home] [Help]

APPS.ZX_REGIMES_PKG dependencies on ZX_REG_REL_PUB

Line 285: zx_reg_rel_pub.insert_rel(err_stat,X_TAX_REGIME_CODE,X_PARENT_REGIME_CODE,

281: end if;
282: close c;
283: -- Insert into zx_regime_relations table
284: if (X_PARENT_REGIME_CODE IS NOT NULL) then
285: zx_reg_rel_pub.insert_rel(err_stat,X_TAX_REGIME_CODE,X_PARENT_REGIME_CODE,
286: X_CREATED_BY, X_CREATION_DATE, X_LAST_UPDATED_BY, X_LAST_UPDATE_DATE,
287: X_LAST_UPDATE_LOGIN, X_REQUEST_ID, X_PROGRAM_ID,
288: X_PROGRAM_LOGIN_ID, X_PROGRAM_APPLICATION_ID);
289: end if;

Line 806: zx_reg_rel_pub.update_rel(err_stat,X_TAX_REGIME_CODE,X_PARENT_REGIME_CODE,

802: if (sql%notfound) then
803: raise no_data_found;
804: end if;
805: -- Update zx_regime_relations table
806: zx_reg_rel_pub.update_rel(err_stat,X_TAX_REGIME_CODE,X_PARENT_REGIME_CODE,
807: X_LAST_UPDATED_BY, X_LAST_UPDATE_DATE,
808: X_LAST_UPDATE_LOGIN, X_REQUEST_ID, X_PROGRAM_ID,
809: X_PROGRAM_LOGIN_ID, X_PROGRAM_APPLICATION_ID);
810:

Line 818: zx_reg_rel_pub.update_taxes(err_stat,X_TAX_REGIME_CODE,R1.REP_TAX_AUTHORITY_ID,

814: --Update zx_taxes_vl table if the rep_tax_auth_id or coll_tax_auth_id has been updated
815: -- Check if update of reporting tax authority id or collecting tax authority has occurred..
816: if(nvl(X_REP_TAX_AUTHORITY_ID,-9999) <> nvl(R1.REP_TAX_AUTHORITY_ID,-9999)) OR
817: (nvl(X_COLL_TAX_AUTHORITY_ID,-9999) <> nvl(R1.COLL_TAX_AUTHORITY_ID,-9999)) THEN
818: zx_reg_rel_pub.update_taxes(err_stat,X_TAX_REGIME_CODE,R1.REP_TAX_AUTHORITY_ID,
819: R1.COLL_TAX_AUTHORITY_ID,X_REP_TAX_AUTHORITY_ID,X_COLL_TAX_AUTHORITY_ID);
820: END IF;
821: end UPDATE_ROW;
822: