[Home] [Help]
PACKAGE BODY: APPS.ASO_QUOTE_STATUS_PKG
Source
1 PACKAGE BODY ASO_QUOTE_STATUS_PKG as
2 /* $Header: asotstab.pls 120.3 2006/05/22 23:00:57 skulkarn ship $ */
3 -- Start of Comments
4 -- Package name : ASO_QUOTE_STATUS_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 G_PKG_NAME CONSTANT VARCHAR2(30):= 'ASO_QUOTE_STATUSE_PKG';
12 G_FILE_NAME CONSTANT VARCHAR2(12) := 'asotstab.pls';
13
14 PROCEDURE Insert_Row(
15 px_QUOTE_STATUS_ID IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
16 p_CREATION_DATE DATE,
17 p_CREATED_BY NUMBER,
18 p_LAST_UPDATED_BY NUMBER,
19 p_LAST_UPDATE_DATE DATE,
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_STATUS_CODE VARCHAR2,
26 p_UPDATE_ALLOWED_FLAG VARCHAR2,
27 p_AUTO_VERSION_FLAG VARCHAR2,
28 p_USER_MAINTAINABLE_FLAG VARCHAR2,
29 p_EFFECTIVE_START_DATE DATE,
30 p_EFFECTIVE_END_DATE DATE,
31 p_ALLOW_LOV_TO_FLAG VARCHAR2,
32 p_ALLOW_LOV_FROM_FLAG VARCHAR2,
33 p_ALLOW_NEW_TO_FLAG VARCHAR2,
34 p_ALLOW_NEW_FROM_FLAG VARCHAR2,
35 p_SEED_TAG VARCHAR2,
36 p_ENABLED_FLAG VARCHAR2,
37 p_ATTRIBUTE_CATEGORY VARCHAR2,
38 p_ATTRIBUTE1 VARCHAR2,
39 p_ATTRIBUTE2 VARCHAR2,
40 p_ATTRIBUTE3 VARCHAR2,
41 p_ATTRIBUTE4 VARCHAR2,
42 p_ATTRIBUTE5 VARCHAR2,
43 p_ATTRIBUTE6 VARCHAR2,
44 p_ATTRIBUTE7 VARCHAR2,
45 p_ATTRIBUTE8 VARCHAR2,
46 p_ATTRIBUTE9 VARCHAR2,
47 p_ATTRIBUTE10 VARCHAR2,
48 p_ATTRIBUTE11 VARCHAR2,
49 p_ATTRIBUTE12 VARCHAR2,
50 p_ATTRIBUTE13 VARCHAR2,
51 p_ATTRIBUTE14 VARCHAR2,
52 p_ATTRIBUTE15 VARCHAR2,
53 p_ATTRIBUTE16 VARCHAR2,
54 p_ATTRIBUTE17 VARCHAR2,
55 p_ATTRIBUTE18 VARCHAR2,
56 p_ATTRIBUTE19 VARCHAR2,
57 p_ATTRIBUTE20 VARCHAR2,
58 p_MEANING VARCHAR2,
59 p_DESCRIPTION VARCHAR2)
60
61 IS
62 CURSOR C IS SELECT ASO_QUOTE_STATUSES_B_S.nextval FROM sys.dual;
63 BEGIN
64 If (px_QUOTE_STATUS_ID IS NULL) OR (px_QUOTE_STATUS_ID = FND_API.G_MISS_NUM) then
65 OPEN C;
66 FETCH C INTO px_QUOTE_STATUS_ID;
67 CLOSE C;
68 End If;
69 INSERT INTO ASO_QUOTE_STATUSES_B(
70 QUOTE_STATUS_ID,
71 CREATION_DATE,
72 CREATED_BY,
73 LAST_UPDATED_BY,
74 LAST_UPDATE_DATE,
75 LAST_UPDATE_LOGIN,
76 REQUEST_ID,
77 PROGRAM_APPLICATION_ID,
78 PROGRAM_ID,
79 PROGRAM_UPDATE_DATE,
80 STATUS_CODE,
81 UPDATE_ALLOWED_FLAG,
82 AUTO_VERSION_FLAG,
83 USER_MAINTAINABLE_FLAG,
84 EFFECTIVE_START_DATE,
85 EFFECTIVE_END_DATE,
86 ALLOW_LOV_TO_FLAG,
87 ALLOW_LOV_FROM_FLAG,
88 ALLOW_NEW_TO_FLAG,
89 ALLOW_NEW_FROM_FLAG,
90 SEED_TAG,
91 ENABLED_FLAG,
92 ATTRIBUTE_CATEGORY,
93 ATTRIBUTE1,
94 ATTRIBUTE2,
95 ATTRIBUTE3,
96 ATTRIBUTE4,
97 ATTRIBUTE5,
98 ATTRIBUTE6,
99 ATTRIBUTE7,
100 ATTRIBUTE8,
101 ATTRIBUTE9,
102 ATTRIBUTE10,
103 ATTRIBUTE11,
104 ATTRIBUTE12,
105 ATTRIBUTE13,
106 ATTRIBUTE14,
107 ATTRIBUTE15,
108 ATTRIBUTE16,
109 ATTRIBUTE17,
110 ATTRIBUTE18,
111 ATTRIBUTE19,
112 ATTRIBUTE20
113 ) VALUES (
114 px_QUOTE_STATUS_ID,
115 ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
116 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
117 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
118 ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
119 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
120 decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
121 decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
122 decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
123 ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
124 decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
125 decode( p_UPDATE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, NULL, p_UPDATE_ALLOWED_FLAG),
126 decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, NULL, p_AUTO_VERSION_FLAG),
127 decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, NULL, p_USER_MAINTAINABLE_FLAG),
128 ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_START_DATE)),
129 ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, NULL, trunc(p_EFFECTIVE_END_DATE)),
130 decode( p_ALLOW_LOV_TO_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_LOV_TO_FLAG),
131 decode( p_ALLOW_LOV_FROM_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_LOV_FROM_FLAG),
132 decode( p_ALLOW_NEW_TO_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_NEW_TO_FLAG),
133 decode( p_ALLOW_NEW_FROM_FLAG, FND_API.G_MISS_CHAR, NULL, p_ALLOW_NEW_FROM_FLAG),
134 decode( p_SEED_TAG, FND_API.G_MISS_CHAR, NULL, p_SEED_TAG),
135 decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_ENABLED_FLAG),
136 decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
137 decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
138 decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
139 decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
140 decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
141 decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
142 decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
143 decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
144 decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
145 decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
146 decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
147 decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
148 decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
149 decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
150 decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
151 decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
152 decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16),
153 decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17),
154 decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18),
155 decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19),
156 decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
157 );
158
159 insert into ASO_QUOTE_STATUSES_TL (
160 QUOTE_STATUS_ID,
161 CREATION_DATE,
162 CREATED_BY,
163 LAST_UPDATED_BY,
164 LAST_UPDATE_DATE,
165 LAST_UPDATE_LOGIN,
166 REQUEST_ID,
167 PROGRAM_APPLICATION_ID,
168 PROGRAM_ID,
169 PROGRAM_UPDATE_DATE,
170 MEANING,
171 DESCRIPTION,
172 LANGUAGE,
173 SOURCE_LANG
174 ) select
175 px_QUOTE_STATUS_ID,
176 ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
177 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
178 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
179 ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
180 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
181 decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
182 decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
183 decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
184 ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_PROGRAM_UPDATE_DATE),
185 decode( p_meaning, FND_API.G_MISS_CHAR, NULL, p_meaning),
186 decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),
187 L.LANGUAGE_CODE,
188 userenv('LANG')
189 from FND_LANGUAGES L
190 where L.INSTALLED_FLAG in ('I', 'B')
191 and not exists
192 (select NULL from ASO_QUOTE_STATUSES_TL T
193 where T.QUOTE_STATUS_ID = px_QUOTE_STATUS_ID
194 and T.LANGUAGE = L.LANGUAGE_CODE);
195 End Insert_Row;
196
197 PROCEDURE Update_Row(
198 p_QUOTE_STATUS_ID NUMBER,
199 p_CREATION_DATE DATE,
200 p_CREATED_BY NUMBER,
201 p_LAST_UPDATED_BY NUMBER,
202 p_LAST_UPDATE_DATE DATE,
203 p_LAST_UPDATE_LOGIN NUMBER,
204 p_REQUEST_ID NUMBER,
205 p_PROGRAM_APPLICATION_ID NUMBER,
206 p_PROGRAM_ID NUMBER,
207 p_PROGRAM_UPDATE_DATE DATE,
208 p_STATUS_CODE VARCHAR2,
209 p_UPDATE_ALLOWED_FLAG VARCHAR2,
210 p_AUTO_VERSION_FLAG VARCHAR2,
211 p_USER_MAINTAINABLE_FLAG VARCHAR2,
212 p_EFFECTIVE_START_DATE DATE,
213 p_EFFECTIVE_END_DATE DATE,
214 p_ALLOW_LOV_TO_FLAG VARCHAR2,
215 p_ALLOW_LOV_FROM_FLAG VARCHAR2,
216 p_ALLOW_NEW_TO_FLAG VARCHAR2,
217 p_ALLOW_NEW_FROM_FLAG VARCHAR2,
218 p_SEED_TAG VARCHAR2,
219 p_ENABLED_FLAG VARCHAR2,
220 p_ATTRIBUTE_CATEGORY VARCHAR2,
221 p_ATTRIBUTE1 VARCHAR2,
222 p_ATTRIBUTE2 VARCHAR2,
223 p_ATTRIBUTE3 VARCHAR2,
224 p_ATTRIBUTE4 VARCHAR2,
225 p_ATTRIBUTE5 VARCHAR2,
226 p_ATTRIBUTE6 VARCHAR2,
227 p_ATTRIBUTE7 VARCHAR2,
228 p_ATTRIBUTE8 VARCHAR2,
229 p_ATTRIBUTE9 VARCHAR2,
230 p_ATTRIBUTE10 VARCHAR2,
231 p_ATTRIBUTE11 VARCHAR2,
232 p_ATTRIBUTE12 VARCHAR2,
233 p_ATTRIBUTE13 VARCHAR2,
234 p_ATTRIBUTE14 VARCHAR2,
235 p_ATTRIBUTE15 VARCHAR2,
236 p_ATTRIBUTE16 VARCHAR2,
237 p_ATTRIBUTE17 VARCHAR2,
238 p_ATTRIBUTE18 VARCHAR2,
239 p_ATTRIBUTE19 VARCHAR2,
240 p_ATTRIBUTE20 VARCHAR2,
241 p_MEANING VARCHAR2,
242 p_DESCRIPTION VARCHAR2)
243 IS
244 BEGIN
245 Update ASO_QUOTE_STATUSES_B
246 SET
247 CREATION_DATE = ASO_UTILITY_PVT.decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
248 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
249 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
250 LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
251 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
252 REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
253 PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
254 PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
255 PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
256 STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
257 UPDATE_ALLOWED_FLAG = decode( p_UPDATE_ALLOWED_FLAG, FND_API.G_MISS_CHAR, UPDATE_ALLOWED_FLAG, p_UPDATE_ALLOWED_FLAG),
258 AUTO_VERSION_FLAG = decode( p_AUTO_VERSION_FLAG, FND_API.G_MISS_CHAR, AUTO_VERSION_FLAG, p_AUTO_VERSION_FLAG),
259 USER_MAINTAINABLE_FLAG = decode( p_USER_MAINTAINABLE_FLAG, FND_API.G_MISS_CHAR, USER_MAINTAINABLE_FLAG, p_USER_MAINTAINABLE_FLAG),
260 EFFECTIVE_START_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_START_DATE), FND_API.G_MISS_DATE, EFFECTIVE_START_DATE, trunc(p_EFFECTIVE_START_DATE)),
261
262 EFFECTIVE_END_DATE = ASO_UTILITY_PVT.decode( trunc(p_EFFECTIVE_END_DATE), FND_API.G_MISS_DATE, EFFECTIVE_END_DATE,trunc(p_EFFECTIVE_END_DATE)),
263 ALLOW_LOV_TO_FLAG = decode( p_ALLOW_LOV_TO_FLAG, FND_API.G_MISS_CHAR, ALLOW_LOV_TO_FLAG, p_ALLOW_LOV_TO_FLAG),
264 ALLOW_LOV_FROM_FLAG = decode( p_ALLOW_LOV_FROM_FLAG, FND_API.G_MISS_CHAR, ALLOW_LOV_FROM_FLAG, p_ALLOW_LOV_FROM_FLAG),
265 ALLOW_NEW_TO_FLAG = decode( p_ALLOW_NEW_TO_FLAG, FND_API.G_MISS_CHAR, ALLOW_NEW_TO_FLAG, p_ALLOW_NEW_TO_FLAG),
266 ALLOW_NEW_FROM_FLAG = decode( p_ALLOW_NEW_FROM_FLAG, FND_API.G_MISS_CHAR, ALLOW_NEW_FROM_FLAG, p_ALLOW_NEW_FROM_FLAG),
267 SEED_TAG = decode( p_SEED_TAG, FND_API.G_MISS_CHAR, SEED_TAG, p_SEED_TAG),
268 ENABLED_FLAG = decode( p_ENABLED_FLAG, FND_API.G_MISS_CHAR, ENABLED_FLAG, p_ENABLED_FLAG),
269 ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
270 ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
271 ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
272 ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
273 ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
274 ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
275 ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
276 ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
277 ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
278 ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
279 ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
280 ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
281 ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
282 ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
283 ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
284 ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
285 ATTRIBUTE16 = decode( p_ATTRIBUTE16, FND_API.G_MISS_CHAR, ATTRIBUTE16, p_ATTRIBUTE16),
286 ATTRIBUTE17 = decode( p_ATTRIBUTE17, FND_API.G_MISS_CHAR, ATTRIBUTE17, p_ATTRIBUTE17),
287 ATTRIBUTE18 = decode( p_ATTRIBUTE18, FND_API.G_MISS_CHAR, ATTRIBUTE18, p_ATTRIBUTE18),
288 ATTRIBUTE19 = decode( p_ATTRIBUTE19, FND_API.G_MISS_CHAR, ATTRIBUTE19, p_ATTRIBUTE19),
289 ATTRIBUTE20 = decode( p_ATTRIBUTE20, FND_API.G_MISS_CHAR, ATTRIBUTE20, p_ATTRIBUTE20)
290 where QUOTE_STATUS_ID = p_QUOTE_STATUS_ID;
291
292 If (SQL%NOTFOUND) then
293 RAISE NO_DATA_FOUND;
294 End If;
295
296 update ASO_QUOTE_STATUSES_TL set
297 MEANING = decode( p_MEANING, FND_API.G_MISS_CHAR, meaning, p_MEANING),
298 DESCRIPTION = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, meaning, p_DESCRIPTION),
299 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
303 PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
300 LAST_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
301 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
302 REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
304 PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
305 PROGRAM_UPDATE_DATE = ASO_UTILITY_PVT.decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
306 SOURCE_LANG = userenv('LANG')
307 where QUOTE_STATUS_ID = P_QUOTE_STATUS_ID
308 and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
309
310 if (sql%notfound) then
311 raise no_data_found;
312 end if;
313 END Update_Row;
314
315 PROCEDURE Delete_Row(
316 p_QUOTE_STATUS_ID NUMBER)
317 IS
318 BEGIN
319 DELETE FROM ASO_QUOTE_STATUSES_B
320 WHERE QUOTE_STATUS_ID = p_QUOTE_STATUS_ID;
321 If (SQL%NOTFOUND) then
322 RAISE NO_DATA_FOUND;
323 End If;
324
325 delete from ASO_QUOTE_STATUSES_TL
326 where QUOTE_STATUS_ID = p_QUOTE_STATUS_ID;
327 if (sql%notfound) then
328 raise no_data_found;
329 end if;
330 END Delete_Row;
331
332 PROCEDURE Lock_Row(
333 p_QUOTE_STATUS_ID NUMBER,
334 p_CREATION_DATE DATE,
335 p_CREATED_BY NUMBER,
336 p_LAST_UPDATED_BY NUMBER,
337 p_LAST_UPDATE_DATE DATE,
338 p_LAST_UPDATE_LOGIN NUMBER,
339 p_REQUEST_ID NUMBER,
340 p_PROGRAM_APPLICATION_ID NUMBER,
341 p_PROGRAM_ID NUMBER,
342 p_PROGRAM_UPDATE_DATE DATE,
343 p_STATUS_CODE VARCHAR2,
344 p_UPDATE_ALLOWED_FLAG VARCHAR2,
345 p_AUTO_VERSION_FLAG VARCHAR2,
346 p_USER_MAINTAINABLE_FLAG VARCHAR2,
347 p_EFFECTIVE_START_DATE DATE,
348 p_EFFECTIVE_END_DATE DATE,
349 p_ALLOW_LOV_TO_FLAG VARCHAR2,
350 p_ALLOW_LOV_FROM_FLAG VARCHAR2,
351 p_ALLOW_NEW_TO_FLAG VARCHAR2,
352 p_ALLOW_NEW_FROM_FLAG VARCHAR2,
353 p_SEED_TAG VARCHAR2,
354 p_ENABLED_FLAG VARCHAR2,
355 p_ATTRIBUTE_CATEGORY VARCHAR2,
356 p_ATTRIBUTE1 VARCHAR2,
357 p_ATTRIBUTE2 VARCHAR2,
358 p_ATTRIBUTE3 VARCHAR2,
359 p_ATTRIBUTE4 VARCHAR2,
360 p_ATTRIBUTE5 VARCHAR2,
361 p_ATTRIBUTE6 VARCHAR2,
362 p_ATTRIBUTE7 VARCHAR2,
363 p_ATTRIBUTE8 VARCHAR2,
364 p_ATTRIBUTE9 VARCHAR2,
365 p_ATTRIBUTE10 VARCHAR2,
366 p_ATTRIBUTE11 VARCHAR2,
367 p_ATTRIBUTE12 VARCHAR2,
368 p_ATTRIBUTE13 VARCHAR2,
369 p_ATTRIBUTE14 VARCHAR2,
370 p_ATTRIBUTE15 VARCHAR2,
371 p_MEANING VARCHAR2,
372 p_DESCRIPTION VARCHAR2)
373
374 IS
375 CURSOR C IS
376 SELECT *
377 FROM ASO_QUOTE_STATUSES_B
378 WHERE QUOTE_STATUS_ID = p_QUOTE_STATUS_ID
379 FOR UPDATE of QUOTE_STATUS_ID NOWAIT;
380 Recinfo C%ROWTYPE;
381
382 CURSOR C_TL IS
383 SELECT MEANING, DESCRIPTION,
384 decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
385 FROM ASO_QUOTE_STATUSES_TL
386 WHERE QUOTE_STATUS_ID = p_QUOTE_STATUS_ID
387 AND userenv('LANG') in (LANGUAGE, SOURCE_LANG)
388 FOR UPDATE of QUOTE_STATUS_ID NOWAIT;
389
390 BEGIN
391 OPEN C;
392 FETCH C INTO Recinfo;
393 If (C%NOTFOUND) then
394 CLOSE C;
395 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
396 APP_EXCEPTION.RAISE_EXCEPTION;
397 End If;
398 CLOSE C;
399 if (
400 /*
401 ( Recinfo.QUOTE_STATUS_ID = p_QUOTE_STATUS_ID)
402 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
403 OR ( ( Recinfo.CREATION_DATE IS NULL )
404 AND ( p_CREATION_DATE IS NULL )))
405 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
406 OR ( ( Recinfo.CREATED_BY IS NULL )
407 AND ( p_CREATED_BY IS NULL )))
408 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
409 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
410 AND ( p_LAST_UPDATED_BY IS NULL )))
411 AND
412 */
413 ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
414 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
415 AND ( p_LAST_UPDATE_DATE IS NULL )))
416 /*
417 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
418 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
419 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
420 AND ( ( Recinfo.REQUEST_ID = p_REQUEST_ID)
421 OR ( ( Recinfo.REQUEST_ID IS NULL )
422 AND ( p_REQUEST_ID IS NULL )))
423 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
424 OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
425 AND ( p_PROGRAM_APPLICATION_ID IS NULL )))
426 AND ( ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
427 OR ( ( Recinfo.PROGRAM_ID IS NULL )
428 AND ( p_PROGRAM_ID IS NULL )))
429 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
433 OR ( ( Recinfo.STATUS_CODE IS NULL )
430 OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
431 AND ( p_PROGRAM_UPDATE_DATE IS NULL )))
432 AND ( ( Recinfo.STATUS_CODE = p_STATUS_CODE)
434 AND ( p_STATUS_CODE IS NULL )))
435 AND ( ( Recinfo.UPDATE_ALLOWED_FLAG = p_UPDATE_ALLOWED_FLAG)
436 OR ( ( Recinfo.UPDATE_ALLOWED_FLAG IS NULL )
437 AND ( p_UPDATE_ALLOWED_FLAG IS NULL )))
438 AND ( ( Recinfo.AUTO_VERSION_FLAG = p_AUTO_VERSION_FLAG)
439 OR ( ( Recinfo.AUTO_VERSION_FLAG IS NULL )
440 AND ( p_AUTO_VERSION_FLAG IS NULL )))
441 AND ( ( Recinfo.USER_MAINTAINABLE_FLAG = p_USER_MAINTAINABLE_FLAG)
442 OR ( ( Recinfo.USER_MAINTAINABLE_FLAG IS NULL )
443 AND ( p_USER_MAINTAINABLE_FLAG IS NULL )))
444 AND ( ( Recinfo.EFFECTIVE_START_DATE = p_EFFECTIVE_START_DATE)
445 OR ( ( Recinfo.EFFECTIVE_START_DATE IS NULL )
446 AND ( p_EFFECTIVE_START_DATE IS NULL )))
447 AND ( ( Recinfo.EFFECTIVE_END_DATE = p_EFFECTIVE_END_DATE)
448 OR ( ( Recinfo.EFFECTIVE_END_DATE IS NULL )
449 AND ( p_EFFECTIVE_END_DATE IS NULL )))
450 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
451 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
452 AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
453 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
454 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
455 AND ( p_ATTRIBUTE1 IS NULL )))
456 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
457 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
458 AND ( p_ATTRIBUTE2 IS NULL )))
459 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
460 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
461 AND ( p_ATTRIBUTE3 IS NULL )))
462 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
463 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
464 AND ( p_ATTRIBUTE4 IS NULL )))
465 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
466 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
467 AND ( p_ATTRIBUTE5 IS NULL )))
468 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
469 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
470 AND ( p_ATTRIBUTE6 IS NULL )))
471 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
472 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
473 AND ( p_ATTRIBUTE7 IS NULL )))
474 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
475 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
476 AND ( p_ATTRIBUTE8 IS NULL )))
477 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
478 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
479 AND ( p_ATTRIBUTE9 IS NULL )))
480 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
481 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
482 AND ( p_ATTRIBUTE10 IS NULL )))
483 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
484 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
485 AND ( p_ATTRIBUTE11 IS NULL )))
486 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
487 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
488 AND ( p_ATTRIBUTE12 IS NULL )))
489 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
490 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
491 AND ( p_ATTRIBUTE13 IS NULL )))
492 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
493 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
494 AND ( p_ATTRIBUTE14 IS NULL )))
495 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
496 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
497 AND ( p_ATTRIBUTE15 IS NULL )))
498 */
499 ) then
500 null;
501 else
502 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
503 APP_EXCEPTION.RAISE_EXCEPTION;
504 End If;
505 for tlinfo in c_tl loop
506 if (tlinfo.BASELANG = 'Y') then
507 if ( ((tlinfo.MEANING = p_MEANING)
508 OR ((tlinfo.MEANING is null) AND (p_MEANING is null)))
509 AND ((tlinfo.DESCRIPTION = p_DESCRIPTION)
510 OR ((tlinfo.DESCRIPTION is null) AND (p_DESCRIPTION is null)))
511 ) then
512 null;
513 else
514 fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
515 app_exception.raise_exception;
516 end if;
517 end if;
518 end loop;
519 return;
520 END Lock_Row;
521
522 procedure ADD_LANGUAGE
523 is
524 begin
525 delete from ASO_QUOTE_STATUSES_TL T
526 where not exists
527 (select NULL
528 from ASO_QUOTE_STATUSES_B B
529 where B.QUOTE_STATUS_ID = T.QUOTE_STATUS_ID
530 );
531
532 update ASO_QUOTE_STATUSES_TL T set (
533 MEANING,
534 DESCRIPTION
535 ) = (select
536 B.MEANING,
537 B.DESCRIPTION
538 from ASO_QUOTE_STATUSES_TL B
539 where B.QUOTE_STATUS_ID = T.QUOTE_STATUS_ID
540 and B.LANGUAGE = T.SOURCE_LANG)
541 where (
542 T.QUOTE_STATUS_ID,
543 T.LANGUAGE
544 ) in (select
545 SUBT.QUOTE_STATUS_ID,
546 SUBT.LANGUAGE
547 from ASO_QUOTE_STATUSES_TL SUBB, ASO_QUOTE_STATUSES_TL SUBT
551 or (SUBB.MEANING is null and SUBT.MEANING is not null)
548 where SUBB.QUOTE_STATUS_ID = SUBT.QUOTE_STATUS_ID
549 and SUBB.LANGUAGE = SUBT.SOURCE_LANG
550 and (SUBB.MEANING <> SUBT.MEANING
552 or (SUBB.MEANING is not null and SUBT.MEANING is null)
553 or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
554 or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
555 or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
556 ));
557
558 insert into ASO_QUOTE_STATUSES_TL (
559 QUOTE_STATUS_ID,
560 LAST_UPDATE_DATE,
561 LAST_UPDATED_BY,
562 CREATION_DATE,
563 CREATED_BY,
564 LAST_UPDATE_LOGIN,
565 REQUEST_ID,
566 PROGRAM_APPLICATION_ID,
567 PROGRAM_ID,
568 PROGRAM_UPDATE_DATE,
569 MEANING,
570 DESCRIPTION,
571 LANGUAGE,
572 SOURCE_LANG
573 ) select
574 B.QUOTE_STATUS_ID,
575 B.LAST_UPDATE_DATE,
576 B.LAST_UPDATED_BY,
577 B.CREATION_DATE,
578 B.CREATED_BY,
579 B.LAST_UPDATE_LOGIN,
580 B.REQUEST_ID,
581 B.PROGRAM_APPLICATION_ID,
582 B.PROGRAM_ID,
583 B.PROGRAM_UPDATE_DATE,
584 B.MEANING,
585 B.DESCRIPTION,
586 L.LANGUAGE_CODE,
587 B.SOURCE_LANG
588 from ASO_QUOTE_STATUSES_TL B, FND_LANGUAGES L
589 where L.INSTALLED_FLAG in ('I', 'B')
590 and B.LANGUAGE = userenv('LANG')
591 and not exists
592 (select NULL
593 from ASO_QUOTE_STATUSES_TL T
594 where T.QUOTE_STATUS_ID = B.QUOTE_STATUS_ID
595 and T.LANGUAGE = L.LANGUAGE_CODE);
596 end ADD_LANGUAGE;
597
598 procedure LOAD_ROW (
599 X_STATUS_CODE in VARCHAR2,
600 X_MEANING in VARCHAR2,
601 X_DESCRIPTION in VARCHAR2,
602 X_UPDATE_ALLOWED_FLAG in VARCHAR2,
603 X_AUTO_VERSION_FLAG in VARCHAR2,
604 X_USER_MAINTAINABLE_FLAG in VARCHAR2,
605 X_EFFECTIVE_START_DATE IN date,
606 X_EFFECTIVE_END_DATE IN DATE,
607 X_ALLOW_LOV_TO_FLAG VARCHAR2,
608 X_ALLOW_LOV_FROM_FLAG VARCHAR2,
609 X_ALLOW_NEW_TO_FLAG VARCHAR2,
610 X_ALLOW_NEW_FROM_FLAG VARCHAR2,
611 X_SEED_TAG VARCHAR2,
612 X_ENABLED_FLAG VARCHAR2,
613 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
614 X_ATTRIBUTE1 in VARCHAR2,
615 X_ATTRIBUTE2 in VARCHAR2,
616 X_ATTRIBUTE3 in VARCHAR2,
617 X_ATTRIBUTE4 in VARCHAR2,
618 X_ATTRIBUTE5 in VARCHAR2,
619 X_ATTRIBUTE6 in VARCHAR2,
620 X_ATTRIBUTE7 in VARCHAR2,
621 X_ATTRIBUTE8 in VARCHAR2,
622 X_ATTRIBUTE9 in VARCHAR2,
623 X_ATTRIBUTE10 in VARCHAR2,
624 X_ATTRIBUTE11 in VARCHAR2,
625 X_ATTRIBUTE12 in VARCHAR2,
626 X_ATTRIBUTE13 in VARCHAR2,
627 X_ATTRIBUTE14 in VARCHAR2,
628 X_ATTRIBUTE15 in VARCHAR2,
629 X_ATTRIBUTE16 in VARCHAR2,
630 X_ATTRIBUTE17 in VARCHAR2,
631 X_ATTRIBUTE18 in VARCHAR2,
632 X_ATTRIBUTE19 in VARCHAR2,
633 X_ATTRIBUTE20 in VARCHAR2,
634 X_OWNER in VARCHAR2
635 ) IS
636 begin
637
638 declare
639 user_id number := 0;
640 row_id varchar2(64);
641 lx_quote_id number;
642 l_quote_status_id number;
643 CURSOR C IS SELECT ASO_QUOTE_STATUSES_B_S.nextval FROM dual;
644 CURSOR C2 IS SELECT QUOTE_STATUS_ID FROM ASO_QUOTE_STATUSES_VL
645 WHERE STATUS_CODE= X_STATUS_CODE;
646
647 begin
648 -- get the user id
649 user_id := fnd_load_util.owner_id(X_OWNER);
650
651 begin
652 for i in C2 loop
653 l_quote_status_id := i.QUOTE_STATUS_ID;
654 exit;
655 end loop;
656 IF (l_quote_status_id is not null) or (l_quote_status_id <> FND_API.G_MISS_NUM) THEN
657 UPDATE_ROW (
658 p_QUOTE_STATUS_ID => l_quote_status_id ,
659 p_STATUS_CODE => X_STATUS_CODE ,
660 p_MEANING => X_MEANING,
661 p_DESCRIPTION => X_DESCRIPTION ,
662 p_UPDATE_ALLOWED_FLAG => X_UPDATE_ALLOWED_FLAG ,
663 p_AUTO_VERSION_FLAG => X_AUTO_VERSION_FLAG ,
664 p_USER_MAINTAINABLE_FLAG => X_USER_MAINTAINABLE_FLAG ,
665 p_EFFECTIVE_START_DATE => X_EFFECTIVE_START_DATE ,
666 p_EFFECTIVE_END_DATE => X_EFFECTIVE_END_DATE ,
667 p_ALLOW_LOV_TO_FLAG => X_ALLOW_LOV_TO_FLAG,
668 p_ALLOW_LOV_FROM_FLAG => X_ALLOW_LOV_FROM_FLAG,
669 p_ALLOW_NEW_TO_FLAG => X_ALLOW_NEW_TO_FLAG,
670 p_ALLOW_NEW_FROM_FLAG => X_ALLOW_NEW_FROM_FLAG,
671 p_SEED_TAG => X_SEED_TAG,
672 p_ENABLED_FLAG => X_ENABLED_FLAG,
673 p_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
674 p_ATTRIBUTE1 => X_ATTRIBUTE1 ,
675 p_ATTRIBUTE2 => X_ATTRIBUTE2 ,
676 p_ATTRIBUTE3 => X_ATTRIBUTE3 ,
677 p_ATTRIBUTE4 => X_ATTRIBUTE4 ,
678 p_ATTRIBUTE5 => X_ATTRIBUTE5 ,
679 p_ATTRIBUTE6 => X_ATTRIBUTE6 ,
680 p_ATTRIBUTE7 => X_ATTRIBUTE7 ,
681 p_ATTRIBUTE8 => X_ATTRIBUTE8 ,
682 p_ATTRIBUTE9 => X_ATTRIBUTE9 ,
683 p_ATTRIBUTE10 => X_ATTRIBUTE10 ,
684 p_ATTRIBUTE11 => X_ATTRIBUTE11 ,
685 p_ATTRIBUTE12 => X_ATTRIBUTE12 ,
686 p_ATTRIBUTE13 => X_ATTRIBUTE13 ,
687 p_ATTRIBUTE14 => X_ATTRIBUTE14 ,
688 p_ATTRIBUTE15 => X_ATTRIBUTE15 ,
692 p_ATTRIBUTE19 => X_ATTRIBUTE19 ,
689 p_ATTRIBUTE16 => X_ATTRIBUTE16 ,
690 p_ATTRIBUTE17 => X_ATTRIBUTE17 ,
691 p_ATTRIBUTE18 => X_ATTRIBUTE18 ,
693 p_ATTRIBUTE20 => X_ATTRIBUTE20 ,
694 p_CREATION_DATE => sysdate,
695 p_CREATED_BY => user_id,
696 p_LAST_UPDATED_BY => user_id,
697 p_LAST_UPDATE_DATE => sysdate,
698 p_LAST_UPDATE_LOGIN => user_id,
699 p_REQUEST_ID => fnd_global.conc_request_id,
700 p_PROGRAM_APPLICATION_ID => fnd_global.prog_appl_id,
701 p_PROGRAM_ID => fnd_global.conc_program_id,
702 p_PROGRAM_UPDATE_DATE => sysdate
703 );
704 --END IF;
705 /*
706 exception
707 when NO_DATA_FOUND then
708 */
709 Else
710 OPEN C;
711 FETCH C INTO lx_quote_id;
712 CLOSE C;
713 INSERT_ROW (
714 px_QUOTE_STATUS_ID => lx_quote_id ,
715 p_STATUS_CODE => X_STATUS_CODE ,
716 p_MEANING => X_MEANING,
717 p_DESCRIPTION => X_DESCRIPTION ,
718 p_UPDATE_ALLOWED_FLAG => X_UPDATE_ALLOWED_FLAG ,
719 p_AUTO_VERSION_FLAG => X_AUTO_VERSION_FLAG ,
720 p_USER_MAINTAINABLE_FLAG => X_USER_MAINTAINABLE_FLAG ,
721 p_EFFECTIVE_START_DATE => X_EFFECTIVE_START_DATE ,
722 p_EFFECTIVE_END_DATE => X_EFFECTIVE_END_DATE ,
723 p_ALLOW_LOV_TO_FLAG => X_ALLOW_LOV_TO_FLAG,
724 p_ALLOW_LOV_FROM_FLAG => X_ALLOW_LOV_FROM_FLAG,
725 p_ALLOW_NEW_TO_FLAG => X_ALLOW_NEW_TO_FLAG,
726 p_ALLOW_NEW_FROM_FLAG => X_ALLOW_NEW_FROM_FLAG,
727 p_SEED_TAG => X_SEED_TAG,
728 p_ENABLED_FLAG => X_ENABLED_FLAG,
729 p_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
730 p_ATTRIBUTE1 => X_ATTRIBUTE1 ,
731 p_ATTRIBUTE2 => X_ATTRIBUTE2 ,
732 p_ATTRIBUTE3 => X_ATTRIBUTE3 ,
733 p_ATTRIBUTE4 => X_ATTRIBUTE4 ,
734 p_ATTRIBUTE5 => X_ATTRIBUTE5 ,
735 p_ATTRIBUTE6 => X_ATTRIBUTE6 ,
736 p_ATTRIBUTE7 => X_ATTRIBUTE7 ,
737 p_ATTRIBUTE8 => X_ATTRIBUTE8 ,
738 p_ATTRIBUTE9 => X_ATTRIBUTE9 ,
739 p_ATTRIBUTE10 => X_ATTRIBUTE10 ,
740 p_ATTRIBUTE11 => X_ATTRIBUTE11 ,
741 p_ATTRIBUTE12 => X_ATTRIBUTE12 ,
742 p_ATTRIBUTE13 => X_ATTRIBUTE13 ,
743 p_ATTRIBUTE14 => X_ATTRIBUTE14 ,
744 p_ATTRIBUTE15 => X_ATTRIBUTE15 ,
745 p_ATTRIBUTE16 => X_ATTRIBUTE16 ,
746 p_ATTRIBUTE17 => X_ATTRIBUTE17 ,
747 p_ATTRIBUTE18 => X_ATTRIBUTE18 ,
748 p_ATTRIBUTE19 => X_ATTRIBUTE19 ,
749 p_ATTRIBUTE20 => X_ATTRIBUTE20 ,
750 p_CREATION_DATE => sysdate,
751 p_CREATED_BY => user_id,
752 p_LAST_UPDATED_BY => user_id,
753 p_LAST_UPDATE_DATE => sysdate,
754 p_LAST_UPDATE_LOGIN => user_id,
755 p_REQUEST_ID => fnd_global.conc_request_id,
756 p_PROGRAM_APPLICATION_ID => fnd_global.prog_appl_id,
757 p_PROGRAM_ID => fnd_global.conc_program_id,
758 p_PROGRAM_UPDATE_DATE => sysdate
759 );
760 end if;
761 commit;
762 end;
763 end;
764
765 end LOAD_ROW;
766
767 procedure TRANSLATE_ROW (
768 X_QUOTE_STATUS_ID in NUMBER,
769 X_DESCRIPTION in VARCHAR2,
770 X_MEANING in VARCHAR2,
771 X_OWNER in VARCHAR2)
772 IS
773 begin
774
775 -- only update rows that have not been altered by user
776
777 update ASO_QUOTE_STATUSES_TL
778 set description = X_DESCRIPTION,
779 meaning = X_MEANING,
780 source_lang = userenv('LANG'),
781 last_update_date = sysdate,
782 last_updated_by = fnd_load_util.owner_id(X_OWNER),
783 last_update_login = 0
784 where QUOTE_STATUS_ID = X_QUOTE_STATUS_ID
785 and userenv('LANG') in (language, source_lang);
786
790 X_UPLOAD_MODE IN VARCHAR2,
787 end TRANSLATE_ROW;
788
789 PROCEDURE LOAD_SEED_ROW (
791 X_STATUS_CODE IN VARCHAR2,
792 X_MEANING IN VARCHAR2,
793 X_DESCRIPTION IN VARCHAR2,
794 X_UPDATE_ALLOWED_FLAG IN VARCHAR2,
795 X_AUTO_VERSION_FLAG IN VARCHAR2,
796 X_USER_MAINTAINABLE_FLAG IN VARCHAR2,
797 X_EFFECTIVE_START_DATE IN DATE,
798 X_EFFECTIVE_END_DATE IN DATE,
799 X_ALLOW_LOV_TO_FLAG IN VARCHAR2,
800 X_ALLOW_LOV_FROM_FLAG IN VARCHAR2,
801 X_ALLOW_NEW_TO_FLAG IN VARCHAR2,
802 X_ALLOW_NEW_FROM_FLAG IN VARCHAR2,
803 X_SEED_TAG IN VARCHAR2,
804 X_ENABLED_FLAG IN VARCHAR2,
805 X_ATTRIBUTE_CATEGORY IN VARCHAR2,
806 X_ATTRIBUTE1 IN VARCHAR2,
807 X_ATTRIBUTE2 IN VARCHAR2,
808 X_ATTRIBUTE3 IN VARCHAR2,
809 X_ATTRIBUTE4 IN VARCHAR2,
810 X_ATTRIBUTE5 IN VARCHAR2,
811 X_ATTRIBUTE6 IN VARCHAR2,
812 X_ATTRIBUTE7 IN VARCHAR2,
813 X_ATTRIBUTE8 IN VARCHAR2,
814 X_ATTRIBUTE9 IN VARCHAR2,
815 X_ATTRIBUTE10 IN VARCHAR2,
816 X_ATTRIBUTE11 IN VARCHAR2,
817 X_ATTRIBUTE12 IN VARCHAR2,
818 X_ATTRIBUTE13 IN VARCHAR2,
819 X_ATTRIBUTE14 IN VARCHAR2,
820 X_ATTRIBUTE15 IN VARCHAR2,
821 X_ATTRIBUTE16 IN VARCHAR2,
822 X_ATTRIBUTE17 IN VARCHAR2,
823 X_ATTRIBUTE18 IN VARCHAR2,
824 X_ATTRIBUTE19 IN VARCHAR2,
825 X_ATTRIBUTE20 IN VARCHAR2,
826 X_OWNER IN VARCHAR2
827 ) IS
828
829 L_QUOTE_STATUS_ID NUMBER(22);
830
831 CURSOR c2 is select QUOTE_STATUS_ID
832 FROM ASO_QUOTE_STATUSES_VL
833 WHERE STATUS_CODE = X_STATUS_CODE ;
834
835 BEGIN
836
837 FOR i IN c2 LOOP
838 L_QUOTE_STATUS_ID := i.QUOTE_STATUS_ID;
839 exit;
840 END LOOP;
841
842 IF (X_UPLOAD_MODE = 'NLS') then
843 ASO_QUOTE_STATUS_PKG.TRANSLATE_ROW (
844 X_QUOTE_STATUS_ID => L_QUOTE_STATUS_ID,
845 X_MEANING => X_MEANING,
846 X_DESCRIPTION => X_DESCRIPTION,
847 X_OWNER => X_OWNER);
848
849 ELSE
850 ASO_QUOTE_STATUS_PKG.LOAD_ROW (
851 X_MEANING => X_MEANING,
852 X_DESCRIPTION => X_DESCRIPTION,
853 X_STATUS_CODE => X_STATUS_CODE,
854 X_UPDATE_ALLOWED_FLAG => X_UPDATE_ALLOWED_FLAG,
855 X_AUTO_VERSION_FLAG => X_AUTO_VERSION_FLAG,
856 X_USER_MAINTAINABLE_FLAG => X_USER_MAINTAINABLE_FLAG,
857 X_EFFECTIVE_START_DATE => X_EFFECTIVE_START_DATE,
858 X_EFFECTIVE_END_DATE => X_EFFECTIVE_END_DATE,
859 X_ALLOW_LOV_TO_FLAG => X_ALLOW_LOV_TO_FLAG,
860 X_ALLOW_LOV_FROM_FLAG => X_ALLOW_LOV_FROM_FLAG,
861 X_ALLOW_NEW_TO_FLAG => X_ALLOW_NEW_TO_FLAG,
862 X_ALLOW_NEW_FROM_FLAG => X_ALLOW_NEW_FROM_FLAG,
863 X_SEED_TAG => X_SEED_TAG,
864 X_ENABLED_FLAG => X_ENABLED_FLAG,
865 X_ATTRIBUTE_CATEGORY => X_ATTRIBUTE_CATEGORY,
866 X_ATTRIBUTE1 => X_ATTRIBUTE1,
867 X_ATTRIBUTE2 => X_ATTRIBUTE2,
868 X_ATTRIBUTE3 => X_ATTRIBUTE3,
869 X_ATTRIBUTE4 => X_ATTRIBUTE4,
870 X_ATTRIBUTE5 => X_ATTRIBUTE5,
871 X_ATTRIBUTE6 => X_ATTRIBUTE6,
872 X_ATTRIBUTE7 => X_ATTRIBUTE7,
873 X_ATTRIBUTE8 => X_ATTRIBUTE8,
874 X_ATTRIBUTE9 => X_ATTRIBUTE9,
875 X_ATTRIBUTE10 => X_ATTRIBUTE10,
876 X_ATTRIBUTE11 => X_ATTRIBUTE11,
877 X_ATTRIBUTE12 => X_ATTRIBUTE12,
878 X_ATTRIBUTE13 => X_ATTRIBUTE13,
879 X_ATTRIBUTE14 => X_ATTRIBUTE14,
880 X_ATTRIBUTE15 => X_ATTRIBUTE15,
881 X_ATTRIBUTE16 => X_ATTRIBUTE16,
882 X_ATTRIBUTE17 => X_ATTRIBUTE17,
883 X_ATTRIBUTE18 => X_ATTRIBUTE18,
884 X_ATTRIBUTE19 => X_ATTRIBUTE19,
885 X_ATTRIBUTE20 => X_ATTRIBUTE20,
886 X_OWNER => X_OWNER);
887 END IF;
888
889 END LOAD_SEED_ROW;
890
891 END ASO_QUOTE_STATUS_PKG;
892