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_B

Line 12: -- This api locks the row in Pji_Mt_Measures_B before updating

8: g_module_name VARCHAR2(100) := 'pa.plsql.pji_mt_measures_pkg';
9: g_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
10:
11: -- -----------------------------------------------------------------------
12: -- This api locks the row in Pji_Mt_Measures_B before updating
13: -- -----------------------------------------------------------------------
14:
15: procedure LOCK_ROW (
16: p_measure_id IN pji_mt_measures_b.measure_id%TYPE,

Line 16: p_measure_id IN pji_mt_measures_b.measure_id%TYPE,

12: -- This api locks the row in Pji_Mt_Measures_B before updating
13: -- -----------------------------------------------------------------------
14:
15: procedure LOCK_ROW (
16: p_measure_id IN pji_mt_measures_b.measure_id%TYPE,
17: p_OBJECT_VERSION_NUMBER IN pji_mt_measures_b.OBJECT_VERSION_NUMBER%TYPE
18: ) is
19:
20: cursor c is

Line 17: p_OBJECT_VERSION_NUMBER IN pji_mt_measures_b.OBJECT_VERSION_NUMBER%TYPE

13: -- -----------------------------------------------------------------------
14:
15: procedure LOCK_ROW (
16: p_measure_id IN pji_mt_measures_b.measure_id%TYPE,
17: p_OBJECT_VERSION_NUMBER IN pji_mt_measures_b.OBJECT_VERSION_NUMBER%TYPE
18: ) is
19:
20: cursor c is
21: select OBJECT_VERSION_NUMBER

Line 22: from PJI_MT_MEASURES_B

18: ) is
19:
20: cursor c is
21: select OBJECT_VERSION_NUMBER
22: from PJI_MT_MEASURES_B
23: where MEASURE_ID = p_measure_id
24: for update of measure_id nowait;
25:
26: recinfo c%rowtype;

Line 54: p_measure_id IN pji_mt_measures_b.measure_id%TYPE

50:
51: -- -----------------------------------------------------------------------
52:
53: procedure DELETE_ROW (
54: p_measure_id IN pji_mt_measures_b.measure_id%TYPE
55: ) is
56:
57:
58: begin

Line 66: delete from PJI_MT_MEASURES_B

62: if (sql%notfound) then
63: raise no_data_found;
64: end if;
65:
66: delete from PJI_MT_MEASURES_B
67: where measure_id = p_measure_id;
68:
69: if (sql%notfound) then
70: raise no_data_found;

Line 82: X_measure_id IN pji_mt_measures_b.measure_id%type,

