DBA Data[Home] [Help]

PACKAGE: APPS.BEN_LOS_FACTORS_API

Source


1 Package ben_LOS_FACTORS_api as
2 /* $Header: belsfapi.pkh 120.0 2005/05/28 03:37:30 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_LOS_FACTORS >------------------------|
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_name                         Yes  varchar2
18 --   p_business_group_id            Yes  number    Business Group of Record
19 --   p_los_det_cd                   No   varchar2
20 --   p_los_det_rl                   No   number
21 --   p_mn_los_num                   No   number
22 --   p_mx_los_num                   No   number
23 --   p_no_mx_los_num_apls_flag      Yes  varchar2
24 --   p_no_mn_los_num_apls_flag      Yes  varchar2
25 --   p_rndg_cd                      No   varchar2
26 --   p_rndg_rl                      No   number
27 --   p_los_dt_to_use_cd             No   varchar2
28 --   p_los_dt_to_use_rl             No   number
29 --   p_los_uom                      No   varchar2
30 --   p_los_calc_rl                  No   number
31 --   p_los_alt_val_to_use_cd        No   varchar2
32 --   p_lsf_attribute_category       No   varchar2  Descriptive Flexfield
33 --   p_lsf_attribute1               No   varchar2  Descriptive Flexfield
34 --   p_lsf_attribute2               No   varchar2  Descriptive Flexfield
35 --   p_lsf_attribute3               No   varchar2  Descriptive Flexfield
36 --   p_lsf_attribute4               No   varchar2  Descriptive Flexfield
37 --   p_lsf_attribute5               No   varchar2  Descriptive Flexfield
38 --   p_lsf_attribute6               No   varchar2  Descriptive Flexfield
39 --   p_lsf_attribute7               No   varchar2  Descriptive Flexfield
40 --   p_lsf_attribute8               No   varchar2  Descriptive Flexfield
41 --   p_lsf_attribute9               No   varchar2  Descriptive Flexfield
42 --   p_lsf_attribute10              No   varchar2  Descriptive Flexfield
43 --   p_lsf_attribute11              No   varchar2  Descriptive Flexfield
44 --   p_lsf_attribute12              No   varchar2  Descriptive Flexfield
45 --   p_lsf_attribute13              No   varchar2  Descriptive Flexfield
46 --   p_lsf_attribute14              No   varchar2  Descriptive Flexfield
47 --   p_lsf_attribute15              No   varchar2  Descriptive Flexfield
48 --   p_lsf_attribute16              No   varchar2  Descriptive Flexfield
49 --   p_lsf_attribute17              No   varchar2  Descriptive Flexfield
50 --   p_lsf_attribute18              No   varchar2  Descriptive Flexfield
51 --   p_lsf_attribute19              No   varchar2  Descriptive Flexfield
52 --   p_lsf_attribute20              No   varchar2  Descriptive Flexfield
53 --   p_lsf_attribute21              No   varchar2  Descriptive Flexfield
54 --   p_lsf_attribute22              No   varchar2  Descriptive Flexfield
55 --   p_lsf_attribute23              No   varchar2  Descriptive Flexfield
56 --   p_lsf_attribute24              No   varchar2  Descriptive Flexfield
57 --   p_lsf_attribute25              No   varchar2  Descriptive Flexfield
58 --   p_lsf_attribute26              No   varchar2  Descriptive Flexfield
59 --   p_lsf_attribute27              No   varchar2  Descriptive Flexfield
60 --   p_lsf_attribute28              No   varchar2  Descriptive Flexfield
61 --   p_lsf_attribute29              No   varchar2  Descriptive Flexfield
62 --   p_lsf_attribute30              No   varchar2  Descriptive Flexfield
63 --   p_use_overid_svc_dt_flag       Yes  varchar2
64 --   p_effective_date           Yes  date      Session Date.
65 --
66 -- Post Success:
67 --
68 -- Out Parameters:
69 --   Name                                Type     Description
70 --   p_los_fctr_id                  Yes  number    PK of record
71 --   p_object_version_number        No   number    OVN of record
72 --
73 -- Post Failure:
74 --
75 -- Access Status:
76 --   Public.
77 --
78 -- {End Of Comments}
79 --
80 procedure create_LOS_FACTORS
81 (
82    p_validate                       in boolean    default false
83   ,p_los_fctr_id                    out nocopy number
84   ,p_name                           in  varchar2  default null
85   ,p_business_group_id              in  number    default null
86   ,p_los_det_cd                     in  varchar2  default null
87   ,p_los_det_rl                     in  number    default null
88   ,p_mn_los_num                     in  number    default null
89   ,p_mx_los_num                     in  number    default null
90   ,p_no_mx_los_num_apls_flag        in  varchar2  default null
91   ,p_no_mn_los_num_apls_flag        in  varchar2  default null
92   ,p_rndg_cd                        in  varchar2  default null
93   ,p_rndg_rl                        in  number    default null
94   ,p_los_dt_to_use_cd               in  varchar2  default null
95   ,p_los_dt_to_use_rl               in  number    default null
96   ,p_los_uom                        in  varchar2  default null
97   ,p_los_calc_rl                    in  number    default null
98   ,p_los_alt_val_to_use_cd          in  varchar2  default null
99   ,p_lsf_attribute_category         in  varchar2  default null
100   ,p_lsf_attribute1                 in  varchar2  default null
101   ,p_lsf_attribute2                 in  varchar2  default null
102   ,p_lsf_attribute3                 in  varchar2  default null
103   ,p_lsf_attribute4                 in  varchar2  default null
104   ,p_lsf_attribute5                 in  varchar2  default null
105   ,p_lsf_attribute6                 in  varchar2  default null
106   ,p_lsf_attribute7                 in  varchar2  default null
107   ,p_lsf_attribute8                 in  varchar2  default null
108   ,p_lsf_attribute9                 in  varchar2  default null
109   ,p_lsf_attribute10                in  varchar2  default null
110   ,p_lsf_attribute11                in  varchar2  default null
111   ,p_lsf_attribute12                in  varchar2  default null
112   ,p_lsf_attribute13                in  varchar2  default null
113   ,p_lsf_attribute14                in  varchar2  default null
114   ,p_lsf_attribute15                in  varchar2  default null
115   ,p_lsf_attribute16                in  varchar2  default null
116   ,p_lsf_attribute17                in  varchar2  default null
117   ,p_lsf_attribute18                in  varchar2  default null
118   ,p_lsf_attribute19                in  varchar2  default null
119   ,p_lsf_attribute20                in  varchar2  default null
120   ,p_lsf_attribute21                in  varchar2  default null
121   ,p_lsf_attribute22                in  varchar2  default null
122   ,p_lsf_attribute23                in  varchar2  default null
123   ,p_lsf_attribute24                in  varchar2  default null
124   ,p_lsf_attribute25                in  varchar2  default null
125   ,p_lsf_attribute26                in  varchar2  default null
126   ,p_lsf_attribute27                in  varchar2  default null
127   ,p_lsf_attribute28                in  varchar2  default null
128   ,p_lsf_attribute29                in  varchar2  default null
129   ,p_lsf_attribute30                in  varchar2  default null
130   ,p_object_version_number          out nocopy number
131   ,p_use_overid_svc_dt_flag         in  varchar2  default null
132   ,p_effective_date            in  date
133  );
134 -- ----------------------------------------------------------------------------
135 -- |------------------------< update_LOS_FACTORS >------------------------|
136 -- ----------------------------------------------------------------------------
137 -- {Start Of Comments}
138 --
139 -- Description:
140 --
141 -- Prerequisites:
142 --
143 --
144 -- In Parameters:
145 --   Name                           Reqd Type     Description
146 --   p_validate                     Yes  boolean  Commit or Rollback.
147 --   p_los_fctr_id                  Yes  number    PK of record
148 --   p_name                         Yes  varchar2
149 --   p_business_group_id            Yes  number    Business Group of Record
150 --   p_los_det_cd                   No   varchar2
151 --   p_los_det_rl                   No   number
152 --   p_mn_los_num                   No   number
153 --   p_mx_los_num                   No   number
154 --   p_no_mx_los_num_apls_flag      Yes  varchar2
155 --   p_no_mn_los_num_apls_flag      Yes  varchar2
156 --   p_rndg_cd                      No   varchar2
157 --   p_rndg_rl                      No   number
158 --   p_los_dt_to_use_cd             No   varchar2
159 --   p_los_dt_to_use_rl             No   number
160 --   p_los_uom                      No   varchar2
161 --   p_los_calc_rl                  No   number
162 --   p_los_alt_val_to_use_cd        No   varchar2
163 --   p_lsf_attribute_category       No   varchar2  Descriptive Flexfield
164 --   p_lsf_attribute1               No   varchar2  Descriptive Flexfield
165 --   p_lsf_attribute2               No   varchar2  Descriptive Flexfield
166 --   p_lsf_attribute3               No   varchar2  Descriptive Flexfield
167 --   p_lsf_attribute4               No   varchar2  Descriptive Flexfield
168 --   p_lsf_attribute5               No   varchar2  Descriptive Flexfield
169 --   p_lsf_attribute6               No   varchar2  Descriptive Flexfield
170 --   p_lsf_attribute7               No   varchar2  Descriptive Flexfield
171 --   p_lsf_attribute8               No   varchar2  Descriptive Flexfield
172 --   p_lsf_attribute9               No   varchar2  Descriptive Flexfield
173 --   p_lsf_attribute10              No   varchar2  Descriptive Flexfield
174 --   p_lsf_attribute11              No   varchar2  Descriptive Flexfield
175 --   p_lsf_attribute12              No   varchar2  Descriptive Flexfield
176 --   p_lsf_attribute13              No   varchar2  Descriptive Flexfield
177 --   p_lsf_attribute14              No   varchar2  Descriptive Flexfield
178 --   p_lsf_attribute15              No   varchar2  Descriptive Flexfield
179 --   p_lsf_attribute16              No   varchar2  Descriptive Flexfield
180 --   p_lsf_attribute17              No   varchar2  Descriptive Flexfield
181 --   p_lsf_attribute18              No   varchar2  Descriptive Flexfield
182 --   p_lsf_attribute19              No   varchar2  Descriptive Flexfield
183 --   p_lsf_attribute20              No   varchar2  Descriptive Flexfield
184 --   p_lsf_attribute21              No   varchar2  Descriptive Flexfield
185 --   p_lsf_attribute22              No   varchar2  Descriptive Flexfield
186 --   p_lsf_attribute23              No   varchar2  Descriptive Flexfield
187 --   p_lsf_attribute24              No   varchar2  Descriptive Flexfield
188 --   p_lsf_attribute25              No   varchar2  Descriptive Flexfield
189 --   p_lsf_attribute26              No   varchar2  Descriptive Flexfield
190 --   p_lsf_attribute27              No   varchar2  Descriptive Flexfield
191 --   p_lsf_attribute28              No   varchar2  Descriptive Flexfield
192 --   p_lsf_attribute29              No   varchar2  Descriptive Flexfield
193 --   p_lsf_attribute30              No   varchar2  Descriptive Flexfield
194 --   p_use_overid_svc_dt_flag       Yes  varchar2
195 --   p_effective_date          Yes  date       Session Date.
196 --
197 -- Post Success:
198 --
199 --   Name                           Type     Description
200 --   p_object_version_number        No   number    OVN of record
201 --
202 -- Post Failure:
203 --
204 -- Access Status:
205 --   Public.
206 --
207 -- {End Of Comments}
208 --
209 procedure update_LOS_FACTORS
210   (
211    p_validate                       in boolean    default false
212   ,p_los_fctr_id                    in  number
213   ,p_name                           in  varchar2  default hr_api.g_varchar2
214   ,p_business_group_id              in  number    default hr_api.g_number
215   ,p_los_det_cd                     in  varchar2  default hr_api.g_varchar2
216   ,p_los_det_rl                     in  number    default hr_api.g_number
217   ,p_mn_los_num                     in  number    default hr_api.g_number
218   ,p_mx_los_num                     in  number    default hr_api.g_number
219   ,p_no_mx_los_num_apls_flag        in  varchar2  default hr_api.g_varchar2
220   ,p_no_mn_los_num_apls_flag        in  varchar2  default hr_api.g_varchar2
221   ,p_rndg_cd                        in  varchar2  default hr_api.g_varchar2
222   ,p_rndg_rl                        in  number    default hr_api.g_number
223   ,p_los_dt_to_use_cd               in  varchar2  default hr_api.g_varchar2
224   ,p_los_dt_to_use_rl               in  number    default hr_api.g_number
225   ,p_los_uom                        in  varchar2  default hr_api.g_varchar2
226   ,p_los_calc_rl                    in  number    default hr_api.g_number
227   ,p_los_alt_val_to_use_cd          in  varchar2  default hr_api.g_varchar2
228   ,p_lsf_attribute_category         in  varchar2  default hr_api.g_varchar2
229   ,p_lsf_attribute1                 in  varchar2  default hr_api.g_varchar2
230   ,p_lsf_attribute2                 in  varchar2  default hr_api.g_varchar2
231   ,p_lsf_attribute3                 in  varchar2  default hr_api.g_varchar2
232   ,p_lsf_attribute4                 in  varchar2  default hr_api.g_varchar2
233   ,p_lsf_attribute5                 in  varchar2  default hr_api.g_varchar2
234   ,p_lsf_attribute6                 in  varchar2  default hr_api.g_varchar2
235   ,p_lsf_attribute7                 in  varchar2  default hr_api.g_varchar2
236   ,p_lsf_attribute8                 in  varchar2  default hr_api.g_varchar2
237   ,p_lsf_attribute9                 in  varchar2  default hr_api.g_varchar2
238   ,p_lsf_attribute10                in  varchar2  default hr_api.g_varchar2
239   ,p_lsf_attribute11                in  varchar2  default hr_api.g_varchar2
240   ,p_lsf_attribute12                in  varchar2  default hr_api.g_varchar2
241   ,p_lsf_attribute13                in  varchar2  default hr_api.g_varchar2
242   ,p_lsf_attribute14                in  varchar2  default hr_api.g_varchar2
243   ,p_lsf_attribute15                in  varchar2  default hr_api.g_varchar2
244   ,p_lsf_attribute16                in  varchar2  default hr_api.g_varchar2
245   ,p_lsf_attribute17                in  varchar2  default hr_api.g_varchar2
246   ,p_lsf_attribute18                in  varchar2  default hr_api.g_varchar2
247   ,p_lsf_attribute19                in  varchar2  default hr_api.g_varchar2
248   ,p_lsf_attribute20                in  varchar2  default hr_api.g_varchar2
249   ,p_lsf_attribute21                in  varchar2  default hr_api.g_varchar2
250   ,p_lsf_attribute22                in  varchar2  default hr_api.g_varchar2
254   ,p_lsf_attribute26                in  varchar2  default hr_api.g_varchar2
251   ,p_lsf_attribute23                in  varchar2  default hr_api.g_varchar2
252   ,p_lsf_attribute24                in  varchar2  default hr_api.g_varchar2
253   ,p_lsf_attribute25                in  varchar2  default hr_api.g_varchar2
255   ,p_lsf_attribute27                in  varchar2  default hr_api.g_varchar2
256   ,p_lsf_attribute28                in  varchar2  default hr_api.g_varchar2
257   ,p_lsf_attribute29                in  varchar2  default hr_api.g_varchar2
258   ,p_lsf_attribute30                in  varchar2  default hr_api.g_varchar2
259   ,p_object_version_number          in out nocopy number
260   ,p_use_overid_svc_dt_flag         in  varchar2  default hr_api.g_varchar2
261   ,p_effective_date            in  date
262   );
263 --
264 -- ----------------------------------------------------------------------------
265 -- |------------------------< delete_LOS_FACTORS >------------------------|
266 -- ----------------------------------------------------------------------------
267 -- {Start Of Comments}
268 --
269 -- Description:
270 --
271 -- Prerequisites:
272 --
273 --
274 -- In Parameters:
275 --   Name                           Reqd Type     Description
276 --   p_validate                     Yes  boolean  Commit or Rollback.
277 --   p_los_fctr_id                  Yes  number    PK of record
278 --   p_effective_date          Yes  date     Session Date.
279 --
280 -- Post Success:
281 --
282 --   Name                           Type     Description
283 --   p_object_version_number        No   number    OVN of record
284 --
285 -- Post Failure:
286 --
287 -- Access Status:
288 --   Public.
289 --
290 -- {End Of Comments}
291 --
292 procedure delete_LOS_FACTORS
293   (
294    p_validate                       in boolean        default false
295   ,p_los_fctr_id                    in  number
296   ,p_object_version_number          in out nocopy number
297   ,p_effective_date            in date
298   );
299 --
300 -- ----------------------------------------------------------------------------
301 -- |----------------------------------< lck >---------------------------------|
302 -- ----------------------------------------------------------------------------
303 -- {Start Of Comments}
304 --
305 -- Description:
306 --
307 -- Prerequisites:
308 --
309 --
310 -- In Parameters:
311 --   Name                           Reqd Type     Description
312 --   p_los_fctr_id                 Yes  number   PK of record
313 --   p_object_version_number        Yes  number   OVN of record
314 --
315 -- Post Success:
316 --
317 --   Name                           Type     Description
318 --
319 -- Post Failure:
320 --
321 -- Access Status:
322 --   Public.
323 --
324 -- {End Of Comments}
325 --
326 procedure lck
327   (
328     p_los_fctr_id                 in number
329    ,p_object_version_number        in number
330   );
331 --
332 end ben_LOS_FACTORS_api;