APPS.ZX_REPORTING_TYPES_PKG dependencies on ZX_REPORTING_TYPES_TL

Line 80: insert into ZX_REPORTING_TYPES_TL (

76: X_HAS_REPORTING_CODES_FLAG,
77: X_OBJECT_VERSION_NUMBER
78: );
79:
80: insert into ZX_REPORTING_TYPES_TL (
81: REPORTING_TYPE_ID,
82: REPORTING_TYPE_NAME,
83: CREATED_BY,
84: CREATION_DATE,

Line 104: from ZX_REPORTING_TYPES_TL T

100: from FND_LANGUAGES L
101: where L.INSTALLED_FLAG in ('I', 'B')
102: and not exists
103: (select NULL
104: from ZX_REPORTING_TYPES_TL T
105: where T.REPORTING_TYPE_ID = X_REPORTING_TYPE_ID
106: and T.LANGUAGE = L.LANGUAGE_CODE);
107:
108: open c;

Line 162: from ZX_REPORTING_TYPES_TL

158:
159: cursor c1 is select
160: REPORTING_TYPE_NAME,
161: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
162: from ZX_REPORTING_TYPES_TL
163: where REPORTING_TYPE_ID = X_REPORTING_TYPE_ID
164: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
165: for update of REPORTING_TYPE_ID nowait;
166: begin

Line 272: update ZX_REPORTING_TYPES_TL set

268: if (sql%notfound) then
269: raise no_data_found;
270: end if;
271:
272: update ZX_REPORTING_TYPES_TL set
273: REPORTING_TYPE_NAME = X_REPORTING_TYPE_NAME,
274: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
275: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
276: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 290: delete from ZX_REPORTING_TYPES_TL

286: procedure DELETE_ROW (
287: X_REPORTING_TYPE_ID in NUMBER
288: ) is
289: begin
290: delete from ZX_REPORTING_TYPES_TL
291: where REPORTING_TYPE_ID = X_REPORTING_TYPE_ID;
292:
293: if (sql%notfound) then
294: raise no_data_found;

Line 308: delete from ZX_REPORTING_TYPES_TL T

304:
305: procedure ADD_LANGUAGE
306: is
307: begin
308: delete from ZX_REPORTING_TYPES_TL T
309: where not exists
310: (select NULL
311: from ZX_REPORTING_TYPES_B B
312: where B.REPORTING_TYPE_ID = T.REPORTING_TYPE_ID

Line 315: update ZX_REPORTING_TYPES_TL T set (

311: from ZX_REPORTING_TYPES_B B
312: where B.REPORTING_TYPE_ID = T.REPORTING_TYPE_ID
313: );
314:
315: update ZX_REPORTING_TYPES_TL T set (
316: REPORTING_TYPE_NAME
317: ) = (select
318: B.REPORTING_TYPE_NAME
319: from ZX_REPORTING_TYPES_TL B

Line 319: from ZX_REPORTING_TYPES_TL B

315: update ZX_REPORTING_TYPES_TL T set (
316: REPORTING_TYPE_NAME
317: ) = (select
318: B.REPORTING_TYPE_NAME
319: from ZX_REPORTING_TYPES_TL B
320: where B.REPORTING_TYPE_ID = T.REPORTING_TYPE_ID
321: and B.LANGUAGE = T.SOURCE_LANG)
322: where (
323: T.REPORTING_TYPE_ID,

Line 328: from ZX_REPORTING_TYPES_TL SUBB, ZX_REPORTING_TYPES_TL SUBT

324: T.LANGUAGE
325: ) in (select
326: SUBT.REPORTING_TYPE_ID,
327: SUBT.LANGUAGE
328: from ZX_REPORTING_TYPES_TL SUBB, ZX_REPORTING_TYPES_TL SUBT
329: where SUBB.REPORTING_TYPE_ID = SUBT.REPORTING_TYPE_ID
330: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
331: and (SUBB.REPORTING_TYPE_NAME <> SUBT.REPORTING_TYPE_NAME
332: or (SUBB.REPORTING_TYPE_NAME is null and SUBT.REPORTING_TYPE_NAME is not null)

Line 336: insert into ZX_REPORTING_TYPES_TL (

332: or (SUBB.REPORTING_TYPE_NAME is null and SUBT.REPORTING_TYPE_NAME is not null)
333: or (SUBB.REPORTING_TYPE_NAME is not null and SUBT.REPORTING_TYPE_NAME is null)
334: ));
335:
336: insert into ZX_REPORTING_TYPES_TL (
337: REPORTING_TYPE_ID,
338: REPORTING_TYPE_NAME,
339: CREATED_BY,
340: CREATION_DATE,

Line 356: from ZX_REPORTING_TYPES_TL B, FND_LANGUAGES L

352: B.LAST_UPDATE_DATE,
353: B.LAST_UPDATE_LOGIN,
354: L.LANGUAGE_CODE,
355: B.SOURCE_LANG
356: from ZX_REPORTING_TYPES_TL B, FND_LANGUAGES L
357: where L.INSTALLED_FLAG in ('I', 'B')
358: and B.LANGUAGE = userenv('LANG')
359: and not exists
360: (select NULL

Line 361: from ZX_REPORTING_TYPES_TL T

357: where L.INSTALLED_FLAG in ('I', 'B')
358: and B.LANGUAGE = userenv('LANG')
359: and not exists
360: (select NULL
361: from ZX_REPORTING_TYPES_TL T
362: where T.REPORTING_TYPE_ID = B.REPORTING_TYPE_ID
363: and T.LANGUAGE = L.LANGUAGE_CODE);
364: end ADD_LANGUAGE;
365: