PACKAGE: APPS.IBE_BI_PMV_UTIL_PVT

Source

1 PACKAGE IBE_BI_PMV_UTIL_PVT AS
2 /* $Header: IBEVBIUTILS.pls 120.1 2005/09/16 05:51:38 appldev ship $ */
3 
4 FUNCTION GET_CURR_CODE(id IN varchar2,p_MSITE_ID IN varchar2)
5                  return varchar2;
6 
7 PROCEDURE ENT_YR_SPAN(p_asof_date   IN  Date,
8                       x_timespan    OUT NOCOPY Number,
9                       x_sequence    OUT NOCOPY Number);
10 
11 PROCEDURE ENT_QTR_SPAN(p_asof_date  IN  DATE,
12                        p_comparator IN  VARCHAR2,
13                        x_cur_start  OUT NOCOPY DATE,
14                        x_prev_start OUT NOCOPY DATE,
15                        x_mid_start  OUT NOCOPY DATE,
16                        x_cur_year   OUT NOCOPY NUMBER,
17                        x_prev_year  OUT NOCOPY NUMBER,
18                        x_timespan   OUT NOCOPY NUMBER);
19 
20 PROCEDURE ENT_PRD_SPAN(p_asof_date  IN  DATE,
21                        p_comparator IN  VARCHAR2,
22                        x_cur_start  OUT NOCOPY DATE,
23                        x_prev_start OUT NOCOPY DATE,
24                        x_mid_start  OUT NOCOPY DATE,
25                        x_cur_year   OUT NOCOPY NUMBER,
26                        x_prev_year  OUT NOCOPY NUMBER,
27                        x_timespan   OUT NOCOPY NUMBER);
28 
29 PROCEDURE WEEK_SPAN(  p_asof_date   IN  DATE,
30                       p_comparator  IN VARCHAR2,
31                       x_cur_start   OUT NOCOPY DATE,
32                       x_prev_start  OUT NOCOPY DATE,
33                       x_pcur_start  OUT NOCOPY DATE,
34                       x_pprev_start OUT NOCOPY DATE,
35                       x_timespan    OUT NOCOPY NUMBER);
36 
37 FUNCTION GET_RECORD_TYPE_ID(p_period_type IN VARCHAR2)
38 RETURN NUMBER;
39 
40 FUNCTION GET_PREV_DATE(p_asof_date IN DATE, p_period_type VARCHAR2, p_comparison_type VARCHAR2)
41 RETURN DATE;
42 
43 END IBE_BI_PMV_UTIL_PVT;