APPS.QP_PRICE_FORMULA_UPG_UTIL_PVT dependencies on QP_LIST_LINES

Line 452: INSERT INTO qp_list_lines (

448: )
449: IS
450: BEGIN
451:
452: INSERT INTO qp_list_lines (
453: list_line_id,
454: list_line_no,
455: creation_date,
456: created_by,

Line 607: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_list_line_id)

603: p_pricing_attribute_datatype,
604: p_comparison_operator_code
605: --ENH Upgrade BOAPI for orig_sys...ref RAVI
606: ,to_char(l_pricing_attribute_id)
607: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_list_line_id)
608: ,(select l.ORIG_SYS_HEADER_REF from qp_list_lines l where l.list_line_id=p_list_line_id)
609: );
610:
611: EXCEPTION

Line 608: ,(select l.ORIG_SYS_HEADER_REF from qp_list_lines l where l.list_line_id=p_list_line_id)

604: p_comparison_operator_code
605: --ENH Upgrade BOAPI for orig_sys...ref RAVI
606: ,to_char(l_pricing_attribute_id)
607: ,(select l.ORIG_SYS_LINE_REF from qp_list_lines l where l.list_line_id=p_list_line_id)
608: ,(select l.ORIG_SYS_HEADER_REF from qp_list_lines l where l.list_line_id=p_list_line_id)
609: );
610:
611: EXCEPTION
612: WHEN OTHERS THEN

Line 704: SELECT QP_LIST_LINES_S.nextval

700: '1' --version_no
701: );
702:
703:
704: SELECT QP_LIST_LINES_S.nextval
705: INTO l_list_line_id
706: FROM DUAL;
707:
708: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_List_Line(

Line 1329: SELECT QP_LIST_LINES_S.nextval

1325: );
1326:
1327: END IF; --If rowcount = 1
1328:
1329: SELECT QP_LIST_LINES_S.nextval
1330: INTO l_list_line_id
1331: FROM DUAL;
1332:
1333: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_List_Line(

Line 1559: -- QP_UTIL.qp_upgrade_context('OE', 'QP', 'SO_PRICING_RULE_LINE_VALUES', 'QP_LIST_LINES');

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:
1562: EXCEPTION
1563: WHEN OTHERS THEN