798: -- Fund related variables
799:
800: l_fund_rec OZF_Funds_Pub.fund_rec_type;
801: l_mks_rec OZF_Funds_Pub.mks_rec_type;
802: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
803: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
804: l_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
805: l_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
806: l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
799:
800: l_fund_rec OZF_Funds_Pub.fund_rec_type;
801: l_mks_rec OZF_Funds_Pub.mks_rec_type;
802: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
803: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
804: l_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
805: l_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
806: l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
807: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
800: l_fund_rec OZF_Funds_Pub.fund_rec_type;
801: l_mks_rec OZF_Funds_Pub.mks_rec_type;
802: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
803: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
804: l_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
805: l_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
806: l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
807: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
808: l_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
801: l_mks_rec OZF_Funds_Pub.mks_rec_type;
802: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
803: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
804: l_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
805: l_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
806: l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
807: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
808: l_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
809:
802: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
803: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
804: l_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
805: l_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
806: l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
807: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
808: l_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
809:
810: BEGIN
803: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
804: l_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
805: l_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
806: l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
807: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
808: l_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
809:
810: BEGIN
811:
804: l_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
805: l_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
806: l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
807: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
808: l_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
809:
810: BEGIN
811:
812: -- Initialize API return status to success
2527: l_threshold_id NUMBER;
2528: l_product_spread_time_id NUMBER;
2529: l_object_version_number NUMBER;
2530: l_quota_id NUMBER := l_quota_rec.quota_id;
2531: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
2532: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
2533: l_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
2534: l_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
2535: l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
2528: l_product_spread_time_id NUMBER;
2529: l_object_version_number NUMBER;
2530: l_quota_id NUMBER := l_quota_rec.quota_id;
2531: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
2532: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
2533: l_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
2534: l_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
2535: l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
2536: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
2529: l_object_version_number NUMBER;
2530: l_quota_id NUMBER := l_quota_rec.quota_id;
2531: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
2532: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
2533: l_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
2534: l_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
2535: l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
2536: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
2537: l_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
2530: l_quota_id NUMBER := l_quota_rec.quota_id;
2531: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
2532: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
2533: l_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
2534: l_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
2535: l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
2536: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
2537: l_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
2538:
2531: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
2532: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
2533: l_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
2534: l_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
2535: l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
2536: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
2537: l_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
2538:
2539: CURSOR c_quota_id (quota_number IN VARCHAR2) IS
2532: l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
2533: l_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
2534: l_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
2535: l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
2536: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
2537: l_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
2538:
2539: CURSOR c_quota_id (quota_number IN VARCHAR2) IS
2540: SELECT fund_id
2533: l_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
2534: l_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
2535: l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
2536: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
2537: l_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
2538:
2539: CURSOR c_quota_id (quota_number IN VARCHAR2) IS
2540: SELECT fund_id
2541: FROM ozf_funds_all_b