eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EMPLOYEE_STATUS_RT_API dependencies on HR_API

Line 122: when hr_api.cannot_find_prog_unit then

118: ,p_esr_attribute30 => p_esr_attribute30
119: ,p_effective_date => trunc(p_effective_date)
120: );
121: exception
122: when hr_api.cannot_find_prog_unit then
123: hr_api.cannot_find_prog_unit_error
124: (
125: p_module_name => 'CREATE_EMPLOYEE_STATUS_RT'
126: ,p_hook_type => 'BP'

Line 123: hr_api.cannot_find_prog_unit_error

119: ,p_effective_date => trunc(p_effective_date)
120: );
121: exception
122: when hr_api.cannot_find_prog_unit then
123: hr_api.cannot_find_prog_unit_error
124: (
125: p_module_name => 'CREATE_EMPLOYEE_STATUS_RT'
126: ,p_hook_type => 'BP'
127: );

Line 227: when hr_api.cannot_find_prog_unit then

223: ,p_object_version_number => l_object_version_number
224: ,p_effective_date => trunc(p_effective_date)
225: );
226: exception
227: when hr_api.cannot_find_prog_unit then
228: hr_api.cannot_find_prog_unit_error
229: (p_module_name => 'CREATE_EMPLOYEE_STATUS_RT'
230: ,p_hook_type => 'AP'
231: );

Line 228: hr_api.cannot_find_prog_unit_error

224: ,p_effective_date => trunc(p_effective_date)
225: );
226: exception
227: when hr_api.cannot_find_prog_unit then
228: hr_api.cannot_find_prog_unit_error
229: (p_module_name => 'CREATE_EMPLOYEE_STATUS_RT'
230: ,p_hook_type => 'AP'
231: );
232: --

Line 251: raise hr_api.validate_enabled;

247: --
248: -- When in validation only mode raise the Validate_Enabled exception
249: --
250: if p_validate then
251: raise hr_api.validate_enabled;
252: end if;
253: --
254: -- Set all output arguments
255: --

Line 265: when hr_api.validate_enabled then

261: hr_utility.set_location(' Leaving:'||l_proc, 70);
262: --
263: exception
264: --
265: when hr_api.validate_enabled then
266: --
267: -- As the Validate_Enabled exception has been raised
268: -- we must rollback to the savepoint
269: --

Line 306: ,p_vrbl_rt_prfl_id in number default hr_api.g_number

