1 PACKAGE WIP_PARAMETER_WIPBIUTZ AUTHID CURRENT_USER AS
2 /* $Header: wipbiups.pls 115.10 2002/11/28 12:09:22 rmahidha ship $ */
3
4 PROCEDURE error(P_FIELD IN VARCHAR2);
5
6 FUNCTION Validate_Org(P_ORG_LEVEL IN VARCHAR2,
7 P_ORGANIZATION_ID IN OUT NOCOPY VARCHAR2,
8 P_ORGANIZATION_NAME IN VARCHAR2 default null) RETURN BOOLEAN;
9
10 FUNCTION Validate_Geo(P_GEOGRAPHY_CODE IN OUT NOCOPY VARCHAR2,
11 P_GEOGRAPHY_NAME IN VARCHAR2 default null,
12 P_GEO_LEVEL IN OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
13
14 FUNCTION Validate_Cat(P_ITEM_CODE IN OUT NOCOPY VARCHAR2,
15 P_ITEM IN VARCHAR2 default null,
16 P_PROD_LEVEL IN OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
17
18 FUNCTION Validate_Date(P_FROM_DATE IN OUT NOCOPY VARCHAR2,
19 P_TO_DATE IN OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
20
21 FUNCTION Validate_Parameters(
22 P_ORG_LEVEL VARCHAR2,
23 P_ORGANIZATION_ID IN OUT NOCOPY VARCHAR2,
24 P_ORGANIZATION_NAME VARCHAR2 default null,
25 P_GEO_LEVEL IN OUT NOCOPY VARCHAR2,
26 P_GEOGRAPHY_CODE IN OUT NOCOPY VARCHAR2,
27 P_GEOGRAPHY_NAME VARCHAR2 default null,
28 P_PROD_LEVEL IN OUT NOCOPY VARCHAR2,
29 P_ITEM_CODE IN OUT NOCOPY VARCHAR2,
30 P_ITEM VARCHAR2 default null,
31 P_FROM_DATE IN OUT NOCOPY VARCHAR2,
32 P_TO_DATE IN OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
33
34 PROCEDURE Init_For_Standard(p_view_by VARCHAR2,
35 p_org_level VARCHAR2,
36 l_org_temp_id VARCHAR2,
37 l_prod_level VARCHAR2,
38 l_prod_code VARCHAR2,
39 l_geo_level VARCHAR2,
40 l_area_code VARCHAR2,
41 l_view_by OUT NOCOPY VARCHAR2,
42 l_org_level OUT NOCOPY VARCHAR2,
43 l_sob_id OUT NOCOPY VARCHAR2,
44 l_le_id OUT NOCOPY VARCHAR2,
45 l_ou_id OUT NOCOPY VARCHAR2,
46 l_org_id OUT NOCOPY VARCHAR2,
47 l_pg_id OUT NOCOPY VARCHAR2,
48 l_area_id OUT NOCOPY VARCHAR2);
49
50 PROCEDURE RunReport;
51 PROCEDURE Build_Parameter_Form;
52 PROCEDURE Build_Java_Script(outstring IN OUT NOCOPY VARCHAR2);
53 PROCEDURE WIPBIUTZ_Parameter_PrintOrg(
54 param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
55 i IN NUMBER, l_org_level VARCHAR2, l_sob_id VARCHAR2,
56 l_le_id VARCHAR2, l_ou_id VARCHAR2, l_org_id VARCHAR2);
57 PROCEDURE WIPBIUTZ_Parameter_PrintGeo(
58 param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
59 i IN NUMBER, l_area_id VARCHAR2);
60 PROCEDURE WIPBIUTZ_Parameter_PrintCat(
61 param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
62 i IN NUMBER, l_pg_id VARCHAR2);
63 PROCEDURE WIPBIUTZ_Parameter_PrintTrgt(
64 param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
65 i IN NUMBER, l_plan_id VARCHAR2);
66 PROCEDURE WIPBIUTZ_Parameter_PrintDate(
67 param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
68 i IN NUMBER, l_date_from VARCHAR2, l_date_to VARCHAR2,
69 need_params_for_date BOOLEAN);
70 PROCEDURE WIPBIUTZ_Parameter_PrintViewby(
71 param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
72 i IN NUMBER, l_view_by VARCHAR2);
73
74 PROCEDURE Before_Parameter_WIPBIUTZ;
75 PROCEDURE After_Parameter_WIPBIUTZ;
76 PROCEDURE parameter_formview_wipbiutz(force_display IN VARCHAR2 DEFAULT NULL);
77 PROCEDURE Parameter_ActionView_WIPBIUTZ(
78 P_ORG_LEVEL VARCHAR2,
79 P_ORGANIZATION_ID VARCHAR2 default null,
80 P_ORGANIZATION_NAME VARCHAR2 default null,
81 P_SOB_NAME VARCHAR2 default null,
82 P_LE_NAME VARCHAR2 default null,
83 P_OU_NAME VARCHAR2 default null,
84 P_GEOGRAPHY_CODE VARCHAR2 default null,
85 P_GEOGRAPHY_NAME VARCHAR2 default null,
86 P_ITEM_CODE VARCHAR2 default null,
87 P_ITEM VARCHAR2 default null,
88 P_FROM_DATE VARCHAR2,
89 P_TO_DATE VARCHAR2,
90 P_TARGET VARCHAR2,
91 P_VIEW_BY VARCHAR2);
92
93 PROCEDURE get_saved_params(l_plan_id OUT NOCOPY VARCHAR2,
94 l_org_level OUT NOCOPY VARCHAR2,
95 l_sob_id OUT NOCOPY VARCHAR2,
96 l_le_id OUT NOCOPY VARCHAR2,
97 l_ou_id OUT NOCOPY VARCHAR2,
98 l_org_id OUT NOCOPY VARCHAR2,
99 l_dept_id OUT NOCOPY VARCHAR2,
100 l_res_id OUT NOCOPY VARCHAR2,
101 l_geo_level OUT NOCOPY VARCHAR2,
102 l_area_id OUT NOCOPY VARCHAR2,
103 l_country_id OUT NOCOPY VARCHAR2,
104 l_region_id OUT NOCOPY VARCHAR2,
105 l_prod_level OUT NOCOPY VARCHAR2,
106 l_pg_id OUT NOCOPY VARCHAR2,
107 l_item_id OUT NOCOPY VARCHAR2,
108 l_date_from OUT NOCOPY VARCHAR2,
109 l_date_to OUT NOCOPY VARCHAR2,
110 l_view_by OUT NOCOPY VARCHAR2,
111 need_params_for_org OUT NOCOPY BOOLEAN,
112 need_params_for_geo OUT NOCOPY BOOLEAN,
113 need_params_for_prod OUT NOCOPY BOOLEAN,
114 need_params_for_date OUT NOCOPY BOOLEAN,
115 need_params_for_trgt OUT NOCOPY BOOLEAN,
116 need_params_for_view OUT NOCOPY BOOLEAN);
117
118 PROCEDURE run_report_wo_page(l_plan_id IN OUT NOCOPY VARCHAR2,
119 l_org_level IN OUT NOCOPY VARCHAR2,
120 l_sob_id IN OUT NOCOPY VARCHAR2,
121 l_le_id IN OUT NOCOPY VARCHAR2,
122 l_ou_id IN OUT NOCOPY VARCHAR2,
123 l_org_id IN OUT NOCOPY VARCHAR2,
124 l_dept_id IN OUT NOCOPY VARCHAR2,
125 l_res_id IN OUT NOCOPY VARCHAR2,
126 l_geo_level IN OUT NOCOPY VARCHAR2,
127 l_area_id IN OUT NOCOPY VARCHAR2,
128 l_country_id IN OUT NOCOPY VARCHAR2,
129 l_region_id IN OUT NOCOPY VARCHAR2,
130 l_prod_level IN OUT NOCOPY VARCHAR2,
131 l_pg_id IN OUT NOCOPY VARCHAR2,
132 l_item_id IN OUT NOCOPY VARCHAR2,
133 l_date_from IN OUT NOCOPY VARCHAR2,
134 l_date_to IN OUT NOCOPY VARCHAR2,
135 l_view_by IN OUT NOCOPY VARCHAR2);
136
137 END WIP_PARAMETER_WIPBIUTZ;