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 982: from qp_list_lines

978: IF p_MODIFIER_LIST_rec.operation = QP_GLOBALS.G_OPR_UPDATE THEN
979:
980: BEGIN
981: select 'Y' into l_modifiers_exist
982: from qp_list_lines
983: where list_header_id = p_MODIFIER_LIST_rec.list_header_id
984: and rownum = 1;
985: EXCEPTION
986: When OTHERS THEN

Line 2274: FROM qp_list_lines

2270: IS
2271: CURSOR C1(a_list_header_id NUMBER)
2272: IS
2273: SELECT list_line_id
2274: FROM qp_list_lines
2275: WHERE list_header_id = a_list_header_id;
2276:
2277: BEGIN
2278:

Line 2292: DELETE FROM QP_LIST_LINES

2288: WHERE FROM_RLTD_MODIFIER_ID = list_lines.list_line_id;
2289:
2290: END LOOP;
2291:
2292: DELETE FROM QP_LIST_LINES
2293: WHERE LIST_HEADER_ID = p_list_header_id;
2294:
2295: DELETE FROM QP_QUALIFIERS
2296: WHERE LIST_HEADER_ID = p_list_header_id;