can any one help me to update Assignment Status
i used this code but always find error
declare
-- Boolean parameters are translated from/to integers:
-- 0/1/null <--> false/true/null
----p_validate boolean := sys.diutil.int_to_bool(:p_validate);
p_no_managers_warning boolean;
p_other_manager_warning boolean;
p_hourly_salaried_warning boolean;
p_concatenated_segments varchar2(200);
p_comment_id number;
p_effective_start_date date;
p_effective_end_date date;
p_gsp_post_process_warning varchar2(200);
p_cagr_grade_def_id number;
l_group_name varchar2(200);
p_cagr_concatenated_segments varchar2(200);
cursor asg is
select a.assignment_number,
a.effective_start_date,
a.assignment_id,
a.object_version_number,
a.soft_coding_keyflex_id,
t.assignment_status_type_id NEW ,
a.assignment_status_type_id old ,
a.cagr_grade_def_id
from ASS_STATUS_UPDATE t,
per_grades g,
per_all_positions p,
per_all_assignments_f a,
PAY_PEOPLE_GROUPS pg
where t.emp_no = a.assignment_number
--and t.position = p.name(+)
and a.grade_id =g.grade_id
and a.position_id=p.position_id
and a.people_group_id=pg.people_group_id
--and t.people_group = pg.group_name(+)
and t.emp_no='5038'
and sysdate between a.effective_start_date and a.effective_end_date
and a.people_group_id =pg.people_group_id
--and p.position_id is not null
order by 1;
begin
-- Call the procedure
For sal in asg loop
hr_assignment_api.update_emp_asg(p_validate => FALSE,
p_effective_date => sysdate,
p_datetrack_update_mode => 'UPDATE',
p_assignment_id => SAL.assignment_id,
p_object_version_number => SAL.object_version_number,
p_cagr_grade_def_id => sal.cagr_grade_def_id,
p_cagr_concatenated_segments => p_cagr_concatenated_segments,
p_concatenated_segments => p_concatenated_segments,
p_soft_coding_keyflex_id => sal.soft_coding_keyflex_id,
p_comment_id => p_comment_id,
p_effective_start_date => p_effective_start_date,
p_effective_end_date => p_effective_end_date,
p_no_managers_warning => p_no_managers_warning,
p_other_manager_warning => p_other_manager_warning,
p_hourly_salaried_warning => p_hourly_salaried_warning,
p_assignment_status_type_id =>sal.NEW,
p_gsp_post_process_warning => p_gsp_post_process_warning);
-- Convert false/true/null to 0/1/null
/*:p_no_managers_warning := sys.diutil.bool_to_int(p_no_managers_warning);
:p_other_manager_warning := sys.diutil.bool_to_int(p_other_manager_warning);
:p_hourly_salaried_warning := sys.diutil.bool_to_int(p_hourly_salaried_warning);*/
end loop;
end;