302: (p_validate in boolean default false
303: ,p_ee_stat_rt_id in number
304: ,p_effective_start_date out nocopy date
305: ,p_effective_end_date out nocopy date
306: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
307: ,p_assignment_status_type_id in number default hr_api.g_number
308: ,p_excld_flag in varchar2 default hr_api.g_varchar2
309: ,p_ordr_num in number default hr_api.g_number
310: ,p_business_group_id in number default hr_api.g_number

Line 307: ,p_assignment_status_type_id in number default hr_api.g_number

303: ,p_ee_stat_rt_id in number
304: ,p_effective_start_date out nocopy date
305: ,p_effective_end_date out nocopy date
306: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
307: ,p_assignment_status_type_id in number default hr_api.g_number
308: ,p_excld_flag in varchar2 default hr_api.g_varchar2
309: ,p_ordr_num in number default hr_api.g_number
310: ,p_business_group_id in number default hr_api.g_number
311: ,p_esr_attribute_category in varchar2 default hr_api.g_varchar2

Line 308: ,p_excld_flag in varchar2 default hr_api.g_varchar2

304: ,p_effective_start_date out nocopy date
305: ,p_effective_end_date out nocopy date
306: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
307: ,p_assignment_status_type_id in number default hr_api.g_number
308: ,p_excld_flag in varchar2 default hr_api.g_varchar2
309: ,p_ordr_num in number default hr_api.g_number
310: ,p_business_group_id in number default hr_api.g_number
311: ,p_esr_attribute_category in varchar2 default hr_api.g_varchar2
312: ,p_esr_attribute1 in varchar2 default hr_api.g_varchar2

Line 309: ,p_ordr_num in number default hr_api.g_number

305: ,p_effective_end_date out nocopy date
306: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
307: ,p_assignment_status_type_id in number default hr_api.g_number
308: ,p_excld_flag in varchar2 default hr_api.g_varchar2
309: ,p_ordr_num in number default hr_api.g_number
310: ,p_business_group_id in number default hr_api.g_number
311: ,p_esr_attribute_category in varchar2 default hr_api.g_varchar2
312: ,p_esr_attribute1 in varchar2 default hr_api.g_varchar2
313: ,p_esr_attribute2 in varchar2 default hr_api.g_varchar2

Line 310: ,p_business_group_id in number default hr_api.g_number

306: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
307: ,p_assignment_status_type_id in number default hr_api.g_number
308: ,p_excld_flag in varchar2 default hr_api.g_varchar2
309: ,p_ordr_num in number default hr_api.g_number
310: ,p_business_group_id in number default hr_api.g_number
311: ,p_esr_attribute_category in varchar2 default hr_api.g_varchar2
312: ,p_esr_attribute1 in varchar2 default hr_api.g_varchar2
313: ,p_esr_attribute2 in varchar2 default hr_api.g_varchar2
314: ,p_esr_attribute3 in varchar2 default hr_api.g_varchar2

Line 311: ,p_esr_attribute_category in varchar2 default hr_api.g_varchar2

307: ,p_assignment_status_type_id in number default hr_api.g_number
308: ,p_excld_flag in varchar2 default hr_api.g_varchar2
309: ,p_ordr_num in number default hr_api.g_number
310: ,p_business_group_id in number default hr_api.g_number
311: ,p_esr_attribute_category in varchar2 default hr_api.g_varchar2
312: ,p_esr_attribute1 in varchar2 default hr_api.g_varchar2
313: ,p_esr_attribute2 in varchar2 default hr_api.g_varchar2
314: ,p_esr_attribute3 in varchar2 default hr_api.g_varchar2
315: ,p_esr_attribute4 in varchar2 default hr_api.g_varchar2

Line 312: ,p_esr_attribute1 in varchar2 default hr_api.g_varchar2

308: ,p_excld_flag in varchar2 default hr_api.g_varchar2
309: ,p_ordr_num in number default hr_api.g_number
310: ,p_business_group_id in number default hr_api.g_number
311: ,p_esr_attribute_category in varchar2 default hr_api.g_varchar2
312: ,p_esr_attribute1 in varchar2 default hr_api.g_varchar2
313: ,p_esr_attribute2 in varchar2 default hr_api.g_varchar2
314: ,p_esr_attribute3 in varchar2 default hr_api.g_varchar2
315: ,p_esr_attribute4 in varchar2 default hr_api.g_varchar2
316: ,p_esr_attribute5 in varchar2 default hr_api.g_varchar2

Line 313: ,p_esr_attribute2 in varchar2 default hr_api.g_varchar2

309: ,p_ordr_num in number default hr_api.g_number
310: ,p_business_group_id in number default hr_api.g_number
311: ,p_esr_attribute_category in varchar2 default hr_api.g_varchar2
312: ,p_esr_attribute1 in varchar2 default hr_api.g_varchar2
313: ,p_esr_attribute2 in varchar2 default hr_api.g_varchar2
314: ,p_esr_attribute3 in varchar2 default hr_api.g_varchar2
315: ,p_esr_attribute4 in varchar2 default hr_api.g_varchar2
316: ,p_esr_attribute5 in varchar2 default hr_api.g_varchar2
317: ,p_esr_attribute6 in varchar2 default hr_api.g_varchar2

Line 314: ,p_esr_attribute3 in varchar2 default hr_api.g_varchar2

310: ,p_business_group_id in number default hr_api.g_number
311: ,p_esr_attribute_category in varchar2 default hr_api.g_varchar2
312: ,p_esr_attribute1 in varchar2 default hr_api.g_varchar2
313: ,p_esr_attribute2 in varchar2 default hr_api.g_varchar2
314: ,p_esr_attribute3 in varchar2 default hr_api.g_varchar2
315: ,p_esr_attribute4 in varchar2 default hr_api.g_varchar2
316: ,p_esr_attribute5 in varchar2 default hr_api.g_varchar2
317: ,p_esr_attribute6 in varchar2 default hr_api.g_varchar2
318: ,p_esr_attribute7 in varchar2 default hr_api.g_varchar2

Line 315: ,p_esr_attribute4 in varchar2 default hr_api.g_varchar2

311: ,p_esr_attribute_category in varchar2 default hr_api.g_varchar2
312: ,p_esr_attribute1 in varchar2 default hr_api.g_varchar2
313: ,p_esr_attribute2 in varchar2 default hr_api.g_varchar2
314: ,p_esr_attribute3 in varchar2 default hr_api.g_varchar2
315: ,p_esr_attribute4 in varchar2 default hr_api.g_varchar2
316: ,p_esr_attribute5 in varchar2 default hr_api.g_varchar2
317: ,p_esr_attribute6 in varchar2 default hr_api.g_varchar2
318: ,p_esr_attribute7 in varchar2 default hr_api.g_varchar2
319: ,p_esr_attribute8 in varchar2 default hr_api.g_varchar2

Line 316: ,p_esr_attribute5 in varchar2 default hr_api.g_varchar2

312: ,p_esr_attribute1 in varchar2 default hr_api.g_varchar2
313: ,p_esr_attribute2 in varchar2 default hr_api.g_varchar2
314: ,p_esr_attribute3 in varchar2 default hr_api.g_varchar2
315: ,p_esr_attribute4 in varchar2 default hr_api.g_varchar2
316: ,p_esr_attribute5 in varchar2 default hr_api.g_varchar2
317: ,p_esr_attribute6 in varchar2 default hr_api.g_varchar2
318: ,p_esr_attribute7 in varchar2 default hr_api.g_varchar2
319: ,p_esr_attribute8 in varchar2 default hr_api.g_varchar2
320: ,p_esr_attribute9 in varchar2 default hr_api.g_varchar2

Line 317: ,p_esr_attribute6 in varchar2 default hr_api.g_varchar2

313: ,p_esr_attribute2 in varchar2 default hr_api.g_varchar2
314: ,p_esr_attribute3 in varchar2 default hr_api.g_varchar2
315: ,p_esr_attribute4 in varchar2 default hr_api.g_varchar2
316: ,p_esr_attribute5 in varchar2 default hr_api.g_varchar2
317: ,p_esr_attribute6 in varchar2 default hr_api.g_varchar2
318: ,p_esr_attribute7 in varchar2 default hr_api.g_varchar2
319: ,p_esr_attribute8 in varchar2 default hr_api.g_varchar2
320: ,p_esr_attribute9 in varchar2 default hr_api.g_varchar2
321: ,p_esr_attribute10 in varchar2 default hr_api.g_varchar2

Line 318: ,p_esr_attribute7 in varchar2 default hr_api.g_varchar2

314: ,p_esr_attribute3 in varchar2 default hr_api.g_varchar2
315: ,p_esr_attribute4 in varchar2 default hr_api.g_varchar2
316: ,p_esr_attribute5 in varchar2 default hr_api.g_varchar2
317: ,p_esr_attribute6 in varchar2 default hr_api.g_varchar2
318: ,p_esr_attribute7 in varchar2 default hr_api.g_varchar2
319: ,p_esr_attribute8 in varchar2 default hr_api.g_varchar2
320: ,p_esr_attribute9 in varchar2 default hr_api.g_varchar2
321: ,p_esr_attribute10 in varchar2 default hr_api.g_varchar2
322: ,p_esr_attribute11 in varchar2 default hr_api.g_varchar2

Line 319: ,p_esr_attribute8 in varchar2 default hr_api.g_varchar2

315: ,p_esr_attribute4 in varchar2 default hr_api.g_varchar2
316: ,p_esr_attribute5 in varchar2 default hr_api.g_varchar2
317: ,p_esr_attribute6 in varchar2 default hr_api.g_varchar2
318: ,p_esr_attribute7 in varchar2 default hr_api.g_varchar2
319: ,p_esr_attribute8 in varchar2 default hr_api.g_varchar2
320: ,p_esr_attribute9 in varchar2 default hr_api.g_varchar2
321: ,p_esr_attribute10 in varchar2 default hr_api.g_varchar2
322: ,p_esr_attribute11 in varchar2 default hr_api.g_varchar2
323: ,p_esr_attribute12 in varchar2 default hr_api.g_varchar2

Line 320: ,p_esr_attribute9 in varchar2 default hr_api.g_varchar2

316: ,p_esr_attribute5 in varchar2 default hr_api.g_varchar2
317: ,p_esr_attribute6 in varchar2 default hr_api.g_varchar2
318: ,p_esr_attribute7 in varchar2 default hr_api.g_varchar2
319: ,p_esr_attribute8 in varchar2 default hr_api.g_varchar2
320: ,p_esr_attribute9 in varchar2 default hr_api.g_varchar2
321: ,p_esr_attribute10 in varchar2 default hr_api.g_varchar2
322: ,p_esr_attribute11 in varchar2 default hr_api.g_varchar2
323: ,p_esr_attribute12 in varchar2 default hr_api.g_varchar2
324: ,p_esr_attribute13 in varchar2 default hr_api.g_varchar2

Line 321: ,p_esr_attribute10 in varchar2 default hr_api.g_varchar2

317: ,p_esr_attribute6 in varchar2 default hr_api.g_varchar2
318: ,p_esr_attribute7 in varchar2 default hr_api.g_varchar2
319: ,p_esr_attribute8 in varchar2 default hr_api.g_varchar2
320: ,p_esr_attribute9 in varchar2 default hr_api.g_varchar2
321: ,p_esr_attribute10 in varchar2 default hr_api.g_varchar2
322: ,p_esr_attribute11 in varchar2 default hr_api.g_varchar2
323: ,p_esr_attribute12 in varchar2 default hr_api.g_varchar2
324: ,p_esr_attribute13 in varchar2 default hr_api.g_varchar2
325: ,p_esr_attribute14 in varchar2 default hr_api.g_varchar2

Line 322: ,p_esr_attribute11 in varchar2 default hr_api.g_varchar2

318: ,p_esr_attribute7 in varchar2 default hr_api.g_varchar2
319: ,p_esr_attribute8 in varchar2 default hr_api.g_varchar2
320: ,p_esr_attribute9 in varchar2 default hr_api.g_varchar2
321: ,p_esr_attribute10 in varchar2 default hr_api.g_varchar2
322: ,p_esr_attribute11 in varchar2 default hr_api.g_varchar2
323: ,p_esr_attribute12 in varchar2 default hr_api.g_varchar2
324: ,p_esr_attribute13 in varchar2 default hr_api.g_varchar2
325: ,p_esr_attribute14 in varchar2 default hr_api.g_varchar2
326: ,p_esr_attribute15 in varchar2 default hr_api.g_varchar2

Line 323: ,p_esr_attribute12 in varchar2 default hr_api.g_varchar2

319: ,p_esr_attribute8 in varchar2 default hr_api.g_varchar2
320: ,p_esr_attribute9 in varchar2 default hr_api.g_varchar2
321: ,p_esr_attribute10 in varchar2 default hr_api.g_varchar2
322: ,p_esr_attribute11 in varchar2 default hr_api.g_varchar2
323: ,p_esr_attribute12 in varchar2 default hr_api.g_varchar2
324: ,p_esr_attribute13 in varchar2 default hr_api.g_varchar2
325: ,p_esr_attribute14 in varchar2 default hr_api.g_varchar2
326: ,p_esr_attribute15 in varchar2 default hr_api.g_varchar2
327: ,p_esr_attribute16 in varchar2 default hr_api.g_varchar2

Line 324: ,p_esr_attribute13 in varchar2 default hr_api.g_varchar2

320: ,p_esr_attribute9 in varchar2 default hr_api.g_varchar2
321: ,p_esr_attribute10 in varchar2 default hr_api.g_varchar2
322: ,p_esr_attribute11 in varchar2 default hr_api.g_varchar2
323: ,p_esr_attribute12 in varchar2 default hr_api.g_varchar2
324: ,p_esr_attribute13 in varchar2 default hr_api.g_varchar2
325: ,p_esr_attribute14 in varchar2 default hr_api.g_varchar2
326: ,p_esr_attribute15 in varchar2 default hr_api.g_varchar2
327: ,p_esr_attribute16 in varchar2 default hr_api.g_varchar2
328: ,p_esr_attribute17 in varchar2 default hr_api.g_varchar2

Line 325: ,p_esr_attribute14 in varchar2 default hr_api.g_varchar2

321: ,p_esr_attribute10 in varchar2 default hr_api.g_varchar2
322: ,p_esr_attribute11 in varchar2 default hr_api.g_varchar2
323: ,p_esr_attribute12 in varchar2 default hr_api.g_varchar2
324: ,p_esr_attribute13 in varchar2 default hr_api.g_varchar2
325: ,p_esr_attribute14 in varchar2 default hr_api.g_varchar2
326: ,p_esr_attribute15 in varchar2 default hr_api.g_varchar2
327: ,p_esr_attribute16 in varchar2 default hr_api.g_varchar2
328: ,p_esr_attribute17 in varchar2 default hr_api.g_varchar2
329: ,p_esr_attribute18 in varchar2 default hr_api.g_varchar2

Line 326: ,p_esr_attribute15 in varchar2 default hr_api.g_varchar2

322: ,p_esr_attribute11 in varchar2 default hr_api.g_varchar2
323: ,p_esr_attribute12 in varchar2 default hr_api.g_varchar2
324: ,p_esr_attribute13 in varchar2 default hr_api.g_varchar2
325: ,p_esr_attribute14 in varchar2 default hr_api.g_varchar2
326: ,p_esr_attribute15 in varchar2 default hr_api.g_varchar2
327: ,p_esr_attribute16 in varchar2 default hr_api.g_varchar2
328: ,p_esr_attribute17 in varchar2 default hr_api.g_varchar2
329: ,p_esr_attribute18 in varchar2 default hr_api.g_varchar2
330: ,p_esr_attribute19 in varchar2 default hr_api.g_varchar2

Line 327: ,p_esr_attribute16 in varchar2 default hr_api.g_varchar2

323: ,p_esr_attribute12 in varchar2 default hr_api.g_varchar2
324: ,p_esr_attribute13 in varchar2 default hr_api.g_varchar2
325: ,p_esr_attribute14 in varchar2 default hr_api.g_varchar2
326: ,p_esr_attribute15 in varchar2 default hr_api.g_varchar2
327: ,p_esr_attribute16 in varchar2 default hr_api.g_varchar2
328: ,p_esr_attribute17 in varchar2 default hr_api.g_varchar2
329: ,p_esr_attribute18 in varchar2 default hr_api.g_varchar2
330: ,p_esr_attribute19 in varchar2 default hr_api.g_varchar2
331: ,p_esr_attribute20 in varchar2 default hr_api.g_varchar2

Line 328: ,p_esr_attribute17 in varchar2 default hr_api.g_varchar2

324: ,p_esr_attribute13 in varchar2 default hr_api.g_varchar2
325: ,p_esr_attribute14 in varchar2 default hr_api.g_varchar2
326: ,p_esr_attribute15 in varchar2 default hr_api.g_varchar2
327: ,p_esr_attribute16 in varchar2 default hr_api.g_varchar2
328: ,p_esr_attribute17 in varchar2 default hr_api.g_varchar2
329: ,p_esr_attribute18 in varchar2 default hr_api.g_varchar2
330: ,p_esr_attribute19 in varchar2 default hr_api.g_varchar2
331: ,p_esr_attribute20 in varchar2 default hr_api.g_varchar2
332: ,p_esr_attribute21 in varchar2 default hr_api.g_varchar2

Line 329: ,p_esr_attribute18 in varchar2 default hr_api.g_varchar2

325: ,p_esr_attribute14 in varchar2 default hr_api.g_varchar2
326: ,p_esr_attribute15 in varchar2 default hr_api.g_varchar2
327: ,p_esr_attribute16 in varchar2 default hr_api.g_varchar2
328: ,p_esr_attribute17 in varchar2 default hr_api.g_varchar2
329: ,p_esr_attribute18 in varchar2 default hr_api.g_varchar2
330: ,p_esr_attribute19 in varchar2 default hr_api.g_varchar2
331: ,p_esr_attribute20 in varchar2 default hr_api.g_varchar2
332: ,p_esr_attribute21 in varchar2 default hr_api.g_varchar2
333: ,p_esr_attribute22 in varchar2 default hr_api.g_varchar2

Line 330: ,p_esr_attribute19 in varchar2 default hr_api.g_varchar2

326: ,p_esr_attribute15 in varchar2 default hr_api.g_varchar2
327: ,p_esr_attribute16 in varchar2 default hr_api.g_varchar2
328: ,p_esr_attribute17 in varchar2 default hr_api.g_varchar2
329: ,p_esr_attribute18 in varchar2 default hr_api.g_varchar2
330: ,p_esr_attribute19 in varchar2 default hr_api.g_varchar2
331: ,p_esr_attribute20 in varchar2 default hr_api.g_varchar2
332: ,p_esr_attribute21 in varchar2 default hr_api.g_varchar2
333: ,p_esr_attribute22 in varchar2 default hr_api.g_varchar2
334: ,p_esr_attribute23 in varchar2 default hr_api.g_varchar2

Line 331: ,p_esr_attribute20 in varchar2 default hr_api.g_varchar2

327: ,p_esr_attribute16 in varchar2 default hr_api.g_varchar2
328: ,p_esr_attribute17 in varchar2 default hr_api.g_varchar2
329: ,p_esr_attribute18 in varchar2 default hr_api.g_varchar2
330: ,p_esr_attribute19 in varchar2 default hr_api.g_varchar2
331: ,p_esr_attribute20 in varchar2 default hr_api.g_varchar2
332: ,p_esr_attribute21 in varchar2 default hr_api.g_varchar2
333: ,p_esr_attribute22 in varchar2 default hr_api.g_varchar2
334: ,p_esr_attribute23 in varchar2 default hr_api.g_varchar2
335: ,p_esr_attribute24 in varchar2 default hr_api.g_varchar2

Line 332: ,p_esr_attribute21 in varchar2 default hr_api.g_varchar2

328: ,p_esr_attribute17 in varchar2 default hr_api.g_varchar2
329: ,p_esr_attribute18 in varchar2 default hr_api.g_varchar2
330: ,p_esr_attribute19 in varchar2 default hr_api.g_varchar2
331: ,p_esr_attribute20 in varchar2 default hr_api.g_varchar2
332: ,p_esr_attribute21 in varchar2 default hr_api.g_varchar2
333: ,p_esr_attribute22 in varchar2 default hr_api.g_varchar2
334: ,p_esr_attribute23 in varchar2 default hr_api.g_varchar2
335: ,p_esr_attribute24 in varchar2 default hr_api.g_varchar2
336: ,p_esr_attribute25 in varchar2 default hr_api.g_varchar2

Line 333: ,p_esr_attribute22 in varchar2 default hr_api.g_varchar2

329: ,p_esr_attribute18 in varchar2 default hr_api.g_varchar2
330: ,p_esr_attribute19 in varchar2 default hr_api.g_varchar2
331: ,p_esr_attribute20 in varchar2 default hr_api.g_varchar2
332: ,p_esr_attribute21 in varchar2 default hr_api.g_varchar2
333: ,p_esr_attribute22 in varchar2 default hr_api.g_varchar2
334: ,p_esr_attribute23 in varchar2 default hr_api.g_varchar2
335: ,p_esr_attribute24 in varchar2 default hr_api.g_varchar2
336: ,p_esr_attribute25 in varchar2 default hr_api.g_varchar2
337: ,p_esr_attribute26 in varchar2 default hr_api.g_varchar2

Line 334: ,p_esr_attribute23 in varchar2 default hr_api.g_varchar2

330: ,p_esr_attribute19 in varchar2 default hr_api.g_varchar2
331: ,p_esr_attribute20 in varchar2 default hr_api.g_varchar2
332: ,p_esr_attribute21 in varchar2 default hr_api.g_varchar2
333: ,p_esr_attribute22 in varchar2 default hr_api.g_varchar2
334: ,p_esr_attribute23 in varchar2 default hr_api.g_varchar2
335: ,p_esr_attribute24 in varchar2 default hr_api.g_varchar2
336: ,p_esr_attribute25 in varchar2 default hr_api.g_varchar2
337: ,p_esr_attribute26 in varchar2 default hr_api.g_varchar2
338: ,p_esr_attribute27 in varchar2 default hr_api.g_varchar2

Line 335: ,p_esr_attribute24 in varchar2 default hr_api.g_varchar2

331: ,p_esr_attribute20 in varchar2 default hr_api.g_varchar2
332: ,p_esr_attribute21 in varchar2 default hr_api.g_varchar2
333: ,p_esr_attribute22 in varchar2 default hr_api.g_varchar2
334: ,p_esr_attribute23 in varchar2 default hr_api.g_varchar2
335: ,p_esr_attribute24 in varchar2 default hr_api.g_varchar2
336: ,p_esr_attribute25 in varchar2 default hr_api.g_varchar2
337: ,p_esr_attribute26 in varchar2 default hr_api.g_varchar2
338: ,p_esr_attribute27 in varchar2 default hr_api.g_varchar2
339: ,p_esr_attribute28 in varchar2 default hr_api.g_varchar2

Line 336: ,p_esr_attribute25 in varchar2 default hr_api.g_varchar2

332: ,p_esr_attribute21 in varchar2 default hr_api.g_varchar2
333: ,p_esr_attribute22 in varchar2 default hr_api.g_varchar2
334: ,p_esr_attribute23 in varchar2 default hr_api.g_varchar2
335: ,p_esr_attribute24 in varchar2 default hr_api.g_varchar2
336: ,p_esr_attribute25 in varchar2 default hr_api.g_varchar2
337: ,p_esr_attribute26 in varchar2 default hr_api.g_varchar2
338: ,p_esr_attribute27 in varchar2 default hr_api.g_varchar2
339: ,p_esr_attribute28 in varchar2 default hr_api.g_varchar2
340: ,p_esr_attribute29 in varchar2 default hr_api.g_varchar2

Line 337: ,p_esr_attribute26 in varchar2 default hr_api.g_varchar2

333: ,p_esr_attribute22 in varchar2 default hr_api.g_varchar2
334: ,p_esr_attribute23 in varchar2 default hr_api.g_varchar2
335: ,p_esr_attribute24 in varchar2 default hr_api.g_varchar2
336: ,p_esr_attribute25 in varchar2 default hr_api.g_varchar2
337: ,p_esr_attribute26 in varchar2 default hr_api.g_varchar2
338: ,p_esr_attribute27 in varchar2 default hr_api.g_varchar2
339: ,p_esr_attribute28 in varchar2 default hr_api.g_varchar2
340: ,p_esr_attribute29 in varchar2 default hr_api.g_varchar2
341: ,p_esr_attribute30 in varchar2 default hr_api.g_varchar2

Line 338: ,p_esr_attribute27 in varchar2 default hr_api.g_varchar2

334: ,p_esr_attribute23 in varchar2 default hr_api.g_varchar2
335: ,p_esr_attribute24 in varchar2 default hr_api.g_varchar2
336: ,p_esr_attribute25 in varchar2 default hr_api.g_varchar2
337: ,p_esr_attribute26 in varchar2 default hr_api.g_varchar2
338: ,p_esr_attribute27 in varchar2 default hr_api.g_varchar2
339: ,p_esr_attribute28 in varchar2 default hr_api.g_varchar2
340: ,p_esr_attribute29 in varchar2 default hr_api.g_varchar2
341: ,p_esr_attribute30 in varchar2 default hr_api.g_varchar2
342: ,p_object_version_number in out nocopy number

Line 339: ,p_esr_attribute28 in varchar2 default hr_api.g_varchar2

335: ,p_esr_attribute24 in varchar2 default hr_api.g_varchar2
336: ,p_esr_attribute25 in varchar2 default hr_api.g_varchar2
337: ,p_esr_attribute26 in varchar2 default hr_api.g_varchar2
338: ,p_esr_attribute27 in varchar2 default hr_api.g_varchar2
339: ,p_esr_attribute28 in varchar2 default hr_api.g_varchar2
340: ,p_esr_attribute29 in varchar2 default hr_api.g_varchar2
341: ,p_esr_attribute30 in varchar2 default hr_api.g_varchar2
342: ,p_object_version_number in out nocopy number
343: ,p_effective_date in date

Line 340: ,p_esr_attribute29 in varchar2 default hr_api.g_varchar2

336: ,p_esr_attribute25 in varchar2 default hr_api.g_varchar2
337: ,p_esr_attribute26 in varchar2 default hr_api.g_varchar2
338: ,p_esr_attribute27 in varchar2 default hr_api.g_varchar2
339: ,p_esr_attribute28 in varchar2 default hr_api.g_varchar2
340: ,p_esr_attribute29 in varchar2 default hr_api.g_varchar2
341: ,p_esr_attribute30 in varchar2 default hr_api.g_varchar2
342: ,p_object_version_number in out nocopy number
343: ,p_effective_date in date
344: ,p_datetrack_mode in varchar2

Line 341: ,p_esr_attribute30 in varchar2 default hr_api.g_varchar2

337: ,p_esr_attribute26 in varchar2 default hr_api.g_varchar2
338: ,p_esr_attribute27 in varchar2 default hr_api.g_varchar2
339: ,p_esr_attribute28 in varchar2 default hr_api.g_varchar2
340: ,p_esr_attribute29 in varchar2 default hr_api.g_varchar2
341: ,p_esr_attribute30 in varchar2 default hr_api.g_varchar2
342: ,p_object_version_number in out nocopy number
343: ,p_effective_date in date
344: ,p_datetrack_mode in varchar2
345: ) is

