[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
This inserts measurement type data into the business group, that
is needed for the 2483 report. Where the data already exists for
business group, it is updated.
-------------------------------------------------------------------------*/
--
procedure load_bg_measure_item(p_business_group_id number
,p_tp_measurement_code varchar2
,p_unit varchar2
,p_cost_level varchar2
,p_budget_level varchar2 default 'PLAN') is
/* --------------------------------------------------------------------------
Description
This procedure inserts or updates 1 measure into the table
for the OTA 2483 Report
------------------------------------------------------------------------- */
--
l_mt_id number;
select tp_measurement_type_id
,object_version_number
from ota_tp_measurement_types
where business_group_id = l_bg_id
and tp_measurement_code = l_measure_code;
thus we shall not subsequently update it */
hr_utility.set_location(l_proc,20);