APPS.BIV_DBI_ACT_PKG dependencies on POA_DBI_TEMPLATE_PKG

Line 13: poa_dbi_template_pkg.g_c_as_of_date := 'least(&BIS_CURRENT_ASOF_DATE,&LAST_COLLECTION)';

9: -- Last refresh date checks
10: procedure set_last_collection
11: is
12: begin
13: poa_dbi_template_pkg.g_c_as_of_date := 'least(&BIS_CURRENT_ASOF_DATE,&LAST_COLLECTION)';
14: poa_dbi_template_pkg.g_p_as_of_date := 'least(&BIS_PREVIOUS_ASOF_DATE,&LAST_COLLECTION)';
15: end set_last_collection;
16:
17: -- Last refresh date checks

Line 14: poa_dbi_template_pkg.g_p_as_of_date := 'least(&BIS_PREVIOUS_ASOF_DATE,&LAST_COLLECTION)';

10: procedure set_last_collection
11: is
12: begin
13: poa_dbi_template_pkg.g_c_as_of_date := 'least(&BIS_CURRENT_ASOF_DATE,&LAST_COLLECTION)';
14: poa_dbi_template_pkg.g_p_as_of_date := 'least(&BIS_PREVIOUS_ASOF_DATE,&LAST_COLLECTION)';
15: end set_last_collection;
16:
17: -- Last refresh date checks
18: procedure unset_last_collection

Line 21: poa_dbi_template_pkg.g_c_as_of_date := '&BIS_CURRENT_ASOF_DATE';

17: -- Last refresh date checks
18: procedure unset_last_collection
19: is
20: begin
21: poa_dbi_template_pkg.g_c_as_of_date := '&BIS_CURRENT_ASOF_DATE';
22: poa_dbi_template_pkg.g_p_as_of_date := '&BIS_PREVIOUS_ASOF_DATE';
23: end unset_last_collection;
24: */
25: procedure get_tbl_sql

Line 22: poa_dbi_template_pkg.g_p_as_of_date := '&BIS_PREVIOUS_ASOF_DATE';

18: procedure unset_last_collection
19: is
20: begin
21: poa_dbi_template_pkg.g_c_as_of_date := '&BIS_CURRENT_ASOF_DATE';
22: poa_dbi_template_pkg.g_p_as_of_date := '&BIS_PREVIOUS_ASOF_DATE';
23: end unset_last_collection;
24: */
25: procedure get_tbl_sql
26: ( p_param in bis_pmv_page_parameter_tbl

Line 225: ( select * from ( ' || poa_dbi_template_pkg.status_sql

221: , ' ||
222: biv_dbi_tmpl_util.get_category_drill_down( l_view_by , g_activity_rep_func ) ||
223: '
224: from
225: ( select * from ( ' || poa_dbi_template_pkg.status_sql
226: ( P_FACT_NAME => l_mv
227: , P_WHERE_CLAUSE => l_where_clause
228: , P_JOIN_TABLES => l_join_tbl
229: , P_USE_WINDOWING => 'N'

Line 328: poa_dbi_template_pkg.status_sql

324: , nvl(c_backlog,0) c_backlog
325: , nvl(p_backlog,0) p_backlog
326: from
327: ( ( ' ||
328: poa_dbi_template_pkg.status_sql
329: ( p_fact_name => l_mv
330: , p_where_clause => l_where_clause
331: , p_join_tables => l_join_tbl
332: , p_use_windowing => 'N'

Line 411: poa_dbi_template_pkg.status_sql

407: , 0 c_backlog
408: , 0 p_backlog
409: from
410: ( ' ||
411: poa_dbi_template_pkg.status_sql
412: ( p_fact_name => l_mv
413: , p_where_clause => l_where_clause
414: , p_join_tables => l_join_tbl
415: , p_use_windowing => 'N'

Line 717: ' || poa_dbi_template_pkg.trend_sql

713: END IF;
714:
715: l_stmt := l_stmt ||'
716: from
717: ' || poa_dbi_template_pkg.trend_sql
718: ( p_xtd => l_xtd
719: , p_comparison_type => l_comparison_type
720: , p_fact_name => l_mv
721: , p_where_clause => l_where_clause

Line 830: ' || poa_dbi_template_pkg.trend_sql

826: , 0 p_closed
827: , nvl(iset.c_backlog,0) c_backlog
828: , nvl(iset.p_backlog,0) p_backlog
829: from
830: ' || poa_dbi_template_pkg.trend_sql
831: ( p_xtd => l_xtd
832: , p_comparison_type => l_comparison_type
833: , p_fact_name => l_mv
834: , p_where_clause => l_where_clause

Line 905: ' || poa_dbi_template_pkg.trend_sql

901: , 0 c_backlog
902: , 0 p_backlog
903:
904: from
905: ' || poa_dbi_template_pkg.trend_sql
906: ( p_xtd => l_xtd
907: , p_comparison_type => l_comparison_type
908: , p_fact_name => l_mv
909: , p_where_clause => l_where_clause