APPS.POA_DBI_PCL_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 53: '|| poa_dbi_template_pkg.status_sql(

49: l_url := 'pFunctionName=POA_DBI_PCL_STATUS_RPT&VIEW_BY_NAME=VIEW_BY_VALUE&VIEW_BY=HRI_PERSON+HRI_PER';
50: end if;
51:
52: l_query := get_status_sel_clause(l_view_by_col, l_url) || ' from
53: '|| poa_dbi_template_pkg.status_sql(
54: l_mv,
55: l_where_clause,
56: l_join_tbl,
57: p_use_windowing => 'Y',

Line 99: '|| poa_dbi_template_pkg.trend_sql(

95: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'purchase_amt', 'N');
96: poa_dbi_util_pkg.add_column(l_col_tbl, 'p_contract_amt_' || l_cur_suffix, 'p_contract_amt', 'N');
97:
98: l_query := get_trend_sel_clause || ' from
99: '|| poa_dbi_template_pkg.trend_sql(
100: l_xtd,
101: l_comparison_type,
102: l_mv,
103: l_where_clause,

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

176: ' || poa_dbi_util_pkg.rate_clause('p_p_contract_amt_total','p_purchase_amt_total') || ' POA_MEASURE2,
177: ' || poa_dbi_util_pkg.rate_clause('c_n_contract_amt_total','c_purchase_amt_total') || ' POA_MEASURE3,
178: ' || poa_dbi_util_pkg.rate_clause('p_n_contract_amt_total','p_purchase_amt_total') || ' POA_MEASURE4
179: from
180: ' || poa_dbi_template_pkg.status_sql( l_mv,
181: l_where_clause,
182: l_join_tbl,
183: p_use_windowing => 'N',
184: p_col_name => l_col_tbl,