APPS.CUG_SR_TASK_TYPE_DETS_PKG dependencies on CUG_SR_TASK_TYPE_DETS_TL

Line 136: insert into CUG_SR_TASK_TYPE_DETS_TL (

132: X_LAST_UPDATED_BY,
133: X_LAST_UPDATE_LOGIN
134: );
135:
136: insert into CUG_SR_TASK_TYPE_DETS_TL (
137: SR_TASK_TYPE_DET_ID,
138: CREATED_BY,
139: CREATION_DATE,
140: LAST_UPDATED_BY,

Line 162: from CUG_SR_TASK_TYPE_DETS_TL T

158: from FND_LANGUAGES L
159: where L.INSTALLED_FLAG in ('I', 'B')
160: and not exists
161: (select NULL
162: from CUG_SR_TASK_TYPE_DETS_TL T
163: where T.SR_TASK_TYPE_DET_ID = X_SR_TASK_TYPE_DET_ID
164: and T.LANGUAGE = L.LANGUAGE_CODE);
165:
166: open c;

Line 259: from CUG_SR_TASK_TYPE_DETS_TL

255: cursor c1 is select
256: TASK_NAME,
257: DESCRIPTION,
258: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
259: from CUG_SR_TASK_TYPE_DETS_TL
260: where SR_TASK_TYPE_DET_ID = X_SR_TASK_TYPE_DET_ID
261: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
262: for update of SR_TASK_TYPE_DET_ID nowait;
263: begin

Line 446: update CUG_SR_TASK_TYPE_DETS_TL set

442: if (sql%notfound) then
443: raise no_data_found;
444: end if;
445:
446: update CUG_SR_TASK_TYPE_DETS_TL set
447: TASK_NAME = X_TASK_NAME,
448: DESCRIPTION = X_DESCRIPTION,
449: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
450: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 465: delete from CUG_SR_TASK_TYPE_DETS_TL

461: procedure DELETE_ROW (
462: X_SR_TASK_TYPE_DET_ID in NUMBER
463: ) is
464: begin
465: delete from CUG_SR_TASK_TYPE_DETS_TL
466: where SR_TASK_TYPE_DET_ID = X_SR_TASK_TYPE_DET_ID;
467:
468: if (sql%notfound) then
469: raise no_data_found;

Line 483: delete from CUG_SR_TASK_TYPE_DETS_TL T

479:
480: procedure ADD_LANGUAGE
481: is
482: begin
483: delete from CUG_SR_TASK_TYPE_DETS_TL T
484: where not exists
485: (select NULL
486: from CUG_SR_TASK_TYPE_DETS_B B
487: where B.SR_TASK_TYPE_DET_ID = T.SR_TASK_TYPE_DET_ID

Line 490: update CUG_SR_TASK_TYPE_DETS_TL T set (

486: from CUG_SR_TASK_TYPE_DETS_B B
487: where B.SR_TASK_TYPE_DET_ID = T.SR_TASK_TYPE_DET_ID
488: );
489:
490: update CUG_SR_TASK_TYPE_DETS_TL T set (
491: TASK_NAME,
492: DESCRIPTION
493: ) = (select
494: B.TASK_NAME,

Line 496: from CUG_SR_TASK_TYPE_DETS_TL B

492: DESCRIPTION
493: ) = (select
494: B.TASK_NAME,
495: B.DESCRIPTION
496: from CUG_SR_TASK_TYPE_DETS_TL B
497: where B.SR_TASK_TYPE_DET_ID = T.SR_TASK_TYPE_DET_ID
498: and B.LANGUAGE = T.SOURCE_LANG)
499: where (
500: T.SR_TASK_TYPE_DET_ID,

Line 505: from CUG_SR_TASK_TYPE_DETS_TL SUBB, CUG_SR_TASK_TYPE_DETS_TL SUBT

501: T.LANGUAGE
502: ) in (select
503: SUBT.SR_TASK_TYPE_DET_ID,
504: SUBT.LANGUAGE
505: from CUG_SR_TASK_TYPE_DETS_TL SUBB, CUG_SR_TASK_TYPE_DETS_TL SUBT
506: where SUBB.SR_TASK_TYPE_DET_ID = SUBT.SR_TASK_TYPE_DET_ID
507: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
508: and (SUBB.TASK_NAME <> SUBT.TASK_NAME
509: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 514: insert into CUG_SR_TASK_TYPE_DETS_TL (

510: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
511: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
512: ));
513:
514: insert into CUG_SR_TASK_TYPE_DETS_TL (
515: SR_TASK_TYPE_DET_ID,
516: CREATED_BY,
517: CREATION_DATE,
518: LAST_UPDATED_BY,

Line 536: from CUG_SR_TASK_TYPE_DETS_TL B, FND_LANGUAGES L

532: B.TASK_NAME,
533: B.DESCRIPTION,
534: L.LANGUAGE_CODE,
535: B.SOURCE_LANG
536: from CUG_SR_TASK_TYPE_DETS_TL B, FND_LANGUAGES L
537: where L.INSTALLED_FLAG in ('I', 'B')
538: and B.LANGUAGE = userenv('LANG')
539: and not exists
540: (select NULL

Line 541: from CUG_SR_TASK_TYPE_DETS_TL T

537: where L.INSTALLED_FLAG in ('I', 'B')
538: and B.LANGUAGE = userenv('LANG')
539: and not exists
540: (select NULL
541: from CUG_SR_TASK_TYPE_DETS_TL T
542: where T.SR_TASK_TYPE_DET_ID = B.SR_TASK_TYPE_DET_ID
543: and T.LANGUAGE = L.LANGUAGE_CODE);
544: end ADD_LANGUAGE;
545: