APPS.ISC_DBI_FR_COST_PER_V_TR_PKG dependencies on POA_DBI_UTIL_PKG

Line 29: l_col_tbl poa_dbi_util_pkg.POA_DBI_COL_TBL;

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

Line 30: l_join_tbl poa_dbi_util_pkg.POA_DBI_JOIN_TBL;

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

Line 31: l_in_join_tbl poa_dbi_util_pkg.POA_DBI_IN_JOIN_TBL;

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

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

43: l_comparison_type := 'Y';
44: l_aggregation_level_flag := '0';
45:
46: -- clear out the tables.
47: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
48: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
49: x_custom_sql := l_query;
50:
51: -- get all the query parameters

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

44: l_aggregation_level_flag := '0';
45:
46: -- clear out the tables.
47: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL ();
48: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL ();
49: x_custom_sql := l_query;
50:
51: -- get all the query parameters
52: isc_dbi_sutil_pkg.process_parameters (

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

77: END IF;
78:
79: -- Add measure columns that need to be aggregated
80: -- No Grand totals required.
81: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
82: p_col_name => 'freight_cost_vol_'||l_currency,
83: p_alias_name => 'freight_cost',
84: p_grand_total => 'N',
85: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 85: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

81: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
82: p_col_name => 'freight_cost_vol_'||l_currency,
83: p_alias_name => 'freight_cost',
84: p_grand_total => 'N',
85: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
86: p_to_date_type => 'XTD');
87:
88: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
89: p_col_name => 'freight_volume_g',

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

84: p_grand_total => 'N',
85: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
86: p_to_date_type => 'XTD');
87:
88: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
89: p_col_name => 'freight_volume_g',
90: p_alias_name => 'freight_volume',
91: p_grand_total => 'N',
92: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

Line 92: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,

88: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl,
89: p_col_name => 'freight_volume_g',
90: p_alias_name => 'freight_volume',
91: p_grand_total => 'N',
92: p_prior_code => poa_dbi_util_pkg.BOTH_PRIORS,
93: p_to_date_type => 'XTD');
94:
95: -- Merge Outer and Inner Query
96: l_query := get_trd_sel_clause(l_view_by) ||

Line 114: poa_dbi_util_pkg.get_custom_trend_binds (

110:
111: -- get all the basic binds used by POA queries
112: -- Do this before adding any of our binds, since the procedure
113: -- reinitializes the output table
114: poa_dbi_util_pkg.get_custom_trend_binds (
115: p_xtd => l_xtd,
116: p_comparison_type => l_comparison_type,
117: x_custom_output => x_custom_output);
118: