eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_OFFER_PVT dependencies on QP_MODIFIERS_PUB

Line 8: -- Use QP_Modifiers_PUB package to create offers.

4: -- PACKAGE
5: -- OZF_Offer_PVT
6: --
7: -- PURPOSE
8: -- Use QP_Modifiers_PUB package to create offers.
9: --
10: -- PROCEDURES
11: -- PUBLIC -- Process_modifiers
12: -- PRIVATE -- Process_offers

Line 635: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;

631: AND b.site_use_code = p_site_use_code
632: AND b.site_use_id = p_site_use_id;
633: -- end comment
634:
635: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
636:
637: l_api_version CONSTANT NUMBER := 1.0;
638: l_api_name CONSTANT VARCHAR2(30) := 'process_adv_options';
639: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 644: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

640: l_object_version_number NUMBER;
641:
642: i NUMBER := 1;
643:
644: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
645: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
646: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
647: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
648: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 645: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

641:
642: i NUMBER := 1;
643:
644: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
645: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
646: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
647: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
648: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
649: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 646: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

642: i NUMBER := 1;
643:
644: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
645: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
646: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
647: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
648: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
649: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
650: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

Line 647: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

643:
644: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
645: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
646: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
647: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
648: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
649: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
650: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
651: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

Line 650: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

646: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
647: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
648: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
649: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
650: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
651: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
652: l_promotional_offers_rec ozf_promotional_offers_pvt.offers_rec_type;
653:
654: BEGIN

Line 651: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

647: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
648: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
649: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
650: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
651: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
652: l_promotional_offers_rec ozf_promotional_offers_pvt.offers_rec_type;
653:
654: BEGIN
655:

Line 693: Qp_Modifiers_Pub.process_modifiers(

689:
690: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in process_adv_options---');
691: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT.process_adv_options before calling QP for list_header_id : '|| p_advanced_options_rec.list_header_id);
692:
693: Qp_Modifiers_Pub.process_modifiers(
694: p_api_version_number => 1.0,
695: p_init_msg_list => p_init_msg_list,
696: p_return_values => Fnd_Api.G_FALSE,
697: x_return_status => x_return_status,

Line 816: -- ,x_modifiers_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

812: ,x_msg_count OUT NOCOPY NUMBER
813: ,x_msg_data OUT NOCOPY VARCHAR2
814: ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
815: ,x_error_location OUT NOCOPY NUMBER
816: -- ,x_modifiers_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
817: -- ,x_pricing_attr_tbl OUT NOCOPY qp_modifiers_pub.pricing_attr_tbl_type
818: )
819: IS
820: l_api_version CONSTANT NUMBER := 1.0;

Line 817: -- ,x_pricing_attr_tbl OUT NOCOPY qp_modifiers_pub.pricing_attr_tbl_type

813: ,x_msg_data OUT NOCOPY VARCHAR2
814: ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
815: ,x_error_location OUT NOCOPY NUMBER
816: -- ,x_modifiers_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
817: -- ,x_pricing_attr_tbl OUT NOCOPY qp_modifiers_pub.pricing_attr_tbl_type
818: )
819: IS
820: l_api_version CONSTANT NUMBER := 1.0;
821: l_api_name CONSTANT VARCHAR2(30) := 'create_offer_tiers';

Line 824: l_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

820: l_api_version CONSTANT NUMBER := 1.0;
821: l_api_name CONSTANT VARCHAR2(30) := 'create_offer_tiers';
822: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
823:
824: l_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
825: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
826: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
827: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
828: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

Line 825: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;

821: l_api_name CONSTANT VARCHAR2(30) := 'create_offer_tiers';
822: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
823:
824: l_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
825: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
826: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
827: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
828: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
829: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

Line 826: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

822: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
823:
824: l_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
825: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
826: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
827: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
828: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
829: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
830: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 827: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

823:
824: l_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
825: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
826: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
827: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
828: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
829: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
830: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
831: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 828: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

824: l_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
825: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
826: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
827: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
828: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
829: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
830: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
831: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
832: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

Line 829: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

825: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
826: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
827: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
828: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
829: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
830: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
831: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
832: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
833: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

Line 832: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

828: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
829: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
830: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
831: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
832: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
833: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
834:
835: CURSOR cur_get_adv_options(parent_list_line_id NUMBER) IS
836: SELECT proration_type_code ,

Line 833: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

829: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
830: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
831: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
832: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
833: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
834:
835: CURSOR cur_get_adv_options(parent_list_line_id NUMBER) IS
836: SELECT proration_type_code ,
837: product_precedence ,

Line 979: Qp_Modifiers_Pub.process_modifiers(

975: debug_message('Calling Pub Process in tiers');
976: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in create_offer_tiers---');
977: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT.create_offer_tiers before calling QP for list_header_id : '|| p_modifier_line_tbl(p_modifier_line_tbl.first).list_header_id);
978: END IF;
979: Qp_Modifiers_Pub.process_modifiers(
980: p_api_version_number => 1.0,
981: p_init_msg_list => p_init_msg_list,
982: p_return_values => Fnd_Api.G_FALSE,
983: x_return_status => x_return_status,

Line 1132: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;

1128: IS
1129: l_api_version CONSTANT NUMBER := 1.0;
1130: l_api_name CONSTANT VARCHAR2(30) := 'processRegExclusions';
1131: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1132: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
1133: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1134: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1135: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1136: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

Line 1133: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

1129: l_api_version CONSTANT NUMBER := 1.0;
1130: l_api_name CONSTANT VARCHAR2(30) := 'processRegExclusions';
1131: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1132: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
1133: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1134: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1135: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1136: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1137: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 1134: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

1130: l_api_name CONSTANT VARCHAR2(30) := 'processRegExclusions';
1131: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1132: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
1133: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1134: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1135: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1136: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1137: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1138: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 1135: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

1131: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1132: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
1133: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1134: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1135: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1136: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1137: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1138: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1139: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

Line 1136: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

1132: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
1133: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1134: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1135: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1136: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1137: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1138: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1139: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1140: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

Line 1139: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

1135: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1136: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1137: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1138: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1139: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1140: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1141:
1142: BEGIN
1143: SAVEPOINT process_exlusions;

Line 1140: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

1136: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1137: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1138: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1139: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1140: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1141:
1142: BEGIN
1143: SAVEPOINT process_exlusions;
1144:

Line 1186: Qp_Modifiers_Pub.process_modifiers(

1182: END LOOP;
1183: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT processRegExclusions before calling QP for list_header_id : '|| p_pricing_attr_tbl(p_pricing_attr_tbl.FIRST).list_line_id);
1184: END IF;
1185:
1186: Qp_Modifiers_Pub.process_modifiers(
1187: p_api_version_number => 1.0,
1188: p_init_msg_list => p_init_msg_list,
1189: p_return_values => Fnd_Api.G_FALSE,
1190: x_return_status => x_return_status,

Line 1416: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

1412: l_api_version CONSTANT NUMBER := 1.0;
1413: l_api_name CONSTANT VARCHAR2(30) := 'process_rltd_modifier_qual';
1414: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1415: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1416: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1417: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1418: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1419: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1420: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 1417: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

1413: l_api_name CONSTANT VARCHAR2(30) := 'process_rltd_modifier_qual';
1414: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1415: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1416: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1417: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1418: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1419: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1420: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1421: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 1418: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

1414: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1415: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1416: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1417: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1418: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1419: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1420: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1421: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1422: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

Line 1419: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

1415: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1416: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1417: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1418: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1419: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1420: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1421: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1422: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1423: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

Line 1422: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

1418: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1419: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1420: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1421: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1422: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1423: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1424: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;
1425:
1426: l_rltd_modifier_id NUMBER;

Line 1423: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

1419: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1420: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1421: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1422: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1423: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1424: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;
1425:
1426: l_rltd_modifier_id NUMBER;
1427: l_index NUMBER := 0;

Line 1486: Qp_Modifiers_Pub.process_modifiers(

1482:
1483: IF l_qualifiers_tbl.COUNT > 0 THEN
1484:
1485: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT.process_rltd_modifier_qual before calling QP for list_header_id : '|| l_qualifiers_tbl(l_qualifiers_tbl.first).list_header_id);
1486: Qp_Modifiers_Pub.process_modifiers(
1487: p_api_version_number => 1.0,
1488: p_init_msg_list => p_init_msg_list,
1489: p_return_values => Fnd_Api.G_FALSE,
1490: x_return_status => x_return_status,

Line 1559: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

1555: l_api_version CONSTANT NUMBER := 1.0;
1556: l_api_name CONSTANT VARCHAR2(30) := 'process_market_qualifiers';
1557: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1558: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1559: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1560: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1561: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1562: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1563: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 1560: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

1556: l_api_name CONSTANT VARCHAR2(30) := 'process_market_qualifiers';
1557: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1558: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1559: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1560: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1561: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1562: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1563: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1564: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 1561: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

1557: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1558: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1559: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1560: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1561: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1562: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1563: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1564: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1565: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

Line 1562: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

1558: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1559: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1560: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1561: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1562: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1563: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1564: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1565: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1566: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

Line 1565: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

1561: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1562: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1563: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1564: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1565: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1566: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1567: l_qualifier_deleted VARCHAR2(1) := 'N';
1568: l_qp_list_header_id NUMBER;
1569: l_offer_type VARCHAR2(30);

Line 1566: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

1562: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1563: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1564: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1565: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1566: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1567: l_qualifier_deleted VARCHAR2(1) := 'N';
1568: l_qp_list_header_id NUMBER;
1569: l_offer_type VARCHAR2(30);
1570:

Line 1647: Qp_Modifiers_Pub.process_modifiers(

1643: END LOOP;
1644: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_market_qualifiers before calling QP for list_header_id : '|| p_qualifiers_tbl(p_qualifiers_tbl.FIRST).list_header_id);
1645: END IF;
1646:
1647: Qp_Modifiers_Pub.process_modifiers(
1648: p_api_version_number => 1.0,
1649: p_init_msg_list => p_init_msg_list,
1650: p_return_values => Fnd_Api.G_FALSE,
1651: x_return_status => x_return_status,

Line 1767: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

1763: l_api_version CONSTANT NUMBER := 1.0;
1764: l_api_name CONSTANT VARCHAR2(30) := 'process_market_qualifiers';
1765: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1766: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1767: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1768: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1769: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1770: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1771: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 1768: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

1764: l_api_name CONSTANT VARCHAR2(30) := 'process_market_qualifiers';
1765: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1766: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1767: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1768: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1769: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1770: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1771: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1772: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 1769: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

1765: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1766: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1767: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1768: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1769: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1770: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1771: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1772: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1773: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

Line 1770: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

1766: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1767: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1768: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1769: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1770: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1771: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1772: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1773: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1774: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

Line 1773: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

1769: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1770: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1771: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1772: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1773: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1774: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1775: l_qualifier_deleted VARCHAR2(1) := 'N';
1776: l_qp_list_header_id NUMBER;
1777:

Line 1774: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

1770: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1771: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1772: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1773: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1774: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1775: l_qualifier_deleted VARCHAR2(1) := 'N';
1776: l_qp_list_header_id NUMBER;
1777:
1778: BEGIN

Line 1849: Qp_Modifiers_Pub.process_modifiers(

1845: END LOOP;
1846: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_market_qualifiers2 before calling QP for list_header_id : '||p_qualifiers_tbl(p_qualifiers_tbl.FIRST).list_header_id);
1847: END IF;
1848:
1849: Qp_Modifiers_Pub.process_modifiers(
1850: p_api_version_number => 1.0,
1851: p_init_msg_list => p_init_msg_list,
1852: p_return_values => Fnd_Api.G_FALSE,
1853: x_return_status => x_return_status,

Line 4443: l_modifier_list_rec Qp_Modifiers_Pub.modifier_list_rec_type;

4439: l_api_version CONSTANT NUMBER := 1.0;
4440: l_api_name CONSTANT VARCHAR2(30) := 'process_qp_list_header';
4441: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
4442:
4443: l_modifier_list_rec Qp_Modifiers_Pub.modifier_list_rec_type;
4444: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
4445:
4446: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
4447: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

Line 4444: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

4440: l_api_name CONSTANT VARCHAR2(30) := 'process_qp_list_header';
4441: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
4442:
4443: l_modifier_list_rec Qp_Modifiers_Pub.modifier_list_rec_type;
4444: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
4445:
4446: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
4447: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
4448: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

Line 4446: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

4442:
4443: l_modifier_list_rec Qp_Modifiers_Pub.modifier_list_rec_type;
4444: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
4445:
4446: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
4447: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
4448: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
4449: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4450: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 4447: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

4443: l_modifier_list_rec Qp_Modifiers_Pub.modifier_list_rec_type;
4444: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
4445:
4446: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
4447: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
4448: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
4449: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4450: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4451: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

Line 4448: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

4444: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
4445:
4446: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
4447: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
4448: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
4449: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4450: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4451: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
4452: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

Line 4451: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

4447: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
4448: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
4449: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4450: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4451: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
4452: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
4453:
4454: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4455: temp_limits_rec QP_Limits_PUB.Limits_Rec_Type;

Line 4452: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

4448: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
4449: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4450: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4451: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
4452: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
4453:
4454: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4455: temp_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4456: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;

Line 4701: Qp_Modifiers_Pub.process_modifiers(

4697: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_qp_list_header before calling QP for list_header_id : '||l_modifier_list_rec.list_header_id);
4698: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in process_qp_list_header org_id = '|| l_modifier_list_rec.org_id);
4699: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in process_qp_list_header global_flag = '|| l_modifier_list_rec.global_flag);
4700:
4701: Qp_Modifiers_Pub.process_modifiers(
4702: p_api_version_number => 1.0,
4703: p_init_msg_list => FND_API.G_FALSE,
4704: p_return_values => Fnd_Api.G_FALSE,
4705: x_return_status => x_return_status,

Line 5340: , x_modifiersTbl IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type

5336: x_return_status OUT NOCOPY VARCHAR2
5337: ,x_msg_count OUT NOCOPY NUMBER
5338: ,x_msg_data OUT NOCOPY VARCHAR2
5339: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5340: , x_modifiersTbl IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
5341: )
5342: IS
5343: l_index NUMBER;
5344: BEGIN

Line 5376: , x_modifiersTbl IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type

5372: x_return_status OUT NOCOPY VARCHAR2
5373: ,x_msg_count OUT NOCOPY NUMBER
5374: ,x_msg_data OUT NOCOPY VARCHAR2
5375: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5376: , x_modifiersTbl IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
5377: )
5378: IS
5379: l_index NUMBER;
5380: BEGIN

Line 5410: , x_modifiersTbl IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type

5406: x_return_status OUT NOCOPY VARCHAR2
5407: ,x_msg_count OUT NOCOPY NUMBER
5408: ,x_msg_data OUT NOCOPY VARCHAR2
5409: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5410: , x_modifiersTbl IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
5411: )
5412: IS
5413: l_index NUMBER;
5414: l_modifierLineRec MODIFIER_LINE_REC_TYPE;

Line 5453: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

5449: x_return_status OUT NOCOPY VARCHAR2
5450: ,x_msg_count OUT NOCOPY NUMBER
5451: ,x_msg_data OUT NOCOPY VARCHAR2
5452: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5453: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
5454: )
5455: IS
5456: l_index NUMBER;
5457: BEGIN

Line 5479: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

5475: x_return_status OUT NOCOPY VARCHAR2
5476: ,x_msg_count OUT NOCOPY NUMBER
5477: ,x_msg_data OUT NOCOPY VARCHAR2
5478: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5479: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
5480: )
5481: IS
5482: l_index NUMBER;
5483: BEGIN

Line 5506: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

5502: x_return_status OUT NOCOPY VARCHAR2
5503: ,x_msg_count OUT NOCOPY NUMBER
5504: ,x_msg_data OUT NOCOPY VARCHAR2
5505: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5506: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
5507: )
5508: IS
5509: CURSOR c_pricingAttr(cp_listLineId NUMBER) IS
5510: SELECT pricing_attribute_id FROM qp_pricing_attributes

Line 5543: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

5539: x_return_status OUT NOCOPY VARCHAR2
5540: ,x_msg_count OUT NOCOPY NUMBER
5541: ,x_msg_data OUT NOCOPY VARCHAR2
5542: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5543: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
5544: )
5545: IS
5546: l_index NUMBER;
5547: l_modifierLineRec MODIFIER_LINE_REC_TYPE;

Line 5598: , x_modifiersTbl IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type

5594: x_return_status OUT NOCOPY VARCHAR2
5595: ,x_msg_count OUT NOCOPY NUMBER
5596: ,x_msg_data OUT NOCOPY VARCHAR2
5597: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5598: , x_modifiersTbl IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
5599: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
5600: )
5601: IS
5602: BEGIN

Line 5599: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

5595: ,x_msg_count OUT NOCOPY NUMBER
5596: ,x_msg_data OUT NOCOPY VARCHAR2
5597: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5598: , x_modifiersTbl IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
5599: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
5600: )
5601: IS
5602: BEGIN
5603: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5647: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type

5643: x_return_status OUT NOCOPY VARCHAR2
5644: ,x_msg_count OUT NOCOPY NUMBER
5645: ,x_msg_data OUT NOCOPY VARCHAR2
5646: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5647: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
5648: )
5649: IS
5650: BEGIN
5651: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5688: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

5684: x_return_status OUT NOCOPY VARCHAR2
5685: ,x_msg_count OUT NOCOPY NUMBER
5686: ,x_msg_data OUT NOCOPY VARCHAR2
5687: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5688: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
5689: )
5690: IS
5691: BEGIN
5692: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5714: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type

5710: x_return_status OUT NOCOPY VARCHAR2
5711: ,x_msg_count OUT NOCOPY NUMBER
5712: ,x_msg_data OUT NOCOPY VARCHAR2
5713: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5714: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
5715: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
5716: )
5717: IS
5718: BEGIN

Line 5715: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

5711: ,x_msg_count OUT NOCOPY NUMBER
5712: ,x_msg_data OUT NOCOPY VARCHAR2
5713: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5714: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
5715: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
5716: )
5717: IS
5718: BEGIN
5719: -- initialize

Line 5761: ,x_modifiersTbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type

5757: ,x_msg_count OUT NOCOPY NUMBER
5758: ,x_msg_data OUT NOCOPY VARCHAR2
5759: ,p_offerType IN VARCHAR2
5760: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5761: ,x_modifiersTbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
5762: -- ,x_error_location OUT NOCOPY NUMBER
5763: )
5764: IS
5765: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;

Line 5765: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;

5761: ,x_modifiersTbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
5762: -- ,x_error_location OUT NOCOPY NUMBER
5763: )
5764: IS
5765: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
5766: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
5767: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
5768: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
5769: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

Line 5766: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;

5762: -- ,x_error_location OUT NOCOPY NUMBER
5763: )
5764: IS
5765: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
5766: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
5767: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
5768: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
5769: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5770: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

Line 5767: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

5763: )
5764: IS
5765: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
5766: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
5767: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
5768: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
5769: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5770: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
5771: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 5768: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

5764: IS
5765: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
5766: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
5767: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
5768: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
5769: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5770: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
5771: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5772: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 5769: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

5765: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
5766: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
5767: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
5768: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
5769: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5770: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
5771: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5772: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5773: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

Line 5770: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

5766: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
5767: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
5768: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
5769: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5770: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
5771: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5772: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5773: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
5774: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

Line 5773: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

5769: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5770: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
5771: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5772: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5773: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
5774: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
5775: l_control_rec qp_globals.control_rec_type;
5776: BEGIN
5777: -- initialize

Line 5774: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

5770: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
5771: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5772: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5773: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
5774: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
5775: l_control_rec qp_globals.control_rec_type;
5776: BEGIN
5777: -- initialize
5778: -- populate pbh data

Line 5815: QP_Modifiers_PUB.process_modifiers(

5811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5812: END IF;
5813: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF_OFFER_PVT.processPbhLine','QP Call in processPbhLine---');
5814: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT processPbhLine before calling QP for list_header_id : '||p_modifierLineRec.list_header_id);
5815: QP_Modifiers_PUB.process_modifiers(
5816: p_api_version_number => 1.0,
5817: p_init_msg_list => FND_API.G_FALSE,
5818: p_return_values => FND_API.G_FALSE,
5819: x_return_status => x_return_status,

Line 5854: ,x_modifiers_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type

5850: ,x_msg_count OUT NOCOPY NUMBER
5851: ,x_msg_data OUT NOCOPY VARCHAR2
5852: ,p_offer_type IN VARCHAR2
5853: ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
5854: ,x_modifiers_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
5855: ,x_error_location OUT NOCOPY NUMBER
5856: ) IS
5857:
5858: l_api_version CONSTANT NUMBER := 1.0;

Line 5862: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

5858: l_api_version CONSTANT NUMBER := 1.0;
5859: l_api_name CONSTANT VARCHAR2(30) := 'process_header_tiers';
5860: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
5861:
5862: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5863:
5864: BEGIN
5865: -- initialize
5866: -- loop thru lines

Line 6062: ,x_modifiers_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type

6058: ,x_msg_data OUT NOCOPY VARCHAR2
6059: ,p_parent_offer_type IN VARCHAR2
6060: ,p_offer_type IN VARCHAR2
6061: ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
6062: ,x_modifiers_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
6063: ,x_error_location OUT NOCOPY NUMBER
6064: ) IS
6065:
6066: l_api_version CONSTANT NUMBER := 1.0;

Line 6072: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;

6068: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
6069:
6070: tiers_modifier_line_tbl MODIFIER_LINE_TBL_TYPE;
6071:
6072: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
6073: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
6074: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6075: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
6076: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

Line 6073: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;

6069:
6070: tiers_modifier_line_tbl MODIFIER_LINE_TBL_TYPE;
6071:
6072: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
6073: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
6074: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6075: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
6076: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
6077: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

Line 6075: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

6071:
6072: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
6073: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
6074: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6075: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
6076: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
6077: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
6078: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
6079: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 6076: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

6072: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
6073: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
6074: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6075: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
6076: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
6077: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
6078: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
6079: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6080: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 6077: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

6073: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
6074: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6075: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
6076: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
6077: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
6078: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
6079: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6080: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
6081: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

Line 6078: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

6074: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6075: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
6076: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
6077: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
6078: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
6079: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6080: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
6081: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
6082: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

Line 6081: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

6077: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
6078: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
6079: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6080: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
6081: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
6082: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
6083: p_list_line_id NUMBER;
6084:
6085: i number := 0;

Line 6082: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

6078: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
6079: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6080: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
6081: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
6082: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
6083: p_list_line_id NUMBER;
6084:
6085: i number := 0;
6086: l_tier_count number := 0;

Line 6424: QP_Modifiers_PUB.process_modifiers(

6420: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_regular_discounts--- l_modifiers_tbl.count = '|| l_modifiers_tbl.count);
6421:
6422: IF l_modifiers_tbl.count > 0 THEN -- bug 3711957. when processing PBH, l_modifiers_tbl is empty
6423: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_regular_discounts before calling for QP list_header_id : '|| l_modifiers_tbl(l_modifiers_tbl.FIRST).list_header_id);
6424: QP_Modifiers_PUB.process_modifiers(
6425: p_api_version_number => 1.0,
6426: p_init_msg_list => FND_API.G_FALSE,
6427: p_return_values => FND_API.G_FALSE,
6428: x_return_status => x_return_status,

Line 6975: , x_modifiers_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

6971: x_return_status OUT NOCOPY VARCHAR2
6972: ,x_msg_count OUT NOCOPY NUMBER
6973: ,x_msg_data OUT NOCOPY VARCHAR2
6974: ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
6975: , x_modifiers_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
6976: ,x_error_location OUT NOCOPY NUMBER
6977: ) IS
6978:
6979: l_api_version CONSTANT NUMBER := 1.0;

Line 6983: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;

6979: l_api_version CONSTANT NUMBER := 1.0;
6980: l_api_name CONSTANT VARCHAR2(30) := 'process_order_value';
6981: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
6982:
6983: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
6984: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6985: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
6986: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
6987: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

Line 6985: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

6981: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
6982:
6983: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
6984: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6985: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
6986: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
6987: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
6988: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
6989: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 6986: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

6982:
6983: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
6984: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6985: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
6986: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
6987: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
6988: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
6989: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6990: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 6987: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

6983: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
6984: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6985: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
6986: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
6987: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
6988: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
6989: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6990: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
6991: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

Line 6988: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

6984: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6985: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
6986: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
6987: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
6988: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
6989: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6990: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
6991: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
6992: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

Line 6991: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

6987: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
6988: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
6989: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6990: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
6991: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
6992: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
6993:
6994: p_list_line_id NUMBER;
6995: CURSOR cur_get_discount_level(p_list_header_id NUMBER) IS

Line 6992: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

6988: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
6989: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6990: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
6991: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
6992: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
6993:
6994: p_list_line_id NUMBER;
6995: CURSOR cur_get_discount_level(p_list_header_id NUMBER) IS
6996: SELECT modifier_level_code

Line 7190: QP_Modifiers_PUB.process_modifiers(

7186: -- end change on 15-Apr-2003
7187: debug_message('ENdDateActive is :'||l_modifiers_tbl(i).end_date_active);
7188: END LOOP;
7189:
7190: QP_Modifiers_PUB.process_modifiers(
7191: p_api_version_number => 1.0,
7192: p_init_msg_list => FND_API.G_FALSE,
7193: p_return_values => FND_API.G_FALSE,
7194: x_return_status => x_return_status,

Line 7256: QP_Modifiers_PUB.process_modifiers(

7252:
7253: END LOOP;
7254:
7255: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_order_value 2---p_modifier_line_tbl.count = '|| p_modifier_line_tbl.count);
7256: QP_Modifiers_PUB.process_modifiers(
7257: p_api_version_number => 1.0,
7258: p_init_msg_list => FND_API.G_FALSE,
7259: p_return_values => FND_API.G_FALSE,
7260: x_return_status => x_return_status,

Line 7549: ,x_modifiers_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

7545: x_return_status OUT NOCOPY VARCHAR2
7546: ,x_msg_count OUT NOCOPY NUMBER
7547: ,x_msg_data OUT NOCOPY VARCHAR2
7548: ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
7549: ,x_modifiers_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
7550: ,x_error_location OUT NOCOPY NUMBER
7551: ) IS
7552:
7553: l_api_version CONSTANT NUMBER := 1.0;

Line 7559: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;

7555: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
7556:
7557: tiers_modifier_line_tbl MODIFIER_LINE_TBL_TYPE;
7558: p_list_line_id NUMBER;
7559: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
7560: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
7561: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
7562: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
7563: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

Line 7560: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;

7556:
7557: tiers_modifier_line_tbl MODIFIER_LINE_TBL_TYPE;
7558: p_list_line_id NUMBER;
7559: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
7560: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
7561: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
7562: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
7563: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
7564: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

Line 7561: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

7557: tiers_modifier_line_tbl MODIFIER_LINE_TBL_TYPE;
7558: p_list_line_id NUMBER;
7559: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
7560: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
7561: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
7562: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
7563: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
7564: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
7565: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 7562: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

7558: p_list_line_id NUMBER;
7559: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
7560: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
7561: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
7562: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
7563: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
7564: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
7565: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
7566: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 7563: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

7559: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
7560: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
7561: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
7562: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
7563: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
7564: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
7565: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
7566: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
7567: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

Line 7564: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

7560: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
7561: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
7562: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
7563: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
7564: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
7565: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
7566: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
7567: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
7568: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

Line 7567: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

7563: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
7564: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
7565: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
7566: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
7567: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
7568: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
7569: l_control_rec qp_globals.control_rec_type;
7570:
7571: l_modifier_parent_index NUMBER := 0;

Line 7568: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

7564: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
7565: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
7566: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
7567: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
7568: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
7569: l_control_rec qp_globals.control_rec_type;
7570:
7571: l_modifier_parent_index NUMBER := 0;
7572: l_list_header_id NUMBER;

Line 8025: , x_modifiers_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

8021: ,x_msg_count OUT NOCOPY NUMBER
8022: ,x_msg_data OUT NOCOPY VARCHAR2
8023: ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
8024: ,p_list_header_id IN NUMBER
8025: , x_modifiers_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
8026: ,x_error_location OUT NOCOPY NUMBER
8027: ) IS
8028:
8029: l_api_version CONSTANT NUMBER := 1.0;

Line 8034: v_off_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

8030: l_api_name CONSTANT VARCHAR2(30) := 'process_trade_deal';
8031: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
8032:
8033: l_modifier_line_tbl MODIFIER_LINE_TBL_TYPE := p_modifier_line_tbl;
8034: v_off_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
8035: v_accr_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
8036: temp_modifier_line_tbl MODIFIER_LINE_TBL_TYPE := p_modifier_line_tbl;
8037:
8038: l_modifier_line_all_off_tbl MODIFIER_LINE_TBL_TYPE; -- line has both off_invoice and accrual values, off_invoice

Line 8035: v_accr_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

8031: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
8032:
8033: l_modifier_line_tbl MODIFIER_LINE_TBL_TYPE := p_modifier_line_tbl;
8034: v_off_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
8035: v_accr_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
8036: temp_modifier_line_tbl MODIFIER_LINE_TBL_TYPE := p_modifier_line_tbl;
8037:
8038: l_modifier_line_all_off_tbl MODIFIER_LINE_TBL_TYPE; -- line has both off_invoice and accrual values, off_invoice
8039: l_modifier_line_all_acc_tbl MODIFIER_LINE_TBL_TYPE; -- line has both off_invoice and accrual values, accural

Line 8042: v_modifier_all_off_tbl qp_modifiers_pub.modifiers_tbl_type;

8038: l_modifier_line_all_off_tbl MODIFIER_LINE_TBL_TYPE; -- line has both off_invoice and accrual values, off_invoice
8039: l_modifier_line_all_acc_tbl MODIFIER_LINE_TBL_TYPE; -- line has both off_invoice and accrual values, accural
8040: l_modifier_line_off_tbl MODIFIER_LINE_TBL_TYPE; -- line has only off_invoice value
8041: l_modifier_line_acc_tbl MODIFIER_LINE_TBL_TYPE; -- line has only accrual value
8042: v_modifier_all_off_tbl qp_modifiers_pub.modifiers_tbl_type;
8043: v_modifier_all_acc_tbl qp_modifiers_pub.modifiers_tbl_type;
8044: v_modifier_off_tbl qp_modifiers_pub.modifiers_tbl_type;
8045: v_modifier_acc_tbl qp_modifiers_pub.modifiers_tbl_type;
8046: v_modifier_ret_tbl qp_modifiers_pub.modifiers_tbl_type;

Line 8043: v_modifier_all_acc_tbl qp_modifiers_pub.modifiers_tbl_type;

8039: l_modifier_line_all_acc_tbl MODIFIER_LINE_TBL_TYPE; -- line has both off_invoice and accrual values, accural
8040: l_modifier_line_off_tbl MODIFIER_LINE_TBL_TYPE; -- line has only off_invoice value
8041: l_modifier_line_acc_tbl MODIFIER_LINE_TBL_TYPE; -- line has only accrual value
8042: v_modifier_all_off_tbl qp_modifiers_pub.modifiers_tbl_type;
8043: v_modifier_all_acc_tbl qp_modifiers_pub.modifiers_tbl_type;
8044: v_modifier_off_tbl qp_modifiers_pub.modifiers_tbl_type;
8045: v_modifier_acc_tbl qp_modifiers_pub.modifiers_tbl_type;
8046: v_modifier_ret_tbl qp_modifiers_pub.modifiers_tbl_type;
8047: l_related_lines_rec ozf_related_lines_pvt.related_lines_rec_type;

Line 8044: v_modifier_off_tbl qp_modifiers_pub.modifiers_tbl_type;

8040: l_modifier_line_off_tbl MODIFIER_LINE_TBL_TYPE; -- line has only off_invoice value
8041: l_modifier_line_acc_tbl MODIFIER_LINE_TBL_TYPE; -- line has only accrual value
8042: v_modifier_all_off_tbl qp_modifiers_pub.modifiers_tbl_type;
8043: v_modifier_all_acc_tbl qp_modifiers_pub.modifiers_tbl_type;
8044: v_modifier_off_tbl qp_modifiers_pub.modifiers_tbl_type;
8045: v_modifier_acc_tbl qp_modifiers_pub.modifiers_tbl_type;
8046: v_modifier_ret_tbl qp_modifiers_pub.modifiers_tbl_type;
8047: l_related_lines_rec ozf_related_lines_pvt.related_lines_rec_type;
8048: l_related_deal_lines_id NUMBER;

Line 8045: v_modifier_acc_tbl qp_modifiers_pub.modifiers_tbl_type;

8041: l_modifier_line_acc_tbl MODIFIER_LINE_TBL_TYPE; -- line has only accrual value
8042: v_modifier_all_off_tbl qp_modifiers_pub.modifiers_tbl_type;
8043: v_modifier_all_acc_tbl qp_modifiers_pub.modifiers_tbl_type;
8044: v_modifier_off_tbl qp_modifiers_pub.modifiers_tbl_type;
8045: v_modifier_acc_tbl qp_modifiers_pub.modifiers_tbl_type;
8046: v_modifier_ret_tbl qp_modifiers_pub.modifiers_tbl_type;
8047: l_related_lines_rec ozf_related_lines_pvt.related_lines_rec_type;
8048: l_related_deal_lines_id NUMBER;
8049: l_all_index NUMBER := 0;

Line 8046: v_modifier_ret_tbl qp_modifiers_pub.modifiers_tbl_type;

8042: v_modifier_all_off_tbl qp_modifiers_pub.modifiers_tbl_type;
8043: v_modifier_all_acc_tbl qp_modifiers_pub.modifiers_tbl_type;
8044: v_modifier_off_tbl qp_modifiers_pub.modifiers_tbl_type;
8045: v_modifier_acc_tbl qp_modifiers_pub.modifiers_tbl_type;
8046: v_modifier_ret_tbl qp_modifiers_pub.modifiers_tbl_type;
8047: l_related_lines_rec ozf_related_lines_pvt.related_lines_rec_type;
8048: l_related_deal_lines_id NUMBER;
8049: l_all_index NUMBER := 0;
8050: l_off_index NUMBER := 0;

Line 8719: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

8715: ,x_msg_data OUT NOCOPY VARCHAR2
8716: ,p_offer_type IN VARCHAR2
8717: ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
8718: ,p_list_header_id IN NUMBER
8719: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
8720: ,x_error_location OUT NOCOPY NUMBER
8721: )IS
8722: l_api_version CONSTANT NUMBER := 1.0;
8723: l_api_name CONSTANT VARCHAR2(30) := 'process_qp_list_lines';

Line 8725: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;

8721: )IS
8722: l_api_version CONSTANT NUMBER := 1.0;
8723: l_api_name CONSTANT VARCHAR2(30) := 'process_qp_list_lines';
8724: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
8725: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
8726: -- RSSHARMA changed on 06-Feb-2003
8727: CURSOR c_volume_offer_type IS
8728: SELECT volume_offer_type FROM ozf_offers
8729: where qp_list_header_id = p_list_header_id;

Line 9217: v_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type; --

9213: temp_modifier_list_rec modifier_list_rec_type := p_modifier_list_rec;
9214: date_temp_modifier_list_rec modifier_list_rec_type := p_modifier_list_rec;
9215: l_modifier_list_rec modifier_list_rec_type := p_modifier_list_rec;
9216: l_offer_id NUMBER;
9217: v_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type; --
9218: l_modifier_line_tbl MODIFIER_LINE_TBL_TYPE := p_modifier_line_tbl;
9219:
9220: l_api_version CONSTANT NUMBER := 1.0;
9221: l_api_name CONSTANT VARCHAR2(30) := 'process_modifiers';

Line 10294: , x_pricingAttrRec OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Rec_type

10290: ,x_msg_count OUT NOCOPY NUMBER
10291: ,x_msg_data OUT NOCOPY VARCHAR2
10292: , p_qp_list_header_id IN NUMBER
10293: , p_offDiscountProductId IN NUMBER
10294: , x_pricingAttrRec OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Rec_type
10295: )
10296: IS
10297: CURSOR c_products(cp_offDiscountProductId NUMBER)IS
10298: SELECT a.offer_discount_line_id

Line 10371: ,x_modifiersRec OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type

10367: (
10368: x_return_status OUT NOCOPY VARCHAR2
10369: ,x_msg_count OUT NOCOPY NUMBER
10370: ,x_msg_data OUT NOCOPY VARCHAR2
10371: ,x_modifiersRec OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type
10372: ,p_offDiscountProductId IN NUMBER
10373: , p_qpListHeaderId IN NUMBER
10374: )
10375: IS

Line 10403: ,x_modifiersRec OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type

10399: (
10400: x_return_status OUT NOCOPY VARCHAR2
10401: ,x_msg_count OUT NOCOPY NUMBER
10402: ,x_msg_data OUT NOCOPY VARCHAR2
10403: ,x_modifiersRec OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type
10404: , p_qpListHeaderId IN NUMBER
10405: , p_offDiscountProductId IN NUMBER
10406: )
10407: IS

Line 10446: ,x_modifiersRec OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type

10442: (
10443: x_return_status OUT NOCOPY VARCHAR2
10444: ,x_msg_count OUT NOCOPY NUMBER
10445: ,x_msg_data OUT NOCOPY VARCHAR2
10446: ,x_modifiersRec OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type
10447: ,p_offerDiscountLineId IN NUMBER
10448: , p_qpListHeaderId IN NUMBER
10449: , p_offDiscountProductId IN NUMBER
10450: )

Line 10520: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type

10516: (
10517: x_return_status OUT NOCOPY VARCHAR2
10518: ,x_msg_count OUT NOCOPY NUMBER
10519: ,x_msg_data OUT NOCOPY VARCHAR2
10520: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
10521: , p_offDiscountProductId IN NUMBER
10522: , p_qpListHeaderId IN NUMBER
10523: )
10524: IS

Line 10574: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type

10570: ,x_msg_count OUT NOCOPY NUMBER
10571: ,x_msg_data OUT NOCOPY VARCHAR2
10572: , p_qp_list_header_id IN NUMBER
10573: , p_offDiscountProductId IN NUMBER
10574: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
10575: )
10576: IS
10577: l_modifiersRec Qp_Modifiers_Pub.modifiers_rec_type;
10578: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;

Line 10577: l_modifiersRec Qp_Modifiers_Pub.modifiers_rec_type;

10573: , p_offDiscountProductId IN NUMBER
10574: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
10575: )
10576: IS
10577: l_modifiersRec Qp_Modifiers_Pub.modifiers_rec_type;
10578: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
10579: v_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
10580: i NUMBER;
10581: BEGIN

Line 10578: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;

10574: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
10575: )
10576: IS
10577: l_modifiersRec Qp_Modifiers_Pub.modifiers_rec_type;
10578: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
10579: v_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
10580: i NUMBER;
10581: BEGIN
10582: -- initialize

Line 10579: v_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;

10575: )
10576: IS
10577: l_modifiersRec Qp_Modifiers_Pub.modifiers_rec_type;
10578: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
10579: v_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
10580: i NUMBER;
10581: BEGIN
10582: -- initialize
10583: -- populate PBH data

Line 10632: ,x_pricingAttrRec IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Rec_type

10628: (
10629: x_return_status OUT NOCOPY VARCHAR2
10630: ,x_msg_count OUT NOCOPY NUMBER
10631: ,x_msg_data OUT NOCOPY VARCHAR2
10632: ,x_pricingAttrRec IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Rec_type
10633: ,p_offerDiscountLineId IN NUMBER
10634: ,p_offDiscountProductId IN NUMBER
10635: )
10636: IS

Line 10659: , x_modifiersTbl IN Qp_Modifiers_Pub.modifiers_tbl_type

10655: (
10656: x_return_status OUT NOCOPY VARCHAR2
10657: ,x_msg_count OUT NOCOPY NUMBER
10658: ,x_msg_data OUT NOCOPY VARCHAR2
10659: , x_modifiersTbl IN Qp_Modifiers_Pub.modifiers_tbl_type
10660: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
10661: , x_pricingAttrRec IN Qp_Modifiers_Pub.pricing_attr_Rec_type
10662: , p_offDiscountProductId IN NUMBER
10663: )

Line 10660: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

10656: x_return_status OUT NOCOPY VARCHAR2
10657: ,x_msg_count OUT NOCOPY NUMBER
10658: ,x_msg_data OUT NOCOPY VARCHAR2
10659: , x_modifiersTbl IN Qp_Modifiers_Pub.modifiers_tbl_type
10660: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
10661: , x_pricingAttrRec IN Qp_Modifiers_Pub.pricing_attr_Rec_type
10662: , p_offDiscountProductId IN NUMBER
10663: )
10664: IS

Line 10661: , x_pricingAttrRec IN Qp_Modifiers_Pub.pricing_attr_Rec_type

10657: ,x_msg_count OUT NOCOPY NUMBER
10658: ,x_msg_data OUT NOCOPY VARCHAR2
10659: , x_modifiersTbl IN Qp_Modifiers_Pub.modifiers_tbl_type
10660: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
10661: , x_pricingAttrRec IN Qp_Modifiers_Pub.pricing_attr_Rec_type
10662: , p_offDiscountProductId IN NUMBER
10663: )
10664: IS
10665: BEGIN

Line 10703: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

10699: x_return_status OUT NOCOPY VARCHAR2
10700: ,x_msg_count OUT NOCOPY NUMBER
10701: ,x_msg_data OUT NOCOPY VARCHAR2
10702: , p_qpListHeaderId IN NUMBER
10703: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
10704: )
10705: IS
10706: CURSOR c_exclusions(cp_qpListHeaderId IN NUMBER) IS
10707: SELECT a.product_attribute, a.product_attr_value, a.excluder_flag

Line 10733: ,p_modifiersTbl IN qp_modifiers_pub.modifiers_tbl_type

10729: (
10730: x_return_status OUT NOCOPY VARCHAR2
10731: ,x_msg_count OUT NOCOPY NUMBER
10732: ,x_msg_data OUT NOCOPY VARCHAR2
10733: ,p_modifiersTbl IN qp_modifiers_pub.modifiers_tbl_type
10734: )
10735: IS
10736: l_discRec OZF_QP_DISCOUNTS_PVT.qp_discount_rec_type;
10737: l_qpDiscountId NUMBER;

