APPS.FND_OAM_CHART_GRPS_PKG dependencies on FND_OAM_CHART_GRPS_TL

Line 132: from fnd_oam_chart_grps_tl

128:
129: begin
130: select LAST_UPDATED_BY, LAST_UPDATE_DATE
131: into db_luby, db_ludate
132: from fnd_oam_chart_grps_tl
133: where chart_group_id = to_number(X_CHART_GROUP_ID)
134: and LANGUAGE = userenv('LANG');
135:
136: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 138: update fnd_oam_chart_grps_tl set

134: and LANGUAGE = userenv('LANG');
135:
136: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
137: db_ludate, X_CUSTOM_MODE)) then
138: update fnd_oam_chart_grps_tl set
139: chart_group_name = nvl(X_CHART_GROUP_NAME, chart_group_name),
140: description = nvl(X_DESCRIPTION, description),
141: source_lang = userenv('LANG'),
142: last_update_date = f_ludate,

Line 195: insert into FND_OAM_CHART_GRPS_TL (

191: X_LAST_UPDATED_BY,
192: X_LAST_UPDATE_LOGIN
193: );
194:
195: insert into FND_OAM_CHART_GRPS_TL (
196: CHART_GROUP_ID,
197: CHART_GROUP_NAME,
198: DESCRIPTION,
199: CREATED_BY,

Line 221: from FND_OAM_CHART_GRPS_TL T

217: from FND_LANGUAGES L
218: where L.INSTALLED_FLAG in ('I', 'B')
219: and not exists
220: (select NULL
221: from FND_OAM_CHART_GRPS_TL T
222: where T.CHART_GROUP_ID = X_CHART_GROUP_ID
223: and T.LANGUAGE = L.LANGUAGE_CODE);
224:
225: open c;

Line 256: from FND_OAM_CHART_GRPS_TL

252: cursor c1 is select
253: CHART_GROUP_NAME,
254: DESCRIPTION,
255: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
256: from FND_OAM_CHART_GRPS_TL
257: where CHART_GROUP_ID = X_CHART_GROUP_ID
258: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
259: for update of CHART_GROUP_ID nowait;
260: begin

Line 321: update FND_OAM_CHART_GRPS_TL set

317: if (sql%notfound) then
318: raise no_data_found;
319: end if;
320:
321: update FND_OAM_CHART_GRPS_TL set
322: CHART_GROUP_NAME = X_CHART_GROUP_NAME,
323: DESCRIPTION = X_DESCRIPTION,
324: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
325: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 340: delete from FND_OAM_CHART_GRPS_TL

336: procedure DELETE_ROW (
337: X_CHART_GROUP_ID in NUMBER
338: ) is
339: begin
340: delete from FND_OAM_CHART_GRPS_TL
341: where CHART_GROUP_ID = X_CHART_GROUP_ID;
342:
343: if (sql%notfound) then
344: raise no_data_found;

Line 364: delete from FND_OAM_CHART_GRPS_TL T

360: /* The following update statements are commented out */
361: /* as a quick workaround to fix the time-consuming table handler issue */
362: /* Eventually we'll need to turn them into a separate fix_language procedure */
363: /*
364: delete from FND_OAM_CHART_GRPS_TL T
365: where not exists
366: (select NULL
367: from FND_OAM_CHART_GRPS B
368: where B.CHART_GROUP_ID = T.CHART_GROUP_ID

Line 371: update FND_OAM_CHART_GRPS_TL T set (

367: from FND_OAM_CHART_GRPS B
368: where B.CHART_GROUP_ID = T.CHART_GROUP_ID
369: );
370:
371: update FND_OAM_CHART_GRPS_TL T set (
372: CHART_GROUP_NAME,
373: DESCRIPTION
374: ) = (select
375: B.CHART_GROUP_NAME,

Line 377: from FND_OAM_CHART_GRPS_TL B

373: DESCRIPTION
374: ) = (select
375: B.CHART_GROUP_NAME,
376: B.DESCRIPTION
377: from FND_OAM_CHART_GRPS_TL B
378: where B.CHART_GROUP_ID = T.CHART_GROUP_ID
379: and B.LANGUAGE = T.SOURCE_LANG)
380: where (
381: T.CHART_GROUP_ID,

Line 386: from FND_OAM_CHART_GRPS_TL SUBB, FND_OAM_CHART_GRPS_TL SUBT

382: T.LANGUAGE
383: ) in (select
384: SUBT.CHART_GROUP_ID,
385: SUBT.LANGUAGE
386: from FND_OAM_CHART_GRPS_TL SUBB, FND_OAM_CHART_GRPS_TL SUBT
387: where SUBB.CHART_GROUP_ID = SUBT.CHART_GROUP_ID
388: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
389: and (SUBB.CHART_GROUP_NAME <> SUBT.CHART_GROUP_NAME
390: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 395: insert into FND_OAM_CHART_GRPS_TL (

391: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
392: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
393: ));
394: */
395: insert into FND_OAM_CHART_GRPS_TL (
396: CHART_GROUP_ID,
397: CHART_GROUP_NAME,
398: DESCRIPTION,
399: CREATED_BY,

Line 417: from FND_OAM_CHART_GRPS_TL B, FND_LANGUAGES L

413: B.LAST_UPDATE_DATE,
414: B.LAST_UPDATE_LOGIN,
415: L.LANGUAGE_CODE,
416: B.SOURCE_LANG
417: from FND_OAM_CHART_GRPS_TL B, FND_LANGUAGES L
418: where L.INSTALLED_FLAG in ('I', 'B')
419: and B.LANGUAGE = userenv('LANG')
420: and not exists
421: (select NULL

Line 422: from FND_OAM_CHART_GRPS_TL T

418: where L.INSTALLED_FLAG in ('I', 'B')
419: and B.LANGUAGE = userenv('LANG')
420: and not exists
421: (select NULL
422: from FND_OAM_CHART_GRPS_TL T
423: where T.CHART_GROUP_ID = B.CHART_GROUP_ID
424: and T.LANGUAGE = L.LANGUAGE_CODE);
425: end ADD_LANGUAGE;
426: