APPS.ZX_RECOVERY_TYPES_PKG dependencies on ZX_RECOVERY_TYPES_B

Line 37: cursor C is select ROWID from ZX_RECOVERY_TYPES_B

33: X_LAST_UPDATE_DATE in DATE,
34: X_LAST_UPDATED_BY in NUMBER,
35: X_LAST_UPDATE_LOGIN in NUMBER
36: ) is
37: cursor C is select ROWID from ZX_RECOVERY_TYPES_B
38: where RECOVERY_TYPE_ID = X_RECOVERY_TYPE_ID
39: ;
40: begin
41: insert into ZX_RECOVERY_TYPES_B (

Line 41: insert into ZX_RECOVERY_TYPES_B (

37: cursor C is select ROWID from ZX_RECOVERY_TYPES_B
38: where RECOVERY_TYPE_ID = X_RECOVERY_TYPE_ID
39: ;
40: begin
41: insert into ZX_RECOVERY_TYPES_B (
42: RECOVERY_TYPE_ID,
43: RECOVERY_TYPE_CODE,
44: TAX_REGIME_CODE,
45: TAX,

Line 191: from ZX_RECOVERY_TYPES_B

187: ATTRIBUTE12,
188: ATTRIBUTE13,
189: ATTRIBUTE14,
190: ATTRIBUTE15
191: from ZX_RECOVERY_TYPES_B
192: where RECOVERY_TYPE_ID = X_RECOVERY_TYPE_ID
193: for update of RECOVERY_TYPE_ID nowait;
194: recinfo c%rowtype;
195: cursor c1 is select

Line 308: update ZX_RECOVERY_TYPES_B set

304: X_LAST_UPDATED_BY in NUMBER,
305: X_LAST_UPDATE_LOGIN in NUMBER
306: ) is
307: begin
308: update ZX_RECOVERY_TYPES_B set
309: RECOVERY_TYPE_CODE = X_RECOVERY_TYPE_CODE,
310: TAX_REGIME_CODE = X_TAX_REGIME_CODE,
311: TAX = X_TAX,
312: Enabled_Flag = X_Enabled_Flag,

Line 361: delete from ZX_RECOVERY_TYPES_B

357: where RECOVERY_TYPE_ID = X_RECOVERY_TYPE_ID;
358: if (sql%notfound) then
359: raise no_data_found;
360: end if;
361: delete from ZX_RECOVERY_TYPES_B
362: where RECOVERY_TYPE_ID = X_RECOVERY_TYPE_ID;
363: if (sql%notfound) then
364: raise no_data_found;
365: end if;

Line 373: from ZX_RECOVERY_TYPES_B B

369: begin
370: delete from ZX_RECOVERY_TYPES_TL T
371: where not exists
372: (select NULL
373: from ZX_RECOVERY_TYPES_B B
374: where B.RECOVERY_TYPE_ID = T.RECOVERY_TYPE_ID
375: );
376: update ZX_RECOVERY_TYPES_TL T set (
377: RECOVERY_TYPE_NAME,