APPS.QP_FORMULA_PRICE_CALC_PVT dependencies on QP_NFORMULA_STEP_VALUES_TMP

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

825:
826: END IF; -- IF stmt comparing price_formula_line_type_code to various values.
827: l_req_line_attrs_tbl.delete; --3531890 attribute were getting accumulated for every step
828: -- smbalara bug 7188211
829: --Based on a profile option,formula step values will be inserted into qp_nformula_step_values_tmp
830: IF QP_PREQ_GRP.G_INSERT_FORMULA_STEP_VALUES = 'Y' THEN
831: IF l_debug = FND_API.G_TRUE THEN
832: QP_PREQ_GRP.engine_debug('Before populating formula stepvalues temp table');
833: QP_PREQ_GRP.engine_debug('Value 1='||l_formula_line_tbl(l_rec.step_number).price_formula_id );

Line 843: INSERT INTO qp_nformula_step_values_tmp

839: QP_PREQ_GRP.engine_debug('Value 7='||l_formula_line_tbl(l_rec.step_number).list_header_id );
840: QP_PREQ_GRP.engine_debug('Value 8='||l_formula_line_tbl(l_rec.step_number).list_line_id );
841: END IF;
842:
843: INSERT INTO qp_nformula_step_values_tmp
844: (price_formula_id,
845: step_number,
846: component_value,
847: price_formula_line_type_code,

Line 995: --populate qp_nformula_step_values_tmp table

991: QP_PREQ_GRP.engine_debug('After populating plsql table of formula lines');
992:
993: END IF;
994: --Based on a profile option, loop over plsql table of formula lines to
995: --populate qp_nformula_step_values_tmp table
996: /* commented for bug 7188211 - temp table insert moved above
997: IF QP_PREQ_GRP.G_INSERT_FORMULA_STEP_VALUES = 'Y' THEN
998:
999: IF l_debug = FND_API.G_TRUE THEN

Line 1013: INSERT INTO qp_nformula_step_values_tmp

1009: --Insert into temp table only for formulas attached to Price List Lines.
1010: IF l_formula_line_tbl(i).list_line_type_code = 'PLL'
1011: THEN
1012:
1013: INSERT INTO qp_nformula_step_values_tmp
1014: (price_formula_id,
1015: step_number,
1016: component_value,
1017: price_formula_line_type_code,