1 PACKAGE JTF_QUAL_TYPE_USGS_PKG AUTHID CURRENT_USER AS
2 /* $Header: jtfvqtus.pls 120.0 2005/06/02 18:22:16 appldev ship $ */
3
4
5 PROCEDURE Insert_Row(
6 x_Rowid IN OUT NOCOPY VARCHAR2,
7 x_QUAL_TYPE_USG_ID IN OUT NOCOPY NUMBER,
8 x_LAST_UPDATE_DATE IN DATE,
9 x_LAST_UPDATED_BY IN NUMBER,
10 x_CREATION_DATE IN DATE,
11 x_CREATED_BY IN NUMBER,
12 x_LAST_UPDATE_LOGIN IN NUMBER,
13 x_QUAL_TYPE_ID IN NUMBER,
14 x_SOURCE_ID IN NUMBER,
15
16 -- x_PACKAGE_FILENAME IN VARCHAR2,
17 x_PACKAGE_NAME IN VARCHAR2,
18 x_PACKAGE_SPOOL_FILENAME IN VARCHAR2,
19
20 x_ORG_ID IN NUMBER);
21
22
23
24 PROCEDURE Lock_Row(
25 x_Rowid IN VARCHAR2,
26 x_QUAL_TYPE_USG_ID IN NUMBER,
27 x_LAST_UPDATE_DATE IN DATE,
28 x_LAST_UPDATED_BY IN NUMBER,
29 x_CREATION_DATE IN DATE,
30 x_CREATED_BY IN NUMBER,
31 x_LAST_UPDATE_LOGIN IN NUMBER,
32 x_QUAL_TYPE_ID IN NUMBER,
33 x_SOURCE_ID IN NUMBER,
34 -- x_PACKAGE_FILENAME IN VARCHAR2,
35 x_PACKAGE_NAME IN VARCHAR2,
36 x_PACKAGE_SPOOL_FILENAME IN VARCHAR2,
37
38 x_ORG_ID IN NUMBER);
39
40
41
42 PROCEDURE Update_Row(
43 x_Rowid IN VARCHAR2,
44 x_QUAL_TYPE_USG_ID IN NUMBER,
45 x_LAST_UPDATE_DATE IN DATE,
46 x_LAST_UPDATED_BY IN NUMBER,
47 x_CREATION_DATE IN DATE,
48 x_CREATED_BY IN NUMBER,
49 x_LAST_UPDATE_LOGIN IN NUMBER,
50 x_QUAL_TYPE_ID IN NUMBER,
51 x_SOURCE_ID IN NUMBER,
52 -- x_PACKAGE_FILENAME IN VARCHAR2,
53 x_PACKAGE_NAME IN VARCHAR2,
54 x_PACKAGE_SPOOL_FILENAME IN VARCHAR2,
55 x_ORG_ID IN NUMBER);
56
57
58
59 PROCEDURE Delete_Row( x_QUAL_TYPE_USG_ID IN NUMBER);
60
61 END JTF_QUAL_TYPE_USGS_PKG;