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 1642: AD_ZD_SEED.PREPARE ('FND_TABLES');

1638: begin
1639: if (P_NZDT_MODE ='Y')
1640: then
1641: begin
1642: AD_ZD_SEED.PREPARE ('FND_TABLES');
1643: end;
1644: end if;
1645:
1646: -- Validate application

Line 1685: from FND_TABLES

1681:
1682: begin
1683: select LAST_UPDATED_BY, LAST_UPDATE_DATE
1684: into db_luby, db_ludate
1685: from FND_TABLES
1686: where APPLICATION_ID = appl_id
1687: and TABLE_NAME = x_table_name;
1688:
1689: if (upload_test(f_luby, f_ludate, db_luby,

Line 1693: update FND_TABLES

1689: if (upload_test(f_luby, f_ludate, db_luby,
1690: db_ludate, X_CUSTOM_MODE)) then
1691:
1692: -- Resolve USER_TABLE_NAME by pre-pending '@'
1693: update FND_TABLES
1694: set USER_TABLE_NAME = '@'||USER_TABLE_NAME
1695: where APPLICATION_ID = appl_id
1696: and TABLE_NAME <> x_table_name
1697: and USER_TABLE_NAME = x_user_table_name;

Line 1699: update FND_TABLES set

1695: where APPLICATION_ID = appl_id
1696: and TABLE_NAME <> x_table_name
1697: and USER_TABLE_NAME = x_user_table_name;
1698:
1699: update FND_TABLES set
1700: USER_TABLE_NAME = x_user_table_name,
1701: TABLE_TYPE = x_table_type,
1702: DESCRIPTION = x_description,
1703: AUTO_SIZE = x_auto_size,

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

1792: into appl_id
1793: from FND_APPLICATION A
1794: where A.APPLICATION_SHORT_NAME = x_application_short_name;
1795:
1796: select T.TABLE_ID into tab_id from FND_TABLES T
1797: where T.APPLICATION_ID = appl_id
1798: and T.TABLE_NAME = x_table_name;
1799:
1800: ResolveConflictColumn(appl_id, tab_id, x_column_name, x_user_column_name,

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

2110: into appl_id
2111: from FND_APPLICATION A
2112: where A.APPLICATION_SHORT_NAME = x_application_short_name;
2113:
2114: select T.TABLE_ID into tab_id from FND_TABLES T
2115: where T.APPLICATION_ID = appl_id
2116: and T.TABLE_NAME = x_table_name;
2117:
2118: -- Bug2631776 In this section handle the parent entity

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

2405: into appl_id
2406: from FND_APPLICATION A
2407: where A.APPLICATION_SHORT_NAME = x_application_short_name;
2408:
2409: select T.TABLE_ID into tab_id from FND_TABLES T
2410: where T.APPLICATION_ID = appl_id
2411: and T.TABLE_NAME = x_table_name;
2412:
2413: select I.INDEX_ID into idx_id from FND_INDEXES I

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

2526: into appl_id
2527: from FND_APPLICATION A
2528: where A.APPLICATION_SHORT_NAME = x_application_short_name;
2529:
2530: select T.TABLE_ID into tab_id from FND_TABLES T
2531: where T.APPLICATION_ID = appl_id
2532: and T.TABLE_NAME = x_table_name;
2533:
2534: -- Validation on primary_key_type, audit_flag and enabled_flag

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

2878: into appl_id
2879: from FND_APPLICATION A
2880: where A.APPLICATION_SHORT_NAME = x_application_short_name;
2881:
2882: select T.TABLE_ID into tab_id from FND_TABLES T
2883: where T.APPLICATION_ID = appl_id
2884: and T.TABLE_NAME = x_table_name;
2885:
2886: select P.PRIMARY_KEY_ID into pk_id from FND_PRIMARY_KEYS P

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

2997: into appl_id
2998: from FND_APPLICATION A
2999: where A.APPLICATION_SHORT_NAME = x_application_short_name;
3000:
3001: select T.TABLE_ID into tab_id from FND_TABLES T
3002: where T.APPLICATION_ID = appl_id
3003: and T.TABLE_NAME = x_table_name;
3004:
3005: -- Validate if primary key exists

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

3308: into appl_id
3309: from FND_APPLICATION A
3310: where A.APPLICATION_SHORT_NAME = x_application_short_name;
3311:
3312: select T.TABLE_ID into tab_id from FND_TABLES T
3313: where T.APPLICATION_ID = appl_id
3314: and T.TABLE_NAME = x_table_name;
3315:
3316: select F.FOREIGN_KEY_ID into fk_id from FND_FOREIGN_KEYS F