1 Package ben_elp_ins as
2 /* $Header: beelprhi.pkh 120.1.12000000.1 2007/01/19 05:29:30 appldev noship $ */
3
4 --
5 --|------------------------< set_base_key_value >----------------------------|
6 -- Description:
7 -- This procedure is called to register the next ID value from the database
8 -- sequence.
9 --
10 -- Prerequisites:
11 --
12 -- In Parameters:
13 -- Primary Key
14 --
15 -- Post Success:
16 --
17 -- Post Failure:
18 --
19 -- Developer Implementation Notes:
20 -- None.
21 --
22 -- Access Status:
23 -- Internal Development Use Only.
24
25 procedure set_base_key_value (p_eligy_prfl_id in number);
26
27 --
28 -- ----------------------------------------------------------------------------
29 -- |------------------------------< insert_dml >------------------------------|
30 -- ----------------------------------------------------------------------------
31 -- {Start Of Comments}
32 --
33 -- Description:
34 -- This procedure calls the dt_insert_dml control logic which handles
35 -- the actual datetrack dml.
36 --
37 -- Prerequisites:
38 -- This is an internal private procedure which must be called from the ins
39 -- procedure and must have all mandatory attributes set (except the
40 -- object_version_number which is initialised within the dt_insert_dml
41 -- procedure).
42 --
43 -- In Parameters:
44 -- A Pl/Sql record structre.
45 --
46 -- Post Success:
47 -- Processing contines.
48 --
49 -- Post Failure:
50 -- No specific error handling is required within this procedure.
51 --
52 -- Developer Implementation Notes:
53 -- None.
54 --
55 -- Access Status:
56 -- Internal Row Handler Use Only.
57 --
58 -- {End Of Comments}
59 -- ----------------------------------------------------------------------------
60 Procedure insert_dml
61 (p_rec in out nocopy ben_elp_shd.g_rec_type,
62 p_effective_date in date,
63 p_datetrack_mode in varchar2,
64 p_validation_start_date in date,
65 p_validation_end_date in date);
66 --
67 -- ----------------------------------------------------------------------------
68 -- |---------------------------------< ins >----------------------------------|
69 -- ----------------------------------------------------------------------------
70 -- {Start Of Comments}
71 --
72 -- Description:
73 -- This procedure is the record interface for the insert process
74 -- for the specified entity. The role of this process is to insert a fully
75 -- validated row, into the HR schema passing back to the calling process,
76 -- any system generated values (e.g. primary and object version number
77 -- attributes). This process is the main backbone of the ins business
78 -- process. The processing of this procedure is as follows:
79 -- 1) We must lock parent rows (if any exist).
80 -- 2) The controlling validation process insert_validate is then executed
81 -- which will execute all private and public validation business rule
82 -- processes.
83 -- 3) The pre_insert process is then executed which enables any
84 -- logic to be processed before the insert dml process is executed.
85 -- 4) The insert_dml process will physical perform the insert dml into the
86 -- specified entity.
87 -- 5) The post_insert process is then executed which enables any
88 -- logic to be processed after the insert dml process.
89 --
90 -- Prerequisites:
91 -- The main parameters to the process have to be in the record
92 -- format.
93 --
94 -- In Parameters:
95 -- p_effective_date
96 -- Specifies the date of the datetrack insert operation.
97 --
98 -- Post Success:
99 -- A fully validated row will be inserted into the specified entity
100 -- without being committed.
101 --
102 -- Post Failure:
103 -- If an error has occurred, an error message will be supplied with the work
104 -- rolled back.
105 --
106 -- Developer Implementation Notes:
107 -- None.
108 --
109 -- Access Status:
110 -- Internal Development Use Only.
111 --
112 -- {End Of Comments}
113 -- ----------------------------------------------------------------------------
114 Procedure ins
115 (
116 p_rec in out nocopy ben_elp_shd.g_rec_type,
117 p_effective_date in date
118 );
119 --
120 -- ----------------------------------------------------------------------------
121 -- |---------------------------------< ins >----------------------------------|
122 -- ----------------------------------------------------------------------------
123 -- {Start Of Comments}
124 --
125 -- Description:
126 -- This procedure is the attribute interface for the insert
127 -- process for the specified entity and is the outermost layer. The role
128 -- of this process is to insert a fully validated row into the HR schema
129 -- passing back to the calling process, any system generated values
130 -- (e.g. object version number attributes). The processing of this
131 -- procedure is as follows:
132 -- 1) The attributes are converted into a local record structure by
133 -- calling the convert_args function.
134 -- 2) After the conversion has taken place, the corresponding record ins
135 -- interface process is executed.
136 -- 3) OUT parameters are then set to their corresponding record attributes.
137 --
138 -- Prerequisites:
139 --
140 -- In Parameters:
141 -- p_effective_date
142 -- Specifies the date of the datetrack insert operation.
143 --
144 -- Post Success:
145 -- A fully validated row will be inserted for the specified entity
146 -- without being committed.
147 --
148 -- Post Failure:
149 -- If an error has occurred, an error message will be supplied with the work
150 -- rolled back.
151 --
152 -- Developer Implementation Notes:
153 -- None.
154 --
155 -- Access Status:
156 -- Internal Development Use Only.
157 --
158 -- {End Of Comments}
159 -- ----------------------------------------------------------------------------
160 Procedure ins
161 (
162 p_eligy_prfl_id out nocopy number,
163 p_effective_start_date out nocopy date,
164 p_effective_end_date out nocopy date,
165 p_name in varchar2,
166 p_description in varchar2 default null,
167 p_stat_cd in varchar2,
168 p_asmt_to_use_cd in varchar2,
169 p_elig_enrld_plip_flag in varchar2,
170 p_elig_cbr_quald_bnf_flag in varchar2,
171 p_elig_enrld_ptip_flag in varchar2,
172 p_elig_dpnt_cvrd_plip_flag in varchar2,
173 p_elig_dpnt_cvrd_ptip_flag in varchar2,
174 p_elig_dpnt_cvrd_pgm_flag in varchar2,
175 p_elig_job_flag in varchar2,
176 p_elig_hrly_slrd_flag in varchar2,
177 p_elig_pstl_cd_flag in varchar2,
178 p_elig_lbr_mmbr_flag in varchar2,
179 p_elig_lgl_enty_flag in varchar2,
180 p_elig_benfts_grp_flag in varchar2,
181 p_elig_wk_loc_flag in varchar2,
182 p_elig_brgng_unit_flag in varchar2,
183 p_elig_age_flag in varchar2,
184 p_elig_los_flag in varchar2,
185 p_elig_per_typ_flag in varchar2,
186 p_elig_fl_tm_pt_tm_flag in varchar2,
187 p_elig_ee_stat_flag in varchar2,
188 p_elig_grd_flag in varchar2,
189 p_elig_pct_fl_tm_flag in varchar2,
190 p_elig_asnt_set_flag in varchar2,
191 p_elig_hrs_wkd_flag in varchar2,
192 p_elig_comp_lvl_flag in varchar2,
193 p_elig_org_unit_flag in varchar2,
194 p_elig_loa_rsn_flag in varchar2,
195 p_elig_pyrl_flag in varchar2,
196 p_elig_schedd_hrs_flag in varchar2,
197 p_elig_py_bss_flag in varchar2,
198 p_eligy_prfl_rl_flag in varchar2,
199 p_elig_cmbn_age_los_flag in varchar2,
200 p_cntng_prtn_elig_prfl_flag in varchar2,
201 p_elig_prtt_pl_flag in varchar2,
202 p_elig_ppl_grp_flag in varchar2,
203 p_elig_svc_area_flag in varchar2,
204 p_elig_ptip_prte_flag in varchar2,
205 p_elig_no_othr_cvg_flag in varchar2,
206 p_elig_enrld_pl_flag in varchar2,
207 p_elig_enrld_oipl_flag in varchar2,
208 p_elig_enrld_pgm_flag in varchar2,
209 p_elig_dpnt_cvrd_pl_flag in varchar2,
210 p_elig_lvg_rsn_flag in varchar2,
211 p_elig_optd_mdcr_flag in varchar2,
212 p_elig_tbco_use_flag in varchar2,
213 p_elig_dpnt_othr_ptip_flag in varchar2,
214 p_business_group_id in number,
215 p_elp_attribute_category in varchar2 default null,
216 p_elp_attribute1 in varchar2 default null,
217 p_elp_attribute2 in varchar2 default null,
218 p_elp_attribute3 in varchar2 default null,
219 p_elp_attribute4 in varchar2 default null,
220 p_elp_attribute5 in varchar2 default null,
221 p_elp_attribute6 in varchar2 default null,
222 p_elp_attribute7 in varchar2 default null,
223 p_elp_attribute8 in varchar2 default null,
224 p_elp_attribute9 in varchar2 default null,
225 p_elp_attribute10 in varchar2 default null,
226 p_elp_attribute11 in varchar2 default null,
227 p_elp_attribute12 in varchar2 default null,
228 p_elp_attribute13 in varchar2 default null,
229 p_elp_attribute14 in varchar2 default null,
230 p_elp_attribute15 in varchar2 default null,
231 p_elp_attribute16 in varchar2 default null,
232 p_elp_attribute17 in varchar2 default null,
233 p_elp_attribute18 in varchar2 default null,
234 p_elp_attribute19 in varchar2 default null,
235 p_elp_attribute20 in varchar2 default null,
236 p_elp_attribute21 in varchar2 default null,
237 p_elp_attribute22 in varchar2 default null,
238 p_elp_attribute23 in varchar2 default null,
239 p_elp_attribute24 in varchar2 default null,
240 p_elp_attribute25 in varchar2 default null,
241 p_elp_attribute26 in varchar2 default null,
242 p_elp_attribute27 in varchar2 default null,
243 p_elp_attribute28 in varchar2 default null,
244 p_elp_attribute29 in varchar2 default null,
245 p_elp_attribute30 in varchar2 default null,
246 p_elig_mrtl_sts_flag in varchar2,
247 p_elig_gndr_flag in varchar2,
248 p_elig_dsblty_ctg_flag in varchar2,
249 p_elig_dsblty_rsn_flag in varchar2,
250 p_elig_dsblty_dgr_flag in varchar2,
251 p_elig_suppl_role_flag in varchar2,
252 p_elig_qual_titl_flag in varchar2,
253 p_elig_pstn_flag in varchar2,
254 p_elig_prbtn_perd_flag in varchar2,
255 p_elig_sp_clng_prg_pt_flag in varchar2,
256 p_bnft_cagr_prtn_cd in varchar2,
257 p_elig_dsbld_flag in varchar2,
258 p_elig_ttl_cvg_vol_flag in varchar2,
259 p_elig_ttl_prtt_flag in varchar2,
260 p_elig_comptncy_flag in varchar2,
261 p_elig_hlth_cvg_flag in varchar2,
262 p_elig_anthr_pl_flag in varchar2,
263 p_elig_qua_in_gr_flag in varchar2,
264 p_elig_perf_rtng_flag in varchar2,
265 p_elig_crit_values_flag in varchar2, /* RBC */
266 p_object_version_number out nocopy number,
267 p_effective_date in date
268 );
269 --
270 end ben_elp_ins;