eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIV_DBI_BAK_PKG dependencies on POA_DBI_TEMPLATE_PKG

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

91: -- Last refresh date checks
92: procedure set_last_collection
93: is
94: begin
95: poa_dbi_template_pkg.g_c_as_of_date := 'least(&BIS_CURRENT_ASOF_DATE,&LAST_COLLECTION)';
96: poa_dbi_template_pkg.g_p_as_of_date := 'least(&BIS_PREVIOUS_ASOF_DATE,&LAST_COLLECTION)';
97: end set_last_collection;
98:
99: -- Last refresh date checks

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

92: procedure set_last_collection
93: is
94: begin
95: poa_dbi_template_pkg.g_c_as_of_date := 'least(&BIS_CURRENT_ASOF_DATE,&LAST_COLLECTION)';
96: poa_dbi_template_pkg.g_p_as_of_date := 'least(&BIS_PREVIOUS_ASOF_DATE,&LAST_COLLECTION)';
97: end set_last_collection;
98:
99: -- Last refresh date checks
100: procedure unset_last_collection

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

99: -- Last refresh date checks
100: procedure unset_last_collection
101: is
102: begin
103: poa_dbi_template_pkg.g_c_as_of_date := '&BIS_CURRENT_ASOF_DATE';
104: poa_dbi_template_pkg.g_p_as_of_date := '&BIS_PREVIOUS_ASOF_DATE';
105: end unset_last_collection;
106: */
107:

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

100: procedure unset_last_collection
101: is
102: begin
103: poa_dbi_template_pkg.g_c_as_of_date := '&BIS_CURRENT_ASOF_DATE';
104: poa_dbi_template_pkg.g_p_as_of_date := '&BIS_PREVIOUS_ASOF_DATE';
105: end unset_last_collection;
106: */
107:
108: procedure get_tbl_sql

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

256: , ' ||
257: drill_across('N','UNOWNED', 'oset.c_unowned', 'BIV_ATTRIBUTE8',l_view_by) ||
258: '
259: from
260: ( select * from ( ' || poa_dbi_template_pkg.status_sql
261: ( p_fact_name => l_mv
262: , p_where_clause => l_where_clause
263: , p_join_tables => l_join_tbl
264: , p_use_windowing => 'N'

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

515: , ' ||
516: drill_across('Y','BACKLOG', 'oset.c_backlog', 'BIV_ATTRIBUTE6',l_view_by) ||
517: '
518: from
519: ( select * from ( ' || poa_dbi_template_pkg.status_sql
520: ( p_fact_name => l_mv
521: , p_where_clause => l_where_clause
522: , p_join_tables => l_join_tbl
523: , p_use_windowing => 'N'

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

775: , ' ||
776: unr_drill_across('Y','BACKLOG', 'oset.c_backlog', 'BIV_ATTRIBUTE6',l_view_by) ||
777: '
778: from
779: ( select * from ( ' || poa_dbi_template_pkg.status_sql
780: ( p_fact_name => l_mv
781: , p_where_clause => l_where_clause
782: , p_join_tables => l_join_tbl
783: , p_use_windowing => 'N'

Line 981: ' || poa_dbi_template_pkg.trend_sql

977:
978: l_stmt := l_stmt ||'
979:
980: from
981: ' || poa_dbi_template_pkg.trend_sql
982: ( p_xtd => l_xtd
983: , p_comparison_type => l_comparison_type
984: , p_fact_name => l_mv
985: , p_where_clause => l_where_clause