APPS.QP_UPDATE_FORMULAPRICE_PVT dependencies on QP_PRICING_ATTRIBUTES

Line 55: CURSOR qp_pricing_attributes_cur(a_list_line_id NUMBER)

51: 'Y', 'Y', NVL(reprice_flag, 'N'))
52: FOR UPDATE;
53: */
54:
55: CURSOR qp_pricing_attributes_cur(a_list_line_id NUMBER)
56: IS
57: SELECT *
58: FROM qp_pricing_attributes
59: WHERE list_line_id = a_list_line_id;

Line 58: FROM qp_pricing_attributes

54:
55: CURSOR qp_pricing_attributes_cur(a_list_line_id NUMBER)
56: IS
57: SELECT *
58: FROM qp_pricing_attributes
59: WHERE list_line_id = a_list_line_id;
60:
61: TYPE QpListLinesCurTyp IS REF CURSOR;
62: qp_list_lines_cursor QpListLinesCurTyp;

Line 131: FOR l_attributes_rec IN qp_pricing_attributes_cur(l_lines_rec.list_line_id)

127: --Delete already existing rows from formula tmp table
128: --DELETE FROM qp_preq_line_attrs_formula_tmp;
129: --dbms_output.put_line('deleted rows from qp_preq_line_attrs_formula_tmp');
130:
131: FOR l_attributes_rec IN qp_pricing_attributes_cur(l_lines_rec.list_line_id)
132: LOOP
133:
134: /* Get the Product Info from any one pricing attribute of a list line*/
135: IF qp_pricing_attributes_cur%ROWCOUNT = 1 THEN

Line 135: IF qp_pricing_attributes_cur%ROWCOUNT = 1 THEN

131: FOR l_attributes_rec IN qp_pricing_attributes_cur(l_lines_rec.list_line_id)
132: LOOP
133:
134: /* Get the Product Info from any one pricing attribute of a list line*/
135: IF qp_pricing_attributes_cur%ROWCOUNT = 1 THEN
136:
137: --Insert the product information record into the temp table since
138: --the formula processing code has been changed(bug 1806928) to look
139: --into temp tables for factor processing due to performance reasons.