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