153: l_return_status VARCHAR2(1);
154: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
155: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
156: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
157: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
158: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
159: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
160: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
161: BEGIN
154: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
155: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
156: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
157: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
158: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
159: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
160: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
161: BEGIN
162:
566: l_return_status VARCHAR2(1);
567: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
568: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
569: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
570: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
571: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
572: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
573: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
574: BEGIN
567: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
568: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
569: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
570: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
571: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
572: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
573: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
574: BEGIN
575:
1588: l_return_status VARCHAR2(1);
1589: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1590: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1591: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1592: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1593: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1594: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1595: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1596: BEGIN
1589: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1590: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1591: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1592: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1593: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1594: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1595: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1596: BEGIN
1597:
1755: l_return_status VARCHAR2(1);
1756: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1757: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1758: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1759: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1760: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1761: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1762: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1763: BEGIN
1756: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1757: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1758: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1759: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1760: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1761: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1762: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1763: BEGIN
1764:
1893: l_return_status VARCHAR2(1);
1894: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1895: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1896: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1897: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1898: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1899: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1900: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1901: BEGIN
1894: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
1895: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
1896: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
1897: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
1898: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
1899: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
1900: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
1901: BEGIN
1902:
2107: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2108: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2109: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2110: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2111: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2112: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2113: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2114: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2115: BEGIN
2108: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2109: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2110: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2111: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2112: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2113: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2114: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2115: BEGIN
2116:
2433: l_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2434: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2435: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2436: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2437: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
2438: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
2439: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2440: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2441: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2434: l_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2435: l_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2436: l_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2437: l_QUALIFIERS_rec Qp_Qualifier_Rules_Pub.Qualifiers_Rec_Type;
2438: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
2439: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2440: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2441: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2442: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2438: l_QUALIFIERS_tbl Qp_Qualifier_Rules_Pub.Qualifiers_Tbl_Type;
2439: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2440: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2441: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2442: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2443: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2444: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2445: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2446: l_continuous_price_break_flag varchar2(1);
2439: l_x_MODIFIER_LIST_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
2440: l_x_MODIFIERS_rec QP_Modifiers_PUB.Modifiers_Rec_Type;
2441: l_x_MODIFIERS_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
2442: l_x_QUALIFIERS_rec QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
2443: l_x_QUALIFIERS_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
2444: l_x_PRICING_ATTR_rec QP_Modifiers_PUB.Pricing_Attr_Rec_Type;
2445: l_x_PRICING_ATTR_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
2446: l_continuous_price_break_flag varchar2(1);
2447: