APPS.FUN_RULE_OBJECTS_PKG dependencies on FUN_RULE_OBJECTS_TL

Line 190: insert into FUN_RULE_OBJECTS_TL (

186: NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY)
187: )RETURNING ROWID INTO X_ROWID;
188:
189:
190: insert into FUN_RULE_OBJECTS_TL (
191: RULE_OBJECT_ID,
192: USER_RULE_OBJECT_NAME,
193: DESCRIPTION,
194: CREATED_BY,

Line 216: from FUN_RULE_OBJECTS_TL T

212: from FND_LANGUAGES L
213: where L.INSTALLED_FLAG in ('I', 'B')
214: and not exists
215: (select NULL
216: from FUN_RULE_OBJECTS_TL T
217: where T.RULE_OBJECT_ID = X_RULE_OBJECT_ID
218: and T.LANGUAGE = L.LANGUAGE_CODE);
219:
220: open c(X_RULE_OBJECT_ID);

Line 420: update FUN_RULE_OBJECTS_TL set

416: if (sql%notfound) then
417: raise no_data_found;
418: end if;
419:
420: update FUN_RULE_OBJECTS_TL set
421: USER_RULE_OBJECT_NAME = X_USER_RULE_OBJECT_NAME,
422: DESCRIPTION = X_DESCRIPTION,
423: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE),
424: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY),

Line 476: delete from FUN_RULE_OBJECTS_TL

472: if (sql%notfound) then
473: raise no_data_found;
474: end if;
475:
476: delete from FUN_RULE_OBJECTS_TL
477: where RULE_OBJECT_ID in (select RULE_OBJECT_ID
478: from FUN_RULE_OBJECTS_B
479: where RULE_OBJECT_NAME = X_RULE_OBJECT_NAME
480: AND APPLICATION_ID = X_APPLICATION_ID

Line 529: delete from FUN_RULE_OBJECTS_TL

525: PROCEDURE DELETE_ROW (
526: X_RULE_OBJECT_ID IN NUMBER
527: ) IS
528: begin
529: delete from FUN_RULE_OBJECTS_TL
530: where RULE_OBJECT_ID = X_RULE_OBJECT_ID;
531:
532: if (sql%notfound) then
533: raise no_data_found;

Line 772: delete from FUN_RULE_OBJECTS_TL T

768:
769: procedure ADD_LANGUAGE
770: is
771: begin
772: delete from FUN_RULE_OBJECTS_TL T
773: where not exists
774: (select NULL
775: from FUN_RULE_OBJECTS_B B
776: where B.RULE_OBJECT_ID = T.RULE_OBJECT_ID

Line 779: update FUN_RULE_OBJECTS_TL T set (

775: from FUN_RULE_OBJECTS_B B
776: where B.RULE_OBJECT_ID = T.RULE_OBJECT_ID
777: );
778:
779: update FUN_RULE_OBJECTS_TL T set (
780: USER_RULE_OBJECT_NAME,
781: DESCRIPTION
782: ) = (select
783: B.USER_RULE_OBJECT_NAME,

Line 785: from FUN_RULE_OBJECTS_TL B

781: DESCRIPTION
782: ) = (select
783: B.USER_RULE_OBJECT_NAME,
784: B.DESCRIPTION
785: from FUN_RULE_OBJECTS_TL B
786: where B.RULE_OBJECT_ID = T.RULE_OBJECT_ID
787: and B.LANGUAGE = T.SOURCE_LANG)
788: where (
789: T.RULE_OBJECT_ID,

Line 794: from FUN_RULE_OBJECTS_TL SUBB, FUN_RULE_OBJECTS_TL SUBT

790: T.LANGUAGE
791: ) in (select
792: SUBT.RULE_OBJECT_ID,
793: SUBT.LANGUAGE
794: from FUN_RULE_OBJECTS_TL SUBB, FUN_RULE_OBJECTS_TL SUBT
795: where SUBB.RULE_OBJECT_ID = SUBT.RULE_OBJECT_ID
796: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
797: and (SUBB.USER_RULE_OBJECT_NAME <> SUBT.USER_RULE_OBJECT_NAME
798: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 804: insert into FUN_RULE_OBJECTS_TL (

800: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
801: ));
802:
803:
804: insert into FUN_RULE_OBJECTS_TL (
805: RULE_OBJECT_ID,
806: USER_RULE_OBJECT_NAME,
807: DESCRIPTION,
808: CREATION_DATE,

Line 826: from FUN_RULE_OBJECTS_TL B, FND_LANGUAGES L

822: B.LAST_UPDATED_BY,
823: B.LAST_UPDATE_LOGIN,
824: L.LANGUAGE_CODE,
825: B.SOURCE_LANG
826: from FUN_RULE_OBJECTS_TL B, FND_LANGUAGES L
827: where L.INSTALLED_FLAG in ('I', 'B')
828: and B.LANGUAGE = userenv('LANG')
829: and not exists
830: (select NULL

Line 831: from FUN_RULE_OBJECTS_TL T

827: where L.INSTALLED_FLAG in ('I', 'B')
828: and B.LANGUAGE = userenv('LANG')
829: and not exists
830: (select NULL
831: from FUN_RULE_OBJECTS_TL T
832: where T.RULE_OBJECT_ID = B.RULE_OBJECT_ID
833: and T.LANGUAGE = L.LANGUAGE_CODE);
834: end ADD_LANGUAGE;
835:

Line 890: from FUN_RULE_OBJECTS_TL

886:
887: BEGIN
888: select last_updated_by, last_update_date
889: into db_luby, db_ludate
890: from FUN_RULE_OBJECTS_TL
891: where rule_object_id = roid
892: and language = userenv('LANG');
893: EXCEPTION
894: WHEN NO_DATA_FOUND THEN

Line 907: update FUN_RULE_OBJECTS_TL

903: p_db_id => db_luby,
904: p_db_lud => db_ludate,
905: p_custom_mode => x_custom_mode))
906: then
907: update FUN_RULE_OBJECTS_TL
908: set user_rule_object_name = nvl(x_user_rule_object_name, user_rule_object_name),
909: description = nvl(x_description, description),
910: source_lang = userenv('LANG')
911: where rule_object_id = roid