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_QUAL_TITL_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_qual_titl_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_qual_titl_prte'
132: ,p_hook_type => 'BP'
133: );

Line 239: when hr_api.cannot_find_prog_unit then

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

Line 240: hr_api.cannot_find_prog_unit_error

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

Line 263: raise hr_api.validate_enabled;

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

Line 277: when hr_api.validate_enabled then

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

Line 315: ,p_business_group_id in number default hr_api.g_number

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

Line 316: ,p_eligy_prfl_id in number default hr_api.g_number

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

Line 317: ,p_ordr_num in number default hr_api.g_number

313: ,p_effective_start_date out nocopy date
314: ,p_effective_end_date out nocopy date
315: ,p_business_group_id in number default hr_api.g_number
316: ,p_eligy_prfl_id in number default hr_api.g_number
317: ,p_ordr_num in number default hr_api.g_number
318: ,p_excld_flag in varchar2 default hr_api.g_varchar2
319: ,p_qualification_type_id in number default hr_api.g_number
320: ,p_title in varchar2 default hr_api.g_varchar2
321: ,p_eqt_attribute_category in varchar2 default hr_api.g_varchar2

Line 318: ,p_excld_flag in varchar2 default hr_api.g_varchar2

314: ,p_effective_end_date out nocopy date
315: ,p_business_group_id in number default hr_api.g_number
316: ,p_eligy_prfl_id in number default hr_api.g_number
317: ,p_ordr_num in number default hr_api.g_number
318: ,p_excld_flag in varchar2 default hr_api.g_varchar2
319: ,p_qualification_type_id in number default hr_api.g_number
320: ,p_title in varchar2 default hr_api.g_varchar2
321: ,p_eqt_attribute_category in varchar2 default hr_api.g_varchar2
322: ,p_eqt_attribute1 in varchar2 default hr_api.g_varchar2

Line 319: ,p_qualification_type_id in number default hr_api.g_number

315: ,p_business_group_id in number default hr_api.g_number
316: ,p_eligy_prfl_id in number default hr_api.g_number
317: ,p_ordr_num in number default hr_api.g_number
318: ,p_excld_flag in varchar2 default hr_api.g_varchar2
319: ,p_qualification_type_id in number default hr_api.g_number
320: ,p_title in varchar2 default hr_api.g_varchar2
321: ,p_eqt_attribute_category in varchar2 default hr_api.g_varchar2
322: ,p_eqt_attribute1 in varchar2 default hr_api.g_varchar2
323: ,p_eqt_attribute2 in varchar2 default hr_api.g_varchar2

Line 320: ,p_title in varchar2 default hr_api.g_varchar2

316: ,p_eligy_prfl_id in number default hr_api.g_number
317: ,p_ordr_num in number default hr_api.g_number
318: ,p_excld_flag in varchar2 default hr_api.g_varchar2
319: ,p_qualification_type_id in number default hr_api.g_number
320: ,p_title in varchar2 default hr_api.g_varchar2
321: ,p_eqt_attribute_category in varchar2 default hr_api.g_varchar2
322: ,p_eqt_attribute1 in varchar2 default hr_api.g_varchar2
323: ,p_eqt_attribute2 in varchar2 default hr_api.g_varchar2
324: ,p_eqt_attribute3 in varchar2 default hr_api.g_varchar2

Line 321: ,p_eqt_attribute_category in varchar2 default hr_api.g_varchar2

317: ,p_ordr_num in number default hr_api.g_number
318: ,p_excld_flag in varchar2 default hr_api.g_varchar2
319: ,p_qualification_type_id in number default hr_api.g_number
320: ,p_title in varchar2 default hr_api.g_varchar2
321: ,p_eqt_attribute_category in varchar2 default hr_api.g_varchar2
322: ,p_eqt_attribute1 in varchar2 default hr_api.g_varchar2
323: ,p_eqt_attribute2 in varchar2 default hr_api.g_varchar2
324: ,p_eqt_attribute3 in varchar2 default hr_api.g_varchar2
325: ,p_eqt_attribute4 in varchar2 default hr_api.g_varchar2

Line 322: ,p_eqt_attribute1 in varchar2 default hr_api.g_varchar2

318: ,p_excld_flag in varchar2 default hr_api.g_varchar2
319: ,p_qualification_type_id in number default hr_api.g_number
320: ,p_title in varchar2 default hr_api.g_varchar2
321: ,p_eqt_attribute_category in varchar2 default hr_api.g_varchar2
322: ,p_eqt_attribute1 in varchar2 default hr_api.g_varchar2
323: ,p_eqt_attribute2 in varchar2 default hr_api.g_varchar2
324: ,p_eqt_attribute3 in varchar2 default hr_api.g_varchar2
325: ,p_eqt_attribute4 in varchar2 default hr_api.g_varchar2
326: ,p_eqt_attribute5 in varchar2 default hr_api.g_varchar2

Line 323: ,p_eqt_attribute2 in varchar2 default hr_api.g_varchar2

319: ,p_qualification_type_id in number default hr_api.g_number
320: ,p_title in varchar2 default hr_api.g_varchar2
321: ,p_eqt_attribute_category in varchar2 default hr_api.g_varchar2
322: ,p_eqt_attribute1 in varchar2 default hr_api.g_varchar2
323: ,p_eqt_attribute2 in varchar2 default hr_api.g_varchar2
324: ,p_eqt_attribute3 in varchar2 default hr_api.g_varchar2
325: ,p_eqt_attribute4 in varchar2 default hr_api.g_varchar2
326: ,p_eqt_attribute5 in varchar2 default hr_api.g_varchar2
327: ,p_eqt_attribute6 in varchar2 default hr_api.g_varchar2

Line 324: ,p_eqt_attribute3 in varchar2 default hr_api.g_varchar2

320: ,p_title in varchar2 default hr_api.g_varchar2
321: ,p_eqt_attribute_category in varchar2 default hr_api.g_varchar2
322: ,p_eqt_attribute1 in varchar2 default hr_api.g_varchar2
323: ,p_eqt_attribute2 in varchar2 default hr_api.g_varchar2
324: ,p_eqt_attribute3 in varchar2 default hr_api.g_varchar2
325: ,p_eqt_attribute4 in varchar2 default hr_api.g_varchar2
326: ,p_eqt_attribute5 in varchar2 default hr_api.g_varchar2
327: ,p_eqt_attribute6 in varchar2 default hr_api.g_varchar2
328: ,p_eqt_attribute7 in varchar2 default hr_api.g_varchar2

Line 325: ,p_eqt_attribute4 in varchar2 default hr_api.g_varchar2

321: ,p_eqt_attribute_category in varchar2 default hr_api.g_varchar2
322: ,p_eqt_attribute1 in varchar2 default hr_api.g_varchar2
323: ,p_eqt_attribute2 in varchar2 default hr_api.g_varchar2
324: ,p_eqt_attribute3 in varchar2 default hr_api.g_varchar2
325: ,p_eqt_attribute4 in varchar2 default hr_api.g_varchar2
326: ,p_eqt_attribute5 in varchar2 default hr_api.g_varchar2
327: ,p_eqt_attribute6 in varchar2 default hr_api.g_varchar2
328: ,p_eqt_attribute7 in varchar2 default hr_api.g_varchar2
329: ,p_eqt_attribute8 in varchar2 default hr_api.g_varchar2

Line 326: ,p_eqt_attribute5 in varchar2 default hr_api.g_varchar2

322: ,p_eqt_attribute1 in varchar2 default hr_api.g_varchar2
323: ,p_eqt_attribute2 in varchar2 default hr_api.g_varchar2
324: ,p_eqt_attribute3 in varchar2 default hr_api.g_varchar2
325: ,p_eqt_attribute4 in varchar2 default hr_api.g_varchar2
326: ,p_eqt_attribute5 in varchar2 default hr_api.g_varchar2
327: ,p_eqt_attribute6 in varchar2 default hr_api.g_varchar2
328: ,p_eqt_attribute7 in varchar2 default hr_api.g_varchar2
329: ,p_eqt_attribute8 in varchar2 default hr_api.g_varchar2
330: ,p_eqt_attribute9 in varchar2 default hr_api.g_varchar2

Line 327: ,p_eqt_attribute6 in varchar2 default hr_api.g_varchar2

