APPS.EGO_RULE_SETS_PKG dependencies on EGO_RULE_SETS_TL

Line 399: update EGO_RULE_SETS_TL set

395: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
396: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
397: where RULESET_ID = X_RULESET_ID;
398:
399: update EGO_RULE_SETS_TL set
400: RULESET_DISPLAY_NAME = X_RULESET_DISPLAY_NAME,
401: DESCRIPTION = X_DESCRIPTION,
402: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,SYSDATE),
403: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 442: insert into EGO_RULE_SETS_TL (

438: X_LAST_UPDATED_BY,
439: X_LAST_UPDATE_LOGIN
440: );
441:
442: insert into EGO_RULE_SETS_TL (
443: RULESET_ID,
444: RULESET_DISPLAY_NAME,
445: DESCRIPTION,
446: LAST_UPDATE_DATE,

Line 468: from EGO_RULE_SETS_TL T

464: from FND_LANGUAGES L
465: where L.INSTALLED_FLAG in ('I', 'B')
466: and not exists
467: (select NULL
468: from EGO_RULE_SETS_TL T
469: where T.RULESET_ID = X_RULESET_ID
470: and T.LANGUAGE = L.LANGUAGE_CODE);
471:
472: LOG_MSG('RULESET_SUCCESS', 'Ruleset: ' || X_RULESET_NAME || ' inserted successfully!');

Line 575: insert into EGO_RULE_SETS_TL (

571: X_LAST_UPDATED_BY,
572: X_LAST_UPDATE_LOGIN
573: );
574:
575: insert into EGO_RULE_SETS_TL (
576: RULESET_ID,
577: RULESET_DISPLAY_NAME,
578: DESCRIPTION,
579: LAST_UPDATE_DATE,

Line 601: from EGO_RULE_SETS_TL T

597: from FND_LANGUAGES L
598: where L.INSTALLED_FLAG in ('I', 'B')
599: and not exists
600: (select NULL
601: from EGO_RULE_SETS_TL T
602: where T.RULESET_ID = X_RULESET_ID
603: and T.LANGUAGE = L.LANGUAGE_CODE);
604:
605: open c;

Line 642: from EGO_RULE_SETS_TL

638: cursor c1 is select
639: RULESET_DISPLAY_NAME,
640: DESCRIPTION,
641: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
642: from EGO_RULE_SETS_TL
643: where RULESET_ID = X_RULESET_ID
644: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
645: for update of RULESET_ID nowait;
646: begin

Line 719: update EGO_RULE_SETS_TL set

715: if (sql%notfound) then
716: raise no_data_found;
717: end if;
718:
719: update EGO_RULE_SETS_TL set
720: RULESET_DISPLAY_NAME = X_RULESET_DISPLAY_NAME,
721: DESCRIPTION = X_DESCRIPTION,
722: LAST_UPDATE_DATE = Nvl(X_LAST_UPDATE_DATE,SYSDATE),
723: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 738: delete from EGO_RULE_SETS_TL

734: procedure DELETE_ROW (
735: X_RULESET_ID in NUMBER
736: ) is
737: begin
738: delete from EGO_RULE_SETS_TL
739: where RULESET_ID = X_RULESET_ID;
740:
741: if (sql%notfound) then
742: raise no_data_found;

Line 756: delete from EGO_RULE_SETS_TL T

752:
753: procedure ADD_LANGUAGE
754: is
755: begin
756: delete from EGO_RULE_SETS_TL T
757: where not exists
758: (select NULL
759: from EGO_RULE_SETS_B B
760: where B.RULESET_ID = T.RULESET_ID

Line 763: update EGO_RULE_SETS_TL T set (

759: from EGO_RULE_SETS_B B
760: where B.RULESET_ID = T.RULESET_ID
761: );
762:
763: update EGO_RULE_SETS_TL T set (
764: RULESET_DISPLAY_NAME,
765: DESCRIPTION
766: ) = (select
767: B.RULESET_DISPLAY_NAME,

Line 769: from EGO_RULE_SETS_TL B

765: DESCRIPTION
766: ) = (select
767: B.RULESET_DISPLAY_NAME,
768: B.DESCRIPTION
769: from EGO_RULE_SETS_TL B
770: where B.RULESET_ID = T.RULESET_ID
771: and B.LANGUAGE = T.SOURCE_LANG)
772: where (
773: T.RULESET_ID,

Line 778: from EGO_RULE_SETS_TL SUBB, EGO_RULE_SETS_TL SUBT

774: T.LANGUAGE
775: ) in (select
776: SUBT.RULESET_ID,
777: SUBT.LANGUAGE
778: from EGO_RULE_SETS_TL SUBB, EGO_RULE_SETS_TL SUBT
779: where SUBB.RULESET_ID = SUBT.RULESET_ID
780: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
781: and (SUBB.RULESET_DISPLAY_NAME <> SUBT.RULESET_DISPLAY_NAME
782: or (SUBB.RULESET_DISPLAY_NAME is null and SUBT.RULESET_DISPLAY_NAME is not null)

Line 789: insert into EGO_RULE_SETS_TL (

785: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
786: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
787: ));
788:
789: insert into EGO_RULE_SETS_TL (
790: RULESET_ID,
791: RULESET_DISPLAY_NAME,
792: DESCRIPTION,
793: LAST_UPDATE_DATE,

Line 811: from EGO_RULE_SETS_TL B, FND_LANGUAGES L

807: B.CREATED_BY,
808: B.LAST_UPDATE_LOGIN,
809: L.LANGUAGE_CODE,
810: B.SOURCE_LANG
811: from EGO_RULE_SETS_TL B, FND_LANGUAGES L
812: where L.INSTALLED_FLAG in ('I', 'B')
813: and B.LANGUAGE = userenv('LANG')
814: and not exists
815: (select NULL

Line 816: from EGO_RULE_SETS_TL T

812: where L.INSTALLED_FLAG in ('I', 'B')
813: and B.LANGUAGE = userenv('LANG')
814: and not exists
815: (select NULL
816: from EGO_RULE_SETS_TL T
817: where T.RULESET_ID = B.RULESET_ID
818: and T.LANGUAGE = L.LANGUAGE_CODE);
819: end ADD_LANGUAGE;
820:

Line 828: update EGO_RULE_SETS_TL set

824: X_DESCRIPTION in VARCHAR2,
825: X_OWNER in VARCHAR2
826: ) is
827: begin
828: update EGO_RULE_SETS_TL set
829: RULESET_DISPLAY_NAME = X_RULESET_DISPLAY_NAME,
830: DESCRIPTION = X_DESCRIPTION,
831: LAST_UPDATE_DATE = sysdate,
832: LAST_UPDATED_BY = decode(x_owner, 'ORACLE', 1, 0),