DBA Data[Home] [Help]

APPS.BEN_ELIG_SCHEDD_HRS_PRTE_API dependencies on HR_API

Line 140: when hr_api.cannot_find_prog_unit then

136: ,p_criteria_score => p_criteria_score
137: ,p_criteria_weight => p_criteria_weight
138: );
139: exception
140: when hr_api.cannot_find_prog_unit then
141: hr_api.cannot_find_prog_unit_error
142: (
143: p_module_name => 'CREATE_ELIG_SCHEDD_HRS_PRTE'
144: ,p_hook_type => 'BP'

Line 141: hr_api.cannot_find_prog_unit_error

137: ,p_criteria_weight => p_criteria_weight
138: );
139: exception
140: when hr_api.cannot_find_prog_unit then
141: hr_api.cannot_find_prog_unit_error
142: (
143: p_module_name => 'CREATE_ELIG_SCHEDD_HRS_PRTE'
144: ,p_hook_type => 'BP'
145: );

Line 263: when hr_api.cannot_find_prog_unit then

259: ,p_criteria_score => p_criteria_score
260: ,p_criteria_weight => p_criteria_weight
261: );
262: exception
263: when hr_api.cannot_find_prog_unit then
264: hr_api.cannot_find_prog_unit_error
265: (p_module_name => 'CREATE_ELIG_SCHEDD_HRS_PRTE'
266: ,p_hook_type => 'AP'
267: );

Line 264: hr_api.cannot_find_prog_unit_error

260: ,p_criteria_weight => p_criteria_weight
261: );
262: exception
263: when hr_api.cannot_find_prog_unit then
264: hr_api.cannot_find_prog_unit_error
265: (p_module_name => 'CREATE_ELIG_SCHEDD_HRS_PRTE'
266: ,p_hook_type => 'AP'
267: );
268: --

Line 287: raise hr_api.validate_enabled;

283: --
284: -- When in validation only mode raise the Validate_Enabled exception
285: --
286: if p_validate then
287: raise hr_api.validate_enabled;
288: end if;
289: --
290: -- Set all output arguments
291: --

Line 301: when hr_api.validate_enabled then

297: hr_utility.set_location(' Leaving:'||l_proc, 70);
298: --
299: exception
300: --
301: when hr_api.validate_enabled then
302: --
303: -- As the Validate_Enabled exception has been raised
304: -- we must rollback to the savepoint
305: --

Line 340: ,p_business_group_id in number default hr_api.g_number

336: (p_validate in boolean default false
337: ,p_elig_schedd_hrs_prte_id in number
338: ,p_effective_start_date out nocopy date
339: ,p_effective_end_date out nocopy date
340: ,p_business_group_id in number default hr_api.g_number
341: ,p_hrs_num in number default hr_api.g_number
342: ,p_determination_cd in varchar2 default hr_api.g_varchar2
343: ,p_determination_rl in number default hr_api.g_number
344: ,p_rounding_cd in varchar2 default hr_api.g_varchar2

Line 341: ,p_hrs_num in number default hr_api.g_number

337: ,p_elig_schedd_hrs_prte_id in number
338: ,p_effective_start_date out nocopy date
339: ,p_effective_end_date out nocopy date
340: ,p_business_group_id in number default hr_api.g_number
341: ,p_hrs_num in number default hr_api.g_number
342: ,p_determination_cd in varchar2 default hr_api.g_varchar2
343: ,p_determination_rl in number default hr_api.g_number
344: ,p_rounding_cd in varchar2 default hr_api.g_varchar2
345: ,p_rounding_rl in number default hr_api.g_number

Line 342: ,p_determination_cd in varchar2 default hr_api.g_varchar2

338: ,p_effective_start_date out nocopy date
339: ,p_effective_end_date out nocopy date
340: ,p_business_group_id in number default hr_api.g_number
341: ,p_hrs_num in number default hr_api.g_number
342: ,p_determination_cd in varchar2 default hr_api.g_varchar2
343: ,p_determination_rl in number default hr_api.g_number
344: ,p_rounding_cd in varchar2 default hr_api.g_varchar2
345: ,p_rounding_rl in number default hr_api.g_number
346: ,p_max_hrs_num in number default hr_api.g_number

Line 343: ,p_determination_rl in number default hr_api.g_number

339: ,p_effective_end_date out nocopy date
340: ,p_business_group_id in number default hr_api.g_number
341: ,p_hrs_num in number default hr_api.g_number
342: ,p_determination_cd in varchar2 default hr_api.g_varchar2
343: ,p_determination_rl in number default hr_api.g_number
344: ,p_rounding_cd in varchar2 default hr_api.g_varchar2
345: ,p_rounding_rl in number default hr_api.g_number
346: ,p_max_hrs_num in number default hr_api.g_number
347: ,p_schedd_hrs_rl in number default hr_api.g_number

Line 344: ,p_rounding_cd in varchar2 default hr_api.g_varchar2

340: ,p_business_group_id in number default hr_api.g_number
341: ,p_hrs_num in number default hr_api.g_number
342: ,p_determination_cd in varchar2 default hr_api.g_varchar2
343: ,p_determination_rl in number default hr_api.g_number
344: ,p_rounding_cd in varchar2 default hr_api.g_varchar2
345: ,p_rounding_rl in number default hr_api.g_number
346: ,p_max_hrs_num in number default hr_api.g_number
347: ,p_schedd_hrs_rl in number default hr_api.g_number
348: ,p_freq_cd in varchar2 default hr_api.g_varchar2

Line 345: ,p_rounding_rl in number default hr_api.g_number

341: ,p_hrs_num in number default hr_api.g_number
342: ,p_determination_cd in varchar2 default hr_api.g_varchar2
343: ,p_determination_rl in number default hr_api.g_number
344: ,p_rounding_cd in varchar2 default hr_api.g_varchar2
345: ,p_rounding_rl in number default hr_api.g_number
346: ,p_max_hrs_num in number default hr_api.g_number
347: ,p_schedd_hrs_rl in number default hr_api.g_number
348: ,p_freq_cd in varchar2 default hr_api.g_varchar2
349: ,p_ordr_num in number default hr_api.g_number

Line 346: ,p_max_hrs_num in number default hr_api.g_number

342: ,p_determination_cd in varchar2 default hr_api.g_varchar2
343: ,p_determination_rl in number default hr_api.g_number
344: ,p_rounding_cd in varchar2 default hr_api.g_varchar2
345: ,p_rounding_rl in number default hr_api.g_number
346: ,p_max_hrs_num in number default hr_api.g_number
347: ,p_schedd_hrs_rl in number default hr_api.g_number
348: ,p_freq_cd in varchar2 default hr_api.g_varchar2
349: ,p_ordr_num in number default hr_api.g_number
350: ,p_excld_flag in varchar2 default hr_api.g_varchar2

Line 347: ,p_schedd_hrs_rl in number default hr_api.g_number

343: ,p_determination_rl in number default hr_api.g_number
344: ,p_rounding_cd in varchar2 default hr_api.g_varchar2
345: ,p_rounding_rl in number default hr_api.g_number
346: ,p_max_hrs_num in number default hr_api.g_number
347: ,p_schedd_hrs_rl in number default hr_api.g_number
348: ,p_freq_cd in varchar2 default hr_api.g_varchar2
349: ,p_ordr_num in number default hr_api.g_number
350: ,p_excld_flag in varchar2 default hr_api.g_varchar2
351: ,p_eligy_prfl_id in number default hr_api.g_number

Line 348: ,p_freq_cd in varchar2 default hr_api.g_varchar2

344: ,p_rounding_cd in varchar2 default hr_api.g_varchar2
345: ,p_rounding_rl in number default hr_api.g_number
346: ,p_max_hrs_num in number default hr_api.g_number
347: ,p_schedd_hrs_rl in number default hr_api.g_number
348: ,p_freq_cd in varchar2 default hr_api.g_varchar2
349: ,p_ordr_num in number default hr_api.g_number
350: ,p_excld_flag in varchar2 default hr_api.g_varchar2
351: ,p_eligy_prfl_id in number default hr_api.g_number
352: ,p_esh_attribute_category in varchar2 default hr_api.g_varchar2

Line 349: ,p_ordr_num in number default hr_api.g_number

345: ,p_rounding_rl in number default hr_api.g_number
346: ,p_max_hrs_num in number default hr_api.g_number
347: ,p_schedd_hrs_rl in number default hr_api.g_number
348: ,p_freq_cd in varchar2 default hr_api.g_varchar2
349: ,p_ordr_num in number default hr_api.g_number
350: ,p_excld_flag in varchar2 default hr_api.g_varchar2
351: ,p_eligy_prfl_id in number default hr_api.g_number
352: ,p_esh_attribute_category in varchar2 default hr_api.g_varchar2
353: ,p_esh_attribute1 in varchar2 default hr_api.g_varchar2

Line 350: ,p_excld_flag in varchar2 default hr_api.g_varchar2

346: ,p_max_hrs_num in number default hr_api.g_number
347: ,p_schedd_hrs_rl in number default hr_api.g_number
348: ,p_freq_cd in varchar2 default hr_api.g_varchar2
349: ,p_ordr_num in number default hr_api.g_number
350: ,p_excld_flag in varchar2 default hr_api.g_varchar2
351: ,p_eligy_prfl_id in number default hr_api.g_number
352: ,p_esh_attribute_category in varchar2 default hr_api.g_varchar2
353: ,p_esh_attribute1 in varchar2 default hr_api.g_varchar2
354: ,p_esh_attribute2 in varchar2 default hr_api.g_varchar2

Line 351: ,p_eligy_prfl_id in number default hr_api.g_number

347: ,p_schedd_hrs_rl in number default hr_api.g_number
348: ,p_freq_cd in varchar2 default hr_api.g_varchar2
349: ,p_ordr_num in number default hr_api.g_number
350: ,p_excld_flag in varchar2 default hr_api.g_varchar2
351: ,p_eligy_prfl_id in number default hr_api.g_number
352: ,p_esh_attribute_category in varchar2 default hr_api.g_varchar2
353: ,p_esh_attribute1 in varchar2 default hr_api.g_varchar2
354: ,p_esh_attribute2 in varchar2 default hr_api.g_varchar2
355: ,p_esh_attribute3 in varchar2 default hr_api.g_varchar2

Line 352: ,p_esh_attribute_category in varchar2 default hr_api.g_varchar2

348: ,p_freq_cd in varchar2 default hr_api.g_varchar2
349: ,p_ordr_num in number default hr_api.g_number
350: ,p_excld_flag in varchar2 default hr_api.g_varchar2
351: ,p_eligy_prfl_id in number default hr_api.g_number
352: ,p_esh_attribute_category in varchar2 default hr_api.g_varchar2
353: ,p_esh_attribute1 in varchar2 default hr_api.g_varchar2
354: ,p_esh_attribute2 in varchar2 default hr_api.g_varchar2
355: ,p_esh_attribute3 in varchar2 default hr_api.g_varchar2
356: ,p_esh_attribute4 in varchar2 default hr_api.g_varchar2

Line 353: ,p_esh_attribute1 in varchar2 default hr_api.g_varchar2

349: ,p_ordr_num in number default hr_api.g_number
350: ,p_excld_flag in varchar2 default hr_api.g_varchar2
351: ,p_eligy_prfl_id in number default hr_api.g_number
352: ,p_esh_attribute_category in varchar2 default hr_api.g_varchar2
353: ,p_esh_attribute1 in varchar2 default hr_api.g_varchar2
354: ,p_esh_attribute2 in varchar2 default hr_api.g_varchar2
355: ,p_esh_attribute3 in varchar2 default hr_api.g_varchar2
356: ,p_esh_attribute4 in varchar2 default hr_api.g_varchar2
357: ,p_esh_attribute5 in varchar2 default hr_api.g_varchar2

Line 354: ,p_esh_attribute2 in varchar2 default hr_api.g_varchar2

350: ,p_excld_flag in varchar2 default hr_api.g_varchar2
351: ,p_eligy_prfl_id in number default hr_api.g_number
352: ,p_esh_attribute_category in varchar2 default hr_api.g_varchar2
353: ,p_esh_attribute1 in varchar2 default hr_api.g_varchar2
354: ,p_esh_attribute2 in varchar2 default hr_api.g_varchar2
355: ,p_esh_attribute3 in varchar2 default hr_api.g_varchar2
356: ,p_esh_attribute4 in varchar2 default hr_api.g_varchar2
357: ,p_esh_attribute5 in varchar2 default hr_api.g_varchar2
358: ,p_esh_attribute6 in varchar2 default hr_api.g_varchar2

Line 355: ,p_esh_attribute3 in varchar2 default hr_api.g_varchar2

351: ,p_eligy_prfl_id in number default hr_api.g_number
352: ,p_esh_attribute_category in varchar2 default hr_api.g_varchar2
353: ,p_esh_attribute1 in varchar2 default hr_api.g_varchar2
354: ,p_esh_attribute2 in varchar2 default hr_api.g_varchar2
355: ,p_esh_attribute3 in varchar2 default hr_api.g_varchar2
356: ,p_esh_attribute4 in varchar2 default hr_api.g_varchar2
357: ,p_esh_attribute5 in varchar2 default hr_api.g_varchar2
358: ,p_esh_attribute6 in varchar2 default hr_api.g_varchar2
359: ,p_esh_attribute7 in varchar2 default hr_api.g_varchar2

Line 356: ,p_esh_attribute4 in varchar2 default hr_api.g_varchar2

352: ,p_esh_attribute_category in varchar2 default hr_api.g_varchar2
353: ,p_esh_attribute1 in varchar2 default hr_api.g_varchar2
354: ,p_esh_attribute2 in varchar2 default hr_api.g_varchar2
355: ,p_esh_attribute3 in varchar2 default hr_api.g_varchar2
356: ,p_esh_attribute4 in varchar2 default hr_api.g_varchar2
357: ,p_esh_attribute5 in varchar2 default hr_api.g_varchar2
358: ,p_esh_attribute6 in varchar2 default hr_api.g_varchar2
359: ,p_esh_attribute7 in varchar2 default hr_api.g_varchar2
360: ,p_esh_attribute8 in varchar2 default hr_api.g_varchar2

Line 357: ,p_esh_attribute5 in varchar2 default hr_api.g_varchar2

353: ,p_esh_attribute1 in varchar2 default hr_api.g_varchar2
354: ,p_esh_attribute2 in varchar2 default hr_api.g_varchar2
355: ,p_esh_attribute3 in varchar2 default hr_api.g_varchar2
356: ,p_esh_attribute4 in varchar2 default hr_api.g_varchar2
357: ,p_esh_attribute5 in varchar2 default hr_api.g_varchar2
358: ,p_esh_attribute6 in varchar2 default hr_api.g_varchar2
359: ,p_esh_attribute7 in varchar2 default hr_api.g_varchar2
360: ,p_esh_attribute8 in varchar2 default hr_api.g_varchar2
361: ,p_esh_attribute9 in varchar2 default hr_api.g_varchar2

Line 358: ,p_esh_attribute6 in varchar2 default hr_api.g_varchar2

354: ,p_esh_attribute2 in varchar2 default hr_api.g_varchar2
355: ,p_esh_attribute3 in varchar2 default hr_api.g_varchar2
356: ,p_esh_attribute4 in varchar2 default hr_api.g_varchar2
357: ,p_esh_attribute5 in varchar2 default hr_api.g_varchar2
358: ,p_esh_attribute6 in varchar2 default hr_api.g_varchar2
359: ,p_esh_attribute7 in varchar2 default hr_api.g_varchar2
360: ,p_esh_attribute8 in varchar2 default hr_api.g_varchar2
361: ,p_esh_attribute9 in varchar2 default hr_api.g_varchar2
362: ,p_esh_attribute10 in varchar2 default hr_api.g_varchar2

Line 359: ,p_esh_attribute7 in varchar2 default hr_api.g_varchar2

355: ,p_esh_attribute3 in varchar2 default hr_api.g_varchar2
356: ,p_esh_attribute4 in varchar2 default hr_api.g_varchar2
357: ,p_esh_attribute5 in varchar2 default hr_api.g_varchar2
358: ,p_esh_attribute6 in varchar2 default hr_api.g_varchar2
359: ,p_esh_attribute7 in varchar2 default hr_api.g_varchar2
360: ,p_esh_attribute8 in varchar2 default hr_api.g_varchar2
361: ,p_esh_attribute9 in varchar2 default hr_api.g_varchar2
362: ,p_esh_attribute10 in varchar2 default hr_api.g_varchar2
363: ,p_esh_attribute11 in varchar2 default hr_api.g_varchar2

Line 360: ,p_esh_attribute8 in varchar2 default hr_api.g_varchar2

356: ,p_esh_attribute4 in varchar2 default hr_api.g_varchar2
357: ,p_esh_attribute5 in varchar2 default hr_api.g_varchar2
358: ,p_esh_attribute6 in varchar2 default hr_api.g_varchar2
359: ,p_esh_attribute7 in varchar2 default hr_api.g_varchar2
360: ,p_esh_attribute8 in varchar2 default hr_api.g_varchar2
361: ,p_esh_attribute9 in varchar2 default hr_api.g_varchar2
362: ,p_esh_attribute10 in varchar2 default hr_api.g_varchar2
363: ,p_esh_attribute11 in varchar2 default hr_api.g_varchar2
364: ,p_esh_attribute12 in varchar2 default hr_api.g_varchar2

Line 361: ,p_esh_attribute9 in varchar2 default hr_api.g_varchar2

357: ,p_esh_attribute5 in varchar2 default hr_api.g_varchar2
358: ,p_esh_attribute6 in varchar2 default hr_api.g_varchar2
359: ,p_esh_attribute7 in varchar2 default hr_api.g_varchar2
360: ,p_esh_attribute8 in varchar2 default hr_api.g_varchar2
361: ,p_esh_attribute9 in varchar2 default hr_api.g_varchar2
362: ,p_esh_attribute10 in varchar2 default hr_api.g_varchar2
363: ,p_esh_attribute11 in varchar2 default hr_api.g_varchar2
364: ,p_esh_attribute12 in varchar2 default hr_api.g_varchar2
365: ,p_esh_attribute13 in varchar2 default hr_api.g_varchar2

Line 362: ,p_esh_attribute10 in varchar2 default hr_api.g_varchar2

358: ,p_esh_attribute6 in varchar2 default hr_api.g_varchar2
359: ,p_esh_attribute7 in varchar2 default hr_api.g_varchar2
360: ,p_esh_attribute8 in varchar2 default hr_api.g_varchar2
361: ,p_esh_attribute9 in varchar2 default hr_api.g_varchar2
362: ,p_esh_attribute10 in varchar2 default hr_api.g_varchar2
363: ,p_esh_attribute11 in varchar2 default hr_api.g_varchar2
364: ,p_esh_attribute12 in varchar2 default hr_api.g_varchar2
365: ,p_esh_attribute13 in varchar2 default hr_api.g_varchar2
366: ,p_esh_attribute14 in varchar2 default hr_api.g_varchar2

Line 363: ,p_esh_attribute11 in varchar2 default hr_api.g_varchar2

359: ,p_esh_attribute7 in varchar2 default hr_api.g_varchar2
360: ,p_esh_attribute8 in varchar2 default hr_api.g_varchar2
361: ,p_esh_attribute9 in varchar2 default hr_api.g_varchar2
362: ,p_esh_attribute10 in varchar2 default hr_api.g_varchar2
363: ,p_esh_attribute11 in varchar2 default hr_api.g_varchar2
364: ,p_esh_attribute12 in varchar2 default hr_api.g_varchar2
365: ,p_esh_attribute13 in varchar2 default hr_api.g_varchar2
366: ,p_esh_attribute14 in varchar2 default hr_api.g_varchar2
367: ,p_esh_attribute15 in varchar2 default hr_api.g_varchar2

Line 364: ,p_esh_attribute12 in varchar2 default hr_api.g_varchar2

360: ,p_esh_attribute8 in varchar2 default hr_api.g_varchar2
361: ,p_esh_attribute9 in varchar2 default hr_api.g_varchar2
362: ,p_esh_attribute10 in varchar2 default hr_api.g_varchar2
363: ,p_esh_attribute11 in varchar2 default hr_api.g_varchar2
364: ,p_esh_attribute12 in varchar2 default hr_api.g_varchar2
365: ,p_esh_attribute13 in varchar2 default hr_api.g_varchar2
366: ,p_esh_attribute14 in varchar2 default hr_api.g_varchar2
367: ,p_esh_attribute15 in varchar2 default hr_api.g_varchar2
368: ,p_esh_attribute16 in varchar2 default hr_api.g_varchar2

Line 365: ,p_esh_attribute13 in varchar2 default hr_api.g_varchar2

361: ,p_esh_attribute9 in varchar2 default hr_api.g_varchar2
362: ,p_esh_attribute10 in varchar2 default hr_api.g_varchar2
363: ,p_esh_attribute11 in varchar2 default hr_api.g_varchar2
364: ,p_esh_attribute12 in varchar2 default hr_api.g_varchar2
365: ,p_esh_attribute13 in varchar2 default hr_api.g_varchar2
366: ,p_esh_attribute14 in varchar2 default hr_api.g_varchar2
367: ,p_esh_attribute15 in varchar2 default hr_api.g_varchar2
368: ,p_esh_attribute16 in varchar2 default hr_api.g_varchar2
369: ,p_esh_attribute17 in varchar2 default hr_api.g_varchar2

Line 366: ,p_esh_attribute14 in varchar2 default hr_api.g_varchar2

362: ,p_esh_attribute10 in varchar2 default hr_api.g_varchar2
363: ,p_esh_attribute11 in varchar2 default hr_api.g_varchar2
364: ,p_esh_attribute12 in varchar2 default hr_api.g_varchar2
365: ,p_esh_attribute13 in varchar2 default hr_api.g_varchar2
366: ,p_esh_attribute14 in varchar2 default hr_api.g_varchar2
367: ,p_esh_attribute15 in varchar2 default hr_api.g_varchar2
368: ,p_esh_attribute16 in varchar2 default hr_api.g_varchar2
369: ,p_esh_attribute17 in varchar2 default hr_api.g_varchar2
370: ,p_esh_attribute18 in varchar2 default hr_api.g_varchar2

Line 367: ,p_esh_attribute15 in varchar2 default hr_api.g_varchar2

363: ,p_esh_attribute11 in varchar2 default hr_api.g_varchar2
364: ,p_esh_attribute12 in varchar2 default hr_api.g_varchar2
365: ,p_esh_attribute13 in varchar2 default hr_api.g_varchar2
366: ,p_esh_attribute14 in varchar2 default hr_api.g_varchar2
367: ,p_esh_attribute15 in varchar2 default hr_api.g_varchar2
368: ,p_esh_attribute16 in varchar2 default hr_api.g_varchar2
369: ,p_esh_attribute17 in varchar2 default hr_api.g_varchar2
370: ,p_esh_attribute18 in varchar2 default hr_api.g_varchar2
371: ,p_esh_attribute19 in varchar2 default hr_api.g_varchar2

Line 368: ,p_esh_attribute16 in varchar2 default hr_api.g_varchar2

364: ,p_esh_attribute12 in varchar2 default hr_api.g_varchar2
365: ,p_esh_attribute13 in varchar2 default hr_api.g_varchar2
366: ,p_esh_attribute14 in varchar2 default hr_api.g_varchar2
367: ,p_esh_attribute15 in varchar2 default hr_api.g_varchar2
368: ,p_esh_attribute16 in varchar2 default hr_api.g_varchar2
369: ,p_esh_attribute17 in varchar2 default hr_api.g_varchar2
370: ,p_esh_attribute18 in varchar2 default hr_api.g_varchar2
371: ,p_esh_attribute19 in varchar2 default hr_api.g_varchar2
372: ,p_esh_attribute20 in varchar2 default hr_api.g_varchar2

Line 369: ,p_esh_attribute17 in varchar2 default hr_api.g_varchar2

365: ,p_esh_attribute13 in varchar2 default hr_api.g_varchar2
366: ,p_esh_attribute14 in varchar2 default hr_api.g_varchar2
367: ,p_esh_attribute15 in varchar2 default hr_api.g_varchar2
368: ,p_esh_attribute16 in varchar2 default hr_api.g_varchar2
369: ,p_esh_attribute17 in varchar2 default hr_api.g_varchar2
370: ,p_esh_attribute18 in varchar2 default hr_api.g_varchar2
371: ,p_esh_attribute19 in varchar2 default hr_api.g_varchar2
372: ,p_esh_attribute20 in varchar2 default hr_api.g_varchar2
373: ,p_esh_attribute21 in varchar2 default hr_api.g_varchar2

Line 370: ,p_esh_attribute18 in varchar2 default hr_api.g_varchar2

366: ,p_esh_attribute14 in varchar2 default hr_api.g_varchar2
367: ,p_esh_attribute15 in varchar2 default hr_api.g_varchar2
368: ,p_esh_attribute16 in varchar2 default hr_api.g_varchar2
369: ,p_esh_attribute17 in varchar2 default hr_api.g_varchar2
370: ,p_esh_attribute18 in varchar2 default hr_api.g_varchar2
371: ,p_esh_attribute19 in varchar2 default hr_api.g_varchar2
372: ,p_esh_attribute20 in varchar2 default hr_api.g_varchar2
373: ,p_esh_attribute21 in varchar2 default hr_api.g_varchar2
374: ,p_esh_attribute22 in varchar2 default hr_api.g_varchar2

Line 371: ,p_esh_attribute19 in varchar2 default hr_api.g_varchar2

367: ,p_esh_attribute15 in varchar2 default hr_api.g_varchar2
368: ,p_esh_attribute16 in varchar2 default hr_api.g_varchar2
369: ,p_esh_attribute17 in varchar2 default hr_api.g_varchar2
370: ,p_esh_attribute18 in varchar2 default hr_api.g_varchar2
371: ,p_esh_attribute19 in varchar2 default hr_api.g_varchar2
372: ,p_esh_attribute20 in varchar2 default hr_api.g_varchar2
373: ,p_esh_attribute21 in varchar2 default hr_api.g_varchar2
374: ,p_esh_attribute22 in varchar2 default hr_api.g_varchar2
375: ,p_esh_attribute23 in varchar2 default hr_api.g_varchar2

Line 372: ,p_esh_attribute20 in varchar2 default hr_api.g_varchar2

368: ,p_esh_attribute16 in varchar2 default hr_api.g_varchar2
369: ,p_esh_attribute17 in varchar2 default hr_api.g_varchar2
370: ,p_esh_attribute18 in varchar2 default hr_api.g_varchar2
371: ,p_esh_attribute19 in varchar2 default hr_api.g_varchar2
372: ,p_esh_attribute20 in varchar2 default hr_api.g_varchar2
373: ,p_esh_attribute21 in varchar2 default hr_api.g_varchar2
374: ,p_esh_attribute22 in varchar2 default hr_api.g_varchar2
375: ,p_esh_attribute23 in varchar2 default hr_api.g_varchar2
376: ,p_esh_attribute24 in varchar2 default hr_api.g_varchar2

Line 373: ,p_esh_attribute21 in varchar2 default hr_api.g_varchar2

369: ,p_esh_attribute17 in varchar2 default hr_api.g_varchar2
370: ,p_esh_attribute18 in varchar2 default hr_api.g_varchar2
371: ,p_esh_attribute19 in varchar2 default hr_api.g_varchar2
372: ,p_esh_attribute20 in varchar2 default hr_api.g_varchar2
373: ,p_esh_attribute21 in varchar2 default hr_api.g_varchar2
374: ,p_esh_attribute22 in varchar2 default hr_api.g_varchar2
375: ,p_esh_attribute23 in varchar2 default hr_api.g_varchar2
376: ,p_esh_attribute24 in varchar2 default hr_api.g_varchar2
377: ,p_esh_attribute25 in varchar2 default hr_api.g_varchar2

Line 374: ,p_esh_attribute22 in varchar2 default hr_api.g_varchar2

370: ,p_esh_attribute18 in varchar2 default hr_api.g_varchar2
371: ,p_esh_attribute19 in varchar2 default hr_api.g_varchar2
372: ,p_esh_attribute20 in varchar2 default hr_api.g_varchar2
373: ,p_esh_attribute21 in varchar2 default hr_api.g_varchar2
374: ,p_esh_attribute22 in varchar2 default hr_api.g_varchar2
375: ,p_esh_attribute23 in varchar2 default hr_api.g_varchar2
376: ,p_esh_attribute24 in varchar2 default hr_api.g_varchar2
377: ,p_esh_attribute25 in varchar2 default hr_api.g_varchar2
378: ,p_esh_attribute26 in varchar2 default hr_api.g_varchar2

Line 375: ,p_esh_attribute23 in varchar2 default hr_api.g_varchar2

371: ,p_esh_attribute19 in varchar2 default hr_api.g_varchar2
372: ,p_esh_attribute20 in varchar2 default hr_api.g_varchar2
373: ,p_esh_attribute21 in varchar2 default hr_api.g_varchar2
374: ,p_esh_attribute22 in varchar2 default hr_api.g_varchar2
375: ,p_esh_attribute23 in varchar2 default hr_api.g_varchar2
376: ,p_esh_attribute24 in varchar2 default hr_api.g_varchar2
377: ,p_esh_attribute25 in varchar2 default hr_api.g_varchar2
378: ,p_esh_attribute26 in varchar2 default hr_api.g_varchar2
379: ,p_esh_attribute27 in varchar2 default hr_api.g_varchar2

Line 376: ,p_esh_attribute24 in varchar2 default hr_api.g_varchar2

372: ,p_esh_attribute20 in varchar2 default hr_api.g_varchar2
373: ,p_esh_attribute21 in varchar2 default hr_api.g_varchar2
374: ,p_esh_attribute22 in varchar2 default hr_api.g_varchar2
375: ,p_esh_attribute23 in varchar2 default hr_api.g_varchar2
376: ,p_esh_attribute24 in varchar2 default hr_api.g_varchar2
377: ,p_esh_attribute25 in varchar2 default hr_api.g_varchar2
378: ,p_esh_attribute26 in varchar2 default hr_api.g_varchar2
379: ,p_esh_attribute27 in varchar2 default hr_api.g_varchar2
380: ,p_esh_attribute28 in varchar2 default hr_api.g_varchar2

Line 377: ,p_esh_attribute25 in varchar2 default hr_api.g_varchar2

373: ,p_esh_attribute21 in varchar2 default hr_api.g_varchar2
374: ,p_esh_attribute22 in varchar2 default hr_api.g_varchar2
375: ,p_esh_attribute23 in varchar2 default hr_api.g_varchar2
376: ,p_esh_attribute24 in varchar2 default hr_api.g_varchar2
377: ,p_esh_attribute25 in varchar2 default hr_api.g_varchar2
378: ,p_esh_attribute26 in varchar2 default hr_api.g_varchar2
379: ,p_esh_attribute27 in varchar2 default hr_api.g_varchar2
380: ,p_esh_attribute28 in varchar2 default hr_api.g_varchar2
381: ,p_esh_attribute29 in varchar2 default hr_api.g_varchar2

Line 378: ,p_esh_attribute26 in varchar2 default hr_api.g_varchar2

374: ,p_esh_attribute22 in varchar2 default hr_api.g_varchar2
375: ,p_esh_attribute23 in varchar2 default hr_api.g_varchar2
376: ,p_esh_attribute24 in varchar2 default hr_api.g_varchar2
377: ,p_esh_attribute25 in varchar2 default hr_api.g_varchar2
378: ,p_esh_attribute26 in varchar2 default hr_api.g_varchar2
379: ,p_esh_attribute27 in varchar2 default hr_api.g_varchar2
380: ,p_esh_attribute28 in varchar2 default hr_api.g_varchar2
381: ,p_esh_attribute29 in varchar2 default hr_api.g_varchar2
382: ,p_esh_attribute30 in varchar2 default hr_api.g_varchar2

Line 379: ,p_esh_attribute27 in varchar2 default hr_api.g_varchar2

375: ,p_esh_attribute23 in varchar2 default hr_api.g_varchar2
376: ,p_esh_attribute24 in varchar2 default hr_api.g_varchar2
377: ,p_esh_attribute25 in varchar2 default hr_api.g_varchar2
378: ,p_esh_attribute26 in varchar2 default hr_api.g_varchar2
379: ,p_esh_attribute27 in varchar2 default hr_api.g_varchar2
380: ,p_esh_attribute28 in varchar2 default hr_api.g_varchar2
381: ,p_esh_attribute29 in varchar2 default hr_api.g_varchar2
382: ,p_esh_attribute30 in varchar2 default hr_api.g_varchar2
383: ,p_object_version_number in out nocopy number

Line 380: ,p_esh_attribute28 in varchar2 default hr_api.g_varchar2

376: ,p_esh_attribute24 in varchar2 default hr_api.g_varchar2
377: ,p_esh_attribute25 in varchar2 default hr_api.g_varchar2
378: ,p_esh_attribute26 in varchar2 default hr_api.g_varchar2
379: ,p_esh_attribute27 in varchar2 default hr_api.g_varchar2
380: ,p_esh_attribute28 in varchar2 default hr_api.g_varchar2
381: ,p_esh_attribute29 in varchar2 default hr_api.g_varchar2
382: ,p_esh_attribute30 in varchar2 default hr_api.g_varchar2
383: ,p_object_version_number in out nocopy number
384: ,p_effective_date in date

Line 381: ,p_esh_attribute29 in varchar2 default hr_api.g_varchar2

377: ,p_esh_attribute25 in varchar2 default hr_api.g_varchar2
378: ,p_esh_attribute26 in varchar2 default hr_api.g_varchar2
379: ,p_esh_attribute27 in varchar2 default hr_api.g_varchar2
380: ,p_esh_attribute28 in varchar2 default hr_api.g_varchar2
381: ,p_esh_attribute29 in varchar2 default hr_api.g_varchar2
382: ,p_esh_attribute30 in varchar2 default hr_api.g_varchar2
383: ,p_object_version_number in out nocopy number
384: ,p_effective_date in date
385: ,p_datetrack_mode in varchar2

Line 382: ,p_esh_attribute30 in varchar2 default hr_api.g_varchar2

378: ,p_esh_attribute26 in varchar2 default hr_api.g_varchar2
379: ,p_esh_attribute27 in varchar2 default hr_api.g_varchar2
380: ,p_esh_attribute28 in varchar2 default hr_api.g_varchar2
381: ,p_esh_attribute29 in varchar2 default hr_api.g_varchar2
382: ,p_esh_attribute30 in varchar2 default hr_api.g_varchar2
383: ,p_object_version_number in out nocopy number
384: ,p_effective_date in date
385: ,p_datetrack_mode in varchar2
386: ,p_criteria_score in number default hr_api.g_number

Line 386: ,p_criteria_score in number default hr_api.g_number

382: ,p_esh_attribute30 in varchar2 default hr_api.g_varchar2
383: ,p_object_version_number in out nocopy number
384: ,p_effective_date in date
385: ,p_datetrack_mode in varchar2
386: ,p_criteria_score in number default hr_api.g_number
387: ,p_criteria_weight in number default hr_api.g_number
388: ) is
389: --
390: -- Declare cursors and local variables

Line 387: ,p_criteria_weight in number default hr_api.g_number

383: ,p_object_version_number in out nocopy number
384: ,p_effective_date in date
385: ,p_datetrack_mode in varchar2
386: ,p_criteria_score in number default hr_api.g_number
387: ,p_criteria_weight in number default hr_api.g_number
388: ) is
389: --
390: -- Declare cursors and local variables
391: --

Line 468: when hr_api.cannot_find_prog_unit then

464: ,p_criteria_score => p_criteria_score
465: ,p_criteria_weight => p_criteria_weight
466: );
467: exception
468: when hr_api.cannot_find_prog_unit then
469: hr_api.cannot_find_prog_unit_error
470: (p_module_name => 'UPDATE_ELIG_SCHEDD_HRS_PRTE'
471: ,p_hook_type => 'BP'
472: );

Line 469: hr_api.cannot_find_prog_unit_error

465: ,p_criteria_weight => p_criteria_weight
466: );
467: exception
468: when hr_api.cannot_find_prog_unit then
469: hr_api.cannot_find_prog_unit_error
470: (p_module_name => 'UPDATE_ELIG_SCHEDD_HRS_PRTE'
471: ,p_hook_type => 'BP'
472: );
473: --

Line 592: when hr_api.cannot_find_prog_unit then

