[Home] [Help]
407: ,uk.database_object_name uk_database_object_name
408: ,fk.foreign_key_name
409: ,obj.entity_code uk_entity_code
410: , obj.defaulting_enabled_flag uk_obj_defaulting_enabled
411: FROM AK_FOREIGN_KEYS fk, AK_UNIQUE_KEYS uk, OE_AK_OBJECTS_EXT obj
412: WHERE fk.database_object_name= p_database_object_name
413: AND fk.application_id= p_application_id
414: AND fk.unique_key_name = uk.unique_key_name
415: AND fk.application_id = uk.application_id
444: AND ak.attribute_code = oe.attribute_code
445: AND ak.attribute_application_id = oe.attribute_application_id
446: ORDER BY oe.defaulting_sequence, ak.attribute_label_long;
447:
448: -- This CURSOR SELECTs the attribute code FROM ak unique keys.
449: -- This will be used only when the primary key is comprised of a single column.
450: -- If the primary key has more than one column, then in the later part of the
451: -- code we loop through to get all the keys.
452:
1272: ORDER BY SEQUENCE_NO;
1273:
1274: CURSOR C_UK_COLS IS
1275: SELECT ua.column_name, fa.column_name
1276: FROM AK_UNIQUE_KEYS uk, AK_UNIQUE_KEY_COLUMNS uc
1277: , AK_FOREIGN_KEYS fk, AK_FOREIGN_KEY_COLUMNS fc
1278: , AK_OBJECT_ATTRIBUTES ua, AK_OBJECT_ATTRIBUTES fa
1279: WHERE uk.database_object_name = l_src_database_object_name
1280: AND uk.unique_key_name = uc.unique_key_name
1289: ORDER BY uc.unique_key_sequence;
1290:
1291: CURSOR C_PK_COLS IS -- 2218044
1292: SELECT ua.column_name
1293: FROM AK_UNIQUE_KEYS uk,
1294: AK_UNIQUE_KEY_COLUMNS uc,
1295: AK_OBJECT_ATTRIBUTES ua
1296: WHERE uk.database_object_name = p_database_object_name
1297: AND ua.database_object_name = p_database_object_name
2177:
2178: CURSOR PKEY (l_database_object_name varchar2,p_application_id number)
2179: IS
2180: SELECT unique_key_name
2181: FROM AK_UNIQUE_KEYS
2182: WHERE database_object_name=l_database_object_name
2183: AND application_id=p_application_id
2184: AND rownum = 1;
2185: