1 PACKAGE MSC_X_NETTING2_PKG AUTHID CURRENT_USER AS
2 /* $Header: MSCXEX2S.pls 115.4 2003/11/12 01:30:38 yptang ship $ */
3
4 PROCEDURE Compute_Material_Shortage(p_refresh_number IN Number,
5 t_company_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
6 t_company_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
7 t_customer_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
8 t_customer_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
9 t_supplier_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
10 t_supplier_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
11 t_item_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
12 t_group_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
13 t_type_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
14 t_trxid1_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
15 t_trxid2_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
16 t_date1_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
17 t_date2_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
18 a_company_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
19 a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,
20 a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
21 a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,
22 a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
23 a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
24 a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
25 a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
26 a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
27 a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
28 a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
29 a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
30 a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
31 a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
32 a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
33 a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
34 a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
35 a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
36 a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
37 a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
38 a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
39 a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
40 a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
41 a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
42 a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
43 a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
44 a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
45 a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
46 a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
47 a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
48 a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
49 a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
50 a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
51 a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
52 a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
53 a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
54 a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
55 a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
56 a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
57 a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
58 a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
59 a_date4 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
60 a_date5 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
61 a_exception_basis IN OUT NOCOPY msc_x_netting_pkg.exceptbasisList);
62
63
64 PROCEDURE Compute_Material_Excess(p_refresh_number IN Number,
65 t_company_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
66 t_company_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
67 t_customer_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
68 t_customer_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
69 t_supplier_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
70 t_supplier_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
71 t_item_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
72 t_group_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
73 t_type_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
74 t_trxid1_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
75 t_trxid2_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
76 t_date1_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
77 t_date2_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
78 a_company_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
79 a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,
80 a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
81 a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,
82 a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
83 a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
84 a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
85 a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
86 a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
87 a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
88 a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
89 a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
90 a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
91 a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
92 a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
93 a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
94 a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
95 a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
96 a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
97 a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
98 a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
99 a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
100 a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
101 a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
102 a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
103 a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
104 a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
105 a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
106 a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
107 a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
108 a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
109 a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
110 a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
111 a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
112 a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
113 a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
114 a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
115 a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
116 a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
117 a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
118 a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
119 a_date4 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
120 a_date5 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
121 a_exception_basis IN OUT NOCOPY msc_x_netting_pkg.exceptbasisList);
122
123
124 END MSC_X_NETTING2_PKG;
125