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_APPLICATION

Line 49: FND_APPLICATION A

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

Line 1109: from fnd_application

1105: begin
1106: begin
1107: select application_id
1108: into appl_id
1109: from fnd_application
1110: where application_short_name = upper(x_application_short_name);
1111: exception
1112: when no_data_found then
1113: RAISE_APPLICATION_ERROR(

Line 1114: -20001, 'Fnd Application value '

1110: where application_short_name = upper(x_application_short_name);
1111: exception
1112: when no_data_found then
1113: RAISE_APPLICATION_ERROR(
1114: -20001, 'Fnd Application value '
1115: || x_application_short_name
1116: || ' not found in the table fnd_application ', TRUE);
1117: return;
1118: end;

Line 1116: || ' not found in the table fnd_application ', TRUE);

1112: when no_data_found then
1113: RAISE_APPLICATION_ERROR(
1114: -20001, 'Fnd Application value '
1115: || x_application_short_name
1116: || ' not found in the table fnd_application ', TRUE);
1117: return;
1118: end;
1119:
1120: begin

Line 1227: from fnd_application

1223: begin
1224: begin
1225: select application_id
1226: into appl_id
1227: from fnd_application
1228: where application_short_name = upper(x_application_short_name);
1229: exception
1230: when no_data_found then
1231: RAISE_APPLICATION_ERROR(

Line 1232: -20001, 'No data found in fnd_application for short name '

1228: where application_short_name = upper(x_application_short_name);
1229: exception
1230: when no_data_found then
1231: RAISE_APPLICATION_ERROR(
1232: -20001, 'No data found in fnd_application for short name '
1233: || x_application_short_name , TRUE);
1234: return;
1235: end;
1236:

Line 1297: from fnd_application

1293: begin
1294: begin
1295: select application_id
1296: into appl_id
1297: from fnd_application
1298: where application_short_name = upper(x_application_short_name);
1299: exception
1300: when no_data_found then
1301: RAISE_APPLICATION_ERROR(

Line 1302: -20001, 'No data found in fnd_application for short name '

1298: where application_short_name = upper(x_application_short_name);
1299: exception
1300: when no_data_found then
1301: RAISE_APPLICATION_ERROR(
1302: -20001, 'No data found in fnd_application for short name '
1303: || x_application_short_name , TRUE);
1304: return;
1305: end;
1306:

Line 1383: from fnd_application

1379: begin
1380: begin
1381: select application_id
1382: into appl_id
1383: from fnd_application
1384: where application_short_name = upper(x_application_short_name);
1385: exception
1386: when no_data_found then
1387: RAISE_APPLICATION_ERROR(

Line 1388: -20001, 'Sql no data found in fnd_application for application short name '

1384: where application_short_name = upper(x_application_short_name);
1385: exception
1386: when no_data_found then
1387: RAISE_APPLICATION_ERROR(
1388: -20001, 'Sql no data found in fnd_application for application short name '
1389: || x_application_short_name , TRUE);
1390: return;
1391: end;
1392:

Line 1447: from fnd_application

1443: begin
1444: begin
1445: select application_id
1446: into appl_id
1447: from fnd_application
1448: where application_short_name = upper(x_application_short_name);
1449: exception
1450: when no_data_found then
1451: RAISE_APPLICATION_ERROR(

Line 1452: -20001, 'Sql no data found in fnd_application for application short name '

1448: where application_short_name = upper(x_application_short_name);
1449: exception
1450: when no_data_found then
1451: RAISE_APPLICATION_ERROR(
1452: -20001, 'Sql no data found in fnd_application for application short name '
1453: || x_application_short_name , TRUE);
1454: return;
1455: end;
1456:

Line 1482: from fnd_application

1478: begin
1479: begin
1480: select application_id
1481: into appl_id
1482: from fnd_application
1483: where application_short_name = upper(x_application_short_name);
1484: exception
1485: when no_data_found then
1486: RAISE_APPLICATION_ERROR(

Line 1487: -20001, 'Sql no data found in fnd_application for application short name '

1483: where application_short_name = upper(x_application_short_name);
1484: exception
1485: when no_data_found then
1486: RAISE_APPLICATION_ERROR(
1487: -20001, 'Sql no data found in fnd_application for application short name '
1488: || x_application_short_name , TRUE);
1489: return;
1490: end;
1491:

Line 1550: from fnd_application

1546:
1547: begin
1548: select application_id
1549: into appl_id
1550: from fnd_application
1551: where application_short_name = upper(x_application_short_name);
1552: exception
1553: when no_data_found then
1554: RAISE_APPLICATION_ERROR(

Line 1555: -20001, 'Sql no data found in fnd_application for application short name '

1551: where application_short_name = upper(x_application_short_name);
1552: exception
1553: when no_data_found then
1554: RAISE_APPLICATION_ERROR(
1555: -20001, 'Sql no data found in fnd_application for application short name '
1556: || x_application_short_name , TRUE);
1557: return;
1558: end;
1559:

Line 1643: from FND_APPLICATION A

1639: -- Validate application
1640: begin
1641: select A.APPLICATION_ID
1642: into appl_id
1643: from FND_APPLICATION A
1644: where A.APPLICATION_SHORT_NAME = x_application_short_name;
1645: exception
1646: when no_data_found then
1647: RAISE_APPLICATION_ERROR(

Line 1648: -20001, 'Sql no data found in fnd_application for application short name '

1644: where A.APPLICATION_SHORT_NAME = x_application_short_name;
1645: exception
1646: when no_data_found then
1647: RAISE_APPLICATION_ERROR(
1648: -20001, 'Sql no data found in fnd_application for application short name '
1649: || x_application_short_name , TRUE);
1650: end;
1651:
1652: -- Validate hosted support style

Line 1780: from FND_APPLICATION A

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

Line 1885: from FND_APPLICATION A

1881: -- Because Column is in the same entity as Table, no need to validate
1882: -- Application and Table again.
1883: select A.APPLICATION_ID
1884: into appl_id
1885: from FND_APPLICATION A
1886: where A.APPLICATION_SHORT_NAME = x_application_short_name;
1887:
1888: -- Translate owner to file_last_updated_by
1889: f_luby := owner_id(x_user_id);

Line 1969: from FND_APPLICATION A

1965: -- Because Column is in the same entity as Table, no need to validate
1966: -- Application and Table again.
1967: select A.APPLICATION_ID
1968: into appl_id
1969: from FND_APPLICATION A
1970: where A.APPLICATION_SHORT_NAME = x_application_short_name;
1971:
1972:
1973: -- Translate owner to file_last_updated_by

Line 2086: from FND_APPLICATION A

2082: -- Application and Table again.
2083:
2084: select A.APPLICATION_ID
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

Line 2381: from FND_APPLICATION A

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

Line 2494: from FND_APPLICATION A

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

Line 2840: from FND_APPLICATION A

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

Line 2952: from FND_APPLICATION A

2948: begin
2949:
2950: select A.APPLICATION_ID
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

Line 3257: from FND_APPLICATION A

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

Line 3359: from FND_APPLICATION A

3355: -- Validate Application.
3356: begin
3357: select A.APPLICATION_ID
3358: into appl_id
3359: from FND_APPLICATION A
3360: where A.APPLICATION_SHORT_NAME = x_application_short_name;
3361:
3362: exception
3363: when no_data_found then

Line 3365: -20001, 'No data found Fnd application - application name '

3361:
3362: exception
3363: when no_data_found then
3364: RAISE_APPLICATION_ERROR(
3365: -20001, 'No data found Fnd application - application name '
3366: || x_application_short_name, TRUE);
3367: end;
3368:
3369: -- Translate owner to file_last_updated_by

Line 3456: from FND_APPLICATION A

3452: -- Validate Application
3453: begin
3454: select A.APPLICATION_ID
3455: into appl_id
3456: from FND_APPLICATION A
3457: where A.APPLICATION_SHORT_NAME = x_application_short_name;
3458: exception
3459: when no_data_found then
3460: RAISE_APPLICATION_ERROR(

Line 3461: -20001, 'No data found Fnd application - application name '

3457: where A.APPLICATION_SHORT_NAME = x_application_short_name;
3458: exception
3459: when no_data_found then
3460: RAISE_APPLICATION_ERROR(
3461: -20001, 'No data found Fnd application - application name '
3462: || x_application_short_name, TRUE);
3463: end;
3464:
3465: if (x_phase_mode = 'BEGIN') then

Line 3670: from FND_APPLICATION A

3666: -- No need to validate/check Application and View.
3667: -- Within the same entity.
3668: select A.APPLICATION_ID
3669: into appl_id
3670: from FND_APPLICATION A
3671: where A.APPLICATION_SHORT_NAME = x_application_short_name;
3672:
3673: select V.VIEW_ID into vw_id from FND_VIEWS V
3674: where V.APPLICATION_ID = appl_id