323: ,p_eqt_attribute2 in varchar2 default hr_api.g_varchar2
324: ,p_eqt_attribute3 in varchar2 default hr_api.g_varchar2
325: ,p_eqt_attribute4 in varchar2 default hr_api.g_varchar2
326: ,p_eqt_attribute5 in varchar2 default hr_api.g_varchar2
327: ,p_eqt_attribute6 in varchar2 default hr_api.g_varchar2
328: ,p_eqt_attribute7 in varchar2 default hr_api.g_varchar2
329: ,p_eqt_attribute8 in varchar2 default hr_api.g_varchar2
330: ,p_eqt_attribute9 in varchar2 default hr_api.g_varchar2
331: ,p_eqt_attribute10 in varchar2 default hr_api.g_varchar2

Line 328: ,p_eqt_attribute7 in varchar2 default hr_api.g_varchar2

324: ,p_eqt_attribute3 in varchar2 default hr_api.g_varchar2
325: ,p_eqt_attribute4 in varchar2 default hr_api.g_varchar2
326: ,p_eqt_attribute5 in varchar2 default hr_api.g_varchar2
327: ,p_eqt_attribute6 in varchar2 default hr_api.g_varchar2
328: ,p_eqt_attribute7 in varchar2 default hr_api.g_varchar2
329: ,p_eqt_attribute8 in varchar2 default hr_api.g_varchar2
330: ,p_eqt_attribute9 in varchar2 default hr_api.g_varchar2
331: ,p_eqt_attribute10 in varchar2 default hr_api.g_varchar2
332: ,p_eqt_attribute11 in varchar2 default hr_api.g_varchar2

Line 329: ,p_eqt_attribute8 in varchar2 default hr_api.g_varchar2

325: ,p_eqt_attribute4 in varchar2 default hr_api.g_varchar2
326: ,p_eqt_attribute5 in varchar2 default hr_api.g_varchar2
327: ,p_eqt_attribute6 in varchar2 default hr_api.g_varchar2
328: ,p_eqt_attribute7 in varchar2 default hr_api.g_varchar2
329: ,p_eqt_attribute8 in varchar2 default hr_api.g_varchar2
330: ,p_eqt_attribute9 in varchar2 default hr_api.g_varchar2
331: ,p_eqt_attribute10 in varchar2 default hr_api.g_varchar2
332: ,p_eqt_attribute11 in varchar2 default hr_api.g_varchar2
333: ,p_eqt_attribute12 in varchar2 default hr_api.g_varchar2

Line 330: ,p_eqt_attribute9 in varchar2 default hr_api.g_varchar2

326: ,p_eqt_attribute5 in varchar2 default hr_api.g_varchar2
327: ,p_eqt_attribute6 in varchar2 default hr_api.g_varchar2
328: ,p_eqt_attribute7 in varchar2 default hr_api.g_varchar2
329: ,p_eqt_attribute8 in varchar2 default hr_api.g_varchar2
330: ,p_eqt_attribute9 in varchar2 default hr_api.g_varchar2
331: ,p_eqt_attribute10 in varchar2 default hr_api.g_varchar2
332: ,p_eqt_attribute11 in varchar2 default hr_api.g_varchar2
333: ,p_eqt_attribute12 in varchar2 default hr_api.g_varchar2
334: ,p_eqt_attribute13 in varchar2 default hr_api.g_varchar2

Line 331: ,p_eqt_attribute10 in varchar2 default hr_api.g_varchar2

327: ,p_eqt_attribute6 in varchar2 default hr_api.g_varchar2
328: ,p_eqt_attribute7 in varchar2 default hr_api.g_varchar2
329: ,p_eqt_attribute8 in varchar2 default hr_api.g_varchar2
330: ,p_eqt_attribute9 in varchar2 default hr_api.g_varchar2
331: ,p_eqt_attribute10 in varchar2 default hr_api.g_varchar2
332: ,p_eqt_attribute11 in varchar2 default hr_api.g_varchar2
333: ,p_eqt_attribute12 in varchar2 default hr_api.g_varchar2
334: ,p_eqt_attribute13 in varchar2 default hr_api.g_varchar2
335: ,p_eqt_attribute14 in varchar2 default hr_api.g_varchar2

Line 332: ,p_eqt_attribute11 in varchar2 default hr_api.g_varchar2

328: ,p_eqt_attribute7 in varchar2 default hr_api.g_varchar2
329: ,p_eqt_attribute8 in varchar2 default hr_api.g_varchar2
330: ,p_eqt_attribute9 in varchar2 default hr_api.g_varchar2
331: ,p_eqt_attribute10 in varchar2 default hr_api.g_varchar2
332: ,p_eqt_attribute11 in varchar2 default hr_api.g_varchar2
333: ,p_eqt_attribute12 in varchar2 default hr_api.g_varchar2
334: ,p_eqt_attribute13 in varchar2 default hr_api.g_varchar2
335: ,p_eqt_attribute14 in varchar2 default hr_api.g_varchar2
336: ,p_eqt_attribute15 in varchar2 default hr_api.g_varchar2

Line 333: ,p_eqt_attribute12 in varchar2 default hr_api.g_varchar2

329: ,p_eqt_attribute8 in varchar2 default hr_api.g_varchar2
330: ,p_eqt_attribute9 in varchar2 default hr_api.g_varchar2
331: ,p_eqt_attribute10 in varchar2 default hr_api.g_varchar2
332: ,p_eqt_attribute11 in varchar2 default hr_api.g_varchar2
333: ,p_eqt_attribute12 in varchar2 default hr_api.g_varchar2
334: ,p_eqt_attribute13 in varchar2 default hr_api.g_varchar2
335: ,p_eqt_attribute14 in varchar2 default hr_api.g_varchar2
336: ,p_eqt_attribute15 in varchar2 default hr_api.g_varchar2
337: ,p_eqt_attribute16 in varchar2 default hr_api.g_varchar2

Line 334: ,p_eqt_attribute13 in varchar2 default hr_api.g_varchar2

330: ,p_eqt_attribute9 in varchar2 default hr_api.g_varchar2
331: ,p_eqt_attribute10 in varchar2 default hr_api.g_varchar2
332: ,p_eqt_attribute11 in varchar2 default hr_api.g_varchar2
333: ,p_eqt_attribute12 in varchar2 default hr_api.g_varchar2
334: ,p_eqt_attribute13 in varchar2 default hr_api.g_varchar2
335: ,p_eqt_attribute14 in varchar2 default hr_api.g_varchar2
336: ,p_eqt_attribute15 in varchar2 default hr_api.g_varchar2
337: ,p_eqt_attribute16 in varchar2 default hr_api.g_varchar2
338: ,p_eqt_attribute17 in varchar2 default hr_api.g_varchar2

Line 335: ,p_eqt_attribute14 in varchar2 default hr_api.g_varchar2

331: ,p_eqt_attribute10 in varchar2 default hr_api.g_varchar2
332: ,p_eqt_attribute11 in varchar2 default hr_api.g_varchar2
333: ,p_eqt_attribute12 in varchar2 default hr_api.g_varchar2
334: ,p_eqt_attribute13 in varchar2 default hr_api.g_varchar2
335: ,p_eqt_attribute14 in varchar2 default hr_api.g_varchar2
336: ,p_eqt_attribute15 in varchar2 default hr_api.g_varchar2
337: ,p_eqt_attribute16 in varchar2 default hr_api.g_varchar2
338: ,p_eqt_attribute17 in varchar2 default hr_api.g_varchar2
339: ,p_eqt_attribute18 in varchar2 default hr_api.g_varchar2

Line 336: ,p_eqt_attribute15 in varchar2 default hr_api.g_varchar2

332: ,p_eqt_attribute11 in varchar2 default hr_api.g_varchar2
333: ,p_eqt_attribute12 in varchar2 default hr_api.g_varchar2
334: ,p_eqt_attribute13 in varchar2 default hr_api.g_varchar2
335: ,p_eqt_attribute14 in varchar2 default hr_api.g_varchar2
336: ,p_eqt_attribute15 in varchar2 default hr_api.g_varchar2
337: ,p_eqt_attribute16 in varchar2 default hr_api.g_varchar2
338: ,p_eqt_attribute17 in varchar2 default hr_api.g_varchar2
339: ,p_eqt_attribute18 in varchar2 default hr_api.g_varchar2
340: ,p_eqt_attribute19 in varchar2 default hr_api.g_varchar2

