SET serveroutput on; DECLARE l_user_name VARCHAR2(100); l_user_id NUMBER; l_resource_id NUMBER; l_resp_id NUMBER; l_api_version NUMBER := 1.0; l_fund_id NUMBER; l_validation_level NUMBER := fnd_api.g_valid_level_none; l_return_status VARCHAR2(1); l_msg_count NUMBER; l_msg_data VARCHAR2(2000); l_pvt_fund_rec OZF_FUNDS_PUB.fund_rec_type; l_modifier_list_rec ozf_offer_pub.modifier_list_rec_type; l_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type; l_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type; l_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type; l_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type; l_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type; l_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type; BEGIN select resource_id into l_pvt_fund_rec.owner from JTF_RS_RESOURCE_EXTNS where user_id = 1177;…