APPS.JTF_TASK_DATE_TYPES_PKG dependencies on JTF_TASK_DATE_TYPES_TL

Line 90: insert into JTF_TASK_DATE_TYPES_TL (

86: X_LAST_UPDATE_LOGIN,
87: 1
88: );
89:
90: insert into JTF_TASK_DATE_TYPES_TL (
91: DATE_TYPE_ID,
92: DATE_TYPE,
93: DESCRIPTION,
94: CREATED_BY,

Line 116: from JTF_TASK_DATE_TYPES_TL T

112: from FND_LANGUAGES L
113: where L.INSTALLED_FLAG in ('I', 'B')
114: and not exists
115: (select NULL
116: from JTF_TASK_DATE_TYPES_TL T
117: where T.DATE_TYPE_ID = X_DATE_TYPE_ID
118: and T.LANGUAGE = L.LANGUAGE_CODE);
119:
120: open c;

Line 219: update JTF_TASK_DATE_TYPES_TL set

215: if (sql%notfound) then
216: raise no_data_found;
217: end if;
218:
219: update JTF_TASK_DATE_TYPES_TL set
220: DATE_TYPE = X_DATE_TYPE,
221: DESCRIPTION = X_DESCRIPTION,
222: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
223: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 238: delete from JTF_TASK_DATE_TYPES_TL

234: procedure DELETE_ROW (
235: X_DATE_TYPE_ID in NUMBER
236: ) is
237: begin
238: delete from JTF_TASK_DATE_TYPES_TL
239: where DATE_TYPE_ID = X_DATE_TYPE_ID;
240:
241: if (sql%notfound) then
242: raise no_data_found;

Line 262: delete from JTF_TASK_DATE_TYPES_TL T

258: /* The following delete and update statements are commented out */
259: /* as a quick workaround to fix the time-consuming table handler issue */
260: /*
261:
262: delete from JTF_TASK_DATE_TYPES_TL T
263: where not exists
264: (select NULL
265: from JTF_TASK_DATE_TYPES_B B
266: where B.DATE_TYPE_ID = T.DATE_TYPE_ID

Line 269: update JTF_TASK_DATE_TYPES_TL T set (

265: from JTF_TASK_DATE_TYPES_B B
266: where B.DATE_TYPE_ID = T.DATE_TYPE_ID
267: );
268:
269: update JTF_TASK_DATE_TYPES_TL T set (
270: DATE_TYPE,
271: DESCRIPTION
272: ) = (select
273: B.DATE_TYPE,

Line 275: from JTF_TASK_DATE_TYPES_TL B

271: DESCRIPTION
272: ) = (select
273: B.DATE_TYPE,
274: B.DESCRIPTION
275: from JTF_TASK_DATE_TYPES_TL B
276: where B.DATE_TYPE_ID = T.DATE_TYPE_ID
277: and B.LANGUAGE = T.SOURCE_LANG)
278: where (
279: T.DATE_TYPE_ID,

Line 284: from JTF_TASK_DATE_TYPES_TL SUBB, JTF_TASK_DATE_TYPES_TL SUBT

280: T.LANGUAGE
281: ) in (select
282: SUBT.DATE_TYPE_ID,
283: SUBT.LANGUAGE
284: from JTF_TASK_DATE_TYPES_TL SUBB, JTF_TASK_DATE_TYPES_TL SUBT
285: where SUBB.DATE_TYPE_ID = SUBT.DATE_TYPE_ID
286: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
287: and (SUBB.DATE_TYPE <> SUBT.DATE_TYPE
288: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 293: insert into JTF_TASK_DATE_TYPES_TL (

289: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
290: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
291: )); */
292:
293: insert into JTF_TASK_DATE_TYPES_TL (
294: DATE_TYPE_ID,
295: DATE_TYPE,
296: DESCRIPTION,
297: CREATED_BY,

Line 315: from JTF_TASK_DATE_TYPES_TL B, FND_LANGUAGES L

311: B.LAST_UPDATE_DATE,
312: B.LAST_UPDATE_LOGIN,
313: L.LANGUAGE_CODE,
314: B.SOURCE_LANG
315: from JTF_TASK_DATE_TYPES_TL B, FND_LANGUAGES L
316: where L.INSTALLED_FLAG in ('I', 'B')
317: and B.LANGUAGE = userenv('LANG')
318: and not exists
319: (select NULL

Line 320: from JTF_TASK_DATE_TYPES_TL T

316: where L.INSTALLED_FLAG in ('I', 'B')
317: and B.LANGUAGE = userenv('LANG')
318: and not exists
319: (select NULL
320: from JTF_TASK_DATE_TYPES_TL T
321: where T.DATE_TYPE_ID = B.DATE_TYPE_ID
322: and T.LANGUAGE = L.LANGUAGE_CODE);
323: end ADD_LANGUAGE;
324:

Line 333: update jtf_task_date_types_tl set

329: x_description in varchar2,
330: x_owner in varchar2 )
331: as
332: begin
333: update jtf_task_date_types_tl set
334: date_type = nvl(x_date_type,date_type),
335: description = nvl(x_description,description ),
336: LAST_UPDATE_DATE = sysdate,
337: LAST_UPDATEd_by = decode(x_owner,'SEED',1,0),