APPS.ISC_DBI_CST_REC_RT_PKG dependencies on POA_DBI_UTIL_PKG

Line 9: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)

5: -----------------------------------------------------*/
6: /* Freight Cost Recovery Rate 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_mv VARCHAR2 (30);

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_mv VARCHAR2 (30);
38:

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

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

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

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

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

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

Line 86: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

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

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

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

Line 93: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

89: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
90: p_col_name => 'freight_charge_amt_'||l_currency,
91: p_alias_name => 'freight_charge',
92: p_grand_total => 'Y',
93: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
94: p_to_date_type => 'XTD');
95:
96: IF l_view_by = 'ITEM+ENI_ITEM_ORG' THEN
97: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,

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

93: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
94: p_to_date_type => 'XTD');
95:
96: IF l_view_by = 'ITEM+ENI_ITEM_ORG' THEN
97: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
98: p_col_name => 'shipped_qty',
99: p_alias_name => 'quantity',
100: p_grand_total => 'Y',
101: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,

Line 101: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,

97: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
98: p_col_name => 'shipped_qty',
99: p_alias_name => 'quantity',
100: p_grand_total => 'Y',
101: p_prior_code => poa_dbi_util_pkg.NO_PRIORS,
102: p_to_date_type => 'XTD');
103: END IF;
104:
105:

Line 125: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);

121: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
122: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
123:
124: -- set the basic bind variables for the status SQL
125: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
126:
127: -- Passing ISC_AGG_FLAG to PMV
128: l_custom_rec.attribute_name := ':ISC_AGG_FLAG';
129: l_custom_rec.attribute_value := l_aggregation_level_flag;

Line 146: l_col_tbl poa_dbi_util_pkg.poa_dbi_filter_tbl;

142: Description: creates additional where clause to filter rows without meaningful data
143: -------------------------------------------------------------------------------------*/
144: FUNCTION get_status_filter_where(p_view_by in VARCHAR2) return VARCHAR2
145: IS
146: l_col_tbl poa_dbi_util_pkg.poa_dbi_filter_tbl;
147: BEGIN
148: l_col_tbl := poa_dbi_util_pkg.POA_DBI_FILTER_TBL();
149: l_col_tbl.extend;
150: l_col_tbl(1) := 'ISC_MEASURE_2';

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

144: FUNCTION get_status_filter_where(p_view_by in VARCHAR2) return VARCHAR2
145: IS
146: l_col_tbl poa_dbi_util_pkg.poa_dbi_filter_tbl;
147: BEGIN
148: l_col_tbl := poa_dbi_util_pkg.POA_DBI_FILTER_TBL();
149: l_col_tbl.extend;
150: l_col_tbl(1) := 'ISC_MEASURE_2';
151: l_col_tbl.extend;
152: l_col_tbl(2) := 'ISC_MEASURE_4';

Line 155: return poa_dbi_util_pkg.get_filter_where(l_col_tbl);

151: l_col_tbl.extend;
152: l_col_tbl(2) := 'ISC_MEASURE_4';
153: l_col_tbl.extend;
154: l_col_tbl(3) := 'ISC_MEASURE_5';
155: return poa_dbi_util_pkg.get_filter_where(l_col_tbl);
156:
157: END;
158:
159:

Line 166: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)

162: Description: builds the outer select clause
163: ---------------------------------------------------*/
164: FUNCTION get_rpt_sel_clause(p_view_by_dim IN VARCHAR2,
165: p_join_tbl IN
166: poa_dbi_util_pkg.POA_DBI_JOIN_TBL)
167: RETURN VARCHAR2
168: IS
169: l_sel_clause VARCHAR2(32000);
170: l_view_by_col_name VARCHAR2(60);