SQL-014: Task delete

Soft-deletes a task row through pk82036_task.task_delete.

Classification

Field	Value
SQL ID	SQL-014
Operation type	Delete
Execution method	Stored procedure
Database	Oracle
Schema	WCIS_DBA
Command type	StoredProcedure
Business object	clsTask
Criteria property	DeleteSQL
Lifecycle method	BeforeDelete

Parameters

Parameter	Direction	Type	Max length	Description
:TaskSeqNum	Input	TASK.TASK_SEQ_NUM%TYPE	N/A	Target task row.
:UpdateSeqNum	Input	TASK.UPDATE_SEQ_NUM%TYPE	N/A	Concurrency token.
:UpdateUser	Input	TASK.UPDATE_USER%TYPE	30	Update user.
:RowsAffected	ReturnValue	NUMBER	N/A	Rows affected.

Tables

Table	Access	Columns used
TASK	UPDATE	TASK_SEQ_NUM, UPDATE_SEQ_NUM, DELETE_FLAG, UPDATE_DATE, UPDATE_USER

Sample SQL

pk82036_task.task_delete(
  :TaskSeqNum,
  :UpdateSeqNum,
  :UpdateUser
) RETURN :RowsAffected;

Operations and processes

• Soft-delete task

Business rules

• BR-010

Sources

• Business\SAIF.Business.Tasks\clsTask.vb