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_UNIQUE_KEY_COLUMNS

Line 1345: insert into AK_UNIQUE_KEY_COLUMNS (

1341: p_create_or_update => 'CREATE') then
1342: null;
1343: end if;
1344:
1345: insert into AK_UNIQUE_KEY_COLUMNS (
1346: UNIQUE_KEY_NAME,
1347: ATTRIBUTE_APPLICATION_ID,
1348: ATTRIBUTE_CODE,
1349: UNIQUE_KEY_SEQUENCE,

Line 1902: from AK_UNIQUE_KEY_COLUMNS

1898: p_delete_cascade IN VARCHAR2
1899: ) is
1900: cursor l_get_columns_csr is
1901: select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE
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

Line 1953: -- AK_UNIQUE_KEY_COLUMNS

1949: -- If we are not deleting any referencing records, we cannot
1950: -- delete the primary key if it is being referenced in any of
1951: -- following tables.
1952: --
1953: -- AK_UNIQUE_KEY_COLUMNS
1954: --
1955: open l_get_columns_csr;
1956: fetch l_get_columns_csr into l_attribute_appl_id, l_attribute_code;
1957: if l_get_columns_csr%found then

Line 2133: AK_UNIQUE_KEY_COLUMNS pkc

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
2137: and pkc.unique_key_name = p_unique_key_name

Line 2238: delete from ak_unique_key_columns

2234: --
2235: -- delete unique key column once we checked that there are no references
2236: -- to it, or all references have been deleted.
2237: --
2238: delete from ak_unique_key_columns
2239: where unique_key_name = p_unique_key_name
2240: and attribute_application_id = p_attribute_application_id
2241: and attribute_code = p_attribute_code;
2242:

Line 2520: from AK_UNIQUE_KEY_COLUMNS

2516: p_attribute_code IN VARCHAR2
2517: ) return BOOLEAN is
2518: cursor l_check_csr is
2519: select 1
2520: from AK_UNIQUE_KEY_COLUMNS
2521: where UNIQUE_KEY_NAME = p_unique_key_name
2522: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
2523: and ATTRIBUTE_CODE = p_attribute_code;
2524: l_api_version_number CONSTANT number := 1.0;

Line 3608: from AK_UNIQUE_KEY_COLUMNS

3604: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
3605: ) is
3606: cursor l_get_row_csr is
3607: select *
3608: from AK_UNIQUE_KEY_COLUMNS
3609: where UNIQUE_KEY_NAME = p_unique_key_name
3610: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
3611: and ATTRIBUTE_CODE = p_attribute_code
3612: for update of UNIQUE_KEY_SEQUENCE;

Line 3617: l_key_column_rec ak_unique_key_columns%ROWTYPE;

3613: l_api_version_number CONSTANT number := 1.0;
3614: l_api_name CONSTANT varchar2(30):= 'Update_Unique_Key_Column';
3615: l_created_by number;
3616: l_creation_date date;
3617: l_key_column_rec ak_unique_key_columns%ROWTYPE;
3618: l_error boolean;
3619: l_last_update_date date;
3620: l_last_update_login number;
3621: l_last_updated_by number;

Line 3640: -- retrieve ak_unique_key_columns row if it exists

3636: end if;
3637:
3638: savepoint start_update_key_column;
3639:
3640: --** retrieve ak_unique_key_columns row if it exists **
3641: open l_get_row_csr;
3642: fetch l_get_row_csr into l_key_column_rec;
3643: if (l_get_row_csr%notfound) then
3644: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 3770: update AK_UNIQUE_KEY_COLUMNS set

3766: p_db_last_update_date => l_key_column_rec.last_update_date,
3767: p_last_update_login => l_last_update_login,
3768: p_create_or_update => 'UPDATE') then
3769:
3770: update AK_UNIQUE_KEY_COLUMNS set
3771: UNIQUE_KEY_SEQUENCE = l_key_column_rec.unique_key_sequence,
3772: ATTRIBUTE_CATEGORY = l_key_column_rec.attribute_category,
3773: ATTRIBUTE1 = l_key_column_rec.attribute1,
3774: ATTRIBUTE2 = l_key_column_rec.attribute2,

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;

Line 4428: from AK_UNIQUE_KEY_COLUMNS

4424: from AK_UNIQUE_KEYS
4425: where UNIQUE_KEY_NAME = p_unique_key_name;
4426: cursor l_check_seq_csr is
4427: select 1
4428: from AK_UNIQUE_KEY_COLUMNS
4429: where UNIQUE_KEY_NAME = p_unique_key_name
4430: and UNIQUE_KEY_SEQUENCE = p_unique_key_sequence
4431: and ( (ATTRIBUTE_APPLICATION_ID <> p_attribute_application_id)
4432: or (ATTRIBUTE_CODE <> p_attribute_code) );

Line 4789: from AK_UNIQUE_KEY_COLUMNS

4785: ) is
4786:
4787: cursor l_get_columns_csr is
4788: select ATTRIBUTE_APPLICATION_ID, ATTRIBUTE_CODE
4789: from AK_UNIQUE_KEY_COLUMNS
4790: where UNIQUE_KEY_NAME = p_unique_key_name;
4791:
4792: l_api_name CONSTANT varchar2(30):= 'Delete_Related_Unique_Key_Col';
4793: l_msg_count NUMBER;

Line 4804: -- p_override flag is set to 'Y' here so that only AK_UNIQUE_KEY_COLUMNS

4800: savepoint start_delete_rel_unique_col;
4801:
4802: for csr_rec in l_get_columns_csr loop
4803: --
4804: -- p_override flag is set to 'Y' here so that only AK_UNIQUE_KEY_COLUMNS
4805: -- get deleted, other references would not be deleted and would not be
4806: -- checked.
4807: AK_KEY_PVT.DELETE_UNIQUE_KEY_COLUMN (
4808: p_validation_level => p_validation_level,