APPS.QP_VALIDATE_PLL_PRICING_ATTR dependencies on QP_LIST_LINES

Line 308: FROM qp_list_lines

304:
305: BEGIN
306: SELECT primary_uom_flag
307: INTO l_primary_uom_flag
308: FROM qp_list_lines
309: WHERE list_line_id = p_PRICING_ATTR_rec.list_line_id;
310:
311: EXCEPTION
312: WHEN OTHERS THEN

Line 320: from qp_list_lines

316: /* Modified by rassharm for Bug No 5457704 to include effective dates check for primary UOM */
317:
318: select start_date_active, end_date_active , revision, list_header_id
319: into l_start_date_active, l_end_date_active, l_revision, l_list_header_id
320: from qp_list_lines
321: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
322:
323:
324: IF l_primary_uom_flag = 'Y' AND p_PRICING_ATTR_rec.product_attribute <> 'PRICING_ATTRIBUTE3' THEN

Line 329: from qp_pricing_attributes b, qp_list_lines c

325: l_count:=0;
326: for c1 in
327: (
328: select b.list_line_id col2
329: from qp_pricing_attributes b, qp_list_lines c
330: where b.list_line_id <> p_PRICING_ATTR_rec.list_line_id
331: and b.list_line_id=c.list_line_id
332: and c.primary_uom_flag='Y'
333: and b.product_attribute_context = p_PRICING_ATTR_rec.product_attribute_context

Line 347: from qp_list_lines

343: /*--------------------------------------------*/
344: begin
345: SELECT start_date_active, end_date_active
346: into l_sdate, l_edate
347: from qp_list_lines
348: where list_line_id = c1.col2;
349:
350: exception
351: when no_data_found then

Line 601: FROM qp_list_lines l, qp_pricing_attributes a

597:
598: BEGIN
599: SELECT count(*)
600: INTO l_count
601: FROM qp_list_lines l, qp_pricing_attributes a
602: WHERE l.list_line_id = a.list_line_id
603: AND a.list_header_id = p_PRICING_ATTR_rec.list_header_id
604: AND a.product_attribute_context =
605: p_PRICING_ATTR_rec.product_attribute_context

Line 629: from qp_list_lines

625: END IF;
626:
627: select start_date_active, end_date_active , revision, list_header_id
628: into l_start_date_active, l_end_date_active, l_revision, l_list_header_id
629: from qp_list_lines
630: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
631: */
632: OE_Debug_Pub.add ( 'Geresh :: Value Set 1' || l_start_date_active || l_end_date_active );
633:

Line 1190: from qp_list_lines

1186: --non-continuous price breaks
1187: BEGIN
1188: select continuous_price_break_flag
1189: into l_continuous_price_break_flag
1190: from qp_list_lines
1191: where list_line_id = l_from_rltd_modifier_id;
1192: EXCEPTION
1193: WHEN OTHERS THEN
1194: l_continuous_price_break_flag := NULL;

Line 1882: from qp_list_lines

1878: /*--------------------------------------------*/
1879: begin
1880: SELECT revision, start_date_active, end_date_active
1881: into l_count, l_sdate, l_edate
1882: from qp_list_lines
1883: where list_line_id = rec.col2;
1884:
1885: exception
1886: when no_data_found then null;

Line 1980: from qp_pricing_attributes a, qp_pricing_attributes b, qp_list_lines c

1976: BEGIN
1977:
1978: select a.list_line_id, b.list_line_id
1979: into l_dummy, l_dummy1
1980: from qp_pricing_attributes a, qp_pricing_attributes b, qp_list_lines c
1981: where a.list_line_id = p_List_Line_ID
1982: and b.list_line_id <> p_List_Line_ID
1983: and b.product_attribute_context = a.product_attribute_context
1984: and b.product_attribute = a.product_attribute

Line 2042: from qp_pricing_attributes a, qp_pricing_attributes b, qp_list_lines c

2038: BEGIN
2039:
2040: select a.list_line_id, b.list_line_id
2041: into l_dummy, l_dummy1
2042: from qp_pricing_attributes a, qp_pricing_attributes b, qp_list_lines c
2043: where a.list_line_id = p_List_Line_ID
2044: and b.list_line_id <> p_List_Line_ID
2045: and b.product_attribute_context = a.product_attribute_context
2046: and b.product_attribute = a.product_attribute