1 PACKAGE JTF_TERR_USGS_PKG AUTHID CURRENT_USER AS
2 /* $Header: jtfvtuss.pls 120.0 2005/06/02 18:23:10 appldev ship $ */
3
4 PROCEDURE Insert_Row(
5 x_Rowid IN OUT NOCOPY VARCHAR2,
6 x_TERR_USG_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_TERR_ID IN NUMBER,
13 x_SOURCE_ID IN NUMBER,
14 x_ORG_ID IN NUMBER);
15
16
17
18 PROCEDURE Lock_Row(
19 x_Rowid IN VARCHAR2,
20 x_TERR_USG_ID IN NUMBER,
21 x_LAST_UPDATE_DATE IN DATE,
22 x_LAST_UPDATED_BY IN NUMBER,
23 x_CREATION_DATE IN DATE,
24 x_CREATED_BY IN NUMBER,
25 x_LAST_UPDATE_LOGIN IN NUMBER,
26 x_TERR_ID IN NUMBER,
27 x_SOURCE_ID IN NUMBER,
28 x_ORG_ID IN NUMBER);
29
30
31
32 PROCEDURE Update_Row(
33 x_Rowid IN VARCHAR2,
34 x_TERR_USG_ID IN NUMBER,
35 x_LAST_UPDATE_DATE IN DATE,
36 x_LAST_UPDATED_BY IN NUMBER,
37 x_CREATION_DATE IN DATE,
38 x_CREATED_BY IN NUMBER,
39 x_LAST_UPDATE_LOGIN IN NUMBER,
40 x_TERR_ID IN NUMBER,
41 x_SOURCE_ID IN NUMBER,
42 x_ORG_ID IN NUMBER);
43
44
45
46 PROCEDURE Delete_Row( x_TERR_USG_ID IN NUMBER);
47
48
49 END JTF_TERR_USGS_PKG;