The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE DeleteObjectDefinition(
p_obj_def_id in number
)
--------------------------------------------------------------------------------
IS
g_api_name constant varchar2(30) := 'DeleteObjectDefinition';
delete from PFT_ACTIVITY_STAT_RU
where stat_rollup_obj_def_id = p_obj_def_id;
END DeleteObjectDefinition;
insert into pft_activity_stat_ru (
stat_rollup_obj_def_id
,activity_hier_obj_id
,statistic_basis_id
,condition_obj_id
,created_by
,creation_date
,last_updated_by
,last_update_date
,last_update_login
,object_version_number
) select
p_target_obj_def_id
,activity_hier_obj_id
,statistic_basis_id
,condition_obj_id
,nvl(p_created_by,created_by)
,nvl(p_creation_date,creation_date)
,FND_GLOBAL.user_id
,sysdate
,FND_GLOBAL.login_id
,object_version_number
from pft_activity_stat_ru
where stat_rollup_obj_def_id = p_source_obj_def_id;