[Home] [Help]
179: --If line has product attributes, then increment qual_ind by 4.
180: BEGIN
181: select 1
182: into l_count
183: from qp_pricing_attributes
184: where list_line_id = l_list_line_id_tbl(i)
185: and excluder_flag = 'N'
186: and rownum = 1;
187:
197: --If line has pricing attributes, then increment qual_ind by 16.
198: BEGIN
199: select 1
200: into l_count
201: from qp_pricing_attributes
202: where list_line_id = l_list_line_id_tbl(i)
203: and pricing_attribute_context is not null
204: and pricing_attribute is not null
205: -- changes made per rchellam's request--spgopal
236: SET qualification_ind = l_qualification_ind_tbl(j)
237: WHERE list_line_id = l_list_line_id_tbl(j);
238:
239: FORALL k IN l_list_line_id_tbl.FIRST..l_list_line_id_tbl.LAST
240: UPDATE qp_pricing_attributes
241: SET qualification_ind = l_qualification_ind_tbl(k)
242: WHERE list_line_id = l_list_line_id_tbl(k);
243:
244: l_total_rows := l_total_rows + SQL%ROWCOUNT;
312: 'C', 'z',
313: '9999/01/01 00:00:00')
314: ELSE pricing_attr_value_to
315: END new_to
316: FROM qp_pricing_attributes
317: WHERE rowid BETWEEN
318: p_start_rowid AND p_end_rowid) pa
319: SET (list_header_id, pricing_phase_id, qualification_ind) =
320: (SELECT ll.list_header_id, ll.pricing_phase_id, ll.qualification_ind
347: cursor pricing_attributes
348: is
349: select pa.pricing_attribute_id pricing_attribute_id
350: /* Removed hint to tune the sqlstmt */
351: from qp_pricing_attributes pa, qp_list_lines ll
352: where pa.list_line_id = ll.list_line_id
353: and pa.list_header_id is null
354: and pa.pricing_phase_id is null
355: order by pricing_attribute_id;
382: into
383: l_total_lines,
384: l_min_line,
385: l_max_line
386: from qp_pricing_attributes pa, qp_list_lines ll
387: where pa.list_line_id = ll.list_line_id
388: and pa.list_header_id is null
389: and pa.pricing_phase_id is null;
390: