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

Line 128: when hr_api.cannot_find_prog_unit then

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

Line 129: hr_api.cannot_find_prog_unit_error

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

Line 241: when hr_api.cannot_find_prog_unit then

237: ,p_criteria_score => p_criteria_score
238: ,p_criteria_weight => p_criteria_weight
239: );
240: exception
241: when hr_api.cannot_find_prog_unit then
242: hr_api.cannot_find_prog_unit_error
243: (p_module_name => 'CREATE_ELIG_COMPTNCY_PRTE'
244: ,p_hook_type => 'AP'
245: );

Line 242: hr_api.cannot_find_prog_unit_error

238: ,p_criteria_weight => p_criteria_weight
239: );
240: exception
241: when hr_api.cannot_find_prog_unit then
242: hr_api.cannot_find_prog_unit_error
243: (p_module_name => 'CREATE_ELIG_COMPTNCY_PRTE'
244: ,p_hook_type => 'AP'
245: );
246: --

Line 266: raise hr_api.validate_enabled;

262: --
263: -- When in validation only mode raise the Validate_Enabled exception
264: --
265: if p_validate then
266: raise hr_api.validate_enabled;
267: end if;
268: --
269: -- Set all output arguments
270: --

Line 280: when hr_api.validate_enabled then

276: hr_utility.set_location(' Leaving:'||l_proc, 70);
277: --
278: exception
279: --
280: when hr_api.validate_enabled then
281: --
282: -- As the Validate_Enabled exception has been raised
283: -- we must rollback to the savepoint
284: --

Line 320: ,p_excld_flag in varchar2 default hr_api.g_varchar2

316: (p_validate in boolean default false
317: ,p_ELIG_COMPTNCY_PRTE_id in number
318: ,p_effective_start_date out nocopy date
319: ,p_effective_end_date out nocopy date
320: ,p_excld_flag in varchar2 default hr_api.g_varchar2
321: ,p_ordr_num in number default hr_api.g_number
322: ,p_competence_id in number default hr_api.g_number
323: ,p_rating_level_id in number default hr_api.g_number
324: ,p_eligy_prfl_id in number default hr_api.g_number

Line 321: ,p_ordr_num in number default hr_api.g_number

317: ,p_ELIG_COMPTNCY_PRTE_id in number
318: ,p_effective_start_date out nocopy date
319: ,p_effective_end_date out nocopy date
320: ,p_excld_flag in varchar2 default hr_api.g_varchar2
321: ,p_ordr_num in number default hr_api.g_number
322: ,p_competence_id in number default hr_api.g_number
323: ,p_rating_level_id in number default hr_api.g_number
324: ,p_eligy_prfl_id in number default hr_api.g_number
325: ,p_business_group_id in number default hr_api.g_number

Line 322: ,p_competence_id in number default hr_api.g_number

318: ,p_effective_start_date out nocopy date
319: ,p_effective_end_date out nocopy date
320: ,p_excld_flag in varchar2 default hr_api.g_varchar2
321: ,p_ordr_num in number default hr_api.g_number
322: ,p_competence_id in number default hr_api.g_number
323: ,p_rating_level_id in number default hr_api.g_number
324: ,p_eligy_prfl_id in number default hr_api.g_number
325: ,p_business_group_id in number default hr_api.g_number
326: ,p_ecy_attribute_category in varchar2 default hr_api.g_varchar2

Line 323: ,p_rating_level_id in number default hr_api.g_number

319: ,p_effective_end_date out nocopy date
320: ,p_excld_flag in varchar2 default hr_api.g_varchar2
321: ,p_ordr_num in number default hr_api.g_number
322: ,p_competence_id in number default hr_api.g_number
323: ,p_rating_level_id in number default hr_api.g_number
324: ,p_eligy_prfl_id in number default hr_api.g_number
325: ,p_business_group_id in number default hr_api.g_number
326: ,p_ecy_attribute_category in varchar2 default hr_api.g_varchar2
327: ,p_ecy_attribute1 in varchar2 default hr_api.g_varchar2

Line 324: ,p_eligy_prfl_id in number default hr_api.g_number

320: ,p_excld_flag in varchar2 default hr_api.g_varchar2
321: ,p_ordr_num in number default hr_api.g_number
322: ,p_competence_id in number default hr_api.g_number
323: ,p_rating_level_id in number default hr_api.g_number
324: ,p_eligy_prfl_id in number default hr_api.g_number
325: ,p_business_group_id in number default hr_api.g_number
326: ,p_ecy_attribute_category in varchar2 default hr_api.g_varchar2
327: ,p_ecy_attribute1 in varchar2 default hr_api.g_varchar2
328: ,p_ecy_attribute2 in varchar2 default hr_api.g_varchar2

Line 325: ,p_business_group_id in number default hr_api.g_number

321: ,p_ordr_num in number default hr_api.g_number
322: ,p_competence_id in number default hr_api.g_number
323: ,p_rating_level_id in number default hr_api.g_number
324: ,p_eligy_prfl_id in number default hr_api.g_number
325: ,p_business_group_id in number default hr_api.g_number
326: ,p_ecy_attribute_category in varchar2 default hr_api.g_varchar2
327: ,p_ecy_attribute1 in varchar2 default hr_api.g_varchar2
328: ,p_ecy_attribute2 in varchar2 default hr_api.g_varchar2
329: ,p_ecy_attribute3 in varchar2 default hr_api.g_varchar2

Line 326: ,p_ecy_attribute_category in varchar2 default hr_api.g_varchar2

322: ,p_competence_id in number default hr_api.g_number
323: ,p_rating_level_id in number default hr_api.g_number
324: ,p_eligy_prfl_id in number default hr_api.g_number
325: ,p_business_group_id in number default hr_api.g_number
326: ,p_ecy_attribute_category in varchar2 default hr_api.g_varchar2
327: ,p_ecy_attribute1 in varchar2 default hr_api.g_varchar2
328: ,p_ecy_attribute2 in varchar2 default hr_api.g_varchar2
329: ,p_ecy_attribute3 in varchar2 default hr_api.g_varchar2
330: ,p_ecy_attribute4 in varchar2 default hr_api.g_varchar2

Line 327: ,p_ecy_attribute1 in varchar2 default hr_api.g_varchar2

323: ,p_rating_level_id in number default hr_api.g_number
324: ,p_eligy_prfl_id in number default hr_api.g_number
325: ,p_business_group_id in number default hr_api.g_number
326: ,p_ecy_attribute_category in varchar2 default hr_api.g_varchar2
327: ,p_ecy_attribute1 in varchar2 default hr_api.g_varchar2
328: ,p_ecy_attribute2 in varchar2 default hr_api.g_varchar2
329: ,p_ecy_attribute3 in varchar2 default hr_api.g_varchar2
330: ,p_ecy_attribute4 in varchar2 default hr_api.g_varchar2
331: ,p_ecy_attribute5 in varchar2 default hr_api.g_varchar2

Line 328: ,p_ecy_attribute2 in varchar2 default hr_api.g_varchar2

324: ,p_eligy_prfl_id in number default hr_api.g_number
325: ,p_business_group_id in number default hr_api.g_number
326: ,p_ecy_attribute_category in varchar2 default hr_api.g_varchar2
327: ,p_ecy_attribute1 in varchar2 default hr_api.g_varchar2
328: ,p_ecy_attribute2 in varchar2 default hr_api.g_varchar2
329: ,p_ecy_attribute3 in varchar2 default hr_api.g_varchar2
330: ,p_ecy_attribute4 in varchar2 default hr_api.g_varchar2
331: ,p_ecy_attribute5 in varchar2 default hr_api.g_varchar2
332: ,p_ecy_attribute6 in varchar2 default hr_api.g_varchar2

Line 329: ,p_ecy_attribute3 in varchar2 default hr_api.g_varchar2

325: ,p_business_group_id in number default hr_api.g_number
326: ,p_ecy_attribute_category in varchar2 default hr_api.g_varchar2
327: ,p_ecy_attribute1 in varchar2 default hr_api.g_varchar2
328: ,p_ecy_attribute2 in varchar2 default hr_api.g_varchar2
329: ,p_ecy_attribute3 in varchar2 default hr_api.g_varchar2
330: ,p_ecy_attribute4 in varchar2 default hr_api.g_varchar2
331: ,p_ecy_attribute5 in varchar2 default hr_api.g_varchar2
332: ,p_ecy_attribute6 in varchar2 default hr_api.g_varchar2
333: ,p_ecy_attribute7 in varchar2 default hr_api.g_varchar2

Line 330: ,p_ecy_attribute4 in varchar2 default hr_api.g_varchar2

326: ,p_ecy_attribute_category in varchar2 default hr_api.g_varchar2
327: ,p_ecy_attribute1 in varchar2 default hr_api.g_varchar2
328: ,p_ecy_attribute2 in varchar2 default hr_api.g_varchar2
329: ,p_ecy_attribute3 in varchar2 default hr_api.g_varchar2
330: ,p_ecy_attribute4 in varchar2 default hr_api.g_varchar2
331: ,p_ecy_attribute5 in varchar2 default hr_api.g_varchar2
332: ,p_ecy_attribute6 in varchar2 default hr_api.g_varchar2
333: ,p_ecy_attribute7 in varchar2 default hr_api.g_varchar2
334: ,p_ecy_attribute8 in varchar2 default hr_api.g_varchar2

Line 331: ,p_ecy_attribute5 in varchar2 default hr_api.g_varchar2

327: ,p_ecy_attribute1 in varchar2 default hr_api.g_varchar2
328: ,p_ecy_attribute2 in varchar2 default hr_api.g_varchar2
329: ,p_ecy_attribute3 in varchar2 default hr_api.g_varchar2
330: ,p_ecy_attribute4 in varchar2 default hr_api.g_varchar2
331: ,p_ecy_attribute5 in varchar2 default hr_api.g_varchar2
332: ,p_ecy_attribute6 in varchar2 default hr_api.g_varchar2
333: ,p_ecy_attribute7 in varchar2 default hr_api.g_varchar2
334: ,p_ecy_attribute8 in varchar2 default hr_api.g_varchar2
335: ,p_ecy_attribute9 in varchar2 default hr_api.g_varchar2

Line 332: ,p_ecy_attribute6 in varchar2 default hr_api.g_varchar2

328: ,p_ecy_attribute2 in varchar2 default hr_api.g_varchar2
329: ,p_ecy_attribute3 in varchar2 default hr_api.g_varchar2
330: ,p_ecy_attribute4 in varchar2 default hr_api.g_varchar2
331: ,p_ecy_attribute5 in varchar2 default hr_api.g_varchar2
332: ,p_ecy_attribute6 in varchar2 default hr_api.g_varchar2
333: ,p_ecy_attribute7 in varchar2 default hr_api.g_varchar2
334: ,p_ecy_attribute8 in varchar2 default hr_api.g_varchar2
335: ,p_ecy_attribute9 in varchar2 default hr_api.g_varchar2
336: ,p_ecy_attribute10 in varchar2 default hr_api.g_varchar2

Line 333: ,p_ecy_attribute7 in varchar2 default hr_api.g_varchar2

329: ,p_ecy_attribute3 in varchar2 default hr_api.g_varchar2
330: ,p_ecy_attribute4 in varchar2 default hr_api.g_varchar2
331: ,p_ecy_attribute5 in varchar2 default hr_api.g_varchar2
332: ,p_ecy_attribute6 in varchar2 default hr_api.g_varchar2
333: ,p_ecy_attribute7 in varchar2 default hr_api.g_varchar2
334: ,p_ecy_attribute8 in varchar2 default hr_api.g_varchar2
335: ,p_ecy_attribute9 in varchar2 default hr_api.g_varchar2
336: ,p_ecy_attribute10 in varchar2 default hr_api.g_varchar2
337: ,p_ecy_attribute11 in varchar2 default hr_api.g_varchar2

Line 334: ,p_ecy_attribute8 in varchar2 default hr_api.g_varchar2

330: ,p_ecy_attribute4 in varchar2 default hr_api.g_varchar2
331: ,p_ecy_attribute5 in varchar2 default hr_api.g_varchar2
332: ,p_ecy_attribute6 in varchar2 default hr_api.g_varchar2
333: ,p_ecy_attribute7 in varchar2 default hr_api.g_varchar2
334: ,p_ecy_attribute8 in varchar2 default hr_api.g_varchar2
335: ,p_ecy_attribute9 in varchar2 default hr_api.g_varchar2
336: ,p_ecy_attribute10 in varchar2 default hr_api.g_varchar2
337: ,p_ecy_attribute11 in varchar2 default hr_api.g_varchar2
338: ,p_ecy_attribute12 in varchar2 default hr_api.g_varchar2

Line 335: ,p_ecy_attribute9 in varchar2 default hr_api.g_varchar2

331: ,p_ecy_attribute5 in varchar2 default hr_api.g_varchar2
332: ,p_ecy_attribute6 in varchar2 default hr_api.g_varchar2
333: ,p_ecy_attribute7 in varchar2 default hr_api.g_varchar2
334: ,p_ecy_attribute8 in varchar2 default hr_api.g_varchar2
335: ,p_ecy_attribute9 in varchar2 default hr_api.g_varchar2
336: ,p_ecy_attribute10 in varchar2 default hr_api.g_varchar2
337: ,p_ecy_attribute11 in varchar2 default hr_api.g_varchar2
338: ,p_ecy_attribute12 in varchar2 default hr_api.g_varchar2
339: ,p_ecy_attribute13 in varchar2 default hr_api.g_varchar2

Line 336: ,p_ecy_attribute10 in varchar2 default hr_api.g_varchar2

332: ,p_ecy_attribute6 in varchar2 default hr_api.g_varchar2
333: ,p_ecy_attribute7 in varchar2 default hr_api.g_varchar2
334: ,p_ecy_attribute8 in varchar2 default hr_api.g_varchar2
335: ,p_ecy_attribute9 in varchar2 default hr_api.g_varchar2
336: ,p_ecy_attribute10 in varchar2 default hr_api.g_varchar2
337: ,p_ecy_attribute11 in varchar2 default hr_api.g_varchar2
338: ,p_ecy_attribute12 in varchar2 default hr_api.g_varchar2
339: ,p_ecy_attribute13 in varchar2 default hr_api.g_varchar2
340: ,p_ecy_attribute14 in varchar2 default hr_api.g_varchar2

Line 337: ,p_ecy_attribute11 in varchar2 default hr_api.g_varchar2

333: ,p_ecy_attribute7 in varchar2 default hr_api.g_varchar2
334: ,p_ecy_attribute8 in varchar2 default hr_api.g_varchar2
335: ,p_ecy_attribute9 in varchar2 default hr_api.g_varchar2
336: ,p_ecy_attribute10 in varchar2 default hr_api.g_varchar2
337: ,p_ecy_attribute11 in varchar2 default hr_api.g_varchar2
338: ,p_ecy_attribute12 in varchar2 default hr_api.g_varchar2
339: ,p_ecy_attribute13 in varchar2 default hr_api.g_varchar2
340: ,p_ecy_attribute14 in varchar2 default hr_api.g_varchar2
341: ,p_ecy_attribute15 in varchar2 default hr_api.g_varchar2

Line 338: ,p_ecy_attribute12 in varchar2 default hr_api.g_varchar2

334: ,p_ecy_attribute8 in varchar2 default hr_api.g_varchar2
335: ,p_ecy_attribute9 in varchar2 default hr_api.g_varchar2
336: ,p_ecy_attribute10 in varchar2 default hr_api.g_varchar2
337: ,p_ecy_attribute11 in varchar2 default hr_api.g_varchar2
338: ,p_ecy_attribute12 in varchar2 default hr_api.g_varchar2
339: ,p_ecy_attribute13 in varchar2 default hr_api.g_varchar2
340: ,p_ecy_attribute14 in varchar2 default hr_api.g_varchar2
341: ,p_ecy_attribute15 in varchar2 default hr_api.g_varchar2
342: ,p_ecy_attribute16 in varchar2 default hr_api.g_varchar2

Line 339: ,p_ecy_attribute13 in varchar2 default hr_api.g_varchar2

335: ,p_ecy_attribute9 in varchar2 default hr_api.g_varchar2
336: ,p_ecy_attribute10 in varchar2 default hr_api.g_varchar2
337: ,p_ecy_attribute11 in varchar2 default hr_api.g_varchar2
338: ,p_ecy_attribute12 in varchar2 default hr_api.g_varchar2
339: ,p_ecy_attribute13 in varchar2 default hr_api.g_varchar2
340: ,p_ecy_attribute14 in varchar2 default hr_api.g_varchar2
341: ,p_ecy_attribute15 in varchar2 default hr_api.g_varchar2
342: ,p_ecy_attribute16 in varchar2 default hr_api.g_varchar2
343: ,p_ecy_attribute17 in varchar2 default hr_api.g_varchar2

Line 340: ,p_ecy_attribute14 in varchar2 default hr_api.g_varchar2

336: ,p_ecy_attribute10 in varchar2 default hr_api.g_varchar2
337: ,p_ecy_attribute11 in varchar2 default hr_api.g_varchar2
338: ,p_ecy_attribute12 in varchar2 default hr_api.g_varchar2
339: ,p_ecy_attribute13 in varchar2 default hr_api.g_varchar2
340: ,p_ecy_attribute14 in varchar2 default hr_api.g_varchar2
341: ,p_ecy_attribute15 in varchar2 default hr_api.g_varchar2
342: ,p_ecy_attribute16 in varchar2 default hr_api.g_varchar2
343: ,p_ecy_attribute17 in varchar2 default hr_api.g_varchar2
344: ,p_ecy_attribute18 in varchar2 default hr_api.g_varchar2

Line 341: ,p_ecy_attribute15 in varchar2 default hr_api.g_varchar2

337: ,p_ecy_attribute11 in varchar2 default hr_api.g_varchar2
338: ,p_ecy_attribute12 in varchar2 default hr_api.g_varchar2
339: ,p_ecy_attribute13 in varchar2 default hr_api.g_varchar2
340: ,p_ecy_attribute14 in varchar2 default hr_api.g_varchar2
341: ,p_ecy_attribute15 in varchar2 default hr_api.g_varchar2
342: ,p_ecy_attribute16 in varchar2 default hr_api.g_varchar2
343: ,p_ecy_attribute17 in varchar2 default hr_api.g_varchar2
344: ,p_ecy_attribute18 in varchar2 default hr_api.g_varchar2
345: ,p_ecy_attribute19 in varchar2 default hr_api.g_varchar2

Line 342: ,p_ecy_attribute16 in varchar2 default hr_api.g_varchar2

338: ,p_ecy_attribute12 in varchar2 default hr_api.g_varchar2
339: ,p_ecy_attribute13 in varchar2 default hr_api.g_varchar2
340: ,p_ecy_attribute14 in varchar2 default hr_api.g_varchar2
341: ,p_ecy_attribute15 in varchar2 default hr_api.g_varchar2
342: ,p_ecy_attribute16 in varchar2 default hr_api.g_varchar2
343: ,p_ecy_attribute17 in varchar2 default hr_api.g_varchar2
344: ,p_ecy_attribute18 in varchar2 default hr_api.g_varchar2
345: ,p_ecy_attribute19 in varchar2 default hr_api.g_varchar2
346: ,p_ecy_attribute20 in varchar2 default hr_api.g_varchar2

Line 343: ,p_ecy_attribute17 in varchar2 default hr_api.g_varchar2

339: ,p_ecy_attribute13 in varchar2 default hr_api.g_varchar2
340: ,p_ecy_attribute14 in varchar2 default hr_api.g_varchar2
341: ,p_ecy_attribute15 in varchar2 default hr_api.g_varchar2
342: ,p_ecy_attribute16 in varchar2 default hr_api.g_varchar2
343: ,p_ecy_attribute17 in varchar2 default hr_api.g_varchar2
344: ,p_ecy_attribute18 in varchar2 default hr_api.g_varchar2
345: ,p_ecy_attribute19 in varchar2 default hr_api.g_varchar2
346: ,p_ecy_attribute20 in varchar2 default hr_api.g_varchar2
347: ,p_ecy_attribute21 in varchar2 default hr_api.g_varchar2

Line 344: ,p_ecy_attribute18 in varchar2 default hr_api.g_varchar2

340: ,p_ecy_attribute14 in varchar2 default hr_api.g_varchar2
341: ,p_ecy_attribute15 in varchar2 default hr_api.g_varchar2
342: ,p_ecy_attribute16 in varchar2 default hr_api.g_varchar2
343: ,p_ecy_attribute17 in varchar2 default hr_api.g_varchar2
344: ,p_ecy_attribute18 in varchar2 default hr_api.g_varchar2
345: ,p_ecy_attribute19 in varchar2 default hr_api.g_varchar2
346: ,p_ecy_attribute20 in varchar2 default hr_api.g_varchar2
347: ,p_ecy_attribute21 in varchar2 default hr_api.g_varchar2
348: ,p_ecy_attribute22 in varchar2 default hr_api.g_varchar2

Line 345: ,p_ecy_attribute19 in varchar2 default hr_api.g_varchar2

341: ,p_ecy_attribute15 in varchar2 default hr_api.g_varchar2
342: ,p_ecy_attribute16 in varchar2 default hr_api.g_varchar2
343: ,p_ecy_attribute17 in varchar2 default hr_api.g_varchar2
344: ,p_ecy_attribute18 in varchar2 default hr_api.g_varchar2
345: ,p_ecy_attribute19 in varchar2 default hr_api.g_varchar2
346: ,p_ecy_attribute20 in varchar2 default hr_api.g_varchar2
347: ,p_ecy_attribute21 in varchar2 default hr_api.g_varchar2
348: ,p_ecy_attribute22 in varchar2 default hr_api.g_varchar2
349: ,p_ecy_attribute23 in varchar2 default hr_api.g_varchar2

Line 346: ,p_ecy_attribute20 in varchar2 default hr_api.g_varchar2

342: ,p_ecy_attribute16 in varchar2 default hr_api.g_varchar2
343: ,p_ecy_attribute17 in varchar2 default hr_api.g_varchar2
344: ,p_ecy_attribute18 in varchar2 default hr_api.g_varchar2
345: ,p_ecy_attribute19 in varchar2 default hr_api.g_varchar2
346: ,p_ecy_attribute20 in varchar2 default hr_api.g_varchar2
347: ,p_ecy_attribute21 in varchar2 default hr_api.g_varchar2
348: ,p_ecy_attribute22 in varchar2 default hr_api.g_varchar2
349: ,p_ecy_attribute23 in varchar2 default hr_api.g_varchar2
350: ,p_ecy_attribute24 in varchar2 default hr_api.g_varchar2

Line 347: ,p_ecy_attribute21 in varchar2 default hr_api.g_varchar2

343: ,p_ecy_attribute17 in varchar2 default hr_api.g_varchar2
344: ,p_ecy_attribute18 in varchar2 default hr_api.g_varchar2
345: ,p_ecy_attribute19 in varchar2 default hr_api.g_varchar2
346: ,p_ecy_attribute20 in varchar2 default hr_api.g_varchar2
347: ,p_ecy_attribute21 in varchar2 default hr_api.g_varchar2
348: ,p_ecy_attribute22 in varchar2 default hr_api.g_varchar2
349: ,p_ecy_attribute23 in varchar2 default hr_api.g_varchar2
350: ,p_ecy_attribute24 in varchar2 default hr_api.g_varchar2
351: ,p_ecy_attribute25 in varchar2 default hr_api.g_varchar2

Line 348: ,p_ecy_attribute22 in varchar2 default hr_api.g_varchar2

344: ,p_ecy_attribute18 in varchar2 default hr_api.g_varchar2
345: ,p_ecy_attribute19 in varchar2 default hr_api.g_varchar2
346: ,p_ecy_attribute20 in varchar2 default hr_api.g_varchar2
347: ,p_ecy_attribute21 in varchar2 default hr_api.g_varchar2
348: ,p_ecy_attribute22 in varchar2 default hr_api.g_varchar2
349: ,p_ecy_attribute23 in varchar2 default hr_api.g_varchar2
350: ,p_ecy_attribute24 in varchar2 default hr_api.g_varchar2
351: ,p_ecy_attribute25 in varchar2 default hr_api.g_varchar2
352: ,p_ecy_attribute26 in varchar2 default hr_api.g_varchar2

Line 349: ,p_ecy_attribute23 in varchar2 default hr_api.g_varchar2

345: ,p_ecy_attribute19 in varchar2 default hr_api.g_varchar2
346: ,p_ecy_attribute20 in varchar2 default hr_api.g_varchar2
347: ,p_ecy_attribute21 in varchar2 default hr_api.g_varchar2
348: ,p_ecy_attribute22 in varchar2 default hr_api.g_varchar2
349: ,p_ecy_attribute23 in varchar2 default hr_api.g_varchar2
350: ,p_ecy_attribute24 in varchar2 default hr_api.g_varchar2
351: ,p_ecy_attribute25 in varchar2 default hr_api.g_varchar2
352: ,p_ecy_attribute26 in varchar2 default hr_api.g_varchar2
353: ,p_ecy_attribute27 in varchar2 default hr_api.g_varchar2

Line 350: ,p_ecy_attribute24 in varchar2 default hr_api.g_varchar2

346: ,p_ecy_attribute20 in varchar2 default hr_api.g_varchar2
347: ,p_ecy_attribute21 in varchar2 default hr_api.g_varchar2
348: ,p_ecy_attribute22 in varchar2 default hr_api.g_varchar2
349: ,p_ecy_attribute23 in varchar2 default hr_api.g_varchar2
350: ,p_ecy_attribute24 in varchar2 default hr_api.g_varchar2
351: ,p_ecy_attribute25 in varchar2 default hr_api.g_varchar2
352: ,p_ecy_attribute26 in varchar2 default hr_api.g_varchar2
353: ,p_ecy_attribute27 in varchar2 default hr_api.g_varchar2
354: ,p_ecy_attribute28 in varchar2 default hr_api.g_varchar2

Line 351: ,p_ecy_attribute25 in varchar2 default hr_api.g_varchar2

347: ,p_ecy_attribute21 in varchar2 default hr_api.g_varchar2
348: ,p_ecy_attribute22 in varchar2 default hr_api.g_varchar2
349: ,p_ecy_attribute23 in varchar2 default hr_api.g_varchar2
350: ,p_ecy_attribute24 in varchar2 default hr_api.g_varchar2
351: ,p_ecy_attribute25 in varchar2 default hr_api.g_varchar2
352: ,p_ecy_attribute26 in varchar2 default hr_api.g_varchar2
353: ,p_ecy_attribute27 in varchar2 default hr_api.g_varchar2
354: ,p_ecy_attribute28 in varchar2 default hr_api.g_varchar2
355: ,p_ecy_attribute29 in varchar2 default hr_api.g_varchar2

Line 352: ,p_ecy_attribute26 in varchar2 default hr_api.g_varchar2

348: ,p_ecy_attribute22 in varchar2 default hr_api.g_varchar2
349: ,p_ecy_attribute23 in varchar2 default hr_api.g_varchar2
350: ,p_ecy_attribute24 in varchar2 default hr_api.g_varchar2
351: ,p_ecy_attribute25 in varchar2 default hr_api.g_varchar2
352: ,p_ecy_attribute26 in varchar2 default hr_api.g_varchar2
353: ,p_ecy_attribute27 in varchar2 default hr_api.g_varchar2
354: ,p_ecy_attribute28 in varchar2 default hr_api.g_varchar2
355: ,p_ecy_attribute29 in varchar2 default hr_api.g_varchar2
356: ,p_ecy_attribute30 in varchar2 default hr_api.g_varchar2

Line 353: ,p_ecy_attribute27 in varchar2 default hr_api.g_varchar2

349: ,p_ecy_attribute23 in varchar2 default hr_api.g_varchar2
350: ,p_ecy_attribute24 in varchar2 default hr_api.g_varchar2
351: ,p_ecy_attribute25 in varchar2 default hr_api.g_varchar2
352: ,p_ecy_attribute26 in varchar2 default hr_api.g_varchar2
353: ,p_ecy_attribute27 in varchar2 default hr_api.g_varchar2
354: ,p_ecy_attribute28 in varchar2 default hr_api.g_varchar2
355: ,p_ecy_attribute29 in varchar2 default hr_api.g_varchar2
356: ,p_ecy_attribute30 in varchar2 default hr_api.g_varchar2
357: ,p_object_version_number in out nocopy number

Line 354: ,p_ecy_attribute28 in varchar2 default hr_api.g_varchar2

350: ,p_ecy_attribute24 in varchar2 default hr_api.g_varchar2
351: ,p_ecy_attribute25 in varchar2 default hr_api.g_varchar2
352: ,p_ecy_attribute26 in varchar2 default hr_api.g_varchar2
353: ,p_ecy_attribute27 in varchar2 default hr_api.g_varchar2
354: ,p_ecy_attribute28 in varchar2 default hr_api.g_varchar2
355: ,p_ecy_attribute29 in varchar2 default hr_api.g_varchar2
356: ,p_ecy_attribute30 in varchar2 default hr_api.g_varchar2
357: ,p_object_version_number in out nocopy number
358: ,p_effective_date in date

Line 355: ,p_ecy_attribute29 in varchar2 default hr_api.g_varchar2

351: ,p_ecy_attribute25 in varchar2 default hr_api.g_varchar2
352: ,p_ecy_attribute26 in varchar2 default hr_api.g_varchar2
353: ,p_ecy_attribute27 in varchar2 default hr_api.g_varchar2
354: ,p_ecy_attribute28 in varchar2 default hr_api.g_varchar2
355: ,p_ecy_attribute29 in varchar2 default hr_api.g_varchar2
356: ,p_ecy_attribute30 in varchar2 default hr_api.g_varchar2
357: ,p_object_version_number in out nocopy number
358: ,p_effective_date in date
359: ,p_datetrack_mode in varchar2

Line 356: ,p_ecy_attribute30 in varchar2 default hr_api.g_varchar2

352: ,p_ecy_attribute26 in varchar2 default hr_api.g_varchar2
353: ,p_ecy_attribute27 in varchar2 default hr_api.g_varchar2
354: ,p_ecy_attribute28 in varchar2 default hr_api.g_varchar2
355: ,p_ecy_attribute29 in varchar2 default hr_api.g_varchar2
356: ,p_ecy_attribute30 in varchar2 default hr_api.g_varchar2
357: ,p_object_version_number in out nocopy number
358: ,p_effective_date in date
359: ,p_datetrack_mode in varchar2
360: ,p_criteria_score in number default hr_api.g_number

Line 360: ,p_criteria_score in number default hr_api.g_number

356: ,p_ecy_attribute30 in varchar2 default hr_api.g_varchar2
357: ,p_object_version_number in out nocopy number
358: ,p_effective_date in date
359: ,p_datetrack_mode in varchar2
360: ,p_criteria_score in number default hr_api.g_number
361: ,p_criteria_weight in number default hr_api.g_number
362: ) is
363: --
364: -- Declare cursors and local variables