Line 10772: ,p_pricingAttrTbl IN qp_modifiers_pub.pricing_attr_tbl_type

10768: (
10769: x_return_status OUT NOCOPY VARCHAR2
10770: ,x_msg_count OUT NOCOPY NUMBER
10771: ,x_msg_data OUT NOCOPY VARCHAR2
10772: ,p_pricingAttrTbl IN qp_modifiers_pub.pricing_attr_tbl_type
10773: ,p_offDiscountProductId IN NUMBER
10774: )
10775: IS
10776: l_prodRec OZF_QP_PRODUCTS_PVT.qp_product_rec_type;

Line 10812: ,p_modifiersTbl IN qp_modifiers_pub.modifiers_tbl_type

10808: (
10809: x_return_status OUT NOCOPY VARCHAR2
10810: ,x_msg_count OUT NOCOPY NUMBER
10811: ,x_msg_data OUT NOCOPY VARCHAR2
10812: ,p_modifiersTbl IN qp_modifiers_pub.modifiers_tbl_type
10813: ,p_pricingAttrTbl IN qp_modifiers_pub.pricing_attr_tbl_type
10814: ,p_offDiscountProductId IN NUMBER
10815: )
10816: IS

Line 10813: ,p_pricingAttrTbl IN qp_modifiers_pub.pricing_attr_tbl_type

10809: x_return_status OUT NOCOPY VARCHAR2
10810: ,x_msg_count OUT NOCOPY NUMBER
10811: ,x_msg_data OUT NOCOPY VARCHAR2
10812: ,p_modifiersTbl IN qp_modifiers_pub.modifiers_tbl_type
10813: ,p_pricingAttrTbl IN qp_modifiers_pub.pricing_attr_tbl_type
10814: ,p_offDiscountProductId IN NUMBER
10815: )
10816: IS
10817: BEGIN

Line 10853: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type

10849: ,x_msg_data OUT NOCOPY VARCHAR2
10850: , p_qp_list_header_id IN NUMBER
10851: , p_offDiscountProductId IN NUMBER
10852: , x_error_location OUT NOCOPY NUMBER
10853: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
10854: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
10855: )
10856: IS
10857: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;

Line 10854: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

10850: , p_qp_list_header_id IN NUMBER
10851: , p_offDiscountProductId IN NUMBER
10852: , x_error_location OUT NOCOPY NUMBER
10853: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
10854: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
10855: )
10856: IS
10857: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
10858: l_pricingAttrRec Qp_Modifiers_Pub.pricing_attr_Rec_type;

Line 10857: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;

10853: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
10854: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
10855: )
10856: IS
10857: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
10858: l_pricingAttrRec Qp_Modifiers_Pub.pricing_attr_Rec_type;
10859: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
10860:
10861: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

Line 10858: l_pricingAttrRec Qp_Modifiers_Pub.pricing_attr_Rec_type;

10854: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
10855: )
10856: IS
10857: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
10858: l_pricingAttrRec Qp_Modifiers_Pub.pricing_attr_Rec_type;
10859: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
10860:
10861: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
10862: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

Line 10859: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;

10855: )
10856: IS
10857: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
10858: l_pricingAttrRec Qp_Modifiers_Pub.pricing_attr_Rec_type;
10859: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
10860:
10861: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
10862: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
10863: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

Line 10861: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

10857: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
10858: l_pricingAttrRec Qp_Modifiers_Pub.pricing_attr_Rec_type;
10859: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
10860:
10861: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
10862: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
10863: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
10864: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
10865: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 10862: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

10858: l_pricingAttrRec Qp_Modifiers_Pub.pricing_attr_Rec_type;
10859: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
10860:
10861: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
10862: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
10863: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
10864: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
10865: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
10866: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 10863: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

10859: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
10860:
10861: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
10862: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
10863: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
10864: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
10865: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
10866: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
10867: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

Line 10864: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

10860:
10861: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
10862: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
10863: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
10864: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
10865: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
10866: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
10867: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
10868: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

Line 10867: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

10863: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
10864: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
10865: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
10866: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
10867: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
10868: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
10869: l_control_rec qp_globals.control_rec_type;
10870: BEGIN
10871: -- initialize

Line 10868: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

10864: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
10865: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
10866: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
10867: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
10868: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
10869: l_control_rec qp_globals.control_rec_type;
10870: BEGIN
10871: -- initialize
10872: -- for the product populate pricing attribute

Line 10938: QP_Modifiers_PUB.process_modifiers(

10934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10935: END IF;
10936: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF_OFFER_PVT.pushDiscountRuleToQp','QP Call in pushDiscountRuleToQp---');
10937: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT pushDiscountRuleToQp before calling QP for list_header_id : '||p_qp_list_header_id);
10938: QP_Modifiers_PUB.process_modifiers(
10939: p_api_version_number => 1.0,
10940: p_init_msg_list => FND_API.G_FALSE,
10941: p_return_values => FND_API.G_FALSE,
10942: x_return_status => x_return_status,

Line 10971: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type

10967: ,x_msg_data OUT NOCOPY VARCHAR2
10968: , p_qp_list_header_id IN NUMBER
10969: , p_offDiscountProductId IN NUMBER
10970: , x_error_location OUT NOCOPY NUMBER
10971: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
10972: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
10973: )
10974: IS
10975: BEGIN

Line 10972: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

10968: , p_qp_list_header_id IN NUMBER
10969: , p_offDiscountProductId IN NUMBER
10970: , x_error_location OUT NOCOPY NUMBER
10971: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
10972: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
10973: )
10974: IS
10975: BEGIN
10976: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 11040: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;

11036: WHERE a.offer_id = b.offer_id
11037: AND a.excluder_flag = 'N'
11038: AND b.qp_list_header_id = cp_qpListHeaderId;
11039:
11040: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
11041: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
11042: l_errorLocation NUMBER;
11043: BEGIN
11044: -- initialize

Line 11041: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;

11037: AND a.excluder_flag = 'N'
11038: AND b.qp_list_header_id = cp_qpListHeaderId;
11039:
11040: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
11041: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
11042: l_errorLocation NUMBER;
11043: BEGIN
11044: -- initialize
11045: SAVEPOINT push_disc_rules;