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