APPS.QP_UPDATE_FORMULAPRICE_PVT dependencies on QP_PREQ_LINE_ATTRS_FORMULA_TMP

Line 128: --DELETE FROM qp_preq_line_attrs_formula_tmp;

124: '00999999999999999999999.99999999999999999999999999999999999999'; --Added for 2884567
125: l_req_line_attrs_tbl.DELETE; /* Empty the plsql table for each list line */
126:
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

Line 129: --dbms_output.put_line('deleted rows from qp_preq_line_attrs_formula_tmp');

125: l_req_line_attrs_tbl.DELETE; /* Empty the plsql table for each list line */
126:
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:

Line 146: INSERT INTO qp_preq_line_attrs_formula_tmp

142: -- bug2425851
143:
144: IF l_attributes_rec.product_attribute_datatype = 'N' THEN
145: --Insert request line attrs with datatype = 'N'
146: INSERT INTO qp_preq_line_attrs_formula_tmp
147: (
148: line_index,
149: attribute_type,
150: context,

Line 171: INSERT INTO qp_preq_line_attrs_formula_tmp

167: -- bug 2425851
168:
169: ELSIF l_attributes_rec.product_attribute_datatype IN ('X','Y','C') THEN
170: --Insert request line attrs with datatype 'X', 'Y', 'C'
171: INSERT INTO qp_preq_line_attrs_formula_tmp
172: (
173: line_index,
174: attribute_type,
175: context,

Line 209: INSERT INTO qp_preq_line_attrs_formula_tmp

205:
206: IF l_attributes_rec.pricing_attribute_datatype = 'N' THEN
207:
208: --Insert request line attrs with datatype = 'N'
209: INSERT INTO qp_preq_line_attrs_formula_tmp
210: (
211: line_index,
212: attribute_type,
213: context,

Line 232: INSERT INTO qp_preq_line_attrs_formula_tmp

228:
229: ELSIF l_attributes_rec.pricing_attribute_datatype IN ('X','Y','C') THEN
230:
231: --Insert request line attrs with datatype 'X', 'Y', 'C'
232: INSERT INTO qp_preq_line_attrs_formula_tmp
233: (
234: line_index,
235: attribute_type,
236: context,

Line 274: DELETE FROM qp_preq_line_attrs_formula_tmp; -- no need since it is done at the beginning of processing each line

270: p_modifier_value => NULL);
271: --dbms_output.put_line('value returned by the formula calculation engine ' || l_list_price);
272:
273: --Delete the temp table records inserted above
274: DELETE FROM qp_preq_line_attrs_formula_tmp; -- no need since it is done at the beginning of processing each line
275: --dbms_output.put_line('deleted rows from qp_preq_line_attrs_formula_tmp');
276:
277: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
278: l_error_message := Fnd_Message.GET;

Line 275: --dbms_output.put_line('deleted rows from qp_preq_line_attrs_formula_tmp');

271: --dbms_output.put_line('value returned by the formula calculation engine ' || l_list_price);
272:
273: --Delete the temp table records inserted above
274: DELETE FROM qp_preq_line_attrs_formula_tmp; -- no need since it is done at the beginning of processing each line
275: --dbms_output.put_line('deleted rows from qp_preq_line_attrs_formula_tmp');
276:
277: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
278: l_error_message := Fnd_Message.GET;
279: Fnd_File.put_line(Fnd_File.LOG,l_error_message);