1 Package pqp_analyzed_alien_det_bk2 AUTHID CURRENT_USER as
2 /* $Header: pqdetapi.pkh 120.0 2005/05/29 01:43:47 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------------< update_analyzed_alien_det_b >-----------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure update_analyzed_alien_det_b
9 (
10 p_analyzed_data_details_id in number
11 ,p_analyzed_data_id in number
12 ,p_income_code in varchar2
13 ,p_withholding_rate in number
14 ,p_income_code_sub_type in varchar2
15 ,p_exemption_code in varchar2
16 ,p_maximum_benefit_amount in number
17 ,p_retro_lose_ben_amt_flag in varchar2
18 ,p_date_benefit_ends in date
19 ,p_retro_lose_ben_date_flag in varchar2
20 ,p_nra_exempt_from_ss in varchar2
21 ,p_nra_exempt_from_medicare in varchar2
22 ,p_student_exempt_from_ss in varchar2
23 ,p_student_exempt_from_medi in varchar2
24 ,p_addl_withholding_flag in varchar2
25 ,p_constant_addl_tax in number
26 ,p_addl_withholding_amt in number
27 ,p_addl_wthldng_amt_period_type in varchar2
28 ,p_personal_exemption in number
29 ,p_addl_exemption_allowed in number
30 ,p_treaty_ben_allowed_flag in varchar2
31 ,p_treaty_benefits_start_date in date
32 ,p_object_version_number in number
33 ,p_effective_date in date
34 ,p_retro_loss_notification_sent in varchar2
35 ,p_current_analysis in varchar2
36 ,p_forecast_income_code in varchar2
37 );
38 --
39 -- ----------------------------------------------------------------------------
40 -- |---------------------------< update_analyzed_alien_det_a >-----------------|
41 -- ----------------------------------------------------------------------------
42 --
43 procedure update_analyzed_alien_det_a
44 (
45 p_analyzed_data_details_id in number
46 ,p_analyzed_data_id in number
47 ,p_income_code in varchar2
48 ,p_withholding_rate in number
49 ,p_income_code_sub_type in varchar2
50 ,p_exemption_code in varchar2
51 ,p_maximum_benefit_amount in number
52 ,p_retro_lose_ben_amt_flag in varchar2
53 ,p_date_benefit_ends in date
54 ,p_retro_lose_ben_date_flag in varchar2
55 ,p_nra_exempt_from_ss in varchar2
56 ,p_nra_exempt_from_medicare in varchar2
57 ,p_student_exempt_from_ss in varchar2
58 ,p_student_exempt_from_medi in varchar2
59 ,p_addl_withholding_flag in varchar2
60 ,p_constant_addl_tax in number
61 ,p_addl_withholding_amt in number
62 ,p_addl_wthldng_amt_period_type in varchar2
63 ,p_personal_exemption in number
64 ,p_addl_exemption_allowed in number
65 ,p_treaty_ben_allowed_flag in varchar2
66 ,p_treaty_benefits_start_date in date
67 ,p_object_version_number in number
68 ,p_effective_date in date
69 ,p_retro_loss_notification_sent in varchar2
70 ,p_current_analysis in varchar2
71 ,p_forecast_income_code in varchar2
72 );
73 --
74 end pqp_analyzed_alien_det_bk2;