3072: -- references exist to any of the following tables :
3073: --
3074: -- - PER_EVENTS
3075: -- - PER_LETTER_REQUEST_LINES
3076: -- - PAY_COST_ALLOCATIONS_F
3077: -- - PAY_PAYROLL_ACTIONS
3078: -- - PAY_PERSONAL_PAYMENT_METHODS_F
3079: -- - PAY_ASSIGNMENT_ACTIONS
3080: -- - PER_COBRA_COV_ENROLLMENTS
3137: or (p_datetrack_mode = 'DELETE'
3138: and date_from > p_validation_start_date)));*/
3139: -- End of 3096114
3140: --
3141: cursor csr_pay_cost_allocations_f is
3142: select null
3143: from sys.dual
3144: where exists(select null
3145: from pay_cost_allocations_f
3141: cursor csr_pay_cost_allocations_f is
3142: select null
3143: from sys.dual
3144: where exists(select null
3145: from pay_cost_allocations_f
3146: where assignment_id = p_assignment_id
3147: and (p_datetrack_mode = 'ZAP'
3148: or (p_datetrack_mode = 'DELETE'
3149: and effective_start_date > p_validation_start_date)));
3254: --
3255: hr_utility.set_location(l_proc, 3);
3256: --
3257: -- Check that no child records exist for the
3258: -- assignment on pay_cost_allocations_f when
3259: -- the assignment is deleted
3260: --
3261: open csr_pay_cost_allocations_f;
3262: fetch csr_pay_cost_allocations_f into l_exists;
3257: -- Check that no child records exist for the
3258: -- assignment on pay_cost_allocations_f when
3259: -- the assignment is deleted
3260: --
3261: open csr_pay_cost_allocations_f;
3262: fetch csr_pay_cost_allocations_f into l_exists;
3263: if csr_pay_cost_allocations_f%found then
3264: close csr_pay_cost_allocations_f;
3265: hr_utility.set_message(801,'HR_7402_ASG_NO_DEL_COST_ALLOCS');
3258: -- assignment on pay_cost_allocations_f when
3259: -- the assignment is deleted
3260: --
3261: open csr_pay_cost_allocations_f;
3262: fetch csr_pay_cost_allocations_f into l_exists;
3263: if csr_pay_cost_allocations_f%found then
3264: close csr_pay_cost_allocations_f;
3265: hr_utility.set_message(801,'HR_7402_ASG_NO_DEL_COST_ALLOCS');
3266: hr_utility.raise_error;
3259: -- the assignment is deleted
3260: --
3261: open csr_pay_cost_allocations_f;
3262: fetch csr_pay_cost_allocations_f into l_exists;
3263: if csr_pay_cost_allocations_f%found then
3264: close csr_pay_cost_allocations_f;
3265: hr_utility.set_message(801,'HR_7402_ASG_NO_DEL_COST_ALLOCS');
3266: hr_utility.raise_error;
3267: end if;
3260: --
3261: open csr_pay_cost_allocations_f;
3262: fetch csr_pay_cost_allocations_f into l_exists;
3263: if csr_pay_cost_allocations_f%found then
3264: close csr_pay_cost_allocations_f;
3265: hr_utility.set_message(801,'HR_7402_ASG_NO_DEL_COST_ALLOCS');
3266: hr_utility.raise_error;
3267: end if;
3268: close csr_pay_cost_allocations_f;
3264: close csr_pay_cost_allocations_f;
3265: hr_utility.set_message(801,'HR_7402_ASG_NO_DEL_COST_ALLOCS');
3266: hr_utility.raise_error;
3267: end if;
3268: close csr_pay_cost_allocations_f;
3269: --
3270: hr_utility.set_location(l_proc, 4);
3271: --
3272: -- Check that no child records exist for the