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 1289: from qp_list_lines where

1285: l_list_line_id := p_Pricing_Attr_rec.list_line_id;
1286:
1287:
1288: select list_line_type_code into l_list_line_type_code
1289: from qp_list_lines where
1290: list_line_id = l_list_line_id;
1291:
1292: IF l_list_line_type_code = 'PBH' THEN
1293:

Line 1339: update qp_list_lines set

1335:
1336: --get or related records
1337:
1338:
1339: update qp_list_lines set
1340: list_line_no = p_Pricing_Attr_rec.list_line_no
1341: ,modifier_level_code = p_Pricing_Attr_rec.modifier_level_code
1342: ,automatic_flag = p_Pricing_Attr_rec.automatic_flag
1343: ,override_flag = p_Pricing_Attr_rec.override_flag

Line 1455: FROM QP_LIST_HEADERS_B lh, QP_LIST_LINES ll

1451: --End Bug 5465263
1452:
1453: SELECT lh.ACTIVE_FLAG
1454: INTO l_active_flag
1455: FROM QP_LIST_HEADERS_B lh, QP_LIST_LINES ll
1456: WHERE lh.LIST_HEADER_ID = ll.LIST_HEADER_ID and ll.LIST_LINE_ID = p_PRICING_ATTR_rec.list_line_id and rownum = 1;
1457:
1458: oe_debug_pub.add('BEGIN Update_Row in QPXUPRAB');
1459:

Line 1569: FROM qp_list_lines

1565: --Fetch list line type code
1566: BEGIN
1567: SELECT list_line_type_code
1568: INTO l_list_line_type_code
1569: FROM qp_list_lines
1570: WHERE list_line_id = p_PRICING_ATTR_rec.list_line_id;
1571: EXCEPTION
1572: WHEN OTHERS THEN
1573: l_list_line_type_code := '';

Line 1654: FROM QP_LIST_HEADERS_B a,QP_LIST_LINES b

1650: ELSE
1651:
1652: SELECT ACTIVE_FLAG
1653: INTO l_active_flag
1654: FROM QP_LIST_HEADERS_B a,QP_LIST_LINES b
1655: WHERE b.list_line_id=p_PRICING_ATTR_rec.list_line_id
1656: AND b.LIST_HEADER_ID = a.list_header_id;
1657: END IF;
1658: oe_debug_pub.add('BEGIN Insert_Row in QPXUPRAB');

Line 1839: FROM qp_list_lines

1835: --Fetch list line type code (Bug 4706180)
1836: BEGIN
1837: SELECT list_line_type_code
1838: INTO l_list_line_type_code
1839: FROM qp_list_lines
1840: WHERE list_line_id = p_PRICING_ATTR_rec.list_line_id;
1841: EXCEPTION
1842: WHEN OTHERS THEN
1843: l_list_line_type_code := '';

Line 2889: from qp_list_lines

2885: ELSE
2886:
2887: select list_header_id
2888: into l_list_header_id
2889: from qp_list_lines
2890: where list_line_id = l_PRICING_ATTR_rec.list_line_id;
2891:
2892: END IF;
2893: