1 PACKAGE BODY OKE_NUMBER_OPTIONS_PKG AS
2 /* $Header: OKENMOPB.pls 115.5 2002/11/21 23:01:09 ybchen ship $ */
3 PROCEDURE INSERT_ROW
4 ( X_ROWID IN OUT NOCOPY VARCHAR2
5 , X_K_TYPE_CODE IN VARCHAR2
6 , X_BUY_OR_SELL IN VARCHAR2
7 , X_CREATION_DATE IN DATE
8 , X_CREATED_BY IN NUMBER
9 , X_LAST_UPDATE_DATE IN DATE
10 , X_LAST_UPDATED_BY IN NUMBER
11 , X_LAST_UPDATE_LOGIN IN NUMBER
12 , X_CONTRACT_NUM_MODE IN VARCHAR2
13 , X_MANUAL_CONTRACT_NUM_TYPE IN VARCHAR2
14 , X_NEXT_CONTRACT_NUM IN NUMBER
15 , X_CONTRACT_NUM_INCREMENT IN NUMBER
16 , X_CONTRACT_NUM_WIDTH IN NUMBER
17 , X_CHGREQ_NUM_MODE IN VARCHAR2
18 , X_MANUAL_CHGREQ_NUM_TYPE IN VARCHAR2
19 , X_CHGREQ_NUM_START_NUMBER IN NUMBER
20 , X_CHGREQ_NUM_INCREMENT IN NUMBER
21 , X_CHGREQ_NUM_WIDTH IN NUMBER
22 , X_LINE_NUM_START_NUMBER IN NUMBER
23 , X_LINE_NUM_INCREMENT IN NUMBER
24 , X_LINE_NUM_WIDTH IN NUMBER
25 , X_SUBLINE_NUM_START_NUMBER IN NUMBER
26 , X_SUBLINE_NUM_INCREMENT IN NUMBER
27 , X_SUBLINE_NUM_WIDTH IN NUMBER
28 , X_DELV_NUM_START_NUMBER IN NUMBER
29 , X_DELV_NUM_INCREMENT IN NUMBER
30 , X_DELV_NUM_WIDTH IN NUMBER
31 , X_ATTRIBUTE_CATEGORY IN VARCHAR2
32 , X_ATTRIBUTE1 IN VARCHAR2
33 , X_ATTRIBUTE2 IN VARCHAR2
34 , X_ATTRIBUTE3 IN VARCHAR2
35 , X_ATTRIBUTE4 IN VARCHAR2
36 , X_ATTRIBUTE5 IN VARCHAR2
37 , X_ATTRIBUTE6 IN VARCHAR2
38 , X_ATTRIBUTE7 IN VARCHAR2
39 , X_ATTRIBUTE8 IN VARCHAR2
40 , X_ATTRIBUTE9 IN VARCHAR2
41 , X_ATTRIBUTE10 IN VARCHAR2
42 , X_ATTRIBUTE11 IN VARCHAR2
43 , X_ATTRIBUTE12 IN VARCHAR2
44 , X_ATTRIBUTE13 IN VARCHAR2
45 , X_ATTRIBUTE14 IN VARCHAR2
46 , X_ATTRIBUTE15 IN VARCHAR2
47 ) IS
48
49 CURSOR c IS
50 SELECT ROWID
51 FROM OKE_NUMBER_OPTIONS
52 WHERE K_TYPE_CODE = X_K_TYPE_CODE
53 AND BUY_OR_SELL = X_BUY_OR_SELL;
54
55 BEGIN
56
57 INSERT INTO OKE_NUMBER_OPTIONS
58 ( K_TYPE_CODE
59 , BUY_OR_SELL
60 , CREATION_DATE
61 , CREATED_BY
62 , LAST_UPDATE_DATE
63 , LAST_UPDATED_BY
64 , LAST_UPDATE_LOGIN
65 , CONTRACT_NUM_MODE
66 , MANUAL_CONTRACT_NUM_TYPE
67 , NEXT_CONTRACT_NUM
68 , CONTRACT_NUM_INCREMENT
69 , CONTRACT_NUM_WIDTH
70 , CHGREQ_NUM_MODE
71 , MANUAL_CHGREQ_NUM_TYPE
72 , CHGREQ_NUM_START_NUMBER
73 , CHGREQ_NUM_INCREMENT
74 , CHGREQ_NUM_WIDTH
75 , LINE_NUM_START_NUMBER
76 , LINE_NUM_INCREMENT
77 , LINE_NUM_WIDTH
78 , SUBLINE_NUM_START_NUMBER
79 , SUBLINE_NUM_INCREMENT
80 , SUBLINE_NUM_WIDTH
81 , DELV_NUM_START_NUMBER
82 , DELV_NUM_INCREMENT
83 , DELV_NUM_WIDTH
84 , ATTRIBUTE_CATEGORY
85 , ATTRIBUTE1
86 , ATTRIBUTE2
87 , ATTRIBUTE3
88 , ATTRIBUTE4
89 , ATTRIBUTE5
90 , ATTRIBUTE6
91 , ATTRIBUTE7
92 , ATTRIBUTE8
93 , ATTRIBUTE9
94 , ATTRIBUTE10
95 , ATTRIBUTE11
96 , ATTRIBUTE12
97 , ATTRIBUTE13
98 , ATTRIBUTE14
99 , ATTRIBUTE15
100 )
101 SELECT
102 X_K_TYPE_CODE
103 , X_BUY_OR_SELL
104 , X_CREATION_DATE
105 , X_CREATED_BY
106 , X_LAST_UPDATE_DATE
107 , X_LAST_UPDATED_BY
108 , X_LAST_UPDATE_LOGIN
109 , X_CONTRACT_NUM_MODE
110 , X_MANUAL_CONTRACT_NUM_TYPE
111 , X_NEXT_CONTRACT_NUM
112 , X_CONTRACT_NUM_INCREMENT
113 , X_CONTRACT_NUM_WIDTH
114 , X_CHGREQ_NUM_MODE
115 , X_MANUAL_CHGREQ_NUM_TYPE
116 , X_CHGREQ_NUM_START_NUMBER
117 , X_CHGREQ_NUM_INCREMENT
118 , X_CHGREQ_NUM_WIDTH
119 , X_LINE_NUM_START_NUMBER
120 , X_LINE_NUM_INCREMENT
121 , X_LINE_NUM_WIDTH
122 , X_SUBLINE_NUM_START_NUMBER
123 , X_SUBLINE_NUM_INCREMENT
124 , X_SUBLINE_NUM_WIDTH
125 , X_DELV_NUM_START_NUMBER
126 , X_DELV_NUM_INCREMENT
127 , X_DELV_NUM_WIDTH
128 , X_ATTRIBUTE_CATEGORY
129 , X_ATTRIBUTE1
130 , X_ATTRIBUTE2
131 , X_ATTRIBUTE3
132 , X_ATTRIBUTE4
133 , X_ATTRIBUTE5
134 , X_ATTRIBUTE6
135 , X_ATTRIBUTE7
136 , X_ATTRIBUTE8
137 , X_ATTRIBUTE9
138 , X_ATTRIBUTE10
139 , X_ATTRIBUTE11
140 , X_ATTRIBUTE12
141 , X_ATTRIBUTE13
142 , X_ATTRIBUTE14
143 , X_ATTRIBUTE15
144 FROM DUAL
145 WHERE NOT EXISTS
146 (SELECT NULL
147 FROM OKE_NUMBER_OPTIONS
148 WHERE K_TYPE_CODE=X_K_TYPE_CODE
149 AND BUY_OR_SELL=X_BUY_OR_SELL);
150
151 OPEN c;
152 FETCH c INTO X_ROWID;
153 IF ( c%notfound ) THEN
154 CLOSE c;
155 RAISE no_data_found;
156 END IF;
157 CLOSE c;
158
159 END INSERT_ROW;
160
161
162 PROCEDURE LOCK_ROW
163 ( X_ROWID IN VARCHAR2
164 , X_K_TYPE_CODE IN VARCHAR2
165 , X_BUY_OR_SELL IN VARCHAR2
166 , X_CREATION_DATE IN DATE
167 , X_CREATED_BY IN NUMBER
168 , X_LAST_UPDATE_DATE IN DATE
169 , X_LAST_UPDATED_BY IN NUMBER
170 , X_LAST_UPDATE_LOGIN IN NUMBER
171 , X_CONTRACT_NUM_MODE IN VARCHAR2
172 , X_MANUAL_CONTRACT_NUM_TYPE IN VARCHAR2
173 , X_NEXT_CONTRACT_NUM IN NUMBER
174 , X_CONTRACT_NUM_INCREMENT IN NUMBER
175 , X_CONTRACT_NUM_WIDTH IN NUMBER
176 , X_CHGREQ_NUM_MODE IN VARCHAR2
177 , X_MANUAL_CHGREQ_NUM_TYPE IN VARCHAR2
178 , X_CHGREQ_NUM_START_NUMBER IN NUMBER
179 , X_CHGREQ_NUM_INCREMENT IN NUMBER
180 , X_CHGREQ_NUM_WIDTH IN NUMBER
181 , X_LINE_NUM_START_NUMBER IN NUMBER
182 , X_LINE_NUM_INCREMENT IN NUMBER
183 , X_LINE_NUM_WIDTH IN NUMBER
184 , X_SUBLINE_NUM_START_NUMBER IN NUMBER
185 , X_SUBLINE_NUM_INCREMENT IN NUMBER
186 , X_SUBLINE_NUM_WIDTH IN NUMBER
187 , X_DELV_NUM_START_NUMBER IN NUMBER
188 , X_DELV_NUM_INCREMENT IN NUMBER
189 , X_DELV_NUM_WIDTH IN NUMBER
190 , X_ATTRIBUTE_CATEGORY IN VARCHAR2
191 , X_ATTRIBUTE1 IN VARCHAR2
192 , X_ATTRIBUTE2 IN VARCHAR2
193 , X_ATTRIBUTE3 IN VARCHAR2
194 , X_ATTRIBUTE4 IN VARCHAR2
195 , X_ATTRIBUTE5 IN VARCHAR2
196 , X_ATTRIBUTE6 IN VARCHAR2
197 , X_ATTRIBUTE7 IN VARCHAR2
198 , X_ATTRIBUTE8 IN VARCHAR2
199 , X_ATTRIBUTE9 IN VARCHAR2
200 , X_ATTRIBUTE10 IN VARCHAR2
201 , X_ATTRIBUTE11 IN VARCHAR2
202 , X_ATTRIBUTE12 IN VARCHAR2
203 , X_ATTRIBUTE13 IN VARCHAR2
204 , X_ATTRIBUTE14 IN VARCHAR2
205 , X_ATTRIBUTE15 IN VARCHAR2
206 ) IS
207
208 CURSOR C IS
209 SELECT K_TYPE_CODE
210 , BUY_OR_SELL
211 , CONTRACT_NUM_MODE
212 , MANUAL_CONTRACT_NUM_TYPE
213 , NEXT_CONTRACT_NUM
214 , CONTRACT_NUM_INCREMENT
215 , CONTRACT_NUM_WIDTH
216 , CHGREQ_NUM_MODE
217 , MANUAL_CHGREQ_NUM_TYPE
218 , CHGREQ_NUM_START_NUMBER
219 , CHGREQ_NUM_INCREMENT
220 , CHGREQ_NUM_WIDTH
221 , LINE_NUM_START_NUMBER
222 , LINE_NUM_INCREMENT
223 , LINE_NUM_WIDTH
224 , SUBLINE_NUM_START_NUMBER
225 , SUBLINE_NUM_INCREMENT
226 , SUBLINE_NUM_WIDTH
227 , DELV_NUM_START_NUMBER
228 , DELV_NUM_INCREMENT
229 , DELV_NUM_WIDTH
230 , ATTRIBUTE_CATEGORY
231 , ATTRIBUTE1
232 , ATTRIBUTE2
233 , ATTRIBUTE3
234 , ATTRIBUTE4
235 , ATTRIBUTE5
236 , ATTRIBUTE6
237 , ATTRIBUTE7
238 , ATTRIBUTE8
239 , ATTRIBUTE9
240 , ATTRIBUTE10
241 , ATTRIBUTE11
242 , ATTRIBUTE12
243 , ATTRIBUTE13
244 , ATTRIBUTE14
245 , ATTRIBUTE15
249 CREC c%rowtype;
246 FROM OKE_NUMBER_OPTIONS
247 WHERE ROWID = X_ROWID
248 FOR UPDATE OF K_TYPE_CODE NOWAIT;
250
251 BEGIN
252
253 OPEN c;
254 FETCH c INTO crec;
255 IF ( c%notfound ) THEN
256 CLOSE c;
257 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
258 APP_EXCEPTION.RAISE_EXCEPTION;
259 END IF;
260 CLOSE c;
261
262 IF ( (CREC.K_TYPE_CODE = X_K_TYPE_CODE)
263 AND (CREC.BUY_OR_SELL = X_BUY_OR_SELL)
264 AND ((CREC.CONTRACT_NUM_MODE = X_CONTRACT_NUM_MODE)
265 OR ((CREC.CONTRACT_NUM_MODE IS NULL) AND (X_CONTRACT_NUM_MODE IS NULL)))
266 AND ((CREC.MANUAL_CONTRACT_NUM_TYPE = X_MANUAL_CONTRACT_NUM_TYPE)
267 OR ((CREC.MANUAL_CONTRACT_NUM_TYPE IS NULL) AND (X_MANUAL_CONTRACT_NUM_TYPE IS NULL)))
268 AND ((CREC.NEXT_CONTRACT_NUM = X_NEXT_CONTRACT_NUM)
269 OR ((CREC.NEXT_CONTRACT_NUM IS NULL) AND (X_NEXT_CONTRACT_NUM IS NULL)))
270 AND ((CREC.CONTRACT_NUM_INCREMENT = X_CONTRACT_NUM_INCREMENT)
271 OR ((CREC.CONTRACT_NUM_INCREMENT IS NULL) AND (X_CONTRACT_NUM_INCREMENT IS NULL)))
272 AND ((CREC.CONTRACT_NUM_WIDTH = X_CONTRACT_NUM_WIDTH)
273 OR ((CREC.CONTRACT_NUM_WIDTH IS NULL) AND (X_CONTRACT_NUM_WIDTH IS NULL)))
274 AND ((CREC.CHGREQ_NUM_MODE = X_CHGREQ_NUM_MODE)
275 OR ((CREC.CHGREQ_NUM_MODE IS NULL) AND (X_CHGREQ_NUM_MODE IS NULL)))
276 AND ((CREC.MANUAL_CHGREQ_NUM_TYPE = X_MANUAL_CHGREQ_NUM_TYPE)
277 OR ((CREC.MANUAL_CHGREQ_NUM_TYPE IS NULL) AND (X_MANUAL_CHGREQ_NUM_TYPE IS NULL)))
278 AND ((CREC.CHGREQ_NUM_START_NUMBER = X_CHGREQ_NUM_START_NUMBER)
279 OR ((CREC.CHGREQ_NUM_START_NUMBER IS NULL) AND (X_CHGREQ_NUM_START_NUMBER IS NULL)))
280 AND ((CREC.CHGREQ_NUM_INCREMENT = X_CHGREQ_NUM_INCREMENT)
281 OR ((CREC.CHGREQ_NUM_INCREMENT IS NULL) AND (X_CHGREQ_NUM_INCREMENT IS NULL)))
282 AND ((CREC.CHGREQ_NUM_WIDTH = X_CHGREQ_NUM_WIDTH)
283 OR ((CREC.CHGREQ_NUM_WIDTH IS NULL) AND (X_CHGREQ_NUM_WIDTH IS NULL)))
284 AND ((CREC.LINE_NUM_START_NUMBER = X_LINE_NUM_START_NUMBER)
285 OR ((CREC.LINE_NUM_START_NUMBER IS NULL) AND (X_LINE_NUM_START_NUMBER IS NULL)))
286 AND ((CREC.LINE_NUM_INCREMENT = X_LINE_NUM_INCREMENT)
287 OR ((CREC.LINE_NUM_INCREMENT IS NULL) AND (X_LINE_NUM_INCREMENT IS NULL)))
288 AND ((CREC.LINE_NUM_WIDTH = X_LINE_NUM_WIDTH)
289 OR ((CREC.LINE_NUM_WIDTH IS NULL) AND (X_LINE_NUM_WIDTH IS NULL)))
290 AND ((CREC.SUBLINE_NUM_START_NUMBER = X_SUBLINE_NUM_START_NUMBER)
291 OR ((CREC.SUBLINE_NUM_START_NUMBER IS NULL) AND (X_SUBLINE_NUM_START_NUMBER IS NULL)))
292 AND ((CREC.SUBLINE_NUM_INCREMENT = X_SUBLINE_NUM_INCREMENT)
293 OR ((CREC.SUBLINE_NUM_INCREMENT IS NULL) AND (X_SUBLINE_NUM_INCREMENT IS NULL)))
294 AND ((CREC.SUBLINE_NUM_WIDTH = X_SUBLINE_NUM_WIDTH)
295 OR ((CREC.SUBLINE_NUM_WIDTH IS NULL) AND (X_SUBLINE_NUM_WIDTH IS NULL)))
296 AND ((CREC.DELV_NUM_START_NUMBER = X_DELV_NUM_START_NUMBER)
297 OR ((CREC.DELV_NUM_START_NUMBER IS NULL) AND (X_DELV_NUM_START_NUMBER IS NULL)))
298 AND ((CREC.DELV_NUM_INCREMENT = X_DELV_NUM_INCREMENT)
299 OR ((CREC.DELV_NUM_INCREMENT IS NULL) AND (X_DELV_NUM_INCREMENT IS NULL)))
300 AND ((CREC.DELV_NUM_WIDTH = X_DELV_NUM_WIDTH)
301 OR ((CREC.DELV_NUM_WIDTH IS NULL) AND (X_DELV_NUM_WIDTH IS NULL)))
302 AND ((CREC.ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY)
303 OR ((CREC.ATTRIBUTE_CATEGORY IS NULL) AND (X_ATTRIBUTE_CATEGORY IS NULL)))
304 AND ((CREC.ATTRIBUTE1 = X_ATTRIBUTE1)
305 OR ((CREC.ATTRIBUTE1 IS NULL) AND (X_ATTRIBUTE1 IS NULL)))
309 OR ((CREC.ATTRIBUTE3 IS NULL) AND (X_ATTRIBUTE3 IS NULL)))
306 AND ((CREC.ATTRIBUTE2 = X_ATTRIBUTE2)
307 OR ((CREC.ATTRIBUTE2 IS NULL) AND (X_ATTRIBUTE2 IS NULL)))
308 AND ((CREC.ATTRIBUTE3 = X_ATTRIBUTE3)
310 AND ((CREC.ATTRIBUTE4 = X_ATTRIBUTE4)
311 OR ((CREC.ATTRIBUTE4 IS NULL) AND (X_ATTRIBUTE4 IS NULL)))
312 AND ((CREC.ATTRIBUTE5 = X_ATTRIBUTE5)
313 OR ((CREC.ATTRIBUTE5 IS NULL) AND (X_ATTRIBUTE5 IS NULL)))
314 AND ((CREC.ATTRIBUTE6 = X_ATTRIBUTE6)
315 OR ((CREC.ATTRIBUTE6 IS NULL) AND (X_ATTRIBUTE6 IS NULL)))
316 AND ((CREC.ATTRIBUTE7 = X_ATTRIBUTE7)
317 OR ((CREC.ATTRIBUTE7 IS NULL) AND (X_ATTRIBUTE7 IS NULL)))
318 AND ((CREC.ATTRIBUTE8 = X_ATTRIBUTE8)
319 OR ((CREC.ATTRIBUTE8 IS NULL) AND (X_ATTRIBUTE8 IS NULL)))
320 AND ((CREC.ATTRIBUTE9 = X_ATTRIBUTE9)
321 OR ((CREC.ATTRIBUTE9 IS NULL) AND (X_ATTRIBUTE9 IS NULL)))
322 AND ((CREC.ATTRIBUTE10 = X_ATTRIBUTE10)
323 OR ((CREC.ATTRIBUTE10 IS NULL) AND (X_ATTRIBUTE10 IS NULL)))
324 AND ((CREC.ATTRIBUTE11 = X_ATTRIBUTE11)
325 OR ((CREC.ATTRIBUTE11 IS NULL) AND (X_ATTRIBUTE11 IS NULL)))
326 AND ((CREC.ATTRIBUTE12 = X_ATTRIBUTE12)
327 OR ((CREC.ATTRIBUTE12 IS NULL) AND (X_ATTRIBUTE12 IS NULL)))
328 AND ((CREC.ATTRIBUTE13 = X_ATTRIBUTE13)
329 OR ((CREC.ATTRIBUTE13 IS NULL) AND (X_ATTRIBUTE13 IS NULL)))
330 AND ((CREC.ATTRIBUTE14 = X_ATTRIBUTE14)
331 OR ((CREC.ATTRIBUTE14 IS NULL) AND (X_ATTRIBUTE14 IS NULL)))
332 AND ((CREC.ATTRIBUTE15 = X_ATTRIBUTE15)
333 OR ((CREC.ATTRIBUTE15 IS NULL) AND (X_ATTRIBUTE15 IS NULL)))
334
335 ) THEN
336 NULL;
337 ELSE
338 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
339 APP_EXCEPTION.RAISE_EXCEPTION;
340 END IF;
341 RETURN;
342
343 END LOCK_ROW;
344
345
346 PROCEDURE UPDATE_ROW
347 ( X_K_TYPE_CODE IN VARCHAR2
348 , X_BUY_OR_SELL IN VARCHAR2
349 , X_LAST_UPDATE_DATE IN DATE
350 , X_LAST_UPDATED_BY IN NUMBER
351 , X_LAST_UPDATE_LOGIN IN NUMBER
352 , X_CONTRACT_NUM_MODE IN VARCHAR2
353 , X_MANUAL_CONTRACT_NUM_TYPE IN VARCHAR2
354 , X_NEXT_CONTRACT_NUM IN NUMBER
355 , X_CONTRACT_NUM_INCREMENT IN NUMBER
356 , X_CONTRACT_NUM_WIDTH IN NUMBER
357 , X_CHGREQ_NUM_MODE IN VARCHAR2
358 , X_MANUAL_CHGREQ_NUM_TYPE IN VARCHAR2
359 , X_CHGREQ_NUM_START_NUMBER IN NUMBER
360 , X_CHGREQ_NUM_INCREMENT IN NUMBER
361 , X_CHGREQ_NUM_WIDTH IN NUMBER
362 , X_LINE_NUM_START_NUMBER IN NUMBER
363 , X_LINE_NUM_INCREMENT IN NUMBER
364 , X_LINE_NUM_WIDTH IN NUMBER
365 , X_SUBLINE_NUM_START_NUMBER IN NUMBER
366 , X_SUBLINE_NUM_INCREMENT IN NUMBER
367 , X_SUBLINE_NUM_WIDTH IN NUMBER
368 , X_DELV_NUM_START_NUMBER IN NUMBER
369 , X_DELV_NUM_INCREMENT IN NUMBER
370 , X_DELV_NUM_WIDTH IN NUMBER
374 , X_ATTRIBUTE3 IN VARCHAR2
371 , X_ATTRIBUTE_CATEGORY IN VARCHAR2
372 , X_ATTRIBUTE1 IN VARCHAR2
373 , X_ATTRIBUTE2 IN VARCHAR2
375 , X_ATTRIBUTE4 IN VARCHAR2
376 , X_ATTRIBUTE5 IN VARCHAR2
377 , X_ATTRIBUTE6 IN VARCHAR2
378 , X_ATTRIBUTE7 IN VARCHAR2
379 , X_ATTRIBUTE8 IN VARCHAR2
380 , X_ATTRIBUTE9 IN VARCHAR2
381 , X_ATTRIBUTE10 IN VARCHAR2
382 , X_ATTRIBUTE11 IN VARCHAR2
383 , X_ATTRIBUTE12 IN VARCHAR2
384 , X_ATTRIBUTE13 IN VARCHAR2
385 , X_ATTRIBUTE14 IN VARCHAR2
386 , X_ATTRIBUTE15 IN VARCHAR2
387 ) IS
388
389 BEGIN
390
391 UPDATE OKE_NUMBER_OPTIONS
392 SET LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
393 , LAST_UPDATED_BY = X_LAST_UPDATED_BY
394 , LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
395 , CONTRACT_NUM_MODE = X_CONTRACT_NUM_MODE
396 , MANUAL_CONTRACT_NUM_TYPE = X_MANUAL_CONTRACT_NUM_TYPE
397 , NEXT_CONTRACT_NUM = X_NEXT_CONTRACT_NUM
398 , CONTRACT_NUM_INCREMENT = X_CONTRACT_NUM_INCREMENT
399 , CONTRACT_NUM_WIDTH = X_CONTRACT_NUM_WIDTH
400 , CHGREQ_NUM_MODE = X_CHGREQ_NUM_MODE
401 , MANUAL_CHGREQ_NUM_TYPE = X_MANUAL_CHGREQ_NUM_TYPE
402 , CHGREQ_NUM_START_NUMBER = X_CHGREQ_NUM_START_NUMBER
403 , CHGREQ_NUM_INCREMENT = X_CHGREQ_NUM_INCREMENT
404 , CHGREQ_NUM_WIDTH = X_CHGREQ_NUM_WIDTH
405 , LINE_NUM_START_NUMBER = X_LINE_NUM_START_NUMBER
406 , LINE_NUM_INCREMENT = X_LINE_NUM_INCREMENT
407 , LINE_NUM_WIDTH = X_LINE_NUM_WIDTH
408 , SUBLINE_NUM_START_NUMBER = X_SUBLINE_NUM_START_NUMBER
409 , SUBLINE_NUM_INCREMENT = X_SUBLINE_NUM_INCREMENT
410 , SUBLINE_NUM_WIDTH = X_SUBLINE_NUM_WIDTH
411 , DELV_NUM_START_NUMBER = X_DELV_NUM_START_NUMBER
412 , DELV_NUM_INCREMENT = X_DELV_NUM_INCREMENT
413 , DELV_NUM_WIDTH = X_DELV_NUM_WIDTH
414 , ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY
415 , ATTRIBUTE1 = X_ATTRIBUTE1
416 , ATTRIBUTE2 = X_ATTRIBUTE2
417 , ATTRIBUTE3 = X_ATTRIBUTE3
418 , ATTRIBUTE4 = X_ATTRIBUTE4
419 , ATTRIBUTE5 = X_ATTRIBUTE5
420 , ATTRIBUTE6 = X_ATTRIBUTE6
421 , ATTRIBUTE7 = X_ATTRIBUTE7
422 , ATTRIBUTE8 = X_ATTRIBUTE8
423 , ATTRIBUTE9 = X_ATTRIBUTE9
424 , ATTRIBUTE10 = X_ATTRIBUTE10
425 , ATTRIBUTE11 = X_ATTRIBUTE11
426 , ATTRIBUTE12 = X_ATTRIBUTE12
427 , ATTRIBUTE13 = X_ATTRIBUTE13
428 , ATTRIBUTE14 = X_ATTRIBUTE14
429 , ATTRIBUTE15 = X_ATTRIBUTE15
430 WHERE K_TYPE_CODE = X_K_TYPE_CODE
431 AND BUY_OR_SELL = X_BUY_OR_SELL;
432
433 IF ( sql%notfound ) THEN
434 RAISE NO_DATA_FOUND;
438
435 END IF;
436
437 END UPDATE_ROW;
439 END OKE_NUMBER_OPTIONS_PKG;
[Home] [Help]