APPS.JTF_TASK_TEMP_GROUPS_PKG dependencies on JTF_TASK_TEMP_GROUPS_TL

Line 96: insert into JTF_TASK_TEMP_GROUPS_TL (

92: 1,
93: X_APPLICATION_ID
94: );
95:
96: insert into JTF_TASK_TEMP_GROUPS_TL (
97: TASK_TEMPLATE_GROUP_ID,
98: TEMPLATE_GROUP_NAME,
99: DESCRIPTION,
100: CREATED_BY,

Line 122: from JTF_TASK_TEMP_GROUPS_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_TEMP_GROUPS_TL T
123: where T.TASK_TEMPLATE_GROUP_ID = X_TASK_TEMPLATE_GROUP_ID
124: and T.LANGUAGE = L.LANGUAGE_CODE);
125:
126: open c;

Line 234: update JTF_TASK_TEMP_GROUPS_TL set

230: if (sql%notfound) then
231: raise no_data_found;
232: end if;
233:
234: update JTF_TASK_TEMP_GROUPS_TL set
235: TEMPLATE_GROUP_NAME = X_TEMPLATE_GROUP_NAME,
236: DESCRIPTION = X_DESCRIPTION,
237: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
238: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 253: delete from JTF_TASK_TEMP_GROUPS_TL

249: procedure DELETE_ROW (
250: X_TASK_TEMPLATE_GROUP_ID in NUMBER
251: ) is
252: begin
253: delete from JTF_TASK_TEMP_GROUPS_TL
254: where TASK_TEMPLATE_GROUP_ID = X_TASK_TEMPLATE_GROUP_ID;
255:
256:
257: if (sql%notfound) then

Line 272: delete from JTF_TASK_TEMP_GROUPS_TL T

268:
269: procedure ADD_LANGUAGE
270: is
271: begin
272: delete from JTF_TASK_TEMP_GROUPS_TL T
273: where not exists
274: (select NULL
275: from JTF_TASK_TEMP_GROUPS_B B
276: where B.TASK_TEMPLATE_GROUP_ID = T.TASK_TEMPLATE_GROUP_ID

Line 279: update JTF_TASK_TEMP_GROUPS_TL T set (

275: from JTF_TASK_TEMP_GROUPS_B B
276: where B.TASK_TEMPLATE_GROUP_ID = T.TASK_TEMPLATE_GROUP_ID
277: );
278:
279: update JTF_TASK_TEMP_GROUPS_TL T set (
280: TEMPLATE_GROUP_NAME,
281: DESCRIPTION
282: ) = (select
283: B.TEMPLATE_GROUP_NAME,

Line 285: from JTF_TASK_TEMP_GROUPS_TL B

281: DESCRIPTION
282: ) = (select
283: B.TEMPLATE_GROUP_NAME,
284: B.DESCRIPTION
285: from JTF_TASK_TEMP_GROUPS_TL B
286: where B.TASK_TEMPLATE_GROUP_ID = T.TASK_TEMPLATE_GROUP_ID
287: and B.LANGUAGE = T.SOURCE_LANG)
288: where (
289: T.TASK_TEMPLATE_GROUP_ID,

Line 294: from JTF_TASK_TEMP_GROUPS_TL SUBB, JTF_TASK_TEMP_GROUPS_TL SUBT

290: T.LANGUAGE
291: ) in (select
292: SUBT.TASK_TEMPLATE_GROUP_ID,
293: SUBT.LANGUAGE
294: from JTF_TASK_TEMP_GROUPS_TL SUBB, JTF_TASK_TEMP_GROUPS_TL SUBT
295: where SUBB.TASK_TEMPLATE_GROUP_ID = SUBT.TASK_TEMPLATE_GROUP_ID
296: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
297: and (SUBB.TEMPLATE_GROUP_NAME <> SUBT.TEMPLATE_GROUP_NAME
298: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 303: insert into JTF_TASK_TEMP_GROUPS_TL (

299: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
300: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
301: ));
302:
303: insert into JTF_TASK_TEMP_GROUPS_TL (
304: TASK_TEMPLATE_GROUP_ID,
305: TEMPLATE_GROUP_NAME,
306: DESCRIPTION,
307: CREATED_BY,

Line 314: ) select /*+ INDEX(b JTF_TASK_TEMP_GROUPS_TL_U1) INDEX (l FND_LANGUAGES_N1) */ -- Added Index Hint on 30/05/2006 for bug# 5213367

310: LAST_UPDATE_DATE,
311: LAST_UPDATE_LOGIN,
312: LANGUAGE,
313: SOURCE_LANG
314: ) select /*+ INDEX(b JTF_TASK_TEMP_GROUPS_TL_U1) INDEX (l FND_LANGUAGES_N1) */ -- Added Index Hint on 30/05/2006 for bug# 5213367
315: B.TASK_TEMPLATE_GROUP_ID,
316: B.TEMPLATE_GROUP_NAME,
317: B.DESCRIPTION,
318: B.CREATED_BY,

Line 325: from JTF_TASK_TEMP_GROUPS_TL B, FND_LANGUAGES L

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

Line 330: from JTF_TASK_TEMP_GROUPS_TL T

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

Line 341: update jtf_task_temp_groups_tl set

337: X_TEMPLATE_GROUP_NAME in varchar2,
338: X_DESCRIPTION in varchar2,
339: x_owner in varchar2) is
340: begin
341: update jtf_task_temp_groups_tl set
342: template_group_NAME= nvl(X_template_group_NAME,template_group_NAME),
343: DESCRIPTION= nvl(X_DESCRIPTION,DESCRIPTION),
344: LAST_UPDATE_DATE = sysdate,
345: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),