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_ELIG_SP_CLNG_PRG_PRTE_API dependencies on HR_API

Line 126: when hr_api.cannot_find_prog_unit then

122: ,p_criteria_score => p_criteria_score
123: ,p_criteria_weight => p_criteria_weight
124: );
125: exception
126: when hr_api.cannot_find_prog_unit then
127: hr_api.cannot_find_prog_unit_error
128: (
129: p_module_name => 'CREATE_elig_sp_clng_prg_prte'
130: ,p_hook_type => 'BP'

Line 127: hr_api.cannot_find_prog_unit_error

123: ,p_criteria_weight => p_criteria_weight
124: );
125: exception
126: when hr_api.cannot_find_prog_unit then
127: hr_api.cannot_find_prog_unit_error
128: (
129: p_module_name => 'CREATE_elig_sp_clng_prg_prte'
130: ,p_hook_type => 'BP'
131: );

Line 235: when hr_api.cannot_find_prog_unit then

231: ,p_criteria_score => p_criteria_score
232: ,p_criteria_weight => p_criteria_weight
233: );
234: exception
235: when hr_api.cannot_find_prog_unit then
236: hr_api.cannot_find_prog_unit_error
237: (p_module_name => 'CREATE_elig_sp_clng_prg_prte'
238: ,p_hook_type => 'AP'
239: );

Line 236: hr_api.cannot_find_prog_unit_error

232: ,p_criteria_weight => p_criteria_weight
233: );
234: exception
235: when hr_api.cannot_find_prog_unit then
236: hr_api.cannot_find_prog_unit_error
237: (p_module_name => 'CREATE_elig_sp_clng_prg_prte'
238: ,p_hook_type => 'AP'
239: );
240: --

Line 259: raise hr_api.validate_enabled;

255: --
256: -- When in validation only mode raise the Validate_Enabled exception
257: --
258: if p_validate then
259: raise hr_api.validate_enabled;
260: end if;
261: --
262: -- Set all output arguments
263: --

Line 273: when hr_api.validate_enabled then

269: hr_utility.set_location(' Leaving:'||l_proc, 70);
270: --
271: exception
272: --
273: when hr_api.validate_enabled then
274: --
275: -- As the Validate_Enabled exception has been raised
276: -- we must rollback to the savepoint
277: --

Line 314: ,p_excld_flag in varchar2 default hr_api.g_varchar2