Line 361: ,p_criteria_weight in number default hr_api.g_number

357: ,p_object_version_number in out nocopy number
358: ,p_effective_date in date
359: ,p_datetrack_mode in varchar2
360: ,p_criteria_score in number default hr_api.g_number
361: ,p_criteria_weight in number default hr_api.g_number
362: ) is
363: --
364: -- Declare cursors and local variables
365: --

Line 436: when hr_api.cannot_find_prog_unit then

432: ,p_criteria_score => p_criteria_score
433: ,p_criteria_weight => p_criteria_weight
434: );
435: exception
436: when hr_api.cannot_find_prog_unit then
437: hr_api.cannot_find_prog_unit_error
438: (p_module_name => 'UPDATE_ELIG_COMPTNCY_PRTE'
439: ,p_hook_type => 'BP'
440: );

Line 437: hr_api.cannot_find_prog_unit_error

433: ,p_criteria_weight => p_criteria_weight
434: );
435: exception
436: when hr_api.cannot_find_prog_unit then
437: hr_api.cannot_find_prog_unit_error
438: (p_module_name => 'UPDATE_ELIG_COMPTNCY_PRTE'
439: ,p_hook_type => 'BP'
440: );
441: --

Line 548: when hr_api.cannot_find_prog_unit then

544: ,p_criteria_score => p_criteria_score
545: ,p_criteria_weight => p_criteria_weight
546: );
547: exception
548: when hr_api.cannot_find_prog_unit then
549: hr_api.cannot_find_prog_unit_error
550: (p_module_name => 'UPDATE_ELIG_COMPTNCY_PRTE'
551: ,p_hook_type => 'AP'
552: );

Line 549: hr_api.cannot_find_prog_unit_error

545: ,p_criteria_weight => p_criteria_weight
546: );
547: exception
548: when hr_api.cannot_find_prog_unit then
549: hr_api.cannot_find_prog_unit_error
550: (p_module_name => 'UPDATE_ELIG_COMPTNCY_PRTE'
551: ,p_hook_type => 'AP'
552: );
553: --

Line 563: raise hr_api.validate_enabled;

559: --
560: -- When in validation only mode raise the Validate_Enabled exception
561: --
562: if p_validate then
563: raise hr_api.validate_enabled;
564: end if;
565: --
566: -- Set all output arguments
567: --

Line 576: when hr_api.validate_enabled then

572: hr_utility.set_location(' Leaving:'||l_proc, 70);
573: --
574: exception
575: --
576: when hr_api.validate_enabled then
577: --
578: -- As the Validate_Enabled exception has been raised
579: -- we must rollback to the savepoint
580: --

Line 650: when hr_api.cannot_find_prog_unit then

646: ,p_effective_date => trunc(p_effective_date)
647: ,p_datetrack_mode => p_datetrack_mode
648: );
649: exception
650: when hr_api.cannot_find_prog_unit then
651: hr_api.cannot_find_prog_unit_error
652: (p_module_name => 'DELETE_ELIG_COMPTNCY_PRTE'
653: ,p_hook_type => 'BP'
654: );

