APPS.POA_DBI_PR_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 123: poa_dbi_template_pkg.status_sql(

119: end if;
120:
121: l_query := get_status_sel_clause(l_view_by, l_view_by_col) || ' from ';
122: l_query := l_query ||
123: poa_dbi_template_pkg.status_sql(
124: l_mv,
125: l_where_clause,
126: l_join_tbl,
127: p_use_windowing => 'Y',

Line 396: poa_dbi_template_pkg.status_sql(

392: end if;
393:
394: l_query := get_status_sum_sel_clause(l_view_by, l_view_by_col) || ' from ';
395: l_query := l_query ||
396: poa_dbi_template_pkg.status_sql(
397: l_mv,
398: l_where_clause,
399: l_join_tbl,
400: p_use_windowing => 'Y',

Line 628: poa_dbi_template_pkg.status_sql(

624: end if;
625:
626: l_query := get_amt_sel_clause(l_view_by, l_view_by_col, l_bucket_rec) || ' from ';
627: l_query := l_query ||
628: poa_dbi_template_pkg.status_sql(
629: l_mv,
630: l_where_clause,
631: l_join_tbl,
632: p_use_windowing => 'Y',

Line 907: poa_dbi_template_pkg.status_sql(

903: end if;
904:
905: l_query := get_age_sel_clause(l_view_by, l_view_by_col, l_bucket_rec) || ' from ';
906: l_query := l_query ||
907: poa_dbi_template_pkg.status_sql(
908: l_mv,
909: l_where_clause,
910: l_join_tbl,
911: p_use_windowing => 'Y',

Line 1210: || poa_dbi_template_pkg.trend_sql(

1206: , p_to_date_type => 'RLX');
1207:
1208: l_query := get_amt_trend_sel_clause || '
1209: from '
1210: || poa_dbi_template_pkg.trend_sql(
1211: l_xtd,
1212: l_comparison_type,
1213: l_mv,
1214: l_where_clause,

Line 1340: || poa_dbi_template_pkg.trend_sql(

1336: p_to_date_type => 'RLX'
1337: );
1338:
1339: l_query := get_age_trend_sel_clause || 'from '|| fnd_global.newline
1340: || poa_dbi_template_pkg.trend_sql(
1341: l_xtd,
1342: l_comparison_type,
1343: l_mv,
1344: l_where_clause,

Line 1473: || poa_dbi_template_pkg.trend_sql(

1469: , p_to_date_type => 'RLX');
1470:
1471: l_query := get_au_trend_sel_clause || '
1472: from '
1473: || poa_dbi_template_pkg.trend_sql(
1474: l_xtd,
1475: l_comparison_type,
1476: l_mv,
1477: l_where_clause,