DBA Data[Home] [Help]

PACKAGE: APPS.BEN_CBR_PER_IN_LER_API

Source


1 Package ben_CBR_PER_IN_LER_api AUTHID CURRENT_USER as
2 /* $Header: becrpapi.pkh 120.0 2005/05/28 01:21:44 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_CBR_PER_IN_LER >------------------------|
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_init_evt_flag                Yes  varchar2
18 --   p_cnt_num                      No   number
19 --   p_per_in_ler_id                Yes  number
20 --   p_cbr_quald_bnf_id             Yes  number
21 --   p_prvs_elig_perd_end_dt        No   date
22 --   p_business_group_id            Yes  number    Business Group of Record
23 --   p_crp_attribute_category       No   varchar2  Descriptive Flexfield
24 --   p_crp_attribute1               No   varchar2  Descriptive Flexfield
25 --   p_crp_attribute2               No   varchar2  Descriptive Flexfield
26 --   p_crp_attribute3               No   varchar2  Descriptive Flexfield
27 --   p_crp_attribute4               No   varchar2  Descriptive Flexfield
28 --   p_crp_attribute5               No   varchar2  Descriptive Flexfield
29 --   p_crp_attribute6               No   varchar2  Descriptive Flexfield
30 --   p_crp_attribute7               No   varchar2  Descriptive Flexfield
31 --   p_crp_attribute8               No   varchar2  Descriptive Flexfield
32 --   p_crp_attribute9               No   varchar2  Descriptive Flexfield
33 --   p_crp_attribute10              No   varchar2  Descriptive Flexfield
34 --   p_crp_attribute11              No   varchar2  Descriptive Flexfield
35 --   p_crp_attribute12              No   varchar2  Descriptive Flexfield
36 --   p_crp_attribute13              No   varchar2  Descriptive Flexfield
37 --   p_crp_attribute14              No   varchar2  Descriptive Flexfield
38 --   p_crp_attribute15              No   varchar2  Descriptive Flexfield
39 --   p_crp_attribute16              No   varchar2  Descriptive Flexfield
40 --   p_crp_attribute17              No   varchar2  Descriptive Flexfield
41 --   p_crp_attribute18              No   varchar2  Descriptive Flexfield
42 --   p_crp_attribute19              No   varchar2  Descriptive Flexfield
43 --   p_crp_attribute20              No   varchar2  Descriptive Flexfield
44 --   p_crp_attribute21              No   varchar2  Descriptive Flexfield
45 --   p_crp_attribute22              No   varchar2  Descriptive Flexfield
46 --   p_crp_attribute23              No   varchar2  Descriptive Flexfield
47 --   p_crp_attribute24              No   varchar2  Descriptive Flexfield
48 --   p_crp_attribute25              No   varchar2  Descriptive Flexfield
49 --   p_crp_attribute26              No   varchar2  Descriptive Flexfield
50 --   p_crp_attribute27              No   varchar2  Descriptive Flexfield
51 --   p_crp_attribute28              No   varchar2  Descriptive Flexfield
52 --   p_crp_attribute29              No   varchar2  Descriptive Flexfield
53 --   p_crp_attribute30              No   varchar2  Descriptive Flexfield
54 --   p_effective_date           Yes  date      Session Date.
55 --
56 -- Post Success:
57 --
58 -- Out Parameters:
59 --   Name                                Type     Description
60 --   p_cbr_per_in_ler_id            Yes  number    PK of record
61 --   p_object_version_number        No   number    OVN of record
62 --
63 -- Post Failure:
64 --
65 -- Access Status:
66 --   Public.
67 --
68 -- {End Of Comments}
69 --
70 procedure create_CBR_PER_IN_LER
71 (
72    p_validate                       in boolean    default false
76   ,p_per_in_ler_id                  in  number    default null
73   ,p_cbr_per_in_ler_id              out nocopy number
74   ,p_init_evt_flag                  in  varchar2  default 'N'
75   ,p_cnt_num                        in  number    default null
77   ,p_cbr_quald_bnf_id               in  number    default null
78   ,p_prvs_elig_perd_end_dt          in  date      default null
79   ,p_business_group_id              in  number    default null
80   ,p_crp_attribute_category         in  varchar2  default null
81   ,p_crp_attribute1                 in  varchar2  default null
82   ,p_crp_attribute2                 in  varchar2  default null
83   ,p_crp_attribute3                 in  varchar2  default null
84   ,p_crp_attribute4                 in  varchar2  default null
85   ,p_crp_attribute5                 in  varchar2  default null
86   ,p_crp_attribute6                 in  varchar2  default null
87   ,p_crp_attribute7                 in  varchar2  default null
88   ,p_crp_attribute8                 in  varchar2  default null
89   ,p_crp_attribute9                 in  varchar2  default null
90   ,p_crp_attribute10                in  varchar2  default null
91   ,p_crp_attribute11                in  varchar2  default null
92   ,p_crp_attribute12                in  varchar2  default null
93   ,p_crp_attribute13                in  varchar2  default null
94   ,p_crp_attribute14                in  varchar2  default null
95   ,p_crp_attribute15                in  varchar2  default null
96   ,p_crp_attribute16                in  varchar2  default null
97   ,p_crp_attribute17                in  varchar2  default null
98   ,p_crp_attribute18                in  varchar2  default null
99   ,p_crp_attribute19                in  varchar2  default null
100   ,p_crp_attribute20                in  varchar2  default null
101   ,p_crp_attribute21                in  varchar2  default null
102   ,p_crp_attribute22                in  varchar2  default null
103   ,p_crp_attribute23                in  varchar2  default null
104   ,p_crp_attribute24                in  varchar2  default null
105   ,p_crp_attribute25                in  varchar2  default null
106   ,p_crp_attribute26                in  varchar2  default null
107   ,p_crp_attribute27                in  varchar2  default null
108   ,p_crp_attribute28                in  varchar2  default null
109   ,p_crp_attribute29                in  varchar2  default null
110   ,p_crp_attribute30                in  varchar2  default null
111   ,p_object_version_number          out nocopy number
112   ,p_effective_date            in  date
113  );
114 -- ----------------------------------------------------------------------------
115 -- |------------------------< update_CBR_PER_IN_LER >------------------------|
116 -- ----------------------------------------------------------------------------
117 -- {Start Of Comments}
118 --
119 -- Description:
120 --
121 -- Prerequisites:
122 --
123 --
124 -- In Parameters:
125 --   Name                           Reqd Type     Description
126 --   p_validate                     Yes  boolean  Commit or Rollback.
127 --   p_cbr_per_in_ler_id            Yes  number    PK of record
128 --   p_init_evt_flag                Yes  varchar2
129 --   p_cnt_num                      No   number
130 --   p_per_in_ler_id                Yes  number
131 --   p_cbr_quald_bnf_id             Yes  number
132 --   p_prvs_elig_perd_end_dt        No   date
133 --   p_business_group_id            Yes  number    Business Group of Record
134 --   p_crp_attribute_category       No   varchar2  Descriptive Flexfield
135 --   p_crp_attribute1               No   varchar2  Descriptive Flexfield
136 --   p_crp_attribute2               No   varchar2  Descriptive Flexfield
137 --   p_crp_attribute3               No   varchar2  Descriptive Flexfield
138 --   p_crp_attribute4               No   varchar2  Descriptive Flexfield
139 --   p_crp_attribute5               No   varchar2  Descriptive Flexfield
140 --   p_crp_attribute6               No   varchar2  Descriptive Flexfield
141 --   p_crp_attribute7               No   varchar2  Descriptive Flexfield
142 --   p_crp_attribute8               No   varchar2  Descriptive Flexfield
143 --   p_crp_attribute9               No   varchar2  Descriptive Flexfield
144 --   p_crp_attribute10              No   varchar2  Descriptive Flexfield
145 --   p_crp_attribute11              No   varchar2  Descriptive Flexfield
146 --   p_crp_attribute12              No   varchar2  Descriptive Flexfield
147 --   p_crp_attribute13              No   varchar2  Descriptive Flexfield
148 --   p_crp_attribute14              No   varchar2  Descriptive Flexfield
149 --   p_crp_attribute15              No   varchar2  Descriptive Flexfield
150 --   p_crp_attribute16              No   varchar2  Descriptive Flexfield
151 --   p_crp_attribute17              No   varchar2  Descriptive Flexfield
152 --   p_crp_attribute18              No   varchar2  Descriptive Flexfield
153 --   p_crp_attribute19              No   varchar2  Descriptive Flexfield
154 --   p_crp_attribute20              No   varchar2  Descriptive Flexfield
155 --   p_crp_attribute21              No   varchar2  Descriptive Flexfield
156 --   p_crp_attribute22              No   varchar2  Descriptive Flexfield
157 --   p_crp_attribute23              No   varchar2  Descriptive Flexfield
158 --   p_crp_attribute24              No   varchar2  Descriptive Flexfield
159 --   p_crp_attribute25              No   varchar2  Descriptive Flexfield
160 --   p_crp_attribute26              No   varchar2  Descriptive Flexfield
161 --   p_crp_attribute27              No   varchar2  Descriptive Flexfield
162 --   p_crp_attribute28              No   varchar2  Descriptive Flexfield
163 --   p_crp_attribute29              No   varchar2  Descriptive Flexfield
164 --   p_crp_attribute30              No   varchar2  Descriptive Flexfield
165 --   p_effective_date          Yes  date       Session Date.
166 --
167 -- Post Success:
168 --
169 --   Name                           Type     Description
170 --   p_object_version_number        No   number    OVN of record
171 --
172 -- Post Failure:
176 --
173 --
174 -- Access Status:
175 --   Public.
177 -- {End Of Comments}
178 --
179 procedure update_CBR_PER_IN_LER
180   (
181    p_validate                       in boolean    default false
182   ,p_cbr_per_in_ler_id              in  number
183   ,p_init_evt_flag                  in  varchar2  default hr_api.g_varchar2
184   ,p_cnt_num                        in  number    default hr_api.g_number
185   ,p_per_in_ler_id                  in  number    default hr_api.g_number
186   ,p_cbr_quald_bnf_id               in  number    default hr_api.g_number
187   ,p_prvs_elig_perd_end_dt          in  date      default hr_api.g_date
188   ,p_business_group_id              in  number    default hr_api.g_number
189   ,p_crp_attribute_category         in  varchar2  default hr_api.g_varchar2
190   ,p_crp_attribute1                 in  varchar2  default hr_api.g_varchar2
191   ,p_crp_attribute2                 in  varchar2  default hr_api.g_varchar2
192   ,p_crp_attribute3                 in  varchar2  default hr_api.g_varchar2
193   ,p_crp_attribute4                 in  varchar2  default hr_api.g_varchar2
194   ,p_crp_attribute5                 in  varchar2  default hr_api.g_varchar2
195   ,p_crp_attribute6                 in  varchar2  default hr_api.g_varchar2
196   ,p_crp_attribute7                 in  varchar2  default hr_api.g_varchar2
197   ,p_crp_attribute8                 in  varchar2  default hr_api.g_varchar2
198   ,p_crp_attribute9                 in  varchar2  default hr_api.g_varchar2
199   ,p_crp_attribute10                in  varchar2  default hr_api.g_varchar2
200   ,p_crp_attribute11                in  varchar2  default hr_api.g_varchar2
201   ,p_crp_attribute12                in  varchar2  default hr_api.g_varchar2
202   ,p_crp_attribute13                in  varchar2  default hr_api.g_varchar2
203   ,p_crp_attribute14                in  varchar2  default hr_api.g_varchar2
204   ,p_crp_attribute15                in  varchar2  default hr_api.g_varchar2
205   ,p_crp_attribute16                in  varchar2  default hr_api.g_varchar2
206   ,p_crp_attribute17                in  varchar2  default hr_api.g_varchar2
207   ,p_crp_attribute18                in  varchar2  default hr_api.g_varchar2
208   ,p_crp_attribute19                in  varchar2  default hr_api.g_varchar2
209   ,p_crp_attribute20                in  varchar2  default hr_api.g_varchar2
210   ,p_crp_attribute21                in  varchar2  default hr_api.g_varchar2
211   ,p_crp_attribute22                in  varchar2  default hr_api.g_varchar2
212   ,p_crp_attribute23                in  varchar2  default hr_api.g_varchar2
213   ,p_crp_attribute24                in  varchar2  default hr_api.g_varchar2
214   ,p_crp_attribute25                in  varchar2  default hr_api.g_varchar2
215   ,p_crp_attribute26                in  varchar2  default hr_api.g_varchar2
216   ,p_crp_attribute27                in  varchar2  default hr_api.g_varchar2
217   ,p_crp_attribute28                in  varchar2  default hr_api.g_varchar2
218   ,p_crp_attribute29                in  varchar2  default hr_api.g_varchar2
219   ,p_crp_attribute30                in  varchar2  default hr_api.g_varchar2
220   ,p_object_version_number          in out nocopy number
221   ,p_effective_date            in  date
222   );
223 --
224 -- ----------------------------------------------------------------------------
225 -- |------------------------< delete_CBR_PER_IN_LER >------------------------|
226 -- ----------------------------------------------------------------------------
227 -- {Start Of Comments}
228 --
229 -- Description:
230 --
231 -- Prerequisites:
232 --
233 --
234 -- In Parameters:
235 --   Name                           Reqd Type     Description
236 --   p_validate                     Yes  boolean  Commit or Rollback.
237 --   p_cbr_per_in_ler_id            Yes  number    PK of record
238 --   p_effective_date          Yes  date     Session Date.
239 --
240 -- Post Success:
241 --
242 --   Name                           Type     Description
243 --   p_object_version_number        No   number    OVN of record
244 --
245 -- Post Failure:
246 --
247 -- Access Status:
248 --   Public.
249 --
250 -- {End Of Comments}
251 --
252 procedure delete_CBR_PER_IN_LER
253   (
254    p_validate                       in boolean        default false
255   ,p_cbr_per_in_ler_id              in  number
256   ,p_object_version_number          in out nocopy number
257   ,p_effective_date            in date
258   );
259 --
260 -- ----------------------------------------------------------------------------
261 -- |----------------------------------< lck >---------------------------------|
262 -- ----------------------------------------------------------------------------
263 -- {Start Of Comments}
267 -- Prerequisites:
264 --
265 -- Description:
266 --
268 --
269 --
270 -- In Parameters:
271 --   Name                           Reqd Type     Description
272 --   p_cbr_per_in_ler_id                 Yes  number   PK of record
273 --   p_object_version_number        Yes  number   OVN of record
274 --
275 -- Post Success:
276 --
277 --   Name                           Type     Description
278 --
279 -- Post Failure:
280 --
281 -- Access Status:
282 --   Public.
283 --
284 -- {End Of Comments}
285 --
286 procedure lck
287   (
288     p_cbr_per_in_ler_id                 in number
289    ,p_object_version_number        in number
290   );
291 --
292 end ben_CBR_PER_IN_LER_api;