SQL-002: Task select

Retrieves one task row through pk82036_task.task_select.

Classification

Field	Value
SQL ID	SQL-002
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	WCIS_DBA
Command type	StoredProcedure
Business object	clsTask
Criteria property	RetrieveSQL
Lifecycle method	BeforeRetrieve

Parameters

Parameter	Direction	Type	Max length	Description
:TaskID	Input	TASK.TASK_SEQ_NUM%TYPE	N/A	Single-task primary key.
:recordset	Output (Cursor)	REF CURSOR	N/A	Returned cursor.

Tables

Table	Access	Columns used
TASK	SELECT	TASK_SEQ_NUM and mapped task/context/audit columns

Sample SQL

pk82036_task.task_select(
  taskseqnum => :TaskID,
  recordset => :recordset
);

Operations and processes

• Retrieve single task

Sources

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