1: PACKAGE BODY per_cancel_hire_or_apl_pkg AS
2: /* $Header: pecanhir.pkb 120.8.12010000.7 2008/09/29 05:19:08 ubhat ship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: pecanhir.pkb 120.8.12010000.7 2008/09/29 05:19:08 ubhat ship $ */
3: --
4: -- Package Variables
5: --
6: g_package VARCHAR2(33) := 'per_cancel_hire_or_apl_pkg.';
7: --
8: /*===========================================================================*
9: | |
10: | LOCK_CWK_ROWS |
2110: -- p_leaving_reason => null,
2111: -- p_old_date_start => null,
2112: -- p_old_leaving_reason => null);
2113: --
2114: per_cancel_hire_or_apl_pkg.update_person_list(p_person_id => p_person_id);
2115: --
2116: for asg_rec in c_assignments loop
2117: --
2118: hr_utility.set_location('cancel_hire_or_apl.do_cancel_hire', 501);
2778:
2779: end if;
2780: -- Bug 4095559 Ends
2781: --
2782: per_cancel_hire_or_apl_pkg.update_person_list (p_person_id => p_person_id);
2783: --
2784: for asg_sec_rec in csr_asg_sec loop
2785: --
2786: hr_security_internal.add_to_person_list(
4091: --
4092: END IF;
4093: -- end of fix 6992346
4094: --
4095: per_cancel_hire_or_apl_pkg.update_person_list(p_person_id => p_person_id);
4096: --
4097: for asg_sec_rec in csr_asg_sec loop
4098: --
4099: hr_utility.set_location(l_proc,300);
4164: RETURN l_legislation_code;
4165: --
4166: END return_legislation_code;
4167: --
4168: END per_cancel_hire_or_apl_pkg;