APPS.FND_DICTIONARY_PKG dependencies on FND_PRIMARY_KEYS

Line 22: from FND_PRIMARY_KEYS

18: l_tmp number;
19: begin
20: select count(*)
21: into l_tmp
22: from FND_PRIMARY_KEYS
23: where APPLICATION_ID = x_application_id
24: and TABLE_ID = x_table_id
25: and PRIMARY_KEY_NAME <> upper(x_primary_key_name)
26: and PRIMARY_KEY_TYPE = 'D';

Line 51: from FND_PRIMARY_KEYS P,

47: begin
48: begin
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

Line 347: -- Add a new primary key into FND_PRIMARY_KEYS.

343: end InsertIndex;
344:
345: --
346: -- InsertPrimaryKey (PRIVATE))
347: -- Add a new primary key into FND_PRIMARY_KEYS.
348: -- This is only called after checking
349: -- there is no such primary key exists in UploadPrimaryKey().
350: --
351: procedure InsertPrimaryKey(

Line 368: insert into FND_PRIMARY_KEYS(

364: ) is
365:
366: begin
367:
368: insert into FND_PRIMARY_KEYS(
369: APPLICATION_ID,
370: TABLE_ID,
371: PRIMARY_KEY_NAME,
372: PRIMARY_KEY_ID,

Line 386: FND_PRIMARY_KEYS_S.NEXTVAL,

382: values (
383: x_application_id,
384: x_table_id,
385: x_primary_key_name,
386: FND_PRIMARY_KEYS_S.NEXTVAL,
387: x_primary_key_type,
388: x_audit_key_flag,
389: x_enabled_flag,
390: x_description,

Line 1292: -- Remove primary key from FND_PRIMARY_KEYS and FND_PRIMARY_KEY_COLUMNS table.

1288: end RemoveIndex;
1289:
1290: --
1291: -- RemovePrimaryKey (PUBLIC)
1292: -- Remove primary key from FND_PRIMARY_KEYS and FND_PRIMARY_KEY_COLUMNS table.
1293: -- Before deleting primary key, make sure that there is no foreign key
1294: -- pointing to this primary key
1295: --
1296: procedure RemovePrimaryKey(

Line 1339: from fnd_primary_keys

1335:
1336: begin
1337: select primary_key_id
1338: into pk_id
1339: from fnd_primary_keys
1340: where application_id = appl_id
1341: and table_id = tab_id
1342: and primary_key_name = upper(x_primary_key_name);
1343: exception

Line 1346: fnd_message.set_token('TABLE', 'FND_PRIMARY_KEYS');

1342: and primary_key_name = upper(x_primary_key_name);
1343: exception
1344: when no_data_found then
1345: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1346: fnd_message.set_token('TABLE', 'FND_PRIMARY_KEYS');
1347: fnd_message.set_token('COLUMN', 'PRIMARY_KEY_NAME');
1348: fnd_message.set_token('VALUE', x_primary_key_name);
1349: app_exception.raise_exception;
1350: return;

Line 1369: delete from fnd_primary_keys

1365: where application_id = appl_id
1366: and table_id = tab_id
1367: and primary_key_id = pk_id;
1368:
1369: delete from fnd_primary_keys
1370: where application_id = appl_id
1371: and table_id = tab_id
1372: and primary_key_id = pk_id;
1373:

Line 1572: from fnd_primary_keys

1568: and table_id = tab_id;
1569:
1570: cursor pk is
1571: select primary_key_name
1572: from fnd_primary_keys
1573: where application_id = appl_id
1574: and table_id = tab_id;
1575:
1576: begin

Line 2495: from FND_PRIMARY_KEYS

2491:
2492: begin
2493: select LAST_UPDATED_BY, LAST_UPDATE_DATE
2494: into db_luby, db_ludate
2495: from FND_PRIMARY_KEYS
2496: where APPLICATION_ID = appl_id
2497: and TABLE_ID = tab_id
2498: and PRIMARY_KEY_NAME = x_primary_key_name;
2499:

Line 2504: update FND_PRIMARY_KEYS set

2500: if (pkmode = 'UPDATE') then
2501:
2502: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
2503: db_ludate, X_CUSTOM_MODE)) then
2504: update FND_PRIMARY_KEYS set
2505: PRIMARY_KEY_TYPE = x_primary_key_type,
2506: AUDIT_KEY_FLAG = x_audit_key_flag,
2507: ENABLED_FLAG = x_enabled_flag,
2508: DESCRIPTION = x_description,

Line 2767: select P.PRIMARY_KEY_ID into pk_id from FND_PRIMARY_KEYS P

2763: select T.TABLE_ID into tab_id from FND_TABLES T
2764: where T.APPLICATION_ID = appl_id
2765: and T.TABLE_NAME = x_table_name;
2766:
2767: select P.PRIMARY_KEY_ID into pk_id from FND_PRIMARY_KEYS P
2768: where P.APPLICATION_ID = appl_id
2769: and P.TABLE_ID = tab_id
2770: and P.PRIMARY_KEY_NAME = x_primary_key_name;
2771:

Line 4054: from fnd_primary_keys p

4050:
4051: -- Fetch all primary keys in this table
4052: cursor pks(aid number, tid number) is
4053: select p.primary_key_id, p.primary_key_name
4054: from fnd_primary_keys p
4055: where p.application_id = aid
4056: and p.table_id = tid;
4057:
4058: hasChild boolean := FALSE;