[Home] [Help]
3321: procedure insert_position_defs(p_transfer_name varchar2,
3322: p_effective_date date,
3323: p_person_id number,
3324: p_flex_name varchar2,
3325: p_pos_defs per_position_definitions%rowtype)
3326: is
3327:
3328: l_proc varchar2(72) := g_package||'insert_position_defs';
3329: l_table_name constant varchar2(30) := 'PER_POSITION_DEFINITIONS';
3325: p_pos_defs per_position_definitions%rowtype)
3326: is
3327:
3328: l_proc varchar2(72) := g_package||'insert_position_defs';
3329: l_table_name constant varchar2(30) := 'PER_POSITION_DEFINITIONS';
3330: l_name varchar2(30);
3331:
3332: begin
3333:
3469: procedure update_position_defs(p_transfer_name varchar2,
3470: p_effective_date date,
3471: p_person_id number,
3472: p_flex_name varchar2,
3473: p_pos_defs per_position_definitions%rowtype)
3474: is
3475:
3476: l_proc varchar2(72) := g_package||'update_position_defs';
3477: l_x varchar2(1);
4049: l_people_ei_row per_people_extra_info%rowtype;
4050: l_element ghr_mt_element_entries_v%rowtype;
4051: l_misc ghr_mt_misc_v%rowtype;
4052:
4053: l_pos_defs per_position_definitions%rowtype;
4054: l_position_rec hr_all_positions_f%rowtype;
4055: l_result_code varchar2(10);
4056: /*
4057: cursor cur_pos_definitions(p_position_id number) is
4055: l_result_code varchar2(10);
4056: /*
4057: cursor cur_pos_definitions(p_position_id number) is
4058: select pd.*
4059: from per_position_definitions pd,
4060: hr_all_positions_f p
4061: where p.position_id = p_position_id
4062: and p.position_definition_id = pd.position_definition_id
4063: and trunc(l_effdate) between p.effective_start_date and
4064: nvl(effective_end_date,l_effdate+1);
4065: */
4066: cursor cur_pos_definitions(p_position_definition_id number) is
4067: select pd.*
4068: from per_position_definitions pd
4069: where pd.position_definition_id = p_position_definition_id;
4070: --
4071: l_address_row per_addresses%rowtype;
4072: cursor cur_addr(p_person_id number) is