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.PQP_ANALYZED_ALIEN_DET_API dependencies on HR_API

Line 94: when hr_api.cannot_find_prog_unit then

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'

Line 95: hr_api.cannot_find_prog_unit_error

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

Line 171: when hr_api.cannot_find_prog_unit then

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

Line 172: hr_api.cannot_find_prog_unit_error

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

Line 186: raise hr_api.validate_enabled;

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

Line 198: when hr_api.validate_enabled then

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

Line 233: ,p_analyzed_data_id in number default hr_api.g_number

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

Line 234: ,p_income_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

Line 235: ,p_withholding_rate 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

Line 236: ,p_income_code_sub_type 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

Line 237: ,p_exemption_code in varchar2 default hr_api.g_varchar2

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

Line 238: ,p_maximum_benefit_amount 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
242: ,p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2

Line 239: ,p_retro_lose_ben_amt_flag 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

Line 240: ,p_date_benefit_ends in date default hr_api.g_date

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

Line 241: ,p_retro_lose_ben_date_flag 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

Line 242: ,p_nra_exempt_from_ss 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

Line 243: ,p_nra_exempt_from_medicare 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

Line 244: ,p_student_exempt_from_ss 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
248: ,p_addl_withholding_amt in number default hr_api.g_number

Line 245: ,p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2

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

Line 246: ,p_addl_withholding_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
250: ,p_personal_exemption in number default hr_api.g_number

Line 247: ,p_constant_addl_tax 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

Line 248: ,p_addl_withholding_amt 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

Line 249: ,p_addl_wthldng_amt_period_type 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

Line 250: ,p_personal_exemption in number default hr_api.g_number

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

Line 251: ,p_addl_exemption_allowed in number default hr_api.g_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

Line 252: ,p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2

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

Line 253: ,p_treaty_benefits_start_date in date default hr_api.g_date

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

Line 256: ,p_retro_loss_notification_sent 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: --

Line 257: ,p_current_analysis 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: --
261: -- Declare cursors and local variables

Line 258: ,p_forecast_income_code in varchar2 default hr_api.g_varchar2

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

Line 315: when hr_api.cannot_find_prog_unit then

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

Line 316: hr_api.cannot_find_prog_unit_error

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

Line 391: when hr_api.cannot_find_prog_unit then

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

Line 392: hr_api.cannot_find_prog_unit_error

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

Line 406: raise hr_api.validate_enabled;

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

Line 417: when hr_api.validate_enabled then

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

Line 482: when hr_api.cannot_find_prog_unit then

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

Line 483: hr_api.cannot_find_prog_unit_error

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

Line 510: when hr_api.cannot_find_prog_unit then

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

Line 511: hr_api.cannot_find_prog_unit_error

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

Line 525: raise hr_api.validate_enabled;

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

Line 532: when hr_api.validate_enabled then

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