1 PACKAGE BEN_PERSON_RECORD AUTHID CURRENT_USER AS
2 /* $Header: benperrec.pkh 120.0.12010000.4 2009/04/10 12:56:22 pvelvano noship $ */
3
4 TYPE g_beneficiary_rec_type IS RECORD
5 (plan_type_name ben_pl_typ_f.name%type
6 ,plan_name ben_pl_f.name%type
7 ,option_name ben_opt_f.name%type
8 ,beneficiary VARCHAR2(400)
9 ,ben_ssn per_all_people_f.national_identifier%type
10 ,ben_relation VARCHAR2(400)
11 ,primary_bnf NUMBER
12 ,contingent_bnf NUMBER
13 ,le_name ben_ler_f.name%type
14 ,ben_full_name per_all_people_f.full_name%type
15 );
16
17 TYPE g_dependent_rec_type IS RECORD
18 (
19 name per_all_people_f.full_name%type,
20 relationship VARCHAR2(400),
21 type_of_benefit ben_pl_typ_f.name%type,
22 coverage VARCHAR2(100)
23 );
24
25 TYPE g_benefits_rec_type IS RECORD
26 (
27 type_of_benefit ben_pl_typ_f.name%type
28 ,plan ben_pl_f.name%type
29 ,coverage_or_participation ben_opt_f.name%type
30 );
31
32 TYPE g_beneficiary_tab_type IS TABLE OF g_beneficiary_rec_type INDEX BY BINARY_INTEGER;
33 TYPE g_benefits_tab_type IS TABLE OF g_benefits_rec_type INDEX BY BINARY_INTEGER;
34 TYPE g_dependent_tab_type IS TABLE OF g_dependent_rec_type INDEX BY BINARY_INTEGER;
35
36 /*Complete Ben record structure*/
37 TYPE ben_record_details is record
38 (
39 benefit g_benefits_tab_type,
40 dependent g_dependent_tab_type
41 );
42
43 -- Procedure to populate the record structure with Person Benefits Data
44 procedure GET_BEN_DETAILS (p_ben_details in out NOCOPY ben_record_details,
45 p_person_id NUMBER,p_effective_date DATE,
46 p_business_group_id NUMBER);
47
48 END BEN_PERSON_RECORD;
49 --