APPS.FND_PROFILE_CATS_PKG dependencies on FND_PROFILE_CATS_TL

Line 41: insert into FND_PROFILE_CATS_TL (

37: X_LAST_UPDATED_BY,
38: X_LAST_UPDATE_LOGIN
39: );
40:
41: insert into FND_PROFILE_CATS_TL (
42: DISPLAY_NAME,
43: NAME,
44: APPLICATION_ID,
45: CREATED_BY,

Line 69: from FND_PROFILE_CATS_TL T

65: from FND_LANGUAGES L
66: where L.INSTALLED_FLAG in ('I', 'B')
67: and not exists
68: (select NULL
69: from FND_PROFILE_CATS_TL T
70: where T.NAME = upper(X_NAME)
71: and T.APPLICATION_ID = X_APPLICATION_ID
72: and T.LANGUAGE = L.LANGUAGE_CODE);
73:

Line 103: from FND_PROFILE_CATS_TL

99: cursor c1 is select
100: DISPLAY_NAME,
101: DESCRIPTION,
102: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
103: from FND_PROFILE_CATS_TL
104: where NAME = X_NAME
105: and APPLICATION_ID = X_APPLICATION_ID
106: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
107: for update of NAME nowait;

Line 166: update FND_PROFILE_CATS_TL set

162: if (sql%notfound) then
163: raise no_data_found;
164: end if;
165:
166: update FND_PROFILE_CATS_TL set
167: DISPLAY_NAME = X_DISPLAY_NAME,
168: DESCRIPTION = X_DESCRIPTION,
169: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
170: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 187: delete from FND_PROFILE_CATS_TL

183: X_NAME in VARCHAR2,
184: X_APPLICATION_ID in NUMBER
185: ) is
186: begin
187: delete from FND_PROFILE_CATS_TL
188: where NAME = upper(X_NAME)
189: and APPLICATION_ID = X_APPLICATION_ID;
190:
191: if (sql%notfound) then

Line 212: delete from FND_PROFILE_CATS_TL T

208:
209: procedure ADD_LANGUAGE
210: is
211: begin
212: delete from FND_PROFILE_CATS_TL T
213: where not exists
214: (select NULL
215: from FND_PROFILE_CATS B
216: where B.NAME = T.NAME

Line 220: update FND_PROFILE_CATS_TL T set (

216: where B.NAME = T.NAME
217: and B.APPLICATION_ID = T.APPLICATION_ID
218: );
219:
220: update FND_PROFILE_CATS_TL T set (
221: DISPLAY_NAME,
222: DESCRIPTION
223: ) = (select
224: B.DISPLAY_NAME,

Line 226: from FND_PROFILE_CATS_TL B

222: DESCRIPTION
223: ) = (select
224: B.DISPLAY_NAME,
225: B.DESCRIPTION
226: from FND_PROFILE_CATS_TL B
227: where B.NAME = T.NAME
228: and B.APPLICATION_ID = T.APPLICATION_ID
229: and B.LANGUAGE = T.SOURCE_LANG)
230: where (

Line 238: from FND_PROFILE_CATS_TL SUBB, FND_PROFILE_CATS_TL SUBT

234: ) in (select
235: SUBT.NAME,
236: SUBT.APPLICATION_ID,
237: SUBT.LANGUAGE
238: from FND_PROFILE_CATS_TL SUBB, FND_PROFILE_CATS_TL SUBT
239: where SUBB.NAME = SUBT.NAME
240: and SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
241: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
242: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME

Line 250: insert into FND_PROFILE_CATS_TL (

246: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
247: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
248: ));
249:
250: insert into FND_PROFILE_CATS_TL (
251: DISPLAY_NAME,
252: NAME,
253: APPLICATION_ID,
254: CREATED_BY,

Line 274: from FND_PROFILE_CATS_TL B, FND_LANGUAGES L

270: B.LAST_UPDATE_LOGIN,
271: B.DESCRIPTION,
272: L.LANGUAGE_CODE,
273: B.SOURCE_LANG
274: from FND_PROFILE_CATS_TL B, FND_LANGUAGES L
275: where L.INSTALLED_FLAG in ('I', 'B')
276: and B.LANGUAGE = userenv('LANG')
277: and not exists
278: (select NULL

Line 279: from FND_PROFILE_CATS_TL T

275: where L.INSTALLED_FLAG in ('I', 'B')
276: and B.LANGUAGE = userenv('LANG')
277: and not exists
278: (select NULL
279: from FND_PROFILE_CATS_TL T
280: where T.NAME = B.NAME
281: and T.APPLICATION_ID = B.APPLICATION_ID
282: and T.LANGUAGE = L.LANGUAGE_CODE);
283: end ADD_LANGUAGE;

Line 315: from FND_PROFILE_CATS_TL

311:
312: begin
313: select LAST_UPDATED_BY, LAST_UPDATE_DATE
314: into db_luby, db_ludate
315: from FND_PROFILE_CATS_TL
316: where NAME = upper(x_name)
317: and APPLICATION_ID = x_appl_id
318: and LANGUAGE = userenv('LANG');
319:

Line 323: update FND_PROFILE_CATS_TL set

319:
320: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
321: db_ludate, X_CUSTOM_MODE)) then
322:
323: update FND_PROFILE_CATS_TL set
324: DESCRIPTION = X_DESCRIPTION,
325: DISPLAY_NAME = X_DISPLAY_NAME,
326: LAST_UPDATE_DATE = f_ludate,
327: LAST_UPDATED_BY = f_luby,