1 PACKAGE HRI_OPL_BEN_ELIG_ENRL AS
2 /* $Header: hripbeec.pkh 120.0 2005/09/21 01:28:40 anmajumd noship $ */
3 --
4 /*++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
5 Name : HRI_OPL_BEN_ELIG_ENRL
6 Purpose : Populate Benefits Eligbility and Enrollment Fact
7 ------------------------------------------------------------------------------
8 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++*/
9
10 TYPE g_pil_rec_type IS RECORD
11 (per_in_ler_id NUMBER
12 ,person_id NUMBER
13 ,lf_evt_ocrd_dt DATE
14 ,per_in_ler_stat_cd VARCHAR2(30)
15 ,business_group_id NUMBER
16 );
17 --
18 TYPE g_pil_tab_type IS TABLE OF g_pil_rec_type
19 INDEX BY BINARY_INTEGER;
20 --
21 TYPE g_date_tab_type IS TABLE OF DATE
22 INDEX BY BINARY_INTEGER;
23 --
24 TYPE g_number_tab_type IS TABLE OF NUMBER
25 INDEX BY BINARY_INTEGER;
26 --
27 TYPE g_varchar2_tab_type IS TABLE OF VARCHAR2(30)
28 INDEX BY BINARY_INTEGER;
29 --
30 TYPE g_rowid_tab_type IS TABLE OF ROWID
31 INDEX BY BINARY_INTEGER;
32 --
33 -- ----------------------------------------------------------------------------
34 -- PRE_PROCESS
35 -- This procedure includes the logic required for performing the pre_process
36 -- task of HRI multithreading utility.
37 -- ----------------------------------------------------------------------------
38 PROCEDURE pre_process
39 (p_mthd_action_id IN NUMBER
40 ,p_sqlstr OUT NOCOPY VARCHAR2);
41 --
42 -- ----------------------------------------------------------------------------
43 -- PROCESS_RANGE
44 -- This procedure is dynamically called from HRI Multithreading utility.
45 -- Calls Collection procedures for Election Event and Elibility Enrollment Event Facts
46 -- for All PER_IN_LER_IDs obtained from the thread range.
47 -- ----------------------------------------------------------------------------
48 PROCEDURE process_range
49 (errbuf OUT NOCOPY VARCHAR2
50 ,retcode OUT NOCOPY NUMBER
51 ,p_mthd_action_id IN NUMBER
52 ,p_mthd_range_id IN NUMBER
53 ,p_start_object_id IN NUMBER
54 ,p_end_object_id IN NUMBER);
55 --
56 -- ----------------------------------------------------------------------------
57 -- POST_PROCESS
58 -- This procedure is dynamically invoked by the HRI Multithreading utility.
59 -- It performs all the clean up action for after collection.
60 -- Enable the MV logs
61 -- Purge the Election and Eligibility Events' incremental events queue
62 -- Update BIS Refresh Log
63 -- ----------------------------------------------------------------------------
64 PROCEDURE post_process
65 (p_mthd_action_id IN NUMBER);
66 --
67 END HRI_OPL_BEN_ELIG_ENRL;
[Home] [Help]