92: -- default is false. The validation is controlled by a savepoint and
93: -- rollback mechanism. The savepoint is issued at the beginning of the
94: -- business process and is rollbacked at the end of the business process
95: -- when all the processing has been completed. The rollback is controlled
96: -- by raising and handling the exception hr_api.validate_enabled. We use
97: -- the exception because, by raising the exception with the business
98: -- process, we can exit successfully without having any of the 'OUT'
99: -- arguments being set.
100: --
165: -- ----------------------------------------------------------------------------
166: procedure upd(
167: p_external_account_id in number
168: ,p_territory_code in varchar2
169: ,p_prenote_date in date default hr_api.g_date
170: ,p_object_version_number in out nocopy number
171: ,p_validate in boolean default false
172: );
173: --
259: --
260: -- {End Of Comments}
261: -- ----------------------------------------------------------------------------
262: procedure upd_or_sel(
263: p_segment1 in varchar2 default hr_api.g_varchar2
264: ,p_segment2 in varchar2 default hr_api.g_varchar2
265: ,p_segment3 in varchar2 default hr_api.g_varchar2
266: ,p_segment4 in varchar2 default hr_api.g_varchar2
267: ,p_segment5 in varchar2 default hr_api.g_varchar2
260: -- {End Of Comments}
261: -- ----------------------------------------------------------------------------
262: procedure upd_or_sel(
263: p_segment1 in varchar2 default hr_api.g_varchar2
264: ,p_segment2 in varchar2 default hr_api.g_varchar2
265: ,p_segment3 in varchar2 default hr_api.g_varchar2
266: ,p_segment4 in varchar2 default hr_api.g_varchar2
267: ,p_segment5 in varchar2 default hr_api.g_varchar2
268: ,p_segment6 in varchar2 default hr_api.g_varchar2
261: -- ----------------------------------------------------------------------------
262: procedure upd_or_sel(
263: p_segment1 in varchar2 default hr_api.g_varchar2
264: ,p_segment2 in varchar2 default hr_api.g_varchar2
265: ,p_segment3 in varchar2 default hr_api.g_varchar2
266: ,p_segment4 in varchar2 default hr_api.g_varchar2
267: ,p_segment5 in varchar2 default hr_api.g_varchar2
268: ,p_segment6 in varchar2 default hr_api.g_varchar2
269: ,p_segment7 in varchar2 default hr_api.g_varchar2
262: procedure upd_or_sel(
263: p_segment1 in varchar2 default hr_api.g_varchar2
264: ,p_segment2 in varchar2 default hr_api.g_varchar2
265: ,p_segment3 in varchar2 default hr_api.g_varchar2
266: ,p_segment4 in varchar2 default hr_api.g_varchar2
267: ,p_segment5 in varchar2 default hr_api.g_varchar2
268: ,p_segment6 in varchar2 default hr_api.g_varchar2
269: ,p_segment7 in varchar2 default hr_api.g_varchar2
270: ,p_segment8 in varchar2 default hr_api.g_varchar2
263: p_segment1 in varchar2 default hr_api.g_varchar2
264: ,p_segment2 in varchar2 default hr_api.g_varchar2
265: ,p_segment3 in varchar2 default hr_api.g_varchar2
266: ,p_segment4 in varchar2 default hr_api.g_varchar2
267: ,p_segment5 in varchar2 default hr_api.g_varchar2
268: ,p_segment6 in varchar2 default hr_api.g_varchar2
269: ,p_segment7 in varchar2 default hr_api.g_varchar2
270: ,p_segment8 in varchar2 default hr_api.g_varchar2
271: ,p_segment9 in varchar2 default hr_api.g_varchar2
264: ,p_segment2 in varchar2 default hr_api.g_varchar2
265: ,p_segment3 in varchar2 default hr_api.g_varchar2
266: ,p_segment4 in varchar2 default hr_api.g_varchar2
267: ,p_segment5 in varchar2 default hr_api.g_varchar2
268: ,p_segment6 in varchar2 default hr_api.g_varchar2
269: ,p_segment7 in varchar2 default hr_api.g_varchar2
270: ,p_segment8 in varchar2 default hr_api.g_varchar2
271: ,p_segment9 in varchar2 default hr_api.g_varchar2
272: ,p_segment10 in varchar2 default hr_api.g_varchar2
265: ,p_segment3 in varchar2 default hr_api.g_varchar2
266: ,p_segment4 in varchar2 default hr_api.g_varchar2
267: ,p_segment5 in varchar2 default hr_api.g_varchar2
268: ,p_segment6 in varchar2 default hr_api.g_varchar2
269: ,p_segment7 in varchar2 default hr_api.g_varchar2
270: ,p_segment8 in varchar2 default hr_api.g_varchar2
271: ,p_segment9 in varchar2 default hr_api.g_varchar2
272: ,p_segment10 in varchar2 default hr_api.g_varchar2
273: ,p_segment11 in varchar2 default hr_api.g_varchar2
266: ,p_segment4 in varchar2 default hr_api.g_varchar2
267: ,p_segment5 in varchar2 default hr_api.g_varchar2
268: ,p_segment6 in varchar2 default hr_api.g_varchar2
269: ,p_segment7 in varchar2 default hr_api.g_varchar2
270: ,p_segment8 in varchar2 default hr_api.g_varchar2
271: ,p_segment9 in varchar2 default hr_api.g_varchar2
272: ,p_segment10 in varchar2 default hr_api.g_varchar2
273: ,p_segment11 in varchar2 default hr_api.g_varchar2
274: ,p_segment12 in varchar2 default hr_api.g_varchar2
267: ,p_segment5 in varchar2 default hr_api.g_varchar2
268: ,p_segment6 in varchar2 default hr_api.g_varchar2
269: ,p_segment7 in varchar2 default hr_api.g_varchar2
270: ,p_segment8 in varchar2 default hr_api.g_varchar2
271: ,p_segment9 in varchar2 default hr_api.g_varchar2
272: ,p_segment10 in varchar2 default hr_api.g_varchar2
273: ,p_segment11 in varchar2 default hr_api.g_varchar2
274: ,p_segment12 in varchar2 default hr_api.g_varchar2
275: ,p_segment13 in varchar2 default hr_api.g_varchar2
268: ,p_segment6 in varchar2 default hr_api.g_varchar2
269: ,p_segment7 in varchar2 default hr_api.g_varchar2
270: ,p_segment8 in varchar2 default hr_api.g_varchar2
271: ,p_segment9 in varchar2 default hr_api.g_varchar2
272: ,p_segment10 in varchar2 default hr_api.g_varchar2
273: ,p_segment11 in varchar2 default hr_api.g_varchar2
274: ,p_segment12 in varchar2 default hr_api.g_varchar2
275: ,p_segment13 in varchar2 default hr_api.g_varchar2
276: ,p_segment14 in varchar2 default hr_api.g_varchar2
269: ,p_segment7 in varchar2 default hr_api.g_varchar2
270: ,p_segment8 in varchar2 default hr_api.g_varchar2
271: ,p_segment9 in varchar2 default hr_api.g_varchar2
272: ,p_segment10 in varchar2 default hr_api.g_varchar2
273: ,p_segment11 in varchar2 default hr_api.g_varchar2
274: ,p_segment12 in varchar2 default hr_api.g_varchar2
275: ,p_segment13 in varchar2 default hr_api.g_varchar2
276: ,p_segment14 in varchar2 default hr_api.g_varchar2
277: ,p_segment15 in varchar2 default hr_api.g_varchar2
270: ,p_segment8 in varchar2 default hr_api.g_varchar2
271: ,p_segment9 in varchar2 default hr_api.g_varchar2
272: ,p_segment10 in varchar2 default hr_api.g_varchar2
273: ,p_segment11 in varchar2 default hr_api.g_varchar2
274: ,p_segment12 in varchar2 default hr_api.g_varchar2
275: ,p_segment13 in varchar2 default hr_api.g_varchar2
276: ,p_segment14 in varchar2 default hr_api.g_varchar2
277: ,p_segment15 in varchar2 default hr_api.g_varchar2
278: ,p_segment16 in varchar2 default hr_api.g_varchar2
271: ,p_segment9 in varchar2 default hr_api.g_varchar2
272: ,p_segment10 in varchar2 default hr_api.g_varchar2
273: ,p_segment11 in varchar2 default hr_api.g_varchar2
274: ,p_segment12 in varchar2 default hr_api.g_varchar2
275: ,p_segment13 in varchar2 default hr_api.g_varchar2
276: ,p_segment14 in varchar2 default hr_api.g_varchar2
277: ,p_segment15 in varchar2 default hr_api.g_varchar2
278: ,p_segment16 in varchar2 default hr_api.g_varchar2
279: ,p_segment17 in varchar2 default hr_api.g_varchar2
272: ,p_segment10 in varchar2 default hr_api.g_varchar2
273: ,p_segment11 in varchar2 default hr_api.g_varchar2
274: ,p_segment12 in varchar2 default hr_api.g_varchar2
275: ,p_segment13 in varchar2 default hr_api.g_varchar2
276: ,p_segment14 in varchar2 default hr_api.g_varchar2
277: ,p_segment15 in varchar2 default hr_api.g_varchar2
278: ,p_segment16 in varchar2 default hr_api.g_varchar2
279: ,p_segment17 in varchar2 default hr_api.g_varchar2
280: ,p_segment18 in varchar2 default hr_api.g_varchar2
273: ,p_segment11 in varchar2 default hr_api.g_varchar2
274: ,p_segment12 in varchar2 default hr_api.g_varchar2
275: ,p_segment13 in varchar2 default hr_api.g_varchar2
276: ,p_segment14 in varchar2 default hr_api.g_varchar2
277: ,p_segment15 in varchar2 default hr_api.g_varchar2
278: ,p_segment16 in varchar2 default hr_api.g_varchar2
279: ,p_segment17 in varchar2 default hr_api.g_varchar2
280: ,p_segment18 in varchar2 default hr_api.g_varchar2
281: ,p_segment19 in varchar2 default hr_api.g_varchar2
274: ,p_segment12 in varchar2 default hr_api.g_varchar2
275: ,p_segment13 in varchar2 default hr_api.g_varchar2
276: ,p_segment14 in varchar2 default hr_api.g_varchar2
277: ,p_segment15 in varchar2 default hr_api.g_varchar2
278: ,p_segment16 in varchar2 default hr_api.g_varchar2
279: ,p_segment17 in varchar2 default hr_api.g_varchar2
280: ,p_segment18 in varchar2 default hr_api.g_varchar2
281: ,p_segment19 in varchar2 default hr_api.g_varchar2
282: ,p_segment20 in varchar2 default hr_api.g_varchar2
275: ,p_segment13 in varchar2 default hr_api.g_varchar2
276: ,p_segment14 in varchar2 default hr_api.g_varchar2
277: ,p_segment15 in varchar2 default hr_api.g_varchar2
278: ,p_segment16 in varchar2 default hr_api.g_varchar2
279: ,p_segment17 in varchar2 default hr_api.g_varchar2
280: ,p_segment18 in varchar2 default hr_api.g_varchar2
281: ,p_segment19 in varchar2 default hr_api.g_varchar2
282: ,p_segment20 in varchar2 default hr_api.g_varchar2
283: ,p_segment21 in varchar2 default hr_api.g_varchar2
276: ,p_segment14 in varchar2 default hr_api.g_varchar2
277: ,p_segment15 in varchar2 default hr_api.g_varchar2
278: ,p_segment16 in varchar2 default hr_api.g_varchar2
279: ,p_segment17 in varchar2 default hr_api.g_varchar2
280: ,p_segment18 in varchar2 default hr_api.g_varchar2
281: ,p_segment19 in varchar2 default hr_api.g_varchar2
282: ,p_segment20 in varchar2 default hr_api.g_varchar2
283: ,p_segment21 in varchar2 default hr_api.g_varchar2
284: ,p_segment22 in varchar2 default hr_api.g_varchar2
277: ,p_segment15 in varchar2 default hr_api.g_varchar2
278: ,p_segment16 in varchar2 default hr_api.g_varchar2
279: ,p_segment17 in varchar2 default hr_api.g_varchar2
280: ,p_segment18 in varchar2 default hr_api.g_varchar2
281: ,p_segment19 in varchar2 default hr_api.g_varchar2
282: ,p_segment20 in varchar2 default hr_api.g_varchar2
283: ,p_segment21 in varchar2 default hr_api.g_varchar2
284: ,p_segment22 in varchar2 default hr_api.g_varchar2
285: ,p_segment23 in varchar2 default hr_api.g_varchar2
278: ,p_segment16 in varchar2 default hr_api.g_varchar2
279: ,p_segment17 in varchar2 default hr_api.g_varchar2
280: ,p_segment18 in varchar2 default hr_api.g_varchar2
281: ,p_segment19 in varchar2 default hr_api.g_varchar2
282: ,p_segment20 in varchar2 default hr_api.g_varchar2
283: ,p_segment21 in varchar2 default hr_api.g_varchar2
284: ,p_segment22 in varchar2 default hr_api.g_varchar2
285: ,p_segment23 in varchar2 default hr_api.g_varchar2
286: ,p_segment24 in varchar2 default hr_api.g_varchar2
279: ,p_segment17 in varchar2 default hr_api.g_varchar2
280: ,p_segment18 in varchar2 default hr_api.g_varchar2
281: ,p_segment19 in varchar2 default hr_api.g_varchar2
282: ,p_segment20 in varchar2 default hr_api.g_varchar2
283: ,p_segment21 in varchar2 default hr_api.g_varchar2
284: ,p_segment22 in varchar2 default hr_api.g_varchar2
285: ,p_segment23 in varchar2 default hr_api.g_varchar2
286: ,p_segment24 in varchar2 default hr_api.g_varchar2
287: ,p_segment25 in varchar2 default hr_api.g_varchar2
280: ,p_segment18 in varchar2 default hr_api.g_varchar2
281: ,p_segment19 in varchar2 default hr_api.g_varchar2
282: ,p_segment20 in varchar2 default hr_api.g_varchar2
283: ,p_segment21 in varchar2 default hr_api.g_varchar2
284: ,p_segment22 in varchar2 default hr_api.g_varchar2
285: ,p_segment23 in varchar2 default hr_api.g_varchar2
286: ,p_segment24 in varchar2 default hr_api.g_varchar2
287: ,p_segment25 in varchar2 default hr_api.g_varchar2
288: ,p_segment26 in varchar2 default hr_api.g_varchar2
281: ,p_segment19 in varchar2 default hr_api.g_varchar2
282: ,p_segment20 in varchar2 default hr_api.g_varchar2
283: ,p_segment21 in varchar2 default hr_api.g_varchar2
284: ,p_segment22 in varchar2 default hr_api.g_varchar2
285: ,p_segment23 in varchar2 default hr_api.g_varchar2
286: ,p_segment24 in varchar2 default hr_api.g_varchar2
287: ,p_segment25 in varchar2 default hr_api.g_varchar2
288: ,p_segment26 in varchar2 default hr_api.g_varchar2
289: ,p_segment27 in varchar2 default hr_api.g_varchar2
282: ,p_segment20 in varchar2 default hr_api.g_varchar2
283: ,p_segment21 in varchar2 default hr_api.g_varchar2
284: ,p_segment22 in varchar2 default hr_api.g_varchar2
285: ,p_segment23 in varchar2 default hr_api.g_varchar2
286: ,p_segment24 in varchar2 default hr_api.g_varchar2
287: ,p_segment25 in varchar2 default hr_api.g_varchar2
288: ,p_segment26 in varchar2 default hr_api.g_varchar2
289: ,p_segment27 in varchar2 default hr_api.g_varchar2
290: ,p_segment28 in varchar2 default hr_api.g_varchar2
283: ,p_segment21 in varchar2 default hr_api.g_varchar2
284: ,p_segment22 in varchar2 default hr_api.g_varchar2
285: ,p_segment23 in varchar2 default hr_api.g_varchar2
286: ,p_segment24 in varchar2 default hr_api.g_varchar2
287: ,p_segment25 in varchar2 default hr_api.g_varchar2
288: ,p_segment26 in varchar2 default hr_api.g_varchar2
289: ,p_segment27 in varchar2 default hr_api.g_varchar2
290: ,p_segment28 in varchar2 default hr_api.g_varchar2
291: ,p_segment29 in varchar2 default hr_api.g_varchar2
284: ,p_segment22 in varchar2 default hr_api.g_varchar2
285: ,p_segment23 in varchar2 default hr_api.g_varchar2
286: ,p_segment24 in varchar2 default hr_api.g_varchar2
287: ,p_segment25 in varchar2 default hr_api.g_varchar2
288: ,p_segment26 in varchar2 default hr_api.g_varchar2
289: ,p_segment27 in varchar2 default hr_api.g_varchar2
290: ,p_segment28 in varchar2 default hr_api.g_varchar2
291: ,p_segment29 in varchar2 default hr_api.g_varchar2
292: ,p_segment30 in varchar2 default hr_api.g_varchar2
285: ,p_segment23 in varchar2 default hr_api.g_varchar2
286: ,p_segment24 in varchar2 default hr_api.g_varchar2
287: ,p_segment25 in varchar2 default hr_api.g_varchar2
288: ,p_segment26 in varchar2 default hr_api.g_varchar2
289: ,p_segment27 in varchar2 default hr_api.g_varchar2
290: ,p_segment28 in varchar2 default hr_api.g_varchar2
291: ,p_segment29 in varchar2 default hr_api.g_varchar2
292: ,p_segment30 in varchar2 default hr_api.g_varchar2
293: ,p_concat_segments in varchar2 default null
286: ,p_segment24 in varchar2 default hr_api.g_varchar2
287: ,p_segment25 in varchar2 default hr_api.g_varchar2
288: ,p_segment26 in varchar2 default hr_api.g_varchar2
289: ,p_segment27 in varchar2 default hr_api.g_varchar2
290: ,p_segment28 in varchar2 default hr_api.g_varchar2
291: ,p_segment29 in varchar2 default hr_api.g_varchar2
292: ,p_segment30 in varchar2 default hr_api.g_varchar2
293: ,p_concat_segments in varchar2 default null
294: ,p_business_group_id in number
287: ,p_segment25 in varchar2 default hr_api.g_varchar2
288: ,p_segment26 in varchar2 default hr_api.g_varchar2
289: ,p_segment27 in varchar2 default hr_api.g_varchar2
290: ,p_segment28 in varchar2 default hr_api.g_varchar2
291: ,p_segment29 in varchar2 default hr_api.g_varchar2
292: ,p_segment30 in varchar2 default hr_api.g_varchar2
293: ,p_concat_segments in varchar2 default null
294: ,p_business_group_id in number
295: -- make territory_code code a mandatory parameter on U interface
288: ,p_segment26 in varchar2 default hr_api.g_varchar2
289: ,p_segment27 in varchar2 default hr_api.g_varchar2
290: ,p_segment28 in varchar2 default hr_api.g_varchar2
291: ,p_segment29 in varchar2 default hr_api.g_varchar2
292: ,p_segment30 in varchar2 default hr_api.g_varchar2
293: ,p_concat_segments in varchar2 default null
294: ,p_business_group_id in number
295: -- make territory_code code a mandatory parameter on U interface
296: ,p_territory_code in varchar2
293: ,p_concat_segments in varchar2 default null
294: ,p_business_group_id in number
295: -- make territory_code code a mandatory parameter on U interface
296: ,p_territory_code in varchar2
297: ,p_prenote_date in date default hr_api.g_date
298: ,p_external_account_id in out nocopy number
299: ,p_object_version_number in out nocopy number
300: ,p_validate in boolean default false
301: );