DBA Data[Home] [Help]

APPS.OE_BLANKET_PRICING_UTIL dependencies on QP_MODIFIERS_PUB

Line 58: l_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

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;

Line 59: l_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_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;

Line 60: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_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;

Line 61: l_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_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;

Line 64: l_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_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;

Line 65: l_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_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;

Line 66: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_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;

Line 67: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_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;

Line 68: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_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;

Line 69: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_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;
73: l_x_qualifier_rules_val_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;

Line 74: l_x_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_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;
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;

Line 75: l_x_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_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;

Line 521: l_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

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;

Line 522: l_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;

Line 523: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_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;

Line 524: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_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;

Line 525: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_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;

Line 526: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_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;

Line 529: l_x_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_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:

Line 530: l_x_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_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:
534: if l_debug_level > 0 then

Line 613: l_modifier_list_tbl QP_Modifiers_PUB.Modifier_List_Tbl_Type;

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';