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_LOOKUP_VALUES

Line 5: PROCEDURE update_fnd_lookup_values(

1: PACKAGE BODY pa_uom AS
2: /* $Header: PATXUOMB.pls 120.3.12020000.3 2013/03/06 09:47:26 admarath ship $ */
3:
4:
5: PROCEDURE update_fnd_lookup_values(
6: X_LOOKUP_TYPE in VARCHAR2,
7: X_SECURITY_GROUP_ID in NUMBER default NULL,
8: X_VIEW_APPLICATION_ID in NUMBER,
9: X_LOOKUP_CODE in VARCHAR2,

Line 49: update FND_LOOKUP_VALUES set

45: sgid := X_SECURITY_GROUP_ID;
46: end if;
47:
48: -- Update "non-translated" values in all languages
49: update FND_LOOKUP_VALUES set
50: TAG = X_TAG,
51: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
52: ATTRIBUTE1 = X_ATTRIBUTE1,
53: ATTRIBUTE2 = X_ATTRIBUTE2,

Line 82: update FND_LOOKUP_VALUES set

78: and LANGUAGE= X_LANGUAGE;
79:
80:
81: -- Update "translated" values in current language
82: update FND_LOOKUP_VALUES set
83: MEANING = X_MEANING,
84: DESCRIPTION = X_DESCRIPTION,
85: SOURCE_LANG = userenv('LANG')
86: where LOOKUP_TYPE = X_LOOKUP_TYPE

Line 101: end update_fnd_lookup_values;

97:
98: exception
99: when others then
100: raise;
101: end update_fnd_lookup_values;
102:
103: /******************************************************************************/
104: ------------------------------ Function Get_UOM ------------------------------
105: /******************************************************************************/

Line 111: /* reflect the same in FND LOOKUP VALUES. Once Updated existing UOM */

107: FUNCTION get_uom(P_user_id IN number , P_uom_code IN VARCHAR2 DEFAULT NULL ) RETURN VARCHAR2 IS
108:
109: /*****************************************************************************/
110: /***** This procedure will first Identify any Upadted UOM in MTL. And *****/
111: /***** reflect the same in FND LOOKUP VALUES. Once Updated existing UOM *****/
112: /***** it will Insert any newly introduced UOMs in MTL to FND LOOKUP *****/
113: /***** VALUES. This is done using BulkInsertion. *****/
114: /*****************************************************************************/
115:

Line 149: FROM fnd_lookup_values flv

145: WHERE mtl_uom.uom_code = p_uom_code
146: /* AND language = userenv('LANG') */
147: AND EXISTS
148: (SELECT lookup_code
149: FROM fnd_lookup_values flv
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

Line 159: FROM fnd_lookup_values flv1

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)

Line 201: FROM fnd_lookup_values flv

197: WHERE MUC_UOM.UOM_CODE = MTL_UOM.UOM_CODE
198: )
199: AND EXISTS
200: (SELECT lookup_code
201: FROM fnd_lookup_values flv
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

Line 211: FROM fnd_lookup_values flv1

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)

Line 259: FROM fnd_lookup_values flv

255: WHERE mtl_uom.uom_code = p_uom_code
256: /* AND language = userenv('LANG') */
257: AND EXISTS
258: (SELECT lookup_code
259: FROM fnd_lookup_values flv
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

Line 269: FROM fnd_lookup_values flv1

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)

Line 306: FROM fnd_lookup_values flv

302: WHERE MUC_UOM.UOM_CODE = MTL_UOM.UOM_CODE
303: )
304: AND EXISTS
305: (SELECT lookup_code
306: FROM fnd_lookup_values flv
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

Line 316: FROM fnd_lookup_values flv1

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)

Line 359: FROM fnd_lookup_values flv

355: WHERE /* language = userenv('LANG') */
356: mtl_uom.uom_code = p_uom_code
357: AND EXISTS
358: (SELECT lookup_code
359: FROM fnd_lookup_values flv
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

Line 369: FROM fnd_lookup_values flv1

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)

Line 412: FROM fnd_lookup_values flv

408: WHERE MUC_UOM.UOM_CODE = MTL_UOM.UOM_CODE
409: )
410: AND EXISTS
411: (SELECT lookup_code
412: FROM fnd_lookup_values flv
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

Line 422: FROM fnd_lookup_values flv1

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)

Line 472: FROM fnd_lookup_values flv

468: WHERE mtl_uom.uom_code = p_uom_code
469: /* AND language = userenv('LANG') */
470: AND NOT EXISTS
471: (SELECT lookup_code
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)

Line 514: FROM fnd_lookup_values flv

510: WHERE MUC_UOM.UOM_CODE = MTL_UOM.UOM_CODE
511: )
512: AND NOT EXISTS
513: (SELECT lookup_code
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)

