1 PACKAGE CSD_TASKS_PKG AUTHID CURRENT_USER as
2 /* $Header: csdttsks.pls 120.0 2005/06/26 14:56:59 sangigup noship $ csdtacts.pls */
3
4 PROCEDURE Insert_Row(
5 px_repair_TASK_ID IN OUT NOCOPY NUMBER
6 ,p_task_id NUMBER
7 ,p_REPAIR_LINE_ID NUMBER
8 ,p_APPLICABLE_QA_PLANS VARCHAR2
9 ,p_OBJECT_VERSION_NUMBER NUMBER
10 ,p_CREATED_BY NUMBER
11 ,p_CREATION_DATE DATE
12 ,p_LAST_UPDATED_BY NUMBER
13 ,p_LAST_UPDATE_DATE DATE
14 ,p_LAST_UPDATE_LOGIN NUMBER
15 );
16
17 PROCEDURE Update_Row(
18 px_repair_TASK_ID NUMBER
19 ,p_TASK_ID NUMBER
20 ,p_OBJECT_VERSION_NUMBER NUMBER
21 ,p_REPAIR_LINE_ID NUMBER
22 ,p_APPLICABLE_QA_PLANS VARCHAR2
23 ,p_CREATED_BY NUMBER
24 ,p_CREATION_DATE DATE
25 ,p_LAST_UPDATED_BY NUMBER
26 ,p_LAST_UPDATE_DATE DATE
27 ,p_LAST_UPDATE_LOGIN NUMBER
28 );
29
30 PROCEDURE Lock_Row(
31 p_REPAIR_TASK_ID NUMBER
32 ,p_OBJECT_VERSION_NUMBER NUMBER);
33
34
35 PROCEDURE Delete_Row(
36 p_repair_TASK_ID NUMBER
37 );
38
39 End CSD_TASKS_PKG;