eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_COURT_ORDERS_API dependencies on HR_API

Line 146: when hr_api.cannot_find_prog_unit then

142: ,p_pl_typ_id => p_pl_typ_id
143: ,p_effective_date => trunc(p_effective_date)
144: );
145: exception
146: when hr_api.cannot_find_prog_unit then
147: hr_api.cannot_find_prog_unit_error
148: (
149: p_module_name => 'CREATE_court_orders'
150: ,p_hook_type => 'BP'

Line 147: hr_api.cannot_find_prog_unit_error

143: ,p_effective_date => trunc(p_effective_date)
144: );
145: exception
146: when hr_api.cannot_find_prog_unit then
147: hr_api.cannot_find_prog_unit_error
148: (
149: p_module_name => 'CREATE_court_orders'
150: ,p_hook_type => 'BP'
151: );

Line 275: when hr_api.cannot_find_prog_unit then

271: ,p_pl_typ_id => p_pl_typ_id
272: ,p_effective_date => trunc(p_effective_date)
273: );
274: exception
275: when hr_api.cannot_find_prog_unit then
276: hr_api.cannot_find_prog_unit_error
277: (p_module_name => 'CREATE_court_orders'
278: ,p_hook_type => 'AP'
279: );

Line 276: hr_api.cannot_find_prog_unit_error

272: ,p_effective_date => trunc(p_effective_date)
273: );
274: exception
275: when hr_api.cannot_find_prog_unit then
276: hr_api.cannot_find_prog_unit_error
277: (p_module_name => 'CREATE_court_orders'
278: ,p_hook_type => 'AP'
279: );
280: --

Line 290: raise hr_api.validate_enabled;

286: --
287: -- When in validation only mode raise the Validate_Enabled exception
288: --
289: if p_validate then
290: raise hr_api.validate_enabled;
291: end if;
292: --
293: -- Set all output arguments
294: --

Line 302: when hr_api.validate_enabled then

298: hr_utility.set_location(' Leaving:'||l_proc, 70);
299: --
300: exception
301: --
302: when hr_api.validate_enabled then
303: --
304: -- As the Validate_Enabled exception has been raised
305: -- we must rollback to the savepoint
306: --

Line 334: ,p_crt_ordr_typ_cd in varchar2 default hr_api.g_varchar2

