Tag: OZF_FUND_UTILIZED_PVT

  • OZF_FUND_UTILIZED_PVT.create_utilization

        SET serveroutput on; DECLARE l_user_name VARCHAR2(100) ; l_user_id NUMBER; l_resp_id NUMBER; l_adj_rec OZF_FUND_UTILIZED_PVT.utilization_rec_type; l_return_status VARCHAR2(1); l_msg_count NUMBER; l_msg_data VARCHAR2(2000); l_utilization_id NUMBER; BEGIN BEGIN select responsibility_id into l_resp_id from fnd_responsibility_vl where responsibility_key = ‘OZF_USER’; EXCEPTION WHEN OTHERS THEN l_resp_id := NULL; END; FND_GLOBAL.apps_initialize (user_id => 1234 — change this value , resp_id => l_resp_id,…