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_FOREIGN_KEYS

Line 396: -- Add a new foreign key into FND_FOREIGN_KEYS.

392: end InsertPrimaryKey;
393:
394: --
395: -- InsertForeignKey (PRIVATE))
396: -- Add a new foreign key into FND_FOREIGN_KEYS.
397: -- This is only called after checking
398: -- there is no such foreign key exists in UploadForeignKey().
399: --
400: procedure InsertForeignKey(

Line 421: insert into FND_FOREIGN_KEYS(

417: ) is
418:
419: begin
420:
421: insert into FND_FOREIGN_KEYS(
422: APPLICATION_ID,
423: TABLE_ID,
424: FOREIGN_KEY_ID,
425: FOREIGN_KEY_NAME,

Line 442: FND_FOREIGN_KEYS_S.NEXTVAL,

438: CREATED_BY)
439: values (
440: x_application_id,
441: x_table_id,
442: FND_FOREIGN_KEYS_S.NEXTVAL,
443: x_foreign_key_name,
444: x_primary_key_application_id,
445: x_primary_key_table_id,
446: x_primary_key_id,

Line 1341: from fnd_foreign_keys

1337: -- pointing to this primary key
1338:
1339: cnt := 0;
1340: select count(*) into cnt
1341: from fnd_foreign_keys
1342: where primary_key_application_id = appl_id
1343: and primary_key_table_id = tab_id
1344: and primary_key_id = pk_id;
1345:

Line 1370: -- Remove foreign key from FND_FOREIGN_KEYS and FND_FOREIGN_KEY_COLUMNS table.

1366: end RemovePrimaryKey;
1367:
1368: --
1369: -- RemoveForeignKey (PUBLIC)
1370: -- Remove foreign key from FND_FOREIGN_KEYS and FND_FOREIGN_KEY_COLUMNS table.
1371: --
1372: procedure RemoveForeignKey(
1373: x_application_short_name in varchar2,
1374: x_table_name in varchar2,

Line 1410: from fnd_foreign_keys

1406:
1407: begin
1408: select foreign_key_id
1409: into fk_id
1410: from fnd_foreign_keys
1411: where application_id = appl_id
1412: and table_id = tab_id
1413: and foreign_key_name = upper(x_foreign_key_name);
1414: exception

Line 1417: -20001, 'Sql no data found in fnd_foreign_keys for for foreign key name '

1413: and foreign_key_name = upper(x_foreign_key_name);
1414: exception
1415: when no_data_found then
1416: RAISE_APPLICATION_ERROR(
1417: -20001, 'Sql no data found in fnd_foreign_keys for for foreign key name '
1418: || x_foreign_key_name , TRUE);
1419: return;
1420: end;
1421:

Line 1428: delete from fnd_foreign_keys

1424: where application_id = appl_id
1425: and table_id = tab_id
1426: and foreign_key_id = fk_id;
1427:
1428: delete from fnd_foreign_keys
1429: where application_id = appl_id
1430: and table_id = tab_id
1431: and foreign_key_id = fk_id;
1432:

Line 1535: from fnd_foreign_keys

1531: and table_id = tab_id;
1532:
1533: cursor fk is
1534: select foreign_key_name
1535: from fnd_foreign_keys
1536: where application_id = appl_id
1537: and table_id = tab_id;
1538:
1539: cursor pk is

Line 2986: from FND_FOREIGN_KEYS

2982: begin
2983:
2984: select FOREIGN_KEY_ID
2985: into fk_id
2986: from FND_FOREIGN_KEYS
2987: where APPLICATION_ID = appl_id
2988: and TABLE_ID = tab_id
2989: and FOREIGN_KEY_NAME = x_foreign_key_name;
2990:

Line 2993: from FND_FOREIGN_KEYS

2989: and FOREIGN_KEY_NAME = x_foreign_key_name;
2990:
2991: select LAST_UPDATED_BY, LAST_UPDATE_DATE
2992: into db_luby, db_ludate
2993: from FND_FOREIGN_KEYS
2994: where APPLICATION_ID = appl_id
2995: and TABLE_ID = tab_id
2996: and FOREIGN_KEY_NAME = x_foreign_key_name;
2997:

Line 3001: update FND_FOREIGN_KEYS set

2997:
2998: if (upload_test(f_luby, f_ludate, db_luby,
2999: db_ludate, X_CUSTOM_MODE)) then
3000:
3001: update FND_FOREIGN_KEYS set
3002: PRIMARY_KEY_APPLICATION_ID = pk_appl_id,
3003: PRIMARY_KEY_TABLE_ID = pk_tab_id,
3004: PRIMARY_KEY_ID = pk_id,
3005: CASCADE_BEHAVIOR = x_cascade_behavior,

Line 3075: from FND_FOREIGN_KEYS

3071: else -- phase_mode = 'END'
3072:
3073: select FOREIGN_KEY_ID
3074: into fk_id
3075: from FND_FOREIGN_KEYS
3076: where APPLICATION_ID = appl_id
3077: and TABLE_ID = tab_id
3078: and FOREIGN_KEY_NAME = x_foreign_key_name;
3079:

Line 3264: select F.FOREIGN_KEY_ID into fk_id from FND_FOREIGN_KEYS F

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
3265: where F.APPLICATION_ID = appl_id
3266: and F.TABLE_ID = tab_id
3267: and F.FOREIGN_KEY_NAME = x_foreign_key_name;
3268: