1 PACKAGE MSC_X_NETTING1_PKG AUTHID CURRENT_USER AS
2 /* $Header: MSCXEX1S.pls 115.4 2003/11/12 01:30:25 yptang ship $ */
3
4
5 PROCEDURE Compute_Late_Order(p_refresh_number IN Number,
6 t_company_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
7 t_company_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
8 t_customer_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
9 t_customer_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
10 t_supplier_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
11 t_supplier_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
12 t_item_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
13 t_group_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
14 t_type_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
15 t_trxid1_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
16 t_trxid2_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
17 t_date1_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
18 t_date2_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
19 a_company_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
20 a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,
21 a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
22 a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,
23 a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
24 a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
25 a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
26 a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
27 a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
28 a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
29 a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
30 a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
31 a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
32 a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
33 a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
34 a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
35 a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
36 a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
37 a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
38 a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
39 a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
40 a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
41 a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
42 a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
43 a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
44 a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
45 a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
46 a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
47 a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
48 a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
49 a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
50 a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
51 a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
52 a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
53 a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
54 a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
55 a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
56 a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
57 a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
58 a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
59 a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
60 a_date4 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
61 a_date5 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
62 a_exception_basis IN OUT NOCOPY msc_x_netting_pkg.exceptbasisList);
63
64
65 PROCEDURE Compute_Early_Order(p_refresh_number IN Number,
66 t_company_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
67 t_company_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
68 t_customer_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
69 t_customer_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
70 t_supplier_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
71 t_supplier_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
72 t_item_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
73 t_group_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
74 t_type_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
75 t_trxid1_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
76 t_trxid2_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
77 t_date1_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
78 t_date2_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
79 a_company_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
80 a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,
81 a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
82 a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,
83 a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
84 a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
85 a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
86 a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
87 a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
88 a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
89 a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
90 a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
91 a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
92 a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
93 a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
94 a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
95 a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
96 a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
97 a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
98 a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
99 a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
100 a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
101 a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
102 a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
103 a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
104 a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
105 a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
106 a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
107 a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
108 a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
109 a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
110 a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
111 a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
112 a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
113 a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
114 a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
115 a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
116 a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
117 a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
118 a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
119 a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
120 a_date4 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
121 a_date5 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
122 a_exception_basis IN OUT NOCOPY msc_x_netting_pkg.exceptbasisList);
123
124 PROCEDURE Compute_Forecast_Mismatch (p_refresh_number In Number,
125 t_company_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
126 t_company_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
127 t_customer_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
128 t_customer_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
129 t_supplier_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
130 t_supplier_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
131 t_item_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
132 t_group_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
133 t_type_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
134 t_trxid1_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
135 t_trxid2_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
136 t_date1_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
137 t_date2_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
138 a_company_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
139 a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,
140 a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
141 a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,
142 a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
146 a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
143 a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
144 a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
145 a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
147 a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
148 a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
149 a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
150 a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
151 a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
152 a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
153 a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
154 a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
155 a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
156 a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
157 a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
158 a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
159 a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
160 a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
161 a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
162 a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
163 a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
164 a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
165 a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
166 a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
167 a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
168 a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
169 a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
170 a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
171 a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
172 a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
173 a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
174 a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
175 a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
176 a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
177 a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
178 a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
179 a_date4 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
180 a_date5 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
181 a_exception_basis IN OUT NOCOPY msc_x_netting_pkg.exceptbasisList);
182
183
184
185
186 END MSC_X_NETTING1_PKG;
187