1 Package hr_psf_ins AUTHID CURRENT_USER as
2 /* $Header: hrpsfrhi.pkh 120.3.12020000.2 2013/04/19 03:06:04 pathota ship $ */
3 --
4 --
5 g_debug boolean := hr_utility.debug_enabled;
6 --
7 --
8 -- ----------------------------------------------------------------------------
9 -- |------------------------< set_base_key_value >----------------------------|
10 -- ----------------------------------------------------------------------------
11 -- {Start of Comments}
12 -- Description:
13 -- This procedure is called to register the next ID value from the database
14 -- sequence.
15 --
16 -- Prerequisites:
17 --
18 -- In Parameters:
19 -- Primary Key
20 --
21 -- Post Success:
22 --
23 -- Post Failure:
24 --
25 -- Developer Implementation Notes:
26 -- None.
27 --
28 -- Access Status:
29 -- Internal Development Use Only.
30 --
31 -- {End of Comments}
32 -- ----------------------------------------------------------------------------
33 procedure set_base_key_value
34 (p_position_id in number);
35 --
36 --
37 -- ----------------------------------------------------------------------------
38 -- |------------------------------< insert_dml >------------------------------|
39 -- ----------------------------------------------------------------------------
40 -- {Start Of Comments}
41 --
42 -- Description:
43 -- This procedure calls the dt_insert_dml control logic which handles
44 -- the actual datetrack dml.
45 --
46 -- Prerequisites:
47 -- This is an internal private procedure which must be called from the ins
48 -- procedure and must have all mandatory attributes set (except the
49 -- object_version_number which is initialised within the dt_insert_dml
50 -- procedure).
51 --
52 -- In Parameters:
53 -- A Pl/Sql record structre.
54 --
55 -- Post Success:
56 -- Processing contines.
57 --
58 -- Post Failure:
59 -- No specific error handling is required within this procedure.
60 --
61 -- Developer Implementation Notes:
62 -- None.
63 --
64 -- Access Status:
65 -- Internal Row Handler Use Only.
66 --
67 -- {End Of Comments}
68 -- ----------------------------------------------------------------------------
69 Procedure insert_dml
70 (p_rec in out nocopy hr_psf_shd.g_rec_type,
71 p_effective_date in date,
72 p_datetrack_mode in varchar2,
73 p_validation_start_date in date,
74 p_validation_end_date in date);
75 --
76 -- ----------------------------------------------------------------------------
77 -- |---------------------------------< ins >----------------------------------|
78 -- ----------------------------------------------------------------------------
79 -- {Start Of Comments}
80 --
81 -- Description:
82 -- This procedure is the record interface for the insert process
83 -- for the specified entity. The role of this process is to insert a fully
84 -- validated row, into the HR schema passing back to the calling process,
85 -- any system generated values (e.g. primary and object version number
86 -- attributes). This process is the main backbone of the ins business
87 -- process. The processing of this procedure is as follows:
88 -- 1) We must lock parent rows (if any exist).
89 -- 2) The controlling validation process insert_validate is then executed
90 -- which will execute all private and public validation business rule
91 -- processes.
92 -- 3) The pre_insert process is then executed which enables any
93 -- logic to be processed before the insert dml process is executed.
94 -- 4) The insert_dml process will physical perform the insert dml into the
95 -- specified entity.
96 -- 5) The post_insert process is then executed which enables any
97 -- logic to be processed after the insert dml process.
98 --
99 -- Prerequisites:
100 -- The main parameters to the process have to be in the record
101 -- format.
102 --
103 -- In Parameters:
104 -- p_effective_date
105 -- Specifies the date of the datetrack insert operation.
106 --
107 -- Post Success:
108 -- A fully validated row will be inserted into the specified entity
109 -- without being committed.
110 --
111 -- Post Failure:
112 -- If an error has occurred, an error message will be supplied with the work
113 -- rolled back.
114 --
115 -- Developer Implementation Notes:
116 -- None.
117 --
118 -- Access Status:
119 -- Internal Development Use Only.
120 --
121 -- {End Of Comments}
122 -- ----------------------------------------------------------------------------
123 Procedure ins
124 (
125 p_rec in out nocopy hr_psf_shd.g_rec_type,
126 p_effective_date in date,
127 p_validate in boolean default false
128 );
129 --
130 -- ----------------------------------------------------------------------------
131 -- |---------------------------------< ins >----------------------------------|
132 -- ----------------------------------------------------------------------------
133 -- {Start Of Comments}
134 --
135 -- Description:
136 -- This procedure is the attribute interface for the insert
137 -- process for the specified entity and is the outermost layer. The role
138 -- of this process is to insert a fully validated row into the HR schema
139 -- passing back to the calling process, any system generated values
140 -- (e.g. object version number attributes). The processing of this
141 -- procedure is as follows:
142 -- 1) The attributes are converted into a local record structure by
143 -- calling the convert_args function.
144 -- 2) After the conversion has taken place, the corresponding record ins
145 -- interface process is executed.
146 -- 3) OUT parameters are then set to their corresponding record attributes.
147 --
148 -- Prerequisites:
149 --
150 -- In Parameters:
151 -- p_effective_date
152 -- Specifies the date of the datetrack insert operation.
153 --
154 -- Post Success:
155 -- A fully validated row will be inserted for the specified entity
156 -- without being committed.
157 --
158 -- Post Failure:
159 -- If an error has occurred, an error message will be supplied with the work
160 -- rolled back.
161 --
162 -- Developer Implementation Notes:
163 -- None.
164 --
165 -- Access Status:
166 -- Internal Development Use Only.
167 --
168 -- {End Of Comments}
169 -- ----------------------------------------------------------------------------
170 Procedure ins
171 (
172 p_position_id out nocopy number,
173 p_effective_start_date out nocopy date,
174 p_effective_end_date out nocopy date,
175 p_availability_status_id in number default null,
176 p_business_group_id in number,
177 p_entry_step_id in number default null,
178 p_entry_grade_rule_id in number default null,
179 p_job_id in number,
180 p_location_id in number default null,
181 p_organization_id in number,
182 p_pay_freq_payroll_id in number default null,
183 p_position_definition_id in number,
184 p_position_transaction_id in number default null,
185 p_prior_position_id in number default null,
186 p_relief_position_id in number default null,
187 p_entry_grade_id in number default null,
188 p_successor_position_id in number default null,
189 p_supervisor_position_id in number default null,
190 p_amendment_date in date default null,
191 p_amendment_recommendation in varchar2 default null,
192 p_amendment_ref_number in varchar2 default null,
193 p_bargaining_unit_cd in varchar2 default null,
194 p_comments in varchar2 default null,
195 p_current_job_prop_end_date in date default null,
196 p_current_org_prop_end_date in date default null,
197 p_avail_status_prop_end_date in date default null,
198 p_date_effective in date,
199 p_date_end in date default null,
200 p_earliest_hire_date in date default null,
201 p_fill_by_date in date default null,
202 p_frequency in varchar2 default null,
203 p_fte in number default null,
204 p_max_persons in number default null,
205 p_name in varchar2 default null,
206 p_overlap_period in number default null,
207 p_overlap_unit_cd in varchar2 default null,
208 p_pay_term_end_day_cd in varchar2 default null,
209 p_pay_term_end_month_cd in varchar2 default null,
210 p_permanent_temporary_flag in varchar2 default null,
211 p_permit_recruitment_flag in varchar2 default null,
212 p_position_type in varchar2 default null,
213 p_posting_description in varchar2 default null,
214 p_probation_period in number default null,
215 p_probation_period_unit_cd in varchar2 default null,
216 p_replacement_required_flag in varchar2 default null,
217 p_review_flag in varchar2 default null,
218 p_seasonal_flag in varchar2 default null,
219 p_security_requirements in varchar2 default null,
220 p_status in varchar2 default null,
221 p_term_start_day_cd in varchar2 default null,
222 p_term_start_month_cd in varchar2 default null,
223 p_time_normal_finish in varchar2 default null,
224 p_time_normal_start in varchar2 default null,
225 p_update_source_cd in varchar2 default null,
226 p_working_hours in number default null,
227 p_works_council_approval_flag in varchar2 default null,
228 p_work_period_type_cd in varchar2 default null,
229 p_work_term_end_day_cd in varchar2 default null,
230 p_work_term_end_month_cd in varchar2 default null,
231 p_proposed_fte_for_layoff in number default null,
232 p_proposed_date_for_layoff in date default null,
233 p_pay_basis_id in number default null,
234 p_supervisor_id in number default null,
235 p_copied_to_old_table_flag in varchar2 default null,
236 p_information1 in varchar2 default null,
237 p_information2 in varchar2 default null,
238 p_information3 in varchar2 default null,
239 p_information4 in varchar2 default null,
240 p_information5 in varchar2 default null,
241 p_information6 in varchar2 default null,
242 p_information7 in varchar2 default null,
243 p_information8 in varchar2 default null,
244 p_information9 in varchar2 default null,
245 p_information10 in varchar2 default null,
246 p_information11 in varchar2 default null,
247 p_information12 in varchar2 default null,
248 p_information13 in varchar2 default null,
249 p_information14 in varchar2 default null,
250 p_information15 in varchar2 default null,
251 p_information16 in varchar2 default null,
252 p_information17 in varchar2 default null,
253 p_information18 in varchar2 default null,
254 p_information19 in varchar2 default null,
255 p_information20 in varchar2 default null,
256 p_information21 in varchar2 default null,
257 p_information22 in varchar2 default null,
258 p_information23 in varchar2 default null,
259 p_information24 in varchar2 default null,
260 p_information25 in varchar2 default null,
261 p_information26 in varchar2 default null,
262 p_information27 in varchar2 default null,
263 p_information28 in varchar2 default null,
264 p_information29 in varchar2 default null,
265 p_information30 in varchar2 default null,
266 p_information_category in varchar2 default null,
267 p_attribute1 in varchar2 default null,
268 p_attribute2 in varchar2 default null,
269 p_attribute3 in varchar2 default null,
270 p_attribute4 in varchar2 default null,
271 p_attribute5 in varchar2 default null,
272 p_attribute6 in varchar2 default null,
273 p_attribute7 in varchar2 default null,
274 p_attribute8 in varchar2 default null,
275 p_attribute9 in varchar2 default null,
276 p_attribute10 in varchar2 default null,
277 p_attribute11 in varchar2 default null,
278 p_attribute12 in varchar2 default null,
279 p_attribute13 in varchar2 default null,
280 p_attribute14 in varchar2 default null,
281 p_attribute15 in varchar2 default null,
282 p_attribute16 in varchar2 default null,
283 p_attribute17 in varchar2 default null,
284 p_attribute18 in varchar2 default null,
285 p_attribute19 in varchar2 default null,
286 p_attribute20 in varchar2 default null,
287 p_attribute21 in varchar2 default null,
288 p_attribute22 in varchar2 default null,
289 p_attribute23 in varchar2 default null,
290 p_attribute24 in varchar2 default null,
291 p_attribute25 in varchar2 default null,
292 p_attribute26 in varchar2 default null,
293 p_attribute27 in varchar2 default null,
294 p_attribute28 in varchar2 default null,
295 p_attribute29 in varchar2 default null,
296 p_attribute30 in varchar2 default null,
297 p_attribute_category in varchar2 default null,
298 p_request_id in number default null,
299 p_program_application_id in number default null,
300 p_program_id in number default null,
301 p_program_update_date in date default null,
302 p_object_version_number out nocopy number,
303 p_effective_date in date,
304 p_validate in boolean default false,
305 p_security_profile_id in number default hr_security.get_security_profile
306 );
307 --
308 end hr_psf_ins;