APPS.POA_DBI_PQC_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 103: poa_dbi_template_pkg.status_sql(

99: l_url,
100: l_asof_year - l_prev_asof_year,
101: l_sec_context) || ' from
102: ' ||
103: poa_dbi_template_pkg.status_sql(
104: p_fact_name => l_mv,
105: p_where_clause => l_where_clause,
106: p_join_tables => l_join_tbl,
107: p_use_windowing => 'Y',

Line 211: poa_dbi_template_pkg.union_all_status_sql(

207: l_view_by_col,
208: l_url,
209: l_asof_year - l_prev_asof_year,
210: l_sec_context) || ' from ('||fnd_global.newline||
211: poa_dbi_template_pkg.union_all_status_sql(
212: p_mv => l_mv_tbl,
213: p_join_tables => l_join_tbl,
214: p_use_windowing => 'Y',
215: p_paren_count => 3,

Line 227: poa_dbi_template_pkg.status_sql(

223: l_url,
224: l_asof_year - l_prev_asof_year,
225: l_sec_context) || ' from
226: ' ||
227: poa_dbi_template_pkg.status_sql(
228: p_fact_name => l_mv,
229: p_where_clause => l_where_clause,
230: p_join_tables => l_join_tbl,
231: p_use_windowing => 'Y',

Line 494: poa_dbi_template_pkg.status_sql(

490: ,l_prev_asof_year-l_prev_prev_asof_year);
491: l_query := l_query || ' from ';
492:
493: l_query := l_query ||
494: poa_dbi_template_pkg.status_sql(
495: p_fact_name => l_mv,
496: p_where_clause => l_where_clause,
497: p_join_tables => l_join_tbl,
498: p_use_windowing => 'Y',

Line 590: poa_dbi_template_pkg.union_all_status_sql(

586: ,l_asof_year - l_prev_asof_year
587: ,l_prev_asof_year-l_prev_prev_asof_year);
588:
589: l_query := l_query || ' from ( ' ||
590: poa_dbi_template_pkg.union_all_status_sql(
591: p_mv => l_mv_tbl,
592: p_join_tables => l_join_tbl,
593: p_use_windowing => 'Y',
594: p_paren_count => 3,

Line 605: poa_dbi_template_pkg.status_sql(

601: ,l_asof_year - l_prev_asof_year
602: ,l_prev_asof_year-l_prev_prev_asof_year);
603:
604: l_query := l_query || ' from ' ||
605: poa_dbi_template_pkg.status_sql(
606: p_fact_name => l_mv,
607: p_where_clause => l_where_clause,
608: p_join_tables => l_join_tbl,
609: p_use_windowing => 'Y',