3:
4: G_RET_STS_ERROR VARCHAR2(1):='E';
5:
6: PROCEDURE LOCK_ROW (
7: p_measure_set_code IN pji_mt_measure_sets_b.measure_set_code%TYPE,
8: p_object_version_number IN pji_mt_measure_sets_b.object_version_number%TYPE
9: );
10:
11: PROCEDURE DELETE_ROW (
4: G_RET_STS_ERROR VARCHAR2(1):='E';
5:
6: PROCEDURE LOCK_ROW (
7: p_measure_set_code IN pji_mt_measure_sets_b.measure_set_code%TYPE,
8: p_object_version_number IN pji_mt_measure_sets_b.object_version_number%TYPE
9: );
10:
11: PROCEDURE DELETE_ROW (
12: p_measure_set_code IN pji_mt_measure_sets_b.measure_set_code%TYPE
8: p_object_version_number IN pji_mt_measure_sets_b.object_version_number%TYPE
9: );
10:
11: PROCEDURE DELETE_ROW (
12: p_measure_set_code IN pji_mt_measure_sets_b.measure_set_code%TYPE
13: );
14:
15: PROCEDURE Insert_Row (
16: X_Rowid IN OUT NOCOPY ROWID,
13: );
14:
15: PROCEDURE Insert_Row (
16: X_Rowid IN OUT NOCOPY ROWID,
17: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%TYPE,
18: X_Measure_Set_Type IN pji_mt_measure_sets_b.Measure_Set_Type%TYPE,
19: X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,
20: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
21: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
14:
15: PROCEDURE Insert_Row (
16: X_Rowid IN OUT NOCOPY ROWID,
17: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%TYPE,
18: X_Measure_Set_Type IN pji_mt_measure_sets_b.Measure_Set_Type%TYPE,
19: X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,
20: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
21: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
22: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
15: PROCEDURE Insert_Row (
16: X_Rowid IN OUT NOCOPY ROWID,
17: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%TYPE,
18: X_Measure_Set_Type IN pji_mt_measure_sets_b.Measure_Set_Type%TYPE,
19: X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,
20: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
21: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
22: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
23: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
16: X_Rowid IN OUT NOCOPY ROWID,
17: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%TYPE,
18: X_Measure_Set_Type IN pji_mt_measure_sets_b.Measure_Set_Type%TYPE,
19: X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,
20: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
21: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
22: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
23: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
24: X_Last_Update_Date IN pji_mt_measure_sets_b.Last_Update_Date%TYPE,
17: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%TYPE,
18: X_Measure_Set_Type IN pji_mt_measure_sets_b.Measure_Set_Type%TYPE,
19: X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,
20: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
21: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
22: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
23: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
24: X_Last_Update_Date IN pji_mt_measure_sets_b.Last_Update_Date%TYPE,
25: X_Last_Updated_by IN pji_mt_measure_sets_b.Last_Updated_by%TYPE,
20: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
21: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
22: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
23: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
24: X_Last_Update_Date IN pji_mt_measure_sets_b.Last_Update_Date%TYPE,
25: X_Last_Updated_by IN pji_mt_measure_sets_b.Last_Updated_by%TYPE,
26: X_Creation_Date IN pji_mt_measure_sets_b.Creation_Date%TYPE,
27: X_Created_By IN pji_mt_measure_sets_b.Created_By%TYPE,
28: X_Last_Update_Login IN pji_mt_measure_sets_b.Last_Update_Login%TYPE,
21: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
22: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
23: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
24: X_Last_Update_Date IN pji_mt_measure_sets_b.Last_Update_Date%TYPE,
25: X_Last_Updated_by IN pji_mt_measure_sets_b.Last_Updated_by%TYPE,
26: X_Creation_Date IN pji_mt_measure_sets_b.Creation_Date%TYPE,
27: X_Created_By IN pji_mt_measure_sets_b.Created_By%TYPE,
28: X_Last_Update_Login IN pji_mt_measure_sets_b.Last_Update_Login%TYPE,
29: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,
22: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
23: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
24: X_Last_Update_Date IN pji_mt_measure_sets_b.Last_Update_Date%TYPE,
25: X_Last_Updated_by IN pji_mt_measure_sets_b.Last_Updated_by%TYPE,
26: X_Creation_Date IN pji_mt_measure_sets_b.Creation_Date%TYPE,
27: X_Created_By IN pji_mt_measure_sets_b.Created_By%TYPE,
28: X_Last_Update_Login IN pji_mt_measure_sets_b.Last_Update_Login%TYPE,
29: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,
30: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE,
23: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
24: X_Last_Update_Date IN pji_mt_measure_sets_b.Last_Update_Date%TYPE,
25: X_Last_Updated_by IN pji_mt_measure_sets_b.Last_Updated_by%TYPE,
26: X_Creation_Date IN pji_mt_measure_sets_b.Creation_Date%TYPE,
27: X_Created_By IN pji_mt_measure_sets_b.Created_By%TYPE,
28: X_Last_Update_Login IN pji_mt_measure_sets_b.Last_Update_Login%TYPE,
29: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,
30: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE,
31: X_Return_Status OUT NOCOPY VARCHAR2,
24: X_Last_Update_Date IN pji_mt_measure_sets_b.Last_Update_Date%TYPE,
25: X_Last_Updated_by IN pji_mt_measure_sets_b.Last_Updated_by%TYPE,
26: X_Creation_Date IN pji_mt_measure_sets_b.Creation_Date%TYPE,
27: X_Created_By IN pji_mt_measure_sets_b.Created_By%TYPE,
28: X_Last_Update_Login IN pji_mt_measure_sets_b.Last_Update_Login%TYPE,
29: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,
30: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE,
31: X_Return_Status OUT NOCOPY VARCHAR2,
32: X_Msg_Data OUT NOCOPY VARCHAR2,
25: X_Last_Updated_by IN pji_mt_measure_sets_b.Last_Updated_by%TYPE,
26: X_Creation_Date IN pji_mt_measure_sets_b.Creation_Date%TYPE,
27: X_Created_By IN pji_mt_measure_sets_b.Created_By%TYPE,
28: X_Last_Update_Login IN pji_mt_measure_sets_b.Last_Update_Login%TYPE,
29: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,
30: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE,
31: X_Return_Status OUT NOCOPY VARCHAR2,
32: X_Msg_Data OUT NOCOPY VARCHAR2,
33: X_Msg_Count OUT NOCOPY NUMBER
26: X_Creation_Date IN pji_mt_measure_sets_b.Creation_Date%TYPE,
27: X_Created_By IN pji_mt_measure_sets_b.Created_By%TYPE,
28: X_Last_Update_Login IN pji_mt_measure_sets_b.Last_Update_Login%TYPE,
29: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,
30: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE,
31: X_Return_Status OUT NOCOPY VARCHAR2,
32: X_Msg_Data OUT NOCOPY VARCHAR2,
33: X_Msg_Count OUT NOCOPY NUMBER
34: );
33: X_Msg_Count OUT NOCOPY NUMBER
34: );
35:
36: PROCEDURE Update_Row (
37: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%TYPE,
38: X_Measure_Set_Type IN pji_mt_measure_sets_b.Measure_Set_Type%TYPE,
39: X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,
40: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
41: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
34: );
35:
36: PROCEDURE Update_Row (
37: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%TYPE,
38: X_Measure_Set_Type IN pji_mt_measure_sets_b.Measure_Set_Type%TYPE,
39: X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,
40: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
41: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
42: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
35:
36: PROCEDURE Update_Row (
37: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%TYPE,
38: X_Measure_Set_Type IN pji_mt_measure_sets_b.Measure_Set_Type%TYPE,
39: X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,
40: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
41: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
42: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
43: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
36: PROCEDURE Update_Row (
37: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%TYPE,
38: X_Measure_Set_Type IN pji_mt_measure_sets_b.Measure_Set_Type%TYPE,
39: X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,
40: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
41: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
42: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
43: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
44: X_Last_Update_Date IN pji_mt_measure_sets_b.Last_Update_Date%TYPE,
37: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%TYPE,
38: X_Measure_Set_Type IN pji_mt_measure_sets_b.Measure_Set_Type%TYPE,
39: X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,
40: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
41: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
42: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
43: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
44: X_Last_Update_Date IN pji_mt_measure_sets_b.Last_Update_Date%TYPE,
45: X_Last_Updated_by IN pji_mt_measure_sets_b.Last_Updated_by%TYPE,
40: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
41: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
42: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
43: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
44: X_Last_Update_Date IN pji_mt_measure_sets_b.Last_Update_Date%TYPE,
45: X_Last_Updated_by IN pji_mt_measure_sets_b.Last_Updated_by%TYPE,
46: X_Last_Update_Login IN pji_mt_measure_sets_b.Last_Update_Login%TYPE,
47: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,
48: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE,
41: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
42: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
43: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
44: X_Last_Update_Date IN pji_mt_measure_sets_b.Last_Update_Date%TYPE,
45: X_Last_Updated_by IN pji_mt_measure_sets_b.Last_Updated_by%TYPE,
46: X_Last_Update_Login IN pji_mt_measure_sets_b.Last_Update_Login%TYPE,
47: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,
48: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE,
49: X_Return_Status OUT NOCOPY VARCHAR2,
42: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
43: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
44: X_Last_Update_Date IN pji_mt_measure_sets_b.Last_Update_Date%TYPE,
45: X_Last_Updated_by IN pji_mt_measure_sets_b.Last_Updated_by%TYPE,
46: X_Last_Update_Login IN pji_mt_measure_sets_b.Last_Update_Login%TYPE,
47: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,
48: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE,
49: X_Return_Status OUT NOCOPY VARCHAR2,
50: X_Msg_Data OUT NOCOPY VARCHAR2,
43: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
44: X_Last_Update_Date IN pji_mt_measure_sets_b.Last_Update_Date%TYPE,
45: X_Last_Updated_by IN pji_mt_measure_sets_b.Last_Updated_by%TYPE,
46: X_Last_Update_Login IN pji_mt_measure_sets_b.Last_Update_Login%TYPE,
47: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,
48: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE,
49: X_Return_Status OUT NOCOPY VARCHAR2,
50: X_Msg_Data OUT NOCOPY VARCHAR2,
51: X_Msg_Count OUT NOCOPY NUMBER
44: X_Last_Update_Date IN pji_mt_measure_sets_b.Last_Update_Date%TYPE,
45: X_Last_Updated_by IN pji_mt_measure_sets_b.Last_Updated_by%TYPE,
46: X_Last_Update_Login IN pji_mt_measure_sets_b.Last_Update_Login%TYPE,
47: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,
48: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE,
49: X_Return_Status OUT NOCOPY VARCHAR2,
50: X_Msg_Data OUT NOCOPY VARCHAR2,
51: X_Msg_Count OUT NOCOPY NUMBER
52: );
51: X_Msg_Count OUT NOCOPY NUMBER
52: );
53:
54: PROCEDURE Load_Row (
55: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%TYPE,
56: X_Measure_Set_Type IN pji_mt_measure_sets_b.Measure_Set_Type%TYPE,
57: X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,
58: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
59: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
52: );
53:
54: PROCEDURE Load_Row (
55: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%TYPE,
56: X_Measure_Set_Type IN pji_mt_measure_sets_b.Measure_Set_Type%TYPE,
57: X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,
58: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
59: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
60: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
53:
54: PROCEDURE Load_Row (
55: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%TYPE,
56: X_Measure_Set_Type IN pji_mt_measure_sets_b.Measure_Set_Type%TYPE,
57: X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,
58: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
59: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
60: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
61: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
54: PROCEDURE Load_Row (
55: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%TYPE,
56: X_Measure_Set_Type IN pji_mt_measure_sets_b.Measure_Set_Type%TYPE,
57: X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,
58: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
59: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
60: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
61: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
62: X_Owner IN VARCHAR2,
55: X_Measure_Set_Code IN pji_mt_measure_sets_b.Measure_Set_Code%TYPE,
56: X_Measure_Set_Type IN pji_mt_measure_sets_b.Measure_Set_Type%TYPE,
57: X_Measure_Format IN pji_mt_measure_sets_b.Measure_Format%TYPE,
58: X_DB_Column_Name IN pji_mt_measure_sets_b.DB_Column_Name%TYPE,
59: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
60: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
61: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
62: X_Owner IN VARCHAR2,
63: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,
59: X_Object_Version_Number IN pji_mt_measure_sets_b.Object_Version_Number%TYPE,
60: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
61: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
62: X_Owner IN VARCHAR2,
63: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,
64: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE
65: );
66:
67: PROCEDURE Add_Language;
60: X_Name IN pji_mt_measure_sets_Tl.Name%TYPE,
61: X_Description IN pji_mt_measure_sets_Tl.Description%TYPE,
62: X_Owner IN VARCHAR2,
63: X_Measure_Formula IN pji_mt_measure_sets_b.Measure_Formula%TYPE,
64: X_Measure_Source IN pji_mt_measure_sets_b.Measure_Source%TYPE
65: );
66:
67: PROCEDURE Add_Language;
68:
66:
67: PROCEDURE Add_Language;
68:
69: PROCEDURE TRANSLATE_ROW (
70: X_measure_set_code IN pji_mt_measure_sets_b.measure_set_code%TYPE,
71: X_owner IN VARCHAR2 ,
72: X_name IN pji_mt_measure_sets_TL.NAME%TYPE,
73: X_description IN pji_mt_measure_sets_TL.DESCRIPTION%TYPE
74: );