1 Package pqp_analyzed_alien_data_api as
2 /* $Header: pqaadapi.pkh 120.0 2005/05/29 01:39:33 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_analyzed_alien_data >------------------------|
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_assignment_id Yes number
18 -- p_data_source Yes varchar2
19 -- p_tax_year Yes number
20 -- p_current_residency_status No varchar2
21 -- p_nra_to_ra_date No date
22 -- p_target_departure_date No date
23 -- p_tax_residence_country_code No varchar2
24 -- p_treaty_info_update_date No date
25 -- p_number_of_days_in_usa No number
26 -- p_withldg_allow_eligible_flag No varchar2
27 -- p_ra_effective_date No date
28 -- p_record_source No varchar2
29 -- p_visa_type No varchar2
30 -- p_j_sub_type No varchar2
31 -- p_primary_activity No varchar2
32 -- p_non_us_country_code No varchar2
33 -- p_citizenship_country_code No varchar2
34 -- p_effective_date Yes date Session Date.
35 -- p_date_8233_signed No date
36 -- p_date_w4_signed No date
37
38 --
39 -- Post Success:
40 --
41 -- Out Parameters:
42 -- Name Type Description
43 -- p_analyzed_data_id Yes number PK of record
44 -- p_object_version_number Yes number OVN of record
45 --
46 -- Post Failure:
47 --
48 -- Access Status:
49 -- Public.
50 --
51 -- {End Of Comments}
52 --
53 procedure create_analyzed_alien_data
54 (
55 p_validate in boolean default false
56 ,p_analyzed_data_id out nocopy number
57 ,p_assignment_id in number default null
58 ,p_data_source in varchar2 default null
59 ,p_tax_year in number default null
60 ,p_current_residency_status in varchar2 default null
61 ,p_nra_to_ra_date in date default null
62 ,p_target_departure_date in date default null
63 ,p_tax_residence_country_code in varchar2 default null
64 ,p_treaty_info_update_date in date default null
65 ,p_number_of_days_in_usa in number default null
66 ,p_withldg_allow_eligible_flag in varchar2 default null
67 ,p_ra_effective_date in date default null
68 ,p_record_source in varchar2 default null
69 ,p_visa_type in varchar2 default null
70 ,p_j_sub_type in varchar2 default null
71 ,p_primary_activity in varchar2 default null
72 ,p_non_us_country_code in varchar2 default null
73 ,p_citizenship_country_code in varchar2 default null
74 ,p_object_version_number out nocopy number
75 ,p_effective_date in date
76 ,p_date_8233_signed in date default null
77 ,p_date_w4_signed in date default null
78
79 );
80 -- ----------------------------------------------------------------------------
81 -- |------------------------< update_analyzed_alien_data >------------------------|
82 -- ----------------------------------------------------------------------------
83 -- {Start Of Comments}
84 --
85 -- Description:
86 --
87 -- Prerequisites:
88 --
89 --
90 -- In Parameters:
91 -- Name Reqd Type Description
92 -- p_validate Yes boolean Commit or Rollback.
93 -- p_analyzed_data_id Yes number PK of record
94 -- p_assignment_id Yes number
95 -- p_data_source Yes varchar2
96 -- p_tax_year Yes number
97 -- p_current_residency_status No varchar2
98 -- p_nra_to_ra_date No date
99 -- p_target_departure_date No date
100 -- p_tax_residence_country_code No varchar2
101 -- p_treaty_info_update_date No date
102 -- p_number_of_days_in_usa No number
103 -- p_withldg_allow_eligible_flag No varchar2
104 -- p_ra_effective_date No date
105 -- p_record_source No varchar2
106 -- p_visa_type No varchar2
107 -- p_j_sub_type No varchar2
108 -- p_primary_activity No varchar2
109 -- p_non_us_country_code No varchar2
110 -- p_citizenship_country_code No varchar2
111 -- p_effective_date Yes date Session Date.
112 -- p_date_8233_signed No date
113 -- p_date_w4_signed No date
114 --
115 -- Post Success:
116 --
117 -- Name Type Description
118 -- p_object_version_number Yes number OVN of record
119 --
120 -- Post Failure:
121 --
122 -- Access Status:
123 -- Public.
124 --
125 -- {End Of Comments}
126 --
127 procedure update_analyzed_alien_data
128 (
129 p_validate in boolean default false
130 ,p_analyzed_data_id in number
131 ,p_assignment_id in number default hr_api.g_number
132 ,p_data_source in varchar2 default hr_api.g_varchar2
133 ,p_tax_year in number default hr_api.g_number
134 ,p_current_residency_status in varchar2 default hr_api.g_varchar2
135 ,p_nra_to_ra_date in date default hr_api.g_date
136 ,p_target_departure_date in date default hr_api.g_date
137 ,p_tax_residence_country_code in varchar2 default hr_api.g_varchar2
138 ,p_treaty_info_update_date in date default hr_api.g_date
139 ,p_number_of_days_in_usa in number default hr_api.g_number
140 ,p_withldg_allow_eligible_flag in varchar2 default hr_api.g_varchar2
141 ,p_ra_effective_date in date default hr_api.g_date
142 ,p_record_source in varchar2 default hr_api.g_varchar2
143 ,p_visa_type in varchar2 default hr_api.g_varchar2
144 ,p_j_sub_type in varchar2 default hr_api.g_varchar2
145 ,p_primary_activity in varchar2 default hr_api.g_varchar2
146 ,p_non_us_country_code in varchar2 default hr_api.g_varchar2
147 ,p_citizenship_country_code in varchar2 default hr_api.g_varchar2
148 ,p_object_version_number in out nocopy number
149 ,p_effective_date in date
150 ,p_date_8233_signed in date default hr_api.g_date
151 ,p_date_w4_signed in date default hr_api.g_date
152 );
153 --
154 -- ----------------------------------------------------------------------------
155 -- |------------------------< delete_analyzed_alien_data >------------------------|
156 -- ----------------------------------------------------------------------------
157 -- {Start Of Comments}
158 --
159 -- Description:
160 --
161 -- Prerequisites:
162 --
163 --
164 -- In Parameters:
165 -- Name Reqd Type Description
166 -- p_validate Yes boolean Commit or Rollback.
167 -- p_analyzed_data_id Yes number PK of record
168 -- p_effective_date Yes date Session Date.
169 --
170 -- Post Success:
171 --
172 -- Name Type Description
173 -- p_object_version_number Yes number OVN of record
174 --
175 -- Post Failure:
176 --
177 -- Access Status:
178 -- Public.
179 --
180 -- {End Of Comments}
181 --
182 procedure delete_analyzed_alien_data
183 (
184 p_validate in boolean default false
185 ,p_analyzed_data_id in number
186 ,p_object_version_number in out nocopy number
187 ,p_effective_date in date
188 );
189 --
190 -- ----------------------------------------------------------------------------
191 -- |----------------------------------< lck >---------------------------------|
192 -- ----------------------------------------------------------------------------
193 -- {Start Of Comments}
194 --
195 -- Description:
196 --
197 -- Prerequisites:
198 --
199 --
200 -- In Parameters:
201 -- Name Reqd Type Description
202 -- p_analyzed_data_id Yes number PK of record
203 -- p_object_version_number Yes number OVN of record
204 --
205 -- Post Success:
206 --
207 -- Name Type Description
208 --
209 -- Post Failure:
210 --
211 -- Access Status:
212 -- Public.
213 --
214 -- {End Of Comments}
215 --
216 procedure lck
217 (
218 p_analyzed_data_id in number
219 ,p_object_version_number in number
220 );
221 --
222 end pqp_analyzed_alien_data_api;