eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FF_DATABASE_ITEMS_PKG dependencies on FF_DATABASE_ITEMS_TL

Line 19: insert into ff_database_items_tl (

15: --
16: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;
17: ff_database_items_pkg.g_disable_triggers := 'Y';
18:
19: insert into ff_database_items_tl (
20: user_name,
21: user_entity_id,
22: translated_user_name,
23: description,

Line 37: from ff_database_items_tl t

33: from fnd_languages l
34: where l.installed_flag in ('I', 'B')
35: and not exists
36: (select null
37: from ff_database_items_tl t
38: where t.user_name = x_user_name
39: and t.user_entity_id = x_user_entity_id
40: and t.language = l.language_code);
41:

Line 175: from ff_database_items_tl

171: ,x_new_name in varchar2
172: ,x_language in varchar2
173: ) is
174: select distinct translated_user_name
175: from ff_database_items_tl
176: where user_name = x_user_name
177: and user_entity_id = x_user_entity_id
178: and translated_user_name <> x_new_name
179: and translated_user_name <> x_user_name

Line 192: from ff_database_items_tl

188: ,x_old_name in varchar2
189: ,x_language in varchar2
190: ) is
191: select null
192: from ff_database_items_tl
193: where user_name = x_user_name
194: and user_entity_id = x_user_entity_id
195: and translated_user_name = x_old_name
196: and language <> x_language

Line 725: update ff_database_items_tl set

721: --
722: l_disable_triggers := ff_database_items_pkg.g_disable_triggers;
723: ff_database_items_pkg.g_disable_triggers := 'Y';
724:
725: update ff_database_items_tl set
726: translated_user_name = l_tl_user_name,
727: description = x_description,
728: last_update_date = x_last_update_date,
729: last_updated_by = x_last_updated_by,

Line 845: from ff_database_items_tl

841: ,x_language in varchar2
842: ,x_new_name in varchar2
843: ) is
844: select translated_user_name
845: from ff_database_items_tl
846: where user_name = x_user_name
847: and user_entity_id = x_user_entity_id
848: and translated_user_name <> x_new_name
849: and translated_user_name <> x_user_name

Line 862: from ff_database_items_tl

858: ,x_old_name in varchar2
859: ,x_language in varchar2
860: ) is
861: select null
862: from ff_database_items_tl
863: where user_name = x_user_name
864: and user_entity_id = x_user_entity_id
865: and translated_user_name = x_old_name
866: and language <> x_language

Line 927: update ff_database_items_tl set

923: hr_utility.raise_error;
924: end if;
925: end if;
926:
927: update ff_database_items_tl set
928: translated_user_name = l_tl_name,
929: description = x_description,
930: source_lang = x_source_lang
931: where user_name = l_user_name

Line 1092: delete /+ INDEX(dbitl FF_DATABASE_ITEMS_TL_PK) /

1088: l_user_name varchar2(2000);
1089: begin
1090: l_user_name := upper(x_user_name);
1091:
1092: delete /*+ INDEX(dbitl FF_DATABASE_ITEMS_TL_PK) */
1093: from ff_database_items_tl dbitl
1094: where dbitl.user_name = l_user_name
1095: and dbitl.user_entity_id = x_user_entity_id;
1096: end delete_tl_rows;

Line 1093: from ff_database_items_tl dbitl

1089: begin
1090: l_user_name := upper(x_user_name);
1091:
1092: delete /*+ INDEX(dbitl FF_DATABASE_ITEMS_TL_PK) */
1093: from ff_database_items_tl dbitl
1094: where dbitl.user_name = l_user_name
1095: and dbitl.user_entity_id = x_user_entity_id;
1096: end delete_tl_rows;
1097:

Line 1189: -- delete from ff_database_items_tl t

1185: hr_utility.trace('add_language:delete');
1186: end if;
1187:
1188: -- bug 13739722 remove delete
1189: -- delete from ff_database_items_tl t
1190: -- where (t.user_name, t.user_entity_id) not in
1191: -- (
1192: -- select /*+ parallel(b) use_hash(b) index_ffs(b) */ b.user_name
1193: -- , b.user_entity_id

Line 1209: update ff_database_items_tl t set (

1205: end if;
1206:
1207: /* bug 13739722 remove update
1208: forall i in ueids.first .. ueids.last
1209: update ff_database_items_tl t set (
1210: translated_user_name,
1211: description
1212: ) = (select
1213: b.translated_user_name,

Line 1215: from ff_database_items_tl b

1211: description
1212: ) = (select
1213: b.translated_user_name,
1214: b.description
1215: from ff_database_items_tl b
1216: where b.user_entity_id = ueids(i)
1217: and b.user_name = t.user_name
1218: and b.user_entity_id = t.user_entity_id
1219: and b.language = t.source_lang)

Line 1228: from ff_database_items_tl subb, ff_database_items_tl subt

1224: ) in (select
1225: subt.user_name,
1226: subt.user_entity_id,
1227: subt.language
1228: from ff_database_items_tl subb, ff_database_items_tl subt
1229: where subb.user_entity_id = ueids(i)
1230: and subb.user_name = subt.user_name
1231: and subb.user_entity_id = subt.user_entity_id
1232: and subb.language = subt.source_lang

Line 1246: insert /+ append parallel(tt) / into ff_database_items_tl tt (

1242: hr_utility.trace('add_language:insert');
1243: end if;
1244:
1245: forall i in ueids.first .. ueids.last
1246: insert /*+ append parallel(tt) */ into ff_database_items_tl tt (
1247: user_name,
1248: user_entity_id,
1249: translated_user_name,
1250: description,

Line 1272: from ff_database_items_tl b,

1268: b.created_by,
1269: b.creation_date,
1270: l.language_code,
1271: b.source_lang
1272: from ff_database_items_tl b,
1273: fnd_languages l
1274: where l.installed_flag in ('I', 'B')
1275: and b.user_entity_id = ueids(i)
1276: and b.language = l_userenv_lang ) v,

Line 1277: ff_database_items_tl t

1273: fnd_languages l
1274: where l.installed_flag in ('I', 'B')
1275: and b.user_entity_id = ueids(i)
1276: and b.language = l_userenv_lang ) v,
1277: ff_database_items_tl t
1278: where t.user_name(+) = v.user_name
1279: and t.user_entity_id(+) = v.user_entity_id
1280: and t.language(+) = v.language_code
1281: and t.user_entity_id IS NULL