DBA Data[Home] [Help]

APPS.FND_INDUSTRY_ACTIVATOR dependencies on FND_LOOKUP_VALUES

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 76: from fnd_lookup_values

72: p_language_code IN VARCHAR2) is
73: select
74: meaning,
75: description
76: from fnd_lookup_values
77: where view_application_id = p_app_id and
78: lookup_type = p_lookup_type and
79: lookup_code = p_lookup_code and
80: language = p_language_code and

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 102: -- replace the meaning and/or description in fnd_lookup_values

98: lookup_code = v1.lookup_code and
99: language_code = v1.language_code and
100: industry_id = v_industry_id;
101: end loop;
102: -- replace the meaning and/or description in fnd_lookup_values
103: -- for the active industry
104: -- using exception handlers around the update meaning statement so that
105: -- we do not violate unique index constraint (APPLSYS.FND_LOOKUP_VALUES_U2)
106: -- this constraint means for a given lookup type there multiple lookup codes cannot

Line 105: -- we do not violate unique index constraint (APPLSYS.FND_LOOKUP_VALUES_U2)

101: end loop;
102: -- replace the meaning and/or description in fnd_lookup_values
103: -- for the active industry
104: -- using exception handlers around the update meaning statement so that
105: -- we do not violate unique index constraint (APPLSYS.FND_LOOKUP_VALUES_U2)
106: -- this constraint means for a given lookup type there multiple lookup codes cannot
107: -- have the same meaning. If the update violates the constraint, we silently do not update that row.
108: begin
109: if v1.meaning is NOT NULL then

Line 110: update fnd_lookup_values

106: -- this constraint means for a given lookup type there multiple lookup codes cannot
107: -- have the same meaning. If the update violates the constraint, we silently do not update that row.
108: begin
109: if v1.meaning is NOT NULL then
110: update fnd_lookup_values
111: set meaning = v1.meaning,
112: last_updated_by = 8
113: where view_application_id = v1.application_id and
114: lookup_type = v1.lookup_type and

Line 123: update fnd_lookup_values

119: when others then
120: null;
121: end;
122: if v1.description is NOT NULL then
123: update fnd_lookup_values
124: set description = v1.description,
125: last_updated_by = 8
126: where view_application_id = v1.application_id and
127: 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 210: fnd_lookup_values lv

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
214: il.lookup_code = lv.lookup_code and

Line 251: update fnd_lookup_values

247: FND_FILE.NEW_LINE(FND_FILE.LOG);
248: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Restoring original lookup values meaning and description.');
249: for v2 in restore_lookups loop
250: if v2.orig_meaning is not null then
251: update fnd_lookup_values
252: set meaning = v2.orig_meaning,
253: description = v2.orig_description,
254: last_updated_by = 2
255: where view_application_id = v2.application_id

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