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

Line 149: when hr_api.cannot_find_prog_unit then

145: p_date_value3 => p_date_value3,
146: p_date_value4 => p_date_value4
147: );
148: exception
149: when hr_api.cannot_find_prog_unit then
150: hr_api.cannot_find_prog_unit_error
151: (
152: p_module_name => 'CREATE_dpnt_eligy_crit_val'
153: ,p_hook_type => 'BP'

Line 150: hr_api.cannot_find_prog_unit_error

146: p_date_value4 => p_date_value4
147: );
148: exception
149: when hr_api.cannot_find_prog_unit then
150: hr_api.cannot_find_prog_unit_error
151: (
152: p_module_name => 'CREATE_dpnt_eligy_crit_val'
153: ,p_hook_type => 'BP'
154: );

Line 280: when hr_api.cannot_find_prog_unit then

276: p_date_value3 => p_date_value3,
277: p_date_value4 => p_date_value4
278: );
279: exception
280: when hr_api.cannot_find_prog_unit then
281: hr_api.cannot_find_prog_unit_error
282: (p_module_name => 'CREATE_dpnt_eligy_crit_val'
283: ,p_hook_type => 'AP'
284: );

Line 281: hr_api.cannot_find_prog_unit_error

277: p_date_value4 => p_date_value4
278: );
279: exception
280: when hr_api.cannot_find_prog_unit then
281: hr_api.cannot_find_prog_unit_error
282: (p_module_name => 'CREATE_dpnt_eligy_crit_val'
283: ,p_hook_type => 'AP'
284: );
285:

Line 305: raise hr_api.validate_enabled;

301: --
302: -- When in validation only mode raise the Validate_Enabled exception
303: --
304: if p_validate then
305: raise hr_api.validate_enabled;
306: end if;
307: --
308: -- Set all output arguments
309: --

Line 319: when hr_api.validate_enabled then

315: hr_utility.set_location(' Leaving:'||l_proc, 70);
316: --
317: exception
318: --
319: when hr_api.validate_enabled then
320: --
321: -- As the Validate_Enabled exception has been raised
322: -- we must rollback to the savepoint
323: --

Line 359: ,p_dpnt_cvg_eligy_prfl_id In Number default hr_api.g_number

