553: l_attribute_grouping_no NUMBER;
554:
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
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,
568: created_by,
569: last_update_date,