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