APPS.AK_OBJECT2_PVT dependencies on AK_UNIQUE_KEYS

Line 1338: from AK_UNIQUE_KEYS

1334: p_database_object_name IN VARCHAR2
1335: ) is
1336: cursor l_get_unique_keys_csr is
1337: select *
1338: from AK_UNIQUE_KEYS
1339: where DATABASE_OBJECT_NAME = p_database_object_name;
1340: cursor l_get_key_columns_csr (unique_key_name_param varchar2) is
1341: select *
1342: from AK_UNIQUE_KEY_COLUMNS

Line 1347: l_unique_keys_rec AK_UNIQUE_KEYS%ROWTYPE;

1343: where UNIQUE_KEY_NAME = unique_key_name_param;
1344: l_api_name CONSTANT varchar2(30) := 'write_unique_key_to_buffer';
1345: l_index NUMBER;
1346: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
1347: l_unique_keys_rec AK_UNIQUE_KEYS%ROWTYPE;
1348: l_key_columns_rec AK_UNIQUE_KEY_COLUMNS%ROWTYPE;
1349: l_return_status varchar2(1);
1350: begin
1351: -- Find out where the next buffer entry to be written to

Line 2219: from AK_UNIQUE_KEYS uk, AK_FOREIGN_KEYS fk

2215: where REGION_APPLICATION_ID = region_appl_id_param
2216: and REGION_CODE = region_code_param;
2217: cursor l_get_fk_objects_csr (database_object_name_param varchar2) is
2218: select uk.DATABASE_OBJECT_NAME
2219: from AK_UNIQUE_KEYS uk, AK_FOREIGN_KEYS fk
2220: where uk.UNIQUE_KEY_NAME = fk.UNIQUE_KEY_NAME
2221: and fk.DATABASE_OBJECT_NAME = database_object_name_param;
2222: cursor l_get_attr_lov_regions_csr (database_object_name_param varchar2) is
2223: select aa.lov_region_application_id, aa.lov_region_code