1 package ben_generate_communications AUTHID CURRENT_USER as
2 /* $Header: bencommu.pkh 120.0.12000000.1 2007/01/19 15:14:09 appldev noship $ */
3 --
4 g_commu_rec ben_type.g_batch_commu_rec;
5 g_comm_generated boolean;
6 --
7 g_comm_start_date date;
8 g_to_be_sent_dt date;
9 --
10 procedure main
11 (p_person_id in number,
12 p_cm_trgr_typ_cd in varchar2 default null,
13 p_cm_typ_id in number default null,
14 p_ler_id in number default null,
15 p_per_in_ler_id in number default null,
16 p_prtt_enrt_actn_id in number default null,
17 p_bnf_person_id in number default null,
18 p_dpnt_person_id in number default null,
19 -- PB : 5422 :
20 -- p_enrt_perd_id in number default null,
21 p_asnd_lf_evt_dt in date default null,
22 p_actn_typ_id in number default null,
23 p_enrt_mthd_cd in varchar2 default null,
24 p_pgm_id in number default null,
25 p_pl_id in number default null,
26 p_pl_typ_id in number default null,
27 p_rqstbl_untl_dt in date default null,
28 p_business_group_id in number,
29 p_proc_cd1 in varchar2 default null,
30 p_proc_cd2 in varchar2 default null,
31 p_proc_cd3 in varchar2 default null,
32 p_proc_cd4 in varchar2 default null,
33 p_proc_cd5 in varchar2 default null,
34 p_proc_cd6 in varchar2 default null,
35 p_proc_cd7 in varchar2 default null,
36 p_proc_cd8 in varchar2 default null,
37 p_proc_cd9 in varchar2 default null,
38 p_proc_cd10 in varchar2 default null,
39 p_effective_date in date,
40 p_lf_evt_ocrd_dt in date default null,
41 p_mode in varchar2 default 'I',
42 p_source in varchar2 default null);
43 --
44 procedure populate_working_tables
45 (p_person_id in number,
46 p_cm_typ_id in number,
47 p_business_group_id in number,
48 p_effective_date in date,
49 p_cm_trgr_id in number,
50 p_inspn_rqd_flag in varchar2,
51 p_cm_dlvry_med_cd in varchar2,
52 p_cm_dlvry_mthd_cd in varchar2,
53 p_per_cm_id in number,
54 p_mode in varchar2 default 'I');
55 --
56 procedure pop_ben_per_cm_usg_f
57 (p_per_cm_id in number,
58 p_cm_typ_usg_id in number,
59 p_business_group_id in number,
60 p_effective_date in date,
61 p_per_cm_usg_id out nocopy number,
62 p_usage_created out nocopy boolean);
63 --
64 procedure pop_ben_per_cm_f
65 (p_person_id in number,
66 p_ler_id in number,
67 p_per_in_ler_id in number,
68 p_prtt_enrt_actn_id in number,
69 p_bnf_person_id in number,
70 p_dpnt_person_id in number,
71 p_cm_typ_id in number,
72 p_lf_evt_ocrd_dt in date,
73 p_rqstbl_untl_dt in date,
74 p_business_group_id in number,
75 p_effective_date in date,
76 p_date_cd in varchar2,
77 p_formula_id in number,
78 p_pgm_id in number,
79 p_pl_id in number,
80 p_per_cm_id out nocopy number);
81 --
82 function get_cvg_strt_dt (p_elig_per_id number,
83 p_per_in_ler_id number)
84 return date;
85
86 pragma restrict_references(get_cvg_strt_dt,WNDS,WNPS);
87
88 end ben_generate_communications;
89 --
[Home] [Help]