APPS.ISC_DBI_FR_COST_PER_W_PKG dependencies on POA_DBI_UTIL_PKG

Line 9: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)

5: -----------------------------------------------------*/
6: /* Rated Freight Cost per Unit Weight Report */
7: FUNCTION get_rpt_sel_clause (p_view_by_dim IN VARCHAR2,
8: p_join_tbl IN
9: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)
10: RETURN VARCHAR2;
11:
12: /* Function to filter rows that don't provide informative data */
13: FUNCTION get_status_filter_where(p_view_by IN VARCHAR2)

Line 32: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

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

Line 33: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

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

Line 34: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;

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

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

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

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

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

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

79: ELSE l_currency := 'f';
80: END IF;
81:
82: -- Add measure columns that need to be aggregated
83: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
84: p_col_name => 'freight_cost_wt_'||l_currency,
85: p_alias_name => 'freight_cost',
86: p_grand_total => 'Y',
87: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 87: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

83: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
84: p_col_name => 'freight_cost_wt_'||l_currency,
85: p_alias_name => 'freight_cost',
86: p_grand_total => 'Y',
87: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
88: p_to_date_type => 'XTD');
89:
90: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
91: p_col_name => 'freight_weight_g',

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

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

Line 94: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

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

Line 120: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

116: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
117: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
118:
119: -- set the basic bind variables for the status SQL
120: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
121:
122: -- Passing ISC_AGG_FLAG to PMV
123: l_custom_rec.attribute_name := ':ISC_AGG_FLAG';
124: l_custom_rec.attribute_value := l_aggregation_level_flag;

Line 141: l_col_tbl poa_dbi_util_pkg.poa_dbi_filter_tbl;

137: Description: creates additional where clause to filter rows without meaningful data
138: -------------------------------------------------------------------------------------*/
139: FUNCTION get_status_filter_where(p_view_by in VARCHAR2) return VARCHAR2
140: IS
141: l_col_tbl poa_dbi_util_pkg.poa_dbi_filter_tbl;
142: BEGIN
143: l_col_tbl := poa_dbi_util_pkg.POA_DBI_FILTER_TBL();
144: l_col_tbl.extend;
145: l_col_tbl(1) := 'ISC_MEASURE_1';

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

139: FUNCTION get_status_filter_where(p_view_by in VARCHAR2) return VARCHAR2
140: IS
141: l_col_tbl poa_dbi_util_pkg.poa_dbi_filter_tbl;
142: BEGIN
143: l_col_tbl := poa_dbi_util_pkg.POA_DBI_FILTER_TBL();
144: l_col_tbl.extend;
145: l_col_tbl(1) := 'ISC_MEASURE_1';
146: l_col_tbl.extend;
147: l_col_tbl(2) := 'ISC_MEASURE_9';

Line 149: return poa_dbi_util_pkg.get_filter_where(l_col_tbl);

145: l_col_tbl(1) := 'ISC_MEASURE_1';
146: l_col_tbl.extend;
147: l_col_tbl(2) := 'ISC_MEASURE_9';
148:
149: return poa_dbi_util_pkg.get_filter_where(l_col_tbl);
150:
151: END;
152:
153:

Line 160: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)

156: Description: builds the outer select clause
157: ---------------------------------------------------*/
158: FUNCTION get_rpt_sel_clause(p_view_by_dim IN VARCHAR2,
159: p_join_tbl IN
160: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)
161: RETURN VARCHAR2
162: IS
163: l_sel_clause VARCHAR2(32000);
164: l_view_by_col_name VARCHAR2(60);