DBA Data[Home] [Help]

PACKAGE: APPS.BEN_WITHIN_YEAR_PERD_API

Source


1 Package ben_WITHIN_YEAR_PERD_api as
2 /* $Header: bewypapi.pkh 120.0 2005/05/28 12:21:12 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_WITHIN_YEAR_PERD >------------------------|
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_strt_day                     No   number
18 --   p_end_day                      No   number
19 --   p_strt_mo                      No   number
20 --   p_end_mo                       No   number
21 --   p_tm_uom                       No   varchar2
22 --   p_yr_perd_id                   No   number
23 --   p_business_group_id            No   number    Business Group of Record
24 --   p_wyp_attribute_category       No   varchar2  Descriptive Flexfield
25 --   p_wyp_attribute1               No   varchar2  Descriptive Flexfield
26 --   p_wyp_attribute2               No   varchar2  Descriptive Flexfield
27 --   p_wyp_attribute3               No   varchar2  Descriptive Flexfield
28 --   p_wyp_attribute4               No   varchar2  Descriptive Flexfield
29 --   p_wyp_attribute5               No   varchar2  Descriptive Flexfield
30 --   p_wyp_attribute6               No   varchar2  Descriptive Flexfield
31 --   p_wyp_attribute7               No   varchar2  Descriptive Flexfield
32 --   p_wyp_attribute8               No   varchar2  Descriptive Flexfield
33 --   p_wyp_attribute9               No   varchar2  Descriptive Flexfield
34 --   p_wyp_attribute10              No   varchar2  Descriptive Flexfield
35 --   p_wyp_attribute11              No   varchar2  Descriptive Flexfield
36 --   p_wyp_attribute12              No   varchar2  Descriptive Flexfield
37 --   p_wyp_attribute13              No   varchar2  Descriptive Flexfield
38 --   p_wyp_attribute14              No   varchar2  Descriptive Flexfield
39 --   p_wyp_attribute15              No   varchar2  Descriptive Flexfield
40 --   p_wyp_attribute16              No   varchar2  Descriptive Flexfield
41 --   p_wyp_attribute17              No   varchar2  Descriptive Flexfield
42 --   p_wyp_attribute18              No   varchar2  Descriptive Flexfield
43 --   p_wyp_attribute19              No   varchar2  Descriptive Flexfield
44 --   p_wyp_attribute20              No   varchar2  Descriptive Flexfield
45 --   p_wyp_attribute21              No   varchar2  Descriptive Flexfield
46 --   p_wyp_attribute22              No   varchar2  Descriptive Flexfield
47 --   p_wyp_attribute23              No   varchar2  Descriptive Flexfield
48 --   p_wyp_attribute24              No   varchar2  Descriptive Flexfield
49 --   p_wyp_attribute25              No   varchar2  Descriptive Flexfield
50 --   p_wyp_attribute26              No   varchar2  Descriptive Flexfield
51 --   p_wyp_attribute27              No   varchar2  Descriptive Flexfield
52 --   p_wyp_attribute28              No   varchar2  Descriptive Flexfield
53 --   p_wyp_attribute29              No   varchar2  Descriptive Flexfield
54 --   p_wyp_attribute30              No   varchar2  Descriptive Flexfield
55 --   p_effective_date               Yes  date      Session Date.
56 --
57 -- Post Success:
58 --
59 -- Out Parameters:
60 --   Name                                Type     Description
61 --   p_wthn_yr_perd_id              Yes  number    PK of record
62 --   p_object_version_number        No   number    OVN of record
63 --
64 -- Post Failure:
65 --
66 -- Access Status:
67 --   Public.
68 --
69 -- {End Of Comments}
70 --
71 procedure create_WITHIN_YEAR_PERD
72 (
73    p_validate                       in boolean    default false
74   ,p_wthn_yr_perd_id                out nocopy number
75   ,p_strt_day                       in  number    default null
76   ,p_end_day                        in  number    default null
77   ,p_strt_mo                        in  number    default null
78   ,p_end_mo                         in  number    default null
79   ,p_tm_uom                         in  varchar2  default null
80   ,p_yr_perd_id                     in  number    default null
81   ,p_business_group_id              in  number    default null
82   ,p_wyp_attribute_category         in  varchar2  default null
83   ,p_wyp_attribute1                 in  varchar2  default null
84   ,p_wyp_attribute2                 in  varchar2  default null
85   ,p_wyp_attribute3                 in  varchar2  default null
86   ,p_wyp_attribute4                 in  varchar2  default null
87   ,p_wyp_attribute5                 in  varchar2  default null
88   ,p_wyp_attribute6                 in  varchar2  default null
89   ,p_wyp_attribute7                 in  varchar2  default null
90   ,p_wyp_attribute8                 in  varchar2  default null
91   ,p_wyp_attribute9                 in  varchar2  default null
92   ,p_wyp_attribute10                in  varchar2  default null
93   ,p_wyp_attribute11                in  varchar2  default null
94   ,p_wyp_attribute12                in  varchar2  default null
95   ,p_wyp_attribute13                in  varchar2  default null
96   ,p_wyp_attribute14                in  varchar2  default null
97   ,p_wyp_attribute15                in  varchar2  default null
98   ,p_wyp_attribute16                in  varchar2  default null
99   ,p_wyp_attribute17                in  varchar2  default null
100   ,p_wyp_attribute18                in  varchar2  default null
101   ,p_wyp_attribute19                in  varchar2  default null
102   ,p_wyp_attribute20                in  varchar2  default null
103   ,p_wyp_attribute21                in  varchar2  default null
104   ,p_wyp_attribute22                in  varchar2  default null
105   ,p_wyp_attribute23                in  varchar2  default null
106   ,p_wyp_attribute24                in  varchar2  default null
107   ,p_wyp_attribute25                in  varchar2  default null
108   ,p_wyp_attribute26                in  varchar2  default null
109   ,p_wyp_attribute27                in  varchar2  default null
110   ,p_wyp_attribute28                in  varchar2  default null
111   ,p_wyp_attribute29                in  varchar2  default null
112   ,p_wyp_attribute30                in  varchar2  default null
113   ,p_object_version_number          out nocopy number
114   ,p_effective_date                 in  date
115  );
116 -- ----------------------------------------------------------------------------
117 -- |------------------------< update_WITHIN_YEAR_PERD >------------------------|
118 -- ----------------------------------------------------------------------------
119 -- {Start Of Comments}
120 --
121 -- Description:
122 --
123 -- Prerequisites:
124 --
125 --
126 -- In Parameters:
127 --   Name                           Reqd Type     Description
128 --   p_validate                     Yes  boolean  Commit or Rollback.
129 --   p_wthn_yr_perd_id              Yes  number    PK of record
130 --   p_strt_day                     No   number
131 --   p_end_day                      No   number
132 --   p_strt_mo                      No   number
133 --   p_end_mo                       No   number
134 --   p_tm_uom                       No   varchar2
135 --   p_yr_perd_id                   No   number
136 --   p_business_group_id            No   number    Business Group of Record
137 --   p_wyp_attribute_category       No   varchar2  Descriptive Flexfield
138 --   p_wyp_attribute1               No   varchar2  Descriptive Flexfield
139 --   p_wyp_attribute2               No   varchar2  Descriptive Flexfield
140 --   p_wyp_attribute3               No   varchar2  Descriptive Flexfield
141 --   p_wyp_attribute4               No   varchar2  Descriptive Flexfield
142 --   p_wyp_attribute5               No   varchar2  Descriptive Flexfield
143 --   p_wyp_attribute6               No   varchar2  Descriptive Flexfield
144 --   p_wyp_attribute7               No   varchar2  Descriptive Flexfield
145 --   p_wyp_attribute8               No   varchar2  Descriptive Flexfield
146 --   p_wyp_attribute9               No   varchar2  Descriptive Flexfield
147 --   p_wyp_attribute10              No   varchar2  Descriptive Flexfield
148 --   p_wyp_attribute11              No   varchar2  Descriptive Flexfield
149 --   p_wyp_attribute12              No   varchar2  Descriptive Flexfield
150 --   p_wyp_attribute13              No   varchar2  Descriptive Flexfield
151 --   p_wyp_attribute14              No   varchar2  Descriptive Flexfield
152 --   p_wyp_attribute15              No   varchar2  Descriptive Flexfield
153 --   p_wyp_attribute16              No   varchar2  Descriptive Flexfield
154 --   p_wyp_attribute17              No   varchar2  Descriptive Flexfield
155 --   p_wyp_attribute18              No   varchar2  Descriptive Flexfield
156 --   p_wyp_attribute19              No   varchar2  Descriptive Flexfield
157 --   p_wyp_attribute20              No   varchar2  Descriptive Flexfield
158 --   p_wyp_attribute21              No   varchar2  Descriptive Flexfield
159 --   p_wyp_attribute22              No   varchar2  Descriptive Flexfield
160 --   p_wyp_attribute23              No   varchar2  Descriptive Flexfield
161 --   p_wyp_attribute24              No   varchar2  Descriptive Flexfield
162 --   p_wyp_attribute25              No   varchar2  Descriptive Flexfield
163 --   p_wyp_attribute26              No   varchar2  Descriptive Flexfield
164 --   p_wyp_attribute27              No   varchar2  Descriptive Flexfield
165 --   p_wyp_attribute28              No   varchar2  Descriptive Flexfield
166 --   p_wyp_attribute29              No   varchar2  Descriptive Flexfield
167 --   p_wyp_attribute30              No   varchar2  Descriptive Flexfield
168 --   p_effective_date               Yes  date      Session Date.
169 --
170 -- Post Success:
171 --
172 --   Name                           Type     Description
173 --   p_object_version_number        No   number    OVN of record
174 --
175 -- Post Failure:
176 --
177 -- Access Status:
178 --   Public.
179 --
180 -- {End Of Comments}
181 --
182 procedure update_WITHIN_YEAR_PERD
183   (
184    p_validate                       in boolean    default false
185   ,p_wthn_yr_perd_id                in  number
186   ,p_strt_day                       in  number    default hr_api.g_number
187   ,p_end_day                        in  number    default hr_api.g_number
188   ,p_strt_mo                        in  number    default hr_api.g_number
189   ,p_end_mo                         in  number    default hr_api.g_number
190   ,p_tm_uom                         in  varchar2  default hr_api.g_varchar2
191   ,p_yr_perd_id                     in  number    default hr_api.g_number
192   ,p_business_group_id              in  number    default hr_api.g_number
193   ,p_wyp_attribute_category         in  varchar2  default hr_api.g_varchar2
194   ,p_wyp_attribute1                 in  varchar2  default hr_api.g_varchar2
195   ,p_wyp_attribute2                 in  varchar2  default hr_api.g_varchar2
196   ,p_wyp_attribute3                 in  varchar2  default hr_api.g_varchar2
197   ,p_wyp_attribute4                 in  varchar2  default hr_api.g_varchar2
198   ,p_wyp_attribute5                 in  varchar2  default hr_api.g_varchar2
199   ,p_wyp_attribute6                 in  varchar2  default hr_api.g_varchar2
200   ,p_wyp_attribute7                 in  varchar2  default hr_api.g_varchar2
201   ,p_wyp_attribute8                 in  varchar2  default hr_api.g_varchar2
202   ,p_wyp_attribute9                 in  varchar2  default hr_api.g_varchar2
203   ,p_wyp_attribute10                in  varchar2  default hr_api.g_varchar2
204   ,p_wyp_attribute11                in  varchar2  default hr_api.g_varchar2
205   ,p_wyp_attribute12                in  varchar2  default hr_api.g_varchar2
206   ,p_wyp_attribute13                in  varchar2  default hr_api.g_varchar2
207   ,p_wyp_attribute14                in  varchar2  default hr_api.g_varchar2
208   ,p_wyp_attribute15                in  varchar2  default hr_api.g_varchar2
209   ,p_wyp_attribute16                in  varchar2  default hr_api.g_varchar2
210   ,p_wyp_attribute17                in  varchar2  default hr_api.g_varchar2
211   ,p_wyp_attribute18                in  varchar2  default hr_api.g_varchar2
212   ,p_wyp_attribute19                in  varchar2  default hr_api.g_varchar2
213   ,p_wyp_attribute20                in  varchar2  default hr_api.g_varchar2
214   ,p_wyp_attribute21                in  varchar2  default hr_api.g_varchar2
215   ,p_wyp_attribute22                in  varchar2  default hr_api.g_varchar2
216   ,p_wyp_attribute23                in  varchar2  default hr_api.g_varchar2
217   ,p_wyp_attribute24                in  varchar2  default hr_api.g_varchar2
218   ,p_wyp_attribute25                in  varchar2  default hr_api.g_varchar2
219   ,p_wyp_attribute26                in  varchar2  default hr_api.g_varchar2
220   ,p_wyp_attribute27                in  varchar2  default hr_api.g_varchar2
221   ,p_wyp_attribute28                in  varchar2  default hr_api.g_varchar2
222   ,p_wyp_attribute29                in  varchar2  default hr_api.g_varchar2
223   ,p_wyp_attribute30                in  varchar2  default hr_api.g_varchar2
224   ,p_effective_date                 in  date
225   ,p_object_version_number          in out nocopy number
226   );
227 --
228 -- ----------------------------------------------------------------------------
229 -- |------------------------< delete_WITHIN_YEAR_PERD >------------------------|
230 -- ----------------------------------------------------------------------------
231 -- {Start Of Comments}
232 --
233 -- Description:
234 --
235 -- Prerequisites:
236 --
237 --
238 -- In Parameters:
239 --   Name                           Reqd Type     Description
240 --   p_validate                     Yes  boolean  Commit or Rollback.
241 --   p_wthn_yr_perd_id              Yes  number    PK of record
242 --   p_effective_date               Yes  date     Session Date.
243 --
244 -- Post Success:
245 --
246 --   Name                           Type     Description
247 --   p_object_version_number        No   number    OVN of record
248 --
249 -- Post Failure:
250 --
251 -- Access Status:
252 --   Public.
253 --
254 -- {End Of Comments}
255 --
256 procedure delete_WITHIN_YEAR_PERD
257   (
258    p_validate                       in boolean        default false
259   ,p_wthn_yr_perd_id                in  number
260   ,p_object_version_number          in out nocopy number
261   ,p_effective_date                 in date
262   );
263 --
264 -- ----------------------------------------------------------------------------
265 -- |----------------------------------< lck >---------------------------------|
266 -- ----------------------------------------------------------------------------
267 -- {Start Of Comments}
268 --
269 -- Description:
270 --
271 -- Prerequisites:
272 --
273 --
274 -- In Parameters:
275 --   Name                           Reqd Type     Description
276 --   p_wthn_yr_perd_id                 Yes  number   PK of record
277 --   p_object_version_number        Yes  number   OVN of record
278 --
279 -- Post Success:
280 --
281 --   Name                           Type     Description
282 --
283 -- Post Failure:
284 --
285 -- Access Status:
286 --   Public.
287 --
288 -- {End Of Comments}
289 --
290 procedure lck
291   (
292     p_wthn_yr_perd_id                 in number
293    ,p_object_version_number        in number
294   );
295 --
296 end ben_WITHIN_YEAR_PERD_api;