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.FND_DICTIONARY_PKG dependencies on FND_TABLES

Line 52: FND_TABLES T,

48: begin
49: select P.APPLICATION_ID, P.TABLE_ID, P.PRIMARY_KEY_ID
50: into x_pk_application_id, x_pk_table_id, x_pk_id
51: from FND_PRIMARY_KEYS P,
52: FND_TABLES T,
53: FND_APPLICATION A
54: where A.APPLICATION_SHORT_NAME = x_application_short_name
55: and A.APPLICATION_ID = T.APPLICATION_ID
56: and T.TABLE_NAME = x_table_name

Line 109: -- Add a new table into FND_TABLES. This is only called after checking

105: end ResolveConflictColumn;
106:
107: --
108: -- InsertTable (PRIVATE))
109: -- Add a new table into FND_TABLES. This is only called after checking
110: -- there is no such table exists in UploadTable().
111: --
112: procedure InsertTable (
113: x_application_id in number,

Line 136: insert into FND_TABLES (

132: x_last_updated_by in number,
133: x_last_update_login in number
134: ) is
135: begin
136: insert into FND_TABLES (
137: APPLICATION_ID,
138: TABLE_ID,
139: TABLE_NAME,
140: USER_TABLE_NAME,

Line 161: FND_TABLES_S.NEXTVAL,

157: CREATION_DATE,
158: CREATED_BY)
159: values (
160: x_application_id,
161: FND_TABLES_S.NEXTVAL,
162: x_table_name,
163: x_user_table_name,
164: x_table_type,
165: x_description,

Line 1126: from fnd_tables

1122:
1123: begin
1124: select table_id
1125: into tab_id
1126: from fnd_tables
1127: where application_id = appl_id
1128: and table_name = upper(x_table_name);
1129: exception
1130: when no_data_found then

Line 1132: fnd_message.set_token('TABLE', 'FND_TABLES');

1128: and table_name = upper(x_table_name);
1129: exception
1130: when no_data_found then
1131: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1132: fnd_message.set_token('TABLE', 'FND_TABLES');
1133: fnd_message.set_token('COLUMN', 'TABLE_NAME');
1134: fnd_message.set_token('VALUE', x_table_name);
1135: app_exception.raise_exception;
1136: return;

Line 1247: from fnd_tables

1243:
1244: begin
1245: select table_id
1246: into tab_id
1247: from fnd_tables
1248: where application_id = appl_id
1249: and table_name = upper(x_table_name);
1250: exception
1251: when no_data_found then

Line 1253: fnd_message.set_token('TABLE', 'FND_TABLES');

1249: and table_name = upper(x_table_name);
1250: exception
1251: when no_data_found then
1252: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1253: fnd_message.set_token('TABLE', 'FND_TABLES');
1254: fnd_message.set_token('COLUMN', 'TABLE_NAME');
1255: fnd_message.set_token('VALUE', x_table_name);
1256: app_exception.raise_exception;
1257: return;

Line 1323: from fnd_tables

1319:
1320: begin
1321: select table_id
1322: into tab_id
1323: from fnd_tables
1324: where application_id = appl_id
1325: and table_name = upper(x_table_name);
1326: exception
1327: when no_data_found then

Line 1329: fnd_message.set_token('TABLE', 'FND_TABLES');

1325: and table_name = upper(x_table_name);
1326: exception
1327: when no_data_found then
1328: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1329: fnd_message.set_token('TABLE', 'FND_TABLES');
1330: fnd_message.set_token('COLUMN', 'TABLE_NAME');
1331: fnd_message.set_token('VALUE', x_table_name);
1332: app_exception.raise_exception;
1333: return;

Line 1415: from fnd_tables

1411:
1412: begin
1413: select table_id
1414: into tab_id
1415: from fnd_tables
1416: where application_id = appl_id
1417: and table_name = upper(x_table_name);
1418: exception
1419: when no_data_found then

Line 1421: fnd_message.set_token('TABLE', 'FND_TABLES');

1417: and table_name = upper(x_table_name);
1418: exception
1419: when no_data_found then
1420: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1421: fnd_message.set_token('TABLE', 'FND_TABLES');
1422: fnd_message.set_token('COLUMN', 'TABLE_NAME');
1423: fnd_message.set_token('VALUE', x_table_name);
1424: app_exception.raise_exception;
1425: return;

Line 1549: -- Remove table from FND_TABLES and all its columns, indexes, primary

1545: end RemoveView;
1546:
1547: --
1548: -- RemoveTable (PUBLIC)
1549: -- Remove table from FND_TABLES and all its columns, indexes, primary
1550: -- keys and foreign keys.
1551: --
1552: procedure RemoveTable(
1553: x_application_short_name in varchar2,

Line 1596: from fnd_tables

1592:
1593: begin
1594: select table_id
1595: into tab_id
1596: from fnd_tables
1597: where application_id = appl_id
1598: and table_name = upper(x_table_name);
1599: exception
1600: when no_data_found then

Line 1602: fnd_message.set_token('TABLE', 'FND_TABLES');

1598: and table_name = upper(x_table_name);
1599: exception
1600: when no_data_found then
1601: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1602: fnd_message.set_token('TABLE', 'FND_TABLES');
1603: fnd_message.set_token('COLUMN', 'TABLE_NAME');
1604: fnd_message.set_token('VALUE', x_table_name);
1605: app_exception.raise_exception;
1606: return;

Line 1634: delete from fnd_tables

1630: where application_id = appl_id
1631: and table_id = tab_id;
1632:
1633: -- Remove table itself
1634: delete from fnd_tables
1635: where application_id = appl_id
1636: and table_id = tab_id;
1637:
1638: end RemoveTable;

Line 1711: from FND_TABLES

1707:
1708: begin
1709: select LAST_UPDATED_BY, LAST_UPDATE_DATE
1710: into db_luby, db_ludate
1711: from FND_TABLES
1712: where APPLICATION_ID = appl_id
1713: and TABLE_NAME = x_table_name;
1714:
1715: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 1719: update FND_TABLES

1715: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
1716: db_ludate, X_CUSTOM_MODE)) then
1717:
1718: -- Resolve USER_TABLE_NAME by pre-pending '@'
1719: update FND_TABLES
1720: set USER_TABLE_NAME = '@'||USER_TABLE_NAME
1721: where APPLICATION_ID = appl_id
1722: and TABLE_NAME <> x_table_name
1723: and USER_TABLE_NAME = x_user_table_name;

Line 1725: update FND_TABLES set

1721: where APPLICATION_ID = appl_id
1722: and TABLE_NAME <> x_table_name
1723: and USER_TABLE_NAME = x_user_table_name;
1724:
1725: update FND_TABLES set
1726: USER_TABLE_NAME = x_user_table_name,
1727: TABLE_TYPE = x_table_type,
1728: DESCRIPTION = x_description,
1729: AUTO_SIZE = x_auto_size,

Line 1816: select T.TABLE_ID into tab_id from FND_TABLES T

1812: into appl_id
1813: from FND_APPLICATION A
1814: where A.APPLICATION_SHORT_NAME = x_application_short_name;
1815:
1816: select T.TABLE_ID into tab_id from FND_TABLES T
1817: where T.APPLICATION_ID = appl_id
1818: and T.TABLE_NAME = x_table_name;
1819:
1820: ResolveConflictColumn(appl_id, tab_id, x_column_name, x_user_column_name,

Line 2025: select T.TABLE_ID into tab_id from FND_TABLES T

2021: into appl_id
2022: from FND_APPLICATION A
2023: where A.APPLICATION_SHORT_NAME = x_application_short_name;
2024:
2025: select T.TABLE_ID into tab_id from FND_TABLES T
2026: where T.APPLICATION_ID = appl_id
2027: and T.TABLE_NAME = x_table_name;
2028:
2029: -- Bug2631776 In this section handle the parent entity

Line 2320: select T.TABLE_ID into tab_id from FND_TABLES T

2316: into appl_id
2317: from FND_APPLICATION A
2318: where A.APPLICATION_SHORT_NAME = x_application_short_name;
2319:
2320: select T.TABLE_ID into tab_id from FND_TABLES T
2321: where T.APPLICATION_ID = appl_id
2322: and T.TABLE_NAME = x_table_name;
2323:
2324: select I.INDEX_ID into idx_id from FND_INDEXES I

Line 2431: select T.TABLE_ID into tab_id from FND_TABLES T

2427: into appl_id
2428: from FND_APPLICATION A
2429: where A.APPLICATION_SHORT_NAME = x_application_short_name;
2430:
2431: select T.TABLE_ID into tab_id from FND_TABLES T
2432: where T.APPLICATION_ID = appl_id
2433: and T.TABLE_NAME = x_table_name;
2434:
2435: -- Validation on primary_key_type, audit_flag and enabled_flag

Line 2763: select T.TABLE_ID into tab_id from FND_TABLES T

2759: into appl_id
2760: from FND_APPLICATION A
2761: where A.APPLICATION_SHORT_NAME = x_application_short_name;
2762:
2763: select T.TABLE_ID into tab_id from FND_TABLES T
2764: where T.APPLICATION_ID = appl_id
2765: and T.TABLE_NAME = x_table_name;
2766:
2767: select P.PRIMARY_KEY_ID into pk_id from FND_PRIMARY_KEYS P

Line 2876: select T.TABLE_ID into tab_id from FND_TABLES T

2872: into appl_id
2873: from FND_APPLICATION A
2874: where A.APPLICATION_SHORT_NAME = x_application_short_name;
2875:
2876: select T.TABLE_ID into tab_id from FND_TABLES T
2877: where T.APPLICATION_ID = appl_id
2878: and T.TABLE_NAME = x_table_name;
2879:
2880: -- Validate if primary key exists

Line 3189: select T.TABLE_ID into tab_id from FND_TABLES T

3185: into appl_id
3186: from FND_APPLICATION A
3187: where A.APPLICATION_SHORT_NAME = x_application_short_name;
3188:
3189: select T.TABLE_ID into tab_id from FND_TABLES T
3190: where T.APPLICATION_ID = appl_id
3191: and T.TABLE_NAME = x_table_name;
3192:
3193: select F.FOREIGN_KEY_ID into fk_id from FND_FOREIGN_KEYS F

Line 3708: from fnd_tables ft, fnd_foreign_keys f, fnd_application a

3704: cursor fks is
3705: select a.application_id, a.application_short_name, ft.table_name,
3706: ft.table_id, f.foreign_key_id,
3707: f.foreign_key_name, f.condition
3708: from fnd_tables ft, fnd_foreign_keys f, fnd_application a
3709: where f.primary_key_application_id = x_application_id
3710: and f.primary_key_table_id = x_primary_table_id
3711: and f.primary_key_id = x_primary_key_id
3712: and ft.table_id = f.table_id

Line 4067: from fnd_application a, fnd_tables t

4063: -- Fetch general info
4064: begin
4065: select a.application_id, t.table_id
4066: into appl_id, tab_id
4067: from fnd_application a, fnd_tables t
4068: where a.application_short_name = x_application_short_name
4069: and a.application_id = t.application_id
4070: and t.table_name = x_primary_table_name;
4071: exception