1 Package ben_asg_upd as
2 /* $Header: beasgrhi.pkh 120.0.12010000.1 2008/07/29 10:51:34 appldev ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------------------< upd >----------------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- This procedure is the record interface for the update business
11 -- process for the specified entity. The role of this process is
12 -- to perform the datetrack update mode, without validating the row
13 -- for the HR schema passing back to the calling process, any system
14 -- generated values (e.g. object version number attribute). This process
15 -- is the main backbone of the upd business process. The processing of
16 -- this procedure is as follows:
17 -- 1) Ensure that the datetrack update mode is valid.
18 -- 2) If the p_validate argument has been set to true then a savepoint
19 -- is issued.
20 -- 3) The row to be updated is then locked and selected into the record
21 -- structure g_old_rec.
22 -- 4) Because on update arguments which are not part of the update do not
23 -- have to be defaulted, we need to build up the updated row by
24 -- converting any system defaulted arguments to their corresponding
25 -- value.
26 -- 5) No validation business rules are executed.
27 -- 6) The pre_update business process is then executed which enables any
28 -- logic to be processed before the update dml process is executed.
29 -- 7) The update_dml process will physical perform the update dml into the
30 -- specified entity.
31 -- 8) The post_update business process is then executed which enables any
32 -- logic to be processed after the update dml process.
33 -- 9) If the p_validate argument has been set to true an exception is
34 -- raised which is handled and processed by performing a rollback to
35 -- the savepoint which was issued at the beginning of the upd process.
36 --
37 -- Pre Conditions:
38 -- The main arguments to the business process have to be in the record
39 -- format.
40 --
41 -- In Arguments:
42 -- p_effective_date
43 -- Specifies the date of the datetrack update operation.
44 -- p_datetrack_mode
45 -- Determines the datetrack update mode.
46 -- p_validate
47 -- Determines if the business process is to be validated. Setting this
48 -- boolean value to true will invoke the process to be validated. The
49 -- default is false. The validation is controlled by a savepoint and
50 -- rollback mechanism. The savepoint is issued at the beginning of the
51 -- business process and is rollbacked at the end of the business process
52 -- when all the processing has been completed. The rollback is controlled
53 -- by raising and handling the exception hr_api.validate_enabled. We use
54 -- the exception because, by raising the exception with the business
55 -- process, we can exit successfully without having any of the 'OUT'
56 -- arguments being set.
57 --
58 -- Post Success:
59 -- The specified row will be datetracked updated for the specified entity
60 -- without being committed for the datetrack mode. If the p_validate argument
61 -- has been set to true then all the work will be rolled back.
62 --
63 -- Post Failure:
64 -- If an error has occurred, an error message will be supplied with the work
65 -- rolled back.
66 --
67 -- Developer Implementation Notes:
68 -- None.
69 --
70 -- Access Status:
71 -- Internal Development Use Only.
72 --
73 -- {End Of Comments}
74 -- ----------------------------------------------------------------------------
75 Procedure upd
76 (
77 p_rec in out nocopy per_asg_shd.g_rec_type,
78 p_effective_date in date,
79 p_datetrack_mode in varchar2,
80 p_validation_start_date out nocopy date,
81 p_validation_end_date out nocopy date,
82 p_validate in boolean default false,
83 p_payroll_id_updated out nocopy boolean,
84 p_other_manager_warning out nocopy boolean,
85 p_hourly_salaried_warning out nocopy boolean,
86 p_no_managers_warning out nocopy boolean,
87 p_org_now_no_manager_warning out nocopy boolean
88 );
89 --
90 -- ----------------------------------------------------------------------------
91 -- |---------------------------------< upd >----------------------------------|
92 -- ----------------------------------------------------------------------------
93 -- {Start Of Comments}
94 --
95 -- Description:
96 -- This procedure is the attribute interface for the datetrack update
97 -- business process for the specified entity and is the outermost layer.
98 -- The role of this process is to update a row into the
99 -- HR schema passing back to the calling process, any system generated
100 -- values (e.g. object version number attributes).The processing of this
101 -- procedure is as follows:
102 -- 1) The attributes are converted into a local record structure by
103 -- calling the convert_defs function.
104 -- 2) After the conversion has taken place, the corresponding record upd
105 -- interface business process is executed.
106 -- 3) OUT arguments are then set to their corresponding record arguments.
107 --
108 -- Pre Conditions:
109 --
110 -- In Arguments:
111 -- p_effective_date
112 -- Specifies the date of the datetrack update operation.
113 -- p_datetrack_mode
114 -- Determines the datetrack update mode.
115 -- p_validate
116 -- Determines if the business process is to be validated. Setting this
117 -- Boolean value to true will invoke the process to be validated.
118 -- The default is false.
119 --
120 -- Post Success:
121 -- A row will be updated for the specified entity
122 -- without being committed (or rollbacked depending on the p_validate
123 -- status).
124 -- Note that the out parameter p_business_group_id will always be set,
125 -- regardless of the p_validate value.
126 --
127 -- Post Failure:
128 -- If an error has occurred, an error message will be supplied with the work
129 -- rolled back.
130 --
131 -- Developer Implementation Notes:
132 -- None.
133 --
134 -- Access Status:
135 -- Internal Development Use Only.
136 --
137 -- {End Of Comments}
138 -- ----------------------------------------------------------------------------
139 Procedure upd
140 (
141 p_assignment_id in number,
142 p_effective_start_date out nocopy date,
143 p_effective_end_date out nocopy date,
144
145 p_business_group_id out nocopy number,
146 p_recruiter_id in number default hr_api.g_number,
147 p_grade_id in number default hr_api.g_number,
148 p_position_id in number default hr_api.g_number,
149 p_job_id in number default hr_api.g_number,
150 p_assignment_status_type_id in number default hr_api.g_number,
151 p_payroll_id in number default hr_api.g_number,
152 p_location_id in number default hr_api.g_number,
153 p_person_referred_by_id in number default hr_api.g_number,
154 p_supervisor_id in number default hr_api.g_number,
155 p_special_ceiling_step_id in number default hr_api.g_number,
156 p_recruitment_activity_id in number default hr_api.g_number,
157 p_source_organization_id in number default hr_api.g_number,
158
159 p_organization_id in number default hr_api.g_number,
160 p_people_group_id in number default hr_api.g_number,
161 p_soft_coding_keyflex_id in number default hr_api.g_number,
162 p_vacancy_id in number default hr_api.g_number,
163 p_pay_basis_id in number default hr_api.g_number,
164 p_assignment_type in varchar2 default hr_api.g_varchar2,
165 p_primary_flag in varchar2 default hr_api.g_varchar2,
166 p_application_id in number default hr_api.g_number,
167 p_assignment_number in varchar2 default hr_api.g_varchar2,
168 p_change_reason in varchar2 default hr_api.g_varchar2,
169 p_comment_id out nocopy number,
170 p_comments in varchar2 default hr_api.g_varchar2,
171 p_date_probation_end in date default hr_api.g_date,
172
173 p_default_code_comb_id in number default hr_api.g_number,
174 p_employment_category in varchar2 default hr_api.g_varchar2,
175 p_frequency in varchar2 default hr_api.g_varchar2,
176 p_internal_address_line in varchar2 default hr_api.g_varchar2,
177 p_manager_flag in varchar2 default hr_api.g_varchar2,
178 p_normal_hours in number default hr_api.g_number,
179 p_perf_review_period in number default hr_api.g_number,
180 p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2,
181 p_period_of_service_id in number default hr_api.g_number,
182 p_probation_period in number default hr_api.g_number,
183 p_probation_unit in varchar2 default hr_api.g_varchar2,
184 p_sal_review_period in number default hr_api.g_number,
185 p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2,
186 p_set_of_books_id in number default hr_api.g_number,
187
188 p_source_type in varchar2 default hr_api.g_varchar2,
189 p_time_normal_finish in varchar2 default hr_api.g_varchar2,
190 p_time_normal_start in varchar2 default hr_api.g_varchar2,
191 p_bargaining_unit_code in varchar2 default hr_api.g_varchar2,
192 p_labour_union_member_flag in varchar2 default hr_api.g_varchar2,
193 p_hourly_salaried_code in varchar2 default hr_api.g_varchar2,
194 p_request_id in number default hr_api.g_number,
195 p_program_application_id in number default hr_api.g_number,
196 p_program_id in number default hr_api.g_number,
197 p_program_update_date in date default hr_api.g_date,
198 p_ass_attribute_category in varchar2 default hr_api.g_varchar2,
199 p_ass_attribute1 in varchar2 default hr_api.g_varchar2,
200 p_ass_attribute2 in varchar2 default hr_api.g_varchar2,
201 p_ass_attribute3 in varchar2 default hr_api.g_varchar2,
202 p_ass_attribute4 in varchar2 default hr_api.g_varchar2,
203 p_ass_attribute5 in varchar2 default hr_api.g_varchar2,
204
205 p_ass_attribute6 in varchar2 default hr_api.g_varchar2,
206 p_ass_attribute7 in varchar2 default hr_api.g_varchar2,
207 p_ass_attribute8 in varchar2 default hr_api.g_varchar2,
208 p_ass_attribute9 in varchar2 default hr_api.g_varchar2,
209 p_ass_attribute10 in varchar2 default hr_api.g_varchar2,
210 p_ass_attribute11 in varchar2 default hr_api.g_varchar2,
211 p_ass_attribute12 in varchar2 default hr_api.g_varchar2,
212 p_ass_attribute13 in varchar2 default hr_api.g_varchar2,
213 p_ass_attribute14 in varchar2 default hr_api.g_varchar2,
214 p_ass_attribute15 in varchar2 default hr_api.g_varchar2,
215 p_ass_attribute16 in varchar2 default hr_api.g_varchar2,
216 p_ass_attribute17 in varchar2 default hr_api.g_varchar2,
217 p_ass_attribute18 in varchar2 default hr_api.g_varchar2,
218
219 p_ass_attribute19 in varchar2 default hr_api.g_varchar2,
220 p_ass_attribute20 in varchar2 default hr_api.g_varchar2,
221 p_ass_attribute21 in varchar2 default hr_api.g_varchar2,
222 p_ass_attribute22 in varchar2 default hr_api.g_varchar2,
223 p_ass_attribute23 in varchar2 default hr_api.g_varchar2,
224 p_ass_attribute24 in varchar2 default hr_api.g_varchar2,
225 p_ass_attribute25 in varchar2 default hr_api.g_varchar2,
226 p_ass_attribute26 in varchar2 default hr_api.g_varchar2,
227 p_ass_attribute27 in varchar2 default hr_api.g_varchar2,
228 p_ass_attribute28 in varchar2 default hr_api.g_varchar2,
229 p_ass_attribute29 in varchar2 default hr_api.g_varchar2,
230 p_ass_attribute30 in varchar2 default hr_api.g_varchar2,
231 p_title in varchar2 default hr_api.g_varchar2,
232 p_contract_id in number default hr_api.g_number,
233 p_establishment_id in number default hr_api.g_number,
234 p_collective_agreement_id in number default hr_api.g_number,
235 p_cagr_grade_def_id in number default hr_api.g_number,
236 p_cagr_id_flex_num in number default hr_api.g_number,
237 p_object_version_number in out nocopy number,
238 p_notice_period in number default hr_api.g_number,
239 p_notice_period_uom in varchar2 default hr_api.g_varchar2,
240 p_employee_category in varchar2 default hr_api.g_varchar2,
241 p_work_at_home in varchar2 default hr_api.g_varchar2,
242 p_job_post_source_name in varchar2 default hr_api.g_varchar2,
243 p_posting_content_id in number default hr_api.g_number,
244 p_placement_date_start in date default hr_api.g_date,
245 p_vendor_id in number default hr_api.g_number,
246 p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
247 p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
248 p_assignment_category in varchar2 default hr_api.g_varchar2,
249 p_project_title in varchar2 default hr_api.g_varchar2,
250 p_applicant_rank in number default hr_api.g_number,
251
252 p_payroll_id_updated out nocopy boolean,
253 p_other_manager_warning out nocopy boolean,
254 p_hourly_salaried_warning out nocopy boolean,
255 p_no_managers_warning out nocopy boolean,
256 p_org_now_no_manager_warning out nocopy boolean,
257 p_validation_start_date out nocopy date,
258 p_validation_end_date out nocopy date,
259 p_effective_date in date,
260 p_datetrack_mode in varchar2,
261 p_validate in boolean default false
262 );
263 --
264 end ben_asg_upd;