1 PACKAGE JTF_TERR_QTYPE_USGS_PKG AS
2 /* $Header: jtfvquts.pls 120.0 2005/06/02 18:22:19 appldev ship $ */
3
4 PROCEDURE Insert_Row(
5 x_Rowid IN OUT NOCOPY VARCHAR2,
6 x_TERR_QTYPE_USG_ID IN OUT NOCOPY NUMBER,
7 x_LAST_UPDATED_BY IN NUMBER,
8 x_LAST_UPDATE_DATE IN DATE,
9 x_CREATED_BY IN NUMBER,
10 x_CREATION_DATE IN DATE,
11 x_LAST_UPDATE_LOGIN IN NUMBER,
12 x_TERR_ID IN NUMBER,
13 x_QUAL_TYPE_USG_ID IN NUMBER,
14 x_ORG_ID IN NUMBER);
15
16
17
18 PROCEDURE Lock_Row(
19 x_Rowid IN VARCHAR2,
20 x_TERR_QTYPE_USG_ID IN NUMBER,
21 x_LAST_UPDATED_BY IN NUMBER,
22 x_LAST_UPDATE_DATE IN DATE,
23 x_CREATED_BY IN NUMBER,
24 x_CREATION_DATE IN DATE,
25 x_LAST_UPDATE_LOGIN IN NUMBER,
26 x_TERR_ID IN NUMBER,
27 x_QUAL_TYPE_USG_ID IN NUMBER,
28 x_ORG_ID IN NUMBER);
29
30
31
32 PROCEDURE Update_Row(
33 x_Rowid IN VARCHAR2,
34 x_TERR_QTYPE_USG_ID IN NUMBER,
35 x_LAST_UPDATED_BY IN NUMBER,
36 x_LAST_UPDATE_DATE IN DATE,
37 x_CREATED_BY IN NUMBER,
38 x_CREATION_DATE IN DATE,
39 x_LAST_UPDATE_LOGIN IN NUMBER,
40 x_TERR_ID IN NUMBER,
41 x_QUAL_TYPE_USG_ID IN NUMBER,
42 x_ORG_ID IN NUMBER);
43
44
45
46 PROCEDURE Delete_Row( x_TERR_QTYPE_USG_ID IN NUMBER);
47
48 END JTF_TERR_QTYPE_USGS_PKG;