APPS.QP_UPDATE_UTIL SQL Statements

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

Line: 30

  select l.list_line_id, l.qualification_ind, h.list_type_code, h.list_header_id
  from   qp_list_lines l, qp_list_headers_b h
  where  l.list_header_id = h.list_header_id
  and    (l.list_line_id between a_list_line_id and b_list_line_id)
  order by l.list_line_id;

Line: 47

    l_list_line_id_tbl.delete;

Line: 48

    l_list_header_id_tbl.delete;

Line: 49

    l_qualification_ind_tbl.delete;

Line: 50

    l_list_type_code_tbl.delete;

Line: 68

            select 1
	    into   l_count
	    from   qp_rltd_modifiers
	    where  to_rltd_modifier_id = l_list_line_id_tbl(i)
	    and    rltd_modifier_grp_type <> 'COUPON'
            and    rownum = 1;

Line: 94

                select 1
	        into   l_count
                from   qp_qualifiers
		where  list_header_id = l_list_header_id_tbl(i)
		and    NOT (qualifier_context = 'MODLIST' and
		 	    qualifier_attribute = 'QUALIFIER_ATTRIBUTE4')
                and    rownum = 1;

Line: 131

                select 1
		into   l_count
	    	from   qp_qualifiers
		where  list_header_id = l_list_header_id_tbl(i)
		and    nvl(list_line_id,-1) = -1
                and    rownum = 1;

Line: 161

              select 1
	      into   l_count
	      from   qp_qualifiers
	      where  list_header_id = l_list_header_id_tbl(i)
	      and    list_line_id = l_list_line_id_tbl(i)
              and    rownum = 1;

Line: 181

	    select 1
	    into   l_count
	    from   qp_pricing_attributes
	    where  list_line_id = l_list_line_id_tbl(i)
	    and    excluder_flag = 'N'
            and    rownum = 1;

Line: 199

	    select 1
	    into   l_count
	    from   qp_pricing_attributes
	    where  list_line_id = l_list_line_id_tbl(i)
	    and    pricing_attribute_context is not null
	    and    pricing_attribute is not null
            -- changes made per rchellam's request--spgopal
	    and    pricing_attr_value_from IS NOT NULL
            and    rownum = 1;

Line: 225

		      p_error_type => 'UPDATE_QUALIFICATION_IND',
		      p_error_desc => 'Error Processing list_line_id '||
		        to_char(l_list_line_id_tbl(l_list_line_id_tbl.FIRST + SQL%ROWCOUNT)),
		      p_error_module => 'Update_Qualification_Ind');

Line: 235

          UPDATE qp_list_lines
		SET    qualification_ind = l_qualification_ind_tbl(j)
		WHERE  list_line_id = l_list_line_id_tbl(j);

Line: 240

          UPDATE qp_pricing_attributes
		SET    qualification_ind = l_qualification_ind_tbl(k)
		WHERE  list_line_id = l_list_line_id_tbl(k);

Line: 253

	    p_error_type => 'UPDATE_QUALIFICATION_IND',
	    p_error_desc => 'Error Processing list_line_id '||
	      to_char(l_list_line_id_tbl(l_list_line_id_tbl.FIRST + SQL%ROWCOUNT)),
	    p_error_module => 'Update_Qualification_Ind');

Line: 265

    UPDATE qp_upg_lines_distribution
    SET    last_proc_line = l_list_line_id_tbl(l_index)
    WHERE  worker = p_worker
    AND    line_type = p_line_type;

Line: 281

END Update_Qualification_ind;

Line: 284

PROCEDURE update_pricing_attributes(
            p_start_rowid  ROWID DEFAULT NULL,
            p_end_rowid    ROWID DEFAULT NULL)
IS
canonical_mask VARCHAR2(100) := qp_number.canonical_mask;

Line: 291

  UPDATE
   (SELECT list_header_id, pricing_phase_id, qualification_ind,
           list_line_id, pricing_attribute_datatype,
           pricing_attr_value_from, pricing_attr_value_to,
           pricing_attr_value_from_number, pricing_attr_value_to_number,
           CASE
             WHEN comparison_operator_code = 'BETWEEN'
                  AND pricing_attr_value_from IS NULL
                  AND pricing_attr_value_to IS NOT NULL
             THEN DECODE(pricing_attribute_datatype,
                         'N', '-9999999999',
                         'C', '0',
                         '0001/01/01 00:00:00')
             ELSE pricing_attr_value_from
           END new_from,
           CASE
             WHEN comparison_operator_code = 'BETWEEN'
                  AND pricing_attr_value_from IS NOT NULL
                  AND pricing_attr_value_to IS NULL
             THEN DECODE(pricing_attribute_datatype,
                         'N', '9999999999',
                         'C', 'z',
                         '9999/01/01 00:00:00')
             ELSE pricing_attr_value_to
           END new_to
    FROM   qp_pricing_attributes
    WHERE  rowid BETWEEN
             p_start_rowid AND p_end_rowid) pa
  SET (list_header_id, pricing_phase_id, qualification_ind) =
        (SELECT ll.list_header_id, ll.pricing_phase_id, ll.qualification_ind
         FROM   qp_list_lines ll
         WHERE  ll.list_line_id = pa.list_line_id),
        pricing_attr_value_from = new_from,
        pricing_attr_value_to = new_to,
        pricing_attr_value_from_number =
          DECODE(pricing_attribute_datatype, 'N',
                 DECODE(ltrim(new_from, '0123456789.-'),
                        null, to_number(new_from, canonical_mask))),
        pricing_attr_value_to_number =
          DECODE(pricing_attribute_datatype, 'N',
                 DECODE(ltrim(new_to, '0123456789.-'),
                        null, to_number(new_to, canonical_mask)));

Line: 339

END update_pricing_attributes;

Line: 349

      select pa.pricing_attribute_id pricing_attribute_id
             /* Removed hint to tune the sqlstmt */
      from  qp_pricing_attributes  pa, qp_list_lines ll
      where pa.list_line_id = ll.list_line_id
      and   pa.list_header_id is null
      and   pa.pricing_phase_id is null
      order by pricing_attribute_id;

Line: 372

      delete from qp_upg_lines_distribution
      where line_type = v_type;

Line: 378

                select
                     count(*),
                     nvl(min(pricing_attribute_id),0),
                     nvl(max(pricing_attribute_id),0)
                into
                     l_total_lines,
                     l_min_line,
                     l_max_line
                from  qp_pricing_attributes  pa, qp_list_lines ll
                where pa.list_line_id = ll.list_line_id
                and   pa.list_header_id is null
                and   pa.pricing_phase_id is null;

Line: 399

                qp_modifier_upgrade_util_pvt.insert_line_distribution
                (
                    l_worker             => 1,
                    l_start_line  => l_min_line,
                    l_end_line    => l_max_line,
                    l_type_var         => 'UPA'
                );

Line: 432

                     qp_modifier_upgrade_util_pvt.insert_line_distribution
                     (
                       l_worker             => l_worker_count,
                       l_start_line  => l_min_line,
                       l_end_line    => l_max_line,
                       l_type_var         => 'UPA'
                     );

Line: 449

                     qp_modifier_upgrade_util_pvt.insert_line_distribution
                     (
                       l_worker             => l_worker_count,
                       l_start_line  => l_min_line,
                       l_end_line    => l_max_line,
                       l_type_var         => 'UPA'
                     );