1 PACKAGE hri_opl_ben_enrl_actn AS
2 /* $Header: hripbeea.pkh 120.0 2005/09/21 01:28:16 anmajumd noship $ */
3 /*++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
4 Name : HRI_OPL_BEN_ENRL_ACTN
5 Purpose : Populate Benefits Enrollment Actions Fact
6 ------------------------------------------------------------------------------
7 History
8 -------
9 Version Date Author Comment
10 -------+----------+----------------+------------------------------------------
11 12.0 30-JUN-05 abparekh Initial Version
12 -------------------------------------------------------------------------------
13 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
14 --
15 TYPE g_pil_rec_type IS RECORD (
16 per_in_ler_id NUMBER,
17 person_id NUMBER,
18 lf_evt_ocrd_dt DATE,
19 per_in_ler_stat_cd VARCHAR2 (30),
20 business_group_id NUMBER
21 );
22
23 --
24 TYPE g_pil_tab_type IS TABLE OF g_pil_rec_type
25 INDEX BY BINARY_INTEGER;
26
27 --
28 TYPE g_per_in_ler_id_tab_type IS TABLE OF NUMBER
29 INDEX BY BINARY_INTEGER;
30
31 --
32 TYPE g_prtt_enrt_rslt_id_tab_type IS TABLE OF NUMBER
33 INDEX BY BINARY_INTEGER;
34
35 --
36 TYPE g_person_id_tab_type IS TABLE OF NUMBER
37 INDEX BY BINARY_INTEGER;
38
39 --
40 TYPE g_actn_typ_id_tab_type IS TABLE OF NUMBER
41 INDEX BY BINARY_INTEGER;
42
43 --
44 TYPE g_event_date_tab_type IS TABLE OF DATE
45 INDEX BY BINARY_INTEGER;
46
47 --
48 TYPE g_lf_evt_ocrd_dt_tab_type IS TABLE OF DATE
49 INDEX BY BINARY_INTEGER;
50
51 --
52 TYPE g_due_dt_tab_type IS TABLE OF DATE
53 INDEX BY BINARY_INTEGER;
54
55 --
56 TYPE g_actn_typ_cd_tab_type IS TABLE OF VARCHAR2 (30)
57 INDEX BY BINARY_INTEGER;
58
59 --
60 TYPE g_rqd_flag_tab_type IS TABLE OF VARCHAR2 (1)
61 INDEX BY BINARY_INTEGER;
62
63 --
64 TYPE g_cmpltd_dt_tab_type IS TABLE OF DATE
65 INDEX BY BINARY_INTEGER;
66
67 --
68 TYPE g_prtt_enrt_actn_id_tab_type IS TABLE OF NUMBER
69 INDEX BY BINARY_INTEGER;
70
71 --
72 --
73 TYPE g_date_tab_type IS TABLE OF DATE
74 INDEX BY BINARY_INTEGER;
75
76 --
77 TYPE g_number_tab_type IS TABLE OF NUMBER
78 INDEX BY BINARY_INTEGER;
79
80 --
81 TYPE g_varchar2_tab_type IS TABLE OF VARCHAR2 (30)
82 INDEX BY BINARY_INTEGER;
83
84 --
85 TYPE g_rowid_tab_type IS TABLE OF ROWID
86 INDEX BY BINARY_INTEGER;
87
88 --
89 -- ----------------------------------------------------------------------------
90 -- PRE_PROCESS
91 -- This procedure includes the logic required for performing the pre_process
92 -- task of HRI multithreading utility.
93 -- ----------------------------------------------------------------------------
94 PROCEDURE pre_process (
95 p_mthd_action_id IN NUMBER,
96 p_sqlstr OUT NOCOPY VARCHAR2
97 );
98
99 --
100 -- ----------------------------------------------------------------------------
101 -- PROCESS_RANGE
102 -- This procedure is dynamically called from HRI Multithreading utility.
103 -- Calls Collection procedures for Election Event and Elibility Enrollment Event Facts
104 -- for All PER_IN_LER_IDs obtained from the thread range.
105 -- ----------------------------------------------------------------------------
106 PROCEDURE process_range (
107 errbuf OUT NOCOPY VARCHAR2,
108 retcode OUT NOCOPY NUMBER,
109 p_mthd_action_id IN NUMBER,
110 p_mthd_range_id IN NUMBER,
111 p_start_object_id IN NUMBER,
112 p_end_object_id IN NUMBER
113 );
114
115 --
116 -- ----------------------------------------------------------------------------
117 -- POST_PROCESS
118 -- This procedure is dynamically invoked by the HRI Multithreading utility.
119 -- It performs all the clean up action for after collection.
120 -- Enable the MV logs
121 -- Purge the Election and Eligibility Events' incremental events queue
122 -- Update BIS Refresh Log
123 -- ----------------------------------------------------------------------------
124 PROCEDURE post_process (p_mthd_action_id IN NUMBER);
125 --
126 END hri_opl_ben_enrl_actn;