Line 416: when hr_api.cannot_find_prog_unit then

412: ,p_effective_date => trunc(p_effective_date)
413: ,p_datetrack_mode => p_datetrack_mode
414: );
415: exception
416: when hr_api.cannot_find_prog_unit then
417: hr_api.cannot_find_prog_unit_error
418: (p_module_name => 'UPDATE_EMPLOYEE_STATUS_RT'
419: ,p_hook_type => 'BP'
420: );

Line 417: hr_api.cannot_find_prog_unit_error

413: ,p_datetrack_mode => p_datetrack_mode
414: );
415: exception
416: when hr_api.cannot_find_prog_unit then
417: hr_api.cannot_find_prog_unit_error
418: (p_module_name => 'UPDATE_EMPLOYEE_STATUS_RT'
419: ,p_hook_type => 'BP'
420: );
421: --

Line 522: when hr_api.cannot_find_prog_unit then

518: ,p_effective_date => trunc(p_effective_date)
519: ,p_datetrack_mode => p_datetrack_mode
520: );
521: exception
522: when hr_api.cannot_find_prog_unit then
523: hr_api.cannot_find_prog_unit_error
524: (p_module_name => 'UPDATE_EMPLOYEE_STATUS_RT'
525: ,p_hook_type => 'AP'
526: );

