1 PACKAGE CST_PARAMETER_CSTREV AUTHID CURRENT_USER AS
2 /* $Header: CSTSREVS.pls 115.5 2003/02/19 21:29:14 weizhou ship $ */
3
4
5
6 /*
7 * Parameter_FormView_CSTREV
8 *
9 * This function is invoked via a form function
10 * and is the entry point into this package.
11 * It creates the HTML parameter page used by
12 * the BIS Sales Revenue report.
13 */
14 PROCEDURE Parameter_FormView_CSTREV( force_display in varchar2 default 'YES');
15
16
17
18 /*
19 * Parameter_ActionView_CSTREV
20 *
21 * This function is invoked when the user clicks
22 * the OK button in the HTML page generated by
23 * Parameter_FormView_CSTREV. It will validate
24 * the input parameters and launch the Sales Revenue
25 * report.
26 */
27 PROCEDURE Parameter_ActionView_CSTREV (
28 P_ORG_LEVEL NUMBER,
29 P_ORGANIZATION_ID VARCHAR2 default null,
30 P_ORGANIZATION_NAME VARCHAR2 default null,
31 P_BUSINESS_PLAN NUMBER,
32 P_GEOGRAPHY_CODE VARCHAR2 default null,
33 P_GEOGRAPHY_NAME VARCHAR2 default null,
34 P_SALES_CHANNEL_CODE VARCHAR2 default null,
35 P_SALES_CHANNEL_NAME VARCHAR2 default null,
36 P_ITEM_CODE VARCHAR2 default null,
37 P_ITEM VARCHAR2 default null,
38 P_VIEW_BY varchar2,
39 P_FROM_DATE VARCHAR2 default null,
40 P_TO_DATE VARCHAR2 default null
41 );
42
43
44
45 /*
46 * Before_Parameter_CSTREV
47 *
48 * This function is called by Parameter_FormView_CSTREV
49 * to perform initial setups. It should not be invoked
50 * directly.
51 */
52 PROCEDURE Before_Parameter_CSTREV;
53
54
55
56 /*
57 * After_Parameter_CSTREV
58 *
59 * This function is called by Parameter_ActionView_CSTREV
60 * to perform validations. It should not be invoked
61 * directly.
62 */
63 PROCEDURE After_Parameter_CSTREV;
64
65
66
67 END CST_PARAMETER_CSTREV;