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_DET_PKG dependencies on PJI_MT_ROWSET_DET

Line 1: PACKAGE BODY PJI_MT_ROWSET_DET_PKG AS

1: PACKAGE BODY PJI_MT_ROWSET_DET_PKG AS
2: /* $Header: PJIMTRDB.pls 120.1 2005/05/31 08:01:34 appldev $ */
3:
4: g_module_name VARCHAR2(100) := 'pa.plsql.pji_mt_rowset_det_pkg';
5: g_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

Line 4: g_module_name VARCHAR2(100) := 'pa.plsql.pji_mt_rowset_det_pkg';

1: PACKAGE BODY PJI_MT_ROWSET_DET_PKG AS
2: /* $Header: PJIMTRDB.pls 120.1 2005/05/31 08:01:34 appldev $ */
3:
4: g_module_name VARCHAR2(100) := 'pa.plsql.pji_mt_rowset_det_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_det before updating

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

4: g_module_name VARCHAR2(100) := 'pa.plsql.pji_mt_rowset_det_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_det before updating
9: ==================================================================*/
10:
11: PROCEDURE LOCK_ROW (
12: p_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,

Line 12: p_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,

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

Line 13: p_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,

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

Line 14: p_object_version_number IN pji_mt_rowset_det.object_version_number%TYPE

10:
11: PROCEDURE LOCK_ROW (
12: p_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
13: p_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
14: p_object_version_number IN pji_mt_rowset_det.object_version_number%TYPE
15: ) IS
16:
17: CURSOR c IS
18: SELECT object_version_number

Line 19: FROM pji_mt_rowset_det

15: ) IS
16:
17: CURSOR c IS
18: SELECT object_version_number
19: FROM pji_mt_rowset_det
20: WHERE measure_set_code = p_measure_set_code
21: AND rowset_code = p_rowset_code
22: FOR UPDATE OF measure_set_code, rowset_code NOWAIT;
23:

Line 51: p_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,

47:
48:
49:
50: PROCEDURE DELETE_ROW (
51: p_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
52: p_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE
53: ) IS
54: BEGIN
55: DELETE FROM pji_mt_rowset_det

Line 52: p_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE

48:
49:
50: PROCEDURE DELETE_ROW (
51: p_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
52: p_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE
53: ) IS
54: BEGIN
55: DELETE FROM pji_mt_rowset_det
56: WHERE measure_set_code = p_measure_set_code

Line 55: DELETE FROM pji_mt_rowset_det

51: p_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
52: p_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE
53: ) IS
54: BEGIN
55: DELETE FROM pji_mt_rowset_det
56: WHERE measure_set_code = p_measure_set_code
57: AND rowset_code = p_rowset_code;
58:
59: IF (SQL%NOTFOUND) THEN

Line 68: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,

