1 PACKAGE BODY CST_PARAMETER_CSTREV AS
2 /* $Header: CSTSREVB.pls 120.1 2005/10/04 17:57:44 julzhang noship $ */
3
4
5 /*
6 * error
7 *
8 * This creates the pretty looking error message page.
9 */
10 PROCEDURE error( P_FIELD IN VARCHAR2 ) IS
11 BEGIN
12
13 return;
14 END error;
15
16
17
18
19 /*
20 * Before_Parameter_CSTREV
21 *
22 * This function is called by Parameter_FormView_CSTREV
23 * to perform initial setups. It should not be invoked
24 * directly.
25 */
26 PROCEDURE Before_Parameter_CSTREV IS
27 BEGIN
28 return;
29 END Before_Parameter_CSTREV;
30
31
32
33
34 /*
35 * After_Parameter_CSTREV
36 *
37 * This function is called by Parameter_ActionView_CSTREV
38 * to perform validations. It should not be invoked
39 * directly.
40 */
41 PROCEDURE After_Parameter_CSTREV IS
42 BEGIN
43 return;
44 END After_Parameter_CSTREV;
45
46
47
48
49 /*
50 * LaunchReport
51 * Launches the report using parameters in
52 * the ICX session attibutes.
53 * Returns TRUE if all necessary parameters are present,
54 * and the report is launched. Otherwise returns FALSE.
55 */
56
57 function LaunchReport(
58 l_session_id in number,
59 L_BUSINESS_PLAN_ID in varchar2,
60 L_ORGANIZATION_LEVEL in varchar2,
61 L_SET_OF_BOOKS_ID in varchar2,
62 L_LEGAL_ENTITY_ID in varchar2,
63 L_OPERATING_UNIT_ID in varchar2,
64 L_GEOGRAPHY_LEVEL in varchar2,
65 L_AREA_ID in varchar2,
66 L_COUNTRY_ID in varchar2,
67 L_REGION_ID in varchar2,
68 L_SALES_CHANNEL_LEVEL in varchar2,
69 L_SALES_CHANNEL_ID in varchar2,
70 L_PRODUCT_LEVEL in varchar2,
71 L_PRODUCT_CATEGORY_ID in varchar2,
72 L_PRODUCT_ID in varchar2,
73 L_DATE_FROM in varchar2,
74 L_DATE_TO in varchar2,
75 L_VIEW_BY in varchar2
76 ) return boolean is
77 begin
78
79 return false;
80
81 end LaunchReport;
82
83
84
85 /*
86 * Parameter_FormView_CSTREV
87 *
88 * This function is invoked via a form function
89 * and is the entry point into this package.
90 * It creates the HTML parameter page used by
91 * the BIS Sales Revenue report.
92 */
93 PROCEDURE Parameter_FormView_CSTREV( force_display in varchar2 default 'YES') IS
94
95 BEGIN
96
97 return;
98
99 END Parameter_FormView_CSTREV;
100
101
102
103
104
105
106
107 FUNCTION Validate_Org( P_ORG_LEVEL IN NUMBER,
108 P_ORG_ID IN VARCHAR2,
109 P_ORG_NAME IN VARCHAR2,
110 l_organization_level OUT NOCOPY VARCHAR2,
111 l_set_of_books_id OUT NOCOPY varchar2,
112 l_legal_entity_id OUT NOCOPY varchar2,
113 l_operating_unit_id out NOCOPY varchar2) RETURN BOOLEAN IS
114 BEGIN
115 return FALSE;
116 END Validate_Org;
117
118
119
120
121
122 FUNCTION Validate_Product(P_PRODUCT_CATEGORY_CODE IN VARCHAR2,
123 P_PRODUCT_CATEGORY_NAME IN VARCHAR2,
124 l_product_level OUT NOCOPY varchar2,
125 l_product_category_id OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
126 BEGIN
127
128 RETURN FALSE;
129
130 END Validate_Product;
131
132
133
134
135
136
137 FUNCTION Validate_Geography(P_AREA_CODE IN VARCHAR2,
138 P_AREA_NAME IN VARCHAR2,
139 l_geography_level out NOCOPY varchar2,
140 l_area_id OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
141 BEGIN
142
143 return FALSE;
144
145 END Validate_Geography;
146
147
148
149
150 FUNCTION Validate_Channel(P_SALES_CHANNEL_CODE IN VARCHAR2,
151 P_SALES_CHANNEL_NAME IN VARCHAR2,
152 l_sales_channel_level OUT NOCOPY VARCHAR2,
153 l_sales_channel_id OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
154 BEGIN
155
156 RETURN FALSE;
157
158 END Validate_Channel;
159
160
161
162
163 FUNCTION Validate_Date(P_FROM_DATE IN VARCHAR2,
164 P_TO_DATE IN VARCHAR2)
165 RETURN BOOLEAN IS
166 BEGIN
167 return FALSE;
168
169 END Validate_Date;
170
171
172
173
174
175 /*
176 * Parameter_ActionView_CSTREV
177 *
178 * This function is invoked when the user clicks
179 * the OK button in the HTML page generated by
180 * Parameter_FormView_CSTREV. It will validate
181 * the input parameters and launch the Sales Revenue
182 * report.
183 */
184 PROCEDURE Parameter_ActionView_CSTREV(
185 P_ORG_LEVEL NUMBER,
186 P_ORGANIZATION_ID VARCHAR2 default null,
187 P_ORGANIZATION_NAME VARCHAR2 default null,
188 P_BUSINESS_PLAN NUMBER,
189 P_GEOGRAPHY_CODE VARCHAR2 default null,
190 P_GEOGRAPHY_NAME VARCHAR2 default null,
191 P_SALES_CHANNEL_CODE VARCHAR2 default null,
192 P_SALES_CHANNEL_NAME VARCHAR2 default null,
193 P_ITEM_CODE VARCHAR2 default null,
194 P_ITEM VARCHAR2 default null,
195 P_VIEW_BY varchar2,
196 P_FROM_DATE VARCHAR2 default null,
197 P_TO_DATE VARCHAR2 default null )
198 IS
199
200 BEGIN
201
202 return;
203
204 END Parameter_ActionView_CSTREV;
205
206
207
208
209
210 END CST_PARAMETER_CSTREV;