1 PACKAGE IEX_BALI_FILTERS_PKG as
2 /* $Header: iextbfls.pls 120.2 2004/05/14 15:17:40 jsanju noship $ */
3
4 PROCEDURE Insert_Row
5 (x_rowid in out nocopy varchar2
6 ,x_bali_filter_id in number
7 ,x_bali_filter_name in varchar2
8 ,x_bali_datasource in varchar2
9 ,x_bali_user_id in number
10 ,x_bali_col_alias in varchar2
11 ,x_bali_col_data_type in varchar2
12 ,x_bali_col_label_text in varchar2
13 ,x_bali_col_condition_code in varchar2
14 ,x_bali_col_condition_value in varchar2
15 ,x_bali_col_value in varchar2
16 ,x_right_parenthesis_code in varchar2
17 ,x_left_parenthesis_code in varchar2
18 ,x_boolean_operator_code in varchar2
19 ,x_object_version_number in number
20 ,x_request_id in number,
21 x_program_application_id in number,
22 x_program_id in number,
23 x_program_update_date in date,
24 x_attribute_category in varchar2,
25 x_attribute1 in varchar2,
26 x_attribute2 in varchar2,
27 x_attribute3 in varchar2,
28 x_attribute4 in varchar2,
29 x_attribute5 in varchar2,
30 x_attribute6 in varchar2,
31 x_attribute7 in varchar2,
32 x_attribute8 in varchar2,
33 x_attribute9 in varchar2,
34 x_attribute10 in varchar2,
35 x_attribute11 in varchar2,
36 x_attribute12 in varchar2,
37 x_attribute13 in varchar2,
38 x_attribute14 in varchar2,
39 x_attribute15 in varchar2,
40 x_creation_date in date,
41 x_created_by in number,
42 x_last_update_date in date,
43 x_last_updated_by in number,
44 x_last_update_login in number);
45
46
47 /* Update_Row procedure */
48 PROCEDURE Update_Row(
49 x_bali_filter_id in number
50 ,x_bali_filter_name in varchar2
51 ,x_bali_datasource in varchar2
52 ,x_bali_user_id in number
53 ,x_bali_col_alias in varchar2
54 ,x_bali_col_data_type in varchar2
55 ,x_bali_col_label_text in varchar2
56 ,x_bali_col_condition_code in varchar2
57 ,x_bali_col_condition_value in varchar2
58 ,x_bali_col_value in varchar2
59 ,x_right_parenthesis_code in varchar2
60 ,x_left_parenthesis_code in varchar2
61 ,x_boolean_operator_code in varchar2
62 ,x_object_version_number in number
63 ,x_request_id in number,
64 x_program_application_id in number,
65 x_program_id in number,
66 x_program_update_date in date,
67 x_attribute_category in varchar2,
68 x_attribute1 in varchar2,
69 x_attribute2 in varchar2,
70 x_attribute3 in varchar2,
71 x_attribute4 in varchar2,
72 x_attribute5 in varchar2,
73 x_attribute6 in varchar2,
74 x_attribute7 in varchar2,
75 x_attribute8 in varchar2,
76 x_attribute9 in varchar2,
77 x_attribute10 in varchar2,
78 x_attribute11 in varchar2,
79 x_attribute12 in varchar2,
80 x_attribute13 in varchar2,
81 x_attribute14 in varchar2,
82 x_attribute15 in varchar2,
83 x_last_update_date in date,
84 x_last_updated_by in number,
85 x_last_update_login in number);
86
87 /* Delete_Row procedure */
88 PROCEDURE Delete_Row(X_BALI_FILTER_ID IN NUMBER);
89
90 procedure LOCK_ROW (
91 X_BALI_FILTER_ID in NUMBER,
92 X_OBJECT_VERSION_NUMBER in NUMBER);
93
94
95 END IEX_BALI_FILTERS_PKG ;