355: procedure update_dpnt_eligy_crit_val
356: (
357: p_validate In Boolean default false
358: ,p_dpnt_eligy_crit_values_id In Number
359: ,p_dpnt_cvg_eligy_prfl_id In Number default hr_api.g_number
360: ,p_eligy_criteria_dpnt_id In Number default hr_api.g_number
361: ,p_effective_start_date Out nocopy Date
362: ,p_effective_end_date Out nocopy Date
363: ,p_ordr_num In Number default hr_api.g_number

Line 360: ,p_eligy_criteria_dpnt_id In Number default hr_api.g_number

356: (
357: p_validate In Boolean default false
358: ,p_dpnt_eligy_crit_values_id In Number
359: ,p_dpnt_cvg_eligy_prfl_id In Number default hr_api.g_number
360: ,p_eligy_criteria_dpnt_id In Number default hr_api.g_number
361: ,p_effective_start_date Out nocopy Date
362: ,p_effective_end_date Out nocopy Date
363: ,p_ordr_num In Number default hr_api.g_number
364: ,p_number_value1 In Number default hr_api.g_number

Line 363: ,p_ordr_num In Number default hr_api.g_number

359: ,p_dpnt_cvg_eligy_prfl_id In Number default hr_api.g_number
360: ,p_eligy_criteria_dpnt_id In Number default hr_api.g_number
361: ,p_effective_start_date Out nocopy Date
362: ,p_effective_end_date Out nocopy Date
363: ,p_ordr_num In Number default hr_api.g_number
364: ,p_number_value1 In Number default hr_api.g_number
365: ,p_number_value2 In Number default hr_api.g_number
366: ,p_char_value1 In Varchar2 default hr_api.g_varchar2
367: ,p_char_value2 In Varchar2 default hr_api.g_varchar2

Line 364: ,p_number_value1 In Number default hr_api.g_number

360: ,p_eligy_criteria_dpnt_id In Number default hr_api.g_number
361: ,p_effective_start_date Out nocopy Date
362: ,p_effective_end_date Out nocopy Date
363: ,p_ordr_num In Number default hr_api.g_number
364: ,p_number_value1 In Number default hr_api.g_number
365: ,p_number_value2 In Number default hr_api.g_number
366: ,p_char_value1 In Varchar2 default hr_api.g_varchar2
367: ,p_char_value2 In Varchar2 default hr_api.g_varchar2
368: ,p_date_value1 In Date default hr_api.g_date

Line 365: ,p_number_value2 In Number default hr_api.g_number

361: ,p_effective_start_date Out nocopy Date
362: ,p_effective_end_date Out nocopy Date
363: ,p_ordr_num In Number default hr_api.g_number
364: ,p_number_value1 In Number default hr_api.g_number
365: ,p_number_value2 In Number default hr_api.g_number
366: ,p_char_value1 In Varchar2 default hr_api.g_varchar2
367: ,p_char_value2 In Varchar2 default hr_api.g_varchar2
368: ,p_date_value1 In Date default hr_api.g_date
369: ,p_date_value2 In Date default hr_api.g_date

Line 366: ,p_char_value1 In Varchar2 default hr_api.g_varchar2

362: ,p_effective_end_date Out nocopy Date
363: ,p_ordr_num In Number default hr_api.g_number
364: ,p_number_value1 In Number default hr_api.g_number
365: ,p_number_value2 In Number default hr_api.g_number
366: ,p_char_value1 In Varchar2 default hr_api.g_varchar2
367: ,p_char_value2 In Varchar2 default hr_api.g_varchar2
368: ,p_date_value1 In Date default hr_api.g_date
369: ,p_date_value2 In Date default hr_api.g_date
370: ,p_excld_flag In Varchar2 default hr_api.g_varchar2

Line 367: ,p_char_value2 In Varchar2 default hr_api.g_varchar2

363: ,p_ordr_num In Number default hr_api.g_number
364: ,p_number_value1 In Number default hr_api.g_number
365: ,p_number_value2 In Number default hr_api.g_number
366: ,p_char_value1 In Varchar2 default hr_api.g_varchar2
367: ,p_char_value2 In Varchar2 default hr_api.g_varchar2
368: ,p_date_value1 In Date default hr_api.g_date
369: ,p_date_value2 In Date default hr_api.g_date
370: ,p_excld_flag In Varchar2 default hr_api.g_varchar2
371: ,p_business_group_id In Number default hr_api.g_number

Line 368: ,p_date_value1 In Date default hr_api.g_date

364: ,p_number_value1 In Number default hr_api.g_number
365: ,p_number_value2 In Number default hr_api.g_number
366: ,p_char_value1 In Varchar2 default hr_api.g_varchar2
367: ,p_char_value2 In Varchar2 default hr_api.g_varchar2
368: ,p_date_value1 In Date default hr_api.g_date
369: ,p_date_value2 In Date default hr_api.g_date
370: ,p_excld_flag In Varchar2 default hr_api.g_varchar2
371: ,p_business_group_id In Number default hr_api.g_number
372: ,p_edc_attribute_category In Varchar2 default hr_api.g_varchar2

Line 369: ,p_date_value2 In Date default hr_api.g_date

365: ,p_number_value2 In Number default hr_api.g_number
366: ,p_char_value1 In Varchar2 default hr_api.g_varchar2
367: ,p_char_value2 In Varchar2 default hr_api.g_varchar2
368: ,p_date_value1 In Date default hr_api.g_date
369: ,p_date_value2 In Date default hr_api.g_date
370: ,p_excld_flag In Varchar2 default hr_api.g_varchar2
371: ,p_business_group_id In Number default hr_api.g_number
372: ,p_edc_attribute_category In Varchar2 default hr_api.g_varchar2
373: ,p_edc_attribute1 In Varchar2 default hr_api.g_varchar2

Line 370: ,p_excld_flag In Varchar2 default hr_api.g_varchar2

366: ,p_char_value1 In Varchar2 default hr_api.g_varchar2
367: ,p_char_value2 In Varchar2 default hr_api.g_varchar2
368: ,p_date_value1 In Date default hr_api.g_date
369: ,p_date_value2 In Date default hr_api.g_date
370: ,p_excld_flag In Varchar2 default hr_api.g_varchar2
371: ,p_business_group_id In Number default hr_api.g_number
372: ,p_edc_attribute_category In Varchar2 default hr_api.g_varchar2
373: ,p_edc_attribute1 In Varchar2 default hr_api.g_varchar2
374: ,p_edc_attribute2 In Varchar2 default hr_api.g_varchar2

Line 371: ,p_business_group_id In Number default hr_api.g_number

367: ,p_char_value2 In Varchar2 default hr_api.g_varchar2
368: ,p_date_value1 In Date default hr_api.g_date
369: ,p_date_value2 In Date default hr_api.g_date
370: ,p_excld_flag In Varchar2 default hr_api.g_varchar2
371: ,p_business_group_id In Number default hr_api.g_number
372: ,p_edc_attribute_category In Varchar2 default hr_api.g_varchar2
373: ,p_edc_attribute1 In Varchar2 default hr_api.g_varchar2
374: ,p_edc_attribute2 In Varchar2 default hr_api.g_varchar2
375: ,p_edc_attribute3 In Varchar2 default hr_api.g_varchar2

Line 372: ,p_edc_attribute_category In Varchar2 default hr_api.g_varchar2

368: ,p_date_value1 In Date default hr_api.g_date
369: ,p_date_value2 In Date default hr_api.g_date
370: ,p_excld_flag In Varchar2 default hr_api.g_varchar2
371: ,p_business_group_id In Number default hr_api.g_number
372: ,p_edc_attribute_category In Varchar2 default hr_api.g_varchar2
373: ,p_edc_attribute1 In Varchar2 default hr_api.g_varchar2
374: ,p_edc_attribute2 In Varchar2 default hr_api.g_varchar2
375: ,p_edc_attribute3 In Varchar2 default hr_api.g_varchar2
376: ,p_edc_attribute4 In Varchar2 default hr_api.g_varchar2

Line 373: ,p_edc_attribute1 In Varchar2 default hr_api.g_varchar2

369: ,p_date_value2 In Date default hr_api.g_date
370: ,p_excld_flag In Varchar2 default hr_api.g_varchar2
371: ,p_business_group_id In Number default hr_api.g_number
372: ,p_edc_attribute_category In Varchar2 default hr_api.g_varchar2
373: ,p_edc_attribute1 In Varchar2 default hr_api.g_varchar2
374: ,p_edc_attribute2 In Varchar2 default hr_api.g_varchar2
375: ,p_edc_attribute3 In Varchar2 default hr_api.g_varchar2
376: ,p_edc_attribute4 In Varchar2 default hr_api.g_varchar2
377: ,p_edc_attribute5 In Varchar2 default hr_api.g_varchar2

Line 374: ,p_edc_attribute2 In Varchar2 default hr_api.g_varchar2

370: ,p_excld_flag In Varchar2 default hr_api.g_varchar2
371: ,p_business_group_id In Number default hr_api.g_number
372: ,p_edc_attribute_category In Varchar2 default hr_api.g_varchar2
373: ,p_edc_attribute1 In Varchar2 default hr_api.g_varchar2
374: ,p_edc_attribute2 In Varchar2 default hr_api.g_varchar2
375: ,p_edc_attribute3 In Varchar2 default hr_api.g_varchar2
376: ,p_edc_attribute4 In Varchar2 default hr_api.g_varchar2
377: ,p_edc_attribute5 In Varchar2 default hr_api.g_varchar2
378: ,p_edc_attribute6 In Varchar2 default hr_api.g_varchar2

Line 375: ,p_edc_attribute3 In Varchar2 default hr_api.g_varchar2

371: ,p_business_group_id In Number default hr_api.g_number
372: ,p_edc_attribute_category In Varchar2 default hr_api.g_varchar2
373: ,p_edc_attribute1 In Varchar2 default hr_api.g_varchar2
374: ,p_edc_attribute2 In Varchar2 default hr_api.g_varchar2
375: ,p_edc_attribute3 In Varchar2 default hr_api.g_varchar2
376: ,p_edc_attribute4 In Varchar2 default hr_api.g_varchar2
377: ,p_edc_attribute5 In Varchar2 default hr_api.g_varchar2
378: ,p_edc_attribute6 In Varchar2 default hr_api.g_varchar2
379: ,p_edc_attribute7 In Varchar2 default hr_api.g_varchar2

Line 376: ,p_edc_attribute4 In Varchar2 default hr_api.g_varchar2

372: ,p_edc_attribute_category In Varchar2 default hr_api.g_varchar2
373: ,p_edc_attribute1 In Varchar2 default hr_api.g_varchar2
374: ,p_edc_attribute2 In Varchar2 default hr_api.g_varchar2
375: ,p_edc_attribute3 In Varchar2 default hr_api.g_varchar2
376: ,p_edc_attribute4 In Varchar2 default hr_api.g_varchar2
377: ,p_edc_attribute5 In Varchar2 default hr_api.g_varchar2
378: ,p_edc_attribute6 In Varchar2 default hr_api.g_varchar2
379: ,p_edc_attribute7 In Varchar2 default hr_api.g_varchar2
380: ,p_edc_attribute8 In Varchar2 default hr_api.g_varchar2

Line 377: ,p_edc_attribute5 In Varchar2 default hr_api.g_varchar2

373: ,p_edc_attribute1 In Varchar2 default hr_api.g_varchar2
374: ,p_edc_attribute2 In Varchar2 default hr_api.g_varchar2
375: ,p_edc_attribute3 In Varchar2 default hr_api.g_varchar2
376: ,p_edc_attribute4 In Varchar2 default hr_api.g_varchar2
377: ,p_edc_attribute5 In Varchar2 default hr_api.g_varchar2
378: ,p_edc_attribute6 In Varchar2 default hr_api.g_varchar2
379: ,p_edc_attribute7 In Varchar2 default hr_api.g_varchar2
380: ,p_edc_attribute8 In Varchar2 default hr_api.g_varchar2
381: ,p_edc_attribute9 In Varchar2 default hr_api.g_varchar2

Line 378: ,p_edc_attribute6 In Varchar2 default hr_api.g_varchar2

374: ,p_edc_attribute2 In Varchar2 default hr_api.g_varchar2
375: ,p_edc_attribute3 In Varchar2 default hr_api.g_varchar2
376: ,p_edc_attribute4 In Varchar2 default hr_api.g_varchar2
377: ,p_edc_attribute5 In Varchar2 default hr_api.g_varchar2
378: ,p_edc_attribute6 In Varchar2 default hr_api.g_varchar2
379: ,p_edc_attribute7 In Varchar2 default hr_api.g_varchar2
380: ,p_edc_attribute8 In Varchar2 default hr_api.g_varchar2
381: ,p_edc_attribute9 In Varchar2 default hr_api.g_varchar2
382: ,p_edc_attribute10 In Varchar2 default hr_api.g_varchar2

Line 379: ,p_edc_attribute7 In Varchar2 default hr_api.g_varchar2

375: ,p_edc_attribute3 In Varchar2 default hr_api.g_varchar2
376: ,p_edc_attribute4 In Varchar2 default hr_api.g_varchar2
377: ,p_edc_attribute5 In Varchar2 default hr_api.g_varchar2
378: ,p_edc_attribute6 In Varchar2 default hr_api.g_varchar2
379: ,p_edc_attribute7 In Varchar2 default hr_api.g_varchar2
380: ,p_edc_attribute8 In Varchar2 default hr_api.g_varchar2
381: ,p_edc_attribute9 In Varchar2 default hr_api.g_varchar2
382: ,p_edc_attribute10 In Varchar2 default hr_api.g_varchar2
383: ,p_edc_attribute11 In Varchar2 default hr_api.g_varchar2

Line 380: ,p_edc_attribute8 In Varchar2 default hr_api.g_varchar2

376: ,p_edc_attribute4 In Varchar2 default hr_api.g_varchar2
377: ,p_edc_attribute5 In Varchar2 default hr_api.g_varchar2
378: ,p_edc_attribute6 In Varchar2 default hr_api.g_varchar2
379: ,p_edc_attribute7 In Varchar2 default hr_api.g_varchar2
380: ,p_edc_attribute8 In Varchar2 default hr_api.g_varchar2
381: ,p_edc_attribute9 In Varchar2 default hr_api.g_varchar2
382: ,p_edc_attribute10 In Varchar2 default hr_api.g_varchar2
383: ,p_edc_attribute11 In Varchar2 default hr_api.g_varchar2
384: ,p_edc_attribute12 In Varchar2 default hr_api.g_varchar2

Line 381: ,p_edc_attribute9 In Varchar2 default hr_api.g_varchar2

377: ,p_edc_attribute5 In Varchar2 default hr_api.g_varchar2
378: ,p_edc_attribute6 In Varchar2 default hr_api.g_varchar2
379: ,p_edc_attribute7 In Varchar2 default hr_api.g_varchar2
380: ,p_edc_attribute8 In Varchar2 default hr_api.g_varchar2
381: ,p_edc_attribute9 In Varchar2 default hr_api.g_varchar2
382: ,p_edc_attribute10 In Varchar2 default hr_api.g_varchar2
383: ,p_edc_attribute11 In Varchar2 default hr_api.g_varchar2
384: ,p_edc_attribute12 In Varchar2 default hr_api.g_varchar2
385: ,p_edc_attribute13 In Varchar2 default hr_api.g_varchar2

Line 382: ,p_edc_attribute10 In Varchar2 default hr_api.g_varchar2

378: ,p_edc_attribute6 In Varchar2 default hr_api.g_varchar2
379: ,p_edc_attribute7 In Varchar2 default hr_api.g_varchar2
380: ,p_edc_attribute8 In Varchar2 default hr_api.g_varchar2
381: ,p_edc_attribute9 In Varchar2 default hr_api.g_varchar2
382: ,p_edc_attribute10 In Varchar2 default hr_api.g_varchar2
383: ,p_edc_attribute11 In Varchar2 default hr_api.g_varchar2
384: ,p_edc_attribute12 In Varchar2 default hr_api.g_varchar2
385: ,p_edc_attribute13 In Varchar2 default hr_api.g_varchar2
386: ,p_edc_attribute14 In Varchar2 default hr_api.g_varchar2

Line 383: ,p_edc_attribute11 In Varchar2 default hr_api.g_varchar2

379: ,p_edc_attribute7 In Varchar2 default hr_api.g_varchar2
380: ,p_edc_attribute8 In Varchar2 default hr_api.g_varchar2
381: ,p_edc_attribute9 In Varchar2 default hr_api.g_varchar2
382: ,p_edc_attribute10 In Varchar2 default hr_api.g_varchar2
383: ,p_edc_attribute11 In Varchar2 default hr_api.g_varchar2
384: ,p_edc_attribute12 In Varchar2 default hr_api.g_varchar2
385: ,p_edc_attribute13 In Varchar2 default hr_api.g_varchar2
386: ,p_edc_attribute14 In Varchar2 default hr_api.g_varchar2
387: ,p_edc_attribute15 In Varchar2 default hr_api.g_varchar2

Line 384: ,p_edc_attribute12 In Varchar2 default hr_api.g_varchar2

380: ,p_edc_attribute8 In Varchar2 default hr_api.g_varchar2
381: ,p_edc_attribute9 In Varchar2 default hr_api.g_varchar2
382: ,p_edc_attribute10 In Varchar2 default hr_api.g_varchar2
383: ,p_edc_attribute11 In Varchar2 default hr_api.g_varchar2
384: ,p_edc_attribute12 In Varchar2 default hr_api.g_varchar2
385: ,p_edc_attribute13 In Varchar2 default hr_api.g_varchar2
386: ,p_edc_attribute14 In Varchar2 default hr_api.g_varchar2
387: ,p_edc_attribute15 In Varchar2 default hr_api.g_varchar2
388: ,p_edc_attribute16 In Varchar2 default hr_api.g_varchar2

Line 385: ,p_edc_attribute13 In Varchar2 default hr_api.g_varchar2

381: ,p_edc_attribute9 In Varchar2 default hr_api.g_varchar2
382: ,p_edc_attribute10 In Varchar2 default hr_api.g_varchar2
383: ,p_edc_attribute11 In Varchar2 default hr_api.g_varchar2
384: ,p_edc_attribute12 In Varchar2 default hr_api.g_varchar2
385: ,p_edc_attribute13 In Varchar2 default hr_api.g_varchar2
386: ,p_edc_attribute14 In Varchar2 default hr_api.g_varchar2
387: ,p_edc_attribute15 In Varchar2 default hr_api.g_varchar2
388: ,p_edc_attribute16 In Varchar2 default hr_api.g_varchar2
389: ,p_edc_attribute17 In Varchar2 default hr_api.g_varchar2

Line 386: ,p_edc_attribute14 In Varchar2 default hr_api.g_varchar2

382: ,p_edc_attribute10 In Varchar2 default hr_api.g_varchar2
383: ,p_edc_attribute11 In Varchar2 default hr_api.g_varchar2
384: ,p_edc_attribute12 In Varchar2 default hr_api.g_varchar2
385: ,p_edc_attribute13 In Varchar2 default hr_api.g_varchar2
386: ,p_edc_attribute14 In Varchar2 default hr_api.g_varchar2
387: ,p_edc_attribute15 In Varchar2 default hr_api.g_varchar2
388: ,p_edc_attribute16 In Varchar2 default hr_api.g_varchar2
389: ,p_edc_attribute17 In Varchar2 default hr_api.g_varchar2
390: ,p_edc_attribute18 In Varchar2 default hr_api.g_varchar2

Line 387: ,p_edc_attribute15 In Varchar2 default hr_api.g_varchar2

383: ,p_edc_attribute11 In Varchar2 default hr_api.g_varchar2
384: ,p_edc_attribute12 In Varchar2 default hr_api.g_varchar2
385: ,p_edc_attribute13 In Varchar2 default hr_api.g_varchar2
386: ,p_edc_attribute14 In Varchar2 default hr_api.g_varchar2
387: ,p_edc_attribute15 In Varchar2 default hr_api.g_varchar2
388: ,p_edc_attribute16 In Varchar2 default hr_api.g_varchar2
389: ,p_edc_attribute17 In Varchar2 default hr_api.g_varchar2
390: ,p_edc_attribute18 In Varchar2 default hr_api.g_varchar2
391: ,p_edc_attribute19 In Varchar2 default hr_api.g_varchar2

Line 388: ,p_edc_attribute16 In Varchar2 default hr_api.g_varchar2

384: ,p_edc_attribute12 In Varchar2 default hr_api.g_varchar2
385: ,p_edc_attribute13 In Varchar2 default hr_api.g_varchar2
386: ,p_edc_attribute14 In Varchar2 default hr_api.g_varchar2
387: ,p_edc_attribute15 In Varchar2 default hr_api.g_varchar2
388: ,p_edc_attribute16 In Varchar2 default hr_api.g_varchar2
389: ,p_edc_attribute17 In Varchar2 default hr_api.g_varchar2
390: ,p_edc_attribute18 In Varchar2 default hr_api.g_varchar2
391: ,p_edc_attribute19 In Varchar2 default hr_api.g_varchar2
392: ,p_edc_attribute20 In Varchar2 default hr_api.g_varchar2

Line 389: ,p_edc_attribute17 In Varchar2 default hr_api.g_varchar2

385: ,p_edc_attribute13 In Varchar2 default hr_api.g_varchar2
386: ,p_edc_attribute14 In Varchar2 default hr_api.g_varchar2
387: ,p_edc_attribute15 In Varchar2 default hr_api.g_varchar2
388: ,p_edc_attribute16 In Varchar2 default hr_api.g_varchar2
389: ,p_edc_attribute17 In Varchar2 default hr_api.g_varchar2
390: ,p_edc_attribute18 In Varchar2 default hr_api.g_varchar2
391: ,p_edc_attribute19 In Varchar2 default hr_api.g_varchar2
392: ,p_edc_attribute20 In Varchar2 default hr_api.g_varchar2
393: ,p_edc_attribute21 In Varchar2 default hr_api.g_varchar2

Line 390: ,p_edc_attribute18 In Varchar2 default hr_api.g_varchar2

386: ,p_edc_attribute14 In Varchar2 default hr_api.g_varchar2
387: ,p_edc_attribute15 In Varchar2 default hr_api.g_varchar2
388: ,p_edc_attribute16 In Varchar2 default hr_api.g_varchar2
389: ,p_edc_attribute17 In Varchar2 default hr_api.g_varchar2
390: ,p_edc_attribute18 In Varchar2 default hr_api.g_varchar2
391: ,p_edc_attribute19 In Varchar2 default hr_api.g_varchar2
392: ,p_edc_attribute20 In Varchar2 default hr_api.g_varchar2
393: ,p_edc_attribute21 In Varchar2 default hr_api.g_varchar2
394: ,p_edc_attribute22 In Varchar2 default hr_api.g_varchar2

Line 391: ,p_edc_attribute19 In Varchar2 default hr_api.g_varchar2

387: ,p_edc_attribute15 In Varchar2 default hr_api.g_varchar2
388: ,p_edc_attribute16 In Varchar2 default hr_api.g_varchar2
389: ,p_edc_attribute17 In Varchar2 default hr_api.g_varchar2
390: ,p_edc_attribute18 In Varchar2 default hr_api.g_varchar2
391: ,p_edc_attribute19 In Varchar2 default hr_api.g_varchar2
392: ,p_edc_attribute20 In Varchar2 default hr_api.g_varchar2
393: ,p_edc_attribute21 In Varchar2 default hr_api.g_varchar2
394: ,p_edc_attribute22 In Varchar2 default hr_api.g_varchar2
395: ,p_edc_attribute23 In Varchar2 default hr_api.g_varchar2

Line 392: ,p_edc_attribute20 In Varchar2 default hr_api.g_varchar2

388: ,p_edc_attribute16 In Varchar2 default hr_api.g_varchar2
389: ,p_edc_attribute17 In Varchar2 default hr_api.g_varchar2
390: ,p_edc_attribute18 In Varchar2 default hr_api.g_varchar2
391: ,p_edc_attribute19 In Varchar2 default hr_api.g_varchar2
392: ,p_edc_attribute20 In Varchar2 default hr_api.g_varchar2
393: ,p_edc_attribute21 In Varchar2 default hr_api.g_varchar2
394: ,p_edc_attribute22 In Varchar2 default hr_api.g_varchar2
395: ,p_edc_attribute23 In Varchar2 default hr_api.g_varchar2
396: ,p_edc_attribute24 In Varchar2 default hr_api.g_varchar2

Line 393: ,p_edc_attribute21 In Varchar2 default hr_api.g_varchar2

389: ,p_edc_attribute17 In Varchar2 default hr_api.g_varchar2
390: ,p_edc_attribute18 In Varchar2 default hr_api.g_varchar2
391: ,p_edc_attribute19 In Varchar2 default hr_api.g_varchar2
392: ,p_edc_attribute20 In Varchar2 default hr_api.g_varchar2
393: ,p_edc_attribute21 In Varchar2 default hr_api.g_varchar2
394: ,p_edc_attribute22 In Varchar2 default hr_api.g_varchar2
395: ,p_edc_attribute23 In Varchar2 default hr_api.g_varchar2
396: ,p_edc_attribute24 In Varchar2 default hr_api.g_varchar2
397: ,p_edc_attribute25 In Varchar2 default hr_api.g_varchar2

Line 394: ,p_edc_attribute22 In Varchar2 default hr_api.g_varchar2

390: ,p_edc_attribute18 In Varchar2 default hr_api.g_varchar2
391: ,p_edc_attribute19 In Varchar2 default hr_api.g_varchar2
392: ,p_edc_attribute20 In Varchar2 default hr_api.g_varchar2
393: ,p_edc_attribute21 In Varchar2 default hr_api.g_varchar2
394: ,p_edc_attribute22 In Varchar2 default hr_api.g_varchar2
395: ,p_edc_attribute23 In Varchar2 default hr_api.g_varchar2
396: ,p_edc_attribute24 In Varchar2 default hr_api.g_varchar2
397: ,p_edc_attribute25 In Varchar2 default hr_api.g_varchar2
398: ,p_edc_attribute26 In Varchar2 default hr_api.g_varchar2

Line 395: ,p_edc_attribute23 In Varchar2 default hr_api.g_varchar2

391: ,p_edc_attribute19 In Varchar2 default hr_api.g_varchar2
392: ,p_edc_attribute20 In Varchar2 default hr_api.g_varchar2
393: ,p_edc_attribute21 In Varchar2 default hr_api.g_varchar2
394: ,p_edc_attribute22 In Varchar2 default hr_api.g_varchar2
395: ,p_edc_attribute23 In Varchar2 default hr_api.g_varchar2
396: ,p_edc_attribute24 In Varchar2 default hr_api.g_varchar2
397: ,p_edc_attribute25 In Varchar2 default hr_api.g_varchar2
398: ,p_edc_attribute26 In Varchar2 default hr_api.g_varchar2
399: ,p_edc_attribute27 In Varchar2 default hr_api.g_varchar2

Line 396: ,p_edc_attribute24 In Varchar2 default hr_api.g_varchar2

392: ,p_edc_attribute20 In Varchar2 default hr_api.g_varchar2
393: ,p_edc_attribute21 In Varchar2 default hr_api.g_varchar2
394: ,p_edc_attribute22 In Varchar2 default hr_api.g_varchar2
395: ,p_edc_attribute23 In Varchar2 default hr_api.g_varchar2
396: ,p_edc_attribute24 In Varchar2 default hr_api.g_varchar2
397: ,p_edc_attribute25 In Varchar2 default hr_api.g_varchar2
398: ,p_edc_attribute26 In Varchar2 default hr_api.g_varchar2
399: ,p_edc_attribute27 In Varchar2 default hr_api.g_varchar2
400: ,p_edc_attribute28 In Varchar2 default hr_api.g_varchar2

Line 397: ,p_edc_attribute25 In Varchar2 default hr_api.g_varchar2

393: ,p_edc_attribute21 In Varchar2 default hr_api.g_varchar2
394: ,p_edc_attribute22 In Varchar2 default hr_api.g_varchar2
395: ,p_edc_attribute23 In Varchar2 default hr_api.g_varchar2
396: ,p_edc_attribute24 In Varchar2 default hr_api.g_varchar2
397: ,p_edc_attribute25 In Varchar2 default hr_api.g_varchar2
398: ,p_edc_attribute26 In Varchar2 default hr_api.g_varchar2
399: ,p_edc_attribute27 In Varchar2 default hr_api.g_varchar2
400: ,p_edc_attribute28 In Varchar2 default hr_api.g_varchar2
401: ,p_edc_attribute29 In Varchar2 default hr_api.g_varchar2

Line 398: ,p_edc_attribute26 In Varchar2 default hr_api.g_varchar2

394: ,p_edc_attribute22 In Varchar2 default hr_api.g_varchar2
395: ,p_edc_attribute23 In Varchar2 default hr_api.g_varchar2
396: ,p_edc_attribute24 In Varchar2 default hr_api.g_varchar2
397: ,p_edc_attribute25 In Varchar2 default hr_api.g_varchar2
398: ,p_edc_attribute26 In Varchar2 default hr_api.g_varchar2
399: ,p_edc_attribute27 In Varchar2 default hr_api.g_varchar2
400: ,p_edc_attribute28 In Varchar2 default hr_api.g_varchar2
401: ,p_edc_attribute29 In Varchar2 default hr_api.g_varchar2
402: ,p_edc_attribute30 In Varchar2 default hr_api.g_varchar2

Line 399: ,p_edc_attribute27 In Varchar2 default hr_api.g_varchar2

395: ,p_edc_attribute23 In Varchar2 default hr_api.g_varchar2
396: ,p_edc_attribute24 In Varchar2 default hr_api.g_varchar2
397: ,p_edc_attribute25 In Varchar2 default hr_api.g_varchar2
398: ,p_edc_attribute26 In Varchar2 default hr_api.g_varchar2
399: ,p_edc_attribute27 In Varchar2 default hr_api.g_varchar2
400: ,p_edc_attribute28 In Varchar2 default hr_api.g_varchar2
401: ,p_edc_attribute29 In Varchar2 default hr_api.g_varchar2
402: ,p_edc_attribute30 In Varchar2 default hr_api.g_varchar2
403: ,p_object_version_number In Out nocopy Number

Line 400: ,p_edc_attribute28 In Varchar2 default hr_api.g_varchar2

396: ,p_edc_attribute24 In Varchar2 default hr_api.g_varchar2
397: ,p_edc_attribute25 In Varchar2 default hr_api.g_varchar2
398: ,p_edc_attribute26 In Varchar2 default hr_api.g_varchar2
399: ,p_edc_attribute27 In Varchar2 default hr_api.g_varchar2
400: ,p_edc_attribute28 In Varchar2 default hr_api.g_varchar2
401: ,p_edc_attribute29 In Varchar2 default hr_api.g_varchar2
402: ,p_edc_attribute30 In Varchar2 default hr_api.g_varchar2
403: ,p_object_version_number In Out nocopy Number
404: ,p_effective_date In Date

Line 401: ,p_edc_attribute29 In Varchar2 default hr_api.g_varchar2

397: ,p_edc_attribute25 In Varchar2 default hr_api.g_varchar2
398: ,p_edc_attribute26 In Varchar2 default hr_api.g_varchar2
399: ,p_edc_attribute27 In Varchar2 default hr_api.g_varchar2
400: ,p_edc_attribute28 In Varchar2 default hr_api.g_varchar2
401: ,p_edc_attribute29 In Varchar2 default hr_api.g_varchar2
402: ,p_edc_attribute30 In Varchar2 default hr_api.g_varchar2
403: ,p_object_version_number In Out nocopy Number
404: ,p_effective_date In Date
405: ,p_datetrack_mode In varchar2

Line 402: ,p_edc_attribute30 In Varchar2 default hr_api.g_varchar2

398: ,p_edc_attribute26 In Varchar2 default hr_api.g_varchar2
399: ,p_edc_attribute27 In Varchar2 default hr_api.g_varchar2
400: ,p_edc_attribute28 In Varchar2 default hr_api.g_varchar2
401: ,p_edc_attribute29 In Varchar2 default hr_api.g_varchar2
402: ,p_edc_attribute30 In Varchar2 default hr_api.g_varchar2
403: ,p_object_version_number In Out nocopy Number
404: ,p_effective_date In Date
405: ,p_datetrack_mode In varchar2
406: ,p_char_value3 In Varchar2 default hr_api.g_varchar2

Line 406: ,p_char_value3 In Varchar2 default hr_api.g_varchar2

402: ,p_edc_attribute30 In Varchar2 default hr_api.g_varchar2
403: ,p_object_version_number In Out nocopy Number
404: ,p_effective_date In Date
405: ,p_datetrack_mode In varchar2
406: ,p_char_value3 In Varchar2 default hr_api.g_varchar2
407: ,p_char_value4 In Varchar2 default hr_api.g_varchar2
408: ,p_number_value3 In Number default hr_api.g_number
409: ,p_number_value4 In Number default hr_api.g_number
410: ,p_date_value3 In Date default hr_api.g_date

Line 407: ,p_char_value4 In Varchar2 default hr_api.g_varchar2

403: ,p_object_version_number In Out nocopy Number
404: ,p_effective_date In Date
405: ,p_datetrack_mode In varchar2
406: ,p_char_value3 In Varchar2 default hr_api.g_varchar2
407: ,p_char_value4 In Varchar2 default hr_api.g_varchar2
408: ,p_number_value3 In Number default hr_api.g_number
409: ,p_number_value4 In Number default hr_api.g_number
410: ,p_date_value3 In Date default hr_api.g_date
411: ,p_date_value4 In Date default hr_api.g_date

Line 408: ,p_number_value3 In Number default hr_api.g_number

404: ,p_effective_date In Date
405: ,p_datetrack_mode In varchar2
406: ,p_char_value3 In Varchar2 default hr_api.g_varchar2
407: ,p_char_value4 In Varchar2 default hr_api.g_varchar2
408: ,p_number_value3 In Number default hr_api.g_number
409: ,p_number_value4 In Number default hr_api.g_number
410: ,p_date_value3 In Date default hr_api.g_date
411: ,p_date_value4 In Date default hr_api.g_date
412: ) is

Line 409: ,p_number_value4 In Number default hr_api.g_number

405: ,p_datetrack_mode In varchar2
406: ,p_char_value3 In Varchar2 default hr_api.g_varchar2
407: ,p_char_value4 In Varchar2 default hr_api.g_varchar2
408: ,p_number_value3 In Number default hr_api.g_number
409: ,p_number_value4 In Number default hr_api.g_number
410: ,p_date_value3 In Date default hr_api.g_date
411: ,p_date_value4 In Date default hr_api.g_date
412: ) is
413: --

Line 410: ,p_date_value3 In Date default hr_api.g_date

406: ,p_char_value3 In Varchar2 default hr_api.g_varchar2
407: ,p_char_value4 In Varchar2 default hr_api.g_varchar2
408: ,p_number_value3 In Number default hr_api.g_number
409: ,p_number_value4 In Number default hr_api.g_number
410: ,p_date_value3 In Date default hr_api.g_date
411: ,p_date_value4 In Date default hr_api.g_date
412: ) is
413: --
414: -- Declare cursors and local variables

Line 411: ,p_date_value4 In Date default hr_api.g_date

407: ,p_char_value4 In Varchar2 default hr_api.g_varchar2
408: ,p_number_value3 In Number default hr_api.g_number
409: ,p_number_value4 In Number default hr_api.g_number
410: ,p_date_value3 In Date default hr_api.g_date
411: ,p_date_value4 In Date default hr_api.g_date
412: ) is
413: --
414: -- Declare cursors and local variables
415: --

Line 495: when hr_api.cannot_find_prog_unit then

491: p_date_value3 => p_date_value3,
492: p_date_value4 => p_date_value4
493: );
494: exception
495: when hr_api.cannot_find_prog_unit then
496: hr_api.cannot_find_prog_unit_error
497: (p_module_name => 'UPDATE_dpnt_eligy_crit_val'
498: ,p_hook_type => 'BP'
499: );

Line 496: hr_api.cannot_find_prog_unit_error

492: p_date_value4 => p_date_value4
493: );
494: exception
495: when hr_api.cannot_find_prog_unit then
496: hr_api.cannot_find_prog_unit_error
497: (p_module_name => 'UPDATE_dpnt_eligy_crit_val'
498: ,p_hook_type => 'BP'
499: );
500: --

Line 628: when hr_api.cannot_find_prog_unit then

624: p_date_value4 => p_date_value4
625: );
626:
627: exception
628: when hr_api.cannot_find_prog_unit then
629: hr_api.cannot_find_prog_unit_error
630: (p_module_name => 'UPDATE_dpnt_eligy_crit_val'
631: ,p_hook_type => 'AP'
632: );

Line 629: hr_api.cannot_find_prog_unit_error

625: );
626:
627: exception
628: when hr_api.cannot_find_prog_unit then
629: hr_api.cannot_find_prog_unit_error
630: (p_module_name => 'UPDATE_dpnt_eligy_crit_val'
631: ,p_hook_type => 'AP'
632: );
633: --

Line 643: raise hr_api.validate_enabled;

639: --
640: -- When in validation only mode raise the Validate_Enabled exception
641: --
642: if p_validate then
643: raise hr_api.validate_enabled;
644: end if;
645: --
646: -- Set all output arguments
647: --

Line 656: when hr_api.validate_enabled then

652: hr_utility.set_location(' Leaving:'||l_proc, 70);
653: --
654: exception
655: --
656: when hr_api.validate_enabled then
657: --
658: -- As the Validate_Enabled exception has been raised
659: -- we must rollback to the savepoint
660: --

Line 731: when hr_api.cannot_find_prog_unit then

727: ,p_effective_date => trunc(p_effective_date)
728: ,p_datetrack_mode => p_datetrack_mode
729: );
730: exception
731: when hr_api.cannot_find_prog_unit then
732: hr_api.cannot_find_prog_unit_error
733: (p_module_name => 'DELETE_dpnt_eligy_crit_val'
734: ,p_hook_type => 'BP'
735: );

Line 732: hr_api.cannot_find_prog_unit_error

728: ,p_datetrack_mode => p_datetrack_mode
729: );
730: exception
731: when hr_api.cannot_find_prog_unit then
732: hr_api.cannot_find_prog_unit_error
733: (p_module_name => 'DELETE_dpnt_eligy_crit_val'
734: ,p_hook_type => 'BP'
735: );
736: --

Line 765: when hr_api.cannot_find_prog_unit then

761: ,p_effective_date => trunc(p_effective_date)
762: ,p_datetrack_mode => p_datetrack_mode
763: );
764: exception
765: when hr_api.cannot_find_prog_unit then
766: hr_api.cannot_find_prog_unit_error
767: (p_module_name => 'DELETE_dpnt_eligy_crit_val'
768: ,p_hook_type => 'AP'
769: );

Line 766: hr_api.cannot_find_prog_unit_error

762: ,p_datetrack_mode => p_datetrack_mode
763: );
764: exception
765: when hr_api.cannot_find_prog_unit then
766: hr_api.cannot_find_prog_unit_error
767: (p_module_name => 'DELETE_dpnt_eligy_crit_val'
768: ,p_hook_type => 'AP'
769: );
770: --

Line 789: raise hr_api.validate_enabled;

785: --
786: -- When in validation only mode raise the Validate_Enabled exception
787: --
788: if p_validate then
789: raise hr_api.validate_enabled;
790: end if;
791: --
792: hr_utility.set_location(' Leaving:'||l_proc, 70);
793: --

Line 796: when hr_api.validate_enabled then

792: hr_utility.set_location(' Leaving:'||l_proc, 70);
793: --
794: exception
795: --
796: when hr_api.validate_enabled then
797: --
798: -- As the Validate_Enabled exception has been raised
799: -- we must rollback to the savepoint
800: --