310: (p_validate in boolean default false
311: ,p_elig_sp_clng_prg_prte_id in number
312: ,p_effective_start_date out nocopy date
313: ,p_effective_end_date out nocopy date
314: ,p_excld_flag in varchar2 default hr_api.g_varchar2
315: ,p_ordr_num in number default hr_api.g_number
316: ,p_special_ceiling_step_id in number default hr_api.g_number
317: ,p_eligy_prfl_id in number default hr_api.g_number
318: ,p_business_group_id in number default hr_api.g_number

Line 315: ,p_ordr_num in number default hr_api.g_number

311: ,p_elig_sp_clng_prg_prte_id in number
312: ,p_effective_start_date out nocopy date
313: ,p_effective_end_date out nocopy date
314: ,p_excld_flag in varchar2 default hr_api.g_varchar2
315: ,p_ordr_num in number default hr_api.g_number
316: ,p_special_ceiling_step_id in number default hr_api.g_number
317: ,p_eligy_prfl_id in number default hr_api.g_number
318: ,p_business_group_id in number default hr_api.g_number
319: ,p_esp_attribute_category in varchar2 default hr_api.g_varchar2

Line 316: ,p_special_ceiling_step_id in number default hr_api.g_number

312: ,p_effective_start_date out nocopy date
313: ,p_effective_end_date out nocopy date
314: ,p_excld_flag in varchar2 default hr_api.g_varchar2
315: ,p_ordr_num in number default hr_api.g_number
316: ,p_special_ceiling_step_id in number default hr_api.g_number
317: ,p_eligy_prfl_id in number default hr_api.g_number
318: ,p_business_group_id in number default hr_api.g_number
319: ,p_esp_attribute_category in varchar2 default hr_api.g_varchar2
320: ,p_esp_attribute1 in varchar2 default hr_api.g_varchar2

Line 317: ,p_eligy_prfl_id in number default hr_api.g_number

313: ,p_effective_end_date out nocopy date
314: ,p_excld_flag in varchar2 default hr_api.g_varchar2
315: ,p_ordr_num in number default hr_api.g_number
316: ,p_special_ceiling_step_id in number default hr_api.g_number
317: ,p_eligy_prfl_id in number default hr_api.g_number
318: ,p_business_group_id in number default hr_api.g_number
319: ,p_esp_attribute_category in varchar2 default hr_api.g_varchar2
320: ,p_esp_attribute1 in varchar2 default hr_api.g_varchar2
321: ,p_esp_attribute2 in varchar2 default hr_api.g_varchar2

Line 318: ,p_business_group_id in number default hr_api.g_number

314: ,p_excld_flag in varchar2 default hr_api.g_varchar2
315: ,p_ordr_num in number default hr_api.g_number
316: ,p_special_ceiling_step_id in number default hr_api.g_number
317: ,p_eligy_prfl_id in number default hr_api.g_number
318: ,p_business_group_id in number default hr_api.g_number
319: ,p_esp_attribute_category in varchar2 default hr_api.g_varchar2
320: ,p_esp_attribute1 in varchar2 default hr_api.g_varchar2
321: ,p_esp_attribute2 in varchar2 default hr_api.g_varchar2
322: ,p_esp_attribute3 in varchar2 default hr_api.g_varchar2

Line 319: ,p_esp_attribute_category in varchar2 default hr_api.g_varchar2

315: ,p_ordr_num in number default hr_api.g_number
316: ,p_special_ceiling_step_id in number default hr_api.g_number
317: ,p_eligy_prfl_id in number default hr_api.g_number
318: ,p_business_group_id in number default hr_api.g_number
319: ,p_esp_attribute_category in varchar2 default hr_api.g_varchar2
320: ,p_esp_attribute1 in varchar2 default hr_api.g_varchar2
321: ,p_esp_attribute2 in varchar2 default hr_api.g_varchar2
322: ,p_esp_attribute3 in varchar2 default hr_api.g_varchar2
323: ,p_esp_attribute4 in varchar2 default hr_api.g_varchar2

Line 320: ,p_esp_attribute1 in varchar2 default hr_api.g_varchar2

316: ,p_special_ceiling_step_id in number default hr_api.g_number
317: ,p_eligy_prfl_id in number default hr_api.g_number
318: ,p_business_group_id in number default hr_api.g_number
319: ,p_esp_attribute_category in varchar2 default hr_api.g_varchar2
320: ,p_esp_attribute1 in varchar2 default hr_api.g_varchar2
321: ,p_esp_attribute2 in varchar2 default hr_api.g_varchar2
322: ,p_esp_attribute3 in varchar2 default hr_api.g_varchar2
323: ,p_esp_attribute4 in varchar2 default hr_api.g_varchar2
324: ,p_esp_attribute5 in varchar2 default hr_api.g_varchar2

Line 321: ,p_esp_attribute2 in varchar2 default hr_api.g_varchar2

317: ,p_eligy_prfl_id in number default hr_api.g_number
318: ,p_business_group_id in number default hr_api.g_number
319: ,p_esp_attribute_category in varchar2 default hr_api.g_varchar2
320: ,p_esp_attribute1 in varchar2 default hr_api.g_varchar2
321: ,p_esp_attribute2 in varchar2 default hr_api.g_varchar2
322: ,p_esp_attribute3 in varchar2 default hr_api.g_varchar2
323: ,p_esp_attribute4 in varchar2 default hr_api.g_varchar2
324: ,p_esp_attribute5 in varchar2 default hr_api.g_varchar2
325: ,p_esp_attribute6 in varchar2 default hr_api.g_varchar2

Line 322: ,p_esp_attribute3 in varchar2 default hr_api.g_varchar2

318: ,p_business_group_id in number default hr_api.g_number
319: ,p_esp_attribute_category in varchar2 default hr_api.g_varchar2
320: ,p_esp_attribute1 in varchar2 default hr_api.g_varchar2
321: ,p_esp_attribute2 in varchar2 default hr_api.g_varchar2
322: ,p_esp_attribute3 in varchar2 default hr_api.g_varchar2
323: ,p_esp_attribute4 in varchar2 default hr_api.g_varchar2
324: ,p_esp_attribute5 in varchar2 default hr_api.g_varchar2
325: ,p_esp_attribute6 in varchar2 default hr_api.g_varchar2
326: ,p_esp_attribute7 in varchar2 default hr_api.g_varchar2

Line 323: ,p_esp_attribute4 in varchar2 default hr_api.g_varchar2

319: ,p_esp_attribute_category in varchar2 default hr_api.g_varchar2
320: ,p_esp_attribute1 in varchar2 default hr_api.g_varchar2
321: ,p_esp_attribute2 in varchar2 default hr_api.g_varchar2
322: ,p_esp_attribute3 in varchar2 default hr_api.g_varchar2
323: ,p_esp_attribute4 in varchar2 default hr_api.g_varchar2
324: ,p_esp_attribute5 in varchar2 default hr_api.g_varchar2
325: ,p_esp_attribute6 in varchar2 default hr_api.g_varchar2
326: ,p_esp_attribute7 in varchar2 default hr_api.g_varchar2
327: ,p_esp_attribute8 in varchar2 default hr_api.g_varchar2

Line 324: ,p_esp_attribute5 in varchar2 default hr_api.g_varchar2

320: ,p_esp_attribute1 in varchar2 default hr_api.g_varchar2
321: ,p_esp_attribute2 in varchar2 default hr_api.g_varchar2
322: ,p_esp_attribute3 in varchar2 default hr_api.g_varchar2
323: ,p_esp_attribute4 in varchar2 default hr_api.g_varchar2
324: ,p_esp_attribute5 in varchar2 default hr_api.g_varchar2
325: ,p_esp_attribute6 in varchar2 default hr_api.g_varchar2
326: ,p_esp_attribute7 in varchar2 default hr_api.g_varchar2
327: ,p_esp_attribute8 in varchar2 default hr_api.g_varchar2
328: ,p_esp_attribute9 in varchar2 default hr_api.g_varchar2

Line 325: ,p_esp_attribute6 in varchar2 default hr_api.g_varchar2

321: ,p_esp_attribute2 in varchar2 default hr_api.g_varchar2
322: ,p_esp_attribute3 in varchar2 default hr_api.g_varchar2
323: ,p_esp_attribute4 in varchar2 default hr_api.g_varchar2
324: ,p_esp_attribute5 in varchar2 default hr_api.g_varchar2
325: ,p_esp_attribute6 in varchar2 default hr_api.g_varchar2
326: ,p_esp_attribute7 in varchar2 default hr_api.g_varchar2
327: ,p_esp_attribute8 in varchar2 default hr_api.g_varchar2
328: ,p_esp_attribute9 in varchar2 default hr_api.g_varchar2
329: ,p_esp_attribute10 in varchar2 default hr_api.g_varchar2

Line 326: ,p_esp_attribute7 in varchar2 default hr_api.g_varchar2

322: ,p_esp_attribute3 in varchar2 default hr_api.g_varchar2
323: ,p_esp_attribute4 in varchar2 default hr_api.g_varchar2
324: ,p_esp_attribute5 in varchar2 default hr_api.g_varchar2
325: ,p_esp_attribute6 in varchar2 default hr_api.g_varchar2
326: ,p_esp_attribute7 in varchar2 default hr_api.g_varchar2
327: ,p_esp_attribute8 in varchar2 default hr_api.g_varchar2
328: ,p_esp_attribute9 in varchar2 default hr_api.g_varchar2
329: ,p_esp_attribute10 in varchar2 default hr_api.g_varchar2
330: ,p_esp_attribute11 in varchar2 default hr_api.g_varchar2

Line 327: ,p_esp_attribute8 in varchar2 default hr_api.g_varchar2

323: ,p_esp_attribute4 in varchar2 default hr_api.g_varchar2
324: ,p_esp_attribute5 in varchar2 default hr_api.g_varchar2
325: ,p_esp_attribute6 in varchar2 default hr_api.g_varchar2
326: ,p_esp_attribute7 in varchar2 default hr_api.g_varchar2
327: ,p_esp_attribute8 in varchar2 default hr_api.g_varchar2
328: ,p_esp_attribute9 in varchar2 default hr_api.g_varchar2
329: ,p_esp_attribute10 in varchar2 default hr_api.g_varchar2
330: ,p_esp_attribute11 in varchar2 default hr_api.g_varchar2
331: ,p_esp_attribute12 in varchar2 default hr_api.g_varchar2

Line 328: ,p_esp_attribute9 in varchar2 default hr_api.g_varchar2

324: ,p_esp_attribute5 in varchar2 default hr_api.g_varchar2
325: ,p_esp_attribute6 in varchar2 default hr_api.g_varchar2
326: ,p_esp_attribute7 in varchar2 default hr_api.g_varchar2
327: ,p_esp_attribute8 in varchar2 default hr_api.g_varchar2
328: ,p_esp_attribute9 in varchar2 default hr_api.g_varchar2
329: ,p_esp_attribute10 in varchar2 default hr_api.g_varchar2
330: ,p_esp_attribute11 in varchar2 default hr_api.g_varchar2
331: ,p_esp_attribute12 in varchar2 default hr_api.g_varchar2
332: ,p_esp_attribute13 in varchar2 default hr_api.g_varchar2

Line 329: ,p_esp_attribute10 in varchar2 default hr_api.g_varchar2

325: ,p_esp_attribute6 in varchar2 default hr_api.g_varchar2
326: ,p_esp_attribute7 in varchar2 default hr_api.g_varchar2
327: ,p_esp_attribute8 in varchar2 default hr_api.g_varchar2
328: ,p_esp_attribute9 in varchar2 default hr_api.g_varchar2
329: ,p_esp_attribute10 in varchar2 default hr_api.g_varchar2
330: ,p_esp_attribute11 in varchar2 default hr_api.g_varchar2
331: ,p_esp_attribute12 in varchar2 default hr_api.g_varchar2
332: ,p_esp_attribute13 in varchar2 default hr_api.g_varchar2
333: ,p_esp_attribute14 in varchar2 default hr_api.g_varchar2

Line 330: ,p_esp_attribute11 in varchar2 default hr_api.g_varchar2

326: ,p_esp_attribute7 in varchar2 default hr_api.g_varchar2
327: ,p_esp_attribute8 in varchar2 default hr_api.g_varchar2
328: ,p_esp_attribute9 in varchar2 default hr_api.g_varchar2
329: ,p_esp_attribute10 in varchar2 default hr_api.g_varchar2
330: ,p_esp_attribute11 in varchar2 default hr_api.g_varchar2
331: ,p_esp_attribute12 in varchar2 default hr_api.g_varchar2
332: ,p_esp_attribute13 in varchar2 default hr_api.g_varchar2
333: ,p_esp_attribute14 in varchar2 default hr_api.g_varchar2
334: ,p_esp_attribute15 in varchar2 default hr_api.g_varchar2

Line 331: ,p_esp_attribute12 in varchar2 default hr_api.g_varchar2

327: ,p_esp_attribute8 in varchar2 default hr_api.g_varchar2
328: ,p_esp_attribute9 in varchar2 default hr_api.g_varchar2
329: ,p_esp_attribute10 in varchar2 default hr_api.g_varchar2
330: ,p_esp_attribute11 in varchar2 default hr_api.g_varchar2
331: ,p_esp_attribute12 in varchar2 default hr_api.g_varchar2
332: ,p_esp_attribute13 in varchar2 default hr_api.g_varchar2
333: ,p_esp_attribute14 in varchar2 default hr_api.g_varchar2
334: ,p_esp_attribute15 in varchar2 default hr_api.g_varchar2
335: ,p_esp_attribute16 in varchar2 default hr_api.g_varchar2

Line 332: ,p_esp_attribute13 in varchar2 default hr_api.g_varchar2

328: ,p_esp_attribute9 in varchar2 default hr_api.g_varchar2
329: ,p_esp_attribute10 in varchar2 default hr_api.g_varchar2
330: ,p_esp_attribute11 in varchar2 default hr_api.g_varchar2
331: ,p_esp_attribute12 in varchar2 default hr_api.g_varchar2
332: ,p_esp_attribute13 in varchar2 default hr_api.g_varchar2
333: ,p_esp_attribute14 in varchar2 default hr_api.g_varchar2
334: ,p_esp_attribute15 in varchar2 default hr_api.g_varchar2
335: ,p_esp_attribute16 in varchar2 default hr_api.g_varchar2
336: ,p_esp_attribute17 in varchar2 default hr_api.g_varchar2

Line 333: ,p_esp_attribute14 in varchar2 default hr_api.g_varchar2

329: ,p_esp_attribute10 in varchar2 default hr_api.g_varchar2
330: ,p_esp_attribute11 in varchar2 default hr_api.g_varchar2
331: ,p_esp_attribute12 in varchar2 default hr_api.g_varchar2
332: ,p_esp_attribute13 in varchar2 default hr_api.g_varchar2
333: ,p_esp_attribute14 in varchar2 default hr_api.g_varchar2
334: ,p_esp_attribute15 in varchar2 default hr_api.g_varchar2
335: ,p_esp_attribute16 in varchar2 default hr_api.g_varchar2
336: ,p_esp_attribute17 in varchar2 default hr_api.g_varchar2
337: ,p_esp_attribute18 in varchar2 default hr_api.g_varchar2

Line 334: ,p_esp_attribute15 in varchar2 default hr_api.g_varchar2

330: ,p_esp_attribute11 in varchar2 default hr_api.g_varchar2
331: ,p_esp_attribute12 in varchar2 default hr_api.g_varchar2
332: ,p_esp_attribute13 in varchar2 default hr_api.g_varchar2
333: ,p_esp_attribute14 in varchar2 default hr_api.g_varchar2
334: ,p_esp_attribute15 in varchar2 default hr_api.g_varchar2
335: ,p_esp_attribute16 in varchar2 default hr_api.g_varchar2
336: ,p_esp_attribute17 in varchar2 default hr_api.g_varchar2
337: ,p_esp_attribute18 in varchar2 default hr_api.g_varchar2
338: ,p_esp_attribute19 in varchar2 default hr_api.g_varchar2

Line 335: ,p_esp_attribute16 in varchar2 default hr_api.g_varchar2

331: ,p_esp_attribute12 in varchar2 default hr_api.g_varchar2
332: ,p_esp_attribute13 in varchar2 default hr_api.g_varchar2
333: ,p_esp_attribute14 in varchar2 default hr_api.g_varchar2
334: ,p_esp_attribute15 in varchar2 default hr_api.g_varchar2
335: ,p_esp_attribute16 in varchar2 default hr_api.g_varchar2
336: ,p_esp_attribute17 in varchar2 default hr_api.g_varchar2
337: ,p_esp_attribute18 in varchar2 default hr_api.g_varchar2
338: ,p_esp_attribute19 in varchar2 default hr_api.g_varchar2
339: ,p_esp_attribute20 in varchar2 default hr_api.g_varchar2

Line 336: ,p_esp_attribute17 in varchar2 default hr_api.g_varchar2

332: ,p_esp_attribute13 in varchar2 default hr_api.g_varchar2
333: ,p_esp_attribute14 in varchar2 default hr_api.g_varchar2
334: ,p_esp_attribute15 in varchar2 default hr_api.g_varchar2
335: ,p_esp_attribute16 in varchar2 default hr_api.g_varchar2
336: ,p_esp_attribute17 in varchar2 default hr_api.g_varchar2
337: ,p_esp_attribute18 in varchar2 default hr_api.g_varchar2
338: ,p_esp_attribute19 in varchar2 default hr_api.g_varchar2
339: ,p_esp_attribute20 in varchar2 default hr_api.g_varchar2
340: ,p_esp_attribute21 in varchar2 default hr_api.g_varchar2

Line 337: ,p_esp_attribute18 in varchar2 default hr_api.g_varchar2

333: ,p_esp_attribute14 in varchar2 default hr_api.g_varchar2
334: ,p_esp_attribute15 in varchar2 default hr_api.g_varchar2
335: ,p_esp_attribute16 in varchar2 default hr_api.g_varchar2
336: ,p_esp_attribute17 in varchar2 default hr_api.g_varchar2
337: ,p_esp_attribute18 in varchar2 default hr_api.g_varchar2
338: ,p_esp_attribute19 in varchar2 default hr_api.g_varchar2
339: ,p_esp_attribute20 in varchar2 default hr_api.g_varchar2
340: ,p_esp_attribute21 in varchar2 default hr_api.g_varchar2
341: ,p_esp_attribute22 in varchar2 default hr_api.g_varchar2

Line 338: ,p_esp_attribute19 in varchar2 default hr_api.g_varchar2

334: ,p_esp_attribute15 in varchar2 default hr_api.g_varchar2
335: ,p_esp_attribute16 in varchar2 default hr_api.g_varchar2
336: ,p_esp_attribute17 in varchar2 default hr_api.g_varchar2
337: ,p_esp_attribute18 in varchar2 default hr_api.g_varchar2
338: ,p_esp_attribute19 in varchar2 default hr_api.g_varchar2
339: ,p_esp_attribute20 in varchar2 default hr_api.g_varchar2
340: ,p_esp_attribute21 in varchar2 default hr_api.g_varchar2
341: ,p_esp_attribute22 in varchar2 default hr_api.g_varchar2
342: ,p_esp_attribute23 in varchar2 default hr_api.g_varchar2

Line 339: ,p_esp_attribute20 in varchar2 default hr_api.g_varchar2

335: ,p_esp_attribute16 in varchar2 default hr_api.g_varchar2
336: ,p_esp_attribute17 in varchar2 default hr_api.g_varchar2
337: ,p_esp_attribute18 in varchar2 default hr_api.g_varchar2
338: ,p_esp_attribute19 in varchar2 default hr_api.g_varchar2
339: ,p_esp_attribute20 in varchar2 default hr_api.g_varchar2
340: ,p_esp_attribute21 in varchar2 default hr_api.g_varchar2
341: ,p_esp_attribute22 in varchar2 default hr_api.g_varchar2
342: ,p_esp_attribute23 in varchar2 default hr_api.g_varchar2
343: ,p_esp_attribute24 in varchar2 default hr_api.g_varchar2

Line 340: ,p_esp_attribute21 in varchar2 default hr_api.g_varchar2

336: ,p_esp_attribute17 in varchar2 default hr_api.g_varchar2
337: ,p_esp_attribute18 in varchar2 default hr_api.g_varchar2
338: ,p_esp_attribute19 in varchar2 default hr_api.g_varchar2
339: ,p_esp_attribute20 in varchar2 default hr_api.g_varchar2
340: ,p_esp_attribute21 in varchar2 default hr_api.g_varchar2
341: ,p_esp_attribute22 in varchar2 default hr_api.g_varchar2
342: ,p_esp_attribute23 in varchar2 default hr_api.g_varchar2
343: ,p_esp_attribute24 in varchar2 default hr_api.g_varchar2
344: ,p_esp_attribute25 in varchar2 default hr_api.g_varchar2

Line 341: ,p_esp_attribute22 in varchar2 default hr_api.g_varchar2

337: ,p_esp_attribute18 in varchar2 default hr_api.g_varchar2
338: ,p_esp_attribute19 in varchar2 default hr_api.g_varchar2
339: ,p_esp_attribute20 in varchar2 default hr_api.g_varchar2
340: ,p_esp_attribute21 in varchar2 default hr_api.g_varchar2
341: ,p_esp_attribute22 in varchar2 default hr_api.g_varchar2
342: ,p_esp_attribute23 in varchar2 default hr_api.g_varchar2
343: ,p_esp_attribute24 in varchar2 default hr_api.g_varchar2
344: ,p_esp_attribute25 in varchar2 default hr_api.g_varchar2
345: ,p_esp_attribute26 in varchar2 default hr_api.g_varchar2

Line 342: ,p_esp_attribute23 in varchar2 default hr_api.g_varchar2

338: ,p_esp_attribute19 in varchar2 default hr_api.g_varchar2
339: ,p_esp_attribute20 in varchar2 default hr_api.g_varchar2
340: ,p_esp_attribute21 in varchar2 default hr_api.g_varchar2
341: ,p_esp_attribute22 in varchar2 default hr_api.g_varchar2
342: ,p_esp_attribute23 in varchar2 default hr_api.g_varchar2
343: ,p_esp_attribute24 in varchar2 default hr_api.g_varchar2
344: ,p_esp_attribute25 in varchar2 default hr_api.g_varchar2
345: ,p_esp_attribute26 in varchar2 default hr_api.g_varchar2
346: ,p_esp_attribute27 in varchar2 default hr_api.g_varchar2

Line 343: ,p_esp_attribute24 in varchar2 default hr_api.g_varchar2

339: ,p_esp_attribute20 in varchar2 default hr_api.g_varchar2
340: ,p_esp_attribute21 in varchar2 default hr_api.g_varchar2
341: ,p_esp_attribute22 in varchar2 default hr_api.g_varchar2
342: ,p_esp_attribute23 in varchar2 default hr_api.g_varchar2
343: ,p_esp_attribute24 in varchar2 default hr_api.g_varchar2
344: ,p_esp_attribute25 in varchar2 default hr_api.g_varchar2
345: ,p_esp_attribute26 in varchar2 default hr_api.g_varchar2
346: ,p_esp_attribute27 in varchar2 default hr_api.g_varchar2
347: ,p_esp_attribute28 in varchar2 default hr_api.g_varchar2

Line 344: ,p_esp_attribute25 in varchar2 default hr_api.g_varchar2

340: ,p_esp_attribute21 in varchar2 default hr_api.g_varchar2
341: ,p_esp_attribute22 in varchar2 default hr_api.g_varchar2
342: ,p_esp_attribute23 in varchar2 default hr_api.g_varchar2
343: ,p_esp_attribute24 in varchar2 default hr_api.g_varchar2
344: ,p_esp_attribute25 in varchar2 default hr_api.g_varchar2
345: ,p_esp_attribute26 in varchar2 default hr_api.g_varchar2
346: ,p_esp_attribute27 in varchar2 default hr_api.g_varchar2
347: ,p_esp_attribute28 in varchar2 default hr_api.g_varchar2
348: ,p_esp_attribute29 in varchar2 default hr_api.g_varchar2

Line 345: ,p_esp_attribute26 in varchar2 default hr_api.g_varchar2

341: ,p_esp_attribute22 in varchar2 default hr_api.g_varchar2
342: ,p_esp_attribute23 in varchar2 default hr_api.g_varchar2
343: ,p_esp_attribute24 in varchar2 default hr_api.g_varchar2
344: ,p_esp_attribute25 in varchar2 default hr_api.g_varchar2
345: ,p_esp_attribute26 in varchar2 default hr_api.g_varchar2
346: ,p_esp_attribute27 in varchar2 default hr_api.g_varchar2
347: ,p_esp_attribute28 in varchar2 default hr_api.g_varchar2
348: ,p_esp_attribute29 in varchar2 default hr_api.g_varchar2
349: ,p_esp_attribute30 in varchar2 default hr_api.g_varchar2

Line 346: ,p_esp_attribute27 in varchar2 default hr_api.g_varchar2

342: ,p_esp_attribute23 in varchar2 default hr_api.g_varchar2
343: ,p_esp_attribute24 in varchar2 default hr_api.g_varchar2
344: ,p_esp_attribute25 in varchar2 default hr_api.g_varchar2
345: ,p_esp_attribute26 in varchar2 default hr_api.g_varchar2
346: ,p_esp_attribute27 in varchar2 default hr_api.g_varchar2
347: ,p_esp_attribute28 in varchar2 default hr_api.g_varchar2
348: ,p_esp_attribute29 in varchar2 default hr_api.g_varchar2
349: ,p_esp_attribute30 in varchar2 default hr_api.g_varchar2
350: ,p_object_version_number in out nocopy number

Line 347: ,p_esp_attribute28 in varchar2 default hr_api.g_varchar2

343: ,p_esp_attribute24 in varchar2 default hr_api.g_varchar2
344: ,p_esp_attribute25 in varchar2 default hr_api.g_varchar2
345: ,p_esp_attribute26 in varchar2 default hr_api.g_varchar2
346: ,p_esp_attribute27 in varchar2 default hr_api.g_varchar2
347: ,p_esp_attribute28 in varchar2 default hr_api.g_varchar2
348: ,p_esp_attribute29 in varchar2 default hr_api.g_varchar2
349: ,p_esp_attribute30 in varchar2 default hr_api.g_varchar2
350: ,p_object_version_number in out nocopy number
351: ,p_effective_date in date

Line 348: ,p_esp_attribute29 in varchar2 default hr_api.g_varchar2

344: ,p_esp_attribute25 in varchar2 default hr_api.g_varchar2
345: ,p_esp_attribute26 in varchar2 default hr_api.g_varchar2
346: ,p_esp_attribute27 in varchar2 default hr_api.g_varchar2
347: ,p_esp_attribute28 in varchar2 default hr_api.g_varchar2
348: ,p_esp_attribute29 in varchar2 default hr_api.g_varchar2
349: ,p_esp_attribute30 in varchar2 default hr_api.g_varchar2
350: ,p_object_version_number in out nocopy number
351: ,p_effective_date in date
352: ,p_datetrack_mode in varchar2

Line 349: ,p_esp_attribute30 in varchar2 default hr_api.g_varchar2

345: ,p_esp_attribute26 in varchar2 default hr_api.g_varchar2
346: ,p_esp_attribute27 in varchar2 default hr_api.g_varchar2
347: ,p_esp_attribute28 in varchar2 default hr_api.g_varchar2
348: ,p_esp_attribute29 in varchar2 default hr_api.g_varchar2
349: ,p_esp_attribute30 in varchar2 default hr_api.g_varchar2
350: ,p_object_version_number in out nocopy number
351: ,p_effective_date in date
352: ,p_datetrack_mode in varchar2
353: ,p_criteria_score in number default hr_api.g_number

Line 353: ,p_criteria_score in number default hr_api.g_number

349: ,p_esp_attribute30 in varchar2 default hr_api.g_varchar2
350: ,p_object_version_number in out nocopy number
351: ,p_effective_date in date
352: ,p_datetrack_mode in varchar2
353: ,p_criteria_score in number default hr_api.g_number
354: ,p_criteria_weight in number default hr_api.g_number
355: ) is
356: --
357: -- Declare cursors and local variables

