149: p_date_value3 => p_date_value3,
150: p_date_value4 => p_date_value4
151: );
152: exception
153: when hr_api.cannot_find_prog_unit then
154: hr_api.cannot_find_prog_unit_error
155: (
156: p_module_name => 'CREATE_eligy_crit_values'
157: ,p_hook_type => 'BP'
150: p_date_value4 => p_date_value4
151: );
152: exception
153: when hr_api.cannot_find_prog_unit then
154: hr_api.cannot_find_prog_unit_error
155: (
156: p_module_name => 'CREATE_eligy_crit_values'
157: ,p_hook_type => 'BP'
158: );
284: p_date_value3 => p_date_value3,
285: p_date_value4 => p_date_value4
286: );
287: exception
288: when hr_api.cannot_find_prog_unit then
289: hr_api.cannot_find_prog_unit_error
290: (p_module_name => 'CREATE_eligy_crit_values'
291: ,p_hook_type => 'AP'
292: );
285: p_date_value4 => p_date_value4
286: );
287: exception
288: when hr_api.cannot_find_prog_unit then
289: hr_api.cannot_find_prog_unit_error
290: (p_module_name => 'CREATE_eligy_crit_values'
291: ,p_hook_type => 'AP'
292: );
293:
309: --
310: -- When in validation only mode raise the Validate_Enabled exception
311: --
312: if p_validate then
313: raise hr_api.validate_enabled;
314: end if;
315: --
316: -- Set all output arguments
317: --
323: hr_utility.set_location(' Leaving:'||l_proc, 70);
324: --
325: exception
326: --
327: when hr_api.validate_enabled then
328: --
329: -- As the Validate_Enabled exception has been raised
330: -- we must rollback to the savepoint
331: --
363: procedure update_eligy_crit_values
364: (
365: p_validate In Boolean default false
366: ,p_eligy_crit_values_id In Number
367: ,p_eligy_prfl_id In Number default hr_api.g_number
368: ,p_eligy_criteria_id In Number default hr_api.g_number
369: ,p_effective_start_date Out nocopy Date
370: ,p_effective_end_date Out nocopy Date
371: ,p_ordr_num In Number default hr_api.g_number
364: (
365: p_validate In Boolean default false
366: ,p_eligy_crit_values_id In Number
367: ,p_eligy_prfl_id In Number default hr_api.g_number
368: ,p_eligy_criteria_id In Number default hr_api.g_number
369: ,p_effective_start_date Out nocopy Date
370: ,p_effective_end_date Out nocopy Date
371: ,p_ordr_num In Number default hr_api.g_number
372: ,p_number_value1 In Number default hr_api.g_number
367: ,p_eligy_prfl_id In Number default hr_api.g_number
368: ,p_eligy_criteria_id In Number default hr_api.g_number
369: ,p_effective_start_date Out nocopy Date
370: ,p_effective_end_date Out nocopy Date
371: ,p_ordr_num In Number default hr_api.g_number
372: ,p_number_value1 In Number default hr_api.g_number
373: ,p_number_value2 In Number default hr_api.g_number
374: ,p_char_value1 In Varchar2 default hr_api.g_varchar2
375: ,p_char_value2 In Varchar2 default hr_api.g_varchar2
368: ,p_eligy_criteria_id In Number default hr_api.g_number
369: ,p_effective_start_date Out nocopy Date
370: ,p_effective_end_date Out nocopy Date
371: ,p_ordr_num In Number default hr_api.g_number
372: ,p_number_value1 In Number default hr_api.g_number
373: ,p_number_value2 In Number default hr_api.g_number
374: ,p_char_value1 In Varchar2 default hr_api.g_varchar2
375: ,p_char_value2 In Varchar2 default hr_api.g_varchar2
376: ,p_date_value1 In Date default hr_api.g_date
369: ,p_effective_start_date Out nocopy Date
370: ,p_effective_end_date Out nocopy Date
371: ,p_ordr_num In Number default hr_api.g_number
372: ,p_number_value1 In Number default hr_api.g_number
373: ,p_number_value2 In Number default hr_api.g_number
374: ,p_char_value1 In Varchar2 default hr_api.g_varchar2
375: ,p_char_value2 In Varchar2 default hr_api.g_varchar2
376: ,p_date_value1 In Date default hr_api.g_date
377: ,p_date_value2 In Date default hr_api.g_date
370: ,p_effective_end_date Out nocopy Date
371: ,p_ordr_num In Number default hr_api.g_number
372: ,p_number_value1 In Number default hr_api.g_number
373: ,p_number_value2 In Number default hr_api.g_number
374: ,p_char_value1 In Varchar2 default hr_api.g_varchar2
375: ,p_char_value2 In Varchar2 default hr_api.g_varchar2
376: ,p_date_value1 In Date default hr_api.g_date
377: ,p_date_value2 In Date default hr_api.g_date
378: ,p_excld_flag In Varchar2 default hr_api.g_varchar2
371: ,p_ordr_num In Number default hr_api.g_number
372: ,p_number_value1 In Number default hr_api.g_number
373: ,p_number_value2 In Number default hr_api.g_number
374: ,p_char_value1 In Varchar2 default hr_api.g_varchar2
375: ,p_char_value2 In Varchar2 default hr_api.g_varchar2
376: ,p_date_value1 In Date default hr_api.g_date
377: ,p_date_value2 In Date default hr_api.g_date
378: ,p_excld_flag In Varchar2 default hr_api.g_varchar2
379: ,p_business_group_id In Number default hr_api.g_number
372: ,p_number_value1 In Number default hr_api.g_number
373: ,p_number_value2 In Number default hr_api.g_number
374: ,p_char_value1 In Varchar2 default hr_api.g_varchar2
375: ,p_char_value2 In Varchar2 default hr_api.g_varchar2
376: ,p_date_value1 In Date default hr_api.g_date
377: ,p_date_value2 In Date default hr_api.g_date
378: ,p_excld_flag In Varchar2 default hr_api.g_varchar2
379: ,p_business_group_id In Number default hr_api.g_number
380: ,p_ecv_attribute_category In Varchar2 default hr_api.g_varchar2
373: ,p_number_value2 In Number default hr_api.g_number
374: ,p_char_value1 In Varchar2 default hr_api.g_varchar2
375: ,p_char_value2 In Varchar2 default hr_api.g_varchar2
376: ,p_date_value1 In Date default hr_api.g_date
377: ,p_date_value2 In Date default hr_api.g_date
378: ,p_excld_flag In Varchar2 default hr_api.g_varchar2
379: ,p_business_group_id In Number default hr_api.g_number
380: ,p_ecv_attribute_category In Varchar2 default hr_api.g_varchar2
381: ,p_ecv_attribute1 In Varchar2 default hr_api.g_varchar2
374: ,p_char_value1 In Varchar2 default hr_api.g_varchar2
375: ,p_char_value2 In Varchar2 default hr_api.g_varchar2
376: ,p_date_value1 In Date default hr_api.g_date
377: ,p_date_value2 In Date default hr_api.g_date
378: ,p_excld_flag In Varchar2 default hr_api.g_varchar2
379: ,p_business_group_id In Number default hr_api.g_number
380: ,p_ecv_attribute_category In Varchar2 default hr_api.g_varchar2
381: ,p_ecv_attribute1 In Varchar2 default hr_api.g_varchar2
382: ,p_ecv_attribute2 In Varchar2 default hr_api.g_varchar2
375: ,p_char_value2 In Varchar2 default hr_api.g_varchar2
376: ,p_date_value1 In Date default hr_api.g_date
377: ,p_date_value2 In Date default hr_api.g_date
378: ,p_excld_flag In Varchar2 default hr_api.g_varchar2
379: ,p_business_group_id In Number default hr_api.g_number
380: ,p_ecv_attribute_category In Varchar2 default hr_api.g_varchar2
381: ,p_ecv_attribute1 In Varchar2 default hr_api.g_varchar2
382: ,p_ecv_attribute2 In Varchar2 default hr_api.g_varchar2
383: ,p_ecv_attribute3 In Varchar2 default hr_api.g_varchar2
376: ,p_date_value1 In Date default hr_api.g_date
377: ,p_date_value2 In Date default hr_api.g_date
378: ,p_excld_flag In Varchar2 default hr_api.g_varchar2
379: ,p_business_group_id In Number default hr_api.g_number
380: ,p_ecv_attribute_category In Varchar2 default hr_api.g_varchar2
381: ,p_ecv_attribute1 In Varchar2 default hr_api.g_varchar2
382: ,p_ecv_attribute2 In Varchar2 default hr_api.g_varchar2
383: ,p_ecv_attribute3 In Varchar2 default hr_api.g_varchar2
384: ,p_ecv_attribute4 In Varchar2 default hr_api.g_varchar2
377: ,p_date_value2 In Date default hr_api.g_date
378: ,p_excld_flag In Varchar2 default hr_api.g_varchar2
379: ,p_business_group_id In Number default hr_api.g_number
380: ,p_ecv_attribute_category In Varchar2 default hr_api.g_varchar2
381: ,p_ecv_attribute1 In Varchar2 default hr_api.g_varchar2
382: ,p_ecv_attribute2 In Varchar2 default hr_api.g_varchar2
383: ,p_ecv_attribute3 In Varchar2 default hr_api.g_varchar2
384: ,p_ecv_attribute4 In Varchar2 default hr_api.g_varchar2
385: ,p_ecv_attribute5 In Varchar2 default hr_api.g_varchar2
378: ,p_excld_flag In Varchar2 default hr_api.g_varchar2
379: ,p_business_group_id In Number default hr_api.g_number
380: ,p_ecv_attribute_category In Varchar2 default hr_api.g_varchar2
381: ,p_ecv_attribute1 In Varchar2 default hr_api.g_varchar2
382: ,p_ecv_attribute2 In Varchar2 default hr_api.g_varchar2
383: ,p_ecv_attribute3 In Varchar2 default hr_api.g_varchar2
384: ,p_ecv_attribute4 In Varchar2 default hr_api.g_varchar2
385: ,p_ecv_attribute5 In Varchar2 default hr_api.g_varchar2
386: ,p_ecv_attribute6 In Varchar2 default hr_api.g_varchar2
379: ,p_business_group_id In Number default hr_api.g_number
380: ,p_ecv_attribute_category In Varchar2 default hr_api.g_varchar2
381: ,p_ecv_attribute1 In Varchar2 default hr_api.g_varchar2
382: ,p_ecv_attribute2 In Varchar2 default hr_api.g_varchar2
383: ,p_ecv_attribute3 In Varchar2 default hr_api.g_varchar2
384: ,p_ecv_attribute4 In Varchar2 default hr_api.g_varchar2
385: ,p_ecv_attribute5 In Varchar2 default hr_api.g_varchar2
386: ,p_ecv_attribute6 In Varchar2 default hr_api.g_varchar2
387: ,p_ecv_attribute7 In Varchar2 default hr_api.g_varchar2
380: ,p_ecv_attribute_category In Varchar2 default hr_api.g_varchar2
381: ,p_ecv_attribute1 In Varchar2 default hr_api.g_varchar2
382: ,p_ecv_attribute2 In Varchar2 default hr_api.g_varchar2
383: ,p_ecv_attribute3 In Varchar2 default hr_api.g_varchar2
384: ,p_ecv_attribute4 In Varchar2 default hr_api.g_varchar2
385: ,p_ecv_attribute5 In Varchar2 default hr_api.g_varchar2
386: ,p_ecv_attribute6 In Varchar2 default hr_api.g_varchar2
387: ,p_ecv_attribute7 In Varchar2 default hr_api.g_varchar2
388: ,p_ecv_attribute8 In Varchar2 default hr_api.g_varchar2
381: ,p_ecv_attribute1 In Varchar2 default hr_api.g_varchar2
382: ,p_ecv_attribute2 In Varchar2 default hr_api.g_varchar2
383: ,p_ecv_attribute3 In Varchar2 default hr_api.g_varchar2
384: ,p_ecv_attribute4 In Varchar2 default hr_api.g_varchar2
385: ,p_ecv_attribute5 In Varchar2 default hr_api.g_varchar2
386: ,p_ecv_attribute6 In Varchar2 default hr_api.g_varchar2
387: ,p_ecv_attribute7 In Varchar2 default hr_api.g_varchar2
388: ,p_ecv_attribute8 In Varchar2 default hr_api.g_varchar2
389: ,p_ecv_attribute9 In Varchar2 default hr_api.g_varchar2
382: ,p_ecv_attribute2 In Varchar2 default hr_api.g_varchar2
383: ,p_ecv_attribute3 In Varchar2 default hr_api.g_varchar2
384: ,p_ecv_attribute4 In Varchar2 default hr_api.g_varchar2
385: ,p_ecv_attribute5 In Varchar2 default hr_api.g_varchar2
386: ,p_ecv_attribute6 In Varchar2 default hr_api.g_varchar2
387: ,p_ecv_attribute7 In Varchar2 default hr_api.g_varchar2
388: ,p_ecv_attribute8 In Varchar2 default hr_api.g_varchar2
389: ,p_ecv_attribute9 In Varchar2 default hr_api.g_varchar2
390: ,p_ecv_attribute10 In Varchar2 default hr_api.g_varchar2
383: ,p_ecv_attribute3 In Varchar2 default hr_api.g_varchar2
384: ,p_ecv_attribute4 In Varchar2 default hr_api.g_varchar2
385: ,p_ecv_attribute5 In Varchar2 default hr_api.g_varchar2
386: ,p_ecv_attribute6 In Varchar2 default hr_api.g_varchar2
387: ,p_ecv_attribute7 In Varchar2 default hr_api.g_varchar2
388: ,p_ecv_attribute8 In Varchar2 default hr_api.g_varchar2
389: ,p_ecv_attribute9 In Varchar2 default hr_api.g_varchar2
390: ,p_ecv_attribute10 In Varchar2 default hr_api.g_varchar2
391: ,p_ecv_attribute11 In Varchar2 default hr_api.g_varchar2
384: ,p_ecv_attribute4 In Varchar2 default hr_api.g_varchar2
385: ,p_ecv_attribute5 In Varchar2 default hr_api.g_varchar2
386: ,p_ecv_attribute6 In Varchar2 default hr_api.g_varchar2
387: ,p_ecv_attribute7 In Varchar2 default hr_api.g_varchar2
388: ,p_ecv_attribute8 In Varchar2 default hr_api.g_varchar2
389: ,p_ecv_attribute9 In Varchar2 default hr_api.g_varchar2
390: ,p_ecv_attribute10 In Varchar2 default hr_api.g_varchar2
391: ,p_ecv_attribute11 In Varchar2 default hr_api.g_varchar2
392: ,p_ecv_attribute12 In Varchar2 default hr_api.g_varchar2
385: ,p_ecv_attribute5 In Varchar2 default hr_api.g_varchar2
386: ,p_ecv_attribute6 In Varchar2 default hr_api.g_varchar2
387: ,p_ecv_attribute7 In Varchar2 default hr_api.g_varchar2
388: ,p_ecv_attribute8 In Varchar2 default hr_api.g_varchar2
389: ,p_ecv_attribute9 In Varchar2 default hr_api.g_varchar2
390: ,p_ecv_attribute10 In Varchar2 default hr_api.g_varchar2
391: ,p_ecv_attribute11 In Varchar2 default hr_api.g_varchar2
392: ,p_ecv_attribute12 In Varchar2 default hr_api.g_varchar2
393: ,p_ecv_attribute13 In Varchar2 default hr_api.g_varchar2
386: ,p_ecv_attribute6 In Varchar2 default hr_api.g_varchar2
387: ,p_ecv_attribute7 In Varchar2 default hr_api.g_varchar2
388: ,p_ecv_attribute8 In Varchar2 default hr_api.g_varchar2
389: ,p_ecv_attribute9 In Varchar2 default hr_api.g_varchar2
390: ,p_ecv_attribute10 In Varchar2 default hr_api.g_varchar2
391: ,p_ecv_attribute11 In Varchar2 default hr_api.g_varchar2
392: ,p_ecv_attribute12 In Varchar2 default hr_api.g_varchar2
393: ,p_ecv_attribute13 In Varchar2 default hr_api.g_varchar2
394: ,p_ecv_attribute14 In Varchar2 default hr_api.g_varchar2
387: ,p_ecv_attribute7 In Varchar2 default hr_api.g_varchar2
388: ,p_ecv_attribute8 In Varchar2 default hr_api.g_varchar2
389: ,p_ecv_attribute9 In Varchar2 default hr_api.g_varchar2
390: ,p_ecv_attribute10 In Varchar2 default hr_api.g_varchar2
391: ,p_ecv_attribute11 In Varchar2 default hr_api.g_varchar2
392: ,p_ecv_attribute12 In Varchar2 default hr_api.g_varchar2
393: ,p_ecv_attribute13 In Varchar2 default hr_api.g_varchar2
394: ,p_ecv_attribute14 In Varchar2 default hr_api.g_varchar2
395: ,p_ecv_attribute15 In Varchar2 default hr_api.g_varchar2
388: ,p_ecv_attribute8 In Varchar2 default hr_api.g_varchar2
389: ,p_ecv_attribute9 In Varchar2 default hr_api.g_varchar2
390: ,p_ecv_attribute10 In Varchar2 default hr_api.g_varchar2
391: ,p_ecv_attribute11 In Varchar2 default hr_api.g_varchar2
392: ,p_ecv_attribute12 In Varchar2 default hr_api.g_varchar2
393: ,p_ecv_attribute13 In Varchar2 default hr_api.g_varchar2
394: ,p_ecv_attribute14 In Varchar2 default hr_api.g_varchar2
395: ,p_ecv_attribute15 In Varchar2 default hr_api.g_varchar2
396: ,p_ecv_attribute16 In Varchar2 default hr_api.g_varchar2
389: ,p_ecv_attribute9 In Varchar2 default hr_api.g_varchar2
390: ,p_ecv_attribute10 In Varchar2 default hr_api.g_varchar2
391: ,p_ecv_attribute11 In Varchar2 default hr_api.g_varchar2
392: ,p_ecv_attribute12 In Varchar2 default hr_api.g_varchar2
393: ,p_ecv_attribute13 In Varchar2 default hr_api.g_varchar2
394: ,p_ecv_attribute14 In Varchar2 default hr_api.g_varchar2
395: ,p_ecv_attribute15 In Varchar2 default hr_api.g_varchar2
396: ,p_ecv_attribute16 In Varchar2 default hr_api.g_varchar2
397: ,p_ecv_attribute17 In Varchar2 default hr_api.g_varchar2
390: ,p_ecv_attribute10 In Varchar2 default hr_api.g_varchar2
391: ,p_ecv_attribute11 In Varchar2 default hr_api.g_varchar2
392: ,p_ecv_attribute12 In Varchar2 default hr_api.g_varchar2
393: ,p_ecv_attribute13 In Varchar2 default hr_api.g_varchar2
394: ,p_ecv_attribute14 In Varchar2 default hr_api.g_varchar2
395: ,p_ecv_attribute15 In Varchar2 default hr_api.g_varchar2
396: ,p_ecv_attribute16 In Varchar2 default hr_api.g_varchar2
397: ,p_ecv_attribute17 In Varchar2 default hr_api.g_varchar2
398: ,p_ecv_attribute18 In Varchar2 default hr_api.g_varchar2
391: ,p_ecv_attribute11 In Varchar2 default hr_api.g_varchar2
392: ,p_ecv_attribute12 In Varchar2 default hr_api.g_varchar2
393: ,p_ecv_attribute13 In Varchar2 default hr_api.g_varchar2
394: ,p_ecv_attribute14 In Varchar2 default hr_api.g_varchar2
395: ,p_ecv_attribute15 In Varchar2 default hr_api.g_varchar2
396: ,p_ecv_attribute16 In Varchar2 default hr_api.g_varchar2
397: ,p_ecv_attribute17 In Varchar2 default hr_api.g_varchar2
398: ,p_ecv_attribute18 In Varchar2 default hr_api.g_varchar2
399: ,p_ecv_attribute19 In Varchar2 default hr_api.g_varchar2
392: ,p_ecv_attribute12 In Varchar2 default hr_api.g_varchar2
393: ,p_ecv_attribute13 In Varchar2 default hr_api.g_varchar2
394: ,p_ecv_attribute14 In Varchar2 default hr_api.g_varchar2
395: ,p_ecv_attribute15 In Varchar2 default hr_api.g_varchar2
396: ,p_ecv_attribute16 In Varchar2 default hr_api.g_varchar2
397: ,p_ecv_attribute17 In Varchar2 default hr_api.g_varchar2
398: ,p_ecv_attribute18 In Varchar2 default hr_api.g_varchar2
399: ,p_ecv_attribute19 In Varchar2 default hr_api.g_varchar2
400: ,p_ecv_attribute20 In Varchar2 default hr_api.g_varchar2
393: ,p_ecv_attribute13 In Varchar2 default hr_api.g_varchar2
394: ,p_ecv_attribute14 In Varchar2 default hr_api.g_varchar2
395: ,p_ecv_attribute15 In Varchar2 default hr_api.g_varchar2
396: ,p_ecv_attribute16 In Varchar2 default hr_api.g_varchar2
397: ,p_ecv_attribute17 In Varchar2 default hr_api.g_varchar2
398: ,p_ecv_attribute18 In Varchar2 default hr_api.g_varchar2
399: ,p_ecv_attribute19 In Varchar2 default hr_api.g_varchar2
400: ,p_ecv_attribute20 In Varchar2 default hr_api.g_varchar2
401: ,p_ecv_attribute21 In Varchar2 default hr_api.g_varchar2
394: ,p_ecv_attribute14 In Varchar2 default hr_api.g_varchar2
395: ,p_ecv_attribute15 In Varchar2 default hr_api.g_varchar2
396: ,p_ecv_attribute16 In Varchar2 default hr_api.g_varchar2
397: ,p_ecv_attribute17 In Varchar2 default hr_api.g_varchar2
398: ,p_ecv_attribute18 In Varchar2 default hr_api.g_varchar2
399: ,p_ecv_attribute19 In Varchar2 default hr_api.g_varchar2
400: ,p_ecv_attribute20 In Varchar2 default hr_api.g_varchar2
401: ,p_ecv_attribute21 In Varchar2 default hr_api.g_varchar2
402: ,p_ecv_attribute22 In Varchar2 default hr_api.g_varchar2
395: ,p_ecv_attribute15 In Varchar2 default hr_api.g_varchar2
396: ,p_ecv_attribute16 In Varchar2 default hr_api.g_varchar2
397: ,p_ecv_attribute17 In Varchar2 default hr_api.g_varchar2
398: ,p_ecv_attribute18 In Varchar2 default hr_api.g_varchar2
399: ,p_ecv_attribute19 In Varchar2 default hr_api.g_varchar2
400: ,p_ecv_attribute20 In Varchar2 default hr_api.g_varchar2
401: ,p_ecv_attribute21 In Varchar2 default hr_api.g_varchar2
402: ,p_ecv_attribute22 In Varchar2 default hr_api.g_varchar2
403: ,p_ecv_attribute23 In Varchar2 default hr_api.g_varchar2
396: ,p_ecv_attribute16 In Varchar2 default hr_api.g_varchar2
397: ,p_ecv_attribute17 In Varchar2 default hr_api.g_varchar2
398: ,p_ecv_attribute18 In Varchar2 default hr_api.g_varchar2
399: ,p_ecv_attribute19 In Varchar2 default hr_api.g_varchar2
400: ,p_ecv_attribute20 In Varchar2 default hr_api.g_varchar2
401: ,p_ecv_attribute21 In Varchar2 default hr_api.g_varchar2
402: ,p_ecv_attribute22 In Varchar2 default hr_api.g_varchar2
403: ,p_ecv_attribute23 In Varchar2 default hr_api.g_varchar2
404: ,p_ecv_attribute24 In Varchar2 default hr_api.g_varchar2
397: ,p_ecv_attribute17 In Varchar2 default hr_api.g_varchar2
398: ,p_ecv_attribute18 In Varchar2 default hr_api.g_varchar2
399: ,p_ecv_attribute19 In Varchar2 default hr_api.g_varchar2
400: ,p_ecv_attribute20 In Varchar2 default hr_api.g_varchar2
401: ,p_ecv_attribute21 In Varchar2 default hr_api.g_varchar2
402: ,p_ecv_attribute22 In Varchar2 default hr_api.g_varchar2
403: ,p_ecv_attribute23 In Varchar2 default hr_api.g_varchar2
404: ,p_ecv_attribute24 In Varchar2 default hr_api.g_varchar2
405: ,p_ecv_attribute25 In Varchar2 default hr_api.g_varchar2
398: ,p_ecv_attribute18 In Varchar2 default hr_api.g_varchar2
399: ,p_ecv_attribute19 In Varchar2 default hr_api.g_varchar2
400: ,p_ecv_attribute20 In Varchar2 default hr_api.g_varchar2
401: ,p_ecv_attribute21 In Varchar2 default hr_api.g_varchar2
402: ,p_ecv_attribute22 In Varchar2 default hr_api.g_varchar2
403: ,p_ecv_attribute23 In Varchar2 default hr_api.g_varchar2
404: ,p_ecv_attribute24 In Varchar2 default hr_api.g_varchar2
405: ,p_ecv_attribute25 In Varchar2 default hr_api.g_varchar2
406: ,p_ecv_attribute26 In Varchar2 default hr_api.g_varchar2
399: ,p_ecv_attribute19 In Varchar2 default hr_api.g_varchar2
400: ,p_ecv_attribute20 In Varchar2 default hr_api.g_varchar2
401: ,p_ecv_attribute21 In Varchar2 default hr_api.g_varchar2
402: ,p_ecv_attribute22 In Varchar2 default hr_api.g_varchar2
403: ,p_ecv_attribute23 In Varchar2 default hr_api.g_varchar2
404: ,p_ecv_attribute24 In Varchar2 default hr_api.g_varchar2
405: ,p_ecv_attribute25 In Varchar2 default hr_api.g_varchar2
406: ,p_ecv_attribute26 In Varchar2 default hr_api.g_varchar2
407: ,p_ecv_attribute27 In Varchar2 default hr_api.g_varchar2
400: ,p_ecv_attribute20 In Varchar2 default hr_api.g_varchar2
401: ,p_ecv_attribute21 In Varchar2 default hr_api.g_varchar2
402: ,p_ecv_attribute22 In Varchar2 default hr_api.g_varchar2
403: ,p_ecv_attribute23 In Varchar2 default hr_api.g_varchar2
404: ,p_ecv_attribute24 In Varchar2 default hr_api.g_varchar2
405: ,p_ecv_attribute25 In Varchar2 default hr_api.g_varchar2
406: ,p_ecv_attribute26 In Varchar2 default hr_api.g_varchar2
407: ,p_ecv_attribute27 In Varchar2 default hr_api.g_varchar2
408: ,p_ecv_attribute28 In Varchar2 default hr_api.g_varchar2
401: ,p_ecv_attribute21 In Varchar2 default hr_api.g_varchar2
402: ,p_ecv_attribute22 In Varchar2 default hr_api.g_varchar2
403: ,p_ecv_attribute23 In Varchar2 default hr_api.g_varchar2
404: ,p_ecv_attribute24 In Varchar2 default hr_api.g_varchar2
405: ,p_ecv_attribute25 In Varchar2 default hr_api.g_varchar2
406: ,p_ecv_attribute26 In Varchar2 default hr_api.g_varchar2
407: ,p_ecv_attribute27 In Varchar2 default hr_api.g_varchar2
408: ,p_ecv_attribute28 In Varchar2 default hr_api.g_varchar2
409: ,p_ecv_attribute29 In Varchar2 default hr_api.g_varchar2
402: ,p_ecv_attribute22 In Varchar2 default hr_api.g_varchar2
403: ,p_ecv_attribute23 In Varchar2 default hr_api.g_varchar2
404: ,p_ecv_attribute24 In Varchar2 default hr_api.g_varchar2
405: ,p_ecv_attribute25 In Varchar2 default hr_api.g_varchar2
406: ,p_ecv_attribute26 In Varchar2 default hr_api.g_varchar2
407: ,p_ecv_attribute27 In Varchar2 default hr_api.g_varchar2
408: ,p_ecv_attribute28 In Varchar2 default hr_api.g_varchar2
409: ,p_ecv_attribute29 In Varchar2 default hr_api.g_varchar2
410: ,p_ecv_attribute30 In Varchar2 default hr_api.g_varchar2
403: ,p_ecv_attribute23 In Varchar2 default hr_api.g_varchar2
404: ,p_ecv_attribute24 In Varchar2 default hr_api.g_varchar2
405: ,p_ecv_attribute25 In Varchar2 default hr_api.g_varchar2
406: ,p_ecv_attribute26 In Varchar2 default hr_api.g_varchar2
407: ,p_ecv_attribute27 In Varchar2 default hr_api.g_varchar2
408: ,p_ecv_attribute28 In Varchar2 default hr_api.g_varchar2
409: ,p_ecv_attribute29 In Varchar2 default hr_api.g_varchar2
410: ,p_ecv_attribute30 In Varchar2 default hr_api.g_varchar2
411: ,p_object_version_number In Out nocopy Number
404: ,p_ecv_attribute24 In Varchar2 default hr_api.g_varchar2
405: ,p_ecv_attribute25 In Varchar2 default hr_api.g_varchar2
406: ,p_ecv_attribute26 In Varchar2 default hr_api.g_varchar2
407: ,p_ecv_attribute27 In Varchar2 default hr_api.g_varchar2
408: ,p_ecv_attribute28 In Varchar2 default hr_api.g_varchar2
409: ,p_ecv_attribute29 In Varchar2 default hr_api.g_varchar2
410: ,p_ecv_attribute30 In Varchar2 default hr_api.g_varchar2
411: ,p_object_version_number In Out nocopy Number
412: ,p_effective_date In Date
405: ,p_ecv_attribute25 In Varchar2 default hr_api.g_varchar2
406: ,p_ecv_attribute26 In Varchar2 default hr_api.g_varchar2
407: ,p_ecv_attribute27 In Varchar2 default hr_api.g_varchar2
408: ,p_ecv_attribute28 In Varchar2 default hr_api.g_varchar2
409: ,p_ecv_attribute29 In Varchar2 default hr_api.g_varchar2
410: ,p_ecv_attribute30 In Varchar2 default hr_api.g_varchar2
411: ,p_object_version_number In Out nocopy Number
412: ,p_effective_date In Date
413: ,p_datetrack_mode In varchar2
406: ,p_ecv_attribute26 In Varchar2 default hr_api.g_varchar2
407: ,p_ecv_attribute27 In Varchar2 default hr_api.g_varchar2
408: ,p_ecv_attribute28 In Varchar2 default hr_api.g_varchar2
409: ,p_ecv_attribute29 In Varchar2 default hr_api.g_varchar2
410: ,p_ecv_attribute30 In Varchar2 default hr_api.g_varchar2
411: ,p_object_version_number In Out nocopy Number
412: ,p_effective_date In Date
413: ,p_datetrack_mode In varchar2
414: ,p_criteria_score In Number default hr_api.g_number
410: ,p_ecv_attribute30 In Varchar2 default hr_api.g_varchar2
411: ,p_object_version_number In Out nocopy Number
412: ,p_effective_date In Date
413: ,p_datetrack_mode In varchar2
414: ,p_criteria_score In Number default hr_api.g_number
415: ,p_criteria_weight In Number default hr_api.g_number
416: ,p_char_value3 In Varchar2 default hr_api.g_varchar2
417: ,p_char_value4 In Varchar2 default hr_api.g_varchar2
418: ,p_number_value3 In Number default hr_api.g_number
411: ,p_object_version_number In Out nocopy Number
412: ,p_effective_date In Date
413: ,p_datetrack_mode In varchar2
414: ,p_criteria_score In Number default hr_api.g_number
415: ,p_criteria_weight In Number default hr_api.g_number
416: ,p_char_value3 In Varchar2 default hr_api.g_varchar2
417: ,p_char_value4 In Varchar2 default hr_api.g_varchar2
418: ,p_number_value3 In Number default hr_api.g_number
419: ,p_number_value4 In Number default hr_api.g_number
412: ,p_effective_date In Date
413: ,p_datetrack_mode In varchar2
414: ,p_criteria_score In Number default hr_api.g_number
415: ,p_criteria_weight In Number default hr_api.g_number
416: ,p_char_value3 In Varchar2 default hr_api.g_varchar2
417: ,p_char_value4 In Varchar2 default hr_api.g_varchar2
418: ,p_number_value3 In Number default hr_api.g_number
419: ,p_number_value4 In Number default hr_api.g_number
420: ,p_date_value3 In Date default hr_api.g_date
413: ,p_datetrack_mode In varchar2
414: ,p_criteria_score In Number default hr_api.g_number
415: ,p_criteria_weight In Number default hr_api.g_number
416: ,p_char_value3 In Varchar2 default hr_api.g_varchar2
417: ,p_char_value4 In Varchar2 default hr_api.g_varchar2
418: ,p_number_value3 In Number default hr_api.g_number
419: ,p_number_value4 In Number default hr_api.g_number
420: ,p_date_value3 In Date default hr_api.g_date
421: ,p_date_value4 In Date default hr_api.g_date
414: ,p_criteria_score In Number default hr_api.g_number
415: ,p_criteria_weight In Number default hr_api.g_number
416: ,p_char_value3 In Varchar2 default hr_api.g_varchar2
417: ,p_char_value4 In Varchar2 default hr_api.g_varchar2
418: ,p_number_value3 In Number default hr_api.g_number
419: ,p_number_value4 In Number default hr_api.g_number
420: ,p_date_value3 In Date default hr_api.g_date
421: ,p_date_value4 In Date default hr_api.g_date
422: ) is
415: ,p_criteria_weight In Number default hr_api.g_number
416: ,p_char_value3 In Varchar2 default hr_api.g_varchar2
417: ,p_char_value4 In Varchar2 default hr_api.g_varchar2
418: ,p_number_value3 In Number default hr_api.g_number
419: ,p_number_value4 In Number default hr_api.g_number
420: ,p_date_value3 In Date default hr_api.g_date
421: ,p_date_value4 In Date default hr_api.g_date
422: ) is
423: --
416: ,p_char_value3 In Varchar2 default hr_api.g_varchar2
417: ,p_char_value4 In Varchar2 default hr_api.g_varchar2
418: ,p_number_value3 In Number default hr_api.g_number
419: ,p_number_value4 In Number default hr_api.g_number
420: ,p_date_value3 In Date default hr_api.g_date
421: ,p_date_value4 In Date default hr_api.g_date
422: ) is
423: --
424: -- Declare cursors and local variables
417: ,p_char_value4 In Varchar2 default hr_api.g_varchar2
418: ,p_number_value3 In Number default hr_api.g_number
419: ,p_number_value4 In Number default hr_api.g_number
420: ,p_date_value3 In Date default hr_api.g_date
421: ,p_date_value4 In Date default hr_api.g_date
422: ) is
423: --
424: -- Declare cursors and local variables
425: --
503: p_date_value3 => p_date_value3,
504: p_date_value4 => p_date_value4
505: );
506: exception
507: when hr_api.cannot_find_prog_unit then
508: hr_api.cannot_find_prog_unit_error
509: (p_module_name => 'UPDATE_eligy_crit_values'
510: ,p_hook_type => 'BP'
511: );
504: p_date_value4 => p_date_value4
505: );
506: exception
507: when hr_api.cannot_find_prog_unit then
508: hr_api.cannot_find_prog_unit_error
509: (p_module_name => 'UPDATE_eligy_crit_values'
510: ,p_hook_type => 'BP'
511: );
512: --
640: p_date_value4 => p_date_value4
641: );
642:
643: exception
644: when hr_api.cannot_find_prog_unit then
645: hr_api.cannot_find_prog_unit_error
646: (p_module_name => 'UPDATE_eligy_crit_values'
647: ,p_hook_type => 'AP'
648: );
641: );
642:
643: exception
644: when hr_api.cannot_find_prog_unit then
645: hr_api.cannot_find_prog_unit_error
646: (p_module_name => 'UPDATE_eligy_crit_values'
647: ,p_hook_type => 'AP'
648: );
649: --
655: --
656: -- When in validation only mode raise the Validate_Enabled exception
657: --
658: if p_validate then
659: raise hr_api.validate_enabled;
660: end if;
661: --
662: -- Set all output arguments
663: --
668: hr_utility.set_location(' Leaving:'||l_proc, 70);
669: --
670: exception
671: --
672: when hr_api.validate_enabled then
673: --
674: -- As the Validate_Enabled exception has been raised
675: -- we must rollback to the savepoint
676: --
743: ,p_effective_date => trunc(p_effective_date)
744: ,p_datetrack_mode => p_datetrack_mode
745: );
746: exception
747: when hr_api.cannot_find_prog_unit then
748: hr_api.cannot_find_prog_unit_error
749: (p_module_name => 'DELETE_eligy_crit_values'
750: ,p_hook_type => 'BP'
751: );
744: ,p_datetrack_mode => p_datetrack_mode
745: );
746: exception
747: when hr_api.cannot_find_prog_unit then
748: hr_api.cannot_find_prog_unit_error
749: (p_module_name => 'DELETE_eligy_crit_values'
750: ,p_hook_type => 'BP'
751: );
752: --
777: ,p_effective_date => trunc(p_effective_date)
778: ,p_datetrack_mode => p_datetrack_mode
779: );
780: exception
781: when hr_api.cannot_find_prog_unit then
782: hr_api.cannot_find_prog_unit_error
783: (p_module_name => 'DELETE_eligy_crit_values'
784: ,p_hook_type => 'AP'
785: );
778: ,p_datetrack_mode => p_datetrack_mode
779: );
780: exception
781: when hr_api.cannot_find_prog_unit then
782: hr_api.cannot_find_prog_unit_error
783: (p_module_name => 'DELETE_eligy_crit_values'
784: ,p_hook_type => 'AP'
785: );
786: --
801: --
802: -- When in validation only mode raise the Validate_Enabled exception
803: --
804: if p_validate then
805: raise hr_api.validate_enabled;
806: end if;
807: --
808: hr_utility.set_location(' Leaving:'||l_proc, 70);
809: --
808: hr_utility.set_location(' Leaving:'||l_proc, 70);
809: --
810: exception
811: --
812: when hr_api.validate_enabled then
813: --
814: -- As the Validate_Enabled exception has been raised
815: -- we must rollback to the savepoint
816: --