DBA Data[Home] [Help] [Dependency Information]

TABLE: SSP.SSP_TEMP_AFFECTED_ROWS

Object Details
Object Name: SSP_TEMP_AFFECTED_ROWS
Object Type: TABLE
Owner: SSP
FND Design Data: TableSSP.SSP_TEMP_AFFECTED_ROWS
Subobject Name:
Status: VALID


This table is populated by database ROW triggers on various tables
concerned with SSP. The row will contain either a PIW_id or
a maternity_id of a PIW/maternity that will be affected by the
triggering change.
The table is read by the STATEMENT level trigger on those same tables,
and the 'locked' column is set to 'Y' while the SSP/SMP is
recalculated for that row. This is because the statement level
triggers which cause it to be read may be fired recursively. Thus, we
can ensure that we only read rows which have not been read by a higher
level triggering statement.
The only reason for this table is that we cannot directly call the
recalculation processes directly from database row triggers because
of the 'mutating table restriction' (see Oracle Application
Developers' Guide).
Note that this table is for temporary data ONLY and should never have
committed data in it. After the recalculation processes have
completed, the rows are deleted.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
MATERNITY_ID NUMBER

Foreign key to SSP_MATERNITIES.
PIW_ID NUMBER

Foreign key to PER_ABSENCE_ATTENDANCES (ABSENCE_ATTENDANCE_ID).
LOCKED VARCHAR2 (30)
Indicates that this row has been selected for processing.
P_DELETING VARCHAR2 (1)
Indicates whether the database mode is delete or not
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT MATERNITY_ID
,      PIW_ID
,      LOCKED
,      P_DELETING
FROM SSP.SSP_TEMP_AFFECTED_ROWS;

Dependencies

[top of page]

SSP.SSP_TEMP_AFFECTED_ROWS does not reference any database object

SSP.SSP_TEMP_AFFECTED_ROWS is referenced by following:

SchemaAPPS
SynonymSSP_TEMP_AFFECTED_ROWS