SQL-001: Task insert
Creates a new task row through pk82036_task.task_insert.
Classification
| Field |
Value |
| SQL ID |
SQL-001 |
| Operation type |
Create |
| Execution method |
Stored procedure |
| Database |
Oracle |
| Schema |
WCIS_DBA |
| Command type |
StoredProcedure |
| Business object |
clsTask |
| Criteria property |
InsertSQL |
| Lifecycle method |
BeforeInsert |
Parameters
| Parameter |
Direction |
Type |
Max length |
Description |
:TaskDate |
Input |
TASK.TASK_DATE%TYPE |
N/A |
Due date. |
:TaskText |
Input |
TASK.TASK_TEXT%TYPE |
4000 |
Task text. |
:TaskUser |
Input |
TASK.TASK_USER%TYPE |
30 |
Assignee. |
:TaskPriorityCode |
Input |
TASK.TASK_PRIORITY_CODE%TYPE |
5 |
Priority. |
:TaskCategoryCode |
Input |
TASK.TASK_CATEGORY_CODE%TYPE |
30 |
Category. |
:TaskSourceCode |
Input |
TASK.TASK_SOURCE_CODE%TYPE |
5 |
Source system. |
: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 |
Caller delete flag. |
: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. |
:CreateUser |
Input |
TASK.CREATE_USER%TYPE |
30 |
Create user. |
:UpdateUser |
Input |
TASK.UPDATE_USER%TYPE |
30 |
Update user. |
:TaskSecurity |
Input |
TASK.TASK_SECURITY%TYPE |
30 |
Task security. |
:RowsAffected |
ReturnValue |
NUMBER |
N/A |
Rows affected. |
Tables
| Table |
Access |
Columns used |
| TASK |
INSERT |
CLAIM_ID, CONTEXT_*, CREATE_DATE, CREATE_USER, DELETE_FLAG, IMAGE_SEQ_NUM, NOTEPAD_FLAG, POLICY_NUM, TASK_ACTION_CODE, TASK_CATEGORY_CODE, TASK_DATE, TASK_PRIORITY_CODE, TASK_SECURITY, TASK_SEQ_NUM, TASK_SOURCE_CODE, TASK_TEXT, TASK_USER, UPDATE_DATE, UPDATE_SEQ_NUM, UPDATE_USER |
Sample SQL
pk82036_task.task_insert(
:TaskDate,
:TaskText,
:TaskUser,
:TaskPriorityCode,
:TaskCategoryCode,
:TaskSourceCode,
:TaskActionCode,
:NotepadFlag,
:DeleteFlag,
:ClaimID,
:PolicyNum,
:ImageSeqNum,
:ContextCode,
:ContextKey,
:ContextCategory,
:ContextText,
:ContextDate,
:ContextNum,
:CreateUser,
:UpdateUser,
: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