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

Line 153: when hr_api.cannot_find_prog_unit then

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'

Line 154: hr_api.cannot_find_prog_unit_error

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

Line 288: when hr_api.cannot_find_prog_unit then

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

Line 289: hr_api.cannot_find_prog_unit_error

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:

Line 313: raise hr_api.validate_enabled;

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: --

Line 327: when hr_api.validate_enabled then

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: --

Line 367: ,p_eligy_prfl_id In Number default hr_api.g_number

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

Line 368: ,p_eligy_criteria_id 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

Line 371: ,p_ordr_num 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

Line 372: ,p_number_value1 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
376: ,p_date_value1 In Date default hr_api.g_date

Line 373: ,p_number_value2 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
377: ,p_date_value2 In Date default hr_api.g_date

Line 374: ,p_char_value1 In Varchar2 default hr_api.g_varchar2

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

Line 375: ,p_char_value2 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

Line 376: ,p_date_value1 In Date default hr_api.g_date

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

Line 377: ,p_date_value2 In Date default hr_api.g_date

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

Line 378: ,p_excld_flag 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

Line 379: ,p_business_group_id In Number default hr_api.g_number

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

Line 380: ,p_ecv_attribute_category 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

Line 381: ,p_ecv_attribute1 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

Line 382: ,p_ecv_attribute2 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

Line 383: ,p_ecv_attribute3 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

Line 384: ,p_ecv_attribute4 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

Line 385: ,p_ecv_attribute5 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

Line 386: ,p_ecv_attribute6 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

Line 387: ,p_ecv_attribute7 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

Line 388: ,p_ecv_attribute8 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

Line 389: ,p_ecv_attribute9 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

Line 390: ,p_ecv_attribute10 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

Line 391: ,p_ecv_attribute11 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

Line 392: ,p_ecv_attribute12 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

Line 393: ,p_ecv_attribute13 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

Line 394: ,p_ecv_attribute14 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

Line 395: ,p_ecv_attribute15 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

Line 396: ,p_ecv_attribute16 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

Line 397: ,p_ecv_attribute17 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

Line 398: ,p_ecv_attribute18 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

Line 399: ,p_ecv_attribute19 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

Line 400: ,p_ecv_attribute20 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

Line 401: ,p_ecv_attribute21 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

Line 402: ,p_ecv_attribute22 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

Line 403: ,p_ecv_attribute23 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

Line 404: ,p_ecv_attribute24 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

Line 405: ,p_ecv_attribute25 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

Line 406: ,p_ecv_attribute26 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

Line 407: ,p_ecv_attribute27 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

Line 408: ,p_ecv_attribute28 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
412: ,p_effective_date In Date

Line 409: ,p_ecv_attribute29 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
413: ,p_datetrack_mode In varchar2

Line 410: ,p_ecv_attribute30 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
414: ,p_criteria_score In Number default hr_api.g_number

Line 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

Line 415: ,p_criteria_weight 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

Line 416: ,p_char_value3 In Varchar2 default hr_api.g_varchar2

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

Line 417: ,p_char_value4 In Varchar2 default hr_api.g_varchar2

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

Line 418: ,p_number_value3 In Number default hr_api.g_number

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

Line 419: ,p_number_value4 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
423: --

Line 420: ,p_date_value3 In Date default hr_api.g_date

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

Line 421: ,p_date_value4 In Date default hr_api.g_date

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: --

Line 507: when hr_api.cannot_find_prog_unit then

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

Line 508: hr_api.cannot_find_prog_unit_error

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: --

Line 644: when hr_api.cannot_find_prog_unit then

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

Line 645: hr_api.cannot_find_prog_unit_error

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: --

Line 659: raise hr_api.validate_enabled;

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: --

Line 672: when hr_api.validate_enabled then

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: --

Line 747: when hr_api.cannot_find_prog_unit then

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

Line 748: hr_api.cannot_find_prog_unit_error

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: --

Line 781: when hr_api.cannot_find_prog_unit then

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

Line 782: hr_api.cannot_find_prog_unit_error

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: --

Line 805: raise hr_api.validate_enabled;

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: --

Line 812: when hr_api.validate_enabled then

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: --