[Home] [Help]
555: BEGIN
556:
557: SELECT QP_PRICING_ATTRIBUTES_S.nextval
558: INTO l_pricing_attribute_id
559: FROM DUAL;
560:
561: SELECT QP_PRICING_ATTR_GROUP_NO_S.nextval
562: INTO l_attribute_grouping_no
563: FROM DUAL;
559: FROM DUAL;
560:
561: SELECT QP_PRICING_ATTR_GROUP_NO_S.nextval
562: INTO l_attribute_grouping_no
563: FROM DUAL;
564:
565: INSERT INTO qp_pricing_attributes(
566: pricing_attribute_id,
567: creation_date,
663: IF l_exists IS NULL THEN -- Price Modifier List Id does not already exist
664:
665: SELECT QP_LIST_HEADERS_B_S.nextval
666: INTO l_list_header_id
667: FROM DUAL;
668:
669: QP_PRICE_FORMULA_UPG_UTIL_PVT.Insert_List_Header(
670: l_list_header_id,
671: l_comp_rec.creation_date,
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(
709: l_list_line_id,
710: l_comp_rec.creation_date,
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
1196: --(Factor List), Modifier(Factor) and Modifier attributes
1197: --(Factor Pricing Attributes). Need to get contexts first.
1281: IF so_rule_line_comp_values_cur%ROWCOUNT = 1 THEN
1282:
1283: SELECT QP_LIST_HEADERS_B_S.nextval
1284: INTO l_list_header_id
1285: FROM DUAL;
1286:
1287: --dbms_output.put_line(' list header '||l_list_header_id);
1288: --dbms_output.put_line(l_value_rec.name || to_char(l_price_formula_line_id));
1289: --dbms_output.put_line(l_lines_rec.pricing_rule_id);
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(
1334: l_list_line_id,
1335: nvl(l_value_rec.creation_date,sysdate),