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 2008/02/14 06:59:56 anuragar 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 407: FROM fnd_lookup_values flv

403: WHERE MUC_UOM.UOM_CODE = MTL_UOM.UOM_CODE
404: )
405: AND EXISTS
406: (SELECT lookup_code
407: FROM fnd_lookup_values flv
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

Line 417: FROM fnd_lookup_values flv1

413: AND flv.language = mtl_uom.language
414: )
415: AND NOT EXISTS
416: (SELECT 1
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)

Line 462: FROM fnd_lookup_values flv

458: WHERE mtl_uom.uom_code = p_uom_code
459: /* AND language = userenv('LANG') */
460: AND NOT EXISTS
461: (SELECT lookup_code
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)

Line 504: FROM fnd_lookup_values flv

500: WHERE MUC_UOM.UOM_CODE = MTL_UOM.UOM_CODE
501: )
502: AND NOT EXISTS
503: (SELECT lookup_code
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)

Line 538: fnd_lookup_values_pkg.insert_row (

534:
535: If p_uom_code IS NOT NULL then -- When PJF team calls they pass p_uom_code
536: FOR rec_new_uom_1 IN cur_new_uom_1 ( p_uom_code )
537: LOOP
538: fnd_lookup_values_pkg.insert_row (
539: x_rowid => l_rowid,
540: x_lookup_type => 'UNIT',
541: x_security_group_id => l_security_group_id,
542: x_view_application_id => 275,

Line 576: fnd_lookup_values_pkg.insert_row (

572: END LOOP ;
573: else -- When PA calls p_uom_code will be NULL
574: FOR rec_new_uom IN cur_new_uom
575: LOOP
576: fnd_lookup_values_pkg.insert_row (
577: x_rowid => l_rowid,
578: x_lookup_type => 'UNIT',
579: x_security_group_id => l_security_group_id,
580: x_view_application_id => 275,

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

615: --------------------------- Update Existing UOMs ----------------------------
616: -------------------------------------------------------------------------------
617:
618:
619: /***** Update UOM Code in FND LOOKUP VALUES from PLSQL Tables. Here all ****/
620: /***** the UOM Codes where meaning is changed in MTL, will be updated to ****/
621: /***** Reflect the same in Lookups ****/
622: If p_uom_code IS NOT NULL then -- When PJF team calls they pass p_uom_code
623: FOR rec_chg_uom_code_1 IN cur_chg_uom_code_1(p_uom_code )

Line 625: fnd_lookup_values_pkg.update_row (

621: /***** Reflect the same in Lookups ****/
622: If p_uom_code IS NOT NULL then -- When PJF team calls they pass p_uom_code
623: FOR rec_chg_uom_code_1 IN cur_chg_uom_code_1(p_uom_code )
624: LOOP
625: fnd_lookup_values_pkg.update_row (
626: x_lookup_type => 'UNIT',
627: x_security_group_id => l_security_group_id,
628: x_view_application_id => 275,
629: x_lookup_code => rec_chg_uom_code_1.Uom_Code,

Line 663: fnd_lookup_values_pkg.update_row (

659: FOR rec_chg_uom_code IN cur_chg_uom_code
660: LOOP
661:
662: /* commented for bug 5624048
663: fnd_lookup_values_pkg.update_row (
664: x_lookup_type => 'UNIT',
665: x_security_group_id => l_security_group_id,
666: x_view_application_id => 275,
667: x_lookup_code => rec_chg_uom_code.Uom_Code,

Line 697: update_fnd_lookup_values (

693: x_last_update_login => l_conc_login_id
694: ) ; */
695:
696: /* changed the call for bug 5624048 */
697: update_fnd_lookup_values (
698: x_lookup_type => 'UNIT',
699: x_security_group_id => l_security_group_id,
700: x_view_application_id => 275,
701: x_lookup_code => rec_chg_uom_code.Uom_Code,

Line 738: fnd_lookup_values_pkg.update_row (

734:
735: If p_uom_code IS NOT NULL then -- When PJF team calls they pass p_uom_code
736: FOR rec_chg_uom_code_y IN cur_chg_uom_code_y(p_uom_code )
737: LOOP
738: fnd_lookup_values_pkg.update_row (
739: x_lookup_type => 'UNIT',
740: x_security_group_id => l_security_group_id,
741: x_view_application_id => 275,
742: x_lookup_code => rec_chg_uom_code_y.Uom_Code,

Line 775: update_fnd_lookup_values (

771: else -- When PA calls p_uom_code will be NULL
772: FOR rec_chg_uom_code IN cur_chg_uom_code_x
773: LOOP
774: /* changed the call for bug 5624048 */
775: update_fnd_lookup_values (
776: x_lookup_type => 'UNIT',
777: x_security_group_id => l_security_group_id,
778: x_view_application_id => 275,
779: x_lookup_code => rec_chg_uom_code.Uom_Code,

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

808: END LOOP;
809:
810: end if;
811:
812: /***** Insert New UOM Code in FND LOOKUP VALUES from PLSQL Tables. Here ****/
813: /***** all the UOMs in MTL where Meaning meaning exists in Lookups but ****/
814: /***** corresponding Code is different, will be inserted to Reflect the ****/
815: /***** same in Lookups ****/
816:

Line 820: fnd_lookup_values_pkg.insert_row (

816:
817: If p_uom_code IS NOT NULL then -- When PJF team calls they pass p_uom_code
818: FOR rec_chg_uom_meaning_1 IN cur_chg_uom_meaning_1(p_uom_code )
819: LOOP
820: fnd_lookup_values_pkg.insert_row (
821: x_rowid => l_rowid,
822: x_lookup_type => 'UNIT',
823: x_security_group_id => l_security_group_id,
824: x_view_application_id => 275,

Line 859: fnd_lookup_values_pkg.insert_row (

855: else -- When PA calls p_uom_code will be NULL
856: FOR rec_chg_uom_meaning IN cur_chg_uom_meaning
857: LOOP
858:
859: fnd_lookup_values_pkg.insert_row (
860: x_rowid => l_rowid,
861: x_lookup_type => 'UNIT',
862: x_security_group_id => l_security_group_id,
863: x_view_application_id => 275,