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 1650: from FND_APPLICATION A

1646: -- Validate application
1647: begin
1648: select A.APPLICATION_ID
1649: into appl_id
1650: from FND_APPLICATION A
1651: where A.APPLICATION_SHORT_NAME = x_application_short_name;
1652: exception
1653: when no_data_found then
1654: RAISE_APPLICATION_ERROR(

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

1651: where A.APPLICATION_SHORT_NAME = x_application_short_name;
1652: exception
1653: when no_data_found then
1654: RAISE_APPLICATION_ERROR(
1655: -20001, 'Sql no data found in fnd_application for application short name '
1656: || x_application_short_name , TRUE);
1657: end;
1658:
1659: -- Validate hosted support style

Line 1793: from FND_APPLICATION A

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

Line 1904: from FND_APPLICATION A

1900: -- Because Column is in the same entity as Table, no need to validate
1901: -- Application and Table again.
1902: select A.APPLICATION_ID
1903: into appl_id
1904: from FND_APPLICATION A
1905: where A.APPLICATION_SHORT_NAME = x_application_short_name;
1906:
1907: -- Translate owner to file_last_updated_by
1908: f_luby := owner_id(x_user_id);

Line 1994: from FND_APPLICATION A

1990: -- Because Column is in the same entity as Table, no need to validate
1991: -- Application and Table again.
1992: select A.APPLICATION_ID
1993: into appl_id
1994: from FND_APPLICATION A
1995: where A.APPLICATION_SHORT_NAME = x_application_short_name;
1996:
1997:
1998: -- Translate owner to file_last_updated_by

Line 2111: from FND_APPLICATION A

2107: -- Application and Table again.
2108:
2109: select A.APPLICATION_ID
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

Line 2406: from FND_APPLICATION A

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

Line 2527: from FND_APPLICATION A

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

Line 2879: from FND_APPLICATION A

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

Line 2998: from FND_APPLICATION A

2994: end;
2995: end if;
2996: select A.APPLICATION_ID
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

Line 3309: from FND_APPLICATION A

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

Line 3411: from FND_APPLICATION A

3407: -- Validate Application.
3408: begin
3409: select A.APPLICATION_ID
3410: into appl_id
3411: from FND_APPLICATION A
3412: where A.APPLICATION_SHORT_NAME = x_application_short_name;
3413:
3414: exception
3415: when no_data_found then

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

3413:
3414: exception
3415: when no_data_found then
3416: RAISE_APPLICATION_ERROR(
3417: -20001, 'No data found Fnd application - application name '
3418: || x_application_short_name, TRUE);
3419: end;
3420:
3421: -- Translate owner to file_last_updated_by

Line 3516: from FND_APPLICATION A

3512: end if;
3513: begin
3514: select A.APPLICATION_ID
3515: into appl_id
3516: from FND_APPLICATION A
3517: where A.APPLICATION_SHORT_NAME = x_application_short_name;
3518: exception
3519: when no_data_found then
3520: RAISE_APPLICATION_ERROR(

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

3517: where A.APPLICATION_SHORT_NAME = x_application_short_name;
3518: exception
3519: when no_data_found then
3520: RAISE_APPLICATION_ERROR(
3521: -20001, 'No data found Fnd application - application name '
3522: || x_application_short_name, TRUE);
3523: end;
3524:
3525: if (x_phase_mode = 'BEGIN') then

Line 3730: from FND_APPLICATION A

3726: -- No need to validate/check Application and View.
3727: -- Within the same entity.
3728: select A.APPLICATION_ID
3729: into appl_id
3730: from FND_APPLICATION A
3731: where A.APPLICATION_SHORT_NAME = x_application_short_name;
3732:
3733: select V.VIEW_ID into vw_id from FND_VIEWS V
3734: where V.APPLICATION_ID = appl_id