588: ,p_criteria_score => p_criteria_score
589: ,p_criteria_weight => p_criteria_weight
590: );
591: exception
592: when hr_api.cannot_find_prog_unit then
593: hr_api.cannot_find_prog_unit_error
594: (p_module_name => 'UPDATE_ELIG_SCHEDD_HRS_PRTE'
595: ,p_hook_type => 'AP'
596: );

Line 593: hr_api.cannot_find_prog_unit_error

589: ,p_criteria_weight => p_criteria_weight
590: );
591: exception
592: when hr_api.cannot_find_prog_unit then
593: hr_api.cannot_find_prog_unit_error
594: (p_module_name => 'UPDATE_ELIG_SCHEDD_HRS_PRTE'
595: ,p_hook_type => 'AP'
596: );
597: --

Line 607: raise hr_api.validate_enabled;

603: --
604: -- When in validation only mode raise the Validate_Enabled exception
605: --
606: if p_validate then
607: raise hr_api.validate_enabled;
608: end if;
609: --
610: -- Set all output arguments
611: --

Line 620: when hr_api.validate_enabled then

616: hr_utility.set_location(' Leaving:'||l_proc, 70);
617: --
618: exception
619: --
620: when hr_api.validate_enabled then
621: --
622: -- As the Validate_Enabled exception has been raised
623: -- we must rollback to the savepoint
624: --

Line 692: when hr_api.cannot_find_prog_unit then

688: ,p_effective_date => trunc(p_effective_date)
689: ,p_datetrack_mode => p_datetrack_mode
690: );
691: exception
692: when hr_api.cannot_find_prog_unit then
693: hr_api.cannot_find_prog_unit_error
694: (p_module_name => 'DELETE_ELIG_SCHEDD_HRS_PRTE'
695: ,p_hook_type => 'BP'
696: );

Line 693: hr_api.cannot_find_prog_unit_error

689: ,p_datetrack_mode => p_datetrack_mode
690: );
691: exception
692: when hr_api.cannot_find_prog_unit then
693: hr_api.cannot_find_prog_unit_error
694: (p_module_name => 'DELETE_ELIG_SCHEDD_HRS_PRTE'
695: ,p_hook_type => 'BP'
696: );
697: --

Line 726: when hr_api.cannot_find_prog_unit then

722: ,p_effective_date => trunc(p_effective_date)
723: ,p_datetrack_mode => p_datetrack_mode
724: );
725: exception
726: when hr_api.cannot_find_prog_unit then
727: hr_api.cannot_find_prog_unit_error
728: (p_module_name => 'DELETE_ELIG_SCHEDD_HRS_PRTE'
729: ,p_hook_type => 'AP'
730: );

Line 727: hr_api.cannot_find_prog_unit_error

723: ,p_datetrack_mode => p_datetrack_mode
724: );
725: exception
726: when hr_api.cannot_find_prog_unit then
727: hr_api.cannot_find_prog_unit_error
728: (p_module_name => 'DELETE_ELIG_SCHEDD_HRS_PRTE'
729: ,p_hook_type => 'AP'
730: );
731: --

Line 750: raise hr_api.validate_enabled;

746: --
747: -- When in validation only mode raise the Validate_Enabled exception
748: --
749: if p_validate then
750: raise hr_api.validate_enabled;
751: end if;
752: --
753: hr_utility.set_location(' Leaving:'||l_proc, 70);
754: --

Line 757: when hr_api.validate_enabled then

753: hr_utility.set_location(' Leaving:'||l_proc, 70);
754: --
755: exception
756: --
757: when hr_api.validate_enabled then
758: --
759: -- As the Validate_Enabled exception has been raised
760: -- we must rollback to the savepoint
761: --