1 PACKAGE ben_on_line_lf_evt AS
2 /* $Header: benollet.pkh 120.1 2005/09/28 03:15:32 ssarkar noship $ */
3 --
4 -- Global set bet by evaluate potentials module if
5 -- any potentials are set to VOID.
6 --
7 g_ptnls_voidd_flag boolean := FALSE;
8 --
9 procedure Start_on_line_lf_evt_proc(p_person_id in number,
10 p_effective_date in date,
11 p_business_group_id in number,
12 p_error_msg in varchar2 ,
13 p_userkey in varchar2,
14 p_itemkey out nocopy varchar2
15 );
16 --
17 procedure End_on_line_lf_evt_proc(itemtype in varchar2,
18 itemkey in varchar2,
19 actid in number,
20 funcmode in varchar2,
21 result in out nocopy varchar2 ) ;
22 --
23 -- Determine which process to run if a item_type have multiple
24 -- runnable processes.
25 -- itemtype : a valid item type
26 -- itemkey : A string generated from application object's PK.
27 -- actid : The function activity ( instance id )
28 -- funcmode : Run/Cancel
29 -- resultout : Name of the workflow process to run.
30 --
31 procedure Selector(itemtype in varchar2,
32 itemkey in varchar2,
33 actid in number,
34 funcmode in varchar2,
35 resultout out nocopy varchar2);
36 --
37 --
38 -- Determine number of records for the person in life event reasons
39 -- potential life event reasons.
40 -- itemtype : a valid item type
41 -- itemkey : A string generated from application object's PK.
42 -- actid : The function activity ( instance id )
43 -- funcmode : Run/Cancel
44 -- resultout : Name of the workflow process to run.
45 --
46 procedure p_cnt_ple(itemtype in varchar2,
47 itemkey in varchar2,
48 actid in number,
49 funcmode in varchar2,
50 resultout out nocopy varchar2);
51 --
52 -- Test whether it's possible to run the form from
53 -- function avtivity.
54 -- itemtype : a valid item type
55 -- itemkey : A string generated from application object's PK.
56 -- actid : The function activity ( instance id )
57 -- funcmode : Run/Cancel
58 -- resultout : Name of the workflow process to run.
59 --
60 procedure p_run_form(itemtype in varchar2,
61 itemkey in varchar2,
62 actid in number,
63 funcmode in varchar2,
64 resultout out nocopy varchar2);
65 --
66 procedure p_evt_lf_events(itemtype in varchar2,
67 itemkey in varchar2,
68 actid in number,
69 funcmode in varchar2,
70 resultout out nocopy varchar2);
71 --
72 procedure p_mng_lf_events(itemtype in varchar2,
73 itemkey in varchar2,
74 actid in number,
75 funcmode in varchar2,
76 resultout out nocopy varchar2);
77 --
78 procedure p_have_elctbl_chcs(itemtype in varchar2,
79 itemkey in varchar2,
80 actid in number,
81 funcmode in varchar2,
82 resultout out nocopy varchar2);
83 --
84 procedure p_can_prtcpnt_enrl(itemtype in varchar2,
85 itemkey in varchar2,
86 actid in number,
87 funcmode in varchar2,
88 resultout out nocopy varchar2);
89 --
90 --
91 -- procedure to evaluate the potential life events,
92 -- and life events
93 --
94 procedure p_manage_life_events(
95 p_person_id in number
96 ,p_effective_date in date
97 ,p_business_group_id in number
98 ,p_prog_count out nocopy number
99 ,p_plan_count out nocopy number
100 ,p_oipl_count out nocopy number
101 ,p_person_count out nocopy number
102 ,p_plan_nip_count out nocopy number
103 ,p_oipl_nip_count out nocopy number
104 ,p_ler_id out nocopy number
105 ,p_errbuf out nocopy varchar2
106 ,p_retcode out nocopy number);
107 --
108 --
109 --
110 -- procedure to evaluate the potential life events,
111 -- and life events
112 --
113 procedure p_manage_life_events(
114 p_person_id in number
115 ,p_effective_date in date
116 ,p_business_group_id in number
117 ,p_pgm_id in number default null
118 ,p_pl_id in number default null
119 ,p_mode in varchar2
120 ,p_lf_evt_ocrd_dt in date default null --GLOBAL CWB
121 ,p_prog_count out nocopy number
122 ,p_plan_count out nocopy number
123 ,p_oipl_count out nocopy number
124 ,p_person_count out nocopy number
125 ,p_plan_nip_count out nocopy number
126 ,p_oipl_nip_count out nocopy number
127 ,p_ler_id out nocopy number
128 ,p_errbuf out nocopy varchar2
129 ,p_retcode out nocopy number);
130 --
131 --
132 -- procedure to evaluate the potential life events,
133 -- and life events from benwatif as it passes the
134 -- derivable factors flag. In future it may be possible to
135 -- bypass the some of the benwatif steps
136 --
137 procedure p_watif_manage_life_events(
138 p_person_id in number
139 ,p_effective_date in date
140 ,p_business_group_id in number
141 ,p_pgm_id in number default null
142 ,p_pl_id in number default null
143 ,p_mode in varchar2
144 ,p_derivable_factors in varchar2
145 ,p_prog_count out nocopy number
146 ,p_plan_count out nocopy number
147 ,p_oipl_count out nocopy number
148 ,p_person_count out nocopy number
149 ,p_plan_nip_count out nocopy number
150 ,p_oipl_nip_count out nocopy number
151 ,p_ler_id out nocopy number
152 ,p_errbuf out nocopy varchar2
153 ,p_retcode out nocopy number);
154 --
155 -- procedure to check whether the context is already established.
156 -- if established then authentication form is bypassed.
157 --
158 procedure p_context_def(
159 itemtype in varchar2
160 ,itemkey in varchar2
161 ,actid in number
162 ,funcmode in varchar2
163 ,resultout out nocopy varchar2);
164 --
165 procedure p_commit;
166 --
167 --
168 -- This procedure to evaluate the potential life events,
169 -- and life events called from benauthe form as a CSR
170 -- desktop activity.
171 --
172 procedure p_evt_lf_evts_from_benauthe(
173 p_person_id in number
174 ,p_effective_date in date
175 ,p_business_group_id in number
176 ,p_pgm_id in number default null
177 ,p_pl_id in number default null
178 ,p_mode in varchar2
179 ,p_popl_enrt_typ_cycl_id in number
180 ,p_lf_evt_ocrd_dt in date
181 ,p_prog_count out nocopy number
182 ,p_plan_count out nocopy number
183 ,p_oipl_count out nocopy number
184 ,p_person_count out nocopy number
185 ,p_plan_nip_count out nocopy number
186 ,p_oipl_nip_count out nocopy number
187 ,p_ler_id out nocopy number
188 ,p_errbuf out nocopy varchar2
189 ,p_retcode out nocopy number);
190 --
191 -- This procedure to process life events called from benauthe form
192 -- as a CSR desktop activity.
193 --
194 procedure p_proc_lf_evts_from_benauthe(
195 p_person_id in number
196 ,p_effective_date in date
197 ,p_business_group_id in number
198 ,p_mode in varchar2
199 ,p_ler_id in number
200 -- PB : 5422 :
201 -- ,p_popl_enrt_typ_cycl_id in number
202 ,p_lf_evt_ocrd_dt in date default null
203 ,p_person_count out nocopy number
204 ,p_benefit_action_id out nocopy number
205 ,p_errbuf out nocopy varchar2
206 ,p_retcode out nocopy number);
207 --
208 procedure p_oll_pop_up_message
209 (p_person_id in number
210 ,p_business_group_id in number
211 ,p_function_name in varchar2
212 ,p_block_name in varchar2
213 ,p_field_name in varchar2
214 ,p_event_name in varchar2
215 ,p_effective_date in date
216 ,p_payroll_id in number default null
217 ,p_payroll_action_id in number default null
218 ,p_assignment_id in number default null
219 ,p_assignment_action_id in number default null
220 ,p_org_pay_method_id in number default null
221 ,p_per_pay_method_id in number default null
222 ,p_organization_id in number default null
223 ,p_tax_unit_id in number default null
224 ,p_jurisdiction_code in number default null
225 ,p_balance_date in number default null
226 ,p_element_entry_id in number default null
227 ,p_element_type_id in number default null
228 ,p_original_entry_id in number default null
229 ,p_tax_group in number default null
230 ,p_pgm_id in number default null
231 ,p_pl_id in number default null
232 ,p_pl_typ_id in number default null
233 ,p_opt_id in number default null
234 ,p_ler_id in number default null
235 ,p_communication_type_id in number default null
236 ,p_action_type_id in number default null
237 ,p_message_count out nocopy number
238 ,p_message1 out nocopy varchar2
239 ,p_message_type1 out nocopy varchar2
240 ,p_message2 out nocopy varchar2
241 ,p_message_type2 out nocopy varchar2
242 ,p_message3 out nocopy varchar2
243 ,p_message_type3 out nocopy varchar2
244 ,p_message4 out nocopy varchar2
245 ,p_message_type4 out nocopy varchar2
246 ,p_message5 out nocopy varchar2
247 ,p_message_type5 out nocopy varchar2
248 ,p_message6 out nocopy varchar2
249 ,p_message_type6 out nocopy varchar2
250 ,p_message7 out nocopy varchar2
251 ,p_message_type7 out nocopy varchar2
252 ,p_message8 out nocopy varchar2
253 ,p_message_type8 out nocopy varchar2
254 ,p_message9 out nocopy varchar2
255 ,p_message_type9 out nocopy varchar2
256 ,p_message10 out nocopy varchar2
257 ,p_message_type10 out nocopy varchar2
258 );
259 -- 99999 any other parameters like : pl_id ler_id etc., to
260 -- be used as parameters.
261 --
262 function f_ret_ptnls_voidd_flag return boolean;
263 --
264 -- Bug : 4504/1217193 This procedure is called from the form
265 -- BENWFREP to see whether any electable choices are created by this
266 -- run of benmngle. If not created then return a message.
267 --
268 function f_ret_elec_chc_created return boolean;
269 --
270 procedure get_ser_message(p_encoded_message out nocopy varchar2,
271 p_app_short_name out nocopy varchar2,
272 p_message_name out nocopy varchar2);
273
274 --
275 -- self-service wrapper to run benmngle in
276 -- unrestricted mode.
277 --
278 procedure p_manage_life_events_w(
279 p_person_id in number
280 ,p_effective_date in date
281 ,p_lf_evt_ocrd_dt in date default null
282 ,p_business_group_id in number
283 ,p_mode in varchar2
284 ,p_ss_process_unrestricted in varchar2 default 'Y'
285 ,p_return_status out nocopy varchar2); --4254792
286 --
287 -- iRec : self-service wrapper to run benmngle through
288 -- iRecruitment
289 --
290 procedure p_manage_irec_life_events_w(
291 p_person_id in number
292 ,p_assignment_id in number
293 ,p_effective_date in date
294 ,p_business_group_id in number
295 ,p_offer_assignment_rec in per_all_assignments_f%rowtype); --bug 4621751 irec2
296 --
297
298 end ben_on_line_lf_evt;