APPS.FND_OAM_DS_ALGOS_PKG dependencies on FND_OAM_DS_ALGOS_TL

Line 63: FROM fnd_oam_ds_algos_tl

59: END IF;
60:
61: SELECT algo_id
62: INTO l_algo_id
63: FROM fnd_oam_ds_algos_tl
64: WHERE display_name = p_display_name
65: AND language = USERENV('LANG');
66:
67: RETURN l_algo_id;

Line 415: from fnd_oam_ds_algos_tl

411:
412: begin
413: select LAST_UPDATED_BY, LAST_UPDATE_DATE
414: into db_luby, db_ludate
415: from fnd_oam_ds_algos_tl
416: where algo_id = to_number(X_ALGO_ID)
417: and LANGUAGE = userenv('LANG');
418:
419: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 421: update fnd_oam_ds_algos_tl set

417: and LANGUAGE = userenv('LANG');
418:
419: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
420: db_ludate, X_CUSTOM_MODE)) then
421: update fnd_oam_ds_algos_tl set
422: display_name = nvl(X_DISPLAY_NAME, display_name),
423: description = nvl(X_DESCRIPTION, description),
424: source_lang = userenv('LANG'),
425: last_update_date = f_ludate,

Line 491: insert into FND_OAM_DS_ALGOS_TL (

487: X_LAST_UPDATE_DATE,
488: X_LAST_UPDATE_LOGIN
489: );
490:
491: insert into FND_OAM_DS_ALGOS_TL (
492: ALGO_ID,
493: DISPLAY_NAME,
494: DESCRIPTION,
495: CREATED_BY,

Line 517: from FND_OAM_DS_ALGOS_TL T

513: from FND_LANGUAGES L
514: where L.INSTALLED_FLAG in ('I', 'B')
515: and not exists
516: (select NULL
517: from FND_OAM_DS_ALGOS_TL T
518: where T.ALGO_ID = X_ALGO_ID
519: and T.LANGUAGE = L.LANGUAGE_CODE);
520:
521: open c;

Line 574: from FND_OAM_DS_ALGOS_TL

570: cursor c1 is select
571: DISPLAY_NAME,
572: DESCRIPTION,
573: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
574: from FND_OAM_DS_ALGOS_TL
575: where ALGO_ID = X_ALGO_ID
576: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
577: for update of ALGO_ID nowait;
578: begin

Line 659: update FND_OAM_DS_ALGOS_TL set

655: if (sql%notfound) then
656: raise no_data_found;
657: end if;
658:
659: update FND_OAM_DS_ALGOS_TL set
660: DISPLAY_NAME = X_DISPLAY_NAME,
661: DESCRIPTION = X_DESCRIPTION,
662: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
663: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 681: delete from FND_OAM_DS_ALGOS_TL

677: procedure DELETE_ROW (
678: X_ALGO_ID in NUMBER
679: ) is
680: begin
681: delete from FND_OAM_DS_ALGOS_TL
682: where ALGO_ID = X_ALGO_ID;
683:
684: if (sql%notfound) then
685: raise no_data_found;

Line 702: delete from FND_OAM_DS_ALGOS_TL T

698:
699: procedure ADD_LANGUAGE
700: is
701: begin
702: delete from FND_OAM_DS_ALGOS_TL T
703: where not exists
704: (select NULL
705: from FND_OAM_DS_ALGOS_B B
706: where B.ALGO_ID = T.ALGO_ID

Line 709: update FND_OAM_DS_ALGOS_TL T set (

705: from FND_OAM_DS_ALGOS_B B
706: where B.ALGO_ID = T.ALGO_ID
707: );
708:
709: update FND_OAM_DS_ALGOS_TL T set (
710: DISPLAY_NAME,
711: DESCRIPTION
712: ) = (select
713: B.DISPLAY_NAME,

Line 715: from FND_OAM_DS_ALGOS_TL B

711: DESCRIPTION
712: ) = (select
713: B.DISPLAY_NAME,
714: B.DESCRIPTION
715: from FND_OAM_DS_ALGOS_TL B
716: where B.ALGO_ID = T.ALGO_ID
717: and B.LANGUAGE = T.SOURCE_LANG)
718: where (
719: T.ALGO_ID,

Line 724: from FND_OAM_DS_ALGOS_TL SUBB, FND_OAM_DS_ALGOS_TL SUBT

720: T.LANGUAGE
721: ) in (select
722: SUBT.ALGO_ID,
723: SUBT.LANGUAGE
724: from FND_OAM_DS_ALGOS_TL SUBB, FND_OAM_DS_ALGOS_TL SUBT
725: where SUBB.ALGO_ID = SUBT.ALGO_ID
726: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
727: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
728: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 733: insert into FND_OAM_DS_ALGOS_TL (

729: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
730: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
731: ));
732:
733: insert into FND_OAM_DS_ALGOS_TL (
734: ALGO_ID,
735: DISPLAY_NAME,
736: DESCRIPTION,
737: CREATED_BY,

Line 755: from FND_OAM_DS_ALGOS_TL B, FND_LANGUAGES L

751: B.LAST_UPDATE_DATE,
752: B.LAST_UPDATE_LOGIN,
753: L.LANGUAGE_CODE,
754: B.SOURCE_LANG
755: from FND_OAM_DS_ALGOS_TL B, FND_LANGUAGES L
756: where L.INSTALLED_FLAG in ('I', 'B')
757: and B.LANGUAGE = userenv('LANG')
758: and not exists
759: (select NULL

Line 760: from FND_OAM_DS_ALGOS_TL T

756: where L.INSTALLED_FLAG in ('I', 'B')
757: and B.LANGUAGE = userenv('LANG')
758: and not exists
759: (select NULL
760: from FND_OAM_DS_ALGOS_TL T
761: where T.ALGO_ID = B.ALGO_ID
762: and T.LANGUAGE = L.LANGUAGE_CODE);
763: end ADD_LANGUAGE;
764:

Line 778: UPDATE FND_OAM_DS_ALGOS_TL SET

774: X_LAST_UPDATE_LOGIN in NUMBER)
775: is
776: begin
777:
778: UPDATE FND_OAM_DS_ALGOS_TL SET
779: DISPLAY_NAME = nvl(x_DISPLAY_NAME,DISPLAY_NAME),
780: last_update_date = nvl(x_last_update_date,sysdate),
781: last_updated_by = x_last_updated_by,
782: last_update_login = 0,