APPS.FEM_MAP_RULE_TYPES_PKG dependencies on FEM_MAP_RULE_TYPES_TL

Line 40: insert into FEM_MAP_RULE_TYPES_TL (

36: X_LAST_UPDATED_BY,
37: X_LAST_UPDATE_LOGIN
38: );
39:
40: insert into FEM_MAP_RULE_TYPES_TL (
41: MAP_RULE_TYPE_CODE,
42: MAP_RULE_TYPE_NAME,
43: DESCRIPTION,
44: CREATION_DATE,

Line 66: from FEM_MAP_RULE_TYPES_TL T

62: from FND_LANGUAGES L
63: where L.INSTALLED_FLAG in ('I', 'B')
64: and not exists
65: (select NULL
66: from FEM_MAP_RULE_TYPES_TL T
67: where T.MAP_RULE_TYPE_CODE = X_MAP_RULE_TYPE_CODE
68: and T.LANGUAGE = L.LANGUAGE_CODE);
69:
70: open c;

Line 99: from FEM_MAP_RULE_TYPES_TL

95: cursor c1 is select
96: MAP_RULE_TYPE_NAME,
97: DESCRIPTION,
98: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
99: from FEM_MAP_RULE_TYPES_TL
100: where MAP_RULE_TYPE_CODE = X_MAP_RULE_TYPE_CODE
101: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
102: for update of MAP_RULE_TYPE_CODE nowait;
103: begin

Line 160: update FEM_MAP_RULE_TYPES_TL set

156: if (sql%notfound) then
157: raise no_data_found;
158: end if;
159:
160: update FEM_MAP_RULE_TYPES_TL set
161: MAP_RULE_TYPE_NAME = X_MAP_RULE_TYPE_NAME,
162: DESCRIPTION = X_DESCRIPTION,
163: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
164: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 179: delete from FEM_MAP_RULE_TYPES_TL

175: procedure DELETE_ROW (
176: X_MAP_RULE_TYPE_CODE in VARCHAR2
177: ) is
178: begin
179: delete from FEM_MAP_RULE_TYPES_TL
180: where MAP_RULE_TYPE_CODE = X_MAP_RULE_TYPE_CODE;
181:
182: if (sql%notfound) then
183: raise no_data_found;

Line 197: delete from FEM_MAP_RULE_TYPES_TL T

193:
194: procedure ADD_LANGUAGE
195: is
196: begin
197: delete from FEM_MAP_RULE_TYPES_TL T
198: where not exists
199: (select NULL
200: from FEM_MAP_RULE_TYPES_B B
201: where B.MAP_RULE_TYPE_CODE = T.MAP_RULE_TYPE_CODE

Line 204: update FEM_MAP_RULE_TYPES_TL T set (

200: from FEM_MAP_RULE_TYPES_B B
201: where B.MAP_RULE_TYPE_CODE = T.MAP_RULE_TYPE_CODE
202: );
203:
204: update FEM_MAP_RULE_TYPES_TL T set (
205: MAP_RULE_TYPE_NAME,
206: DESCRIPTION
207: ) = (select
208: B.MAP_RULE_TYPE_NAME,

Line 210: from FEM_MAP_RULE_TYPES_TL B

206: DESCRIPTION
207: ) = (select
208: B.MAP_RULE_TYPE_NAME,
209: B.DESCRIPTION
210: from FEM_MAP_RULE_TYPES_TL B
211: where B.MAP_RULE_TYPE_CODE = T.MAP_RULE_TYPE_CODE
212: and B.LANGUAGE = T.SOURCE_LANG)
213: where (
214: T.MAP_RULE_TYPE_CODE,

Line 219: from FEM_MAP_RULE_TYPES_TL SUBB, FEM_MAP_RULE_TYPES_TL SUBT

215: T.LANGUAGE
216: ) in (select
217: SUBT.MAP_RULE_TYPE_CODE,
218: SUBT.LANGUAGE
219: from FEM_MAP_RULE_TYPES_TL SUBB, FEM_MAP_RULE_TYPES_TL SUBT
220: where SUBB.MAP_RULE_TYPE_CODE = SUBT.MAP_RULE_TYPE_CODE
221: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
222: and (SUBB.MAP_RULE_TYPE_NAME <> SUBT.MAP_RULE_TYPE_NAME
223: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 228: insert into FEM_MAP_RULE_TYPES_TL (

224: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
225: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
226: ));
227:
228: insert into FEM_MAP_RULE_TYPES_TL (
229: MAP_RULE_TYPE_CODE,
230: MAP_RULE_TYPE_NAME,
231: DESCRIPTION,
232: CREATION_DATE,

Line 250: from FEM_MAP_RULE_TYPES_TL B, FND_LANGUAGES L

246: B.LAST_UPDATE_DATE,
247: B.LAST_UPDATE_LOGIN,
248: L.LANGUAGE_CODE,
249: B.SOURCE_LANG
250: from FEM_MAP_RULE_TYPES_TL B, FND_LANGUAGES L
251: where L.INSTALLED_FLAG in ('I', 'B')
252: and B.LANGUAGE = userenv('LANG')
253: and not exists
254: (select NULL

Line 255: from FEM_MAP_RULE_TYPES_TL T

251: where L.INSTALLED_FLAG in ('I', 'B')
252: and B.LANGUAGE = userenv('LANG')
253: and not exists
254: (select NULL
255: from FEM_MAP_RULE_TYPES_TL T
256: where T.MAP_RULE_TYPE_CODE = B.MAP_RULE_TYPE_CODE
257: and T.LANGUAGE = L.LANGUAGE_CODE);
258: end ADD_LANGUAGE;
259: PROCEDURE TRANSLATE_ROW(

Line 285: from FEM_MAP_RULE_TYPES_TL

281: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
282: begin
283: select LAST_UPDATED_BY, LAST_UPDATE_DATE
284: into db_luby, db_ludate
285: from FEM_MAP_RULE_TYPES_TL
286: where MAP_RULE_TYPE_CODE = x_MAP_RULE_TYPE_CODE
287: and LANGUAGE = userenv('LANG');
288:
289: -- Test for customization and version

Line 293: update FEM_MAP_RULE_TYPES_TL set

289: -- Test for customization and version
290: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
291: db_ludate, x_custom_mode)) then
292: -- Update translations for this language
293: update FEM_MAP_RULE_TYPES_TL set
294: MAP_RULE_TYPE_NAME = decode(x_MAP_RULE_TYPE_NAME,
295: fnd_load_util.null_value, null, -- Real null
296: null, x_MAP_RULE_TYPE_NAME, -- No change
297: x_MAP_RULE_TYPE_NAME),