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_KEYS

Line 270: insert into AK_FOREIGN_KEYS (

266:
267: select userenv('LANG') into l_lang
268: from dual;
269:
270: insert into AK_FOREIGN_KEYS (
271: FOREIGN_KEY_NAME,
272: DATABASE_OBJECT_NAME,
273: UNIQUE_KEY_NAME,
274: APPLICATION_ID,

Line 337: insert into AK_FOREIGN_KEYS_TL (

333: --dbms_output.put_line(G_PKG_NAME || 'Error - First insert failed');
334: raise FND_API.G_EXC_ERROR;
335: end if;
336:
337: insert into AK_FOREIGN_KEYS_TL (
338: FOREIGN_KEY_NAME,
339: LANGUAGE,
340: FROM_TO_NAME,
341: FROM_TO_DESCRIPTION,

Line 367: from AK_FOREIGN_KEYS_TL T

363: from FND_LANGUAGES L
364: where L.INSTALLED_FLAG in ('I', 'B')
365: and not exists
366: (select NULL
367: from AK_FOREIGN_KEYS_TL T
368: where T.FOREIGN_KEY_NAME = p_foreign_key_name
369: and T.LANGUAGE = L.LANGUAGE_CODE);
370:
371: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN

Line 1653: delete from ak_foreign_keys

1649: --
1650: -- delete foreign key once we checked that there are no references
1651: -- to it, or all references have been deleted.
1652: --
1653: delete from ak_foreign_keys
1654: where foreign_key_name = p_foreign_key_name;
1655:
1656: if (sql%notfound) then
1657: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 1664: delete from ak_foreign_keys_tl

1660: end if;
1661: raise FND_API.G_EXC_ERROR;
1662: end if;
1663:
1664: delete from ak_foreign_keys_tl
1665: where foreign_key_name = p_foreign_key_name;
1666:
1667: if (sql%notfound) then
1668: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 1906: from AK_FOREIGN_KEYS

1902: from AK_UNIQUE_KEY_COLUMNS
1903: where UNIQUE_KEY_NAME = p_unique_key_name;
1904: cursor l_get_fk_csr is
1905: select FOREIGN_KEY_NAME
1906: from AK_FOREIGN_KEYS
1907: where UNIQUE_KEY_NAME = p_unique_key_name;
1908:
1909: l_api_version_number CONSTANT number := 1.0;
1910: l_api_name CONSTANT varchar2(30):= 'Delete_Unique_Key';

Line 1967: -- AK_FOREIGN_KEYS

1963: raise FND_API.G_EXC_ERROR;
1964: end if;
1965: close l_get_columns_csr;
1966: --
1967: -- AK_FOREIGN_KEYS
1968: --
1969: open l_get_fk_csr;
1970: fetch l_get_fk_csr into l_foreign_key_name;
1971: if l_get_fk_csr%found then

Line 2132: AK_FOREIGN_KEYS fk,

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
2136: and fkc.foreign_key_sequence = pkc.unique_key_sequence

Line 2323: from AK_FOREIGN_KEYS

2319: p_foreign_key_name IN VARCHAR2
2320: ) return BOOLEAN is
2321: cursor l_check_csr is
2322: select 1
2323: from AK_FOREIGN_KEYS
2324: where FOREIGN_KEY_NAME = p_foreign_key_name;
2325: l_api_version_number CONSTANT number := 1.0;
2326: l_api_name CONSTANT varchar2(30) := 'Foreign_Key_Exists';
2327: l_dummy number;

Line 2618: from AK_FOREIGN_KEYS

2614: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
2615: ) is
2616: cursor l_get_row_csr is
2617: select *
2618: from AK_FOREIGN_KEYS
2619: where FOREIGN_KEY_NAME = p_foreign_key_name
2620: for update of DATABASE_OBJECT_NAME;
2621: cursor l_get_tl_row_csr (lang_parm varchar2) is
2622: select *

Line 2623: from AK_FOREIGN_KEYS_TL

2619: where FOREIGN_KEY_NAME = p_foreign_key_name
2620: for update of DATABASE_OBJECT_NAME;
2621: cursor l_get_tl_row_csr (lang_parm varchar2) is
2622: select *
2623: from AK_FOREIGN_KEYS_TL
2624: where FOREIGN_KEY_NAME = p_foreign_key_name
2625: and LANGUAGE = lang_parm
2626: for update of FROM_TO_NAME;
2627: l_api_version_number CONSTANT number := 1.0;

Line 2631: l_foreign_key_rec ak_foreign_keys%ROWTYPE;

2627: l_api_version_number CONSTANT number := 1.0;
2628: l_api_name CONSTANT varchar2(30):= 'Update_Foreign_Key';
2629: l_created_by number;
2630: l_creation_date date;
2631: l_foreign_key_rec ak_foreign_keys%ROWTYPE;
2632: l_foreign_key_tl_rec ak_foreign_keys_tl%ROWTYPE;
2633: l_error boolean;
2634: l_lang varchar2(30);
2635: l_last_update_date date;

Line 2632: l_foreign_key_tl_rec ak_foreign_keys_tl%ROWTYPE;

2628: l_api_name CONSTANT varchar2(30):= 'Update_Foreign_Key';
2629: l_created_by number;
2630: l_creation_date date;
2631: l_foreign_key_rec ak_foreign_keys%ROWTYPE;
2632: l_foreign_key_tl_rec ak_foreign_keys_tl%ROWTYPE;
2633: l_error boolean;
2634: l_lang varchar2(30);
2635: l_last_update_date date;
2636: l_last_update_login number;

Line 2660: -- retrieve ak_foreign_keys row if it exists

2656:
2657: select userenv('LANG') into l_lang
2658: from dual;
2659:
2660: --** retrieve ak_foreign_keys row if it exists **
2661: open l_get_row_csr;
2662: fetch l_get_row_csr into l_foreign_key_rec;
2663: if (l_get_row_csr%notfound) then
2664: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 2674: -- retrieve ak_foreign_keys_tl row if it exists

2670: raise FND_API.G_EXC_ERROR;
2671: end if;
2672: close l_get_row_csr;
2673:
2674: --** retrieve ak_foreign_keys_tl row if it exists **
2675: open l_get_tl_row_csr(l_lang);
2676: fetch l_get_tl_row_csr into l_foreign_key_tl_rec;
2677: if (l_get_tl_row_csr%notfound) then
2678: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 2835: update AK_FOREIGN_KEYS set

2831: p_db_last_update_date => l_foreign_key_rec.last_update_date,
2832: p_last_update_login => l_last_update_login,
2833: p_create_or_update => 'UPDATE') then
2834:
2835: update AK_FOREIGN_KEYS set
2836: DATABASE_OBJECT_NAME = l_foreign_key_rec.database_object_name,
2837: UNIQUE_KEY_NAME = l_foreign_key_rec.unique_key_name,
2838: APPLICATION_ID = l_foreign_key_rec.application_id,
2839: ATTRIBUTE_CATEGORY = l_foreign_key_rec.attribute_category,

Line 2868: update AK_FOREIGN_KEYS_TL set

2864: -- dbms_output.put_line('Row does not exist during update');
2865: raise FND_API.G_EXC_ERROR;
2866: end if;
2867:
2868: update AK_FOREIGN_KEYS_TL set
2869: FROM_TO_NAME = l_foreign_key_tl_rec.from_to_name,
2870: FROM_TO_DESCRIPTION = l_foreign_key_tl_rec.from_to_description,
2871: TO_FROM_NAME = l_foreign_key_tl_rec.to_from_name,
2872: TO_FROM_DESCRIPTION = l_foreign_key_tl_rec.to_from_description,

Line 4083: from AK_FOREIGN_KEYS

4079: p_pass IN NUMBER := 2
4080: ) return BOOLEAN is
4081: cursor l_check_fk_csr is
4082: select database_object_name
4083: from AK_FOREIGN_KEYS
4084: where FOREIGN_KEY_NAME = p_foreign_key_name;
4085: cursor l_check_seq_csr is
4086: select 1
4087: from AK_UNIQUE_KEY_COLUMNS pkc, AK_FOREIGN_KEYS fk

Line 4087: from AK_UNIQUE_KEY_COLUMNS pkc, AK_FOREIGN_KEYS fk

4083: from AK_FOREIGN_KEYS
4084: where FOREIGN_KEY_NAME = p_foreign_key_name;
4085: cursor l_check_seq_csr is
4086: select 1
4087: from AK_UNIQUE_KEY_COLUMNS pkc, AK_FOREIGN_KEYS fk
4088: where fk.FOREIGN_KEY_NAME = p_foreign_key_name
4089: and fk.UNIQUE_KEY_NAME = pkc.UNIQUE_KEY_NAME
4090: and pkc.UNIQUE_KEY_SEQUENCE = p_foreign_key_sequence;
4091: l_api_version_number CONSTANT number := 1.0;