APPS.PAY_EXA_UPD dependencies on HR_API

Line 96: -- by raising and handling the exception hr_api.validate_enabled. We use

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: --

Line 169: ,p_prenote_date in date default hr_api.g_date

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: --

Line 263: p_segment1 in varchar2 default hr_api.g_varchar2

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

Line 264: ,p_segment2 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

Line 265: ,p_segment3 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

Line 266: ,p_segment4 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

Line 267: ,p_segment5 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

Line 268: ,p_segment6 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

Line 269: ,p_segment7 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

Line 270: ,p_segment8 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

Line 271: ,p_segment9 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

Line 272: ,p_segment10 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

Line 273: ,p_segment11 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

Line 274: ,p_segment12 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

Line 275: ,p_segment13 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

Line 276: ,p_segment14 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

Line 277: ,p_segment15 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

Line 278: ,p_segment16 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

Line 279: ,p_segment17 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

Line 280: ,p_segment18 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

Line 281: ,p_segment19 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

Line 282: ,p_segment20 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

Line 283: ,p_segment21 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

Line 284: ,p_segment22 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

Line 285: ,p_segment23 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

Line 286: ,p_segment24 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

Line 287: ,p_segment25 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

Line 288: ,p_segment26 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

Line 289: ,p_segment27 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

Line 290: ,p_segment28 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
294: ,p_business_group_id in number

Line 291: ,p_segment29 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
295: -- make territory_code code a mandatory parameter on U interface

Line 292: ,p_segment30 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
296: ,p_territory_code in varchar2

Line 297: ,p_prenote_date in date default hr_api.g_date

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: );