1 Package pqp_analyzed_alien_det_api as
2 /* $Header: pqdetapi.pkh 120.0 2005/05/29 01:43:47 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_analyzed_alien_det >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- Prerequisites:
12 --
13 --
14 -- In Parameters:
15 -- Name Reqd Type Description
16 -- p_validate Yes boolean Commit or Rollback.
17 -- p_analyzed_data_id Yes number
18 -- p_income_code No varchar2
19 -- p_withholding_rate No number
20 -- p_income_code_sub_type No varchar2
21 -- p_exemption_code No varchar2
22 -- p_maximum_benefit_amount No number
23 -- p_retro_lose_ben_amt_flag No varchar2
24 -- p_date_benefit_ends No date
25 -- p_retro_lose_ben_date_flag No varchar2
26 -- p_nra_exempt_from_ss No varchar2
27 -- p_nra_exempt_from_medicare No varchar2
28 -- p_student_exempt_from_ss No varchar2
29 -- p_student_exempt_from_medi No varchar2
30 -- p_addl_withholding_flag No varchar2
31 -- p_constant_addl_tax No number
32 -- p_addl_withholding_amt No number
33 -- p_addl_wthldng_amt_period_type No varchar2
34 -- p_personal_exemption No number
35 -- p_addl_exemption_allowed No number
36 -- p_treaty_ben_allowed_flag No varchar2
37 -- p_treaty_benefits_start_date No date
38 -- p_effective_date Yes date Session Date.
39 -- p_retro_loss_notification_sent No varchar2
40 --
41 -- Post Success:
42 --
43 -- Out Parameters:
44 -- Name Type Description
45 -- p_analyzed_data_details_id Yes number PK of record
46 -- p_object_version_number Yes number OVN of record
47 --
48 -- Post Failure:
49 --
50 -- Access Status:
51 -- Public.
52 --
53 -- {End Of Comments}
54 --
55 procedure create_analyzed_alien_det
56 (
57 p_validate in boolean default false
58 ,p_analyzed_data_details_id out nocopy number
59 ,p_analyzed_data_id in number default null
60 ,p_income_code in varchar2 default null
61 ,p_withholding_rate in number default null
62 ,p_income_code_sub_type in varchar2 default null
63 ,p_exemption_code in varchar2 default null
64 ,p_maximum_benefit_amount in number default null
65 ,p_retro_lose_ben_amt_flag in varchar2 default null
66 ,p_date_benefit_ends in date default null
67 ,p_retro_lose_ben_date_flag in varchar2 default null
68 ,p_nra_exempt_from_ss in varchar2 default null
69 ,p_nra_exempt_from_medicare in varchar2 default null
70 ,p_student_exempt_from_ss in varchar2 default null
71 ,p_student_exempt_from_medi in varchar2 default null
72 ,p_addl_withholding_flag in varchar2 default null
73 ,p_constant_addl_tax in number default null
74 ,p_addl_withholding_amt in number default null
75 ,p_addl_wthldng_amt_period_type in varchar2 default null
76 ,p_personal_exemption in number default null
77 ,p_addl_exemption_allowed in number default null
78 ,p_treaty_ben_allowed_flag in varchar2 default null
79 ,p_treaty_benefits_start_date in date default null
80 ,p_object_version_number out nocopy number
81 ,p_effective_date in date
82 ,p_retro_loss_notification_sent in varchar2 default null
83 ,p_current_analysis in varchar2 default null
84 ,p_forecast_income_code in varchar2 default null
85 );
86 -- ----------------------------------------------------------------------------
87 -- |------------------------< update_analyzed_alien_det >------------------------|
88 -- ----------------------------------------------------------------------------
89 -- {Start Of Comments}
90 --
91 -- Description:
92 --
93 -- Prerequisites:
94 --
95 --
96 -- In Parameters:
97 -- Name Reqd Type Description
98 -- p_validate Yes boolean Commit or Rollback.
99 -- p_analyzed_data_details_id Yes number PK of record
100 -- p_analyzed_data_id Yes number
101 -- p_income_code No varchar2
102 -- p_withholding_rate No number
103 -- p_income_code_sub_type No varchar2
104 -- p_exemption_code No varchar2
105 -- p_maximum_benefit_amount No number
106 -- p_retro_lose_ben_amt_flag No varchar2
107 -- p_date_benefit_ends No date
108 -- p_retro_lose_ben_date_flag No varchar2
109 -- p_nra_exempt_from_ss No varchar2
110 -- p_nra_exempt_from_medicare No varchar2
111 -- p_student_exempt_from_ss No varchar2
112 -- p_student_exempt_from_medi No varchar2
113 -- p_addl_withholding_flag No varchar2
114 -- p_constant_addl_tax No number
115 -- p_addl_withholding_amt No number
116 -- p_addl_wthldng_amt_period_type No varchar2
117 -- p_personal_exemption No number
118 -- p_addl_exemption_allowed No number
119 -- p_treaty_ben_allowed_flag No varchar2
120 -- p_treaty_benefits_start_date No date
121 -- p_effective_date Yes date Session Date.
122 -- p_retro_loss_notification_sent No varchar2
123 --
124 -- Post Success:
125 --
126 -- Name Type Description
127 -- p_object_version_number Yes number OVN of record
128 --
129 -- Post Failure:
130 --
131 -- Access Status:
132 -- Public.
133 --
134 -- {End Of Comments}
135 --
136 procedure update_analyzed_alien_det
137 (
138 p_validate in boolean default false
139 ,p_analyzed_data_details_id in number
140 ,p_analyzed_data_id in number default hr_api.g_number
141 ,p_income_code in varchar2 default hr_api.g_varchar2
142 ,p_withholding_rate in number default hr_api.g_number
143 ,p_income_code_sub_type in varchar2 default hr_api.g_varchar2
144 ,p_exemption_code in varchar2 default hr_api.g_varchar2
145 ,p_maximum_benefit_amount in number default hr_api.g_number
146 ,p_retro_lose_ben_amt_flag in varchar2 default hr_api.g_varchar2
147 ,p_date_benefit_ends in date default hr_api.g_date
148 ,p_retro_lose_ben_date_flag in varchar2 default hr_api.g_varchar2
149 ,p_nra_exempt_from_ss in varchar2 default hr_api.g_varchar2
150 ,p_nra_exempt_from_medicare in varchar2 default hr_api.g_varchar2
151 ,p_student_exempt_from_ss in varchar2 default hr_api.g_varchar2
152 ,p_student_exempt_from_medi in varchar2 default hr_api.g_varchar2
153 ,p_addl_withholding_flag in varchar2 default hr_api.g_varchar2
154 ,p_constant_addl_tax in number default hr_api.g_number
155 ,p_addl_withholding_amt in number default hr_api.g_number
156 ,p_addl_wthldng_amt_period_type in varchar2 default hr_api.g_varchar2
157 ,p_personal_exemption in number default hr_api.g_number
158 ,p_addl_exemption_allowed in number default hr_api.g_number
159 ,p_treaty_ben_allowed_flag in varchar2 default hr_api.g_varchar2
160 ,p_treaty_benefits_start_date in date default hr_api.g_date
161 ,p_object_version_number in out nocopy number
162 ,p_effective_date in date
163 ,p_retro_loss_notification_sent in varchar2 default hr_api.g_varchar2
164 ,p_current_analysis in varchar2 default hr_api.g_varchar2
165 ,p_forecast_income_code in varchar2 default hr_api.g_varchar2
166 );
167 --
168 -- ----------------------------------------------------------------------------
169 -- |------------------------< delete_analyzed_alien_det >------------------------|
170 -- ----------------------------------------------------------------------------
171 -- {Start Of Comments}
172 --
173 -- Description:
174 --
175 -- Prerequisites:
176 --
177 --
178 -- In Parameters:
179 -- Name Reqd Type Description
180 -- p_validate Yes boolean Commit or Rollback.
181 -- p_analyzed_data_details_id Yes number PK of record
182 -- p_effective_date Yes date Session Date.
183 --
184 -- Post Success:
185 --
186 -- Name Type Description
187 -- p_object_version_number Yes number OVN of record
188 --
189 -- Post Failure:
190 --
191 -- Access Status:
192 -- Public.
193 --
194 -- {End Of Comments}
195 --
196 procedure delete_analyzed_alien_det
197 (
198 p_validate in boolean default false
199 ,p_analyzed_data_details_id in number
200 ,p_object_version_number in out nocopy number
201 ,p_effective_date in date
202 );
203 --
204 -- ----------------------------------------------------------------------------
205 -- |----------------------------------< lck >---------------------------------|
206 -- ----------------------------------------------------------------------------
207 -- {Start Of Comments}
208 --
209 -- Description:
210 --
211 -- Prerequisites:
212 --
213 --
214 -- In Parameters:
215 -- Name Reqd Type Description
216 -- p_analyzed_data_details_id Yes number PK of record
217 -- p_object_version_number Yes number OVN of record
218 --
219 -- Post Success:
220 --
221 -- Name Type Description
222 --
223 -- Post Failure:
224 --
225 -- Access Status:
226 -- Public.
227 --
228 -- {End Of Comments}
229 --
230 procedure lck
231 (
232 p_analyzed_data_details_id in number
233 ,p_object_version_number in number
234 );
235 --
236 end pqp_analyzed_alien_det_api;