[Home] [Help]
PACKAGE: APPS.WIP_PARAMETER_WIPBISQU
Source
1 PACKAGE WIP_PARAMETER_WIPBISQU AUTHID CURRENT_USER AS
2 /* $Header: wipbisqs.pls 115.7 2002/11/28 11:56:37 rmahidha ship $ */
3
4 PROCEDURE error(P_FIELD IN VARCHAR2, P_ERROR_NO IN NUMBER);
5
6 FUNCTION Validate_Org(P_ORG_LEVEL IN OUT NOCOPY VARCHAR2,
7 P_ORGANIZATION_ID IN OUT NOCOPY VARCHAR2,
8 P_ORGANIZATION_NAME IN VARCHAR2 default null,
9 P_SET_OF_BOOKS IN OUT NOCOPY VARCHAR2,
10 P_LEGAL_ENTITY IN OUT NOCOPY VARCHAR2,
11 P_OPERATING_UNIT IN OUT NOCOPY VARCHAR2,
12 P_INV_ORGANIZATION IN OUT NOCOPY VARCHAR2
13 ) RETURN BOOLEAN;
14
15 FUNCTION Validate_Geo(P_GEOGRAPHY_CODE IN OUT NOCOPY VARCHAR2,
16 P_GEOGRAPHY_NAME IN VARCHAR2 default null,
17 P_GEO_LEVEL IN OUT NOCOPY VARCHAR2,
18 P_AREA IN OUT NOCOPY VARCHAR2,
19 P_COUNTRY IN OUT NOCOPY VARCHAR2,
20 P_REGION IN OUT NOCOPY VARCHAR2
21 ) RETURN BOOLEAN;
22
23 FUNCTION Validate_Cat(P_ITEM_CODE IN OUT NOCOPY VARCHAR2,
24 P_ITEM IN VARCHAR2 default null,
25 P_PROD_LEVEL IN OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
26
27 FUNCTION Validate_Date(P_FROM_DATE IN OUT NOCOPY VARCHAR2,
28 P_TO_DATE IN OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
29
30 FUNCTION Validate_Parameters(
31 P_ORG_LEVEL IN OUT NOCOPY VARCHAR2,
32 P_ORGANIZATION_ID IN OUT NOCOPY VARCHAR2,
33 P_ORGANIZATION_NAME VARCHAR2 default null,
34 P_SET_OF_BOOKS IN OUT NOCOPY VARCHAR2,
35 P_LEGAL_ENTITY IN OUT NOCOPY VARCHAR2,
36 P_OPERATING_UNIT IN OUT NOCOPY VARCHAR2,
37 P_INV_ORGANIZATION IN OUT NOCOPY VARCHAR2,
38 P_GEO_LEVEL IN OUT NOCOPY VARCHAR2,
39 P_GEOGRAPHY_CODE IN OUT NOCOPY VARCHAR2,
40 P_GEOGRAPHY_NAME VARCHAR2 default null,
41 P_AREA IN OUT NOCOPY VARCHAR2,
42 P_COUNTRY IN OUT NOCOPY VARCHAR2,
43 P_REGION IN OUT NOCOPY VARCHAR2,
44 P_PROD_LEVEL IN OUT NOCOPY VARCHAR2,
45 P_ITEM_CODE IN OUT NOCOPY VARCHAR2,
46 P_ITEM VARCHAR2 default null,
47 P_FROM_DATE IN OUT NOCOPY VARCHAR2,
48 P_TO_DATE IN OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
49 PROCEDURE RunReport;
50 PROCEDURE Build_Parameter_Form;
51 PROCEDURE Build_Java_Script(outstring IN OUT NOCOPY VARCHAR2);
52 PROCEDURE WIPBISQU_Parameter_PrintOrg(
53 param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
54 i IN NUMBER);
55 PROCEDURE WIPBISQU_Parameter_PrintGeo(
56 param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
57 i IN NUMBER);
58 PROCEDURE WIPBISQU_Parameter_PrintCat(
59 param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
60 i IN NUMBER);
61 PROCEDURE WIPBISQU_Parameter_PrintTrgt(
62 param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
63 i IN NUMBER);
64 PROCEDURE WIPBISQU_Parameter_PrintDate(
65 param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
66 i IN NUMBER);
67 PROCEDURE WIPBISQU_Parameter_PrintView(
68 param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
69 i IN NUMBER);
70
71 PROCEDURE Before_Parameter_WIPBISQU;
72 PROCEDURE After_Parameter_WIPBISQU;
73 PROCEDURE Parameter_FormView_WIPBISQU;
74
75 PROCEDURE Parameter_ActionView_WIPBISQU(
76 P_ORG_LEVEL NUMBER,
77 P_ORGANIZATION_ID VARCHAR2,
78 P_ORGANIZATION_NAME VARCHAR2 default null,
79 P_SOB_NAME VARCHAR2 default null,
80 P_LE_NAME VARCHAR2 default null,
81 P_OU_NAME VARCHAR2 default null,
82 P_TARGET VARCHAR2 default null,
83 P_GEO_LEVEL NUMBER,
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_VIEW_BY VARCHAR2,
89 P_FROM_DATE VARCHAR2 default null,
90 P_TO_DATE VARCHAR2 default null);
91 --PROCEDURE Parameter_ActionView_WIPBISQU(
92 -- P_ORG_LEVEL VARCHAR2,
93 -- P_ORGANIZATION_ID VARCHAR2,
94 -- P_ORGANIZATION_NAME VARCHAR2 default null,
95 -- P_SOB_NAME VARCHAR2 default null,
96 -- P_LE_NAME VARCHAR2 default null,
97 -- P_OU_NAME VARCHAR2 default null,
98 -- P_GEOGRAPHY_CODE VARCHAR2,
99 -- P_GEOGRAPHY_NAME VARCHAR2 default null,
100 -- P_ITEM_CODE VARCHAR2,
101 -- P_ITEM VARCHAR2 default null,
102 -- P_FROM_DATE VARCHAR2,
103 -- P_TO_DATE VARCHAR2,
104 -- P_TARGET VARCHAR2,
105 -- P_VIEW_BY VARCHAR2);
106
107 END WIP_PARAMETER_WIPBISQU;