APPS.HZ_WORD_CONDITIONS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 111

            sql_str := 'select ''Y'' from dual where ''' ||country_str ||''' IN ('||adjusted_user_val||')';

Line: 153

            sql_str := 'select ''Y'' from dual where ''' ||country_str ||''' NOT IN ('||adjusted_user_val||')';

Line: 188

    (select condition_id
     from hz_word_rpl_cond_attribs
     where assoc_cond_attrib_id = p_attribute_id
     and rownum < 2
     )
    LOOP

       return TRUE ;

Line: 218

    (select attribute_id
     from hz_trans_attributes_vl
     where attribute_name = p_attribute_name
     and entity_name = p_entity)
    LOOP
       -- In the get we need to be careful
       -- since the attribute id may not exists as part of the global record
       -- if either the match rule does not have the attribute as part of its definition
       -- or the user does not even pass criteria at that level ( for example an entire
       -- party site search list may be empty).

       IF gbl_condition_rec.EXISTS(att_cur.attribute_id)
       THEN
            return gbl_condition_rec(att_cur.attribute_id) ;

Line: 275

      SELECT condition_function INTO user_defined_proc_name
      FROM HZ_WORD_RPL_CONDS_B
      WHERE condition_id = p_condition_id ;

Line: 281

      sql_str := 'select HZ_WORD_CONDITIONS_PKG.'||user_defined_proc_name||'(:p_input_str,:p_token_str,:p_repl_str, :p_condition_id,:p_user_spec_cond_val) from dual' ;