1 PACKAGE JTF_TERR_CNR_GROUP_VALUES_PKG AUTHID CURRENT_USER AS
2 /* $Header: jtfvtcvs.pls 120.0 2005/06/02 18:22:40 appldev ship $ */
3
4 -- 05/15/01 ARPATEL Created table handlers
5 -- 05/16/01 ARPATEL Added Start_Date_Active and End_Date_Active
6 -- 04/25/02 ARPATEL Removed SECURITY_GROUP_ID references for bug#2269867
7
8 PROCEDURE Insert_Row(
9 x_Rowid IN OUT NOCOPY VARCHAR2,
10 x_CNR_GROUP_VALUE_ID IN OUT NOCOPY NUMBER,
11 x_LAST_UPDATED_BY IN NUMBER,
12 x_LAST_UPDATE_DATE IN DATE,
13 x_CREATED_BY IN NUMBER,
14 x_CREATION_DATE IN DATE,
15 x_LAST_UPDATE_LOGIN IN NUMBER,
16 x_CNR_GROUP_ID IN NUMBER,
17 x_COMPARISON_OPERATOR IN VARCHAR2,
18 x_LOW_VALUE_CHAR IN VARCHAR2,
19 x_HIGH_VALUE_CHAR IN VARCHAR2,
20 x_START_DATE_ACTIVE IN DATE,
21 x_END_DATE_ACTIVE IN DATE,
22 x_ORG_ID IN NUMBER);
23
24
25
26 PROCEDURE Lock_Row(
27 x_Rowid IN OUT NOCOPY VARCHAR2,
28 x_CNR_GROUP_VALUE_ID IN OUT NOCOPY NUMBER,
29 x_LAST_UPDATED_BY IN NUMBER,
30 x_LAST_UPDATE_DATE IN DATE,
31 x_CREATED_BY IN NUMBER,
32 x_CREATION_DATE IN DATE,
33 x_LAST_UPDATE_LOGIN IN NUMBER,
34 x_CNR_GROUP_ID IN NUMBER,
35 x_COMPARISON_OPERATOR IN VARCHAR2,
36 x_LOW_VALUE_CHAR IN VARCHAR2,
37 x_HIGH_VALUE_CHAR IN VARCHAR2,
38 x_START_DATE_ACTIVE IN DATE,
39 x_END_DATE_ACTIVE IN DATE,
40 x_ORG_ID IN NUMBER);
41
42
43
44 PROCEDURE Update_Row(
45 x_Rowid IN OUT NOCOPY VARCHAR2,
46 x_CNR_GROUP_VALUE_ID IN OUT NOCOPY NUMBER,
47 x_LAST_UPDATED_BY IN NUMBER,
48 x_LAST_UPDATE_DATE IN DATE,
49 x_CREATED_BY IN NUMBER,
50 x_CREATION_DATE IN DATE,
51 x_LAST_UPDATE_LOGIN IN NUMBER,
52 x_CNR_GROUP_ID IN NUMBER,
53 x_COMPARISON_OPERATOR IN VARCHAR2,
54 x_LOW_VALUE_CHAR IN VARCHAR2,
55 x_HIGH_VALUE_CHAR IN VARCHAR2,
56 x_START_DATE_ACTIVE IN DATE,
57 x_END_DATE_ACTIVE IN DATE,
58 x_ORG_ID IN NUMBER);
59
60
61
62 PROCEDURE Delete_Row( x_CNR_GROUP_VALUE_ID IN NUMBER);
63
64
65 END JTF_TERR_CNR_GROUP_VALUES_PKG;