APPS.JTF_TASK_PRIORITIES_PKG dependencies on JTF_TASK_PRIORITIES_TL

Line 96: insert into JTF_TASK_PRIORITIES_TL (

92: X_LAST_UPDATE_LOGIN,
93: 1
94: );
95:
96: insert into JTF_TASK_PRIORITIES_TL (
97: TASK_PRIORITY_ID,
98: NAME,
99: DESCRIPTION,
100: CREATED_BY,

Line 122: from JTF_TASK_PRIORITIES_TL T

118: from FND_LANGUAGES L
119: where L.INSTALLED_FLAG in ('I', 'B')
120: and not exists
121: (select NULL
122: from JTF_TASK_PRIORITIES_TL T
123: where T.TASK_PRIORITY_ID = X_TASK_PRIORITY_ID
124: and T.LANGUAGE = L.LANGUAGE_CODE);
125:
126: open c;

Line 229: update JTF_TASK_PRIORITIES_TL set

225: if (sql%notfound) then
226: raise no_data_found;
227: end if;
228:
229: update JTF_TASK_PRIORITIES_TL set
230: NAME = X_NAME,
231: DESCRIPTION = X_DESCRIPTION,
232: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
233: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 248: delete from JTF_TASK_PRIORITIES_TL

244: procedure DELETE_ROW (
245: X_TASK_PRIORITY_ID in NUMBER
246: ) is
247: begin
248: delete from JTF_TASK_PRIORITIES_TL
249: where TASK_PRIORITY_ID = X_TASK_PRIORITY_ID;
250:
251: if (sql%notfound) then
252: raise no_data_found;

Line 271: delete from JTF_TASK_PRIORITIES_TL T

267: /* Solving Perf. Bug 3723927*/
268: /* The following delete and update statements are commented out */
269: /* as a quick workaround to fix the time-consuming table handler issue */
270: /*
271: delete from JTF_TASK_PRIORITIES_TL T
272: where not exists
273: (select NULL
274: from JTF_TASK_PRIORITIES_B B
275: where B.TASK_PRIORITY_ID = T.TASK_PRIORITY_ID

Line 278: update JTF_TASK_PRIORITIES_TL T set (

274: from JTF_TASK_PRIORITIES_B B
275: where B.TASK_PRIORITY_ID = T.TASK_PRIORITY_ID
276: );
277:
278: update JTF_TASK_PRIORITIES_TL T set (
279: NAME,
280: DESCRIPTION
281: ) = (select
282: B.NAME,

Line 284: from JTF_TASK_PRIORITIES_TL B

280: DESCRIPTION
281: ) = (select
282: B.NAME,
283: B.DESCRIPTION
284: from JTF_TASK_PRIORITIES_TL B
285: where B.TASK_PRIORITY_ID = T.TASK_PRIORITY_ID
286: and B.LANGUAGE = T.SOURCE_LANG)
287: where (
288: T.TASK_PRIORITY_ID,

Line 293: from JTF_TASK_PRIORITIES_TL SUBB, JTF_TASK_PRIORITIES_TL SUBT

289: T.LANGUAGE
290: ) in (select
291: SUBT.TASK_PRIORITY_ID,
292: SUBT.LANGUAGE
293: from JTF_TASK_PRIORITIES_TL SUBB, JTF_TASK_PRIORITIES_TL SUBT
294: where SUBB.TASK_PRIORITY_ID = SUBT.TASK_PRIORITY_ID
295: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
296: and (SUBB.NAME <> SUBT.NAME
297: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 302: insert into JTF_TASK_PRIORITIES_TL (

298: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
299: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
300: ));
301: */
302: insert into JTF_TASK_PRIORITIES_TL (
303: TASK_PRIORITY_ID,
304: NAME,
305: DESCRIPTION,
306: CREATED_BY,

Line 313: ) select /*+ INDEX(b JTF_TASK_PRIORITIES_TL_U1) INDEX (l FND_LANGUAGES_N1) */ -- Added index hint for bug# 5213367 on 30/05/2006

309: LAST_UPDATE_DATE,
310: LAST_UPDATE_LOGIN,
311: LANGUAGE,
312: SOURCE_LANG
313: ) select /*+ INDEX(b JTF_TASK_PRIORITIES_TL_U1) INDEX (l FND_LANGUAGES_N1) */ -- Added index hint for bug# 5213367 on 30/05/2006
314: B.TASK_PRIORITY_ID,
315: B.NAME,
316: B.DESCRIPTION,
317: B.CREATED_BY,

Line 324: from JTF_TASK_PRIORITIES_TL B, FND_LANGUAGES L

320: B.LAST_UPDATE_DATE,
321: B.LAST_UPDATE_LOGIN,
322: L.LANGUAGE_CODE,
323: B.SOURCE_LANG
324: from JTF_TASK_PRIORITIES_TL B, FND_LANGUAGES L
325: where L.INSTALLED_FLAG in ('I', 'B')
326: and B.LANGUAGE = userenv('LANG')
327: and not exists
328: (select NULL

Line 329: from JTF_TASK_PRIORITIES_TL T

325: where L.INSTALLED_FLAG in ('I', 'B')
326: and B.LANGUAGE = userenv('LANG')
327: and not exists
328: (select NULL
329: from JTF_TASK_PRIORITIES_TL T
330: where T.TASK_PRIORITY_ID = B.TASK_PRIORITY_ID
331: and T.LANGUAGE = L.LANGUAGE_CODE);
332: end ADD_LANGUAGE;
333:

Line 345: update jtf_task_priorities_tl set

341: IF x_owner = 'SEED'
342: THEN
343: l_user_id := 1;
344: END IF;
345: update jtf_task_priorities_tl set
346: NAME= nvl(X_NAME,name),
347: DESCRIPTION= nvl(X_DESCRIPTION,description),
348: LAST_UPDATE_DATE = sysdate,
349: LAST_UPDATE_LOGIN = 0,

Line 422: update JTF_TASK_PRIORITIES_TL set

418: LAST_UPDATE_LOGIN = 0
419: where TASK_PRIORITY_ID = X_TASK_PRIORITY_ID ;
420:
421:
422: update JTF_TASK_PRIORITIES_TL set
423: NAME = X_NAME,
424: DESCRIPTION = X_DESCRIPTION,
425: LAST_UPDATE_DATE = sysdate,
426: LAST_UPDATED_BY = l_user_id,