90: ,p_current_analysis => p_current_analysis
91: ,p_forecast_income_code => p_forecast_income_code
92: );
93: exception
94: when hr_api.cannot_find_prog_unit then
95: hr_api.cannot_find_prog_unit_error
96: (
97: p_module_name => 'CREATE_ANALYZED_ALIEN_DET'
98: ,p_hook_type => 'BP'
91: ,p_forecast_income_code => p_forecast_income_code
92: );
93: exception
94: when hr_api.cannot_find_prog_unit then
95: hr_api.cannot_find_prog_unit_error
96: (
97: p_module_name => 'CREATE_ANALYZED_ALIEN_DET'
98: ,p_hook_type => 'BP'
99: );
167: ,p_current_analysis => p_current_analysis
168: ,p_forecast_income_code => p_forecast_income_code
169: );
170: exception
171: when hr_api.cannot_find_prog_unit then
172: hr_api.cannot_find_prog_unit_error
173: (p_module_name => 'CREATE_ANALYZED_ALIEN_DET'
174: ,p_hook_type => 'AP'
175: );
168: ,p_forecast_income_code => p_forecast_income_code
169: );
170: exception
171: when hr_api.cannot_find_prog_unit then
172: hr_api.cannot_find_prog_unit_error
173: (p_module_name => 'CREATE_ANALYZED_ALIEN_DET'
174: ,p_hook_type => 'AP'
175: );
176: --
182: --
183: -- When in validation only mode raise the Validate_Enabled exception
184: --
185: if p_validate then
186: raise hr_api.validate_enabled;
187: end if;
188: --
189: -- Set all output arguments
190: --
194: hr_utility.set_location(' Leaving:'||l_proc, 70);
195: --
196: exception
197: --
198: when hr_api.validate_enabled then
199: --
200: -- As the Validate_Enabled exception has been raised
201: -- we must rollback to the savepoint
202: --
229: --
230: procedure update_analyzed_alien_det
231: (p_validate in boolean default false
232: ,p_analyzed_data_details_id in number
233: ,p_analyzed_data_id in number default hr_api.g_number
234: ,p_income_code in varchar2 default hr_api.g_varchar2
235: ,p_withholding_rate in number default hr_api.g_number
236: ,p_income_code_sub_type in varchar2 default hr_api.g_varchar2
237: ,p_exemption_code in varchar2 default hr_api.g_varchar2
230: procedure update_analyzed_alien_det
231: (p_validate in boolean default false
232: ,p_analyzed_data_details_id in number
233: ,p_analyzed_data_id in number default hr_api.g_number
234: ,p_income_code in varchar2 default hr_api.g_varchar2
235: ,p_withholding_rate in number default hr_api.g_number
236: ,p_income_code_sub_type in varchar2 default hr_api.g_varchar2
237: ,p_exemption_code in varchar2 default hr_api.g_varchar2
238: ,p_maximum_benefit_amount in number default hr_api.g_number
231: (p_validate in boolean default false
232: ,p_analyzed_data_details_id in number
233: ,p_analyzed_data_id in number default hr_api.g_number
234: ,p_income_code in varchar2 default hr_api.g_varchar2
235: ,p_withholding_rate in number default hr_api.g_number
236: ,p_income_code_sub_type in varchar2 default hr_api.g_varchar2
237: ,p_exemption_code in varchar2 default hr_api.g_varchar2
238: ,p_maximum_benefit_amount in number default hr_api.g_number
239: ,p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2
232: ,p_analyzed_data_details_id in number
233: ,p_analyzed_data_id in number default hr_api.g_number
234: ,p_income_code in varchar2 default hr_api.g_varchar2
235: ,p_withholding_rate in number default hr_api.g_number
236: ,p_income_code_sub_type in varchar2 default hr_api.g_varchar2
237: ,p_exemption_code in varchar2 default hr_api.g_varchar2
238: ,p_maximum_benefit_amount in number default hr_api.g_number
239: ,p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2
240: ,p_date_benefit_ends in date default hr_api.g_date
233: ,p_analyzed_data_id in number default hr_api.g_number
234: ,p_income_code in varchar2 default hr_api.g_varchar2
235: ,p_withholding_rate in number default hr_api.g_number
236: ,p_income_code_sub_type in varchar2 default hr_api.g_varchar2
237: ,p_exemption_code in varchar2 default hr_api.g_varchar2
238: ,p_maximum_benefit_amount in number default hr_api.g_number
239: ,p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2
240: ,p_date_benefit_ends in date default hr_api.g_date
241: ,p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2
234: ,p_income_code in varchar2 default hr_api.g_varchar2
235: ,p_withholding_rate in number default hr_api.g_number
236: ,p_income_code_sub_type in varchar2 default hr_api.g_varchar2
237: ,p_exemption_code in varchar2 default hr_api.g_varchar2
238: ,p_maximum_benefit_amount in number default hr_api.g_number
239: ,p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2
240: ,p_date_benefit_ends in date default hr_api.g_date
241: ,p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2
242: ,p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2
235: ,p_withholding_rate in number default hr_api.g_number
236: ,p_income_code_sub_type in varchar2 default hr_api.g_varchar2
237: ,p_exemption_code in varchar2 default hr_api.g_varchar2
238: ,p_maximum_benefit_amount in number default hr_api.g_number
239: ,p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2
240: ,p_date_benefit_ends in date default hr_api.g_date
241: ,p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2
242: ,p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2
243: ,p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2
236: ,p_income_code_sub_type in varchar2 default hr_api.g_varchar2
237: ,p_exemption_code in varchar2 default hr_api.g_varchar2
238: ,p_maximum_benefit_amount in number default hr_api.g_number
239: ,p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2
240: ,p_date_benefit_ends in date default hr_api.g_date
241: ,p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2
242: ,p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2
243: ,p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2
244: ,p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2
237: ,p_exemption_code in varchar2 default hr_api.g_varchar2
238: ,p_maximum_benefit_amount in number default hr_api.g_number
239: ,p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2
240: ,p_date_benefit_ends in date default hr_api.g_date
241: ,p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2
242: ,p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2
243: ,p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2
244: ,p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2
245: ,p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2
238: ,p_maximum_benefit_amount in number default hr_api.g_number
239: ,p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2
240: ,p_date_benefit_ends in date default hr_api.g_date
241: ,p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2
242: ,p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2
243: ,p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2
244: ,p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2
245: ,p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2
246: ,p_addl_withholding_flag in varchar2 default hr_api.g_varchar2
239: ,p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2
240: ,p_date_benefit_ends in date default hr_api.g_date
241: ,p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2
242: ,p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2
243: ,p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2
244: ,p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2
245: ,p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2
246: ,p_addl_withholding_flag in varchar2 default hr_api.g_varchar2
247: ,p_constant_addl_tax in number default hr_api.g_number
240: ,p_date_benefit_ends in date default hr_api.g_date
241: ,p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2
242: ,p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2
243: ,p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2
244: ,p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2
245: ,p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2
246: ,p_addl_withholding_flag in varchar2 default hr_api.g_varchar2
247: ,p_constant_addl_tax in number default hr_api.g_number
248: ,p_addl_withholding_amt in number default hr_api.g_number
241: ,p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2
242: ,p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2
243: ,p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2
244: ,p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2
245: ,p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2
246: ,p_addl_withholding_flag in varchar2 default hr_api.g_varchar2
247: ,p_constant_addl_tax in number default hr_api.g_number
248: ,p_addl_withholding_amt in number default hr_api.g_number
249: ,p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2
242: ,p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2
243: ,p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2
244: ,p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2
245: ,p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2
246: ,p_addl_withholding_flag in varchar2 default hr_api.g_varchar2
247: ,p_constant_addl_tax in number default hr_api.g_number
248: ,p_addl_withholding_amt in number default hr_api.g_number
249: ,p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2
250: ,p_personal_exemption in number default hr_api.g_number
243: ,p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2
244: ,p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2
245: ,p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2
246: ,p_addl_withholding_flag in varchar2 default hr_api.g_varchar2
247: ,p_constant_addl_tax in number default hr_api.g_number
248: ,p_addl_withholding_amt in number default hr_api.g_number
249: ,p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2
250: ,p_personal_exemption in number default hr_api.g_number
251: ,p_addl_exemption_allowed in number default hr_api.g_number
244: ,p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2
245: ,p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2
246: ,p_addl_withholding_flag in varchar2 default hr_api.g_varchar2
247: ,p_constant_addl_tax in number default hr_api.g_number
248: ,p_addl_withholding_amt in number default hr_api.g_number
249: ,p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2
250: ,p_personal_exemption in number default hr_api.g_number
251: ,p_addl_exemption_allowed in number default hr_api.g_number
252: ,p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2
245: ,p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2
246: ,p_addl_withholding_flag in varchar2 default hr_api.g_varchar2
247: ,p_constant_addl_tax in number default hr_api.g_number
248: ,p_addl_withholding_amt in number default hr_api.g_number
249: ,p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2
250: ,p_personal_exemption in number default hr_api.g_number
251: ,p_addl_exemption_allowed in number default hr_api.g_number
252: ,p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2
253: ,p_treaty_benefits_start_date in date default hr_api.g_date
246: ,p_addl_withholding_flag in varchar2 default hr_api.g_varchar2
247: ,p_constant_addl_tax in number default hr_api.g_number
248: ,p_addl_withholding_amt in number default hr_api.g_number
249: ,p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2
250: ,p_personal_exemption in number default hr_api.g_number
251: ,p_addl_exemption_allowed in number default hr_api.g_number
252: ,p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2
253: ,p_treaty_benefits_start_date in date default hr_api.g_date
254: ,p_object_version_number in out nocopy number
247: ,p_constant_addl_tax in number default hr_api.g_number
248: ,p_addl_withholding_amt in number default hr_api.g_number
249: ,p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2
250: ,p_personal_exemption in number default hr_api.g_number
251: ,p_addl_exemption_allowed in number default hr_api.g_number
252: ,p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2
253: ,p_treaty_benefits_start_date in date default hr_api.g_date
254: ,p_object_version_number in out nocopy number
255: ,p_effective_date in date
248: ,p_addl_withholding_amt in number default hr_api.g_number
249: ,p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2
250: ,p_personal_exemption in number default hr_api.g_number
251: ,p_addl_exemption_allowed in number default hr_api.g_number
252: ,p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2
253: ,p_treaty_benefits_start_date in date default hr_api.g_date
254: ,p_object_version_number in out nocopy number
255: ,p_effective_date in date
256: ,p_retro_loss_notification_sent in varchar2 default hr_api.g_varchar2
249: ,p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2
250: ,p_personal_exemption in number default hr_api.g_number
251: ,p_addl_exemption_allowed in number default hr_api.g_number
252: ,p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2
253: ,p_treaty_benefits_start_date in date default hr_api.g_date
254: ,p_object_version_number in out nocopy number
255: ,p_effective_date in date
256: ,p_retro_loss_notification_sent in varchar2 default hr_api.g_varchar2
257: ,p_current_analysis in varchar2 default hr_api.g_varchar2
252: ,p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2
253: ,p_treaty_benefits_start_date in date default hr_api.g_date
254: ,p_object_version_number in out nocopy number
255: ,p_effective_date in date
256: ,p_retro_loss_notification_sent in varchar2 default hr_api.g_varchar2
257: ,p_current_analysis in varchar2 default hr_api.g_varchar2
258: ,p_forecast_income_code in varchar2 default hr_api.g_varchar2
259: ) is
260: --
253: ,p_treaty_benefits_start_date in date default hr_api.g_date
254: ,p_object_version_number in out nocopy number
255: ,p_effective_date in date
256: ,p_retro_loss_notification_sent in varchar2 default hr_api.g_varchar2
257: ,p_current_analysis in varchar2 default hr_api.g_varchar2
258: ,p_forecast_income_code in varchar2 default hr_api.g_varchar2
259: ) is
260: --
261: -- Declare cursors and local variables
254: ,p_object_version_number in out nocopy number
255: ,p_effective_date in date
256: ,p_retro_loss_notification_sent in varchar2 default hr_api.g_varchar2
257: ,p_current_analysis in varchar2 default hr_api.g_varchar2
258: ,p_forecast_income_code in varchar2 default hr_api.g_varchar2
259: ) is
260: --
261: -- Declare cursors and local variables
262: --
311: ,p_current_analysis => p_current_analysis
312: ,p_forecast_income_code => p_forecast_income_code
313: );
314: exception
315: when hr_api.cannot_find_prog_unit then
316: hr_api.cannot_find_prog_unit_error
317: (p_module_name => 'UPDATE_ANALYZED_ALIEN_DET'
318: ,p_hook_type => 'BP'
319: );
312: ,p_forecast_income_code => p_forecast_income_code
313: );
314: exception
315: when hr_api.cannot_find_prog_unit then
316: hr_api.cannot_find_prog_unit_error
317: (p_module_name => 'UPDATE_ANALYZED_ALIEN_DET'
318: ,p_hook_type => 'BP'
319: );
320: --
387: ,p_current_analysis => p_current_analysis
388: ,p_forecast_income_code => p_forecast_income_code
389: );
390: exception
391: when hr_api.cannot_find_prog_unit then
392: hr_api.cannot_find_prog_unit_error
393: (p_module_name => 'UPDATE_ANALYZED_ALIEN_DET'
394: ,p_hook_type => 'AP'
395: );
388: ,p_forecast_income_code => p_forecast_income_code
389: );
390: exception
391: when hr_api.cannot_find_prog_unit then
392: hr_api.cannot_find_prog_unit_error
393: (p_module_name => 'UPDATE_ANALYZED_ALIEN_DET'
394: ,p_hook_type => 'AP'
395: );
396: --
402: --
403: -- When in validation only mode raise the Validate_Enabled exception
404: --
405: if p_validate then
406: raise hr_api.validate_enabled;
407: end if;
408: --
409: -- Set all output arguments
410: --
413: hr_utility.set_location(' Leaving:'||l_proc, 70);
414: --
415: exception
416: --
417: when hr_api.validate_enabled then
418: --
419: -- As the Validate_Enabled exception has been raised
420: -- we must rollback to the savepoint
421: --
478: ,p_object_version_number => p_object_version_number
479: ,p_effective_date => trunc(p_effective_date)
480: );
481: exception
482: when hr_api.cannot_find_prog_unit then
483: hr_api.cannot_find_prog_unit_error
484: (p_module_name => 'DELETE_ANALYZED_ALIEN_DET'
485: ,p_hook_type => 'BP'
486: );
479: ,p_effective_date => trunc(p_effective_date)
480: );
481: exception
482: when hr_api.cannot_find_prog_unit then
483: hr_api.cannot_find_prog_unit_error
484: (p_module_name => 'DELETE_ANALYZED_ALIEN_DET'
485: ,p_hook_type => 'BP'
486: );
487: --
506: ,p_object_version_number => l_object_version_number
507: ,p_effective_date => trunc(p_effective_date)
508: );
509: exception
510: when hr_api.cannot_find_prog_unit then
511: hr_api.cannot_find_prog_unit_error
512: (p_module_name => 'DELETE_ANALYZED_ALIEN_DET'
513: ,p_hook_type => 'AP'
514: );
507: ,p_effective_date => trunc(p_effective_date)
508: );
509: exception
510: when hr_api.cannot_find_prog_unit then
511: hr_api.cannot_find_prog_unit_error
512: (p_module_name => 'DELETE_ANALYZED_ALIEN_DET'
513: ,p_hook_type => 'AP'
514: );
515: --
521: --
522: -- When in validation only mode raise the Validate_Enabled exception
523: --
524: if p_validate then
525: raise hr_api.validate_enabled;
526: end if;
527: --
528: hr_utility.set_location(' Leaving:'||l_proc, 70);
529: --
528: hr_utility.set_location(' Leaving:'||l_proc, 70);
529: --
530: exception
531: --
532: when hr_api.validate_enabled then
533: --
534: -- As the Validate_Enabled exception has been raised
535: -- we must rollback to the savepoint
536: --