1125:
1126: FUNCTION IS_USE_INSTANCE(p_rule_object_id IN NUMBER)
1127: RETURN BOOLEAN
1128: IS
1129: l_parent_rule_object_id FUN_RULE_OBJECTS_B.PARENT_RULE_OBJECT_ID%TYPE;
1130: params_cursor INTEGER;
1131: params_rows_processed INTEGER;
1132:
1133: l_sql VARCHAR2(1000) := 'SELECT PARENT_RULE_OBJECT_ID FROM FUN_RULE_OBJECTS_B WHERE
1129: l_parent_rule_object_id FUN_RULE_OBJECTS_B.PARENT_RULE_OBJECT_ID%TYPE;
1130: params_cursor INTEGER;
1131: params_rows_processed INTEGER;
1132:
1133: l_sql VARCHAR2(1000) := 'SELECT PARENT_RULE_OBJECT_ID FROM FUN_RULE_OBJECTS_B WHERE
1134: RULE_OBJECT_ID = :1';
1135:
1136: BEGIN
1137: