APPS.BEN_ELIG_CRIT_DPNT_API dependencies on HR_API

Line 161: when hr_api.cannot_find_prog_unit then

157: ,p_time_access_calc_rule1 => p_time_access_calc_rule1
158: ,p_time_access_calc_rule2 => p_time_access_calc_rule2
159: );
160: exception
161: when hr_api.cannot_find_prog_unit then
162: hr_api.cannot_find_prog_unit_error
163: (
164: p_module_name => 'CREATE_dpnt_eligy_criteria'
165: ,p_hook_type => 'BP'

Line 162: hr_api.cannot_find_prog_unit_error

158: ,p_time_access_calc_rule2 => p_time_access_calc_rule2
159: );
160: exception
161: when hr_api.cannot_find_prog_unit then
162: hr_api.cannot_find_prog_unit_error
163: (
164: p_module_name => 'CREATE_dpnt_eligy_criteria'
165: ,p_hook_type => 'BP'
166: );

Line 305: when hr_api.cannot_find_prog_unit then

301: ,p_time_access_calc_rule2 => p_time_access_calc_rule2
302: );
303:
304: exception
305: when hr_api.cannot_find_prog_unit then
306: hr_api.cannot_find_prog_unit_error
307: (p_module_name => 'CREATE_dpnt_eligy_criteria'
308: ,p_hook_type => 'AP'
309: );

Line 306: hr_api.cannot_find_prog_unit_error

302: );
303:
304: exception
305: when hr_api.cannot_find_prog_unit then
306: hr_api.cannot_find_prog_unit_error
307: (p_module_name => 'CREATE_dpnt_eligy_criteria'
308: ,p_hook_type => 'AP'
309: );
310: --

Line 320: raise hr_api.validate_enabled;

316: --
317: -- When in validation only mode raise the Validate_Enabled exception
318: --
319: if p_validate then
320: raise hr_api.validate_enabled;
321: end if;
322: --
323: -- Set all output arguments
324: --

Line 332: when hr_api.validate_enabled then

328:
329: --
330: exception
331: --
332: when hr_api.validate_enabled then
333: --
334: -- As the Validate_Enabled exception has been raised
335: -- we must rollback to the savepoint
336: --

Line 365: ,p_name in varchar2 default hr_api.g_varchar2

361: procedure update_dpnt_eligy_criteria
362: (
363: p_validate in boolean default false
364: ,p_eligy_criteria_dpnt_id in number
365: ,p_name in varchar2 default hr_api.g_varchar2
366: ,p_short_code in varchar2 default hr_api.g_varchar2
367: ,p_description in varchar2 default hr_api.g_varchar2
368: ,p_criteria_type in varchar2 default hr_api.g_varchar2
369: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2

Line 366: ,p_short_code in varchar2 default hr_api.g_varchar2

362: (
363: p_validate in boolean default false
364: ,p_eligy_criteria_dpnt_id in number
365: ,p_name in varchar2 default hr_api.g_varchar2
366: ,p_short_code in varchar2 default hr_api.g_varchar2
367: ,p_description in varchar2 default hr_api.g_varchar2
368: ,p_criteria_type in varchar2 default hr_api.g_varchar2
369: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2
370: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2

Line 367: ,p_description in varchar2 default hr_api.g_varchar2

363: p_validate in boolean default false
364: ,p_eligy_criteria_dpnt_id in number
365: ,p_name in varchar2 default hr_api.g_varchar2
366: ,p_short_code in varchar2 default hr_api.g_varchar2
367: ,p_description in varchar2 default hr_api.g_varchar2
368: ,p_criteria_type in varchar2 default hr_api.g_varchar2
369: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2
370: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2
371: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2

Line 368: ,p_criteria_type in varchar2 default hr_api.g_varchar2

364: ,p_eligy_criteria_dpnt_id in number
365: ,p_name in varchar2 default hr_api.g_varchar2
366: ,p_short_code in varchar2 default hr_api.g_varchar2
367: ,p_description in varchar2 default hr_api.g_varchar2
368: ,p_criteria_type in varchar2 default hr_api.g_varchar2
369: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2
370: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2
371: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2
372: ,p_col1_value_set_id in number default hr_api.g_number

Line 369: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2

365: ,p_name in varchar2 default hr_api.g_varchar2
366: ,p_short_code in varchar2 default hr_api.g_varchar2
367: ,p_description in varchar2 default hr_api.g_varchar2
368: ,p_criteria_type in varchar2 default hr_api.g_varchar2
369: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2
370: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2
371: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2
372: ,p_col1_value_set_id in number default hr_api.g_number
373: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2

Line 370: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2

366: ,p_short_code in varchar2 default hr_api.g_varchar2
367: ,p_description in varchar2 default hr_api.g_varchar2
368: ,p_criteria_type in varchar2 default hr_api.g_varchar2
369: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2
370: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2
371: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2
372: ,p_col1_value_set_id in number default hr_api.g_number
373: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2
374: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2

Line 371: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2

367: ,p_description in varchar2 default hr_api.g_varchar2
368: ,p_criteria_type in varchar2 default hr_api.g_varchar2
369: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2
370: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2
371: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2
372: ,p_col1_value_set_id in number default hr_api.g_number
373: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2
374: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2
375: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2

Line 372: ,p_col1_value_set_id in number default hr_api.g_number

368: ,p_criteria_type in varchar2 default hr_api.g_varchar2
369: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2
370: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2
371: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2
372: ,p_col1_value_set_id in number default hr_api.g_number
373: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2
374: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2
375: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2
376: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2

Line 373: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2

369: ,p_crit_col1_val_type_cd in varchar2 default hr_api.g_varchar2
370: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2
371: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2
372: ,p_col1_value_set_id in number default hr_api.g_number
373: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2
374: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2
375: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2
376: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2
377: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2

Line 374: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2

370: ,p_crit_col1_datatype in varchar2 default hr_api.g_varchar2
371: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2
372: ,p_col1_value_set_id in number default hr_api.g_number
373: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2
374: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2
375: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2
376: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2
377: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2
378: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2

Line 375: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2

371: ,p_col1_lookup_type in varchar2 default hr_api.g_varchar2
372: ,p_col1_value_set_id in number default hr_api.g_number
373: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2
374: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2
375: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2
376: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2
377: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2
378: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2
379: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2

Line 376: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2

372: ,p_col1_value_set_id in number default hr_api.g_number
373: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2
374: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2
375: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2
376: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2
377: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2
378: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2
379: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2
380: ,p_col2_value_set_id in number default hr_api.g_number

Line 377: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2

373: ,p_access_table_name1 in varchar2 default hr_api.g_varchar2
374: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2
375: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2
376: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2
377: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2
378: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2
379: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2
380: ,p_col2_value_set_id in number default hr_api.g_number
381: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2

Line 378: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2

374: ,p_access_column_name1 in varchar2 default hr_api.g_varchar2
375: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2
376: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2
377: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2
378: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2
379: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2
380: ,p_col2_value_set_id in number default hr_api.g_number
381: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2
382: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2

Line 379: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2

375: ,p_time_entry_access_tab_nam1 in varchar2 default hr_api.g_varchar2
376: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2
377: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2
378: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2
379: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2
380: ,p_col2_value_set_id in number default hr_api.g_number
381: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2
382: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2
383: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2

Line 380: ,p_col2_value_set_id in number default hr_api.g_number

376: ,p_time_entry_access_col_nam1 in varchar2 default hr_api.g_varchar2
377: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2
378: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2
379: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2
380: ,p_col2_value_set_id in number default hr_api.g_number
381: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2
382: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2
383: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2
384: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2

Line 381: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2

377: ,p_crit_col2_val_type_cd in varchar2 default hr_api.g_varchar2
378: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2
379: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2
380: ,p_col2_value_set_id in number default hr_api.g_number
381: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2
382: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2
383: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2
384: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2
385: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2

Line 382: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2

378: ,p_crit_col2_datatype in varchar2 default hr_api.g_varchar2
379: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2
380: ,p_col2_value_set_id in number default hr_api.g_number
381: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2
382: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2
383: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2
384: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2
385: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2
386: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2

Line 383: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2

379: ,p_col2_lookup_type in varchar2 default hr_api.g_varchar2
380: ,p_col2_value_set_id in number default hr_api.g_number
381: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2
382: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2
383: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2
384: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2
385: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2
386: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2
387: ,p_business_group_id in number default hr_api.g_number

Line 384: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2

380: ,p_col2_value_set_id in number default hr_api.g_number
381: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2
382: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2
383: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2
384: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2
385: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2
386: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2
387: ,p_business_group_id in number default hr_api.g_number
388: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2

Line 385: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2

381: ,p_access_table_name2 in varchar2 default hr_api.g_varchar2
382: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2
383: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2
384: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2
385: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2
386: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2
387: ,p_business_group_id in number default hr_api.g_number
388: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
389: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2

Line 386: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2

382: ,p_access_column_name2 in varchar2 default hr_api.g_varchar2
383: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2
384: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2
385: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2
386: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2
387: ,p_business_group_id in number default hr_api.g_number
388: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
389: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
390: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2

Line 387: ,p_business_group_id in number default hr_api.g_number

383: ,p_time_entry_access_tab_nam2 in varchar2 default hr_api.g_varchar2
384: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2
385: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2
386: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2
387: ,p_business_group_id in number default hr_api.g_number
388: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
389: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
390: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
391: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2

Line 388: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2

384: ,p_time_entry_access_col_nam2 in varchar2 default hr_api.g_varchar2
385: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2
386: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2
387: ,p_business_group_id in number default hr_api.g_number
388: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
389: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
390: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
391: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
392: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2

Line 389: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2

385: ,p_allow_range_validation_flg in varchar2 default hr_api.g_varchar2
386: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2
387: ,p_business_group_id in number default hr_api.g_number
388: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
389: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
390: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
391: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
392: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
393: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2

Line 390: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2

386: ,p_user_defined_flag in varchar2 default hr_api.g_varchar2
387: ,p_business_group_id in number default hr_api.g_number
388: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
389: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
390: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
391: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
392: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
393: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
394: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2

Line 391: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2

387: ,p_business_group_id in number default hr_api.g_number
388: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
389: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
390: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
391: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
392: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
393: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
394: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
395: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2

Line 392: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2

388: ,p_egd_attribute_category in varchar2 default hr_api.g_varchar2
389: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
390: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
391: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
392: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
393: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
394: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
395: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
396: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2

Line 393: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2

389: ,p_egd_attribute1 in varchar2 default hr_api.g_varchar2
390: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
391: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
392: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
393: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
394: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
395: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
396: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
397: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2

Line 394: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2

390: ,p_egd_attribute2 in varchar2 default hr_api.g_varchar2
391: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
392: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
393: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
394: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
395: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
396: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
397: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
398: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2

Line 395: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2

391: ,p_egd_attribute3 in varchar2 default hr_api.g_varchar2
392: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
393: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
394: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
395: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
396: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
397: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
398: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
399: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2

Line 396: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2

392: ,p_egd_attribute4 in varchar2 default hr_api.g_varchar2
393: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
394: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
395: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
396: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
397: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
398: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
399: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
400: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2

Line 397: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2

393: ,p_egd_attribute5 in varchar2 default hr_api.g_varchar2
394: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
395: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
396: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
397: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
398: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
399: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
400: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
401: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2

Line 398: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2

394: ,p_egd_attribute6 in varchar2 default hr_api.g_varchar2
395: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
396: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
397: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
398: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
399: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
400: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
401: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
402: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2

Line 399: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2

395: ,p_egd_attribute7 in varchar2 default hr_api.g_varchar2
396: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
397: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
398: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
399: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
400: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
401: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
402: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
403: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2

Line 400: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2

396: ,p_egd_attribute8 in varchar2 default hr_api.g_varchar2
397: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
398: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
399: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
400: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
401: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
402: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
403: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
404: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2

Line 401: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2

397: ,p_egd_attribute9 in varchar2 default hr_api.g_varchar2
398: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
399: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
400: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
401: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
402: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
403: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
404: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
405: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2

Line 402: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2

398: ,p_egd_attribute10 in varchar2 default hr_api.g_varchar2
399: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
400: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
401: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
402: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
403: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
404: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
405: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
406: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2

Line 403: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2

399: ,p_egd_attribute11 in varchar2 default hr_api.g_varchar2
400: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
401: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
402: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
403: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
404: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
405: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
406: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
407: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2

Line 404: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2

400: ,p_egd_attribute12 in varchar2 default hr_api.g_varchar2
401: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
402: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
403: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
404: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
405: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
406: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
407: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
408: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2

Line 405: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2

401: ,p_egd_attribute13 in varchar2 default hr_api.g_varchar2
402: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
403: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
404: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
405: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
406: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
407: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
408: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
409: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2

Line 406: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2

402: ,p_egd_attribute14 in varchar2 default hr_api.g_varchar2
403: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
404: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
405: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
406: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
407: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
408: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
409: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
410: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2

Line 407: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2

403: ,p_egd_attribute15 in varchar2 default hr_api.g_varchar2
404: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
405: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
406: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
407: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
408: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
409: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
410: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
411: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2

Line 408: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2

404: ,p_egd_attribute16 in varchar2 default hr_api.g_varchar2
405: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
406: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
407: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
408: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
409: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
410: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
411: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
412: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2

Line 409: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2

405: ,p_egd_attribute17 in varchar2 default hr_api.g_varchar2
406: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
407: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
408: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
409: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
410: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
411: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
412: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
413: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2

Line 410: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2

406: ,p_egd_attribute18 in varchar2 default hr_api.g_varchar2
407: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
408: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
409: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
410: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
411: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
412: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
413: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
414: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2

Line 411: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2

407: ,p_egd_attribute19 in varchar2 default hr_api.g_varchar2
408: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
409: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
410: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
411: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
412: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
413: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
414: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
415: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2

Line 412: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2

408: ,p_egd_attribute20 in varchar2 default hr_api.g_varchar2
409: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
410: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
411: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
412: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
413: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
414: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
415: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
416: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2

Line 413: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2

409: ,p_egd_attribute21 in varchar2 default hr_api.g_varchar2
410: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
411: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
412: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
413: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
414: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
415: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
416: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2
417: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2

Line 414: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2

410: ,p_egd_attribute22 in varchar2 default hr_api.g_varchar2
411: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
412: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
413: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
414: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
415: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
416: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2
417: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2
418: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2

Line 415: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2

411: ,p_egd_attribute23 in varchar2 default hr_api.g_varchar2
412: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
413: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
414: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
415: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
416: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2
417: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2
418: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2
419: ,p_object_version_number in out nocopy number

Line 416: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2

412: ,p_egd_attribute24 in varchar2 default hr_api.g_varchar2
413: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
414: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
415: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
416: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2
417: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2
418: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2
419: ,p_object_version_number in out nocopy number
420: ,p_effective_date in date

Line 417: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2

413: ,p_egd_attribute25 in varchar2 default hr_api.g_varchar2
414: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
415: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
416: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2
417: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2
418: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2
419: ,p_object_version_number in out nocopy number
420: ,p_effective_date in date
421: ,p_allow_range_validation_flag2 in varchar2 default hr_api.g_varchar2

Line 418: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2

414: ,p_egd_attribute26 in varchar2 default hr_api.g_varchar2
415: ,p_egd_attribute27 in varchar2 default hr_api.g_varchar2
416: ,p_egd_attribute28 in varchar2 default hr_api.g_varchar2
417: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2
418: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2
419: ,p_object_version_number in out nocopy number
420: ,p_effective_date in date
421: ,p_allow_range_validation_flag2 in varchar2 default hr_api.g_varchar2
422: ,p_time_access_calc_rule1 in number default hr_api.g_number

Line 421: ,p_allow_range_validation_flag2 in varchar2 default hr_api.g_varchar2

417: ,p_egd_attribute29 in varchar2 default hr_api.g_varchar2
418: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2
419: ,p_object_version_number in out nocopy number
420: ,p_effective_date in date
421: ,p_allow_range_validation_flag2 in varchar2 default hr_api.g_varchar2
422: ,p_time_access_calc_rule1 in number default hr_api.g_number
423: ,p_time_access_calc_rule2 in number default hr_api.g_number
424: ) is
425: --

Line 422: ,p_time_access_calc_rule1 in number default hr_api.g_number

418: ,p_egd_attribute30 in varchar2 default hr_api.g_varchar2
419: ,p_object_version_number in out nocopy number
420: ,p_effective_date in date
421: ,p_allow_range_validation_flag2 in varchar2 default hr_api.g_varchar2
422: ,p_time_access_calc_rule1 in number default hr_api.g_number
423: ,p_time_access_calc_rule2 in number default hr_api.g_number
424: ) is
425: --
426: -- Declare cursors and local variables

Line 423: ,p_time_access_calc_rule2 in number default hr_api.g_number

419: ,p_object_version_number in out nocopy number
420: ,p_effective_date in date
421: ,p_allow_range_validation_flag2 in varchar2 default hr_api.g_varchar2
422: ,p_time_access_calc_rule1 in number default hr_api.g_number
423: ,p_time_access_calc_rule2 in number default hr_api.g_number
424: ) is
425: --
426: -- Declare cursors and local variables
427: --

Line 518: when hr_api.cannot_find_prog_unit then

514: ,p_time_access_calc_rule1 => p_time_access_calc_rule1
515: ,p_time_access_calc_rule2 => p_time_access_calc_rule2
516: );
517: exception
518: when hr_api.cannot_find_prog_unit then
519: hr_api.cannot_find_prog_unit_error
520: (p_module_name => 'UPDATE_dpnt_eligy_criteria'
521: ,p_hook_type => 'BP'
522: );

Line 519: hr_api.cannot_find_prog_unit_error

515: ,p_time_access_calc_rule2 => p_time_access_calc_rule2
516: );
517: exception
518: when hr_api.cannot_find_prog_unit then
519: hr_api.cannot_find_prog_unit_error
520: (p_module_name => 'UPDATE_dpnt_eligy_criteria'
521: ,p_hook_type => 'BP'
522: );
523: --

Line 660: when hr_api.cannot_find_prog_unit then

656: ,p_time_access_calc_rule1 => p_time_access_calc_rule1
657: ,p_time_access_calc_rule2 => p_time_access_calc_rule2
658: );
659: exception
660: when hr_api.cannot_find_prog_unit then
661: hr_api.cannot_find_prog_unit_error
662: (p_module_name => 'UPDATE_dpnt_eligy_criteria'
663: ,p_hook_type => 'AP'
664: );

Line 661: hr_api.cannot_find_prog_unit_error

657: ,p_time_access_calc_rule2 => p_time_access_calc_rule2
658: );
659: exception
660: when hr_api.cannot_find_prog_unit then
661: hr_api.cannot_find_prog_unit_error
662: (p_module_name => 'UPDATE_dpnt_eligy_criteria'
663: ,p_hook_type => 'AP'
664: );
665: --

Line 675: raise hr_api.validate_enabled;

671: --
672: -- When in validation only mode raise the Validate_Enabled exception
673: --
674: if p_validate then
675: raise hr_api.validate_enabled;
676: end if;
677: --
678: -- Set all output arguments
679: --

Line 686: when hr_api.validate_enabled then

682:
683: --
684: exception
685: --
686: when hr_api.validate_enabled then
687: --
688: -- As the Validate_Enabled exception has been raised
689: -- we must rollback to the savepoint
690: --

Line 749: when hr_api.cannot_find_prog_unit then

745: ,p_object_version_number => p_object_version_number
746: ,p_effective_date => trunc(p_effective_date)
747: );
748: exception
749: when hr_api.cannot_find_prog_unit then
750: hr_api.cannot_find_prog_unit_error
751: (p_module_name => 'DELETE_dpnt_eligy_criteria'
752: ,p_hook_type => 'BP'
753: );

Line 750: hr_api.cannot_find_prog_unit_error

746: ,p_effective_date => trunc(p_effective_date)
747: );
748: exception
749: when hr_api.cannot_find_prog_unit then
750: hr_api.cannot_find_prog_unit_error
751: (p_module_name => 'DELETE_dpnt_eligy_criteria'
752: ,p_hook_type => 'BP'
753: );
754: --

Line 777: when hr_api.cannot_find_prog_unit then

773: ,p_object_version_number => l_object_version_number
774: ,p_effective_date => trunc(p_effective_date)
775: );
776: exception
777: when hr_api.cannot_find_prog_unit then
778: hr_api.cannot_find_prog_unit_error
779: (p_module_name => 'DELETE_dpnt_eligy_criteria'
780: ,p_hook_type => 'AP'
781: );

Line 778: hr_api.cannot_find_prog_unit_error

774: ,p_effective_date => trunc(p_effective_date)
775: );
776: exception
777: when hr_api.cannot_find_prog_unit then
778: hr_api.cannot_find_prog_unit_error
779: (p_module_name => 'DELETE_dpnt_eligy_criteria'
780: ,p_hook_type => 'AP'
781: );
782: --

Line 792: raise hr_api.validate_enabled;

788: --
789: -- When in validation only mode raise the Validate_Enabled exception
790: --
791: if p_validate then
792: raise hr_api.validate_enabled;
793: end if;
794: --
795:
796: --

Line 799: when hr_api.validate_enabled then

795:
796: --
797: exception
798: --
799: when hr_api.validate_enabled then
800: --
801: -- As the Validate_Enabled exception has been raised
802: -- we must rollback to the savepoint
803: --