54: l_return_status varchar2(1);
55: l_msg_count NUMBER;
56: l_msg_data varchar2(2000);
57:
58: l_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
59: l_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
60: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
61: l_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
62: l_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
55: l_msg_count NUMBER;
56: l_msg_data varchar2(2000);
57:
58: l_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
59: l_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
60: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
61: l_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
62: l_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
63: l_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
56: l_msg_data varchar2(2000);
57:
58: l_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
59: l_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
60: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
61: l_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
62: l_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
63: l_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
64: l_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
57:
58: l_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
59: l_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
60: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
61: l_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
62: l_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
63: l_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
64: l_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
65: l_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
60: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
61: l_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
62: l_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
63: l_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
64: l_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
65: l_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
66: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
67: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
68: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
61: l_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
62: l_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
63: l_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
64: l_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
65: l_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
66: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
67: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
68: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
69: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
62: l_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
63: l_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
64: l_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
65: l_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
66: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
67: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
68: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
69: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
70: l_x_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
63: l_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
64: l_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
65: l_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
66: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
67: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
68: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
69: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
70: l_x_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
71: l_x_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
64: l_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
65: l_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
66: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
67: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
68: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
69: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
70: l_x_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
71: l_x_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
72: l_x_qualifier_rules_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
65: l_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
66: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
67: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
68: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
69: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
70: l_x_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
71: l_x_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
72: l_x_qualifier_rules_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
73: l_x_qualifier_rules_val_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
70: l_x_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
71: l_x_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
72: l_x_qualifier_rules_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
73: l_x_qualifier_rules_val_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
74: l_x_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
75: l_x_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
76: l_control_rec QP_GLOBALS.Control_Rec_Type;
77:
78: l_line_id_tbl OE_GLOBALS.Number_Tbl_Type;
71: l_x_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
72: l_x_qualifier_rules_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
73: l_x_qualifier_rules_val_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
74: l_x_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
75: l_x_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
76: l_control_rec QP_GLOBALS.Control_Rec_Type;
77:
78: l_line_id_tbl OE_GLOBALS.Number_Tbl_Type;
79: l_hdr_req_index NUMBER;
517: l_msg_data varchar2(2000);
518: --
519: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
520: --
521: l_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
522: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
523: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
524: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
525: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
518: --
519: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
520: --
521: l_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
522: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
523: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
524: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
525: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
526: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
519: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
520: --
521: l_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
522: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
523: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
524: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
525: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
526: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
527: l_x_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
520: --
521: l_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
522: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
523: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
524: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
525: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
526: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
527: l_x_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
528: l_x_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
521: l_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
522: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
523: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
524: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
525: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
526: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
527: l_x_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
528: l_x_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
529: l_x_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
522: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
523: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
524: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
525: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
526: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
527: l_x_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
528: l_x_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
529: l_x_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
530: l_x_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
525: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
526: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
527: l_x_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
528: l_x_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
529: l_x_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
530: l_x_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
531: l_control_rec QP_GLOBALS.Control_Rec_Type;
532: BEGIN
533:
526: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
527: l_x_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
528: l_x_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
529: l_x_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
530: l_x_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
531: l_control_rec QP_GLOBALS.Control_Rec_Type;
532: BEGIN
533:
534: if l_debug_level > 0 then
609: IS
610: l_qp_list_line_id NUMBER;
611: l_mod_list_line_id NUMBER;
612: l_price_list_tbl QP_Price_List_PUB.Price_List_Tbl_Type;
613: l_modifier_list_tbl QP_Modifiers_PUB.Modifier_List_Tbl_Type;
614: l_return_status VARCHAR2(30);
615: l_msg_count NUMBER;
616: l_msg_data VARCHAR2(2000);
617: l_exist_qp_list_line_id VARCHAR2(1) := 'Y';