APPS.FND_OAM_METVAL_PKG dependencies on FND_OAM_METS_TL

Line 34: update FND_OAM_METS_TL set

30: if (sql%notfound) then
31: raise no_data_found;
32: end if;
33:
34: update FND_OAM_METS_TL set
35: METRIC_DISPLAY_NAME = X_METRIC_DISPLAY_NAME,
36: DESCRIPTION = X_DESCRIPTION,
37: SOURCE_LANG = userenv('LANG')
38: where METRIC_SHORT_NAME = X_METRIC_SHORT_NAME

Line 284: from fnd_oam_mets_tl

280: begin
281:
282: select LAST_UPDATED_BY, LAST_UPDATE_DATE
283: into db_luby, db_ludate
284: from fnd_oam_mets_tl
285: where metric_short_name = X_METRIC_SHORT_NAME
286: and LANGUAGE = userenv('LANG');
287:
288: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 290: update fnd_oam_mets_tl set

286: and LANGUAGE = userenv('LANG');
287:
288: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
289: db_ludate, X_CUSTOM_MODE)) then
290: update fnd_oam_mets_tl set
291: metric_display_name = nvl(X_METRIC_DISPLAY_NAME, metric_display_name),
292: description = nvl(X_DESCRIPTION, description),
293: source_lang = userenv('LANG'),
294: last_update_date = f_ludate,

Line 380: insert into FND_OAM_METS_TL (

376: X_LAST_UPDATED_BY,
377: X_LAST_UPDATE_DATE,
378: X_LAST_UPDATE_LOGIN);
379:
380: insert into FND_OAM_METS_TL (
381: METRIC_SHORT_NAME,
382: METRIC_DISPLAY_NAME,
383: DESCRIPTION,
384: CREATED_BY,

Line 406: from FND_OAM_METS_TL T

402: from FND_LANGUAGES L
403: where L.INSTALLED_FLAG in ('I', 'B')
404: and not exists
405: (select NULL
406: from FND_OAM_METS_TL T
407: where T.METRIC_SHORT_NAME = X_METRIC_SHORT_NAME
408: and T.LANGUAGE = L.LANGUAGE_CODE);
409:
410: open c;

Line 467: update FND_OAM_METS_TL set

463: if (sql%notfound) then
464: raise no_data_found;
465: end if;
466:
467: update FND_OAM_METS_TL set
468: METRIC_DISPLAY_NAME = X_METRIC_DISPLAY_NAME,
469: DESCRIPTION = X_DESCRIPTION,
470: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
471: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 486: delete from FND_OAM_METS_TL

482: procedure DELETE_ROW (
483: X_METRIC_SHORT_NAME in VARCHAR2
484: ) is
485: begin
486: delete from FND_OAM_METS_TL
487: where METRIC_SHORT_NAME = X_METRIC_SHORT_NAME;
488:
489: if (sql%notfound) then
490: raise no_data_found;

Line 510: delete from FND_OAM_METS_TL T

506: /* The following delete and update statements are commented out */
507: /* as a quick workaround to fix the time-consuming table handler issue */
508: /* Eventually we'll need to turn them into a separate fix_language procedure */
509: /*
510: delete from FND_OAM_METS_TL T
511: where not exists
512: (select NULL
513: from FND_OAM_METVAL B
514: where B.METRIC_SHORT_NAME = T.METRIC_SHORT_NAME

Line 517: update FND_OAM_METS_TL T set (

513: from FND_OAM_METVAL B
514: where B.METRIC_SHORT_NAME = T.METRIC_SHORT_NAME
515: );
516:
517: update FND_OAM_METS_TL T set (
518: METRIC_DISPLAY_NAME,
519: DESCRIPTION
520: ) = (select
521: B.METRIC_DISPLAY_NAME,

Line 523: from FND_OAM_METS_TL B

519: DESCRIPTION
520: ) = (select
521: B.METRIC_DISPLAY_NAME,
522: B.DESCRIPTION
523: from FND_OAM_METS_TL B
524: where B.METRIC_SHORT_NAME = T.METRIC_SHORT_NAME
525: and B.LANGUAGE = T.SOURCE_LANG)
526: where (
527: T.METRIC_SHORT_NAME,

Line 532: from FND_OAM_METS_TL SUBB, FND_OAM_METS_TL SUBT

528: T.LANGUAGE
529: ) in (select
530: SUBT.METRIC_SHORT_NAME,
531: SUBT.LANGUAGE
532: from FND_OAM_METS_TL SUBB, FND_OAM_METS_TL SUBT
533: where SUBB.METRIC_SHORT_NAME = SUBT.METRIC_SHORT_NAME
534: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
535: and (SUBB.METRIC_DISPLAY_NAME <> SUBT.METRIC_DISPLAY_NAME
536: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 542: insert into FND_OAM_METS_TL (

538: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
539: ));
540: */
541:
542: insert into FND_OAM_METS_TL (
543: METRIC_SHORT_NAME,
544: METRIC_DISPLAY_NAME,
545: DESCRIPTION,
546: CREATED_BY,

Line 564: from FND_OAM_METS_TL B, FND_LANGUAGES L

560: B.LAST_UPDATE_DATE,
561: B.LAST_UPDATE_LOGIN,
562: L.LANGUAGE_CODE,
563: B.SOURCE_LANG
564: from FND_OAM_METS_TL B, FND_LANGUAGES L
565: where L.INSTALLED_FLAG in ('I', 'B')
566: and B.LANGUAGE = userenv('LANG')
567: and not exists
568: (select NULL

Line 569: from FND_OAM_METS_TL T

565: where L.INSTALLED_FLAG in ('I', 'B')
566: and B.LANGUAGE = userenv('LANG')
567: and not exists
568: (select NULL
569: from FND_OAM_METS_TL T
570: where T.METRIC_SHORT_NAME = B.METRIC_SHORT_NAME
571: and T.LANGUAGE = L.LANGUAGE_CODE);
572: end ADD_LANGUAGE;
573: