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 544: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;

540: AND b.site_use_code = p_site_use_code
541: AND b.site_use_id = p_site_use_id;
542: -- end comment
543:
544: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
545:
546: l_api_version CONSTANT NUMBER := 1.0;
547: l_api_name CONSTANT VARCHAR2(30) := 'process_adv_options';
548: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;

Line 553: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

549: l_object_version_number NUMBER;
550:
551: i NUMBER := 1;
552:
553: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
554: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
555: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
556: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
557: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 554: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

550:
551: i NUMBER := 1;
552:
553: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
554: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
555: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
556: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
557: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
558: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 555: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

551: i NUMBER := 1;
552:
553: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
554: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
555: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
556: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
557: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
558: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
559: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

Line 556: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

552:
553: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
554: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
555: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
556: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
557: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
558: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
559: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
560: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

Line 559: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

555: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
556: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
557: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
558: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
559: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
560: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
561: l_promotional_offers_rec ozf_promotional_offers_pvt.offers_rec_type;
562:
563: BEGIN

Line 560: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

556: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
557: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
558: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
559: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
560: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
561: l_promotional_offers_rec ozf_promotional_offers_pvt.offers_rec_type;
562:
563: BEGIN
564:

Line 599: Qp_Modifiers_Pub.process_modifiers(

595: l_modifiers_tbl(i).operation := Qp_Globals.G_OPR_UPDATE;
596: i:= i+1;
597: END LOOP;
598:
599: Qp_Modifiers_Pub.process_modifiers(
600: p_api_version_number => 1.0,
601: p_init_msg_list => p_init_msg_list,
602: p_return_values => Fnd_Api.G_FALSE,
603: x_return_status => x_return_status,

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

718: ,x_msg_count OUT NOCOPY NUMBER
719: ,x_msg_data OUT NOCOPY VARCHAR2
720: ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
721: ,x_error_location OUT NOCOPY NUMBER
722: -- ,x_modifiers_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
723: -- ,x_pricing_attr_tbl OUT NOCOPY qp_modifiers_pub.pricing_attr_tbl_type
724: )
725: IS
726: l_api_version CONSTANT NUMBER := 1.0;

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

719: ,x_msg_data OUT NOCOPY VARCHAR2
720: ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
721: ,x_error_location OUT NOCOPY NUMBER
722: -- ,x_modifiers_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
723: -- ,x_pricing_attr_tbl OUT NOCOPY qp_modifiers_pub.pricing_attr_tbl_type
724: )
725: IS
726: l_api_version CONSTANT NUMBER := 1.0;
727: l_api_name CONSTANT VARCHAR2(30) := 'create_offer_tiers';

Line 730: l_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

726: l_api_version CONSTANT NUMBER := 1.0;
727: l_api_name CONSTANT VARCHAR2(30) := 'create_offer_tiers';
728: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
729:
730: l_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
731: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
732: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
733: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
734: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

Line 731: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;

727: l_api_name CONSTANT VARCHAR2(30) := 'create_offer_tiers';
728: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
729:
730: l_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
731: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
732: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
733: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
734: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
735: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

Line 732: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

728: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
729:
730: l_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
731: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
732: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
733: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
734: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
735: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
736: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 733: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

729:
730: l_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
731: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
732: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
733: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
734: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
735: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
736: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
737: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 734: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

730: l_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
731: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
732: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
733: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
734: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
735: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
736: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
737: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
738: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

Line 735: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

731: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
732: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
733: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
734: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
735: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
736: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
737: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
738: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
739: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

Line 738: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

734: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
735: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
736: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
737: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
738: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
739: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
740:
741: CURSOR cur_get_adv_options(parent_list_line_id NUMBER) IS
742: SELECT proration_type_code ,

Line 739: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

735: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
736: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
737: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
738: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
739: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
740:
741: CURSOR cur_get_adv_options(parent_list_line_id NUMBER) IS
742: SELECT proration_type_code ,
743: product_precedence ,

Line 882: Qp_Modifiers_Pub.process_modifiers(

878: END IF;
879:
880: END IF;
881: debug_message('Calling Pub Process in tiers');
882: Qp_Modifiers_Pub.process_modifiers(
883: p_api_version_number => 1.0,
884: p_init_msg_list => p_init_msg_list,
885: p_return_values => Fnd_Api.G_FALSE,
886: x_return_status => x_return_status,

Line 1035: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;

1031: IS
1032: l_api_version CONSTANT NUMBER := 1.0;
1033: l_api_name CONSTANT VARCHAR2(30) := 'processRegExclusions';
1034: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1035: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
1036: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1037: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1038: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1039: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

Line 1036: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

1032: l_api_version CONSTANT NUMBER := 1.0;
1033: l_api_name CONSTANT VARCHAR2(30) := 'processRegExclusions';
1034: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1035: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
1036: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1037: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1038: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1039: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1040: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 1037: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

1033: l_api_name CONSTANT VARCHAR2(30) := 'processRegExclusions';
1034: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1035: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
1036: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1037: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1038: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1039: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1040: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1041: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 1038: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

1034: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1035: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
1036: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1037: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1038: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1039: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1040: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1041: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1042: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

Line 1039: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

1035: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
1036: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1037: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1038: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1039: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1040: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1041: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1042: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1043: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

Line 1042: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

1038: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1039: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1040: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1041: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1042: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1043: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1044:
1045: BEGIN
1046: SAVEPOINT process_exlusions;

Line 1043: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

1039: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1040: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1041: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1042: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1043: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1044:
1045: BEGIN
1046: SAVEPOINT process_exlusions;
1047:

Line 1085: Qp_Modifiers_Pub.process_modifiers(

1081: END IF;
1082: END LOOP;
1083: END IF;
1084:
1085: Qp_Modifiers_Pub.process_modifiers(
1086: p_api_version_number => 1.0,
1087: p_init_msg_list => p_init_msg_list,
1088: p_return_values => Fnd_Api.G_FALSE,
1089: x_return_status => x_return_status,

Line 1315: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

1311: l_api_version CONSTANT NUMBER := 1.0;
1312: l_api_name CONSTANT VARCHAR2(30) := 'process_rltd_modifier_qual';
1313: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1314: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1315: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1316: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1317: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1318: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1319: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 1316: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

1312: l_api_name CONSTANT VARCHAR2(30) := 'process_rltd_modifier_qual';
1313: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1314: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1315: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1316: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1317: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1318: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1319: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1320: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 1317: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

1313: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1314: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1315: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1316: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1317: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1318: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1319: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1320: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1321: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

Line 1318: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

1314: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1315: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1316: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1317: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1318: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1319: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1320: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1321: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1322: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

Line 1321: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

1317: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1318: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1319: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1320: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1321: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1322: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1323: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;
1324:
1325: l_rltd_modifier_id NUMBER;

Line 1322: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

1318: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1319: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1320: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1321: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1322: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1323: l_qualifiers_tbl_out qp_qualifier_rules_pub.qualifiers_tbl_type;
1324:
1325: l_rltd_modifier_id NUMBER;
1326: l_index NUMBER := 0;

Line 1380: Qp_Modifiers_Pub.process_modifiers(

1376: END IF;
1377: END LOOP;
1378: debug_message('jl qualifier tbl count: ' || l_qualifiers_tbl.count);
1379: --raise Fnd_Api.g_exc_error;
1380: Qp_Modifiers_Pub.process_modifiers(
1381: p_api_version_number => 1.0,
1382: p_init_msg_list => p_init_msg_list,
1383: p_return_values => Fnd_Api.G_FALSE,
1384: x_return_status => x_return_status,

Line 1453: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

1449: l_api_version CONSTANT NUMBER := 1.0;
1450: l_api_name CONSTANT VARCHAR2(30) := 'process_market_qualifiers';
1451: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1452: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1453: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1454: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1455: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1456: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1457: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 1454: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

1450: l_api_name CONSTANT VARCHAR2(30) := 'process_market_qualifiers';
1451: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1452: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1453: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1454: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1455: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1456: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1457: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1458: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 1455: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

1451: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1452: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1453: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1454: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1455: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1456: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1457: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1458: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1459: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

Line 1456: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

1452: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1453: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1454: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1455: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1456: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1457: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1458: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1459: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1460: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

Line 1459: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

1455: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1456: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1457: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1458: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1459: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1460: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1461: l_qualifier_deleted VARCHAR2(1) := 'N';
1462: l_qp_list_header_id NUMBER;
1463: l_offer_type VARCHAR2(30);

Line 1460: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

1456: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1457: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1458: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1459: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1460: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1461: l_qualifier_deleted VARCHAR2(1) := 'N';
1462: l_qp_list_header_id NUMBER;
1463: l_offer_type VARCHAR2(30);
1464:

Line 1539: Qp_Modifiers_Pub.process_modifiers(

1535: END IF;
1536: END LOOP;
1537: END IF;
1538:
1539: Qp_Modifiers_Pub.process_modifiers(
1540: p_api_version_number => 1.0,
1541: p_init_msg_list => p_init_msg_list,
1542: p_return_values => Fnd_Api.G_FALSE,
1543: x_return_status => x_return_status,

Line 1659: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

1655: l_api_version CONSTANT NUMBER := 1.0;
1656: l_api_name CONSTANT VARCHAR2(30) := 'process_market_qualifiers';
1657: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1658: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1659: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1660: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1661: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1662: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1663: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 1660: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

1656: l_api_name CONSTANT VARCHAR2(30) := 'process_market_qualifiers';
1657: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1658: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1659: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1660: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1661: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1662: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1663: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1664: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 1661: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

1657: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1658: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1659: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1660: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1661: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1662: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1663: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1664: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1665: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

Line 1662: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

1658: l_qualifiers_tbl Qp_Qualifier_Rules_Pub.qualifiers_tbl_type;
1659: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
1660: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
1661: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1662: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1663: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1664: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1665: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1666: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

Line 1665: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

1661: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1662: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1663: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1664: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1665: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1666: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1667: l_qualifier_deleted VARCHAR2(1) := 'N';
1668: l_qp_list_header_id NUMBER;
1669:

Line 1666: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

1662: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
1663: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1664: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
1665: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1666: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
1667: l_qualifier_deleted VARCHAR2(1) := 'N';
1668: l_qp_list_header_id NUMBER;
1669:
1670: BEGIN

Line 1739: Qp_Modifiers_Pub.process_modifiers(

1735: END IF;
1736: END LOOP;
1737: END IF;
1738:
1739: Qp_Modifiers_Pub.process_modifiers(
1740: p_api_version_number => 1.0,
1741: p_init_msg_list => p_init_msg_list,
1742: p_return_values => Fnd_Api.G_FALSE,
1743: x_return_status => x_return_status,

Line 4228: l_modifier_list_rec Qp_Modifiers_Pub.modifier_list_rec_type;

4224: l_api_version CONSTANT NUMBER := 1.0;
4225: l_api_name CONSTANT VARCHAR2(30) := 'process_qp_list_header';
4226: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
4227:
4228: l_modifier_list_rec Qp_Modifiers_Pub.modifier_list_rec_type;
4229: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
4230:
4231: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
4232: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

Line 4229: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

4225: l_api_name CONSTANT VARCHAR2(30) := 'process_qp_list_header';
4226: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
4227:
4228: l_modifier_list_rec Qp_Modifiers_Pub.modifier_list_rec_type;
4229: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
4230:
4231: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
4232: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
4233: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

Line 4231: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

4227:
4228: l_modifier_list_rec Qp_Modifiers_Pub.modifier_list_rec_type;
4229: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
4230:
4231: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
4232: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
4233: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
4234: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4235: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 4232: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

4228: l_modifier_list_rec Qp_Modifiers_Pub.modifier_list_rec_type;
4229: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
4230:
4231: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
4232: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
4233: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
4234: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4235: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4236: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

Line 4233: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

4229: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
4230:
4231: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
4232: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
4233: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
4234: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4235: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4236: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
4237: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

Line 4236: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

4232: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
4233: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
4234: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4235: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4236: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
4237: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
4238:
4239: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4240: temp_limits_rec QP_Limits_PUB.Limits_Rec_Type;

Line 4237: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

4233: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
4234: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
4235: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
4236: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
4237: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
4238:
4239: l_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4240: temp_limits_rec QP_Limits_PUB.Limits_Rec_Type;
4241: v_limits_rec QP_Limits_PUB.Limits_Rec_Type;

Line 4389: Qp_Modifiers_Pub.process_modifiers(

4385: l_modifier_list_rec.org_id := NULL;
4386: END IF;
4387:
4388: --dbms_output.put_line('calling qp procedure');
4389: Qp_Modifiers_Pub.process_modifiers(
4390: p_api_version_number => 1.0,
4391: p_init_msg_list => FND_API.G_FALSE,
4392: p_return_values => Fnd_Api.G_FALSE,
4393: x_return_status => x_return_status,

Line 4962: , x_modifiersTbl IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type

4958: x_return_status OUT NOCOPY VARCHAR2
4959: ,x_msg_count OUT NOCOPY NUMBER
4960: ,x_msg_data OUT NOCOPY VARCHAR2
4961: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
4962: , x_modifiersTbl IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
4963: )
4964: IS
4965: l_index NUMBER;
4966: BEGIN

Line 4998: , x_modifiersTbl IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type

4994: x_return_status OUT NOCOPY VARCHAR2
4995: ,x_msg_count OUT NOCOPY NUMBER
4996: ,x_msg_data OUT NOCOPY VARCHAR2
4997: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
4998: , x_modifiersTbl IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
4999: )
5000: IS
5001: l_index NUMBER;
5002: BEGIN

Line 5032: , x_modifiersTbl IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type

5028: x_return_status OUT NOCOPY VARCHAR2
5029: ,x_msg_count OUT NOCOPY NUMBER
5030: ,x_msg_data OUT NOCOPY VARCHAR2
5031: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5032: , x_modifiersTbl IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
5033: )
5034: IS
5035: l_index NUMBER;
5036: l_modifierLineRec MODIFIER_LINE_REC_TYPE;

Line 5075: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

5071: x_return_status OUT NOCOPY VARCHAR2
5072: ,x_msg_count OUT NOCOPY NUMBER
5073: ,x_msg_data OUT NOCOPY VARCHAR2
5074: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5075: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
5076: )
5077: IS
5078: l_index NUMBER;
5079: BEGIN

Line 5101: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

5097: x_return_status OUT NOCOPY VARCHAR2
5098: ,x_msg_count OUT NOCOPY NUMBER
5099: ,x_msg_data OUT NOCOPY VARCHAR2
5100: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5101: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
5102: )
5103: IS
5104: l_index NUMBER;
5105: BEGIN

Line 5128: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

5124: x_return_status OUT NOCOPY VARCHAR2
5125: ,x_msg_count OUT NOCOPY NUMBER
5126: ,x_msg_data OUT NOCOPY VARCHAR2
5127: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5128: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
5129: )
5130: IS
5131: CURSOR c_pricingAttr(cp_listLineId NUMBER) IS
5132: SELECT pricing_attribute_id FROM qp_pricing_attributes

Line 5165: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

5161: x_return_status OUT NOCOPY VARCHAR2
5162: ,x_msg_count OUT NOCOPY NUMBER
5163: ,x_msg_data OUT NOCOPY VARCHAR2
5164: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5165: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
5166: )
5167: IS
5168: l_index NUMBER;
5169: l_modifierLineRec MODIFIER_LINE_REC_TYPE;

Line 5220: , x_modifiersTbl IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type

5216: x_return_status OUT NOCOPY VARCHAR2
5217: ,x_msg_count OUT NOCOPY NUMBER
5218: ,x_msg_data OUT NOCOPY VARCHAR2
5219: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5220: , x_modifiersTbl IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
5221: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
5222: )
5223: IS
5224: BEGIN

Line 5221: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

5217: ,x_msg_count OUT NOCOPY NUMBER
5218: ,x_msg_data OUT NOCOPY VARCHAR2
5219: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5220: , x_modifiersTbl IN OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
5221: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
5222: )
5223: IS
5224: BEGIN
5225: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5269: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type

5265: x_return_status OUT NOCOPY VARCHAR2
5266: ,x_msg_count OUT NOCOPY NUMBER
5267: ,x_msg_data OUT NOCOPY VARCHAR2
5268: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5269: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
5270: )
5271: IS
5272: BEGIN
5273: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5310: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

5306: x_return_status OUT NOCOPY VARCHAR2
5307: ,x_msg_count OUT NOCOPY NUMBER
5308: ,x_msg_data OUT NOCOPY VARCHAR2
5309: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5310: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
5311: )
5312: IS
5313: BEGIN
5314: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5336: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type

5332: x_return_status OUT NOCOPY VARCHAR2
5333: ,x_msg_count OUT NOCOPY NUMBER
5334: ,x_msg_data OUT NOCOPY VARCHAR2
5335: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5336: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
5337: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
5338: )
5339: IS
5340: BEGIN

Line 5337: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

5333: ,x_msg_count OUT NOCOPY NUMBER
5334: ,x_msg_data OUT NOCOPY VARCHAR2
5335: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5336: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
5337: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
5338: )
5339: IS
5340: BEGIN
5341: -- initialize

Line 5383: ,x_modifiersTbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type

5379: ,x_msg_count OUT NOCOPY NUMBER
5380: ,x_msg_data OUT NOCOPY VARCHAR2
5381: ,p_offerType IN VARCHAR2
5382: ,p_modifierLineRec IN MODIFIER_LINE_REC_TYPE
5383: ,x_modifiersTbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
5384: -- ,x_error_location OUT NOCOPY NUMBER
5385: )
5386: IS
5387: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;

Line 5387: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;

5383: ,x_modifiersTbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
5384: -- ,x_error_location OUT NOCOPY NUMBER
5385: )
5386: IS
5387: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
5388: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
5389: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
5390: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
5391: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

Line 5388: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;

5384: -- ,x_error_location OUT NOCOPY NUMBER
5385: )
5386: IS
5387: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
5388: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
5389: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
5390: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
5391: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5392: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

Line 5389: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

5385: )
5386: IS
5387: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
5388: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
5389: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
5390: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
5391: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5392: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
5393: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 5390: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

5386: IS
5387: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
5388: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
5389: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
5390: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
5391: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5392: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
5393: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5394: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 5391: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

5387: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
5388: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
5389: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
5390: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
5391: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5392: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
5393: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5394: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5395: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

Line 5392: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

5388: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
5389: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
5390: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
5391: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5392: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
5393: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5394: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5395: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
5396: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

Line 5395: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

5391: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5392: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
5393: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5394: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5395: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
5396: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
5397: l_control_rec qp_globals.control_rec_type;
5398: BEGIN
5399: -- initialize

Line 5396: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

5392: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
5393: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5394: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5395: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
5396: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
5397: l_control_rec qp_globals.control_rec_type;
5398: BEGIN
5399: -- initialize
5400: -- populate pbh data

Line 5436: QP_Modifiers_PUB.process_modifiers(

5432: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5434: END IF;
5435:
5436: QP_Modifiers_PUB.process_modifiers(
5437: p_api_version_number => 1.0,
5438: p_init_msg_list => FND_API.G_FALSE,
5439: p_return_values => FND_API.G_FALSE,
5440: x_return_status => x_return_status,

Line 5475: ,x_modifiers_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type

5471: ,x_msg_count OUT NOCOPY NUMBER
5472: ,x_msg_data OUT NOCOPY VARCHAR2
5473: ,p_offer_type IN VARCHAR2
5474: ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
5475: ,x_modifiers_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
5476: ,x_error_location OUT NOCOPY NUMBER
5477: ) IS
5478:
5479: l_api_version CONSTANT NUMBER := 1.0;

Line 5483: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

5479: l_api_version CONSTANT NUMBER := 1.0;
5480: l_api_name CONSTANT VARCHAR2(30) := 'process_header_tiers';
5481: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
5482:
5483: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5484:
5485: BEGIN
5486: -- initialize
5487: -- loop thru lines

Line 5562: ,x_modifiers_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type

5558: ,x_msg_data OUT NOCOPY VARCHAR2
5559: ,p_parent_offer_type IN VARCHAR2
5560: ,p_offer_type IN VARCHAR2
5561: ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
5562: ,x_modifiers_tbl OUT NOCOPY QP_MODIFIERS_PUB.modifiers_tbl_type
5563: ,x_error_location OUT NOCOPY NUMBER
5564: ) IS
5565:
5566: l_api_version CONSTANT NUMBER := 1.0;

Line 5572: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;

5568: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
5569:
5570: tiers_modifier_line_tbl MODIFIER_LINE_TBL_TYPE;
5571:
5572: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
5573: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
5574: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5575: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
5576: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

Line 5573: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;

5569:
5570: tiers_modifier_line_tbl MODIFIER_LINE_TBL_TYPE;
5571:
5572: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
5573: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
5574: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5575: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
5576: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
5577: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

Line 5575: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

5571:
5572: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
5573: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
5574: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5575: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
5576: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
5577: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5578: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
5579: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 5576: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

5572: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
5573: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
5574: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5575: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
5576: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
5577: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5578: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
5579: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5580: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 5577: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

5573: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
5574: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5575: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
5576: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
5577: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5578: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
5579: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5580: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5581: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

Line 5578: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

5574: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5575: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
5576: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
5577: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5578: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
5579: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5580: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5581: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
5582: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

Line 5581: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

5577: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
5578: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
5579: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5580: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5581: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
5582: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
5583: p_list_line_id NUMBER;
5584:
5585: i number := 0;

Line 5582: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

5578: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
5579: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
5580: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
5581: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
5582: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
5583: p_list_line_id NUMBER;
5584:
5585: i number := 0;
5586: l_tier_count number := 0;

Line 5897: QP_Modifiers_PUB.process_modifiers(

5893: END LOOP;
5894: -- RAISE Fnd_Api.g_exc_error;
5895:
5896: IF l_modifiers_tbl.count > 0 THEN -- bug 3711957. when processing PBH, l_modifiers_tbl is empty
5897: QP_Modifiers_PUB.process_modifiers(
5898: p_api_version_number => 1.0,
5899: p_init_msg_list => FND_API.G_FALSE,
5900: p_return_values => FND_API.G_FALSE,
5901: x_return_status => x_return_status,

Line 6445: , x_modifiers_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

6441: x_return_status OUT NOCOPY VARCHAR2
6442: ,x_msg_count OUT NOCOPY NUMBER
6443: ,x_msg_data OUT NOCOPY VARCHAR2
6444: ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
6445: , x_modifiers_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
6446: ,x_error_location OUT NOCOPY NUMBER
6447: ) IS
6448:
6449: l_api_version CONSTANT NUMBER := 1.0;

Line 6453: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;

6449: l_api_version CONSTANT NUMBER := 1.0;
6450: l_api_name CONSTANT VARCHAR2(30) := 'process_order_value';
6451: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
6452:
6453: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
6454: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6455: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
6456: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
6457: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

Line 6455: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

6451: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
6452:
6453: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
6454: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6455: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
6456: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
6457: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
6458: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
6459: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 6456: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

6452:
6453: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
6454: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6455: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
6456: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
6457: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
6458: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
6459: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6460: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 6457: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

6453: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
6454: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6455: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
6456: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
6457: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
6458: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
6459: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6460: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
6461: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

Line 6458: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

6454: l_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6455: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
6456: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
6457: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
6458: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
6459: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6460: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
6461: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
6462: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

Line 6461: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

6457: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
6458: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
6459: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6460: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
6461: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
6462: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
6463:
6464: p_list_line_id NUMBER;
6465: CURSOR cur_get_discount_level(p_list_header_id NUMBER) IS

Line 6462: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

6458: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
6459: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
6460: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
6461: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
6462: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
6463:
6464: p_list_line_id NUMBER;
6465: CURSOR cur_get_discount_level(p_list_header_id NUMBER) IS
6466: SELECT modifier_level_code

Line 6658: QP_Modifiers_PUB.process_modifiers(

6654: -- end change on 15-Apr-2003
6655: debug_message('ENdDateActive is :'||l_modifiers_tbl(i).end_date_active);
6656: END LOOP;
6657:
6658: QP_Modifiers_PUB.process_modifiers(
6659: p_api_version_number => 1.0,
6660: p_init_msg_list => FND_API.G_FALSE,
6661: p_return_values => FND_API.G_FALSE,
6662: x_return_status => x_return_status,

Line 6722: QP_Modifiers_PUB.process_modifiers(

6718:
6719: END LOOP;
6720:
6721:
6722: QP_Modifiers_PUB.process_modifiers(
6723: p_api_version_number => 1.0,
6724: p_init_msg_list => FND_API.G_FALSE,
6725: p_return_values => FND_API.G_FALSE,
6726: x_return_status => x_return_status,

Line 7015: ,x_modifiers_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

7011: x_return_status OUT NOCOPY VARCHAR2
7012: ,x_msg_count OUT NOCOPY NUMBER
7013: ,x_msg_data OUT NOCOPY VARCHAR2
7014: ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
7015: ,x_modifiers_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
7016: ,x_error_location OUT NOCOPY NUMBER
7017: ) IS
7018:
7019: l_api_version CONSTANT NUMBER := 1.0;

Line 7025: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;

7021: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
7022:
7023: tiers_modifier_line_tbl MODIFIER_LINE_TBL_TYPE;
7024: p_list_line_id NUMBER;
7025: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
7026: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
7027: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
7028: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
7029: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

Line 7026: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;

7022:
7023: tiers_modifier_line_tbl MODIFIER_LINE_TBL_TYPE;
7024: p_list_line_id NUMBER;
7025: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
7026: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
7027: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
7028: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
7029: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
7030: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

Line 7027: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

7023: tiers_modifier_line_tbl MODIFIER_LINE_TBL_TYPE;
7024: p_list_line_id NUMBER;
7025: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
7026: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
7027: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
7028: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
7029: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
7030: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
7031: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 7028: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

7024: p_list_line_id NUMBER;
7025: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
7026: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
7027: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
7028: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
7029: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
7030: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
7031: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
7032: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 7029: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

7025: l_modifiers_tbl Qp_Modifiers_Pub.modifiers_tbl_type;
7026: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
7027: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
7028: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
7029: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
7030: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
7031: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
7032: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
7033: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

Line 7030: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

7026: l_pricing_attr_tbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
7027: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
7028: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
7029: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
7030: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
7031: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
7032: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
7033: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
7034: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

Line 7033: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

7029: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
7030: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
7031: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
7032: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
7033: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
7034: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
7035: l_control_rec qp_globals.control_rec_type;
7036:
7037: l_modifier_parent_index NUMBER := 0;

Line 7034: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

7030: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
7031: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
7032: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
7033: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
7034: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
7035: l_control_rec qp_globals.control_rec_type;
7036:
7037: l_modifier_parent_index NUMBER := 0;
7038: l_list_header_id NUMBER;

Line 7491: , x_modifiers_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

7487: ,x_msg_count OUT NOCOPY NUMBER
7488: ,x_msg_data OUT NOCOPY VARCHAR2
7489: ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
7490: ,p_list_header_id IN NUMBER
7491: , x_modifiers_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
7492: ,x_error_location OUT NOCOPY NUMBER
7493: ) IS
7494:
7495: l_api_version CONSTANT NUMBER := 1.0;

Line 7500: v_off_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

7496: l_api_name CONSTANT VARCHAR2(30) := 'process_trade_deal';
7497: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
7498:
7499: l_modifier_line_tbl MODIFIER_LINE_TBL_TYPE := p_modifier_line_tbl;
7500: v_off_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
7501: v_accr_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
7502: temp_modifier_line_tbl MODIFIER_LINE_TBL_TYPE := p_modifier_line_tbl;
7503:
7504: l_modifier_line_all_off_tbl MODIFIER_LINE_TBL_TYPE; -- line has both off_invoice and accrual values, off_invoice

Line 7501: v_accr_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

7497: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
7498:
7499: l_modifier_line_tbl MODIFIER_LINE_TBL_TYPE := p_modifier_line_tbl;
7500: v_off_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
7501: v_accr_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
7502: temp_modifier_line_tbl MODIFIER_LINE_TBL_TYPE := p_modifier_line_tbl;
7503:
7504: l_modifier_line_all_off_tbl MODIFIER_LINE_TBL_TYPE; -- line has both off_invoice and accrual values, off_invoice
7505: l_modifier_line_all_acc_tbl MODIFIER_LINE_TBL_TYPE; -- line has both off_invoice and accrual values, accural

Line 7508: v_modifier_all_off_tbl qp_modifiers_pub.modifiers_tbl_type;

7504: l_modifier_line_all_off_tbl MODIFIER_LINE_TBL_TYPE; -- line has both off_invoice and accrual values, off_invoice
7505: l_modifier_line_all_acc_tbl MODIFIER_LINE_TBL_TYPE; -- line has both off_invoice and accrual values, accural
7506: l_modifier_line_off_tbl MODIFIER_LINE_TBL_TYPE; -- line has only off_invoice value
7507: l_modifier_line_acc_tbl MODIFIER_LINE_TBL_TYPE; -- line has only accrual value
7508: v_modifier_all_off_tbl qp_modifiers_pub.modifiers_tbl_type;
7509: v_modifier_all_acc_tbl qp_modifiers_pub.modifiers_tbl_type;
7510: v_modifier_off_tbl qp_modifiers_pub.modifiers_tbl_type;
7511: v_modifier_acc_tbl qp_modifiers_pub.modifiers_tbl_type;
7512: v_modifier_ret_tbl qp_modifiers_pub.modifiers_tbl_type;

Line 7509: v_modifier_all_acc_tbl qp_modifiers_pub.modifiers_tbl_type;

7505: l_modifier_line_all_acc_tbl MODIFIER_LINE_TBL_TYPE; -- line has both off_invoice and accrual values, accural
7506: l_modifier_line_off_tbl MODIFIER_LINE_TBL_TYPE; -- line has only off_invoice value
7507: l_modifier_line_acc_tbl MODIFIER_LINE_TBL_TYPE; -- line has only accrual value
7508: v_modifier_all_off_tbl qp_modifiers_pub.modifiers_tbl_type;
7509: v_modifier_all_acc_tbl qp_modifiers_pub.modifiers_tbl_type;
7510: v_modifier_off_tbl qp_modifiers_pub.modifiers_tbl_type;
7511: v_modifier_acc_tbl qp_modifiers_pub.modifiers_tbl_type;
7512: v_modifier_ret_tbl qp_modifiers_pub.modifiers_tbl_type;
7513: l_related_lines_rec ozf_related_lines_pvt.related_lines_rec_type;

Line 7510: v_modifier_off_tbl qp_modifiers_pub.modifiers_tbl_type;

7506: l_modifier_line_off_tbl MODIFIER_LINE_TBL_TYPE; -- line has only off_invoice value
7507: l_modifier_line_acc_tbl MODIFIER_LINE_TBL_TYPE; -- line has only accrual value
7508: v_modifier_all_off_tbl qp_modifiers_pub.modifiers_tbl_type;
7509: v_modifier_all_acc_tbl qp_modifiers_pub.modifiers_tbl_type;
7510: v_modifier_off_tbl qp_modifiers_pub.modifiers_tbl_type;
7511: v_modifier_acc_tbl qp_modifiers_pub.modifiers_tbl_type;
7512: v_modifier_ret_tbl qp_modifiers_pub.modifiers_tbl_type;
7513: l_related_lines_rec ozf_related_lines_pvt.related_lines_rec_type;
7514: l_related_deal_lines_id NUMBER;

Line 7511: v_modifier_acc_tbl qp_modifiers_pub.modifiers_tbl_type;

7507: l_modifier_line_acc_tbl MODIFIER_LINE_TBL_TYPE; -- line has only accrual value
7508: v_modifier_all_off_tbl qp_modifiers_pub.modifiers_tbl_type;
7509: v_modifier_all_acc_tbl qp_modifiers_pub.modifiers_tbl_type;
7510: v_modifier_off_tbl qp_modifiers_pub.modifiers_tbl_type;
7511: v_modifier_acc_tbl qp_modifiers_pub.modifiers_tbl_type;
7512: v_modifier_ret_tbl qp_modifiers_pub.modifiers_tbl_type;
7513: l_related_lines_rec ozf_related_lines_pvt.related_lines_rec_type;
7514: l_related_deal_lines_id NUMBER;
7515: l_all_index NUMBER := 0;

Line 7512: v_modifier_ret_tbl qp_modifiers_pub.modifiers_tbl_type;

7508: v_modifier_all_off_tbl qp_modifiers_pub.modifiers_tbl_type;
7509: v_modifier_all_acc_tbl qp_modifiers_pub.modifiers_tbl_type;
7510: v_modifier_off_tbl qp_modifiers_pub.modifiers_tbl_type;
7511: v_modifier_acc_tbl qp_modifiers_pub.modifiers_tbl_type;
7512: v_modifier_ret_tbl qp_modifiers_pub.modifiers_tbl_type;
7513: l_related_lines_rec ozf_related_lines_pvt.related_lines_rec_type;
7514: l_related_deal_lines_id NUMBER;
7515: l_all_index NUMBER := 0;
7516: l_off_index NUMBER := 0;

Line 8185: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type

8181: ,x_msg_data OUT NOCOPY VARCHAR2
8182: ,p_offer_type IN VARCHAR2
8183: ,p_modifier_line_tbl IN MODIFIER_LINE_TBL_TYPE
8184: ,p_list_header_id IN NUMBER
8185: ,x_modifier_line_tbl OUT NOCOPY qp_modifiers_pub.modifiers_tbl_type
8186: ,x_error_location OUT NOCOPY NUMBER
8187: )IS
8188: l_api_version CONSTANT NUMBER := 1.0;
8189: l_api_name CONSTANT VARCHAR2(30) := 'process_qp_list_lines';

Line 8191: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;

8187: )IS
8188: l_api_version CONSTANT NUMBER := 1.0;
8189: l_api_name CONSTANT VARCHAR2(30) := 'process_qp_list_lines';
8190: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
8191: l_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
8192: -- RSSHARMA changed on 06-Feb-2003
8193: CURSOR c_volume_offer_type IS
8194: SELECT volume_offer_type FROM ozf_offers
8195: where qp_list_header_id = p_list_header_id;

Line 8683: v_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type; --

8679: temp_modifier_list_rec modifier_list_rec_type := p_modifier_list_rec;
8680: date_temp_modifier_list_rec modifier_list_rec_type := p_modifier_list_rec;
8681: l_modifier_list_rec modifier_list_rec_type := p_modifier_list_rec;
8682: l_offer_id NUMBER;
8683: v_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type; --
8684: l_modifier_line_tbl MODIFIER_LINE_TBL_TYPE := p_modifier_line_tbl;
8685:
8686: l_api_version CONSTANT NUMBER := 1.0;
8687: l_api_name CONSTANT VARCHAR2(30) := 'process_modifiers';

Line 9713: , x_pricingAttrRec OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Rec_type

9709: ,x_msg_count OUT NOCOPY NUMBER
9710: ,x_msg_data OUT NOCOPY VARCHAR2
9711: , p_qp_list_header_id IN NUMBER
9712: , p_offDiscountProductId IN NUMBER
9713: , x_pricingAttrRec OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Rec_type
9714: )
9715: IS
9716: CURSOR c_products(cp_offDiscountProductId NUMBER)IS
9717: SELECT a.offer_discount_line_id

Line 9790: ,x_modifiersRec OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type

9786: (
9787: x_return_status OUT NOCOPY VARCHAR2
9788: ,x_msg_count OUT NOCOPY NUMBER
9789: ,x_msg_data OUT NOCOPY VARCHAR2
9790: ,x_modifiersRec OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type
9791: ,p_offDiscountProductId IN NUMBER
9792: , p_qpListHeaderId IN NUMBER
9793: )
9794: IS

Line 9822: ,x_modifiersRec OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type

9818: (
9819: x_return_status OUT NOCOPY VARCHAR2
9820: ,x_msg_count OUT NOCOPY NUMBER
9821: ,x_msg_data OUT NOCOPY VARCHAR2
9822: ,x_modifiersRec OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type
9823: , p_qpListHeaderId IN NUMBER
9824: , p_offDiscountProductId IN NUMBER
9825: )
9826: IS

Line 9865: ,x_modifiersRec OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type

9861: (
9862: x_return_status OUT NOCOPY VARCHAR2
9863: ,x_msg_count OUT NOCOPY NUMBER
9864: ,x_msg_data OUT NOCOPY VARCHAR2
9865: ,x_modifiersRec OUT NOCOPY Qp_Modifiers_Pub.modifiers_rec_type
9866: ,p_offerDiscountLineId IN NUMBER
9867: , p_qpListHeaderId IN NUMBER
9868: , p_offDiscountProductId IN NUMBER
9869: )

