1: PACKAGE PJI_MT_ROWSET_DET_PKG AS
2: /* $Header: PJIMTRDS.pls 120.1 2005/05/31 08:01:40 appldev $ */
3:
4: PROCEDURE LOCK_ROW (
5: p_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
1: PACKAGE PJI_MT_ROWSET_DET_PKG AS
2: /* $Header: PJIMTRDS.pls 120.1 2005/05/31 08:01:40 appldev $ */
3:
4: PROCEDURE LOCK_ROW (
5: p_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
6: p_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
7: p_object_version_number IN pji_mt_rowset_det.object_version_number%TYPE
8: );
9:
2: /* $Header: PJIMTRDS.pls 120.1 2005/05/31 08:01:40 appldev $ */
3:
4: PROCEDURE LOCK_ROW (
5: p_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
6: p_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
7: p_object_version_number IN pji_mt_rowset_det.object_version_number%TYPE
8: );
9:
10:
3:
4: PROCEDURE LOCK_ROW (
5: p_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
6: p_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
7: p_object_version_number IN pji_mt_rowset_det.object_version_number%TYPE
8: );
9:
10:
11: PROCEDURE DELETE_ROW (
8: );
9:
10:
11: PROCEDURE DELETE_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: );
15:
16:
9:
10:
11: PROCEDURE DELETE_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: );
15:
16:
17: PROCEDURE Insert_Row (
15:
16:
17: PROCEDURE Insert_Row (
18: X_Rowid IN OUT NOCOPY ROWID,
19: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
20: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
21: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
22: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
23: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
16:
17: PROCEDURE Insert_Row (
18: X_Rowid IN OUT NOCOPY ROWID,
19: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
20: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
21: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
22: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
23: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
24: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
17: PROCEDURE Insert_Row (
18: X_Rowid IN OUT NOCOPY ROWID,
19: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
20: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
21: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
22: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
23: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
24: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
25: X_Creation_Date IN pji_mt_rowset_det.Creation_Date%TYPE,
18: X_Rowid IN OUT NOCOPY ROWID,
19: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
20: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
21: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
22: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
23: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
24: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
25: X_Creation_Date IN pji_mt_rowset_det.Creation_Date%TYPE,
26: X_Created_By IN pji_mt_rowset_det.Created_By%TYPE,
19: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
20: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
21: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
22: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
23: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
24: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
25: X_Creation_Date IN pji_mt_rowset_det.Creation_Date%TYPE,
26: X_Created_By IN pji_mt_rowset_det.Created_By%TYPE,
27: X_Last_Update_Login IN pji_mt_rowset_det.Last_Update_Login%TYPE,
20: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
21: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
22: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
23: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
24: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
25: X_Creation_Date IN pji_mt_rowset_det.Creation_Date%TYPE,
26: X_Created_By IN pji_mt_rowset_det.Created_By%TYPE,
27: X_Last_Update_Login IN pji_mt_rowset_det.Last_Update_Login%TYPE,
28: X_Return_Status OUT NOCOPY VARCHAR2,
21: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
22: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
23: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
24: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
25: X_Creation_Date IN pji_mt_rowset_det.Creation_Date%TYPE,
26: X_Created_By IN pji_mt_rowset_det.Created_By%TYPE,
27: X_Last_Update_Login IN pji_mt_rowset_det.Last_Update_Login%TYPE,
28: X_Return_Status OUT NOCOPY VARCHAR2,
29: X_Msg_Data OUT NOCOPY VARCHAR2,
22: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
23: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
24: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
25: X_Creation_Date IN pji_mt_rowset_det.Creation_Date%TYPE,
26: X_Created_By IN pji_mt_rowset_det.Created_By%TYPE,
27: X_Last_Update_Login IN pji_mt_rowset_det.Last_Update_Login%TYPE,
28: X_Return_Status OUT NOCOPY VARCHAR2,
29: X_Msg_Data OUT NOCOPY VARCHAR2,
30: X_Msg_Count OUT NOCOPY NUMBER
23: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
24: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
25: X_Creation_Date IN pji_mt_rowset_det.Creation_Date%TYPE,
26: X_Created_By IN pji_mt_rowset_det.Created_By%TYPE,
27: X_Last_Update_Login IN pji_mt_rowset_det.Last_Update_Login%TYPE,
28: X_Return_Status OUT NOCOPY VARCHAR2,
29: X_Msg_Data OUT NOCOPY VARCHAR2,
30: X_Msg_Count OUT NOCOPY NUMBER
31: );
31: );
32:
33:
34: PROCEDURE Update_Row (
35: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
36: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
37: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
38: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
39: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
32:
33:
34: PROCEDURE Update_Row (
35: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
36: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
37: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
38: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
39: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
40: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
33:
34: PROCEDURE Update_Row (
35: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
36: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
37: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
38: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
39: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
40: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
41: X_Last_Update_Login IN pji_mt_rowset_det.Last_Update_Login%TYPE,
34: PROCEDURE Update_Row (
35: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
36: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
37: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
38: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
39: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
40: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
41: X_Last_Update_Login IN pji_mt_rowset_det.Last_Update_Login%TYPE,
42: X_Return_Status OUT NOCOPY VARCHAR2,
35: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
36: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
37: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
38: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
39: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
40: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
41: X_Last_Update_Login IN pji_mt_rowset_det.Last_Update_Login%TYPE,
42: X_Return_Status OUT NOCOPY VARCHAR2,
43: X_Msg_Data OUT NOCOPY VARCHAR2,
36: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
37: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
38: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
39: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
40: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
41: X_Last_Update_Login IN pji_mt_rowset_det.Last_Update_Login%TYPE,
42: X_Return_Status OUT NOCOPY VARCHAR2,
43: X_Msg_Data OUT NOCOPY VARCHAR2,
44: X_Msg_Count OUT NOCOPY NUMBER
37: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
38: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
39: X_Last_Update_Date IN pji_mt_rowset_det.Last_Update_Date%TYPE,
40: X_Last_Updated_by IN pji_mt_rowset_det.Last_Updated_by%TYPE,
41: X_Last_Update_Login IN pji_mt_rowset_det.Last_Update_Login%TYPE,
42: X_Return_Status OUT NOCOPY VARCHAR2,
43: X_Msg_Data OUT NOCOPY VARCHAR2,
44: X_Msg_Count OUT NOCOPY NUMBER
45: );
45: );
46:
47:
48: PROCEDURE Load_Row (
49: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
50: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
51: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
52: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
53: X_Owner IN VARCHAR2
46:
47:
48: PROCEDURE Load_Row (
49: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
50: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
51: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
52: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
53: X_Owner IN VARCHAR2
54: );
47:
48: PROCEDURE Load_Row (
49: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
50: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
51: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
52: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
53: X_Owner IN VARCHAR2
54: );
55:
48: PROCEDURE Load_Row (
49: X_measure_set_code IN pji_mt_rowset_det.measure_set_code%TYPE,
50: X_rowset_code IN pji_mt_rowset_det.rowset_code%TYPE,
51: X_Object_Version_Number IN pji_mt_rowset_det.Object_Version_Number%TYPE,
52: X_display_order IN pji_mt_rowset_det.display_order%TYPE, --Bug 3798976
53: X_Owner IN VARCHAR2
54: );
55:
56:
53: X_Owner IN VARCHAR2
54: );
55:
56:
57: END PJI_MT_ROWSET_DET_PKG;