330: --
331: procedure update_court_orders
332: (p_validate in boolean default false
333: ,p_crt_ordr_id in number
334: ,p_crt_ordr_typ_cd in varchar2 default hr_api.g_varchar2
335: ,p_apls_perd_endg_dt in date default hr_api.g_date
336: ,p_apls_perd_strtg_dt in date default hr_api.g_date
337: ,p_crt_ident in varchar2 default hr_api.g_varchar2
338: ,p_description in varchar2 default hr_api.g_varchar2

Line 335: ,p_apls_perd_endg_dt in date default hr_api.g_date

331: procedure update_court_orders
332: (p_validate in boolean default false
333: ,p_crt_ordr_id in number
334: ,p_crt_ordr_typ_cd in varchar2 default hr_api.g_varchar2
335: ,p_apls_perd_endg_dt in date default hr_api.g_date
336: ,p_apls_perd_strtg_dt in date default hr_api.g_date
337: ,p_crt_ident in varchar2 default hr_api.g_varchar2
338: ,p_description in varchar2 default hr_api.g_varchar2
339: ,p_detd_qlfd_ordr_dt in date default hr_api.g_date

Line 336: ,p_apls_perd_strtg_dt in date default hr_api.g_date

332: (p_validate in boolean default false
333: ,p_crt_ordr_id in number
334: ,p_crt_ordr_typ_cd in varchar2 default hr_api.g_varchar2
335: ,p_apls_perd_endg_dt in date default hr_api.g_date
336: ,p_apls_perd_strtg_dt in date default hr_api.g_date
337: ,p_crt_ident in varchar2 default hr_api.g_varchar2
338: ,p_description in varchar2 default hr_api.g_varchar2
339: ,p_detd_qlfd_ordr_dt in date default hr_api.g_date
340: ,p_issue_dt in date default hr_api.g_date

Line 337: ,p_crt_ident in varchar2 default hr_api.g_varchar2

333: ,p_crt_ordr_id in number
334: ,p_crt_ordr_typ_cd in varchar2 default hr_api.g_varchar2
335: ,p_apls_perd_endg_dt in date default hr_api.g_date
336: ,p_apls_perd_strtg_dt in date default hr_api.g_date
337: ,p_crt_ident in varchar2 default hr_api.g_varchar2
338: ,p_description in varchar2 default hr_api.g_varchar2
339: ,p_detd_qlfd_ordr_dt in date default hr_api.g_date
340: ,p_issue_dt in date default hr_api.g_date
341: ,p_qdro_amt in number default hr_api.g_number

Line 338: ,p_description in varchar2 default hr_api.g_varchar2

334: ,p_crt_ordr_typ_cd in varchar2 default hr_api.g_varchar2
335: ,p_apls_perd_endg_dt in date default hr_api.g_date
336: ,p_apls_perd_strtg_dt in date default hr_api.g_date
337: ,p_crt_ident in varchar2 default hr_api.g_varchar2
338: ,p_description in varchar2 default hr_api.g_varchar2
339: ,p_detd_qlfd_ordr_dt in date default hr_api.g_date
340: ,p_issue_dt in date default hr_api.g_date
341: ,p_qdro_amt in number default hr_api.g_number
342: ,p_qdro_dstr_mthd_cd in varchar2 default hr_api.g_varchar2

Line 339: ,p_detd_qlfd_ordr_dt in date default hr_api.g_date

335: ,p_apls_perd_endg_dt in date default hr_api.g_date
336: ,p_apls_perd_strtg_dt in date default hr_api.g_date
337: ,p_crt_ident in varchar2 default hr_api.g_varchar2
338: ,p_description in varchar2 default hr_api.g_varchar2
339: ,p_detd_qlfd_ordr_dt in date default hr_api.g_date
340: ,p_issue_dt in date default hr_api.g_date
341: ,p_qdro_amt in number default hr_api.g_number
342: ,p_qdro_dstr_mthd_cd in varchar2 default hr_api.g_varchar2
343: ,p_qdro_pct in number default hr_api.g_number

Line 340: ,p_issue_dt in date default hr_api.g_date

336: ,p_apls_perd_strtg_dt in date default hr_api.g_date
337: ,p_crt_ident in varchar2 default hr_api.g_varchar2
338: ,p_description in varchar2 default hr_api.g_varchar2
339: ,p_detd_qlfd_ordr_dt in date default hr_api.g_date
340: ,p_issue_dt in date default hr_api.g_date
341: ,p_qdro_amt in number default hr_api.g_number
342: ,p_qdro_dstr_mthd_cd in varchar2 default hr_api.g_varchar2
343: ,p_qdro_pct in number default hr_api.g_number
344: ,p_rcvd_dt in date default hr_api.g_date

Line 341: ,p_qdro_amt in number default hr_api.g_number

337: ,p_crt_ident in varchar2 default hr_api.g_varchar2
338: ,p_description in varchar2 default hr_api.g_varchar2
339: ,p_detd_qlfd_ordr_dt in date default hr_api.g_date
340: ,p_issue_dt in date default hr_api.g_date
341: ,p_qdro_amt in number default hr_api.g_number
342: ,p_qdro_dstr_mthd_cd in varchar2 default hr_api.g_varchar2
343: ,p_qdro_pct in number default hr_api.g_number
344: ,p_rcvd_dt in date default hr_api.g_date
345: ,p_uom in varchar2 default hr_api.g_varchar2

Line 342: ,p_qdro_dstr_mthd_cd in varchar2 default hr_api.g_varchar2

338: ,p_description in varchar2 default hr_api.g_varchar2
339: ,p_detd_qlfd_ordr_dt in date default hr_api.g_date
340: ,p_issue_dt in date default hr_api.g_date
341: ,p_qdro_amt in number default hr_api.g_number
342: ,p_qdro_dstr_mthd_cd in varchar2 default hr_api.g_varchar2
343: ,p_qdro_pct in number default hr_api.g_number
344: ,p_rcvd_dt in date default hr_api.g_date
345: ,p_uom in varchar2 default hr_api.g_varchar2
346: ,p_crt_issng in varchar2 default hr_api.g_varchar2

Line 343: ,p_qdro_pct in number default hr_api.g_number

339: ,p_detd_qlfd_ordr_dt in date default hr_api.g_date
340: ,p_issue_dt in date default hr_api.g_date
341: ,p_qdro_amt in number default hr_api.g_number
342: ,p_qdro_dstr_mthd_cd in varchar2 default hr_api.g_varchar2
343: ,p_qdro_pct in number default hr_api.g_number
344: ,p_rcvd_dt in date default hr_api.g_date
345: ,p_uom in varchar2 default hr_api.g_varchar2
346: ,p_crt_issng in varchar2 default hr_api.g_varchar2
347: ,p_pl_id in number default hr_api.g_number

Line 344: ,p_rcvd_dt in date default hr_api.g_date

340: ,p_issue_dt in date default hr_api.g_date
341: ,p_qdro_amt in number default hr_api.g_number
342: ,p_qdro_dstr_mthd_cd in varchar2 default hr_api.g_varchar2
343: ,p_qdro_pct in number default hr_api.g_number
344: ,p_rcvd_dt in date default hr_api.g_date
345: ,p_uom in varchar2 default hr_api.g_varchar2
346: ,p_crt_issng in varchar2 default hr_api.g_varchar2
347: ,p_pl_id in number default hr_api.g_number
348: ,p_person_id in number default hr_api.g_number

Line 345: ,p_uom in varchar2 default hr_api.g_varchar2

341: ,p_qdro_amt in number default hr_api.g_number
342: ,p_qdro_dstr_mthd_cd in varchar2 default hr_api.g_varchar2
343: ,p_qdro_pct in number default hr_api.g_number
344: ,p_rcvd_dt in date default hr_api.g_date
345: ,p_uom in varchar2 default hr_api.g_varchar2
346: ,p_crt_issng in varchar2 default hr_api.g_varchar2
347: ,p_pl_id in number default hr_api.g_number
348: ,p_person_id in number default hr_api.g_number
349: ,p_business_group_id in number default hr_api.g_number

Line 346: ,p_crt_issng in varchar2 default hr_api.g_varchar2

342: ,p_qdro_dstr_mthd_cd in varchar2 default hr_api.g_varchar2
343: ,p_qdro_pct in number default hr_api.g_number
344: ,p_rcvd_dt in date default hr_api.g_date
345: ,p_uom in varchar2 default hr_api.g_varchar2
346: ,p_crt_issng in varchar2 default hr_api.g_varchar2
347: ,p_pl_id in number default hr_api.g_number
348: ,p_person_id in number default hr_api.g_number
349: ,p_business_group_id in number default hr_api.g_number
350: ,p_crt_attribute_category in varchar2 default hr_api.g_varchar2

Line 347: ,p_pl_id in number default hr_api.g_number

343: ,p_qdro_pct in number default hr_api.g_number
344: ,p_rcvd_dt in date default hr_api.g_date
345: ,p_uom in varchar2 default hr_api.g_varchar2
346: ,p_crt_issng in varchar2 default hr_api.g_varchar2
347: ,p_pl_id in number default hr_api.g_number
348: ,p_person_id in number default hr_api.g_number
349: ,p_business_group_id in number default hr_api.g_number
350: ,p_crt_attribute_category in varchar2 default hr_api.g_varchar2
351: ,p_crt_attribute1 in varchar2 default hr_api.g_varchar2

Line 348: ,p_person_id in number default hr_api.g_number

344: ,p_rcvd_dt in date default hr_api.g_date
345: ,p_uom in varchar2 default hr_api.g_varchar2
346: ,p_crt_issng in varchar2 default hr_api.g_varchar2
347: ,p_pl_id in number default hr_api.g_number
348: ,p_person_id in number default hr_api.g_number
349: ,p_business_group_id in number default hr_api.g_number
350: ,p_crt_attribute_category in varchar2 default hr_api.g_varchar2
351: ,p_crt_attribute1 in varchar2 default hr_api.g_varchar2
352: ,p_crt_attribute2 in varchar2 default hr_api.g_varchar2

Line 349: ,p_business_group_id in number default hr_api.g_number

345: ,p_uom in varchar2 default hr_api.g_varchar2
346: ,p_crt_issng in varchar2 default hr_api.g_varchar2
347: ,p_pl_id in number default hr_api.g_number
348: ,p_person_id in number default hr_api.g_number
349: ,p_business_group_id in number default hr_api.g_number
350: ,p_crt_attribute_category in varchar2 default hr_api.g_varchar2
351: ,p_crt_attribute1 in varchar2 default hr_api.g_varchar2
352: ,p_crt_attribute2 in varchar2 default hr_api.g_varchar2
353: ,p_crt_attribute3 in varchar2 default hr_api.g_varchar2

Line 350: ,p_crt_attribute_category in varchar2 default hr_api.g_varchar2

346: ,p_crt_issng in varchar2 default hr_api.g_varchar2
347: ,p_pl_id in number default hr_api.g_number
348: ,p_person_id in number default hr_api.g_number
349: ,p_business_group_id in number default hr_api.g_number
350: ,p_crt_attribute_category in varchar2 default hr_api.g_varchar2
351: ,p_crt_attribute1 in varchar2 default hr_api.g_varchar2
352: ,p_crt_attribute2 in varchar2 default hr_api.g_varchar2
353: ,p_crt_attribute3 in varchar2 default hr_api.g_varchar2
354: ,p_crt_attribute4 in varchar2 default hr_api.g_varchar2

Line 351: ,p_crt_attribute1 in varchar2 default hr_api.g_varchar2

347: ,p_pl_id in number default hr_api.g_number
348: ,p_person_id in number default hr_api.g_number
349: ,p_business_group_id in number default hr_api.g_number
350: ,p_crt_attribute_category in varchar2 default hr_api.g_varchar2
351: ,p_crt_attribute1 in varchar2 default hr_api.g_varchar2
352: ,p_crt_attribute2 in varchar2 default hr_api.g_varchar2
353: ,p_crt_attribute3 in varchar2 default hr_api.g_varchar2
354: ,p_crt_attribute4 in varchar2 default hr_api.g_varchar2
355: ,p_crt_attribute5 in varchar2 default hr_api.g_varchar2

Line 352: ,p_crt_attribute2 in varchar2 default hr_api.g_varchar2

348: ,p_person_id in number default hr_api.g_number
349: ,p_business_group_id in number default hr_api.g_number
350: ,p_crt_attribute_category in varchar2 default hr_api.g_varchar2
351: ,p_crt_attribute1 in varchar2 default hr_api.g_varchar2
352: ,p_crt_attribute2 in varchar2 default hr_api.g_varchar2
353: ,p_crt_attribute3 in varchar2 default hr_api.g_varchar2
354: ,p_crt_attribute4 in varchar2 default hr_api.g_varchar2
355: ,p_crt_attribute5 in varchar2 default hr_api.g_varchar2
356: ,p_crt_attribute6 in varchar2 default hr_api.g_varchar2

Line 353: ,p_crt_attribute3 in varchar2 default hr_api.g_varchar2

349: ,p_business_group_id in number default hr_api.g_number
350: ,p_crt_attribute_category in varchar2 default hr_api.g_varchar2
351: ,p_crt_attribute1 in varchar2 default hr_api.g_varchar2
352: ,p_crt_attribute2 in varchar2 default hr_api.g_varchar2
353: ,p_crt_attribute3 in varchar2 default hr_api.g_varchar2
354: ,p_crt_attribute4 in varchar2 default hr_api.g_varchar2
355: ,p_crt_attribute5 in varchar2 default hr_api.g_varchar2
356: ,p_crt_attribute6 in varchar2 default hr_api.g_varchar2
357: ,p_crt_attribute7 in varchar2 default hr_api.g_varchar2

Line 354: ,p_crt_attribute4 in varchar2 default hr_api.g_varchar2

350: ,p_crt_attribute_category in varchar2 default hr_api.g_varchar2
351: ,p_crt_attribute1 in varchar2 default hr_api.g_varchar2
352: ,p_crt_attribute2 in varchar2 default hr_api.g_varchar2
353: ,p_crt_attribute3 in varchar2 default hr_api.g_varchar2
354: ,p_crt_attribute4 in varchar2 default hr_api.g_varchar2
355: ,p_crt_attribute5 in varchar2 default hr_api.g_varchar2
356: ,p_crt_attribute6 in varchar2 default hr_api.g_varchar2
357: ,p_crt_attribute7 in varchar2 default hr_api.g_varchar2
358: ,p_crt_attribute8 in varchar2 default hr_api.g_varchar2

Line 355: ,p_crt_attribute5 in varchar2 default hr_api.g_varchar2

351: ,p_crt_attribute1 in varchar2 default hr_api.g_varchar2
352: ,p_crt_attribute2 in varchar2 default hr_api.g_varchar2
353: ,p_crt_attribute3 in varchar2 default hr_api.g_varchar2
354: ,p_crt_attribute4 in varchar2 default hr_api.g_varchar2
355: ,p_crt_attribute5 in varchar2 default hr_api.g_varchar2
356: ,p_crt_attribute6 in varchar2 default hr_api.g_varchar2
357: ,p_crt_attribute7 in varchar2 default hr_api.g_varchar2
358: ,p_crt_attribute8 in varchar2 default hr_api.g_varchar2
359: ,p_crt_attribute9 in varchar2 default hr_api.g_varchar2

Line 356: ,p_crt_attribute6 in varchar2 default hr_api.g_varchar2

352: ,p_crt_attribute2 in varchar2 default hr_api.g_varchar2
353: ,p_crt_attribute3 in varchar2 default hr_api.g_varchar2
354: ,p_crt_attribute4 in varchar2 default hr_api.g_varchar2
355: ,p_crt_attribute5 in varchar2 default hr_api.g_varchar2
356: ,p_crt_attribute6 in varchar2 default hr_api.g_varchar2
357: ,p_crt_attribute7 in varchar2 default hr_api.g_varchar2
358: ,p_crt_attribute8 in varchar2 default hr_api.g_varchar2
359: ,p_crt_attribute9 in varchar2 default hr_api.g_varchar2
360: ,p_crt_attribute10 in varchar2 default hr_api.g_varchar2

Line 357: ,p_crt_attribute7 in varchar2 default hr_api.g_varchar2

353: ,p_crt_attribute3 in varchar2 default hr_api.g_varchar2
354: ,p_crt_attribute4 in varchar2 default hr_api.g_varchar2
355: ,p_crt_attribute5 in varchar2 default hr_api.g_varchar2
356: ,p_crt_attribute6 in varchar2 default hr_api.g_varchar2
357: ,p_crt_attribute7 in varchar2 default hr_api.g_varchar2
358: ,p_crt_attribute8 in varchar2 default hr_api.g_varchar2
359: ,p_crt_attribute9 in varchar2 default hr_api.g_varchar2
360: ,p_crt_attribute10 in varchar2 default hr_api.g_varchar2
361: ,p_crt_attribute11 in varchar2 default hr_api.g_varchar2

Line 358: ,p_crt_attribute8 in varchar2 default hr_api.g_varchar2

354: ,p_crt_attribute4 in varchar2 default hr_api.g_varchar2
355: ,p_crt_attribute5 in varchar2 default hr_api.g_varchar2
356: ,p_crt_attribute6 in varchar2 default hr_api.g_varchar2
357: ,p_crt_attribute7 in varchar2 default hr_api.g_varchar2
358: ,p_crt_attribute8 in varchar2 default hr_api.g_varchar2
359: ,p_crt_attribute9 in varchar2 default hr_api.g_varchar2
360: ,p_crt_attribute10 in varchar2 default hr_api.g_varchar2
361: ,p_crt_attribute11 in varchar2 default hr_api.g_varchar2
362: ,p_crt_attribute12 in varchar2 default hr_api.g_varchar2

Line 359: ,p_crt_attribute9 in varchar2 default hr_api.g_varchar2

355: ,p_crt_attribute5 in varchar2 default hr_api.g_varchar2
356: ,p_crt_attribute6 in varchar2 default hr_api.g_varchar2
357: ,p_crt_attribute7 in varchar2 default hr_api.g_varchar2
358: ,p_crt_attribute8 in varchar2 default hr_api.g_varchar2
359: ,p_crt_attribute9 in varchar2 default hr_api.g_varchar2
360: ,p_crt_attribute10 in varchar2 default hr_api.g_varchar2
361: ,p_crt_attribute11 in varchar2 default hr_api.g_varchar2
362: ,p_crt_attribute12 in varchar2 default hr_api.g_varchar2
363: ,p_crt_attribute13 in varchar2 default hr_api.g_varchar2

Line 360: ,p_crt_attribute10 in varchar2 default hr_api.g_varchar2

356: ,p_crt_attribute6 in varchar2 default hr_api.g_varchar2
357: ,p_crt_attribute7 in varchar2 default hr_api.g_varchar2
358: ,p_crt_attribute8 in varchar2 default hr_api.g_varchar2
359: ,p_crt_attribute9 in varchar2 default hr_api.g_varchar2
360: ,p_crt_attribute10 in varchar2 default hr_api.g_varchar2
361: ,p_crt_attribute11 in varchar2 default hr_api.g_varchar2
362: ,p_crt_attribute12 in varchar2 default hr_api.g_varchar2
363: ,p_crt_attribute13 in varchar2 default hr_api.g_varchar2
364: ,p_crt_attribute14 in varchar2 default hr_api.g_varchar2

Line 361: ,p_crt_attribute11 in varchar2 default hr_api.g_varchar2

357: ,p_crt_attribute7 in varchar2 default hr_api.g_varchar2
358: ,p_crt_attribute8 in varchar2 default hr_api.g_varchar2
359: ,p_crt_attribute9 in varchar2 default hr_api.g_varchar2
360: ,p_crt_attribute10 in varchar2 default hr_api.g_varchar2
361: ,p_crt_attribute11 in varchar2 default hr_api.g_varchar2
362: ,p_crt_attribute12 in varchar2 default hr_api.g_varchar2
363: ,p_crt_attribute13 in varchar2 default hr_api.g_varchar2
364: ,p_crt_attribute14 in varchar2 default hr_api.g_varchar2
365: ,p_crt_attribute15 in varchar2 default hr_api.g_varchar2

Line 362: ,p_crt_attribute12 in varchar2 default hr_api.g_varchar2

358: ,p_crt_attribute8 in varchar2 default hr_api.g_varchar2
359: ,p_crt_attribute9 in varchar2 default hr_api.g_varchar2
360: ,p_crt_attribute10 in varchar2 default hr_api.g_varchar2
361: ,p_crt_attribute11 in varchar2 default hr_api.g_varchar2
362: ,p_crt_attribute12 in varchar2 default hr_api.g_varchar2
363: ,p_crt_attribute13 in varchar2 default hr_api.g_varchar2
364: ,p_crt_attribute14 in varchar2 default hr_api.g_varchar2
365: ,p_crt_attribute15 in varchar2 default hr_api.g_varchar2
366: ,p_crt_attribute16 in varchar2 default hr_api.g_varchar2

Line 363: ,p_crt_attribute13 in varchar2 default hr_api.g_varchar2

359: ,p_crt_attribute9 in varchar2 default hr_api.g_varchar2
360: ,p_crt_attribute10 in varchar2 default hr_api.g_varchar2
361: ,p_crt_attribute11 in varchar2 default hr_api.g_varchar2
362: ,p_crt_attribute12 in varchar2 default hr_api.g_varchar2
363: ,p_crt_attribute13 in varchar2 default hr_api.g_varchar2
364: ,p_crt_attribute14 in varchar2 default hr_api.g_varchar2
365: ,p_crt_attribute15 in varchar2 default hr_api.g_varchar2
366: ,p_crt_attribute16 in varchar2 default hr_api.g_varchar2
367: ,p_crt_attribute17 in varchar2 default hr_api.g_varchar2

Line 364: ,p_crt_attribute14 in varchar2 default hr_api.g_varchar2

360: ,p_crt_attribute10 in varchar2 default hr_api.g_varchar2
361: ,p_crt_attribute11 in varchar2 default hr_api.g_varchar2
362: ,p_crt_attribute12 in varchar2 default hr_api.g_varchar2
363: ,p_crt_attribute13 in varchar2 default hr_api.g_varchar2
364: ,p_crt_attribute14 in varchar2 default hr_api.g_varchar2
365: ,p_crt_attribute15 in varchar2 default hr_api.g_varchar2
366: ,p_crt_attribute16 in varchar2 default hr_api.g_varchar2
367: ,p_crt_attribute17 in varchar2 default hr_api.g_varchar2
368: ,p_crt_attribute18 in varchar2 default hr_api.g_varchar2

Line 365: ,p_crt_attribute15 in varchar2 default hr_api.g_varchar2

361: ,p_crt_attribute11 in varchar2 default hr_api.g_varchar2
362: ,p_crt_attribute12 in varchar2 default hr_api.g_varchar2
363: ,p_crt_attribute13 in varchar2 default hr_api.g_varchar2
364: ,p_crt_attribute14 in varchar2 default hr_api.g_varchar2
365: ,p_crt_attribute15 in varchar2 default hr_api.g_varchar2
366: ,p_crt_attribute16 in varchar2 default hr_api.g_varchar2
367: ,p_crt_attribute17 in varchar2 default hr_api.g_varchar2
368: ,p_crt_attribute18 in varchar2 default hr_api.g_varchar2
369: ,p_crt_attribute19 in varchar2 default hr_api.g_varchar2

Line 366: ,p_crt_attribute16 in varchar2 default hr_api.g_varchar2

362: ,p_crt_attribute12 in varchar2 default hr_api.g_varchar2
363: ,p_crt_attribute13 in varchar2 default hr_api.g_varchar2
364: ,p_crt_attribute14 in varchar2 default hr_api.g_varchar2
365: ,p_crt_attribute15 in varchar2 default hr_api.g_varchar2
366: ,p_crt_attribute16 in varchar2 default hr_api.g_varchar2
367: ,p_crt_attribute17 in varchar2 default hr_api.g_varchar2
368: ,p_crt_attribute18 in varchar2 default hr_api.g_varchar2
369: ,p_crt_attribute19 in varchar2 default hr_api.g_varchar2
370: ,p_crt_attribute20 in varchar2 default hr_api.g_varchar2

Line 367: ,p_crt_attribute17 in varchar2 default hr_api.g_varchar2

363: ,p_crt_attribute13 in varchar2 default hr_api.g_varchar2
364: ,p_crt_attribute14 in varchar2 default hr_api.g_varchar2
365: ,p_crt_attribute15 in varchar2 default hr_api.g_varchar2
366: ,p_crt_attribute16 in varchar2 default hr_api.g_varchar2
367: ,p_crt_attribute17 in varchar2 default hr_api.g_varchar2
368: ,p_crt_attribute18 in varchar2 default hr_api.g_varchar2
369: ,p_crt_attribute19 in varchar2 default hr_api.g_varchar2
370: ,p_crt_attribute20 in varchar2 default hr_api.g_varchar2
371: ,p_crt_attribute21 in varchar2 default hr_api.g_varchar2

Line 368: ,p_crt_attribute18 in varchar2 default hr_api.g_varchar2

364: ,p_crt_attribute14 in varchar2 default hr_api.g_varchar2
365: ,p_crt_attribute15 in varchar2 default hr_api.g_varchar2
366: ,p_crt_attribute16 in varchar2 default hr_api.g_varchar2
367: ,p_crt_attribute17 in varchar2 default hr_api.g_varchar2
368: ,p_crt_attribute18 in varchar2 default hr_api.g_varchar2
369: ,p_crt_attribute19 in varchar2 default hr_api.g_varchar2
370: ,p_crt_attribute20 in varchar2 default hr_api.g_varchar2
371: ,p_crt_attribute21 in varchar2 default hr_api.g_varchar2
372: ,p_crt_attribute22 in varchar2 default hr_api.g_varchar2

Line 369: ,p_crt_attribute19 in varchar2 default hr_api.g_varchar2

365: ,p_crt_attribute15 in varchar2 default hr_api.g_varchar2
366: ,p_crt_attribute16 in varchar2 default hr_api.g_varchar2
367: ,p_crt_attribute17 in varchar2 default hr_api.g_varchar2
368: ,p_crt_attribute18 in varchar2 default hr_api.g_varchar2
369: ,p_crt_attribute19 in varchar2 default hr_api.g_varchar2
370: ,p_crt_attribute20 in varchar2 default hr_api.g_varchar2
371: ,p_crt_attribute21 in varchar2 default hr_api.g_varchar2
372: ,p_crt_attribute22 in varchar2 default hr_api.g_varchar2
373: ,p_crt_attribute23 in varchar2 default hr_api.g_varchar2

Line 370: ,p_crt_attribute20 in varchar2 default hr_api.g_varchar2

366: ,p_crt_attribute16 in varchar2 default hr_api.g_varchar2
367: ,p_crt_attribute17 in varchar2 default hr_api.g_varchar2
368: ,p_crt_attribute18 in varchar2 default hr_api.g_varchar2
369: ,p_crt_attribute19 in varchar2 default hr_api.g_varchar2
370: ,p_crt_attribute20 in varchar2 default hr_api.g_varchar2
371: ,p_crt_attribute21 in varchar2 default hr_api.g_varchar2
372: ,p_crt_attribute22 in varchar2 default hr_api.g_varchar2
373: ,p_crt_attribute23 in varchar2 default hr_api.g_varchar2
374: ,p_crt_attribute24 in varchar2 default hr_api.g_varchar2

Line 371: ,p_crt_attribute21 in varchar2 default hr_api.g_varchar2

367: ,p_crt_attribute17 in varchar2 default hr_api.g_varchar2
368: ,p_crt_attribute18 in varchar2 default hr_api.g_varchar2
369: ,p_crt_attribute19 in varchar2 default hr_api.g_varchar2
370: ,p_crt_attribute20 in varchar2 default hr_api.g_varchar2
371: ,p_crt_attribute21 in varchar2 default hr_api.g_varchar2
372: ,p_crt_attribute22 in varchar2 default hr_api.g_varchar2
373: ,p_crt_attribute23 in varchar2 default hr_api.g_varchar2
374: ,p_crt_attribute24 in varchar2 default hr_api.g_varchar2
375: ,p_crt_attribute25 in varchar2 default hr_api.g_varchar2

Line 372: ,p_crt_attribute22 in varchar2 default hr_api.g_varchar2

368: ,p_crt_attribute18 in varchar2 default hr_api.g_varchar2
369: ,p_crt_attribute19 in varchar2 default hr_api.g_varchar2
370: ,p_crt_attribute20 in varchar2 default hr_api.g_varchar2
371: ,p_crt_attribute21 in varchar2 default hr_api.g_varchar2
372: ,p_crt_attribute22 in varchar2 default hr_api.g_varchar2
373: ,p_crt_attribute23 in varchar2 default hr_api.g_varchar2
374: ,p_crt_attribute24 in varchar2 default hr_api.g_varchar2
375: ,p_crt_attribute25 in varchar2 default hr_api.g_varchar2
376: ,p_crt_attribute26 in varchar2 default hr_api.g_varchar2

Line 373: ,p_crt_attribute23 in varchar2 default hr_api.g_varchar2

369: ,p_crt_attribute19 in varchar2 default hr_api.g_varchar2
370: ,p_crt_attribute20 in varchar2 default hr_api.g_varchar2
371: ,p_crt_attribute21 in varchar2 default hr_api.g_varchar2
372: ,p_crt_attribute22 in varchar2 default hr_api.g_varchar2
373: ,p_crt_attribute23 in varchar2 default hr_api.g_varchar2
374: ,p_crt_attribute24 in varchar2 default hr_api.g_varchar2
375: ,p_crt_attribute25 in varchar2 default hr_api.g_varchar2
376: ,p_crt_attribute26 in varchar2 default hr_api.g_varchar2
377: ,p_crt_attribute27 in varchar2 default hr_api.g_varchar2

Line 374: ,p_crt_attribute24 in varchar2 default hr_api.g_varchar2

370: ,p_crt_attribute20 in varchar2 default hr_api.g_varchar2
371: ,p_crt_attribute21 in varchar2 default hr_api.g_varchar2
372: ,p_crt_attribute22 in varchar2 default hr_api.g_varchar2
373: ,p_crt_attribute23 in varchar2 default hr_api.g_varchar2
374: ,p_crt_attribute24 in varchar2 default hr_api.g_varchar2
375: ,p_crt_attribute25 in varchar2 default hr_api.g_varchar2
376: ,p_crt_attribute26 in varchar2 default hr_api.g_varchar2
377: ,p_crt_attribute27 in varchar2 default hr_api.g_varchar2
378: ,p_crt_attribute28 in varchar2 default hr_api.g_varchar2

Line 375: ,p_crt_attribute25 in varchar2 default hr_api.g_varchar2

371: ,p_crt_attribute21 in varchar2 default hr_api.g_varchar2
372: ,p_crt_attribute22 in varchar2 default hr_api.g_varchar2
373: ,p_crt_attribute23 in varchar2 default hr_api.g_varchar2
374: ,p_crt_attribute24 in varchar2 default hr_api.g_varchar2
375: ,p_crt_attribute25 in varchar2 default hr_api.g_varchar2
376: ,p_crt_attribute26 in varchar2 default hr_api.g_varchar2
377: ,p_crt_attribute27 in varchar2 default hr_api.g_varchar2
378: ,p_crt_attribute28 in varchar2 default hr_api.g_varchar2
379: ,p_crt_attribute29 in varchar2 default hr_api.g_varchar2

Line 376: ,p_crt_attribute26 in varchar2 default hr_api.g_varchar2

372: ,p_crt_attribute22 in varchar2 default hr_api.g_varchar2
373: ,p_crt_attribute23 in varchar2 default hr_api.g_varchar2
374: ,p_crt_attribute24 in varchar2 default hr_api.g_varchar2
375: ,p_crt_attribute25 in varchar2 default hr_api.g_varchar2
376: ,p_crt_attribute26 in varchar2 default hr_api.g_varchar2
377: ,p_crt_attribute27 in varchar2 default hr_api.g_varchar2
378: ,p_crt_attribute28 in varchar2 default hr_api.g_varchar2
379: ,p_crt_attribute29 in varchar2 default hr_api.g_varchar2
380: ,p_crt_attribute30 in varchar2 default hr_api.g_varchar2

Line 377: ,p_crt_attribute27 in varchar2 default hr_api.g_varchar2

373: ,p_crt_attribute23 in varchar2 default hr_api.g_varchar2
374: ,p_crt_attribute24 in varchar2 default hr_api.g_varchar2
375: ,p_crt_attribute25 in varchar2 default hr_api.g_varchar2
376: ,p_crt_attribute26 in varchar2 default hr_api.g_varchar2
377: ,p_crt_attribute27 in varchar2 default hr_api.g_varchar2
378: ,p_crt_attribute28 in varchar2 default hr_api.g_varchar2
379: ,p_crt_attribute29 in varchar2 default hr_api.g_varchar2
380: ,p_crt_attribute30 in varchar2 default hr_api.g_varchar2
381: ,p_object_version_number in out nocopy number

Line 378: ,p_crt_attribute28 in varchar2 default hr_api.g_varchar2

374: ,p_crt_attribute24 in varchar2 default hr_api.g_varchar2
375: ,p_crt_attribute25 in varchar2 default hr_api.g_varchar2
376: ,p_crt_attribute26 in varchar2 default hr_api.g_varchar2
377: ,p_crt_attribute27 in varchar2 default hr_api.g_varchar2
378: ,p_crt_attribute28 in varchar2 default hr_api.g_varchar2
379: ,p_crt_attribute29 in varchar2 default hr_api.g_varchar2
380: ,p_crt_attribute30 in varchar2 default hr_api.g_varchar2
381: ,p_object_version_number in out nocopy number
382: ,p_qdro_num_pymt_val in number default hr_api.g_number

Line 379: ,p_crt_attribute29 in varchar2 default hr_api.g_varchar2

375: ,p_crt_attribute25 in varchar2 default hr_api.g_varchar2
376: ,p_crt_attribute26 in varchar2 default hr_api.g_varchar2
377: ,p_crt_attribute27 in varchar2 default hr_api.g_varchar2
378: ,p_crt_attribute28 in varchar2 default hr_api.g_varchar2
379: ,p_crt_attribute29 in varchar2 default hr_api.g_varchar2
380: ,p_crt_attribute30 in varchar2 default hr_api.g_varchar2
381: ,p_object_version_number in out nocopy number
382: ,p_qdro_num_pymt_val in number default hr_api.g_number
383: ,p_qdro_per_perd_cd in varchar2 default hr_api.g_varchar2

Line 380: ,p_crt_attribute30 in varchar2 default hr_api.g_varchar2

376: ,p_crt_attribute26 in varchar2 default hr_api.g_varchar2
377: ,p_crt_attribute27 in varchar2 default hr_api.g_varchar2
378: ,p_crt_attribute28 in varchar2 default hr_api.g_varchar2
379: ,p_crt_attribute29 in varchar2 default hr_api.g_varchar2
380: ,p_crt_attribute30 in varchar2 default hr_api.g_varchar2
381: ,p_object_version_number in out nocopy number
382: ,p_qdro_num_pymt_val in number default hr_api.g_number
383: ,p_qdro_per_perd_cd in varchar2 default hr_api.g_varchar2
384: ,p_pl_typ_id in number default hr_api.g_number

Line 382: ,p_qdro_num_pymt_val in number default hr_api.g_number

378: ,p_crt_attribute28 in varchar2 default hr_api.g_varchar2
379: ,p_crt_attribute29 in varchar2 default hr_api.g_varchar2
380: ,p_crt_attribute30 in varchar2 default hr_api.g_varchar2
381: ,p_object_version_number in out nocopy number
382: ,p_qdro_num_pymt_val in number default hr_api.g_number
383: ,p_qdro_per_perd_cd in varchar2 default hr_api.g_varchar2
384: ,p_pl_typ_id in number default hr_api.g_number
385: ,p_effective_date in date
386: ) is

Line 383: ,p_qdro_per_perd_cd in varchar2 default hr_api.g_varchar2

379: ,p_crt_attribute29 in varchar2 default hr_api.g_varchar2
380: ,p_crt_attribute30 in varchar2 default hr_api.g_varchar2
381: ,p_object_version_number in out nocopy number
382: ,p_qdro_num_pymt_val in number default hr_api.g_number
383: ,p_qdro_per_perd_cd in varchar2 default hr_api.g_varchar2
384: ,p_pl_typ_id in number default hr_api.g_number
385: ,p_effective_date in date
386: ) is
387: --

Line 384: ,p_pl_typ_id in number default hr_api.g_number

380: ,p_crt_attribute30 in varchar2 default hr_api.g_varchar2
381: ,p_object_version_number in out nocopy number
382: ,p_qdro_num_pymt_val in number default hr_api.g_number
383: ,p_qdro_per_perd_cd in varchar2 default hr_api.g_varchar2
384: ,p_pl_typ_id in number default hr_api.g_number
385: ,p_effective_date in date
386: ) is
387: --
388: -- Declare cursors and local variables

Line 468: when hr_api.cannot_find_prog_unit then

464: ,p_pl_typ_id => p_pl_typ_id
465: ,p_effective_date => trunc(p_effective_date)
466: );
467: exception
468: when hr_api.cannot_find_prog_unit then
469: hr_api.cannot_find_prog_unit_error
470: (p_module_name => 'UPDATE_court_orders'
471: ,p_hook_type => 'BP'
472: );

Line 469: hr_api.cannot_find_prog_unit_error

465: ,p_effective_date => trunc(p_effective_date)
466: );
467: exception
468: when hr_api.cannot_find_prog_unit then
469: hr_api.cannot_find_prog_unit_error
470: (p_module_name => 'UPDATE_court_orders'
471: ,p_hook_type => 'BP'
472: );
473: --

Line 596: when hr_api.cannot_find_prog_unit then

592: ,p_pl_typ_id => p_pl_typ_id
593: ,p_effective_date => trunc(p_effective_date)
594: );
595: exception
596: when hr_api.cannot_find_prog_unit then
597: hr_api.cannot_find_prog_unit_error
598: (p_module_name => 'UPDATE_court_orders'
599: ,p_hook_type => 'AP'
600: );

Line 597: hr_api.cannot_find_prog_unit_error

593: ,p_effective_date => trunc(p_effective_date)
594: );
595: exception
596: when hr_api.cannot_find_prog_unit then
597: hr_api.cannot_find_prog_unit_error
598: (p_module_name => 'UPDATE_court_orders'
599: ,p_hook_type => 'AP'
600: );
601: --

