APPS.CUG_TSK_TYP_ATTR_DEPS_PKG dependencies on CUG_TSK_TYP_ATTR_DEPS_TL

Line 102: insert into CUG_TSK_TYP_ATTR_DEPS_TL (

98: X_LAST_UPDATED_BY,
99: X_LAST_UPDATE_LOGIN
100: );
101:
102: insert into CUG_TSK_TYP_ATTR_DEPS_TL (
103: TSK_TYP_ATTR_DEP_ID,
104: CREATED_BY,
105: CREATION_DATE,
106: LAST_UPDATED_BY,

Line 126: from CUG_TSK_TYP_ATTR_DEPS_TL T

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

Line 199: from CUG_TSK_TYP_ATTR_DEPS_TL

195:
196: cursor c1 is select
197: SR_ATTRIBUTE_VALUE,
198: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
199: from CUG_TSK_TYP_ATTR_DEPS_TL
200: where TSK_TYP_ATTR_DEP_ID = X_TSK_TYP_ATTR_DEP_ID
201: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
202: for update of TSK_TYP_ATTR_DEP_ID nowait;
203: begin

Line 342: update CUG_TSK_TYP_ATTR_DEPS_TL set

338: if (sql%notfound) then
339: raise no_data_found;
340: end if;
341:
342: update CUG_TSK_TYP_ATTR_DEPS_TL set
343: SR_ATTRIBUTE_VALUE = X_SR_ATTRIBUTE_VALUE,
344: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
345: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
346: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 360: delete from CUG_TSK_TYP_ATTR_DEPS_TL

356: procedure DELETE_ROW (
357: X_TSK_TYP_ATTR_DEP_ID in NUMBER
358: ) is
359: begin
360: delete from CUG_TSK_TYP_ATTR_DEPS_TL
361: where TSK_TYP_ATTR_DEP_ID = X_TSK_TYP_ATTR_DEP_ID;
362:
363: if (sql%notfound) then
364: raise no_data_found;

Line 378: delete from CUG_TSK_TYP_ATTR_DEPS_TL T

374:
375: procedure ADD_LANGUAGE
376: is
377: begin
378: delete from CUG_TSK_TYP_ATTR_DEPS_TL T
379: where not exists
380: (select NULL
381: from CUG_TSK_TYP_ATTR_DEPS_B B
382: where B.TSK_TYP_ATTR_DEP_ID = T.TSK_TYP_ATTR_DEP_ID

Line 385: update CUG_TSK_TYP_ATTR_DEPS_TL T set (

381: from CUG_TSK_TYP_ATTR_DEPS_B B
382: where B.TSK_TYP_ATTR_DEP_ID = T.TSK_TYP_ATTR_DEP_ID
383: );
384:
385: update CUG_TSK_TYP_ATTR_DEPS_TL T set (
386: SR_ATTRIBUTE_VALUE
387: ) = (select
388: B.SR_ATTRIBUTE_VALUE
389: from CUG_TSK_TYP_ATTR_DEPS_TL B

Line 389: from CUG_TSK_TYP_ATTR_DEPS_TL B

385: update CUG_TSK_TYP_ATTR_DEPS_TL T set (
386: SR_ATTRIBUTE_VALUE
387: ) = (select
388: B.SR_ATTRIBUTE_VALUE
389: from CUG_TSK_TYP_ATTR_DEPS_TL B
390: where B.TSK_TYP_ATTR_DEP_ID = T.TSK_TYP_ATTR_DEP_ID
391: and B.LANGUAGE = T.SOURCE_LANG)
392: where (
393: T.TSK_TYP_ATTR_DEP_ID,

Line 398: from CUG_TSK_TYP_ATTR_DEPS_TL SUBB, CUG_TSK_TYP_ATTR_DEPS_TL SUBT

394: T.LANGUAGE
395: ) in (select
396: SUBT.TSK_TYP_ATTR_DEP_ID,
397: SUBT.LANGUAGE
398: from CUG_TSK_TYP_ATTR_DEPS_TL SUBB, CUG_TSK_TYP_ATTR_DEPS_TL SUBT
399: where SUBB.TSK_TYP_ATTR_DEP_ID = SUBT.TSK_TYP_ATTR_DEP_ID
400: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
401: and (SUBB.SR_ATTRIBUTE_VALUE <> SUBT.SR_ATTRIBUTE_VALUE
402: or (SUBB.SR_ATTRIBUTE_VALUE is null and SUBT.SR_ATTRIBUTE_VALUE is not null)

Line 406: insert into CUG_TSK_TYP_ATTR_DEPS_TL (

402: or (SUBB.SR_ATTRIBUTE_VALUE is null and SUBT.SR_ATTRIBUTE_VALUE is not null)
403: or (SUBB.SR_ATTRIBUTE_VALUE is not null and SUBT.SR_ATTRIBUTE_VALUE is null)
404: ));
405:
406: insert into CUG_TSK_TYP_ATTR_DEPS_TL (
407: TSK_TYP_ATTR_DEP_ID,
408: CREATED_BY,
409: CREATION_DATE,
410: LAST_UPDATED_BY,

Line 426: from CUG_TSK_TYP_ATTR_DEPS_TL B, FND_LANGUAGES L

422: B.LAST_UPDATE_DATE,
423: B.SR_ATTRIBUTE_VALUE,
424: L.LANGUAGE_CODE,
425: B.SOURCE_LANG
426: from CUG_TSK_TYP_ATTR_DEPS_TL B, FND_LANGUAGES L
427: where L.INSTALLED_FLAG in ('I', 'B')
428: and B.LANGUAGE = userenv('LANG')
429: and not exists
430: (select NULL

Line 431: from CUG_TSK_TYP_ATTR_DEPS_TL T

427: where L.INSTALLED_FLAG in ('I', 'B')
428: and B.LANGUAGE = userenv('LANG')
429: and not exists
430: (select NULL
431: from CUG_TSK_TYP_ATTR_DEPS_TL T
432: where T.TSK_TYP_ATTR_DEP_ID = B.TSK_TYP_ATTR_DEP_ID
433: and T.LANGUAGE = L.LANGUAGE_CODE);
434: end ADD_LANGUAGE;
435: