APPS.CUG_TSK_TYP_ATTR_MAPS_PKG dependencies on CUG_TSK_TYP_ATTR_MAPS_TL

Line 105: insert into CUG_TSK_TYP_ATTR_MAPS_TL (

101: X_LAST_UPDATED_BY,
102: X_LAST_UPDATE_LOGIN
103: );
104:
105: insert into CUG_TSK_TYP_ATTR_MAPS_TL (
106: TSK_TYP_ATTR_MAP_ID,
107: CREATED_BY,
108: CREATION_DATE,
109: LAST_UPDATED_BY,

Line 129: from CUG_TSK_TYP_ATTR_MAPS_TL T

125: from FND_LANGUAGES L
126: where L.INSTALLED_FLAG in ('I', 'B')
127: and not exists
128: (select NULL
129: from CUG_TSK_TYP_ATTR_MAPS_TL T
130: where T.TSK_TYP_ATTR_MAP_ID = X_TSK_TYP_ATTR_MAP_ID
131: and T.LANGUAGE = L.LANGUAGE_CODE);
132:
133: open c;

Line 204: from CUG_TSK_TYP_ATTR_MAPS_TL

200:
201: cursor c1 is select
202: TASK_ATTR_DEFAULT_VALUE,
203: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
204: from CUG_TSK_TYP_ATTR_MAPS_TL
205: where TSK_TYP_ATTR_MAP_ID = X_TSK_TYP_ATTR_MAP_ID
206: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
207: for update of TSK_TYP_ATTR_MAP_ID nowait;
208: begin

Line 351: update CUG_TSK_TYP_ATTR_MAPS_TL set

347: if (sql%notfound) then
348: raise no_data_found;
349: end if;
350:
351: update CUG_TSK_TYP_ATTR_MAPS_TL set
352: TASK_ATTR_DEFAULT_VALUE = X_TASK_ATTR_DEFAULT_VALUE,
353: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
354: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
355: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 369: delete from CUG_TSK_TYP_ATTR_MAPS_TL

365: procedure DELETE_ROW (
366: X_TSK_TYP_ATTR_MAP_ID in NUMBER
367: ) is
368: begin
369: delete from CUG_TSK_TYP_ATTR_MAPS_TL
370: where TSK_TYP_ATTR_MAP_ID = X_TSK_TYP_ATTR_MAP_ID;
371:
372: if (sql%notfound) then
373: raise no_data_found;

Line 500: UPDATE CUG_TSK_TYP_ATTR_MAPS_TL

496: X_TSK_TYP_ATTR_MAP_ID in NUMBER,
497: X_TASK_ATTR_DEFAULT_VALUE in VARCHAR2,
498: X_OWNER in VARCHAR2) IS
499: BEGIN
500: UPDATE CUG_TSK_TYP_ATTR_MAPS_TL
501: SET TASK_ATTR_DEFAULT_VALUE = X_TASK_ATTR_DEFAULT_VALUE,
502: source_lang = userenv('LANG'),
503: last_update_date = sysdate,
504: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),

Line 515: delete from CUG_TSK_TYP_ATTR_MAPS_TL T

511:
512: procedure ADD_LANGUAGE
513: is
514: begin
515: delete from CUG_TSK_TYP_ATTR_MAPS_TL T
516: where not exists
517: (select NULL
518: from CUG_TSK_TYP_ATTR_MAPS_B B
519: where B.TSK_TYP_ATTR_MAP_ID = T.TSK_TYP_ATTR_MAP_ID

Line 522: update CUG_TSK_TYP_ATTR_MAPS_TL T set (

518: from CUG_TSK_TYP_ATTR_MAPS_B B
519: where B.TSK_TYP_ATTR_MAP_ID = T.TSK_TYP_ATTR_MAP_ID
520: );
521:
522: update CUG_TSK_TYP_ATTR_MAPS_TL T set (
523: TASK_ATTR_DEFAULT_VALUE
524: ) = (select
525: B.TASK_ATTR_DEFAULT_VALUE
526: from CUG_TSK_TYP_ATTR_MAPS_TL B

Line 526: from CUG_TSK_TYP_ATTR_MAPS_TL B

522: update CUG_TSK_TYP_ATTR_MAPS_TL T set (
523: TASK_ATTR_DEFAULT_VALUE
524: ) = (select
525: B.TASK_ATTR_DEFAULT_VALUE
526: from CUG_TSK_TYP_ATTR_MAPS_TL B
527: where B.TSK_TYP_ATTR_MAP_ID = T.TSK_TYP_ATTR_MAP_ID
528: and B.LANGUAGE = T.SOURCE_LANG)
529: where (
530: T.TSK_TYP_ATTR_MAP_ID,

Line 535: from CUG_TSK_TYP_ATTR_MAPS_TL SUBB, CUG_TSK_TYP_ATTR_MAPS_TL SUBT

531: T.LANGUAGE
532: ) in (select
533: SUBT.TSK_TYP_ATTR_MAP_ID,
534: SUBT.LANGUAGE
535: from CUG_TSK_TYP_ATTR_MAPS_TL SUBB, CUG_TSK_TYP_ATTR_MAPS_TL SUBT
536: where SUBB.TSK_TYP_ATTR_MAP_ID = SUBT.TSK_TYP_ATTR_MAP_ID
537: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
538: and (SUBB.TASK_ATTR_DEFAULT_VALUE <> SUBT.TASK_ATTR_DEFAULT_VALUE
539: or (SUBB.TASK_ATTR_DEFAULT_VALUE is null and SUBT.TASK_ATTR_DEFAULT_VALUE is not null)

Line 543: insert into CUG_TSK_TYP_ATTR_MAPS_TL (

539: or (SUBB.TASK_ATTR_DEFAULT_VALUE is null and SUBT.TASK_ATTR_DEFAULT_VALUE is not null)
540: or (SUBB.TASK_ATTR_DEFAULT_VALUE is not null and SUBT.TASK_ATTR_DEFAULT_VALUE is null)
541: ));
542:
543: insert into CUG_TSK_TYP_ATTR_MAPS_TL (
544: TSK_TYP_ATTR_MAP_ID,
545: CREATED_BY,
546: CREATION_DATE,
547: LAST_UPDATED_BY,

Line 563: from CUG_TSK_TYP_ATTR_MAPS_TL B, FND_LANGUAGES L

559: B.LAST_UPDATE_DATE,
560: B.TASK_ATTR_DEFAULT_VALUE,
561: L.LANGUAGE_CODE,
562: B.SOURCE_LANG
563: from CUG_TSK_TYP_ATTR_MAPS_TL B, FND_LANGUAGES L
564: where L.INSTALLED_FLAG in ('I', 'B')
565: and B.LANGUAGE = userenv('LANG')
566: and not exists
567: (select NULL

Line 568: from CUG_TSK_TYP_ATTR_MAPS_TL T

564: where L.INSTALLED_FLAG in ('I', 'B')
565: and B.LANGUAGE = userenv('LANG')
566: and not exists
567: (select NULL
568: from CUG_TSK_TYP_ATTR_MAPS_TL T
569: where T.TSK_TYP_ATTR_MAP_ID = B.TSK_TYP_ATTR_MAP_ID
570: and T.LANGUAGE = L.LANGUAGE_CODE);
571: end ADD_LANGUAGE;
572: