1 Package ben_plan_design_program_module AUTHID CURRENT_USER as
2 /* $Header: bepdcpgm.pkh 120.1.12000000.1 2007/01/19 20:49:52 appldev noship $ */
3 --
4
5 g_pdw_allow_dup_rslt varchar2(30);
6 g_pdw_no_dup_rslt varchar2(30) := 'PDW_NO_DUP_RSLT';
7
8 --
9 CURSOR g_table_route(c_parent_table_alias varchar2) is
10 SELECT table_route_id
11 FROM pqh_table_route trt
12 WHERE trt.table_alias = c_parent_table_alias;
13 --
14
15 procedure create_program_result
16 (
17 p_validate in number default 0 -- false
18 ,p_copy_entity_result_id out nocopy number
19 ,p_copy_entity_txn_id in number
20 ,p_pgm_id in number
21 ,p_business_group_id in number default null
22 ,p_number_of_copies in number default 0
23 ,p_object_version_number out nocopy number
24 ,p_effective_date in date
25 ,p_no_dup_rslt in varchar2 default null
26 ) ;
27 --
28 procedure create_formula_result
29 (
30 p_validate in number default 0 -- false
31 ,p_copy_entity_result_id in number
32 ,p_copy_entity_txn_id in number
33 ,p_formula_id in number
34 ,p_business_group_id in number default null
35 ,p_copy_to_clob in varchar2 default 'N'
36 ,p_number_of_copies in number default 0
37 ,p_object_version_number out nocopy number
38 ,p_effective_date in date
39 ) ;
40 --
41 procedure create_actn_typ_result
42 (
43 p_validate in number default 0 -- false
44 ,p_copy_entity_txn_id in number
45 ,p_business_group_id in number default null
46 ,p_number_of_copies in number default 0
47 ,p_effective_date in date
48 );
49 --
50 function get_ler_name
51 (
52 p_ler_id in number
53 ,p_effective_date in date
54 ) return varchar2;
55 --
56
57 function get_pgm_name
58 (
59 p_pgm_id in number
60 ,p_effective_date in date
61 ) return varchar2;
62 --
63
64 function get_pl_typ_name
65 (
66 p_pl_typ_id in number
67 ,p_effective_date in date
68 ) return varchar2;
69 --
70
71 function get_pl_name
72 (
73 p_pl_id in number
74 ,p_effective_date in date
75 ) return varchar2;
76 --
77
78 function get_ptip_name
79 (
80 p_ptip_id in number
81 ,p_effective_date in date
82 ) return varchar2;
83 --
84
85 function get_plip_name
86 (
87 p_plip_id in number
88 ,p_effective_date in date
89 ) return varchar2;
90 --
91
92 function get_oipl_name
93 (
94 p_oipl_id in number
95 ,p_effective_date in date
96 ) return varchar2;
97 --
98
99 function get_opt_name
100 (
101 p_opt_id in number
102 ,p_effective_date in date
103 ) return varchar2;
104 --
105
106 function get_regn_name
107 (
108 p_regn_id in number
109 ,p_effective_date in date
110 ) return varchar2;
111 --
112
113 function get_gd_or_svc_typ_name
114 (
115 p_gd_or_svc_typ_id in number
116 ) return varchar2;
117 --
118
119 function get_actn_typ_name
120 (
121 p_actn_typ_id in number
122 ) return varchar2;
123 --
124
125 function get_formula_name
126 (
127 p_formula_id in number
128 ,p_effective_date in date
129 ) return varchar2;
130 --
131
132 function get_organization_name
133 (
134 p_organization_id in number
135 ) return varchar2;
136 --
137
138 function get_yr_perd_name
139 (
140 p_yr_perd_id in number
141 ) return varchar2;
142 --
143
144 function get_rptg_grp_name
145 (
146 p_rptg_grp_id in number
147 ) return varchar2;
148 --
149
150 function get_per_info_chg_cs_ler_name
151 (
152 p_per_info_chg_cs_ler_id in number
153 ,p_effective_date in date
154 ) return varchar2;
155 --
156
157 function get_rltd_per_chg_cs_ler_name
158 (
159 p_rltd_per_chg_cs_ler_id in number
160 ,p_effective_date in date
161 ) return varchar2;
162 --
163
164 function get_oiplip_name
165 (
166 p_oipl_id in number
167 ,p_plip_id in number
168 ,p_effective_date in date
169 ) return varchar2;
170 --
171
172 function get_optip_name
173 (
174 p_opt_id in number
175 ,p_pl_typ_id in number
176 ,p_effective_date in date
177 ) return varchar2;
178 --
179
180 function get_ptd_lmt_name
181 (
182 p_ptd_lmt_id in number
183 ,p_effective_date in date
184 ) return varchar2;
185 --
186
187 function get_vrbl_rt_prfl_name
188 (
189 p_vrbl_rt_prfl_id in number
190 ,p_effective_date in date
191 ) return varchar2;
192 --
193
194 function get_age_fctr_name
195 (
196 p_age_fctr_id in number
197 ) return varchar2;
198 --
199
200 function get_assignment_set_name
201 (
202 p_assignment_set_id in number
203 ) return varchar2;
204 --
205
206 function get_benfts_grp_name
207 (
208 p_benfts_grp_id in number
209 ) return varchar2;
210 --
211
212 function get_cmbn_age_los_fctr_name
213 (
214 p_cmbn_age_los_fctr_id in number
215 ) return varchar2;
216 --
217
218 function get_comp_lvl_fctr_name
219 (
220 p_comp_lvl_fctr_id in number
221 ) return varchar2;
222 --
223
224 function get_assignment_sts_type_name
225 (
226 p_assignment_status_type_id in number
227 ) return varchar2;
228 --
229
230 function get_grade_name
231 (
232 p_grade_id in number
233 ) return varchar2;
234 --
235
236 function get_hrs_wkd_in_perd_fctr_name
237 (
238 p_hrs_wkd_in_perd_fctr_id in number
239 ) return varchar2;
240 --
241
242 function get_lbr_mmbr_name
243 (
244 p_lbr_mmbr_flag in varchar2
245 ) return varchar2;
246 --
247
248 function get_absence_type_name
249 (
250 p_absence_attendance_type_id in number
251 ) return varchar2;
252 --
253
254 function get_los_fctr_name
255 (
256 p_los_fctr_id in number
257 ) return varchar2;
258 --
259
260 function get_pct_fl_tm_fctr_name
261 (
262 p_pct_fl_tm_fctr_id in number
263 ) return varchar2;
264 --
265
266 function get_person_type_name
267 (
268 p_person_type_id in number
269 ) return varchar2;
270 --
271
272 function get_people_group_name
273 (
274 p_people_group_id in number
275 ) return varchar2;
276 --
277
278 function get_pstl_zip_rng_name
279 (
280 p_pstl_zip_rng_id in number
281 ,p_effective_date in date
282 ) return varchar2;
283 --
284
285 function get_payroll_name
286 (
287 p_payroll_id in number
288 ,p_effective_date in date
289 ) return varchar2;
290 --
291
292 function get_pay_basis_name
293 (
294 p_pay_basis_id in number
295 ) return varchar2;
296 --
297
298 function get_svc_area_name
299 (
300 p_svc_area_id in number
301 ,p_effective_date in date
302 ) return varchar2;
303 --
304
305 function get_location_name
306 (
307 p_location_id in number
308 ) return varchar2;
309 --
310
311 function get_acty_base_rt_name
312 (
313 p_acty_base_rt_id in number
314 ,p_effective_date in date
315 ) return varchar2;
316 --
317
318 function get_eligy_prfl_name
319 (
320 p_eligy_prfl_id in number
321 ,p_effective_date in date
322 ) return varchar2;
323 --
324
325 function get_cbr_quald_bnf_name
326 (
327 p_ptip_id in number
328 ,p_pgm_id in number
329 ,p_effective_date in date
330 ) return varchar2;
331 --
332
333 function get_job_name
334 (
335 p_job_id in number
336 ) return varchar2;
337 --
338
339 function get_sp_clng_step_name
340 (
341 p_special_ceiling_step_id in number
342 ,p_effective_date in date
343 ) return varchar2;
344 --
345
346 function get_position_name
347 (
348 p_position_id in number
349 ) return varchar2;
350 --
351
352 function get_qual_type_name
353 (
354 p_qualification_type_id in number
355 ) return varchar2;
356 --
357
358 function get_dpnt_cvg_eligy_prfl_name
359 (
360 p_dpnt_cvg_eligy_prfl_id in number
361 ,p_effective_date in date
362 ) return varchar2 ;
363 --
364
365 function get_competence_rating_name
366 (
367 p_competence_id in number
368 ,p_rating_level_id in number
369 ) return varchar2;
370 --
371
372 function get_hlth_cvg_name
373 (
374 p_pl_typ_opt_typ_id in number
375 ,p_oipl_id in number
376 ,p_effective_date in date
377 ) return varchar2;
378 --
379 function get_eligy_criteria_name
380 (
381 p_eligy_criteria_id in number
382 ) return varchar2;
383 --
384
385 function get_exclude_message
386 (
387 p_excld_flag in varchar2
388 ) return varchar2;
389 --
390
391 end ben_plan_design_program_module;