1 package ben_conc_reports AUTHID CURRENT_USER as
2 /*$Header: becncrep.pkh 115.4 2003/01/20 09:28:15 vsethi noship $*/
3 --
4 /*
5 Name
6 Benefits Concurrent reports process
7 Purpose
8 This is a batch process that accepts parameters from conc request window
9 and submits reports.
10 History
11 Version Date Author Comment
12 -------+----------+----------+------------------------------------------------
13 115.0 28-SEP-02 nhunur Created
14 115.3 30-Dec-2002 mmudigon NOCOPY
15 115.4 20-Jan-02 vsethi Made procedure rep_person_selection_rule as public
16 ------------------------------------------------------------------------------
17 */
18 --
19 procedure process
20 (errbuf out nocopy varchar2
21 ,retcode out nocopy number
22 ,p_report_name in varchar2
23 ,p_effective_date in varchar2
24 ,p_benefit_action_id in number default null
25 ,p_pgm_id in number default null
26 ,p_pl_nip_id in number default null
27 ,p_plan_in_pgm_flag in varchar2 default 'N'
28 ,p_organization_id in number default null
29 ,p_location_id in number default null
30 ,p_person_id in number default null
31 ,p_ler_id in number default null
32 ,p_lf_evt_ocrd_dt in varchar2 default null
33 ,p_person_selection_rule_id in number default null
34 ,p_comp_selection_rule_id in number default null
35 ,p_business_group_id in number
36 ,p_reporting_group_id in number default null
37 ,p_svc_area_id in number default null
38 ,p_assignment_type in varchar2 default null
39 ,p_cvg_strt_dt in varchar2 default null
40 ,p_cvg_end_dt in varchar2 default null
41 ,p_person_type_id in number default null
42 ,p_ben_sel_flag in varchar2 default 'Y'
43 ,p_flx_sum_flag in varchar2 default 'Y'
44 ,p_actn_items_flag in varchar2 default 'Y'
45 ,p_cov_dpnt_flag in varchar2 default 'Y'
46 ,p_prmy_care_flag in varchar2 default 'Y'
47 ,p_beneficaries_flag in varchar2 default 'Y'
48 ,p_certifications_flag in varchar2 default 'Y'
49 ,p_disp_epe_flxfld_flag in varchar2 default 'Y'
50 ,p_disp_flex_fields in varchar2 default 'Y'
51 ) ;
52 --
53 procedure rep_person_selection_rule
54 (p_person_id in Number
55 ,p_business_group_id in Number
56 ,p_person_selection_rule_id in Number
57 ,p_effective_date in Date
58 ,p_batch_flag in Boolean default FALSE
59 ,p_return in out nocopy varchar2
60 ,p_err_message in out nocopy varchar2 );
61 --
62 end ben_conc_reports;