PACKAGE: APPS.BIV_DBI_BAK_AGE_PKG

Source

1 package biv_dbi_bak_age_pkg
2 /* $Header: bivsrvrbags.pls 120.0 2005/05/25 10:58:41 appldev noship $ */
3 as
4 
5 procedure get_tbl_sql
6 ( p_param           in bis_pmv_page_parameter_tbl
7 , x_custom_sql      out nocopy varchar2
8 , x_custom_output   out nocopy bis_query_attributes_tbl
9 , p_distribution    in varchar2 := 'N'
10 );
11 
12 procedure get_dbn_tbl_sql
13 ( p_param           in bis_pmv_page_parameter_tbl
14 , x_custom_sql      out nocopy varchar2
15 , x_custom_output   out nocopy bis_query_attributes_tbl
16 );
17 
18 procedure get_trd_sql
19 ( p_param           in bis_pmv_page_parameter_tbl
20 , x_custom_sql      out nocopy varchar2
21 , x_custom_output   out nocopy bis_query_attributes_tbl
22 , p_distribution    in varchar2 := 'N'
23 );
24 
25 procedure get_dbn_trd_sql
26 ( p_param           in bis_pmv_page_parameter_tbl
27 , x_custom_sql      out nocopy varchar2
28 , x_custom_output   out nocopy bis_query_attributes_tbl
29 );
30 
31 procedure get_detail_sql
32 ( p_param           in bis_pmv_page_parameter_tbl
33 , x_custom_sql      out nocopy varchar2
34 , x_custom_output   out nocopy bis_query_attributes_tbl
35 );
36 
37 FUNCTION get_last_refresh_date
38 (p_object_name IN varchar2
39 )
40 RETURN varchar2;
41 
42 FUNCTION current_report_start_date (
43     as_of_date			IN	 DATE
44   , period_type 		IN	 VARCHAR2
45 )
46 RETURN DATE;
47 
48 end  biv_dbi_bak_age_pkg;