129: ,p_effective_date => trunc(p_effective_date));
130: --
131: exception
132: --
133: when hr_api.cannot_find_prog_unit then
134: --
135: hr_api.cannot_find_prog_unit_error
136: (p_module_name => 'CREATE_cm_typ_usg'
137: ,p_hook_type => 'BP');
131: exception
132: --
133: when hr_api.cannot_find_prog_unit then
134: --
135: hr_api.cannot_find_prog_unit_error
136: (p_module_name => 'CREATE_cm_typ_usg'
137: ,p_hook_type => 'BP');
138: --
139: -- End of API User Hook for the before hook of create_cm_typ_usg
243: ,p_effective_date => trunc(p_effective_date));
244: --
245: exception
246: --
247: when hr_api.cannot_find_prog_unit then
248: --
249: hr_api.cannot_find_prog_unit_error
250: (p_module_name => 'CREATE_cm_typ_usg'
251: ,p_hook_type => 'AP');
245: exception
246: --
247: when hr_api.cannot_find_prog_unit then
248: --
249: hr_api.cannot_find_prog_unit_error
250: (p_module_name => 'CREATE_cm_typ_usg'
251: ,p_hook_type => 'AP');
252: --
253: -- End of API User Hook for the after hook of create_cm_typ_usg
258: --
259: -- When in validation only mode raise the Validate_Enabled exception
260: --
261: if p_validate then
262: raise hr_api.validate_enabled;
263: end if;
264: --
265: -- Set all output arguments
266: --
272: hr_utility.set_location(' Leaving:'||l_proc, 70);
273: --
274: exception
275: --
276: when hr_api.validate_enabled then
277: --
278: -- As the Validate_Enabled exception has been raised
279: -- we must rollback to the savepoint
280: --
310: (p_validate in boolean default false
311: ,p_cm_typ_usg_id in number
312: ,p_effective_start_date out nocopy date
313: ,p_effective_end_date out nocopy date
314: ,p_all_r_any_cd in varchar2 default hr_api.g_varchar2
315: ,p_cm_usg_rl in number default hr_api.g_number
316: ,p_descr_text in varchar2 default hr_api.g_varchar2
317: ,p_pgm_id in number default hr_api.g_number
318: ,p_pl_id in number default hr_api.g_number
311: ,p_cm_typ_usg_id in number
312: ,p_effective_start_date out nocopy date
313: ,p_effective_end_date out nocopy date
314: ,p_all_r_any_cd in varchar2 default hr_api.g_varchar2
315: ,p_cm_usg_rl in number default hr_api.g_number
316: ,p_descr_text in varchar2 default hr_api.g_varchar2
317: ,p_pgm_id in number default hr_api.g_number
318: ,p_pl_id in number default hr_api.g_number
319: ,p_pl_typ_id in number default hr_api.g_number
312: ,p_effective_start_date out nocopy date
313: ,p_effective_end_date out nocopy date
314: ,p_all_r_any_cd in varchar2 default hr_api.g_varchar2
315: ,p_cm_usg_rl in number default hr_api.g_number
316: ,p_descr_text in varchar2 default hr_api.g_varchar2
317: ,p_pgm_id in number default hr_api.g_number
318: ,p_pl_id in number default hr_api.g_number
319: ,p_pl_typ_id in number default hr_api.g_number
320: ,p_enrt_perd_id in number default hr_api.g_number
313: ,p_effective_end_date out nocopy date
314: ,p_all_r_any_cd in varchar2 default hr_api.g_varchar2
315: ,p_cm_usg_rl in number default hr_api.g_number
316: ,p_descr_text in varchar2 default hr_api.g_varchar2
317: ,p_pgm_id in number default hr_api.g_number
318: ,p_pl_id in number default hr_api.g_number
319: ,p_pl_typ_id in number default hr_api.g_number
320: ,p_enrt_perd_id in number default hr_api.g_number
321: ,p_actn_typ_id in number default hr_api.g_number
314: ,p_all_r_any_cd in varchar2 default hr_api.g_varchar2
315: ,p_cm_usg_rl in number default hr_api.g_number
316: ,p_descr_text in varchar2 default hr_api.g_varchar2
317: ,p_pgm_id in number default hr_api.g_number
318: ,p_pl_id in number default hr_api.g_number
319: ,p_pl_typ_id in number default hr_api.g_number
320: ,p_enrt_perd_id in number default hr_api.g_number
321: ,p_actn_typ_id in number default hr_api.g_number
322: ,p_cm_typ_id in number default hr_api.g_number
315: ,p_cm_usg_rl in number default hr_api.g_number
316: ,p_descr_text in varchar2 default hr_api.g_varchar2
317: ,p_pgm_id in number default hr_api.g_number
318: ,p_pl_id in number default hr_api.g_number
319: ,p_pl_typ_id in number default hr_api.g_number
320: ,p_enrt_perd_id in number default hr_api.g_number
321: ,p_actn_typ_id in number default hr_api.g_number
322: ,p_cm_typ_id in number default hr_api.g_number
323: ,p_ler_id in number default hr_api.g_number
316: ,p_descr_text in varchar2 default hr_api.g_varchar2
317: ,p_pgm_id in number default hr_api.g_number
318: ,p_pl_id in number default hr_api.g_number
319: ,p_pl_typ_id in number default hr_api.g_number
320: ,p_enrt_perd_id in number default hr_api.g_number
321: ,p_actn_typ_id in number default hr_api.g_number
322: ,p_cm_typ_id in number default hr_api.g_number
323: ,p_ler_id in number default hr_api.g_number
324: ,p_business_group_id in number default hr_api.g_number
317: ,p_pgm_id in number default hr_api.g_number
318: ,p_pl_id in number default hr_api.g_number
319: ,p_pl_typ_id in number default hr_api.g_number
320: ,p_enrt_perd_id in number default hr_api.g_number
321: ,p_actn_typ_id in number default hr_api.g_number
322: ,p_cm_typ_id in number default hr_api.g_number
323: ,p_ler_id in number default hr_api.g_number
324: ,p_business_group_id in number default hr_api.g_number
325: ,p_ctu_attribute_category in varchar2 default hr_api.g_varchar2
318: ,p_pl_id in number default hr_api.g_number
319: ,p_pl_typ_id in number default hr_api.g_number
320: ,p_enrt_perd_id in number default hr_api.g_number
321: ,p_actn_typ_id in number default hr_api.g_number
322: ,p_cm_typ_id in number default hr_api.g_number
323: ,p_ler_id in number default hr_api.g_number
324: ,p_business_group_id in number default hr_api.g_number
325: ,p_ctu_attribute_category in varchar2 default hr_api.g_varchar2
326: ,p_ctu_attribute1 in varchar2 default hr_api.g_varchar2
319: ,p_pl_typ_id in number default hr_api.g_number
320: ,p_enrt_perd_id in number default hr_api.g_number
321: ,p_actn_typ_id in number default hr_api.g_number
322: ,p_cm_typ_id in number default hr_api.g_number
323: ,p_ler_id in number default hr_api.g_number
324: ,p_business_group_id in number default hr_api.g_number
325: ,p_ctu_attribute_category in varchar2 default hr_api.g_varchar2
326: ,p_ctu_attribute1 in varchar2 default hr_api.g_varchar2
327: ,p_ctu_attribute2 in varchar2 default hr_api.g_varchar2
320: ,p_enrt_perd_id in number default hr_api.g_number
321: ,p_actn_typ_id in number default hr_api.g_number
322: ,p_cm_typ_id in number default hr_api.g_number
323: ,p_ler_id in number default hr_api.g_number
324: ,p_business_group_id in number default hr_api.g_number
325: ,p_ctu_attribute_category in varchar2 default hr_api.g_varchar2
326: ,p_ctu_attribute1 in varchar2 default hr_api.g_varchar2
327: ,p_ctu_attribute2 in varchar2 default hr_api.g_varchar2
328: ,p_ctu_attribute3 in varchar2 default hr_api.g_varchar2
321: ,p_actn_typ_id in number default hr_api.g_number
322: ,p_cm_typ_id in number default hr_api.g_number
323: ,p_ler_id in number default hr_api.g_number
324: ,p_business_group_id in number default hr_api.g_number
325: ,p_ctu_attribute_category in varchar2 default hr_api.g_varchar2
326: ,p_ctu_attribute1 in varchar2 default hr_api.g_varchar2
327: ,p_ctu_attribute2 in varchar2 default hr_api.g_varchar2
328: ,p_ctu_attribute3 in varchar2 default hr_api.g_varchar2
329: ,p_ctu_attribute4 in varchar2 default hr_api.g_varchar2
322: ,p_cm_typ_id in number default hr_api.g_number
323: ,p_ler_id in number default hr_api.g_number
324: ,p_business_group_id in number default hr_api.g_number
325: ,p_ctu_attribute_category in varchar2 default hr_api.g_varchar2
326: ,p_ctu_attribute1 in varchar2 default hr_api.g_varchar2
327: ,p_ctu_attribute2 in varchar2 default hr_api.g_varchar2
328: ,p_ctu_attribute3 in varchar2 default hr_api.g_varchar2
329: ,p_ctu_attribute4 in varchar2 default hr_api.g_varchar2
330: ,p_ctu_attribute5 in varchar2 default hr_api.g_varchar2
323: ,p_ler_id in number default hr_api.g_number
324: ,p_business_group_id in number default hr_api.g_number
325: ,p_ctu_attribute_category in varchar2 default hr_api.g_varchar2
326: ,p_ctu_attribute1 in varchar2 default hr_api.g_varchar2
327: ,p_ctu_attribute2 in varchar2 default hr_api.g_varchar2
328: ,p_ctu_attribute3 in varchar2 default hr_api.g_varchar2
329: ,p_ctu_attribute4 in varchar2 default hr_api.g_varchar2
330: ,p_ctu_attribute5 in varchar2 default hr_api.g_varchar2
331: ,p_ctu_attribute6 in varchar2 default hr_api.g_varchar2
324: ,p_business_group_id in number default hr_api.g_number
325: ,p_ctu_attribute_category in varchar2 default hr_api.g_varchar2
326: ,p_ctu_attribute1 in varchar2 default hr_api.g_varchar2
327: ,p_ctu_attribute2 in varchar2 default hr_api.g_varchar2
328: ,p_ctu_attribute3 in varchar2 default hr_api.g_varchar2
329: ,p_ctu_attribute4 in varchar2 default hr_api.g_varchar2
330: ,p_ctu_attribute5 in varchar2 default hr_api.g_varchar2
331: ,p_ctu_attribute6 in varchar2 default hr_api.g_varchar2
332: ,p_ctu_attribute7 in varchar2 default hr_api.g_varchar2
325: ,p_ctu_attribute_category in varchar2 default hr_api.g_varchar2
326: ,p_ctu_attribute1 in varchar2 default hr_api.g_varchar2
327: ,p_ctu_attribute2 in varchar2 default hr_api.g_varchar2
328: ,p_ctu_attribute3 in varchar2 default hr_api.g_varchar2
329: ,p_ctu_attribute4 in varchar2 default hr_api.g_varchar2
330: ,p_ctu_attribute5 in varchar2 default hr_api.g_varchar2
331: ,p_ctu_attribute6 in varchar2 default hr_api.g_varchar2
332: ,p_ctu_attribute7 in varchar2 default hr_api.g_varchar2
333: ,p_ctu_attribute8 in varchar2 default hr_api.g_varchar2
326: ,p_ctu_attribute1 in varchar2 default hr_api.g_varchar2
327: ,p_ctu_attribute2 in varchar2 default hr_api.g_varchar2
328: ,p_ctu_attribute3 in varchar2 default hr_api.g_varchar2
329: ,p_ctu_attribute4 in varchar2 default hr_api.g_varchar2
330: ,p_ctu_attribute5 in varchar2 default hr_api.g_varchar2
331: ,p_ctu_attribute6 in varchar2 default hr_api.g_varchar2
332: ,p_ctu_attribute7 in varchar2 default hr_api.g_varchar2
333: ,p_ctu_attribute8 in varchar2 default hr_api.g_varchar2
334: ,p_ctu_attribute9 in varchar2 default hr_api.g_varchar2
327: ,p_ctu_attribute2 in varchar2 default hr_api.g_varchar2
328: ,p_ctu_attribute3 in varchar2 default hr_api.g_varchar2
329: ,p_ctu_attribute4 in varchar2 default hr_api.g_varchar2
330: ,p_ctu_attribute5 in varchar2 default hr_api.g_varchar2
331: ,p_ctu_attribute6 in varchar2 default hr_api.g_varchar2
332: ,p_ctu_attribute7 in varchar2 default hr_api.g_varchar2
333: ,p_ctu_attribute8 in varchar2 default hr_api.g_varchar2
334: ,p_ctu_attribute9 in varchar2 default hr_api.g_varchar2
335: ,p_ctu_attribute10 in varchar2 default hr_api.g_varchar2
328: ,p_ctu_attribute3 in varchar2 default hr_api.g_varchar2
329: ,p_ctu_attribute4 in varchar2 default hr_api.g_varchar2
330: ,p_ctu_attribute5 in varchar2 default hr_api.g_varchar2
331: ,p_ctu_attribute6 in varchar2 default hr_api.g_varchar2
332: ,p_ctu_attribute7 in varchar2 default hr_api.g_varchar2
333: ,p_ctu_attribute8 in varchar2 default hr_api.g_varchar2
334: ,p_ctu_attribute9 in varchar2 default hr_api.g_varchar2
335: ,p_ctu_attribute10 in varchar2 default hr_api.g_varchar2
336: ,p_ctu_attribute11 in varchar2 default hr_api.g_varchar2
329: ,p_ctu_attribute4 in varchar2 default hr_api.g_varchar2
330: ,p_ctu_attribute5 in varchar2 default hr_api.g_varchar2
331: ,p_ctu_attribute6 in varchar2 default hr_api.g_varchar2
332: ,p_ctu_attribute7 in varchar2 default hr_api.g_varchar2
333: ,p_ctu_attribute8 in varchar2 default hr_api.g_varchar2
334: ,p_ctu_attribute9 in varchar2 default hr_api.g_varchar2
335: ,p_ctu_attribute10 in varchar2 default hr_api.g_varchar2
336: ,p_ctu_attribute11 in varchar2 default hr_api.g_varchar2
337: ,p_ctu_attribute12 in varchar2 default hr_api.g_varchar2
330: ,p_ctu_attribute5 in varchar2 default hr_api.g_varchar2
331: ,p_ctu_attribute6 in varchar2 default hr_api.g_varchar2
332: ,p_ctu_attribute7 in varchar2 default hr_api.g_varchar2
333: ,p_ctu_attribute8 in varchar2 default hr_api.g_varchar2
334: ,p_ctu_attribute9 in varchar2 default hr_api.g_varchar2
335: ,p_ctu_attribute10 in varchar2 default hr_api.g_varchar2
336: ,p_ctu_attribute11 in varchar2 default hr_api.g_varchar2
337: ,p_ctu_attribute12 in varchar2 default hr_api.g_varchar2
338: ,p_ctu_attribute13 in varchar2 default hr_api.g_varchar2
331: ,p_ctu_attribute6 in varchar2 default hr_api.g_varchar2
332: ,p_ctu_attribute7 in varchar2 default hr_api.g_varchar2
333: ,p_ctu_attribute8 in varchar2 default hr_api.g_varchar2
334: ,p_ctu_attribute9 in varchar2 default hr_api.g_varchar2
335: ,p_ctu_attribute10 in varchar2 default hr_api.g_varchar2
336: ,p_ctu_attribute11 in varchar2 default hr_api.g_varchar2
337: ,p_ctu_attribute12 in varchar2 default hr_api.g_varchar2
338: ,p_ctu_attribute13 in varchar2 default hr_api.g_varchar2
339: ,p_ctu_attribute14 in varchar2 default hr_api.g_varchar2
332: ,p_ctu_attribute7 in varchar2 default hr_api.g_varchar2
333: ,p_ctu_attribute8 in varchar2 default hr_api.g_varchar2
334: ,p_ctu_attribute9 in varchar2 default hr_api.g_varchar2
335: ,p_ctu_attribute10 in varchar2 default hr_api.g_varchar2
336: ,p_ctu_attribute11 in varchar2 default hr_api.g_varchar2
337: ,p_ctu_attribute12 in varchar2 default hr_api.g_varchar2
338: ,p_ctu_attribute13 in varchar2 default hr_api.g_varchar2
339: ,p_ctu_attribute14 in varchar2 default hr_api.g_varchar2
340: ,p_ctu_attribute15 in varchar2 default hr_api.g_varchar2
333: ,p_ctu_attribute8 in varchar2 default hr_api.g_varchar2
334: ,p_ctu_attribute9 in varchar2 default hr_api.g_varchar2
335: ,p_ctu_attribute10 in varchar2 default hr_api.g_varchar2
336: ,p_ctu_attribute11 in varchar2 default hr_api.g_varchar2
337: ,p_ctu_attribute12 in varchar2 default hr_api.g_varchar2
338: ,p_ctu_attribute13 in varchar2 default hr_api.g_varchar2
339: ,p_ctu_attribute14 in varchar2 default hr_api.g_varchar2
340: ,p_ctu_attribute15 in varchar2 default hr_api.g_varchar2
341: ,p_ctu_attribute16 in varchar2 default hr_api.g_varchar2
334: ,p_ctu_attribute9 in varchar2 default hr_api.g_varchar2
335: ,p_ctu_attribute10 in varchar2 default hr_api.g_varchar2
336: ,p_ctu_attribute11 in varchar2 default hr_api.g_varchar2
337: ,p_ctu_attribute12 in varchar2 default hr_api.g_varchar2
338: ,p_ctu_attribute13 in varchar2 default hr_api.g_varchar2
339: ,p_ctu_attribute14 in varchar2 default hr_api.g_varchar2
340: ,p_ctu_attribute15 in varchar2 default hr_api.g_varchar2
341: ,p_ctu_attribute16 in varchar2 default hr_api.g_varchar2
342: ,p_ctu_attribute17 in varchar2 default hr_api.g_varchar2
335: ,p_ctu_attribute10 in varchar2 default hr_api.g_varchar2
336: ,p_ctu_attribute11 in varchar2 default hr_api.g_varchar2
337: ,p_ctu_attribute12 in varchar2 default hr_api.g_varchar2
338: ,p_ctu_attribute13 in varchar2 default hr_api.g_varchar2
339: ,p_ctu_attribute14 in varchar2 default hr_api.g_varchar2
340: ,p_ctu_attribute15 in varchar2 default hr_api.g_varchar2
341: ,p_ctu_attribute16 in varchar2 default hr_api.g_varchar2
342: ,p_ctu_attribute17 in varchar2 default hr_api.g_varchar2
343: ,p_ctu_attribute18 in varchar2 default hr_api.g_varchar2
336: ,p_ctu_attribute11 in varchar2 default hr_api.g_varchar2
337: ,p_ctu_attribute12 in varchar2 default hr_api.g_varchar2
338: ,p_ctu_attribute13 in varchar2 default hr_api.g_varchar2
339: ,p_ctu_attribute14 in varchar2 default hr_api.g_varchar2
340: ,p_ctu_attribute15 in varchar2 default hr_api.g_varchar2
341: ,p_ctu_attribute16 in varchar2 default hr_api.g_varchar2
342: ,p_ctu_attribute17 in varchar2 default hr_api.g_varchar2
343: ,p_ctu_attribute18 in varchar2 default hr_api.g_varchar2
344: ,p_ctu_attribute19 in varchar2 default hr_api.g_varchar2
337: ,p_ctu_attribute12 in varchar2 default hr_api.g_varchar2
338: ,p_ctu_attribute13 in varchar2 default hr_api.g_varchar2
339: ,p_ctu_attribute14 in varchar2 default hr_api.g_varchar2
340: ,p_ctu_attribute15 in varchar2 default hr_api.g_varchar2
341: ,p_ctu_attribute16 in varchar2 default hr_api.g_varchar2
342: ,p_ctu_attribute17 in varchar2 default hr_api.g_varchar2
343: ,p_ctu_attribute18 in varchar2 default hr_api.g_varchar2
344: ,p_ctu_attribute19 in varchar2 default hr_api.g_varchar2
345: ,p_ctu_attribute20 in varchar2 default hr_api.g_varchar2
338: ,p_ctu_attribute13 in varchar2 default hr_api.g_varchar2
339: ,p_ctu_attribute14 in varchar2 default hr_api.g_varchar2
340: ,p_ctu_attribute15 in varchar2 default hr_api.g_varchar2
341: ,p_ctu_attribute16 in varchar2 default hr_api.g_varchar2
342: ,p_ctu_attribute17 in varchar2 default hr_api.g_varchar2
343: ,p_ctu_attribute18 in varchar2 default hr_api.g_varchar2
344: ,p_ctu_attribute19 in varchar2 default hr_api.g_varchar2
345: ,p_ctu_attribute20 in varchar2 default hr_api.g_varchar2
346: ,p_ctu_attribute21 in varchar2 default hr_api.g_varchar2
339: ,p_ctu_attribute14 in varchar2 default hr_api.g_varchar2
340: ,p_ctu_attribute15 in varchar2 default hr_api.g_varchar2
341: ,p_ctu_attribute16 in varchar2 default hr_api.g_varchar2
342: ,p_ctu_attribute17 in varchar2 default hr_api.g_varchar2
343: ,p_ctu_attribute18 in varchar2 default hr_api.g_varchar2
344: ,p_ctu_attribute19 in varchar2 default hr_api.g_varchar2
345: ,p_ctu_attribute20 in varchar2 default hr_api.g_varchar2
346: ,p_ctu_attribute21 in varchar2 default hr_api.g_varchar2
347: ,p_ctu_attribute22 in varchar2 default hr_api.g_varchar2
340: ,p_ctu_attribute15 in varchar2 default hr_api.g_varchar2
341: ,p_ctu_attribute16 in varchar2 default hr_api.g_varchar2
342: ,p_ctu_attribute17 in varchar2 default hr_api.g_varchar2
343: ,p_ctu_attribute18 in varchar2 default hr_api.g_varchar2
344: ,p_ctu_attribute19 in varchar2 default hr_api.g_varchar2
345: ,p_ctu_attribute20 in varchar2 default hr_api.g_varchar2
346: ,p_ctu_attribute21 in varchar2 default hr_api.g_varchar2
347: ,p_ctu_attribute22 in varchar2 default hr_api.g_varchar2
348: ,p_ctu_attribute23 in varchar2 default hr_api.g_varchar2
341: ,p_ctu_attribute16 in varchar2 default hr_api.g_varchar2
342: ,p_ctu_attribute17 in varchar2 default hr_api.g_varchar2
343: ,p_ctu_attribute18 in varchar2 default hr_api.g_varchar2
344: ,p_ctu_attribute19 in varchar2 default hr_api.g_varchar2
345: ,p_ctu_attribute20 in varchar2 default hr_api.g_varchar2
346: ,p_ctu_attribute21 in varchar2 default hr_api.g_varchar2
347: ,p_ctu_attribute22 in varchar2 default hr_api.g_varchar2
348: ,p_ctu_attribute23 in varchar2 default hr_api.g_varchar2
349: ,p_ctu_attribute24 in varchar2 default hr_api.g_varchar2
342: ,p_ctu_attribute17 in varchar2 default hr_api.g_varchar2
343: ,p_ctu_attribute18 in varchar2 default hr_api.g_varchar2
344: ,p_ctu_attribute19 in varchar2 default hr_api.g_varchar2
345: ,p_ctu_attribute20 in varchar2 default hr_api.g_varchar2
346: ,p_ctu_attribute21 in varchar2 default hr_api.g_varchar2
347: ,p_ctu_attribute22 in varchar2 default hr_api.g_varchar2
348: ,p_ctu_attribute23 in varchar2 default hr_api.g_varchar2
349: ,p_ctu_attribute24 in varchar2 default hr_api.g_varchar2
350: ,p_ctu_attribute25 in varchar2 default hr_api.g_varchar2
343: ,p_ctu_attribute18 in varchar2 default hr_api.g_varchar2
344: ,p_ctu_attribute19 in varchar2 default hr_api.g_varchar2
345: ,p_ctu_attribute20 in varchar2 default hr_api.g_varchar2
346: ,p_ctu_attribute21 in varchar2 default hr_api.g_varchar2
347: ,p_ctu_attribute22 in varchar2 default hr_api.g_varchar2
348: ,p_ctu_attribute23 in varchar2 default hr_api.g_varchar2
349: ,p_ctu_attribute24 in varchar2 default hr_api.g_varchar2
350: ,p_ctu_attribute25 in varchar2 default hr_api.g_varchar2
351: ,p_ctu_attribute26 in varchar2 default hr_api.g_varchar2
344: ,p_ctu_attribute19 in varchar2 default hr_api.g_varchar2
345: ,p_ctu_attribute20 in varchar2 default hr_api.g_varchar2
346: ,p_ctu_attribute21 in varchar2 default hr_api.g_varchar2
347: ,p_ctu_attribute22 in varchar2 default hr_api.g_varchar2
348: ,p_ctu_attribute23 in varchar2 default hr_api.g_varchar2
349: ,p_ctu_attribute24 in varchar2 default hr_api.g_varchar2
350: ,p_ctu_attribute25 in varchar2 default hr_api.g_varchar2
351: ,p_ctu_attribute26 in varchar2 default hr_api.g_varchar2
352: ,p_ctu_attribute27 in varchar2 default hr_api.g_varchar2
345: ,p_ctu_attribute20 in varchar2 default hr_api.g_varchar2
346: ,p_ctu_attribute21 in varchar2 default hr_api.g_varchar2
347: ,p_ctu_attribute22 in varchar2 default hr_api.g_varchar2
348: ,p_ctu_attribute23 in varchar2 default hr_api.g_varchar2
349: ,p_ctu_attribute24 in varchar2 default hr_api.g_varchar2
350: ,p_ctu_attribute25 in varchar2 default hr_api.g_varchar2
351: ,p_ctu_attribute26 in varchar2 default hr_api.g_varchar2
352: ,p_ctu_attribute27 in varchar2 default hr_api.g_varchar2
353: ,p_ctu_attribute28 in varchar2 default hr_api.g_varchar2
346: ,p_ctu_attribute21 in varchar2 default hr_api.g_varchar2
347: ,p_ctu_attribute22 in varchar2 default hr_api.g_varchar2
348: ,p_ctu_attribute23 in varchar2 default hr_api.g_varchar2
349: ,p_ctu_attribute24 in varchar2 default hr_api.g_varchar2
350: ,p_ctu_attribute25 in varchar2 default hr_api.g_varchar2
351: ,p_ctu_attribute26 in varchar2 default hr_api.g_varchar2
352: ,p_ctu_attribute27 in varchar2 default hr_api.g_varchar2
353: ,p_ctu_attribute28 in varchar2 default hr_api.g_varchar2
354: ,p_ctu_attribute29 in varchar2 default hr_api.g_varchar2
347: ,p_ctu_attribute22 in varchar2 default hr_api.g_varchar2
348: ,p_ctu_attribute23 in varchar2 default hr_api.g_varchar2
349: ,p_ctu_attribute24 in varchar2 default hr_api.g_varchar2
350: ,p_ctu_attribute25 in varchar2 default hr_api.g_varchar2
351: ,p_ctu_attribute26 in varchar2 default hr_api.g_varchar2
352: ,p_ctu_attribute27 in varchar2 default hr_api.g_varchar2
353: ,p_ctu_attribute28 in varchar2 default hr_api.g_varchar2
354: ,p_ctu_attribute29 in varchar2 default hr_api.g_varchar2
355: ,p_ctu_attribute30 in varchar2 default hr_api.g_varchar2
348: ,p_ctu_attribute23 in varchar2 default hr_api.g_varchar2
349: ,p_ctu_attribute24 in varchar2 default hr_api.g_varchar2
350: ,p_ctu_attribute25 in varchar2 default hr_api.g_varchar2
351: ,p_ctu_attribute26 in varchar2 default hr_api.g_varchar2
352: ,p_ctu_attribute27 in varchar2 default hr_api.g_varchar2
353: ,p_ctu_attribute28 in varchar2 default hr_api.g_varchar2
354: ,p_ctu_attribute29 in varchar2 default hr_api.g_varchar2
355: ,p_ctu_attribute30 in varchar2 default hr_api.g_varchar2
356: ,p_object_version_number in out nocopy number
349: ,p_ctu_attribute24 in varchar2 default hr_api.g_varchar2
350: ,p_ctu_attribute25 in varchar2 default hr_api.g_varchar2
351: ,p_ctu_attribute26 in varchar2 default hr_api.g_varchar2
352: ,p_ctu_attribute27 in varchar2 default hr_api.g_varchar2
353: ,p_ctu_attribute28 in varchar2 default hr_api.g_varchar2
354: ,p_ctu_attribute29 in varchar2 default hr_api.g_varchar2
355: ,p_ctu_attribute30 in varchar2 default hr_api.g_varchar2
356: ,p_object_version_number in out nocopy number
357: ,p_effective_date in date
350: ,p_ctu_attribute25 in varchar2 default hr_api.g_varchar2
351: ,p_ctu_attribute26 in varchar2 default hr_api.g_varchar2
352: ,p_ctu_attribute27 in varchar2 default hr_api.g_varchar2
353: ,p_ctu_attribute28 in varchar2 default hr_api.g_varchar2
354: ,p_ctu_attribute29 in varchar2 default hr_api.g_varchar2
355: ,p_ctu_attribute30 in varchar2 default hr_api.g_varchar2
356: ,p_object_version_number in out nocopy number
357: ,p_effective_date in date
358: ,p_datetrack_mode in varchar2) is
351: ,p_ctu_attribute26 in varchar2 default hr_api.g_varchar2
352: ,p_ctu_attribute27 in varchar2 default hr_api.g_varchar2
353: ,p_ctu_attribute28 in varchar2 default hr_api.g_varchar2
354: ,p_ctu_attribute29 in varchar2 default hr_api.g_varchar2
355: ,p_ctu_attribute30 in varchar2 default hr_api.g_varchar2
356: ,p_object_version_number in out nocopy number
357: ,p_effective_date in date
358: ,p_datetrack_mode in varchar2) is
359: --
431: ,p_datetrack_mode => p_datetrack_mode);
432: --
433: exception
434: --
435: when hr_api.cannot_find_prog_unit then
436: --
437: hr_api.cannot_find_prog_unit_error
438: (p_module_name => 'UPDATE_cm_typ_usg'
439: ,p_hook_type => 'BP');
433: exception
434: --
435: when hr_api.cannot_find_prog_unit then
436: --
437: hr_api.cannot_find_prog_unit_error
438: (p_module_name => 'UPDATE_cm_typ_usg'
439: ,p_hook_type => 'BP');
440: --
441: -- End of API User Hook for the before hook of update_cm_typ_usg
547: ,p_datetrack_mode => p_datetrack_mode);
548: --
549: exception
550: --
551: when hr_api.cannot_find_prog_unit then
552: --
553: hr_api.cannot_find_prog_unit_error
554: (p_module_name => 'UPDATE_cm_typ_usg'
555: ,p_hook_type => 'AP');
549: exception
550: --
551: when hr_api.cannot_find_prog_unit then
552: --
553: hr_api.cannot_find_prog_unit_error
554: (p_module_name => 'UPDATE_cm_typ_usg'
555: ,p_hook_type => 'AP');
556: --
557: -- End of API User Hook for the after hook of update_cm_typ_usg
562: --
563: -- When in validation only mode raise the Validate_Enabled exception
564: --
565: if p_validate then
566: raise hr_api.validate_enabled;
567: end if;
568: --
569: -- Set all output arguments
570: --
575: hr_utility.set_location(' Leaving:'||l_proc, 70);
576: --
577: exception
578: --
579: when hr_api.validate_enabled then
580: --
581: -- As the Validate_Enabled exception has been raised
582: -- we must rollback to the savepoint
583: --
647: ,p_datetrack_mode => p_datetrack_mode);
648: --
649: exception
650: --
651: when hr_api.cannot_find_prog_unit then
652: --
653: hr_api.cannot_find_prog_unit_error
654: (p_module_name => 'DELETE_cm_typ_usg'
655: ,p_hook_type => 'BP');
649: exception
650: --
651: when hr_api.cannot_find_prog_unit then
652: --
653: hr_api.cannot_find_prog_unit_error
654: (p_module_name => 'DELETE_cm_typ_usg'
655: ,p_hook_type => 'BP');
656: --
657: -- End of API User Hook for the before hook of delete_cm_typ_usg
679: ,p_datetrack_mode => p_datetrack_mode);
680: --
681: exception
682: --
683: when hr_api.cannot_find_prog_unit then
684: --
685: hr_api.cannot_find_prog_unit_error
686: (p_module_name => 'DELETE_cm_typ_usg'
687: ,p_hook_type => 'AP');
681: exception
682: --
683: when hr_api.cannot_find_prog_unit then
684: --
685: hr_api.cannot_find_prog_unit_error
686: (p_module_name => 'DELETE_cm_typ_usg'
687: ,p_hook_type => 'AP');
688: --
689: -- End of API User Hook for the after hook of delete_cm_typ_usg
694: --
695: -- When in validation only mode raise the Validate_Enabled exception
696: --
697: if p_validate then
698: raise hr_api.validate_enabled;
699: end if;
700: --
701: hr_utility.set_location(' Leaving:'||l_proc, 70);
702: --
701: hr_utility.set_location(' Leaving:'||l_proc, 70);
702: --
703: exception
704: --
705: when hr_api.validate_enabled then
706: --
707: -- As the Validate_Enabled exception has been raised
708: -- we must rollback to the savepoint
709: --