Line 354: ,p_criteria_weight in number default hr_api.g_number

350: ,p_object_version_number in out nocopy number
351: ,p_effective_date in date
352: ,p_datetrack_mode in varchar2
353: ,p_criteria_score in number default hr_api.g_number
354: ,p_criteria_weight in number default hr_api.g_number
355: ) is
356: --
357: -- Declare cursors and local variables
358: --

Line 428: when hr_api.cannot_find_prog_unit then

424: ,p_criteria_score => p_criteria_score
425: ,p_criteria_weight => p_criteria_weight
426: );
427: exception
428: when hr_api.cannot_find_prog_unit then
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'UPDATE_elig_sp_clng_prg_prte'
431: ,p_hook_type => 'BP'
432: );

Line 429: hr_api.cannot_find_prog_unit_error

425: ,p_criteria_weight => p_criteria_weight
426: );
427: exception
428: when hr_api.cannot_find_prog_unit then
429: hr_api.cannot_find_prog_unit_error
430: (p_module_name => 'UPDATE_elig_sp_clng_prg_prte'
431: ,p_hook_type => 'BP'
432: );
433: --

Line 538: when hr_api.cannot_find_prog_unit then

534: ,p_criteria_score => p_criteria_score
535: ,p_criteria_weight => p_criteria_weight
536: );
537: exception
538: when hr_api.cannot_find_prog_unit then
539: hr_api.cannot_find_prog_unit_error
540: (p_module_name => 'UPDATE_elig_sp_clng_prg_prte'
541: ,p_hook_type => 'AP'
542: );

