APPS.JTF_TASK_TEMPLATES_PKG dependencies on JTF_TASK_TEMPLATES_TL

Line 168: insert into JTF_TASK_TEMPLATES_TL (

164: X_LAST_UPDATE_LOGIN,
165: 1
166: );
167:
168: insert into JTF_TASK_TEMPLATES_TL (
169: TASK_TEMPLATE_ID,
170: TASK_NAME,
171: DESCRIPTION,
172: CREATED_BY,

Line 194: from JTF_TASK_TEMPLATES_TL T

190: from FND_LANGUAGES L
191: where L.INSTALLED_FLAG in ('I', 'B')
192: and not exists
193: (select NULL
194: from JTF_TASK_TEMPLATES_TL T
195: where T.TASK_TEMPLATE_ID = X_TASK_TEMPLATE_ID
196: and T.LANGUAGE = L.LANGUAGE_CODE);
197:
198: open c;

Line 349: update JTF_TASK_TEMPLATES_TL set

345: if (sql%notfound) then
346: raise no_data_found;
347: end if;
348:
349: update JTF_TASK_TEMPLATES_TL set
350: TASK_NAME = X_TASK_NAME,
351: DESCRIPTION = X_DESCRIPTION,
352: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
353: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 368: delete from JTF_TASK_TEMPLATES_TL

364: procedure DELETE_ROW (
365: X_TASK_TEMPLATE_ID in NUMBER
366: ) is
367: begin
368: delete from JTF_TASK_TEMPLATES_TL
369: where TASK_TEMPLATE_ID = X_TASK_TEMPLATE_ID;
370:
371: if (sql%notfound) then
372: raise no_data_found;

Line 392: delete from JTF_TASK_TEMPLATES_TL T

388: /* The following delete and update statements are commented out */
389: /* as a quick workaround to fix the time-consuming table handler issue */
390: /*
391:
392: delete from JTF_TASK_TEMPLATES_TL T
393: where not exists
394: (select NULL
395: from JTF_TASK_TEMPLATES_B B
396: where B.TASK_TEMPLATE_ID = T.TASK_TEMPLATE_ID

Line 399: update JTF_TASK_TEMPLATES_TL T set (

395: from JTF_TASK_TEMPLATES_B B
396: where B.TASK_TEMPLATE_ID = T.TASK_TEMPLATE_ID
397: );
398:
399: update JTF_TASK_TEMPLATES_TL T set (
400: TASK_NAME,
401: DESCRIPTION
402: ) = (select
403: B.TASK_NAME,

Line 405: from JTF_TASK_TEMPLATES_TL B

401: DESCRIPTION
402: ) = (select
403: B.TASK_NAME,
404: B.DESCRIPTION
405: from JTF_TASK_TEMPLATES_TL B
406: where B.TASK_TEMPLATE_ID = T.TASK_TEMPLATE_ID
407: and B.LANGUAGE = T.SOURCE_LANG)
408: where (
409: T.TASK_TEMPLATE_ID,

Line 414: from JTF_TASK_TEMPLATES_TL SUBB, JTF_TASK_TEMPLATES_TL SUBT

410: T.LANGUAGE
411: ) in (select
412: SUBT.TASK_TEMPLATE_ID,
413: SUBT.LANGUAGE
414: from JTF_TASK_TEMPLATES_TL SUBB, JTF_TASK_TEMPLATES_TL SUBT
415: where SUBB.TASK_TEMPLATE_ID = SUBT.TASK_TEMPLATE_ID
416: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
417: and (SUBB.TASK_NAME <> SUBT.TASK_NAME
418: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 423: insert into JTF_TASK_TEMPLATES_TL (

419: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
420: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
421: )); */
422:
423: insert into JTF_TASK_TEMPLATES_TL (
424: TASK_TEMPLATE_ID,
425: TASK_NAME,
426: DESCRIPTION,
427: CREATED_BY,

Line 445: from JTF_TASK_TEMPLATES_TL B, FND_LANGUAGES L

441: B.LAST_UPDATE_DATE,
442: B.LAST_UPDATE_LOGIN,
443: L.LANGUAGE_CODE,
444: B.SOURCE_LANG
445: from JTF_TASK_TEMPLATES_TL B, FND_LANGUAGES L
446: where L.INSTALLED_FLAG in ('I', 'B')
447: and B.LANGUAGE = userenv('LANG')
448: and not exists
449: (select NULL

Line 450: from JTF_TASK_TEMPLATES_TL T

446: where L.INSTALLED_FLAG in ('I', 'B')
447: and B.LANGUAGE = userenv('LANG')
448: and not exists
449: (select NULL
450: from JTF_TASK_TEMPLATES_TL T
451: where T.TASK_TEMPLATE_ID = B.TASK_TEMPLATE_ID
452: and T.LANGUAGE = L.LANGUAGE_CODE);
453: end ADD_LANGUAGE;
454:

Line 461: update jtf_task_templates_tl set

457: X_task_NAME in varchar2,
458: X_DESCRIPTION in varchar2,
459: x_owner in varchar2) is
460: begin
461: update jtf_task_templates_tl set
462: task_NAME = nvl(X_task_NAME,task_name),
463: DESCRIPTION = nvl(X_DESCRIPTION,description),
464: LAST_UPDATE_DATE = sysdate,
465: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),