APPS.SSP_SMP_SUPPORT_PKG dependencies on SSP_TEMP_AFFECTED_ROWS

Line 527: from ssp_temp_affected_rows TAR1

523: -- cause the row triggers to fire and call this procedure recursively),
524: -- and rows which are duplicated.
525: --
526: select tar1.maternity_id, nvl(tar1.p_deleting, 'N') l_deleting
527: from ssp_temp_affected_rows TAR1
528: where tar1.maternity_id is not null
529: --and nvl (tar1.locked, 'NULL') <> 'Y'
530: and tar1.locked = to_char(userenv('sessionid'))
531: for update;

Line 547: from ssp_temp_affected_rows TAR1

543: -- the previous "not exists" did not work... the data is already
544: -- selected before they can be updated.
545: --
546: select tar1.PIW_id, nvl(tar1.locked,'NULL') locked
547: from ssp_temp_affected_rows TAR1
548: where tar1.PIW_id is not null
549: -- and nvl (tar1.locked,'NULL') <> 'Y'
550: and tar1.locked = to_char(userenv('sessionid'))
551: for update;

Line 599: update ssp_temp_affected_rows

595: to_char(each_PIW.PIW_ID));
596: --
597: if each_PIW.locked <> 'Y'
598: then
599: update ssp_temp_affected_rows
600: set locked = 'Y'
601: where current of csr_affected_PIWs;
602: --
603: ssp_ssp_pkg.ssp_control(each_PIW.piw_id);

Line 613: update ssp_temp_affected_rows

609: for each_maternity in csr_affected_maternities LOOP
610: hr_utility.trace (' Recalculate SMP for maternity_id # '
611: ||to_char (each_maternity.maternity_id));
612: --
613: update ssp_temp_affected_rows
614: set locked = 'Y'
615: where current of csr_affected_maternities;
616: --
617: if each_maternity.l_deleting = 'Y'

Line 656: delete ssp_temp_affected_rows

652: where maternity_id = each_maternity.maternity_id;
653: end if;
654: end loop;
655: --
656: delete ssp_temp_affected_rows
657: where locked = to_char(userenv('sessionid'))
658: or locked is null
659: or locked not in (select to_char(AUDSID) from v$session);
660: end if;