1 PACKAGE BODY IBE_BI_PMV_UTIL_PVT AS
2 /* $Header: IBEVBIUTILB.pls 120.5 2011/07/28 10:17:32 saradhak ship $ */
3
4 FUNCTION GET_CURR_CODE(id IN varchar2,p_MSITE_ID IN varchar2) return varchar2 is
5 BEGIN
6 RETURN 'xxx';
7 END GET_CURR_CODE;
8
9 FUNCTION GET_RECORD_TYPE_ID(p_period_type IN VARCHAR2)
10 RETURN NUMBER IS
11 BEGIN
12 RETURN NULL;
13 END GET_RECORD_TYPE_ID;
14
15 -- Function to get the previous date.. required for calculating the % change
16
17 FUNCTION GET_PREV_DATE(p_asof_date IN DATE, p_period_type VARCHAR2, p_comparison_type VARCHAR2)
18 RETURN DATE IS
19 BEGIN
20 RETURN NULL;
21 END GET_PREV_DATE;
22
23 PROCEDURE ENT_YR_SPAN(p_asof_date IN Date,
24 x_timespan OUT NOCOPY Number,
25 x_sequence OUT NOCOPY Number)
26 IS
27 Begin
28 NULL;
29 END ENT_YR_SPAN;
30
31 PROCEDURE ENT_QTR_SPAN(p_asof_date IN DATE,
32 p_comparator IN VARCHAR2,
33 x_cur_start OUT NOCOPY DATE,
34 x_prev_start OUT NOCOPY DATE,
35 x_mid_start OUT NOCOPY DATE,
36 x_cur_year OUT NOCOPY NUMBER,
37 x_prev_year OUT NOCOPY NUMBER,
38 x_timespan OUT NOCOPY NUMBER)
39 IS
40 Begin
41 NULL;
42 END ENT_QTR_SPAN;
43
44 PROCEDURE ENT_PRD_SPAN(p_asof_date IN DATE,
45
46 p_comparator IN VARCHAR2,
47 x_cur_start OUT NOCOPY DATE,
48 x_prev_start OUT NOCOPY DATE,
49 x_mid_start OUT NOCOPY DATE,
50 x_cur_year OUT NOCOPY NUMBER,
51 x_prev_year OUT NOCOPY NUMBER,
52 x_timespan OUT NOCOPY NUMBER)
53 IS
54 Begin
55 NULL;
56 END ENT_PRD_SPAN;
57
58 PROCEDURE WEEK_SPAN(p_asof_date IN DATE,
59 p_comparator IN VARCHAR2,
60 x_cur_start OUT NOCOPY DATE,
61 x_prev_start OUT NOCOPY DATE,
62 x_pcur_start OUT NOCOPY DATE,
63 x_pprev_start OUT NOCOPY DATE,
64 x_timespan OUT NOCOPY NUMBER)
65 IS
66 Begin
67 NULL;
68 END WEEK_SPAN;
69
70 END IBE_BI_PMV_UTIL_PVT;