APPS.POA_DBI_RDE_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 90: poa_dbi_template_pkg.status_sql(l_mv,

86: l_url := null;
87:
88: end if;
89: l_query := get_status_sel_clause(l_view_by, l_url,l_view_by_col) || ' from ' ||
90: poa_dbi_template_pkg.status_sql(l_mv,
91: l_where_clause,
92: l_join_tbl,
93: p_use_windowing => 'Y',
94: p_col_name => l_col_tbl,

Line 161: '|| poa_dbi_template_pkg.trend_sql(l_xtd,

157:
158:
159:
160: l_query := get_rate_trend_sel_clause || ' from
161: '|| poa_dbi_template_pkg.trend_sql(l_xtd,
162: l_comparison_type,
163: l_mv,
164: l_where_clause,
165: l_col_tbl,

Line 263: poa_dbi_template_pkg.status_sql(l_mv,

259: l_url := null;
260:
261: end if;
262: l_query := get_amt_rpt_sel_clause(l_view_by, l_url,l_view_by_col) || ' from ' ||
263: poa_dbi_template_pkg.status_sql(l_mv,
264: l_where_clause,
265: l_join_tbl,
266: p_use_windowing => 'Y',
267: p_col_name => l_col_tbl,

Line 350: poa_dbi_template_pkg.status_sql(l_mv,

346: l_url := null;
347:
348: end if;
349: l_query := get_txn_rpt_sel_clause(l_view_by, l_url,l_view_by_col) || ' from ' ||
350: poa_dbi_template_pkg.status_sql(l_mv,
351: l_where_clause,
352: l_join_tbl,
353: p_use_windowing => 'Y',
354: p_col_name => l_col_tbl,

Line 430: ' || poa_dbi_template_pkg.status_sql(l_mv,

426: poa_dbi_util_pkg.add_column(l_col_tbl, 'amt_receipt_' || l_cur_suffix, 'amt_receipt',p_to_date_type => l_to_date_type);
427: poa_dbi_util_pkg.add_column(l_col_tbl, 'num_txns_receipt_cnt', 'cnt_receipt',p_to_date_type => l_to_date_type);
428: poa_dbi_util_pkg.add_column(l_col_tbl, 'amt_expt_' || l_cur_suffix, 'amt_expt',p_to_date_type => l_to_date_type);
429: l_query := get_status_it_sel_clause(l_view_by,l_view_by_col) || ' from
430: ' || poa_dbi_template_pkg.status_sql(l_mv,
431: l_where_clause,
432: l_join_tbl,
433: p_use_windowing => 'Y',
434: p_col_name => l_col_tbl,

Line 968: '|| poa_dbi_template_pkg.trend_sql(l_xtd,

964: poa_dbi_util_pkg.add_column(l_col_tbl, 'num_txns_late_cnt', 'late_cnt', 'N',p_to_date_type => l_to_date_type);
965: poa_dbi_util_pkg.add_column(l_col_tbl, 'amt_expt_' || l_cur_suffix,'amt_expt', 'N',p_to_date_type => l_to_date_type);
966:
967: l_query := get_trend_sel_clause || ' from
968: '|| poa_dbi_template_pkg.trend_sql(l_xtd,
969: l_comparison_type,
970: l_mv,
971: l_where_clause,
972: l_col_tbl,