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'
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: );
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: );
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: --
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: --
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: --
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: --
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: );
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: --
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: );
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: --
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: --
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: --
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: );
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: --
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: );
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: --
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: --
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: --