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_ROWSET_PKG dependencies on PJI_MT_ROWSET_B

Line 8: This api locks the row in pji_mt_rowset_b before updating

4: g_module_name VARCHAR2(100) := 'pa.plsql.pji_mt_rowset_pkg';
5: g_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
6:
7: /*==================================================================
8: This api locks the row in pji_mt_rowset_b before updating
9: ==================================================================*/
10:
11: PROCEDURE LOCK_ROW (
12: p_rowset_code IN pji_mt_rowset_b.rowset_code%TYPE,

Line 12: p_rowset_code IN pji_mt_rowset_b.rowset_code%TYPE,

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

Line 13: p_object_version_number IN pji_mt_rowset_b.object_version_number%TYPE

9: ==================================================================*/
10:
11: PROCEDURE LOCK_ROW (
12: p_rowset_code IN pji_mt_rowset_b.rowset_code%TYPE,
13: p_object_version_number IN pji_mt_rowset_b.object_version_number%TYPE
14: ) IS
15:
16: CURSOR c IS
17: SELECT object_version_number

Line 18: FROM pji_mt_rowset_b

14: ) IS
15:
16: CURSOR c IS
17: SELECT object_version_number
18: FROM pji_mt_rowset_b
19: WHERE rowset_code = p_rowset_code
20: FOR UPDATE OF rowset_code NOWAIT;
21:
22: recinfo c%ROWTYPE;

Line 47: p_rowset_code IN pji_mt_rowset_b.rowset_code%TYPE

43:
44: END LOCK_ROW;
45:
46: PROCEDURE DELETE_ROW (
47: p_rowset_code IN pji_mt_rowset_b.rowset_code%TYPE
48: ) IS
49: BEGIN
50: DELETE FROM pji_mt_rowset_TL
51: WHERE rowset_code = p_rowset_code;

Line 57: DELETE FROM pji_mt_rowset_B

53: IF (SQL%NOTFOUND) THEN
54: RAISE NO_DATA_FOUND;
55: END IF;
56:
57: DELETE FROM pji_mt_rowset_B
58: WHERE rowset_code = p_rowset_code;
59:
60: IF (SQL%NOTFOUND) THEN
61: RAISE NO_DATA_FOUND;

Line 68: X_rowset_Code IN pji_mt_rowset_b.Rowset_Code%TYPE,

64:
65:
66: PROCEDURE Insert_Row (
67: X_Rowid IN OUT NOCOPY ROWID,
68: X_rowset_Code IN pji_mt_rowset_b.Rowset_Code%TYPE,
69: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
70: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
71: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
72: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,

Line 69: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,

65:
66: PROCEDURE Insert_Row (
67: X_Rowid IN OUT NOCOPY ROWID,
68: X_rowset_Code IN pji_mt_rowset_b.Rowset_Code%TYPE,
69: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
70: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
71: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
72: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
73: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,

Line 72: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,

68: X_rowset_Code IN pji_mt_rowset_b.Rowset_Code%TYPE,
69: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
70: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
71: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
72: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
73: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,
74: X_Creation_Date IN pji_mt_rowset_b.Creation_Date%TYPE,
75: X_Created_By IN pji_mt_rowset_b.Created_By%TYPE,
76: X_Last_Update_Login IN pji_mt_rowset_b.Last_Update_Login%TYPE,

Line 73: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,

69: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
70: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
71: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
72: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
73: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,
74: X_Creation_Date IN pji_mt_rowset_b.Creation_Date%TYPE,
75: X_Created_By IN pji_mt_rowset_b.Created_By%TYPE,
76: X_Last_Update_Login IN pji_mt_rowset_b.Last_Update_Login%TYPE,
77: X_Return_Status OUT NOCOPY VARCHAR2,

Line 74: X_Creation_Date IN pji_mt_rowset_b.Creation_Date%TYPE,

70: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
71: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
72: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
73: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,
74: X_Creation_Date IN pji_mt_rowset_b.Creation_Date%TYPE,
75: X_Created_By IN pji_mt_rowset_b.Created_By%TYPE,
76: X_Last_Update_Login IN pji_mt_rowset_b.Last_Update_Login%TYPE,
77: X_Return_Status OUT NOCOPY VARCHAR2,
78: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 75: X_Created_By IN pji_mt_rowset_b.Created_By%TYPE,

71: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
72: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
73: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,
74: X_Creation_Date IN pji_mt_rowset_b.Creation_Date%TYPE,
75: X_Created_By IN pji_mt_rowset_b.Created_By%TYPE,
76: X_Last_Update_Login IN pji_mt_rowset_b.Last_Update_Login%TYPE,
77: X_Return_Status OUT NOCOPY VARCHAR2,
78: X_Msg_Data OUT NOCOPY VARCHAR2,
79: X_Msg_Count OUT NOCOPY NUMBER

Line 76: X_Last_Update_Login IN pji_mt_rowset_b.Last_Update_Login%TYPE,

72: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
73: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,
74: X_Creation_Date IN pji_mt_rowset_b.Creation_Date%TYPE,
75: X_Created_By IN pji_mt_rowset_b.Created_By%TYPE,
76: X_Last_Update_Login IN pji_mt_rowset_b.Last_Update_Login%TYPE,
77: X_Return_Status OUT NOCOPY VARCHAR2,
78: X_Msg_Data OUT NOCOPY VARCHAR2,
79: X_Msg_Count OUT NOCOPY NUMBER
80: ) IS

Line 82: CURSOR C IS SELECT ROWID FROM pji_mt_rowset_b

78: X_Msg_Data OUT NOCOPY VARCHAR2,
79: X_Msg_Count OUT NOCOPY NUMBER
80: ) IS
81:
82: CURSOR C IS SELECT ROWID FROM pji_mt_rowset_b
83: WHERE rowset_code = x_rowset_code;
84:
85: l_return_status VARCHAR2(1) := NULL;
86: l_msg_count NUMBER := 0;

