APPS.ZX_REGIMES_PKG dependencies on ZX_REGIMES_B

Line 85: cursor C is select ROWID from ZX_REGIMES_B

81: X_TAX_ACCOUNT_PRECEDENCE_CODE in VARCHAR2,
82: X_OBJECT_VERSION_NUMBER in NUMBER
83: ) is
84:
85: cursor C is select ROWID from ZX_REGIMES_B
86: where TAX_REGIME_ID = X_TAX_REGIME_ID ;
87:
88: err_stat VARCHAR2(30);
89:

Line 94: insert into ZX_REGIMES_B (

90: begin
91:
92: err_stat := FND_API.G_RET_STS_SUCCESS;
93:
94: insert into ZX_REGIMES_B (
95: PARENT_REGIME_CODE,
96: TAX_REGIME_ID,
97: TAX_REGIME_CODE,
98: Has_Sub_Regime_Flag,

Line 440: from ZX_REGIMES_B

436: REGIME_PRECEDENCE,
437: Cross_Regime_Compounding_Flag,
438: TAX_ACCOUNT_PRECEDENCE_CODE,
439: OBJECT_VERSION_NUMBER
440: from ZX_REGIMES_B
441: where TAX_REGIME_ID = X_TAX_REGIME_ID
442: for update of TAX_REGIME_ID nowait;
443: recinfo c%rowtype;
444: cursor c1 is select

Line 716: update ZX_REGIMES_B set

712:
713: OPEN C1;
714: FETCH C1 INTO R1;
715: CLOSE C1;
716: update ZX_REGIMES_B set
717: PARENT_REGIME_CODE = X_PARENT_REGIME_CODE,
718: TAX_REGIME_CODE = X_TAX_REGIME_CODE,
719: Has_Sub_Regime_Flag = X_Has_Sub_Regime_Flag,
720: Country_Or_Group_Code = X_Country_Or_Group_Code,

Line 832: delete from ZX_REGIMES_B

828: where TAX_REGIME_ID = X_TAX_REGIME_ID;
829: if (sql%notfound) then
830: raise no_data_found;
831: end if;
832: delete from ZX_REGIMES_B
833: where TAX_REGIME_ID = X_TAX_REGIME_ID;
834: if (sql%notfound) then
835: raise no_data_found;
836: end if;

Line 845: from ZX_REGIMES_B B

841: begin
842: delete from ZX_REGIMES_TL T
843: where not exists
844: (select NULL
845: from ZX_REGIMES_B B
846: where B.TAX_REGIME_ID = T.TAX_REGIME_ID
847: );
848: update ZX_REGIMES_TL T set (
849: TAX_REGIME_NAME