[Home] [Help]
775: close csr_linked_absence;
776: --
777: -- It is possible to enter separate but contiguous sickness absences. That
778: -- means that a series of absences could be entered consisting of four,
779: -- one-day absences. Each individual day would not itself comprise a PIW,
780: -- but taken together, a PIW is formed. Since absences must be entered in
781: -- chronological order, this would be detected on entry of the fourth one.
782: -- However, if the PIW thus formed links to a previous absence, then the
783: -- PIW ID must be applied to all four of the absences, not just the fourth
1289: where person_id = p_person_id);
1290:
1291: cursor get_age2 is
1292: select months_between(p_date,p_date_of_birth)/12
1293: from dual;
1294:
1295: begin
1296: if p_date_of_birth is null then
1297: open get_age;
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
4163: from ssp_temp_affected_rows t2
4164: where t2.PIW_id = p_absence_id);