APPS.ZX_RECOVERY_TYPES_PKG dependencies on ZX_RECOVERY_TYPES_TL

Line 102: insert into ZX_RECOVERY_TYPES_TL (

98: X_LAST_UPDATE_DATE,
99: X_LAST_UPDATED_BY,
100: X_LAST_UPDATE_LOGIN
101: );
102: insert into ZX_RECOVERY_TYPES_TL (
103: RECOVERY_TYPE_ID,
104: RECOVERY_TYPE_NAME,
105: RECOVERY_TYPE_DESC,
106: CREATION_DATE,

Line 128: from ZX_RECOVERY_TYPES_TL T

124: from FND_LANGUAGES L
125: where L.INSTALLED_FLAG in ('I', 'B')
126: and not exists
127: (select NULL
128: from ZX_RECOVERY_TYPES_TL T
129: where T.RECOVERY_TYPE_ID = X_RECOVERY_TYPE_ID
130: and T.LANGUAGE = L.LANGUAGE_CODE);
131: open c;
132: fetch c into X_ROWID;

Line 199: from ZX_RECOVERY_TYPES_TL

195: cursor c1 is select
196: RECOVERY_TYPE_NAME,
197: RECOVERY_TYPE_DESC,
198: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
199: from ZX_RECOVERY_TYPES_TL
200: where RECOVERY_TYPE_ID = X_RECOVERY_TYPE_ID
201: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
202: for update of RECOVERY_TYPE_ID nowait;
203: begin

Line 339: update ZX_RECOVERY_TYPES_TL set

335: where RECOVERY_TYPE_ID = X_RECOVERY_TYPE_ID;
336: if (sql%notfound) then
337: raise no_data_found;
338: end if;
339: update ZX_RECOVERY_TYPES_TL set
340: RECOVERY_TYPE_NAME = X_RECOVERY_TYPE_NAME,
341: RECOVERY_TYPE_DESC = X_RECOVERY_TYPE_DESC,
342: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
343: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 356: delete from ZX_RECOVERY_TYPES_TL

352: procedure DELETE_ROW (
353: X_RECOVERY_TYPE_ID in NUMBER
354: ) is
355: begin
356: delete from ZX_RECOVERY_TYPES_TL
357: where RECOVERY_TYPE_ID = X_RECOVERY_TYPE_ID;
358: if (sql%notfound) then
359: raise no_data_found;
360: end if;

Line 370: delete from ZX_RECOVERY_TYPES_TL T

366: end DELETE_ROW;
367: procedure ADD_LANGUAGE
368: is
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

Line 376: update ZX_RECOVERY_TYPES_TL T set (

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,
378: RECOVERY_TYPE_DESC
379: ) = (select
380: B.RECOVERY_TYPE_NAME,

Line 382: from ZX_RECOVERY_TYPES_TL B

378: RECOVERY_TYPE_DESC
379: ) = (select
380: B.RECOVERY_TYPE_NAME,
381: B.RECOVERY_TYPE_DESC
382: from ZX_RECOVERY_TYPES_TL B
383: where B.RECOVERY_TYPE_ID = T.RECOVERY_TYPE_ID
384: and B.LANGUAGE = T.SOURCE_LANG)
385: where (
386: T.RECOVERY_TYPE_ID,

Line 391: from ZX_RECOVERY_TYPES_TL SUBB, ZX_RECOVERY_TYPES_TL SUBT

387: T.LANGUAGE
388: ) in (select
389: SUBT.RECOVERY_TYPE_ID,
390: SUBT.LANGUAGE
391: from ZX_RECOVERY_TYPES_TL SUBB, ZX_RECOVERY_TYPES_TL SUBT
392: where SUBB.RECOVERY_TYPE_ID = SUBT.RECOVERY_TYPE_ID
393: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
394: and (SUBB.RECOVERY_TYPE_NAME <> SUBT.RECOVERY_TYPE_NAME
395: or SUBB.RECOVERY_TYPE_DESC <> SUBT.RECOVERY_TYPE_DESC

Line 399: insert into ZX_RECOVERY_TYPES_TL (

395: or SUBB.RECOVERY_TYPE_DESC <> SUBT.RECOVERY_TYPE_DESC
396: or (SUBB.RECOVERY_TYPE_DESC is null and SUBT.RECOVERY_TYPE_DESC is not null)
397: or (SUBB.RECOVERY_TYPE_DESC is not null and SUBT.RECOVERY_TYPE_DESC is null)
398: ));
399: insert into ZX_RECOVERY_TYPES_TL (
400: RECOVERY_TYPE_ID,
401: RECOVERY_TYPE_NAME,
402: RECOVERY_TYPE_DESC,
403: CREATION_DATE,

Line 421: from ZX_RECOVERY_TYPES_TL B, FND_LANGUAGES L

417: B.LAST_UPDATED_BY,
418: B.LAST_UPDATE_LOGIN,
419: L.LANGUAGE_CODE,
420: B.SOURCE_LANG
421: from ZX_RECOVERY_TYPES_TL B, FND_LANGUAGES L
422: where L.INSTALLED_FLAG in ('I', 'B')
423: and B.LANGUAGE = userenv('LANG')
424: and not exists
425: (select NULL

Line 426: from ZX_RECOVERY_TYPES_TL T

422: where L.INSTALLED_FLAG in ('I', 'B')
423: and B.LANGUAGE = userenv('LANG')
424: and not exists
425: (select NULL
426: from ZX_RECOVERY_TYPES_TL T
427: where T.RECOVERY_TYPE_ID = B.RECOVERY_TYPE_ID
428: and T.LANGUAGE = L.LANGUAGE_CODE);
429: end ADD_LANGUAGE;
430: end ZX_RECOVERY_TYPES_PKG;