78: procedure INSERT_ROW(
79:
80: X_rowid IN OUT NOCOPY rowid,
81:
82: X_measure_id IN pji_mt_measures_b.measure_id%type,
83:
84: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
85: X_measure_code IN pji_mt_measures_b.measure_code%type,
86: X_xtd_type IN pji_mt_measures_b.xtd_type%type,

Line 84: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,

80: X_rowid IN OUT NOCOPY rowid,
81:
82: X_measure_id IN pji_mt_measures_b.measure_id%type,
83:
84: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
85: X_measure_code IN pji_mt_measures_b.measure_code%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,

Line 85: X_measure_code IN pji_mt_measures_b.measure_code%type,

81:
82: X_measure_id IN pji_mt_measures_b.measure_id%type,
83:
84: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
85: X_measure_code IN pji_mt_measures_b.measure_code%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:

Line 86: X_xtd_type IN pji_mt_measures_b.xtd_type%type,

82: X_measure_id IN pji_mt_measures_b.measure_id%type,
83:
84: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
85: X_measure_code IN pji_mt_measures_b.measure_code%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,

Line 87: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,

83:
84: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
85: X_measure_code IN pji_mt_measures_b.measure_code%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,

Line 88: X_object_version_number IN pji_mt_measures_b.object_version_number%type,

84: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
85: X_measure_code IN pji_mt_measures_b.measure_code%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:

Line 93: X_last_update_date IN pji_mt_measures_b.last_update_date%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,
96: X_created_by IN pji_mt_measures_b.created_by%Type,
97: X_last_update_Login IN pji_mt_measures_b.last_update_Login%Type,

Line 94: X_last_updated_by IN pji_mt_measures_b.last_updated_by%Type,

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,
96: X_created_by IN pji_mt_measures_b.created_by%Type,
97: X_last_update_Login IN pji_mt_measures_b.last_update_Login%Type,
98:

Line 95: X_creation_date IN pji_mt_measures_b.creation_date%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,
96: X_created_by IN pji_mt_measures_b.created_by%Type,
97: X_last_update_Login IN pji_mt_measures_b.last_update_Login%Type,
98:
99: X_return_status OUT NOCOPY VARCHAR2,

Line 96: X_created_by IN pji_mt_measures_b.created_by%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,
96: X_created_by IN pji_mt_measures_b.created_by%Type,
97: X_last_update_Login IN pji_mt_measures_b.last_update_Login%Type,
98:
99: X_return_status OUT NOCOPY VARCHAR2,
100: X_msg_data OUT NOCOPY VARCHAR2,

Line 97: X_last_update_Login IN pji_mt_measures_b.last_update_Login%Type,

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,
96: X_created_by IN pji_mt_measures_b.created_by%Type,
97: X_last_update_Login IN pji_mt_measures_b.last_update_Login%Type,
98:
99: X_return_status OUT NOCOPY VARCHAR2,
100: X_msg_data OUT NOCOPY VARCHAR2,
101: X_msg_count OUT NOCOPY NUMBER

Line 105: l_measure_id pji_mt_measures_b.MEASURE_ID%type;

101: X_msg_count OUT NOCOPY NUMBER
102:
103: ) is
104:
105: l_measure_id pji_mt_measures_b.MEASURE_ID%type;
106:
107: cursor C is select ROWID from pji_mt_measures_b
108: where MEASURE_ID = l_measure_id;
109:

Line 107: cursor C is select ROWID from pji_mt_measures_b

103: ) is
104:
105: l_measure_id pji_mt_measures_b.MEASURE_ID%type;
106:
107: cursor C is select ROWID from pji_mt_measures_b
108: where MEASURE_ID = l_measure_id;
109:
110: l_return_status VARCHAR2(1) := NULL;
111: l_msg_count NUMBER := 0;

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

128: into l_measure_id
129: from dual;
130:
131: IF g_debug_mode = 'Y' THEN
132: pa_debug.g_err_stage:= 'Inserting record in pji_mt_measures_b'||to_char(l_measure_id);
133: pa_debug.write(g_module_name,pa_debug.g_err_stage,
134: pa_fp_constants_pkg.g_debug_level3);
135: END IF;
136:

Line 137: INSERT INTO Pji_Mt_Measures_B

