DBA Data[Home] [Help]

APPS.OE_DEFAULTING_FWK_PUB dependencies on OE_DEF_ATTR_CONDNS

Line 1248: FROM OE_DEF_ATTR_CONDNS

1244: l_rule_id NUMBER;
1245:
1246: CURSOR C_CONDNS IS
1247: SELECT condition_id, attr_def_condition_id
1248: FROM OE_DEF_ATTR_CONDNS
1249: WHERE DATABASE_OBJECT_NAME = p_database_object_name
1250: AND ATTRIBUTE_CODE = p_attribute_code
1251: AND ENABLED_FLAG = 'Y'
1252: ORDER BY PRECEDENCE;

Line 3229: Text(' FROM OE_DEF_ATTR_DEF_RULES R, OE_DEF_ATTR_CONDNS C',0);

3225: Text(' R.SRC_PROFILE_OPTION,',0);
3226: Text(' R.SRC_API_PKG||''.''||R.SRC_API_FN SRC_API_NAME,',0);
3227: Text(' R.SRC_CONSTANT_VALUE,',0);
3228: Text(' R.SRC_SEQUENCE_NAME',0);
3229: Text(' FROM OE_DEF_ATTR_DEF_RULES R, OE_DEF_ATTR_CONDNS C',0);
3230: Text(' WHERE R.database_object_name = g_database_object_name',0);
3231: Text(' AND R.attribute_code = l_attribute_code',0);
3232: Text(' AND C.database_object_name = g_database_object_name',0);
3233: Text(' AND C.attribute_code = l_attribute_code',0);

Line 3315: Text(' FROM OE_DEF_ATTR_CONDNS ',0);

3311: Text('condns_cached BOOLEAN := FALSE;',0);
3312: Text('num_attr_condns NUMBER := 0;',0);
3313: Text('CURSOR ATTRC IS ',0);
3314: Text(' SELECT condition_id ',0);
3315: Text(' FROM OE_DEF_ATTR_CONDNS ',0);
3316: Text(' WHERE attribute_code = p_attr_code ',0);
3317: Text(' AND database_object_name = g_database_object_name ',0);
3318: Text(' AND enabled_flag = ''Y''',0);
3319: Text(' ORDER BY precedence;',0);