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 3074: -- - PER_EVENTS

3070: -- Description:
3071: -- Validates that an assignment cannot be purged if foreign key
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

Line 3114: cursor csr_per_events is

3110: --
3111: l_exists varchar2(1);
3112: l_proc varchar2(72) := g_package||'chk_ref_int_del';
3113: --
3114: cursor csr_per_events is
3115: select null
3116: from sys.dual
3117: where exists(select null
3118: from per_events pe

Line 3118: from per_events pe

3114: cursor csr_per_events is
3115: select null
3116: from sys.dual
3117: where exists(select null
3118: from per_events pe
3119: where pe.assignment_id = p_assignment_id
3120: and (p_datetrack_mode = 'ZAP'
3121: or (p_datetrack_mode = 'DELETE'
3122: and date_start > p_validation_start_date))

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

3222: begin
3223: hr_utility.set_location('Entering:'|| l_proc, 1);
3224: --
3225: -- Check that no child records exist for the
3226: -- assignment on per_events when the assignment is
3227: -- deleted
3228: --
3229: open csr_per_events;
3230: fetch csr_per_events into l_exists;

Line 3229: open csr_per_events;

3225: -- Check that no child records exist for the
3226: -- assignment on per_events when the assignment is
3227: -- deleted
3228: --
3229: open csr_per_events;
3230: fetch csr_per_events into l_exists;
3231: if csr_per_events%found then
3232: close csr_per_events;
3233: hr_utility.set_message(801,'HR_7400_ASG_NO_DEL_ASS_EVENTS');

Line 3230: fetch csr_per_events into l_exists;

3226: -- assignment on per_events when the assignment is
3227: -- deleted
3228: --
3229: open csr_per_events;
3230: fetch csr_per_events into l_exists;
3231: if csr_per_events%found then
3232: close csr_per_events;
3233: hr_utility.set_message(801,'HR_7400_ASG_NO_DEL_ASS_EVENTS');
3234: hr_utility.raise_error;

Line 3231: if csr_per_events%found then

3227: -- deleted
3228: --
3229: open csr_per_events;
3230: fetch csr_per_events into l_exists;
3231: if csr_per_events%found then
3232: close csr_per_events;
3233: hr_utility.set_message(801,'HR_7400_ASG_NO_DEL_ASS_EVENTS');
3234: hr_utility.raise_error;
3235: end if;

Line 3232: close csr_per_events;

3228: --
3229: open csr_per_events;
3230: fetch csr_per_events into l_exists;
3231: if csr_per_events%found then
3232: close csr_per_events;
3233: hr_utility.set_message(801,'HR_7400_ASG_NO_DEL_ASS_EVENTS');
3234: hr_utility.raise_error;
3235: end if;
3236: close csr_per_events;

Line 3236: close csr_per_events;

3232: close csr_per_events;
3233: hr_utility.set_message(801,'HR_7400_ASG_NO_DEL_ASS_EVENTS');
3234: hr_utility.raise_error;
3235: end if;
3236: close csr_per_events;
3237: --
3238: hr_utility.set_location(l_proc, 2);
3239: --
3240: -- Check that no child records exist for the