1 PACKAGE BIM_PMV_DBI_UTL_PKG AS
2 /*$Header: bimvutls.pls 120.1 2005/08/04 23:32:27 sbassi noship $ */
3
4 PROCEDURE get_bim_page_params (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
5 l_as_of_date OUT NOCOPY DATE,
6 l_period_type IN OUT NOCOPY VARCHAR2,
7 l_record_type_id OUT NOCOPY NUMBER,
8 l_comp_type OUT NOCOPY VARCHAR2,
9 l_country in OUT NOCOPY VARCHAR2,
10 l_view_by in OUT NOCOPY VARCHAR2,
11 l_cat_id in OUT NOCOPY VARCHAR2,
12 l_campaign_id in OUT NOCOPY VARCHAR2,
13 l_currency in OUT NOCOPY VARCHAR2,
14 l_col_id in OUT NOCOPY NUMBER,
15 l_area in OUT NOCOPY VARCHAR2,
16 l_media in OUT NOCOPY VARCHAR2,
17 l_report_name in OUT NOCOPY VARCHAR2
18 ) ;
19 PROCEDURE get_bim_page_sgmt_params (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
20 p_as_of_date OUT NOCOPY DATE,
21 p_period_type IN OUT NOCOPY VARCHAR2,
22 p_record_type_id OUT NOCOPY NUMBER,
23 p_view_by IN OUT NOCOPY VARCHAR2,
24 p_cat_id IN OUT NOCOPY VARCHAR2,
25 p_sgmt_id IN OUT NOCOPY VARCHAR2,
26 p_currency IN OUT NOCOPY VARCHAR2,
27 p_url_metric IN OUT NOCOPY VARCHAR2,
28 p_url_viewby IN OUT NOCOPY VARCHAR2,
29 p_url_viewbyid IN OUT NOCOPY VARCHAR2
30 ) ;
31 PROCEDURE get_viewby_id (p_page_parameter_tbl IN BIS_PMV_PAGE_PARAMETER_TBL,
32 l_viewby_id in OUT NOCOPY NUMBER);
33
34 FUNCTION Current_Period_Start_Date(l_as_of_date DATE,
35 l_period_type VARCHAR2) RETURN DATE;
36
37 FUNCTION Previous_Period_Start_Date(l_as_of_date DATE,
38 l_period_type VARCHAR2,
39 l_comp_type VARCHAR2) RETURN DATE;
40
41 FUNCTION Current_Report_Start_Date(l_as_of_date DATE,
42 l_period_type VARCHAR2) RETURN DATE ;
43
44 FUNCTION Previous_Report_Start_Date(l_as_of_date DATE,
45 l_period_type VARCHAR2,
46 l_comp_type VARCHAR2) RETURN DATE;
47
48 FUNCTION Previous_Period_Asof_Date(l_as_of_date DATE,
49 l_period_type VARCHAR2,
50 l_comp_type VARCHAR2) RETURN DATE ;
51
52 PROCEDURE GET_TREND_PARAMS( p_page_period_type IN VARCHAR2,
53 p_comp_type IN VARCHAR2,
54 p_curr_as_of_date IN DATE,
55 p_table_name OUT NOCOPY VARCHAR2,
56 p_column_name OUT NOCOPY VARCHAR2,
57 p_curr_start_date OUT NOCOPY DATE,
58 p_prev_start_date OUT NOCOPY DATE,
59 p_prev_end_date OUT NOCOPY DATE,
60 p_series_name OUT NOCOPY VARCHAR2,
61 p_time_ids OUT NOCOPY VARCHAR2
62 );
63
64 FUNCTION GET_COLUMN_A ( p_name IN Varchar2) RETURN VARCHAR2;
65
66
67 FUNCTION get_rpl_label(p_name in varchar2,pld in varchar2) RETURN VARCHAR2;
68
69 FUNCTION GET_LOOKUP_VALUE (code in varchar2) return VARCHAR2 ;
70
71 FUNCTION GET_CONTEXT_VIEWBY (code in varchar2) return VARCHAR2 ;
72
73 END BIM_PMV_DBI_UTL_PKG;