eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FEM_DIS_GEOGRAPHY_HIER_PKG dependencies on FEM_DIS_GEOGRAPHY_HIER_TL

Line 282: insert into FEM_DIS_GEOGRAPHY_HIER_TL (

278: X_LAST_UPDATED_BY,
279: X_LAST_UPDATE_LOGIN
280: );
281:
282: insert into FEM_DIS_GEOGRAPHY_HIER_TL (
283: OBJECT_ID,
284: OBJECT_DEFINITION_ID,
285: VALUE_SET_ID,
286: LEVEL1_ID,

Line 432: from FEM_DIS_GEOGRAPHY_HIER_TL T

428: from FND_LANGUAGES L
429: where L.INSTALLED_FLAG in ('I', 'B')
430: and not exists
431: (select NULL
432: from FEM_DIS_GEOGRAPHY_HIER_TL T
433: where T.OBJECT_ID = X_OBJECT_ID
434: and T.OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID
435: and T.VALUE_SET_ID = X_VALUE_SET_ID
436: and T.LEVEL1_ID = X_LEVEL1_ID

Line 687: from FEM_DIS_GEOGRAPHY_HIER_TL

683: LEVEL18_DESCRIPTION,
684: LEVEL19_DESCRIPTION,
685: LEVEL20_DESCRIPTION,
686: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
687: from FEM_DIS_GEOGRAPHY_HIER_TL
688: where OBJECT_ID = X_OBJECT_ID
689: and OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID
690: and VALUE_SET_ID = X_VALUE_SET_ID
691: and LEVEL1_ID = X_LEVEL1_ID

Line 1027: update FEM_DIS_GEOGRAPHY_HIER_TL set

1023: if (sql%notfound) then
1024: raise no_data_found;
1025: end if;
1026:
1027: update FEM_DIS_GEOGRAPHY_HIER_TL set
1028: OBJECT_NAME = X_OBJECT_NAME,
1029: OBJECT_DEFINITION_NAME = X_OBJECT_DEFINITION_NAME,
1030: LEVEL1_NAME = X_LEVEL1_NAME,
1031: LEVEL2_NAME = X_LEVEL2_NAME,

Line 1130: delete from FEM_DIS_GEOGRAPHY_HIER_TL

1126: X_LEVEL19_ID in NUMBER,
1127: X_LEVEL20_ID in NUMBER
1128: ) is
1129: begin
1130: delete from FEM_DIS_GEOGRAPHY_HIER_TL
1131: where OBJECT_ID = X_OBJECT_ID
1132: and OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID
1133: and VALUE_SET_ID = X_VALUE_SET_ID
1134: and LEVEL1_ID = X_LEVEL1_ID

Line 1192: delete from FEM_DIS_GEOGRAPHY_HIER_TL T

1188:
1189: procedure ADD_LANGUAGE
1190: is
1191: begin
1192: delete from FEM_DIS_GEOGRAPHY_HIER_TL T
1193: where not exists
1194: (select NULL
1195: from FEM_DIS_GEOGRAPHY_HIER_B B
1196: where B.OBJECT_ID = T.OBJECT_ID

Line 1221: update FEM_DIS_GEOGRAPHY_HIER_TL T set (

1217: and B.LEVEL19_ID = T.LEVEL19_ID
1218: and B.LEVEL20_ID = T.LEVEL20_ID
1219: );
1220:
1221: update FEM_DIS_GEOGRAPHY_HIER_TL T set (
1222: OBJECT_NAME,
1223: OBJECT_DEFINITION_NAME,
1224: LEVEL1_NAME,
1225: LEVEL2_NAME,

Line 1307: from FEM_DIS_GEOGRAPHY_HIER_TL B

1303: B.LEVEL17_DESCRIPTION,
1304: B.LEVEL18_DESCRIPTION,
1305: B.LEVEL19_DESCRIPTION,
1306: B.LEVEL20_DESCRIPTION
1307: from FEM_DIS_GEOGRAPHY_HIER_TL B
1308: where B.OBJECT_ID = T.OBJECT_ID
1309: and B.OBJECT_DEFINITION_ID = T.OBJECT_DEFINITION_ID
1310: and B.VALUE_SET_ID = T.VALUE_SET_ID
1311: and B.LEVEL1_ID = T.LEVEL1_ID

Line 1382: from FEM_DIS_GEOGRAPHY_HIER_TL SUBB, FEM_DIS_GEOGRAPHY_HIER_TL SUBT

1378: SUBT.LEVEL18_ID,
1379: SUBT.LEVEL19_ID,
1380: SUBT.LEVEL20_ID,
1381: SUBT.LANGUAGE
1382: from FEM_DIS_GEOGRAPHY_HIER_TL SUBB, FEM_DIS_GEOGRAPHY_HIER_TL SUBT
1383: where SUBB.OBJECT_ID = SUBT.OBJECT_ID
1384: and SUBB.OBJECT_DEFINITION_ID = SUBT.OBJECT_DEFINITION_ID
1385: and SUBB.VALUE_SET_ID = SUBT.VALUE_SET_ID
1386: and SUBB.LEVEL1_ID = SUBT.LEVEL1_ID

Line 1491: insert into FEM_DIS_GEOGRAPHY_HIER_TL (

1487: or (SUBB.LEVEL20_DESCRIPTION is null and SUBT.LEVEL20_DESCRIPTION is not null)
1488: or (SUBB.LEVEL20_DESCRIPTION is not null and SUBT.LEVEL20_DESCRIPTION is null)
1489: ));
1490:
1491: insert into FEM_DIS_GEOGRAPHY_HIER_TL (
1492: OBJECT_ID,
1493: OBJECT_DEFINITION_ID,
1494: VALUE_SET_ID,
1495: LEVEL1_ID,

Line 1637: from FEM_DIS_GEOGRAPHY_HIER_TL B, FND_LANGUAGES L

1633: B.LAST_UPDATED_BY,
1634: B.LAST_UPDATE_LOGIN,
1635: L.LANGUAGE_CODE,
1636: B.SOURCE_LANG
1637: from FEM_DIS_GEOGRAPHY_HIER_TL B, FND_LANGUAGES L
1638: where L.INSTALLED_FLAG in ('I', 'B')
1639: and B.LANGUAGE = userenv('LANG')
1640: and not exists
1641: (select NULL

Line 1642: from FEM_DIS_GEOGRAPHY_HIER_TL T

1638: where L.INSTALLED_FLAG in ('I', 'B')
1639: and B.LANGUAGE = userenv('LANG')
1640: and not exists
1641: (select NULL
1642: from FEM_DIS_GEOGRAPHY_HIER_TL T
1643: where T.OBJECT_ID = B.OBJECT_ID
1644: and T.OBJECT_DEFINITION_ID = B.OBJECT_DEFINITION_ID
1645: and T.VALUE_SET_ID = B.VALUE_SET_ID
1646: and T.LEVEL1_ID = B.LEVEL1_ID

Line 1736: from FEM_DIS_GEOGRAPHY_HIER_TL

1732: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
1733: begin
1734: select LAST_UPDATED_BY, LAST_UPDATE_DATE
1735: into db_luby, db_ludate
1736: from FEM_DIS_GEOGRAPHY_HIER_TL
1737: where OBJECT_ID = x_OBJECT_ID
1738: and OBJECT_DEFINITION_ID = x_OBJECT_DEFINITION_ID
1739: and VALUE_SET_ID = x_VALUE_SET_ID
1740: and LEVEL1_ID = x_LEVEL1_ID

Line 1766: update FEM_DIS_GEOGRAPHY_HIER_TL set

1762: -- Test for customization and version
1763: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
1764: db_ludate, x_custom_mode)) then
1765: -- Update translations for this language
1766: update FEM_DIS_GEOGRAPHY_HIER_TL set
1767: OBJECT_NAME = nvl(x_OBJECT_NAME, OBJECT_NAME),
1768: OBJECT_DEFINITION_NAME = nvl(x_OBJECT_DEFINITION_NAME, OBJECT_DEFINITION_NAME),
1769: LEVEL1_NAME = nvl(x_LEVEL1_NAME, LEVEL1_NAME),
1770: LEVEL2_NAME = nvl(x_LEVEL2_NAME, LEVEL2_NAME),