[Home] [Help]
PACKAGE: APPS.BIS_LOV_PUB
Source
1 package bis_lov_pub as
2 /* $Header: BISPLOVS.pls 120.2 2005/12/28 06:02:33 ashankar noship $ */
3 c_asterisk CONSTANT varchar2(1) := '*';
4 c_plus CONSTANT varchar2(1) := '+';
5 c_amp CONSTANT varchar2(1) := '&';
6 c_percent CONSTANT varchar2(1) := '%';
7 c_rowcount CONSTANT pls_integer := 20;
8
9 -- Set the colors for the appropriate areas
10 c_pgbgcolor CONSTANT varchar2(30) := '#eaeff5'; --#88BBEE
11 c_fmbgcolor CONSTANT varchar2(30) := '#88BBEE';
12 c_rowcolor CONSTANT varchar2(30) := '#F2F2F5';
13 c_tblsurnd CONSTANT varchar2(30) := '#a6a9b5';
14 c_rowHeader CONSTANT VARCHAR2(30) := '#999999';
15
16 -- Set the translated strings from the database
17 c_of CONSTANT varchar2(100) := BIS_UTILITIES_PVT.getPrompt('BIS_OF');
18 c_to CONSTANT varchar2(100) := BIS_UTILITIES_PVT.getPrompt('BIS_TO');
19 c_listofvalues CONSTANT varchar2(100) := BIS_UTILITIES_PVT.getPrompt('BIS_LISTOFVALUES');
20 c_previous CONSTANT varchar2(100) := BIS_UTILITIES_PVT.getPrompt('BIS_PREVIOUS');
21 c_next CONSTANT varchar2(100) := BIS_UTILITIES_PVT.getPrompt('BIS_NEXT');
22 c_find CONSTANT varchar2(100) := BIS_UTILITIES_PVT.getPrompt('BIS_FIND');
23 c_values CONSTANT varchar2(100) := BIS_UTILITIES_PVT.getPrompt('BIS_VALUES');
24 c_cancel CONSTANT varchar2(100) := BIS_UTILITIES_PVT.getPrompt('BIS_CANCEL');
25 c_possible CONSTANT varchar2(100) := BIS_UTILITIES_PVT.getPrompt('BIS_POSSIBLE');
26
27 type column_info is RECORD (header varchar2(200),
28 value varchar2(1),
29 link varchar2(1),
30 display varchar2(1)
31 );
32
33 type colinfo_table is table of column_info index by binary_integer;
34 type colstore_table is table of varchar2(32000) index by binary_integer;
35
36 /*
37 procedure main (p_procname in varchar2 default NULL
38 ,p_qrycnd in varchar2 default NULl
39 ,p_jsfuncname in varchar2 default NULL
40 ,p_startnum in pls_integer default NULL
41 ,p_rowcount in pls_integer default NULL
42 ,p_totalcount in pls_integer default NULL
43 ,p_search_str in varchar2 default NULL
44 ,p_sql in varchar2 default NULL
45 ,p_sqlcount in varchar2 default NULL
46 ,p_coldata in colinfo_table);
47 */
48
49 procedure main
50 ( p_procname in varchar2 default NULL
51 , p_qrycnd in varchar2 default NULL
52 , p_jsfuncname in varchar2 default NULl
53 , p_startnum in pls_integer default NULL
54 , p_rowcount in pls_integer default NULL
55 , p_totalcount in pls_integer default NULL
56 , p_search_str in varchar2 default NULL
57 , p_dim_level_id in number default NULL
58 , p_sqlcount in varchar2 default NULL
59 , p_coldata in colinfo_table
60 , p_rel_dim_lev_id in varchar2 default NULL
61 , p_rel_dim_lev_val_id in varchar2 default NULL
62 , p_rel_dim_lev_g_var in varchar2 default NULL
63 , Z in pls_integer default NULL
64 , p_user_id in pls_integer default NULL
65 , x_string out nocopy VARCHAR2
66 );
67
68 procedure lov_search( p_totalpossible in pls_integer default NULL
69 , p_totalavailable in pls_integer default NULL
70 , p_titlename in varchar2 default NULL
71 , p_startnum in pls_integer default NULL
72 , p_rowcount in pls_integer default NULL
73 , p_search_str in varchar2 default NULL
74 , x_string out nocopy VARCHAR2);
75
76 /*
77 procedure lov_data( p_startnum in pls_integer default NULL
78 , p_rowcount in pls_integer default NULL
79 , p_totalavailable in pls_integer default NULL
80 , p_sql in varchar2 default NULL
81 , p_head in colstore_table
82 , p_value in colstore_table
83 , p_link in colstore_table
84 , p_disp in colstore_table);
85 */
86
87
88 procedure lov_data
89 ( p_startnum in pls_integer default NULL
90 , p_rowcount in pls_integer default NULL
91 , p_totalavailable in pls_integer default NULL
92 , p_dim_level_id in number default NULL
93 , p_search_str in varchar2 default NULL
94 , p_head in colstore_table
95 , p_value in colstore_table
96 , p_link in colstore_table
97 , p_disp in colstore_table
98 , p_rel_dim_lev_id in varchar2 default NULL
99 , p_rel_dim_lev_val_id in varchar2 default NULL
100 , p_rel_dim_lev_g_var in varchar2 default NULL
101 , Z in pls_integer default NULL
102 , p_user_id in pls_integer default NULL
103 , x_string out nocopy VARCHAR2
104 );
105
106 procedure lov_buttons( p_startnum in pls_integer default NULL
107 , p_rowcount in pls_integer default NULL
108 , p_totalavailable in pls_integer default NULL
109 , x_string out nocopy VARCHAR);
110
111
112 function concat_string (p_search_str in varchar2 default NULL) return varchar2;
113
114 procedure lovjscript(x_string out nocopy varchar2);
115
116 PROCEDURE setGlobalVar
117 ( p_dim_lev_id in VARCHAR2
118 , p_dim_lev_val_id in VARCHAR2
119 , p_dim_lev_g_var in VARCHAR2
120 , x_return_status out NOCOPY VARCHAR2
121 );
122
123 -- mdamle 01/15/2001
124 procedure editlovjscript(x_string out nocopy varchar2);
125
126 end bis_lov_pub;