[Home] [Help]
PACKAGE: APPS.JTF_TYPE_QTYPE_USGS_PKG
Source
1 PACKAGE JTF_TYPE_QTYPE_USGS_PKG AUTHID CURRENT_USER as
2 /* $Header: jtfvtqus.pls 115.1 2000/02/29 18:25:52 pkm 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 VARCHAR2,
9 x_TYPE_QTYPE_USG_ID IN OUT 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_TERR_TYPE_ID IN NUMBER,
16 x_QUAL_TYPE_USG_ID IN NUMBER,
17 x_ORG_ID IN NUMBER);
18
19
20
21 PROCEDURE Lock_Row(
22 x_Rowid IN VARCHAR2,
23 x_TYPE_QTYPE_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_QUAL_TYPE_USG_ID IN NUMBER,
31 x_ORG_ID IN NUMBER);
32
33
34
35 PROCEDURE Update_Row(
36 x_Rowid IN VARCHAR2,
37 x_TYPE_QTYPE_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_QUAL_TYPE_USG_ID IN NUMBER,
45 x_ORG_ID IN NUMBER);
46
47
48
49 PROCEDURE Delete_Row( x_TYPE_QTYPE_USG_ID IN NUMBER);
50
51
52 END JTF_TYPE_QTYPE_USGS_PKG;