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