1 PACKAGE ben_maintain_benefit_actions AS
2 /* $Header: benbmbft.pkh 120.0 2005/05/28 03:43:58 appldev noship $ */
3 --
4 -- Local package types
5 --
6 type g_processes_table is table of number index by binary_integer;
7 --
8 g_processes_rec g_processes_table;
9 --
10 g_num_processes number := 0;
11 --
12 PROCEDURE grab_next_batch_range
13 (p_benefit_action_id in number
14 --
15 ,p_start_person_action_id out nocopy number
16 ,p_end_person_action_id out nocopy number
17 ,p_rows_found out nocopy boolean
18 );
19 --
20 procedure start_slaves
21 (p_threads in number
22 ,p_num_ranges in number
23 ,p_validate in varchar2
24 ,p_benefit_action_id in number
25 ,p_effective_date in varchar2
26 ,p_pgm_id in number
27 ,p_business_group_id in number
28 ,p_pl_id in number
29 ,p_no_programs in varchar2
30 ,p_no_plans in varchar2
31 ,p_rptg_grp_id in number
32 ,p_pl_typ_id in number
33 ,p_opt_id in number
34 ,p_eligy_prfl_id in number
35 ,p_vrbl_rt_prfl_id in number
36 ,p_mode in varchar2
37 ,p_person_selection_rule_id in number
38 ,p_comp_selection_rule_id in number
39 ,p_derivable_factors in varchar2
40 ,p_cbr_tmprl_evt_flag in varchar2
41 ,p_lf_evt_ocrd_dt in varchar2
42 ,p_lmt_prpnip_by_org_flag in varchar2
43 ,p_gsp_eval_elig_flag in varchar2 default null -- GSP Rate Sync : Evaluate Eligibility
44 ,p_lf_evt_oper_cd in varchar2 default null -- GSP Rate Sync : Life Event Operation code
45 );
46 --
47 procedure check_slaves_status
48 (p_num_processes in number
49 ,p_processes_rec in ben_maintain_benefit_actions.g_processes_table
50 ,p_master in varchar2
51 ,p_slave_errored out nocopy boolean
52 );
53 --
54 procedure check_all_slaves_finished
55 (p_benefit_action_id in number
56 ,p_business_group_id in number
57 ,p_slave_errored out nocopy boolean
58 );
59 --
60 PROCEDURE get_peractionrange_persondets
61 (p_benefit_action_id in number
62 ,p_start_person_action_id in number
63 ,p_end_person_action_id in number
64 --
65 ,p_personid_va in out nocopy benutils.g_number_table
66 ,p_pactid_va in out nocopy benutils.g_number_table
67 ,p_pactovn_va in out nocopy benutils.g_number_table
68 ,p_lerid_va in out nocopy benutils.g_number_table
69 );
70 --
71 END ben_maintain_benefit_actions;
[Home] [Help]