1 PACKAGE JTF_QUAL_TYPES_PKG as
2 /* $Header: jtfvqtys.pls 120.0 2005/06/02 18:22:17 appldev ship $ */
3
4 PROCEDURE Insert_Row(
5 x_Rowid IN OUT NOCOPY VARCHAR2,
6 x_QUAL_TYPE_ID IN OUT NOCOPY NUMBER,
7 x_LAST_UPDATE_DATE IN DATE,
8 x_LAST_UPDATED_BY IN NUMBER,
9 x_CREATION_DATE IN DATE,
10 x_CREATED_BY IN NUMBER,
11 x_LAST_UPDATE_LOGIN IN NUMBER,
12 x_NAME IN VARCHAR2,
13 x_DESCRIPTION IN VARCHAR2,
14 x_SELECT_CLAUSE IN VARCHAR2,
15 x_WHERE_CLAUSE IN VARCHAR2,
16 x_VIEW_NAME IN VARCHAR2,
17 x_VIEW_DDL_FILENAME IN VARCHAR2,
18 x_RELATED_ID1 IN NUMBER,
19 x_RELATED_ID2 IN NUMBER,
20 x_RELATED_ID3 IN NUMBER,
21 x_RELATED_ID4 IN NUMBER,
22 x_RELATED_ID5 IN NUMBER,
23 x_ORG_ID IN NUMBER);
24
25
26
27 PROCEDURE Lock_Row(
28 x_Rowid IN VARCHAR2,
29 x_QUAL_TYPE_ID IN NUMBER,
30 x_LAST_UPDATE_DATE IN DATE,
31 x_LAST_UPDATED_BY IN NUMBER,
32 x_CREATION_DATE IN DATE,
33 x_CREATED_BY IN NUMBER,
34 x_LAST_UPDATE_LOGIN IN NUMBER,
35 x_NAME IN VARCHAR2,
36 x_DESCRIPTION IN VARCHAR2,
37 x_SELECT_CLAUSE IN VARCHAR2,
38 x_WHERE_CLAUSE IN VARCHAR2,
39 x_VIEW_NAME IN VARCHAR2,
40 x_VIEW_DDL_FILENAME IN VARCHAR2,
41 x_RELATED_ID1 IN NUMBER,
42 x_RELATED_ID2 IN NUMBER,
43 x_RELATED_ID3 IN NUMBER,
44 x_RELATED_ID4 IN NUMBER,
45 x_RELATED_ID5 IN NUMBER,
46 x_ORG_ID IN NUMBER);
47
48
49
50 PROCEDURE Update_Row(
51 x_Rowid IN VARCHAR2,
52 x_QUAL_TYPE_ID IN NUMBER,
53 x_LAST_UPDATE_DATE IN DATE,
54 x_LAST_UPDATED_BY IN NUMBER,
55 x_CREATION_DATE IN DATE,
56 x_CREATED_BY IN NUMBER,
57 x_LAST_UPDATE_LOGIN IN NUMBER,
58 x_NAME IN VARCHAR2,
59 x_DESCRIPTION IN VARCHAR2,
60 x_SELECT_CLAUSE IN VARCHAR2,
61 x_WHERE_CLAUSE IN VARCHAR2,
62 x_VIEW_NAME IN VARCHAR2,
63 x_VIEW_DDL_FILENAME IN VARCHAR2,
64 x_RELATED_ID1 IN NUMBER,
65 x_RELATED_ID2 IN NUMBER,
66 x_RELATED_ID3 IN NUMBER,
67 x_RELATED_ID4 IN NUMBER,
68 x_RELATED_ID5 IN NUMBER,
69 x_ORG_ID IN NUMBER);
70
71
72 PROCEDURE Delete_Row( x_QUAL_TYPE_ID IN NUMBER);
73
74 END JTF_QUAL_TYPES_PKG;