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_B

Line 9: This api locks the row in pji_mt_measure_sets_b before updating

5: g_debug_mode VARCHAR2(1) := NVL(Fnd_Profile.value('PA_DEBUG_MODE'),'N');
6:
7:
8: /*==================================================================
9: This api locks the row in pji_mt_measure_sets_b before updating
10: ==================================================================*/
11:
12: PROCEDURE LOCK_ROW (
13: p_measure_set_code IN pji_mt_measure_sets_b.measure_set_code%TYPE,

Line 13: p_measure_set_code IN pji_mt_measure_sets_b.measure_set_code%TYPE,

9: This api locks the row in pji_mt_measure_sets_b before updating
10: ==================================================================*/
11:
12: PROCEDURE LOCK_ROW (
13: p_measure_set_code IN pji_mt_measure_sets_b.measure_set_code%TYPE,
14: p_object_version_number IN pji_mt_measure_sets_b.object_version_number%TYPE
15: ) IS
16:
17: CURSOR c IS

Line 14: p_object_version_number IN pji_mt_measure_sets_b.object_version_number%TYPE

10: ==================================================================*/
11:
12: PROCEDURE LOCK_ROW (
13: p_measure_set_code IN pji_mt_measure_sets_b.measure_set_code%TYPE,
14: p_object_version_number IN pji_mt_measure_sets_b.object_version_number%TYPE
15: ) IS
16:
17: CURSOR c IS
18: SELECT object_version_number

Line 19: FROM pji_mt_measure_sets_B

15: ) IS
16:
17: CURSOR c IS
18: SELECT object_version_number
19: FROM pji_mt_measure_sets_B
20: WHERE measure_set_code = p_measure_set_code
21: FOR UPDATE OF measure_set_code NOWAIT;
22:
23: recinfo c%ROWTYPE;

Line 48: p_measure_set_code IN pji_mt_measure_sets_b.measure_set_code%TYPE

44:
45: END LOCK_ROW;
46:
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;

Line 58: DELETE FROM pji_mt_measure_sets_b

54: IF (SQL%NOTFOUND) THEN
55: RAISE NO_DATA_FOUND;
56: END IF;
57:
58: DELETE FROM pji_mt_measure_sets_b
59: WHERE measure_set_code = p_measure_set_code;
60:
61: IF (SQL%NOTFOUND) THEN
62: RAISE NO_DATA_FOUND;

Line 69: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%TYPE,

