[Home] [Help]
436: oe.security_api_proc,
437: oe.defaulting_condn_ref_flag,
438: oe.defaulting_enabled_flag
439: FROM OE_AK_OBJ_ATTR_EXT OE
440: , AK_OBJECT_ATTRIBUTES_VL ak
441: WHERE oe.database_object_name = p_database_object_name
442: AND oe.attribute_application_id = p_application_id
443: AND ak.database_object_name = oe.database_object_name
444: AND ak.attribute_code = oe.attribute_code
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
1281: AND fk.database_object_name = p_database_object_name
1282: AND fk.unique_key_name = uk.unique_key_name
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
1298: AND uk.unique_key_name = uc.unique_key_name
1299: AND uc.attribute_code = ua.attribute_code
1483: WHERE DATABASE_OBJECT_NAME = l_src_database_object_name;
1484:
1485: SELECT column_name
1486: INTO l_src_column_name
1487: FROM AK_OBJECT_ATTRIBUTES
1488: WHERE DATABASE_OBJECT_NAME = l_src_database_object_name
1489: AND ATTRIBUTE_CODE = l_src_attribute_code;
1490:
1491: Text('IF '||l_app_short_name||'_'||l_related_entity_code
1527: ELSIF l_src_type = 'SAME_RECORD' THEN
1528:
1529: SELECT column_name
1530: INTO l_src_column_name
1531: FROM AK_OBJECT_ATTRIBUTES
1532: WHERE DATABASE_OBJECT_NAME = p_database_object_name
1533: AND ATTRIBUTE_CODE = l_src_attribute_code;
1534:
1535: Text('l_return_value := p_'||LOWER(p_entity_code)||'_rec.'||l_src_column_name||';',2);
2072: Text( 'END Get_Default_Value; ',0);
2073: New_Line ;
2074: Pkg_End (l_package,'BODY');
2075:
2076: UPDATE AK_OBJECT_ATTRIBUTES
2077: SET defaulting_api_pkg= l_package,
2078: defaulting_api_proc = 'Get_Default_Value'
2079: WHERE attribute_code = p_attribute_code
2080: AND database_object_name=p_database_object_name
2169: CURSOR OASV (p_database_object_name varchar2,p_application_id number)
2170: is
2171: SELECT aoj.attribute_code,NVL(aoj.data_type,'VARCHAR2')data_type,
2172: aoj.column_name
2173: FROM AK_OBJECT_ATTRIBUTES_VL aoj
2174: WHERE aoj.database_object_name = p_database_object_name
2175: AND aoj.attribute_application_id = p_application_id
2176: AND aoj.column_name is not null;
2177:
2197: l_database_object_name varchar2)
2198: IS
2199: SELECT b.attribute_code, b.column_name,
2200: foreign_key_sequence, b.data_type
2201: FROM ak_object_attributes_vl b,ak_foreign_key_columns a
2202: WHERE a.foreign_key_name= l_fk_name
2203: AND b.database_object_name = l_database_object_name
2204: AND b.attribute_application_id = a.attribute_application_id
2205: AND b.attribute_code = a.attribute_code
2220: FROM OE_DEF_AK_FKEYS_V fk
2221: WHERE fk_database_object_name=l_database_object_name
2222: AND application_id=p_application_id
2223: AND exists (SELECT 'Y'
2224: FROM ak_object_attributes_vl oa
2225: WHERE oa.database_object_name = fk.uk_database_object_name
2226: AND oa.data_type = 'DATE'
2227: );
2228: --
3449: CURSOR OASS(p_database_object_name varchar2)
3450: is
3451: SELECT oeatt.attribute_code, akatt.column_name
3452: FROM OE_AK_OBJ_ATTR_EXT oeatt
3453: , AK_OBJECT_ATTRIBUTES akatt
3454: WHERE oeatt.database_object_name = p_database_object_name
3455: AND oeatt.attribute_application_id=p_application_id
3456: AND oeatt.attribute_code = akatt.attribute_code
3457: AND oeatt.database_object_name = akatt.database_object_name