[Home] [Help]
2192:
2193: procedure insert_assignment_ei(p_transfer_name varchar2,
2194: p_person_id number,
2195: p_effective_date date,
2196: p_a_ei per_assignment_extra_info%rowtype)
2197: is
2198:
2199: l_proc varchar2(72) := g_package||'insert_assignment_ei';
2200: l_table_name constant varchar2(30) := 'PER_ASSIGNMENT_EXTRA_INFO';
2196: p_a_ei per_assignment_extra_info%rowtype)
2197: is
2198:
2199: l_proc varchar2(72) := g_package||'insert_assignment_ei';
2200: l_table_name constant varchar2(30) := 'PER_ASSIGNMENT_EXTRA_INFO';
2201: l_name varchar2(30);
2202:
2203: l_info4_meaning varchar2(80) := null;
2204: l_info5_meaning varchar2(80) := null;
2439:
2440: procedure update_assignment_ei(p_transfer_name varchar2,
2441: p_person_id number,
2442: p_effective_date date,
2443: p_a_ei per_assignment_extra_info%rowtype)
2444: is
2445:
2446: l_proc varchar2(72) := g_package||'update_assignment_ei';
2447: l_x varchar2(1);
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:
4038: l_adj_basic_pay number;
4039: l_multi_error_flag boolean;
4077: between nvl(date_from,l_effdate)
4078: and nvl(date_to,l_effdate);
4079:
4080: l_assignments_row per_all_assignments_f%rowtype;
4081: l_assignment_ei_row per_assignment_extra_info%rowtype;
4082: cursor cur_assignments_f(p_person_id number) is
4083: select assignment_id, position_id, business_group_id, grade_id, location_id
4084: from per_all_assignments_f
4085: where primary_flag = 'Y'