SQL-015: Task purge¶

Physically deletes previously soft-deleted task rows through PK82036_Task.Task_Purge.

Classification¶

Field	Value
SQL ID	SQL-015
Operation type	Delete
Execution method	Stored procedure
Database	Oracle
Schema	`WCIS_DBA`
Command type	StoredProcedure
Business object	`clsTaskCollection`
Criteria property	N/A
Lifecycle method	`PurgeTasks`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:intasksourcecode`	Input	`TASK.TASK_SOURCE_CODE%TYPE`	5	Source-system filter.
`:intaskcategorycode`	Input	`TASK.TASK_CATEGORY_CODE%TYPE`	5	Category filter.
`:inkeepdays`	Input	`VARCHAR2`	5	Retention days.
`:outdelrows`	Output	`VARCHAR2`	15	Deleted-row count.

Tables¶

Table	Access	Columns used
TASK	DELETE	TASK_SOURCE_CODE, TASK_CATEGORY_CODE, DELETE_FLAG, UPDATE_DATE

Sample SQL¶

PK82036_Task.Task_Purge(
  intasksourcecode => :intasksourcecode,
  intaskcategorycode => :intaskcategorycode,
  inkeepdays => :inkeepdays,
  outdelrows => :outdelrows
);

Operations and processes¶

Purge deleted tasks

Sources¶

Business\SAIF.Business.Tasks\clsTaskCollection.vb