APPS.QP_MODIFIER_LIST_UTIL dependencies on QP_LIST_LINES

Line 570: select distinct pricing_phase_id from qp_list_lines

566: IS
567: l_modifiers_exist VARCHAR2(1) := 'N';
568: ------------------------fix for bug 3756625
569: CURSOR l_pricing_phase_cur (l_list_header_id NUMBER) IS
570: select distinct pricing_phase_id from qp_list_lines
571: where list_header_id = l_list_header_id;
572: BEGIN
573:
574: oe_debug_pub.add('BEGIN apply_attribute_changes in QPXUMLHB');

Line 872: from qp_list_lines

868: IF p_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
869:
870: BEGIN
871: select 'Y' into l_modifiers_exist
872: from qp_list_lines
873: where list_header_id = p_MODIFIER_LIST_rec.list_header_id
874: and rownum = 1;
875: EXCEPTION
876: When OTHERS THEN

Line 2043: FROM qp_list_lines

2039: IS
2040: CURSOR C1(a_list_header_id NUMBER)
2041: IS
2042: SELECT list_line_id
2043: FROM qp_list_lines
2044: WHERE list_header_id = a_list_header_id;
2045:
2046: BEGIN
2047:

Line 2061: DELETE FROM QP_LIST_LINES

2057: WHERE FROM_RLTD_MODIFIER_ID = list_lines.list_line_id;
2058:
2059: END LOOP;
2060:
2061: DELETE FROM QP_LIST_LINES
2062: WHERE LIST_HEADER_ID = p_list_header_id;
2063:
2064: DELETE FROM QP_QUALIFIERS
2065: WHERE LIST_HEADER_ID = p_list_header_id;