DBA Data[Home] [Help]

PACKAGE: APPS.PQP_ANALYZED_ALIEN_DATA_API

Source


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;