DBA Data[Home] [Help]

APPS.QP_PRICE_FORMULA_UPG_UTIL_PVT dependencies on QP_PRICE_FORMULA_LINES

Line 194: INSERT INTO qp_price_formula_lines

190: IS
191:
192: BEGIN
193:
194: INSERT INTO qp_price_formula_lines
195: ( price_formula_line_id
196: , creation_date
197: , created_by
198: , last_update_date

Line 1191: SELECT QP_PRICE_FORMULA_LINES_S.nextval

1187: FOR l_lines_rec IN
1188: so_pricing_rule_lines_cur(l_rec.pricing_rule_id)
1189: LOOP
1190:
1191: SELECT QP_PRICE_FORMULA_LINES_S.nextval
1192: INTO l_price_formula_line_id
1193: FROM DUAL;
1194:
1195: --Before inserting the formula line record, insert a Modifier List

Line 1557: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_PRICING_RULE_LINES', 'QP_PRICE_FORMULA_LINES');

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;
1561: