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_CAL_PER_HIER_PKG dependencies on FEM_DIS_CAL_PER_HIER_TL

Line 278: insert into FEM_DIS_CAL_PER_HIER_TL (

274: X_LAST_UPDATED_BY,
275: X_LAST_UPDATE_LOGIN
276: );
277:
278: insert into FEM_DIS_CAL_PER_HIER_TL (
279: LEVEL15_NAME,
280: LEVEL16_NAME,
281: LEVEL17_NAME,
282: LEVEL18_NAME,

Line 426: from FEM_DIS_CAL_PER_HIER_TL T

422: from FND_LANGUAGES L
423: where L.INSTALLED_FLAG in ('I', 'B')
424: and not exists
425: (select NULL
426: from FEM_DIS_CAL_PER_HIER_TL T
427: where T.OBJECT_ID = X_OBJECT_ID
428: and T.OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID
429: and T.LEVEL1_ID = X_LEVEL1_ID
430: and T.LEVEL2_ID = X_LEVEL2_ID

Line 678: from FEM_DIS_CAL_PER_HIER_TL

674: LEVEL18_DESCRIPTION,
675: LEVEL19_DESCRIPTION,
676: LEVEL20_DESCRIPTION,
677: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
678: from FEM_DIS_CAL_PER_HIER_TL
679: where OBJECT_ID = X_OBJECT_ID
680: and OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID
681: and LEVEL1_ID = X_LEVEL1_ID
682: and LEVEL2_ID = X_LEVEL2_ID

Line 1015: update FEM_DIS_CAL_PER_HIER_TL set

1011: if (sql%notfound) then
1012: raise no_data_found;
1013: end if;
1014:
1015: update FEM_DIS_CAL_PER_HIER_TL set
1016: OBJECT_NAME = X_OBJECT_NAME,
1017: OBJECT_DEFINITION_NAME = X_OBJECT_DEFINITION_NAME,
1018: LEVEL1_NAME = X_LEVEL1_NAME,
1019: LEVEL2_NAME = X_LEVEL2_NAME,

Line 1116: delete from FEM_DIS_CAL_PER_HIER_TL

1112: X_LEVEL19_ID in NUMBER,
1113: X_LEVEL20_ID in NUMBER
1114: ) is
1115: begin
1116: delete from FEM_DIS_CAL_PER_HIER_TL
1117: where OBJECT_ID = X_OBJECT_ID
1118: and OBJECT_DEFINITION_ID = X_OBJECT_DEFINITION_ID
1119: and LEVEL1_ID = X_LEVEL1_ID
1120: and LEVEL2_ID = X_LEVEL2_ID

Line 1176: delete from FEM_DIS_CAL_PER_HIER_TL T

1172:
1173: procedure ADD_LANGUAGE
1174: is
1175: begin
1176: delete from FEM_DIS_CAL_PER_HIER_TL T
1177: where not exists
1178: (select NULL
1179: from FEM_DIS_CAL_PER_HIER_B B
1180: where B.OBJECT_ID = T.OBJECT_ID

Line 1204: update FEM_DIS_CAL_PER_HIER_TL T set (

1200: and B.LEVEL19_ID = T.LEVEL19_ID
1201: and B.LEVEL20_ID = T.LEVEL20_ID
1202: );
1203:
1204: update FEM_DIS_CAL_PER_HIER_TL T set (
1205: OBJECT_NAME,
1206: OBJECT_DEFINITION_NAME,
1207: LEVEL1_NAME,
1208: LEVEL2_NAME,

Line 1290: from FEM_DIS_CAL_PER_HIER_TL B

1286: B.LEVEL17_DESCRIPTION,
1287: B.LEVEL18_DESCRIPTION,
1288: B.LEVEL19_DESCRIPTION,
1289: B.LEVEL20_DESCRIPTION
1290: from FEM_DIS_CAL_PER_HIER_TL B
1291: where B.OBJECT_ID = T.OBJECT_ID
1292: and B.OBJECT_DEFINITION_ID = T.OBJECT_DEFINITION_ID
1293: and B.LEVEL1_ID = T.LEVEL1_ID
1294: and B.LEVEL2_ID = T.LEVEL2_ID

Line 1362: from FEM_DIS_CAL_PER_HIER_TL SUBB, FEM_DIS_CAL_PER_HIER_TL SUBT

1358: SUBT.LEVEL18_ID,
1359: SUBT.LEVEL19_ID,
1360: SUBT.LEVEL20_ID,
1361: SUBT.LANGUAGE
1362: from FEM_DIS_CAL_PER_HIER_TL SUBB, FEM_DIS_CAL_PER_HIER_TL SUBT
1363: where SUBB.OBJECT_ID = SUBT.OBJECT_ID
1364: and SUBB.OBJECT_DEFINITION_ID = SUBT.OBJECT_DEFINITION_ID
1365: and SUBB.LEVEL1_ID = SUBT.LEVEL1_ID
1366: and SUBB.LEVEL2_ID = SUBT.LEVEL2_ID

Line 1470: insert into FEM_DIS_CAL_PER_HIER_TL (

1466: or (SUBB.LEVEL20_DESCRIPTION is null and SUBT.LEVEL20_DESCRIPTION is not null)
1467: or (SUBB.LEVEL20_DESCRIPTION is not null and SUBT.LEVEL20_DESCRIPTION is null)
1468: ));
1469:
1470: insert into FEM_DIS_CAL_PER_HIER_TL (
1471: LEVEL15_NAME,
1472: LEVEL16_NAME,
1473: LEVEL17_NAME,
1474: LEVEL18_NAME,

Line 1614: from FEM_DIS_CAL_PER_HIER_TL B, FND_LANGUAGES L

1610: B.LAST_UPDATED_BY,
1611: B.LAST_UPDATE_LOGIN,
1612: L.LANGUAGE_CODE,
1613: B.SOURCE_LANG
1614: from FEM_DIS_CAL_PER_HIER_TL B, FND_LANGUAGES L
1615: where L.INSTALLED_FLAG in ('I', 'B')
1616: and B.LANGUAGE = userenv('LANG')
1617: and not exists
1618: (select NULL

Line 1619: from FEM_DIS_CAL_PER_HIER_TL T

1615: where L.INSTALLED_FLAG in ('I', 'B')
1616: and B.LANGUAGE = userenv('LANG')
1617: and not exists
1618: (select NULL
1619: from FEM_DIS_CAL_PER_HIER_TL T
1620: where T.OBJECT_ID = B.OBJECT_ID
1621: and T.OBJECT_DEFINITION_ID = B.OBJECT_DEFINITION_ID
1622: and T.LEVEL1_ID = B.LEVEL1_ID
1623: and T.LEVEL2_ID = B.LEVEL2_ID

Line 1711: from FEM_DIS_CAL_PER_HIER_TL

1707: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
1708: begin
1709: select LAST_UPDATED_BY, LAST_UPDATE_DATE
1710: into db_luby, db_ludate
1711: from FEM_DIS_CAL_PER_HIER_TL
1712: where OBJECT_ID = x_OBJECT_ID
1713: and OBJECT_DEFINITION_ID = x_OBJECT_DEFINITION_ID
1714: and LEVEL1_ID = x_LEVEL1_ID
1715: and LEVEL2_ID = x_LEVEL2_ID

Line 1740: update FEM_DIS_CAL_PER_HIER_TL set

1736: -- Test for customization and version
1737: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
1738: db_ludate, x_custom_mode)) then
1739: -- Update translations for this language
1740: update FEM_DIS_CAL_PER_HIER_TL set
1741: OBJECT_NAME = nvl(x_OBJECT_NAME, OBJECT_NAME),
1742: OBJECT_DEFINITION_NAME = nvl(x_OBJECT_DEFINITION_NAME, OBJECT_DEFINITION_NAME),
1743: LEVEL1_NAME = nvl(x_LEVEL1_NAME, LEVEL1_NAME),
1744: LEVEL2_NAME = nvl(x_LEVEL2_NAME, LEVEL2_NAME),