1 package ben_custom_formula as
2 /* $Header: bencustf.pkh 120.0 2005/05/28 03:55:58 appldev noship $ */
3 /*
4 This package is to be used to deliver custom formula examples.
5 see bencustf.sql for delivering formula functions.
6
7 Function overview
8 *****************
9 contact_valid
10 -------------
11 This function allows formula to test validity of
12 contact types. I.E. Do I have a spouse who is over
13 25 years old. If so if she causes a boundary event
14 then create a temporal event.
15 */
16 --
17 function contact_valid
18 (p_assignment_id in number, -- Context
19 p_effective_date in date, -- Context
20 p_business_group_id in number, -- Context
21 p_pgm_id in number, -- Context
22 p_pl_typ_id in number, -- Context
23 p_pl_id in number, -- Context
24 p_opt_id in number, -- Context
25 p_contact_type in varchar2,
26 p_min_age_val in number,
27 p_max_age_val in number,
28 p_age_det_cd in varchar2,
29 p_age_det_rl in number,
30 p_age_uom in varchar2,
31 p_rndg_cd in varchar2,
32 p_rndg_rl in number,
33 p_create_tmprl_event in varchar2 default 'N') return varchar2;
34 --
35 end ben_custom_formula;
36 --