APPS.RRS_HIERARCHIES_EXT_PKG dependencies on RRS_HIERARCHIES_EXT_TL

Line 361: insert into RRS_HIERARCHIES_EXT_TL (

357: X_LAST_UPDATED_BY,
358: X_LAST_UPDATE_LOGIN
359: );
360:
361: insert into RRS_HIERARCHIES_EXT_TL (
362: EXTENSION_ID,
363: SITE_GROUP_VERSION_ID ,
364: HIERARCHY_PURPOSE_CODE,
365: ATTR_GROUP_ID,

Line 469: from RRS_HIERARCHIES_EXT_TL T

465: from FND_LANGUAGES L
466: where L.INSTALLED_FLAG in ('I', 'B')
467: and not exists
468: (select NULL
469: from RRS_HIERARCHIES_EXT_TL T
470: where T.EXTENSION_ID = l_extension_id
471: and T.LANGUAGE = L.LANGUAGE_CODE);
472:
473: open c;

Line 762: from RRS_HIERARCHIES_EXT_TL

758: TL_EXT_ATTR38,
759: TL_EXT_ATTR39,
760: TL_EXT_ATTR40,
761: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
762: from RRS_HIERARCHIES_EXT_TL
763: where EXTENSION_ID = X_EXTENSION_ID
764: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
765: for update of EXTENSION_ID nowait;
766: begin

Line 1305: update RRS_HIERARCHIES_EXT_TL set

1301: if (sql%notfound) then
1302: raise no_data_found;
1303: end if;
1304:
1305: update RRS_HIERARCHIES_EXT_TL set
1306: TL_EXT_ATTR1 = X_TL_EXT_ATTR1,
1307: TL_EXT_ATTR2 = X_TL_EXT_ATTR2,
1308: TL_EXT_ATTR3 = X_TL_EXT_ATTR3,
1309: TL_EXT_ATTR4 = X_TL_EXT_ATTR4,

Line 1362: delete from RRS_HIERARCHIES_EXT_TL

1358: procedure DELETE_ROW (
1359: X_EXTENSION_ID in NUMBER
1360: ) is
1361: begin
1362: delete from RRS_HIERARCHIES_EXT_TL
1363: where EXTENSION_ID = X_EXTENSION_ID;
1364:
1365: if (sql%notfound) then
1366: raise no_data_found;

Line 1380: delete from RRS_HIERARCHIES_EXT_TL T

1376:
1377: procedure ADD_LANGUAGE
1378: is
1379: begin
1380: delete from RRS_HIERARCHIES_EXT_TL T
1381: where not exists
1382: (select NULL
1383: from RRS_HIERARCHIES_EXT_B B
1384: where B.EXTENSION_ID = T.EXTENSION_ID

Line 1387: update RRS_HIERARCHIES_EXT_TL T set (

1383: from RRS_HIERARCHIES_EXT_B B
1384: where B.EXTENSION_ID = T.EXTENSION_ID
1385: );
1386:
1387: update RRS_HIERARCHIES_EXT_TL T set (
1388: TL_EXT_ATTR1,
1389: TL_EXT_ATTR2,
1390: TL_EXT_ATTR3,
1391: TL_EXT_ATTR4,

Line 1469: from RRS_HIERARCHIES_EXT_TL B

1465: B.TL_EXT_ATTR37,
1466: B.TL_EXT_ATTR38,
1467: B.TL_EXT_ATTR39,
1468: B.TL_EXT_ATTR40
1469: from RRS_HIERARCHIES_EXT_TL B
1470: where B.EXTENSION_ID = T.EXTENSION_ID
1471: and B.LANGUAGE = T.SOURCE_LANG)
1472: where (
1473: T.EXTENSION_ID,

Line 1478: from RRS_HIERARCHIES_EXT_TL SUBB, RRS_HIERARCHIES_EXT_TL SUBT

1474: T.LANGUAGE
1475: ) in (select
1476: SUBT.EXTENSION_ID,
1477: SUBT.LANGUAGE
1478: from RRS_HIERARCHIES_EXT_TL SUBB, RRS_HIERARCHIES_EXT_TL SUBT
1479: where SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
1480: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1481: and (SUBB.TL_EXT_ATTR1 <> SUBT.TL_EXT_ATTR1
1482: or (SUBB.TL_EXT_ATTR1 is null and SUBT.TL_EXT_ATTR1 is not null)

Line 1603: insert into RRS_HIERARCHIES_EXT_TL (

1599: or (SUBB.TL_EXT_ATTR40 is null and SUBT.TL_EXT_ATTR40 is not null)
1600: or (SUBB.TL_EXT_ATTR40 is not null and SUBT.TL_EXT_ATTR40 is null)
1601: ));
1602:
1603: insert into RRS_HIERARCHIES_EXT_TL (
1604: EXTENSION_ID,
1605: SITE_GROUP_VERSION_ID,
1606: HIERARCHY_PURPOSE_CODE,
1607: ATTR_GROUP_ID,

Line 1709: from RRS_HIERARCHIES_EXT_TL B, FND_LANGUAGES L

1705: B.TL_EXT_ATTR40,
1706: B.DATA_LEVEL_ID,
1707: L.LANGUAGE_CODE,
1708: B.SOURCE_LANG
1709: from RRS_HIERARCHIES_EXT_TL B, FND_LANGUAGES L
1710: where L.INSTALLED_FLAG in ('I', 'B')
1711: and B.LANGUAGE = userenv('LANG')
1712: and not exists
1713: (select NULL

Line 1714: from RRS_HIERARCHIES_EXT_TL T

1710: where L.INSTALLED_FLAG in ('I', 'B')
1711: and B.LANGUAGE = userenv('LANG')
1712: and not exists
1713: (select NULL
1714: from RRS_HIERARCHIES_EXT_TL T
1715: where T.EXTENSION_ID = B.EXTENSION_ID
1716: and T.LANGUAGE = L.LANGUAGE_CODE);
1717: end ADD_LANGUAGE;
1718: