DBA Data[Home] [Help]

PACKAGE: APPS.BEN_PRTN_ELIG_PRFL_API

Source


1 Package ben_PRTN_ELIG_PRFL_api as
2 /* $Header: becepapi.pkh 120.0 2005/05/28 00:59:50 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_PRTN_ELIG_PRFL >------------------------|
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_mndtry_flag                  Yes  varchar2
19 --   p_prtn_elig_id                 Yes  number
20 --   p_eligy_prfl_id                Yes  number
21 --   p_Elig_prfl_type_cd            Yes  varchar2
22 --   p_cep_attribute_category       No   varchar2  Descriptive Flexfield
23 --   p_cep_attribute1               No   varchar2  Descriptive Flexfield
24 --   p_cep_attribute2               No   varchar2  Descriptive Flexfield
25 --   p_cep_attribute3               No   varchar2  Descriptive Flexfield
26 --   p_cep_attribute4               No   varchar2  Descriptive Flexfield
27 --   p_cep_attribute5               No   varchar2  Descriptive Flexfield
28 --   p_cep_attribute6               No   varchar2  Descriptive Flexfield
29 --   p_cep_attribute7               No   varchar2  Descriptive Flexfield
30 --   p_cep_attribute8               No   varchar2  Descriptive Flexfield
31 --   p_cep_attribute9               No   varchar2  Descriptive Flexfield
32 --   p_cep_attribute10              No   varchar2  Descriptive Flexfield
33 --   p_cep_attribute11              No   varchar2  Descriptive Flexfield
34 --   p_cep_attribute12              No   varchar2  Descriptive Flexfield
35 --   p_cep_attribute13              No   varchar2  Descriptive Flexfield
36 --   p_cep_attribute14              No   varchar2  Descriptive Flexfield
37 --   p_cep_attribute15              No   varchar2  Descriptive Flexfield
38 --   p_cep_attribute16              No   varchar2  Descriptive Flexfield
39 --   p_cep_attribute17              No   varchar2  Descriptive Flexfield
40 --   p_cep_attribute18              No   varchar2  Descriptive Flexfield
41 --   p_cep_attribute19              No   varchar2  Descriptive Flexfield
42 --   p_cep_attribute20              No   varchar2  Descriptive Flexfield
43 --   p_cep_attribute21              No   varchar2  Descriptive Flexfield
44 --   p_cep_attribute22              No   varchar2  Descriptive Flexfield
45 --   p_cep_attribute23              No   varchar2  Descriptive Flexfield
46 --   p_cep_attribute24              No   varchar2  Descriptive Flexfield
47 --   p_cep_attribute25              No   varchar2  Descriptive Flexfield
48 --   p_cep_attribute26              No   varchar2  Descriptive Flexfield
49 --   p_cep_attribute27              No   varchar2  Descriptive Flexfield
50 --   p_cep_attribute28              No   varchar2  Descriptive Flexfield
51 --   p_cep_attribute29              No   varchar2  Descriptive Flexfield
52 --   p_cep_attribute30              No   varchar2  Descriptive Flexfield
53 --   p_effective_date                Yes  date      Session Date.
54 --
55 -- Post Success:
56 --
57 -- Out Parameters:
58 --   Name                                Type     Description
59 --   p_prtn_elig_prfl_id            Yes  number    PK of record
60 --   p_effective_start_date         Yes  date      Effective Start Date of Record
61 --   p_effective_end_date           Yes  date      Effective End Date 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_PRTN_ELIG_PRFL
72 (
73    p_validate                       in boolean    default false
74   ,p_prtn_elig_prfl_id              out nocopy number
75   ,p_effective_start_date           out nocopy date
76   ,p_effective_end_date             out nocopy date
77   ,p_business_group_id              in  number    default null
78   ,p_mndtry_flag                    in  varchar2  default null
79   ,p_prtn_elig_id                   in  number    default null
80   ,p_eligy_prfl_id                  in  number    default null
81   ,p_Elig_prfl_type_cd              in  varchar2  default null
82   ,p_cep_attribute_category         in  varchar2  default null
83   ,p_cep_attribute1                 in  varchar2  default null
84   ,p_cep_attribute2                 in  varchar2  default null
85   ,p_cep_attribute3                 in  varchar2  default null
86   ,p_cep_attribute4                 in  varchar2  default null
87   ,p_cep_attribute5                 in  varchar2  default null
88   ,p_cep_attribute6                 in  varchar2  default null
89   ,p_cep_attribute7                 in  varchar2  default null
90   ,p_cep_attribute8                 in  varchar2  default null
91   ,p_cep_attribute9                 in  varchar2  default null
92   ,p_cep_attribute10                in  varchar2  default null
93   ,p_cep_attribute11                in  varchar2  default null
94   ,p_cep_attribute12                in  varchar2  default null
95   ,p_cep_attribute13                in  varchar2  default null
96   ,p_cep_attribute14                in  varchar2  default null
97   ,p_cep_attribute15                in  varchar2  default null
98   ,p_cep_attribute16                in  varchar2  default null
99   ,p_cep_attribute17                in  varchar2  default null
100   ,p_cep_attribute18                in  varchar2  default null
101   ,p_cep_attribute19                in  varchar2  default null
102   ,p_cep_attribute20                in  varchar2  default null
103   ,p_cep_attribute21                in  varchar2  default null
104   ,p_cep_attribute22                in  varchar2  default null
105   ,p_cep_attribute23                in  varchar2  default null
106   ,p_cep_attribute24                in  varchar2  default null
107   ,p_cep_attribute25                in  varchar2  default null
108   ,p_cep_attribute26                in  varchar2  default null
109   ,p_cep_attribute27                in  varchar2  default null
110   ,p_cep_attribute28                in  varchar2  default null
111   ,p_cep_attribute29                in  varchar2  default null
112   ,p_cep_attribute30                in  varchar2  default null
113   ,p_pgm_id                         in  number    default null
114   ,p_pl_id                          in  number    default null
115   ,p_ptip_id                        in  number    default null
116   ,p_plip_id                        in  number    default null
117   ,p_oipl_id                        in  number    default null
118   ,p_object_version_number          out nocopy number
119   ,p_effective_date                 in  date
120   ,p_compute_score_flag             in varchar2   default null
121  );
122 -- ----------------------------------------------------------------------------
123 -- |------------------------< update_PRTN_ELIG_PRFL >------------------------|
124 -- ----------------------------------------------------------------------------
125 -- {Start Of Comments}
126 --
127 -- Description:
128 --
129 -- Prerequisites:
130 --
131 --
132 -- In Parameters:
133 --   Name                           Reqd Type     Description
134 --   p_validate                     Yes  boolean  Commit or Rollback.
135 --   p_prtn_elig_prfl_id            Yes  number    PK of record
136 --   p_business_group_id            Yes  number    Business Group of Record
137 --   p_mndtry_flag                  Yes  varchar2
138 --   p_prtn_elig_id                 Yes  number
139 --   p_eligy_prfl_id                Yes  number
140 --   p_Elig_prfl_type_cd            Yes  varchar2
141 --   p_cep_attribute_category       No   varchar2  Descriptive Flexfield
142 --   p_cep_attribute1               No   varchar2  Descriptive Flexfield
143 --   p_cep_attribute2               No   varchar2  Descriptive Flexfield
144 --   p_cep_attribute3               No   varchar2  Descriptive Flexfield
145 --   p_cep_attribute4               No   varchar2  Descriptive Flexfield
146 --   p_cep_attribute5               No   varchar2  Descriptive Flexfield
147 --   p_cep_attribute6               No   varchar2  Descriptive Flexfield
148 --   p_cep_attribute7               No   varchar2  Descriptive Flexfield
149 --   p_cep_attribute8               No   varchar2  Descriptive Flexfield
150 --   p_cep_attribute9               No   varchar2  Descriptive Flexfield
151 --   p_cep_attribute10              No   varchar2  Descriptive Flexfield
152 --   p_cep_attribute11              No   varchar2  Descriptive Flexfield
153 --   p_cep_attribute12              No   varchar2  Descriptive Flexfield
154 --   p_cep_attribute13              No   varchar2  Descriptive Flexfield
155 --   p_cep_attribute14              No   varchar2  Descriptive Flexfield
156 --   p_cep_attribute15              No   varchar2  Descriptive Flexfield
157 --   p_cep_attribute16              No   varchar2  Descriptive Flexfield
158 --   p_cep_attribute17              No   varchar2  Descriptive Flexfield
159 --   p_cep_attribute18              No   varchar2  Descriptive Flexfield
160 --   p_cep_attribute19              No   varchar2  Descriptive Flexfield
161 --   p_cep_attribute20              No   varchar2  Descriptive Flexfield
162 --   p_cep_attribute21              No   varchar2  Descriptive Flexfield
163 --   p_cep_attribute22              No   varchar2  Descriptive Flexfield
164 --   p_cep_attribute23              No   varchar2  Descriptive Flexfield
165 --   p_cep_attribute24              No   varchar2  Descriptive Flexfield
166 --   p_cep_attribute25              No   varchar2  Descriptive Flexfield
167 --   p_cep_attribute26              No   varchar2  Descriptive Flexfield
168 --   p_cep_attribute27              No   varchar2  Descriptive Flexfield
169 --   p_cep_attribute28              No   varchar2  Descriptive Flexfield
170 --   p_cep_attribute29              No   varchar2  Descriptive Flexfield
171 --   p_cep_attribute30              No   varchar2  Descriptive Flexfield
172 --   p_effective_date               Yes  date       Session Date.
173 --   p_datetrack_mode               Yes  varchar2   Datetrack mode.
174 --
175 -- Post Success:
176 --
177 --   Name                           Type     Description
178 --   p_effective_start_date         Yes  date      Effective Start Date of Record
179 --   p_effective_end_date           Yes  date      Effective End Date of Record
180 --   p_object_version_number        No   number    OVN of record
181 --
182 -- Post Failure:
183 --
184 -- Access Status:
185 --   Public.
186 --
187 -- {End Of Comments}
188 --
189 procedure update_PRTN_ELIG_PRFL
190   (
191    p_validate                       in boolean    default false
192   ,p_prtn_elig_prfl_id              in  number
193   ,p_effective_start_date           out nocopy date
194   ,p_effective_end_date             out nocopy date
195   ,p_business_group_id              in  number    default hr_api.g_number
196   ,p_mndtry_flag                    in  varchar2  default hr_api.g_varchar2
197   ,p_prtn_elig_id                   in  number    default hr_api.g_number
198   ,p_eligy_prfl_id                  in  number    default hr_api.g_number
199   ,p_Elig_prfl_type_cd              in  varchar2  default hr_api.g_varchar2
200   ,p_cep_attribute_category         in  varchar2  default hr_api.g_varchar2
201   ,p_cep_attribute1                 in  varchar2  default hr_api.g_varchar2
202   ,p_cep_attribute2                 in  varchar2  default hr_api.g_varchar2
203   ,p_cep_attribute3                 in  varchar2  default hr_api.g_varchar2
204   ,p_cep_attribute4                 in  varchar2  default hr_api.g_varchar2
205   ,p_cep_attribute5                 in  varchar2  default hr_api.g_varchar2
206   ,p_cep_attribute6                 in  varchar2  default hr_api.g_varchar2
207   ,p_cep_attribute7                 in  varchar2  default hr_api.g_varchar2
208   ,p_cep_attribute8                 in  varchar2  default hr_api.g_varchar2
209   ,p_cep_attribute9                 in  varchar2  default hr_api.g_varchar2
210   ,p_cep_attribute10                in  varchar2  default hr_api.g_varchar2
211   ,p_cep_attribute11                in  varchar2  default hr_api.g_varchar2
212   ,p_cep_attribute12                in  varchar2  default hr_api.g_varchar2
213   ,p_cep_attribute13                in  varchar2  default hr_api.g_varchar2
214   ,p_cep_attribute14                in  varchar2  default hr_api.g_varchar2
215   ,p_cep_attribute15                in  varchar2  default hr_api.g_varchar2
216   ,p_cep_attribute16                in  varchar2  default hr_api.g_varchar2
217   ,p_cep_attribute17                in  varchar2  default hr_api.g_varchar2
218   ,p_cep_attribute18                in  varchar2  default hr_api.g_varchar2
219   ,p_cep_attribute19                in  varchar2  default hr_api.g_varchar2
220   ,p_cep_attribute20                in  varchar2  default hr_api.g_varchar2
221   ,p_cep_attribute21                in  varchar2  default hr_api.g_varchar2
222   ,p_cep_attribute22                in  varchar2  default hr_api.g_varchar2
223   ,p_cep_attribute23                in  varchar2  default hr_api.g_varchar2
224   ,p_cep_attribute24                in  varchar2  default hr_api.g_varchar2
225   ,p_cep_attribute25                in  varchar2  default hr_api.g_varchar2
226   ,p_cep_attribute26                in  varchar2  default hr_api.g_varchar2
227   ,p_cep_attribute27                in  varchar2  default hr_api.g_varchar2
228   ,p_cep_attribute28                in  varchar2  default hr_api.g_varchar2
229   ,p_cep_attribute29                in  varchar2  default hr_api.g_varchar2
230   ,p_cep_attribute30                in  varchar2  default hr_api.g_varchar2
231   ,p_object_version_number          in out nocopy number
232   ,p_effective_date                 in  date
233   ,p_datetrack_mode                 in  varchar2
234   ,p_compute_score_flag             in  varchar2  default hr_api.g_varchar2
235   );
236 --
237 -- ----------------------------------------------------------------------------
238 -- |------------------------< delete_PRTN_ELIG_PRFL >------------------------|
239 -- ----------------------------------------------------------------------------
240 -- {Start Of Comments}
241 --
242 -- Description:
243 --
244 -- Prerequisites:
245 --
246 --
247 -- In Parameters:
248 --   Name                           Reqd Type     Description
249 --   p_validate                     Yes  boolean  Commit or Rollback.
250 --   p_prtn_elig_prfl_id            Yes  number    PK of record
251 --   p_effective_date               Yes  date     Session Date.
252 --   p_datetrack_mode               Yes  varchar2 Datetrack mode.
253 --
254 -- Post Success:
255 --
256 --   Name                           Type     Description
257 --   p_effective_start_date         Yes  date      Effective Start Date of Record
258 --   p_effective_end_date           Yes  date      Effective End Date of Record
259 --   p_object_version_number        No   number    OVN of record
260 --
261 -- Post Failure:
262 --
263 -- Access Status:
264 --   Public.
265 --
266 -- {End Of Comments}
267 --
268 procedure delete_PRTN_ELIG_PRFL
269   (
270    p_validate                       in boolean        default false
271   ,p_prtn_elig_prfl_id              in  number
272   ,p_effective_start_date           out nocopy date
273   ,p_effective_end_date             out nocopy date
274   ,p_object_version_number          in out nocopy number
275   ,p_effective_date                 in date
276   ,p_datetrack_mode                 in varchar2
277   );
278 --
279 -- ----------------------------------------------------------------------------
280 -- |----------------------------------< lck >---------------------------------|
281 -- ----------------------------------------------------------------------------
282 -- {Start Of Comments}
283 --
284 -- Description:
285 --
286 -- Prerequisites:
287 --
288 --
289 -- In Parameters:
290 --   Name                           Reqd Type     Description
291 --   p_prtn_elig_prfl_id                 Yes  number   PK of record
292 --   p_object_version_number        Yes  number   OVN of record
293 --   p_effective_date               Yes  date     Session Date.
294 --   p_datetrack_mode               Yes  varchar2 Datetrack mode.
295 --
296 -- Post Success:
297 --
298 --   Name                           Type     Description
299 --   p_validation_start_date        Yes      Derived Effective Start Date.
300 --   p_validation_end_date          Yes      Derived Effective End Date.
301 --
302 -- Post Failure:
303 --
304 -- Access Status:
305 --   Public.
306 --
307 -- {End Of Comments}
308 --
309 procedure lck
310   (
311     p_prtn_elig_prfl_id                 in number
312    ,p_object_version_number        in number
313    ,p_effective_date              in date
314    ,p_datetrack_mode              in varchar2
315    ,p_validation_start_date        out nocopy date
316    ,p_validation_end_date          out nocopy date
317   );
318 --
319 procedure insert_prtn_elig
320   (
321     p_pgm_id                in number  default null
322    ,p_pl_id                 in number  default null
323    ,p_plip_id               in number  default null
324    ,p_oipl_id               in number  default null
325    ,p_ptip_id               in number  default null
326    ,p_effective_date        in date
327    ,p_business_group_id     in number  default null
328    ,p_prtn_elig_id          out nocopy number
329   );
330 end ben_PRTN_ELIG_PRFL_api;