APPS.OKI_DBI_NSCM_ACT_PVT dependencies on POA_DBI_TEMPLATE_PKG

Line 160: || poa_dbi_template_pkg.union_all_status_sql

156: l_query := get_activations_sel_clause (l_view_by, l_view_by_col)
157:
158: || ' from ('
159:
160: || poa_dbi_template_pkg.union_all_status_sql
161: (p_mv => l_mv_tbl,
162: p_join_tables => l_join_tbl,
163: p_use_windowing => 'Y',
164: p_paren_count => 1,

Line 169: || poa_dbi_template_pkg.get_viewby_rank_clause ( p_join_tables => l_join_tbl

165: p_filter_where => NULL,
166: p_generate_viewby => 'N') || ')'
167: || ' oset05 ) oset10) oset15) oset20 ) where' || l_filter_where || ')oset , '
168:
169: || poa_dbi_template_pkg.get_viewby_rank_clause ( p_join_tables => l_join_tbl
170: , p_use_windowing => 'Y' );
171:
172: --}
173: ELSE

Line 215: || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv

211:
212: -- Generate sql query
213: l_query := get_activations_sel_clause (l_view_by, l_view_by_col) || ' from '
214:
215: || poa_dbi_template_pkg.status_sql (p_fact_name => l_mv
216: , p_where_clause => l_where_clause
217: , p_filter_where => l_filter_where
218: , p_join_tables => l_join_tbl
219: , p_use_windowing => 'Y'

Line 573: ||poa_dbi_template_pkg.union_all_trend_sql

569:
570:
571: l_query := get_act_trend_sel_clause
572: || ' from '
573: ||poa_dbi_template_pkg.union_all_trend_sql
574: (p_mv => l_mv_tbl,
575: p_comparison_type => 'R',
576: p_filter_where => NULL);
577: --}

Line 615: || poa_dbi_template_pkg.trend_sql (p_xtd => l_xtd

611:
612: l_query :=
613: get_act_trend_sel_clause
614: || ' from '
615: || poa_dbi_template_pkg.trend_sql (p_xtd => l_xtd
616: , p_comparison_type => l_comparison_type
617: , p_fact_name => l_mv
618: , p_where_clause => l_where_clause
619: , p_col_name => l_col_tbl

Line 772: || poa_dbi_template_pkg.dtl_status_sql2 (

768: l_where_clause := l_where_clause ||' AND renewal_flag in (1,3) ';
769: end if;
770:
771: l_query := get_act_dtl_sel_clause (l_cur_suffix, l_period_type,l_status_id)
772: || poa_dbi_template_pkg.dtl_status_sql2 (
773: p_fact_name => l_mv
774: , p_where_clause => l_where_clause || l_rpt_specific_where
775: , p_join_tables => l_join_tbl
776: , p_use_windowing => 'Y'