eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.BEN_ENROLLMENT_RATE_BK1

Source


1 package body BEN_ENROLLMENT_RATE_BK1 as
2 /* $Header: beecrapi.pkb 115.22 2004/03/23 12:43:03 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2007/01/03 21:31:25 (YYYY/MM/DD HH24:MI:SS)
5 procedure CREATE_ENROLLMENT_RATE_A
6 (P_ENRT_RT_ID in NUMBER
7 ,P_ORDR_NUM in NUMBER
8 ,P_ACTY_TYP_CD in VARCHAR2
9 ,P_TX_TYP_CD in VARCHAR2
10 ,P_CTFN_RQD_FLAG in VARCHAR2
11 ,P_DFLT_FLAG in VARCHAR2
12 ,P_DFLT_PNDG_CTFN_FLAG in VARCHAR2
13 ,P_DSPLY_ON_ENRT_FLAG in VARCHAR2
14 ,P_USE_TO_CALC_NET_FLX_CR_FLAG in VARCHAR2
15 ,P_ENTR_VAL_AT_ENRT_FLAG in VARCHAR2
16 ,P_ASN_ON_ENRT_FLAG in VARCHAR2
17 ,P_RL_CRS_ONLY_FLAG in VARCHAR2
18 ,P_DFLT_VAL in NUMBER
19 ,P_ANN_VAL in NUMBER
20 ,P_ANN_MN_ELCN_VAL in NUMBER
21 ,P_ANN_MX_ELCN_VAL in NUMBER
22 ,P_VAL in NUMBER
23 ,P_NNMNTRY_UOM in VARCHAR2
24 ,P_MX_ELCN_VAL in NUMBER
25 ,P_MN_ELCN_VAL in NUMBER
26 ,P_INCRMT_ELCN_VAL in NUMBER
27 ,P_CMCD_ACTY_REF_PERD_CD in VARCHAR2
28 ,P_CMCD_MN_ELCN_VAL in NUMBER
29 ,P_CMCD_MX_ELCN_VAL in NUMBER
30 ,P_CMCD_VAL in NUMBER
31 ,P_CMCD_DFLT_VAL in NUMBER
32 ,P_RT_USG_CD in VARCHAR2
33 ,P_ANN_DFLT_VAL in NUMBER
34 ,P_BNFT_RT_TYP_CD in VARCHAR2
35 ,P_RT_MLT_CD in VARCHAR2
36 ,P_DSPLY_MN_ELCN_VAL in NUMBER
37 ,P_DSPLY_MX_ELCN_VAL in NUMBER
38 ,P_ENTR_ANN_VAL_FLAG in VARCHAR2
39 ,P_RT_STRT_DT in DATE
40 ,P_RT_STRT_DT_CD in VARCHAR2
41 ,P_RT_STRT_DT_RL in NUMBER
42 ,P_RT_TYP_CD in VARCHAR2
43 ,P_ELIG_PER_ELCTBL_CHC_ID in NUMBER
44 ,P_ACTY_BASE_RT_ID in NUMBER
45 ,P_SPCL_RT_ENRT_RT_ID in NUMBER
46 ,P_ENRT_BNFT_ID in NUMBER
47 ,P_PRTT_RT_VAL_ID in NUMBER
48 ,P_DECR_BNFT_PRVDR_POOL_ID in NUMBER
49 ,P_CVG_AMT_CALC_MTHD_ID in NUMBER
50 ,P_ACTL_PREM_ID in NUMBER
51 ,P_COMP_LVL_FCTR_ID in NUMBER
52 ,P_PTD_COMP_LVL_FCTR_ID in NUMBER
53 ,P_CLM_COMP_LVL_FCTR_ID in NUMBER
54 ,P_BUSINESS_GROUP_ID in NUMBER
55 ,P_ISS_VAL in NUMBER
56 ,P_VAL_LAST_UPD_DATE in DATE
57 ,P_VAL_LAST_UPD_PERSON_ID in NUMBER
58 ,P_PP_IN_YR_USED_NUM in NUMBER
59 ,P_ECR_ATTRIBUTE_CATEGORY in VARCHAR2
60 ,P_ECR_ATTRIBUTE1 in VARCHAR2
61 ,P_ECR_ATTRIBUTE2 in VARCHAR2
62 ,P_ECR_ATTRIBUTE3 in VARCHAR2
63 ,P_ECR_ATTRIBUTE4 in VARCHAR2
64 ,P_ECR_ATTRIBUTE5 in VARCHAR2
65 ,P_ECR_ATTRIBUTE6 in VARCHAR2
66 ,P_ECR_ATTRIBUTE7 in VARCHAR2
67 ,P_ECR_ATTRIBUTE8 in VARCHAR2
68 ,P_ECR_ATTRIBUTE9 in VARCHAR2
69 ,P_ECR_ATTRIBUTE10 in VARCHAR2
70 ,P_ECR_ATTRIBUTE11 in VARCHAR2
71 ,P_ECR_ATTRIBUTE12 in VARCHAR2
72 ,P_ECR_ATTRIBUTE13 in VARCHAR2
73 ,P_ECR_ATTRIBUTE14 in VARCHAR2
74 ,P_ECR_ATTRIBUTE15 in VARCHAR2
75 ,P_ECR_ATTRIBUTE16 in VARCHAR2
76 ,P_ECR_ATTRIBUTE17 in VARCHAR2
77 ,P_ECR_ATTRIBUTE18 in VARCHAR2
78 ,P_ECR_ATTRIBUTE19 in VARCHAR2
79 ,P_ECR_ATTRIBUTE20 in VARCHAR2
80 ,P_ECR_ATTRIBUTE21 in VARCHAR2
81 ,P_ECR_ATTRIBUTE22 in VARCHAR2
82 ,P_ECR_ATTRIBUTE23 in VARCHAR2
83 ,P_ECR_ATTRIBUTE24 in VARCHAR2
84 ,P_ECR_ATTRIBUTE25 in VARCHAR2
85 ,P_ECR_ATTRIBUTE26 in VARCHAR2
86 ,P_ECR_ATTRIBUTE27 in VARCHAR2
87 ,P_ECR_ATTRIBUTE28 in VARCHAR2
88 ,P_ECR_ATTRIBUTE29 in VARCHAR2
89 ,P_ECR_ATTRIBUTE30 in VARCHAR2
90 ,P_REQUEST_ID in NUMBER
91 ,P_PROGRAM_APPLICATION_ID in NUMBER
92 ,P_PROGRAM_ID in NUMBER
93 ,P_PROGRAM_UPDATE_DATE in DATE
94 ,P_OBJECT_VERSION_NUMBER in NUMBER
95 ,P_EFFECTIVE_DATE in DATE
96 )is
97 begin
98 hr_utility.set_location('Entering: BEN_ENROLLMENT_RATE_BK1.CREATE_ENROLLMENT_RATE_A', 10);
99 hr_utility.set_location(' Leaving: BEN_ENROLLMENT_RATE_BK1.CREATE_ENROLLMENT_RATE_A', 20);
100 end CREATE_ENROLLMENT_RATE_A;
101 procedure CREATE_ENROLLMENT_RATE_B
102 (P_ENRT_RT_ID in NUMBER
103 ,P_ORDR_NUM in NUMBER
104 ,P_ACTY_TYP_CD in VARCHAR2
105 ,P_TX_TYP_CD in VARCHAR2
106 ,P_CTFN_RQD_FLAG in VARCHAR2
107 ,P_DFLT_FLAG in VARCHAR2
108 ,P_DFLT_PNDG_CTFN_FLAG in VARCHAR2
109 ,P_DSPLY_ON_ENRT_FLAG in VARCHAR2
110 ,P_USE_TO_CALC_NET_FLX_CR_FLAG in VARCHAR2
111 ,P_ENTR_VAL_AT_ENRT_FLAG in VARCHAR2
112 ,P_ASN_ON_ENRT_FLAG in VARCHAR2
113 ,P_RL_CRS_ONLY_FLAG in VARCHAR2
114 ,P_DFLT_VAL in NUMBER
115 ,P_ANN_VAL in NUMBER
116 ,P_ANN_MN_ELCN_VAL in NUMBER
117 ,P_ANN_MX_ELCN_VAL in NUMBER
118 ,P_VAL in NUMBER
119 ,P_NNMNTRY_UOM in VARCHAR2
120 ,P_MX_ELCN_VAL in NUMBER
121 ,P_MN_ELCN_VAL in NUMBER
122 ,P_INCRMT_ELCN_VAL in NUMBER
123 ,P_CMCD_ACTY_REF_PERD_CD in VARCHAR2
124 ,P_CMCD_MN_ELCN_VAL in NUMBER
125 ,P_CMCD_MX_ELCN_VAL in NUMBER
126 ,P_CMCD_VAL in NUMBER
127 ,P_CMCD_DFLT_VAL in NUMBER
128 ,P_RT_USG_CD in VARCHAR2
129 ,P_ANN_DFLT_VAL in NUMBER
130 ,P_BNFT_RT_TYP_CD in VARCHAR2
131 ,P_RT_MLT_CD in VARCHAR2
132 ,P_DSPLY_MN_ELCN_VAL in NUMBER
133 ,P_DSPLY_MX_ELCN_VAL in NUMBER
134 ,P_ENTR_ANN_VAL_FLAG in VARCHAR2
135 ,P_RT_STRT_DT in DATE
136 ,P_RT_STRT_DT_CD in VARCHAR2
137 ,P_RT_STRT_DT_RL in NUMBER
138 ,P_RT_TYP_CD in VARCHAR2
139 ,P_ELIG_PER_ELCTBL_CHC_ID in NUMBER
140 ,P_ACTY_BASE_RT_ID in NUMBER
141 ,P_SPCL_RT_ENRT_RT_ID in NUMBER
142 ,P_ENRT_BNFT_ID in NUMBER
143 ,P_PRTT_RT_VAL_ID in NUMBER
144 ,P_DECR_BNFT_PRVDR_POOL_ID in NUMBER
145 ,P_CVG_AMT_CALC_MTHD_ID in NUMBER
146 ,P_ACTL_PREM_ID in NUMBER
147 ,P_COMP_LVL_FCTR_ID in NUMBER
148 ,P_PTD_COMP_LVL_FCTR_ID in NUMBER
149 ,P_CLM_COMP_LVL_FCTR_ID in NUMBER
150 ,P_BUSINESS_GROUP_ID in NUMBER
151 ,P_ISS_VAL in NUMBER
152 ,P_VAL_LAST_UPD_DATE in DATE
153 ,P_VAL_LAST_UPD_PERSON_ID in NUMBER
154 ,P_PP_IN_YR_USED_NUM in NUMBER
155 ,P_ECR_ATTRIBUTE_CATEGORY in VARCHAR2
156 ,P_ECR_ATTRIBUTE1 in VARCHAR2
157 ,P_ECR_ATTRIBUTE2 in VARCHAR2
158 ,P_ECR_ATTRIBUTE3 in VARCHAR2
159 ,P_ECR_ATTRIBUTE4 in VARCHAR2
160 ,P_ECR_ATTRIBUTE5 in VARCHAR2
161 ,P_ECR_ATTRIBUTE6 in VARCHAR2
162 ,P_ECR_ATTRIBUTE7 in VARCHAR2
163 ,P_ECR_ATTRIBUTE8 in VARCHAR2
164 ,P_ECR_ATTRIBUTE9 in VARCHAR2
165 ,P_ECR_ATTRIBUTE10 in VARCHAR2
166 ,P_ECR_ATTRIBUTE11 in VARCHAR2
167 ,P_ECR_ATTRIBUTE12 in VARCHAR2
168 ,P_ECR_ATTRIBUTE13 in VARCHAR2
169 ,P_ECR_ATTRIBUTE14 in VARCHAR2
170 ,P_ECR_ATTRIBUTE15 in VARCHAR2
171 ,P_ECR_ATTRIBUTE16 in VARCHAR2
172 ,P_ECR_ATTRIBUTE17 in VARCHAR2
173 ,P_ECR_ATTRIBUTE18 in VARCHAR2
174 ,P_ECR_ATTRIBUTE19 in VARCHAR2
175 ,P_ECR_ATTRIBUTE20 in VARCHAR2
176 ,P_ECR_ATTRIBUTE21 in VARCHAR2
177 ,P_ECR_ATTRIBUTE22 in VARCHAR2
178 ,P_ECR_ATTRIBUTE23 in VARCHAR2
179 ,P_ECR_ATTRIBUTE24 in VARCHAR2
180 ,P_ECR_ATTRIBUTE25 in VARCHAR2
181 ,P_ECR_ATTRIBUTE26 in VARCHAR2
182 ,P_ECR_ATTRIBUTE27 in VARCHAR2
183 ,P_ECR_ATTRIBUTE28 in VARCHAR2
184 ,P_ECR_ATTRIBUTE29 in VARCHAR2
185 ,P_ECR_ATTRIBUTE30 in VARCHAR2
186 ,P_REQUEST_ID in NUMBER
187 ,P_PROGRAM_APPLICATION_ID in NUMBER
188 ,P_PROGRAM_ID in NUMBER
189 ,P_PROGRAM_UPDATE_DATE in DATE
190 ,P_EFFECTIVE_DATE in DATE
191 )is
192 begin
193 hr_utility.set_location('Entering: BEN_ENROLLMENT_RATE_BK1.CREATE_ENROLLMENT_RATE_B', 10);
194 hr_utility.set_location(' Leaving: BEN_ENROLLMENT_RATE_BK1.CREATE_ENROLLMENT_RATE_B', 20);
195 end CREATE_ENROLLMENT_RATE_B;
196 end BEN_ENROLLMENT_RATE_BK1;