1 package ben_prem_prtt_credits_mo as
2 /* $Header: benprprc.pkh 120.0.12010000.2 2008/08/05 14:49:44 ubhat ship $ */
3 --
4 type g_vrbl_prfl_rec is record
5 (vrbl_rt_prfl_id number,
6 match_cnt number,
7 val number);
8 --
9 type g_vrbl_prfl_table is table of g_vrbl_prfl_rec
10 index by binary_integer;
11
12 g_rec ben_type.g_report_rec ;
13
14 -- ----------------------------------------------------------------------------
15 -- |------------------------------< main >------------------------------------|
16 -- ----------------------------------------------------------------------------
17 -- This is the procedure to call to determine all the premiums credits for
18 -- prior months.
19 procedure main
20 (p_validate in varchar2 default 'N',
21 p_person_id in number default null,
22 p_pl_id in number default null,
23 p_person_selection_rule_id in number default null,
24 p_comp_selection_rule_id in number default null,
25 p_pgm_id in number default null,
26 p_pl_typ_id in number default null,
27 p_organization_id in number default null,
28 p_legal_entity_id in number default null,
29 p_business_group_id in number,
30 p_mo_num in number,
31 p_yr_num in number,
32 p_first_day_of_month in date,
33 p_effective_date in date) ;
34 end ben_prem_prtt_credits_mo;
[Home] [Help]