Line 337: ,p_eqt_attribute16 in varchar2 default hr_api.g_varchar2

333: ,p_eqt_attribute12 in varchar2 default hr_api.g_varchar2
334: ,p_eqt_attribute13 in varchar2 default hr_api.g_varchar2
335: ,p_eqt_attribute14 in varchar2 default hr_api.g_varchar2
336: ,p_eqt_attribute15 in varchar2 default hr_api.g_varchar2
337: ,p_eqt_attribute16 in varchar2 default hr_api.g_varchar2
338: ,p_eqt_attribute17 in varchar2 default hr_api.g_varchar2
339: ,p_eqt_attribute18 in varchar2 default hr_api.g_varchar2
340: ,p_eqt_attribute19 in varchar2 default hr_api.g_varchar2
341: ,p_eqt_attribute20 in varchar2 default hr_api.g_varchar2

Line 338: ,p_eqt_attribute17 in varchar2 default hr_api.g_varchar2

334: ,p_eqt_attribute13 in varchar2 default hr_api.g_varchar2
335: ,p_eqt_attribute14 in varchar2 default hr_api.g_varchar2
336: ,p_eqt_attribute15 in varchar2 default hr_api.g_varchar2
337: ,p_eqt_attribute16 in varchar2 default hr_api.g_varchar2
338: ,p_eqt_attribute17 in varchar2 default hr_api.g_varchar2
339: ,p_eqt_attribute18 in varchar2 default hr_api.g_varchar2
340: ,p_eqt_attribute19 in varchar2 default hr_api.g_varchar2
341: ,p_eqt_attribute20 in varchar2 default hr_api.g_varchar2
342: ,p_eqt_attribute21 in varchar2 default hr_api.g_varchar2

Line 339: ,p_eqt_attribute18 in varchar2 default hr_api.g_varchar2

335: ,p_eqt_attribute14 in varchar2 default hr_api.g_varchar2
336: ,p_eqt_attribute15 in varchar2 default hr_api.g_varchar2
337: ,p_eqt_attribute16 in varchar2 default hr_api.g_varchar2
338: ,p_eqt_attribute17 in varchar2 default hr_api.g_varchar2
339: ,p_eqt_attribute18 in varchar2 default hr_api.g_varchar2
340: ,p_eqt_attribute19 in varchar2 default hr_api.g_varchar2
341: ,p_eqt_attribute20 in varchar2 default hr_api.g_varchar2
342: ,p_eqt_attribute21 in varchar2 default hr_api.g_varchar2
343: ,p_eqt_attribute22 in varchar2 default hr_api.g_varchar2

Line 340: ,p_eqt_attribute19 in varchar2 default hr_api.g_varchar2

336: ,p_eqt_attribute15 in varchar2 default hr_api.g_varchar2
337: ,p_eqt_attribute16 in varchar2 default hr_api.g_varchar2
338: ,p_eqt_attribute17 in varchar2 default hr_api.g_varchar2
339: ,p_eqt_attribute18 in varchar2 default hr_api.g_varchar2
340: ,p_eqt_attribute19 in varchar2 default hr_api.g_varchar2
341: ,p_eqt_attribute20 in varchar2 default hr_api.g_varchar2
342: ,p_eqt_attribute21 in varchar2 default hr_api.g_varchar2
343: ,p_eqt_attribute22 in varchar2 default hr_api.g_varchar2
344: ,p_eqt_attribute23 in varchar2 default hr_api.g_varchar2

Line 341: ,p_eqt_attribute20 in varchar2 default hr_api.g_varchar2

337: ,p_eqt_attribute16 in varchar2 default hr_api.g_varchar2
338: ,p_eqt_attribute17 in varchar2 default hr_api.g_varchar2
339: ,p_eqt_attribute18 in varchar2 default hr_api.g_varchar2
340: ,p_eqt_attribute19 in varchar2 default hr_api.g_varchar2
341: ,p_eqt_attribute20 in varchar2 default hr_api.g_varchar2
342: ,p_eqt_attribute21 in varchar2 default hr_api.g_varchar2
343: ,p_eqt_attribute22 in varchar2 default hr_api.g_varchar2
344: ,p_eqt_attribute23 in varchar2 default hr_api.g_varchar2
345: ,p_eqt_attribute24 in varchar2 default hr_api.g_varchar2

Line 342: ,p_eqt_attribute21 in varchar2 default hr_api.g_varchar2

338: ,p_eqt_attribute17 in varchar2 default hr_api.g_varchar2
339: ,p_eqt_attribute18 in varchar2 default hr_api.g_varchar2
340: ,p_eqt_attribute19 in varchar2 default hr_api.g_varchar2
341: ,p_eqt_attribute20 in varchar2 default hr_api.g_varchar2
342: ,p_eqt_attribute21 in varchar2 default hr_api.g_varchar2
343: ,p_eqt_attribute22 in varchar2 default hr_api.g_varchar2
344: ,p_eqt_attribute23 in varchar2 default hr_api.g_varchar2
345: ,p_eqt_attribute24 in varchar2 default hr_api.g_varchar2
346: ,p_eqt_attribute25 in varchar2 default hr_api.g_varchar2

Line 343: ,p_eqt_attribute22 in varchar2 default hr_api.g_varchar2

339: ,p_eqt_attribute18 in varchar2 default hr_api.g_varchar2
340: ,p_eqt_attribute19 in varchar2 default hr_api.g_varchar2
341: ,p_eqt_attribute20 in varchar2 default hr_api.g_varchar2
342: ,p_eqt_attribute21 in varchar2 default hr_api.g_varchar2
343: ,p_eqt_attribute22 in varchar2 default hr_api.g_varchar2
344: ,p_eqt_attribute23 in varchar2 default hr_api.g_varchar2
345: ,p_eqt_attribute24 in varchar2 default hr_api.g_varchar2
346: ,p_eqt_attribute25 in varchar2 default hr_api.g_varchar2
347: ,p_eqt_attribute26 in varchar2 default hr_api.g_varchar2

Line 344: ,p_eqt_attribute23 in varchar2 default hr_api.g_varchar2

340: ,p_eqt_attribute19 in varchar2 default hr_api.g_varchar2
341: ,p_eqt_attribute20 in varchar2 default hr_api.g_varchar2
342: ,p_eqt_attribute21 in varchar2 default hr_api.g_varchar2
343: ,p_eqt_attribute22 in varchar2 default hr_api.g_varchar2
344: ,p_eqt_attribute23 in varchar2 default hr_api.g_varchar2
345: ,p_eqt_attribute24 in varchar2 default hr_api.g_varchar2
346: ,p_eqt_attribute25 in varchar2 default hr_api.g_varchar2
347: ,p_eqt_attribute26 in varchar2 default hr_api.g_varchar2
348: ,p_eqt_attribute27 in varchar2 default hr_api.g_varchar2

Line 345: ,p_eqt_attribute24 in varchar2 default hr_api.g_varchar2

341: ,p_eqt_attribute20 in varchar2 default hr_api.g_varchar2
342: ,p_eqt_attribute21 in varchar2 default hr_api.g_varchar2
343: ,p_eqt_attribute22 in varchar2 default hr_api.g_varchar2
344: ,p_eqt_attribute23 in varchar2 default hr_api.g_varchar2
345: ,p_eqt_attribute24 in varchar2 default hr_api.g_varchar2
346: ,p_eqt_attribute25 in varchar2 default hr_api.g_varchar2
347: ,p_eqt_attribute26 in varchar2 default hr_api.g_varchar2
348: ,p_eqt_attribute27 in varchar2 default hr_api.g_varchar2
349: ,p_eqt_attribute28 in varchar2 default hr_api.g_varchar2

Line 346: ,p_eqt_attribute25 in varchar2 default hr_api.g_varchar2

342: ,p_eqt_attribute21 in varchar2 default hr_api.g_varchar2
343: ,p_eqt_attribute22 in varchar2 default hr_api.g_varchar2
344: ,p_eqt_attribute23 in varchar2 default hr_api.g_varchar2
345: ,p_eqt_attribute24 in varchar2 default hr_api.g_varchar2
346: ,p_eqt_attribute25 in varchar2 default hr_api.g_varchar2
347: ,p_eqt_attribute26 in varchar2 default hr_api.g_varchar2
348: ,p_eqt_attribute27 in varchar2 default hr_api.g_varchar2
349: ,p_eqt_attribute28 in varchar2 default hr_api.g_varchar2
350: ,p_eqt_attribute29 in varchar2 default hr_api.g_varchar2

Line 347: ,p_eqt_attribute26 in varchar2 default hr_api.g_varchar2

343: ,p_eqt_attribute22 in varchar2 default hr_api.g_varchar2
344: ,p_eqt_attribute23 in varchar2 default hr_api.g_varchar2
345: ,p_eqt_attribute24 in varchar2 default hr_api.g_varchar2
346: ,p_eqt_attribute25 in varchar2 default hr_api.g_varchar2
347: ,p_eqt_attribute26 in varchar2 default hr_api.g_varchar2
348: ,p_eqt_attribute27 in varchar2 default hr_api.g_varchar2
349: ,p_eqt_attribute28 in varchar2 default hr_api.g_varchar2
350: ,p_eqt_attribute29 in varchar2 default hr_api.g_varchar2
351: ,p_eqt_attribute30 in varchar2 default hr_api.g_varchar2

Line 348: ,p_eqt_attribute27 in varchar2 default hr_api.g_varchar2

344: ,p_eqt_attribute23 in varchar2 default hr_api.g_varchar2
345: ,p_eqt_attribute24 in varchar2 default hr_api.g_varchar2
346: ,p_eqt_attribute25 in varchar2 default hr_api.g_varchar2
347: ,p_eqt_attribute26 in varchar2 default hr_api.g_varchar2
348: ,p_eqt_attribute27 in varchar2 default hr_api.g_varchar2
349: ,p_eqt_attribute28 in varchar2 default hr_api.g_varchar2
350: ,p_eqt_attribute29 in varchar2 default hr_api.g_varchar2
351: ,p_eqt_attribute30 in varchar2 default hr_api.g_varchar2
352: ,p_object_version_number in out nocopy number

Line 349: ,p_eqt_attribute28 in varchar2 default hr_api.g_varchar2

345: ,p_eqt_attribute24 in varchar2 default hr_api.g_varchar2
346: ,p_eqt_attribute25 in varchar2 default hr_api.g_varchar2
347: ,p_eqt_attribute26 in varchar2 default hr_api.g_varchar2
348: ,p_eqt_attribute27 in varchar2 default hr_api.g_varchar2
349: ,p_eqt_attribute28 in varchar2 default hr_api.g_varchar2
350: ,p_eqt_attribute29 in varchar2 default hr_api.g_varchar2
351: ,p_eqt_attribute30 in varchar2 default hr_api.g_varchar2
352: ,p_object_version_number in out nocopy number
353: ,p_effective_date in date

Line 350: ,p_eqt_attribute29 in varchar2 default hr_api.g_varchar2

346: ,p_eqt_attribute25 in varchar2 default hr_api.g_varchar2
347: ,p_eqt_attribute26 in varchar2 default hr_api.g_varchar2
348: ,p_eqt_attribute27 in varchar2 default hr_api.g_varchar2
349: ,p_eqt_attribute28 in varchar2 default hr_api.g_varchar2
350: ,p_eqt_attribute29 in varchar2 default hr_api.g_varchar2
351: ,p_eqt_attribute30 in varchar2 default hr_api.g_varchar2
352: ,p_object_version_number in out nocopy number
353: ,p_effective_date in date
354: ,p_datetrack_mode in varchar2

Line 351: ,p_eqt_attribute30 in varchar2 default hr_api.g_varchar2

347: ,p_eqt_attribute26 in varchar2 default hr_api.g_varchar2
348: ,p_eqt_attribute27 in varchar2 default hr_api.g_varchar2
349: ,p_eqt_attribute28 in varchar2 default hr_api.g_varchar2
350: ,p_eqt_attribute29 in varchar2 default hr_api.g_varchar2
351: ,p_eqt_attribute30 in varchar2 default hr_api.g_varchar2
352: ,p_object_version_number in out nocopy number
353: ,p_effective_date in date
354: ,p_datetrack_mode in varchar2
355: ,p_criteria_score in number default hr_api.g_number

