DBA Data[Home] [Help]

PACKAGE: APPS.CS_COUNTERFILTER_PVT

Source


1 Package CS_COUNTERFILTER_PVT AUTHID CURRENT_USER AS
2 /* $Header: csctdfls.pls 115.7 2002/11/18 21:57:14 mkommuri ship $ */
3   ---------------------------------------------------------------------------
4   -- GLOBAL DATASTRUCTURES
5   ---------------------------------------------------------------------------
6   TYPE CounterFilter_Rec_Type IS RECORD (
7     counter_der_filter_id          NUMBER := NULL,
8     counter_id                     NUMBER := NULL,
9     seq_no                         NUMBER := NULL,
10     left_paren                     CS_COUNTER_DER_FILTERS.LEFT_PAREN%TYPE := NULL,
11     counter_property_id            NUMBER := NULL,
12     relational_operator            CS_COUNTER_DER_FILTERS.RELATIONAL_OPERATOR%TYPE := NULL,
13     right_paren                    CS_COUNTER_DER_FILTERS.RIGHT_PAREN%TYPE := NULL,
14     right_value                    CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := NULL,
15     logical_operator               CS_COUNTER_DER_FILTERS.LOGICAL_OPERATOR%TYPE := NULL,
16     last_update_date               CS_COUNTER_DER_FILTERS.LAST_UPDATE_DATE%TYPE := NULL,
17     last_updated_by                NUMBER := NULL,
18     creation_date                  CS_COUNTER_DER_FILTERS.CREATION_DATE%TYPE := NULL,
19     created_by                     NUMBER := NULL,
20     last_update_login              NUMBER := NULL,
21     attribute1                     CS_COUNTER_DER_FILTERS.ATTRIBUTE1%TYPE := NULL,
22     attribute2                     CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := NULL,
23     attribute3                     CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := NULL,
24     attribute4                     CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := NULL,
25     attribute5                     CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := NULL,
26     attribute6                     CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := NULL,
27     attribute7                     CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := NULL,
28     attribute8                     CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := NULL,
29     attribute9                     CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := NULL,
30     attribute10                    CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := NULL,
31     attribute11                    CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := NULL,
32     attribute12                    CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := NULL,
33     attribute13                    CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := NULL,
34     attribute14                    CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := NULL,
35     attribute15                    CS_COUNTER_DER_FILTERS.ATTRIBUTE15%TYPE := NULL,
36     context                        CS_COUNTER_DER_FILTERS.CONTEXT%TYPE := NULL,
37     object_version_number          NUMBER := NULL);
38   G_MISS_counterfilter_rec                CounterFilter_Rec_Type;
39   TYPE CounterFilter_Val_Rec_Type IS RECORD (
40     counter_der_filter_id          NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
41     counter_id                     NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
42     seq_no                         NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
43     left_paren                     CS_COUNTER_DER_FILTERS.LEFT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
44     counter_property_id            NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
45     relational_operator            CS_COUNTER_DER_FILTERS.RELATIONAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
46     right_paren                    CS_COUNTER_DER_FILTERS.RIGHT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
47     right_value                    CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
48     logical_operator               CS_COUNTER_DER_FILTERS.LOGICAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
49     last_update_date               CS_COUNTER_DER_FILTERS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
50     last_updated_by                NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
51     creation_date                  CS_COUNTER_DER_FILTERS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
52     created_by                     NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
53     last_update_login              NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
54     attribute1                     CS_COUNTER_DER_FILTERS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
55     attribute2                     CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
56     attribute3                     CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
57     attribute4                     CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
58     attribute5                     CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
59     attribute6                     CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
60     attribute7                     CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
61     attribute8                     CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
62     attribute9                     CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
63     attribute10                    CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
64     attribute11                    CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
65     attribute12                    CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
66     attribute13                    CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
67     attribute14                    CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
68     attribute15                    CS_COUNTER_DER_FILTERS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
69     context                        CS_COUNTER_DER_FILTERS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
70     object_version_number          NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
71   G_MISS_counterfilter_val_rec            CounterFilter_Val_Rec_Type;
72   ---------------------------------------------------------------------------
73   -- GLOBAL MESSAGE CONSTANTS
74   ---------------------------------------------------------------------------
75   G_FND_APP			CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FND_APP;
76   G_FORM_UNABLE_TO_RESERVE_REC	CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_UNABLE_TO_RESERVE_REC;
77   G_FORM_RECORD_DELETED		CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_DELETED;
78   G_FORM_RECORD_CHANGED		CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_FORM_RECORD_CHANGED;
79   G_RECORD_LOGICALLY_DELETED	CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_RECORD_LOGICALLY_DELETED;
80   G_REQUIRED_VALUE		CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_REQUIRED_VALUE;
81   G_INVALID_VALUE			CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_INVALID_VALUE;
82   G_COL_NAME_TOKEN		CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_COL_NAME_TOKEN;
83   G_PARENT_TABLE_TOKEN		CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_PARENT_TABLE_TOKEN;
84   G_CHILD_TABLE_TOKEN		CONSTANT VARCHAR2(200) := TAPI_DEV_KIT.G_CHILD_TABLE_TOKEN;
85   ---------------------------------------------------------------------------
86   -- GLOBAL VARIABLES
87   ---------------------------------------------------------------------------
88   G_PKG_NAME			CONSTANT	VARCHAR2(200) := 'CS_COUNTERFILTER_PVT';
89   G_APP_NAME			CONSTANT 	VARCHAR2(3) :=  TAPI_DEV_KIT.G_APP_NAME;
90   ---------------------------------------------------------------------------
91   -- Procedures and Functions
92   ---------------------------------------------------------------------------
93 
94   PROCEDURE insert_row
95   (
96     p_api_version                  IN NUMBER,
97     p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
98     p_validation_level             IN NUMBER,
99     p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
100     x_return_status                OUT NOCOPY VARCHAR2,
101     x_msg_count                    OUT NOCOPY NUMBER,
102     x_msg_data                     OUT NOCOPY VARCHAR2,
103     p_counterfilter_rec            IN CounterFilter_Rec_Type := G_MISS_COUNTERFILTER_REC,
104     x_counter_der_filter_id        OUT NOCOPY NUMBER,
105     x_object_version_number        OUT NOCOPY NUMBER);
106 
107   PROCEDURE insert_row
108   (
109     p_api_version                  IN NUMBER,
110     p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
111     p_validation_level             IN NUMBER,
112     p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
113     x_return_status                OUT NOCOPY VARCHAR2,
114     x_msg_count                    OUT NOCOPY NUMBER,
115     x_msg_data                     OUT NOCOPY VARCHAR2,
116     p_counter_id                   IN NUMBER := NULL,
117     p_seq_no                       IN NUMBER := NULL,
118     p_left_paren                   IN CS_COUNTER_DER_FILTERS.LEFT_PAREN%TYPE := NULL,
119     p_counter_property_id          IN NUMBER := NULL,
120     p_relational_operator          IN CS_COUNTER_DER_FILTERS.RELATIONAL_OPERATOR%TYPE := NULL,
121     p_right_paren                  IN CS_COUNTER_DER_FILTERS.RIGHT_PAREN%TYPE := NULL,
122     p_right_value                  IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := NULL,
123     p_logical_operator             IN CS_COUNTER_DER_FILTERS.LOGICAL_OPERATOR%TYPE := NULL,
124     p_last_update_date             IN CS_COUNTER_DER_FILTERS.LAST_UPDATE_DATE%TYPE := NULL,
125     p_last_updated_by              IN NUMBER := NULL,
126     p_creation_date                IN CS_COUNTER_DER_FILTERS.CREATION_DATE%TYPE := NULL,
127     p_created_by                   IN NUMBER := NULL,
128     p_last_update_login            IN NUMBER := NULL,
129     p_attribute1                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE1%TYPE := NULL,
130     p_attribute2                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := NULL,
131     p_attribute3                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := NULL,
132     p_attribute4                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := NULL,
133     p_attribute5                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := NULL,
134     p_attribute6                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := NULL,
135     p_attribute7                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := NULL,
136     p_attribute8                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := NULL,
137     p_attribute9                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := NULL,
138     p_attribute10                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := NULL,
139     p_attribute11                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := NULL,
140     p_attribute12                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := NULL,
141     p_attribute13                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := NULL,
142     p_attribute14                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := NULL,
143     p_attribute15                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE15%TYPE := NULL,
144     p_context                      IN CS_COUNTER_DER_FILTERS.CONTEXT%TYPE := NULL,
145     p_object_version_number        IN NUMBER := NULL,
146     x_counter_der_filter_id        OUT NOCOPY NUMBER,
147     x_object_version_number        OUT NOCOPY NUMBER);
148   Procedure lock_row
149   (
150     p_api_version                  IN NUMBER,
151     p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
152     p_validation_level             IN NUMBER,
153     p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
154     x_return_status                OUT NOCOPY VARCHAR2,
155     x_msg_count                    OUT NOCOPY NUMBER,
156     x_msg_data                     OUT NOCOPY VARCHAR2,
157     p_counter_der_filter_id        IN NUMBER,
158     p_object_version_number        IN NUMBER);
159   Procedure update_row
160   (
161     p_api_version                  IN NUMBER,
162     p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
163     p_validation_level             IN NUMBER,
164     p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
165     x_return_status                OUT NOCOPY VARCHAR2,
166     x_msg_count                    OUT NOCOPY NUMBER,
167     x_msg_data                     OUT NOCOPY VARCHAR2,
168     p_counterfilter_val_rec        IN CounterFilter_Val_Rec_Type := G_MISS_COUNTERFILTER_VAL_REC,
169     x_object_version_number        OUT NOCOPY NUMBER);
170   Procedure update_row
171   (
172     p_api_version                  IN NUMBER,
173     p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
174     p_validation_level             IN NUMBER,
175     p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
176     x_return_status                OUT NOCOPY VARCHAR2,
177     x_msg_count                    OUT NOCOPY NUMBER,
178     x_msg_data                     OUT NOCOPY VARCHAR2,
179     p_counter_der_filter_id        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
180     p_counter_id                   IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
181     p_seq_no                       IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
182     p_left_paren                   IN CS_COUNTER_DER_FILTERS.LEFT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
183     p_counter_property_id          IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
184     p_relational_operator          IN CS_COUNTER_DER_FILTERS.RELATIONAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
185     p_right_paren                  IN CS_COUNTER_DER_FILTERS.RIGHT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
186     p_right_value                  IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
187     p_logical_operator             IN CS_COUNTER_DER_FILTERS.LOGICAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
188     p_last_update_date             IN CS_COUNTER_DER_FILTERS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
189     p_last_updated_by              IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
190     p_creation_date                IN CS_COUNTER_DER_FILTERS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
191     p_created_by                   IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
192     p_last_update_login            IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
193     p_attribute1                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
194     p_attribute2                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
195     p_attribute3                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
196     p_attribute4                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
197     p_attribute5                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
198     p_attribute6                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
199     p_attribute7                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
200     p_attribute8                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
201     p_attribute9                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
202     p_attribute10                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
203     p_attribute11                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
204     p_attribute12                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
205     p_attribute13                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
206     p_attribute14                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
207     p_attribute15                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
208     p_context                      IN CS_COUNTER_DER_FILTERS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
209     p_object_version_number        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
210     x_object_version_number        OUT NOCOPY NUMBER);
211   Procedure delete_row
212   (
213     p_api_version                  IN NUMBER,
214     p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
215     p_validation_level             IN NUMBER,
216     p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
217     x_return_status                OUT NOCOPY VARCHAR2,
221   PROCEDURE validate_row
218     x_msg_count                    OUT NOCOPY NUMBER,
219     x_msg_data                     OUT NOCOPY VARCHAR2,
220     p_counter_der_filter_id        IN NUMBER);
222   (
223     p_api_version                  IN NUMBER,
224     p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
225     p_validation_level             IN NUMBER,
226     p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
227     x_return_status                OUT NOCOPY VARCHAR2,
228     x_msg_count                    OUT NOCOPY NUMBER,
229     x_msg_data                     OUT NOCOPY VARCHAR2,
230     p_counterfilter_val_rec        IN CounterFilter_Val_Rec_Type := G_MISS_COUNTERFILTER_VAL_REC);
231   PROCEDURE validate_row
232   (
233     p_api_version                  IN NUMBER,
234     p_init_msg_list                IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
235     p_validation_level             IN NUMBER,
236     p_commit                       IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
237     x_return_status                OUT NOCOPY VARCHAR2,
238     x_msg_count                    OUT NOCOPY NUMBER,
239     x_msg_data                     OUT NOCOPY VARCHAR2,
240     p_counter_der_filter_id        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
241     p_counter_id                   IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
242     p_seq_no                       IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
243     p_left_paren                   IN CS_COUNTER_DER_FILTERS.LEFT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
244     p_counter_property_id          IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
245     p_relational_operator          IN CS_COUNTER_DER_FILTERS.RELATIONAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
246     p_right_paren                  IN CS_COUNTER_DER_FILTERS.RIGHT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
247     p_right_value                  IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
248     p_logical_operator             IN CS_COUNTER_DER_FILTERS.LOGICAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
249     p_last_update_date             IN CS_COUNTER_DER_FILTERS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
250     p_last_updated_by              IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
251     p_creation_date                IN CS_COUNTER_DER_FILTERS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
252     p_created_by                   IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
253     p_last_update_login            IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
254     p_attribute1                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
255     p_attribute2                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
256     p_attribute3                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
257     p_attribute4                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
258     p_attribute5                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
259     p_attribute6                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
260     p_attribute7                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
261     p_attribute8                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
262     p_attribute9                   IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
263     p_attribute10                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
264     p_attribute11                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
265     p_attribute12                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
266     p_attribute13                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
267     p_attribute14                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
268     p_attribute15                  IN CS_COUNTER_DER_FILTERS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
269     p_context                      IN CS_COUNTER_DER_FILTERS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
270     p_object_version_number        IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM);
271 END CS_COUNTERFILTER_PVT;