[Home] [Help]
39:
40: begin
41:
42: if (X_SECURITY_GROUP_ID is NULL) then
43: sgid:= FND_GLOBAL.SECURITY_GROUP_ID;
44: else
45: sgid := X_SECURITY_GROUP_ID;
46: end if;
47:
150: WHERE flv.lookup_type = 'UNIT'
151: AND flv.meaning <> mtl_uom.unit_of_measure_tl
152: AND flv.lookup_code = mtl_uom.uom_code
153: AND flv.view_application_id = 275
154: AND flv.security_group_id = fnd_global.lookup_security_group('UNIT',275)
155: AND flv.language = mtl_uom.language
156: )
157: AND NOT EXISTS
158: (SELECT 1
159: FROM fnd_lookup_values flv1
160: WHERE flv1.lookup_type = 'UNIT'
161: AND flv1.meaning = mtl_uom.unit_of_measure_tl
162: AND flv1.view_application_id = 275
163: AND flv1.security_group_id = fnd_global.lookup_security_group('UNIT',275)
164: AND flv1.language = mtl_uom.language
165: )
166: AND rowid = (
167: SELECT max(rowid) from Mtl_Units_Of_Measure_TL mtl_uom_2
202: WHERE flv.lookup_type = 'UNIT'
203: AND flv.meaning <> mtl_uom.unit_of_measure_tl
204: AND flv.lookup_code = mtl_uom.uom_code
205: AND flv.view_application_id = 275
206: AND flv.security_group_id = fnd_global.lookup_security_group('UNIT',275)
207: AND flv.language = mtl_uom.language
208: )
209: AND NOT EXISTS
210: (SELECT 1
211: FROM fnd_lookup_values flv1
212: WHERE flv1.lookup_type = 'UNIT'
213: AND flv1.meaning = mtl_uom.unit_of_measure_tl
214: AND flv1.view_application_id = 275
215: AND flv1.security_group_id = fnd_global.lookup_security_group('UNIT',275)
216: AND flv1.language = mtl_uom.language
217: )
218: AND rowid = (
219: SELECT max(rowid) from Mtl_Units_Of_Measure_TL mtl_uom_2
260: WHERE flv.lookup_type = 'UNIT'
261: AND flv.meaning <> mtl_uom.unit_of_measure_tl
262: AND flv.lookup_code = mtl_uom.uom_code
263: AND flv.view_application_id = 275
264: AND flv.security_group_id = fnd_global.lookup_security_group('UNIT',275)
265: AND flv.language = mtl_uom.language
266: )
267: AND NOT EXISTS
268: (SELECT 1
269: FROM fnd_lookup_values flv1
270: WHERE flv1.lookup_type = 'UNIT'
271: AND flv1.meaning = '@'||mtl_uom.unit_of_measure_tl
272: AND flv1.view_application_id = 275
273: AND flv1.security_group_id = fnd_global.lookup_security_group('UNIT',275)
274: AND flv1.language = mtl_uom.language
275: );
276: CURSOR cur_chg_uom_code_x IS /*cursor to update records with @meaning where duplication for meaning exists*/
277: SELECT language
307: WHERE flv.lookup_type = 'UNIT'
308: AND flv.meaning <> mtl_uom.unit_of_measure_tl
309: AND flv.lookup_code = mtl_uom.uom_code
310: AND flv.view_application_id = 275
311: AND flv.security_group_id = fnd_global.lookup_security_group('UNIT',275)
312: AND flv.language = mtl_uom.language
313: )
314: AND NOT EXISTS
315: (SELECT 1
316: FROM fnd_lookup_values flv1
317: WHERE flv1.lookup_type = 'UNIT'
318: AND flv1.meaning = '@'||mtl_uom.unit_of_measure_tl
319: AND flv1.view_application_id = 275
320: AND flv1.security_group_id = fnd_global.lookup_security_group('UNIT',275)
321: AND flv1.language = mtl_uom.language
322: );
323: /* Removed check for bug 4130638
324: AND EXISTS
360: WHERE flv.lookup_type = 'UNIT'
361: AND flv.meaning = mtl_uom.unit_of_measure_tl
362: AND flv.lookup_code <> mtl_uom.uom_code
363: AND flv.view_application_id = 275
364: AND flv.security_group_id = fnd_global.lookup_security_group('UNIT',275)
365: AND flv.language = mtl_uom.language
366: )
367: AND NOT EXISTS
368: (SELECT 1
369: FROM fnd_lookup_values flv1
370: WHERE flv1.lookup_type = 'UNIT'
371: AND flv1.lookup_code = mtl_uom.uom_code
372: AND flv1.view_application_id = 275
373: AND flv1.security_group_id = fnd_global.lookup_security_group('UNIT',275)
374: AND flv1.language = mtl_uom.language
375: )
376: AND rowid = ( /*Added this condition for the bug 13539202 */
377: SELECT max(rowid) from Mtl_Units_Of_Measure_TL mtl_uom_2
413: WHERE flv.lookup_type = 'UNIT'
414: AND flv.meaning = mtl_uom.unit_of_measure_tl
415: AND flv.lookup_code <> mtl_uom.uom_code
416: AND flv.view_application_id = 275
417: AND flv.security_group_id = fnd_global.lookup_security_group('UNIT',275)
418: AND flv.language = mtl_uom.language
419: )
420: AND NOT EXISTS
421: (SELECT 1
422: FROM fnd_lookup_values flv1
423: WHERE flv1.lookup_type = 'UNIT'
424: AND flv1.lookup_code = mtl_uom.uom_code
425: AND flv1.view_application_id = 275
426: AND flv1.security_group_id = fnd_global.lookup_security_group('UNIT',275)
427: AND flv1.language = mtl_uom.language
428: )
429: AND rowid = ( /*Added this condition for the bug 13539202 */
430: SELECT max(rowid) from Mtl_Units_Of_Measure_TL mtl_uom_2
472: FROM fnd_lookup_values flv
473: WHERE flv.lookup_type = 'UNIT'
474: AND (flv.meaning = mtl_uom.unit_of_measure_tl OR flv.lookup_code = mtl_uom.uom_code)
475: AND flv.view_application_id = 275
476: AND flv.security_group_id = fnd_global.lookup_security_group('UNIT',275)
477: AND flv.language = mtl_uom.language
478: )
479: AND rowid = (
480: SELECT max(rowid) from Mtl_Units_Of_Measure_TL mtl_uom_2
514: FROM fnd_lookup_values flv
515: WHERE flv.lookup_type = 'UNIT'
516: AND (flv.meaning = mtl_uom.unit_of_measure_tl OR flv.lookup_code = mtl_uom.uom_code)
517: AND flv.view_application_id = 275
518: AND flv.security_group_id = fnd_global.lookup_security_group('UNIT',275)
519: --AND flv.language = mtl_uom.language /*Bug 13899806 Commented the condition*/
520: )
521: AND rowid = (
522: SELECT max(rowid) from Mtl_Units_Of_Measure_TL mtl_uom_2
531: ) ;
532: */
533: BEGIN --Function Get_UOM Begins
534:
535: l_conc_login_id := fnd_global.CONC_LOGIN_ID;
536: l_security_group_id := fnd_global.lookup_security_group('UNIT',275);
537: l_return_str := 'S';
538:
539: /* Bug 6740153 Changed the logic so that new UOMS defined in MTL are inserted first
532: */
533: BEGIN --Function Get_UOM Begins
534:
535: l_conc_login_id := fnd_global.CONC_LOGIN_ID;
536: l_security_group_id := fnd_global.lookup_security_group('UNIT',275);
537: l_return_str := 'S';
538:
539: /* Bug 6740153 Changed the logic so that new UOMS defined in MTL are inserted first
540: (only one record per meaning) so that the next record is updated with @meaning */