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.FND_INDUSTRY_ACTIVATOR dependencies on FND_LOOKUP_VALUES_IL

Line 66: from fnd_lookup_values_il

62: lookup_code,
63: language_code,
64: meaning,
65: description
66: from fnd_lookup_values_il
67: where industry_id = p_industry_id;
68:
69: cursor get_original_lookups(p_app_id IN NUMBER,
70: p_lookup_type IN VARCHAR2,

Line 86: -- get the list of lookups for the current industry from fnd_lookup_values_il

82:
83: BEGIN
84: FND_FILE.NEW_LINE(FND_FILE.LOG);
85: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updating industry translated lookups.');
86: -- get the list of lookups for the current industry from fnd_lookup_values_il
87: for v1 in industry_lookup_list(v_industry_id) loop
88: -- populate the orig_message_text column
89: for v2 in get_original_lookups(v1.application_id,
90: v1.lookup_type,

Line 93: update fnd_lookup_values_il

89: for v2 in get_original_lookups(v1.application_id,
90: v1.lookup_type,
91: v1.lookup_code,
92: v1.language_code) loop
93: update fnd_lookup_values_il
94: set orig_meaning = v2.meaning,
95: orig_description = v2.description
96: where application_id = v1.application_id and
97: lookup_type = v1.lookup_type and

Line 209: from fnd_lookup_values_il il,

205: il.lookup_code,
206: il.language_code,
207: il.orig_meaning,
208: il.orig_description
209: from fnd_lookup_values_il il,
210: fnd_lookup_values lv
211: where il.industry_id = v_industry_id and
212: il.application_id = lv.view_application_id and
213: il.lookup_type = lv.lookup_type and

Line 263: -- clean up the orig_meaning and orig_description columns in the FND_LOOKUP_VALUES_IL table

259: end if;
260: end loop;
261: commit;
262: FND_FILE.PUT_LINE(FND_FILE.LOG,'Original lookup value meanings and descriptions restored.');
263: -- clean up the orig_meaning and orig_description columns in the FND_LOOKUP_VALUES_IL table
264: update fnd_lookup_values_il
265: set orig_meaning = null,
266: orig_description = null;
267: commit;

Line 264: update fnd_lookup_values_il

260: end loop;
261: commit;
262: FND_FILE.PUT_LINE(FND_FILE.LOG,'Original lookup value meanings and descriptions restored.');
263: -- clean up the orig_meaning and orig_description columns in the FND_LOOKUP_VALUES_IL table
264: update fnd_lookup_values_il
265: set orig_meaning = null,
266: orig_description = null;
267: commit;
268: if fnd_profile.save('FND_INDUSTRY_ID', NULL,'SITE') then