[Home] [Help]
123: --
124: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
125: --
126: Begin
127: hr_utility.set_location('Entering:'||l_proc, 5);
128: --
129: -- Call the corresponding datetrack api
130: --
131: dt_api.find_dt_upd_modes
138: ,p_update_override => p_update_override
139: ,p_update_change_insert => p_update_change_insert
140: );
141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 10);
143: End find_dt_upd_modes;
144: --
145: -- ----------------------------------------------------------------------------
146: -- |---------------------------< find_dt_del_modes >--------------------------|
166: and p_effective_date
167: between t.effective_start_date and t.effective_end_date;
168: --
169: Begin
170: hr_utility.set_location('Entering:'||l_proc, 5);
171: Open C_sel1;
172: Fetch C_Sel1 Into
173: l_parent_key_value1;
174: If C_Sel1%NOTFOUND then
195: ,p_future_change => p_future_change
196: ,p_delete_next_change => p_delete_next_change
197: );
198: --
199: hr_utility.set_location(' Leaving:'||l_proc, 10);
200: End find_dt_del_modes;
201: --
202: -- ----------------------------------------------------------------------------
203: -- |-----------------------< upd_effective_end_date >-------------------------|
214: l_proc varchar2(72) := g_package||'upd_effective_end_date';
215: l_object_version_number number;
216: --
217: Begin
218: hr_utility.set_location('Entering:'||l_proc, 5);
219: --
220: -- Because we are updating a row we must get the next object
221: -- version number.
222: --
226: ,p_base_key_column => 'elig_rslt_id'
227: ,p_base_key_value => p_base_key_value
228: );
229: --
230: hr_utility.set_location(l_proc, 10);
231: --
232: --
233: -- Update the specified datetrack row setting the effective
234: -- end date to the specified new effective end date.
241: between t.effective_start_date and t.effective_end_date;
242: --
243: --
244: p_object_version_number := l_object_version_number;
245: hr_utility.set_location(' Leaving:'||l_proc, 15);
246: --
247: End upd_effective_end_date;
248: --
249: -- ----------------------------------------------------------------------------
285: --
286: --
287: --
288: Begin
289: hr_utility.set_location('Entering:'||l_proc, 5);
290: --
291: -- Ensure that all the mandatory arguments are not null
292: --
293: hr_api.mandatory_arg_error(p_api_name => l_proc
366: --
367: p_validation_start_date := l_validation_start_date;
368: p_validation_end_date := l_validation_end_date;
369: --
370: hr_utility.set_location(' Leaving:'||l_proc, 30);
371: --
372: -- We need to trap the ORA LOCK exception
373: --
374: Exception