DBA Data[Home] [Help]

APPS.QP_VALIDATE_PLL_PRICING_ATTR dependencies on QP_LIST_LINES

Line 314: FROM qp_list_lines

310:
311: BEGIN
312: SELECT primary_uom_flag
313: INTO l_primary_uom_flag
314: FROM qp_list_lines
315: WHERE list_line_id = p_PRICING_ATTR_rec.list_line_id;
316:
317: EXCEPTION
318: WHEN OTHERS THEN

Line 326: from qp_list_lines

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

Line 335: from qp_pricing_attributes b, qp_list_lines c

331: l_count:=0;
332: for c1 in
333: (
334: select b.list_line_id col2
335: from qp_pricing_attributes b, qp_list_lines c
336: where b.list_line_id <> p_PRICING_ATTR_rec.list_line_id
337: and b.list_line_id=c.list_line_id
338: and c.primary_uom_flag='Y'
339: and b.product_attribute_context = p_PRICING_ATTR_rec.product_attribute_context

Line 353: from qp_list_lines

349: /*--------------------------------------------*/
350: begin
351: SELECT start_date_active, end_date_active
352: into l_sdate, l_edate
353: from qp_list_lines
354: where list_line_id = c1.col2;
355:
356: exception
357: when no_data_found then

Line 405: from qp_list_lines

401: IF l_count > 0 THEN
402: --Add check for Pricing attributes 8359896
403: select start_date_active, end_date_active , revision, list_header_id
404: into l_start_date_active, l_end_date_active, l_revision, l_list_header_id
405: from qp_list_lines
406: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
407:
408: OE_Debug_Pub.add ( 'smbalara :: Value Set 1' || l_start_date_active || l_end_date_active );
409:

Line 658: FROM qp_list_lines l, qp_pricing_attributes a

654:
655: BEGIN
656: SELECT count(*)
657: INTO l_count
658: FROM qp_list_lines l, qp_pricing_attributes a
659: WHERE l.list_line_id = a.list_line_id
660: AND a.list_header_id = p_PRICING_ATTR_rec.list_header_id
661: AND a.product_attribute_context =
662: p_PRICING_ATTR_rec.product_attribute_context

Line 686: from qp_list_lines

682: END IF;
683:
684: select start_date_active, end_date_active , revision, list_header_id
685: into l_start_date_active, l_end_date_active, l_revision, l_list_header_id
686: from qp_list_lines
687: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
688: */
689: OE_Debug_Pub.add ( 'Geresh :: Value Set 1' || l_start_date_active || l_end_date_active );
690:

Line 1247: from qp_list_lines

1243: --non-continuous price breaks
1244: BEGIN
1245: select continuous_price_break_flag
1246: into l_continuous_price_break_flag
1247: from qp_list_lines
1248: where list_line_id = l_from_rltd_modifier_id;
1249: EXCEPTION
1250: WHEN OTHERS THEN
1251: l_continuous_price_break_flag := NULL;

Line 1947: from qp_list_lines

1943: /*--------------------------------------------*/
1944: begin
1945: SELECT revision, start_date_active, end_date_active
1946: into l_count, l_sdate, l_edate
1947: from qp_list_lines
1948: where list_line_id = rec.col2;
1949:
1950: exception
1951: when no_data_found then null;

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

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

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

2103: BEGIN
2104:
2105: select a.list_line_id, b.list_line_id
2106: into l_dummy, l_dummy1
2107: from qp_pricing_attributes a, qp_pricing_attributes b, qp_list_lines c
2108: where a.list_line_id = p_List_Line_ID
2109: and b.list_line_id <> p_List_Line_ID
2110: and b.product_attribute_context = a.product_attribute_context
2111: and b.product_attribute = a.product_attribute