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.PJI_MT_MEASURE_SETS_PKG dependencies on PJI_MT_MEASURE_SETS_TL

Line 51: DELETE FROM pji_mt_measure_sets_TL

47: PROCEDURE DELETE_ROW (
48: p_measure_set_code IN pji_mt_measure_sets_b.measure_set_code%TYPE
49: ) IS
50: BEGIN
51: DELETE FROM pji_mt_measure_sets_TL
52: WHERE measure_set_code = p_measure_set_code;
53:
54: IF (SQL%NOTFOUND) THEN
55: RAISE NO_DATA_FOUND;

Line 74: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,

70: X_Measure_Set_Type IN pji_mt_measure_sets_b.Measure_Set_Type%TYPE,
71: X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,
72: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
73: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
74: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
75: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
76: X_Last_Update_Date IN pji_mt_measure_sets_b.Last_Update_Date%TYPE,
77: X_Last_Updated_by IN pji_mt_measure_sets_b.Last_Updated_by%TYPE,
78: X_Creation_Date IN pji_mt_measure_sets_b.Creation_Date%TYPE,

Line 75: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,

71: X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,
72: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
73: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
74: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
75: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
76: X_Last_Update_Date IN pji_mt_measure_sets_b.Last_Update_Date%TYPE,
77: X_Last_Updated_by IN pji_mt_measure_sets_b.Last_Updated_by%TYPE,
78: X_Creation_Date IN pji_mt_measure_sets_b.Creation_Date%TYPE,
79: X_Created_By IN pji_mt_measure_sets_b.Created_By%TYPE,

Line 144: Pa_Debug.g_err_stage:= 'Inserting record in pji_mt_measure_sets_tl '||X_Measure_Set_Code;

140: , X_Measure_Source
141: );
142:
143: IF g_debug_mode = 'Y' THEN
144: Pa_Debug.g_err_stage:= 'Inserting record in pji_mt_measure_sets_tl '||X_Measure_Set_Code;
145: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level3);
146: END IF;
147:
148: INSERT INTO pji_mt_measure_sets_tl

Line 148: INSERT INTO pji_mt_measure_sets_tl

144: Pa_Debug.g_err_stage:= 'Inserting record in pji_mt_measure_sets_tl '||X_Measure_Set_Code;
145: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level3);
146: END IF;
147:
148: INSERT INTO pji_mt_measure_sets_tl
149: (
150: Measure_Set_Code,
151: Name,
152: Description,

Line 175: (SELECT NULL FROM pji_mt_measure_sets_tl T

171: USERENV('Lang')
172: FROM Fnd_Languages L
173: WHERE L.Installed_Flag IN ('I', 'B')
174: AND NOT EXISTS
175: (SELECT NULL FROM pji_mt_measure_sets_tl T
176: WHERE T.measure_set_code = X_Measure_Set_Code
177: AND T.LANGUAGE = L.Language_Code);
178:
179: Hr_Utility.trace('after inserting t row');

Line 253: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,

249: X_Measure_Set_Type IN pji_mt_measure_sets_b.Measure_Set_Type%TYPE,
250: X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,
251: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
252: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
253: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
254: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
255: X_Last_Update_Date IN pji_mt_measure_sets_b.Last_Update_Date%TYPE,
256: X_Last_Updated_by IN pji_mt_measure_sets_b.Last_Updated_by%TYPE,
257: X_Last_Update_Login IN pji_mt_measure_sets_b.Last_Update_Login%TYPE,

Line 254: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,

250: X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,
251: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
252: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
253: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
254: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
255: X_Last_Update_Date IN pji_mt_measure_sets_b.Last_Update_Date%TYPE,
256: X_Last_Updated_by IN pji_mt_measure_sets_b.Last_Updated_by%TYPE,
257: X_Last_Update_Login IN pji_mt_measure_sets_b.Last_Update_Login%TYPE,
258: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,

Line 335: Pa_Debug.g_err_stage:= 'Updating pji_mt_measure_sets_tl for '||X_measure_set_code;

331: RAISE NO_DATA_FOUND;
332: END IF;
333:
334: IF g_debug_mode = 'Y' THEN
335: Pa_Debug.g_err_stage:= 'Updating pji_mt_measure_sets_tl for '||X_measure_set_code;
336: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,Pa_Fp_Constants_Pkg.g_debug_level3);
337: END IF;
338:
339: UPDATE pji_mt_measure_sets_tl

Line 339: UPDATE pji_mt_measure_sets_tl

335: Pa_Debug.g_err_stage:= 'Updating pji_mt_measure_sets_tl for '||X_measure_set_code;
336: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,Pa_Fp_Constants_Pkg.g_debug_level3);
337: END IF;
338:
339: UPDATE pji_mt_measure_sets_tl
340: SET Name = X_Name,
341: Description = X_Description,
342: Last_Update_Date = X_Last_Update_Date,
343: Last_Updated_By = X_Last_Updated_By,

