APPS.POA_DBI_FR_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 121: poa_dbi_template_pkg.status_sql(l_mv,

117:
118: l_query := get_status_sel_clause(l_view_by, l_view_by_col) || ' from ';
119:
120: l_query := l_query ||
121: poa_dbi_template_pkg.status_sql(l_mv,
122: l_where_clause,
123: l_join_tbl,
124: p_use_windowing => 'Y',
125: p_col_name => l_col_tbl,

Line 393: poa_dbi_template_pkg.status_sql(

389: end if;
390:
391: l_query := get_summary_sel_clause(l_view_by, l_view_by_col) || ' from ';
392: l_query := l_query ||
393: poa_dbi_template_pkg.status_sql(
394: l_mv,
395: l_where_clause,
396: l_join_tbl,
397: p_use_windowing => 'Y',

Line 629: poa_dbi_template_pkg.status_sql(l_mv,

625:
626: l_query := get_amt_sql_sel_clause(l_view_by, l_view_by_col,l_bucket_rec) || ' from ';
627:
628: l_query := l_query ||
629: poa_dbi_template_pkg.status_sql(l_mv,
630: l_where_clause,
631: l_join_tbl,
632: p_use_windowing => 'Y',
633: p_col_name => l_col_tbl,

Line 1057: poa_dbi_template_pkg.status_sql(

1053:
1054: l_query := get_req_age_sel_clause(l_view_by, l_view_by_col,l_bucket_rec) || ' from ';
1055:
1056: l_query := l_query ||
1057: poa_dbi_template_pkg.status_sql(
1058: l_mv,
1059: l_where_clause,
1060: l_join_tbl,
1061: p_use_windowing => 'Y',

Line 1325: || poa_dbi_template_pkg.trend_sql(

1321: , p_to_date_type => 'RLX');
1322:
1323: l_query := get_trend_sel_clause || '
1324: from '
1325: || poa_dbi_template_pkg.trend_sql(
1326: l_xtd,
1327: l_comparison_type,
1328: l_mv,
1329: l_where_clause,

Line 1419: || poa_dbi_template_pkg.trend_sql(

1415: , p_to_date_type => 'RLX');
1416:
1417: l_query := get_amt_trend_sel_clause || '
1418: from '
1419: || poa_dbi_template_pkg.trend_sql(
1420: l_xtd,
1421: l_comparison_type,
1422: l_mv,
1423: l_where_clause,

Line 1518: || poa_dbi_template_pkg.trend_sql(

1514: , p_to_date_type => 'RLX');
1515:
1516: l_query := get_ped_trend_sel_clause || '
1517: from '
1518: || poa_dbi_template_pkg.trend_sql(
1519: l_xtd,
1520: l_comparison_type,
1521: l_mv,
1522: l_where_clause,