Line 539: hr_api.cannot_find_prog_unit_error

535: ,p_criteria_weight => p_criteria_weight
536: );
537: exception
538: when hr_api.cannot_find_prog_unit then
539: hr_api.cannot_find_prog_unit_error
540: (p_module_name => 'UPDATE_elig_sp_clng_prg_prte'
541: ,p_hook_type => 'AP'
542: );
543: --

Line 553: raise hr_api.validate_enabled;

549: --
550: -- When in validation only mode raise the Validate_Enabled exception
551: --
552: if p_validate then
553: raise hr_api.validate_enabled;
554: end if;
555: --
556: -- Set all output arguments
557: --

Line 566: when hr_api.validate_enabled then

562: hr_utility.set_location(' Leaving:'||l_proc, 70);
563: --
564: exception
565: --
566: when hr_api.validate_enabled then
567: --
568: -- As the Validate_Enabled exception has been raised
569: -- we must rollback to the savepoint
570: --

Line 641: when hr_api.cannot_find_prog_unit then

637: ,p_effective_date => trunc(p_effective_date)
638: ,p_datetrack_mode => p_datetrack_mode
639: );
640: exception
641: when hr_api.cannot_find_prog_unit then
642: hr_api.cannot_find_prog_unit_error
643: (p_module_name => 'DELETE_elig_sp_clng_prg_prte'
644: ,p_hook_type => 'BP'
645: );