Line 611: raise hr_api.validate_enabled;

607: --
608: -- When in validation only mode raise the Validate_Enabled exception
609: --
610: if p_validate then
611: raise hr_api.validate_enabled;
612: end if;
613: --
614: -- Set all output arguments
615: --

Line 622: when hr_api.validate_enabled then

618: hr_utility.set_location(' Leaving:'||l_proc, 70);
619: --
620: exception
621: --
622: when hr_api.validate_enabled then
623: --
624: -- As the Validate_Enabled exception has been raised
625: -- we must rollback to the savepoint
626: --

Line 686: when hr_api.cannot_find_prog_unit then

682: ,p_object_version_number => p_object_version_number
683: ,p_effective_date => trunc(p_effective_date)
684: );
685: exception
686: when hr_api.cannot_find_prog_unit then
687: hr_api.cannot_find_prog_unit_error
688: (p_module_name => 'DELETE_court_orders'
689: ,p_hook_type => 'BP'
690: );

Line 687: hr_api.cannot_find_prog_unit_error

683: ,p_effective_date => trunc(p_effective_date)
684: );
685: exception
686: when hr_api.cannot_find_prog_unit then
687: hr_api.cannot_find_prog_unit_error
688: (p_module_name => 'DELETE_court_orders'
689: ,p_hook_type => 'BP'
690: );
691: --