65:
66:
67: PROCEDURE Insert_Row (
68: X_Rowid IN OUT NOCOPY ROWID,
69: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%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,

Line 70: X_Measure_Set_Type IN pji_mt_measure_sets_b.Measure_Set_Type%TYPE,

66:
67: PROCEDURE Insert_Row (
68: X_Rowid IN OUT NOCOPY ROWID,
69: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%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,

Line 71: X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,

67: PROCEDURE Insert_Row (
68: X_Rowid IN OUT NOCOPY ROWID,
69: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%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,

Line 72: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,

68: X_Rowid IN OUT NOCOPY ROWID,
69: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%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,

Line 73: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,

69: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%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,

Line 76: X_Last_Update_Date IN pji_mt_measure_sets_b.Last_Update_Date%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,
80: X_Last_Update_Login IN pji_mt_measure_sets_b.Last_Update_Login%TYPE,

Line 77: X_Last_Updated_by IN pji_mt_measure_sets_b.Last_Updated_by%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,
80: X_Last_Update_Login IN pji_mt_measure_sets_b.Last_Update_Login%TYPE,
81: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,

Line 78: X_Creation_Date IN pji_mt_measure_sets_b.Creation_Date%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,
80: X_Last_Update_Login IN pji_mt_measure_sets_b.Last_Update_Login%TYPE,
81: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,
82: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE,

Line 79: X_Created_By IN pji_mt_measure_sets_b.Created_By%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,
80: X_Last_Update_Login IN pji_mt_measure_sets_b.Last_Update_Login%TYPE,
81: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,
82: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE,
83: X_Return_Status OUT NOCOPY VARCHAR2,

Line 80: X_Last_Update_Login IN pji_mt_measure_sets_b.Last_Update_Login%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,
80: X_Last_Update_Login IN pji_mt_measure_sets_b.Last_Update_Login%TYPE,
81: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,
82: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE,
83: X_Return_Status OUT NOCOPY VARCHAR2,
84: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 81: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%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,
80: X_Last_Update_Login IN pji_mt_measure_sets_b.Last_Update_Login%TYPE,
81: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,
82: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE,
83: X_Return_Status OUT NOCOPY VARCHAR2,
84: X_Msg_Data OUT NOCOPY VARCHAR2,
85: X_Msg_Count OUT NOCOPY NUMBER

Line 82: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%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,
80: X_Last_Update_Login IN pji_mt_measure_sets_b.Last_Update_Login%TYPE,
81: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,
82: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE,
83: X_Return_Status OUT NOCOPY VARCHAR2,
84: X_Msg_Data OUT NOCOPY VARCHAR2,
85: X_Msg_Count OUT NOCOPY NUMBER
86: )IS

Line 88: CURSOR C IS SELECT ROWID FROM pji_mt_measure_sets_b

84: X_Msg_Data OUT NOCOPY VARCHAR2,
85: X_Msg_Count OUT NOCOPY NUMBER
86: )IS
87:
88: CURSOR C IS SELECT ROWID FROM pji_mt_measure_sets_b
89: WHERE measure_set_code = x_measure_set_code;
90:
91: l_return_status VARCHAR2(1) := NULL;
92: l_msg_count NUMBER := 0;

Line 108: Pa_Debug.g_err_stage:= 'Inserting record in pji_mt_measure_sets_B '||X_Measure_Set_Code;

104: p_debug_mode => g_debug_mode );
105: END IF;
106:
107: IF g_debug_mode = 'Y' THEN
108: Pa_Debug.g_err_stage:= 'Inserting record in pji_mt_measure_sets_B '||X_Measure_Set_Code;
109: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
110: Pa_Fp_Constants_Pkg.g_debug_level3);
111: END IF;
112:

Line 113: INSERT INTO pji_mt_measure_sets_B

109: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,
110: Pa_Fp_Constants_Pkg.g_debug_level3);
111: END IF;
112:
113: INSERT INTO pji_mt_measure_sets_B
114: (
115: Measure_Set_Code
116: , Measure_Set_Type
117: , Measure_Format

Line 248: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%TYPE,

244: END Insert_Row;
245:
246:
247: PROCEDURE Update_Row (
248: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%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,

Line 249: X_Measure_Set_Type IN pji_mt_measure_sets_b.Measure_Set_Type%TYPE,

245:
246:
247: PROCEDURE Update_Row (
248: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%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,

Line 250: X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,

246:
247: PROCEDURE Update_Row (
248: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%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,

Line 251: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,

247: PROCEDURE Update_Row (
248: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%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,

Line 252: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,

248: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%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,

Line 255: X_Last_Update_Date IN pji_mt_measure_sets_b.Last_Update_Date%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,
259: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE,

Line 256: X_Last_Updated_by IN pji_mt_measure_sets_b.Last_Updated_by%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,
259: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE,
260: X_Return_Status OUT NOCOPY VARCHAR2,

Line 257: X_Last_Update_Login IN pji_mt_measure_sets_b.Last_Update_Login%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,
259: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE,
260: X_Return_Status OUT NOCOPY VARCHAR2,
261: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 258: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%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,
259: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE,
260: X_Return_Status OUT NOCOPY VARCHAR2,
261: X_Msg_Data OUT NOCOPY VARCHAR2,
262: X_Msg_Count OUT NOCOPY NUMBER

Line 259: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%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,
259: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE,
260: X_Return_Status OUT NOCOPY VARCHAR2,
261: X_Msg_Data OUT NOCOPY VARCHAR2,
262: X_Msg_Count OUT NOCOPY NUMBER
263: ) IS

Line 283: Pa_Debug.g_err_stage:= 'Updating pji_mt_measure_sets_b for '||X_measure_set_code;

279: p_debug_mode => g_debug_mode );
280: END IF;
281:
282: IF g_debug_mode = 'Y' THEN
283: Pa_Debug.g_err_stage:= 'Updating pji_mt_measure_sets_b for '||X_measure_set_code;
284: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage,Pa_Fp_Constants_Pkg.g_debug_level3);
285: END IF;
286:
287: BEGIN

Line 290: FROM pji_mt_measure_sets_B

286:
287: BEGIN
288: SELECT object_version_number
289: INTO l_object_version_number
290: FROM pji_mt_measure_sets_B
291: WHERE measure_set_code = X_measure_set_code FOR UPDATE;
292: EXCEPTION
293: WHEN TOO_MANY_ROWS OR NO_DATA_FOUND THEN
294: IF g_debug_mode = 'Y' THEN

Line 295: Pa_Debug.g_err_stage:= 'select error while checking object version number in pji_mt_measure_sets_B '||X_measure_set_code;

291: WHERE measure_set_code = X_measure_set_code FOR UPDATE;
292: EXCEPTION
293: WHEN TOO_MANY_ROWS OR NO_DATA_FOUND THEN
294: IF g_debug_mode = 'Y' THEN
295: Pa_Debug.g_err_stage:= 'select error while checking object version number in pji_mt_measure_sets_B '||X_measure_set_code;
296: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level5);
297: END IF;
298: RAISE;
299: END;

Line 311: UPDATE pji_mt_measure_sets_B

307: l_object_version_number := X_Object_Version_Number + 1;
308: END IF;
309: END IF;
310:
311: UPDATE pji_mt_measure_sets_B
312: SET
313: Measure_Set_Code = X_Measure_Set_Code
314: , Measure_Set_Type = X_Measure_Set_Type
315: , Measure_Format = X_Measure_Format

Line 327: Pa_Debug.g_err_stage:= 'NDF while updating pji_mt_measure_sets_B '||X_measure_set_code;

323: WHERE measure_set_code = X_measure_set_code;
324:
325: IF (SQL%NOTFOUND) THEN
326: IF g_debug_mode = 'Y' THEN
327: Pa_Debug.g_err_stage:= 'NDF while updating pji_mt_measure_sets_B '||X_measure_set_code;
328: Pa_Debug.WRITE(g_module_name,Pa_Debug.g_err_stage, Pa_Fp_Constants_Pkg.g_debug_level5);
329: END IF;
330:
331: RAISE NO_DATA_FOUND;

Line 407: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%TYPE,

403: RAISE;
404: END Update_Row;
405:
406: PROCEDURE Load_Row (
407: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%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,

Line 408: X_Measure_Set_Type IN pji_mt_measure_sets_b.Measure_Set_Type%TYPE,

404: END Update_Row;
405:
406: PROCEDURE Load_Row (
407: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%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,

Line 409: X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,

405:
406: PROCEDURE Load_Row (
407: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%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,

Line 410: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,

406: PROCEDURE Load_Row (
407: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%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,

Line 411: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,

407: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%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,

Line 415: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%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: )
418: IS
419:

Line 416: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%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: )
418: IS
419:
420: User_Id NUMBER := NULL;

Line 508: FROM pji_mt_measure_sets_b B

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
510: );
511:
512: UPDATE pji_mt_measure_sets_tl T SET (

Line 570: X_measure_set_code IN pji_mt_measure_sets_b.measure_set_code%TYPE,

566: END ADD_LANGUAGE;
567:
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