[Home] [Help]
PACKAGE: APPS.JTFB_PICASSO_DEMO
Source
1 package jtfb_picasso_demo as
2 /* $Header: jtfbdems.pls 120.1 2005/07/02 02:33:21 appldev ship $ */
3 --
4 --
5 /*****************************************************************************/
6 -- Start Of Comments
7 --
8 -- Name
9 -- jtfb_picasso_demo
10 --
11 -- Purpose
12 -- This package consists of procedures and functions to populate Demo data.
13 --
14 -- Functions
15 -- get_dynamic_footer
16 -- get_dynamic_name
17 -- get_dynamic_report_col2
18 -- get_dynamic_report_col4
19 -- get_dynamic_report_col6
20 -- get_dynamic_report_col8
21 -- get_dynamic_report_col10
22 -- get_dynamic_report_col12
23 -- get_xaxis_label_name
24 -- get_yaxis_label_name
25 --
26 --
27 -- Procedures
28 -- load_jtfb_demo_bin
29 -- load_jtfb_demo_bin1
30 -- load_jtfb_demo_report
31 --
32 -- Notes
33 --
34 -- History
35 -- 15-MAY-2001, Pandian Athimoolam, Created the functions to return
36 -- the graph xaxis and yaxis label name
37 -- 10-MAY-2001, Elanchelvan Elango, Replaced inserts with API calls
38 -- 09-MAY-2001, Pandian Athimoolam, Created
39 --
40 -- End of Comments
41 --
42 --
43 /*****************************************************************************/
44 -- Start of Package Globals
45 --
46 g_pkg_name constant varchar2(30) := 'jtfb_picasso_demo';
47 --
48 -- End of Global Package Globals
49 --
50 --
51 /*****************************************************************************/
52 -- Start Of Comments
53 --
54 -- Name : load_jtfb_demo_bin
55 -- Type : Public
56 -- Function:
57 -- Loads the first Data-Out BIN
58 --
59 -- Pre-Reqs:
60 -- None.
61 --
62 -- Parameters:
63 -- p_context
64 -- in varchar2 default null
65 --
66 -- Notes:
67 -- None.
68 --
69 -- End Of Comments
70 procedure load_jtfb_demo_bin(
71 p_context in varchar2 default null
72 );
73 --
74 --
75 /*****************************************************************************/
76 -- Start Of Comments
77 --
78 -- Name : load_jtfb_demo_bin1
79 -- Type : Public
80 -- Function:
81 -- Loads the Data-Out BIN1
82 --
83 -- Pre-Reqs:
84 -- None.
85 --
86 -- Parameters:
87 -- p_context
88 -- in varchar2 default null
89 --
90 -- Notes:
91 -- None.
92 --
93 -- End Of Comments
94 procedure load_jtfb_demo_bin1(
95 p_context in varchar2 default null
96 );
97 --
98 --
99 /*****************************************************************************/
100 -- Start Of Comments
101 --
102 -- Name : load_jtfb_demo_report
103 -- Type : Public
104 -- Function:
105 -- Loads the first Report
106 --
107 -- Pre-Reqs:
108 -- None.
109 --
110 -- Parameters:
111 -- p_context
112 -- in varchar2 default null
113 --
114 -- Notes:
115 -- None.
116 --
117 -- End Of Comments
118 procedure load_jtfb_demo_report(
119 p_context in varchar2 default null
120 );
121 --
122 --
123 /*****************************************************************************/
124 -- Start Of Comments
125 --
126 -- Name : get_dynamic_footer
127 -- Type : Public
128 -- Function:
129 -- Gets a dynamic Footer
130 --
131 -- Pre-Reqs:
132 -- None.
133 --
134 -- Parameters:
135 -- p_context
136 -- in varchar2 default null
137 --
138 -- Returns:
139 -- varchar2 (approximately 80 characters ?)
140 -- The dynamic footer text
141 -- Notes:
142 -- None.
143 --
144 -- End Of Comments
145 function get_dynamic_footer(
146 p_context in varchar2 default null
147 ) return varchar2;
148 --
149 --
150 /*****************************************************************************/
151 -- Start Of Comments
152 --
153 -- Name : get_dynamic_name
154 -- Type : Public
155 -- Function:
156 -- Gets a dynamic Name
157 --
158 -- Pre-Reqs:
159 -- None.
160 --
161 -- Parameters:
162 -- p_context
163 -- in varchar2 default null
164 --
165 -- Returns:
166 -- varchar2 (approximately 80 characters ?)
167 -- The dynamic name
168 -- Notes:
169 -- None.
170 --
171 -- End Of Comments
172 function get_dynamic_name(
173 p_context in varchar2 default null
174 ) return varchar2;
175 --
176 --
177 /*****************************************************************************/
178 -- Start Of Comments
179 --
180 -- Name : get_dynamic_report_col2
181 -- Type : Public
182 -- Function:
183 -- Gets a dynamic label for col2, the first column of the Data-Out BINS
184 --
185 -- Pre-Reqs:
186 -- None.
187 --
188 -- Parameters:
189 -- p_context
190 -- in varchar2 default null
191 --
192 -- Returns:
193 -- varchar2 (approximately 80 characters ?)
194 -- The dynamic column text
195 -- Notes:
196 -- None.
197 --
198 -- End Of Comments
199 function get_dynamic_report_col2(
200 p_context in varchar2 default null
201 ) return varchar2;
202 --
203 --
204 /*****************************************************************************/
205 -- Start Of Comments
206 --
207 -- Name : get_dynamic_report_col4
208 -- Type : Public
209 -- Function:
210 -- Gets a dynamic label for col4, the second column of the Data-Out BINS
211 --
212 -- Pre-Reqs:
213 -- None.
214 --
215 -- Parameters:
216 -- p_context
217 -- in varchar2 default null
218 --
219 -- Returns:
220 -- varchar2 (approximately 80 characters ?)
221 -- The dynamic column text
222 -- Notes:
223 -- None.
224 --
225 -- End Of Comments
226 function get_dynamic_report_col4(
227 p_context in varchar2 default null
228 ) return varchar2;
229 --
230 --
231 /*****************************************************************************/
232 -- Start Of Comments
233 --
234 -- Name : get_dynamic_report_col6
235 -- Type : Public
236 -- Function:
237 -- Gets a dynamic label for col6, the third column of the Data-Out BINS
238 --
239 -- Pre-Reqs:
240 -- None.
241 --
242 -- Parameters:
243 -- p_context
244 -- in varchar2 default null
245 --
246 -- Returns:
247 -- varchar2 (approximately 80 characters ?)
248 -- The dynamic column text
249 -- Notes:
250 -- None.
251 --
252 -- End Of Comments
253 function get_dynamic_report_col6(
254 p_context in varchar2 default null
255 ) return varchar2;
256 --
257 --
258 /*****************************************************************************/
259 -- Start Of Comments
260 --
261 -- Name : get_dynamic_report_col8
262 -- Type : Public
263 -- Function:
264 -- Gets a dynamic label for col8, the fourth column of the Data-Out BINS
265 --
266 -- Pre-Reqs:
267 -- None.
268 --
269 -- Parameters:
270 -- p_context
271 -- in varchar2 default null
272 --
273 -- Returns:
274 -- varchar2 (approximately 80 characters ?)
275 -- The dynamic column text
276 -- Notes:
277 -- None.
278 --
279 -- End Of Comments
280 function get_dynamic_report_col8(
281 p_context in varchar2 default null
282 ) return varchar2;
283 --
284 --
285 /*****************************************************************************/
286 -- Start Of Comments
287 --
288 -- Name : get_dynamic_report_col10
289 -- Type : Public
290 -- Function:
291 -- Gets a dynamic label for col10, the fifth column of the Data-Out BINS
292 --
293 -- Pre-Reqs:
294 -- None.
295 --
296 -- Parameters:
297 -- p_context
298 -- in varchar2 default null
299 --
300 -- Returns:
301 -- varchar2 (approximately 80 characters ?)
302 -- The dynamic column text
303 -- Notes:
304 -- None.
305 --
306 -- End Of Comments
307 function get_dynamic_report_col10(
308 p_context in varchar2 default null
309 ) return varchar2;
310 --
311 --
312 /*****************************************************************************/
313 -- Start Of Comments
314 --
315 -- Name : get_dynamic_report_col12
316 -- Type : Public
317 -- Function:
318 -- Gets a dynamic label for col12, the sixth column of the Data-Out BINS
319 --
320 -- Pre-Reqs:
321 -- None.
322 --
323 -- Parameters:
324 -- p_context
325 -- in varchar2 default null
326 --
327 -- Returns:
328 -- varchar2 (approximately 80 characters ?)
329 -- The dynamic column text
330 -- Notes:
331 -- None.
332 --
333 -- End Of Comments
334 function get_dynamic_report_col12(
335 p_context in varchar2 default null
336 ) return varchar2;
337 --
338 --
339 function get_xaxis_label_name(
340 p_context in varchar2 default null
341 ) return varchar2;
342 --
343 --
344 function get_yaxis_label_name(
345 p_context in varchar2 default null
346 ) return varchar2;
347 --
348 --
349 end jtfb_picasso_demo;