Line 355: ,p_criteria_score in number default hr_api.g_number

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

Line 356: ,p_criteria_weight in number default hr_api.g_number

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

Line 431: when hr_api.cannot_find_prog_unit then

427: ,p_criteria_score => p_criteria_score
428: ,p_criteria_weight => p_criteria_weight
429: );
430: exception
431: when hr_api.cannot_find_prog_unit then
432: hr_api.cannot_find_prog_unit_error
433: (p_module_name => 'UPDATE_elig_qual_titl_prte'
434: ,p_hook_type => 'BP'
435: );

Line 432: hr_api.cannot_find_prog_unit_error

428: ,p_criteria_weight => p_criteria_weight
429: );
430: exception
431: when hr_api.cannot_find_prog_unit then
432: hr_api.cannot_find_prog_unit_error
433: (p_module_name => 'UPDATE_elig_qual_titl_prte'
434: ,p_hook_type => 'BP'
435: );
436: --

Line 543: when hr_api.cannot_find_prog_unit then

539: ,p_criteria_score => p_criteria_score
540: ,p_criteria_weight => p_criteria_weight
541: );
542: exception
543: when hr_api.cannot_find_prog_unit then
544: hr_api.cannot_find_prog_unit_error
545: (p_module_name => 'UPDATE_elig_qual_titl_prte'
546: ,p_hook_type => 'AP'
547: );

Line 544: hr_api.cannot_find_prog_unit_error

540: ,p_criteria_weight => p_criteria_weight
541: );
542: exception
543: when hr_api.cannot_find_prog_unit then
544: hr_api.cannot_find_prog_unit_error
545: (p_module_name => 'UPDATE_elig_qual_titl_prte'
546: ,p_hook_type => 'AP'
547: );
548: --

Line 558: raise hr_api.validate_enabled;

554: --
555: -- When in validation only mode raise the Validate_Enabled exception
556: --
557: if p_validate then
558: raise hr_api.validate_enabled;
559: end if;
560: --
561: -- Set all output arguments
562: --

Line 571: when hr_api.validate_enabled then

567: hr_utility.set_location(' Leaving:'||l_proc, 70);
568: --
569: exception
570: --
571: when hr_api.validate_enabled then
572: --
573: -- As the Validate_Enabled exception has been raised
574: -- we must rollback to the savepoint
575: --

Line 644: when hr_api.cannot_find_prog_unit then

640: ,p_effective_date => trunc(p_effective_date)
641: ,p_datetrack_mode => p_datetrack_mode
642: );
643: exception
644: when hr_api.cannot_find_prog_unit then
645: hr_api.cannot_find_prog_unit_error
646: (p_module_name => 'DELETE_elig_qual_titl_prte'
647: ,p_hook_type => 'BP'
648: );

Line 645: hr_api.cannot_find_prog_unit_error

641: ,p_datetrack_mode => p_datetrack_mode
642: );
643: exception
644: when hr_api.cannot_find_prog_unit then
645: hr_api.cannot_find_prog_unit_error
646: (p_module_name => 'DELETE_elig_qual_titl_prte'
647: ,p_hook_type => 'BP'
648: );
649: --

Line 678: when hr_api.cannot_find_prog_unit then

674: ,p_effective_date => trunc(p_effective_date)
675: ,p_datetrack_mode => p_datetrack_mode
676: );
677: exception
678: when hr_api.cannot_find_prog_unit then
679: hr_api.cannot_find_prog_unit_error
680: (p_module_name => 'DELETE_elig_qual_titl_prte'
681: ,p_hook_type => 'AP'
682: );

Line 679: hr_api.cannot_find_prog_unit_error

675: ,p_datetrack_mode => p_datetrack_mode
676: );
677: exception
678: when hr_api.cannot_find_prog_unit then
679: hr_api.cannot_find_prog_unit_error
680: (p_module_name => 'DELETE_elig_qual_titl_prte'
681: ,p_hook_type => 'AP'
682: );
683: --

Line 702: raise hr_api.validate_enabled;

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

Line 709: when hr_api.validate_enabled then

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