APPS.ISC_DBI_FR_COST_PER_D_PKG dependencies on POA_DBI_UTIL_PKG

Line 13: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)

9:
10: /* Rated Freight Cost per Unit Distance Report */
11: FUNCTION get_rpt_sel_clause (p_view_by_dim IN VARCHAR2,
12: p_join_tbl IN
13: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)
14: RETURN VARCHAR2;
15:
16:
17: /*------------------------------------------------

Line 33: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

29: l_cur_suffix VARCHAR2(10);
30: l_currency VARCHAR2(10);
31: l_custom_sql VARCHAR2 (10000);
32:
33: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
34: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
35: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
36:
37: l_where_clause VARCHAR2 (2000);

Line 34: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

30: l_currency VARCHAR2(10);
31: l_custom_sql VARCHAR2 (10000);
32:
33: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
34: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
35: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
36:
37: l_where_clause VARCHAR2 (2000);
38: l_filter_where VARCHAR2 (240);

Line 35: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;

31: l_custom_sql VARCHAR2 (10000);
32:
33: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;
34: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;
35: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;
36:
37: l_where_clause VARCHAR2 (2000);
38: l_filter_where VARCHAR2 (240);
39: l_mv VARCHAR2 (30);

Line 54: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();

50: l_comparison_type := 'Y';
51: l_aggregation_level_flag := '0';
52:
53: -- clear out the column and Join info tables.
54: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
55: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
56:
57: -- get all the query parameters
58: isc_dbi_sutil_pkg.process_parameters (

Line 55: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();

51: l_aggregation_level_flag := '0';
52:
53: -- clear out the column and Join info tables.
54: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
55: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
56:
57: -- get all the query parameters
58: isc_dbi_sutil_pkg.process_parameters (
59: p_param => p_param,

Line 86: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

82: ELSE l_currency := 'g';
83: END IF;
84:
85: -- Add measure columns that need to be aggregated
86: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
87: p_col_name => 'freight_cost_'||l_currency,
88: p_alias_name => 'freight_cost',
89: p_grand_total => 'Y',
90: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 90: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

86: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
87: p_col_name => 'freight_cost_'||l_currency,
88: p_alias_name => 'freight_cost',
89: p_grand_total => 'Y',
90: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
91: p_to_date_type => 'XTD');
92:
93: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
94: p_col_name => 'freight_distance_g',

Line 93: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

89: p_grand_total => 'Y',
90: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
91: p_to_date_type => 'XTD');
92:
93: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
94: p_col_name => 'freight_distance_g',
95: p_alias_name => 'freight_distance',
96: p_grand_total => 'Y',
97: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 97: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

93: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
94: p_col_name => 'freight_distance_g',
95: p_alias_name => 'freight_distance',
96: p_grand_total => 'Y',
97: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
98: p_to_date_type => 'XTD');
99:
100: /* Additional filter needed to avoid displaying records queried due to total values at node */
101:

Line 138: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

134: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
135: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
136:
137: -- set the basic bind variables for the status SQL
138: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
139:
140: -- Passing ISC_AGG_FLAG to PMV
141: l_custom_rec.attribute_name := ':ISC_AGG_FLAG';
142: l_custom_rec.attribute_value := l_aggregation_level_flag;

Line 159: l_col_tbl poa_dbi_util_pkg.poa_dbi_filter_tbl;

155: Description: creates additional where clause to filter rows without meaningful data
156: -------------------------------------------------------------------------------------*/
157: FUNCTION get_status_filter_where(p_view_by in VARCHAR2) return VARCHAR2
158: IS
159: l_col_tbl poa_dbi_util_pkg.poa_dbi_filter_tbl;
160: BEGIN
161: l_col_tbl := poa_dbi_util_pkg.POA_DBI_FILTER_TBL();
162: l_col_tbl.extend;
163: l_col_tbl(1) := 'ISC_MEASURE_10';

Line 161: l_col_tbl := poa_dbi_util_pkg.POA_DBI_FILTER_TBL();

157: FUNCTION get_status_filter_where(p_view_by in VARCHAR2) return VARCHAR2
158: IS
159: l_col_tbl poa_dbi_util_pkg.poa_dbi_filter_tbl;
160: BEGIN
161: l_col_tbl := poa_dbi_util_pkg.POA_DBI_FILTER_TBL();
162: l_col_tbl.extend;
163: l_col_tbl(1) := 'ISC_MEASURE_10';
164: l_col_tbl.extend;
165: l_col_tbl(2) := 'ISC_MEASURE_4';

Line 167: return poa_dbi_util_pkg.get_filter_where(l_col_tbl);

163: l_col_tbl(1) := 'ISC_MEASURE_10';
164: l_col_tbl.extend;
165: l_col_tbl(2) := 'ISC_MEASURE_4';
166:
167: return poa_dbi_util_pkg.get_filter_where(l_col_tbl);
168:
169: END;
170:
171:

Line 178: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)

174: Description: builds the outer select clause
175: ---------------------------------------------------*/
176: FUNCTION get_rpt_sel_clause(p_view_by_dim IN VARCHAR2,
177: p_join_tbl IN
178: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)
179: RETURN VARCHAR2
180: IS
181: l_sel_clause VARCHAR2(32000);
182: l_view_by_col_name VARCHAR2(60);