1 PACKAGE POA_REPORT_UTIL AUTHID CURRENT_USER AS
2 /* $Header: poarutls.pls 115.6 2002/12/28 00:54:54 iali ship $ */
3
4 TYPE SOB_Rec_Type IS RECORD (
5 SOB_ID NUMBER := NULL
6 );
7
8 TYPE SOB_Tbl_Type IS TABLE of SOB_Rec_Type
9 INDEX BY BINARY_INTEGER;
10
11 PROCEDURE Build_OrderDates(
12 p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
13 p_index IN NUMBER);
14
15 PROCEDURE Build_CTL_ViewBy(
16 p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
17 p_index IN NUMBER);
18
19 PROCEDURE Build_LSS_ViewBy(
20 p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
21 p_index IN NUMBER);
22
23 PROCEDURE Build_SPA_ViewBy(
24 p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
25 p_index IN NUMBER);
26
27 PROCEDURE Build_ReportingDates(
28 p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
29 p_index IN NUMBER);
30
31 PROCEDURE Build_SupplierItem(
32 p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
33 p_index IN NUMBER);
34
35 PROCEDURE Build_PrefSupplier(
36 p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
37 p_index IN NUMBER);
38
39 PROCEDURE Build_ConsSupplier(
40 p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
41 p_index IN NUMBER);
42
43 PROCEDURE Build_QualityCost(
44 p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
45 p_index IN NUMBER);
46
47 PROCEDURE Build_DeliveryCost(
48 p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
49 p_index IN NUMBER);
50
51 PROCEDURE Build_HiddenStartDate(p_start_date IN VARCHAR2,
52 p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
53 p_index IN NUMBER);
54
55 PROCEDURE Build_HiddenEndDate(p_end_date IN VARCHAR2,
56 p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
57 p_index IN NUMBER);
58
59 PROCEDURE Build_HiddenCurrency(p_currency_code IN VARCHAR2,
60 p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
61 p_index IN NUMBER);
62
63 PROCEDURE Build_HiddenItem(p_item_id IN VARCHAR2,
64 p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
65 p_index IN NUMBER);
66
67 PROCEDURE Build_SupplierNum(
68 p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
69 p_index IN NUMBER);
70
71 PROCEDURE Build_SupplierOrderBy(
72 p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
73 p_index IN NUMBER);
74
75
76 PROCEDURE Build_SavingsOperatingUnit(
77 p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
78 p_index IN NUMBER);
79
80 PROCEDURE Build_PPS_OperatingUnit(
81 p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
82 p_index IN NUMBER);
83
84
85 PROCEDURE Build_SavingsBuyer(
86 p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
87 p_index IN NUMBER);
88
89 PROCEDURE Build_SavingsCommodity(
90 p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
91 p_index IN NUMBER);
92
93 PROCEDURE Build_SavingsItem(
94 p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
95 p_index IN NUMBER);
96
97 PROCEDURE Build_SavingsSupplier(
98 p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
99 p_index IN NUMBER);
100
101 PROCEDURE Build_KPIPeriodType(
102 p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
103 p_index IN NUMBER);
104
105 PROCEDURE Build_KPI_2PeriodType(
106 p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
107 p_index IN NUMBER);
108
109 PROCEDURE Build_SavingsShipToOrg(
110 p_param IN OUT NOCOPY BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type,
111 p_index IN NUMBER);
112
113 PROCEDURE Build_Selection(p_name IN VARCHAR2,
114 p_select IN VARCHAR2, p_output IN OUT NOCOPY VARCHAR2);
115
116 PROCEDURE Build_ErrorPage(
117 p_param IN BIS_UTILITIES_PUB.Report_Parameter_Tbl_Type);
118
119 FUNCTION Validate_OrderDates(p_fdate IN OUT NOCOPY VARCHAR2,
120 p_tdate IN OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
121
122 FUNCTION Validate_SupplierNum(p_num_of_suppliers IN OUT NOCOPY NUMBER)
123 RETURN BOOLEAN;
124
125 FUNCTION Validate_QualityCost(p_quality_cost IN OUT NOCOPY NUMBER)
126 RETURN BOOLEAN;
127
128 FUNCTION Validate_DeliveryCost(p_delivery_cost IN OUT NOCOPY NUMBER)
129 RETURN BOOLEAN;
130
131 FUNCTION Validate_SupplierItem(p_item_name IN VARCHAR2,
132 p_item_id OUT NOCOPY NUMBER) RETURN BOOLEAN;
133
134 FUNCTION Validate_PrefSupplier(p_pref_supp_name IN VARCHAR2,
135 p_pref_supp_id OUT NOCOPY NUMBER) RETURN BOOLEAN;
136
137 FUNCTION Validate_ConsSupplier(p_cons_supp_name IN VARCHAR2,
138 p_cons_supp_id OUT NOCOPY NUMBER) RETURN BOOLEAN;
139
140 FUNCTION Validate_SavingsBuyer(p_buyer_name IN VARCHAR2,
141 p_buyer_id OUT NOCOPY NUMBER) RETURN BOOLEAN;
142
143 FUNCTION Validate_SavingsSupplier(p_supplier_name IN VARCHAR2,
144 p_supplier_id OUT NOCOPY NUMBER) RETURN BOOLEAN;
145
146 FUNCTION Validate_SavingsShipToOrg(p_org_name IN VARCHAR2,
147 p_org_id OUT NOCOPY NUMBER) RETURN BOOLEAN;
148
149 FUNCTION Validate_SavingsOperatingUnit(p_oper_unit_name IN VARCHAR2,
150 p_oper_unit_id OUT NOCOPY NUMBER) RETURN BOOLEAN;
151
152 FUNCTION Validate_PPS_OperatingUnit(p_oper_unit_name IN VARCHAR2,
153 p_oper_unit_id OUT NOCOPY NUMBER) RETURN BOOLEAN;
154
155 FUNCTION Validate_SavingsCommodity(p_commodity_name IN VARCHAR2,
156 p_commodity_id OUT NOCOPY NUMBER) RETURN BOOLEAN;
157
158 PROCEDURE Retrieve_Org_Where_Clause(p_user_id IN NUMBER := NULL,
159 p_user_name IN VARCHAR2 := NULL,
160 x_where_clause OUT NOCOPY VARCHAR2,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type);
163
164 PROCEDURE Retrieve_Set_of_Books_Id(
165 x_Responsibility_tbl IN BIS_RESPONSIBILITY_PVT.Responsibility_Tbl_Type,
166 x_SOB_tbl OUT NOCOPY POA_REPORT_UTIL.SOB_Tbl_Type,
167 x_return_status OUT NOCOPY VARCHAR2);
168
169
170 END POA_REPORT_UTIL;