1 PACKAGE MSC_X_NETTING4_PKG AS
2 /* $Header: MSCXEX4S.pls 120.0.12000000.1 2007/01/16 22:38:43 appldev ship $ */
3
4
5 PROCEDURE Compute_Changed_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 PROCEDURE Compute_Forecast_Accuracy(
65 a_company_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
66 a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,
67 a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
68 a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,
69 a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
70 a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
71 a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
72 a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
73 a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
74 a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
75 a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
76 a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
77 a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
78 a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
79 a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
80 a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
81 a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
82 a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
83 a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
84 a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
85 a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
86 a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
87 a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
88 a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
89 a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
90 a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
91 a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
92 a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
93 a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
94 a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
95 a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
96 a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
97 a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
98 a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
99 a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
100 a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
101 a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
102 a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
103 a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
104 a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
105 a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
106 a_date4 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
107 a_date5 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
108 a_exception_basis IN OUT NOCOPY msc_x_netting_pkg.exceptbasisList);
109
110 PROCEDURE Compute_Performance(
111 a_company_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
112 a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,
113 a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
114 a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,
115 a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
116 a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
117 a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
118 a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
119 a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
120 a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
121 a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
122 a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
123 a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
124 a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
125 a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
126 a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
127 a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
128 a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
129 a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
130 a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
131 a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
132 a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
133 a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
134 a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
135 a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
136 a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
137 a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
138 a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
139 a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
140 a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
141 a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
142 a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
143 a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
144 a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
145 a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
146 a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
147 a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
148 a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
149 a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
150 a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
151 a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
152 a_date4 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
153 a_date5 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
154 a_exception_basis IN OUT NOCOPY msc_x_netting_pkg.exceptbasisList);
155
156 PROCEDURE Compute_Custom_Exception;
157
158 END MSC_X_NETTING4_PKG;
159
[Home] [Help]