1 package ben_benbatch_persons AUTHID CURRENT_USER as
2 /* $Header: benbatpe.pkh 120.2.12010000.1 2008/07/29 12:03:05 appldev ship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1997 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10
11 Name
12 Benefit Batch Persons.
13 Purpose
14 This package is used to create Person actions for batch related
15 tasks.
16 History
17 Date Who Version What?
18 ---- --- ------- -----
19 11-AUG-98 GPERRY 110.0 Created after moving code
20 from benmngle.pkh
21 26-AUG-98 GPERRY 115.1 Added p_person_selection_rule_id
22 parameter.
23 23-SEP-98 GPERRY 115.2 Added p_commit_data parameter
24 for use with Prasads stuff.
25 29-SEP-98 GPERRY 115.3 Added num persons out nocopy parameter.
26 21-APR-99 GPERRY 115.4 Changes for temporal mode.
27 03-AUG-99 GPERRY 115.5 Performance enhancements.
28 22-DEC-99 GPERRY 115.6 Bug 2752 fixed.
29 WWBUG 1096742.
30 Life event mode supports all
31 selection criteria.
32 29-Jun-00 mhoyes 115.7 Added p_mode_cd to
33 create_normal_person_actions.
34 18-Sep-00 pbodla 115.8 - Healthnet changes : PB : Added parameter
35 p_lmt_prpnip_by_org_typ_id
36 02-Jul-02 pbodla 115.9 - ABSNCES - in case of absence mode
37 consider persons with absence
38 potential life events.
39 15-Jul-02 pbodla 115.10 - ABSENCES - Fixed typo
40 16-Jul-02 mmudigon 115.11 - Added driver commands
41 31-Jan-03 pbodla 115.12 - GRADE/STEP - modified
42 create_life_person_actions
43 to support extra parameters.
44 06-Feb-03 pbodla 115.13 - GRADE/STEP - modified
45 p_asg_events_to_all_sel_dt to date type
46 01-Aug-03 rpgupta 115.15 - Grade/step changes
47 14-Oct-04 abparekh 115.16 - GSP Rate Sync changes : Added p_lf_evt_oper_cd
48 to procedure create_life_person_actions
49 03-Jan-06 nhunur 115.17 - cwb - changes for person type param.
50 09-Aug-07 vvprabhu 115.18 Bug 5857493 - added g_audit_flag to
51 control person selection rule error logging
52 */
53 -----------------------------------------------------------------------
54 -- Type definitions use max chunk size for limits
55 --
56 type l_number_type is varray(200) of number;
57 g_audit_flag boolean :=false;
58 -----------------------------------------------------------------------
59 procedure create_life_person_actions
60 (p_benefit_action_id in number,
61 p_business_group_id in number,
62 p_person_id in number,
63 p_ler_id in number,
64 p_person_type_id in number,
65 p_benfts_grp_id in number,
66 p_location_id in number,
67 p_legal_entity_id in number,
68 p_payroll_id in number,
69 p_pstl_zip_rng_id in number,
70 p_organization_id in number,
71 p_person_selection_rule_id in number,
72 p_effective_date in date,
73 p_chunk_size in number,
74 p_threads in number,
75 p_num_ranges out nocopy number,
76 p_num_persons out nocopy number,
77 p_commit_data in varchar2,
78 p_lmt_prpnip_by_org_flag in varchar2,
79 -- GRADE/STEP : Added for grade/step benmngle
80 p_org_heirarchy_id in number default null,
81 p_org_starting_node_id in number default null,
82 p_grade_ladder_id in number default null,
83 p_asg_events_to_all_sel_dt in date default null,
84 p_rate_id in number default null ,
85 p_per_sel_dt_cd in varchar2 default null,
86 p_per_sel_dt_from in date default null,
87 p_per_sel_dt_to in date default null,
88 p_year_from in number default null,
89 p_year_to in number default null,
90 p_cagr_id in number default null,
91 p_qual_type in number default null,
92 p_qual_status in varchar2 default null,
93 -- 2940151
94 p_per_sel_freq_cd in varchar2 default 'Y',
95 p_id_flex_num in number default null,
96 p_concat_segs in varchar2 default null,
97 -- end 2940151
98 -- ABSENCES
99 p_mode in varchar2 default null,
100 p_lf_evt_oper_cd IN varchar2 default null /* GSP Rate Sync */
101 );
102 -----------------------------------------------------------------------
103 procedure create_normal_person_actions
104 (p_benefit_action_id in number
105 ,p_mode_cd in varchar2
106 ,p_business_group_id in number
107 ,p_person_id in number
108 ,p_ler_id in number
109 ,p_person_type_id in number
110 ,p_benfts_grp_id in number
111 ,p_location_id in number
112 ,p_legal_entity_id in number
113 ,p_payroll_id in number
114 ,p_pstl_zip_rng_id in number
115 ,p_organization_id in number
116 ,p_ler_override_id in number
117 ,p_person_selection_rule_id in number
118 ,p_effective_date in date
119 ,p_mode in varchar2
120 ,p_chunk_size in number
121 ,p_threads in number
122 ,p_num_ranges out nocopy number
123 ,p_num_persons out nocopy number
124 ,p_commit_data in varchar2
125 ,p_lmt_prpnip_by_org_flag in varchar2
126 ,p_popl_enrt_typ_cycl_id in number default NULL
127 ,p_cwb_person_type in varchar2 default NULL
128 ,p_lf_evt_ocrd_dt in date
129 );
130 -----------------------------------------------------------------------
131 procedure create_restart_person_actions
132 (p_benefit_action_id in number,
133 p_effective_date in date,
134 p_chunk_size in number,
135 p_threads in number,
136 p_num_ranges out nocopy number,
137 p_num_persons out nocopy number,
138 p_commit_data in varchar2);
139 -----------------------------------------------------------------------
140 end ben_benbatch_persons;