1 PACKAGE CSD_GROUP_JOB_PARAM_TEMP_PKG AUTHID CURRENT_USER as
2 /* $Header: csdtjprs.pls 115.4 2002/12/02 23:43:17 takwong noship $ */
3 -- Start of Comments
4 -- Package name : CSD_GROUP_JOB_PARAM_TEMP_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 PROCEDURE Insert_Row(
11 px_GROUP_JOB_ID IN OUT NOCOPY NUMBER
12 ,p_REPAIR_GROUP_ID NUMBER
13 ,p_INVENTORY_ITEM_ID NUMBER
14 ,p_ORGANIZATION_ID NUMBER
15 ,p_JOB_TYPE NUMBER
16 ,p_ROUTING_REFERENCE_ID NUMBER
17 ,p_ALTERNATE_DESIGNATOR_CODE VARCHAR2
18 ,p_JOB_STATUS_TYPE VARCHAR2
19 ,p_ACCOUNTING_CLASS VARCHAR2
20 ,p_START_DATE DATE
21 ,p_COMPLETION_DATE DATE
22 ,p_QUANTITY_RECEIVED NUMBER
23 ,p_QUANTITY_SUBMITTED NUMBER
24 ,p_ITEM_REVISION VARCHAR2
25 ,p_CREATED_BY NUMBER
26 ,p_CREATION_DATE DATE
27 ,p_LAST_UPDATED_BY NUMBER
28 ,p_LAST_UPDATE_LOGIN NUMBER
29 ,p_OBJECT_VERSION_NUMBER NUMBER
30 ,p_LAST_UPDATE_DATE DATE
31 ,p_INCIDENT_ID NUMBER
32 ,p_PROCESS_ID NUMBER);
33
34 PROCEDURE Update_Row(
35 p_GROUP_JOB_ID NUMBER
36 ,p_REPAIR_GROUP_ID NUMBER
37 ,p_INVENTORY_ITEM_ID NUMBER
38 ,p_ORGANIZATION_ID NUMBER
39 ,p_JOB_TYPE NUMBER
40 ,p_ROUTING_REFERENCE_ID NUMBER
41 ,p_ALTERNATE_DESIGNATOR_CODE VARCHAR2
42 ,p_JOB_STATUS_TYPE VARCHAR2
43 ,p_ACCOUNTING_CLASS VARCHAR2
44 ,p_START_DATE DATE
45 ,p_COMPLETION_DATE DATE
46 ,p_QUANTITY_RECEIVED NUMBER
47 ,p_QUANTITY_SUBMITTED NUMBER
48 ,p_ITEM_REVISION VARCHAR2
49 ,p_CREATED_BY NUMBER
50 ,p_CREATION_DATE DATE
51 ,p_LAST_UPDATED_BY NUMBER
52 ,p_LAST_UPDATE_LOGIN NUMBER
53 ,p_OBJECT_VERSION_NUMBER NUMBER
54 ,p_LAST_UPDATE_DATE DATE
55 ,p_INCIDENT_ID NUMBER
56 ,p_PROCESS_ID NUMBER);
57
58 PROCEDURE Lock_Row(
59 p_GROUP_JOB_ID NUMBER
60 ,p_OBJECT_VERSION_NUMBER NUMBER);
61
62 PROCEDURE Delete_Row(
63 p_GROUP_JOB_ID NUMBER);
64 End CSD_GROUP_JOB_PARAM_TEMP_PKG;