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