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_MEASURES_PKG dependencies on PJI_MT_MEASURES_TL

Line 59: delete from PJI_MT_MEASURES_TL

55: ) is
56:
57:
58: begin
59: delete from PJI_MT_MEASURES_TL
60: where measure_id = p_measure_id;
61:
62: if (sql%notfound) then
63: raise no_data_found;

Line 90: X_name IN pji_mt_measures_tl.name%type,

86: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
87: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
88: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
89:
90: X_name IN pji_mt_measures_tl.name%type,
91: X_description IN pji_mt_measures_tl.description%type,
92:
93: X_last_update_date IN pji_mt_measures_b.last_update_date%Type,
94: X_last_updated_by IN pji_mt_measures_b.last_updated_by%Type,

Line 91: X_description IN pji_mt_measures_tl.description%type,

87: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
88: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
89:
90: X_name IN pji_mt_measures_tl.name%type,
91: X_description IN pji_mt_measures_tl.description%type,
92:
93: X_last_update_date IN pji_mt_measures_b.last_update_date%Type,
94: X_last_updated_by IN pji_mt_measures_b.last_updated_by%Type,
95: X_creation_date IN pji_mt_measures_b.creation_date%Type,

Line 170: pa_debug.g_err_stage:= 'Inserting record in pji_mt_Measures_tl'||to_char(l_measure_id);

166: );
167:
168:
169: IF g_debug_mode = 'Y' THEN
170: pa_debug.g_err_stage:= 'Inserting record in pji_mt_Measures_tl'||to_char(l_measure_id);
171: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level3);
172:
173: END IF;
174:

Line 175: INSERT INTO pji_mt_measures_tl

171: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level3);
172:
173: END IF;
174:
175: INSERT INTO pji_mt_measures_tl
176: (
177: measure_id,
178:
179: name,

Line 209: (SELECT NULL FROM Pji_Mt_Measures_Tl T

205:
206: FROM Fnd_Languages L
207: WHERE L.Installed_Flag In ('I', 'B')
208: AND NOT EXISTS
209: (SELECT NULL FROM Pji_Mt_Measures_Tl T
210: WHERE T.Measure_Id = L_Measure_Id
211: AND T.Language = L.Language_Code);
212:
213: OPEN C;

Line 287: X_name IN pji_mt_measures_tl.name%type,

283: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
284: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
285: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
286:
287: X_name IN pji_mt_measures_tl.name%type,
288: X_description IN pji_mt_measures_tl.description%type,
289:
290: X_last_update_date IN pji_mt_measures_b.last_update_date%Type,
291: X_last_updated_by IN pji_mt_measures_b.last_updated_by%Type,

Line 288: X_description IN pji_mt_measures_tl.description%type,

284: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
285: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
286:
287: X_name IN pji_mt_measures_tl.name%type,
288: X_description IN pji_mt_measures_tl.description%type,
289:
290: X_last_update_date IN pji_mt_measures_b.last_update_date%Type,
291: X_last_updated_by IN pji_mt_measures_b.last_updated_by%Type,
292: X_last_update_login IN pji_mt_measures_b.last_update_login%Type,

Line 343: pa_debug.g_err_stage:= 'Updating Pji_Mt_Measures_Tl for'||to_char(X_measure_id);

339: RAISE NO_DATA_FOUND;
340: END IF;
341:
342: IF g_debug_mode = 'Y' THEN
343: pa_debug.g_err_stage:= 'Updating Pji_Mt_Measures_Tl for'||to_char(X_measure_id);
344: pa_debug.write(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
345: END IF;
346:
347: UPDATE Pji_Mt_Measures_Tl

Line 347: UPDATE Pji_Mt_Measures_Tl

343: pa_debug.g_err_stage:= 'Updating Pji_Mt_Measures_Tl for'||to_char(X_measure_id);
344: pa_debug.write(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
345: END IF;
346:
347: UPDATE Pji_Mt_Measures_Tl
348: SET
349: Name = X_Name,
350: Description = X_Description,
351: Last_Update_Date = X_Last_Update_Date,

Line 426: X_name IN pji_mt_measures_tl.name%type,

422: X_xtd_type IN pji_mt_measures_b.xtd_type%type,
423: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
424: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
425:
426: X_name IN pji_mt_measures_tl.name%type,
427: X_description IN pji_mt_measures_tl.description%type,
428:
429: X_owner IN VARCHAR2
430: ) IS

Line 427: X_description IN pji_mt_measures_tl.description%type,

423: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,
424: X_object_version_number IN pji_mt_measures_b.object_version_number%type,
425:
426: X_name IN pji_mt_measures_tl.name%type,
427: X_description IN pji_mt_measures_tl.description%type,
428:
429: X_owner IN VARCHAR2
430: ) IS
431:

Line 537: delete from PJI_MT_MEASURES_TL T

533: IS
534:
535: begin
536:
537: delete from PJI_MT_MEASURES_TL T
538: where not exists
539: (select NULL
540: from PJI_MT_MEASURES_B B
541: where B.MEASURE_ID = T.MEASURE_ID

Line 544: update PJI_MT_MEASURES_TL T set (

540: from PJI_MT_MEASURES_B B
541: where B.MEASURE_ID = T.MEASURE_ID
542: );
543:
544: update PJI_MT_MEASURES_TL T set (
545: NAME,
546: DESCRIPTION
547: ) = (select
548: B.NAME,

Line 550: from PJI_MT_MEASURES_TL B

546: DESCRIPTION
547: ) = (select
548: B.NAME,
549: B.DESCRIPTION
550: from PJI_MT_MEASURES_TL B
551: where B.MEASURE_ID = T.MEASURE_ID
552: and B.LANGUAGE = T.SOURCE_LANG)
553: where (
554: T.MEASURE_ID,

Line 559: from PJI_MT_MEASURES_TL SUBB, PJI_MT_MEASURES_TL SUBT

555: T.LANGUAGE
556: ) in (select
557: SUBT.MEASURE_ID,
558: SUBT.LANGUAGE
559: from PJI_MT_MEASURES_TL SUBB, PJI_MT_MEASURES_TL SUBT
560: where SUBB.MEASURE_ID = SUBT.MEASURE_ID
561: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
562: and (SUBB.NAME <> SUBT.NAME
563: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 568: insert into PJI_MT_MEASURES_TL (

564: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
565: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
566: ));
567:
568: insert into PJI_MT_MEASURES_TL (
569:
570: MEASURE_ID,
571:
572: NAME,

Line 599: from PJI_MT_MEASURES_TL B, FND_LANGUAGES L

595: B.CREATED_BY,
596: B.LAST_UPDATE_DATE,
597: B.LAST_UPDATED_BY
598:
599: from PJI_MT_MEASURES_TL B, FND_LANGUAGES L
600: where L.INSTALLED_FLAG in ('I', 'B')
601: and B.LANGUAGE = userenv('LANG')
602: and not exists
603: (select NULL

Line 604: from PJI_MT_MEASURES_TL T

600: where L.INSTALLED_FLAG in ('I', 'B')
601: and B.LANGUAGE = userenv('LANG')
602: and not exists
603: (select NULL
604: from PJI_MT_MEASURES_TL T
605: where T.MEASURE_ID = B.MEASURE_ID
606: and T.LANGUAGE = L.LANGUAGE_CODE);
607:
608: end ADD_LANGUAGE;

Line 617: X_NAME in PJI_MT_MEASURES_TL.NAME%TYPE,

613: procedure TRANSLATE_ROW (
614:
615: X_MEASURE_ID in PJI_MT_MEASURES_B.MEASURE_ID%TYPE,
616:
617: X_NAME in PJI_MT_MEASURES_TL.NAME%TYPE,
618: X_DESCRIPTION in PJI_MT_MEASURES_TL.DESCRIPTION%TYPE,
619:
620: X_OWNER in VARCHAR2
621:

Line 618: X_DESCRIPTION in PJI_MT_MEASURES_TL.DESCRIPTION%TYPE,

614:
615: X_MEASURE_ID in PJI_MT_MEASURES_B.MEASURE_ID%TYPE,
616:
617: X_NAME in PJI_MT_MEASURES_TL.NAME%TYPE,
618: X_DESCRIPTION in PJI_MT_MEASURES_TL.DESCRIPTION%TYPE,
619:
620: X_OWNER in VARCHAR2
621:
622: ) is

Line 630: update PJI_MT_MEASURES_TL set

626:
627: g_debug_mode := 'N';
628:
629:
630: update PJI_MT_MEASURES_TL set
631: NAME = X_NAME,
632: DESCRIPTION = X_DESCRIPTION,
633: LAST_UPDATE_DATE = sysdate,
634: LAST_UPDATED_BY = decode(X_OWNER, 'SEED', 1, 0),