APPS.POA_DBI_APM_PKG dependencies on POA_DBI_TEMPLATE_PKG

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

61: l_url := 'pFunctionName=POA_DBI_APM_STATUS_RPT&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=HRI_PERSON+HRI_PER&pParamIds=Y';
62: end if;
63:
64: l_query := get_status_sel_clause(l_view_by_col, l_url) || ' from
65: '|| poa_dbi_template_pkg.status_sql(l_mv,
66: l_where_clause,
67: l_join_tbl,
68: p_use_windowing => 'Y',
69: p_col_name => l_col_tbl,

Line 118: '|| poa_dbi_template_pkg.trend_sql(

114: poa_dbi_util_pkg.add_column(l_col_tbl, 'manual_dist_count', 'manual_dist_count', 'N',p_to_date_type => l_to_date_type);
115: poa_dbi_util_pkg.add_column(l_col_tbl, 'dist_count', 'dist_count', 'N',p_to_date_type => l_to_date_type);
116:
117: l_query := get_trend_sel_clause || ' from
118: '|| poa_dbi_template_pkg.trend_sql(
119: l_xtd,
120: l_comparison_type,
121: l_mv,
122: l_where_clause,

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

184: ' || poa_dbi_util_pkg.rate_clause('p_manual_dist_count','p_dist_count') || ' POA_PERCENT2,
185: ' || poa_dbi_util_pkg.rate_clause('c_manual_dist_count_total','c_dist_count_total') || ' POA_MEASURE1,
186: ' || poa_dbi_util_pkg.rate_clause('p_manual_dist_count_total','p_dist_count_total') || ' POA_MEASURE2
187: from
188: ' || poa_dbi_template_pkg.status_sql(l_mv,
189: l_where_clause,
190: l_join_tbl,
191: p_use_windowing => 'N',
192: p_col_name => l_col_tbl,