APPS.QP_QUALIFICATION_IND_UPG_UTIL SQL Statements

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

Line: 16

     select start_line_id,
            end_line_id
     into v_min_line,
          v_max_line
     from qp_upg_lines_distribution
     where worker = l_worker
	and line_type = 'QUA';

Line: 38

update qp_list_lines qpl set qpl.qualification_ind=3
where list_line_id between v_min_line and v_max_line
and (qualification_ind is null or qualification_ind <> 3)
and rownum<=p_batchsize;

Line: 84

     select start_line_id,
            end_line_id
     into v_min_line,
          v_max_line
     from qp_upg_lines_distribution
     where worker = l_worker
	and line_type = 'QUA';

Line: 104

update qp_list_lines qpl set qpl.qualification_ind=1
where list_line_id between v_min_line and v_max_line
and qualification_ind = 3
and (exists (select 'X' from qp_rltd_modifiers qprltd where qprltd.to_rltd_modifier_id=qpl.list_line_id and rltd_modifier_grp_type<>'COUPON')
or exists (select 'X' from qp_qualifiers q where q.list_header_id=qpl.list_header_id and (q.list_line_id=qpl.list_line_id or q.list_line_id IS NULL))
or not exists (select 'X' from qp_pricing_attributes qpprod where qpprod.list_line_id = qpl.list_line_id))
and rownum<=p_batchsize;

Line: 152

     select start_line_id,
            end_line_id
     into v_min_line,
          v_max_line
     from qp_upg_lines_distribution
     where worker = l_worker
	and line_type = 'QUA';

Line: 175

update qp_list_lines qpl set qpl.qualification_ind=2
where qpl.list_line_id between v_min_line and v_max_line
and exists (select 'X' from qp_rltd_modifiers qprltd where qprltd.to_rltd_modifier_id=qpl.list_line_id and rltd_modifier_grp_type<>'COUPON')
and not exists (select 'X' from qp_qualifiers q where q.list_header_id=qpl.list_header_id and (q.list_line_id=qpl.list_line_id or q.list_line_id IS NULL))
and exists (select 'X' from qp_pricing_attributes qpprod where qpprod.list_line_id = qpl.list_line_id)
and qpl.qualification_ind=1
and rownum<=p_batchsize;

Line: 196

update qp_list_lines qpl set qpl.qualification_ind=4
where qpl.list_line_id between v_min_line and v_max_line
and exists (select 'X' from qp_rltd_modifiers qprltd where qprltd.to_rltd_modifier_id=qpl.list_line_id and rltd_modifier_grp_type<>'COUPON')
and exists (select 'X' from qp_qualifiers q where q.list_header_id=qpl.list_header_id and (q.list_line_id=qpl.list_line_id or q.list_line_id IS NULL))
and not exists (select 'X' from qp_pricing_attributes qpprod where qpprod.list_line_id = qpl.list_line_id)
and qpl.qualification_ind=1
and rownum<=p_batchsize;

Line: 217

update qp_list_lines qpl set qpl.qualification_ind=5
where qpl.list_line_id between v_min_line and v_max_line
and not exists (select 'X' from qp_rltd_modifiers qprltd where qprltd.to_rltd_modifier_id=qpl.list_line_id and rltd_modifier_grp_type<>'COUPON')
and exists (select 'X' from qp_qualifiers q where q.list_header_id=qpl.list_header_id and (q.list_line_id=qpl.list_line_id or q.list_line_id IS NULL))
and not exists (select 'X' from qp_pricing_attributes qpprod where qpprod.list_line_id = qpl.list_line_id)
and qpl.qualification_ind=1
and rownum<=p_batchsize;

Line: 238

update qp_list_lines qpl set qpl.qualification_ind=6
where qpl.list_line_id between v_min_line and v_max_line
and exists (select 'X' from qp_rltd_modifiers qprltd where qprltd.to_rltd_modifier_id=qpl.list_line_id and rltd_modifier_grp_type<>'COUPON')
and not exists (select 'X' from qp_qualifiers q where q.list_header_id=qpl.list_header_id and (q.list_line_id=qpl.list_line_id or q.list_line_id IS NULL))
and not exists (select 'X' from qp_pricing_attributes qpprod where qpprod.list_line_id = qpl.list_line_id)
and qpl.qualification_ind=1
and rownum<=p_batchsize;

Line: 259

update qp_list_lines qpl set qpl.qualification_ind=7
where qpl.list_line_id between v_min_line and v_max_line
and not exists (select 'X' from qp_rltd_modifiers qprltd where qprltd.to_rltd_modifier_id=qpl.list_line_id and rltd_modifier_grp_type<>'COUPON')
and not exists (select 'X' from qp_qualifiers q where q.list_header_id=qpl.list_header_id and (q.list_line_id=qpl.list_line_id or q.list_line_id IS NULL))
and not exists (select 'X' from qp_pricing_attributes qpprod where qpprod.list_line_id = qpl.list_line_id)
and qpl.qualification_ind=1
and rownum<=p_batchsize;

Line: 280

update qp_list_lines qpl set qpl.qualification_ind=NULL
where qpl.list_line_id between v_min_line and v_max_line
and exists (select 'X' from qp_rltd_modifiers qprltd where qprltd.to_rltd_modifier_id=qpl.list_line_id and rltd_modifier_grp_type<>'COUPON')
and exists (select 'X' from qp_qualifiers q where q.list_header_id=qpl.list_header_id and (q.list_line_id=qpl.list_line_id or q.list_line_id IS NULL))
and exists (select 'X' from qp_pricing_attributes qpprod where qpprod.list_line_id = qpl.list_line_id)
and qpl.qualification_ind=1
and rownum<=p_batchsize;

Line: 337

      DELETE FROM qp_upg_lines_distribution
      WHERE line_type = l_type;

Line: 343

          select nvl(min(list_line_id),0), nvl(max(list_line_id),0)
          into   l_min_line, l_max_line
          from   qp_list_lines;

Line: 348

          select nvl(min(list_header_id),0), nvl(max(list_header_id),0)
          into   l_min_line, l_max_line
          from   qp_list_headers_b;

Line: 373

                qp_modifier_upgrade_util_pvt.insert_line_distribution
                (
                    l_worker             => i,
                    l_start_line  => l_worker_start,
                    l_end_line    => l_worker_end,
                    l_type_var         =>l_type
                );

Line: 404

     select 1
     into   l_count
     from   qp_upg_lines_distribution
     where  line_type = l_type
     and    last_proc_line is not null
     and    rownum = 1;

Line: 420

     delete from qp_upg_lines_distribution
     where  line_type = l_type;

Line: 424

     select round(count(*)/l_workers) + 1
     into   l_slab
     from   qp_list_lines;

Line: 431

         select max(list_line_id), min(list_line_id)
         into   l_max, l_min
         from   (select list_line_id
                 from   (select list_line_id
                         from   qp_list_lines
                         where  list_line_id > l_max
                         order  by list_line_id
                        )
	         where  rownum <  l_slab + 1
                 );

Line: 442

         qp_modifier_upgrade_util_pvt.insert_line_distribution
	   	   (l_worker      => i,
		    l_start_line  => l_min,
		    l_end_line    => l_max,
		    l_type_var    => 'QIN');