[Home] [Help]
PACKAGE: APPS.BIS_PMV_TIME_LEVELS_PVT
Source
1 package BIS_PMV_TIME_LEVELS_PVT AUTHID CURRENT_USER AS
2 /* $Header: BISVTMLS.pls 120.1 2005/07/12 17:13:21 serao noship $ */
3 -- dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=pls \
4 -- dbdrv: checkfile(115.10=120.1):~PROD:~PATH:~FILE
5 --
6 -- To modify this template, edit file PKGSPEC.TXT in TEMPLATE
7 -- directory of SQL Navigator
8 --
9 -- Purpose: Briefly explain the functionality of the package
10 --
11 -- MODIFICATION HISTORY
12 -- Person Date Comments
13 -- --------- ------ ------------------------------------------
14 --
15 -- ansingh Apr 22, 2003 BugFix#2887200
16 -- nbarik Jul 10, 2003 BugFix#2999602
17
18
19 -- Enter package declarations as shown below
20 PROCEDURE GET_PREVIOUS_TIME_LEVEL_VALUE
21 (p_DimensionLevel in VARCHAR2
22 ,p_region_Code in VARCHAR2
23 ,p_Responsibility_id in VARCHAR2
24 ,p_asof_date in DATE
25 ,p_time_comparison_type in VARCHAR2
26 ,x_time_level_id OUT NOCOPY VARCHAR2
27 ,x_time_level_value OUT NOCOPY VARCHAR2
28 ,x_start_Date OUT NOCOPY DATE
29 ,x_end_date OUT NOCOPY DATE
30 ,x_return_status OUT NOCOPY VARCHAR2
31 ,x_msg_count OUT NOCOPY NUMBER
32 ,x_msg_data OUT NOCOPY VARCHAR2
33 ,p_use_current_mode IN BOOLEAN DEFAULT FALSE
34 );
35
36 PROCEDURE GET_TIME_LEVEL_INFO
37 (p_DimensionLevel IN VARCHAR2
38 ,p_region_code IN VARCHAR2
39 ,p_Responsibility_id in VARCHAR2
40 ,p_asof_date IN DATE
41 ,p_mode IN VARCHAR2
42 ,x_time_level_id OUT NOCOPY VARCHAR2
43 ,x_time_level_Value OUT NOCOPY VARCHAR2
44 ,x_start_Date OUT NOCOPY DATE
45 ,x_end_date OUT NOCOPY DATE
46 ,x_return_Status OUT NOCOPY VARCHAR2
47 ,x_msg_count OUT NOCOPY NUMBER
48 ,x_msg_data OUT NOCOPY VARCHAR2
49 );
50 PROCEDURE GET_PREVIOUS_ASOF_DATE
51 (p_DimensionLevel IN VARCHAR2
52 ,p_time_comparison_type IN VARCHAR2
53 ,p_asof_date IN DATE
54 ,x_prev_asof_Date OUT NOCOPY DATE
55 ,x_Return_status OUT NOCOPY VARCHAR2
56 ,x_msg_count OUT NOCOPY NUMBER
57 ,x_msg_data OUT NOCOPY VARCHAR2
58 );
59 PROCEDURE GET_BIS_COMMON_START_DATE
60 (x_prev_asof_Date OUT NOCOPY DATE
61 ,x_return_Status OUT NOCOPY VARCHAR2
62 ,x_msg_count OUT NOCOPY NUMBER
63 ,x_msg_data OUT NOCOPY VARCHAR2
64 );
65 PROCEDURE GET_REPORT_START_DATE
66 (p_time_comparison_type IN VARCHAR2
67 ,p_asof_date IN DATE
68 ,p_time_level IN VARCHAR2
69 ,x_report_start_date OUT NOCOPY DATE
70 ,x_return_status OUT NOCOPY VARCHAR2
71 ,x_msg_count OUT NOCOPY NUMBER
72 ,x_msg_data OUT NOCOPY VARCHAR2
73 );
74
75 /*-----BugFix#2887200 -ansingh-------*/
76 PROCEDURE GET_TIME_PARAMETER_RECORD (
77 p_TimeParamterName IN VARCHAR2,
78 p_DateParameter IN DATE,
79 x_parameterRecord OUT NOCOPY BIS_PMV_PARAMETERS_PVT.PARAMETER_REC_TYPE,
80 x_return_Status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_Data OUT NOCOPY VARCHAR2
83 );
84 /*-----BugFix#2887200 -ansingh-------*/
85 /*
86 Bug Fix 2999602 - Added x_prev_effective_start_date and x_prev_effective_end_date
87 */
88 PROCEDURE GET_COMPUTED_DATES (
89 p_region_code IN VARCHAR2,
90 p_resp_id IN VARCHAR2,
91 p_time_comparison_type IN VARCHAR2,
92 p_asof_date IN varchar2,
93 p_time_level IN VARCHAR2,
94 x_prev_asof_Date OUT NOCOPY DATE,
95 x_curr_effective_start_date OUT NOCOPY DATE,
96 x_curr_effective_end_date OUT NOCOPY DATE,
97 x_curr_report_Start_date OUT NOCOPY DATE,
98 x_prev_report_Start_date OUT NOCOPY DATE,
99 x_time_level_id OUT NOCOPY VARCHAR2,
100 x_time_level_value OUT NOCOPY VARCHAR2,
101 x_prev_effective_start_date OUT NOCOPY DATE,
102 x_prev_effective_end_date OUT NOCOPY DATE,
103 x_prev_time_level_id OUT NOCOPY VARCHAR2,
104 x_prev_time_level_value OUT NOCOPY VARCHAR2,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_Data OUT NOCOPY VARCHAR2
108 );
109
110
111 PROCEDURE GET_NESTED_PATTERN
112 (p_time_comparison_type IN VARCHAR2
113 ,p_time_level IN VARCHAR2
114 ,x_nested_pattern OUT NOCOPY VARCHAR2
115 ,x_return_Status OUT NOCOPY VARCHAR2
116 ,x_msg_count OUT NOCOPY NUMBER
117 ,x_msg_Data OUT NOCOPY VARCHAR2
118 );
119
120 --Combo Box Enh
121 PROCEDURE GET_POPLIST_DATES (
122 p_asof_date IN DATE,
123 p_rolling IN VARCHAR2 DEFAULT NULL,
124 x_last_week OUT NOCOPY DATE,
125 x_last_period OUT NOCOPY DATE,
126 x_last_qtr OUT NOCOPY DATE,
127 x_last_year OUT NOCOPY DATE,
128 x_week OUT NOCOPY DATE,
129 x_period OUT NOCOPY DATE,
130 x_qtr OUT NOCOPY DATE,
131 x_year OUT NOCOPY DATE,
132 x_rolling_week OUT NOCOPY DATE,
133 x_rolling_period OUT NOCOPY DATE,
134 x_rolling_qtr OUT NOCOPY DATE,
135 x_rolling_year OUT NOCOPY DATE,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_count OUT NOCOPY NUMBER,
138 x_msg_Data OUT NOCOPY VARCHAR2
139 );
140
141 end BIS_PMV_TIME_LEVELS_PVT;