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.AK_KEY_PVT dependencies on AK_FOREIGN_KEY_COLUMNS

Line 658: insert into AK_FOREIGN_KEY_COLUMNS (

654: p_create_or_update => 'CREATE') then
655: null;
656: end if;
657:
658: insert into AK_FOREIGN_KEY_COLUMNS (
659: FOREIGN_KEY_NAME,
660: ATTRIBUTE_APPLICATION_ID,
661: ATTRIBUTE_CODE,
662: FOREIGN_KEY_SEQUENCE,

Line 1488: from AK_FOREIGN_KEY_COLUMNS

1484: p_delete_cascade IN VARCHAR2
1485: ) is
1486: cursor l_get_columns_csr is
1487: select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE
1488: from AK_FOREIGN_KEY_COLUMNS
1489: where FOREIGN_KEY_NAME = p_foreign_key_name;
1490: cursor l_get_relations_csr is
1491: select FLOW_APPLICATION_ID, FLOW_CODE, FROM_PAGE_APPL_ID, FROM_PAGE_CODE,
1492: FROM_REGION_APPL_ID, FROM_REGION_CODE, TO_PAGE_APPL_ID,

Line 1549: -- AK_FOREIGN_KEY_COLUMNS

1545: -- If we are not deleting any referencing records, we cannot
1546: -- delete the foreign key if it is being referenced in any of
1547: -- following tables.
1548: --
1549: -- AK_FOREIGN_KEY_COLUMNS
1550: --
1551: open l_get_columns_csr;
1552: fetch l_get_columns_csr into l_attribute_appl_id, l_attribute_code;
1553: if l_get_columns_csr%found then

Line 1585: -- AK_FOREIGN_KEY_COLUMNS

1581: else
1582: --
1583: -- Otherwise, delete all referencing rows in other tables
1584: --
1585: -- AK_FOREIGN_KEY_COLUMNS
1586: --
1587: open l_get_columns_csr;
1588: loop
1589: fetch l_get_columns_csr into l_attribute_appl_id, l_attribute_code;

Line 1809: delete from ak_foreign_key_columns

1805: --
1806: -- delete foreign key column once we checked that there are no references
1807: -- to it, or all references have been deleted.
1808: --
1809: delete from ak_foreign_key_columns
1810: where foreign_key_name = p_foreign_key_name
1811: and attribute_application_id = p_attribute_application_id
1812: and attribute_code = p_attribute_code;
1813:

Line 2131: from AK_FOREIGN_KEY_COLUMNS fkc,

2127: ) is
2128: cursor l_get_fkc_csr is
2129: select fkc.FOREIGN_KEY_NAME, fkc.ATTRIBUTE_APPLICATION_ID,
2130: fkc.ATTRIBUTE_CODE
2131: from AK_FOREIGN_KEY_COLUMNS fkc,
2132: AK_FOREIGN_KEYS fk,
2133: AK_UNIQUE_KEY_COLUMNS pkc
2134: where fk.unique_key_name = pkc.unique_key_name
2135: and fk.foreign_key_name = fkc.foreign_key_name

Line 2189: -- AK_FOREIGN_KEY_COLUMNS

2185: -- If we are not deleting any referencing records, we cannot
2186: -- delete the unique key column if it is being referenced in any of
2187: -- following tables.
2188: --
2189: -- AK_FOREIGN_KEY_COLUMNS
2190: --
2191: open l_get_fkc_csr;
2192: fetch l_get_fkc_csr into l_foreign_key_name, l_attribute_appl_id,
2193: l_attribute_code;

Line 2207: -- AK_FOREIGN_KEY_COLUMNS

2203: else
2204: --
2205: -- Otherwise, delete all referencing rows in other tables
2206: --
2207: -- AK_FOREIGN_KEY_COLUMNS
2208: --
2209: open l_get_fkc_csr;
2210: loop
2211: fetch l_get_fkc_csr into l_foreign_key_name, l_attribute_appl_id,

Line 2393: from AK_FOREIGN_KEY_COLUMNS

2389: p_attribute_code IN VARCHAR2
2390: ) return BOOLEAN is
2391: cursor l_check_csr is
2392: select 1
2393: from AK_FOREIGN_KEY_COLUMNS
2394: where FOREIGN_KEY_NAME = p_foreign_key_name
2395: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
2396: and ATTRIBUTE_CODE = p_attribute_code;
2397: l_api_version_number CONSTANT number := 1.0;

Line 2996: from AK_FOREIGN_KEY_COLUMNS

2992: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
2993: ) is
2994: cursor l_get_row_csr is
2995: select *
2996: from AK_FOREIGN_KEY_COLUMNS
2997: where FOREIGN_KEY_NAME = p_foreign_key_name
2998: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
2999: and ATTRIBUTE_CODE = p_attribute_code
3000: for update of FOREIGN_KEY_SEQUENCE;

Line 3005: l_key_column_rec ak_foreign_key_columns%ROWTYPE;

3001: l_api_version_number CONSTANT number := 1.0;
3002: l_api_name CONSTANT varchar2(30):= 'Update_Foreign_Key_Column';
3003: l_created_by number;
3004: l_creation_date date;
3005: l_key_column_rec ak_foreign_key_columns%ROWTYPE;
3006: l_error boolean;
3007: l_last_update_date date;
3008: l_last_update_login number;
3009: l_last_updated_by number;

Line 3028: -- retrieve ak_foreign_key_columns row if it exists

3024: end if;
3025:
3026: savepoint start_update_key_column;
3027:
3028: --** retrieve ak_foreign_key_columns row if it exists **
3029: open l_get_row_csr;
3030: fetch l_get_row_csr into l_key_column_rec;
3031: if (l_get_row_csr%notfound) then
3032: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 3159: update AK_FOREIGN_KEY_COLUMNS set

3155: p_db_last_update_date => l_key_column_rec.last_update_date,
3156: p_last_update_login => l_last_update_login,
3157: p_create_or_update => 'UPDATE') then
3158:
3159: update AK_FOREIGN_KEY_COLUMNS set
3160: FOREIGN_KEY_SEQUENCE = l_key_column_rec.foreign_key_sequence,
3161: ATTRIBUTE_CATEGORY = l_key_column_rec.attribute_category,
3162: ATTRIBUTE1 = l_key_column_rec.attribute1,
3163: ATTRIBUTE2 = l_key_column_rec.attribute2,

Line 4603: from AK_FOREIGN_KEY_COLUMNS

4599: p_foreign_key_sequence IN NUMBER
4600: ) is
4601: cursor l_check_csr is
4602: select ATTRIBUTE_CODE, ATTRIBUTE_APPLICATION_ID
4603: from AK_FOREIGN_KEY_COLUMNS
4604: where FOREIGN_KEY_NAME = p_foreign_key_name
4605: and FOREIGN_KEY_SEQUENCE = p_foreign_key_sequence;
4606: l_api_version_number CONSTANT number := 1.0;
4607: l_api_name CONSTANT varchar2(30) := 'Cbeck_Foreign_Key_Sequence';

Line 4696: from AK_FOREIGN_KEY_COLUMNS

4692: ) is
4693:
4694: cursor l_get_columns_csr is
4695: select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE
4696: from AK_FOREIGN_KEY_COLUMNS
4697: where FOREIGN_KEY_NAME = p_foreign_key_name;
4698:
4699: l_api_name CONSTANT varchar2(30):= 'Delete_Related_Foreign_Key_Col';
4700: l_msg_count NUMBER;