Line 714: when hr_api.cannot_find_prog_unit then

710: ,p_object_version_number => l_object_version_number
711: ,p_effective_date => trunc(p_effective_date)
712: );
713: exception
714: when hr_api.cannot_find_prog_unit then
715: hr_api.cannot_find_prog_unit_error
716: (p_module_name => 'DELETE_court_orders'
717: ,p_hook_type => 'AP'
718: );

Line 715: hr_api.cannot_find_prog_unit_error

711: ,p_effective_date => trunc(p_effective_date)
712: );
713: exception
714: when hr_api.cannot_find_prog_unit then
715: hr_api.cannot_find_prog_unit_error
716: (p_module_name => 'DELETE_court_orders'
717: ,p_hook_type => 'AP'
718: );
719: --

Line 729: raise hr_api.validate_enabled;

725: --
726: -- When in validation only mode raise the Validate_Enabled exception
727: --
728: if p_validate then
729: raise hr_api.validate_enabled;
730: end if;
731: --
732: hr_utility.set_location(' Leaving:'||l_proc, 70);
733: --

Line 736: when hr_api.validate_enabled then

732: hr_utility.set_location(' Leaving:'||l_proc, 70);
733: --
734: exception
735: --
736: when hr_api.validate_enabled then
737: --
738: -- As the Validate_Enabled exception has been raised
739: -- we must rollback to the savepoint
740: --