1: PACKAGE PJI_MT_ROWSET_PKG AS
2: /* $Header: PJIMTRSS.pls 120.1 2005/05/31 08:01:59 appldev $ */
3:
4: PROCEDURE LOCK_ROW (
5: p_rowset_code IN pji_mt_rowset_b.rowset_code%TYPE,
6: p_object_version_number IN pji_mt_rowset_b.object_version_number%TYPE
7: );
8:
9:
2: /* $Header: PJIMTRSS.pls 120.1 2005/05/31 08:01:59 appldev $ */
3:
4: PROCEDURE LOCK_ROW (
5: p_rowset_code IN pji_mt_rowset_b.rowset_code%TYPE,
6: p_object_version_number IN pji_mt_rowset_b.object_version_number%TYPE
7: );
8:
9:
10: PROCEDURE DELETE_ROW (
7: );
8:
9:
10: PROCEDURE DELETE_ROW (
11: p_rowset_code IN pji_mt_rowset_b.rowset_code%TYPE
12: );
13:
14:
15: PROCEDURE Insert_Row (
13:
14:
15: PROCEDURE Insert_Row (
16: X_Rowid IN OUT NOCOPY ROWID,
17: X_rowset_Code IN pji_mt_rowset_b.Rowset_Code%TYPE,
18: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
19: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
20: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
21: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
14:
15: PROCEDURE Insert_Row (
16: X_Rowid IN OUT NOCOPY ROWID,
17: X_rowset_Code IN pji_mt_rowset_b.Rowset_Code%TYPE,
18: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
19: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
20: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
21: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
22: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,
17: X_rowset_Code IN pji_mt_rowset_b.Rowset_Code%TYPE,
18: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
19: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
20: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
21: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
22: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,
23: X_Creation_Date IN pji_mt_rowset_b.Creation_Date%TYPE,
24: X_Created_By IN pji_mt_rowset_b.Created_By%TYPE,
25: X_Last_Update_Login IN pji_mt_rowset_b.Last_Update_Login%TYPE,
18: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
19: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
20: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
21: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
22: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,
23: X_Creation_Date IN pji_mt_rowset_b.Creation_Date%TYPE,
24: X_Created_By IN pji_mt_rowset_b.Created_By%TYPE,
25: X_Last_Update_Login IN pji_mt_rowset_b.Last_Update_Login%TYPE,
26: X_Return_Status OUT NOCOPY VARCHAR2,
19: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
20: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
21: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
22: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,
23: X_Creation_Date IN pji_mt_rowset_b.Creation_Date%TYPE,
24: X_Created_By IN pji_mt_rowset_b.Created_By%TYPE,
25: X_Last_Update_Login IN pji_mt_rowset_b.Last_Update_Login%TYPE,
26: X_Return_Status OUT NOCOPY VARCHAR2,
27: X_Msg_Data OUT NOCOPY VARCHAR2,
20: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
21: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
22: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,
23: X_Creation_Date IN pji_mt_rowset_b.Creation_Date%TYPE,
24: X_Created_By IN pji_mt_rowset_b.Created_By%TYPE,
25: X_Last_Update_Login IN pji_mt_rowset_b.Last_Update_Login%TYPE,
26: X_Return_Status OUT NOCOPY VARCHAR2,
27: X_Msg_Data OUT NOCOPY VARCHAR2,
28: X_Msg_Count OUT NOCOPY NUMBER
21: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
22: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,
23: X_Creation_Date IN pji_mt_rowset_b.Creation_Date%TYPE,
24: X_Created_By IN pji_mt_rowset_b.Created_By%TYPE,
25: X_Last_Update_Login IN pji_mt_rowset_b.Last_Update_Login%TYPE,
26: X_Return_Status OUT NOCOPY VARCHAR2,
27: X_Msg_Data OUT NOCOPY VARCHAR2,
28: X_Msg_Count OUT NOCOPY NUMBER
29: );
29: );
30:
31:
32: PROCEDURE Update_Row (
33: X_Rowset_Code IN pji_mt_rowset_b.Rowset_Code%TYPE,
34: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
35: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
36: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
37: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
30:
31:
32: PROCEDURE Update_Row (
33: X_Rowset_Code IN pji_mt_rowset_b.Rowset_Code%TYPE,
34: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
35: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
36: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
37: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
38: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,
33: X_Rowset_Code IN pji_mt_rowset_b.Rowset_Code%TYPE,
34: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
35: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
36: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
37: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
38: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,
39: X_Last_Update_Login IN pji_mt_rowset_b.Last_Update_Login%TYPE,
40: X_Lock_Flag IN VARCHAR2 DEFAULT 'true',
41: X_Return_Status OUT NOCOPY VARCHAR2,
34: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
35: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
36: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
37: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
38: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,
39: X_Last_Update_Login IN pji_mt_rowset_b.Last_Update_Login%TYPE,
40: X_Lock_Flag IN VARCHAR2 DEFAULT 'true',
41: X_Return_Status OUT NOCOPY VARCHAR2,
42: X_Msg_Data OUT NOCOPY VARCHAR2,
35: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
36: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
37: X_Last_Update_Date IN pji_mt_rowset_b.Last_Update_Date%TYPE,
38: X_Last_Updated_by IN pji_mt_rowset_b.Last_Updated_by%TYPE,
39: X_Last_Update_Login IN pji_mt_rowset_b.Last_Update_Login%TYPE,
40: X_Lock_Flag IN VARCHAR2 DEFAULT 'true',
41: X_Return_Status OUT NOCOPY VARCHAR2,
42: X_Msg_Data OUT NOCOPY VARCHAR2,
43: X_Msg_Count OUT NOCOPY NUMBER
44: );
45:
46:
47: PROCEDURE Load_Row (
48: X_Rowset_Code IN pji_mt_rowset_b.Rowset_Code%TYPE,
49: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
50: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
51: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
52: X_Owner IN VARCHAR2
45:
46:
47: PROCEDURE Load_Row (
48: X_Rowset_Code IN pji_mt_rowset_b.Rowset_Code%TYPE,
49: X_Object_Version_Number IN pji_mt_rowset_b.Object_Version_Number%TYPE,
50: X_Name IN pji_mt_rowset_Tl.Name%TYPE,
51: X_Description IN pji_mt_rowset_Tl.Description%TYPE,
52: X_Owner IN VARCHAR2
53: );
54:
55: PROCEDURE Add_Language;
56:
57: PROCEDURE Translate_Row (
58: X_rowset_code IN pji_mt_rowset_b.rowset_code%TYPE,
59: X_OWNER IN VARCHAR2 ,
60: X_NAME IN pji_mt_rowset_TL.NAME%TYPE,
61: X_DESCRIPTION IN pji_mt_rowset_TL.DESCRIPTION%TYPE
62: );