DBA Data[Home] [Help]

APPS.QP_FORMULA_PRICE_CALC_PVT dependencies on QP_PRICE_FORMULAS_TL

Line 500: l_formula_name qp_price_formulas_tl.name%TYPE;

496:
497: l_formula_start_time NUMBER;
498: l_formula_end_time NUMBER;
499: l_time_difference NUMBER;
500: l_formula_name qp_price_formulas_tl.name%TYPE;
501: L_MAINT_DYN_SRC_VER VARCHAR2(1) := NVL(Fnd_Profile.value('QP_MAINTAIN_DYNAMIC_SOURCE_VERSIONS'),'N'); -- 13638721
502: l_pkg_ver VARCHAR2(10);
503: BEGIN
504:

Line 517: FROM qp_price_formulas_tl

513:
514: --added for formula messages
515: SELECT name
516: INTO l_formula_name
517: FROM qp_price_formulas_tl
518: WHERE price_formula_id = p_price_formula_id
519: AND language = userenv('LANG') --bug#13250347
520: AND rownum<2;
521:

Line 1431: l_formula_name qp_price_formulas_tl.name%TYPE;

1427: l_price_formula_line_type_code qp_price_formula_lines.price_formula_line_type_code%TYPE;
1428: l_pricing_attribute_context qp_price_formula_lines.pricing_attribute_context%TYPE;
1429: l_pricing_attribute qp_price_formula_lines.pricing_attribute%TYPE;
1430: l_all_steps VARCHAR2(100);
1431: l_formula_name qp_price_formulas_tl.name%TYPE;
1432: l_index NUMBER;
1433: l_attribute VARCHAR2(80);
1434: --added for display of right message in case of undefined step.
1435: --can be removed once validation is done in formula form.