1 PACKAGE ben_reopen_ler_conc AUTHID CURRENT_USER AS
2 /* $Header: benrecon.pkh 120.0.12000000.1 2007/07/12 10:08:03 gsehgal noship $ */
3 --
4 /* ============================================================================
5 * Name
6 * Reopen Life Events Concurrent Manager Process
7 *
8 * Purpose
9 * This package simply houses the concurrent manager and multi-thread
10 * processes for Reopen Life Events.
11 *
12 * History
13 * Date Who Version What?
14 * ------- --------- ------- --------------------------------------
15 * 8/14/2006 gsehgal 115.0 Created
16 *
17 * -----------------------------------------------------------------------------
18 */
19 --
20 -- Global type declaration
21 --
22 type g_cache_person_process_object is record
23 (person_id ben_person_actions.person_id%type
24 ,person_action_id ben_person_actions.person_action_id%type
25 ,object_version_number ben_person_actions.object_version_number%type
26 ,ler_id ben_person_actions.ler_id%type
27 );
28 type g_cache_person_process_rec is table of g_cache_person_process_object
29 index by binary_integer;
30 --
31 -- Global varaibles.
32 --
33
34
35 -- Global Procedures
36 PROCEDURE process (
37 errbuf OUT NOCOPY VARCHAR2,
38 retcode OUT NOCOPY NUMBER,
39 p_benefit_action_id IN NUMBER,
40 p_effective_date IN VARCHAR2,
41 p_validate IN VARCHAR2 DEFAULT 'N',
42 p_business_group_id IN NUMBER,
43 p_ler_id IN NUMBER DEFAULT NULL,
44 p_from_ocrd_date IN VARCHAR2 DEFAULT NULL,
45 p_organization_id IN NUMBER DEFAULT NULL,
46 p_location_id IN NUMBER DEFAULT NULL,
47 p_benfts_grp_id IN NUMBER DEFAULT NULL,
48 p_legal_entity_id IN NUMBER DEFAULT NULL,
49 p_person_selection_rl IN NUMBER DEFAULT NULL,
50 p_debug_messages IN VARCHAR2 DEFAULT 'N'
51 );
52
53 PROCEDURE do_multithread (
54 errbuf OUT NOCOPY VARCHAR2,
55 retcode OUT NOCOPY NUMBER,
56 p_validate IN VARCHAR2 DEFAULT 'N',
57 p_benefit_action_id IN NUMBER,
58 p_effective_date IN VARCHAR2,
59 p_business_group_id IN NUMBER,
60 p_ler_id IN NUMBER,
61 p_thread_id IN NUMBER
62 );
63 PROCEDURE submit_all_reports (p_rpt_flag IN BOOLEAN DEFAULT FALSE);
64 END ben_reopen_ler_conc;
65
66