[Home] [Help]
2873:
2874: procedure insert_position_ei(p_transfer_name varchar2,
2875: p_person_id number,
2876: p_effective_date date,
2877: p_pos_ei per_position_extra_info%rowtype)
2878: is
2879:
2880: l_proc varchar2(72) := g_package||'insert_position_ei';
2881:
2887: l_info13_meaning varchar2(80) := null;
2888: l_info14_meaning varchar2(80) := null;
2889: l_info16_meaning varchar2(80) := null;
2890:
2891: l_table_name constant varchar2(30) := 'PER_POSITION_EXTRA_INFO';
2892: l_name varchar2(30);
2893:
2894: begin
2895:
3140:
3141: procedure update_position_ei(p_transfer_name varchar2,
3142: p_person_id number,
3143: p_effective_date date,
3144: p_pos_ei per_position_extra_info%rowtype)
3145: is
3146:
3147: l_proc varchar2(72) := g_package||'update_position_ei';
3148: l_x varchar2(1);
4029: l_assignment_id per_assignments_f.assignment_id%type;
4030: l_grade_id per_assignments_f.grade_id%type;
4031: l_business_group_id per_assignments_f.business_group_id%type;
4032:
4033: l_pos_ei_data per_position_extra_info%rowtype;
4034: l_per_ei_data per_people_extra_info%rowtype;
4035: l_asg_ei_data per_assignment_extra_info%rowtype;
4036: l_special_info ghr_api.special_information_type;
4037:
4088: and trunc(l_effdate) between effective_start_date
4089: and effective_end_date;
4090:
4091: l_positions_row hr_all_positions_f%rowtype;
4092: l_position_ei_row per_position_extra_info%rowtype;
4093:
4094: l_contact_type varchar2(30);
4095: l_contact_name varchar2(240);
4096: l_contact_person_id per_people_f.person_id%type;