APPS.FND_OAM_CHARTS_PKG dependencies on FND_OAM_CHARTS_TL

Line 147: from fnd_oam_charts_tl

143:
144: begin
145: select LAST_UPDATED_BY, LAST_UPDATE_DATE
146: into db_luby, db_ludate
147: from fnd_oam_charts_tl
148: where chart_id = to_number(X_CHART_ID)
149: and LANGUAGE = userenv('LANG');
150:
151: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 153: update fnd_oam_charts_tl set

149: and LANGUAGE = userenv('LANG');
150:
151: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
152: db_ludate, X_CUSTOM_MODE)) then
153: update fnd_oam_charts_tl set
154: chart_name = nvl(X_CHART_NAME, chart_name),
155: description = nvl(X_DESCRIPTION, description),
156: source_lang = userenv('LANG'),
157: last_update_date = f_ludate,

Line 219: insert into FND_OAM_CHARTS_TL (

215: X_LAST_UPDATED_BY,
216: X_LAST_UPDATE_LOGIN
217: );
218:
219: insert into FND_OAM_CHARTS_TL (
220: CHART_ID,
221: CHART_NAME,
222: DESCRIPTION,
223: CREATED_BY,

Line 245: from FND_OAM_CHARTS_TL T

241: from FND_LANGUAGES L
242: where L.INSTALLED_FLAG in ('I', 'B')
243: and not exists
244: (select NULL
245: from FND_OAM_CHARTS_TL T
246: where T.CHART_ID = X_CHART_ID
247: and T.LANGUAGE = L.LANGUAGE_CODE);
248:
249: open c;

Line 286: from FND_OAM_CHARTS_TL

282: cursor c1 is select
283: CHART_NAME,
284: DESCRIPTION,
285: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
286: from FND_OAM_CHARTS_TL
287: where CHART_ID = X_CHART_ID
288: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
289: for update of CHART_ID nowait;
290: begin

Line 358: update FND_OAM_CHARTS_TL set

354: if (sql%notfound) then
355: raise no_data_found;
356: end if;
357:
358: update FND_OAM_CHARTS_TL set
359: CHART_NAME = X_CHART_NAME,
360: DESCRIPTION = X_DESCRIPTION,
361: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
362: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 377: delete from FND_OAM_CHARTS_TL

373: procedure DELETE_ROW (
374: X_CHART_ID in NUMBER
375: ) is
376: begin
377: delete from FND_OAM_CHARTS_TL
378: where CHART_ID = X_CHART_ID;
379:
380: if (sql%notfound) then
381: raise no_data_found;

Line 400: delete from FND_OAM_CHARTS_TL T

396: /* The following update statements are commented out */
397: /* as a quick workaround to fix the time-consuming table handler issue */
398: /* Eventually we'll need to turn them into a separate fix_language procedure */
399: /*
400: delete from FND_OAM_CHARTS_TL T
401: where not exists
402: (select NULL
403: from FND_OAM_CHARTS B
404: where B.CHART_ID = T.CHART_ID

Line 407: update FND_OAM_CHARTS_TL T set (

403: from FND_OAM_CHARTS B
404: where B.CHART_ID = T.CHART_ID
405: );
406:
407: update FND_OAM_CHARTS_TL T set (
408: CHART_NAME,
409: DESCRIPTION
410: ) = (select
411: B.CHART_NAME,

Line 413: from FND_OAM_CHARTS_TL B

409: DESCRIPTION
410: ) = (select
411: B.CHART_NAME,
412: B.DESCRIPTION
413: from FND_OAM_CHARTS_TL B
414: where B.CHART_ID = T.CHART_ID
415: and B.LANGUAGE = T.SOURCE_LANG)
416: where (
417: T.CHART_ID,

Line 422: from FND_OAM_CHARTS_TL SUBB, FND_OAM_CHARTS_TL SUBT

418: T.LANGUAGE
419: ) in (select
420: SUBT.CHART_ID,
421: SUBT.LANGUAGE
422: from FND_OAM_CHARTS_TL SUBB, FND_OAM_CHARTS_TL SUBT
423: where SUBB.CHART_ID = SUBT.CHART_ID
424: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
425: and (SUBB.CHART_NAME <> SUBT.CHART_NAME
426: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 431: insert into FND_OAM_CHARTS_TL (

427: ));
428:
429: */
430:
431: insert into FND_OAM_CHARTS_TL (
432: CHART_ID,
433: CHART_NAME,
434: DESCRIPTION,
435: CREATED_BY,

Line 453: from FND_OAM_CHARTS_TL B, FND_LANGUAGES L

449: B.LAST_UPDATE_DATE,
450: B.LAST_UPDATE_LOGIN,
451: L.LANGUAGE_CODE,
452: B.SOURCE_LANG
453: from FND_OAM_CHARTS_TL B, FND_LANGUAGES L
454: where L.INSTALLED_FLAG in ('I', 'B')
455: and B.LANGUAGE = userenv('LANG')
456: and not exists
457: (select NULL

Line 458: from FND_OAM_CHARTS_TL T

454: where L.INSTALLED_FLAG in ('I', 'B')
455: and B.LANGUAGE = userenv('LANG')
456: and not exists
457: (select NULL
458: from FND_OAM_CHARTS_TL T
459: where T.CHART_ID = B.CHART_ID
460: and T.LANGUAGE = L.LANGUAGE_CODE);
461: end ADD_LANGUAGE;
462: