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_OPTION_IN_PLAN_BK2

Source


1 package body BEN_OPTION_IN_PLAN_BK2 as
2 /* $Header: becopapi.pkb 120.0 2005/05/28 01:09:51 generated noship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2007/01/03 21:30:53 (YYYY/MM/DD HH24:MI:SS)
5 procedure UPDATE_OPTION_IN_PLAN_A
6 (P_OIPL_ID in NUMBER
7 ,P_EFFECTIVE_START_DATE in DATE
8 ,P_EFFECTIVE_END_DATE in DATE
9 ,P_IVR_IDENT in VARCHAR2
10 ,P_URL_REF_NAME in VARCHAR2
11 ,P_OPT_ID in NUMBER
12 ,P_BUSINESS_GROUP_ID in NUMBER
13 ,P_PL_ID in NUMBER
14 ,P_ORDR_NUM in NUMBER
15 ,P_RQD_PERD_ENRT_NENRT_VAL in NUMBER
16 ,P_DFLT_FLAG in VARCHAR2
17 ,P_ACTL_PREM_ID in NUMBER
18 ,P_MNDTRY_FLAG in VARCHAR2
19 ,P_OIPL_STAT_CD in VARCHAR2
20 ,P_PCP_DSGN_CD in VARCHAR2
21 ,P_PCP_DPNT_DSGN_CD in VARCHAR2
22 ,P_RQD_PERD_ENRT_NENRT_UOM in VARCHAR2
23 ,P_ELIG_APLS_FLAG in VARCHAR2
24 ,P_DFLT_ENRT_DET_RL in NUMBER
25 ,P_TRK_INELIG_PER_FLAG in VARCHAR2
26 ,P_DRVBL_FCTR_PRTN_ELIG_FLAG in VARCHAR2
27 ,P_MNDTRY_RL in NUMBER
28 ,P_RQD_PERD_ENRT_NENRT_RL in NUMBER
29 ,P_DFLT_ENRT_CD in VARCHAR2
30 ,P_PRTN_ELIG_OVRID_ALWD_FLAG in VARCHAR2
31 ,P_DRVBL_FCTR_APLS_RTS_FLAG in VARCHAR2
32 ,P_PER_CVRD_CD in VARCHAR2
33 ,P_POSTELCN_EDIT_RL in NUMBER
34 ,P_VRFY_FMLY_MMBR_CD in VARCHAR2
35 ,P_VRFY_FMLY_MMBR_RL in NUMBER
36 ,P_ENRT_CD in VARCHAR2
37 ,P_ENRT_RL in NUMBER
38 ,P_AUTO_ENRT_FLAG in VARCHAR2
39 ,P_AUTO_ENRT_MTHD_RL in NUMBER
40 ,P_SHORT_NAME in VARCHAR2
41 ,P_SHORT_CODE in VARCHAR2
42 ,P_LEGISLATION_CODE in VARCHAR2
43 ,P_LEGISLATION_SUBGROUP in VARCHAR2
44 ,P_HIDDEN_FLAG in VARCHAR2
45 ,P_SUSP_IF_CTFN_NOT_PRVD_FLAG in VARCHAR2
46 ,P_CTFN_DETERMINE_CD in VARCHAR2
47 ,P_COP_ATTRIBUTE_CATEGORY in VARCHAR2
48 ,P_COP_ATTRIBUTE1 in VARCHAR2
49 ,P_COP_ATTRIBUTE2 in VARCHAR2
50 ,P_COP_ATTRIBUTE3 in VARCHAR2
51 ,P_COP_ATTRIBUTE4 in VARCHAR2
52 ,P_COP_ATTRIBUTE5 in VARCHAR2
53 ,P_COP_ATTRIBUTE6 in VARCHAR2
54 ,P_COP_ATTRIBUTE7 in VARCHAR2
55 ,P_COP_ATTRIBUTE8 in VARCHAR2
56 ,P_COP_ATTRIBUTE9 in VARCHAR2
57 ,P_COP_ATTRIBUTE10 in VARCHAR2
58 ,P_COP_ATTRIBUTE11 in VARCHAR2
59 ,P_COP_ATTRIBUTE12 in VARCHAR2
60 ,P_COP_ATTRIBUTE13 in VARCHAR2
61 ,P_COP_ATTRIBUTE14 in VARCHAR2
62 ,P_COP_ATTRIBUTE15 in VARCHAR2
63 ,P_COP_ATTRIBUTE16 in VARCHAR2
64 ,P_COP_ATTRIBUTE17 in VARCHAR2
65 ,P_COP_ATTRIBUTE18 in VARCHAR2
66 ,P_COP_ATTRIBUTE19 in VARCHAR2
67 ,P_COP_ATTRIBUTE20 in VARCHAR2
68 ,P_COP_ATTRIBUTE21 in VARCHAR2
69 ,P_COP_ATTRIBUTE22 in VARCHAR2
70 ,P_COP_ATTRIBUTE23 in VARCHAR2
71 ,P_COP_ATTRIBUTE24 in VARCHAR2
72 ,P_COP_ATTRIBUTE25 in VARCHAR2
73 ,P_COP_ATTRIBUTE26 in VARCHAR2
74 ,P_COP_ATTRIBUTE27 in VARCHAR2
75 ,P_COP_ATTRIBUTE28 in VARCHAR2
76 ,P_COP_ATTRIBUTE29 in VARCHAR2
77 ,P_COP_ATTRIBUTE30 in VARCHAR2
78 ,P_OBJECT_VERSION_NUMBER in NUMBER
79 ,P_EFFECTIVE_DATE in DATE
80 ,P_DATETRACK_MODE in VARCHAR2
81 )is
82 begin
83 hr_utility.set_location('Entering: BEN_OPTION_IN_PLAN_BK2.UPDATE_OPTION_IN_PLAN_A', 10);
84 hr_utility.set_location(' Leaving: BEN_OPTION_IN_PLAN_BK2.UPDATE_OPTION_IN_PLAN_A', 20);
85 end UPDATE_OPTION_IN_PLAN_A;
86 procedure UPDATE_OPTION_IN_PLAN_B
87 (P_OIPL_ID in NUMBER
88 ,P_IVR_IDENT in VARCHAR2
89 ,P_URL_REF_NAME in VARCHAR2
90 ,P_OPT_ID in NUMBER
91 ,P_BUSINESS_GROUP_ID in NUMBER
92 ,P_PL_ID in NUMBER
93 ,P_ORDR_NUM in NUMBER
94 ,P_RQD_PERD_ENRT_NENRT_VAL in NUMBER
95 ,P_DFLT_FLAG in VARCHAR2
96 ,P_ACTL_PREM_ID in NUMBER
97 ,P_MNDTRY_FLAG in VARCHAR2
98 ,P_OIPL_STAT_CD in VARCHAR2
99 ,P_PCP_DSGN_CD in VARCHAR2
100 ,P_PCP_DPNT_DSGN_CD in VARCHAR2
101 ,P_RQD_PERD_ENRT_NENRT_UOM in VARCHAR2
102 ,P_ELIG_APLS_FLAG in VARCHAR2
103 ,P_DFLT_ENRT_DET_RL in NUMBER
104 ,P_TRK_INELIG_PER_FLAG in VARCHAR2
105 ,P_DRVBL_FCTR_PRTN_ELIG_FLAG in VARCHAR2
106 ,P_MNDTRY_RL in NUMBER
107 ,P_RQD_PERD_ENRT_NENRT_RL in NUMBER
108 ,P_DFLT_ENRT_CD in VARCHAR2
109 ,P_PRTN_ELIG_OVRID_ALWD_FLAG in VARCHAR2
110 ,P_DRVBL_FCTR_APLS_RTS_FLAG in VARCHAR2
111 ,P_PER_CVRD_CD in VARCHAR2
112 ,P_POSTELCN_EDIT_RL in NUMBER
113 ,P_VRFY_FMLY_MMBR_CD in VARCHAR2
114 ,P_VRFY_FMLY_MMBR_RL in NUMBER
115 ,P_ENRT_CD in VARCHAR2
116 ,P_ENRT_RL in NUMBER
117 ,P_AUTO_ENRT_FLAG in VARCHAR2
118 ,P_AUTO_ENRT_MTHD_RL in NUMBER
119 ,P_SHORT_NAME in VARCHAR2
120 ,P_SHORT_CODE in VARCHAR2
121 ,P_LEGISLATION_CODE in VARCHAR2
122 ,P_LEGISLATION_SUBGROUP in VARCHAR2
123 ,P_HIDDEN_FLAG in VARCHAR2
124 ,P_SUSP_IF_CTFN_NOT_PRVD_FLAG in VARCHAR2
125 ,P_CTFN_DETERMINE_CD in VARCHAR2
126 ,P_COP_ATTRIBUTE_CATEGORY in VARCHAR2
127 ,P_COP_ATTRIBUTE1 in VARCHAR2
128 ,P_COP_ATTRIBUTE2 in VARCHAR2
129 ,P_COP_ATTRIBUTE3 in VARCHAR2
130 ,P_COP_ATTRIBUTE4 in VARCHAR2
131 ,P_COP_ATTRIBUTE5 in VARCHAR2
132 ,P_COP_ATTRIBUTE6 in VARCHAR2
133 ,P_COP_ATTRIBUTE7 in VARCHAR2
134 ,P_COP_ATTRIBUTE8 in VARCHAR2
135 ,P_COP_ATTRIBUTE9 in VARCHAR2
136 ,P_COP_ATTRIBUTE10 in VARCHAR2
137 ,P_COP_ATTRIBUTE11 in VARCHAR2
138 ,P_COP_ATTRIBUTE12 in VARCHAR2
139 ,P_COP_ATTRIBUTE13 in VARCHAR2
140 ,P_COP_ATTRIBUTE14 in VARCHAR2
141 ,P_COP_ATTRIBUTE15 in VARCHAR2
142 ,P_COP_ATTRIBUTE16 in VARCHAR2
143 ,P_COP_ATTRIBUTE17 in VARCHAR2
144 ,P_COP_ATTRIBUTE18 in VARCHAR2
145 ,P_COP_ATTRIBUTE19 in VARCHAR2
146 ,P_COP_ATTRIBUTE20 in VARCHAR2
147 ,P_COP_ATTRIBUTE21 in VARCHAR2
148 ,P_COP_ATTRIBUTE22 in VARCHAR2
149 ,P_COP_ATTRIBUTE23 in VARCHAR2
150 ,P_COP_ATTRIBUTE24 in VARCHAR2
151 ,P_COP_ATTRIBUTE25 in VARCHAR2
152 ,P_COP_ATTRIBUTE26 in VARCHAR2
153 ,P_COP_ATTRIBUTE27 in VARCHAR2
154 ,P_COP_ATTRIBUTE28 in VARCHAR2
155 ,P_COP_ATTRIBUTE29 in VARCHAR2
156 ,P_COP_ATTRIBUTE30 in VARCHAR2
157 ,P_OBJECT_VERSION_NUMBER in NUMBER
158 ,P_EFFECTIVE_DATE in DATE
159 ,P_DATETRACK_MODE in VARCHAR2
160 )is
161 begin
162 hr_utility.set_location('Entering: BEN_OPTION_IN_PLAN_BK2.UPDATE_OPTION_IN_PLAN_B', 10);
163 hr_utility.set_location(' Leaving: BEN_OPTION_IN_PLAN_BK2.UPDATE_OPTION_IN_PLAN_B', 20);
164 end UPDATE_OPTION_IN_PLAN_B;
165 end BEN_OPTION_IN_PLAN_BK2;