eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ASG_BUS2 dependencies on PER_EVENTS

Line 3114: -- - PER_EVENTS

3110: -- Description:
3111: -- Validates that an assignment cannot be purged if foreign key
3112: -- references exist to any of the following tables :
3113: --
3114: -- - PER_EVENTS
3115: -- - PER_LETTER_REQUEST_LINES
3116: -- - PAY_COST_ALLOCATIONS_F
3117: -- - PAY_PAYROLL_ACTIONS
3118: -- - PAY_PERSONAL_PAYMENT_METHODS_F

Line 3154: cursor csr_per_events is

3150: --
3151: l_exists varchar2(1);
3152: l_proc varchar2(72) := g_package||'chk_ref_int_del';
3153: --
3154: cursor csr_per_events is
3155: select null
3156: from sys.dual
3157: where exists(select null
3158: from per_events pe

Line 3158: from per_events pe

3154: cursor csr_per_events is
3155: select null
3156: from sys.dual
3157: where exists(select null
3158: from per_events pe
3159: where pe.assignment_id = p_assignment_id
3160: and (p_datetrack_mode = 'ZAP'
3161: or (p_datetrack_mode = 'DELETE'
3162: and date_start > p_validation_start_date))

Line 3266: -- assignment on per_events when the assignment is

3262: begin
3263: hr_utility.set_location('Entering:'|| l_proc, 1);
3264: --
3265: -- Check that no child records exist for the
3266: -- assignment on per_events when the assignment is
3267: -- deleted
3268: --
3269: open csr_per_events;
3270: fetch csr_per_events into l_exists;

Line 3269: open csr_per_events;

3265: -- Check that no child records exist for the
3266: -- assignment on per_events when the assignment is
3267: -- deleted
3268: --
3269: open csr_per_events;
3270: fetch csr_per_events into l_exists;
3271: if csr_per_events%found then
3272: close csr_per_events;
3273: hr_utility.set_message(801,'HR_7400_ASG_NO_DEL_ASS_EVENTS');

Line 3270: fetch csr_per_events into l_exists;

3266: -- assignment on per_events when the assignment is
3267: -- deleted
3268: --
3269: open csr_per_events;
3270: fetch csr_per_events into l_exists;
3271: if csr_per_events%found then
3272: close csr_per_events;
3273: hr_utility.set_message(801,'HR_7400_ASG_NO_DEL_ASS_EVENTS');
3274: hr_utility.raise_error;

Line 3271: if csr_per_events%found then

3267: -- deleted
3268: --
3269: open csr_per_events;
3270: fetch csr_per_events into l_exists;
3271: if csr_per_events%found then
3272: close csr_per_events;
3273: hr_utility.set_message(801,'HR_7400_ASG_NO_DEL_ASS_EVENTS');
3274: hr_utility.raise_error;
3275: end if;

Line 3272: close csr_per_events;

3268: --
3269: open csr_per_events;
3270: fetch csr_per_events into l_exists;
3271: if csr_per_events%found then
3272: close csr_per_events;
3273: hr_utility.set_message(801,'HR_7400_ASG_NO_DEL_ASS_EVENTS');
3274: hr_utility.raise_error;
3275: end if;
3276: close csr_per_events;

Line 3276: close csr_per_events;

3272: close csr_per_events;
3273: hr_utility.set_message(801,'HR_7400_ASG_NO_DEL_ASS_EVENTS');
3274: hr_utility.raise_error;
3275: end if;
3276: close csr_per_events;
3277: --
3278: hr_utility.set_location(l_proc, 2);
3279: --
3280: -- Check that no child records exist for the