Line 642: hr_api.cannot_find_prog_unit_error

638: ,p_datetrack_mode => p_datetrack_mode
639: );
640: exception
641: when hr_api.cannot_find_prog_unit then
642: hr_api.cannot_find_prog_unit_error
643: (p_module_name => 'DELETE_elig_sp_clng_prg_prte'
644: ,p_hook_type => 'BP'
645: );
646: --

Line 675: when hr_api.cannot_find_prog_unit then

671: ,p_effective_date => trunc(p_effective_date)
672: ,p_datetrack_mode => p_datetrack_mode
673: );
674: exception
675: when hr_api.cannot_find_prog_unit then
676: hr_api.cannot_find_prog_unit_error
677: (p_module_name => 'DELETE_elig_sp_clng_prg_prte'
678: ,p_hook_type => 'AP'
679: );

Line 676: hr_api.cannot_find_prog_unit_error

672: ,p_datetrack_mode => p_datetrack_mode
673: );
674: exception
675: when hr_api.cannot_find_prog_unit then
676: hr_api.cannot_find_prog_unit_error
677: (p_module_name => 'DELETE_elig_sp_clng_prg_prte'
678: ,p_hook_type => 'AP'
679: );
680: --

Line 699: raise hr_api.validate_enabled;

695: --
696: -- When in validation only mode raise the Validate_Enabled exception
697: --
698: if p_validate then
699: raise hr_api.validate_enabled;
700: end if;
701: --
702: hr_utility.set_location(' Leaving:'||l_proc, 70);
703: --

Line 706: when hr_api.validate_enabled then

702: hr_utility.set_location(' Leaving:'||l_proc, 70);
703: --
704: exception
705: --
706: when hr_api.validate_enabled then
707: --
708: -- As the Validate_Enabled exception has been raised
709: -- we must rollback to the savepoint
710: --