APPS.QP_PRICING_ATTR_UTIL dependencies on QP_LIST_LINES

Line 650: from qp_list_lines

646: BEGIN
647:
648: oe_debug_pub.add('list_line_id in apply gsp'||to_char(p_PRICING_ATTR_rec.list_line_id));
649: select list_header_id into x_PRICING_ATTR_rec.list_header_id
650: from qp_list_lines
651: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
652: EXCEPTION
653: When NO_DATA_FOUND Then
654: Null;

Line 674: from qp_list_lines

670:
671: BEGIN
672: oe_debug_pub.add('list_line_id in apply gsp'||to_char(p_PRICING_ATTR_rec.list_line_id));
673: select pricing_phase_id into x_PRICING_ATTR_rec.pricing_phase_id
674: from qp_list_lines
675: where list_line_id = p_PRICING_ATTR_rec.list_line_id;
676: EXCEPTION
677: When NO_DATA_FOUND Then
678: Null;

Line 796: from qp_list_lines ql, qp_rltd_modifiers qrm

792: SET product_uom_code = p_PRICING_ATTR_rec.product_uom_code
793: where list_line_id in
794: (
795: select to_rltd_modifier_id
796: from qp_list_lines ql, qp_rltd_modifiers qrm
797: where from_rltd_modifier_id= p_PRICING_ATTR_rec.list_line_id
798: AND qrm.to_rltd_modifier_id = ql.list_line_id
799: AND qrm.rltd_modifier_grp_type = 'PRICE BREAK'
800: ) ;

Line 1273: from qp_list_lines where

1269: l_list_line_id := p_Pricing_Attr_rec.list_line_id;
1270:
1271:
1272: select list_line_type_code into l_list_line_type_code
1273: from qp_list_lines where
1274: list_line_id = l_list_line_id;
1275:
1276: IF l_list_line_type_code = 'PBH' THEN
1277:

Line 1323: update qp_list_lines set

1319:
1320: --get or related records
1321:
1322:
1323: update qp_list_lines set
1324: list_line_no = p_Pricing_Attr_rec.list_line_no
1325: ,modifier_level_code = p_Pricing_Attr_rec.modifier_level_code
1326: ,automatic_flag = p_Pricing_Attr_rec.automatic_flag
1327: ,override_flag = p_Pricing_Attr_rec.override_flag

Line 1439: FROM QP_LIST_HEADERS_B lh, QP_LIST_LINES ll

1435: --End Bug 5465263
1436:
1437: SELECT lh.ACTIVE_FLAG
1438: INTO l_active_flag
1439: FROM QP_LIST_HEADERS_B lh, QP_LIST_LINES ll
1440: WHERE lh.LIST_HEADER_ID = ll.LIST_HEADER_ID and ll.LIST_LINE_ID = p_PRICING_ATTR_rec.list_line_id and rownum = 1;
1441:
1442: oe_debug_pub.add('BEGIN Update_Row in QPXUPRAB');
1443:

Line 1553: FROM qp_list_lines

1549: --Fetch list line type code
1550: BEGIN
1551: SELECT list_line_type_code
1552: INTO l_list_line_type_code
1553: FROM qp_list_lines
1554: WHERE list_line_id = p_PRICING_ATTR_rec.list_line_id;
1555: EXCEPTION
1556: WHEN OTHERS THEN
1557: l_list_line_type_code := '';

Line 1638: FROM QP_LIST_HEADERS_B a,QP_LIST_LINES b

1634: ELSE
1635:
1636: SELECT ACTIVE_FLAG
1637: INTO l_active_flag
1638: FROM QP_LIST_HEADERS_B a,QP_LIST_LINES b
1639: WHERE b.list_line_id=p_PRICING_ATTR_rec.list_line_id
1640: AND b.LIST_HEADER_ID = a.list_header_id;
1641: END IF;
1642: oe_debug_pub.add('BEGIN Insert_Row in QPXUPRAB');

Line 1823: FROM qp_list_lines

1819: --Fetch list line type code (Bug 4706180)
1820: BEGIN
1821: SELECT list_line_type_code
1822: INTO l_list_line_type_code
1823: FROM qp_list_lines
1824: WHERE list_line_id = p_PRICING_ATTR_rec.list_line_id;
1825: EXCEPTION
1826: WHEN OTHERS THEN
1827: l_list_line_type_code := '';

Line 2799: from qp_list_lines

2795: ELSE
2796:
2797: select list_header_id
2798: into l_list_header_id
2799: from qp_list_lines
2800: where list_line_id = l_PRICING_ATTR_rec.list_line_id;
2801:
2802: END IF;
2803: