80: ,p_xdo_template_id => p_xdo_template_id
81: ,p_effective_date => trunc(p_effective_date)
82: );
83: exception
84: when hr_api.cannot_find_prog_unit then
85: hr_api.cannot_find_prog_unit_error
86: (
87: p_module_name => 'CREATE_EXT_RSLT'
88: ,p_hook_type => 'BP'
81: ,p_effective_date => trunc(p_effective_date)
82: );
83: exception
84: when hr_api.cannot_find_prog_unit then
85: hr_api.cannot_find_prog_unit_error
86: (
87: p_module_name => 'CREATE_EXT_RSLT'
88: ,p_hook_type => 'BP'
89: );
147: ,p_object_version_number => l_object_version_number
148: ,p_effective_date => trunc(p_effective_date)
149: );
150: exception
151: when hr_api.cannot_find_prog_unit then
152: hr_api.cannot_find_prog_unit_error
153: (p_module_name => 'CREATE_EXT_RSLT'
154: ,p_hook_type => 'AP'
155: );
148: ,p_effective_date => trunc(p_effective_date)
149: );
150: exception
151: when hr_api.cannot_find_prog_unit then
152: hr_api.cannot_find_prog_unit_error
153: (p_module_name => 'CREATE_EXT_RSLT'
154: ,p_hook_type => 'AP'
155: );
156: --
162: --
163: -- When in validation only mode raise the Validate_Enabled exception
164: --
165: if p_validate then
166: raise hr_api.validate_enabled;
167: end if;
168: --
169: -- Set all output arguments
170: --
174: hr_utility.set_location(' Leaving:'||l_proc, 70);
175: --
176: exception
177: --
178: when hr_api.validate_enabled then
179: --
180: -- As the Validate_Enabled exception has been raised
181: -- we must rollback to the savepoint
182: --
206: --
207: procedure update_EXT_RSLT
208: (p_validate in boolean default false
209: ,p_ext_rslt_id in number
210: ,p_run_strt_dt in date default hr_api.g_date
211: ,p_run_end_dt in date default hr_api.g_date
212: ,p_ext_stat_cd in varchar2 default hr_api.g_varchar2
213: ,p_tot_rec_num in number default hr_api.g_number
214: ,p_tot_per_num in number default hr_api.g_number
207: procedure update_EXT_RSLT
208: (p_validate in boolean default false
209: ,p_ext_rslt_id in number
210: ,p_run_strt_dt in date default hr_api.g_date
211: ,p_run_end_dt in date default hr_api.g_date
212: ,p_ext_stat_cd in varchar2 default hr_api.g_varchar2
213: ,p_tot_rec_num in number default hr_api.g_number
214: ,p_tot_per_num in number default hr_api.g_number
215: ,p_tot_err_num in number default hr_api.g_number
208: (p_validate in boolean default false
209: ,p_ext_rslt_id in number
210: ,p_run_strt_dt in date default hr_api.g_date
211: ,p_run_end_dt in date default hr_api.g_date
212: ,p_ext_stat_cd in varchar2 default hr_api.g_varchar2
213: ,p_tot_rec_num in number default hr_api.g_number
214: ,p_tot_per_num in number default hr_api.g_number
215: ,p_tot_err_num in number default hr_api.g_number
216: ,p_eff_dt in date default hr_api.g_date
209: ,p_ext_rslt_id in number
210: ,p_run_strt_dt in date default hr_api.g_date
211: ,p_run_end_dt in date default hr_api.g_date
212: ,p_ext_stat_cd in varchar2 default hr_api.g_varchar2
213: ,p_tot_rec_num in number default hr_api.g_number
214: ,p_tot_per_num in number default hr_api.g_number
215: ,p_tot_err_num in number default hr_api.g_number
216: ,p_eff_dt in date default hr_api.g_date
217: ,p_ext_strt_dt in date default hr_api.g_date
210: ,p_run_strt_dt in date default hr_api.g_date
211: ,p_run_end_dt in date default hr_api.g_date
212: ,p_ext_stat_cd in varchar2 default hr_api.g_varchar2
213: ,p_tot_rec_num in number default hr_api.g_number
214: ,p_tot_per_num in number default hr_api.g_number
215: ,p_tot_err_num in number default hr_api.g_number
216: ,p_eff_dt in date default hr_api.g_date
217: ,p_ext_strt_dt in date default hr_api.g_date
218: ,p_ext_end_dt in date default hr_api.g_date
211: ,p_run_end_dt in date default hr_api.g_date
212: ,p_ext_stat_cd in varchar2 default hr_api.g_varchar2
213: ,p_tot_rec_num in number default hr_api.g_number
214: ,p_tot_per_num in number default hr_api.g_number
215: ,p_tot_err_num in number default hr_api.g_number
216: ,p_eff_dt in date default hr_api.g_date
217: ,p_ext_strt_dt in date default hr_api.g_date
218: ,p_ext_end_dt in date default hr_api.g_date
219: ,p_output_name in varchar2 default hr_api.g_varchar2
212: ,p_ext_stat_cd in varchar2 default hr_api.g_varchar2
213: ,p_tot_rec_num in number default hr_api.g_number
214: ,p_tot_per_num in number default hr_api.g_number
215: ,p_tot_err_num in number default hr_api.g_number
216: ,p_eff_dt in date default hr_api.g_date
217: ,p_ext_strt_dt in date default hr_api.g_date
218: ,p_ext_end_dt in date default hr_api.g_date
219: ,p_output_name in varchar2 default hr_api.g_varchar2
220: ,p_drctry_name in varchar2 default hr_api.g_varchar2
213: ,p_tot_rec_num in number default hr_api.g_number
214: ,p_tot_per_num in number default hr_api.g_number
215: ,p_tot_err_num in number default hr_api.g_number
216: ,p_eff_dt in date default hr_api.g_date
217: ,p_ext_strt_dt in date default hr_api.g_date
218: ,p_ext_end_dt in date default hr_api.g_date
219: ,p_output_name in varchar2 default hr_api.g_varchar2
220: ,p_drctry_name in varchar2 default hr_api.g_varchar2
221: ,p_ext_dfn_id in number default hr_api.g_number
214: ,p_tot_per_num in number default hr_api.g_number
215: ,p_tot_err_num in number default hr_api.g_number
216: ,p_eff_dt in date default hr_api.g_date
217: ,p_ext_strt_dt in date default hr_api.g_date
218: ,p_ext_end_dt in date default hr_api.g_date
219: ,p_output_name in varchar2 default hr_api.g_varchar2
220: ,p_drctry_name in varchar2 default hr_api.g_varchar2
221: ,p_ext_dfn_id in number default hr_api.g_number
222: ,p_business_group_id in number default hr_api.g_number
215: ,p_tot_err_num in number default hr_api.g_number
216: ,p_eff_dt in date default hr_api.g_date
217: ,p_ext_strt_dt in date default hr_api.g_date
218: ,p_ext_end_dt in date default hr_api.g_date
219: ,p_output_name in varchar2 default hr_api.g_varchar2
220: ,p_drctry_name in varchar2 default hr_api.g_varchar2
221: ,p_ext_dfn_id in number default hr_api.g_number
222: ,p_business_group_id in number default hr_api.g_number
223: ,p_program_application_id in number default hr_api.g_number
216: ,p_eff_dt in date default hr_api.g_date
217: ,p_ext_strt_dt in date default hr_api.g_date
218: ,p_ext_end_dt in date default hr_api.g_date
219: ,p_output_name in varchar2 default hr_api.g_varchar2
220: ,p_drctry_name in varchar2 default hr_api.g_varchar2
221: ,p_ext_dfn_id in number default hr_api.g_number
222: ,p_business_group_id in number default hr_api.g_number
223: ,p_program_application_id in number default hr_api.g_number
224: ,p_program_id in number default hr_api.g_number
217: ,p_ext_strt_dt in date default hr_api.g_date
218: ,p_ext_end_dt in date default hr_api.g_date
219: ,p_output_name in varchar2 default hr_api.g_varchar2
220: ,p_drctry_name in varchar2 default hr_api.g_varchar2
221: ,p_ext_dfn_id in number default hr_api.g_number
222: ,p_business_group_id in number default hr_api.g_number
223: ,p_program_application_id in number default hr_api.g_number
224: ,p_program_id in number default hr_api.g_number
225: ,p_program_update_date in date default hr_api.g_date
218: ,p_ext_end_dt in date default hr_api.g_date
219: ,p_output_name in varchar2 default hr_api.g_varchar2
220: ,p_drctry_name in varchar2 default hr_api.g_varchar2
221: ,p_ext_dfn_id in number default hr_api.g_number
222: ,p_business_group_id in number default hr_api.g_number
223: ,p_program_application_id in number default hr_api.g_number
224: ,p_program_id in number default hr_api.g_number
225: ,p_program_update_date in date default hr_api.g_date
226: ,p_request_id in number default hr_api.g_number
219: ,p_output_name in varchar2 default hr_api.g_varchar2
220: ,p_drctry_name in varchar2 default hr_api.g_varchar2
221: ,p_ext_dfn_id in number default hr_api.g_number
222: ,p_business_group_id in number default hr_api.g_number
223: ,p_program_application_id in number default hr_api.g_number
224: ,p_program_id in number default hr_api.g_number
225: ,p_program_update_date in date default hr_api.g_date
226: ,p_request_id in number default hr_api.g_number
227: ,p_output_type in varchar2 default hr_api.g_varchar2
220: ,p_drctry_name in varchar2 default hr_api.g_varchar2
221: ,p_ext_dfn_id in number default hr_api.g_number
222: ,p_business_group_id in number default hr_api.g_number
223: ,p_program_application_id in number default hr_api.g_number
224: ,p_program_id in number default hr_api.g_number
225: ,p_program_update_date in date default hr_api.g_date
226: ,p_request_id in number default hr_api.g_number
227: ,p_output_type in varchar2 default hr_api.g_varchar2
228: ,p_xdo_template_id in number default hr_api.g_number
221: ,p_ext_dfn_id in number default hr_api.g_number
222: ,p_business_group_id in number default hr_api.g_number
223: ,p_program_application_id in number default hr_api.g_number
224: ,p_program_id in number default hr_api.g_number
225: ,p_program_update_date in date default hr_api.g_date
226: ,p_request_id in number default hr_api.g_number
227: ,p_output_type in varchar2 default hr_api.g_varchar2
228: ,p_xdo_template_id in number default hr_api.g_number
229: ,p_object_version_number in out nocopy number
222: ,p_business_group_id in number default hr_api.g_number
223: ,p_program_application_id in number default hr_api.g_number
224: ,p_program_id in number default hr_api.g_number
225: ,p_program_update_date in date default hr_api.g_date
226: ,p_request_id in number default hr_api.g_number
227: ,p_output_type in varchar2 default hr_api.g_varchar2
228: ,p_xdo_template_id in number default hr_api.g_number
229: ,p_object_version_number in out nocopy number
230: ,p_effective_date in date
223: ,p_program_application_id in number default hr_api.g_number
224: ,p_program_id in number default hr_api.g_number
225: ,p_program_update_date in date default hr_api.g_date
226: ,p_request_id in number default hr_api.g_number
227: ,p_output_type in varchar2 default hr_api.g_varchar2
228: ,p_xdo_template_id in number default hr_api.g_number
229: ,p_object_version_number in out nocopy number
230: ,p_effective_date in date
231: ) is
224: ,p_program_id in number default hr_api.g_number
225: ,p_program_update_date in date default hr_api.g_date
226: ,p_request_id in number default hr_api.g_number
227: ,p_output_type in varchar2 default hr_api.g_varchar2
228: ,p_xdo_template_id in number default hr_api.g_number
229: ,p_object_version_number in out nocopy number
230: ,p_effective_date in date
231: ) is
232: --
278: ,p_object_version_number => p_object_version_number
279: ,p_effective_date => trunc(p_effective_date)
280: );
281: exception
282: when hr_api.cannot_find_prog_unit then
283: hr_api.cannot_find_prog_unit_error
284: (p_module_name => 'UPDATE_EXT_RSLT'
285: ,p_hook_type => 'BP'
286: );
279: ,p_effective_date => trunc(p_effective_date)
280: );
281: exception
282: when hr_api.cannot_find_prog_unit then
283: hr_api.cannot_find_prog_unit_error
284: (p_module_name => 'UPDATE_EXT_RSLT'
285: ,p_hook_type => 'BP'
286: );
287: --
344: ,p_object_version_number => l_object_version_number
345: ,p_effective_date => trunc(p_effective_date)
346: );
347: exception
348: when hr_api.cannot_find_prog_unit then
349: hr_api.cannot_find_prog_unit_error
350: (p_module_name => 'UPDATE_EXT_RSLT'
351: ,p_hook_type => 'AP'
352: );
345: ,p_effective_date => trunc(p_effective_date)
346: );
347: exception
348: when hr_api.cannot_find_prog_unit then
349: hr_api.cannot_find_prog_unit_error
350: (p_module_name => 'UPDATE_EXT_RSLT'
351: ,p_hook_type => 'AP'
352: );
353: --
359: --
360: -- When in validation only mode raise the Validate_Enabled exception
361: --
362: if p_validate then
363: raise hr_api.validate_enabled;
364: end if;
365: --
366: -- Set all output arguments
367: --
370: hr_utility.set_location(' Leaving:'||l_proc, 70);
371: --
372: exception
373: --
374: when hr_api.validate_enabled then
375: --
376: -- As the Validate_Enabled exception has been raised
377: -- we must rollback to the savepoint
378: --
433: ,p_object_version_number => p_object_version_number
434: ,p_effective_date => trunc(p_effective_date)
435: );
436: exception
437: when hr_api.cannot_find_prog_unit then
438: hr_api.cannot_find_prog_unit_error
439: (p_module_name => 'DELETE_EXT_RSLT'
440: ,p_hook_type => 'BP'
441: );
434: ,p_effective_date => trunc(p_effective_date)
435: );
436: exception
437: when hr_api.cannot_find_prog_unit then
438: hr_api.cannot_find_prog_unit_error
439: (p_module_name => 'DELETE_EXT_RSLT'
440: ,p_hook_type => 'BP'
441: );
442: --
461: ,p_object_version_number => l_object_version_number
462: ,p_effective_date => trunc(p_effective_date)
463: );
464: exception
465: when hr_api.cannot_find_prog_unit then
466: hr_api.cannot_find_prog_unit_error
467: (p_module_name => 'DELETE_EXT_RSLT'
468: ,p_hook_type => 'AP'
469: );
462: ,p_effective_date => trunc(p_effective_date)
463: );
464: exception
465: when hr_api.cannot_find_prog_unit then
466: hr_api.cannot_find_prog_unit_error
467: (p_module_name => 'DELETE_EXT_RSLT'
468: ,p_hook_type => 'AP'
469: );
470: --
476: --
477: -- When in validation only mode raise the Validate_Enabled exception
478: --
479: if p_validate then
480: raise hr_api.validate_enabled;
481: end if;
482: --
483: hr_utility.set_location(' Leaving:'||l_proc, 70);
484: --
483: hr_utility.set_location(' Leaving:'||l_proc, 70);
484: --
485: exception
486: --
487: when hr_api.validate_enabled then
488: --
489: -- As the Validate_Enabled exception has been raised
490: -- we must rollback to the savepoint
491: --