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_APPLICATION

Line 53: FND_APPLICATION A

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
57: and T.TABLE_ID = P.TABLE_ID

Line 1111: from fnd_application

1107: begin
1108: begin
1109: select application_id
1110: into appl_id
1111: from fnd_application
1112: where application_short_name = upper(x_application_short_name);
1113: exception
1114: when no_data_found then
1115: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

Line 1116: fnd_message.set_token('TABLE', 'FND_APPLICATION');

1112: where application_short_name = upper(x_application_short_name);
1113: exception
1114: when no_data_found then
1115: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1116: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1117: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1118: fnd_message.set_token('VALUE', x_application_short_name);
1119: app_exception.raise_exception;
1120: return;

Line 1232: from fnd_application

1228: begin
1229: begin
1230: select application_id
1231: into appl_id
1232: from fnd_application
1233: where application_short_name = upper(x_application_short_name);
1234: exception
1235: when no_data_found then
1236: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

Line 1237: fnd_message.set_token('TABLE', 'FND_APPLICATION');

1233: where application_short_name = upper(x_application_short_name);
1234: exception
1235: when no_data_found then
1236: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1237: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1238: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1239: fnd_message.set_token('VALUE', x_application_short_name);
1240: app_exception.raise_exception;
1241: return;

Line 1308: from fnd_application

1304: begin
1305: begin
1306: select application_id
1307: into appl_id
1308: from fnd_application
1309: where application_short_name = upper(x_application_short_name);
1310: exception
1311: when no_data_found then
1312: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

Line 1313: fnd_message.set_token('TABLE', 'FND_APPLICATION');

1309: where application_short_name = upper(x_application_short_name);
1310: exception
1311: when no_data_found then
1312: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1313: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1314: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1315: fnd_message.set_token('VALUE', x_application_short_name);
1316: app_exception.raise_exception;
1317: return;

Line 1400: from fnd_application

1396: begin
1397: begin
1398: select application_id
1399: into appl_id
1400: from fnd_application
1401: where application_short_name = upper(x_application_short_name);
1402: exception
1403: when no_data_found then
1404: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

Line 1405: fnd_message.set_token('TABLE', 'FND_APPLICATION');

1401: where application_short_name = upper(x_application_short_name);
1402: exception
1403: when no_data_found then
1404: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1405: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1406: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1407: fnd_message.set_token('VALUE', x_application_short_name);
1408: app_exception.raise_exception;
1409: return;

Line 1470: from fnd_application

1466: begin
1467: begin
1468: select application_id
1469: into appl_id
1470: from fnd_application
1471: where application_short_name = upper(x_application_short_name);
1472: exception
1473: when no_data_found then
1474: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

Line 1475: fnd_message.set_token('TABLE', 'FND_APPLICATION');

1471: where application_short_name = upper(x_application_short_name);
1472: exception
1473: when no_data_found then
1474: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1475: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1476: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1477: fnd_message.set_token('VALUE', x_application_short_name);
1478: app_exception.raise_exception;
1479: return;

Line 1509: from fnd_application

1505: begin
1506: begin
1507: select application_id
1508: into appl_id
1509: from fnd_application
1510: where application_short_name = upper(x_application_short_name);
1511: exception
1512: when no_data_found then
1513: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

Line 1514: fnd_message.set_token('TABLE', 'FND_APPLICATION');

1510: where application_short_name = upper(x_application_short_name);
1511: exception
1512: when no_data_found then
1513: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1514: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1515: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1516: fnd_message.set_token('VALUE', x_application_short_name);
1517: app_exception.raise_exception;
1518: return;

Line 1581: from fnd_application

1577:
1578: begin
1579: select application_id
1580: into appl_id
1581: from fnd_application
1582: where application_short_name = upper(x_application_short_name);
1583: exception
1584: when no_data_found then
1585: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

Line 1586: fnd_message.set_token('TABLE', 'FND_APPLICATION');

1582: where application_short_name = upper(x_application_short_name);
1583: exception
1584: when no_data_found then
1585: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1586: fnd_message.set_token('TABLE', 'FND_APPLICATION');
1587: fnd_message.set_token('COLUMN', 'APPLICATION_SHORT_NAME');
1588: fnd_message.set_token('VALUE', x_application_short_name);
1589: app_exception.raise_exception;
1590: return;

Line 1678: from FND_APPLICATION A

