1 PACKAGE BODY WIP_PARAMETER_WIPBISQU as
2 /* $Header: wipbisqb.pls 120.1 2005/10/04 17:56:06 weizhou noship $ */
3
4 PROCEDURE error(P_FIELD IN VARCHAR2, P_ERROR_NO IN NUMBER) IS
5 BEGIN
6 return;
7 END error;
8
9 FUNCTION Validate_Org(P_ORG_LEVEL IN OUT NOCOPY VARCHAR2,
10 P_ORGANIZATION_ID IN OUT NOCOPY VARCHAR2,
11 P_ORGANIZATION_NAME IN VARCHAR2 default null,
12 P_SET_OF_BOOKS IN OUT NOCOPY VARCHAR2,
13 P_LEGAL_ENTITY IN OUT NOCOPY VARCHAR2,
14 P_OPERATING_UNIT IN OUT NOCOPY VARCHAR2,
15 P_INV_ORGANIZATION IN OUT NOCOPY VARCHAR2
16 )
17 RETURN BOOLEAN IS
18 BEGIN
19 return FALSE;
20 END Validate_Org;
21
22 FUNCTION Validate_Geo(P_GEOGRAPHY_CODE IN OUT NOCOPY VARCHAR2,
23 P_GEOGRAPHY_NAME IN VARCHAR2 default null,
24 P_GEO_LEVEL IN OUT NOCOPY VARCHAR2,
25 P_AREA IN OUT NOCOPY VARCHAR2,
26 P_COUNTRY IN OUT NOCOPY VARCHAR2,
27 P_REGION IN OUT NOCOPY VARCHAR2
28 )
29 RETURN BOOLEAN IS
30 BEGIN
31 return FALSE;
32 END Validate_Geo;
33
34 FUNCTION Validate_Cat(P_ITEM_CODE IN OUT NOCOPY VARCHAR2,
35 P_ITEM IN VARCHAR2 default null,
36 P_PROD_LEVEL IN OUT NOCOPY VARCHAR2)
37 RETURN BOOLEAN IS
38 BEGIN
39 return FALSE;
40 END Validate_Cat;
41
42 FUNCTION Validate_Date(P_FROM_DATE IN OUT NOCOPY VARCHAR2,
43 P_TO_DATE IN OUT NOCOPY VARCHAR2)
44 RETURN BOOLEAN IS
45 BEGIN
46 return FALSE;
47 END Validate_Date;
48
49 FUNCTION Validate_Parameters(
50 P_ORG_LEVEL IN OUT NOCOPY VARCHAR2,
51 P_ORGANIZATION_ID IN OUT NOCOPY VARCHAR2,
52 P_ORGANIZATION_NAME VARCHAR2 default null,
53 P_SET_OF_BOOKS IN OUT NOCOPY VARCHAR2,
54 P_LEGAL_ENTITY IN OUT NOCOPY VARCHAR2,
55 P_OPERATING_UNIT IN OUT NOCOPY VARCHAR2,
56 P_INV_ORGANIZATION IN OUT NOCOPY VARCHAR2,
57 P_GEO_LEVEL IN OUT NOCOPY VARCHAR2,
58 P_GEOGRAPHY_CODE IN OUT NOCOPY VARCHAR2,
59 P_GEOGRAPHY_NAME VARCHAR2 default null,
60 P_AREA IN OUT NOCOPY VARCHAR2,
61 P_COUNTRY IN OUT NOCOPY VARCHAR2,
62 P_REGION IN OUT NOCOPY VARCHAR2,
63 P_PROD_LEVEL IN OUT NOCOPY VARCHAR2,
64 P_ITEM_CODE IN OUT NOCOPY VARCHAR2,
65 P_ITEM VARCHAR2 default null,
66 P_FROM_DATE IN OUT NOCOPY VARCHAR2,
67 P_TO_DATE IN OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
68 BEGIN
69 return FALSE;
70 END Validate_Parameters;
71
72 PROCEDURE RunReport IS
73 BEGIN
74 NULL;
75 END RunReport;
76
77 PROCEDURE Build_Java_Script (outstring IN OUT NOCOPY VARCHAR2) IS
78 BEGIN
79 return;
80 END Build_Java_Script;
81
82 PROCEDURE Before_Parameter_WIPBISQU IS
83 BEGIN
84 return;
85 END Before_Parameter_WIPBISQU;
86
87 PROCEDURE After_Parameter_WIPBISQU IS
88 BEGIN
89 NULL;
90 END After_Parameter_WIPBISQU;
91
92 PROCEDURE Build_Parameter_Form IS
93 BEGIN
94 NULL;
95 END Build_Parameter_Form;
96
97 PROCEDURE Parameter_ActionView_WIPBISQU(
98 P_ORG_LEVEL NUMBER,
99 P_ORGANIZATION_ID VARCHAR2,
100 P_ORGANIZATION_NAME VARCHAR2 default null,
101 P_SOB_NAME VARCHAR2 default null,
102 P_LE_NAME VARCHAR2 default null ,
103 P_OU_NAME VARCHAR2 default null,
104 P_TARGET VARCHAR2 default null,
105 P_GEO_LEVEL NUMBER,
106 P_GEOGRAPHY_CODE VARCHAR2 default null,
107 P_GEOGRAPHY_NAME VARCHAR2 default null,
108 P_ITEM_CODE VARCHAR2 default null,
109 P_ITEM VARCHAR2 default null,
110 P_VIEW_BY VARCHAR2,
111 P_FROM_DATE VARCHAR2 default null,
112 P_TO_DATE VARCHAR2 default null) AS
113 BEGIN
114 return;
115 END Parameter_ActionView_WIPBISQU;
116
117 PROCEDURE WIPBISQU_Parameter_PrintCat(
118 param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
119 i IN NUMBER) IS
120 BEGIN
121 return;
122 END WIPBISQU_Parameter_PrintCat;
123
124 PROCEDURE WIPBISQU_Parameter_PrintGeo(
125 param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
126 i IN NUMBER) IS
127 BEGIN
128 return;
129 END WIPBISQU_Parameter_PrintGeo;
130
131
132 PROCEDURE WIPBISQU_Parameter_PrintOrg(
133 param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
134 i IN NUMBER) IS
135 BEGIN
136 return;
137 END WIPBISQU_Parameter_PrintOrg;
138
139 PROCEDURE WIPBISQU_Parameter_PrintView(
140 param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
141 i IN NUMBER) IS
142 BEGIN
143 return;
144 END WIPBISQU_Parameter_PrintView;
145
146 PROCEDURE WIPBISQU_Parameter_PrintTrgt(
147 param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
148 i IN NUMBER) IS
149 BEGIN
150 return;
151 END WIPBISQU_Parameter_PrintTrgt;
152
153 PROCEDURE WIPBISQU_Parameter_PrintDate(param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
154 i IN NUMBER) IS
155 BEGIN
156 return;
157 END WIPBISQU_Parameter_PrintDate;
158
159 PROCEDURE Parameter_FormView_WIPBISQU IS
160 BEGIN
161 return;
162 END Parameter_FormView_WIPBISQU;
163
164 END WIP_PARAMETER_WIPBISQU;