136: ,p_use_overid_svc_dt_flag => p_use_overid_svc_dt_flag
137: ,p_effective_date => trunc(p_effective_date)
138: );
139: exception
140: when hr_api.cannot_find_prog_unit then
141: hr_api.cannot_find_prog_unit_error
142: (
143: p_module_name => 'CREATE_LOS_FACTORS'
144: ,p_hook_type => 'BP'
137: ,p_effective_date => trunc(p_effective_date)
138: );
139: exception
140: when hr_api.cannot_find_prog_unit then
141: hr_api.cannot_find_prog_unit_error
142: (
143: p_module_name => 'CREATE_LOS_FACTORS'
144: ,p_hook_type => 'BP'
145: );
259: ,p_use_overid_svc_dt_flag => p_use_overid_svc_dt_flag
260: ,p_effective_date => trunc(p_effective_date)
261: );
262: exception
263: when hr_api.cannot_find_prog_unit then
264: hr_api.cannot_find_prog_unit_error
265: (p_module_name => 'CREATE_LOS_FACTORS'
266: ,p_hook_type => 'AP'
267: );
260: ,p_effective_date => trunc(p_effective_date)
261: );
262: exception
263: when hr_api.cannot_find_prog_unit then
264: hr_api.cannot_find_prog_unit_error
265: (p_module_name => 'CREATE_LOS_FACTORS'
266: ,p_hook_type => 'AP'
267: );
268: --
274: --
275: -- When in validation only mode raise the Validate_Enabled exception
276: --
277: if p_validate then
278: raise hr_api.validate_enabled;
279: end if;
280: --
281: -- Set all output arguments
282: --
286: hr_utility.set_location(' Leaving:'||l_proc, 70);
287: --
288: exception
289: --
290: when hr_api.validate_enabled then
291: --
292: -- As the Validate_Enabled exception has been raised
293: -- we must rollback to the savepoint
294: --
318: --
319: procedure update_LOS_FACTORS
320: (p_validate in boolean default false
321: ,p_los_fctr_id in number
322: ,p_name in varchar2 default hr_api.g_varchar2
323: ,p_business_group_id in number default hr_api.g_number
324: ,p_los_det_cd in varchar2 default hr_api.g_varchar2
325: ,p_los_det_rl in number default hr_api.g_number
326: ,p_mn_los_num in number default hr_api.g_number
319: procedure update_LOS_FACTORS
320: (p_validate in boolean default false
321: ,p_los_fctr_id in number
322: ,p_name in varchar2 default hr_api.g_varchar2
323: ,p_business_group_id in number default hr_api.g_number
324: ,p_los_det_cd in varchar2 default hr_api.g_varchar2
325: ,p_los_det_rl in number default hr_api.g_number
326: ,p_mn_los_num in number default hr_api.g_number
327: ,p_mx_los_num in number default hr_api.g_number
320: (p_validate in boolean default false
321: ,p_los_fctr_id in number
322: ,p_name in varchar2 default hr_api.g_varchar2
323: ,p_business_group_id in number default hr_api.g_number
324: ,p_los_det_cd in varchar2 default hr_api.g_varchar2
325: ,p_los_det_rl in number default hr_api.g_number
326: ,p_mn_los_num in number default hr_api.g_number
327: ,p_mx_los_num in number default hr_api.g_number
328: ,p_no_mx_los_num_apls_flag in varchar2 default hr_api.g_varchar2
321: ,p_los_fctr_id in number
322: ,p_name in varchar2 default hr_api.g_varchar2
323: ,p_business_group_id in number default hr_api.g_number
324: ,p_los_det_cd in varchar2 default hr_api.g_varchar2
325: ,p_los_det_rl in number default hr_api.g_number
326: ,p_mn_los_num in number default hr_api.g_number
327: ,p_mx_los_num in number default hr_api.g_number
328: ,p_no_mx_los_num_apls_flag in varchar2 default hr_api.g_varchar2
329: ,p_no_mn_los_num_apls_flag in varchar2 default hr_api.g_varchar2
322: ,p_name in varchar2 default hr_api.g_varchar2
323: ,p_business_group_id in number default hr_api.g_number
324: ,p_los_det_cd in varchar2 default hr_api.g_varchar2
325: ,p_los_det_rl in number default hr_api.g_number
326: ,p_mn_los_num in number default hr_api.g_number
327: ,p_mx_los_num in number default hr_api.g_number
328: ,p_no_mx_los_num_apls_flag in varchar2 default hr_api.g_varchar2
329: ,p_no_mn_los_num_apls_flag in varchar2 default hr_api.g_varchar2
330: ,p_rndg_cd in varchar2 default hr_api.g_varchar2
323: ,p_business_group_id in number default hr_api.g_number
324: ,p_los_det_cd in varchar2 default hr_api.g_varchar2
325: ,p_los_det_rl in number default hr_api.g_number
326: ,p_mn_los_num in number default hr_api.g_number
327: ,p_mx_los_num in number default hr_api.g_number
328: ,p_no_mx_los_num_apls_flag in varchar2 default hr_api.g_varchar2
329: ,p_no_mn_los_num_apls_flag in varchar2 default hr_api.g_varchar2
330: ,p_rndg_cd in varchar2 default hr_api.g_varchar2
331: ,p_rndg_rl in number default hr_api.g_number
324: ,p_los_det_cd in varchar2 default hr_api.g_varchar2
325: ,p_los_det_rl in number default hr_api.g_number
326: ,p_mn_los_num in number default hr_api.g_number
327: ,p_mx_los_num in number default hr_api.g_number
328: ,p_no_mx_los_num_apls_flag in varchar2 default hr_api.g_varchar2
329: ,p_no_mn_los_num_apls_flag in varchar2 default hr_api.g_varchar2
330: ,p_rndg_cd in varchar2 default hr_api.g_varchar2
331: ,p_rndg_rl in number default hr_api.g_number
332: ,p_los_dt_to_use_cd in varchar2 default hr_api.g_varchar2
325: ,p_los_det_rl in number default hr_api.g_number
326: ,p_mn_los_num in number default hr_api.g_number
327: ,p_mx_los_num in number default hr_api.g_number
328: ,p_no_mx_los_num_apls_flag in varchar2 default hr_api.g_varchar2
329: ,p_no_mn_los_num_apls_flag in varchar2 default hr_api.g_varchar2
330: ,p_rndg_cd in varchar2 default hr_api.g_varchar2
331: ,p_rndg_rl in number default hr_api.g_number
332: ,p_los_dt_to_use_cd in varchar2 default hr_api.g_varchar2
333: ,p_los_dt_to_use_rl in number default hr_api.g_number
326: ,p_mn_los_num in number default hr_api.g_number
327: ,p_mx_los_num in number default hr_api.g_number
328: ,p_no_mx_los_num_apls_flag in varchar2 default hr_api.g_varchar2
329: ,p_no_mn_los_num_apls_flag in varchar2 default hr_api.g_varchar2
330: ,p_rndg_cd in varchar2 default hr_api.g_varchar2
331: ,p_rndg_rl in number default hr_api.g_number
332: ,p_los_dt_to_use_cd in varchar2 default hr_api.g_varchar2
333: ,p_los_dt_to_use_rl in number default hr_api.g_number
334: ,p_los_uom in varchar2 default hr_api.g_varchar2
327: ,p_mx_los_num in number default hr_api.g_number
328: ,p_no_mx_los_num_apls_flag in varchar2 default hr_api.g_varchar2
329: ,p_no_mn_los_num_apls_flag in varchar2 default hr_api.g_varchar2
330: ,p_rndg_cd in varchar2 default hr_api.g_varchar2
331: ,p_rndg_rl in number default hr_api.g_number
332: ,p_los_dt_to_use_cd in varchar2 default hr_api.g_varchar2
333: ,p_los_dt_to_use_rl in number default hr_api.g_number
334: ,p_los_uom in varchar2 default hr_api.g_varchar2
335: ,p_los_calc_rl in number default hr_api.g_number
328: ,p_no_mx_los_num_apls_flag in varchar2 default hr_api.g_varchar2
329: ,p_no_mn_los_num_apls_flag in varchar2 default hr_api.g_varchar2
330: ,p_rndg_cd in varchar2 default hr_api.g_varchar2
331: ,p_rndg_rl in number default hr_api.g_number
332: ,p_los_dt_to_use_cd in varchar2 default hr_api.g_varchar2
333: ,p_los_dt_to_use_rl in number default hr_api.g_number
334: ,p_los_uom in varchar2 default hr_api.g_varchar2
335: ,p_los_calc_rl in number default hr_api.g_number
336: ,p_los_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2
329: ,p_no_mn_los_num_apls_flag in varchar2 default hr_api.g_varchar2
330: ,p_rndg_cd in varchar2 default hr_api.g_varchar2
331: ,p_rndg_rl in number default hr_api.g_number
332: ,p_los_dt_to_use_cd in varchar2 default hr_api.g_varchar2
333: ,p_los_dt_to_use_rl in number default hr_api.g_number
334: ,p_los_uom in varchar2 default hr_api.g_varchar2
335: ,p_los_calc_rl in number default hr_api.g_number
336: ,p_los_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2
337: ,p_lsf_attribute_category in varchar2 default hr_api.g_varchar2
330: ,p_rndg_cd in varchar2 default hr_api.g_varchar2
331: ,p_rndg_rl in number default hr_api.g_number
332: ,p_los_dt_to_use_cd in varchar2 default hr_api.g_varchar2
333: ,p_los_dt_to_use_rl in number default hr_api.g_number
334: ,p_los_uom in varchar2 default hr_api.g_varchar2
335: ,p_los_calc_rl in number default hr_api.g_number
336: ,p_los_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2
337: ,p_lsf_attribute_category in varchar2 default hr_api.g_varchar2
338: ,p_lsf_attribute1 in varchar2 default hr_api.g_varchar2
331: ,p_rndg_rl in number default hr_api.g_number
332: ,p_los_dt_to_use_cd in varchar2 default hr_api.g_varchar2
333: ,p_los_dt_to_use_rl in number default hr_api.g_number
334: ,p_los_uom in varchar2 default hr_api.g_varchar2
335: ,p_los_calc_rl in number default hr_api.g_number
336: ,p_los_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2
337: ,p_lsf_attribute_category in varchar2 default hr_api.g_varchar2
338: ,p_lsf_attribute1 in varchar2 default hr_api.g_varchar2
339: ,p_lsf_attribute2 in varchar2 default hr_api.g_varchar2
332: ,p_los_dt_to_use_cd in varchar2 default hr_api.g_varchar2
333: ,p_los_dt_to_use_rl in number default hr_api.g_number
334: ,p_los_uom in varchar2 default hr_api.g_varchar2
335: ,p_los_calc_rl in number default hr_api.g_number
336: ,p_los_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2
337: ,p_lsf_attribute_category in varchar2 default hr_api.g_varchar2
338: ,p_lsf_attribute1 in varchar2 default hr_api.g_varchar2
339: ,p_lsf_attribute2 in varchar2 default hr_api.g_varchar2
340: ,p_lsf_attribute3 in varchar2 default hr_api.g_varchar2
333: ,p_los_dt_to_use_rl in number default hr_api.g_number
334: ,p_los_uom in varchar2 default hr_api.g_varchar2
335: ,p_los_calc_rl in number default hr_api.g_number
336: ,p_los_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2
337: ,p_lsf_attribute_category in varchar2 default hr_api.g_varchar2
338: ,p_lsf_attribute1 in varchar2 default hr_api.g_varchar2
339: ,p_lsf_attribute2 in varchar2 default hr_api.g_varchar2
340: ,p_lsf_attribute3 in varchar2 default hr_api.g_varchar2
341: ,p_lsf_attribute4 in varchar2 default hr_api.g_varchar2
334: ,p_los_uom in varchar2 default hr_api.g_varchar2
335: ,p_los_calc_rl in number default hr_api.g_number
336: ,p_los_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2
337: ,p_lsf_attribute_category in varchar2 default hr_api.g_varchar2
338: ,p_lsf_attribute1 in varchar2 default hr_api.g_varchar2
339: ,p_lsf_attribute2 in varchar2 default hr_api.g_varchar2
340: ,p_lsf_attribute3 in varchar2 default hr_api.g_varchar2
341: ,p_lsf_attribute4 in varchar2 default hr_api.g_varchar2
342: ,p_lsf_attribute5 in varchar2 default hr_api.g_varchar2
335: ,p_los_calc_rl in number default hr_api.g_number
336: ,p_los_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2
337: ,p_lsf_attribute_category in varchar2 default hr_api.g_varchar2
338: ,p_lsf_attribute1 in varchar2 default hr_api.g_varchar2
339: ,p_lsf_attribute2 in varchar2 default hr_api.g_varchar2
340: ,p_lsf_attribute3 in varchar2 default hr_api.g_varchar2
341: ,p_lsf_attribute4 in varchar2 default hr_api.g_varchar2
342: ,p_lsf_attribute5 in varchar2 default hr_api.g_varchar2
343: ,p_lsf_attribute6 in varchar2 default hr_api.g_varchar2
336: ,p_los_alt_val_to_use_cd in varchar2 default hr_api.g_varchar2
337: ,p_lsf_attribute_category in varchar2 default hr_api.g_varchar2
338: ,p_lsf_attribute1 in varchar2 default hr_api.g_varchar2
339: ,p_lsf_attribute2 in varchar2 default hr_api.g_varchar2
340: ,p_lsf_attribute3 in varchar2 default hr_api.g_varchar2
341: ,p_lsf_attribute4 in varchar2 default hr_api.g_varchar2
342: ,p_lsf_attribute5 in varchar2 default hr_api.g_varchar2
343: ,p_lsf_attribute6 in varchar2 default hr_api.g_varchar2
344: ,p_lsf_attribute7 in varchar2 default hr_api.g_varchar2
337: ,p_lsf_attribute_category in varchar2 default hr_api.g_varchar2
338: ,p_lsf_attribute1 in varchar2 default hr_api.g_varchar2
339: ,p_lsf_attribute2 in varchar2 default hr_api.g_varchar2
340: ,p_lsf_attribute3 in varchar2 default hr_api.g_varchar2
341: ,p_lsf_attribute4 in varchar2 default hr_api.g_varchar2
342: ,p_lsf_attribute5 in varchar2 default hr_api.g_varchar2
343: ,p_lsf_attribute6 in varchar2 default hr_api.g_varchar2
344: ,p_lsf_attribute7 in varchar2 default hr_api.g_varchar2
345: ,p_lsf_attribute8 in varchar2 default hr_api.g_varchar2
338: ,p_lsf_attribute1 in varchar2 default hr_api.g_varchar2
339: ,p_lsf_attribute2 in varchar2 default hr_api.g_varchar2
340: ,p_lsf_attribute3 in varchar2 default hr_api.g_varchar2
341: ,p_lsf_attribute4 in varchar2 default hr_api.g_varchar2
342: ,p_lsf_attribute5 in varchar2 default hr_api.g_varchar2
343: ,p_lsf_attribute6 in varchar2 default hr_api.g_varchar2
344: ,p_lsf_attribute7 in varchar2 default hr_api.g_varchar2
345: ,p_lsf_attribute8 in varchar2 default hr_api.g_varchar2
346: ,p_lsf_attribute9 in varchar2 default hr_api.g_varchar2
339: ,p_lsf_attribute2 in varchar2 default hr_api.g_varchar2
340: ,p_lsf_attribute3 in varchar2 default hr_api.g_varchar2
341: ,p_lsf_attribute4 in varchar2 default hr_api.g_varchar2
342: ,p_lsf_attribute5 in varchar2 default hr_api.g_varchar2
343: ,p_lsf_attribute6 in varchar2 default hr_api.g_varchar2
344: ,p_lsf_attribute7 in varchar2 default hr_api.g_varchar2
345: ,p_lsf_attribute8 in varchar2 default hr_api.g_varchar2
346: ,p_lsf_attribute9 in varchar2 default hr_api.g_varchar2
347: ,p_lsf_attribute10 in varchar2 default hr_api.g_varchar2
340: ,p_lsf_attribute3 in varchar2 default hr_api.g_varchar2
341: ,p_lsf_attribute4 in varchar2 default hr_api.g_varchar2
342: ,p_lsf_attribute5 in varchar2 default hr_api.g_varchar2
343: ,p_lsf_attribute6 in varchar2 default hr_api.g_varchar2
344: ,p_lsf_attribute7 in varchar2 default hr_api.g_varchar2
345: ,p_lsf_attribute8 in varchar2 default hr_api.g_varchar2
346: ,p_lsf_attribute9 in varchar2 default hr_api.g_varchar2
347: ,p_lsf_attribute10 in varchar2 default hr_api.g_varchar2
348: ,p_lsf_attribute11 in varchar2 default hr_api.g_varchar2
341: ,p_lsf_attribute4 in varchar2 default hr_api.g_varchar2
342: ,p_lsf_attribute5 in varchar2 default hr_api.g_varchar2
343: ,p_lsf_attribute6 in varchar2 default hr_api.g_varchar2
344: ,p_lsf_attribute7 in varchar2 default hr_api.g_varchar2
345: ,p_lsf_attribute8 in varchar2 default hr_api.g_varchar2
346: ,p_lsf_attribute9 in varchar2 default hr_api.g_varchar2
347: ,p_lsf_attribute10 in varchar2 default hr_api.g_varchar2
348: ,p_lsf_attribute11 in varchar2 default hr_api.g_varchar2
349: ,p_lsf_attribute12 in varchar2 default hr_api.g_varchar2
342: ,p_lsf_attribute5 in varchar2 default hr_api.g_varchar2
343: ,p_lsf_attribute6 in varchar2 default hr_api.g_varchar2
344: ,p_lsf_attribute7 in varchar2 default hr_api.g_varchar2
345: ,p_lsf_attribute8 in varchar2 default hr_api.g_varchar2
346: ,p_lsf_attribute9 in varchar2 default hr_api.g_varchar2
347: ,p_lsf_attribute10 in varchar2 default hr_api.g_varchar2
348: ,p_lsf_attribute11 in varchar2 default hr_api.g_varchar2
349: ,p_lsf_attribute12 in varchar2 default hr_api.g_varchar2
350: ,p_lsf_attribute13 in varchar2 default hr_api.g_varchar2
343: ,p_lsf_attribute6 in varchar2 default hr_api.g_varchar2
344: ,p_lsf_attribute7 in varchar2 default hr_api.g_varchar2
345: ,p_lsf_attribute8 in varchar2 default hr_api.g_varchar2
346: ,p_lsf_attribute9 in varchar2 default hr_api.g_varchar2
347: ,p_lsf_attribute10 in varchar2 default hr_api.g_varchar2
348: ,p_lsf_attribute11 in varchar2 default hr_api.g_varchar2
349: ,p_lsf_attribute12 in varchar2 default hr_api.g_varchar2
350: ,p_lsf_attribute13 in varchar2 default hr_api.g_varchar2
351: ,p_lsf_attribute14 in varchar2 default hr_api.g_varchar2
344: ,p_lsf_attribute7 in varchar2 default hr_api.g_varchar2
345: ,p_lsf_attribute8 in varchar2 default hr_api.g_varchar2
346: ,p_lsf_attribute9 in varchar2 default hr_api.g_varchar2
347: ,p_lsf_attribute10 in varchar2 default hr_api.g_varchar2
348: ,p_lsf_attribute11 in varchar2 default hr_api.g_varchar2
349: ,p_lsf_attribute12 in varchar2 default hr_api.g_varchar2
350: ,p_lsf_attribute13 in varchar2 default hr_api.g_varchar2
351: ,p_lsf_attribute14 in varchar2 default hr_api.g_varchar2
352: ,p_lsf_attribute15 in varchar2 default hr_api.g_varchar2
345: ,p_lsf_attribute8 in varchar2 default hr_api.g_varchar2
346: ,p_lsf_attribute9 in varchar2 default hr_api.g_varchar2
347: ,p_lsf_attribute10 in varchar2 default hr_api.g_varchar2
348: ,p_lsf_attribute11 in varchar2 default hr_api.g_varchar2
349: ,p_lsf_attribute12 in varchar2 default hr_api.g_varchar2
350: ,p_lsf_attribute13 in varchar2 default hr_api.g_varchar2
351: ,p_lsf_attribute14 in varchar2 default hr_api.g_varchar2
352: ,p_lsf_attribute15 in varchar2 default hr_api.g_varchar2
353: ,p_lsf_attribute16 in varchar2 default hr_api.g_varchar2
346: ,p_lsf_attribute9 in varchar2 default hr_api.g_varchar2
347: ,p_lsf_attribute10 in varchar2 default hr_api.g_varchar2
348: ,p_lsf_attribute11 in varchar2 default hr_api.g_varchar2
349: ,p_lsf_attribute12 in varchar2 default hr_api.g_varchar2
350: ,p_lsf_attribute13 in varchar2 default hr_api.g_varchar2
351: ,p_lsf_attribute14 in varchar2 default hr_api.g_varchar2
352: ,p_lsf_attribute15 in varchar2 default hr_api.g_varchar2
353: ,p_lsf_attribute16 in varchar2 default hr_api.g_varchar2
354: ,p_lsf_attribute17 in varchar2 default hr_api.g_varchar2
347: ,p_lsf_attribute10 in varchar2 default hr_api.g_varchar2
348: ,p_lsf_attribute11 in varchar2 default hr_api.g_varchar2
349: ,p_lsf_attribute12 in varchar2 default hr_api.g_varchar2
350: ,p_lsf_attribute13 in varchar2 default hr_api.g_varchar2
351: ,p_lsf_attribute14 in varchar2 default hr_api.g_varchar2
352: ,p_lsf_attribute15 in varchar2 default hr_api.g_varchar2
353: ,p_lsf_attribute16 in varchar2 default hr_api.g_varchar2
354: ,p_lsf_attribute17 in varchar2 default hr_api.g_varchar2
355: ,p_lsf_attribute18 in varchar2 default hr_api.g_varchar2
348: ,p_lsf_attribute11 in varchar2 default hr_api.g_varchar2
349: ,p_lsf_attribute12 in varchar2 default hr_api.g_varchar2
350: ,p_lsf_attribute13 in varchar2 default hr_api.g_varchar2
351: ,p_lsf_attribute14 in varchar2 default hr_api.g_varchar2
352: ,p_lsf_attribute15 in varchar2 default hr_api.g_varchar2
353: ,p_lsf_attribute16 in varchar2 default hr_api.g_varchar2
354: ,p_lsf_attribute17 in varchar2 default hr_api.g_varchar2
355: ,p_lsf_attribute18 in varchar2 default hr_api.g_varchar2
356: ,p_lsf_attribute19 in varchar2 default hr_api.g_varchar2
349: ,p_lsf_attribute12 in varchar2 default hr_api.g_varchar2
350: ,p_lsf_attribute13 in varchar2 default hr_api.g_varchar2
351: ,p_lsf_attribute14 in varchar2 default hr_api.g_varchar2
352: ,p_lsf_attribute15 in varchar2 default hr_api.g_varchar2
353: ,p_lsf_attribute16 in varchar2 default hr_api.g_varchar2
354: ,p_lsf_attribute17 in varchar2 default hr_api.g_varchar2
355: ,p_lsf_attribute18 in varchar2 default hr_api.g_varchar2
356: ,p_lsf_attribute19 in varchar2 default hr_api.g_varchar2
357: ,p_lsf_attribute20 in varchar2 default hr_api.g_varchar2
350: ,p_lsf_attribute13 in varchar2 default hr_api.g_varchar2
351: ,p_lsf_attribute14 in varchar2 default hr_api.g_varchar2
352: ,p_lsf_attribute15 in varchar2 default hr_api.g_varchar2
353: ,p_lsf_attribute16 in varchar2 default hr_api.g_varchar2
354: ,p_lsf_attribute17 in varchar2 default hr_api.g_varchar2
355: ,p_lsf_attribute18 in varchar2 default hr_api.g_varchar2
356: ,p_lsf_attribute19 in varchar2 default hr_api.g_varchar2
357: ,p_lsf_attribute20 in varchar2 default hr_api.g_varchar2
358: ,p_lsf_attribute21 in varchar2 default hr_api.g_varchar2
351: ,p_lsf_attribute14 in varchar2 default hr_api.g_varchar2
352: ,p_lsf_attribute15 in varchar2 default hr_api.g_varchar2
353: ,p_lsf_attribute16 in varchar2 default hr_api.g_varchar2
354: ,p_lsf_attribute17 in varchar2 default hr_api.g_varchar2
355: ,p_lsf_attribute18 in varchar2 default hr_api.g_varchar2
356: ,p_lsf_attribute19 in varchar2 default hr_api.g_varchar2
357: ,p_lsf_attribute20 in varchar2 default hr_api.g_varchar2
358: ,p_lsf_attribute21 in varchar2 default hr_api.g_varchar2
359: ,p_lsf_attribute22 in varchar2 default hr_api.g_varchar2
352: ,p_lsf_attribute15 in varchar2 default hr_api.g_varchar2
353: ,p_lsf_attribute16 in varchar2 default hr_api.g_varchar2
354: ,p_lsf_attribute17 in varchar2 default hr_api.g_varchar2
355: ,p_lsf_attribute18 in varchar2 default hr_api.g_varchar2
356: ,p_lsf_attribute19 in varchar2 default hr_api.g_varchar2
357: ,p_lsf_attribute20 in varchar2 default hr_api.g_varchar2
358: ,p_lsf_attribute21 in varchar2 default hr_api.g_varchar2
359: ,p_lsf_attribute22 in varchar2 default hr_api.g_varchar2
360: ,p_lsf_attribute23 in varchar2 default hr_api.g_varchar2
353: ,p_lsf_attribute16 in varchar2 default hr_api.g_varchar2
354: ,p_lsf_attribute17 in varchar2 default hr_api.g_varchar2
355: ,p_lsf_attribute18 in varchar2 default hr_api.g_varchar2
356: ,p_lsf_attribute19 in varchar2 default hr_api.g_varchar2
357: ,p_lsf_attribute20 in varchar2 default hr_api.g_varchar2
358: ,p_lsf_attribute21 in varchar2 default hr_api.g_varchar2
359: ,p_lsf_attribute22 in varchar2 default hr_api.g_varchar2
360: ,p_lsf_attribute23 in varchar2 default hr_api.g_varchar2
361: ,p_lsf_attribute24 in varchar2 default hr_api.g_varchar2
354: ,p_lsf_attribute17 in varchar2 default hr_api.g_varchar2
355: ,p_lsf_attribute18 in varchar2 default hr_api.g_varchar2
356: ,p_lsf_attribute19 in varchar2 default hr_api.g_varchar2
357: ,p_lsf_attribute20 in varchar2 default hr_api.g_varchar2
358: ,p_lsf_attribute21 in varchar2 default hr_api.g_varchar2
359: ,p_lsf_attribute22 in varchar2 default hr_api.g_varchar2
360: ,p_lsf_attribute23 in varchar2 default hr_api.g_varchar2
361: ,p_lsf_attribute24 in varchar2 default hr_api.g_varchar2
362: ,p_lsf_attribute25 in varchar2 default hr_api.g_varchar2
355: ,p_lsf_attribute18 in varchar2 default hr_api.g_varchar2
356: ,p_lsf_attribute19 in varchar2 default hr_api.g_varchar2
357: ,p_lsf_attribute20 in varchar2 default hr_api.g_varchar2
358: ,p_lsf_attribute21 in varchar2 default hr_api.g_varchar2
359: ,p_lsf_attribute22 in varchar2 default hr_api.g_varchar2
360: ,p_lsf_attribute23 in varchar2 default hr_api.g_varchar2
361: ,p_lsf_attribute24 in varchar2 default hr_api.g_varchar2
362: ,p_lsf_attribute25 in varchar2 default hr_api.g_varchar2
363: ,p_lsf_attribute26 in varchar2 default hr_api.g_varchar2
356: ,p_lsf_attribute19 in varchar2 default hr_api.g_varchar2
357: ,p_lsf_attribute20 in varchar2 default hr_api.g_varchar2
358: ,p_lsf_attribute21 in varchar2 default hr_api.g_varchar2
359: ,p_lsf_attribute22 in varchar2 default hr_api.g_varchar2
360: ,p_lsf_attribute23 in varchar2 default hr_api.g_varchar2
361: ,p_lsf_attribute24 in varchar2 default hr_api.g_varchar2
362: ,p_lsf_attribute25 in varchar2 default hr_api.g_varchar2
363: ,p_lsf_attribute26 in varchar2 default hr_api.g_varchar2
364: ,p_lsf_attribute27 in varchar2 default hr_api.g_varchar2
357: ,p_lsf_attribute20 in varchar2 default hr_api.g_varchar2
358: ,p_lsf_attribute21 in varchar2 default hr_api.g_varchar2
359: ,p_lsf_attribute22 in varchar2 default hr_api.g_varchar2
360: ,p_lsf_attribute23 in varchar2 default hr_api.g_varchar2
361: ,p_lsf_attribute24 in varchar2 default hr_api.g_varchar2
362: ,p_lsf_attribute25 in varchar2 default hr_api.g_varchar2
363: ,p_lsf_attribute26 in varchar2 default hr_api.g_varchar2
364: ,p_lsf_attribute27 in varchar2 default hr_api.g_varchar2
365: ,p_lsf_attribute28 in varchar2 default hr_api.g_varchar2
358: ,p_lsf_attribute21 in varchar2 default hr_api.g_varchar2
359: ,p_lsf_attribute22 in varchar2 default hr_api.g_varchar2
360: ,p_lsf_attribute23 in varchar2 default hr_api.g_varchar2
361: ,p_lsf_attribute24 in varchar2 default hr_api.g_varchar2
362: ,p_lsf_attribute25 in varchar2 default hr_api.g_varchar2
363: ,p_lsf_attribute26 in varchar2 default hr_api.g_varchar2
364: ,p_lsf_attribute27 in varchar2 default hr_api.g_varchar2
365: ,p_lsf_attribute28 in varchar2 default hr_api.g_varchar2
366: ,p_lsf_attribute29 in varchar2 default hr_api.g_varchar2
359: ,p_lsf_attribute22 in varchar2 default hr_api.g_varchar2
360: ,p_lsf_attribute23 in varchar2 default hr_api.g_varchar2
361: ,p_lsf_attribute24 in varchar2 default hr_api.g_varchar2
362: ,p_lsf_attribute25 in varchar2 default hr_api.g_varchar2
363: ,p_lsf_attribute26 in varchar2 default hr_api.g_varchar2
364: ,p_lsf_attribute27 in varchar2 default hr_api.g_varchar2
365: ,p_lsf_attribute28 in varchar2 default hr_api.g_varchar2
366: ,p_lsf_attribute29 in varchar2 default hr_api.g_varchar2
367: ,p_lsf_attribute30 in varchar2 default hr_api.g_varchar2
360: ,p_lsf_attribute23 in varchar2 default hr_api.g_varchar2
361: ,p_lsf_attribute24 in varchar2 default hr_api.g_varchar2
362: ,p_lsf_attribute25 in varchar2 default hr_api.g_varchar2
363: ,p_lsf_attribute26 in varchar2 default hr_api.g_varchar2
364: ,p_lsf_attribute27 in varchar2 default hr_api.g_varchar2
365: ,p_lsf_attribute28 in varchar2 default hr_api.g_varchar2
366: ,p_lsf_attribute29 in varchar2 default hr_api.g_varchar2
367: ,p_lsf_attribute30 in varchar2 default hr_api.g_varchar2
368: ,p_object_version_number in out nocopy number
361: ,p_lsf_attribute24 in varchar2 default hr_api.g_varchar2
362: ,p_lsf_attribute25 in varchar2 default hr_api.g_varchar2
363: ,p_lsf_attribute26 in varchar2 default hr_api.g_varchar2
364: ,p_lsf_attribute27 in varchar2 default hr_api.g_varchar2
365: ,p_lsf_attribute28 in varchar2 default hr_api.g_varchar2
366: ,p_lsf_attribute29 in varchar2 default hr_api.g_varchar2
367: ,p_lsf_attribute30 in varchar2 default hr_api.g_varchar2
368: ,p_object_version_number in out nocopy number
369: ,p_use_overid_svc_dt_flag in varchar2 default hr_api.g_varchar2
362: ,p_lsf_attribute25 in varchar2 default hr_api.g_varchar2
363: ,p_lsf_attribute26 in varchar2 default hr_api.g_varchar2
364: ,p_lsf_attribute27 in varchar2 default hr_api.g_varchar2
365: ,p_lsf_attribute28 in varchar2 default hr_api.g_varchar2
366: ,p_lsf_attribute29 in varchar2 default hr_api.g_varchar2
367: ,p_lsf_attribute30 in varchar2 default hr_api.g_varchar2
368: ,p_object_version_number in out nocopy number
369: ,p_use_overid_svc_dt_flag in varchar2 default hr_api.g_varchar2
370: ,p_effective_date in date
363: ,p_lsf_attribute26 in varchar2 default hr_api.g_varchar2
364: ,p_lsf_attribute27 in varchar2 default hr_api.g_varchar2
365: ,p_lsf_attribute28 in varchar2 default hr_api.g_varchar2
366: ,p_lsf_attribute29 in varchar2 default hr_api.g_varchar2
367: ,p_lsf_attribute30 in varchar2 default hr_api.g_varchar2
368: ,p_object_version_number in out nocopy number
369: ,p_use_overid_svc_dt_flag in varchar2 default hr_api.g_varchar2
370: ,p_effective_date in date
371: ) is
365: ,p_lsf_attribute28 in varchar2 default hr_api.g_varchar2
366: ,p_lsf_attribute29 in varchar2 default hr_api.g_varchar2
367: ,p_lsf_attribute30 in varchar2 default hr_api.g_varchar2
368: ,p_object_version_number in out nocopy number
369: ,p_use_overid_svc_dt_flag in varchar2 default hr_api.g_varchar2
370: ,p_effective_date in date
371: ) is
372: --
373: -- Declare cursors and local variables
446: ,p_use_overid_svc_dt_flag => p_use_overid_svc_dt_flag
447: ,p_effective_date => trunc(p_effective_date)
448: );
449: exception
450: when hr_api.cannot_find_prog_unit then
451: hr_api.cannot_find_prog_unit_error
452: (p_module_name => 'UPDATE_LOS_FACTORS'
453: ,p_hook_type => 'BP'
454: );
447: ,p_effective_date => trunc(p_effective_date)
448: );
449: exception
450: when hr_api.cannot_find_prog_unit then
451: hr_api.cannot_find_prog_unit_error
452: (p_module_name => 'UPDATE_LOS_FACTORS'
453: ,p_hook_type => 'BP'
454: );
455: --
568: ,p_use_overid_svc_dt_flag => p_use_overid_svc_dt_flag
569: ,p_effective_date => trunc(p_effective_date)
570: );
571: exception
572: when hr_api.cannot_find_prog_unit then
573: hr_api.cannot_find_prog_unit_error
574: (p_module_name => 'UPDATE_LOS_FACTORS'
575: ,p_hook_type => 'AP'
576: );
569: ,p_effective_date => trunc(p_effective_date)
570: );
571: exception
572: when hr_api.cannot_find_prog_unit then
573: hr_api.cannot_find_prog_unit_error
574: (p_module_name => 'UPDATE_LOS_FACTORS'
575: ,p_hook_type => 'AP'
576: );
577: --
583: --
584: -- When in validation only mode raise the Validate_Enabled exception
585: --
586: if p_validate then
587: raise hr_api.validate_enabled;
588: end if;
589: --
590: -- Set all output arguments
591: --
594: hr_utility.set_location(' Leaving:'||l_proc, 70);
595: --
596: exception
597: --
598: when hr_api.validate_enabled then
599: --
600: -- As the Validate_Enabled exception has been raised
601: -- we must rollback to the savepoint
602: --
657: ,p_object_version_number => p_object_version_number
658: ,p_effective_date => trunc(p_effective_date)
659: );
660: exception
661: when hr_api.cannot_find_prog_unit then
662: hr_api.cannot_find_prog_unit_error
663: (p_module_name => 'DELETE_LOS_FACTORS'
664: ,p_hook_type => 'BP'
665: );
658: ,p_effective_date => trunc(p_effective_date)
659: );
660: exception
661: when hr_api.cannot_find_prog_unit then
662: hr_api.cannot_find_prog_unit_error
663: (p_module_name => 'DELETE_LOS_FACTORS'
664: ,p_hook_type => 'BP'
665: );
666: --
685: ,p_object_version_number => l_object_version_number
686: ,p_effective_date => trunc(p_effective_date)
687: );
688: exception
689: when hr_api.cannot_find_prog_unit then
690: hr_api.cannot_find_prog_unit_error
691: (p_module_name => 'DELETE_LOS_FACTORS'
692: ,p_hook_type => 'AP'
693: );
686: ,p_effective_date => trunc(p_effective_date)
687: );
688: exception
689: when hr_api.cannot_find_prog_unit then
690: hr_api.cannot_find_prog_unit_error
691: (p_module_name => 'DELETE_LOS_FACTORS'
692: ,p_hook_type => 'AP'
693: );
694: --
700: --
701: -- When in validation only mode raise the Validate_Enabled exception
702: --
703: if p_validate then
704: raise hr_api.validate_enabled;
705: end if;
706: --
707: hr_utility.set_location(' Leaving:'||l_proc, 70);
708: --
707: hr_utility.set_location(' Leaving:'||l_proc, 70);
708: --
709: exception
710: --
711: when hr_api.validate_enabled then
712: --
713: -- As the Validate_Enabled exception has been raised
714: -- we must rollback to the savepoint
715: --