DBA Data[Home] [Help]

APPS.OE_BLANKET_PRICING_UTIL dependencies on QP_MODIFIERS_PUB

Line 59: l_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

55: l_return_status varchar2(1);
56: l_msg_count NUMBER;
57: l_msg_data varchar2(2000);
58:
59: l_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
60: l_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
61: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
62: l_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
63: l_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 60: l_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;

56: l_msg_count NUMBER;
57: l_msg_data varchar2(2000);
58:
59: l_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
60: l_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
61: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
62: l_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
63: l_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
64: l_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;

Line 61: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

57: l_msg_data varchar2(2000);
58:
59: l_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
60: l_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
61: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
62: l_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
63: l_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
64: l_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
65: l_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 62: l_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;

58:
59: l_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
60: l_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
61: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
62: l_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
63: l_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
64: l_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
65: l_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
66: l_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;

Line 65: l_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

61: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
62: l_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
63: l_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
64: l_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
65: l_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
66: l_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
67: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
68: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
69: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

Line 66: l_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;

62: l_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
63: l_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
64: l_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
65: l_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
66: l_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
67: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
68: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
69: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
70: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;

Line 67: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

63: l_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
64: l_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
65: l_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
66: l_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
67: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
68: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
69: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
70: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
71: l_x_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 68: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;

64: l_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
65: l_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
66: l_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
67: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
68: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
69: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
70: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
71: l_x_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
72: l_x_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;

Line 69: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

65: l_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
66: l_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
67: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
68: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
69: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
70: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
71: l_x_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
72: l_x_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
73: l_x_qualifier_rules_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;

Line 70: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;

66: l_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
67: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
68: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
69: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
70: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
71: l_x_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
72: l_x_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
73: l_x_qualifier_rules_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
74: l_x_qualifier_rules_val_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;

Line 75: l_x_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

71: l_x_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
72: l_x_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
73: l_x_qualifier_rules_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
74: l_x_qualifier_rules_val_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
75: l_x_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
76: l_x_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
77: l_control_rec QP_GLOBALS.Control_Rec_Type;
78:
79: l_line_id_tbl OE_GLOBALS.Number_Tbl_Type;

Line 76: l_x_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;

72: l_x_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
73: l_x_qualifier_rules_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Rec_Type;
74: l_x_qualifier_rules_val_rec QP_Qualifier_Rules_PUB.Qualifier_Rules_Val_Rec_Type;
75: l_x_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
76: l_x_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
77: l_control_rec QP_GLOBALS.Control_Rec_Type;
78:
79: l_line_id_tbl OE_GLOBALS.Number_Tbl_Type;
80: l_hdr_req_index NUMBER;

Line 542: l_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

538: l_msg_data varchar2(2000);
539: --
540: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
541: --
542: l_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
543: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
544: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
545: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
546: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

Line 543: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

539: --
540: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
541: --
542: l_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
543: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
544: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
545: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
546: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
547: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;

Line 544: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;

540: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
541: --
542: l_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
543: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
544: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
545: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
546: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
547: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
548: l_x_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

Line 545: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;

541: --
542: l_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
543: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
544: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
545: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
546: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
547: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
548: l_x_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
549: l_x_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;

Line 546: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;

542: l_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
543: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
544: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
545: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
546: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
547: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
548: l_x_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
549: l_x_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
550: l_x_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

Line 547: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;

543: l_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
544: l_x_modifier_list_rec QP_Modifiers_PUB.Modifier_List_Rec_Type;
545: l_x_modifier_list_val_rec QP_Modifiers_PUB.Modifier_List_Val_Rec_Type;
546: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
547: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
548: l_x_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
549: l_x_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
550: l_x_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
551: l_x_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;

Line 550: l_x_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;

546: l_x_modifiers_tbl QP_Modifiers_PUB.Modifiers_Tbl_Type;
547: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
548: l_x_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
549: l_x_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
550: l_x_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
551: l_x_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
552: l_control_rec QP_GLOBALS.Control_Rec_Type;
553: BEGIN
554:

Line 551: l_x_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;

547: l_x_modifiers_val_tbl QP_Modifiers_PUB.Modifiers_Val_Tbl_Type;
548: l_x_qualifiers_tbl QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
549: l_x_qualifiers_val_tbl QP_Qualifier_Rules_PUB.Qualifiers_Val_Tbl_Type;
550: l_x_pricing_attr_tbl QP_Modifiers_PUB.Pricing_Attr_Tbl_Type;
551: l_x_pricing_attr_val_tbl QP_Modifiers_PUB.Pricing_Attr_Val_Tbl_Type;
552: l_control_rec QP_GLOBALS.Control_Rec_Type;
553: BEGIN
554:
555: if l_debug_level > 0 then

Line 634: l_modifier_list_tbl QP_Modifiers_PUB.Modifier_List_Tbl_Type;

630: IS
631: l_qp_list_line_id NUMBER;
632: l_mod_list_line_id NUMBER;
633: l_price_list_tbl QP_Price_List_PUB.Price_List_Tbl_Type;
634: l_modifier_list_tbl QP_Modifiers_PUB.Modifier_List_Tbl_Type;
635: l_return_status VARCHAR2(30);
636: l_msg_count NUMBER;
637: l_msg_data VARCHAR2(2000);
638: l_exist_qp_list_line_id VARCHAR2(1) := 'Y';