46: IS
47:
48: BEGIN
49:
50: INSERT INTO qp_price_formulas_b
51: ( price_formula_id,
52: creation_date,
53: created_by,
54: last_update_date,
1144:
1145: BEGIN
1146: SELECT 'Y'
1147: INTO l_exists
1148: FROM qp_price_formulas_b b
1149: WHERE b.price_formula_id = l_rec.pricing_rule_id;
1150: EXCEPTION
1151: WHEN NO_DATA_FOUND THEN
1152: l_exists := NULL;
1552:
1553: -- Flexfield Merging
1554: -- Run the utility procedure to upgrade Descriptive Flexfields
1555: -- from Pricing to Price Formulas
1556: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_PRICING_RULES', 'QP_PRICE_FORMULAS_B');
1557: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_PRICING_RULE_LINES', 'QP_PRICE_FORMULA_LINES');
1558: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_RULE_FORMULA_COMPONENTS', 'QP_LIST_HEADERS');
1559: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_PRICING_RULE_LINE_VALUES', 'QP_LIST_LINES');
1560: commit;