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