Line 9939: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type

9935: (
9936: x_return_status OUT NOCOPY VARCHAR2
9937: ,x_msg_count OUT NOCOPY NUMBER
9938: ,x_msg_data OUT NOCOPY VARCHAR2
9939: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
9940: , p_offDiscountProductId IN NUMBER
9941: , p_qpListHeaderId IN NUMBER
9942: )
9943: IS

Line 9993: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type

9989: ,x_msg_count OUT NOCOPY NUMBER
9990: ,x_msg_data OUT NOCOPY VARCHAR2
9991: , p_qp_list_header_id IN NUMBER
9992: , p_offDiscountProductId IN NUMBER
9993: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
9994: )
9995: IS
9996: l_modifiersRec Qp_Modifiers_Pub.modifiers_rec_type;
9997: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;

Line 9996: l_modifiersRec Qp_Modifiers_Pub.modifiers_rec_type;

9992: , p_offDiscountProductId IN NUMBER
9993: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
9994: )
9995: IS
9996: l_modifiersRec Qp_Modifiers_Pub.modifiers_rec_type;
9997: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
9998: v_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
9999: i NUMBER;
10000: BEGIN

Line 9997: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;

9993: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
9994: )
9995: IS
9996: l_modifiersRec Qp_Modifiers_Pub.modifiers_rec_type;
9997: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
9998: v_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
9999: i NUMBER;
10000: BEGIN
10001: -- initialize

Line 9998: v_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;

9994: )
9995: IS
9996: l_modifiersRec Qp_Modifiers_Pub.modifiers_rec_type;
9997: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
9998: v_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
9999: i NUMBER;
10000: BEGIN
10001: -- initialize
10002: -- populate PBH data

Line 10051: ,x_pricingAttrRec IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Rec_type

10047: (
10048: x_return_status OUT NOCOPY VARCHAR2
10049: ,x_msg_count OUT NOCOPY NUMBER
10050: ,x_msg_data OUT NOCOPY VARCHAR2
10051: ,x_pricingAttrRec IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_Rec_type
10052: ,p_offerDiscountLineId IN NUMBER
10053: ,p_offDiscountProductId IN NUMBER
10054: )
10055: IS

Line 10078: , x_modifiersTbl IN Qp_Modifiers_Pub.modifiers_tbl_type

10074: (
10075: x_return_status OUT NOCOPY VARCHAR2
10076: ,x_msg_count OUT NOCOPY NUMBER
10077: ,x_msg_data OUT NOCOPY VARCHAR2
10078: , x_modifiersTbl IN Qp_Modifiers_Pub.modifiers_tbl_type
10079: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
10080: , x_pricingAttrRec IN Qp_Modifiers_Pub.pricing_attr_Rec_type
10081: , p_offDiscountProductId IN NUMBER
10082: )

Line 10079: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

10075: x_return_status OUT NOCOPY VARCHAR2
10076: ,x_msg_count OUT NOCOPY NUMBER
10077: ,x_msg_data OUT NOCOPY VARCHAR2
10078: , x_modifiersTbl IN Qp_Modifiers_Pub.modifiers_tbl_type
10079: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
10080: , x_pricingAttrRec IN Qp_Modifiers_Pub.pricing_attr_Rec_type
10081: , p_offDiscountProductId IN NUMBER
10082: )
10083: IS

Line 10080: , x_pricingAttrRec IN Qp_Modifiers_Pub.pricing_attr_Rec_type

10076: ,x_msg_count OUT NOCOPY NUMBER
10077: ,x_msg_data OUT NOCOPY VARCHAR2
10078: , x_modifiersTbl IN Qp_Modifiers_Pub.modifiers_tbl_type
10079: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
10080: , x_pricingAttrRec IN Qp_Modifiers_Pub.pricing_attr_Rec_type
10081: , p_offDiscountProductId IN NUMBER
10082: )
10083: IS
10084: BEGIN

Line 10122: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

10118: x_return_status OUT NOCOPY VARCHAR2
10119: ,x_msg_count OUT NOCOPY NUMBER
10120: ,x_msg_data OUT NOCOPY VARCHAR2
10121: , p_qpListHeaderId IN NUMBER
10122: , x_pricingAttrTbl IN OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
10123: )
10124: IS
10125: CURSOR c_exclusions(cp_qpListHeaderId IN NUMBER) IS
10126: SELECT a.product_attribute, a.product_attr_value, a.excluder_flag

Line 10152: ,p_modifiersTbl IN qp_modifiers_pub.modifiers_tbl_type

10148: (
10149: x_return_status OUT NOCOPY VARCHAR2
10150: ,x_msg_count OUT NOCOPY NUMBER
10151: ,x_msg_data OUT NOCOPY VARCHAR2
10152: ,p_modifiersTbl IN qp_modifiers_pub.modifiers_tbl_type
10153: )
10154: IS
10155: l_discRec OZF_QP_DISCOUNTS_PVT.qp_discount_rec_type;
10156: l_qpDiscountId NUMBER;

Line 10191: ,p_pricingAttrTbl IN qp_modifiers_pub.pricing_attr_tbl_type

10187: (
10188: x_return_status OUT NOCOPY VARCHAR2
10189: ,x_msg_count OUT NOCOPY NUMBER
10190: ,x_msg_data OUT NOCOPY VARCHAR2
10191: ,p_pricingAttrTbl IN qp_modifiers_pub.pricing_attr_tbl_type
10192: ,p_offDiscountProductId IN NUMBER
10193: )
10194: IS
10195: l_prodRec OZF_QP_PRODUCTS_PVT.qp_product_rec_type;

Line 10231: ,p_modifiersTbl IN qp_modifiers_pub.modifiers_tbl_type

