1 PACKAGE HZ_CLASS_CATEGORY_USES_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHCAUTS.pls 115.4 2002/11/21 21:07:33 sponnamb ship $ */
3
4 PROCEDURE Insert_Row (
5 X_CLASS_CATEGORY IN VARCHAR2,
6 X_OWNER_TABLE IN VARCHAR2,
7 X_COLUMN_NAME IN VARCHAR2,
8 X_ADDITIONAL_WHERE_CLAUSE IN VARCHAR2,
9 X_OBJECT_VERSION_NUMBER IN NUMBER,
10 X_CREATED_BY_MODULE IN VARCHAR2,
11 X_APPLICATION_ID IN NUMBER
12 );
13
14 PROCEDURE Update_Row (
15 X_CLASS_CATEGORY IN VARCHAR2,
16 X_OWNER_TABLE IN VARCHAR2,
17 X_COLUMN_NAME IN VARCHAR2,
18 X_ADDITIONAL_WHERE_CLAUSE IN VARCHAR2,
19 X_OBJECT_VERSION_NUMBER IN NUMBER,
20 X_CREATED_BY_MODULE IN VARCHAR2,
21 X_APPLICATION_ID IN NUMBER
22 );
23
24 PROCEDURE Lock_Row (
25 X_Rowid IN OUT NOCOPY VARCHAR2,
26 X_CLASS_CATEGORY IN VARCHAR2,
27 X_OWNER_TABLE IN VARCHAR2,
28 X_COLUMN_NAME IN VARCHAR2,
29 X_ADDITIONAL_WHERE_CLAUSE IN VARCHAR2,
30 X_CREATED_BY IN NUMBER,
31 X_CREATION_DATE IN DATE,
32 X_LAST_UPDATE_LOGIN IN NUMBER,
33 X_LAST_UPDATE_DATE IN DATE,
34 X_LAST_UPDATED_BY IN NUMBER,
35 X_OBJECT_VERSION_NUMBER IN NUMBER,
36 X_CREATED_BY_MODULE IN VARCHAR2,
37 X_APPLICATION_ID IN NUMBER
38 );
39
40 PROCEDURE Select_Row (
41 X_CLASS_CATEGORY IN OUT NOCOPY VARCHAR2,
42 X_OWNER_TABLE IN OUT NOCOPY VARCHAR2,
43 X_COLUMN_NAME OUT NOCOPY VARCHAR2,
44 X_ADDITIONAL_WHERE_CLAUSE OUT NOCOPY VARCHAR2,
45 X_CREATED_BY_MODULE OUT NOCOPY VARCHAR2,
46 X_APPLICATION_ID OUT NOCOPY NUMBER
47 );
48
49 PROCEDURE Delete_Row (
50 X_CLASS_CATEGORY IN VARCHAR2,
51 X_OWNER_TABLE IN VARCHAR2
52 );
53
54 END HZ_CLASS_CATEGORY_USES_PKG;
[Home] [Help]