64:
65:
66: PROCEDURE Insert_Row (
67: X_Rowid IN OUT NOCOPY ROWID,
68: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
69: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
70: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
71: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
72: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,

Line 69: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,

65:
66: PROCEDURE Insert_Row (
67: X_Rowid IN OUT NOCOPY ROWID,
68: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
69: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
70: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
71: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
72: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
73: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,

Line 70: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,

66: PROCEDURE Insert_Row (
67: X_Rowid IN OUT NOCOPY ROWID,
68: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
69: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
70: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
71: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
72: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
73: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
74: X_Creation_Date IN pji_mt_rowset_det.Creation_Date%TYPE,

Line 71: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976

67: X_Rowid IN OUT NOCOPY ROWID,
68: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
69: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
70: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
71: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
72: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
73: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
74: X_Creation_Date IN pji_mt_rowset_det.Creation_Date%TYPE,
75: X_Created_By IN pji_mt_rowset_det.Created_By%TYPE,

Line 72: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,

68: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
69: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
70: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
71: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
72: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
73: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
74: X_Creation_Date IN pji_mt_rowset_det.Creation_Date%TYPE,
75: X_Created_By IN pji_mt_rowset_det.Created_By%TYPE,
76: X_Last_Update_Login IN pji_mt_rowset_det.Last_Update_Login%TYPE,

Line 73: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,

69: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
70: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
71: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
72: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
73: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
74: X_Creation_Date IN pji_mt_rowset_det.Creation_Date%TYPE,
75: X_Created_By IN pji_mt_rowset_det.Created_By%TYPE,
76: X_Last_Update_Login IN pji_mt_rowset_det.Last_Update_Login%TYPE,
77: X_Return_Status OUT NOCOPY VARCHAR2,

Line 74: X_Creation_Date IN pji_mt_rowset_det.Creation_Date%TYPE,

70: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
71: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
72: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
73: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
74: X_Creation_Date IN pji_mt_rowset_det.Creation_Date%TYPE,
75: X_Created_By IN pji_mt_rowset_det.Created_By%TYPE,
76: X_Last_Update_Login IN pji_mt_rowset_det.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_det.Created_By%TYPE,

71: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
72: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
73: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
74: X_Creation_Date IN pji_mt_rowset_det.Creation_Date%TYPE,
75: X_Created_By IN pji_mt_rowset_det.Created_By%TYPE,
76: X_Last_Update_Login IN pji_mt_rowset_det.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_det.Last_Update_Login%TYPE,

72: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
73: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
74: X_Creation_Date IN pji_mt_rowset_det.Creation_Date%TYPE,
75: X_Created_By IN pji_mt_rowset_det.Created_By%TYPE,
76: X_Last_Update_Login IN pji_mt_rowset_det.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_det

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_det
83: WHERE measure_set_code = x_measure_set_code
84: AND rowset_code = x_rowset_code;
85:
86: l_return_status VARCHAR2(1) := NULL;

Line 103: pa_debug.g_err_stage:= 'Inserting record in pji_mt_rowset_det, measure_code= '||X_measure_set_code||', rowset_code= '||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_det, measure_code= '||X_measure_set_code||', rowset_code= '||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_det

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_det
109: (
110: measure_set_code
111: , rowset_code
112: , Object_Version_Number

Line 133: pa_debug.g_err_stage:= 'Inserting record in pji_mt_rowset_det '||X_measure_set_code;

129: , X_Last_Update_Login
130: );
131:
132: IF g_debug_mode = 'Y' THEN
133: pa_debug.g_err_stage:= 'Inserting record in pji_mt_rowset_det '||X_measure_set_code;
134: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level3);
135: END IF;
136:
137: OPEN C;

Line 184: ( p_pkg_name => 'PJI_MT_ROWSET_DET_PKG'

180: x_msg_count := 1;
181: x_msg_data := SQLERRM;
182:
183: FND_MSG_PUB.add_exc_msg
184: ( p_pkg_name => 'PJI_MT_ROWSET_DET_PKG'
185: ,p_procedure_name => 'Insert Row'
186: ,p_error_text => x_msg_data);
187:
188: IF g_debug_mode = 'Y' THEN

Line 201: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,

197: END Insert_Row;
198:
199:
200: PROCEDURE Update_Row (
201: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
202: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
203: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
204: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
205: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,

Line 202: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,

198:
199:
200: PROCEDURE Update_Row (
201: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
202: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
203: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
204: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
205: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
206: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,

Line 203: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,

199:
200: PROCEDURE Update_Row (
201: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
202: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
203: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
204: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
205: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
206: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
207: X_Last_Update_Login IN pji_mt_rowset_det.Last_Update_Login%TYPE,

Line 204: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976

200: PROCEDURE Update_Row (
201: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
202: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
203: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
204: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
205: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
206: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
207: X_Last_Update_Login IN pji_mt_rowset_det.Last_Update_Login%TYPE,
208: X_Return_Status OUT NOCOPY VARCHAR2,

Line 205: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,

201: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
202: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
203: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
204: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
205: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
206: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
207: X_Last_Update_Login IN pji_mt_rowset_det.Last_Update_Login%TYPE,
208: X_Return_Status OUT NOCOPY VARCHAR2,
209: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 206: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,

202: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
203: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
204: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
205: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
206: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
207: X_Last_Update_Login IN pji_mt_rowset_det.Last_Update_Login%TYPE,
208: X_Return_Status OUT NOCOPY VARCHAR2,
209: X_Msg_Data OUT NOCOPY VARCHAR2,
210: X_Msg_Count OUT NOCOPY NUMBER

Line 207: X_Last_Update_Login IN pji_mt_rowset_det.Last_Update_Login%TYPE,

203: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
204: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
205: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
206: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
207: X_Last_Update_Login IN pji_mt_rowset_det.Last_Update_Login%TYPE,
208: X_Return_Status OUT NOCOPY VARCHAR2,
209: X_Msg_Data OUT NOCOPY VARCHAR2,
210: X_Msg_Count OUT NOCOPY NUMBER
211: )

Line 232: pa_debug.g_err_stage:= 'Updating pji_mt_rowset_det for'||X_measure_set_code;

228: p_debug_mode => g_debug_mode );
229: END IF;
230:
231: IF g_debug_mode = 'Y' THEN
232: pa_debug.g_err_stage:= 'Updating pji_mt_rowset_det for'||X_measure_set_code;
233: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
234: END IF;
235:
236: UPDATE pji_mt_rowset_det

Line 236: UPDATE pji_mt_rowset_det

232: pa_debug.g_err_stage:= 'Updating pji_mt_rowset_det for'||X_measure_set_code;
233: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
234: END IF;
235:
236: UPDATE pji_mt_rowset_det
237: SET
238: Object_Version_Number = X_Object_Version_Number
239: , display_order = X_display_order --Bug 3798976
240: , Last_Update_Date = X_Last_Update_Date

Line 248: pa_debug.g_err_stage:= 'NDF while updating pji_mt_rowset_det, measure_code= '||X_measure_set_code||', rowset_code= '||x_rowset_code;

244: AND rowset_code = X_rowset_code;
245:
246: IF (SQL%NOTFOUND) THEN
247: IF g_debug_mode = 'Y' THEN
248: pa_debug.g_err_stage:= 'NDF while updating pji_mt_rowset_det, measure_code= '||X_measure_set_code||', rowset_code= '||x_rowset_code;
249: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);
250: END IF;
251: RAISE NO_DATA_FOUND;
252: END IF;

Line 255: pa_debug.g_err_stage:= 'Updating pji_mt_rowset_det for, measure_code= '||X_measure_set_code||', rowset_code= '||x_rowset_code;

251: RAISE NO_DATA_FOUND;
252: END IF;
253:
254: IF g_debug_mode = 'Y' THEN
255: pa_debug.g_err_stage:= 'Updating pji_mt_rowset_det for, measure_code= '||X_measure_set_code||', rowset_code= '||x_rowset_code;
256: pa_debug.WRITE(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
257: END IF;
258:
259: EXCEPTION

Line 292: ( p_pkg_name => 'PJI_MT_ROWSET_DET_PKG'

288: x_msg_count := 1;
289: x_msg_data := SQLERRM;
290:
291: FND_MSG_PUB.add_exc_msg
292: ( p_pkg_name => 'PJI_MT_ROWSET_DET_PKG'
293: ,p_procedure_name => 'UPDATE_ROW'
294: ,p_error_text => x_msg_data);
295:
296: IF g_debug_mode = 'Y' THEN

Line 309: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,

305:
306:
307:
308: PROCEDURE Load_Row (
309: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
310: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
311: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
312: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
313: X_Owner IN VARCHAR2

Line 310: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,

306:
307:
308: PROCEDURE Load_Row (
309: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
310: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
311: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
312: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
313: X_Owner IN VARCHAR2
314: )

Line 311: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,

307:
308: PROCEDURE Load_Row (
309: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
310: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
311: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
312: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
313: X_Owner IN VARCHAR2
314: )
315: IS

Line 312: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976

308: PROCEDURE Load_Row (
309: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
310: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
311: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
312: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
313: X_Owner IN VARCHAR2
314: )
315: IS
316: User_Id NUMBER := NULL;

Line 333: PJI_MT_ROWSET_DET_PKG.Update_Row (

329: User_Id := 1;
330: ELSE
331: User_Id := 0;
332: END IF;
333: PJI_MT_ROWSET_DET_PKG.Update_Row (
334: X_measure_set_code => X_measure_set_code ,
335: X_rowset_code => X_rowset_code ,
336: X_Object_Version_Number => X_Object_Version_Number ,
337: X_display_order => X_display_order , --Bug 3798976

Line 349: PJI_MT_ROWSET_DET_PKG.Insert_Row (

345:
346: EXCEPTION
347: WHEN NO_DATA_FOUND THEN
348:
349: PJI_MT_ROWSET_DET_PKG.Insert_Row (
350: X_Rowid => X_Rowid ,
351: X_measure_set_code => X_measure_set_code ,
352: X_rowset_code => X_rowset_code ,
353: X_Object_Version_Number => X_Object_Version_Number ,

Line 371: ( p_pkg_name => 'PJI_MT_ROWSET_DET_PKG'

367: l_msg_count := 1;
368: l_msg_data := SQLERRM;
369:
370: FND_MSG_PUB.add_exc_msg
371: ( p_pkg_name => 'PJI_MT_ROWSET_DET_PKG'
372: ,p_procedure_name => 'UPDATE_ROW'
373: ,p_error_text => l_msg_data);
374:
375: IF g_debug_mode = 'Y' THEN

Line 387: END PJI_MT_ROWSET_DET_PKG;

383: END Load_Row;
384:
385:
386:
387: END PJI_MT_ROWSET_DET_PKG;