174: --
175: hr_utility.set_location(l_proc, 90);
176: --
177: EXCEPTION
178: WHEN hr_api.cannot_find_prog_unit THEN
179: hr_api.cannot_find_prog_unit_error
180: (
181: p_module_name => 'create_soc_ins_contributions'
182: ,p_hook_type => 'BP'
175: hr_utility.set_location(l_proc, 90);
176: --
177: EXCEPTION
178: WHEN hr_api.cannot_find_prog_unit THEN
179: hr_api.cannot_find_prog_unit_error
180: (
181: p_module_name => 'create_soc_ins_contributions'
182: ,p_hook_type => 'BP'
183: );
321: hr_utility.set_location(l_proc, 130);
322: --
323:
324: EXCEPTION
325: WHEN hr_api.cannot_find_prog_unit THEN
326: hr_api.cannot_find_prog_unit_error
327: (p_module_name => 'create_soc_ins_contributions'
328: ,p_hook_type => 'AP'
329: );
322: --
323:
324: EXCEPTION
325: WHEN hr_api.cannot_find_prog_unit THEN
326: hr_api.cannot_find_prog_unit_error
327: (p_module_name => 'create_soc_ins_contributions'
328: ,p_hook_type => 'AP'
329: );
330: --
336: --
337: -- When in validation only mode RAISE the Validate_Enabled EXCEPTION
338: --
339: IF p_validate THEN
340: RAISE hr_api.validate_enabled;
341: END IF;
342: --
343: -- Set all output arguments
344: --
351: hr_utility.set_location(' Leaving:'||l_proc, 999);
352: --
353: EXCEPTION
354: --
355: WHEN hr_api.validate_enabled THEN
356: --
357: -- As the Validate_Enabled EXCEPTION has been RAISEd
358: -- we must rollback to the SAVEPOINT
359: --
392: PROCEDURE update_soc_ins_contributions
393: (
394:
395: p_validate IN boolean default false
396: ,p_organization_id IN number default hr_api.g_number
397: ,p_normal_percentage IN number default hr_api.g_number
398: ,p_normal_amount IN number default hr_api.g_number
399: ,p_increased_percentage IN number default hr_api.g_number
400: ,p_increased_amount IN number default hr_api.g_number
393: (
394:
395: p_validate IN boolean default false
396: ,p_organization_id IN number default hr_api.g_number
397: ,p_normal_percentage IN number default hr_api.g_number
398: ,p_normal_amount IN number default hr_api.g_number
399: ,p_increased_percentage IN number default hr_api.g_number
400: ,p_increased_amount IN number default hr_api.g_number
401: ,p_reduced_percentage IN number default hr_api.g_number
394:
395: p_validate IN boolean default false
396: ,p_organization_id IN number default hr_api.g_number
397: ,p_normal_percentage IN number default hr_api.g_number
398: ,p_normal_amount IN number default hr_api.g_number
399: ,p_increased_percentage IN number default hr_api.g_number
400: ,p_increased_amount IN number default hr_api.g_number
401: ,p_reduced_percentage IN number default hr_api.g_number
402: ,p_reduced_amount IN number default hr_api.g_number
395: p_validate IN boolean default false
396: ,p_organization_id IN number default hr_api.g_number
397: ,p_normal_percentage IN number default hr_api.g_number
398: ,p_normal_amount IN number default hr_api.g_number
399: ,p_increased_percentage IN number default hr_api.g_number
400: ,p_increased_amount IN number default hr_api.g_number
401: ,p_reduced_percentage IN number default hr_api.g_number
402: ,p_reduced_amount IN number default hr_api.g_number
403: ,p_effective_start_date IN OUT NOCOPY date
396: ,p_organization_id IN number default hr_api.g_number
397: ,p_normal_percentage IN number default hr_api.g_number
398: ,p_normal_amount IN number default hr_api.g_number
399: ,p_increased_percentage IN number default hr_api.g_number
400: ,p_increased_amount IN number default hr_api.g_number
401: ,p_reduced_percentage IN number default hr_api.g_number
402: ,p_reduced_amount IN number default hr_api.g_number
403: ,p_effective_start_date IN OUT NOCOPY date
404: ,p_effective_end_date IN OUT NOCOPY date
397: ,p_normal_percentage IN number default hr_api.g_number
398: ,p_normal_amount IN number default hr_api.g_number
399: ,p_increased_percentage IN number default hr_api.g_number
400: ,p_increased_amount IN number default hr_api.g_number
401: ,p_reduced_percentage IN number default hr_api.g_number
402: ,p_reduced_amount IN number default hr_api.g_number
403: ,p_effective_start_date IN OUT NOCOPY date
404: ,p_effective_end_date IN OUT NOCOPY date
405: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
398: ,p_normal_amount IN number default hr_api.g_number
399: ,p_increased_percentage IN number default hr_api.g_number
400: ,p_increased_amount IN number default hr_api.g_number
401: ,p_reduced_percentage IN number default hr_api.g_number
402: ,p_reduced_amount IN number default hr_api.g_number
403: ,p_effective_start_date IN OUT NOCOPY date
404: ,p_effective_end_date IN OUT NOCOPY date
405: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
406: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
401: ,p_reduced_percentage IN number default hr_api.g_number
402: ,p_reduced_amount IN number default hr_api.g_number
403: ,p_effective_start_date IN OUT NOCOPY date
404: ,p_effective_end_date IN OUT NOCOPY date
405: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
406: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
407: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
408: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
409: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
402: ,p_reduced_amount IN number default hr_api.g_number
403: ,p_effective_start_date IN OUT NOCOPY date
404: ,p_effective_end_date IN OUT NOCOPY date
405: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
406: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
407: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
408: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
409: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
410: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
403: ,p_effective_start_date IN OUT NOCOPY date
404: ,p_effective_end_date IN OUT NOCOPY date
405: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
406: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
407: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
408: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
409: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
410: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
411: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
404: ,p_effective_end_date IN OUT NOCOPY date
405: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
406: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
407: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
408: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
409: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
410: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
411: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
412: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
405: ,p_attribute_category IN varchar2 default hr_api.g_varchar2
406: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
407: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
408: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
409: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
410: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
411: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
412: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
413: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
406: ,p_attribute1 IN varchar2 default hr_api.g_varchar2
407: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
408: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
409: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
410: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
411: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
412: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
413: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
414: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
407: ,p_attribute2 IN varchar2 default hr_api.g_varchar2
408: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
409: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
410: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
411: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
412: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
413: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
414: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
415: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
408: ,p_attribute3 IN varchar2 default hr_api.g_varchar2
409: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
410: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
411: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
412: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
413: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
414: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
415: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
416: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
409: ,p_attribute4 IN varchar2 default hr_api.g_varchar2
410: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
411: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
412: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
413: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
414: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
415: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
416: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
417: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
410: ,p_attribute5 IN varchar2 default hr_api.g_varchar2
411: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
412: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
413: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
414: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
415: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
416: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
417: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
418: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
411: ,p_attribute6 IN varchar2 default hr_api.g_varchar2
412: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
413: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
414: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
415: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
416: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
417: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
418: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
419: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
412: ,p_attribute7 IN varchar2 default hr_api.g_varchar2
413: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
414: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
415: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
416: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
417: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
418: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
419: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
420: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
413: ,p_attribute8 IN varchar2 default hr_api.g_varchar2
414: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
415: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
416: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
417: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
418: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
419: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
420: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
421: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
414: ,p_attribute9 IN varchar2 default hr_api.g_varchar2
415: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
416: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
417: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
418: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
419: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
420: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
421: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
422: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
415: ,p_attribute10 IN varchar2 default hr_api.g_varchar2
416: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
417: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
418: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
419: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
420: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
421: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
422: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
423: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
416: ,p_attribute11 IN varchar2 default hr_api.g_varchar2
417: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
418: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
419: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
420: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
421: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
422: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
423: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
424: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
417: ,p_attribute12 IN varchar2 default hr_api.g_varchar2
418: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
419: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
420: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
421: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
422: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
423: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
424: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
425: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
418: ,p_attribute13 IN varchar2 default hr_api.g_varchar2
419: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
420: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
421: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
422: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
423: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
424: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
425: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
426: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
419: ,p_attribute14 IN varchar2 default hr_api.g_varchar2
420: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
421: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
422: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
423: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
424: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
425: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
426: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
427: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
420: ,p_attribute15 IN varchar2 default hr_api.g_varchar2
421: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
422: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
423: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
424: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
425: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
426: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
427: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
428: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
421: ,p_attribute16 IN varchar2 default hr_api.g_varchar2
422: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
423: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
424: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
425: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
426: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
427: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
428: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
429: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
422: ,p_attribute17 IN varchar2 default hr_api.g_varchar2
423: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
424: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
425: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
426: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
427: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
428: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
429: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
430: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
423: ,p_attribute18 IN varchar2 default hr_api.g_varchar2
424: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
425: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
426: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
427: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
428: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
429: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
430: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
431: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
424: ,p_attribute19 IN varchar2 default hr_api.g_varchar2
425: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
426: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
427: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
428: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
429: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
430: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
431: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
432: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
425: ,p_attribute20 IN varchar2 default hr_api.g_varchar2
426: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
427: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
428: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
429: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
430: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
431: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
432: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
433: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
426: ,p_attribute21 IN varchar2 default hr_api.g_varchar2
427: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
428: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
429: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
430: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
431: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
432: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
433: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
434: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
427: ,p_attribute22 IN varchar2 default hr_api.g_varchar2
428: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
429: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
430: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
431: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
432: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
433: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
434: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
435: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
428: ,p_attribute23 IN varchar2 default hr_api.g_varchar2
429: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
430: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
431: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
432: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
433: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
434: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
435: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
436: ,p_effective_date IN date
429: ,p_attribute24 IN varchar2 default hr_api.g_varchar2
430: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
431: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
432: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
433: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
434: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
435: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
436: ,p_effective_date IN date
437: ,p_object_version_number IN OUT NOCOPY number
430: ,p_attribute25 IN varchar2 default hr_api.g_varchar2
431: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
432: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
433: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
434: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
435: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
436: ,p_effective_date IN date
437: ,p_object_version_number IN OUT NOCOPY number
438: ,p_soc_ins_contr_lvls_id IN number
431: ,p_attribute26 IN varchar2 default hr_api.g_varchar2
432: ,p_attribute27 IN varchar2 default hr_api.g_varchar2
433: ,p_attribute28 IN varchar2 default hr_api.g_varchar2
434: ,p_attribute29 IN varchar2 default hr_api.g_varchar2
435: ,p_attribute30 IN varchar2 default hr_api.g_varchar2
436: ,p_effective_date IN date
437: ,p_object_version_number IN OUT NOCOPY number
438: ,p_soc_ins_contr_lvls_id IN number
439: ,p_datetrack_mode in varchar2
436: ,p_effective_date IN date
437: ,p_object_version_number IN OUT NOCOPY number
438: ,p_soc_ins_contr_lvls_id IN number
439: ,p_datetrack_mode in varchar2
440: ,p_flat_tax_limit_per_month IN number default hr_api.g_number
441: ,p_flat_tax_limit_per_year IN number default hr_api.g_number
442: ,p_min_increased_contribution IN number default hr_api.g_number
443: ,p_max_increased_contribution IN number default hr_api.g_number
444: ,p_month1 IN varchar2 default hr_api.g_varchar2
437: ,p_object_version_number IN OUT NOCOPY number
438: ,p_soc_ins_contr_lvls_id IN number
439: ,p_datetrack_mode in varchar2
440: ,p_flat_tax_limit_per_month IN number default hr_api.g_number
441: ,p_flat_tax_limit_per_year IN number default hr_api.g_number
442: ,p_min_increased_contribution IN number default hr_api.g_number
443: ,p_max_increased_contribution IN number default hr_api.g_number
444: ,p_month1 IN varchar2 default hr_api.g_varchar2
445: ,p_month1_min_contribution IN number default hr_api.g_number
438: ,p_soc_ins_contr_lvls_id IN number
439: ,p_datetrack_mode in varchar2
440: ,p_flat_tax_limit_per_month IN number default hr_api.g_number
441: ,p_flat_tax_limit_per_year IN number default hr_api.g_number
442: ,p_min_increased_contribution IN number default hr_api.g_number
443: ,p_max_increased_contribution IN number default hr_api.g_number
444: ,p_month1 IN varchar2 default hr_api.g_varchar2
445: ,p_month1_min_contribution IN number default hr_api.g_number
446: ,p_month1_max_contribution IN number default hr_api.g_number
439: ,p_datetrack_mode in varchar2
440: ,p_flat_tax_limit_per_month IN number default hr_api.g_number
441: ,p_flat_tax_limit_per_year IN number default hr_api.g_number
442: ,p_min_increased_contribution IN number default hr_api.g_number
443: ,p_max_increased_contribution IN number default hr_api.g_number
444: ,p_month1 IN varchar2 default hr_api.g_varchar2
445: ,p_month1_min_contribution IN number default hr_api.g_number
446: ,p_month1_max_contribution IN number default hr_api.g_number
447: ,p_month2 IN varchar2 default hr_api.g_varchar2
440: ,p_flat_tax_limit_per_month IN number default hr_api.g_number
441: ,p_flat_tax_limit_per_year IN number default hr_api.g_number
442: ,p_min_increased_contribution IN number default hr_api.g_number
443: ,p_max_increased_contribution IN number default hr_api.g_number
444: ,p_month1 IN varchar2 default hr_api.g_varchar2
445: ,p_month1_min_contribution IN number default hr_api.g_number
446: ,p_month1_max_contribution IN number default hr_api.g_number
447: ,p_month2 IN varchar2 default hr_api.g_varchar2
448: ,p_month2_min_contribution IN number default hr_api.g_number
441: ,p_flat_tax_limit_per_year IN number default hr_api.g_number
442: ,p_min_increased_contribution IN number default hr_api.g_number
443: ,p_max_increased_contribution IN number default hr_api.g_number
444: ,p_month1 IN varchar2 default hr_api.g_varchar2
445: ,p_month1_min_contribution IN number default hr_api.g_number
446: ,p_month1_max_contribution IN number default hr_api.g_number
447: ,p_month2 IN varchar2 default hr_api.g_varchar2
448: ,p_month2_min_contribution IN number default hr_api.g_number
449: ,p_month2_max_contribution IN number default hr_api.g_number
442: ,p_min_increased_contribution IN number default hr_api.g_number
443: ,p_max_increased_contribution IN number default hr_api.g_number
444: ,p_month1 IN varchar2 default hr_api.g_varchar2
445: ,p_month1_min_contribution IN number default hr_api.g_number
446: ,p_month1_max_contribution IN number default hr_api.g_number
447: ,p_month2 IN varchar2 default hr_api.g_varchar2
448: ,p_month2_min_contribution IN number default hr_api.g_number
449: ,p_month2_max_contribution IN number default hr_api.g_number
450: ,p_employee_contribution IN number default hr_api.g_number
443: ,p_max_increased_contribution IN number default hr_api.g_number
444: ,p_month1 IN varchar2 default hr_api.g_varchar2
445: ,p_month1_min_contribution IN number default hr_api.g_number
446: ,p_month1_max_contribution IN number default hr_api.g_number
447: ,p_month2 IN varchar2 default hr_api.g_varchar2
448: ,p_month2_min_contribution IN number default hr_api.g_number
449: ,p_month2_max_contribution IN number default hr_api.g_number
450: ,p_employee_contribution IN number default hr_api.g_number
451: ,p_contribution_level_type IN varchar2 default hr_api.g_varchar2
444: ,p_month1 IN varchar2 default hr_api.g_varchar2
445: ,p_month1_min_contribution IN number default hr_api.g_number
446: ,p_month1_max_contribution IN number default hr_api.g_number
447: ,p_month2 IN varchar2 default hr_api.g_varchar2
448: ,p_month2_min_contribution IN number default hr_api.g_number
449: ,p_month2_max_contribution IN number default hr_api.g_number
450: ,p_employee_contribution IN number default hr_api.g_number
451: ,p_contribution_level_type IN varchar2 default hr_api.g_varchar2
452: ) is
445: ,p_month1_min_contribution IN number default hr_api.g_number
446: ,p_month1_max_contribution IN number default hr_api.g_number
447: ,p_month2 IN varchar2 default hr_api.g_varchar2
448: ,p_month2_min_contribution IN number default hr_api.g_number
449: ,p_month2_max_contribution IN number default hr_api.g_number
450: ,p_employee_contribution IN number default hr_api.g_number
451: ,p_contribution_level_type IN varchar2 default hr_api.g_varchar2
452: ) is
453:
446: ,p_month1_max_contribution IN number default hr_api.g_number
447: ,p_month2 IN varchar2 default hr_api.g_varchar2
448: ,p_month2_min_contribution IN number default hr_api.g_number
449: ,p_month2_max_contribution IN number default hr_api.g_number
450: ,p_employee_contribution IN number default hr_api.g_number
451: ,p_contribution_level_type IN varchar2 default hr_api.g_varchar2
452: ) is
453:
454:
447: ,p_month2 IN varchar2 default hr_api.g_varchar2
448: ,p_month2_min_contribution IN number default hr_api.g_number
449: ,p_month2_max_contribution IN number default hr_api.g_number
450: ,p_employee_contribution IN number default hr_api.g_number
451: ,p_contribution_level_type IN varchar2 default hr_api.g_varchar2
452: ) is
453:
454:
455: --
547: , p_employee_contribution => p_employee_contribution
548: , p_contribution_level_type => p_contribution_level_type
549: );
550: EXCEPTION
551: WHEN hr_api.cannot_find_prog_unit THEN
552: hr_api.cannot_find_prog_unit_error
553: (p_module_name => 'update_soc_ins_contributions'
554: ,p_hook_type => 'BP'
555: );
548: , p_contribution_level_type => p_contribution_level_type
549: );
550: EXCEPTION
551: WHEN hr_api.cannot_find_prog_unit THEN
552: hr_api.cannot_find_prog_unit_error
553: (p_module_name => 'update_soc_ins_contributions'
554: ,p_hook_type => 'BP'
555: );
556: --
681: , p_contribution_level_type => p_contribution_level_type
682: );
683:
684: EXCEPTION
685: WHEN hr_api.cannot_find_prog_unit THEN
686: hr_api.cannot_find_prog_unit_error
687: (p_module_name => 'update_soc_ins_contributions'
688: ,p_hook_type => 'AP'
689: );
682: );
683:
684: EXCEPTION
685: WHEN hr_api.cannot_find_prog_unit THEN
686: hr_api.cannot_find_prog_unit_error
687: (p_module_name => 'update_soc_ins_contributions'
688: ,p_hook_type => 'AP'
689: );
690: --
696: --
697: -- When in validation only mode RAISE the Validate_Enabled EXCEPTION
698: --
699: IF p_validate THEN
700: RAISE hr_api.validate_enabled;
701: END IF;
702: --
703: -- Set all output arguments
704: --
709: hr_utility.set_location(' Leaving:'||l_proc, 70);
710: --
711: EXCEPTION
712: --
713: WHEN hr_api.validate_enabled THEN
714: --
715: -- As the Validate_Enabled EXCEPTION has been RAISEd
716: -- we must rollback to the SAVEPOINT
717: --
788: ,p_effective_date => TRUNC(p_effective_date)
789: ,p_datetrack_mode => p_datetrack_mode);
790: --
791: EXCEPTION
792: WHEN hr_api.cannot_find_prog_unit THEN
793: hr_api.cannot_find_prog_unit_error
794: (p_module_name => 'delete_soc_ins_contributions'
795: ,p_hook_type => 'BP'
796: );
789: ,p_datetrack_mode => p_datetrack_mode);
790: --
791: EXCEPTION
792: WHEN hr_api.cannot_find_prog_unit THEN
793: hr_api.cannot_find_prog_unit_error
794: (p_module_name => 'delete_soc_ins_contributions'
795: ,p_hook_type => 'BP'
796: );
797: --
822: ,p_effective_date => TRUNC(p_effective_date)
823: ,p_datetrack_mode => p_datetrack_mode
824: );
825: EXCEPTION
826: WHEN hr_api.cannot_find_prog_unit THEN
827: hr_api.cannot_find_prog_unit_error
828: (p_module_name => 'delete_soc_ins_contributions'
829: ,p_hook_type => 'AP'
830: );
823: ,p_datetrack_mode => p_datetrack_mode
824: );
825: EXCEPTION
826: WHEN hr_api.cannot_find_prog_unit THEN
827: hr_api.cannot_find_prog_unit_error
828: (p_module_name => 'delete_soc_ins_contributions'
829: ,p_hook_type => 'AP'
830: );
831: --
837: --
838: -- When in validation only mode RAISE the Validate_Enabled EXCEPTION
839: --
840: IF p_validate THEN
841: RAISE hr_api.validate_enabled;
842: END IF;
843: --
844: p_object_version_number := l_object_version_number;
845: p_effective_start_date := l_effective_start_date;
848: hr_utility.set_location(' Leaving:'||l_proc, 70);
849: --
850: EXCEPTION
851: --
852: WHEN hr_api.validate_enabled THEN
853: --
854: -- As the Validate_Enabled EXCEPTION has been RAISEd
855: -- we must rollback to the SAVEPOINT
856: --