APPS.QP_VALIDATE_PRICING_ATTR dependencies on QP_PRICING_ATTRIBUTES

Line 151: from qp_pricing_attributes

147: DECLARE
148: count_attr NUMBER;
149: BEGIN
150: Select count(*) into count_attr
151: from qp_pricing_attributes
152: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
153: if count_attr > 1 THEN
154: l_return_status := FND_API.G_RET_STS_ERROR;
155:

Line 174: from qp_pricing_attributes

170: DECLARE
171: count_attr NUMBER;
172: BEGIN
173: Select count(*) into count_attr
174: from qp_pricing_attributes
175: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
176: if count_attr > 1 AND p_PRICING_ATTR_rec.excluder_flag = 'N' THEN
177: l_return_status := FND_API.G_RET_STS_ERROR;
178:

Line 1286: FROM QP_PRICING_ATTRIBUTES

1282: BEGIN
1283:
1284: SELECT COUNT(*)
1285: INTO l_no_pricing_attr
1286: FROM QP_PRICING_ATTRIBUTES
1287: WHERE LIST_LINE_ID = p_PRICING_ATTR_rec.list_line_id
1288: AND PRICING_ATTRIBUTE_CONTEXT <> 'VOLUME';
1289:
1290: IF nvl(l_no_pricing_attr,0) = 1

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

1974: l_y_list_line_id NUMBER;
1975:
1976: CURSOR get_rec(l_List_Line_ID NUMBER ) is
1977: select a.list_line_id col1, b.list_line_id col2
1978: from qp_pricing_attributes a, qp_pricing_attributes b, qp_list_lines c,
1979: qp_list_lines c1
1980: where a.list_line_id = l_List_Line_ID
1981: and b.list_line_id <> l_List_Line_ID
1982: and b.product_attribute_context = a.product_attribute_context

Line 2007: from qp_pricing_attributes

2003: and c1.list_header_id = p_List_Header_ID
2004: and c.list_header_id = p_List_Header_ID
2005: group by a.list_line_id, b.list_line_id
2006: having count(b.list_line_id ) = ( select count(*)
2007: from qp_pricing_attributes
2008: where list_line_id = l_List_Line_ID)
2009: and count(b.list_line_id) = ( select count(*)
2010: from qp_pricing_attributes
2011: where list_line_id = b.list_line_id) ;

Line 2010: from qp_pricing_attributes

2006: having count(b.list_line_id ) = ( select count(*)
2007: from qp_pricing_attributes
2008: where list_line_id = l_List_Line_ID)
2009: and count(b.list_line_id) = ( select count(*)
2010: from qp_pricing_attributes
2011: where list_line_id = b.list_line_id) ;
2012:
2013:
2014: CURSOR get_rec_no_attr(l_List_Line_ID NUMBER ) is

Line 2025: from qp_pricing_attributes

2021: and c.automatic_flag = c1.automatic_flag
2022: and c1.list_header_id = p_List_Header_ID
2023: and c.list_header_id = p_List_Header_ID
2024: and not exists (select list_line_id
2025: from qp_pricing_attributes
2026: where list_line_id = c1.list_line_id)
2027: group by c.list_line_id, c1.list_line_id;
2028:
2029: l_min_date date := to_date('01/01/1900', 'MM/DD/YYYY');