Line 548: fnd_lookup_values_pkg.insert_row (

544:
545: If p_uom_code IS NOT NULL then -- When PJF team calls they pass p_uom_code
546: FOR rec_new_uom_1 IN cur_new_uom_1 ( p_uom_code )
547: LOOP
548: fnd_lookup_values_pkg.insert_row (
549: x_rowid => l_rowid,
550: x_lookup_type => 'UNIT',
551: x_security_group_id => l_security_group_id,
552: x_view_application_id => 275,

Line 586: fnd_lookup_values_pkg.insert_row (

582: END LOOP ;
583: else -- When PA calls p_uom_code will be NULL
584: FOR rec_new_uom IN cur_new_uom
585: LOOP
586: fnd_lookup_values_pkg.insert_row (
587: x_rowid => l_rowid,
588: x_lookup_type => 'UNIT',
589: x_security_group_id => l_security_group_id,
590: x_view_application_id => 275,

Line 629: /* Update UOM Code in FND LOOKUP VALUES from PLSQL Tables. Here all /

625: --------------------------- Update Existing UOMs ----------------------------
626: -------------------------------------------------------------------------------
627:
628:
629: /***** Update UOM Code in FND LOOKUP VALUES from PLSQL Tables. Here all ****/
630: /***** the UOM Codes where meaning is changed in MTL, will be updated to ****/
631: /***** Reflect the same in Lookups ****/
632: If p_uom_code IS NOT NULL then -- When PJF team calls they pass p_uom_code
633: FOR rec_chg_uom_code_1 IN cur_chg_uom_code_1(p_uom_code )

Line 635: fnd_lookup_values_pkg.update_row (

631: /***** Reflect the same in Lookups ****/
632: If p_uom_code IS NOT NULL then -- When PJF team calls they pass p_uom_code
633: FOR rec_chg_uom_code_1 IN cur_chg_uom_code_1(p_uom_code )
634: LOOP
635: fnd_lookup_values_pkg.update_row (
636: x_lookup_type => 'UNIT',
637: x_security_group_id => l_security_group_id,
638: x_view_application_id => 275,
639: x_lookup_code => rec_chg_uom_code_1.Uom_Code,

Line 673: fnd_lookup_values_pkg.update_row (

669: FOR rec_chg_uom_code IN cur_chg_uom_code
670: LOOP
671:
672: /* commented for bug 5624048
673: fnd_lookup_values_pkg.update_row (
674: x_lookup_type => 'UNIT',
675: x_security_group_id => l_security_group_id,
676: x_view_application_id => 275,
677: x_lookup_code => rec_chg_uom_code.Uom_Code,

Line 707: update_fnd_lookup_values (

703: x_last_update_login => l_conc_login_id
704: ) ; */
705:
706: /* changed the call for bug 5624048 */
707: update_fnd_lookup_values (
708: x_lookup_type => 'UNIT',
709: x_security_group_id => l_security_group_id,
710: x_view_application_id => 275,
711: x_lookup_code => rec_chg_uom_code.Uom_Code,

Line 748: fnd_lookup_values_pkg.update_row (

744:
745: If p_uom_code IS NOT NULL then -- When PJF team calls they pass p_uom_code
746: FOR rec_chg_uom_code_y IN cur_chg_uom_code_y(p_uom_code )
747: LOOP
748: fnd_lookup_values_pkg.update_row (
749: x_lookup_type => 'UNIT',
750: x_security_group_id => l_security_group_id,
751: x_view_application_id => 275,
752: x_lookup_code => rec_chg_uom_code_y.Uom_Code,

Line 785: update_fnd_lookup_values (

781: else -- When PA calls p_uom_code will be NULL
782: FOR rec_chg_uom_code IN cur_chg_uom_code_x
783: LOOP
784: /* changed the call for bug 5624048 */
785: update_fnd_lookup_values (
786: x_lookup_type => 'UNIT',
787: x_security_group_id => l_security_group_id,
788: x_view_application_id => 275,
789: x_lookup_code => rec_chg_uom_code.Uom_Code,

Line 822: /* Insert New UOM Code in FND LOOKUP VALUES from PLSQL Tables. Here /

818: END LOOP;
819:
820: end if;
821:
822: /***** Insert New UOM Code in FND LOOKUP VALUES from PLSQL Tables. Here ****/
823: /***** all the UOMs in MTL where Meaning meaning exists in Lookups but ****/
824: /***** corresponding Code is different, will be inserted to Reflect the ****/
825: /***** same in Lookups ****/
826:

Line 830: fnd_lookup_values_pkg.insert_row (

826:
827: If p_uom_code IS NOT NULL then -- When PJF team calls they pass p_uom_code
828: FOR rec_chg_uom_meaning_1 IN cur_chg_uom_meaning_1(p_uom_code )
829: LOOP
830: fnd_lookup_values_pkg.insert_row (
831: x_rowid => l_rowid,
832: x_lookup_type => 'UNIT',
833: x_security_group_id => l_security_group_id,
834: x_view_application_id => 275,

Line 869: fnd_lookup_values_pkg.insert_row (

865: else -- When PA calls p_uom_code will be NULL
866: FOR rec_chg_uom_meaning IN cur_chg_uom_meaning
867: LOOP
868:
869: fnd_lookup_values_pkg.insert_row (
870: x_rowid => l_rowid,
871: x_lookup_type => 'UNIT',
872: x_security_group_id => l_security_group_id,
873: x_view_application_id => 275,