DBA Data[Home] [Help]

APPS.IRC_IAD_SHD dependencies on HR_UTILITY

Line 130: hr_utility.set_location('Entering:'||l_proc, 5);

126: --
127: l_proc varchar2(72) := g_package||'find_dt_upd_modes';
128: --
129: Begin
130: hr_utility.set_location('Entering:'||l_proc, 5);
131: --
132: -- Call the corresponding datetrack api
133: --
134: dt_api.find_dt_upd_modes

Line 145: hr_utility.set_location(' Leaving:'||l_proc, 10);

141: ,p_update_override => p_update_override
142: ,p_update_change_insert => p_update_change_insert
143: );
144: --
145: hr_utility.set_location(' Leaving:'||l_proc, 10);
146: End find_dt_upd_modes;
147: --
148: -- ----------------------------------------------------------------------------
149: -- |---------------------------< find_dt_del_modes >--------------------------|

Line 165: hr_utility.set_location('Entering:'||l_proc, 5);

161: --
162: l_parent_key_value1 number;
163: --
164: Begin
165: hr_utility.set_location('Entering:'||l_proc, 5);
166: --
167: -- Base key value is also the parent key value in this case
168: --
169: l_parent_key_value1 := p_base_key_value;

Line 187: hr_utility.set_location(' Leaving:'||l_proc, 10);

183: ,p_future_change => p_future_change
184: ,p_delete_next_change => p_delete_next_change
185: );
186: --
187: hr_utility.set_location(' Leaving:'||l_proc, 10);
188: End find_dt_del_modes;
189: --
190: -- ----------------------------------------------------------------------------
191: -- |-----------------------< upd_effective_end_date >-------------------------|

Line 206: hr_utility.set_location('Entering:'||l_proc, 5);

202: l_proc varchar2(72) := g_package||'upd_effective_end_date';
203: l_object_version_number number;
204: --
205: Begin
206: hr_utility.set_location('Entering:'||l_proc, 5);
207: --
208: -- Because we are updating a row we must get the next object
209: -- version number.
210: --

Line 218: hr_utility.set_location(l_proc, 10);

214: ,p_base_key_column => 'assignment_id'
215: ,p_base_key_value => p_base_key_value
216: );
217: --
218: hr_utility.set_location(l_proc, 10);
219: --
220: --
221: -- Update the specified datetrack row setting the effective
222: -- end date to the specified new effective end date.

Line 233: hr_utility.set_location(' Leaving:'||l_proc, 15);

229: between t.effective_start_date and t.effective_end_date;
230: --
231: --
232: p_object_version_number := l_object_version_number;
233: hr_utility.set_location(' Leaving:'||l_proc, 15);
234: --
235: End upd_effective_end_date;
236: --
237: -- ----------------------------------------------------------------------------

Line 279: hr_utility.set_location('Entering:'||l_proc, 5);

275: order by details_version desc
276: for update nowait;
277: --
278: Begin
279: hr_utility.set_location('Entering:'||l_proc, 5);
280: --
281: -- Ensure that all the mandatory arguments are not null
282: --
283: hr_api.mandatory_arg_error(p_api_name => l_proc

Line 377: hr_utility.set_location(' Leaving:'||l_proc, 30);

373: --
374: p_validation_start_date := l_validation_start_date;
375: p_validation_end_date := l_validation_end_date;
376: --
377: hr_utility.set_location(' Leaving:'||l_proc, 30);
378: --
379: -- We need to trap the ORA LOCK exception
380: --
381: Exception