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.SSP_SSP_PKG dependencies on SSP_TEMP_AFFECTED_ROWS

Line 230: 115.55 09-DEC-06 5706912 KTHAMPAN Amend procedure ins_ssp_temp_affected_rows_PIW,

226: instead of 1 October 2006.
227: 115.52 09-SEP-06 5517272 HWINSOR Changed nocopy declaration
228: 115.53 19-SEP-06 5550795 KTHAMPAN Amend the check_age
229: 115.54 12-OCT-06 5583730 NPERSHAD Modified the function absence_is_a_PIW with 4 parameters.
230: 115.55 09-DEC-06 5706912 KTHAMPAN Amend procedure ins_ssp_temp_affected_rows_PIW,
231: update_linked_absence_ids and person_control
232: 115.56 19-MAR-07 5932995 HWINSOR Arcs in KTHAMPAN changes. Employees starting
233: post 1-Oct-06 have correct PIW start dates.
234: 115.57 23-DEC-07 6658285 PBALU Changed a For loop in qualifying_days_in_period to use

Line 650: ssp_temp_affected_rows TRANSACTION

646: -- Get all the absences affected by the current transaction.
647: --
648: select absence.*
649: from per_absence_attendances ABSENCE,
650: ssp_temp_affected_rows TRANSACTION
651: where
652: ( (transaction.PIW_ID = absence.absence_attendance_id and
653: absence.linked_absence_id IS NULL)
654: or

Line 698: update ssp_temp_affected_rows

694: --
695: -- Update the list of PIWs affected by the current transaction to
696: -- reflect the PIW series actually affected.
697: --
698: update ssp_temp_affected_rows
699: set PIW_ID = l_new_linked_absence_id
700: where PIW_ID = new_link.absence_attendance_id;
701: end if;
702: end if;

Line 4137: procedure ins_ssp_temp_affected_rows_PIW(p_absence_id in number,

4133: hr_utility.set_location('Leaving :'||l_proc,100);
4134: --
4135: end generate_payments;
4136: --------------------------------------------------------------------------------
4137: procedure ins_ssp_temp_affected_rows_PIW(p_absence_id in number,
4138: p_deleting in boolean default false) is
4139: --
4140: -- Inserts a row in ssp_temp_affected_rows for the PIW id, if not already there
4141: --

Line 4140: -- Inserts a row in ssp_temp_affected_rows for the PIW id, if not already there

4136: --------------------------------------------------------------------------------
4137: procedure ins_ssp_temp_affected_rows_PIW(p_absence_id in number,
4138: p_deleting in boolean default false) is
4139: --
4140: -- Inserts a row in ssp_temp_affected_rows for the PIW id, if not already there
4141: --
4142: l_proc varchar2 (72) := g_package||'ins_ssp_temp_affected_rows_PIW';
4143: l_deleting_ch varchar2(1);
4144: --

Line 4142: l_proc varchar2 (72) := g_package||'ins_ssp_temp_affected_rows_PIW';

4138: p_deleting in boolean default false) is
4139: --
4140: -- Inserts a row in ssp_temp_affected_rows for the PIW id, if not already there
4141: --
4142: l_proc varchar2 (72) := g_package||'ins_ssp_temp_affected_rows_PIW';
4143: l_deleting_ch varchar2(1);
4144: --
4145: begin
4146: --

Line 4158: insert into ssp_temp_affected_rows (PIW_id, p_deleting, locked)

4154: if p_absence_id is not null then
4155: hr_utility.trace('inserting record for absence '||to_char(p_absence_id)||
4156: 'deleting is '||l_deleting_ch);
4157: --
4158: insert into ssp_temp_affected_rows (PIW_id, p_deleting, locked)
4159: select p_absence_id, l_deleting_ch, userenv('sessionid')
4160: from sys.dual
4161: where not exists
4162: (select null

Line 4163: from ssp_temp_affected_rows t2

4159: select p_absence_id, l_deleting_ch, userenv('sessionid')
4160: from sys.dual
4161: where not exists
4162: (select null
4163: from ssp_temp_affected_rows t2
4164: where t2.PIW_id = p_absence_id);
4165: end if;
4166: --
4167: hr_utility.set_location('Leaving :'||l_proc,100);

Line 4169: end ins_ssp_temp_affected_rows_PIW;

4165: end if;
4166: --
4167: hr_utility.set_location('Leaving :'||l_proc,100);
4168: --
4169: end ins_ssp_temp_affected_rows_PIW;
4170: --------------------------------------------------------------------------------
4171: procedure SSP1L_control (
4172: --
4173: -- If prior employment details are updated then we must recalculate SSP

Line 4227: ins_ssp_temp_affected_rows_PIW (l_PIW_ID, p_deleting => FALSE);

4223: if l_PIW_ID is not null then
4224: --
4225: -- Store the PIW ID for later use in the recalculate_SSP_and_SMP procedure
4226: --
4227: ins_ssp_temp_affected_rows_PIW (l_PIW_ID, p_deleting => FALSE);
4228: end if;
4229: --
4230: hr_utility.set_location('Leaving :'||l_proc,100);
4231: --

Line 4298: ins_ssp_temp_affected_rows_PIW (l_absence.absence_attendance_id,

4294: p_date_of_birth),
4295: p_date_of_death))
4296: then
4297: if l_employee_age < 16 then
4298: ins_ssp_temp_affected_rows_PIW (l_absence.absence_attendance_id,
4299: p_deleting => FALSE);
4300: else
4301: ins_ssp_temp_affected_rows_PIW (nvl(l_absence.linked_absence_id,
4302: l_absence.absence_attendance_id),

Line 4301: ins_ssp_temp_affected_rows_PIW (nvl(l_absence.linked_absence_id,

4297: if l_employee_age < 16 then
4298: ins_ssp_temp_affected_rows_PIW (l_absence.absence_attendance_id,
4299: p_deleting => FALSE);
4300: else
4301: ins_ssp_temp_affected_rows_PIW (nvl(l_absence.linked_absence_id,
4302: l_absence.absence_attendance_id),
4303: p_deleting => FALSE);
4304: end if;
4305: end if;

Line 4370: delete ssp_temp_affected_rows

4366: close csr_person;
4367: --
4368: generate_payments (p_entitled_to_SSP => FALSE);
4369: --
4370: delete ssp_temp_affected_rows
4371: where PIW_id = g_PIW_id;
4372: else
4373: --
4374: -- The PIW series must have been updated or inserted. Recalculate SSP.

Line 4375: ins_ssp_temp_affected_rows_PIW (nvl(p_linked_absence_id,p_absence_attendance_id)

4371: where PIW_id = g_PIW_id;
4372: else
4373: --
4374: -- The PIW series must have been updated or inserted. Recalculate SSP.
4375: ins_ssp_temp_affected_rows_PIW (nvl(p_linked_absence_id,p_absence_attendance_id)
4376: ,p_deleting);
4377: end if;
4378: --
4379: hr_utility.set_location('Leaving :'||l_proc,100);

Line 4433: ins_ssp_temp_affected_rows_PIW (g_absence.absence_attendance_id,

4429: if g_absence.absence_attendance_id is not null
4430: then
4431: hr_utility.set_location (l_proc,10);
4432: --
4433: ins_ssp_temp_affected_rows_PIW (g_absence.absence_attendance_id,
4434: p_deleting => FALSE);
4435: end if;
4436: --
4437: hr_utility.set_location('Leaving :'||l_proc,100);

Line 4453: ins_ssp_temp_affected_rows_PIW (p_absence_id, p_deleting => FALSE);

4449: hr_utility.set_location('Entering:'||l_proc,1);
4450: --
4451: if p_absence_id is not null
4452: then
4453: ins_ssp_temp_affected_rows_PIW (p_absence_id, p_deleting => FALSE);
4454: end if;
4455: --
4456: hr_utility.set_location('Leaving :'||l_proc,100);
4457: --

Line 4473: ins_ssp_temp_affected_rows_PIW (p_absence_id, p_deleting => FALSE);

4469: hr_utility.set_location('Entering:'||l_proc,1);
4470: --
4471: if p_absence_id is not null and g_absence_del = 'N'
4472: then
4473: ins_ssp_temp_affected_rows_PIW (p_absence_id, p_deleting => FALSE);
4474: end if;
4475:
4476: g_absence_del := 'N';
4477: --