APPS.HZ_DQM_SEARCH_UTIL SQL Statements

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

Line: 85

  SELECT nvl(temp_section,p_within) --Bug No: 4244535
  FROM HZ_TRANS_ATTRIBUTES_VL
  WHERE attribute_id = p_attr_id;

Line: 262

  l_sqlstr := 'DELETE FROM HZ_DQM_PARTIES_GT m WHERE NOT EXISTS ('||
              'SELECT p.party_id FROM HZ_PARTIES p '||
              'WHERE p.party_id = m.party_id AND '||
              p_subset_defn || ') AND SEARCH_CONTEXT_ID = :ctxid';

Line: 470

    SELECT 1 INTO T FROM HZ_STAGED_PARTIES
    WHERE ROWNUM=1
    AND CONTAINS (concat_col, 'dummy_string')>0;

Line: 480

    SELECT 1 INTO T FROM HZ_STAGED_PARTY_SITES
    WHERE ROWNUM=1
    AND CONTAINS (CONCAT_COL, 'dummy_string')>0;

Line: 490

    SELECT 1 INTO T FROM HZ_STAGED_CONTACTS
    WHERE ROWNUM=1
    AND CONTAINS (CONCAT_COL, 'dummy_string')>0;

Line: 500

    SELECT 1 INTO T FROM HZ_STAGED_CONTACT_POINTS
    WHERE ROWNUM=1
    AND CONTAINS (CONCAT_COL, 'dummy_string')>0;

Line: 522

  CURSOR c1 is select compilation_flag from hz_match_rules_b where match_rule_id = p_match_rule_id;

Line: 523

 CURSOR c2 is select count(*)
            from hz_trans_functions_b
            where function_id in (
                       select function_id
                       from hz_match_rule_primary mp, hz_primary_trans pt
                       where match_rule_id = p_match_rule_id
                       and mp.primary_attribute_id = pt.primary_attribute_id
                       union
                       select function_id
                       from hz_match_rule_secondary ms, hz_secondary_trans st
                       where match_rule_id = p_match_rule_id
                       and ms.secondary_attribute_id = st.secondary_attribute_id
            )
            and staged_flag <> 'Y'
            and nvl(active_flag, 'Y') <> 'N' ;

Line: 573

PROCEDURE update_word_list (
   p_repl_word VARCHAR2,
   p_word_list_id NUMBER) IS
  repl_str VARCHAR2(2000);

Line: 598

         select rule_purpose into l_rule_purpose
         from hz_match_rules_vl
         where match_rule_id = p_match_rule_id;

Line: 604

                select party_id, score
                from hz_matched_parties_gt
                where search_context_id = p_srch_ctx_id)
           LOOP
             select * into l_party_rec
             from HZ_PARTIES
             where party_id = TX.party_id;

Line: 614

             update hz_matched_parties_gt
             set score = l_final_score
             where search_context_id = p_srch_ctx_id
             and party_id = TX.party_id;

Line: 620

           select sum(score) into l_mms
           from hz_match_rule_secondary
           where match_rule_id =  p_match_rule_id;

Line: 623

           FOR TX IN (select party_id, score
                from hz_matched_parties_gt
                where search_context_id = p_srch_ctx_id)
           LOOP
             select * into l_party_rec
             from HZ_PARTIES
             where party_id = TX.party_id;

Line: 633

             update hz_matched_parties_gt
             set score = l_final_score
             where search_context_id = p_srch_ctx_id
             and party_id = TX.party_id;

Line: 659

  	select instr(P_PROCEDURE_NAME,'.') into dotCheck from dual;

Line: 662

	/*select count(*) into procCheck from sys.all_objects
	where object_name=trim(upper(P_PROCEDURE_NAME))
	and (object_type='PROCEDURE' OR object_type='FUNCTION');*/

Line: 667

    l_sqlstr := ' select count(*) from sys.all_procedures where object_name=trim(upper(:P_PROCEDURE_NAME)) and owner=:2';

Line: 678

        l_sql := 'select ' || P_PROCEDURE_NAME ||
             '(:attrval,:lang,:attr,:entity) from dual';

Line: 701

 	select instr(P_CUST_PROCEDURE_NAME,'.') into dotCheck from dual;

Line: 704

	/*select count(*) into procCheck from sys.all_objects
	where object_name=trim(upper(P_CUST_PROCEDURE_NAME))
	and (object_type='PROCEDURE' OR object_type='FUNCTION');*/

Line: 709

    l_sqlstr := ' select count(*) from sys.all_procedures where object_name=trim(upper(:1)) and owner=:2 ';

Line: 720

        l_sql := 'select ' || P_CUST_PROCEDURE_NAME ||
             '(:record_id,:entity,:attr) from dual';