SQL-013: Task update
Updates an existing task row through pk82036_task.task_update.
Classification
| Field |
Value |
| SQL ID |
SQL-013 |
| Operation type |
Update |
| Execution method |
Stored procedure |
| Database |
Oracle |
| Schema |
WCIS_DBA |
| Command type |
StoredProcedure |
| Business object |
clsTask |
| Criteria property |
UpdateSQL |
| Lifecycle method |
BeforeUpdate |
Parameters
| Parameter |
Direction |
Type |
Max length |
Description |
:TaskSeqNum |
Input |
TASK.TASK_SEQ_NUM%TYPE |
N/A |
Target task row. |
:TaskDate |
Input |
TASK.TASK_DATE%TYPE |
N/A |
Updated due date. |
:TaskText |
Input |
TASK.TASK_TEXT%TYPE |
4000 |
Updated text. |
:TaskUser |
Input |
TASK.TASK_USER%TYPE |
30 |
Updated assignee. |
:TaskPriorityCode |
Input |
TASK.TASK_PRIORITY_CODE%TYPE |
5 |
Priority code. |
:TaskCategoryCode |
Input |
TASK.TASK_CATEGORY_CODE%TYPE |
30 |
Category code. |
:TaskActionCode |
Input |
TASK.TASK_ACTION_CODE%TYPE |
5 |
Action code. |
:NotepadFlag |
Input |
TASK.NOTEPAD_FLAG%TYPE |
1 |
Notepad flag. |
:DeleteFlag |
Input |
TASK.DELETE_FLAG%TYPE |
1 |
Delete flag value. |
:ClaimID |
Input |
TASK.CLAIM_ID%TYPE |
N/A |
Claim identifier. |
:PolicyNum |
Input |
TASK.POLICY_NUM%TYPE |
N/A |
Policy number. |
:ImageSeqNum |
Input |
TASK.IMAGE_SEQ_NUM%TYPE |
N/A |
Image sequence. |
:ContextCode |
Input |
TASK.CONTEXT_CODE%TYPE |
5 |
Context code. |
:ContextKey |
Input |
TASK.CONTEXT_KEY%TYPE |
100 |
Context key. |
:ContextCategory |
Input |
TASK.CONTEXT_CATEGORY%TYPE |
100 |
Context category. |
:ContextText |
Input |
TASK.CONTEXT_TEXT%TYPE |
4000 |
Context text. |
:ContextDate |
Input |
TASK.CONTEXT_DATE%TYPE |
N/A |
Context date. |
:ContextNum |
Input |
TASK.CONTEXT_NUM%TYPE |
N/A |
Context numeric value. |
:UpdateUser |
Input |
TASK.UPDATE_USER%TYPE |
30 |
Update user. |
:UpdateSeqNum |
Input |
TASK.UPDATE_SEQ_NUM%TYPE |
N/A |
Concurrency token. |
:TaskSecurity |
Input |
TASK.TASK_SECURITY%TYPE |
30 |
Security tag. |
:RowsAffected |
ReturnValue |
NUMBER |
N/A |
Rows affected. |
Tables
| Table |
Access |
Columns used |
| TASK |
UPDATE |
TASK_SEQ_NUM, TASK_DATE, TASK_TEXT, TASK_USER, TASK_PRIORITY_CODE, TASK_CATEGORY_CODE, TASK_ACTION_CODE, NOTEPAD_FLAG, DELETE_FLAG, CLAIM_ID, POLICY_NUM, IMAGE_SEQ_NUM, CONTEXT_*, UPDATE_DATE, UPDATE_SEQ_NUM, UPDATE_USER, TASK_SECURITY |
Sample SQL
pk82036_task.task_update(
:TaskSeqNum,
:TaskDate,
:TaskText,
:TaskUser,
:TaskPriorityCode,
:TaskCategoryCode,
:TaskActionCode,
:NotepadFlag,
:DeleteFlag,
:ClaimID,
:PolicyNum,
:ImageSeqNum,
:ContextCode,
:ContextKey,
:ContextCategory,
:ContextText,
:ContextDate,
:ContextNum,
:UpdateUser,
:UpdateSeqNum,
:TaskSecurity
) RETURN :RowsAffected;
Operations and processes
Business rules
Note: Statements marked with * are inferred from code behavior rather than explicit documentation or comments.
Sources
Business\SAIF.Business.Tasks\clsTask.vb