APPS.POA_DBI_RET_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 112: poa_dbi_template_pkg.status_sql(l_mv,

108:
109: l_url := 'pFunctionName=POA_DBI_RET_REASON_RPT&VIEW_BY_NAME=VIEW_BY_ID&VIEW_BY=ITEM+ENI_ITEM_PO_CAT&pParamIds=Y';
110:
111: l_query := get_status_sel_clause(l_view_by, l_view_by_col, l_url) || ' from ' ||
112: poa_dbi_template_pkg.status_sql(l_mv,
113: l_where_clause,
114: l_join_tbl,
115: p_use_windowing => 'Y',
116: p_col_name => l_col_tbl,

Line 320: || poa_dbi_template_pkg.status_sql(l_mv,

316: ,'qty_return'
317: ,p_to_date_type => l_to_date_type);
318: end if;
319: l_query := get_reason_sel_clause(l_view_by, l_view_by_col,null) || ' from '
320: || poa_dbi_template_pkg.status_sql(l_mv,
321: l_where_clause,
322: l_join_tbl,
323: p_use_windowing => 'Y',
324: p_col_name => l_col_tbl,

Line 541: || poa_dbi_template_pkg.trend_sql(

537: poa_dbi_util_pkg.add_column(l_col_tbl,'num_txns_return_cnt','cnt_return','N',3,p_to_date_type => l_to_date_type);
538:
539: l_query := get_trend_sel_clause || '
540: from '
541: || poa_dbi_template_pkg.trend_sql(
542: l_xtd,
543: l_comparison_type,
544: l_mv,
545: l_where_clause,

Line 651: || poa_dbi_template_pkg.status_sql(

647: nvl(p_cnt_return,0) poa_measure4,
648: nvl(c_cnt_return_total,0) POA_MEASURE8,
649: nvl(p_cnt_return_total,0) poa_measure9
650: from '
651: || poa_dbi_template_pkg.status_sql(
652: l_mv,
653: l_where_clause,
654: l_join_tbl,
655: p_use_windowing => 'N',