1 package ben_proc_common_enrt_rslt AUTHID CURRENT_USER as
2 /* $Header: benprcme.pkh 120.2.12010000.1 2008/07/29 12:28:30 appldev ship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1998 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10 --
11 Name
12 Common Enrollment Results Process
13 Purpose
14
15 --------------------------------------------------------------------------------
16 History
17
18 Version Date Author Comments
19 -------+-----------+--------------+----------------------------------------
20 110.0 02-JUN-1998 stee Created
21 110.1 18-JUN-1998 maagrawa Two new parameters added
22 p_pgm_id and p_pl_id
23 115.2 31-Oct-1998 stee Added person_id and proc_cd
24 to process_post_enrollment.
25 115.3 10-Dec-1998 bbulusu added per_in_ler_id to process_post_result
26 115.4 10-Feb-1999 yrathman Added set_elcn_made_or_asnd_dt procedure
27 115.5 29-Jun-1999 stee Removed update_cobra_info procedure.
28 115.6 31-Jul-2000 pzclark Added a wrapper to procedure
29 process_post_enrollment to allow self
30 service java code to call using varchar2
31 'TRUE' or 'FALSE' instead of booleans.
32 115.7 15-Aug-2000 maagrawa Added procedure process_post_enrt_calls_w
33 (wrapper for self-service).
34 115.8 17-May-2001 maagrawa Added parameter self_service_flag to
35 process_post_results for performance.
36 115.10 28-Dec-2001 ikasire added dbdrv lines
37 115.11 02-jan-2002 tjesumic 2170324 paramter for proc_cd2 to proc_cd5 added
38 115.12 11-Oct-2004 kmahendr bug#3944970 - added two parameters to post_results
39 115.13 03-Dec-2004 ikasire Bug 3988565 Changed effective_date data type to Date
40 115.14 16-Nov-06 vvprabhu Bug 5664300 - parameter p_called_from_ss added
41 115.15 to process_post_results
42 */
43 --------------------------------------------------------------------------------
44 --
45 procedure set_elcn_made_or_asnd_dt
46 (p_per_in_ler_id in number default null
47 ,p_pgm_id in number
48 ,p_pl_id in number
49 ,p_enrt_mthd_cd in varchar2
50 ,p_business_group_id in number
51 ,p_effective_date in date
52 ,p_validate in boolean default false
53 );
54 --
55 procedure process_post_results
56 (p_flx_cr_flag in varchar2 default 'N'
57 ,p_person_id in number
58 ,p_enrt_mthd_cd in varchar2
59 ,p_effective_date in date
60 ,p_business_group_id in number
61 ,p_validate in boolean default false
62 ,p_per_in_ler_id in number default null
63 ,p_self_service_flag in boolean default false
64 ,p_pgm_id in number default null
65 ,p_pl_id in number default null
66 ,p_called_frm_ss in boolean default false
67 );
68 --
69 procedure process_post_enrollment
70 (p_per_in_ler_id in number default null
71 ,p_pgm_id in number
72 ,p_pl_id in number
73 ,p_enrt_mthd_cd in varchar2
74 ,p_cls_enrt_flag in boolean default true
75 ,p_proc_cd in varchar2 default null
76 ,p_proc_cd2 in varchar2 default null
77 ,p_proc_cd3 in varchar2 default null
78 ,p_proc_cd4 in varchar2 default null
79 ,p_proc_cd5 in varchar2 default null
80 ,p_person_id in number
81 ,p_business_group_id in number
82 ,p_effective_date in date
83 ,p_validate in boolean default false
84 );
85 --
86 procedure process_post_enrollment_w
87 (p_per_in_ler_id in number
88 ,p_pgm_id in number
89 ,p_pl_id in number
90 ,p_enrt_mthd_cd in varchar2
91 ,p_cls_enrt_flag in varchar2
92 ,p_proc_cd in varchar2
93 ,p_person_id in number
94 ,p_business_group_id in number
95 ,p_effective_date in date
96 ,p_validate in varchar2
97 );
98 --
99 procedure process_post_enrt_calls_w
100 (p_validate in varchar2 default 'N'
101 ,p_person_id in number
102 ,p_per_in_ler_id in number
103 ,p_pgm_id in number default null
104 ,p_pl_id in number default null
105 ,p_flx_cr_flag in varchar2 default 'N'
106 ,p_enrt_mthd_cd in varchar2
107 ,p_proc_cd in varchar2 default null
108 ,p_cls_enrt_flag in varchar2 default 'N'
109 ,p_business_group_id in number
110 ,p_effective_date in date );
111 --
112 --OVERLOADED PROCEDURE with p_self_service_flag for Coversion purpose
113 --Always pass p_self_service_flag = 'N' when this api is called
114 --for other ssben purpose
115 --
116 procedure process_post_enrt_calls_w
117 (p_validate in varchar2 default 'N'
118 ,p_person_id in number
119 ,p_per_in_ler_id in number
120 ,p_pgm_id in number default null
121 ,p_pl_id in number default null
122 ,p_flx_cr_flag in varchar2 default 'N'
123 ,p_enrt_mthd_cd in varchar2
124 ,p_proc_cd in varchar2 default null
125 ,p_cls_enrt_flag in varchar2 default 'N'
126 ,p_business_group_id in number
127 ,p_effective_date in date
128 ,p_self_service_flag in varchar2 );
129 --
130 end;