Line 523: hr_api.cannot_find_prog_unit_error

519: ,p_datetrack_mode => p_datetrack_mode
520: );
521: exception
522: when hr_api.cannot_find_prog_unit then
523: hr_api.cannot_find_prog_unit_error
524: (p_module_name => 'UPDATE_EMPLOYEE_STATUS_RT'
525: ,p_hook_type => 'AP'
526: );
527: --

Line 537: raise hr_api.validate_enabled;

533: --
534: -- When in validation only mode raise the Validate_Enabled exception
535: --
536: if p_validate then
537: raise hr_api.validate_enabled;
538: end if;
539: --
540: -- Set all output arguments
541: --

Line 550: when hr_api.validate_enabled then

546: hr_utility.set_location(' Leaving:'||l_proc, 70);
547: --
548: exception
549: --
550: when hr_api.validate_enabled then
551: --
552: -- As the Validate_Enabled exception has been raised
553: -- we must rollback to the savepoint
554: --

Line 625: when hr_api.cannot_find_prog_unit then

621: ,p_effective_date => trunc(p_effective_date)
622: ,p_datetrack_mode => p_datetrack_mode
623: );
624: exception
625: when hr_api.cannot_find_prog_unit then
626: hr_api.cannot_find_prog_unit_error
627: (p_module_name => 'DELETE_EMPLOYEE_STATUS_RT'
628: ,p_hook_type => 'BP'
629: );

