[Home] [Help]
PACKAGE: APPS.IEX_BALI_FILTERS_PVT
Source
1 PACKAGE IEX_BALI_FILTERS_PVT as
2 /* $Header: iexvbfls.pls 120.3 2004/06/04 19:58:58 jsanju noship $ */
3 -- Start of Comments
4 -- Package name : IEX_BALI_FILTERS_PVT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 ------------------------------------------------------------------------------
11 -- Global Variables
12 G_PKG_NAME CONSTANT VARCHAR2(200) := 'IEX_BALI_FILTERS_PVT';
13 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
14 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
15 G_DEFAULT_NUM_REC_FETCH CONSTANT NUMBER := 30;
16 G_YES CONSTANT VARCHAR2(1) := 'Y';
17 G_NO CONSTANT VARCHAR2(1) := 'N';
18 ------------------------------------------------------------------------------
19
20
21 -- Default number of records fetch per call
22 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
23
24 TYPE bali_filter_rec_type IS RECORD
25 (
26 bali_filter_id number
27 ,bali_filter_name varchar2(100)
28 ,bali_datasource varchar2(100)
29 ,bali_user_id number
30 ,bali_col_alias varchar2(30)
31 ,bali_col_data_type varchar2(30)
32 ,bali_col_label_text varchar2(80)
33 ,bali_col_condition_code varchar2(30)
34 ,bali_col_condition_value varchar2(30)
35 ,bali_col_value varchar2(100)
36 ,right_parenthesis_code varchar2(100)
37 ,left_parenthesis_code varchar2(100)
38 ,boolean_operator_code varchar2(100)
39 ,object_version_number number
40 ,request_id number ,
41 program_application_id number ,
42 program_id number ,
43 program_update_date date ,
44 attribute_category varchar2(240) ,
45 attribute1 varchar2(240) ,
46 attribute2 varchar2(240) ,
47 attribute3 varchar2(240) ,
48 attribute4 varchar2(240) ,
49 attribute5 varchar2(240) ,
50 attribute6 varchar2(240) ,
51 attribute7 varchar2(240) ,
52 attribute8 varchar2(240) ,
53 attribute9 varchar2(240) ,
54 attribute10 varchar2(240) ,
55 attribute11 varchar2(240) ,
56 attribute12 varchar2(240) ,
57 attribute13 varchar2(240) ,
58 attribute14 varchar2(240) ,
59 attribute15 varchar2(240) ,
60 created_by number ,
61 creation_date date ,
62 last_updated_by number ,
63 last_update_date date ,
64 last_update_login number
65 );
66
67 G_MISS_bali_filter_rec bali_filter_rec_type;
68 TYPE bali_filter_tbl_Type IS TABLE OF bali_filter_rec_type
69 INDEX BY BINARY_INTEGER;
70 G_MISS_bali_filter_tbl bali_filter_tbl_Type;
71
72
73
74 PROCEDURE create_BALI_FILTERS(
75 P_Api_Version_Number IN NUMBER,
76 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
77 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
78 P_bali_filter_rec IN bali_filter_rec_type,
79 X_bali_filter_id OUT NOCOPY NUMBER
80 ,x_return_status OUT NOCOPY VARCHAR2
81 ,x_msg_count OUT NOCOPY NUMBER
82 ,x_msg_data OUT NOCOPY VARCHAR2
83 );
84
85 PROCEDURE update_BALI_FILTERS(
86 P_Api_Version_Number IN NUMBER,
87 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
88 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
89 P_bali_filter_rec IN bali_filter_rec_type,
90 x_return_status OUT NOCOPY VARCHAR2
91 ,x_msg_count OUT NOCOPY NUMBER
92 ,x_msg_data OUT NOCOPY VARCHAR2
93 ,XO_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER
94 );
95
96 PROCEDURE delete_BALI_FILTERS(
97 P_Api_Version_Number IN NUMBER,
98 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
99 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
100 p_bali_filter_id IN NUMBER ,
101 x_return_status OUT NOCOPY VARCHAR2
102 ,x_msg_count OUT NOCOPY NUMBER
103 ,x_msg_data OUT NOCOPY VARCHAR2
104
105 );
106
107 Procedure commit_work;
108 End IEX_BALI_FILTERS_PVT;