Line 651: hr_api.cannot_find_prog_unit_error

647: ,p_datetrack_mode => p_datetrack_mode
648: );
649: exception
650: when hr_api.cannot_find_prog_unit then
651: hr_api.cannot_find_prog_unit_error
652: (p_module_name => 'DELETE_ELIG_COMPTNCY_PRTE'
653: ,p_hook_type => 'BP'
654: );
655: --

Line 684: when hr_api.cannot_find_prog_unit then

680: ,p_effective_date => trunc(p_effective_date)
681: ,p_datetrack_mode => p_datetrack_mode
682: );
683: exception
684: when hr_api.cannot_find_prog_unit then
685: hr_api.cannot_find_prog_unit_error
686: (p_module_name => 'DELETE_ELIG_COMPTNCY_PRTE'
687: ,p_hook_type => 'AP'
688: );

Line 685: hr_api.cannot_find_prog_unit_error

681: ,p_datetrack_mode => p_datetrack_mode
682: );
683: exception
684: when hr_api.cannot_find_prog_unit then
685: hr_api.cannot_find_prog_unit_error
686: (p_module_name => 'DELETE_ELIG_COMPTNCY_PRTE'
687: ,p_hook_type => 'AP'
688: );
689: --

Line 708: raise hr_api.validate_enabled;

704: --
705: -- When in validation only mode raise the Validate_Enabled exception
706: --
707: if p_validate then
708: raise hr_api.validate_enabled;
709: end if;
710: --
711: hr_utility.set_location(' Leaving:'||l_proc, 70);
712: --

Line 715: when hr_api.validate_enabled then

711: hr_utility.set_location(' Leaving:'||l_proc, 70);
712: --
713: exception
714: --
715: when hr_api.validate_enabled then
716: --
717: -- As the Validate_Enabled exception has been raised
718: -- we must rollback to the savepoint
719: --