DBA Data[Home] [Help]

APPS.OZF_QUOTA_PUB dependencies on OZF_OFFER_PUB

Line 802: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;

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;

Line 803: l_modifier_line_tbl ozf_offer_pub.modifier_line_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;

Line 804: l_vo_pbh_tbl ozf_offer_pub.vo_disc_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;

Line 805: l_vo_dis_tbl ozf_offer_pub.vo_disc_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:

Line 806: l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_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:
810: BEGIN

Line 807: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_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
811:

Line 808: l_vo_mo_tbl ozf_offer_pub.vo_mo_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:
812: -- Initialize API return status to success

Line 2531: l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;

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;

Line 2532: l_modifier_line_tbl ozf_offer_pub.modifier_line_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;

Line 2533: l_vo_pbh_tbl ozf_offer_pub.vo_disc_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;

Line 2534: l_vo_dis_tbl ozf_offer_pub.vo_disc_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:

Line 2535: l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;

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

Line 2536: l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_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
2540: SELECT fund_id

Line 2537: l_vo_mo_tbl ozf_offer_pub.vo_mo_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
2541: FROM ozf_funds_all_b