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.

APPS.PA_UOM dependencies on FND_GLOBAL

Line 43: sgid:= FND_GLOBAL.SECURITY_GROUP_ID;

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:

Line 154: AND flv.security_group_id = fnd_global.lookup_security_group('UNIT',275)

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

Line 163: AND flv1.security_group_id = fnd_global.lookup_security_group('UNIT',275)

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

Line 206: AND flv.security_group_id = fnd_global.lookup_security_group('UNIT',275)

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

Line 215: AND flv1.security_group_id = fnd_global.lookup_security_group('UNIT',275)

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

Line 264: AND flv.security_group_id = fnd_global.lookup_security_group('UNIT',275)

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

Line 273: AND flv1.security_group_id = fnd_global.lookup_security_group('UNIT',275)

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

Line 311: AND flv.security_group_id = fnd_global.lookup_security_group('UNIT',275)

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

Line 320: AND flv1.security_group_id = fnd_global.lookup_security_group('UNIT',275)

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

Line 364: AND flv.security_group_id = fnd_global.lookup_security_group('UNIT',275)

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

Line 373: AND flv1.security_group_id = fnd_global.lookup_security_group('UNIT',275)

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:
377: CURSOR cur_chg_uom_meaning IS/*cursor to select records where different UOM code exists for the same meaning */

Line 412: AND flv.security_group_id = fnd_global.lookup_security_group('UNIT',275)

408: WHERE flv.lookup_type = 'UNIT'
409: AND flv.meaning = mtl_uom.unit_of_measure_tl
410: AND flv.lookup_code <> mtl_uom.uom_code
411: AND flv.view_application_id = 275
412: AND flv.security_group_id = fnd_global.lookup_security_group('UNIT',275)
413: AND flv.language = mtl_uom.language
414: )
415: AND NOT EXISTS
416: (SELECT 1

Line 421: AND flv1.security_group_id = fnd_global.lookup_security_group('UNIT',275)

417: FROM fnd_lookup_values flv1
418: WHERE flv1.lookup_type = 'UNIT'
419: AND flv1.lookup_code = mtl_uom.uom_code
420: AND flv1.view_application_id = 275
421: AND flv1.security_group_id = fnd_global.lookup_security_group('UNIT',275)
422: AND flv1.language = mtl_uom.language
423: );
424:
425: /* Removed check for bug 4130638

Line 466: AND flv.security_group_id = fnd_global.lookup_security_group('UNIT',275)

462: FROM fnd_lookup_values flv
463: WHERE flv.lookup_type = 'UNIT'
464: AND (flv.meaning = mtl_uom.unit_of_measure_tl OR flv.lookup_code = mtl_uom.uom_code)
465: AND flv.view_application_id = 275
466: AND flv.security_group_id = fnd_global.lookup_security_group('UNIT',275)
467: AND flv.language = mtl_uom.language
468: )
469: AND rowid = (
470: SELECT max(rowid) from Mtl_Units_Of_Measure_TL mtl_uom_2

Line 508: AND flv.security_group_id = fnd_global.lookup_security_group('UNIT',275)

504: FROM fnd_lookup_values flv
505: WHERE flv.lookup_type = 'UNIT'
506: AND (flv.meaning = mtl_uom.unit_of_measure_tl OR flv.lookup_code = mtl_uom.uom_code)
507: AND flv.view_application_id = 275
508: AND flv.security_group_id = fnd_global.lookup_security_group('UNIT',275)
509: AND flv.language = mtl_uom.language
510: )
511: AND rowid = (
512: SELECT max(rowid) from Mtl_Units_Of_Measure_TL mtl_uom_2

Line 525: l_conc_login_id := fnd_global.CONC_LOGIN_ID;

521: ) ;
522: */
523: BEGIN --Function Get_UOM Begins
524:
525: l_conc_login_id := fnd_global.CONC_LOGIN_ID;
526: l_security_group_id := fnd_global.lookup_security_group('UNIT',275);
527: l_return_str := 'S';
528:
529: /* Bug 6740153 Changed the logic so that new UOMS defined in MTL are inserted first

Line 526: l_security_group_id := fnd_global.lookup_security_group('UNIT',275);

522: */
523: BEGIN --Function Get_UOM Begins
524:
525: l_conc_login_id := fnd_global.CONC_LOGIN_ID;
526: l_security_group_id := fnd_global.lookup_security_group('UNIT',275);
527: l_return_str := 'S';
528:
529: /* Bug 6740153 Changed the logic so that new UOMS defined in MTL are inserted first
530: (only one record per meaning) so that the next record is updated with @meaning */