[Home] [Help]
PACKAGE BODY: APPS.ASO_QUOTE_LINE_DETAILS_PKG
Source
1 PACKAGE BODY ASO_QUOTE_LINE_DETAILS_PKG as
2 /* $Header: asotldtb.pls 120.1 2005/06/29 12:39:09 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_QUOTE_LINE_DETAILS_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_QUOTE_LINE_DETAILS_PKG';
12 G_FILE_NAME CONSTANT VARCHAR2(12) := 'asotldtb.pls';
13
14 PROCEDURE Insert_Row(
15 px_QUOTE_LINE_DETAIL_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
16 p_CREATION_DATE DATE,
17 p_CREATED_BY NUMBER,
18 p_LAST_UPDATE_DATE DATE,
19 p_LAST_UPDATED_BY NUMBER,
20 p_LAST_UPDATE_LOGIN NUMBER,
21 p_REQUEST_ID NUMBER,
22 p_PROGRAM_APPLICATION_ID NUMBER,
23 p_PROGRAM_ID NUMBER,
24 p_PROGRAM_UPDATE_DATE DATE,
25 p_QUOTE_LINE_ID NUMBER,
26 p_CONFIG_HEADER_ID NUMBER,
27 p_CONFIG_REVISION_NUM NUMBER,
28 p_COMPLETE_CONFIGURATION_FLAG VARCHAR2,
29 p_VALID_CONFIGURATION_FLAG VARCHAR2,
30 p_COMPONENT_CODE VARCHAR2,
31 p_SERVICE_COTERMINATE_FLAG VARCHAR2,
32 p_SERVICE_DURATION NUMBER,
33 p_SERVICE_PERIOD VARCHAR2,
34 p_SERVICE_UNIT_SELLING_PERCENT NUMBER,
35 p_SERVICE_UNIT_LIST_PERCENT NUMBER,
36 p_SERVICE_NUMBER NUMBER,
37 p_UNIT_PERCENT_BASE_PRICE NUMBER,
38 p_ATTRIBUTE_CATEGORY VARCHAR2,
39 p_RETURN_REASON_CODE VARCHAR2,
40 p_ATTRIBUTE1 VARCHAR2,
41 p_ATTRIBUTE2 VARCHAR2,
42 p_ATTRIBUTE3 VARCHAR2,
43 p_ATTRIBUTE4 VARCHAR2,
44 p_ATTRIBUTE5 VARCHAR2,
45 p_ATTRIBUTE6 VARCHAR2,
46 p_ATTRIBUTE7 VARCHAR2,
47 p_ATTRIBUTE8 VARCHAR2,
48 p_ATTRIBUTE9 VARCHAR2,
49 p_ATTRIBUTE10 VARCHAR2,
50 p_ATTRIBUTE11 VARCHAR2,
51 p_ATTRIBUTE12 VARCHAR2,
52 p_ATTRIBUTE13 VARCHAR2,
53 p_ATTRIBUTE14 VARCHAR2,
54 p_ATTRIBUTE15 VARCHAR2,
55 p_ATTRIBUTE16 VARCHAR2,
56 p_ATTRIBUTE17 VARCHAR2,
57 p_ATTRIBUTE18 VARCHAR2,
58 p_ATTRIBUTE19 VARCHAR2,
59 p_ATTRIBUTE20 VARCHAR2,
60 p_SERVICE_REF_TYPE_CODE VARCHAR2,
61 p_SERVICE_REF_ORDER_NUMBER NUMBER,
62 p_SERVICE_REF_LINE_NUMBER NUMBER,
63 p_SERVICE_REF_LINE_ID NUMBER,
64 p_SERVICE_REF_SYSTEM_ID NUMBER,
65 p_SERVICE_REF_OPTION_NUMB NUMBER,
66 p_SERVICE_REF_SHIPMENT_NUMB NUMBER,
67 p_RETURN_REF_TYPE VARCHAR2,
68 p_RETURN_REF_HEADER_ID NUMBER,
69 p_RETURN_REF_LINE_ID NUMBER,
70 p_RETURN_ATTRIBUTE1 VARCHAR2,
71 p_RETURN_ATTRIBUTE2 VARCHAR2,
72 p_RETURN_ATTRIBUTE3 VARCHAR2,
73 p_RETURN_ATTRIBUTE4 VARCHAR2,
74 p_RETURN_ATTRIBUTE5 VARCHAR2,
75 p_RETURN_ATTRIBUTE6 VARCHAR2,
76 p_RETURN_ATTRIBUTE7 VARCHAR2,
77 p_RETURN_ATTRIBUTE8 VARCHAR2,
78 p_RETURN_ATTRIBUTE9 VARCHAR2,
79 p_RETURN_ATTRIBUTE10 VARCHAR2,
80 p_RETURN_ATTRIBUTE11 VARCHAR2,
81 p_RETURN_ATTRIBUTE15 VARCHAR2,
82 p_RETURN_ATTRIBUTE12 VARCHAR2,
83 p_RETURN_ATTRIBUTE13 VARCHAR2,
84 p_RETURN_ATTRIBUTE14 VARCHAR2,
85 p_CONFIG_ITEM_ID NUMBER,
86 p_REF_TYPE_CODE VARCHAR2,
87 p_REF_LINE_ID NUMBER,
88 p_INSTANCE_ID NUMBER,
89 p_BOM_SORT_ORDER VARCHAR2,
90 p_CONFIG_DELTA NUMBER,
91 p_CONFIG_INSTANCE_NAME VARCHAR2,
92 p_OBJECT_VERSION_NUMBER NUMBER,
93 p_TOP_MODEL_LINE_ID NUMBER,
94 p_ATO_LINE_ID NUMBER,
95 p_COMPONENT_SEQUENCE_ID NUMBER
96 )
97
98 IS
99 CURSOR C2 IS SELECT ASO_QUOTE_LINE_DETAILS_S.nextval FROM sys.dual;
100 BEGIN
101 If (px_QUOTE_LINE_DETAIL_ID IS NULL) OR (px_QUOTE_LINE_DETAIL_ID = FND_API.G_MISS_NUM) then
102 OPEN C2;
103 FETCH C2 INTO px_QUOTE_LINE_DETAIL_ID;
104 CLOSE C2;
105 End If;
106 INSERT INTO ASO_QUOTE_LINE_DETAILS(
107 QUOTE_LINE_DETAIL_ID,
108 CREATION_DATE,
109 CREATED_BY,
110 LAST_UPDATE_DATE,
111 LAST_UPDATED_BY,
112 LAST_UPDATE_LOGIN,
113 REQUEST_ID,
114 PROGRAM_APPLICATION_ID,
115 PROGRAM_ID,
116 PROGRAM_UPDATE_DATE,
117 QUOTE_LINE_ID,
118 CONFIG_HEADER_ID,
119 CONFIG_REVISION_NUM,
120 COMPLETE_CONFIGURATION_FLAG,
121 VALID_CONFIGURATION_FLAG,
122 COMPONENT_CODE,
123 SERVICE_COTERMINATE_FLAG,
124 SERVICE_DURATION,
125 SERVICE_PERIOD,
126 SERVICE_UNIT_SELLING_PERCENT,
127 SERVICE_UNIT_LIST_PERCENT,
128 SERVICE_NUMBER,
129 UNIT_PERCENT_BASE_PRICE,
130 ATTRIBUTE_CATEGORY,
131 RETURN_REASON_CODE ,
132 ATTRIBUTE1,
133 ATTRIBUTE2,
134 ATTRIBUTE3,
135 ATTRIBUTE4,
136 ATTRIBUTE5,
137 ATTRIBUTE6,
138 ATTRIBUTE7,
139 ATTRIBUTE8,
140 ATTRIBUTE9,
141 ATTRIBUTE10,
142 ATTRIBUTE11,
143 ATTRIBUTE12,
144 ATTRIBUTE13,
145 ATTRIBUTE14,
146 ATTRIBUTE15,
147 ATTRIBUTE16,
148 ATTRIBUTE17,
149 ATTRIBUTE18,
150 ATTRIBUTE19,
151 ATTRIBUTE20,
152 SERVICE_REF_TYPE_CODE,
153 SERVICE_REF_ORDER_NUMBER,
154 SERVICE_REF_LINE_NUMBER,
155 SERVICE_REF_LINE_ID,
156 SERVICE_REF_SYSTEM_ID,
157 SERVICE_REF_OPTION_NUMB,
158 SERVICE_REF_SHIPMENT_NUMB,
159 RETURN_REF_TYPE,
160 RETURN_REF_HEADER_ID,
161 RETURN_REF_LINE_ID,
162 RETURN_ATTRIBUTE1,
163 RETURN_ATTRIBUTE2,
164 RETURN_ATTRIBUTE3,
165 RETURN_ATTRIBUTE4,
166 RETURN_ATTRIBUTE5,
167 RETURN_ATTRIBUTE6,
168 RETURN_ATTRIBUTE7,
169 RETURN_ATTRIBUTE8,
170 RETURN_ATTRIBUTE9,
171 RETURN_ATTRIBUTE10,
172 RETURN_ATTRIBUTE11,
173 RETURN_ATTRIBUTE15,
174 RETURN_ATTRIBUTE12,
175 RETURN_ATTRIBUTE13,
176 RETURN_ATTRIBUTE14,
177 CONFIG_ITEM_ID,
178 REF_TYPE_CODE,
179 REF_LINE_ID,
180 INSTANCE_ID,
181 BOM_SORT_ORDER,
182 CONFIG_DELTA,
183 CONFIG_INSTANCE_NAME,
184 OBJECT_VERSION_NUMBER,
185 TOP_MODEL_LINE_ID,
186 ATO_LINE_ID ,
187 COMPONENT_SEQUENCE_ID
188
189 ) VALUES (
190 px_QUOTE_LINE_DETAIL_ID,
191 ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
192 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
193 ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
194 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
195 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
196 decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
197 decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
198 decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
199 ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
200 decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_QUOTE_LINE_ID),
201 decode( p_CONFIG_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_CONFIG_HEADER_ID),
202 decode( p_CONFIG_REVISION_NUM, FND_API.G_MISS_NUM, NULL, p_CONFIG_REVISION_NUM),
203 decode( p_COMPLETE_CONFIGURATION_FLAG, FND_API.G_MISS_CHAR, NULL, p_COMPLETE_CONFIGURATION_FLAG),
204 decode( p_VALID_CONFIGURATION_FLAG, FND_API.G_MISS_CHAR, NULL, p_VALID_CONFIGURATION_FLAG),
205 decode( p_COMPONENT_CODE, FND_API.G_MISS_CHAR, NULL, p_COMPONENT_CODE),
206 decode( p_SERVICE_COTERMINATE_FLAG, FND_API.G_MISS_CHAR, NULL, p_SERVICE_COTERMINATE_FLAG),
207 decode( p_SERVICE_DURATION, FND_API.G_MISS_NUM, NULL, p_SERVICE_DURATION),
208 decode( p_SERVICE_PERIOD, FND_API.G_MISS_CHAR, NULL, p_SERVICE_PERIOD),
209 decode( p_SERVICE_UNIT_SELLING_PERCENT, FND_API.G_MISS_NUM, NULL, p_SERVICE_UNIT_SELLING_PERCENT),
210 decode( p_SERVICE_UNIT_LIST_PERCENT, FND_API.G_MISS_NUM, NULL, p_SERVICE_UNIT_LIST_PERCENT),
211 decode( p_SERVICE_NUMBER, FND_API.G_MISS_NUM, NULL, p_SERVICE_NUMBER),
212 decode( p_UNIT_PERCENT_BASE_PRICE, FND_API.G_MISS_NUM, NULL, p_UNIT_PERCENT_BASE_PRICE),
213 decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
214 decode( p_RETURN_REASON_CODE , FND_API.G_MISS_CHAR, NULL,p_RETURN_REASON_CODE),
215 decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
216 decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
217 decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
218 decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
219 decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
220 decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
221 decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
222 decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
223 decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
224 decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
225 decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
226 decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
227 decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
228 decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
229 decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
230 decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
231 decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
232 decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
233 decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
234 decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20),
235 decode( p_SERVICE_REF_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_SERVICE_REF_TYPE_CODE),
236 decode( p_SERVICE_REF_ORDER_NUMBER, FND_API.G_MISS_NUM, NULL, p_SERVICE_REF_ORDER_NUMBER),
237 decode( p_SERVICE_REF_LINE_NUMBER, FND_API.G_MISS_NUM, NULL, p_SERVICE_REF_LINE_NUMBER),
238 decode( p_SERVICE_REF_LINE_ID, FND_API.G_MISS_NUM, NULL, p_SERVICE_REF_LINE_ID),
239 decode( p_SERVICE_REF_SYSTEM_ID, FND_API.G_MISS_NUM, NULL, p_SERVICE_REF_SYSTEM_ID),
240 decode( p_SERVICE_REF_OPTION_NUMB, FND_API.G_MISS_NUM, NULL, p_SERVICE_REF_OPTION_NUMB),
241 decode( p_SERVICE_REF_SHIPMENT_NUMB, FND_API.G_MISS_NUM, NULL, p_SERVICE_REF_SHIPMENT_NUMB),
242 decode( p_RETURN_REF_TYPE, FND_API.G_MISS_CHAR, NULL, p_RETURN_REF_TYPE),
243 decode( p_RETURN_REF_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_RETURN_REF_HEADER_ID),
244 decode( p_RETURN_REF_LINE_ID, FND_API.G_MISS_NUM, NULL, p_RETURN_REF_LINE_ID),
245 decode( p_RETURN_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE1),
246 decode( p_RETURN_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE2),
247 decode( p_RETURN_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE3),
248 decode( p_RETURN_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE4),
249 decode( p_RETURN_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE5),
250 decode( p_RETURN_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE6),
251 decode( p_RETURN_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE7),
252 decode( p_RETURN_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE8),
253 decode( p_RETURN_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE9),
254 decode( p_RETURN_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE10),
255 decode( p_RETURN_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE11),
256 decode( p_RETURN_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE15),
257 decode( p_RETURN_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE12),
258 decode( p_RETURN_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE13),
259 decode( p_RETURN_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_RETURN_ATTRIBUTE14),
260 decode( p_CONFIG_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_CONFIG_ITEM_ID),
261 decode( p_REF_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_REF_TYPE_CODE),
262 decode( p_REF_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REF_LINE_ID),
263 decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_ID),
264 decode( p_BOM_SORT_ORDER, FND_API.G_MISS_CHAR, NULL, p_BOM_SORT_ORDER),
265 decode( p_CONFIG_DELTA, FND_API.G_MISS_NUM, NULL, p_CONFIG_DELTA),
266 decode( p_CONFIG_INSTANCE_NAME, FND_API.G_MISS_CHAR, NULL, p_CONFIG_INSTANCE_NAME),
267 decode ( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,1,NULL,1, p_OBJECT_VERSION_NUMBER),
268 decode (p_TOP_MODEL_LINE_ID , FND_API.G_MISS_NUM,NULL,p_TOP_MODEL_LINE_ID),
269 decode ( p_ATO_LINE_ID, FND_API.G_MISS_NUM,NULL,p_ATO_LINE_ID),
270 decode ( p_COMPONENT_SEQUENCE_ID, FND_API.G_MISS_NUM,NULL,p_COMPONENT_SEQUENCE_ID)
271 );
272 End Insert_Row;
273
274 PROCEDURE Update_Row(
275 p_QUOTE_LINE_DETAIL_ID NUMBER,
276 p_CREATION_DATE DATE,
277 p_CREATED_BY NUMBER,
278 p_LAST_UPDATE_DATE DATE,
279 p_LAST_UPDATED_BY NUMBER,
280 p_LAST_UPDATE_LOGIN NUMBER,
281 p_REQUEST_ID NUMBER,
282 p_PROGRAM_APPLICATION_ID NUMBER,
283 p_PROGRAM_ID NUMBER,
284 p_PROGRAM_UPDATE_DATE DATE,
285 p_QUOTE_LINE_ID NUMBER,
286 p_CONFIG_HEADER_ID NUMBER,
287 p_CONFIG_REVISION_NUM NUMBER,
291 p_SERVICE_COTERMINATE_FLAG VARCHAR2,
288 p_COMPLETE_CONFIGURATION_FLAG VARCHAR2,
289 p_VALID_CONFIGURATION_FLAG VARCHAR2,
290 p_COMPONENT_CODE VARCHAR2,
292 p_SERVICE_DURATION NUMBER,
293 p_SERVICE_PERIOD VARCHAR2,
294 p_SERVICE_UNIT_SELLING_PERCENT NUMBER,
295 p_SERVICE_UNIT_LIST_PERCENT NUMBER,
296 p_SERVICE_NUMBER NUMBER,
297 p_UNIT_PERCENT_BASE_PRICE NUMBER,
298 p_ATTRIBUTE_CATEGORY VARCHAR2,
299 p_RETURN_REASON_CODE VARCHAR2,
300 p_ATTRIBUTE1 VARCHAR2,
301 p_ATTRIBUTE2 VARCHAR2,
302 p_ATTRIBUTE3 VARCHAR2,
303 p_ATTRIBUTE4 VARCHAR2,
304 p_ATTRIBUTE5 VARCHAR2,
305 p_ATTRIBUTE6 VARCHAR2,
306 p_ATTRIBUTE7 VARCHAR2,
307 p_ATTRIBUTE8 VARCHAR2,
308 p_ATTRIBUTE9 VARCHAR2,
309 p_ATTRIBUTE10 VARCHAR2,
310 p_ATTRIBUTE11 VARCHAR2,
311 p_ATTRIBUTE12 VARCHAR2,
312 p_ATTRIBUTE13 VARCHAR2,
313 p_ATTRIBUTE14 VARCHAR2,
314 p_ATTRIBUTE15 VARCHAR2,
315 p_ATTRIBUTE16 VARCHAR2,
316 p_ATTRIBUTE17 VARCHAR2,
317 p_ATTRIBUTE18 VARCHAR2,
318 p_ATTRIBUTE19 VARCHAR2,
319 p_ATTRIBUTE20 VARCHAR2,
320 p_SERVICE_REF_TYPE_CODE VARCHAR2,
321 p_SERVICE_REF_ORDER_NUMBER NUMBER,
322 p_SERVICE_REF_LINE_NUMBER NUMBER,
323 p_SERVICE_REF_LINE_ID NUMBER,
324 p_SERVICE_REF_SYSTEM_ID NUMBER,
325 p_SERVICE_REF_OPTION_NUMB NUMBER,
326 p_SERVICE_REF_SHIPMENT_NUMB NUMBER,
327 p_RETURN_REF_TYPE VARCHAR2,
328 p_RETURN_REF_HEADER_ID NUMBER,
329 p_RETURN_REF_LINE_ID NUMBER,
330 p_RETURN_ATTRIBUTE1 VARCHAR2,
331 p_RETURN_ATTRIBUTE2 VARCHAR2,
332 p_RETURN_ATTRIBUTE3 VARCHAR2,
333 p_RETURN_ATTRIBUTE4 VARCHAR2,
334 p_RETURN_ATTRIBUTE5 VARCHAR2,
335 p_RETURN_ATTRIBUTE6 VARCHAR2,
336 p_RETURN_ATTRIBUTE7 VARCHAR2,
337 p_RETURN_ATTRIBUTE8 VARCHAR2,
338 p_RETURN_ATTRIBUTE9 VARCHAR2,
339 p_RETURN_ATTRIBUTE10 VARCHAR2,
340 p_RETURN_ATTRIBUTE11 VARCHAR2,
341 p_RETURN_ATTRIBUTE15 VARCHAR2,
342 p_RETURN_ATTRIBUTE12 VARCHAR2,
343 p_RETURN_ATTRIBUTE13 VARCHAR2,
344 p_RETURN_ATTRIBUTE14 VARCHAR2,
345 p_CONFIG_ITEM_ID NUMBER,
346 p_REF_TYPE_CODE VARCHAR2,
347 p_REF_LINE_ID NUMBER,
348 p_INSTANCE_ID NUMBER,
349 p_BOM_SORT_ORDER VARCHAR2,
350 p_CONFIG_DELTA NUMBER,
351 p_CONFIG_INSTANCE_NAME VARCHAR2,
352 p_OBJECT_VERSION_NUMBER NUMBER,
353 p_TOP_MODEL_LINE_ID NUMBER,
354 p_ATO_LINE_ID NUMBER,
355 p_COMPONENT_SEQUENCE_ID NUMBER
356 )
357
358 IS
359 BEGIN
360 Update ASO_QUOTE_LINE_DETAILS
361 SET
362 /* CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
363 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),*/
364 LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
365 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
366 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
367 REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
368 PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
369 PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
370 PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
371 QUOTE_LINE_ID = decode( p_QUOTE_LINE_ID, FND_API.G_MISS_NUM, QUOTE_LINE_ID, p_QUOTE_LINE_ID),
372 CONFIG_HEADER_ID = decode( p_CONFIG_HEADER_ID, FND_API.G_MISS_NUM, CONFIG_HEADER_ID, p_CONFIG_HEADER_ID),
373 CONFIG_REVISION_NUM = decode( p_CONFIG_REVISION_NUM, FND_API.G_MISS_NUM, CONFIG_REVISION_NUM, p_CONFIG_REVISION_NUM),
374 COMPLETE_CONFIGURATION_FLAG = decode( p_COMPLETE_CONFIGURATION_FLAG, FND_API.G_MISS_CHAR, COMPLETE_CONFIGURATION_FLAG, p_COMPLETE_CONFIGURATION_FLAG),
375 VALID_CONFIGURATION_FLAG = decode( p_VALID_CONFIGURATION_FLAG, FND_API.G_MISS_CHAR, VALID_CONFIGURATION_FLAG, p_VALID_CONFIGURATION_FLAG),
376 COMPONENT_CODE = decode( p_COMPONENT_CODE, FND_API.G_MISS_CHAR, COMPONENT_CODE, p_COMPONENT_CODE),
377 SERVICE_COTERMINATE_FLAG = decode( p_SERVICE_COTERMINATE_FLAG, FND_API.G_MISS_CHAR, SERVICE_COTERMINATE_FLAG, p_SERVICE_COTERMINATE_FLAG),
378 SERVICE_DURATION = decode( p_SERVICE_DURATION, FND_API.G_MISS_NUM, SERVICE_DURATION, p_SERVICE_DURATION),
379 SERVICE_PERIOD = decode( p_SERVICE_PERIOD, FND_API.G_MISS_CHAR, SERVICE_PERIOD, p_SERVICE_PERIOD),
380 SERVICE_UNIT_SELLING_PERCENT = decode( p_SERVICE_UNIT_SELLING_PERCENT, FND_API.G_MISS_NUM, SERVICE_UNIT_SELLING_PERCENT, p_SERVICE_UNIT_SELLING_PERCENT),
381 SERVICE_UNIT_LIST_PERCENT = decode( p_SERVICE_UNIT_LIST_PERCENT, FND_API.G_MISS_NUM, SERVICE_UNIT_LIST_PERCENT, p_SERVICE_UNIT_LIST_PERCENT),
382 SERVICE_NUMBER = decode( p_SERVICE_NUMBER, FND_API.G_MISS_NUM, SERVICE_NUMBER, p_SERVICE_NUMBER),
383 UNIT_PERCENT_BASE_PRICE = decode( p_UNIT_PERCENT_BASE_PRICE, FND_API.G_MISS_NUM, UNIT_PERCENT_BASE_PRICE, p_UNIT_PERCENT_BASE_PRICE),
387 ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
384 ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
385 RETURN_REASON_CODE = decode( p_RETURN_REASON_CODE, FND_API.G_MISS_CHAR, RETURN_REASON_CODE, p_RETURN_REASON_CODE),
386 ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
388 ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
389 ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
390 ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
391 ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
392 ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
393 ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
394 ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
395 ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
396 ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
397 ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
398 ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
399 ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
400 ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
401 ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
402 ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
403 ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
404 ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
405 ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20),
406 SERVICE_REF_TYPE_CODE = decode( p_SERVICE_REF_TYPE_CODE, FND_API.G_MISS_CHAR, SERVICE_REF_TYPE_CODE, p_SERVICE_REF_TYPE_CODE),
407 SERVICE_REF_ORDER_NUMBER = decode( p_SERVICE_REF_ORDER_NUMBER, FND_API.G_MISS_NUM, SERVICE_REF_ORDER_NUMBER, p_SERVICE_REF_ORDER_NUMBER),
408 SERVICE_REF_LINE_NUMBER = decode( p_SERVICE_REF_LINE_NUMBER, FND_API.G_MISS_NUM, SERVICE_REF_LINE_NUMBER, p_SERVICE_REF_LINE_NUMBER),
409 SERVICE_REF_LINE_ID = decode( p_SERVICE_REF_LINE_ID, FND_API.G_MISS_NUM, SERVICE_REF_LINE_ID, p_SERVICE_REF_LINE_ID),
410 SERVICE_REF_SYSTEM_ID = decode( p_SERVICE_REF_SYSTEM_ID, FND_API.G_MISS_NUM, SERVICE_REF_SYSTEM_ID, p_SERVICE_REF_SYSTEM_ID),
411 SERVICE_REF_OPTION_NUMB = decode( p_SERVICE_REF_OPTION_NUMB, FND_API.G_MISS_NUM, SERVICE_REF_OPTION_NUMB, p_SERVICE_REF_OPTION_NUMB),
412 SERVICE_REF_SHIPMENT_NUMB = decode( p_SERVICE_REF_SHIPMENT_NUMB, FND_API.G_MISS_NUM, SERVICE_REF_SHIPMENT_NUMB, p_SERVICE_REF_SHIPMENT_NUMB),
413 RETURN_REF_TYPE = decode( p_RETURN_REF_TYPE, FND_API.G_MISS_CHAR, RETURN_REF_TYPE, p_RETURN_REF_TYPE),
414 RETURN_REF_HEADER_ID = decode( p_RETURN_REF_HEADER_ID, FND_API.G_MISS_NUM, RETURN_REF_HEADER_ID, p_RETURN_REF_HEADER_ID),
415 RETURN_REF_LINE_ID = decode( p_RETURN_REF_LINE_ID, FND_API.G_MISS_NUM, RETURN_REF_LINE_ID, p_RETURN_REF_LINE_ID),
416 RETURN_ATTRIBUTE1 = decode( p_RETURN_ATTRIBUTE1, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE1, p_RETURN_ATTRIBUTE1),
417 RETURN_ATTRIBUTE2 = decode( p_RETURN_ATTRIBUTE2, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE2, p_RETURN_ATTRIBUTE2),
418 RETURN_ATTRIBUTE3 = decode( p_RETURN_ATTRIBUTE3, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE3, p_RETURN_ATTRIBUTE3),
419 RETURN_ATTRIBUTE4 = decode( p_RETURN_ATTRIBUTE4, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE4, p_RETURN_ATTRIBUTE4),
420 RETURN_ATTRIBUTE5 = decode( p_RETURN_ATTRIBUTE5, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE5, p_RETURN_ATTRIBUTE5),
421 RETURN_ATTRIBUTE6 = decode( p_RETURN_ATTRIBUTE6, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE6, p_RETURN_ATTRIBUTE6),
422 RETURN_ATTRIBUTE7 = decode( p_RETURN_ATTRIBUTE7, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE7, p_RETURN_ATTRIBUTE7),
423 RETURN_ATTRIBUTE8 = decode( p_RETURN_ATTRIBUTE8, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE8, p_RETURN_ATTRIBUTE8),
424 RETURN_ATTRIBUTE9 = decode( p_RETURN_ATTRIBUTE9, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE9, p_RETURN_ATTRIBUTE9),
425 RETURN_ATTRIBUTE10 = decode( p_RETURN_ATTRIBUTE10, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE10, p_RETURN_ATTRIBUTE10),
426 RETURN_ATTRIBUTE11 = decode( p_RETURN_ATTRIBUTE11, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE11, p_RETURN_ATTRIBUTE11),
427 RETURN_ATTRIBUTE15 = decode( p_RETURN_ATTRIBUTE15, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE15, p_RETURN_ATTRIBUTE15),
428 RETURN_ATTRIBUTE12 = decode( p_RETURN_ATTRIBUTE12, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE12, p_RETURN_ATTRIBUTE12),
429 RETURN_ATTRIBUTE13 = decode( p_RETURN_ATTRIBUTE13, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE13, p_RETURN_ATTRIBUTE13),
430 RETURN_ATTRIBUTE14 = decode( p_RETURN_ATTRIBUTE14, FND_API.G_MISS_CHAR, RETURN_ATTRIBUTE14, p_RETURN_ATTRIBUTE14),
431 CONFIG_ITEM_ID = decode( p_CONFIG_ITEM_ID, FND_API.G_MISS_NUM, CONFIG_ITEM_ID, p_CONFIG_ITEM_ID),
432 REF_TYPE_CODE = decode( p_REF_TYPE_CODE, FND_API.G_MISS_CHAR, REF_TYPE_CODE, p_REF_TYPE_CODE),
433 REF_LINE_ID = decode( p_REF_LINE_ID, FND_API.G_MISS_NUM, REF_LINE_ID, p_REF_LINE_ID),
434 INSTANCE_ID = decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, p_INSTANCE_ID),
435 BOM_SORT_ORDER = decode( p_BOM_SORT_ORDER, FND_API.G_MISS_CHAR, BOM_SORT_ORDER, p_BOM_SORT_ORDER),
436 CONFIG_DELTA = decode(p_CONFIG_DELTA, FND_API.G_MISS_NUM, CONFIG_DELTA, p_CONFIG_DELTA),
437 CONFIG_INSTANCE_NAME = decode(p_CONFIG_INSTANCE_NAME, FND_API.G_MISS_CHAR, CONFIG_INSTANCE_NAME, p_CONFIG_INSTANCE_NAME),
441 TOP_MODEL_LINE_ID = decode( p_TOP_MODEL_LINE_ID, FND_API.G_MISS_NUM, TOP_MODEL_LINE_ID, p_TOP_MODEL_LINE_ID),
438 OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, nvl(OBJECT_VERSION_NUMBER,0)+1, nvl(p_OBJECT_VERSION_NUMBER, nvl(OBJECT_VERSION_NUMBER,0))+1),
439
440
442 COMPONENT_SEQUENCE_ID = decode( p_COMPONENT_SEQUENCE_ID, FND_API.G_MISS_NUM, COMPONENT_SEQUENCE_ID, p_COMPONENT_SEQUENCE_ID),
443 ATO_LINE_ID = decode( p_ATO_LINE_ID, FND_API.G_MISS_NUM, ATO_LINE_ID, p_ATO_LINE_ID)
444 where QUOTE_LINE_DETAIL_ID = p_QUOTE_LINE_DETAIL_ID;
445
446 If (SQL%NOTFOUND) then
447 RAISE NO_DATA_FOUND;
448 End If;
449 END Update_Row;
450
451 PROCEDURE Delete_Row(
452 p_QUOTE_LINE_DETAIL_ID NUMBER)
453 IS
454 BEGIN
455 DELETE FROM ASO_QUOTE_LINE_DETAILS
456 WHERE QUOTE_LINE_DETAIL_ID = p_QUOTE_LINE_DETAIL_ID;
457 If (SQL%NOTFOUND) then
458 RAISE NO_DATA_FOUND;
459 End If;
460 END Delete_Row;
461
462 PROCEDURE Delete_Row(
463 p_QUOTE_LINE_ID NUMBER)
464 IS
465 BEGIN
466 DELETE FROM ASO_QUOTE_LINE_DETAILS
467 WHERE QUOTE_LINE_ID = p_QUOTE_LINE_ID;
468 If (SQL%NOTFOUND) then
469 RAISE NO_DATA_FOUND;
470 End If;
471 END Delete_Row;
472
473 PROCEDURE Lock_Row(
474 --p_OBJECT_VERSION_NUMBER NUMBER,
475 p_QUOTE_LINE_DETAIL_ID NUMBER,
476 p_CREATION_DATE DATE,
477 p_CREATED_BY NUMBER,
478 p_LAST_UPDATE_DATE DATE,
479 p_LAST_UPDATED_BY NUMBER,
480 p_LAST_UPDATE_LOGIN NUMBER,
481 p_REQUEST_ID NUMBER,
482 p_PROGRAM_APPLICATION_ID NUMBER,
483 p_PROGRAM_ID NUMBER,
484 p_PROGRAM_UPDATE_DATE DATE,
485 p_QUOTE_LINE_ID NUMBER,
486 p_CONFIG_HEADER_ID NUMBER,
487 p_CONFIG_REVISION_NUM NUMBER,
488 p_COMPLETE_CONFIGURATION_FLAG VARCHAR2,
489 p_VALID_CONFIGURATION_FLAG VARCHAR2,
490 p_COMPONENT_CODE VARCHAR2,
491 p_SERVICE_COTERMINATE_FLAG VARCHAR2,
492 p_SERVICE_DURATION NUMBER,
493 p_SERVICE_PERIOD VARCHAR2,
494 p_SERVICE_UNIT_SELLING_PERCENT NUMBER,
495 p_SERVICE_UNIT_LIST_PERCENT NUMBER,
496 p_SERVICE_NUMBER NUMBER,
497 p_UNIT_PERCENT_BASE_PRICE NUMBER,
498 p_ATTRIBUTE_CATEGORY VARCHAR2,
499 p_RETURN_REASON_CODE VARCHAR2,
500 p_ATTRIBUTE1 VARCHAR2,
501 p_ATTRIBUTE2 VARCHAR2,
502 p_ATTRIBUTE3 VARCHAR2,
503 p_ATTRIBUTE4 VARCHAR2,
504 p_ATTRIBUTE5 VARCHAR2,
505 p_ATTRIBUTE6 VARCHAR2,
506 p_ATTRIBUTE7 VARCHAR2,
507 p_ATTRIBUTE8 VARCHAR2,
508 p_ATTRIBUTE9 VARCHAR2,
509 p_ATTRIBUTE10 VARCHAR2,
510 p_ATTRIBUTE11 VARCHAR2,
511 p_ATTRIBUTE12 VARCHAR2,
512 p_ATTRIBUTE13 VARCHAR2,
513 p_ATTRIBUTE14 VARCHAR2,
514 p_ATTRIBUTE15 VARCHAR2,
515 p_SERVICE_REF_TYPE_CODE VARCHAR2,
516 p_SERVICE_REF_ORDER_NUMBER NUMBER,
517 p_SERVICE_REF_LINE_NUMBER NUMBER,
518 p_SERVICE_REF_LINE_ID NUMBER,
519 p_SERVICE_REF_SYSTEM_ID NUMBER,
520 p_SERVICE_REF_OPTION_NUMB NUMBER,
521 p_SERVICE_REF_SHIPMENT_NUMB NUMBER,
522 p_RETURN_REF_TYPE VARCHAR2,
523 p_RETURN_REF_HEADER_ID NUMBER,
524 p_RETURN_REF_LINE_ID NUMBER,
525 p_RETURN_ATTRIBUTE1 VARCHAR2,
526 p_RETURN_ATTRIBUTE2 VARCHAR2,
527 p_RETURN_ATTRIBUTE3 VARCHAR2,
528 p_RETURN_ATTRIBUTE4 VARCHAR2,
529 p_RETURN_ATTRIBUTE5 VARCHAR2,
530 p_RETURN_ATTRIBUTE6 VARCHAR2,
531 p_RETURN_ATTRIBUTE7 VARCHAR2,
532 p_RETURN_ATTRIBUTE8 VARCHAR2,
533 p_RETURN_ATTRIBUTE9 VARCHAR2,
534 p_RETURN_ATTRIBUTE10 VARCHAR2,
535 p_RETURN_ATTRIBUTE11 VARCHAR2,
536 p_RETURN_ATTRIBUTE15 VARCHAR2,
537 p_RETURN_ATTRIBUTE12 VARCHAR2,
538 p_RETURN_ATTRIBUTE13 VARCHAR2,
539 p_RETURN_ATTRIBUTE14 VARCHAR2,
540 p_CONFIG_ITEM_ID NUMBER)
541 IS
542 CURSOR C IS
543 SELECT ATTRIBUTE4,
544 --OBJECT_VERSION_NUMBER,
545 ATTRIBUTE5,
546 ATTRIBUTE6,
547 ATTRIBUTE7,
548 ATTRIBUTE8,
549 ATTRIBUTE9,
550 ATTRIBUTE10,
551 ATTRIBUTE11,
552 ATTRIBUTE12,
553 ATTRIBUTE13,
554 ATTRIBUTE14,
555 ATTRIBUTE15,
556 SERVICE_REF_TYPE_CODE,
557 SERVICE_REF_ORDER_NUMBER,
558 SERVICE_REF_LINE_NUMBER,
559 SERVICE_REF_LINE_ID,
560 SERVICE_REF_SYSTEM_ID,
561 SERVICE_REF_OPTION_NUMB,
562 SERVICE_REF_SHIPMENT_NUMB,
563 RETURN_REF_TYPE,
564 RETURN_REF_HEADER_ID,
565 RETURN_REF_LINE_ID,
566 RETURN_ATTRIBUTE1,
567 RETURN_ATTRIBUTE2,
568 RETURN_ATTRIBUTE3,
569 RETURN_ATTRIBUTE4,
570 RETURN_ATTRIBUTE5,
571 RETURN_ATTRIBUTE6,
572 RETURN_ATTRIBUTE7,
573 RETURN_ATTRIBUTE8,
574 RETURN_ATTRIBUTE9,
575 RETURN_ATTRIBUTE10,
576 RETURN_ATTRIBUTE11,
577 RETURN_ATTRIBUTE12,
578 RETURN_ATTRIBUTE13,
579 RETURN_ATTRIBUTE14,
580 RETURN_ATTRIBUTE15,
581 QUOTE_LINE_DETAIL_ID,
582 CREATION_DATE,
583 CREATED_BY,
584 LAST_UPDATE_DATE,
585 LAST_UPDATED_BY,
586 LAST_UPDATE_LOGIN,
587 REQUEST_ID,
588 PROGRAM_APPLICATION_ID,
589 PROGRAM_ID,
590 PROGRAM_UPDATE_DATE,
591 QUOTE_LINE_ID,
592 CONFIG_HEADER_ID,
593 CONFIG_REVISION_NUM,
594 CONFIG_ITEM_ID,
598 SERVICE_COTERMINATE_FLAG,
595 COMPLETE_CONFIGURATION_FLAG,
596 VALID_CONFIGURATION_FLAG,
597 COMPONENT_CODE,
599 SERVICE_DURATION,
600 SERVICE_PERIOD,
601 SERVICE_UNIT_SELLING_PERCENT,
602 SERVICE_UNIT_LIST_PERCENT,
603 SERVICE_NUMBER,
604 UNIT_PERCENT_BASE_PRICE,
605 ATTRIBUTE_CATEGORY,
606 RETURN_REASON_CODE,
607 ATTRIBUTE1,
608 ATTRIBUTE2,
609 ATTRIBUTE3
610 FROM ASO_QUOTE_LINE_DETAILS
611 WHERE QUOTE_LINE_DETAIL_ID = p_QUOTE_LINE_DETAIL_ID
612 FOR UPDATE of QUOTE_LINE_DETAIL_ID NOWAIT;
613 Recinfo C%ROWTYPE;
614 BEGIN
615 OPEN C;
616 FETCH C INTO Recinfo;
617 If (C%NOTFOUND) then
618 CLOSE C;
619 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
620 APP_EXCEPTION.RAISE_EXCEPTION;
621 End If;
622 CLOSE C;
623 if (
624 /*
625 ( Recinfo.QUOTE_LINE_DETAIL_ID = p_QUOTE_LINE_DETAIL_ID)
626 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
627 OR ( ( Recinfo.CREATION_DATE IS NULL )
628 AND ( p_CREATION_DATE IS NULL )))
629 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
630 OR ( ( Recinfo.CREATED_BY IS NULL )
631 AND ( p_CREATED_BY IS NULL )))
632 AND
633 */
634 ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
635 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
636 AND ( p_LAST_UPDATE_DATE IS NULL )))
637 /*
638 AND
639 ( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
640 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
641 AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
642 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
643 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
644 AND ( p_LAST_UPDATED_BY IS NULL )))
645 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
646 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
647 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
648 AND ( ( Recinfo.REQUEST_ID = p_REQUEST_ID)
649 OR ( ( Recinfo.REQUEST_ID IS NULL )
650 AND ( p_REQUEST_ID IS NULL )))
651 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
652 OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
653 AND ( p_PROGRAM_APPLICATION_ID IS NULL )))
654 AND ( ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
655 OR ( ( Recinfo.PROGRAM_ID IS NULL )
656 AND ( p_PROGRAM_ID IS NULL )))
657 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
658 OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
659 AND ( p_PROGRAM_UPDATE_DATE IS NULL )))
660 AND ( ( Recinfo.QUOTE_LINE_ID = p_QUOTE_LINE_ID)
661 OR ( ( Recinfo.QUOTE_LINE_ID IS NULL )
662 AND ( p_QUOTE_LINE_ID IS NULL )))
663 AND ( ( Recinfo.CONFIG_HEADER_ID = p_CONFIG_HEADER_ID)
664 OR ( ( Recinfo.CONFIG_HEADER_ID IS NULL )
665 AND ( p_CONFIG_HEADER_ID IS NULL )))
666 AND ( ( Recinfo.CONFIG_REVISION_NUM = p_CONFIG_REVISION_NUM)
667 OR ( ( Recinfo.CONFIG_REVISION_NUM IS NULL )
668 AND ( p_CONFIG_REVISION_NUM IS NULL )))
669 AND ( ( Recinfo.COMPLETE_CONFIGURATION_FLAG = p_COMPLETE_CONFIGURATION_FLAG)
670 OR ( ( Recinfo.COMPLETE_CONFIGURATION_FLAG IS NULL )
671 AND ( p_COMPLETE_CONFIGURATION_FLAG IS NULL )))
672 AND ( ( Recinfo.VALID_CONFIGURATION_FLAG = p_VALID_CONFIGURATION_FLAG)
673 OR ( ( Recinfo.VALID_CONFIGURATION_FLAG IS NULL )
674 AND ( p_VALID_CONFIGURATION_FLAG IS NULL )))
675 AND ( ( Recinfo.COMPONENT_CODE = p_COMPONENT_CODE)
676 OR ( ( Recinfo.COMPONENT_CODE IS NULL )
677 AND ( p_COMPONENT_CODE IS NULL )))
678 AND ( ( Recinfo.SERVICE_COTERMINATE_FLAG = p_SERVICE_COTERMINATE_FLAG)
679 OR ( ( Recinfo.SERVICE_COTERMINATE_FLAG IS NULL )
680 AND ( p_SERVICE_COTERMINATE_FLAG IS NULL )))
681 AND ( ( Recinfo.SERVICE_DURATION = p_SERVICE_DURATION)
682 OR ( ( Recinfo.SERVICE_DURATION IS NULL )
683 AND ( p_SERVICE_DURATION IS NULL )))
684 AND ( ( Recinfo.SERVICE_PERIOD = p_SERVICE_PERIOD)
685 OR ( ( Recinfo.SERVICE_PERIOD IS NULL )
686 AND ( p_SERVICE_PERIOD IS NULL )))
687 AND ( ( Recinfo.SERVICE_UNIT_SELLING_PERCENT = p_SERVICE_UNIT_SELLING_PERCENT)
688 OR ( ( Recinfo.SERVICE_UNIT_SELLING_PERCENT IS NULL )
689 AND ( p_SERVICE_UNIT_SELLING_PERCENT IS NULL )))
690 AND ( ( Recinfo.SERVICE_UNIT_LIST_PERCENT = p_SERVICE_UNIT_LIST_PERCENT)
691 OR ( ( Recinfo.SERVICE_UNIT_LIST_PERCENT IS NULL )
692 AND ( p_SERVICE_UNIT_LIST_PERCENT IS NULL )))
693 AND ( ( Recinfo.SERVICE_NUMBER = p_SERVICE_NUMBER)
694 OR ( ( Recinfo.SERVICE_NUMBER IS NULL )
695 AND ( p_SERVICE_NUMBER IS NULL )))
696 AND ( ( Recinfo.UNIT_PERCENT_BASE_PRICE = p_UNIT_PERCENT_BASE_PRICE)
697 OR ( ( Recinfo.UNIT_PERCENT_BASE_PRICE IS NULL )
698 AND ( p_UNIT_PERCENT_BASE_PRICE IS NULL )))
699 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
700 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
701 AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
702 AND ( ( Recinfo.RETURN_REASON_CODE = p_RETURN_REASON_CODE)
703 OR ( ( Recinfo.RETURN_REASON_CODE IS NULL )
704 AND ( p_RETURN_REASON_CODE IS NULL )))
705 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
706 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
707 AND ( p_ATTRIBUTE1 IS NULL )))
708 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
712 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
709 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
710 AND ( p_ATTRIBUTE2 IS NULL )))
711 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
713 AND ( p_ATTRIBUTE3 IS NULL )))
714 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
715 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
716 AND ( p_ATTRIBUTE4 IS NULL )))
717 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
718 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
719 AND ( p_ATTRIBUTE5 IS NULL )))
720 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
721 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
722 AND ( p_ATTRIBUTE6 IS NULL )))
723 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
724 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
725 AND ( p_ATTRIBUTE7 IS NULL )))
726 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
727 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
728 AND ( p_ATTRIBUTE8 IS NULL )))
729 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
730 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
731 AND ( p_ATTRIBUTE9 IS NULL )))
732 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
733 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
734 AND ( p_ATTRIBUTE10 IS NULL )))
735 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
736 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
737 AND ( p_ATTRIBUTE11 IS NULL )))
738 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
739 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
740 AND ( p_ATTRIBUTE12 IS NULL )))
741 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
742 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
743 AND ( p_ATTRIBUTE13 IS NULL )))
744 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
745 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
746 AND ( p_ATTRIBUTE14 IS NULL )))
747 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
748 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
749 AND ( p_ATTRIBUTE15 IS NULL )))
750 AND ( ( Recinfo.SERVICE_REF_TYPE_CODE = p_SERVICE_REF_TYPE_CODE)
751 OR ( ( Recinfo.SERVICE_REF_TYPE_CODE IS NULL )
752 AND ( p_SERVICE_REF_TYPE_CODE IS NULL )))
753 AND ( ( Recinfo.SERVICE_REF_ORDER_NUMBER = p_SERVICE_REF_ORDER_NUMBER)
754 OR ( ( Recinfo.SERVICE_REF_ORDER_NUMBER IS NULL )
755 AND ( p_SERVICE_REF_ORDER_NUMBER IS NULL )))
756 AND ( ( Recinfo.SERVICE_REF_LINE_NUMBER = p_SERVICE_REF_LINE_NUMBER)
757 OR ( ( Recinfo.SERVICE_REF_LINE_NUMBER IS NULL )
758 AND ( p_SERVICE_REF_LINE_NUMBER IS NULL )))
759 AND ( ( Recinfo.SERVICE_REF_LINE_ID = p_SERVICE_REF_LINE_ID)
760 OR ( ( Recinfo.SERVICE_REF_LINE_ID IS NULL )
761 AND ( p_SERVICE_REF_LINE_ID IS NULL )))
762 AND ( ( Recinfo.SERVICE_REF_SYSTEM_ID = p_SERVICE_REF_SYSTEM_ID)
763 OR ( ( Recinfo.SERVICE_REF_SYSTEM_ID IS NULL )
764 AND ( p_SERVICE_REF_SYSTEM_ID IS NULL )))
765 AND ( ( Recinfo.SERVICE_REF_OPTION_NUMB = p_SERVICE_REF_OPTION_NUMB)
766 OR ( ( Recinfo.SERVICE_REF_OPTION_NUMB IS NULL )
767 AND ( p_SERVICE_REF_OPTION_NUMB IS NULL )))
768 AND ( ( Recinfo.SERVICE_REF_SHIPMENT_NUMB = p_SERVICE_REF_SHIPMENT_NUMB)
769 OR ( ( Recinfo.SERVICE_REF_SHIPMENT_NUMB IS NULL )
770 AND ( p_SERVICE_REF_SHIPMENT_NUMB IS NULL )))
771 AND ( ( Recinfo.RETURN_REF_TYPE = p_RETURN_REF_TYPE)
772 OR ( ( Recinfo.RETURN_REF_TYPE IS NULL )
773 AND ( p_RETURN_REF_TYPE IS NULL )))
774 AND ( ( Recinfo.RETURN_REF_HEADER_ID = p_RETURN_REF_HEADER_ID)
775 OR ( ( Recinfo.RETURN_REF_HEADER_ID IS NULL )
776 AND ( p_RETURN_REF_HEADER_ID IS NULL )))
777 AND ( ( Recinfo.RETURN_REF_LINE_ID = p_RETURN_REF_LINE_ID)
778 OR ( ( Recinfo.RETURN_REF_LINE_ID IS NULL )
779 AND ( p_RETURN_REF_LINE_ID IS NULL )))
780 AND ( ( Recinfo.RETURN_ATTRIBUTE1 = p_RETURN_ATTRIBUTE1)
781 OR ( ( Recinfo.RETURN_ATTRIBUTE1 IS NULL )
782 AND ( p_RETURN_ATTRIBUTE1 IS NULL )))
783 AND ( ( Recinfo.RETURN_ATTRIBUTE2 = p_RETURN_ATTRIBUTE2)
784 OR ( ( Recinfo.RETURN_ATTRIBUTE2 IS NULL )
785 AND ( p_RETURN_ATTRIBUTE2 IS NULL )))
786 AND ( ( Recinfo.RETURN_ATTRIBUTE3 = p_RETURN_ATTRIBUTE3)
787 OR ( ( Recinfo.RETURN_ATTRIBUTE3 IS NULL )
788 AND ( p_RETURN_ATTRIBUTE3 IS NULL )))
789 AND ( ( Recinfo.RETURN_ATTRIBUTE4 = p_RETURN_ATTRIBUTE4)
790 OR ( ( Recinfo.RETURN_ATTRIBUTE4 IS NULL )
791 AND ( p_RETURN_ATTRIBUTE4 IS NULL )))
792 AND ( ( Recinfo.RETURN_ATTRIBUTE5 = p_RETURN_ATTRIBUTE5)
793 OR ( ( Recinfo.RETURN_ATTRIBUTE5 IS NULL )
794 AND ( p_RETURN_ATTRIBUTE5 IS NULL )))
795 AND ( ( Recinfo.RETURN_ATTRIBUTE6 = p_RETURN_ATTRIBUTE6)
796 OR ( ( Recinfo.RETURN_ATTRIBUTE6 IS NULL )
797 AND ( p_RETURN_ATTRIBUTE6 IS NULL )))
798 AND ( ( Recinfo.RETURN_ATTRIBUTE7 = p_RETURN_ATTRIBUTE7)
799 OR ( ( Recinfo.RETURN_ATTRIBUTE7 IS NULL )
800 AND ( p_RETURN_ATTRIBUTE7 IS NULL )))
801 AND ( ( Recinfo.RETURN_ATTRIBUTE8 = p_RETURN_ATTRIBUTE8)
802 OR ( ( Recinfo.RETURN_ATTRIBUTE8 IS NULL )
803 AND ( p_RETURN_ATTRIBUTE8 IS NULL )))
804 AND ( ( Recinfo.RETURN_ATTRIBUTE9 = p_RETURN_ATTRIBUTE9)
805 OR ( ( Recinfo.RETURN_ATTRIBUTE9 IS NULL )
806 AND ( p_RETURN_ATTRIBUTE9 IS NULL )))
807 AND ( ( Recinfo.RETURN_ATTRIBUTE10 = p_RETURN_ATTRIBUTE10)
811 OR ( ( Recinfo.RETURN_ATTRIBUTE11 IS NULL )
808 OR ( ( Recinfo.RETURN_ATTRIBUTE10 IS NULL )
809 AND ( p_RETURN_ATTRIBUTE10 IS NULL )))
810 AND ( ( Recinfo.RETURN_ATTRIBUTE11 = p_RETURN_ATTRIBUTE11)
812 AND ( p_RETURN_ATTRIBUTE11 IS NULL )))
813 AND ( ( Recinfo.RETURN_ATTRIBUTE15 = p_RETURN_ATTRIBUTE15)
814 OR ( ( Recinfo.RETURN_ATTRIBUTE15 IS NULL )
815 AND ( p_RETURN_ATTRIBUTE15 IS NULL )))
816 AND ( ( Recinfo.RETURN_ATTRIBUTE12 = p_RETURN_ATTRIBUTE12)
817 OR ( ( Recinfo.RETURN_ATTRIBUTE12 IS NULL )
818 AND ( p_RETURN_ATTRIBUTE12 IS NULL )))
819 AND ( ( Recinfo.RETURN_ATTRIBUTE13 = p_RETURN_ATTRIBUTE13)
820 OR ( ( Recinfo.RETURN_ATTRIBUTE13 IS NULL )
821 AND ( p_RETURN_ATTRIBUTE13 IS NULL )))
822 AND ( ( Recinfo.RETURN_ATTRIBUTE14 = p_RETURN_ATTRIBUTE14)
823 OR ( ( Recinfo.RETURN_ATTRIBUTE14 IS NULL )
824 AND ( p_RETURN_ATTRIBUTE14 IS NULL )))
825
826 AND ( ( Recinfo.CONFIG_ITEM_ID = p_CONFIG_ITEM_ID)
827 OR ( ( Recinfo.CONFIG_ITEM_ID IS NULL )
828 AND ( p_CONFIG_ITEM_ID IS NULL )))
829 */
830 ) then
831 return;
832 else
833 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
834 APP_EXCEPTION.RAISE_EXCEPTION;
835 End If;
836 END Lock_Row;
837
838 End ASO_QUOTE_LINE_DETAILS_PKG;