APPS.FRM_GLB_TEMPLATE_ALIASES_PKG dependencies on FRM_GLB_TEMPLATE_ALIASES_TL

Line 36: insert into FRM_GLB_TEMPLATE_ALIASES_TL (

32: X_LAST_UPDATED_BY,
33: X_LAST_UPDATE_LOGIN
34: );
35:
36: insert into FRM_GLB_TEMPLATE_ALIASES_TL (
37: ELEMENT_NAME,
38: USER_NAME,
39: CREATION_DATE,
40: CREATED_BY,

Line 60: from FRM_GLB_TEMPLATE_ALIASES_TL T

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

Line 89: from FRM_GLB_TEMPLATE_ALIASES_TL

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

Line 144: update FRM_GLB_TEMPLATE_ALIASES_TL set

140: if (sql%notfound) then
141: raise no_data_found;
142: end if;
143:
144: update FRM_GLB_TEMPLATE_ALIASES_TL set
145: USER_NAME = X_USER_NAME,
146: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
147: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
148: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 162: delete from FRM_GLB_TEMPLATE_ALIASES_TL

158: procedure DELETE_ROW (
159: X_ELEMENT_NAME in VARCHAR2
160: ) is
161: begin
162: delete from FRM_GLB_TEMPLATE_ALIASES_TL
163: where ELEMENT_NAME = X_ELEMENT_NAME;
164:
165: if (sql%notfound) then
166: raise no_data_found;

Line 180: delete from FRM_GLB_TEMPLATE_ALIASES_TL T

176:
177: procedure ADD_LANGUAGE
178: is
179: begin
180: delete from FRM_GLB_TEMPLATE_ALIASES_TL T
181: where not exists
182: (select NULL
183: from FRM_GLB_TEMPLATE_ALIASES_B B
184: where B.ELEMENT_NAME = T.ELEMENT_NAME

Line 187: update FRM_GLB_TEMPLATE_ALIASES_TL T set (

183: from FRM_GLB_TEMPLATE_ALIASES_B B
184: where B.ELEMENT_NAME = T.ELEMENT_NAME
185: );
186:
187: update FRM_GLB_TEMPLATE_ALIASES_TL T set (
188: USER_NAME
189: ) = (select
190: B.USER_NAME
191: from FRM_GLB_TEMPLATE_ALIASES_TL B

Line 191: from FRM_GLB_TEMPLATE_ALIASES_TL B

187: update FRM_GLB_TEMPLATE_ALIASES_TL T set (
188: USER_NAME
189: ) = (select
190: B.USER_NAME
191: from FRM_GLB_TEMPLATE_ALIASES_TL B
192: where B.ELEMENT_NAME = T.ELEMENT_NAME
193: and B.LANGUAGE = T.SOURCE_LANG)
194: where (
195: T.ELEMENT_NAME,

Line 200: from FRM_GLB_TEMPLATE_ALIASES_TL SUBB, FRM_GLB_TEMPLATE_ALIASES_TL SUBT

196: T.LANGUAGE
197: ) in (select
198: SUBT.ELEMENT_NAME,
199: SUBT.LANGUAGE
200: from FRM_GLB_TEMPLATE_ALIASES_TL SUBB, FRM_GLB_TEMPLATE_ALIASES_TL SUBT
201: where SUBB.ELEMENT_NAME = SUBT.ELEMENT_NAME
202: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
203: and (SUBB.USER_NAME <> SUBT.USER_NAME
204: ));

Line 206: insert into FRM_GLB_TEMPLATE_ALIASES_TL (

202: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
203: and (SUBB.USER_NAME <> SUBT.USER_NAME
204: ));
205:
206: insert into FRM_GLB_TEMPLATE_ALIASES_TL (
207: ELEMENT_NAME,
208: USER_NAME,
209: CREATION_DATE,
210: CREATED_BY,

Line 226: from FRM_GLB_TEMPLATE_ALIASES_TL B, FND_LANGUAGES L

222: B.LAST_UPDATE_LOGIN,
223: B.LAST_UPDATE_DATE,
224: L.LANGUAGE_CODE,
225: B.SOURCE_LANG
226: from FRM_GLB_TEMPLATE_ALIASES_TL B, FND_LANGUAGES L
227: where L.INSTALLED_FLAG in ('I', 'B')
228: and B.LANGUAGE = userenv('LANG')
229: and not exists
230: (select NULL

Line 231: from FRM_GLB_TEMPLATE_ALIASES_TL T

227: where L.INSTALLED_FLAG in ('I', 'B')
228: and B.LANGUAGE = userenv('LANG')
229: and not exists
230: (select NULL
231: from FRM_GLB_TEMPLATE_ALIASES_TL T
232: where T.ELEMENT_NAME = B.ELEMENT_NAME
233: and T.LANGUAGE = L.LANGUAGE_CODE);
234: end ADD_LANGUAGE;
235:

Line 342: from FRM_GLB_TEMPLATE_ALIASES_TL

338: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
339: begin
340: select LAST_UPDATED_BY, LAST_UPDATE_DATE
341: into db_luby, db_ludate
342: from FRM_GLB_TEMPLATE_ALIASES_TL
343: where ELEMENT_NAME = x_element_name
344: and LANGUAGE = userenv('LANG');
345:
346: -- Test for customization and version

Line 350: update FRM_GLB_TEMPLATE_ALIASES_TL

346: -- Test for customization and version
347: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
348: db_ludate, x_custom_mode)) then
349:
350: update FRM_GLB_TEMPLATE_ALIASES_TL
351: set USER_NAME = x_user_name,
352: LAST_UPDATE_DATE = f_ludate,
353: LAST_UPDATED_BY = f_luby,
354: LAST_UPDATE_LOGIN = 0,