[Home] [Help]
PACKAGE: APPS.PJI_MT_ROWSET_PKG
Source
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
10 PROCEDURE DELETE_ROW (
11 p_rowset_code IN pji_mt_rowset_b.rowset_code%TYPE
12 );
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,
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 );
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,
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
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 );
63
64 END PJI_MT_ROWSET_PKG;