1 Package ben_Related_person_ler_api AUTHID CURRENT_USER as
2 /* $Header: benrllrb.pkh 120.0 2005/05/28 09:26:32 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_related_person_ler >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This event determines any impact on persons, e.g. dependents or
11 -- beneficiaries related to a current participant, new participant, or
12 -- former participant as the result of an information change to a participant,
13 -- e.g. death, divorce, or termination.
14 --
15 -- This process performs the following operations:
16 --
17 -- 1. For a single person, accept a life event reason.
18 -- 2. Determine if the particpant's life event has an associated related person life event.
19 -- 3. If found, identify participant's related persons, if any.
20 -- 4. If found, create related person's potential life event.
21 --
22 -- Prerequisites:
23 -- Person must have a PER_IN_LER record for the ler_id passed in.
24 --
25 -- In Parameters:
26 -- Name Reqd Type Description
27 -- p_validate boolean
28 -- p_person_id Y number
29 -- p_ler_id Y number Life Event id that the person
30 -- experienced on which we are basing
31 -- a related person life event.
32 -- p_effective_date Y date
33 -- p_business_group_id Y number
34 -- p_from_form varchar2 If being called in batch mode, then
35 -- pass in a 'N'. Otherwise we assume
36 -- we are being called from a form. When
37 -- called from a form, the benutils report
38 -- is NOT created, and the p_validate CAN
39 -- cause a rollback. Errors are also processed
40 -- differently.
41 --
42 -- Post Success:
43 -- A record is written to ben_ptnl_ler_for_per_f.
44 --
45 -- Post Failure:
46 -- If p_from_form = 'N', then an error row is written to the report.
47 -- if p_from_form = 'Y', then the error is passed along to the form.
48 --
49 -- Access Status:
50 -- Public.
51 --
52 -- {End Of Comments}
53 --
54 procedure create_related_person_ler
55 (p_validate in boolean default false
56 ,p_person_id in number
57 ,p_ler_id in number
58 ,p_effective_date in date
59 ,p_business_group_id in number
60 ,p_csd_by_ptnl_ler_for_per_id in number default null
61 ,p_from_form in varchar2 default 'Y' ) ;
62 --
63 end ben_Related_person_ler_api;