APPS.POA_DBI_NCP_PKG dependencies on POA_DBI_TEMPLATE_PKG

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

43: l_url := 'pFunctionName=POA_DBI_NCP_STATUS_RPT&VIEW_BY_NAME=VIEW_BY_VALUE&VIEW_BY=SUPPLIER+POA_SUPPLIERS';
44: end if;
45:
46: l_query := get_status_sel_clause(l_view_by_col, l_url) || ' from
47: '|| poa_dbi_template_pkg.status_sql(l_mv,
48: l_where_clause,
49: l_join_tbl,
50: p_use_windowing => 'Y',
51: p_col_name => l_col_tbl,

Line 107: '|| poa_dbi_template_pkg.trend_sql(

103: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'purchase_amt', 'N');
104: poa_dbi_util_pkg.add_column(l_col_tbl, 'n_contract_amt_' || l_cur_suffix, 'n_contract_amt', 'N');
105:
106: l_query := get_trend_sel_clause || ' from
107: '|| poa_dbi_template_pkg.trend_sql(
108: l_xtd,
109: l_comparison_type,
110: l_mv,
111: l_where_clause,