1 PACKAGE JTF_TERR_VALUES_PKG AS
2 /* $Header: jtfvtvls.pls 120.0 2005/06/02 18:23:11 appldev ship $ */
3 -- 02/22/00 JDOCHERT Passing in ORG_ID to Insert/Update/Lock
4
5
6
7 PROCEDURE Insert_Row(
8 x_Rowid IN OUT NOCOPY VARCHAR2,
9 x_TERR_VALUE_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_TERR_QUAL_ID IN NUMBER,
16 x_INCLUDE_FLAG IN VARCHAR2,
17 x_COMPARISON_OPERATOR IN VARCHAR2,
18 x_LOW_VALUE_CHAR IN VARCHAR2,
19 x_HIGH_VALUE_CHAR IN VARCHAR2,
20 x_LOW_VALUE_NUMBER IN NUMBER,
21 x_HIGH_VALUE_NUMBER IN NUMBER,
22 x_VALUE_SET IN NUMBER,
23 x_INTEREST_TYPE_ID IN NUMBER,
24 x_PRIMARY_INTEREST_CODE_ID IN NUMBER,
25 x_SECONDARY_INTEREST_CODE_ID IN NUMBER,
26 x_CURRENCY_CODE IN VARCHAR2,
27 x_ID_USED_FLAG IN VARCHAR2,
28 x_LOW_VALUE_CHAR_ID IN NUMBER,
29 x_ORG_ID IN NUMBER,
30 x_CNR_GROUP_ID IN NUMBER,
31 x_VALUE1_ID IN NUMBER,
32 x_VALUE2_ID IN NUMBER,
33 x_VALUE3_ID IN NUMBER,
34 x_VALUE4_ID IN NUMBER);
35
36
37
38 PROCEDURE Lock_Row(
39 x_Rowid IN VARCHAR2,
40 x_TERR_VALUE_ID IN NUMBER,
41 x_LAST_UPDATED_BY IN NUMBER,
42 x_LAST_UPDATE_DATE IN DATE,
43 x_CREATED_BY IN NUMBER,
44 x_CREATION_DATE IN DATE,
45 x_LAST_UPDATE_LOGIN IN NUMBER,
46 x_TERR_QUAL_ID IN NUMBER,
47 x_INCLUDE_FLAG IN VARCHAR2,
48 x_COMPARISON_OPERATOR IN VARCHAR2,
49 x_LOW_VALUE_CHAR IN VARCHAR2,
50 x_HIGH_VALUE_CHAR IN VARCHAR2,
51 x_LOW_VALUE_NUMBER IN NUMBER,
52 x_HIGH_VALUE_NUMBER IN NUMBER,
53 x_VALUE_SET IN NUMBER,
54 x_INTEREST_TYPE_ID IN NUMBER,
55 x_PRIMARY_INTEREST_CODE_ID IN NUMBER,
56 x_SECONDARY_INTEREST_CODE_ID IN NUMBER,
57 x_CURRENCY_CODE IN VARCHAR2,
58 x_ID_USED_FLAG IN VARCHAR2,
59 x_LOW_VALUE_CHAR_ID IN NUMBER,
60 x_ORG_ID IN NUMBER,
61 x_CNR_GROUP_ID IN NUMBER,
62 x_VALUE1_ID IN NUMBER,
63 x_VALUE2_ID IN NUMBER,
64 x_VALUE3_ID IN NUMBER,
65 x_VALUE4_ID IN NUMBER);
66
67
68
69 PROCEDURE Update_Row(
70 x_Rowid IN VARCHAR2,
71 x_TERR_VALUE_ID IN NUMBER,
72 x_LAST_UPDATED_BY IN NUMBER,
73 x_LAST_UPDATE_DATE IN DATE,
74 x_CREATED_BY IN NUMBER,
75 x_CREATION_DATE IN DATE,
76 x_LAST_UPDATE_LOGIN IN NUMBER,
77 x_TERR_QUAL_ID IN NUMBER,
78 x_INCLUDE_FLAG IN VARCHAR2,
79 x_COMPARISON_OPERATOR IN VARCHAR2,
80 x_LOW_VALUE_CHAR IN VARCHAR2,
81 x_HIGH_VALUE_CHAR IN VARCHAR2,
82 x_LOW_VALUE_NUMBER IN NUMBER,
83 x_HIGH_VALUE_NUMBER IN NUMBER,
84 x_VALUE_SET IN NUMBER,
85 x_INTEREST_TYPE_ID IN NUMBER,
86 x_PRIMARY_INTEREST_CODE_ID IN NUMBER,
87 x_SECONDARY_INTEREST_CODE_ID IN NUMBER,
88 x_CURRENCY_CODE IN VARCHAR2,
89 x_ID_USED_FLAG IN VARCHAR2,
90 x_LOW_VALUE_CHAR_ID IN NUMBER,
91 x_ORG_ID IN NUMBER,
92 x_CNR_GROUP_ID IN NUMBER,
93 x_VALUE1_ID IN NUMBER,
94 x_VALUE2_ID IN NUMBER,
95 x_VALUE3_ID IN NUMBER,
96 x_VALUE4_ID IN NUMBER);
97
98
99
100 PROCEDURE Delete_Row( x_TERR_VALUE_ID IN NUMBER);
101
102
103 END JTF_TERR_VALUES_PKG;