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_XDFDICTIONARY_PKG dependencies on FND_TABLES

Line 48: FND_TABLES T,

44: begin
45: select P.APPLICATION_ID, P.TABLE_ID, P.PRIMARY_KEY_ID
46: into x_pk_application_id, x_pk_table_id, x_pk_id
47: from FND_PRIMARY_KEYS P,
48: FND_TABLES T,
49: FND_APPLICATION A
50: where A.APPLICATION_SHORT_NAME = x_application_short_name
51: and A.APPLICATION_ID = T.APPLICATION_ID
52: and T.TABLE_NAME = x_table_name

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

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

Line 132: insert into FND_TABLES (

128: x_last_updated_by in number,
129: x_last_update_login in number
130: ) is
131: begin
132: insert into FND_TABLES (
133: APPLICATION_ID,
134: TABLE_ID,
135: TABLE_NAME,
136: USER_TABLE_NAME,

Line 157: FND_TABLES_S.NEXTVAL,

153: CREATION_DATE,
154: CREATED_BY)
155: values (
156: x_application_id,
157: FND_TABLES_S.NEXTVAL,
158: x_table_name,
159: x_user_table_name,
160: x_table_type,
161: x_description,

Line 1123: from fnd_tables

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

Line 1131: || ' not found in the table fnd_tables ', TRUE);

1127: when no_data_found then
1128: RAISE_APPLICATION_ERROR(
1129: -20001, 'Fnd table '
1130: || x_table_name
1131: || ' not found in the table fnd_tables ', TRUE);
1132: return;
1133: end;
1134:
1135: begin

Line 1240: from fnd_tables

1236:
1237: begin
1238: select table_id
1239: into tab_id
1240: from fnd_tables
1241: where application_id = appl_id
1242: and table_name = upper(x_table_name);
1243: exception
1244: when no_data_found then

Line 1246: -20001, 'No data found in fnd_tables for table name '

1242: and table_name = upper(x_table_name);
1243: exception
1244: when no_data_found then
1245: RAISE_APPLICATION_ERROR(
1246: -20001, 'No data found in fnd_tables for table name '
1247: || x_table_name , TRUE);
1248: return;
1249: end;
1250:

Line 1310: from fnd_tables

1306:
1307: begin
1308: select table_id
1309: into tab_id
1310: from fnd_tables
1311: where application_id = appl_id
1312: and table_name = upper(x_table_name);
1313: exception
1314: when no_data_found then

Line 1316: -20001, 'No data found in fnd_tables for table name '

1312: and table_name = upper(x_table_name);
1313: exception
1314: when no_data_found then
1315: RAISE_APPLICATION_ERROR(
1316: -20001, 'No data found in fnd_tables for table name '
1317: || x_table_name , TRUE);
1318: return;
1319: end;
1320:

Line 1396: from fnd_tables

1392:
1393: begin
1394: select table_id
1395: into tab_id
1396: from fnd_tables
1397: where application_id = appl_id
1398: and table_name = upper(x_table_name);
1399: exception
1400: when no_data_found then

Line 1402: -20001, 'Sql no data found in fnd_tables for table name '

1398: and table_name = upper(x_table_name);
1399: exception
1400: when no_data_found then
1401: RAISE_APPLICATION_ERROR(
1402: -20001, 'Sql no data found in fnd_tables for table name '
1403: || x_table_name , TRUE);
1404: return;
1405: end;
1406:

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

