APPS.AK_KEY_PVT dependencies on AK_UNIQUE_KEYS

Line 1007: insert into AK_UNIQUE_KEYS (

1003: p_create_or_update => 'CREATE') then
1004: null;
1005: end if;
1006:
1007: insert into AK_UNIQUE_KEYS (
1008: UNIQUE_KEY_NAME,
1009: DATABASE_OBJECT_NAME,
1010: APPLICATION_ID,
1011: ATTRIBUTE_CATEGORY,

Line 1985: -- AK_UNIQUE_KEYS

1981: else
1982: --
1983: -- Otherwise, delete all referencing rows in other tables
1984: --
1985: -- AK_UNIQUE_KEYS
1986: --
1987: open l_get_columns_csr;
1988: loop
1989: fetch l_get_columns_csr into l_attribute_appl_id, l_attribute_code;

Line 2039: delete from ak_unique_keys

2035: --
2036: -- delete unique key once we checked that there are no references
2037: -- to it, or all references have been deleted.
2038: --
2039: delete from ak_unique_keys
2040: where unique_key_name = p_unique_key_name;
2041:
2042: if (sql%notfound) then
2043: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 2457: from AK_UNIQUE_KEYS

2453: p_unique_key_name IN VARCHAR2
2454: ) return BOOLEAN is
2455: cursor l_check_csr is
2456: select 1
2457: from AK_UNIQUE_KEYS
2458: where UNIQUE_KEY_NAME = p_unique_key_name;
2459: l_api_version_number CONSTANT number := 1.0;
2460: l_api_name CONSTANT varchar2(30) := 'Unique_Key_Exists';
2461: l_dummy number;

Line 3306: from AK_UNIQUE_KEYS

3302: p_copy_redo_flag IN OUT NOCOPY BOOLEAN
3303: ) is
3304: cursor l_get_row_csr is
3305: select *
3306: from AK_UNIQUE_KEYS
3307: where UNIQUE_KEY_NAME = p_unique_key_name
3308: for update of DATABASE_OBJECT_NAME;
3309: l_api_version_number CONSTANT number := 1.0;
3310: l_api_name CONSTANT varchar2(30):= 'Update_Unique_Key';

Line 3313: l_unique_key_rec ak_unique_keys%ROWTYPE;

3309: l_api_version_number CONSTANT number := 1.0;
3310: l_api_name CONSTANT varchar2(30):= 'Update_Unique_Key';
3311: l_created_by number;
3312: l_creation_date date;
3313: l_unique_key_rec ak_unique_keys%ROWTYPE;
3314: l_error boolean;
3315: l_last_update_date date;
3316: l_last_update_login number;
3317: l_last_updated_by number;

Line 3336: --** retrieve ak_unique_keys row if it exists **

3332: end if;
3333:
3334: savepoint start_update_unique_key;
3335:
3336: --** retrieve ak_unique_keys row if it exists **
3337: open l_get_row_csr;
3338: fetch l_get_row_csr into l_unique_key_rec;
3339: if (l_get_row_csr%notfound) then
3340: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

Line 3468: update AK_UNIQUE_KEYS set

3464: p_db_last_update_date => l_unique_key_rec.last_update_date,
3465: p_last_update_login => l_last_update_login,
3466: p_create_or_update => 'UPDATE') then
3467:
3468: update AK_UNIQUE_KEYS set
3469: DATABASE_OBJECT_NAME = l_unique_key_rec.database_object_name,
3470: APPLICATION_ID = l_unique_key_rec.application_id,
3471: ATTRIBUTE_CATEGORY = l_unique_key_rec.attribute_category,
3472: ATTRIBUTE1 = l_unique_key_rec.attribute1,

Line 4424: from AK_UNIQUE_KEYS

4420: p_pass IN NUMBER := 2
4421: ) return BOOLEAN is
4422: cursor l_check_pk_csr is
4423: select database_object_name
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