10227: (
10228: x_return_status OUT NOCOPY VARCHAR2
10229: ,x_msg_count OUT NOCOPY NUMBER
10230: ,x_msg_data OUT NOCOPY VARCHAR2
10231: ,p_modifiersTbl IN qp_modifiers_pub.modifiers_tbl_type
10232: ,p_pricingAttrTbl IN qp_modifiers_pub.pricing_attr_tbl_type
10233: ,p_offDiscountProductId IN NUMBER
10234: )
10235: IS

Line 10232: ,p_pricingAttrTbl IN qp_modifiers_pub.pricing_attr_tbl_type

10228: x_return_status OUT NOCOPY VARCHAR2
10229: ,x_msg_count OUT NOCOPY NUMBER
10230: ,x_msg_data OUT NOCOPY VARCHAR2
10231: ,p_modifiersTbl IN qp_modifiers_pub.modifiers_tbl_type
10232: ,p_pricingAttrTbl IN qp_modifiers_pub.pricing_attr_tbl_type
10233: ,p_offDiscountProductId IN NUMBER
10234: )
10235: IS
10236: BEGIN

Line 10272: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type

10268: ,x_msg_data OUT NOCOPY VARCHAR2
10269: , p_qp_list_header_id IN NUMBER
10270: , p_offDiscountProductId IN NUMBER
10271: , x_error_location OUT NOCOPY NUMBER
10272: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
10273: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
10274: )
10275: IS
10276: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;

Line 10273: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

10269: , p_qp_list_header_id IN NUMBER
10270: , p_offDiscountProductId IN NUMBER
10271: , x_error_location OUT NOCOPY NUMBER
10272: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
10273: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
10274: )
10275: IS
10276: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
10277: l_pricingAttrRec Qp_Modifiers_Pub.pricing_attr_Rec_type;

Line 10276: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;

10272: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
10273: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
10274: )
10275: IS
10276: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
10277: l_pricingAttrRec Qp_Modifiers_Pub.pricing_attr_Rec_type;
10278: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
10279:
10280: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

Line 10277: l_pricingAttrRec Qp_Modifiers_Pub.pricing_attr_Rec_type;

10273: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
10274: )
10275: IS
10276: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
10277: l_pricingAttrRec Qp_Modifiers_Pub.pricing_attr_Rec_type;
10278: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
10279:
10280: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
10281: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

Line 10278: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;

10274: )
10275: IS
10276: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
10277: l_pricingAttrRec Qp_Modifiers_Pub.pricing_attr_Rec_type;
10278: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
10279:
10280: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
10281: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
10282: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

Line 10280: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;

10276: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
10277: l_pricingAttrRec Qp_Modifiers_Pub.pricing_attr_Rec_type;
10278: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
10279:
10280: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
10281: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
10282: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
10283: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
10284: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;

Line 10281: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;

10277: l_pricingAttrRec Qp_Modifiers_Pub.pricing_attr_Rec_type;
10278: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
10279:
10280: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
10281: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
10282: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
10283: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
10284: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
10285: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;

Line 10282: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;

10278: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
10279:
10280: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
10281: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
10282: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
10283: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
10284: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
10285: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
10286: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

Line 10283: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;

10279:
10280: v_modifier_list_rec qp_modifiers_pub.modifier_list_rec_type;
10281: v_modifier_list_val_rec qp_modifiers_pub.modifier_list_val_rec_type;
10282: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
10283: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
10284: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
10285: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
10286: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
10287: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

Line 10286: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;

10282: v_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
10283: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
10284: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
10285: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
10286: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
10287: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
10288: l_control_rec qp_globals.control_rec_type;
10289: BEGIN
10290: -- initialize

Line 10287: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;

10283: v_modifiers_val_tbl qp_modifiers_pub.modifiers_val_tbl_type;
10284: v_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
10285: v_qualifiers_val_tbl qp_qualifier_rules_pub.qualifiers_val_tbl_type;
10286: v_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
10287: v_pricing_attr_val_tbl qp_modifiers_pub.pricing_attr_val_tbl_type;
10288: l_control_rec qp_globals.control_rec_type;
10289: BEGIN
10290: -- initialize
10291: -- for the product populate pricing attribute

Line 10356: QP_Modifiers_PUB.process_modifiers(

10352: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10354: END IF;
10355:
10356: QP_Modifiers_PUB.process_modifiers(
10357: p_api_version_number => 1.0,
10358: p_init_msg_list => FND_API.G_FALSE,
10359: p_return_values => FND_API.G_FALSE,
10360: x_return_status => x_return_status,

Line 10389: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type

10385: ,x_msg_data OUT NOCOPY VARCHAR2
10386: , p_qp_list_header_id IN NUMBER
10387: , p_offDiscountProductId IN NUMBER
10388: , x_error_location OUT NOCOPY NUMBER
10389: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
10390: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
10391: )
10392: IS
10393: BEGIN

Line 10390: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type

10386: , p_qp_list_header_id IN NUMBER
10387: , p_offDiscountProductId IN NUMBER
10388: , x_error_location OUT NOCOPY NUMBER
10389: , x_modifiersTbl OUT NOCOPY Qp_Modifiers_Pub.modifiers_tbl_type
10390: , x_pricingAttrTbl OUT NOCOPY Qp_Modifiers_Pub.pricing_attr_tbl_type
10391: )
10392: IS
10393: BEGIN
10394: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 10458: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;

10454: WHERE a.offer_id = b.offer_id
10455: AND a.excluder_flag = 'N'
10456: AND b.qp_list_header_id = cp_qpListHeaderId;
10457:
10458: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
10459: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
10460: l_errorLocation NUMBER;
10461: BEGIN
10462: -- initialize

Line 10459: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;

10455: AND a.excluder_flag = 'N'
10456: AND b.qp_list_header_id = cp_qpListHeaderId;
10457:
10458: l_modifiersTbl Qp_Modifiers_Pub.modifiers_tbl_type;
10459: l_pricingAttrTbl Qp_Modifiers_Pub.pricing_attr_tbl_type;
10460: l_errorLocation NUMBER;
10461: BEGIN
10462: -- initialize
10463: SAVEPOINT push_disc_rules;