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