1 package ben_purge_bckdt_voided AUTHID CURRENT_USER as
2 /* $Header: benprbck.pkh 120.1.12010000.1 2008/07/29 12:28:23 appldev ship $ */
3 /* ========================================================================
4 * Name
5 * Close Enrollment
6 * Purpose
7 * This package is used to purge the benmngle rows for the bckt and voided life
8 * events
9 * History
10 * Date Who Ver What?
11 * --------- ---------- ------ ----------------------------
12 * 11 Nov 03 kmahendr 110.0 Created.
13 * 17 May 04 kmahendr 115.1 Added additional parameters.
14 *
15 ===========================================================================
16 */
17 --
18 -- Global varaibles.
19 --
20 type g_cache_person_process_object is record
21 (person_id ben_person_actions.person_id%type
22 ,person_action_id ben_person_actions.person_action_id%type
23 ,object_version_number ben_person_actions.object_version_number%type
24 );
25 type g_cache_person_process_rec is table of g_cache_person_process_object
26 index by binary_integer;
27 g_debug boolean := FALSE;
28 --
29 -- Procedure declaration.
30 --
31 Procedure purge_single_person
32 (p_effective_date in date
33 ,p_business_group_id in number
34 ,p_person_id in Number default NULL
35 ,p_life_event_id in number default null
36 ,p_from_ocrd_date in date default null
37 ,p_to_ocrd_date in date
38 ,p_life_evt_typ_cd in varchar2 default null
39 ,p_bckt_stat_cd in varchar2 default 'VOIDD'
40 ,p_audit_log_flag in varchar2 default 'N'
41 ,p_delete_life_evt in varchar2 default 'N'
42 );
43 --
44 Procedure process
45 (errbuf out nocopy varchar2
46 ,retcode out nocopy number
47 ,p_benefit_action_id in number
48 ,p_effective_date in varchar2
49 ,p_business_group_id in number
50 ,p_Person_id in number default NULL
51 ,p_Person_selection_rl in number default NULL
52 ,p_life_event_id in number default null
53 ,p_from_ocrd_date in varchar2 default null
54 ,p_to_ocrd_date in varchar2
55 ,p_organization_id in number default null
56 ,p_location_id in number default null
57 ,p_benfts_grp_id in number default null
58 ,p_legal_entity_id in number default null
59 ,p_payroll_id in number default null
60 ,p_life_evt_typ_cd in varchar2 default null
61 ,p_bckt_stat_cd in varchar2 default 'VOIDD'
62 ,p_audit_log_flag in varchar2 default 'N'
63 ,p_delete_life_evt in varchar2 default 'N'
64 ,p_delete_ptnl_life_evt in varchar2 default 'N'
65 ) ;
66 --
67 Procedure do_multithread
68 (errbuf out nocopy varchar2
69 ,retcode out nocopy number
70 ,p_benefit_action_id in number
71 ,p_thread_id in number
72 ,p_effective_date in varchar2
73 ,p_business_group_id in number
74 ,p_life_event_id in number default null
75 ,p_from_ocrd_date in varchar2 default null
76 ,p_to_ocrd_date in varchar2
77 ,p_organization_id in number default null
78 ,p_location_id in number default null
79 ,p_benfts_grp_id in number default null
80 ,p_legal_entity_id in number default null
81 ,p_payroll_id in number default null
82 ,p_life_evt_typ_cd in varchar2 default null
83 ,p_bckt_stat_cd in varchar2 default 'VOIDD'
84 ,p_audit_log_flag in varchar2 default 'N'
85 ,p_delete_life_evt in varchar2 default 'N'
86 );
87 --
88 Procedure restart
89 (errbuf out nocopy varchar2
90 ,retcode out nocopy number
91 ,p_benefit_action_id in number
92 );
93 --
94 --
95 End ;