1 Package per_asg_ins as
2 /* $Header: peasgrhi.pkh 120.4.12010000.1 2008/07/28 04:11:01 appldev ship $ */
3 --
4 ----------------------------------------------------------------------------
5 -- |------------------------< set_base_key_value >----------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start of Comments}
8 -- Description:
9 -- This procedure is called to register the next ID value from the database
10 -- sequence.
11 --
12 -- Prerequisites:
13 --
14 -- In Parameters:
15 -- Primary Key
16 --
17 -- Post Success:
18 --
19 -- Post Failure:
20 --
21 -- Developer Implementation Notes:
22 -- None.
23 --
24 -- Access Status:
25 -- Internal Development Use Only.
26 --
27 -- {End of Comments}
28 -- ----------------------------------------------------------------------------
29 procedure set_base_key_value
30 (p_assignment_id in number);
31 --
32 -- ----------------------------------------------------------------------------
33 -- |------------------------------< insert_dml >------------------------------|
34 -- ----------------------------------------------------------------------------
35 -- {Start Of Comments}
36 --
37 -- Description:
38 -- This procedure calls the dt_insert_dml control logic which handles
39 -- the actual datetrack dml.
40 --
41 -- Pre Conditions:
42 -- This is an internal private procedure which must be called from the ins
43 -- procedure and must have all mandatory arguments set (except the
44 -- object_version_number which is initialised within the dt_insert_dml
45 -- procedure).
46 --
47 -- In Arguments:
48 -- A Pl/Sql record structre.
49 --
50 -- Post Success:
51 -- Processing contines.
52 --
53 -- Post Failure:
54 -- No specific error handling is required within this procedure.
55 --
56 -- Developer Implementation Notes:
57 -- None.
58 --
59 -- Access Status:
60 -- Internal Table Handler Use Only.
61 --
62 -- {End Of Comments}
63 -- ----------------------------------------------------------------------------
64 Procedure insert_dml
65 (p_rec in out nocopy per_asg_shd.g_rec_type,
66 p_effective_date in date,
67 p_datetrack_mode in varchar2,
68 p_validation_start_date in date,
69 p_validation_end_date in date);
70 --
71 -- ----------------------------------------------------------------------------
72 -- |---------------------------------< ins >----------------------------------|
73 -- ----------------------------------------------------------------------------
74 -- {Start Of Comments}
75 --
76 -- Description:
77 -- This procedure is the record interface for the insert business process
78 -- for the specified entity. The role of this process is to insert a fully
79 -- validated row, into the HR schema passing back to the calling process,
80 -- any system generated values (e.g. primary and object version number
81 -- attributes). This process is the main backbone of the ins business
82 -- process. The processing of this procedure is as follows:
83 -- 1) If the p_validate argument has been set to true then a savepoint is
84 -- issued.
85 -- 2) We must lock parent rows (if any exist).
86 -- 3) The controlling validation process insert_validate is then executed
87 -- which will execute all private and public validation business rule
88 -- processes.
89 -- 4) The pre_insert business process is then executed which enables any
90 -- logic to be processed before the insert dml process is executed.
91 -- 5) The insert_dml process will physical perform the insert dml into the
92 -- specified entity.
93 -- 6) The post_insert business process is then executed which enables any
94 -- logic to be processed after the insert dml process.
95 -- 7) If the p_validate argument has been set to true an exception is raised
96 -- which is handled and processed by performing a rollback to the
97 -- savepoint which was issued at the beginning of the Ins process.
98 --
99 -- Pre Conditions:
100 -- The main arguments to the business process have to be in the record
101 -- format.
102 --
103 -- In Arguments:
104 -- p_effective_date
105 -- Specifies the date of the datetrack insert operation.
106 -- p_validate
107 -- Determines if the business process is to be validated. Setting this
108 -- boolean value to true will invoke the process to be validated. The
109 -- default is false. The validation is controlled by a savepoint and
110 -- rollback mechanism. The savepoint is issued at the beginning of the
111 -- business process and is rollbacked at the end of the business process
112 -- when all the processing has been completed. The rollback is controlled
113 -- by raising and handling the exception hr_api.validate_enabled. We use
114 -- the exception because, by raising the exception with the business
115 -- process, we can exit successfully without having any of the 'OUT'
116 -- arguments being set.
117 -- p_validate_df_flex
118
119 -- Optional parameter used to determine whether descriptive flexfield
120 -- validation is to be performed or bypassed; necessary for API calls
121 -- that attempt to insert an assignment row but are unable to complete
122 -- as they have no means of providing mandatory segment values. Default
123 -- is True - perform validation.
124 --
125 -- Post Success:
126 -- A fully validated row will be inserted into the specified entity
127 -- without being committed. If the p_validate argument has been set to true
128 -- then all the work will be rolled back.
129 --
130 -- Post Failure:
131 -- If an error has occurred, an error message will be supplied with the work
132 -- rolled back.
133 --
134 -- Developer Implementation Notes:
135 -- None.
136 --
137 -- Access Status:
138 -- Internal Development Use Only.
139 --
140 -- {End Of Comments}
141 -- ----------------------------------------------------------------------------
142 Procedure ins
143 (
144 p_rec in out nocopy per_asg_shd.g_rec_type,
145 p_effective_date in date,
146 p_validate in boolean default false,
147 p_validate_df_flex in boolean default true,
148 --
149 -- 70.2 change a start.
150 --
151 p_other_manager_warning out nocopy boolean,
152 -- Bug 2033513
153 p_hourly_salaried_warning out nocopy boolean
154 --
155 -- 70.2 change a end.
156 --
157 );
158 --
159 -- ----------------------------------------------------------------------------
160 -- |---------------------------------< ins >----------------------------------|
161 -- ----------------------------------------------------------------------------
162 -- {Start Of Comments}
163 --
164 -- Description:
165 -- This procedure is the attribute interface for the insert business
166 -- process for the specified entity and is the outermost layer. The role
167 -- of this process is to insert a fully validated row into the HR schema
168 -- passing back to the calling process, any system generated values
169 -- (e.g. object version number attributes).The processing of this
170 -- procedure is as follows:
171 -- 1) The attributes are converted into a local record structure by
172 -- calling the convert_args function.
173 -- 2) After the conversion has taken place, the corresponding record ins
174 -- interface business process is executed.
175 -- 3) OUT arguments are then set to their corresponding record arguments.
176 --
177 -- Pre Conditions:
178 --
179 -- In Arguments:
180 -- p_effective_date
181 -- Specifies the date of the datetrack insert operation.
182 -- p_validate
183 -- Determines if the business process is to be validated. Setting this
184 -- Boolean value to true will invoke the process to be validated.
185 -- The default is false.
186 -- p_validate_df_flex
187 -- Optional parameter used to determine whether descriptive flexfield
188 -- validation is to be performed or bypassed; necessary for API calls
189 -- that attempt to insert an assignment row but are unable to complete
190 -- as they have no means of providing mandatory segment values. Default
191 -- is True - perform validation
192 --
193 -- Post Success:
194 -- A fully validated row will be inserted for the specified entity
195 -- without being committed (or rollbacked depending on the p_validate
196 -- status).
197 -- p_assignment_number has been validated or generated.
198 --
199 -- Post Failure:
200 -- If an error has occurred, an error message will be supplied with the work
201 -- rolled back.
202 --
203 -- Developer Implementation Notes:
204 -- None.
205 --
206 -- Access Status:
207 -- Internal Development Use Only.
208 --
209 -- {End Of Comments}
210 -- ----------------------------------------------------------------------------
211 Procedure ins
212 (
213 p_assignment_id out nocopy number,
214 p_effective_start_date out nocopy date,
215 p_effective_end_date out nocopy date,
216 p_business_group_id in number,
217 p_recruiter_id in number default null,
218 p_grade_id in number default null,
219 p_position_id in number default null,
220 p_job_id in number default null,
221 p_assignment_status_type_id in number,
222 p_payroll_id in number default null,
223 p_location_id in number default null,
224 p_person_referred_by_id in number default null,
225 p_supervisor_id in number default null,
226 p_special_ceiling_step_id in number default null,
227 p_person_id in number,
228 p_recruitment_activity_id in number default null,
229 p_source_organization_id in number default null,
230 p_organization_id in number,
231 p_people_group_id in number default null,
232 p_soft_coding_keyflex_id in number default null,
233 p_vacancy_id in number default null,
234 p_pay_basis_id in number default null,
235 p_assignment_sequence out nocopy number,
236 p_assignment_type in varchar2,
237 p_primary_flag in varchar2,
238 p_application_id in number default null,
239 p_assignment_number in out nocopy varchar2,
240 p_change_reason in varchar2 default null,
241 p_comment_id out nocopy number,
242 p_comments in varchar2 default null,
243 p_date_probation_end in date default null,
244 p_default_code_comb_id in number default null,
245 p_employment_category in varchar2 default null,
246 p_frequency in varchar2 default null,
247 p_internal_address_line in varchar2 default null,
248 p_manager_flag in varchar2 default null,
249 p_normal_hours in number default null,
250 p_perf_review_period in number default null,
251 p_perf_review_period_frequency in varchar2 default null,
252 p_period_of_service_id in number default null,
253 p_probation_period in number default null,
254 p_probation_unit in varchar2 default null,
255 p_sal_review_period in number default null,
256 p_sal_review_period_frequency in varchar2 default null,
257 p_set_of_books_id in number default null,
258 p_source_type in varchar2 default null,
259 p_time_normal_finish in varchar2 default null,
260 p_time_normal_start in varchar2 default null,
261 p_bargaining_unit_code in varchar2 default null,
262 p_labour_union_member_flag in varchar2 default 'N',
263 p_hourly_salaried_code in varchar2 default null,
264 p_request_id in number default null,
265 p_program_application_id in number default null,
266 p_program_id in number default null,
267 p_program_update_date in date default null,
268 p_ass_attribute_category in varchar2 default null,
269 p_ass_attribute1 in varchar2 default null,
270 p_ass_attribute2 in varchar2 default null,
271 p_ass_attribute3 in varchar2 default null,
272 p_ass_attribute4 in varchar2 default null,
273 p_ass_attribute5 in varchar2 default null,
274 p_ass_attribute6 in varchar2 default null,
275 p_ass_attribute7 in varchar2 default null,
276 p_ass_attribute8 in varchar2 default null,
277 p_ass_attribute9 in varchar2 default null,
278 p_ass_attribute10 in varchar2 default null,
279 p_ass_attribute11 in varchar2 default null,
280 p_ass_attribute12 in varchar2 default null,
281 p_ass_attribute13 in varchar2 default null,
282 p_ass_attribute14 in varchar2 default null,
283 p_ass_attribute15 in varchar2 default null,
284 p_ass_attribute16 in varchar2 default null,
285 p_ass_attribute17 in varchar2 default null,
286 p_ass_attribute18 in varchar2 default null,
287 p_ass_attribute19 in varchar2 default null,
288 p_ass_attribute20 in varchar2 default null,
289 p_ass_attribute21 in varchar2 default null,
290 p_ass_attribute22 in varchar2 default null,
291 p_ass_attribute23 in varchar2 default null,
292 p_ass_attribute24 in varchar2 default null,
293 p_ass_attribute25 in varchar2 default null,
294 p_ass_attribute26 in varchar2 default null,
295 p_ass_attribute27 in varchar2 default null,
296 p_ass_attribute28 in varchar2 default null,
297 p_ass_attribute29 in varchar2 default null,
298 p_ass_attribute30 in varchar2 default null,
299 p_title in varchar2 default null,
300 p_validate_df_flex in boolean default true,
301 p_object_version_number out nocopy number,
302 p_other_manager_warning out nocopy boolean,
303 p_hourly_salaried_warning out nocopy boolean,
304 p_effective_date in date,
305 p_validate in boolean default false ,
306 p_contract_id in number default null,
307 p_establishment_id in number default null,
308 p_collective_agreement_id in number default null,
309 p_cagr_grade_def_id in number default null,
310 p_cagr_id_flex_num in number default null,
311 p_notice_period in number default null,
312 p_notice_period_uom in varchar2 default null,
313 p_employee_category in varchar2 default null,
314 p_work_at_home in varchar2 default null,
315 p_job_post_source_name in varchar2 default null,
316 p_posting_content_id in number default null,
317 p_placement_date_start in date default null,
318 p_vendor_id in number default null,
319 p_vendor_employee_number in varchar2 default null,
320 p_vendor_assignment_number in varchar2 default null,
321 p_assignment_category in varchar2 default null,
322 p_project_title in varchar2 default null,
323 p_applicant_rank in number default null,
324 p_grade_ladder_pgm_id in number default null,
325 p_supervisor_assignment_id in number default null,
329 p_projected_assignment_end in date default null
326 p_vendor_site_id in number default null,
327 p_po_header_id in number default null,
328 p_po_line_id in number default null,
330 );
331 --
332 end per_asg_ins;