1 package ben_manage_default_enrt as
2 /* $Header: beneadeb.pkh 120.0.12010000.1 2008/07/29 12:22:21 appldev ship $ */
3 /* ===========================================================================+
4 * Name
5 * Manage Default enrollment
6 * Purpose
7 * This package is used to check validity of parameters passed in via SRS
8 * or via a PL/SQL function or procedure. This package will make a call
9 * to process default enrollment for all comp. object for each person
10 * that their default enrollment date is over due.
11 *
12 * Version Date Author Comment
13 * -------+-----------+---------+----------------------------------------------
14 * 110.0 25 Mar 1998 Hugh Dang Initial Created.
15 * 115.2 28 Oct 1998 Hugh Dang Add new procedure default_comp_obj
16 * declaration.
17 * 115.3 24 Nov 1998 Hugh Dang Remove some of record declaration and add
18 * master flag on master multi will not kill
19 * itself in order to submit report and complete
20 * its task.
21 * 115.4 20-Dec-1998 Hugh Dang Add audit log parameter into procedure. and
22 * remove p_mode paramater from Process.
23 * 115.5 22-Feb-1999 Hugh Dang Chagne p_effective_date data type from date
24 * to varchar2
25 * 115.6 22-May-2000 GPERRY Added l_number_type varray.
26 * 115.8 03-Jul-2001 tmathers 9i compliance fix.
27 *
28 * 115.9 19-dec-2002 pabodla NOCOPY Changes
29 * 115.10 19-dec-2002 pabodla Added dbdrv commands
30 * 115.12 13-sep-2004 vvprabhu Bug 3876613 Procedure Default_Comp_obj_w added
31 * 115.13 05-nov-2004 vvprabhu Bug 3978573 parameter p_called_frm_ss added to
32 * Default_Comp_Obj to suppress multirowedit
33 * ==========================================================================+
34 */
35 --
36 -- Global Cursors and Global variables.
37 --
38 g_debug boolean := FALSE;
39 type g_cache_person_process_object is record
40 (person_id ben_person_actions.person_id%type
41 ,person_action_id ben_person_actions.person_action_id%type
42 ,object_version_number ben_person_actions.object_version_number%type
43 ,ler_id ben_person_actions.ler_id%type
44 );
45 type g_cache_person_process_rec is table of g_cache_person_process_object
46 index by binary_integer;
47 g_cache_person_process g_cache_person_process_rec;
48 --
49 -- Type definitions use max chunk size for limits
50 --
51 type l_number_type is varray(200) of number;
52 --
53 Procedure process
54 (errbuf out nocopy varchar2
55 ,retcode out nocopy number
56 ,p_benefit_action_id in number
57 ,p_effective_date in varchar2
58 ,p_validate in varchar2 default 'N'
59 ,p_person_id in number default null
60 ,p_person_type_id in number default null
61 ,p_business_group_id in number
62 ,p_popl_enrt_typ_cycl_id in number default null
63 ,p_person_selection_rule_id in number default null
64 ,p_ler_id in number default null
65 ,p_organization_id in number default null
66 ,p_benfts_grp_id in number default null
67 ,p_location_id in number default null
68 ,p_legal_entity_id in number default null
69 ,p_payroll_id in number default null
70 ,p_debug_messages in varchar2 default 'N'
71 ,p_audit_log in varchar2 default 'N'
72 );
73 Procedure restart
74 (errbuf out nocopy varchar2
75 ,retcode out nocopy number
76 ,p_benefit_action_id in number
77 );
78 Procedure do_multithread
79 (errbuf out nocopy varchar2
80 ,retcode out nocopy number
81 ,p_validate in varchar2 default 'N'
82 ,p_benefit_action_id in number
83 ,p_thread_id in number
84 ,p_effective_date in varchar2
85 ,p_business_group_id in number
86 ,p_audit_log in varchar2 default 'N'
87 );
88 Procedure process_default_enrt
89 (p_validate in varchar2 default 'N'
90 ,p_person_id in number default null
91 ,p_person_action_id in number default null
92 ,p_object_version_number in out nocopy number
93 ,p_business_group_id in number
94 ,p_effective_date in date
95 ,p_batch_flag in Boolean default FALSE
96 ,p_audit_log in varchar2 default 'N'
97 );
98 Procedure Default_Comp_obj
99 (p_validate in Boolean default FALSE
100 ,p_per_in_ler_id in Number
101 ,p_person_id in Number
102 ,p_business_group_id in Number
103 ,p_effective_date in Date
104 ,p_pgm_id in Number
105 ,p_pl_nip_id in Number
106 ,p_susp_flag out nocopy Boolean
107 ,p_batch_flag in Boolean default FALSE
108 ,p_cls_enrt_flag in Boolean default TRUE
109 ,p_called_frm_ss in Boolean default FALSE -- Bug 3978573
110 );
111
112 Procedure Default_Comp_obj_w
113 (p_validate in varchar2 default 'TRUE'
114 ,p_per_in_ler_id in Number
115 ,p_person_id in Number
116 ,p_business_group_id in Number
117 ,p_effective_date in Date
118 ,p_pgm_id in Number
119 ,p_pl_nip_id in Number default null
120 ,p_susp_flag out nocopy varchar2
121 ,p_batch_flag in varchar2 default 'FALSE'
122 ,p_cls_enrt_flag in varchar2 default 'FALSE'
123 );
124 End ben_manage_default_enrt;