Line 412: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,

408: X_Measure_Set_Type IN pji_mt_measure_sets_b.Measure_Set_Type%TYPE,
409: X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,
410: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
411: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
412: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
413: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
414: X_Owner IN VARCHAR2,
415: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,
416: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE

Line 413: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,

409: X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,
410: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
411: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
412: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
413: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
414: X_Owner IN VARCHAR2,
415: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,
416: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE
417: )

Line 505: DELETE FROM pji_mt_measure_sets_tl T

501: PROCEDURE Add_Language
502: IS
503: BEGIN
504:
505: DELETE FROM pji_mt_measure_sets_tl T
506: WHERE NOT EXISTS
507: (SELECT NULL
508: FROM pji_mt_measure_sets_b B
509: WHERE B.measure_set_code = T.measure_set_code

Line 512: UPDATE pji_mt_measure_sets_tl T SET (

508: FROM pji_mt_measure_sets_b B
509: WHERE B.measure_set_code = T.measure_set_code
510: );
511:
512: UPDATE pji_mt_measure_sets_tl T SET (
513: NAME,
514: DESCRIPTION
515: ) = (SELECT
516: B.NAME,

Line 518: FROM pji_mt_measure_sets_tl B

514: DESCRIPTION
515: ) = (SELECT
516: B.NAME,
517: B.DESCRIPTION
518: FROM pji_mt_measure_sets_tl B
519: WHERE B.measure_set_code = T.measure_set_code
520: AND B.LANGUAGE = T.SOURCE_LANG)
521: WHERE (
522: T.measure_set_code,

Line 527: FROM pji_mt_measure_sets_tl SUBB, pji_mt_measure_sets_tl SUBT

523: T.LANGUAGE
524: ) IN (SELECT
525: SUBT.measure_set_code,
526: SUBT.LANGUAGE
527: FROM pji_mt_measure_sets_tl SUBB, pji_mt_measure_sets_tl SUBT
528: WHERE SUBB.measure_set_code = SUBT.measure_set_code
529: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
530: AND (SUBB.NAME <> SUBT.NAME
531: OR SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 536: INSERT INTO pji_mt_measure_sets_tl(

532: OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
533: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
534: ));
535:
536: INSERT INTO pji_mt_measure_sets_tl(
537: LAST_UPDATE_LOGIN,
538: CREATION_DATE,
539: CREATED_BY,
540: LAST_UPDATE_DATE,

Line 558: FROM pji_mt_measure_sets_tl B, FND_LANGUAGES L

554: B.NAME,
555: B.DESCRIPTION,
556: L.LANGUAGE_CODE,
557: B.SOURCE_LANG
558: FROM pji_mt_measure_sets_tl B, FND_LANGUAGES L
559: WHERE L.INSTALLED_FLAG IN ('I', 'B')
560: AND B.LANGUAGE = USERENV('LANG')
561: AND NOT EXISTS
562: (SELECT NULL

Line 563: FROM pji_mt_measure_sets_tl T

559: WHERE L.INSTALLED_FLAG IN ('I', 'B')
560: AND B.LANGUAGE = USERENV('LANG')
561: AND NOT EXISTS
562: (SELECT NULL
563: FROM pji_mt_measure_sets_tl T
564: WHERE T.measure_set_code = B.measure_set_code
565: AND T.LANGUAGE = L.LANGUAGE_CODE);
566: END ADD_LANGUAGE;
567:

Line 572: X_name IN pji_mt_measure_sets_TL.NAME%TYPE,

568:
569: PROCEDURE TRANSLATE_ROW (
570: X_measure_set_code IN pji_mt_measure_sets_b.measure_set_code%TYPE,
571: X_owner IN VARCHAR2 ,
572: X_name IN pji_mt_measure_sets_TL.NAME%TYPE,
573: X_description IN pji_mt_measure_sets_TL.DESCRIPTION%TYPE
574: )IS
575: BEGIN
576:

Line 573: X_description IN pji_mt_measure_sets_TL.DESCRIPTION%TYPE

569: PROCEDURE TRANSLATE_ROW (
570: X_measure_set_code IN pji_mt_measure_sets_b.measure_set_code%TYPE,
571: X_owner IN VARCHAR2 ,
572: X_name IN pji_mt_measure_sets_TL.NAME%TYPE,
573: X_description IN pji_mt_measure_sets_TL.DESCRIPTION%TYPE
574: )IS
575: BEGIN
576:
577: g_debug_mode:='N';

Line 579: UPDATE pji_mt_measure_sets_tl SET

575: BEGIN
576:
577: g_debug_mode:='N';
578:
579: UPDATE pji_mt_measure_sets_tl SET
580: NAME = X_NAME,
581: DESCRIPTION = X_DESCRIPTION,
582: LAST_UPDATE_DATE = SYSDATE,
583: LAST_UPDATED_BY = DECODE(X_OWNER, 'SEED', 1, 0),