1674: -- Validate application
1675: begin
1676: select A.APPLICATION_ID
1677: into appl_id
1678: from FND_APPLICATION A
1679: where A.APPLICATION_SHORT_NAME = x_application_short_name;
1680: exception
1681: when no_data_found then
1682: fnd_message.set_name('FND', 'FND-APPLICATION NAME');

Line 1682: fnd_message.set_name('FND', 'FND-APPLICATION NAME');

1678: from FND_APPLICATION A
1679: where A.APPLICATION_SHORT_NAME = x_application_short_name;
1680: exception
1681: when no_data_found then
1682: fnd_message.set_name('FND', 'FND-APPLICATION NAME');
1683: fnd_message.set_token('APPLICATION_NAME', x_application_short_name);
1684: app_exception.raise_exception;
1685: end;
1686:

Line 1813: from FND_APPLICATION A

1809: -- Because Column is in the same entity as Table, no need to validate
1810: -- Application and Table again.
1811: select A.APPLICATION_ID
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

Line 1918: from FND_APPLICATION A

1914: -- Because Column is in the same entity as Table, no need to validate
1915: -- Application and Table again.
1916: select A.APPLICATION_ID
1917: into appl_id
1918: from FND_APPLICATION A
1919: where A.APPLICATION_SHORT_NAME = x_application_short_name;
1920:
1921: -- Translate owner to file_last_updated_by
1922: f_luby := fnd_load_util.owner_id(x_user_id);

Line 2022: from FND_APPLICATION A

2018: -- Application and Table again.
2019:
2020: select A.APPLICATION_ID
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

Line 2317: from FND_APPLICATION A

2313: -- Because Index Column is in the same entity as Table and Index,
2314: -- no need to validate them again.
2315: select A.APPLICATION_ID
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

Line 2428: from FND_APPLICATION A

2424: -- Because Primary Key is in the same entity as Table, no need to validate
2425: -- Application and Table again.
2426: select A.APPLICATION_ID
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

Line 2760: from FND_APPLICATION A

2756: -- No need to validate/check Application, Table or Primary Key.
2757: -- Within the same entity.
2758: select A.APPLICATION_ID
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

Line 2873: from FND_APPLICATION A

2869: begin
2870:
2871: select A.APPLICATION_ID
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

Line 3186: from FND_APPLICATION A

3182: -- No need to validate/check Application, Table or Foreign Key.
3183: -- Within the same entity.
3184: select A.APPLICATION_ID
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

Line 3289: from FND_APPLICATION A

3285: -- Validate Application.
3286: begin
3287: select A.APPLICATION_ID
3288: into appl_id
3289: from FND_APPLICATION A
3290: where A.APPLICATION_SHORT_NAME = x_application_short_name;
3291:
3292: exception
3293: when no_data_found then

Line 3294: fnd_message.set_name('FND', 'FND-APPLICATION NAME');

3290: where A.APPLICATION_SHORT_NAME = x_application_short_name;
3291:
3292: exception
3293: when no_data_found then
3294: fnd_message.set_name('FND', 'FND-APPLICATION NAME');
3295: fnd_message.set_token('APPLICATION_NAME', x_application_short_name);
3296: app_exception.raise_exception;
3297: end;
3298:

Line 3386: from FND_APPLICATION A

3382: -- Validate Application
3383: begin
3384: select A.APPLICATION_ID
3385: into appl_id
3386: from FND_APPLICATION A
3387: where A.APPLICATION_SHORT_NAME = x_application_short_name;
3388: exception
3389: when no_data_found then
3390: fnd_message.set_name('FND', 'FND-APPLICATION NAME');

Line 3390: fnd_message.set_name('FND', 'FND-APPLICATION NAME');

3386: from FND_APPLICATION A
3387: where A.APPLICATION_SHORT_NAME = x_application_short_name;
3388: exception
3389: when no_data_found then
3390: fnd_message.set_name('FND', 'FND-APPLICATION NAME');
3391: fnd_message.set_token('APPLICATION_NAME', x_application_short_name);
3392: app_exception.raise_exception;
3393: end;
3394:

Line 3600: from FND_APPLICATION A

3596: -- No need to validate/check Application and View.
3597: -- Within the same entity.
3598: select A.APPLICATION_ID
3599: into appl_id
3600: from FND_APPLICATION A
3601: where A.APPLICATION_SHORT_NAME = x_application_short_name;
3602:
3603: select V.VIEW_ID into vw_id from FND_VIEWS V
3604: where V.APPLICATION_ID = appl_id

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