APPS.CUG_SR_TYPE_ATTR_MAPS_PKG dependencies on CUG_SR_TYPE_ATTR_MAPS_TL

Line 126: insert into CUG_SR_TYPE_ATTR_MAPS_TL (

122: X_LAST_UPDATED_BY,
123: X_LAST_UPDATE_LOGIN
124: );
125:
126: insert into CUG_SR_TYPE_ATTR_MAPS_TL (
127: SR_TYPE_ATTR_MAP_ID,
128: CREATED_BY,
129: CREATION_DATE,
130: LAST_UPDATE_LOGIN,

Line 152: from CUG_SR_TYPE_ATTR_MAPS_TL T

148: from FND_LANGUAGES L
149: where L.INSTALLED_FLAG in ('I', 'B')
150: and not exists
151: (select NULL
152: from CUG_SR_TYPE_ATTR_MAPS_TL T
153: where T.SR_TYPE_ATTR_MAP_ID = X_SR_TYPE_ATTR_MAP_ID
154: and T.LANGUAGE = L.LANGUAGE_CODE);
155:
156: open c;

Line 241: from CUG_SR_TYPE_ATTR_MAPS_TL

237:
238: cursor c1 is select
239: SR_ATTR_DEFAULT_VALUE,
240: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
241: from CUG_SR_TYPE_ATTR_MAPS_TL
242: where SR_TYPE_ATTR_MAP_ID = X_SR_TYPE_ATTR_MAP_ID
243: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
244: for update of SR_TYPE_ATTR_MAP_ID nowait;
245: begin

Line 414: update CUG_SR_TYPE_ATTR_MAPS_TL set

410: if (sql%notfound) then
411: raise no_data_found;
412: end if;
413:
414: update CUG_SR_TYPE_ATTR_MAPS_TL set
415: SR_ATTR_DEFAULT_VALUE = X_SR_ATTR_DEFAULT_VALUE,
416: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
417: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
418: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 432: delete from CUG_SR_TYPE_ATTR_MAPS_TL

428: procedure DELETE_ROW (
429: X_SR_TYPE_ATTR_MAP_ID in NUMBER
430: ) is
431: begin
432: delete from CUG_SR_TYPE_ATTR_MAPS_TL
433: where SR_TYPE_ATTR_MAP_ID = X_SR_TYPE_ATTR_MAP_ID;
434:
435: if (sql%notfound) then
436: raise no_data_found;

Line 450: delete from CUG_SR_TYPE_ATTR_MAPS_TL T

446:
447: procedure ADD_LANGUAGE
448: is
449: begin
450: delete from CUG_SR_TYPE_ATTR_MAPS_TL T
451: where not exists
452: (select NULL
453: from CUG_SR_TYPE_ATTR_MAPS_B B
454: where B.SR_TYPE_ATTR_MAP_ID = T.SR_TYPE_ATTR_MAP_ID

Line 457: update CUG_SR_TYPE_ATTR_MAPS_TL T set (

453: from CUG_SR_TYPE_ATTR_MAPS_B B
454: where B.SR_TYPE_ATTR_MAP_ID = T.SR_TYPE_ATTR_MAP_ID
455: );
456:
457: update CUG_SR_TYPE_ATTR_MAPS_TL T set (
458: SR_ATTR_DEFAULT_VALUE
459: ) = (select
460: B.SR_ATTR_DEFAULT_VALUE
461: from CUG_SR_TYPE_ATTR_MAPS_TL B

Line 461: from CUG_SR_TYPE_ATTR_MAPS_TL B

457: update CUG_SR_TYPE_ATTR_MAPS_TL T set (
458: SR_ATTR_DEFAULT_VALUE
459: ) = (select
460: B.SR_ATTR_DEFAULT_VALUE
461: from CUG_SR_TYPE_ATTR_MAPS_TL B
462: where B.SR_TYPE_ATTR_MAP_ID = T.SR_TYPE_ATTR_MAP_ID
463: and B.LANGUAGE = T.SOURCE_LANG)
464: where (
465: T.SR_TYPE_ATTR_MAP_ID,

Line 470: from CUG_SR_TYPE_ATTR_MAPS_TL SUBB, CUG_SR_TYPE_ATTR_MAPS_TL SUBT

466: T.LANGUAGE
467: ) in (select
468: SUBT.SR_TYPE_ATTR_MAP_ID,
469: SUBT.LANGUAGE
470: from CUG_SR_TYPE_ATTR_MAPS_TL SUBB, CUG_SR_TYPE_ATTR_MAPS_TL SUBT
471: where SUBB.SR_TYPE_ATTR_MAP_ID = SUBT.SR_TYPE_ATTR_MAP_ID
472: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
473: and (SUBB.SR_ATTR_DEFAULT_VALUE <> SUBT.SR_ATTR_DEFAULT_VALUE
474: or (SUBB.SR_ATTR_DEFAULT_VALUE is null and SUBT.SR_ATTR_DEFAULT_VALUE is not null)

Line 478: insert into CUG_SR_TYPE_ATTR_MAPS_TL (

474: or (SUBB.SR_ATTR_DEFAULT_VALUE is null and SUBT.SR_ATTR_DEFAULT_VALUE is not null)
475: or (SUBB.SR_ATTR_DEFAULT_VALUE is not null and SUBT.SR_ATTR_DEFAULT_VALUE is null)
476: ));
477:
478: insert into CUG_SR_TYPE_ATTR_MAPS_TL (
479: SR_TYPE_ATTR_MAP_ID,
480: CREATED_BY,
481: CREATION_DATE,
482: LAST_UPDATE_LOGIN,

Line 500: from CUG_SR_TYPE_ATTR_MAPS_TL B, FND_LANGUAGES L

496: B.LAST_UPDATED_BY,
497: B.SECURITY_GROUP_ID,
498: L.LANGUAGE_CODE,
499: B.SOURCE_LANG
500: from CUG_SR_TYPE_ATTR_MAPS_TL B, FND_LANGUAGES L
501: where L.INSTALLED_FLAG in ('I', 'B')
502: and B.LANGUAGE = userenv('LANG')
503: and not exists
504: (select NULL

Line 505: from CUG_SR_TYPE_ATTR_MAPS_TL T

501: where L.INSTALLED_FLAG in ('I', 'B')
502: and B.LANGUAGE = userenv('LANG')
503: and not exists
504: (select NULL
505: from CUG_SR_TYPE_ATTR_MAPS_TL T
506: where T.SR_TYPE_ATTR_MAP_ID = B.SR_TYPE_ATTR_MAP_ID
507: and T.LANGUAGE = L.LANGUAGE_CODE);
508: end ADD_LANGUAGE;
509:

Line 636: UPDATE CUG_SR_TYPE_ATTR_MAPS_TL

632: X_SR_ATTR_DEFAULT_VALUE in VARCHAR2,
633: X_OWNER in VARCHAR2) IS
634: BEGIN
635:
636: UPDATE CUG_SR_TYPE_ATTR_MAPS_TL
637: SET SR_ATTR_DEFAULT_VALUE = X_SR_ATTR_DEFAULT_VALUE ,
638: source_lang = userenv('LANG'),
639: last_update_date = sysdate,
640: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),