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