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_CWB_PL_DSGN_BK1

Source


1 package body BEN_CWB_PL_DSGN_BK1 as
2 /* $Header: becpdapi.pkb 120.1 2006/01/04 01:43:14 generated noship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2007/01/03 21:30:54 (YYYY/MM/DD HH24:MI:SS)
5 procedure CREATE_PLAN_OR_OPTION_A
6 (P_PL_ID in NUMBER
7 ,P_OIPL_ID in NUMBER
8 ,P_LF_EVT_OCRD_DT in DATE
9 ,P_EFFECTIVE_DATE in DATE
10 ,P_NAME in VARCHAR2
11 ,P_GROUP_PL_ID in NUMBER
12 ,P_GROUP_OIPL_ID in NUMBER
13 ,P_OPT_HIDDEN_FLAG in VARCHAR2
14 ,P_OPT_ID in NUMBER
15 ,P_PL_UOM in VARCHAR2
16 ,P_PL_ORDR_NUM in NUMBER
17 ,P_OIPL_ORDR_NUM in NUMBER
18 ,P_PL_XCHG_RATE in NUMBER
19 ,P_OPT_COUNT in NUMBER
20 ,P_USES_BDGT_FLAG in VARCHAR2
21 ,P_PRSRV_BDGT_CD in VARCHAR2
22 ,P_UPD_START_DT in DATE
23 ,P_UPD_END_DT in DATE
24 ,P_APPROVAL_MODE in VARCHAR2
25 ,P_ENRT_PERD_START_DT in DATE
26 ,P_ENRT_PERD_END_DT in DATE
27 ,P_YR_PERD_START_DT in DATE
28 ,P_YR_PERD_END_DT in DATE
29 ,P_WTHN_YR_START_DT in DATE
30 ,P_WTHN_YR_END_DT in DATE
31 ,P_ENRT_PERD_ID in NUMBER
32 ,P_YR_PERD_ID in NUMBER
33 ,P_BUSINESS_GROUP_ID in NUMBER
34 ,P_PERF_REVW_STRT_DT in DATE
35 ,P_ASG_UPDT_EFF_DATE in DATE
36 ,P_EMP_INTERVIEW_TYP_CD in VARCHAR2
37 ,P_SALARY_CHANGE_REASON in VARCHAR2
38 ,P_WS_ABR_ID in NUMBER
39 ,P_WS_NNMNTRY_UOM in VARCHAR2
40 ,P_WS_RNDG_CD in VARCHAR2
41 ,P_WS_SUB_ACTY_TYP_CD in VARCHAR2
42 ,P_DIST_BDGT_ABR_ID in NUMBER
43 ,P_DIST_BDGT_NNMNTRY_UOM in VARCHAR2
44 ,P_DIST_BDGT_RNDG_CD in VARCHAR2
45 ,P_WS_BDGT_ABR_ID in NUMBER
46 ,P_WS_BDGT_NNMNTRY_UOM in VARCHAR2
47 ,P_WS_BDGT_RNDG_CD in VARCHAR2
48 ,P_RSRV_ABR_ID in NUMBER
49 ,P_RSRV_NNMNTRY_UOM in VARCHAR2
50 ,P_RSRV_RNDG_CD in VARCHAR2
51 ,P_ELIG_SAL_ABR_ID in NUMBER
52 ,P_ELIG_SAL_NNMNTRY_UOM in VARCHAR2
53 ,P_ELIG_SAL_RNDG_CD in VARCHAR2
54 ,P_MISC1_ABR_ID in NUMBER
55 ,P_MISC1_NNMNTRY_UOM in VARCHAR2
56 ,P_MISC1_RNDG_CD in VARCHAR2
57 ,P_MISC2_ABR_ID in NUMBER
58 ,P_MISC2_NNMNTRY_UOM in VARCHAR2
59 ,P_MISC2_RNDG_CD in VARCHAR2
60 ,P_MISC3_ABR_ID in NUMBER
61 ,P_MISC3_NNMNTRY_UOM in VARCHAR2
62 ,P_MISC3_RNDG_CD in VARCHAR2
63 ,P_STAT_SAL_ABR_ID in NUMBER
64 ,P_STAT_SAL_NNMNTRY_UOM in VARCHAR2
65 ,P_STAT_SAL_RNDG_CD in VARCHAR2
66 ,P_REC_ABR_ID in NUMBER
67 ,P_REC_NNMNTRY_UOM in VARCHAR2
68 ,P_REC_RNDG_CD in VARCHAR2
69 ,P_TOT_COMP_ABR_ID in NUMBER
70 ,P_TOT_COMP_NNMNTRY_UOM in VARCHAR2
71 ,P_TOT_COMP_RNDG_CD in VARCHAR2
72 ,P_OTH_COMP_ABR_ID in NUMBER
73 ,P_OTH_COMP_NNMNTRY_UOM in VARCHAR2
74 ,P_OTH_COMP_RNDG_CD in VARCHAR2
75 ,P_ACTUAL_FLAG in VARCHAR2
76 ,P_ACTY_REF_PERD_CD in VARCHAR2
77 ,P_LEGISLATION_CODE in VARCHAR2
78 ,P_PL_ANNULIZATION_FACTOR in NUMBER
79 ,P_PL_STAT_CD in VARCHAR2
80 ,P_UOM_PRECISION in NUMBER
81 ,P_WS_ELEMENT_TYPE_ID in NUMBER
82 ,P_WS_INPUT_VALUE_ID in NUMBER
83 ,P_DATA_FREEZE_DATE in DATE
84 ,P_WS_AMT_EDIT_CD in VARCHAR2
85 ,P_WS_AMT_EDIT_ENF_CD_FOR_NUL in VARCHAR2
86 ,P_WS_OVER_BUDGET_EDIT_CD in VARCHAR2
87 ,P_WS_OVER_BUDGET_TOL_PCT in NUMBER
88 ,P_BDGT_OVER_BUDGET_EDIT_CD in VARCHAR2
89 ,P_BDGT_OVER_BUDGET_TOL_PCT in NUMBER
90 ,P_AUTO_DISTR_FLAG in VARCHAR2
91 ,P_PQH_DOCUMENT_SHORT_NAME in VARCHAR2
92 ,P_OBJECT_VERSION_NUMBER in NUMBER
93 ,P_OVRID_RT_STRT_DT in DATE
94 ,P_DO_NOT_PROCESS_FLAG in VARCHAR2
95 ,P_OVR_PERF_REVW_STRT_DT in DATE
96 )is
97 begin
98 hr_utility.set_location('Entering: BEN_CWB_PL_DSGN_BK1.CREATE_PLAN_OR_OPTION_A', 10);
99 hr_utility.set_location(' Leaving: BEN_CWB_PL_DSGN_BK1.CREATE_PLAN_OR_OPTION_A', 20);
100 end CREATE_PLAN_OR_OPTION_A;
101 procedure CREATE_PLAN_OR_OPTION_B
102 (P_PL_ID in NUMBER
103 ,P_OIPL_ID in NUMBER
104 ,P_LF_EVT_OCRD_DT in DATE
105 ,P_EFFECTIVE_DATE in DATE
106 ,P_NAME in VARCHAR2
107 ,P_GROUP_PL_ID in NUMBER
108 ,P_GROUP_OIPL_ID in NUMBER
109 ,P_OPT_HIDDEN_FLAG in VARCHAR2
110 ,P_OPT_ID in NUMBER
111 ,P_PL_UOM in VARCHAR2
112 ,P_PL_ORDR_NUM in NUMBER
113 ,P_OIPL_ORDR_NUM in NUMBER
114 ,P_PL_XCHG_RATE in NUMBER
115 ,P_OPT_COUNT in NUMBER
116 ,P_USES_BDGT_FLAG in VARCHAR2
117 ,P_PRSRV_BDGT_CD in VARCHAR2
118 ,P_UPD_START_DT in DATE
119 ,P_UPD_END_DT in DATE
120 ,P_APPROVAL_MODE in VARCHAR2
121 ,P_ENRT_PERD_START_DT in DATE
122 ,P_ENRT_PERD_END_DT in DATE
123 ,P_YR_PERD_START_DT in DATE
124 ,P_YR_PERD_END_DT in DATE
125 ,P_WTHN_YR_START_DT in DATE
126 ,P_WTHN_YR_END_DT in DATE
127 ,P_ENRT_PERD_ID in NUMBER
128 ,P_YR_PERD_ID in NUMBER
129 ,P_BUSINESS_GROUP_ID in NUMBER
130 ,P_PERF_REVW_STRT_DT in DATE
131 ,P_ASG_UPDT_EFF_DATE in DATE
132 ,P_EMP_INTERVIEW_TYP_CD in VARCHAR2
133 ,P_SALARY_CHANGE_REASON in VARCHAR2
134 ,P_WS_ABR_ID in NUMBER
135 ,P_WS_NNMNTRY_UOM in VARCHAR2
136 ,P_WS_RNDG_CD in VARCHAR2
137 ,P_WS_SUB_ACTY_TYP_CD in VARCHAR2
138 ,P_DIST_BDGT_ABR_ID in NUMBER
139 ,P_DIST_BDGT_NNMNTRY_UOM in VARCHAR2
140 ,P_DIST_BDGT_RNDG_CD in VARCHAR2
141 ,P_WS_BDGT_ABR_ID in NUMBER
142 ,P_WS_BDGT_NNMNTRY_UOM in VARCHAR2
143 ,P_WS_BDGT_RNDG_CD in VARCHAR2
144 ,P_RSRV_ABR_ID in NUMBER
145 ,P_RSRV_NNMNTRY_UOM in VARCHAR2
146 ,P_RSRV_RNDG_CD in VARCHAR2
147 ,P_ELIG_SAL_ABR_ID in NUMBER
148 ,P_ELIG_SAL_NNMNTRY_UOM in VARCHAR2
149 ,P_ELIG_SAL_RNDG_CD in VARCHAR2
150 ,P_MISC1_ABR_ID in NUMBER
151 ,P_MISC1_NNMNTRY_UOM in VARCHAR2
152 ,P_MISC1_RNDG_CD in VARCHAR2
153 ,P_MISC2_ABR_ID in NUMBER
154 ,P_MISC2_NNMNTRY_UOM in VARCHAR2
155 ,P_MISC2_RNDG_CD in VARCHAR2
156 ,P_MISC3_ABR_ID in NUMBER
157 ,P_MISC3_NNMNTRY_UOM in VARCHAR2
158 ,P_MISC3_RNDG_CD in VARCHAR2
159 ,P_STAT_SAL_ABR_ID in NUMBER
160 ,P_STAT_SAL_NNMNTRY_UOM in VARCHAR2
161 ,P_STAT_SAL_RNDG_CD in VARCHAR2
162 ,P_REC_ABR_ID in NUMBER
163 ,P_REC_NNMNTRY_UOM in VARCHAR2
164 ,P_REC_RNDG_CD in VARCHAR2
165 ,P_TOT_COMP_ABR_ID in NUMBER
166 ,P_TOT_COMP_NNMNTRY_UOM in VARCHAR2
167 ,P_TOT_COMP_RNDG_CD in VARCHAR2
168 ,P_OTH_COMP_ABR_ID in NUMBER
169 ,P_OTH_COMP_NNMNTRY_UOM in VARCHAR2
170 ,P_OTH_COMP_RNDG_CD in VARCHAR2
171 ,P_ACTUAL_FLAG in VARCHAR2
172 ,P_ACTY_REF_PERD_CD in VARCHAR2
173 ,P_LEGISLATION_CODE in VARCHAR2
174 ,P_PL_ANNULIZATION_FACTOR in NUMBER
175 ,P_PL_STAT_CD in VARCHAR2
176 ,P_UOM_PRECISION in NUMBER
177 ,P_WS_ELEMENT_TYPE_ID in NUMBER
178 ,P_WS_INPUT_VALUE_ID in NUMBER
179 ,P_DATA_FREEZE_DATE in DATE
180 ,P_WS_AMT_EDIT_CD in VARCHAR2
181 ,P_WS_AMT_EDIT_ENF_CD_FOR_NUL in VARCHAR2
182 ,P_WS_OVER_BUDGET_EDIT_CD in VARCHAR2
183 ,P_WS_OVER_BUDGET_TOL_PCT in NUMBER
184 ,P_BDGT_OVER_BUDGET_EDIT_CD in VARCHAR2
185 ,P_BDGT_OVER_BUDGET_TOL_PCT in NUMBER
186 ,P_AUTO_DISTR_FLAG in VARCHAR2
187 ,P_PQH_DOCUMENT_SHORT_NAME in VARCHAR2
188 ,P_OVRID_RT_STRT_DT in DATE
189 ,P_DO_NOT_PROCESS_FLAG in VARCHAR2
190 ,P_OVR_PERF_REVW_STRT_DT in DATE
191 )is
192 begin
193 hr_utility.set_location('Entering: BEN_CWB_PL_DSGN_BK1.CREATE_PLAN_OR_OPTION_B', 10);
194 hr_utility.set_location(' Leaving: BEN_CWB_PL_DSGN_BK1.CREATE_PLAN_OR_OPTION_B', 20);
195 end CREATE_PLAN_OR_OPTION_B;
196 end BEN_CWB_PL_DSGN_BK1;