DBA Data[Home] [Help]

PACKAGE: APPS.BEN_BENEFITS_GROUP_API

Source


1 Package ben_Benefits_Group_api as
2 /* $Header: bebngapi.pkh 120.0 2005/05/28 00:45:10 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_Benefits_Group >------------------------|
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_business_group_id            Yes  number    Business Group of Record
18 --   p_name                         Yes  varchar2
19 --   p_bng_desc                     No   varchar2
20 --   p_bng_attribute_category       No   varchar2  Descriptive Flexfield
21 --   p_bng_attribute1               No   varchar2  Descriptive Flexfield
22 --   p_bng_attribute2               No   varchar2  Descriptive Flexfield
23 --   p_bng_attribute3               No   varchar2  Descriptive Flexfield
24 --   p_bng_attribute4               No   varchar2  Descriptive Flexfield
25 --   p_bng_attribute5               No   varchar2  Descriptive Flexfield
26 --   p_bng_attribute6               No   varchar2  Descriptive Flexfield
27 --   p_bng_attribute7               No   varchar2  Descriptive Flexfield
28 --   p_bng_attribute8               No   varchar2  Descriptive Flexfield
29 --   p_bng_attribute9               No   varchar2  Descriptive Flexfield
30 --   p_bng_attribute10              No   varchar2  Descriptive Flexfield
31 --   p_bng_attribute11              No   varchar2  Descriptive Flexfield
32 --   p_bng_attribute12              No   varchar2  Descriptive Flexfield
33 --   p_bng_attribute13              No   varchar2  Descriptive Flexfield
34 --   p_bng_attribute14              No   varchar2  Descriptive Flexfield
35 --   p_bng_attribute15              No   varchar2  Descriptive Flexfield
36 --   p_bng_attribute16              No   varchar2  Descriptive Flexfield
37 --   p_bng_attribute17              No   varchar2  Descriptive Flexfield
38 --   p_bng_attribute18              No   varchar2  Descriptive Flexfield
39 --   p_bng_attribute19              No   varchar2  Descriptive Flexfield
40 --   p_bng_attribute20              No   varchar2  Descriptive Flexfield
41 --   p_bng_attribute21              No   varchar2  Descriptive Flexfield
42 --   p_bng_attribute22              No   varchar2  Descriptive Flexfield
43 --   p_bng_attribute23              No   varchar2  Descriptive Flexfield
44 --   p_bng_attribute24              No   varchar2  Descriptive Flexfield
45 --   p_bng_attribute25              No   varchar2  Descriptive Flexfield
46 --   p_bng_attribute26              No   varchar2  Descriptive Flexfield
47 --   p_bng_attribute27              No   varchar2  Descriptive Flexfield
48 --   p_bng_attribute28              No   varchar2  Descriptive Flexfield
49 --   p_bng_attribute29              No   varchar2  Descriptive Flexfield
50 --   p_bng_attribute30              No   varchar2  Descriptive Flexfield
51 --
52 -- Post Success:
53 --
54 -- Out Parameters:
55 --   Name                                Type     Description
56 --   p_benfts_grp_id                Yes  number    PK of record
57 --   p_object_version_number        No   number    OVN of record
58 --
59 -- Post Failure:
60 --
61 -- Access Status:
62 --   Public.
63 --
64 -- {End Of Comments}
65 --
66 procedure create_Benefits_Group
67 (
68    p_validate                       in boolean    default false
69   ,p_benfts_grp_id                  out nocopy number
70   ,p_business_group_id              in  number    default null
71   ,p_name                           in  varchar2  default null
72   ,p_bng_desc                       in  varchar2  default null
73   ,p_bng_attribute_category         in  varchar2  default null
74   ,p_bng_attribute1                 in  varchar2  default null
75   ,p_bng_attribute2                 in  varchar2  default null
76   ,p_bng_attribute3                 in  varchar2  default null
77   ,p_bng_attribute4                 in  varchar2  default null
78   ,p_bng_attribute5                 in  varchar2  default null
79   ,p_bng_attribute6                 in  varchar2  default null
80   ,p_bng_attribute7                 in  varchar2  default null
81   ,p_bng_attribute8                 in  varchar2  default null
82   ,p_bng_attribute9                 in  varchar2  default null
83   ,p_bng_attribute10                in  varchar2  default null
84   ,p_bng_attribute11                in  varchar2  default null
85   ,p_bng_attribute12                in  varchar2  default null
86   ,p_bng_attribute13                in  varchar2  default null
87   ,p_bng_attribute14                in  varchar2  default null
88   ,p_bng_attribute15                in  varchar2  default null
89   ,p_bng_attribute16                in  varchar2  default null
90   ,p_bng_attribute17                in  varchar2  default null
91   ,p_bng_attribute18                in  varchar2  default null
92   ,p_bng_attribute19                in  varchar2  default null
93   ,p_bng_attribute20                in  varchar2  default null
94   ,p_bng_attribute21                in  varchar2  default null
95   ,p_bng_attribute22                in  varchar2  default null
96   ,p_bng_attribute23                in  varchar2  default null
97   ,p_bng_attribute24                in  varchar2  default null
98   ,p_bng_attribute25                in  varchar2  default null
99   ,p_bng_attribute26                in  varchar2  default null
100   ,p_bng_attribute27                in  varchar2  default null
101   ,p_bng_attribute28                in  varchar2  default null
102   ,p_bng_attribute29                in  varchar2  default null
103   ,p_bng_attribute30                in  varchar2  default null
104   ,p_object_version_number          out nocopy number
105  );
106 -- ----------------------------------------------------------------------------
107 -- |------------------------< update_Benefits_Group >------------------------|
108 -- ----------------------------------------------------------------------------
109 -- {Start Of Comments}
110 --
111 -- Description:
112 --
113 -- Prerequisites:
114 --
115 --
116 -- In Parameters:
117 --   Name                           Reqd Type     Description
118 --   p_validate                     Yes  boolean  Commit or Rollback.
119 --   p_benfts_grp_id                Yes  number    PK of record
120 --   p_business_group_id            Yes  number    Business Group of Record
121 --   p_name                         Yes  varchar2
122 --   p_bng_desc                     No   varchar2
123 --   p_bng_attribute_category       No   varchar2  Descriptive Flexfield
124 --   p_bng_attribute1               No   varchar2  Descriptive Flexfield
125 --   p_bng_attribute2               No   varchar2  Descriptive Flexfield
126 --   p_bng_attribute3               No   varchar2  Descriptive Flexfield
127 --   p_bng_attribute4               No   varchar2  Descriptive Flexfield
128 --   p_bng_attribute5               No   varchar2  Descriptive Flexfield
129 --   p_bng_attribute6               No   varchar2  Descriptive Flexfield
130 --   p_bng_attribute7               No   varchar2  Descriptive Flexfield
131 --   p_bng_attribute8               No   varchar2  Descriptive Flexfield
132 --   p_bng_attribute9               No   varchar2  Descriptive Flexfield
133 --   p_bng_attribute10              No   varchar2  Descriptive Flexfield
134 --   p_bng_attribute11              No   varchar2  Descriptive Flexfield
135 --   p_bng_attribute12              No   varchar2  Descriptive Flexfield
136 --   p_bng_attribute13              No   varchar2  Descriptive Flexfield
137 --   p_bng_attribute14              No   varchar2  Descriptive Flexfield
138 --   p_bng_attribute15              No   varchar2  Descriptive Flexfield
139 --   p_bng_attribute16              No   varchar2  Descriptive Flexfield
140 --   p_bng_attribute17              No   varchar2  Descriptive Flexfield
141 --   p_bng_attribute18              No   varchar2  Descriptive Flexfield
142 --   p_bng_attribute19              No   varchar2  Descriptive Flexfield
143 --   p_bng_attribute20              No   varchar2  Descriptive Flexfield
144 --   p_bng_attribute21              No   varchar2  Descriptive Flexfield
145 --   p_bng_attribute22              No   varchar2  Descriptive Flexfield
146 --   p_bng_attribute23              No   varchar2  Descriptive Flexfield
147 --   p_bng_attribute24              No   varchar2  Descriptive Flexfield
148 --   p_bng_attribute25              No   varchar2  Descriptive Flexfield
149 --   p_bng_attribute26              No   varchar2  Descriptive Flexfield
150 --   p_bng_attribute27              No   varchar2  Descriptive Flexfield
151 --   p_bng_attribute28              No   varchar2  Descriptive Flexfield
152 --   p_bng_attribute29              No   varchar2  Descriptive Flexfield
153 --   p_bng_attribute30              No   varchar2  Descriptive Flexfield
154 --
155 -- Post Success:
156 --
157 --   Name                           Type     Description
158 --   p_object_version_number        No   number    OVN of record
159 --
160 -- Post Failure:
161 --
162 -- Access Status:
163 --   Public.
164 --
165 -- {End Of Comments}
166 --
167 procedure update_Benefits_Group
168   (
169    p_validate                       in boolean    default false
170   ,p_benfts_grp_id                  in  number
171   ,p_business_group_id              in  number    default hr_api.g_number
172   ,p_name                           in  varchar2  default hr_api.g_varchar2
173   ,p_bng_desc                       in  varchar2  default hr_api.g_varchar2
174   ,p_bng_attribute_category         in  varchar2  default hr_api.g_varchar2
175   ,p_bng_attribute1                 in  varchar2  default hr_api.g_varchar2
176   ,p_bng_attribute2                 in  varchar2  default hr_api.g_varchar2
177   ,p_bng_attribute3                 in  varchar2  default hr_api.g_varchar2
178   ,p_bng_attribute4                 in  varchar2  default hr_api.g_varchar2
179   ,p_bng_attribute5                 in  varchar2  default hr_api.g_varchar2
180   ,p_bng_attribute6                 in  varchar2  default hr_api.g_varchar2
181   ,p_bng_attribute7                 in  varchar2  default hr_api.g_varchar2
182   ,p_bng_attribute8                 in  varchar2  default hr_api.g_varchar2
183   ,p_bng_attribute9                 in  varchar2  default hr_api.g_varchar2
184   ,p_bng_attribute10                in  varchar2  default hr_api.g_varchar2
185   ,p_bng_attribute11                in  varchar2  default hr_api.g_varchar2
186   ,p_bng_attribute12                in  varchar2  default hr_api.g_varchar2
187   ,p_bng_attribute13                in  varchar2  default hr_api.g_varchar2
188   ,p_bng_attribute14                in  varchar2  default hr_api.g_varchar2
189   ,p_bng_attribute15                in  varchar2  default hr_api.g_varchar2
190   ,p_bng_attribute16                in  varchar2  default hr_api.g_varchar2
191   ,p_bng_attribute17                in  varchar2  default hr_api.g_varchar2
192   ,p_bng_attribute18                in  varchar2  default hr_api.g_varchar2
193   ,p_bng_attribute19                in  varchar2  default hr_api.g_varchar2
194   ,p_bng_attribute20                in  varchar2  default hr_api.g_varchar2
195   ,p_bng_attribute21                in  varchar2  default hr_api.g_varchar2
196   ,p_bng_attribute22                in  varchar2  default hr_api.g_varchar2
197   ,p_bng_attribute23                in  varchar2  default hr_api.g_varchar2
198   ,p_bng_attribute24                in  varchar2  default hr_api.g_varchar2
199   ,p_bng_attribute25                in  varchar2  default hr_api.g_varchar2
200   ,p_bng_attribute26                in  varchar2  default hr_api.g_varchar2
201   ,p_bng_attribute27                in  varchar2  default hr_api.g_varchar2
202   ,p_bng_attribute28                in  varchar2  default hr_api.g_varchar2
203   ,p_bng_attribute29                in  varchar2  default hr_api.g_varchar2
204   ,p_bng_attribute30                in  varchar2  default hr_api.g_varchar2
205   ,p_object_version_number          in out nocopy number
206   );
207 --
208 -- ----------------------------------------------------------------------------
209 -- |------------------------< delete_Benefits_Group >------------------------|
210 -- ----------------------------------------------------------------------------
211 -- {Start Of Comments}
212 --
213 -- Description:
214 --
215 -- Prerequisites:
216 --
217 --
218 -- In Parameters:
219 --   Name                           Reqd Type     Description
220 --   p_validate                     Yes  boolean  Commit or Rollback.
221 --   p_benfts_grp_id                Yes  number    PK of record
222 --
223 -- Post Success:
224 --
225 --   Name                           Type     Description
226 --   p_object_version_number        No   number    OVN of record
227 --
228 -- Post Failure:
229 --
230 -- Access Status:
231 --   Public.
232 --
233 -- {End Of Comments}
234 --
235 procedure delete_Benefits_Group
236   (
237    p_validate                       in boolean        default false
238   ,p_benfts_grp_id                  in  number
239   ,p_object_version_number          in out nocopy number
240   );
241 --
242 -- ----------------------------------------------------------------------------
243 -- |----------------------------------< lck >---------------------------------|
244 -- ----------------------------------------------------------------------------
245 -- {Start Of Comments}
246 --
247 -- Description:
248 --
249 -- Prerequisites:
250 --
251 --
252 -- In Parameters:
253 --   Name                           Reqd Type     Description
254 --   p_benfts_grp_id                 Yes  number   PK of record
255 --   p_object_version_number        Yes  number   OVN of record
256 --
257 -- Post Success:
258 --
259 --   Name                           Type     Description
260 --
261 -- Post Failure:
262 --
263 -- Access Status:
264 --   Public.
265 --
266 -- {End Of Comments}
267 --
268 procedure lck
269   (
270     p_benfts_grp_id                 in number
271    ,p_object_version_number        in number
272   );
273 --
274 end ben_Benefits_Group_api;