eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.CSD_WIP_TRANSACTION_DTLS_PKG

Source


1 PACKAGE BODY CSD_WIP_TRANSACTION_DTLS_PKG as
2 /* $Header: csdtwtdb.pls 120.11.12020000.2 2013/02/07 00:25:31 vicli ship $ */
3 -- Start of Comments
4 -- Package name     : CSD_WIP_TRANSACTION_DTLS_PKG
5 -- Purpose          :
6 -- History          :
7 -- NOTE             :
8 -- End of Comments
9 
10 
11 
12 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSD_WIP_TRANSACTION_DTLS_PKG';
13 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdtdwdb.pls';
14 l_debug        NUMBER ;
15 
16 PROCEDURE Insert_Row(
17           px_WIP_TRANSACTION_DETAIL_ID IN OUT NOCOPY NUMBER
18          ,p_CREATED_BY           IN NUMBER
19          ,p_CREATION_DATE        IN DATE
20          ,p_LAST_UPDATED_BY      IN NUMBER
21          ,p_LAST_UPDATE_DATE     IN DATE
22          ,p_LAST_UPDATE_LOGIN    IN NUMBER
23          ,p_INVENTORY_ITEM_ID    IN NUMBER
24          ,p_WIP_ENTITY_ID        IN NUMBER
25          ,p_OPERATION_SEQ_NUM    IN NUMBER
26          ,p_RESOURCE_SEQ_NUM     IN NUMBER
27          ,p_employee_id          IN NUMBER
28          ,p_TRANSACTION_QUANTITY IN NUMBER
29          ,p_TRANSACTION_UOM      IN VARCHAR2
30          ,p_SERIAL_NUMBER        IN VARCHAR2
31          ,p_REVISION             IN VARCHAR2 -- swai: bug 7182047 (FP of 6995498)
32          -- swai bug 6841113: added material txn reason code
33          ,p_REASON_ID      IN NUMBER
34          -- swai: added code for operations
35          ,p_BACKFLUSH_FLAG             IN NUMBER
36          ,p_COUNT_POINT_TYPE           IN NUMBER
37          ,p_DEPARTMENT_ID              IN NUMBER
38          ,p_DESCRIPTION                IN VARCHAR2
39          ,p_FIRST_UNIT_COMPLETION_DATE IN DATE
40          ,p_FIRST_UNIT_START_DATE      IN DATE
41          ,p_LAST_UNIT_COMPLETION_DATE  IN DATE
42          ,p_LAST_UNIT_START_DATE       IN DATE
43          ,p_MINIMUM_TRANSFER_QUANTITY  IN NUMBER
44          ,p_STANDARD_OPERATION_ID      IN NUMBER
45          -- yvchen: bug 13258460
46          -- 12.1.3+ add DFF attributes to csd_wip_transaction_details
47          ,p_ATTRIBUTE_CATEGORY        VARCHAR2 := null
48          ,p_ATTRIBUTE1                VARCHAR2 := null
49          ,p_ATTRIBUTE2                VARCHAR2 := null
50          ,p_ATTRIBUTE3                VARCHAR2 := null
51          ,p_ATTRIBUTE4                VARCHAR2 := null
52          ,p_ATTRIBUTE5                VARCHAR2 := null
53          ,p_ATTRIBUTE6                VARCHAR2 := null
54          ,p_ATTRIBUTE7                VARCHAR2 := null
55          ,p_ATTRIBUTE8                VARCHAR2 := null
56          ,p_ATTRIBUTE9                VARCHAR2 := null
57          ,p_ATTRIBUTE10               VARCHAR2 := null
58          ,p_ATTRIBUTE11               VARCHAR2 := null
59          ,p_ATTRIBUTE12               VARCHAR2 := null
60          ,p_ATTRIBUTE13               VARCHAR2 := null
61          ,p_ATTRIBUTE14               VARCHAR2 := null
62          ,p_ATTRIBUTE15               VARCHAR2 := null
63          ,p_CREATE_RO_FLAG            VARCHAR2 := FND_API.G_MISS_CHAR --bug#13698799 auto create ro, parent ro
64          )
65 
66  IS
67    CURSOR C2 IS SELECT CSD_WIP_TRANSACTION_DETAILS_S1.nextval FROM sys.dual;
68    l_object_version_number NUMBER := 1;
69 BEGIN
70    If (px_WIP_TRANSACTION_DETAIL_ID IS NULL) OR (px_WIP_TRANSACTION_DETAIL_ID = FND_API.G_MISS_NUM) then
71        OPEN C2;
72        FETCH C2 INTO px_WIP_TRANSACTION_DETAIL_ID;
73        CLOSE C2;
74    End If;
75    INSERT INTO CSD_WIP_TRANSACTION_DETAILS(
76           WIP_TRANSACTION_DETAIL_ID
77           ,CREATED_BY
78          ,CREATION_DATE
79          ,LAST_UPDATED_BY
80          ,LAST_UPDATE_DATE
81          ,LAST_UPDATE_LOGIN
82          ,INVENTORY_ITEM_ID
83          ,WIP_ENTITY_ID
84          ,OPERATION_SEQ_NUM
85          ,RESOURCE_SEQ_NUM
86          ,employee_id
87          ,TRANSACTION_QUANTITY
88          ,TRANSACTION_UOM
89          ,SERIAL_NUMBER
90          ,REVISION         -- swai: bug 7182047 (FP of 6995498)
91          , REASON_ID         -- swai bug 6841113: added material txn reason code
92          -- swai: added code for operations
93          ,BACKFLUSH_FLAG
94          ,COUNT_POINT_TYPE
95          ,DEPARTMENT_ID
96          ,DESCRIPTION
97          ,FIRST_UNIT_COMPLETION_DATE
98          ,FIRST_UNIT_START_DATE
99          ,LAST_UNIT_COMPLETION_DATE
100          ,LAST_UNIT_START_DATE
101          ,MINIMUM_TRANSFER_QUANTITY
102          ,STANDARD_OPERATION_ID
103          -- end swai: added code for operations
104          ,OBJECT_VERSION_NUMBER
105          -- yvchen: bug 13258460
106          -- 12.1.3+ add DFF attributes
107          ,ATTRIBUTE_CATEGORY
108          ,ATTRIBUTE1
109          ,ATTRIBUTE2
110          ,ATTRIBUTE3
111          ,ATTRIBUTE4
112          ,ATTRIBUTE5
113          ,ATTRIBUTE6
114          ,ATTRIBUTE7
115          ,ATTRIBUTE8
116          ,ATTRIBUTE9
117          ,ATTRIBUTE10
118          ,ATTRIBUTE11
119          ,ATTRIBUTE12
120          ,ATTRIBUTE13
121          ,ATTRIBUTE14
122          ,ATTRIBUTE15
123          -- end yvchen: bug 13258460
124          ,CREATE_RO_FLAG -- bug#13698799 auto create ro, parent ro
125           ) VALUES (
126            px_WIP_TRANSACTION_DETAIL_ID
127           ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
128           ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
129           ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
130           ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
131           ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
132           ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
133           ,decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, p_WIP_ENTITY_ID)
134           ,decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_OPERATION_SEQ_NUM)
135           ,decode( p_RESOURCE_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_RESOURCE_SEQ_NUM)
136           ,decode( p_employee_id, FND_API.G_MISS_NUM, NULL, p_employee_id)
137           ,decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_QUANTITY)
138           ,decode( p_TRANSACTION_UOM, FND_API.G_MISS_CHAR, NULL, p_TRANSACTION_UOM)
139           ,decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER)
140           -- swai: bug 7182047 (FP of 6995498) added item revision
141           ,decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION)
142           -- end swai: bug 7182047 (FP of 6995498) added item revision
143           -- swai bug 6841113: added material txn reason code
144           ,decode( p_REASON_ID, FND_API.G_MISS_NUM, NULL, p_REASON_ID)
145           -- end swai bug 6841113: added material txn reason code
146           -- swai: added code for operations
147           ,decode( p_BACKFLUSH_FLAG, FND_API.G_MISS_NUM, NULL, p_BACKFLUSH_FLAG)
148           ,decode( p_COUNT_POINT_TYPE, FND_API.G_MISS_NUM, NULL, p_COUNT_POINT_TYPE)
149           ,decode( p_DEPARTMENT_ID, FND_API.G_MISS_NUM, NULL, p_DEPARTMENT_ID)
150           ,decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION)
151           ,decode( p_FIRST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, p_FIRST_UNIT_COMPLETION_DATE)
152           ,decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, p_FIRST_UNIT_START_DATE)
153           ,decode( p_LAST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UNIT_COMPLETION_DATE)
154           ,decode( p_LAST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UNIT_START_DATE)
155           ,decode( p_MINIMUM_TRANSFER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MINIMUM_TRANSFER_QUANTITY)
156           ,decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, p_STANDARD_OPERATION_ID)
157           -- end swai:  added code for operations
158           ,l_object_version_number
159           -- yvchen: bug 13258460
160           -- 12.1.3+ add DFF attributes to csd_wip_transaction_details
161           ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
162           ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
163           ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
164           ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
165           ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
166           ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
167           ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
168           ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
169           ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
170           ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
171           ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
172           ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
173           ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
174           ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
175           ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
176           ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
177           -- end yvchen: bug 13258460
178           ,decode( p_CREATE_RO_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREATE_RO_FLAG) -- bug#13698799 auto create ro, parent ro
179             );
180 End Insert_Row;
181 
182 PROCEDURE Update_Row(
183           p_WIP_TRANSACTION_DETAIL_ID IN NUMBER
184          ,p_CREATED_BY           IN NUMBER
185          ,p_CREATION_DATE        IN DATE
186          ,p_LAST_UPDATED_BY      IN NUMBER
187          ,p_LAST_UPDATE_DATE     IN DATE
188          ,p_LAST_UPDATE_LOGIN    IN NUMBER
189          ,p_INVENTORY_ITEM_ID    IN NUMBER
190          ,p_WIP_ENTITY_ID        IN NUMBER
191          ,p_OPERATION_SEQ_NUM    IN NUMBER
192          ,p_RESOURCE_SEQ_NUM     IN NUMBER
193          ,p_employee_id          IN NUMBER
194          ,p_TRANSACTION_QUANTITY IN NUMBER
195          ,p_TRANSACTION_UOM      IN VARCHAR2
196          ,p_SERIAL_NUMBER        IN VARCHAR2
197          ,p_REVISION             IN VARCHAR2 -- swai: bug 7182047 (FP of 6995498)
198          -- swai bug 6841113: added material txn reason code
199          ,p_REASON_ID            IN NUMBER
200          -- swai: added code for operations
201          ,p_BACKFLUSH_FLAG             IN NUMBER
202          ,p_COUNT_POINT_TYPE           IN NUMBER
203          ,p_DEPARTMENT_ID              IN NUMBER
204          ,p_DESCRIPTION                IN VARCHAR2
205          ,p_FIRST_UNIT_COMPLETION_DATE IN DATE
206          ,p_FIRST_UNIT_START_DATE      IN DATE
207          ,p_LAST_UNIT_COMPLETION_DATE  IN DATE
208          ,p_LAST_UNIT_START_DATE       IN DATE
209          ,p_MINIMUM_TRANSFER_QUANTITY  IN NUMBER
210          ,p_STANDARD_OPERATION_ID      IN NUMBER
211          ,p_OBJECT_VERSION_NUMBER IN NUMBER
212          -- yvchen: bug 13258460
213          -- 12.1.3+ add attributes to csd_wip_transaction_details
214          -- default these to null so they will remain unchanged unless
215          -- unless otherwise specified
216          ,p_ATTRIBUTE_CATEGORY        VARCHAR2 := null
217          ,p_ATTRIBUTE1                VARCHAR2 := null
218          ,p_ATTRIBUTE2                VARCHAR2 := null
219          ,p_ATTRIBUTE3                VARCHAR2 := null
220          ,p_ATTRIBUTE4                VARCHAR2 := null
221          ,p_ATTRIBUTE5                VARCHAR2 := null
222          ,p_ATTRIBUTE6                VARCHAR2 := null
223          ,p_ATTRIBUTE7                VARCHAR2 := null
224          ,p_ATTRIBUTE8                VARCHAR2 := null
225          ,p_ATTRIBUTE9                VARCHAR2 := null
226          ,p_ATTRIBUTE10               VARCHAR2 := null
227          ,p_ATTRIBUTE11               VARCHAR2 := null
228          ,p_ATTRIBUTE12               VARCHAR2 := null
229          ,p_ATTRIBUTE13               VARCHAR2 := null
230          ,p_ATTRIBUTE14               VARCHAR2 := null
231          ,p_ATTRIBUTE15               VARCHAR2 := null
232          ,p_CREATE_RO_FLAG            VARCHAR2 := FND_API.G_MISS_CHAR --bug#13698799 auto create ro, parent ro
233  )
234 
235 IS
236 BEGIN
237     Update CSD_WIP_TRANSACTION_DETAILS
238     SET
239        CREATED_BY             = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)
240        ,CREATION_DATE          = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
241        ,LAST_UPDATED_BY        = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
242        ,LAST_UPDATE_DATE       = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
243        ,LAST_UPDATE_LOGIN      = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
244        ,INVENTORY_ITEM_ID      = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
245        ,WIP_ENTITY_ID          = decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, NULL, WIP_ENTITY_ID, p_WIP_ENTITY_ID)
249        ,TRANSACTION_QUANTITY            = decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, TRANSACTION_QUANTITY, p_TRANSACTION_QUANTITY)
246        ,OPERATION_SEQ_NUM        = decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, NULL, OPERATION_SEQ_NUM, p_OPERATION_SEQ_NUM)
247        ,RESOURCE_SEQ_NUM         = decode( p_RESOURCE_SEQ_NUM, FND_API.G_MISS_NUM, NULL, NULL, RESOURCE_SEQ_NUM, p_RESOURCE_SEQ_NUM)
248        ,employee_id = decode( p_employee_id, FND_API.G_MISS_NUM, NULL, NULL, employee_id , p_employee_id)
250        ,TRANSACTION_UOM            = decode( p_TRANSACTION_UOM, FND_API.G_MISS_CHAR, NULL, NULL, TRANSACTION_UOM, p_TRANSACTION_UOM)
251        ,SERIAL_NUMBER             = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, SERIAL_NUMBER, p_SERIAL_NUMBER)
252        -- swai: bug 7182047 (FP of 6995498) added item revision
253        ,REVISION                  = decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, NULL, REVISION, p_REVISION)
254        -- end swai: bug 7182047 (FP of 6995498) added item revision
255        -- swai bug 6841113: added material txn reason code
256        ,REASON_ID      = decode( p_REASON_ID, FND_API.G_MISS_NUM, NULL, NULL, REASON_ID, p_REASON_ID)
257        -- end swai bug 6841113: added material txn reason code
258        -- swai: added code for operations
259        ,BACKFLUSH_FLAG             = decode( p_BACKFLUSH_FLAG, FND_API.G_MISS_NUM, NULL, NULL, BACKFLUSH_FLAG, p_BACKFLUSH_FLAG)
260        ,COUNT_POINT_TYPE           = decode( p_COUNT_POINT_TYPE, FND_API.G_MISS_NUM, NULL, NULL, COUNT_POINT_TYPE, p_COUNT_POINT_TYPE)
261        ,DEPARTMENT_ID              = decode( p_DEPARTMENT_ID, FND_API.G_MISS_NUM, NULL, NULL, DEPARTMENT_ID, p_DEPARTMENT_ID)
262        ,DESCRIPTION                = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, NULL, DESCRIPTION, p_DESCRIPTION)
263        ,FIRST_UNIT_COMPLETION_DATE = decode( p_FIRST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, NULL, FIRST_UNIT_COMPLETION_DATE, p_FIRST_UNIT_COMPLETION_DATE)
264        ,FIRST_UNIT_START_DATE      = decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, NULL, FIRST_UNIT_START_DATE, p_FIRST_UNIT_START_DATE)
265        ,LAST_UNIT_COMPLETION_DATE  = decode( p_LAST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UNIT_COMPLETION_DATE, p_LAST_UNIT_COMPLETION_DATE)
266        ,LAST_UNIT_START_DATE       = decode( p_LAST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UNIT_START_DATE, p_LAST_UNIT_START_DATE)
267        ,MINIMUM_TRANSFER_QUANTITY  = decode( p_MINIMUM_TRANSFER_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, MINIMUM_TRANSFER_QUANTITY, p_MINIMUM_TRANSFER_QUANTITY)
268        ,STANDARD_OPERATION_ID      = decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, NULL, STANDARD_OPERATION_ID, p_STANDARD_OPERATION_ID)
269        -- end swai:  added code for operations
270        ,OBJECT_VERSION_NUMBER                = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
271        -- yvchen: bug 13258460
272        -- 12.1.3+ add DFF attributes to csd_wip_transaction_details
273        ,ATTRIBUTE_CATEGORY         = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
274        ,ATTRIBUTE1                 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
275        ,ATTRIBUTE2                 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
276        ,ATTRIBUTE3                 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
277        ,ATTRIBUTE4                 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
278        ,ATTRIBUTE5                 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
279        ,ATTRIBUTE6                 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
280        ,ATTRIBUTE7                 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
281        ,ATTRIBUTE8                 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
282        ,ATTRIBUTE9                 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
283        ,ATTRIBUTE10                = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
284        ,ATTRIBUTE11                = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
285        ,ATTRIBUTE12                = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
286        ,ATTRIBUTE13                = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
287        ,ATTRIBUTE14                = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
288        ,ATTRIBUTE15                = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
289        -- end yvchen: bug 13258460
290        ,CREATE_RO_FLAG             = decode( p_CREATE_RO_FLAG, FND_API.G_MISS_CHAR, CREATE_RO_FLAG, p_CREATE_RO_FLAG) -- bug#13698799 auto create ro, parent ro
291 
292     where WIP_TRANSACTION_DETAIL_ID = p_WIP_TRANSACTION_DETAIL_ID;
293 
294     If (SQL%NOTFOUND) then
295         RAISE NO_DATA_FOUND;
296     End If;
297 END Update_Row;
298 
299 PROCEDURE Delete_Row(
300     p_WIP_TRANSACTION_DETAIL_ID  NUMBER)
301 IS
302 BEGIN
303     DELETE FROM CSD_WIP_TRANSACTION_DETAILS
304     WHERE WIP_TRANSACTION_DETAIL_ID = p_WIP_TRANSACTION_DETAIL_ID;
305     If (SQL%NOTFOUND) then
306         RAISE NO_DATA_FOUND;
307     End If;
308 END Delete_Row;
309 
310 
311 
312 End CSD_WIP_TRANSACTION_DTLS_PKG;