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