DBA Data[Home] [Help]

APPS.QP_PRICE_FORMULA_UPG_UTIL_PVT dependencies on QP_PRICE_FORMULAS_B

Line 50: INSERT INTO qp_price_formulas_b

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,

Line 1148: FROM qp_price_formulas_b b

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;

Line 1556: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_PRICING_RULES', 'QP_PRICE_FORMULAS_B');

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;