[Home] [Help]
3563: procedure insert_element_entries(
3564: p_transfer_name varchar2,
3565: p_person_id number,
3566: p_effective_date date,
3567: p_element in out nocopy ghr_mt_element_entries_v%rowtype)
3568: is
3569:
3570: l_proc varchar2(72) := g_package||'insert_element_entries';
3571: l_fegli_meaning hr_lookups.meaning%type;
3602: l_retirement_plan_meaning := get_code_meaning (
3603: p_lookup_type => 'GHR_US_RETIREMENT_PLAN',
3604: p_lookup_code => p_element.retirement_plan);
3605:
3606: insert into ghr_mt_element_entries_v (
3607: GHR_INTERFACE_ID,
3608: MT_PROCESS_DATE,
3609: MT_SOURCE,
3610: MT_EFFECTIVE_DATE,
3718: procedure update_element_entries(
3719: p_transfer_name varchar2,
3720: p_person_id number,
3721: p_effective_date date,
3722: p_element in out nocopy ghr_mt_element_entries_v%rowtype)
3723: is
3724:
3725: l_proc varchar2(72) := g_package||'update_element_entries';
3726: l_fegli_meaning hr_lookups.meaning%type;
3728: l_x varchar2(1);
3729:
3730: cursor cur_elements is
3731: select 'x'
3732: from ghr_mt_element_entries_v
3733: where mt_name = p_transfer_name
3734: and mt_person_id = to_char(p_person_id)
3735: for update;
3736:
3766: l_retirement_plan_meaning := get_code_meaning (
3767: p_lookup_type => 'GHR_US_RETIREMENT_PLAN',
3768: p_lookup_code => p_element.retirement_plan);
3769:
3770: update ghr_mt_element_entries_v
3771: set
3772: MT_EFFECTIVE_DATE = p_effective_date,
3773: TOTAL_SALARY = nvl(p_element.TOTAL_SALARY,TOTAL_SALARY),
3774: SALARY = nvl(p_element.SALARY,SALARY),
4046: ---------------
4047: l_people_row per_all_people_f%rowtype;
4048: l_position_row hr_all_positions_f%rowtype;
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;