1 PACKAGE HZ_CLASS_CODE_RELATIONS_PKG AUTHID CURRENT_USER AS
2 /*$Header: ARHCCRTS.pls 115.2 2002/11/21 19:37:50 sponnamb ship $ */
3
4 PROCEDURE Insert_Row (
5 X_CLASS_CATEGORY IN VARCHAR2,
6 X_CLASS_CODE IN VARCHAR2,
7 X_SUB_CLASS_CODE IN VARCHAR2,
8 X_START_DATE_ACTIVE IN DATE,
9 X_END_DATE_ACTIVE IN DATE,
10 X_OBJECT_VERSION_NUMBER IN NUMBER,
11 X_CREATED_BY_MODULE IN VARCHAR2,
12 X_APPLICATION_ID IN NUMBER
13 );
14
15 PROCEDURE Update_Row (
16 X_CLASS_CATEGORY IN VARCHAR2,
17 X_CLASS_CODE IN VARCHAR2,
18 X_SUB_CLASS_CODE IN VARCHAR2,
19 X_START_DATE_ACTIVE IN DATE,
20 X_END_DATE_ACTIVE IN DATE,
21 X_OBJECT_VERSION_NUMBER IN NUMBER,
22 X_CREATED_BY_MODULE IN VARCHAR2,
23 X_APPLICATION_ID IN NUMBER
24 );
25
26 PROCEDURE Lock_Row (
27 X_Rowid IN OUT NOCOPY VARCHAR2,
28 X_CLASS_CATEGORY IN VARCHAR2,
29 X_CLASS_CODE IN VARCHAR2,
30 X_SUB_CLASS_CODE IN VARCHAR2,
31 X_START_DATE_ACTIVE IN DATE,
32 X_END_DATE_ACTIVE IN DATE,
33 X_CREATED_BY IN NUMBER,
34 X_CREATION_DATE IN DATE,
35 X_LAST_UPDATE_LOGIN IN NUMBER,
36 X_LAST_UPDATE_DATE IN DATE,
37 X_LAST_UPDATED_BY IN NUMBER,
38 X_OBJECT_VERSION_NUMBER IN NUMBER,
39 X_CREATED_BY_MODULE IN VARCHAR2,
40 X_APPLICATION_ID IN NUMBER
41 );
42
43 PROCEDURE Select_Row (
44 X_CLASS_CATEGORY IN OUT NOCOPY VARCHAR2,
45 X_CLASS_CODE IN OUT NOCOPY VARCHAR2,
46 X_SUB_CLASS_CODE IN OUT NOCOPY VARCHAR2,
47 X_START_DATE_ACTIVE IN OUT NOCOPY DATE,
48 X_END_DATE_ACTIVE OUT NOCOPY DATE,
49 X_CREATED_BY_MODULE OUT NOCOPY VARCHAR2,
50 X_APPLICATION_ID OUT NOCOPY NUMBER
51 );
52
53 PROCEDURE Delete_Row (
54 X_CLASS_CATEGORY IN VARCHAR2,
55 X_CLASS_CODE IN VARCHAR2,
56 X_SUB_CLASS_CODE IN VARCHAR2,
57 X_START_DATE_ACTIVE IN DATE
58 );
59
60 END HZ_CLASS_CODE_RELATIONS_PKG;