DBA Data[Home] [Help]

APPS.BIV_DBI_BAK_AGE_PKG dependencies on POA_DBI_TEMPLATE_PKG

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

15: -- Last refresh date checks
16: procedure set_last_collection
17: is
18: begin
19: poa_dbi_template_pkg.g_c_as_of_date := 'least(&BIS_CURRENT_ASOF_DATE,&LAST_COLLECTION)';
20: poa_dbi_template_pkg.g_p_as_of_date := 'least(&BIS_PREVIOUS_ASOF_DATE,&LAST_COLLECTION)';
21: end set_last_collection;
22:
23: -- Last refresh date checks

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

16: procedure set_last_collection
17: is
18: begin
19: poa_dbi_template_pkg.g_c_as_of_date := 'least(&BIS_CURRENT_ASOF_DATE,&LAST_COLLECTION)';
20: poa_dbi_template_pkg.g_p_as_of_date := 'least(&BIS_PREVIOUS_ASOF_DATE,&LAST_COLLECTION)';
21: end set_last_collection;
22:
23: -- Last refresh date checks
24: procedure unset_last_collection

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

23: -- Last refresh date checks
24: procedure unset_last_collection
25: is
26: begin
27: poa_dbi_template_pkg.g_c_as_of_date := '&BIS_CURRENT_ASOF_DATE';
28: poa_dbi_template_pkg.g_p_as_of_date := '&BIS_PREVIOUS_ASOF_DATE';
29: end unset_last_collection;
30: */
31:

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

24: procedure unset_last_collection
25: is
26: begin
27: poa_dbi_template_pkg.g_c_as_of_date := '&BIS_CURRENT_ASOF_DATE';
28: poa_dbi_template_pkg.g_p_as_of_date := '&BIS_PREVIOUS_ASOF_DATE';
29: end unset_last_collection;
30: */
31:
32:

Line 171: poa_dbi_template_pkg.get_viewby_rank_clause (

167:
168: IF(p_generate_viewby = 'Y')
169: THEN
170: l_viewby_rank_where := ','||
171: poa_dbi_template_pkg.get_viewby_rank_clause (
172: p_join_tables => p_join_tables
173: , p_use_windowing => p_use_windowing);
174: END IF;
175: