APPS.POA_DBI_INV_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 99: poa_dbi_template_pkg.status_sql(

95: l_url := null;
96: END IF;
97:
98: l_query := get_status_sel_clause(l_view_by, l_view_by_col, l_url,l_to_date_type, l_sec_context) || ' from ' ||
99: poa_dbi_template_pkg.status_sql(
100: p_fact_name => l_mv,
101: p_where_clause => l_where_clause,
102: p_join_tables => l_join_tbl,
103: p_use_windowing => 'Y',

Line 193: poa_dbi_template_pkg.union_all_status_sql(

189: l_mv_tbl(2).in_join_tbls := l_in_join_tbl2;
190: l_mv_tbl(2).use_grp_id := 'N';
191:
192: l_query := get_status_sel_clause(l_view_by, l_view_by_col, l_url,'XTD', l_sec_context) || ' from (' ||
193: poa_dbi_template_pkg.union_all_status_sql(
194: p_mv => l_mv_tbl,
195: p_join_tables => l_join_tbl,
196: p_use_windowing => 'Y',
197: p_paren_count => 3,

Line 203: poa_dbi_template_pkg.status_sql(

199: p_generate_viewby => 'Y',
200: p_diff_measures => 'N');
201: else
202: l_query := get_status_sel_clause(l_view_by, l_view_by_col, l_url,'XTD', l_sec_context) || ' from ' ||
203: poa_dbi_template_pkg.status_sql(
204: p_fact_name => l_mv,
205: p_where_clause => l_where_clause,
206: p_join_tables => l_join_tbl,
207: p_use_windowing => 'Y',

Line 426: || poa_dbi_template_pkg.trend_sql(

422: poa_dbi_util_pkg.add_column(l_col_tbl,'amount_' || l_cur_suffix,'amount','N', p_to_date_type => l_to_date_type);
423:
424: l_query := get_trend_sel_clause || '
425: from '
426: || poa_dbi_template_pkg.trend_sql(
427: p_xtd => l_xtd
428: ,p_comparison_type => l_comparison_type
429: ,p_fact_name => l_mv
430: ,p_where_clause => l_where_clause

Line 513: || poa_dbi_template_pkg.union_all_trend_sql(

509: l_mv_tbl(2).mv_xtd := l_xtd;
510:
511: l_query := get_trend_sel_clause('union') || '
512: from '
513: || poa_dbi_template_pkg.union_all_trend_sql(
514: p_mv => l_mv_tbl,
515: p_comparison_type => l_comparison_type,
516: p_diff_measures => 'N');
517: else

Line 520: || poa_dbi_template_pkg.trend_sql(

516: p_diff_measures => 'N');
517: else
518: l_query := get_trend_sel_clause || '
519: from '
520: || poa_dbi_template_pkg.trend_sql(
521: p_xtd => l_xtd,
522: p_comparison_type => l_comparison_type,
523: p_fact_name => l_mv,
524: p_where_clause => l_where_clause,