1 Package BEN_DETERMINE_CHC_CTFN as
2 /* $Header: benchctf.pkh 120.1 2005/09/13 10:39:48 ikasire noship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1997 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10 Name:
11 Determine choice certifications.
12 Purpose:
13 This process determines what certifications are necessary for an election and
14 then writes them to elctbl_chc_ctfn.
15 History:
16 Date Who Version What?
17 ---- --- ------- -----
18 10 Feb 99 T Guy 115.0 Created.
19 26 Feb 99 T Guy 115.1 Removed control m's
20 13 Apr 99 T Guy 115.2 Added object_version_number
21 to get_ecf_ctfns and write_ctfns
22 28 Apr 99 Shdas 115.3 Added organization_id to parameter
23 04 May 99 Shdas 115.4 Added jurisdiction code
24 14 May 99 T Guy 115.5 is to as
25 02 Nov 99 maagrawa 115.6 Added new procedure write_ctfn.
26 Removed local procedures.
27 05 Jun 00 stee 115.7 add p_elig_per_elctbl_chc_id
28 to main.
29 20 Aug 04 kmahendr 115.9 Enh 3747490 : Optional certificaction
30 added parms to write_ctfn
31 15 Nov 04 kmahendr 115.10 Added parameter p_mode
32 12 Sep 05 ikasire 115.11 Added new procedure update_susp_if_ctfn_flag
33 */
34 -----------------------------------------------------------------------------------
35 procedure main(p_effective_date IN date,
36 p_person_id IN number,
37 p_elig_per_elctbl_chc_id IN number,
38 p_mode in varchar2 default null
39 );
40 --
41 procedure write_ctfn(p_elig_per_elctbl_chc_id in number,
42 p_enrt_bnft_id in number default null,
43 p_enrt_ctfn_typ_cd in varchar2,
44 p_rqd_flag in varchar2,
45 p_ctfn_rqd_when_rl in number,
46 p_business_group_id in number,
47 p_effective_date in date,
48 p_assignment_id in number,
49 p_organization_id in number,
50 p_jurisdiction_code in varchar2,
51 p_pgm_id in number,
52 p_pl_id in number,
53 p_pl_typ_id in number,
54 p_opt_id in number,
55 p_ler_id in number,
56 p_susp_if_ctfn_not_prvd_flag in varchar2 default 'Y',
57 p_ctfn_determine_cd in varchar2 default null,
58 p_mode in varchar2 default null
59 );
60 --
61 procedure update_susp_if_ctfn_flag(
62 p_effective_date in date,
63 p_lf_evt_ocrd_dt in date,
64 p_person_id in number,
65 p_per_in_ler_id in number
66 );
67
68 --
69 end BEN_DETERMINE_CHC_CTFN;
70