APPS.JTF_TASK_REFERENCES_PKG dependencies on JTF_TASK_REFERENCES_TL

Line 102: insert into JTF_TASK_REFERENCES_TL (

98: X_LAST_UPDATE_LOGIN,
99: 1
100: );
101:
102: insert into JTF_TASK_REFERENCES_TL (
103: TASK_REFERENCE_ID,
104: USAGE,
105: CREATED_BY,
106: CREATION_DATE,

Line 126: from JTF_TASK_REFERENCES_TL T

122: from FND_LANGUAGES L
123: where L.INSTALLED_FLAG in ('I', 'B')
124: and not exists
125: (select NULL
126: from JTF_TASK_REFERENCES_TL T
127: where T.TASK_REFERENCE_ID = X_TASK_REFERENCE_ID
128: and T.LANGUAGE = L.LANGUAGE_CODE);
129:
130: open c;

Line 236: update JTF_TASK_REFERENCES_TL set

232: if (sql%notfound) then
233: raise no_data_found;
234: end if;
235:
236: update JTF_TASK_REFERENCES_TL set
237: USAGE = X_USAGE,
238: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
239: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
240: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 254: delete from JTF_TASK_REFERENCES_TL

250: procedure DELETE_ROW (
251: X_TASK_REFERENCE_ID in NUMBER
252: ) is
253: begin
254: delete from JTF_TASK_REFERENCES_TL
255: where TASK_REFERENCE_ID = X_TASK_REFERENCE_ID;
256:
257: if (sql%notfound) then
258: raise no_data_found;

Line 278: delete from JTF_TASK_REFERENCES_TL T

274: /* The following delete and update statements are commented out */
275: /* as a quick workaround to fix the time-consuming table handler issue */
276: /*
277:
278: delete from JTF_TASK_REFERENCES_TL T
279: where not exists
280: (select NULL
281: from JTF_TASK_REFERENCES_B B
282: where B.TASK_REFERENCE_ID = T.TASK_REFERENCE_ID

Line 285: update JTF_TASK_REFERENCES_TL T set (

281: from JTF_TASK_REFERENCES_B B
282: where B.TASK_REFERENCE_ID = T.TASK_REFERENCE_ID
283: );
284:
285: update JTF_TASK_REFERENCES_TL T set (
286: USAGE
287: ) = (select
288: B.USAGE
289: from JTF_TASK_REFERENCES_TL B

Line 289: from JTF_TASK_REFERENCES_TL B

285: update JTF_TASK_REFERENCES_TL T set (
286: USAGE
287: ) = (select
288: B.USAGE
289: from JTF_TASK_REFERENCES_TL B
290: where B.TASK_REFERENCE_ID = T.TASK_REFERENCE_ID
291: and B.LANGUAGE = T.SOURCE_LANG)
292: where (
293: T.TASK_REFERENCE_ID,

Line 298: from JTF_TASK_REFERENCES_TL SUBB, JTF_TASK_REFERENCES_TL SUBT

294: T.LANGUAGE
295: ) in (select
296: SUBT.TASK_REFERENCE_ID,
297: SUBT.LANGUAGE
298: from JTF_TASK_REFERENCES_TL SUBB, JTF_TASK_REFERENCES_TL SUBT
299: where SUBB.TASK_REFERENCE_ID = SUBT.TASK_REFERENCE_ID
300: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
301: and (SUBB.USAGE <> SUBT.USAGE
302: or (SUBB.USAGE is null and SUBT.USAGE is not null)

Line 309: insert into JTF_TASK_REFERENCES_TL (

305: */
306:
307: -- Added hint 'parallel' by SBARAT on 19/01/2006 for perf bug# 4888496
308:
309: insert into JTF_TASK_REFERENCES_TL (
310: TASK_REFERENCE_ID,
311: USAGE,
312: CREATED_BY,
313: CREATION_DATE,

Line 329: from JTF_TASK_REFERENCES_TL B, FND_LANGUAGES L

325: B.LAST_UPDATE_DATE,
326: B.LAST_UPDATE_LOGIN,
327: L.LANGUAGE_CODE,
328: B.SOURCE_LANG
329: from JTF_TASK_REFERENCES_TL B, FND_LANGUAGES L
330: where L.INSTALLED_FLAG in ('I', 'B')
331: and B.LANGUAGE = userenv('LANG')
332: and not exists
333: (select /*+ parallel(T) */ NULL

Line 334: from JTF_TASK_REFERENCES_TL T

330: where L.INSTALLED_FLAG in ('I', 'B')
331: and B.LANGUAGE = userenv('LANG')
332: and not exists
333: (select /*+ parallel(T) */ NULL
334: from JTF_TASK_REFERENCES_TL T
335: where T.TASK_REFERENCE_ID = B.TASK_REFERENCE_ID
336: and T.LANGUAGE = L.LANGUAGE_CODE);
337: end ADD_LANGUAGE;
338:

Line 345: update jtf_task_references_tl set

341: x_usage in varchar2,
342: x_owner in varchar2 )
343: as
344: begin
345: update jtf_task_references_tl set
346: usage = nvl(X_usage,usage),
347: LAST_UPDATE_DATE = sysdate,
348: LAST_UPDATEd_by = decode(x_owner,'SEED',1,0),
349: LAST_UPDATE_LOGIN = 0,