APPS.QP_FORMULA_PRICE_CALC_PVT dependencies on QP_NFORMULA_STEP_VALUES_TMP

Line 987: --Based on a profile option,formula step values will be inserted into qp_nformula_step_values_tmp

983:
984: END IF; -- IF stmt comparing price_formula_line_type_code to various values.
985: l_req_line_attrs_tbl.delete; --3531890 attribute were getting accumulated for every step
986: -- smbalara bug 7188211
987: --Based on a profile option,formula step values will be inserted into qp_nformula_step_values_tmp
988: IF QP_PREQ_GRP.G_INSERT_FORMULA_STEP_VALUES = 'Y' THEN
989: IF l_debug = FND_API.G_TRUE THEN
990: QP_PREQ_GRP.engine_debug('Before populating formula stepvalues temp table');
991: QP_PREQ_GRP.engine_debug('Value price_formula_id ='||l_formula_line_tbl(l_rec.step_number).price_formula_id );

Line 1001: INSERT INTO qp_nformula_step_values_tmp

997: QP_PREQ_GRP.engine_debug('Value list_header_id ='||l_formula_line_tbl(l_rec.step_number).list_header_id );
998: QP_PREQ_GRP.engine_debug('Value list_line_id ='||l_formula_line_tbl(l_rec.step_number).list_line_id );
999: END IF;
1000:
1001: INSERT INTO qp_nformula_step_values_tmp
1002: (price_formula_id,
1003: step_number,
1004: component_value,
1005: price_formula_line_type_code,

Line 1154: --populate qp_nformula_step_values_tmp table

1150:
1151: END IF;*/
1152: --commenting above for bug 10273166 smbalara END
1153: --Based on a profile option, loop over plsql table of formula lines to
1154: --populate qp_nformula_step_values_tmp table
1155: /* commented for bug 7188211 - temp table insert moved above
1156: IF QP_PREQ_GRP.G_INSERT_FORMULA_STEP_VALUES = 'Y' THEN
1157:
1158: IF l_debug = FND_API.G_TRUE THEN

Line 1172: INSERT INTO qp_nformula_step_values_tmp

1168: --Insert into temp table only for formulas attached to Price List Lines.
1169: IF l_formula_line_tbl(i).list_line_type_code = 'PLL'
1170: THEN
1171:
1172: INSERT INTO qp_nformula_step_values_tmp
1173: (price_formula_id,
1174: step_number,
1175: component_value,
1176: price_formula_line_type_code,