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