133: pa_debug.write(g_module_name,pa_debug.g_err_stage,
134: pa_fp_constants_pkg.g_debug_level3);
135: END IF;
136:
137: INSERT INTO Pji_Mt_Measures_B
138: (
139: measure_id,
140: measure_set_code,
141: measure_code,

Line 280: X_measure_id IN pji_mt_measures_b.measure_id%type,

276: -- -----------------------------------------------------------------------
277:
278: procedure UPDATE_ROW (
279:
280: X_measure_id IN pji_mt_measures_b.measure_id%type,
281: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
282: X_measure_code IN pji_mt_measures_b.measure_code%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,

Line 281: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,

277:
278: procedure UPDATE_ROW (
279:
280: X_measure_id IN pji_mt_measures_b.measure_id%type,
281: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
282: X_measure_code IN pji_mt_measures_b.measure_code%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,

Line 282: X_measure_code IN pji_mt_measures_b.measure_code%type,

278: procedure UPDATE_ROW (
279:
280: X_measure_id IN pji_mt_measures_b.measure_id%type,
281: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
282: X_measure_code IN pji_mt_measures_b.measure_code%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:

Line 283: X_xtd_type IN pji_mt_measures_b.xtd_type%type,

279:
280: X_measure_id IN pji_mt_measures_b.measure_id%type,
281: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
282: X_measure_code IN pji_mt_measures_b.measure_code%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,

Line 284: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,

280: X_measure_id IN pji_mt_measures_b.measure_id%type,
281: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
282: X_measure_code IN pji_mt_measures_b.measure_code%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,

Line 285: X_object_version_number IN pji_mt_measures_b.object_version_number%type,

281: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
282: X_measure_code IN pji_mt_measures_b.measure_code%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:

Line 290: X_last_update_date IN pji_mt_measures_b.last_update_date%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,
293:
294: X_return_status OUT NOCOPY VARCHAR2,

Line 291: X_last_updated_by IN pji_mt_measures_b.last_updated_by%Type,

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,
293:
294: X_return_status OUT NOCOPY VARCHAR2,
295: X_msg_data OUT NOCOPY VARCHAR2,

Line 292: X_last_update_login IN pji_mt_measures_b.last_update_login%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,
293:
294: X_return_status OUT NOCOPY VARCHAR2,
295: X_msg_data OUT NOCOPY VARCHAR2,
296: X_msg_count OUT NOCOPY NUMBER

Line 319: pa_debug.g_err_stage:= 'Updating Pji_Mt_Measures_B for'||to_char(X_measure_id);

315: p_debug_mode => g_debug_mode );
316: END IF;
317:
318: IF g_debug_mode = 'Y' THEN
319: pa_debug.g_err_stage:= 'Updating Pji_Mt_Measures_B for'||to_char(X_measure_id);
320: pa_debug.write(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
321: END IF;
322:
323: UPDATE Pji_Mt_Measures_B

Line 323: UPDATE Pji_Mt_Measures_B

319: pa_debug.g_err_stage:= 'Updating Pji_Mt_Measures_B for'||to_char(X_measure_id);
320: pa_debug.write(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
321: END IF;
322:
323: UPDATE Pji_Mt_Measures_B
324: SET
325:
326: measure_set_code = X_measure_set_code,
327: measure_code = X_measure_code,

Line 336: pa_debug.g_err_stage:= 'NDF while updating Pji_Mt_Measures_B'||to_char(X_measure_id);

332: where Measure_Id = X_Measure_Id;
333:
334: IF (SQL%NOTFOUND) THEN
335: IF g_debug_mode = 'Y' THEN
336: pa_debug.g_err_stage:= 'NDF while updating Pji_Mt_Measures_B'||to_char(X_measure_id);
337: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);
338: END IF;
339: RAISE NO_DATA_FOUND;
340: END IF;

Line 418: X_measure_id IN pji_mt_measures_b.measure_id%type,

414: -- -----------------------------------------------------------------------
415:
416: procedure LOAD_ROW (
417:
418: X_measure_id IN pji_mt_measures_b.measure_id%type,
419:
420: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
421: X_measure_code IN pji_mt_measures_b.measure_code%type,
422: X_xtd_type IN pji_mt_measures_b.xtd_type%type,

Line 420: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,

416: procedure LOAD_ROW (
417:
418: X_measure_id IN pji_mt_measures_b.measure_id%type,
419:
420: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
421: X_measure_code IN pji_mt_measures_b.measure_code%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,

Line 421: X_measure_code IN pji_mt_measures_b.measure_code%type,

417:
418: X_measure_id IN pji_mt_measures_b.measure_id%type,
419:
420: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
421: X_measure_code IN pji_mt_measures_b.measure_code%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:

Line 422: X_xtd_type IN pji_mt_measures_b.xtd_type%type,

418: X_measure_id IN pji_mt_measures_b.measure_id%type,
419:
420: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
421: X_measure_code IN pji_mt_measures_b.measure_code%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,

Line 423: X_pl_sql_api IN pji_mt_measures_b.pl_sql_api%type,

419:
420: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
421: X_measure_code IN pji_mt_measures_b.measure_code%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,

Line 424: X_object_version_number IN pji_mt_measures_b.object_version_number%type,

420: X_measure_set_code IN pji_mt_measures_b.measure_set_code%type,
421: X_measure_code IN pji_mt_measures_b.measure_code%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:

Line 540: from PJI_MT_MEASURES_B B

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
542: );
543:
544: update PJI_MT_MEASURES_TL T set (

Line 615: X_MEASURE_ID in PJI_MT_MEASURES_B.MEASURE_ID%TYPE,

611: -- -----------------------------------------------------------------------
612:
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: