1 PACKAGE MSC_X_NETTING3_PKG AUTHID CURRENT_USER AS
2 /* $Header: MSCXEX3S.pls 115.4 2003/11/12 01:30:48 yptang ship $ */
3
4
5 PROCEDURE COMPUTE_RESPONSE_REQUIRED(
6 a_company_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
7 a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,
8 a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
9 a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,
10 a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
11 a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
12 a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
13 a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
14 a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
15 a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
16 a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
17 a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
18 a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
19 a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
20 a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
21 a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
22 a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
23 a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
24 a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
25 a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
26 a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
27 a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
28 a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
29 a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
30 a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
31 a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
32 a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
33 a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
34 a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
35 a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
36 a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
37 a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
38 a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
39 a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
40 a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
41 a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
42 a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
43 a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
44 a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
45 a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
46 a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
47 a_date4 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
48 a_date5 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
49 a_exception_basis IN OUT NOCOPY msc_x_netting_pkg.exceptbasisList);
50
51 PROCEDURE Compute_Potential_Late_Order(p_refresh_number IN Number,
52 t_company_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
53 t_company_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
54 t_customer_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
55 t_customer_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
56 t_supplier_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
57 t_supplier_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
58 t_item_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
59 t_group_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
60 t_type_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
61 t_trxid1_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
62 t_trxid2_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
63 t_date1_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
64 t_date2_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
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 END MSC_X_NETTING3_PKG;
110