[Home] [Help]
3839:
3840: procedure insert_misc(p_transfer_name varchar2,
3841: p_person_id number,
3842: p_effective_date date,
3843: p_misc ghr_mt_misc_v%rowtype)
3844: is
3845:
3846: l_proc varchar2(72) := g_package||'insert_misc';
3847: l_table_name constant varchar2(30) := 'MISCELANEOUS';
3874: l_from_agency_code_desc := get_code_meaning (
3875: p_lookup_type => 'GHR_US_AGENCY_CODE',
3876: p_lookup_code => p_misc.from_agency_code);
3877:
3878: insert into ghr_mt_misc_v (
3879: GHR_INTERFACE_ID,
3880: MT_PROCESS_DATE,
3881: MT_SOURCE,
3882: MT_EFFECTIVE_DATE,
3933:
3934: procedure update_misc(p_transfer_name varchar2,
3935: p_person_id number,
3936: p_effective_date date,
3937: p_misc ghr_mt_misc_v%rowtype)
3938: is
3939:
3940: l_proc varchar2(72) := g_package||'update_misc';
3941: l_x varchar2(1);
3942: l_from_agency_code_desc varchar2(80);
3943:
3944: cursor cur_misc is
3945: select 'x'
3946: from ghr_mt_misc_v
3947: where mt_name = p_transfer_name
3948: and mt_person_id = to_char(p_person_id)
3949: for update;
3950:
3964: l_from_agency_code_desc := get_code_meaning (
3965: p_lookup_type => 'GHR_US_AGENCY_CODE',
3966: p_lookup_code => p_misc.from_agency_code);
3967:
3968: update ghr_mt_misc_v
3969: set
3970: MT_EFFECTIVE_DATE = p_effective_date,
3971: FROM_GRADE_OR_LEVEL = nvl(p_misc.FROM_GRADE_OR_LEVEL,FROM_GRADE_OR_LEVEL),
3972: FROM_PAY_PLAN = nvl(p_misc.FROM_PAY_PLAN,FROM_PAY_PLAN),
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;
4055: l_result_code varchar2(10);