PACKAGE: APPS.CSD_REPAIR_ORDER_GROUPS_PKG

Source

1 PACKAGE CSD_REPAIR_ORDER_GROUPS_PKG AUTHID CURRENT_USER as
2 /* $Header: csdtgrgs.pls 115.6 2002/12/02 23:41:34 takwong noship $ */
3 -- Start of Comments
4 -- Package name     : CSD_REPAIR_ORDER_GROUPS_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 PROCEDURE Insert_Row(
11           px_REPAIR_GROUP_ID   IN OUT NOCOPY NUMBER
12          ,p_INCIDENT_ID    NUMBER
13          ,p_REPAIR_GROUP_NUMBER    VARCHAR2
14          ,p_REPAIR_TYPE_ID    NUMBER
15          ,p_INVENTORY_ITEM_ID    NUMBER
16          ,p_UNIT_OF_MEASURE    VARCHAR2
17          ,p_GROUP_QUANTITY    NUMBER
18          ,p_REPAIR_ORDER_QUANTITY    NUMBER
19          ,p_RMA_QUANTITY    NUMBER
20          ,p_RECEIVED_QUANTITY    NUMBER
21          ,p_APPROVED_QUANTITY    NUMBER
22          ,p_SUBMITTED_QUANTITY    NUMBER
23          ,p_COMPLETED_QUANTITY    NUMBER
24          ,p_RELEASED_QUANTITY    NUMBER
25          ,p_SHIPPED_QUANTITY    NUMBER
26          ,p_CREATED_BY    NUMBER
27          ,p_CREATION_DATE    DATE
28          ,p_LAST_UPDATED_BY    NUMBER
29          ,p_LAST_UPDATE_DATE    DATE
30          ,p_LAST_UPDATE_LOGIN    NUMBER
31          ,p_CONTEXT    VARCHAR2
32          ,p_ATTRIBUTE1    VARCHAR2
33          ,p_ATTRIBUTE2    VARCHAR2
34          ,p_ATTRIBUTE3    VARCHAR2
35          ,p_ATTRIBUTE4    VARCHAR2
36          ,p_ATTRIBUTE5    VARCHAR2
37          ,p_ATTRIBUTE6    VARCHAR2
38          ,p_ATTRIBUTE7    VARCHAR2
39          ,p_ATTRIBUTE8    VARCHAR2
40          ,p_ATTRIBUTE9    VARCHAR2
41          ,p_ATTRIBUTE10    VARCHAR2
42          ,p_ATTRIBUTE11    VARCHAR2
43          ,p_ATTRIBUTE12    VARCHAR2
44          ,p_ATTRIBUTE13    VARCHAR2
45          ,p_ATTRIBUTE14    VARCHAR2
46          ,p_ATTRIBUTE15    VARCHAR2
47          ,p_OBJECT_VERSION_NUMBER    NUMBER
48          ,p_GROUP_TXN_STATUS    VARCHAR2
49          ,p_WIP_ENTITY_ID    NUMBER
50         ,p_GROUP_APPROVAL_STATUS  VARCHAR2
51         ,p_REPAIR_MODE  VARCHAR2);
52 
53 PROCEDURE Update_Row(
54           p_REPAIR_GROUP_ID    NUMBER
55          ,p_INCIDENT_ID    NUMBER
56          ,p_REPAIR_GROUP_NUMBER    VARCHAR2
57          ,p_REPAIR_TYPE_ID    NUMBER
58          ,p_INVENTORY_ITEM_ID    NUMBER
59          ,p_UNIT_OF_MEASURE    VARCHAR2
60          ,p_GROUP_QUANTITY    NUMBER
61          ,p_REPAIR_ORDER_QUANTITY    NUMBER
62          ,p_RMA_QUANTITY    NUMBER
63          ,p_RECEIVED_QUANTITY    NUMBER
64          ,p_APPROVED_QUANTITY    NUMBER
65          ,p_SUBMITTED_QUANTITY    NUMBER
66          ,p_COMPLETED_QUANTITY    NUMBER
67          ,p_RELEASED_QUANTITY    NUMBER
68          ,p_SHIPPED_QUANTITY    NUMBER
69          ,p_CREATED_BY    NUMBER
70          ,p_CREATION_DATE    DATE
71          ,p_LAST_UPDATED_BY    NUMBER
72          ,p_LAST_UPDATE_DATE    DATE
73          ,p_LAST_UPDATE_LOGIN    NUMBER
74          ,p_CONTEXT    VARCHAR2
75          ,p_ATTRIBUTE1    VARCHAR2
76          ,p_ATTRIBUTE2    VARCHAR2
77          ,p_ATTRIBUTE3    VARCHAR2
78          ,p_ATTRIBUTE4    VARCHAR2
79          ,p_ATTRIBUTE5    VARCHAR2
80          ,p_ATTRIBUTE6    VARCHAR2
81          ,p_ATTRIBUTE7    VARCHAR2
82          ,p_ATTRIBUTE8    VARCHAR2
83          ,p_ATTRIBUTE9    VARCHAR2
84          ,p_ATTRIBUTE10    VARCHAR2
85          ,p_ATTRIBUTE11    VARCHAR2
86          ,p_ATTRIBUTE12    VARCHAR2
87          ,p_ATTRIBUTE13    VARCHAR2
88          ,p_ATTRIBUTE14    VARCHAR2
89          ,p_ATTRIBUTE15    VARCHAR2
90          ,p_OBJECT_VERSION_NUMBER    NUMBER
91          ,p_GROUP_TXN_STATUS    VARCHAR2
92          ,p_WIP_ENTITY_ID    NUMBER
93         ,p_GROUP_APPROVAL_STATUS  VARCHAR2
94         ,p_REPAIR_MODE  VARCHAR2);
95 
96 PROCEDURE Lock_Row(
97           p_REPAIR_GROUP_ID    NUMBER
98          ,p_OBJECT_VERSION_NUMBER    NUMBER);
99 
100 PROCEDURE Delete_Row(
101     p_REPAIR_GROUP_ID  NUMBER);
102 End CSD_REPAIR_ORDER_GROUPS_PKG;