1514: end RemoveView;
1515:
1516: --
1517: -- RemoveTable (PUBLIC)
1518: -- Remove table from FND_TABLES and all its columns, indexes, primary
1519: -- keys and foreign keys.
1520: --
1521: procedure RemoveTable(
1522: x_application_short_name in varchar2,

Line 1563: from fnd_tables

1559:
1560: begin
1561: select table_id
1562: into tab_id
1563: from fnd_tables
1564: where application_id = appl_id
1565: and table_name = upper(x_table_name);
1566: exception
1567: when no_data_found then

Line 1569: -20001, 'Sql no data found in fnd_tables for table name '

1565: and table_name = upper(x_table_name);
1566: exception
1567: when no_data_found then
1568: RAISE_APPLICATION_ERROR(
1569: -20001, 'Sql no data found in fnd_tables for table name '
1570: || x_table_name , TRUE);
1571: return;
1572: end;
1573:

Line 1599: delete from fnd_tables

1595: where application_id = appl_id
1596: and table_id = tab_id;
1597:
1598: -- Remove table itself
1599: delete from fnd_tables
1600: where application_id = appl_id
1601: and table_id = tab_id;
1602:
1603: end RemoveTable;

Line 1678: from FND_TABLES

1674:
1675: begin
1676: select LAST_UPDATED_BY, LAST_UPDATE_DATE
1677: into db_luby, db_ludate
1678: from FND_TABLES
1679: where APPLICATION_ID = appl_id
1680: and TABLE_NAME = x_table_name;
1681:
1682: if (upload_test(f_luby, f_ludate, db_luby,

Line 1686: update FND_TABLES

1682: if (upload_test(f_luby, f_ludate, db_luby,
1683: db_ludate, X_CUSTOM_MODE)) then
1684:
1685: -- Resolve USER_TABLE_NAME by pre-pending '@'
1686: update FND_TABLES
1687: set USER_TABLE_NAME = '@'||USER_TABLE_NAME
1688: where APPLICATION_ID = appl_id
1689: and TABLE_NAME <> x_table_name
1690: and USER_TABLE_NAME = x_user_table_name;

Line 1692: update FND_TABLES set

1688: where APPLICATION_ID = appl_id
1689: and TABLE_NAME <> x_table_name
1690: and USER_TABLE_NAME = x_user_table_name;
1691:
1692: update FND_TABLES set
1693: USER_TABLE_NAME = x_user_table_name,
1694: TABLE_TYPE = x_table_type,
1695: DESCRIPTION = x_description,
1696: AUTO_SIZE = x_auto_size,

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

1779: into appl_id
1780: from FND_APPLICATION A
1781: where A.APPLICATION_SHORT_NAME = x_application_short_name;
1782:
1783: select T.TABLE_ID into tab_id from FND_TABLES T
1784: where T.APPLICATION_ID = appl_id
1785: and T.TABLE_NAME = x_table_name;
1786:
1787: ResolveConflictColumn(appl_id, tab_id, x_column_name, x_user_column_name,

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

2085: into appl_id
2086: from FND_APPLICATION A
2087: where A.APPLICATION_SHORT_NAME = x_application_short_name;
2088:
2089: select T.TABLE_ID into tab_id from FND_TABLES T
2090: where T.APPLICATION_ID = appl_id
2091: and T.TABLE_NAME = x_table_name;
2092:
2093: -- Bug2631776 In this section handle the parent entity

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

2380: into appl_id
2381: from FND_APPLICATION A
2382: where A.APPLICATION_SHORT_NAME = x_application_short_name;
2383:
2384: select T.TABLE_ID into tab_id from FND_TABLES T
2385: where T.APPLICATION_ID = appl_id
2386: and T.TABLE_NAME = x_table_name;
2387:
2388: select I.INDEX_ID into idx_id from FND_INDEXES I

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

2493: into appl_id
2494: from FND_APPLICATION A
2495: where A.APPLICATION_SHORT_NAME = x_application_short_name;
2496:
2497: select T.TABLE_ID into tab_id from FND_TABLES T
2498: where T.APPLICATION_ID = appl_id
2499: and T.TABLE_NAME = x_table_name;
2500:
2501: -- Validation on primary_key_type, audit_flag and enabled_flag

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

2839: into appl_id
2840: from FND_APPLICATION A
2841: where A.APPLICATION_SHORT_NAME = x_application_short_name;
2842:
2843: select T.TABLE_ID into tab_id from FND_TABLES T
2844: where T.APPLICATION_ID = appl_id
2845: and T.TABLE_NAME = x_table_name;
2846:
2847: select P.PRIMARY_KEY_ID into pk_id from FND_PRIMARY_KEYS P

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

2951: into appl_id
2952: from FND_APPLICATION A
2953: where A.APPLICATION_SHORT_NAME = x_application_short_name;
2954:
2955: select T.TABLE_ID into tab_id from FND_TABLES T
2956: where T.APPLICATION_ID = appl_id
2957: and T.TABLE_NAME = x_table_name;
2958:
2959: -- Validate if primary key exists

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

3256: into appl_id
3257: from FND_APPLICATION A
3258: where A.APPLICATION_SHORT_NAME = x_application_short_name;
3259:
3260: select T.TABLE_ID into tab_id from FND_TABLES T
3261: where T.APPLICATION_ID = appl_id
3262: and T.TABLE_NAME = x_table_name;
3263:
3264: select F.FOREIGN_KEY_ID into fk_id from FND_FOREIGN_KEYS F