1 PACKAGE ISC_DBI_SUTIL_PKG AS
2 /*$Header: iscdbisutils.pls 120.0 2005/05/25 17:24:10 appldev noship $ */
3
4 -- Array for the MV aggregation level values
5 TYPE mv_agg_lvl_rec IS RECORD(VALUE NUMBER);
6 TYPE mv_agg_lvl_tbl IS TABLE OF mv_agg_lvl_rec;
7
8 /* Generic Process Parameter function.
9 */
10 PROCEDURE process_parameters (p_param IN BIS_PMV_PAGE_PARAMETER_TBL,
11 p_view_by OUT NOCOPY VARCHAR2,
12 p_view_by_col_name OUT NOCOPY VARCHAR2,
13 p_comparison_type OUT NOCOPY VARCHAR2,
14 p_xtd OUT NOCOPY VARCHAR2,
15 p_cur_suffix OUT NOCOPY VARCHAR2,
16 p_where_clause OUT NOCOPY VARCHAR2,
17 p_mv OUT NOCOPY VARCHAR2,
18 p_join_tbl OUT NOCOPY
19 poa_dbi_util_pkg.poa_dbi_join_tbl,
20 p_mv_level_flag OUT NOCOPY VARCHAR2,
21 p_trend IN VARCHAR2,
22 p_func_area IN VaRCHAR2,
23 p_version IN VARCHAR2,
24 p_role IN VARCHAR2,
25 p_mv_set IN VARCHAR2,
26 p_mv_flag_type IN VARCHAR2 DEFAULT 'NONE',
27 p_in_join_tbl OUT NOCOPY
28 poa_dbi_util_pkg.poa_dbi_in_join_tbl);
29
30
31 /* For the status_sql, get the name of the viewby column. */
32 FUNCTION get_view_by_col_name (p_dim_name VARCHAR2)
33 RETURN VARCHAR2;
34
35 /* Get the VIEWBY and VIEWBYID columns */
36 FUNCTION get_view_by_select_clause (p_viewby IN VARCHAR2)
37 RETURN VARCHAR2;
38
39 /* Build the fact view by columns string using the join table
40 for queries using windowing. */
41 FUNCTION get_fact_select_columns (p_join_tbl IN
42 poa_dbi_util_pkg.POA_DBI_JOIN_TBL)
43 RETURN VARCHAR2;
44
45 /* rate_str
46
47 Gets the string for percentage/ratio change of two specified strings.
48 Better than copying CASE statements everywhere */
49 FUNCTION rate_str (p_numerator IN VARCHAR2,
50 p_denominator IN VARCHAR2,
51 p_rate_type IN VARCHAR2,
52 p_measure_name IN VARCHAR2)
53 RETURN VARCHAR2;
54
55 /* pos_denom_percent_str
56
57 Gets the string for percentage change of two specified strings if
58 the denominator is positive and greater than 0.
59 Better than copying CASE statements everywhere. */
60 FUNCTION pos_denom_percent_str (p_numerator IN VARCHAR2,
61 p_denominator IN VARCHAR2,
62 p_measure_name IN VARCHAR2)
63 RETURN VARCHAR2;
64
65 /* change_str
66 Get the percentage change string. Better than writing out all the case
67 statements */
68 FUNCTION change_str (p_new_numerator IN VARCHAR2,
69 p_old_numerator IN VARCHAR2,
70 p_denominator IN VARCHAR2,
71 p_measure_name IN VARCHAR2)
72 RETURN VARCHAR2;
73
74
75 /* change_rate_str
76 Get the change in percentage/ratio string. Better than writing out all the case
77 statements */
78 FUNCTION change_rate_str (p_new_numerator IN VARCHAR2,
79 p_new_denominator IN VARCHAR2,
80 p_old_numerator IN VARCHAR2,
81 p_old_denominator IN VARCHAR2,
82 p_rate_type IN VARCHAR2,
83 p_measure_name IN VARCHAR2)
84 RETURN VARCHAR2;
85
86 /* get_global_weight_uom
87 Gets the global weight unit of measure
88 */
89 FUNCTION get_global_weight_uom RETURN VARCHAR2;
90
91 /* get_global_volume_uom
92 Gets the global volume unit of measure
93 */
94 FUNCTION get_global_volume_uom RETURN VARCHAR2;
95
96 /* get_global_distance_uom
97 Gets the global distance unit of measure
98 */
99 FUNCTION get_global_distance_uom RETURN VARCHAR2;
100
101 END ISC_DBI_SUTIL_PKG;