DBA Data[Home] [Help]

APPS.QP_FORMULA_PRICE_CALC_PVT dependencies on QP_PRICE_FORMULAS_TL

Line 498: l_formula_name qp_price_formulas_tl.name%TYPE;

494:
495: l_formula_start_time NUMBER;
496: l_formula_end_time NUMBER;
497: l_time_difference NUMBER;
498: l_formula_name qp_price_formulas_tl.name%TYPE;
499:
500: BEGIN
501:
502: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

Line 514: FROM qp_price_formulas_tl

510:
511: --added for formula messages
512: SELECT name
513: INTO l_formula_name
514: FROM qp_price_formulas_tl
515: WHERE price_formula_id = p_price_formula_id
516: AND rownum<2;
517:
518: OPEN price_formulas_cur (p_price_formula_id, p_price_effective_date);

Line 1217: l_formula_name qp_price_formulas_tl.name%TYPE;

1213: l_price_formula_line_type_code qp_price_formula_lines.price_formula_line_type_code%TYPE;
1214: l_pricing_attribute_context qp_price_formula_lines.pricing_attribute_context%TYPE;
1215: l_pricing_attribute qp_price_formula_lines.pricing_attribute%TYPE;
1216: l_all_steps VARCHAR2(100);
1217: l_formula_name qp_price_formulas_tl.name%TYPE;
1218: l_index NUMBER;
1219: l_attribute VARCHAR2(80);
1220: --added for display of right message in case of undefined step.
1221: --can be removed once validation is done in formula form.