Line 626: hr_api.cannot_find_prog_unit_error

622: ,p_datetrack_mode => p_datetrack_mode
623: );
624: exception
625: when hr_api.cannot_find_prog_unit then
626: hr_api.cannot_find_prog_unit_error
627: (p_module_name => 'DELETE_EMPLOYEE_STATUS_RT'
628: ,p_hook_type => 'BP'
629: );
630: --

Line 659: when hr_api.cannot_find_prog_unit then

655: ,p_effective_date => trunc(p_effective_date)
656: ,p_datetrack_mode => p_datetrack_mode
657: );
658: exception
659: when hr_api.cannot_find_prog_unit then
660: hr_api.cannot_find_prog_unit_error
661: (p_module_name => 'DELETE_EMPLOYEE_STATUS_RT'
662: ,p_hook_type => 'AP'
663: );

Line 660: hr_api.cannot_find_prog_unit_error

656: ,p_datetrack_mode => p_datetrack_mode
657: );
658: exception
659: when hr_api.cannot_find_prog_unit then
660: hr_api.cannot_find_prog_unit_error
661: (p_module_name => 'DELETE_EMPLOYEE_STATUS_RT'
662: ,p_hook_type => 'AP'
663: );
664: --

Line 683: raise hr_api.validate_enabled;

679: --
680: -- When in validation only mode raise the Validate_Enabled exception
681: --
682: if p_validate then
683: raise hr_api.validate_enabled;
684: end if;
685: --
686: hr_utility.set_location(' Leaving:'||l_proc, 70);
687: --

Line 690: when hr_api.validate_enabled then

686: hr_utility.set_location(' Leaving:'||l_proc, 70);
687: --
688: exception
689: --
690: when hr_api.validate_enabled then
691: --
692: -- As the Validate_Enabled exception has been raised
693: -- we must rollback to the savepoint
694: --