1 PACKAGE JTF_TERR_TYPE_USGS_PKG AS
2 /* $Header: jtfvttus.pls 120.0 2005/06/02 18:23:07 appldev ship $ */
3
4
5 -- 02/17/00 VNEDUNGA Changing Table handler to accept ORG_ID
6
7 PROCEDURE Insert_Row(
8 x_Rowid IN OUT NOCOPY VARCHAR2,
9 x_TERR_TYPE_USG_ID IN OUT NOCOPY NUMBER,
10 x_LAST_UPDATED_BY IN NUMBER,
11 x_LAST_UPDATE_DATE IN DATE,
12 x_CREATED_BY IN NUMBER,
13 x_CREATION_DATE IN DATE,
14 x_LAST_UPDATE_LOGIN IN NUMBER,
15 x_SOURCE_ID IN NUMBER,
16 x_TERR_TYPE_ID IN NUMBER,
17 x_ORG_ID IN NUMBER);
18
19
20
21 PROCEDURE Lock_Row(
22 x_Rowid IN VARCHAR2,
23 x_TERR_TYPE_USG_ID IN NUMBER,
24 x_LAST_UPDATED_BY IN NUMBER,
25 x_LAST_UPDATE_DATE IN DATE,
26 x_CREATED_BY IN NUMBER,
27 x_CREATION_DATE IN DATE,
28 x_LAST_UPDATE_LOGIN IN NUMBER,
29 x_TERR_TYPE_ID IN NUMBER,
30 x_SOURCE_ID IN NUMBER,
31 x_ORG_ID IN NUMBER);
32
33
34
35 PROCEDURE Update_Row(
36 x_Rowid IN VARCHAR2,
37 x_TERR_TYPE_USG_ID IN NUMBER,
38 x_LAST_UPDATED_BY IN NUMBER,
39 x_LAST_UPDATE_DATE IN DATE,
40 x_CREATED_BY IN NUMBER,
41 x_CREATION_DATE IN DATE,
42 x_LAST_UPDATE_LOGIN IN NUMBER,
43 x_TERR_TYPE_ID IN NUMBER,
44 x_SOURCE_ID IN NUMBER,
45 x_ORG_ID IN NUMBER);
46
47
48
49 PROCEDURE Delete_Row( x_TERR_TYPE_USG_ID IN NUMBER);
50
51 END JTF_TERR_TYPE_USGS_PKG;