110: ,rt_mode varchar2(10)
111: );
112: --
113: g_old_rt_id number := -1;
114: g_to_be_uploaded_eed date := hr_api.g_eot;
115: rec_uploaded rt_record;
116: l_call_set_end_date boolean := true;
117: --
118: TYPE rtu_record IS RECORD(rtu_id number
127: ,rtu_mode varchar2(10)
128: );
129: --
130: g_old_rtu_id number := -1;
131: g_rtu_to_be_uploaded_eed date := hr_api.g_eot;
132: rec_rtu_uploaded rtu_record;
133: l_call_rtu_set_end_date boolean := true;
134: --
135: TYPE g_rtopm_record IS RECORD
136: (old_rom_id number(9) default -1
137: ,new_rom_id number(9) default -1
138: ,new_esd date
139: ,old_esd date
140: ,new_eed date default hr_api.g_eot
141: ,old_eed date default hr_api.g_eot
142: ,ovn number(9)
143: );
144: --
137: ,new_rom_id number(9) default -1
138: ,new_esd date
139: ,old_esd date
140: ,new_eed date default hr_api.g_eot
141: ,old_eed date default hr_api.g_eot
142: ,ovn number(9)
143: );
144: --
145: G_ROM_REC g_rtopm_record;
148: (old_etu_id number(9) default -1
149: ,new_etu_id number(9) default -1
150: ,new_esd date
151: ,old_esd date
152: ,new_eed date default hr_api.g_eot
153: ,old_eed date default hr_api.g_eot
154: ,ovn number(9)
155: ,l_mode varchar2(30)
156: );
149: ,new_etu_id number(9) default -1
150: ,new_esd date
151: ,old_esd date
152: ,new_eed date default hr_api.g_eot
153: ,old_eed date default hr_api.g_eot
154: ,ovn number(9)
155: ,l_mode varchar2(30)
156: );
157: --