APPS.FEM_APPLICATION_GROUPS_PKG dependencies on FEM_APPLICATION_GROUPS_TL

Line 34: insert into FEM_APPLICATION_GROUPS_TL (

30: X_LAST_UPDATED_BY,
31: X_LAST_UPDATE_LOGIN
32: );
33:
34: insert into FEM_APPLICATION_GROUPS_TL (
35: LAST_UPDATE_DATE,
36: LAST_UPDATE_LOGIN,
37: APPLICATION_GROUP_NAME,
38: DESCRIPTION,

Line 60: from FEM_APPLICATION_GROUPS_TL T

56: from FND_LANGUAGES L
57: where L.INSTALLED_FLAG in ('I', 'B')
58: and not exists
59: (select NULL
60: from FEM_APPLICATION_GROUPS_TL T
61: where T.APPLICATION_GROUP_ID = X_APPLICATION_GROUP_ID
62: and T.LANGUAGE = L.LANGUAGE_CODE);
63:
64: open c;

Line 89: from FEM_APPLICATION_GROUPS_TL

85: cursor c1 is select
86: APPLICATION_GROUP_NAME,
87: DESCRIPTION,
88: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
89: from FEM_APPLICATION_GROUPS_TL
90: where APPLICATION_GROUP_ID = X_APPLICATION_GROUP_ID
91: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
92: for update of APPLICATION_GROUP_ID nowait;
93: begin

Line 138: update FEM_APPLICATION_GROUPS_TL set

134: if (sql%notfound) then
135: raise no_data_found;
136: end if;
137:
138: update FEM_APPLICATION_GROUPS_TL set
139: APPLICATION_GROUP_NAME = X_APPLICATION_GROUP_NAME,
140: DESCRIPTION = X_DESCRIPTION,
141: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
142: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 157: delete from FEM_APPLICATION_GROUPS_TL

153: procedure DELETE_ROW (
154: X_APPLICATION_GROUP_ID in NUMBER
155: ) is
156: begin
157: delete from FEM_APPLICATION_GROUPS_TL
158: where APPLICATION_GROUP_ID = X_APPLICATION_GROUP_ID;
159:
160: if (sql%notfound) then
161: raise no_data_found;

Line 175: delete from FEM_APPLICATION_GROUPS_TL T

171:
172: procedure ADD_LANGUAGE
173: is
174: begin
175: delete from FEM_APPLICATION_GROUPS_TL T
176: where not exists
177: (select NULL
178: from FEM_APPLICATION_GROUPS_B B
179: where B.APPLICATION_GROUP_ID = T.APPLICATION_GROUP_ID

Line 182: update FEM_APPLICATION_GROUPS_TL T set (

178: from FEM_APPLICATION_GROUPS_B B
179: where B.APPLICATION_GROUP_ID = T.APPLICATION_GROUP_ID
180: );
181:
182: update FEM_APPLICATION_GROUPS_TL T set (
183: APPLICATION_GROUP_NAME,
184: DESCRIPTION
185: ) = (select
186: B.APPLICATION_GROUP_NAME,

Line 188: from FEM_APPLICATION_GROUPS_TL B

184: DESCRIPTION
185: ) = (select
186: B.APPLICATION_GROUP_NAME,
187: B.DESCRIPTION
188: from FEM_APPLICATION_GROUPS_TL B
189: where B.APPLICATION_GROUP_ID = T.APPLICATION_GROUP_ID
190: and B.LANGUAGE = T.SOURCE_LANG)
191: where (
192: T.APPLICATION_GROUP_ID,

Line 197: from FEM_APPLICATION_GROUPS_TL SUBB, FEM_APPLICATION_GROUPS_TL SUBT

193: T.LANGUAGE
194: ) in (select
195: SUBT.APPLICATION_GROUP_ID,
196: SUBT.LANGUAGE
197: from FEM_APPLICATION_GROUPS_TL SUBB, FEM_APPLICATION_GROUPS_TL SUBT
198: where SUBB.APPLICATION_GROUP_ID = SUBT.APPLICATION_GROUP_ID
199: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
200: and (SUBB.APPLICATION_GROUP_NAME <> SUBT.APPLICATION_GROUP_NAME
201: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 206: insert into FEM_APPLICATION_GROUPS_TL (

202: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
203: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
204: ));
205:
206: insert into FEM_APPLICATION_GROUPS_TL (
207: LAST_UPDATE_DATE,
208: LAST_UPDATE_LOGIN,
209: APPLICATION_GROUP_NAME,
210: DESCRIPTION,

Line 228: from FEM_APPLICATION_GROUPS_TL B, FND_LANGUAGES L

224: B.LAST_UPDATED_BY,
225: B.APPLICATION_GROUP_ID,
226: L.LANGUAGE_CODE,
227: B.SOURCE_LANG
228: from FEM_APPLICATION_GROUPS_TL B, FND_LANGUAGES L
229: where L.INSTALLED_FLAG in ('I', 'B')
230: and B.LANGUAGE = userenv('LANG')
231: and not exists
232: (select NULL

Line 233: from FEM_APPLICATION_GROUPS_TL T

229: where L.INSTALLED_FLAG in ('I', 'B')
230: and B.LANGUAGE = userenv('LANG')
231: and not exists
232: (select NULL
233: from FEM_APPLICATION_GROUPS_TL T
234: where T.APPLICATION_GROUP_ID = B.APPLICATION_GROUP_ID
235: and T.LANGUAGE = L.LANGUAGE_CODE);
236: end ADD_LANGUAGE;
237: PROCEDURE TRANSLATE_ROW(

Line 263: from FEM_APPLICATION_GROUPS_TL

259: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
260: begin
261: select LAST_UPDATED_BY, LAST_UPDATE_DATE
262: into db_luby, db_ludate
263: from FEM_APPLICATION_GROUPS_TL
264: where APPLICATION_GROUP_ID = x_APPLICATION_GROUP_ID
265: and LANGUAGE = userenv('LANG');
266:
267: -- Test for customization and version

Line 271: update FEM_APPLICATION_GROUPS_TL set

267: -- Test for customization and version
268: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
269: db_ludate, x_custom_mode)) then
270: -- Update translations for this language
271: update FEM_APPLICATION_GROUPS_TL set
272: APPLICATION_GROUP_NAME = decode(x_APPLICATION_GROUP_NAME,
273: fnd_load_util.null_value, null, -- Real null
274: null, x_APPLICATION_GROUP_NAME, -- No change
275: x_APPLICATION_GROUP_NAME),