1 PACKAGE JTF_TERR_TYPE_QUAL_PKG AS
2 /* $Header: jtfvttqs.pls 120.0 2005/06/02 18:23:06 appldev ship $ */
3
4 -----------------------------------------------------------------------
5 -- HISTORY
6 -- 11/20/99 VNEDUNGA Changing qualifer Mode form
7 -- number to varchar2
8 -- 02/17/00 VNEDUNGA Changing Table handler to accept ORG_ID
9 --
10 -- End of Comments
11 ------------------------------------------------------------------------
12
13 PROCEDURE Insert_Row(
14 x_Rowid IN OUT NOCOPY VARCHAR2,
15 x_TERR_TYPE_QUAL_ID IN OUT NOCOPY NUMBER,
16 x_LAST_UPDATED_BY IN NUMBER,
17 x_LAST_UPDATE_DATE IN DATE,
18 x_CREATED_BY IN NUMBER,
19 x_CREATION_DATE IN DATE,
20 x_LAST_UPDATE_LOGIN IN NUMBER,
21 x_QUAL_USG_ID IN NUMBER,
22 x_TERR_TYPE_ID IN NUMBER,
23 x_EXCLUSIVE_USE_FLAG IN VARCHAR2,
24 x_OVERLAP_ALLOWED_FLAG IN VARCHAR2,
25 x_IN_USE_FLAG IN VARCHAR2,
26 x_QUALIFIER_MODE IN VARCHAR2,
27 x_ORG_ID IN NUMBER);
28
29
30
31 PROCEDURE Lock_Row(
32 x_Rowid IN VARCHAR2,
33 x_TERR_TYPE_QUAL_ID IN NUMBER,
34 x_LAST_UPDATED_BY IN NUMBER,
35 x_LAST_UPDATE_DATE IN DATE,
36 x_CREATED_BY IN NUMBER,
37 x_CREATION_DATE IN DATE,
38 x_LAST_UPDATE_LOGIN IN NUMBER,
39 x_QUAL_USG_ID IN NUMBER,
40 x_TERR_TYPE_ID IN NUMBER,
41 x_EXCLUSIVE_USE_FLAG IN VARCHAR2,
42 x_OVERLAP_ALLOWED_FLAG IN VARCHAR2,
43 x_IN_USE_FLAG IN VARCHAR2,
44 x_QUALIFIER_MODE IN VARCHAR2,
45 x_ORG_ID IN NUMBER);
46
47
48
49 PROCEDURE Update_Row(
50 x_Rowid IN VARCHAR2,
51 x_TERR_TYPE_QUAL_ID IN NUMBER,
52 x_LAST_UPDATED_BY IN NUMBER,
53 x_LAST_UPDATE_DATE IN DATE,
54 x_CREATED_BY IN NUMBER,
55 x_CREATION_DATE IN DATE,
56 x_LAST_UPDATE_LOGIN IN NUMBER,
57 x_QUAL_USG_ID IN NUMBER,
58 x_TERR_TYPE_ID IN NUMBER,
59 x_EXCLUSIVE_USE_FLAG IN VARCHAR2,
60 x_OVERLAP_ALLOWED_FLAG IN VARCHAR2,
61 x_IN_USE_FLAG IN VARCHAR2,
62 x_QUALIFIER_MODE IN VARCHAR2,
63 x_ORG_ID IN NUMBER);
64
65
66 PROCEDURE Delete_Row( x_TERR_TYPE_QUAL_ID IN NUMBER);
67
68 END JTF_TERR_TYPE_QUAL_PKG;