Line 103: pa_debug.g_err_stage:= 'Inserting record in pji_mt_rowset_B '||X_Rowset_Code;

99: p_debug_mode => g_debug_mode );
100: END IF;
101:
102: IF g_debug_mode = 'Y' THEN
103: pa_debug.g_err_stage:= 'Inserting record in pji_mt_rowset_B '||X_Rowset_Code;
104: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,
105: pa_fp_constants_pkg.g_debug_level3);
106: END IF;
107:

Line 108: INSERT INTO pji_mt_rowset_B

104: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,
105: pa_fp_constants_pkg.g_debug_level3);
106: END IF;
107:
108: INSERT INTO pji_mt_rowset_B
109: (
110: Rowset_Code
111: , Object_Version_Number
112: , Creation_Date

Line 228: X_Rowset_Code IN pji_mt_rowset_b.Rowset_Code%TYPE,

224: END Insert_Row;
225:
226:
227: PROCEDURE Update_Row (
228: X_Rowset_Code IN pji_mt_rowset_b.Rowset_Code%TYPE,
229: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
230: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
231: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
232: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,

Line 229: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,

225:
226:
227: PROCEDURE Update_Row (
228: X_Rowset_Code IN pji_mt_rowset_b.Rowset_Code%TYPE,
229: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
230: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
231: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
232: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
233: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,

Line 232: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,

228: X_Rowset_Code IN pji_mt_rowset_b.Rowset_Code%TYPE,
229: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
230: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
231: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
232: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
233: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,
234: X_Last_Update_Login IN pji_mt_rowset_b.Last_Update_Login%TYPE,
235: X_Lock_Flag IN VARCHAR2 DEFAULT 'true',
236: X_Return_Status OUT NOCOPY VARCHAR2,

Line 233: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,

229: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
230: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
231: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
232: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
233: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,
234: X_Last_Update_Login IN pji_mt_rowset_b.Last_Update_Login%TYPE,
235: X_Lock_Flag IN VARCHAR2 DEFAULT 'true',
236: X_Return_Status OUT NOCOPY VARCHAR2,
237: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 234: X_Last_Update_Login IN pji_mt_rowset_b.Last_Update_Login%TYPE,

230: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
231: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
232: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
233: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,
234: X_Last_Update_Login IN pji_mt_rowset_b.Last_Update_Login%TYPE,
235: X_Lock_Flag IN VARCHAR2 DEFAULT 'true',
236: X_Return_Status OUT NOCOPY VARCHAR2,
237: X_Msg_Data OUT NOCOPY VARCHAR2,
238: X_Msg_Count OUT NOCOPY NUMBER

Line 261: pa_debug.g_err_stage:= 'Updating pji_mt_rowset_b for'||X_Rowset_Code;

257: p_debug_mode => g_debug_mode );
258: END IF;
259:
260: IF g_debug_mode = 'Y' THEN
261: pa_debug.g_err_stage:= 'Updating pji_mt_rowset_b for'||X_Rowset_Code;
262: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
263: END IF;
264:
265: -- The lock row procedure need not be called when the update_row is called

Line 275: UPDATE pji_mt_rowset_B

271: END IF;
272:
273: l_object_version_number := l_object_version_number + 1;
274:
275: UPDATE pji_mt_rowset_B
276: SET
277: Rowset_Code = X_Rowset_Code
278: , Object_Version_Number = l_object_version_number
279: , Last_Update_Date = X_Last_Update_Date

Line 286: pa_debug.g_err_stage:= 'NDF while updating pji_mt_rowset_B '||X_Rowset_Code;

282: WHERE rowset_code = X_rowset_code;
283:
284: IF (SQL%NOTFOUND) THEN
285: IF g_debug_mode = 'Y' THEN
286: pa_debug.g_err_stage:= 'NDF while updating pji_mt_rowset_B '||X_Rowset_Code;
287: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);
288: END IF;
289: RAISE NO_DATA_FOUND;
290: END IF;

Line 367: X_Rowset_Code IN pji_mt_rowset_b.Rowset_Code%TYPE,

363:
364:
365:
366: PROCEDURE Load_Row (
367: X_Rowset_Code IN pji_mt_rowset_b.Rowset_Code%TYPE,
368: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
369: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
370: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
371: X_Owner IN VARCHAR2

Line 368: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,

364:
365:
366: PROCEDURE Load_Row (
367: X_Rowset_Code IN pji_mt_rowset_b.Rowset_Code%TYPE,
368: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
369: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
370: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
371: X_Owner IN VARCHAR2
372: )

Line 452: FROM pji_mt_rowset_B B

448:
449: DELETE FROM pji_mt_rowset_tl T
450: WHERE NOT EXISTS
451: (SELECT NULL
452: FROM pji_mt_rowset_B B
453: WHERE B.rowset_code = T.rowset_code
454: );
455:
456: UPDATE pji_mt_rowset_tl T SET (

Line 514: X_rowset_code IN pji_mt_rowset_b.rowset_code%TYPE,

510: END ADD_LANGUAGE;
511:
512:
513: PROCEDURE TRANSLATE_ROW (
514: X_rowset_code IN pji_mt_rowset_b.rowset_code%TYPE,
515: X_OWNER IN VARCHAR2 ,
516: X_NAME IN pji_mt_rowset_TL.NAME%TYPE,
517: X_DESCRIPTION IN pji_mt_rowset_TL.DESCRIPTION%TYPE
518: )IS