1 package ben_determine_communications AUTHID CURRENT_USER as
2 /*$Header: bentmpcm.pkh 115.11 2002/12/23 13:56:21 hmani ship $*/
3 --
4 /*
5 Name
6 Determine Communications
7 Purpose
8 This is a batch process that creates person communication for triggers
9 that are not automatically generated by an OAB process.
10 History
11 Version Date Author Comment
12 -------+---------+----------+-------------------------------------------------
13 115.0 19-Nov-98 bbulusu Created initial shell for code freeze.
14 115.1 31-Dec-98 bbulusu Added procs process, restart and do_multithread
15 115.2 04-Feb-99 bbulusu Removed p_min_cmbn and p_max_cmbn
16 115.3 25-Feb-99 bbulusu Changed dates in process and do_multithread to
17 varchar2.
18 115.4 08-May-99 maagrawa -Removed parameter comp_object_selection_rule.
19 -Added procedures to provide details to comm.
20 reports.
21 115.5 10-May-99 maagrawa Corrected the Header position.
22 115.6 10-Sep-99 maagrawa Added 3 parameters comp_selection_rl,
23 los_det_to_use_cd, use_fctr_to_sel_flag.
24 115.7 13-Oct-99 maagrawa Ordered the parameter list in procedure process
25 as in seeded concurrent procedure.
26 115.8 08-May-00 maagrawa added parameter p_status in standard_header Procedure.
27 115.9 05-Sep-00 pbodla - Bug 5422 : Allow different enrollment periods
28 for programs for a scheduled a enrollment.
29 115.10 03-Jul-01 tmathers 9i compliance fixes change p_mode to default 'I'
30 115.11 11-dec-2002 hmani NoCopy changes
31 ------------------------------------------------------------------------------
32 */
33 procedure process
34 (errbuf out nocopy varchar2
35 ,retcode out nocopy number
36 ,p_benefit_action_id in number default null
37 ,p_validate in varchar2 default 'N'
38 ,p_effective_date in varchar2
39 ,p_business_group_id in number
40 ,p_mode in varchar2 default 'I'
41 ,p_cm_trgr_typ_cd in varchar2
42 ,p_cm_typ_id in number default null
43 ,p_person_id in number default null
44 ,p_person_type_id in number default null
45 ,p_person_sel_rl in number default null
46 ,p_organization_id in number default null
47 ,p_location_id in number default null
48 ,p_ler_id in number default null
49 ,p_pgm_id in number default null
50 ,p_pl_nip_id in number default null
51 ,p_plan_in_pgm_flag in varchar2 default 'Y'
52 ,p_actn_typ_id in number default null
53 ,p_elig_enrol_cd in varchar2 default null
54 ,p_age_fctr_id in number default null
55 ,p_min_age in number default null
56 ,p_max_age in number default null
57 ,p_los_fctr_id in number default null
58 ,p_min_los in number default null
59 ,p_max_los in number default null
60 ,p_cmbn_age_los_fctr_id in number default null
61 ,p_date_from in varchar2 default null
62 -- PB : 5422 :
63 -- ,p_popl_enrt_typ_cycl_id in number default null
64 ,p_lf_evt_ocrd_dt in varchar2 default null
65 ,p_audit_log_flag in varchar2 default 'N'
66 ,p_comp_selection_rl in number default null
67 ,p_use_fctr_to_sel_flag in varchar2 default 'N'
68 ,p_los_det_to_use_cd in varchar2 default null);
69 --
70 --
71 procedure restart
72 (errbuf out nocopy varchar2
73 ,retcode out nocopy number
74 ,p_benefit_action_id in number);
75 --
76 --
77 procedure do_multithread
78 (errbuf out nocopy varchar2
79 ,retcode out nocopy number
80 ,p_validate in varchar2 default 'N'
81 ,p_benefit_action_id in number
82 ,p_thread_id in number
83 ,p_effective_date in varchar2
84 ,p_business_group_id in number);
85 --
86 --
87 procedure summary_by_action(p_concurrent_request_id in number,
88 p_rcv_comm_count out nocopy number,
89 p_rcv_1_comm_count out nocopy number,
90 p_rcv_mlt_comm_count out nocopy number);
91 --
92 --
93 procedure standard_header(p_concurrent_request_id in number,
94 p_concurrent_program_name out nocopy varchar2,
95 p_process_date out nocopy date,
96 p_validate out nocopy varchar2,
97 p_business_group out nocopy varchar2,
98 p_mode out nocopy varchar2,
99 p_cm_trgr_typ out nocopy varchar2,
100 p_cm_typ out nocopy varchar2,
101 p_person out nocopy varchar2,
102 p_person_type out nocopy varchar2,
103 p_person_selection_rule out nocopy varchar2,
104 p_organization out nocopy varchar2,
105 p_location out nocopy varchar2,
106 p_ler out nocopy varchar2,
107 p_program out nocopy varchar2,
108 p_plan out nocopy varchar2,
109 p_plan_in_program out nocopy varchar2,
110 p_actn_typ out nocopy varchar2,
111 p_elig_enrol out nocopy varchar2,
112 p_age_fctr out nocopy varchar2,
113 p_min_age out nocopy number,
114 p_max_age out nocopy number,
115 p_los_fctr out nocopy varchar2,
116 p_min_los out nocopy number,
117 p_max_los out nocopy number,
118 p_cmbn_age_los_fctr out nocopy varchar2,
119 p_date_from out nocopy date,
120 p_enrollment_period out nocopy varchar2,
121 p_audit_log out nocopy varchar2,
122 p_status out nocopy varchar2);
123 --
124 --
125 end ben_determine_communications;