35: sd.supplier_site_name,
36: sd.supplier_item_name,
37: sd.supplier_item_description,
38: sd.creation_date,
39: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP11,
40: sd.supplier_id,
41: sd.supplier_site_id,
42: sd.inventory_item_id,
43: null,
44: null,
45: sd.publisher_id,
46: sd.publisher_site_id,
47: sd.key_date),
48: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP31,
49: sd.publisher_id,
50: sd.publisher_site_id,
51: sd.inventory_item_id,
52: sd.supplier_id,
54: null,
55: null,
56: sd.key_date)
57: FROM msc_sup_dem_entries sd
58: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
59: AND sd.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
60: AND msc_x_netting_pkg.does_so_exist(sd.order_number,
61: sd.release_number,
62: sd.line_number,
55: null,
56: sd.key_date)
57: FROM msc_sup_dem_entries sd
58: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
59: AND sd.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
60: AND msc_x_netting_pkg.does_so_exist(sd.order_number,
61: sd.release_number,
62: sd.line_number,
63: sd.supplier_id,
56: sd.key_date)
57: FROM msc_sup_dem_entries sd
58: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
59: AND sd.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
60: AND msc_x_netting_pkg.does_so_exist(sd.order_number,
61: sd.release_number,
62: sd.line_number,
63: sd.supplier_id,
64: sd.supplier_site_id,
105: sd.customer_site_name,
106: sd.customer_item_name,
107: sd.customer_item_description,
108: sd.creation_date ,
109: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP12,
110: sd.publisher_id,
111: sd.publisher_site_id,
112: sd.inventory_item_id,
113: null,
114: null,
115: sd.customer_id,
116: sd.customer_site_id,
117: sd.key_date),
118: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP32,
119: sd.customer_id,
120: sd.customer_site_id,
121: sd.inventory_item_id,
122: sd.publisher_id,
124: null,
125: null,
126: sd.key_date)
127: FROM msc_sup_dem_entries sd
128: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
129: AND sd.publisher_order_type = msc_x_netting_pkg.SALES_ORDER
130: AND msc_x_netting_pkg.does_po_exist(sd.end_order_number,
131: sd.end_order_rel_number,
132: sd.end_order_line_number,
125: null,
126: sd.key_date)
127: FROM msc_sup_dem_entries sd
128: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
129: AND sd.publisher_order_type = msc_x_netting_pkg.SALES_ORDER
130: AND msc_x_netting_pkg.does_po_exist(sd.end_order_number,
131: sd.end_order_rel_number,
132: sd.end_order_line_number,
133: sd.customer_id,
126: sd.key_date)
127: FROM msc_sup_dem_entries sd
128: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
129: AND sd.publisher_order_type = msc_x_netting_pkg.SALES_ORDER
130: AND msc_x_netting_pkg.does_po_exist(sd.end_order_number,
131: sd.end_order_rel_number,
132: sd.end_order_line_number,
133: sd.customer_id,
134: sd.customer_site_id,
168: sd.supplier_item_name,
169: sd.supplier_item_description,
170: sd.creation_date
171: FROM msc_sup_dem_entries sd
172: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
173: AND sd.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
174: AND sd.last_refresh_number > p_refresh_number;
175:
176: /* Cursor level_1_supp_po fetches the first level of
169: sd.supplier_item_description,
170: sd.creation_date
171: FROM msc_sup_dem_entries sd
172: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
173: AND sd.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
174: AND sd.last_refresh_number > p_refresh_number;
175:
176: /* Cursor level_1_supp_po fetches the first level of
177: supplier's PO that have been created
189: p_item_id IN Number) IS
190: SELECT distinct sd2.transaction_id --po trx-id
191: FROM msc_sup_dem_entries sd1,
192: msc_sup_dem_entries sd2
193: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
194: AND sd1.plan_id = sd2.plan_id
195: AND sd1.publisher_order_type = msc_x_netting_pkg.SALES_ORDER --SO
196: AND sd1.publisher_id = p_supplier_id
197: AND sd1.publisher_site_id = p_supplier_site_id
191: FROM msc_sup_dem_entries sd1,
192: msc_sup_dem_entries sd2
193: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
194: AND sd1.plan_id = sd2.plan_id
195: AND sd1.publisher_order_type = msc_x_netting_pkg.SALES_ORDER --SO
196: AND sd1.publisher_id = p_supplier_id
197: AND sd1.publisher_site_id = p_supplier_site_id
198: AND sd1.inventory_item_id = p_item_id
199: AND sd1.inventory_item_id = sd2.inventory_item_id
201: AND nvl(sd1.end_order_rel_number, -1) =
202: nvl(p_release_number, -1)
203: AND nvl(sd1.end_order_line_number, -1) =
204: nvl(p_line_number, -1)
205: AND sd2.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER --PO
206: AND nvl(sd1.order_number, -1) =
207: nvl(sd2.end_order_number, -1)
208: AND nvl(sd1.release_number, -1) =
209: nvl(sd2.end_order_rel_number, -1)
277: sd2.order_number,
278: sd2.release_number,
279: sd2.line_number,
280: sd2.creation_date,
281: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP13,
282: sd1.publisher_id,
283: sd1.publisher_site_id,
284: sd1.inventory_item_id,
285: sd1.supplier_id,
288: null,
289: sd1.key_date)
290: FROM msc_sup_dem_entries sd1,
291: msc_sup_dem_entries sd2
292: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
293: AND sd1.plan_id = sd2.plan_id
294: AND sd1.inventory_item_id = p_item_id
295: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
296: AND sd1.transaction_id = p_transaction_id -- po trxid
291: msc_sup_dem_entries sd2
292: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
293: AND sd1.plan_id = sd2.plan_id
294: AND sd1.inventory_item_id = p_item_id
295: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
296: AND sd1.transaction_id = p_transaction_id -- po trxid
297: AND sd1.publisher_id = sd2.customer_id
298: AND sd1.publisher_id = p_company_id
299: AND sd1.publisher_site_id = sd2.customer_site_id
297: AND sd1.publisher_id = sd2.customer_id
298: AND sd1.publisher_id = p_company_id
299: AND sd1.publisher_site_id = sd2.customer_site_id
300: AND sd1.publisher_site_id = p_company_site_id
301: AND sd2.publisher_order_type = msc_x_netting_pkg.SALES_ORDER
302: AND sd2.inventory_item_id = sd1.inventory_item_id
303: AND sd1.order_number = sd2.end_order_number
304: AND nvl(sd1.release_number,-1) =
305: nvl(sd2.end_order_rel_number,-1)
305: nvl(sd2.end_order_rel_number,-1)
306: AND nvl(sd1.line_number,-1) =
307: nvl(sd2.end_order_line_number,-1)
308: AND trunc(sd2.key_date) > trunc(sd1.key_date) +
309: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP13,
310: sd1.publisher_id,
311: sd1.publisher_site_id,
312: sd1.inventory_item_id,
313: sd1.supplier_id,
361: sd1.release_number,
362: sd1.line_number
363: FROM msc_sup_dem_entries sd1,
364: msc_sup_dem_entries sd2
365: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
366: AND sd1.plan_id = sd2.plan_id
367: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
368: AND sd1.publisher_id = sd2.customer_id
369: AND sd1.publisher_site_id = sd2.customer_site_id
363: FROM msc_sup_dem_entries sd1,
364: msc_sup_dem_entries sd2
365: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
366: AND sd1.plan_id = sd2.plan_id
367: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
368: AND sd1.publisher_id = sd2.customer_id
369: AND sd1.publisher_site_id = sd2.customer_site_id
370: AND sd2.publisher_order_type = msc_x_netting_pkg.SALES_ORDER
371: AND sd2.inventory_item_id = sd1.inventory_item_id
366: AND sd1.plan_id = sd2.plan_id
367: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
368: AND sd1.publisher_id = sd2.customer_id
369: AND sd1.publisher_site_id = sd2.customer_site_id
370: AND sd2.publisher_order_type = msc_x_netting_pkg.SALES_ORDER
371: AND sd2.inventory_item_id = sd1.inventory_item_id
372: AND sd1.order_number = sd2.end_order_number
373: AND nvl(sd1.release_number,-1) =
374: nvl(sd2.end_order_rel_number,-1)
416: sd1.customer_site_name,
417: sd1.customer_item_name,
418: sd1.customer_item_description
419: FROM msc_sup_dem_entries sd1
420: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
421: AND sd1.inventory_item_id = P_ITEM_ID
422: AND sd1.publisher_id = p_customer_id /* sbala P_SUPPLIER_ID */
423: AND sd1.publisher_site_id = p_customer_site_id /* sbala P_SUPPLIER_SITE_ID */
424: AND sd1.publisher_order_type = msc_x_netting_pkg.SALES_ORDER
420: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
421: AND sd1.inventory_item_id = P_ITEM_ID
422: AND sd1.publisher_id = p_customer_id /* sbala P_SUPPLIER_ID */
423: AND sd1.publisher_site_id = p_customer_site_id /* sbala P_SUPPLIER_SITE_ID */
424: AND sd1.publisher_order_type = msc_x_netting_pkg.SALES_ORDER
425: /* sbala msc_x_netting_pkg.PURCHASE_ORDER */
426: AND sd1.order_number = P_ORDER_NUMBER
427: AND nvl(sd1.release_number,'-1') = nvl(P_RELEASE_NUMBER,'-1')
428: AND nvl(sd1.line_number, '-1') = nvl(P_LINE_NUMBER,'-1');
421: AND sd1.inventory_item_id = P_ITEM_ID
422: AND sd1.publisher_id = p_customer_id /* sbala P_SUPPLIER_ID */
423: AND sd1.publisher_site_id = p_customer_site_id /* sbala P_SUPPLIER_SITE_ID */
424: AND sd1.publisher_order_type = msc_x_netting_pkg.SALES_ORDER
425: /* sbala msc_x_netting_pkg.PURCHASE_ORDER */
426: AND sd1.order_number = P_ORDER_NUMBER
427: AND nvl(sd1.release_number,'-1') = nvl(P_RELEASE_NUMBER,'-1')
428: AND nvl(sd1.line_number, '-1') = nvl(P_LINE_NUMBER,'-1');
429:
493: supplier_id, supplier_site_id, inventory_item_id,
494: transaction_id1, transaction_id2
495: FROM msc_x_exception_details
496: WHERE plan_id = -1
497: AND exception_type in (msc_x_netting_pkg.G_EXCEP50,msc_x_netting_pkg.G_EXCEP51)
498: AND transaction_id2 = p_transaction_id;
499:
500: --------------------------------------------------------------
501: --Need to clean up the existing exceptions before regenerate
515: msc_item_suppliers itm,
516: msc_trading_partner_maps map2,
517: msc_trading_partner_maps map3,
518: msc_company_relationships r
519: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
520: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER --
521: AND map.map_type = 2
522: AND map.company_key = sd1.publisher_site_id
523: AND map.tp_key = tp.partner_id
516: msc_trading_partner_maps map2,
517: msc_trading_partner_maps map3,
518: msc_company_relationships r
519: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
520: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER --
521: AND map.map_type = 2
522: AND map.company_key = sd1.publisher_site_id
523: AND map.tp_key = tp.partner_id
524: AND itm.plan_id = sd1.plan_id
580: msc_item_suppliers itm,
581: msc_trading_partner_maps map2,
582: msc_trading_partner_maps map3,
583: msc_company_relationships r
584: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
585: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER --
586: AND map.map_type = 2
587: AND map.company_key = sd1.publisher_site_id
588: AND map.tp_key = tp.partner_id
581: msc_trading_partner_maps map2,
582: msc_trading_partner_maps map3,
583: msc_company_relationships r
584: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
585: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER --
586: AND map.map_type = 2
587: AND map.company_key = sd1.publisher_site_id
588: AND map.tp_key = tp.partner_id
589: AND itm.plan_id = sd1.plan_id
644: msc_item_suppliers itm,
645: msc_trading_partner_maps map2,
646: msc_trading_partner_maps map3,
647: msc_company_relationships r
648: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
649: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER --
650: AND map.map_type = 2
651: AND map.company_key = sd1.publisher_site_id
652: AND map.tp_key = tp.partner_id
645: msc_trading_partner_maps map2,
646: msc_trading_partner_maps map3,
647: msc_company_relationships r
648: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
649: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER --
650: AND map.map_type = 2
651: AND map.company_key = sd1.publisher_site_id
652: AND map.tp_key = tp.partner_id
653: AND itm.plan_id = sd1.plan_id
664: AND map3.map_type = 3
665: AND map3.company_key = sd1.supplier_site_id
666: AND itm.inventory_item_id = sd1.inventory_item_id
667: AND not exists (SELECT * FROM msc_x_exception_details d
668: WHERE d.exception_type = msc_x_netting_pkg.G_EXCEP3
669: AND d.transaction_id1 = sd1.transaction_id)
670: AND nvl(sd1.last_refresh_number,-1) > nvl(p_refresh_number,-1)
671: ORDER BY sd1.publisher_id, sd1.publisher_site_id, sd1.supplier_id, sd1.supplier_site_id, sd1.inventory_item_id;
672: --------------------------------------------------------------------------------------
703: sd1.customer_item_name,
704: sd1.customer_item_description,
705: sd1.creation_date
706: FROM msc_sup_dem_entries sd1
707: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
708: AND sd1.publisher_order_type = msc_x_netting_pkg.SALES_ORDER
709: AND not exists (SELECT * FROM msc_x_exception_details d
710: WHERE d.exception_type in (3,12)
711: AND d.transaction_id1 = sd1.transaction_id)
704: sd1.customer_item_description,
705: sd1.creation_date
706: FROM msc_sup_dem_entries sd1
707: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
708: AND sd1.publisher_order_type = msc_x_netting_pkg.SALES_ORDER
709: AND not exists (SELECT * FROM msc_x_exception_details d
710: WHERE d.exception_type in (3,12)
711: AND d.transaction_id1 = sd1.transaction_id)
712: AND sd1.last_refresh_number > p_refresh_number
716: --======================================================================
717: --COMPUTE_RESPONSE_REQUIRED
718: --======================================================================
719: PROCEDURE COMPUTE_RESPONSE_REQUIRED (
720: a_company_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
721: a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,
722: a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
723: a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,
724: a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
717: --COMPUTE_RESPONSE_REQUIRED
718: --======================================================================
719: PROCEDURE COMPUTE_RESPONSE_REQUIRED (
720: a_company_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
721: a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,
722: a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
723: a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,
724: a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
725: a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
718: --======================================================================
719: PROCEDURE COMPUTE_RESPONSE_REQUIRED (
720: a_company_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
721: a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,
722: a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
723: a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,
724: a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
725: a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
726: a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
719: PROCEDURE COMPUTE_RESPONSE_REQUIRED (
720: a_company_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
721: a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,
722: a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
723: a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,
724: a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
725: a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
726: a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
727: a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
720: a_company_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
721: a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,
722: a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
723: a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,
724: a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
725: a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
726: a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
727: a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
728: a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
721: a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,
722: a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
723: a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,
724: a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
725: a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
726: a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
727: a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
728: a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
729: a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
722: a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
723: a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,
724: a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
725: a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
726: a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
727: a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
728: a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
729: a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
730: a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
723: a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,
724: a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
725: a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
726: a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
727: a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
728: a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
729: a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
730: a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
731: a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
724: a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
725: a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
726: a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
727: a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
728: a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
729: a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
730: a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
731: a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
732: a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
725: a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
726: a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
727: a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
728: a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
729: a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
730: a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
731: a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
732: a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
733: a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
726: a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
727: a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
728: a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
729: a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
730: a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
731: a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
732: a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
733: a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
734: a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
727: a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
728: a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
729: a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
730: a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
731: a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
732: a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
733: a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
734: a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
735: a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
728: a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
729: a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
730: a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
731: a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
732: a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
733: a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
734: a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
735: a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
736: a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
729: a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
730: a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
731: a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
732: a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
733: a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
734: a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
735: a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
736: a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
737: a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
730: a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
731: a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
732: a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
733: a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
734: a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
735: a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
736: a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
737: a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
738: a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
731: a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
732: a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
733: a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
734: a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
735: a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
736: a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
737: a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
738: a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
739: a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
732: a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
733: a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
734: a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
735: a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
736: a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
737: a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
738: a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
739: a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
740: a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
733: a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
734: a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
735: a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
736: a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
737: a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
738: a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
739: a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
740: a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
741: a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
734: a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
735: a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
736: a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
737: a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
738: a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
739: a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
740: a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
741: a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
742: a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
735: a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
736: a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
737: a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
738: a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
739: a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
740: a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
741: a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
742: a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
743: a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
736: a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
737: a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
738: a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
739: a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
740: a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
741: a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
742: a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
743: a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
744: a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
737: a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
738: a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
739: a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
740: a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
741: a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
742: a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
743: a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
744: a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
745: a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
738: a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
739: a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
740: a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
741: a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
742: a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
743: a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
744: a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
745: a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
746: a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
739: a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
740: a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
741: a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
742: a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
743: a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
744: a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
745: a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
746: a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
747: a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
740: a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
741: a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
742: a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
743: a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
744: a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
745: a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
746: a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
747: a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
748: a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
741: a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
742: a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
743: a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
744: a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
745: a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
746: a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
747: a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
748: a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
749: a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
742: a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
743: a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
744: a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
745: a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
746: a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
747: a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
748: a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
749: a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
750: a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
743: a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
744: a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
745: a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
746: a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
747: a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
748: a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
749: a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
750: a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
751: a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
744: a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
745: a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
746: a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
747: a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
748: a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
749: a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
750: a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
751: a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
752: a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
745: a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
746: a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
747: a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
748: a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
749: a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
750: a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
751: a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
752: a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
753: a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
746: a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
747: a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
748: a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
749: a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
750: a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
751: a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
752: a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
753: a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
754: a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
747: a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
748: a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
749: a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
750: a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
751: a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
752: a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
753: a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
754: a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
755: a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
748: a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
749: a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
750: a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
751: a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
752: a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
753: a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
754: a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
755: a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
756: a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
749: a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
750: a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
751: a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
752: a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
753: a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
754: a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
755: a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
756: a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
757: a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
750: a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
751: a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
752: a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
753: a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
754: a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
755: a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
756: a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
757: a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
758: a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
751: a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
752: a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
753: a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
754: a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
755: a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
756: a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
757: a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
758: a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
759: a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
752: a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
753: a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
754: a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
755: a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
756: a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
757: a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
758: a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
759: a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
760: a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
753: a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
754: a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
755: a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
756: a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
757: a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
758: a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
759: a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
760: a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
761: a_date4 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
754: a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
755: a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
756: a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
757: a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
758: a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
759: a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
760: a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
761: a_date4 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
762: a_date5 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
755: a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
756: a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
757: a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
758: a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
759: a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
760: a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
761: a_date4 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
762: a_date5 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
763: a_exception_basis IN OUT NOCOPY msc_x_netting_pkg.exceptbasisList) IS
756: a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
757: a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
758: a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
759: a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
760: a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
761: a_date4 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
762: a_date5 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
763: a_exception_basis IN OUT NOCOPY msc_x_netting_pkg.exceptbasisList) IS
764:
757: a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
758: a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
759: a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
760: a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
761: a_date4 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
762: a_date5 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
763: a_exception_basis IN OUT NOCOPY msc_x_netting_pkg.exceptbasisList) IS
764:
765:
758: a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
759: a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
760: a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
761: a_date4 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
762: a_date5 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
763: a_exception_basis IN OUT NOCOPY msc_x_netting_pkg.exceptbasisList) IS
764:
765:
766: CURSOR excepSummary IS
759: a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
760: a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
761: a_date4 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
762: a_date5 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
763: a_exception_basis IN OUT NOCOPY msc_x_netting_pkg.exceptbasisList) IS
764:
765:
766: CURSOR excepSummary IS
767: select plan_id,
771: exception_group,
772: exception_type,
773: count(*)
774: from msc_x_exception_details
775: where plan_id =msc_x_netting_pkg.G_PLAN_ID
776: and version = 'X'
777: and exception_type in (11,12,31,32)
778: group by plan_id,
779: inventory_item_id,
783: exception_type;
784:
785:
786:
787: b_threshold1 msc_x_netting_pkg.number_arr;
788: b_threshold2 msc_x_netting_pkg.number_arr;
789: b_company_id msc_x_netting_pkg.number_arr;
790: b_organization_id msc_x_netting_pkg.number_arr;
791: b_trx_id1 msc_x_netting_pkg.number_arr;
784:
785:
786:
787: b_threshold1 msc_x_netting_pkg.number_arr;
788: b_threshold2 msc_x_netting_pkg.number_arr;
789: b_company_id msc_x_netting_pkg.number_arr;
790: b_organization_id msc_x_netting_pkg.number_arr;
791: b_trx_id1 msc_x_netting_pkg.number_arr;
792: b_trx_id2 msc_x_netting_pkg.number_arr;
785:
786:
787: b_threshold1 msc_x_netting_pkg.number_arr;
788: b_threshold2 msc_x_netting_pkg.number_arr;
789: b_company_id msc_x_netting_pkg.number_arr;
790: b_organization_id msc_x_netting_pkg.number_arr;
791: b_trx_id1 msc_x_netting_pkg.number_arr;
792: b_trx_id2 msc_x_netting_pkg.number_arr;
793: b_publisher_id msc_x_netting_pkg.number_arr;
786:
787: b_threshold1 msc_x_netting_pkg.number_arr;
788: b_threshold2 msc_x_netting_pkg.number_arr;
789: b_company_id msc_x_netting_pkg.number_arr;
790: b_organization_id msc_x_netting_pkg.number_arr;
791: b_trx_id1 msc_x_netting_pkg.number_arr;
792: b_trx_id2 msc_x_netting_pkg.number_arr;
793: b_publisher_id msc_x_netting_pkg.number_arr;
794: b_publisher_site_id msc_x_netting_pkg.number_arr;
787: b_threshold1 msc_x_netting_pkg.number_arr;
788: b_threshold2 msc_x_netting_pkg.number_arr;
789: b_company_id msc_x_netting_pkg.number_arr;
790: b_organization_id msc_x_netting_pkg.number_arr;
791: b_trx_id1 msc_x_netting_pkg.number_arr;
792: b_trx_id2 msc_x_netting_pkg.number_arr;
793: b_publisher_id msc_x_netting_pkg.number_arr;
794: b_publisher_site_id msc_x_netting_pkg.number_arr;
795: b_item_id msc_x_netting_pkg.number_arr;
788: b_threshold2 msc_x_netting_pkg.number_arr;
789: b_company_id msc_x_netting_pkg.number_arr;
790: b_organization_id msc_x_netting_pkg.number_arr;
791: b_trx_id1 msc_x_netting_pkg.number_arr;
792: b_trx_id2 msc_x_netting_pkg.number_arr;
793: b_publisher_id msc_x_netting_pkg.number_arr;
794: b_publisher_site_id msc_x_netting_pkg.number_arr;
795: b_item_id msc_x_netting_pkg.number_arr;
796: b_po_qty msc_x_netting_pkg.number_arr;
789: b_company_id msc_x_netting_pkg.number_arr;
790: b_organization_id msc_x_netting_pkg.number_arr;
791: b_trx_id1 msc_x_netting_pkg.number_arr;
792: b_trx_id2 msc_x_netting_pkg.number_arr;
793: b_publisher_id msc_x_netting_pkg.number_arr;
794: b_publisher_site_id msc_x_netting_pkg.number_arr;
795: b_item_id msc_x_netting_pkg.number_arr;
796: b_po_qty msc_x_netting_pkg.number_arr;
797: b_so_qty msc_x_netting_pkg.number_arr;
790: b_organization_id msc_x_netting_pkg.number_arr;
791: b_trx_id1 msc_x_netting_pkg.number_arr;
792: b_trx_id2 msc_x_netting_pkg.number_arr;
793: b_publisher_id msc_x_netting_pkg.number_arr;
794: b_publisher_site_id msc_x_netting_pkg.number_arr;
795: b_item_id msc_x_netting_pkg.number_arr;
796: b_po_qty msc_x_netting_pkg.number_arr;
797: b_so_qty msc_x_netting_pkg.number_arr;
798: b_tp_qty msc_x_netting_pkg.number_arr;
791: b_trx_id1 msc_x_netting_pkg.number_arr;
792: b_trx_id2 msc_x_netting_pkg.number_arr;
793: b_publisher_id msc_x_netting_pkg.number_arr;
794: b_publisher_site_id msc_x_netting_pkg.number_arr;
795: b_item_id msc_x_netting_pkg.number_arr;
796: b_po_qty msc_x_netting_pkg.number_arr;
797: b_so_qty msc_x_netting_pkg.number_arr;
798: b_tp_qty msc_x_netting_pkg.number_arr;
799: b_posting_po_qty msc_x_netting_pkg.number_arr;
792: b_trx_id2 msc_x_netting_pkg.number_arr;
793: b_publisher_id msc_x_netting_pkg.number_arr;
794: b_publisher_site_id msc_x_netting_pkg.number_arr;
795: b_item_id msc_x_netting_pkg.number_arr;
796: b_po_qty msc_x_netting_pkg.number_arr;
797: b_so_qty msc_x_netting_pkg.number_arr;
798: b_tp_qty msc_x_netting_pkg.number_arr;
799: b_posting_po_qty msc_x_netting_pkg.number_arr;
800: b_posting_so_qty msc_x_netting_pkg.number_arr;
793: b_publisher_id msc_x_netting_pkg.number_arr;
794: b_publisher_site_id msc_x_netting_pkg.number_arr;
795: b_item_id msc_x_netting_pkg.number_arr;
796: b_po_qty msc_x_netting_pkg.number_arr;
797: b_so_qty msc_x_netting_pkg.number_arr;
798: b_tp_qty msc_x_netting_pkg.number_arr;
799: b_posting_po_qty msc_x_netting_pkg.number_arr;
800: b_posting_so_qty msc_x_netting_pkg.number_arr;
801: b_customer_id msc_x_netting_pkg.number_arr;
794: b_publisher_site_id msc_x_netting_pkg.number_arr;
795: b_item_id msc_x_netting_pkg.number_arr;
796: b_po_qty msc_x_netting_pkg.number_arr;
797: b_so_qty msc_x_netting_pkg.number_arr;
798: b_tp_qty msc_x_netting_pkg.number_arr;
799: b_posting_po_qty msc_x_netting_pkg.number_arr;
800: b_posting_so_qty msc_x_netting_pkg.number_arr;
801: b_customer_id msc_x_netting_pkg.number_arr;
802: b_customer_site_id msc_x_netting_pkg.number_arr;
795: b_item_id msc_x_netting_pkg.number_arr;
796: b_po_qty msc_x_netting_pkg.number_arr;
797: b_so_qty msc_x_netting_pkg.number_arr;
798: b_tp_qty msc_x_netting_pkg.number_arr;
799: b_posting_po_qty msc_x_netting_pkg.number_arr;
800: b_posting_so_qty msc_x_netting_pkg.number_arr;
801: b_customer_id msc_x_netting_pkg.number_arr;
802: b_customer_site_id msc_x_netting_pkg.number_arr;
803: b_supplier_id msc_x_netting_pkg.number_arr;
796: b_po_qty msc_x_netting_pkg.number_arr;
797: b_so_qty msc_x_netting_pkg.number_arr;
798: b_tp_qty msc_x_netting_pkg.number_arr;
799: b_posting_po_qty msc_x_netting_pkg.number_arr;
800: b_posting_so_qty msc_x_netting_pkg.number_arr;
801: b_customer_id msc_x_netting_pkg.number_arr;
802: b_customer_site_id msc_x_netting_pkg.number_arr;
803: b_supplier_id msc_x_netting_pkg.number_arr;
804: b_supplier_site_id msc_x_netting_pkg.number_arr;
797: b_so_qty msc_x_netting_pkg.number_arr;
798: b_tp_qty msc_x_netting_pkg.number_arr;
799: b_posting_po_qty msc_x_netting_pkg.number_arr;
800: b_posting_so_qty msc_x_netting_pkg.number_arr;
801: b_customer_id msc_x_netting_pkg.number_arr;
802: b_customer_site_id msc_x_netting_pkg.number_arr;
803: b_supplier_id msc_x_netting_pkg.number_arr;
804: b_supplier_site_id msc_x_netting_pkg.number_arr;
805: b_lead_time msc_x_netting_pkg.number_arr;
798: b_tp_qty msc_x_netting_pkg.number_arr;
799: b_posting_po_qty msc_x_netting_pkg.number_arr;
800: b_posting_so_qty msc_x_netting_pkg.number_arr;
801: b_customer_id msc_x_netting_pkg.number_arr;
802: b_customer_site_id msc_x_netting_pkg.number_arr;
803: b_supplier_id msc_x_netting_pkg.number_arr;
804: b_supplier_site_id msc_x_netting_pkg.number_arr;
805: b_lead_time msc_x_netting_pkg.number_arr;
806: b_po_key_date msc_x_netting_pkg.date_arr;
799: b_posting_po_qty msc_x_netting_pkg.number_arr;
800: b_posting_so_qty msc_x_netting_pkg.number_arr;
801: b_customer_id msc_x_netting_pkg.number_arr;
802: b_customer_site_id msc_x_netting_pkg.number_arr;
803: b_supplier_id msc_x_netting_pkg.number_arr;
804: b_supplier_site_id msc_x_netting_pkg.number_arr;
805: b_lead_time msc_x_netting_pkg.number_arr;
806: b_po_key_date msc_x_netting_pkg.date_arr;
807: b_so_key_date msc_x_netting_pkg.date_arr;
800: b_posting_so_qty msc_x_netting_pkg.number_arr;
801: b_customer_id msc_x_netting_pkg.number_arr;
802: b_customer_site_id msc_x_netting_pkg.number_arr;
803: b_supplier_id msc_x_netting_pkg.number_arr;
804: b_supplier_site_id msc_x_netting_pkg.number_arr;
805: b_lead_time msc_x_netting_pkg.number_arr;
806: b_po_key_date msc_x_netting_pkg.date_arr;
807: b_so_key_date msc_x_netting_pkg.date_arr;
808: b_po_ship_date msc_x_netting_pkg.date_arr;
801: b_customer_id msc_x_netting_pkg.number_arr;
802: b_customer_site_id msc_x_netting_pkg.number_arr;
803: b_supplier_id msc_x_netting_pkg.number_arr;
804: b_supplier_site_id msc_x_netting_pkg.number_arr;
805: b_lead_time msc_x_netting_pkg.number_arr;
806: b_po_key_date msc_x_netting_pkg.date_arr;
807: b_so_key_date msc_x_netting_pkg.date_arr;
808: b_po_ship_date msc_x_netting_pkg.date_arr;
809: b_so_ship_date msc_x_netting_pkg.date_arr;
802: b_customer_site_id msc_x_netting_pkg.number_arr;
803: b_supplier_id msc_x_netting_pkg.number_arr;
804: b_supplier_site_id msc_x_netting_pkg.number_arr;
805: b_lead_time msc_x_netting_pkg.number_arr;
806: b_po_key_date msc_x_netting_pkg.date_arr;
807: b_so_key_date msc_x_netting_pkg.date_arr;
808: b_po_ship_date msc_x_netting_pkg.date_arr;
809: b_so_ship_date msc_x_netting_pkg.date_arr;
810: b_po_receipt_date msc_x_netting_pkg.date_arr;
803: b_supplier_id msc_x_netting_pkg.number_arr;
804: b_supplier_site_id msc_x_netting_pkg.number_arr;
805: b_lead_time msc_x_netting_pkg.number_arr;
806: b_po_key_date msc_x_netting_pkg.date_arr;
807: b_so_key_date msc_x_netting_pkg.date_arr;
808: b_po_ship_date msc_x_netting_pkg.date_arr;
809: b_so_ship_date msc_x_netting_pkg.date_arr;
810: b_po_receipt_date msc_x_netting_pkg.date_arr;
811: b_so_receipt_date msc_x_netting_pkg.date_arr;
804: b_supplier_site_id msc_x_netting_pkg.number_arr;
805: b_lead_time msc_x_netting_pkg.number_arr;
806: b_po_key_date msc_x_netting_pkg.date_arr;
807: b_so_key_date msc_x_netting_pkg.date_arr;
808: b_po_ship_date msc_x_netting_pkg.date_arr;
809: b_so_ship_date msc_x_netting_pkg.date_arr;
810: b_po_receipt_date msc_x_netting_pkg.date_arr;
811: b_so_receipt_date msc_x_netting_pkg.date_arr;
812: b_po_creation_date msc_x_netting_pkg.date_arr;
805: b_lead_time msc_x_netting_pkg.number_arr;
806: b_po_key_date msc_x_netting_pkg.date_arr;
807: b_so_key_date msc_x_netting_pkg.date_arr;
808: b_po_ship_date msc_x_netting_pkg.date_arr;
809: b_so_ship_date msc_x_netting_pkg.date_arr;
810: b_po_receipt_date msc_x_netting_pkg.date_arr;
811: b_so_receipt_date msc_x_netting_pkg.date_arr;
812: b_po_creation_date msc_x_netting_pkg.date_arr;
813: b_so_creation_date msc_x_netting_pkg.date_arr;
806: b_po_key_date msc_x_netting_pkg.date_arr;
807: b_so_key_date msc_x_netting_pkg.date_arr;
808: b_po_ship_date msc_x_netting_pkg.date_arr;
809: b_so_ship_date msc_x_netting_pkg.date_arr;
810: b_po_receipt_date msc_x_netting_pkg.date_arr;
811: b_so_receipt_date msc_x_netting_pkg.date_arr;
812: b_po_creation_date msc_x_netting_pkg.date_arr;
813: b_so_creation_date msc_x_netting_pkg.date_arr;
814: b_item_name msc_x_netting_pkg.itemnameList;
807: b_so_key_date msc_x_netting_pkg.date_arr;
808: b_po_ship_date msc_x_netting_pkg.date_arr;
809: b_so_ship_date msc_x_netting_pkg.date_arr;
810: b_po_receipt_date msc_x_netting_pkg.date_arr;
811: b_so_receipt_date msc_x_netting_pkg.date_arr;
812: b_po_creation_date msc_x_netting_pkg.date_arr;
813: b_so_creation_date msc_x_netting_pkg.date_arr;
814: b_item_name msc_x_netting_pkg.itemnameList;
815: b_item_desc msc_x_netting_pkg.itemdescList;
808: b_po_ship_date msc_x_netting_pkg.date_arr;
809: b_so_ship_date msc_x_netting_pkg.date_arr;
810: b_po_receipt_date msc_x_netting_pkg.date_arr;
811: b_so_receipt_date msc_x_netting_pkg.date_arr;
812: b_po_creation_date msc_x_netting_pkg.date_arr;
813: b_so_creation_date msc_x_netting_pkg.date_arr;
814: b_item_name msc_x_netting_pkg.itemnameList;
815: b_item_desc msc_x_netting_pkg.itemdescList;
816: b_publisher_name msc_x_netting_pkg.publisherList;
809: b_so_ship_date msc_x_netting_pkg.date_arr;
810: b_po_receipt_date msc_x_netting_pkg.date_arr;
811: b_so_receipt_date msc_x_netting_pkg.date_arr;
812: b_po_creation_date msc_x_netting_pkg.date_arr;
813: b_so_creation_date msc_x_netting_pkg.date_arr;
814: b_item_name msc_x_netting_pkg.itemnameList;
815: b_item_desc msc_x_netting_pkg.itemdescList;
816: b_publisher_name msc_x_netting_pkg.publisherList;
817: b_publisher_site_name msc_x_netting_pkg.pubsiteList;
810: b_po_receipt_date msc_x_netting_pkg.date_arr;
811: b_so_receipt_date msc_x_netting_pkg.date_arr;
812: b_po_creation_date msc_x_netting_pkg.date_arr;
813: b_so_creation_date msc_x_netting_pkg.date_arr;
814: b_item_name msc_x_netting_pkg.itemnameList;
815: b_item_desc msc_x_netting_pkg.itemdescList;
816: b_publisher_name msc_x_netting_pkg.publisherList;
817: b_publisher_site_name msc_x_netting_pkg.pubsiteList;
818: b_supplier_name msc_x_netting_pkg.supplierList;
811: b_so_receipt_date msc_x_netting_pkg.date_arr;
812: b_po_creation_date msc_x_netting_pkg.date_arr;
813: b_so_creation_date msc_x_netting_pkg.date_arr;
814: b_item_name msc_x_netting_pkg.itemnameList;
815: b_item_desc msc_x_netting_pkg.itemdescList;
816: b_publisher_name msc_x_netting_pkg.publisherList;
817: b_publisher_site_name msc_x_netting_pkg.pubsiteList;
818: b_supplier_name msc_x_netting_pkg.supplierList;
819: b_supplier_site_name msc_x_netting_pkg.suppsiteList;
812: b_po_creation_date msc_x_netting_pkg.date_arr;
813: b_so_creation_date msc_x_netting_pkg.date_arr;
814: b_item_name msc_x_netting_pkg.itemnameList;
815: b_item_desc msc_x_netting_pkg.itemdescList;
816: b_publisher_name msc_x_netting_pkg.publisherList;
817: b_publisher_site_name msc_x_netting_pkg.pubsiteList;
818: b_supplier_name msc_x_netting_pkg.supplierList;
819: b_supplier_site_name msc_x_netting_pkg.suppsiteList;
820: b_supplier_item_name msc_x_netting_pkg.itemnameList;
813: b_so_creation_date msc_x_netting_pkg.date_arr;
814: b_item_name msc_x_netting_pkg.itemnameList;
815: b_item_desc msc_x_netting_pkg.itemdescList;
816: b_publisher_name msc_x_netting_pkg.publisherList;
817: b_publisher_site_name msc_x_netting_pkg.pubsiteList;
818: b_supplier_name msc_x_netting_pkg.supplierList;
819: b_supplier_site_name msc_x_netting_pkg.suppsiteList;
820: b_supplier_item_name msc_x_netting_pkg.itemnameList;
821: b_supplier_item_desc msc_x_netting_pkg.itemdescList;
814: b_item_name msc_x_netting_pkg.itemnameList;
815: b_item_desc msc_x_netting_pkg.itemdescList;
816: b_publisher_name msc_x_netting_pkg.publisherList;
817: b_publisher_site_name msc_x_netting_pkg.pubsiteList;
818: b_supplier_name msc_x_netting_pkg.supplierList;
819: b_supplier_site_name msc_x_netting_pkg.suppsiteList;
820: b_supplier_item_name msc_x_netting_pkg.itemnameList;
821: b_supplier_item_desc msc_x_netting_pkg.itemdescList;
822: b_customer_name msc_x_netting_pkg.customerList;
815: b_item_desc msc_x_netting_pkg.itemdescList;
816: b_publisher_name msc_x_netting_pkg.publisherList;
817: b_publisher_site_name msc_x_netting_pkg.pubsiteList;
818: b_supplier_name msc_x_netting_pkg.supplierList;
819: b_supplier_site_name msc_x_netting_pkg.suppsiteList;
820: b_supplier_item_name msc_x_netting_pkg.itemnameList;
821: b_supplier_item_desc msc_x_netting_pkg.itemdescList;
822: b_customer_name msc_x_netting_pkg.customerList;
823: b_customer_site_name msc_x_netting_pkg.custsiteList;
816: b_publisher_name msc_x_netting_pkg.publisherList;
817: b_publisher_site_name msc_x_netting_pkg.pubsiteList;
818: b_supplier_name msc_x_netting_pkg.supplierList;
819: b_supplier_site_name msc_x_netting_pkg.suppsiteList;
820: b_supplier_item_name msc_x_netting_pkg.itemnameList;
821: b_supplier_item_desc msc_x_netting_pkg.itemdescList;
822: b_customer_name msc_x_netting_pkg.customerList;
823: b_customer_site_name msc_x_netting_pkg.custsiteList;
824: b_customer_item_name msc_x_netting_pkg.itemnameList;
817: b_publisher_site_name msc_x_netting_pkg.pubsiteList;
818: b_supplier_name msc_x_netting_pkg.supplierList;
819: b_supplier_site_name msc_x_netting_pkg.suppsiteList;
820: b_supplier_item_name msc_x_netting_pkg.itemnameList;
821: b_supplier_item_desc msc_x_netting_pkg.itemdescList;
822: b_customer_name msc_x_netting_pkg.customerList;
823: b_customer_site_name msc_x_netting_pkg.custsiteList;
824: b_customer_item_name msc_x_netting_pkg.itemnameList;
825: b_customer_item_desc msc_x_netting_pkg.itemdescList;
818: b_supplier_name msc_x_netting_pkg.supplierList;
819: b_supplier_site_name msc_x_netting_pkg.suppsiteList;
820: b_supplier_item_name msc_x_netting_pkg.itemnameList;
821: b_supplier_item_desc msc_x_netting_pkg.itemdescList;
822: b_customer_name msc_x_netting_pkg.customerList;
823: b_customer_site_name msc_x_netting_pkg.custsiteList;
824: b_customer_item_name msc_x_netting_pkg.itemnameList;
825: b_customer_item_desc msc_x_netting_pkg.itemdescList;
826: b_order_number msc_x_netting_pkg.ordernumberList;
819: b_supplier_site_name msc_x_netting_pkg.suppsiteList;
820: b_supplier_item_name msc_x_netting_pkg.itemnameList;
821: b_supplier_item_desc msc_x_netting_pkg.itemdescList;
822: b_customer_name msc_x_netting_pkg.customerList;
823: b_customer_site_name msc_x_netting_pkg.custsiteList;
824: b_customer_item_name msc_x_netting_pkg.itemnameList;
825: b_customer_item_desc msc_x_netting_pkg.itemdescList;
826: b_order_number msc_x_netting_pkg.ordernumberList;
827: b_release_number msc_x_netting_pkg.releasenumList;
820: b_supplier_item_name msc_x_netting_pkg.itemnameList;
821: b_supplier_item_desc msc_x_netting_pkg.itemdescList;
822: b_customer_name msc_x_netting_pkg.customerList;
823: b_customer_site_name msc_x_netting_pkg.custsiteList;
824: b_customer_item_name msc_x_netting_pkg.itemnameList;
825: b_customer_item_desc msc_x_netting_pkg.itemdescList;
826: b_order_number msc_x_netting_pkg.ordernumberList;
827: b_release_number msc_x_netting_pkg.releasenumList;
828: b_line_number msc_x_netting_pkg.linenumList;
821: b_supplier_item_desc msc_x_netting_pkg.itemdescList;
822: b_customer_name msc_x_netting_pkg.customerList;
823: b_customer_site_name msc_x_netting_pkg.custsiteList;
824: b_customer_item_name msc_x_netting_pkg.itemnameList;
825: b_customer_item_desc msc_x_netting_pkg.itemdescList;
826: b_order_number msc_x_netting_pkg.ordernumberList;
827: b_release_number msc_x_netting_pkg.releasenumList;
828: b_line_number msc_x_netting_pkg.linenumList;
829: b_end_order_num msc_x_netting_pkg.ordernumberList;
822: b_customer_name msc_x_netting_pkg.customerList;
823: b_customer_site_name msc_x_netting_pkg.custsiteList;
824: b_customer_item_name msc_x_netting_pkg.itemnameList;
825: b_customer_item_desc msc_x_netting_pkg.itemdescList;
826: b_order_number msc_x_netting_pkg.ordernumberList;
827: b_release_number msc_x_netting_pkg.releasenumList;
828: b_line_number msc_x_netting_pkg.linenumList;
829: b_end_order_num msc_x_netting_pkg.ordernumberList;
830: b_end_order_rel_num msc_x_netting_pkg.releasenumList;
823: b_customer_site_name msc_x_netting_pkg.custsiteList;
824: b_customer_item_name msc_x_netting_pkg.itemnameList;
825: b_customer_item_desc msc_x_netting_pkg.itemdescList;
826: b_order_number msc_x_netting_pkg.ordernumberList;
827: b_release_number msc_x_netting_pkg.releasenumList;
828: b_line_number msc_x_netting_pkg.linenumList;
829: b_end_order_num msc_x_netting_pkg.ordernumberList;
830: b_end_order_rel_num msc_x_netting_pkg.releasenumList;
831: b_end_order_line_num msc_x_netting_pkg.linenumList;
824: b_customer_item_name msc_x_netting_pkg.itemnameList;
825: b_customer_item_desc msc_x_netting_pkg.itemdescList;
826: b_order_number msc_x_netting_pkg.ordernumberList;
827: b_release_number msc_x_netting_pkg.releasenumList;
828: b_line_number msc_x_netting_pkg.linenumList;
829: b_end_order_num msc_x_netting_pkg.ordernumberList;
830: b_end_order_rel_num msc_x_netting_pkg.releasenumList;
831: b_end_order_line_num msc_x_netting_pkg.linenumList;
832:
825: b_customer_item_desc msc_x_netting_pkg.itemdescList;
826: b_order_number msc_x_netting_pkg.ordernumberList;
827: b_release_number msc_x_netting_pkg.releasenumList;
828: b_line_number msc_x_netting_pkg.linenumList;
829: b_end_order_num msc_x_netting_pkg.ordernumberList;
830: b_end_order_rel_num msc_x_netting_pkg.releasenumList;
831: b_end_order_line_num msc_x_netting_pkg.linenumList;
832:
833: l_exception_type Number;
826: b_order_number msc_x_netting_pkg.ordernumberList;
827: b_release_number msc_x_netting_pkg.releasenumList;
828: b_line_number msc_x_netting_pkg.linenumList;
829: b_end_order_num msc_x_netting_pkg.ordernumberList;
830: b_end_order_rel_num msc_x_netting_pkg.releasenumList;
831: b_end_order_line_num msc_x_netting_pkg.linenumList;
832:
833: l_exception_type Number;
834: l_exception_group Number;
827: b_release_number msc_x_netting_pkg.releasenumList;
828: b_line_number msc_x_netting_pkg.linenumList;
829: b_end_order_num msc_x_netting_pkg.ordernumberList;
830: b_end_order_rel_num msc_x_netting_pkg.releasenumList;
831: b_end_order_line_num msc_x_netting_pkg.linenumList;
832:
833: l_exception_type Number;
834: l_exception_group Number;
835: l_exception_type_name fnd_lookup_values.meaning%type;
885: =====================================================*/
886:
887: update msc_x_exception_details
888: set version = 'X'
889: where plan_id = msc_x_netting_pkg.G_PLAN_ID
890: and exception_type in (11,12,31,32);
891:
892: update msc_item_exceptions
893: set version = version + 1
890: and exception_type in (11,12,31,32);
891:
892: update msc_item_exceptions
893: set version = version + 1
894: where plan_id = msc_x_netting_pkg.G_PLAN_ID
895: and exception_type in (11,12,31,32);
896:
897:
898: --dbms_output.put_line('Exception 11 and 31');
931:
932: IF (b_trx_id1 is not null and b_trx_id1.COUNT > 0) THEN
933: FOR j in 1..b_trx_id1.COUNT LOOP
934:
935: l_exception_type := msc_x_netting_pkg.G_EXCEP11;
936: l_exception_group := msc_x_netting_pkg.G_RESPONSE_REQUIRED;
937: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
938: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
939:
932: IF (b_trx_id1 is not null and b_trx_id1.COUNT > 0) THEN
933: FOR j in 1..b_trx_id1.COUNT LOOP
934:
935: l_exception_type := msc_x_netting_pkg.G_EXCEP11;
936: l_exception_group := msc_x_netting_pkg.G_RESPONSE_REQUIRED;
937: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
938: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
939:
940: IF (sysdate > b_po_creation_date(j) + b_threshold1(j)) THEN
933: FOR j in 1..b_trx_id1.COUNT LOOP
934:
935: l_exception_type := msc_x_netting_pkg.G_EXCEP11;
936: l_exception_group := msc_x_netting_pkg.G_RESPONSE_REQUIRED;
937: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
938: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
939:
940: IF (sysdate > b_po_creation_date(j) + b_threshold1(j)) THEN
941:
934:
935: l_exception_type := msc_x_netting_pkg.G_EXCEP11;
936: l_exception_group := msc_x_netting_pkg.G_RESPONSE_REQUIRED;
937: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
938: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
939:
940: IF (sysdate > b_po_creation_date(j) + b_threshold1(j)) THEN
941:
942:
953: -----------------------------------------------------------------------
954: -- exception 3.1 (supplier centric)
955: -----------------------------------------------------------------------
956:
957: l_exception_detail_id1 := msc_x_netting_pkg.does_detail_excep_exist(b_supplier_id(j),
958: b_supplier_site_id(j),
959: b_item_id(j),
960: l_exception_type,
961: b_trx_id1(j));
971: where exception_detail_id = l_exception_detail_id1;
972:
973: --Need to reset the item exception. The item exception
974: --might be archive for the same key
975: msc_x_netting_pkg.update_exceptions_summary(b_supplier_id(j),
976: b_supplier_site_id(j),
977: b_item_id(j),
978: l_exception_type,
979: l_exception_group);
980:
981: ELSE
982: --dbms_output.put_line('-----Exception11: Create exception' );
983:
984: msc_x_netting_pkg.add_to_exception_tbl(b_supplier_id(j),
985: b_supplier_name(j),
986: b_supplier_site_id(j),
987: b_supplier_site_name(j),
988: b_item_id(j),
1078: -- exception 3.2(customer centric)
1079: -----------------------------------------------------------------------
1080: l_exception_detail_id2 := null;
1081: IF (sysdate > b_po_creation_date(j) + b_threshold2(j)) THEN
1082: l_exception_type := msc_x_netting_pkg.G_EXCEP31;
1083: l_exception_group := msc_x_netting_pkg.G_RESPONSE_REQUIRED;
1084:
1085: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
1086: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
1079: -----------------------------------------------------------------------
1080: l_exception_detail_id2 := null;
1081: IF (sysdate > b_po_creation_date(j) + b_threshold2(j)) THEN
1082: l_exception_type := msc_x_netting_pkg.G_EXCEP31;
1083: l_exception_group := msc_x_netting_pkg.G_RESPONSE_REQUIRED;
1084:
1085: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
1086: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
1087: l_exception_detail_id2 := msc_x_netting_pkg.does_detail_excep_exist(b_publisher_id(j),
1081: IF (sysdate > b_po_creation_date(j) + b_threshold2(j)) THEN
1082: l_exception_type := msc_x_netting_pkg.G_EXCEP31;
1083: l_exception_group := msc_x_netting_pkg.G_RESPONSE_REQUIRED;
1084:
1085: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
1086: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
1087: l_exception_detail_id2 := msc_x_netting_pkg.does_detail_excep_exist(b_publisher_id(j),
1088: b_publisher_site_id(j),
1089: b_item_id(j),
1082: l_exception_type := msc_x_netting_pkg.G_EXCEP31;
1083: l_exception_group := msc_x_netting_pkg.G_RESPONSE_REQUIRED;
1084:
1085: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
1086: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
1087: l_exception_detail_id2 := msc_x_netting_pkg.does_detail_excep_exist(b_publisher_id(j),
1088: b_publisher_site_id(j),
1089: b_item_id(j),
1090: l_exception_type,
1083: l_exception_group := msc_x_netting_pkg.G_RESPONSE_REQUIRED;
1084:
1085: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
1086: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
1087: l_exception_detail_id2 := msc_x_netting_pkg.does_detail_excep_exist(b_publisher_id(j),
1088: b_publisher_site_id(j),
1089: b_item_id(j),
1090: l_exception_type,
1091: b_trx_id1(j));
1101: where exception_detail_id = l_exception_detail_id2;
1102:
1103: --Need to reset the item exception. The item exception
1104: --might be archive for the same key
1105: msc_x_netting_pkg.update_exceptions_summary(b_publisher_id(j),
1106: b_publisher_site_id(j),
1107: b_item_id(j),
1108: l_exception_type,
1109: l_exception_group);
1110:
1111: ELSE
1112: --dbms_output.put_line('-----Exception31: Create exception' );
1113:
1114: msc_x_netting_pkg.add_to_exception_tbl(b_publisher_id(j),
1115: b_publisher_name(j),
1116: b_publisher_site_id(j),
1117: b_publisher_site_name(j),
1118: b_item_id(j),
1206:
1207: END LOOP;
1208: END IF;
1209:
1210: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(11) ||
1211: msc_x_netting_pkg.get_message_type(31) || ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
1212:
1213:
1214: l_exception_detail_id1 := null;
1207: END LOOP;
1208: END IF;
1209:
1210: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(11) ||
1211: msc_x_netting_pkg.get_message_type(31) || ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
1212:
1213:
1214: l_exception_detail_id1 := null;
1215: l_exception_detail_id2 := null;
1250:
1251: IF (b_trx_id1 is not null and b_trx_id1.COUNT > 0) THEN
1252: FOR j in 1..b_trx_id1.COUNT LOOP
1253:
1254: l_exception_type := msc_x_netting_pkg.G_EXCEP12;
1255: l_exception_group := msc_x_netting_pkg.G_RESPONSE_REQUIRED;
1256: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
1257: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
1258:
1251: IF (b_trx_id1 is not null and b_trx_id1.COUNT > 0) THEN
1252: FOR j in 1..b_trx_id1.COUNT LOOP
1253:
1254: l_exception_type := msc_x_netting_pkg.G_EXCEP12;
1255: l_exception_group := msc_x_netting_pkg.G_RESPONSE_REQUIRED;
1256: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
1257: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
1258:
1259: IF (sysdate > b_so_creation_date(j) + b_threshold1(j)) THEN
1252: FOR j in 1..b_trx_id1.COUNT LOOP
1253:
1254: l_exception_type := msc_x_netting_pkg.G_EXCEP12;
1255: l_exception_group := msc_x_netting_pkg.G_RESPONSE_REQUIRED;
1256: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
1257: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
1258:
1259: IF (sysdate > b_so_creation_date(j) + b_threshold1(j)) THEN
1260:
1253:
1254: l_exception_type := msc_x_netting_pkg.G_EXCEP12;
1255: l_exception_group := msc_x_netting_pkg.G_RESPONSE_REQUIRED;
1256: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
1257: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
1258:
1259: IF (sysdate > b_so_creation_date(j) + b_threshold1(j)) THEN
1260:
1261: --------------------------------------------------------------------------
1271:
1272: -------------------------------------------------------------
1273: -- exception 12 (supplier centric)
1274: --------------------------------------------------------------
1275: l_exception_detail_id1 := msc_x_netting_pkg.does_detail_excep_exist(b_publisher_id(j),
1276: b_publisher_site_id(j),
1277: b_item_id(j),
1278: l_exception_type,
1279: b_trx_id1(j));
1290: where exception_detail_id = l_exception_detail_id1;
1291:
1292: --Need to reset the item exception. The item exception
1293: --might be archive for the same key
1294: msc_x_netting_pkg.update_exceptions_summary(b_publisher_id(j),
1295: b_publisher_site_id(j),
1296: b_item_id(j),
1297: l_exception_type,
1298: l_exception_group);
1299:
1300: ELSE
1301: --dbms_output.put_line('-----Exception12: Create exception' );
1302:
1303: msc_x_netting_pkg.add_to_exception_tbl(b_publisher_id(j),
1304: b_publisher_name(j),
1305: b_publisher_site_id(j),
1306: b_publisher_site_name(j),
1307: b_item_id(j),
1403: IF (sysdate > b_so_creation_date(j) + b_threshold2(j)) THEN
1404: -------------------------------------------------------------
1405: -- exception 32 (customer centric)
1406: --------------------------------------------------------------
1407: l_exception_type := msc_x_netting_pkg.G_EXCEP32;
1408: l_exception_group := msc_x_netting_pkg.G_RESPONSE_REQUIRED;
1409: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
1410: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
1411:
1404: -------------------------------------------------------------
1405: -- exception 32 (customer centric)
1406: --------------------------------------------------------------
1407: l_exception_type := msc_x_netting_pkg.G_EXCEP32;
1408: l_exception_group := msc_x_netting_pkg.G_RESPONSE_REQUIRED;
1409: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
1410: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
1411:
1412: l_exception_detail_id2 := msc_x_netting_pkg.does_detail_excep_exist(b_customer_id(j),
1405: -- exception 32 (customer centric)
1406: --------------------------------------------------------------
1407: l_exception_type := msc_x_netting_pkg.G_EXCEP32;
1408: l_exception_group := msc_x_netting_pkg.G_RESPONSE_REQUIRED;
1409: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
1410: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
1411:
1412: l_exception_detail_id2 := msc_x_netting_pkg.does_detail_excep_exist(b_customer_id(j),
1413: b_customer_site_id(j),
1406: --------------------------------------------------------------
1407: l_exception_type := msc_x_netting_pkg.G_EXCEP32;
1408: l_exception_group := msc_x_netting_pkg.G_RESPONSE_REQUIRED;
1409: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
1410: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
1411:
1412: l_exception_detail_id2 := msc_x_netting_pkg.does_detail_excep_exist(b_customer_id(j),
1413: b_customer_site_id(j),
1414: b_item_id(j),
1408: l_exception_group := msc_x_netting_pkg.G_RESPONSE_REQUIRED;
1409: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
1410: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
1411:
1412: l_exception_detail_id2 := msc_x_netting_pkg.does_detail_excep_exist(b_customer_id(j),
1413: b_customer_site_id(j),
1414: b_item_id(j),
1415: l_exception_type,
1416: b_trx_id1(j));
1427: where exception_detail_id = l_exception_detail_id2;
1428:
1429: --Need to reset the item exception. The item exception
1430: --might be archive for the same key
1431: msc_x_netting_pkg.update_exceptions_summary(b_customer_id(j),
1432: b_customer_site_id(j),
1433: b_item_id(j),
1434: l_exception_type,
1435: l_exception_group);
1436:
1437: ELSE
1438: --dbms_output.put_line('-----Exception32: Create exception' );
1439:
1440: msc_x_netting_pkg.add_to_exception_tbl(b_customer_id(j),
1441: b_customer_name(j),
1442: b_customer_site_id(j),
1443: b_customer_site_name(j),
1444: b_item_id(j),
1530: END IF;
1531: END LOOP;
1532: END IF;
1533:
1534: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(12) ||
1535: msc_x_netting_pkg.get_message_type(32) || ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
1536:
1537:
1538: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total exceptions inserted for the group ' ||
1531: END LOOP;
1532: END IF;
1533:
1534: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(12) ||
1535: msc_x_netting_pkg.get_message_type(32) || ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
1536:
1537:
1538: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total exceptions inserted for the group ' ||
1539: msc_x_netting_pkg.get_message_group(msc_x_netting_pkg.G_RESPONSE_REQUIRED) || ':' || l_inserted_record);
1535: msc_x_netting_pkg.get_message_type(32) || ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
1536:
1537:
1538: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total exceptions inserted for the group ' ||
1539: msc_x_netting_pkg.get_message_group(msc_x_netting_pkg.G_RESPONSE_REQUIRED) || ':' || l_inserted_record);
1540: --===========================================================================================
1541: --Archive all the exception notifications sent out in previous engine runs
1542: --and are not re-occurr in this run
1543: --The old exceptions with version = 'X' in msc_x_exception_details table
1543: --The old exceptions with version = 'X' in msc_x_exception_details table
1544: --=======================================================================================
1545: BEGIN
1546: delete msc_x_exception_details
1547: where plan_id = msc_x_netting_pkg.G_PLAN_ID
1548: and exception_type in (11,12,31,32)
1549: and version = 'X';
1550:
1551: l_row := SQL%ROWCOUNT;
1592: to_char(u_inventory_item_id(i)) || '-' ||
1593: to_char(u_company_id(i)) || '-' ||
1594: to_char(u_company_site_id(i)) || '%';
1595:
1596: msc_x_netting_pkg.delete_wf_notification(l_item_type, l_item_key);
1597: END LOOP;
1598: END IF;
1599: EXCEPTION WHEN OTHERS THEN
1600: return;
1612: --===================================================================================
1613: --COMPUTE_POTENTIAL_LATE_ORDER
1614: --===================================================================================
1615: PROCEDURE COMPUTE_POTENTIAL_LATE_ORDER (p_refresh_number IN Number,
1616: t_company_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1617: t_company_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1618: t_customer_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1619: t_customer_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1620: t_supplier_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1613: --COMPUTE_POTENTIAL_LATE_ORDER
1614: --===================================================================================
1615: PROCEDURE COMPUTE_POTENTIAL_LATE_ORDER (p_refresh_number IN Number,
1616: t_company_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1617: t_company_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1618: t_customer_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1619: t_customer_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1620: t_supplier_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1621: t_supplier_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1614: --===================================================================================
1615: PROCEDURE COMPUTE_POTENTIAL_LATE_ORDER (p_refresh_number IN Number,
1616: t_company_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1617: t_company_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1618: t_customer_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1619: t_customer_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1620: t_supplier_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1621: t_supplier_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1622: t_item_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1615: PROCEDURE COMPUTE_POTENTIAL_LATE_ORDER (p_refresh_number IN Number,
1616: t_company_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1617: t_company_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1618: t_customer_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1619: t_customer_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1620: t_supplier_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1621: t_supplier_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1622: t_item_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1623: t_group_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1616: t_company_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1617: t_company_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1618: t_customer_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1619: t_customer_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1620: t_supplier_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1621: t_supplier_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1622: t_item_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1623: t_group_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1624: t_type_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1617: t_company_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1618: t_customer_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1619: t_customer_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1620: t_supplier_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1621: t_supplier_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1622: t_item_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1623: t_group_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1624: t_type_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1625: t_trxid1_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1618: t_customer_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1619: t_customer_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1620: t_supplier_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1621: t_supplier_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1622: t_item_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1623: t_group_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1624: t_type_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1625: t_trxid1_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1626: t_trxid2_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1619: t_customer_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1620: t_supplier_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1621: t_supplier_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1622: t_item_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1623: t_group_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1624: t_type_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1625: t_trxid1_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1626: t_trxid2_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1627: t_date1_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1620: t_supplier_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1621: t_supplier_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1622: t_item_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1623: t_group_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1624: t_type_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1625: t_trxid1_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1626: t_trxid2_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1627: t_date1_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1628: t_date2_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1621: t_supplier_site_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1622: t_item_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1623: t_group_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1624: t_type_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1625: t_trxid1_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1626: t_trxid2_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1627: t_date1_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1628: t_date2_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1629: a_company_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1622: t_item_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1623: t_group_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1624: t_type_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1625: t_trxid1_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1626: t_trxid2_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1627: t_date1_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1628: t_date2_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1629: a_company_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1630: a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,
1623: t_group_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1624: t_type_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1625: t_trxid1_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1626: t_trxid2_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1627: t_date1_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1628: t_date2_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1629: a_company_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1630: a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,
1631: a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1624: t_type_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1625: t_trxid1_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1626: t_trxid2_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1627: t_date1_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1628: t_date2_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1629: a_company_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1630: a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,
1631: a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1632: a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,
1625: t_trxid1_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1626: t_trxid2_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1627: t_date1_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1628: t_date2_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1629: a_company_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1630: a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,
1631: a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1632: a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,
1633: a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1626: t_trxid2_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1627: t_date1_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1628: t_date2_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1629: a_company_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1630: a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,
1631: a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1632: a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,
1633: a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1634: a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1627: t_date1_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1628: t_date2_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1629: a_company_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1630: a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,
1631: a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1632: a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,
1633: a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1634: a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1635: a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
1628: t_date2_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1629: a_company_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1630: a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,
1631: a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1632: a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,
1633: a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1634: a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1635: a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
1636: a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1629: a_company_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1630: a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,
1631: a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1632: a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,
1633: a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1634: a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1635: a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
1636: a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1637: a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
1630: a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,
1631: a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1632: a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,
1633: a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1634: a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1635: a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
1636: a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1637: a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
1638: a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1631: a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1632: a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,
1633: a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1634: a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1635: a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
1636: a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1637: a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
1638: a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1639: a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
1632: a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,
1633: a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1634: a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1635: a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
1636: a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1637: a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
1638: a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1639: a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
1640: a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1633: a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1634: a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1635: a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
1636: a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1637: a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
1638: a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1639: a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
1640: a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1641: a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1634: a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1635: a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
1636: a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1637: a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
1638: a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1639: a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
1640: a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1641: a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1642: a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1635: a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,
1636: a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1637: a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
1638: a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1639: a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
1640: a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1641: a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1642: a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1643: a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
1636: a_exception_type IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1637: a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
1638: a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1639: a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
1640: a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1641: a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1642: a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1643: a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
1644: a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1637: a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,
1638: a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1639: a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
1640: a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1641: a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1642: a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1643: a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
1644: a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1645: a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
1638: a_exception_group IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1639: a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
1640: a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1641: a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1642: a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1643: a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
1644: a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1645: a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
1646: a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1639: a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,
1640: a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1641: a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1642: a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1643: a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
1644: a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1645: a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
1646: a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1647: a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1640: a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1641: a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1642: a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1643: a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
1644: a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1645: a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
1646: a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1647: a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1648: a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
1641: a_trx_id2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1642: a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1643: a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
1644: a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1645: a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
1646: a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1647: a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1648: a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
1649: a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1642: a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1643: a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
1644: a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1645: a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
1646: a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1647: a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1648: a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
1649: a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1650: a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
1643: a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,
1644: a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1645: a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
1646: a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1647: a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1648: a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
1649: a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1650: a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
1651: a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1644: a_customer_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1645: a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
1646: a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1647: a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1648: a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
1649: a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1650: a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
1651: a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1652: a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1645: a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,
1646: a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1647: a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1648: a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
1649: a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1650: a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
1651: a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1652: a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1653: a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1646: a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1647: a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1648: a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
1649: a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1650: a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
1651: a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1652: a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1653: a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1654: a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1647: a_supplier_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1648: a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
1649: a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1650: a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
1651: a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1652: a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1653: a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1654: a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1655: a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1648: a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,
1649: a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1650: a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
1651: a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1652: a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1653: a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1654: a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1655: a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1656: a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1649: a_supplier_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1650: a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
1651: a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1652: a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1653: a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1654: a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1655: a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1656: a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1657: a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1650: a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,
1651: a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1652: a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1653: a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1654: a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1655: a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1656: a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1657: a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1658: a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1651: a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,
1652: a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1653: a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1654: a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1655: a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1656: a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1657: a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1658: a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1659: a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
1652: a_number1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1653: a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1654: a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1655: a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1656: a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1657: a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1658: a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1659: a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
1660: a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
1653: a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1654: a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1655: a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1656: a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1657: a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1658: a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1659: a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
1660: a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
1661: a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
1654: a_number3 IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1655: a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1656: a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1657: a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1658: a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1659: a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
1660: a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
1661: a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
1662: a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
1655: a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1656: a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1657: a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1658: a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1659: a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
1660: a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
1661: a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
1662: a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
1663: a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
1656: a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1657: a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1658: a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1659: a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
1660: a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
1661: a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
1662: a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
1663: a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
1664: a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
1657: a_item_min_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1658: a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1659: a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
1660: a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
1661: a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
1662: a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
1663: a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
1664: a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
1665: a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1658: a_item_max_qty IN OUT NOCOPY msc_x_netting_pkg.number_arr,
1659: a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
1660: a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
1661: a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
1662: a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
1663: a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
1664: a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
1665: a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1666: a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1659: a_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
1660: a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
1661: a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
1662: a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
1663: a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
1664: a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
1665: a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1666: a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1667: a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1660: a_release_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
1661: a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
1662: a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
1663: a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
1664: a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
1665: a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1666: a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1667: a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1668: a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1661: a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
1662: a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
1663: a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
1664: a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
1665: a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1666: a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1667: a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1668: a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1669: a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1662: a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,
1663: a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
1664: a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
1665: a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1666: a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1667: a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1668: a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1669: a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1670: a_date4 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1663: a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,
1664: a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
1665: a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1666: a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1667: a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1668: a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1669: a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1670: a_date4 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1671: a_date5 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1664: a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,
1665: a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1666: a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1667: a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1668: a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1669: a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1670: a_date4 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1671: a_date5 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1672: a_exception_basis IN OUT NOCOPY msc_x_netting_pkg.exceptbasisList) IS
1665: a_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1666: a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1667: a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1668: a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1669: a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1670: a_date4 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1671: a_date5 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1672: a_exception_basis IN OUT NOCOPY msc_x_netting_pkg.exceptbasisList) IS
1673:
1666: a_tp_creation_date IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1667: a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1668: a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1669: a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1670: a_date4 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1671: a_date5 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1672: a_exception_basis IN OUT NOCOPY msc_x_netting_pkg.exceptbasisList) IS
1673:
1674:
1667: a_date1 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1668: a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1669: a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1670: a_date4 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1671: a_date5 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1672: a_exception_basis IN OUT NOCOPY msc_x_netting_pkg.exceptbasisList) IS
1673:
1674:
1675:
1668: a_date2 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1669: a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1670: a_date4 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1671: a_date5 IN OUT NOCOPY msc_x_netting_pkg.date_arr,
1672: a_exception_basis IN OUT NOCOPY msc_x_netting_pkg.exceptbasisList) IS
1673:
1674:
1675:
1676: b_pegged_trx_id msc_x_netting_pkg.number_arr;
1672: a_exception_basis IN OUT NOCOPY msc_x_netting_pkg.exceptbasisList) IS
1673:
1674:
1675:
1676: b_pegged_trx_id msc_x_netting_pkg.number_arr;
1677: b_order_type msc_x_netting_pkg.number_arr;
1678: b_po_trx_id msc_x_netting_pkg.number_arr;
1679: b_source_trx_id msc_x_netting_pkg.number_arr;
1680: b_threshold msc_x_netting_pkg.number_arr;
1673:
1674:
1675:
1676: b_pegged_trx_id msc_x_netting_pkg.number_arr;
1677: b_order_type msc_x_netting_pkg.number_arr;
1678: b_po_trx_id msc_x_netting_pkg.number_arr;
1679: b_source_trx_id msc_x_netting_pkg.number_arr;
1680: b_threshold msc_x_netting_pkg.number_arr;
1681: b_company_id msc_x_netting_pkg.number_arr;
1674:
1675:
1676: b_pegged_trx_id msc_x_netting_pkg.number_arr;
1677: b_order_type msc_x_netting_pkg.number_arr;
1678: b_po_trx_id msc_x_netting_pkg.number_arr;
1679: b_source_trx_id msc_x_netting_pkg.number_arr;
1680: b_threshold msc_x_netting_pkg.number_arr;
1681: b_company_id msc_x_netting_pkg.number_arr;
1682: b_organization_id msc_x_netting_pkg.number_arr;
1675:
1676: b_pegged_trx_id msc_x_netting_pkg.number_arr;
1677: b_order_type msc_x_netting_pkg.number_arr;
1678: b_po_trx_id msc_x_netting_pkg.number_arr;
1679: b_source_trx_id msc_x_netting_pkg.number_arr;
1680: b_threshold msc_x_netting_pkg.number_arr;
1681: b_company_id msc_x_netting_pkg.number_arr;
1682: b_organization_id msc_x_netting_pkg.number_arr;
1683: b_trx_id1 msc_x_netting_pkg.number_arr;
1676: b_pegged_trx_id msc_x_netting_pkg.number_arr;
1677: b_order_type msc_x_netting_pkg.number_arr;
1678: b_po_trx_id msc_x_netting_pkg.number_arr;
1679: b_source_trx_id msc_x_netting_pkg.number_arr;
1680: b_threshold msc_x_netting_pkg.number_arr;
1681: b_company_id msc_x_netting_pkg.number_arr;
1682: b_organization_id msc_x_netting_pkg.number_arr;
1683: b_trx_id1 msc_x_netting_pkg.number_arr;
1684: b_trx_id2 msc_x_netting_pkg.number_arr;
1677: b_order_type msc_x_netting_pkg.number_arr;
1678: b_po_trx_id msc_x_netting_pkg.number_arr;
1679: b_source_trx_id msc_x_netting_pkg.number_arr;
1680: b_threshold msc_x_netting_pkg.number_arr;
1681: b_company_id msc_x_netting_pkg.number_arr;
1682: b_organization_id msc_x_netting_pkg.number_arr;
1683: b_trx_id1 msc_x_netting_pkg.number_arr;
1684: b_trx_id2 msc_x_netting_pkg.number_arr;
1685: b_publisher_id msc_x_netting_pkg.number_arr;
1678: b_po_trx_id msc_x_netting_pkg.number_arr;
1679: b_source_trx_id msc_x_netting_pkg.number_arr;
1680: b_threshold msc_x_netting_pkg.number_arr;
1681: b_company_id msc_x_netting_pkg.number_arr;
1682: b_organization_id msc_x_netting_pkg.number_arr;
1683: b_trx_id1 msc_x_netting_pkg.number_arr;
1684: b_trx_id2 msc_x_netting_pkg.number_arr;
1685: b_publisher_id msc_x_netting_pkg.number_arr;
1686: b_publisher_site_id msc_x_netting_pkg.number_arr;
1679: b_source_trx_id msc_x_netting_pkg.number_arr;
1680: b_threshold msc_x_netting_pkg.number_arr;
1681: b_company_id msc_x_netting_pkg.number_arr;
1682: b_organization_id msc_x_netting_pkg.number_arr;
1683: b_trx_id1 msc_x_netting_pkg.number_arr;
1684: b_trx_id2 msc_x_netting_pkg.number_arr;
1685: b_publisher_id msc_x_netting_pkg.number_arr;
1686: b_publisher_site_id msc_x_netting_pkg.number_arr;
1687: b_item_id msc_x_netting_pkg.number_arr;
1680: b_threshold msc_x_netting_pkg.number_arr;
1681: b_company_id msc_x_netting_pkg.number_arr;
1682: b_organization_id msc_x_netting_pkg.number_arr;
1683: b_trx_id1 msc_x_netting_pkg.number_arr;
1684: b_trx_id2 msc_x_netting_pkg.number_arr;
1685: b_publisher_id msc_x_netting_pkg.number_arr;
1686: b_publisher_site_id msc_x_netting_pkg.number_arr;
1687: b_item_id msc_x_netting_pkg.number_arr;
1688: b_po_qty msc_x_netting_pkg.number_arr;
1681: b_company_id msc_x_netting_pkg.number_arr;
1682: b_organization_id msc_x_netting_pkg.number_arr;
1683: b_trx_id1 msc_x_netting_pkg.number_arr;
1684: b_trx_id2 msc_x_netting_pkg.number_arr;
1685: b_publisher_id msc_x_netting_pkg.number_arr;
1686: b_publisher_site_id msc_x_netting_pkg.number_arr;
1687: b_item_id msc_x_netting_pkg.number_arr;
1688: b_po_qty msc_x_netting_pkg.number_arr;
1689: b_so_qty msc_x_netting_pkg.number_arr;
1682: b_organization_id msc_x_netting_pkg.number_arr;
1683: b_trx_id1 msc_x_netting_pkg.number_arr;
1684: b_trx_id2 msc_x_netting_pkg.number_arr;
1685: b_publisher_id msc_x_netting_pkg.number_arr;
1686: b_publisher_site_id msc_x_netting_pkg.number_arr;
1687: b_item_id msc_x_netting_pkg.number_arr;
1688: b_po_qty msc_x_netting_pkg.number_arr;
1689: b_so_qty msc_x_netting_pkg.number_arr;
1690: b_tp_po_qty msc_x_netting_pkg.number_arr;
1683: b_trx_id1 msc_x_netting_pkg.number_arr;
1684: b_trx_id2 msc_x_netting_pkg.number_arr;
1685: b_publisher_id msc_x_netting_pkg.number_arr;
1686: b_publisher_site_id msc_x_netting_pkg.number_arr;
1687: b_item_id msc_x_netting_pkg.number_arr;
1688: b_po_qty msc_x_netting_pkg.number_arr;
1689: b_so_qty msc_x_netting_pkg.number_arr;
1690: b_tp_po_qty msc_x_netting_pkg.number_arr;
1691: b_tp_so_qty msc_x_netting_pkg.number_arr;
1684: b_trx_id2 msc_x_netting_pkg.number_arr;
1685: b_publisher_id msc_x_netting_pkg.number_arr;
1686: b_publisher_site_id msc_x_netting_pkg.number_arr;
1687: b_item_id msc_x_netting_pkg.number_arr;
1688: b_po_qty msc_x_netting_pkg.number_arr;
1689: b_so_qty msc_x_netting_pkg.number_arr;
1690: b_tp_po_qty msc_x_netting_pkg.number_arr;
1691: b_tp_so_qty msc_x_netting_pkg.number_arr;
1692: b_posting_po_qty msc_x_netting_pkg.number_arr;
1685: b_publisher_id msc_x_netting_pkg.number_arr;
1686: b_publisher_site_id msc_x_netting_pkg.number_arr;
1687: b_item_id msc_x_netting_pkg.number_arr;
1688: b_po_qty msc_x_netting_pkg.number_arr;
1689: b_so_qty msc_x_netting_pkg.number_arr;
1690: b_tp_po_qty msc_x_netting_pkg.number_arr;
1691: b_tp_so_qty msc_x_netting_pkg.number_arr;
1692: b_posting_po_qty msc_x_netting_pkg.number_arr;
1693: b_posting_so_qty msc_x_netting_pkg.number_arr;
1686: b_publisher_site_id msc_x_netting_pkg.number_arr;
1687: b_item_id msc_x_netting_pkg.number_arr;
1688: b_po_qty msc_x_netting_pkg.number_arr;
1689: b_so_qty msc_x_netting_pkg.number_arr;
1690: b_tp_po_qty msc_x_netting_pkg.number_arr;
1691: b_tp_so_qty msc_x_netting_pkg.number_arr;
1692: b_posting_po_qty msc_x_netting_pkg.number_arr;
1693: b_posting_so_qty msc_x_netting_pkg.number_arr;
1694: b_customer_id msc_x_netting_pkg.number_arr;
1687: b_item_id msc_x_netting_pkg.number_arr;
1688: b_po_qty msc_x_netting_pkg.number_arr;
1689: b_so_qty msc_x_netting_pkg.number_arr;
1690: b_tp_po_qty msc_x_netting_pkg.number_arr;
1691: b_tp_so_qty msc_x_netting_pkg.number_arr;
1692: b_posting_po_qty msc_x_netting_pkg.number_arr;
1693: b_posting_so_qty msc_x_netting_pkg.number_arr;
1694: b_customer_id msc_x_netting_pkg.number_arr;
1695: b_customer_site_id msc_x_netting_pkg.number_arr;
1688: b_po_qty msc_x_netting_pkg.number_arr;
1689: b_so_qty msc_x_netting_pkg.number_arr;
1690: b_tp_po_qty msc_x_netting_pkg.number_arr;
1691: b_tp_so_qty msc_x_netting_pkg.number_arr;
1692: b_posting_po_qty msc_x_netting_pkg.number_arr;
1693: b_posting_so_qty msc_x_netting_pkg.number_arr;
1694: b_customer_id msc_x_netting_pkg.number_arr;
1695: b_customer_site_id msc_x_netting_pkg.number_arr;
1696: b_supplier_id msc_x_netting_pkg.number_arr;
1689: b_so_qty msc_x_netting_pkg.number_arr;
1690: b_tp_po_qty msc_x_netting_pkg.number_arr;
1691: b_tp_so_qty msc_x_netting_pkg.number_arr;
1692: b_posting_po_qty msc_x_netting_pkg.number_arr;
1693: b_posting_so_qty msc_x_netting_pkg.number_arr;
1694: b_customer_id msc_x_netting_pkg.number_arr;
1695: b_customer_site_id msc_x_netting_pkg.number_arr;
1696: b_supplier_id msc_x_netting_pkg.number_arr;
1697: b_supplier_site_id msc_x_netting_pkg.number_arr;
1690: b_tp_po_qty msc_x_netting_pkg.number_arr;
1691: b_tp_so_qty msc_x_netting_pkg.number_arr;
1692: b_posting_po_qty msc_x_netting_pkg.number_arr;
1693: b_posting_so_qty msc_x_netting_pkg.number_arr;
1694: b_customer_id msc_x_netting_pkg.number_arr;
1695: b_customer_site_id msc_x_netting_pkg.number_arr;
1696: b_supplier_id msc_x_netting_pkg.number_arr;
1697: b_supplier_site_id msc_x_netting_pkg.number_arr;
1698: b_first_supplier_id msc_x_netting_pkg.number_arr;
1691: b_tp_so_qty msc_x_netting_pkg.number_arr;
1692: b_posting_po_qty msc_x_netting_pkg.number_arr;
1693: b_posting_so_qty msc_x_netting_pkg.number_arr;
1694: b_customer_id msc_x_netting_pkg.number_arr;
1695: b_customer_site_id msc_x_netting_pkg.number_arr;
1696: b_supplier_id msc_x_netting_pkg.number_arr;
1697: b_supplier_site_id msc_x_netting_pkg.number_arr;
1698: b_first_supplier_id msc_x_netting_pkg.number_arr;
1699: b_first_supplier_site_id msc_x_netting_pkg.number_arr;
1692: b_posting_po_qty msc_x_netting_pkg.number_arr;
1693: b_posting_so_qty msc_x_netting_pkg.number_arr;
1694: b_customer_id msc_x_netting_pkg.number_arr;
1695: b_customer_site_id msc_x_netting_pkg.number_arr;
1696: b_supplier_id msc_x_netting_pkg.number_arr;
1697: b_supplier_site_id msc_x_netting_pkg.number_arr;
1698: b_first_supplier_id msc_x_netting_pkg.number_arr;
1699: b_first_supplier_site_id msc_x_netting_pkg.number_arr;
1700: b_last_publisher_id msc_x_netting_pkg.number_arr;
1693: b_posting_so_qty msc_x_netting_pkg.number_arr;
1694: b_customer_id msc_x_netting_pkg.number_arr;
1695: b_customer_site_id msc_x_netting_pkg.number_arr;
1696: b_supplier_id msc_x_netting_pkg.number_arr;
1697: b_supplier_site_id msc_x_netting_pkg.number_arr;
1698: b_first_supplier_id msc_x_netting_pkg.number_arr;
1699: b_first_supplier_site_id msc_x_netting_pkg.number_arr;
1700: b_last_publisher_id msc_x_netting_pkg.number_arr;
1701: b_last_publisher_site_id msc_x_netting_pkg.number_arr;
1694: b_customer_id msc_x_netting_pkg.number_arr;
1695: b_customer_site_id msc_x_netting_pkg.number_arr;
1696: b_supplier_id msc_x_netting_pkg.number_arr;
1697: b_supplier_site_id msc_x_netting_pkg.number_arr;
1698: b_first_supplier_id msc_x_netting_pkg.number_arr;
1699: b_first_supplier_site_id msc_x_netting_pkg.number_arr;
1700: b_last_publisher_id msc_x_netting_pkg.number_arr;
1701: b_last_publisher_site_id msc_x_netting_pkg.number_arr;
1702: b_lead_time msc_x_netting_pkg.number_arr;
1695: b_customer_site_id msc_x_netting_pkg.number_arr;
1696: b_supplier_id msc_x_netting_pkg.number_arr;
1697: b_supplier_site_id msc_x_netting_pkg.number_arr;
1698: b_first_supplier_id msc_x_netting_pkg.number_arr;
1699: b_first_supplier_site_id msc_x_netting_pkg.number_arr;
1700: b_last_publisher_id msc_x_netting_pkg.number_arr;
1701: b_last_publisher_site_id msc_x_netting_pkg.number_arr;
1702: b_lead_time msc_x_netting_pkg.number_arr;
1703: b_po_key_date msc_x_netting_pkg.date_arr;
1696: b_supplier_id msc_x_netting_pkg.number_arr;
1697: b_supplier_site_id msc_x_netting_pkg.number_arr;
1698: b_first_supplier_id msc_x_netting_pkg.number_arr;
1699: b_first_supplier_site_id msc_x_netting_pkg.number_arr;
1700: b_last_publisher_id msc_x_netting_pkg.number_arr;
1701: b_last_publisher_site_id msc_x_netting_pkg.number_arr;
1702: b_lead_time msc_x_netting_pkg.number_arr;
1703: b_po_key_date msc_x_netting_pkg.date_arr;
1704: b_so_key_date msc_x_netting_pkg.date_arr;
1697: b_supplier_site_id msc_x_netting_pkg.number_arr;
1698: b_first_supplier_id msc_x_netting_pkg.number_arr;
1699: b_first_supplier_site_id msc_x_netting_pkg.number_arr;
1700: b_last_publisher_id msc_x_netting_pkg.number_arr;
1701: b_last_publisher_site_id msc_x_netting_pkg.number_arr;
1702: b_lead_time msc_x_netting_pkg.number_arr;
1703: b_po_key_date msc_x_netting_pkg.date_arr;
1704: b_so_key_date msc_x_netting_pkg.date_arr;
1705: b_po_receipt_date msc_x_netting_pkg.date_arr;
1698: b_first_supplier_id msc_x_netting_pkg.number_arr;
1699: b_first_supplier_site_id msc_x_netting_pkg.number_arr;
1700: b_last_publisher_id msc_x_netting_pkg.number_arr;
1701: b_last_publisher_site_id msc_x_netting_pkg.number_arr;
1702: b_lead_time msc_x_netting_pkg.number_arr;
1703: b_po_key_date msc_x_netting_pkg.date_arr;
1704: b_so_key_date msc_x_netting_pkg.date_arr;
1705: b_po_receipt_date msc_x_netting_pkg.date_arr;
1706: b_so_receipt_date msc_x_netting_pkg.date_arr;
1699: b_first_supplier_site_id msc_x_netting_pkg.number_arr;
1700: b_last_publisher_id msc_x_netting_pkg.number_arr;
1701: b_last_publisher_site_id msc_x_netting_pkg.number_arr;
1702: b_lead_time msc_x_netting_pkg.number_arr;
1703: b_po_key_date msc_x_netting_pkg.date_arr;
1704: b_so_key_date msc_x_netting_pkg.date_arr;
1705: b_po_receipt_date msc_x_netting_pkg.date_arr;
1706: b_so_receipt_date msc_x_netting_pkg.date_arr;
1707: b_po_ship_date msc_x_netting_pkg.date_arr;
1700: b_last_publisher_id msc_x_netting_pkg.number_arr;
1701: b_last_publisher_site_id msc_x_netting_pkg.number_arr;
1702: b_lead_time msc_x_netting_pkg.number_arr;
1703: b_po_key_date msc_x_netting_pkg.date_arr;
1704: b_so_key_date msc_x_netting_pkg.date_arr;
1705: b_po_receipt_date msc_x_netting_pkg.date_arr;
1706: b_so_receipt_date msc_x_netting_pkg.date_arr;
1707: b_po_ship_date msc_x_netting_pkg.date_arr;
1708: b_so_ship_date msc_x_netting_pkg.date_arr;
1701: b_last_publisher_site_id msc_x_netting_pkg.number_arr;
1702: b_lead_time msc_x_netting_pkg.number_arr;
1703: b_po_key_date msc_x_netting_pkg.date_arr;
1704: b_so_key_date msc_x_netting_pkg.date_arr;
1705: b_po_receipt_date msc_x_netting_pkg.date_arr;
1706: b_so_receipt_date msc_x_netting_pkg.date_arr;
1707: b_po_ship_date msc_x_netting_pkg.date_arr;
1708: b_so_ship_date msc_x_netting_pkg.date_arr;
1709: b_po_creation_date msc_x_netting_pkg.date_arr;
1702: b_lead_time msc_x_netting_pkg.number_arr;
1703: b_po_key_date msc_x_netting_pkg.date_arr;
1704: b_so_key_date msc_x_netting_pkg.date_arr;
1705: b_po_receipt_date msc_x_netting_pkg.date_arr;
1706: b_so_receipt_date msc_x_netting_pkg.date_arr;
1707: b_po_ship_date msc_x_netting_pkg.date_arr;
1708: b_so_ship_date msc_x_netting_pkg.date_arr;
1709: b_po_creation_date msc_x_netting_pkg.date_arr;
1710: b_so_creation_date msc_x_netting_pkg.date_arr;
1703: b_po_key_date msc_x_netting_pkg.date_arr;
1704: b_so_key_date msc_x_netting_pkg.date_arr;
1705: b_po_receipt_date msc_x_netting_pkg.date_arr;
1706: b_so_receipt_date msc_x_netting_pkg.date_arr;
1707: b_po_ship_date msc_x_netting_pkg.date_arr;
1708: b_so_ship_date msc_x_netting_pkg.date_arr;
1709: b_po_creation_date msc_x_netting_pkg.date_arr;
1710: b_so_creation_date msc_x_netting_pkg.date_arr;
1711: b_first_po_key_date msc_x_netting_pkg.date_arr;
1704: b_so_key_date msc_x_netting_pkg.date_arr;
1705: b_po_receipt_date msc_x_netting_pkg.date_arr;
1706: b_so_receipt_date msc_x_netting_pkg.date_arr;
1707: b_po_ship_date msc_x_netting_pkg.date_arr;
1708: b_so_ship_date msc_x_netting_pkg.date_arr;
1709: b_po_creation_date msc_x_netting_pkg.date_arr;
1710: b_so_creation_date msc_x_netting_pkg.date_arr;
1711: b_first_po_key_date msc_x_netting_pkg.date_arr;
1712: b_first_po_ship_date msc_x_netting_pkg.date_arr;
1705: b_po_receipt_date msc_x_netting_pkg.date_arr;
1706: b_so_receipt_date msc_x_netting_pkg.date_arr;
1707: b_po_ship_date msc_x_netting_pkg.date_arr;
1708: b_so_ship_date msc_x_netting_pkg.date_arr;
1709: b_po_creation_date msc_x_netting_pkg.date_arr;
1710: b_so_creation_date msc_x_netting_pkg.date_arr;
1711: b_first_po_key_date msc_x_netting_pkg.date_arr;
1712: b_first_po_ship_date msc_x_netting_pkg.date_arr;
1713: b_first_po_receipt_date msc_x_netting_pkg.date_arr;
1706: b_so_receipt_date msc_x_netting_pkg.date_arr;
1707: b_po_ship_date msc_x_netting_pkg.date_arr;
1708: b_so_ship_date msc_x_netting_pkg.date_arr;
1709: b_po_creation_date msc_x_netting_pkg.date_arr;
1710: b_so_creation_date msc_x_netting_pkg.date_arr;
1711: b_first_po_key_date msc_x_netting_pkg.date_arr;
1712: b_first_po_ship_date msc_x_netting_pkg.date_arr;
1713: b_first_po_receipt_date msc_x_netting_pkg.date_arr;
1714: b_key_date msc_x_netting_pkg.date_arr;
1707: b_po_ship_date msc_x_netting_pkg.date_arr;
1708: b_so_ship_date msc_x_netting_pkg.date_arr;
1709: b_po_creation_date msc_x_netting_pkg.date_arr;
1710: b_so_creation_date msc_x_netting_pkg.date_arr;
1711: b_first_po_key_date msc_x_netting_pkg.date_arr;
1712: b_first_po_ship_date msc_x_netting_pkg.date_arr;
1713: b_first_po_receipt_date msc_x_netting_pkg.date_arr;
1714: b_key_date msc_x_netting_pkg.date_arr;
1715: b_item_name msc_x_netting_pkg.itemnameList;
1708: b_so_ship_date msc_x_netting_pkg.date_arr;
1709: b_po_creation_date msc_x_netting_pkg.date_arr;
1710: b_so_creation_date msc_x_netting_pkg.date_arr;
1711: b_first_po_key_date msc_x_netting_pkg.date_arr;
1712: b_first_po_ship_date msc_x_netting_pkg.date_arr;
1713: b_first_po_receipt_date msc_x_netting_pkg.date_arr;
1714: b_key_date msc_x_netting_pkg.date_arr;
1715: b_item_name msc_x_netting_pkg.itemnameList;
1716: b_item_desc msc_x_netting_pkg.itemdescList;
1709: b_po_creation_date msc_x_netting_pkg.date_arr;
1710: b_so_creation_date msc_x_netting_pkg.date_arr;
1711: b_first_po_key_date msc_x_netting_pkg.date_arr;
1712: b_first_po_ship_date msc_x_netting_pkg.date_arr;
1713: b_first_po_receipt_date msc_x_netting_pkg.date_arr;
1714: b_key_date msc_x_netting_pkg.date_arr;
1715: b_item_name msc_x_netting_pkg.itemnameList;
1716: b_item_desc msc_x_netting_pkg.itemdescList;
1717: b_publisher_name msc_x_netting_pkg.publisherList;
1710: b_so_creation_date msc_x_netting_pkg.date_arr;
1711: b_first_po_key_date msc_x_netting_pkg.date_arr;
1712: b_first_po_ship_date msc_x_netting_pkg.date_arr;
1713: b_first_po_receipt_date msc_x_netting_pkg.date_arr;
1714: b_key_date msc_x_netting_pkg.date_arr;
1715: b_item_name msc_x_netting_pkg.itemnameList;
1716: b_item_desc msc_x_netting_pkg.itemdescList;
1717: b_publisher_name msc_x_netting_pkg.publisherList;
1718: b_publisher_site_name msc_x_netting_pkg.pubsiteList;
1711: b_first_po_key_date msc_x_netting_pkg.date_arr;
1712: b_first_po_ship_date msc_x_netting_pkg.date_arr;
1713: b_first_po_receipt_date msc_x_netting_pkg.date_arr;
1714: b_key_date msc_x_netting_pkg.date_arr;
1715: b_item_name msc_x_netting_pkg.itemnameList;
1716: b_item_desc msc_x_netting_pkg.itemdescList;
1717: b_publisher_name msc_x_netting_pkg.publisherList;
1718: b_publisher_site_name msc_x_netting_pkg.pubsiteList;
1719: b_supplier_name msc_x_netting_pkg.supplierList;
1712: b_first_po_ship_date msc_x_netting_pkg.date_arr;
1713: b_first_po_receipt_date msc_x_netting_pkg.date_arr;
1714: b_key_date msc_x_netting_pkg.date_arr;
1715: b_item_name msc_x_netting_pkg.itemnameList;
1716: b_item_desc msc_x_netting_pkg.itemdescList;
1717: b_publisher_name msc_x_netting_pkg.publisherList;
1718: b_publisher_site_name msc_x_netting_pkg.pubsiteList;
1719: b_supplier_name msc_x_netting_pkg.supplierList;
1720: b_supplier_site_name msc_x_netting_pkg.suppsiteList;
1713: b_first_po_receipt_date msc_x_netting_pkg.date_arr;
1714: b_key_date msc_x_netting_pkg.date_arr;
1715: b_item_name msc_x_netting_pkg.itemnameList;
1716: b_item_desc msc_x_netting_pkg.itemdescList;
1717: b_publisher_name msc_x_netting_pkg.publisherList;
1718: b_publisher_site_name msc_x_netting_pkg.pubsiteList;
1719: b_supplier_name msc_x_netting_pkg.supplierList;
1720: b_supplier_site_name msc_x_netting_pkg.suppsiteList;
1721: b_supplier_item_name msc_x_netting_pkg.itemnameList;
1714: b_key_date msc_x_netting_pkg.date_arr;
1715: b_item_name msc_x_netting_pkg.itemnameList;
1716: b_item_desc msc_x_netting_pkg.itemdescList;
1717: b_publisher_name msc_x_netting_pkg.publisherList;
1718: b_publisher_site_name msc_x_netting_pkg.pubsiteList;
1719: b_supplier_name msc_x_netting_pkg.supplierList;
1720: b_supplier_site_name msc_x_netting_pkg.suppsiteList;
1721: b_supplier_item_name msc_x_netting_pkg.itemnameList;
1722: b_supplier_item_desc msc_x_netting_pkg.itemdescList;
1715: b_item_name msc_x_netting_pkg.itemnameList;
1716: b_item_desc msc_x_netting_pkg.itemdescList;
1717: b_publisher_name msc_x_netting_pkg.publisherList;
1718: b_publisher_site_name msc_x_netting_pkg.pubsiteList;
1719: b_supplier_name msc_x_netting_pkg.supplierList;
1720: b_supplier_site_name msc_x_netting_pkg.suppsiteList;
1721: b_supplier_item_name msc_x_netting_pkg.itemnameList;
1722: b_supplier_item_desc msc_x_netting_pkg.itemdescList;
1723: b_customer_name msc_x_netting_pkg.customerList;
1716: b_item_desc msc_x_netting_pkg.itemdescList;
1717: b_publisher_name msc_x_netting_pkg.publisherList;
1718: b_publisher_site_name msc_x_netting_pkg.pubsiteList;
1719: b_supplier_name msc_x_netting_pkg.supplierList;
1720: b_supplier_site_name msc_x_netting_pkg.suppsiteList;
1721: b_supplier_item_name msc_x_netting_pkg.itemnameList;
1722: b_supplier_item_desc msc_x_netting_pkg.itemdescList;
1723: b_customer_name msc_x_netting_pkg.customerList;
1724: b_customer_site_name msc_x_netting_pkg.custsiteList;
1717: b_publisher_name msc_x_netting_pkg.publisherList;
1718: b_publisher_site_name msc_x_netting_pkg.pubsiteList;
1719: b_supplier_name msc_x_netting_pkg.supplierList;
1720: b_supplier_site_name msc_x_netting_pkg.suppsiteList;
1721: b_supplier_item_name msc_x_netting_pkg.itemnameList;
1722: b_supplier_item_desc msc_x_netting_pkg.itemdescList;
1723: b_customer_name msc_x_netting_pkg.customerList;
1724: b_customer_site_name msc_x_netting_pkg.custsiteList;
1725: b_customer_item_name msc_x_netting_pkg.itemnameList;
1718: b_publisher_site_name msc_x_netting_pkg.pubsiteList;
1719: b_supplier_name msc_x_netting_pkg.supplierList;
1720: b_supplier_site_name msc_x_netting_pkg.suppsiteList;
1721: b_supplier_item_name msc_x_netting_pkg.itemnameList;
1722: b_supplier_item_desc msc_x_netting_pkg.itemdescList;
1723: b_customer_name msc_x_netting_pkg.customerList;
1724: b_customer_site_name msc_x_netting_pkg.custsiteList;
1725: b_customer_item_name msc_x_netting_pkg.itemnameList;
1726: b_customer_item_desc msc_x_netting_pkg.itemdescList;
1719: b_supplier_name msc_x_netting_pkg.supplierList;
1720: b_supplier_site_name msc_x_netting_pkg.suppsiteList;
1721: b_supplier_item_name msc_x_netting_pkg.itemnameList;
1722: b_supplier_item_desc msc_x_netting_pkg.itemdescList;
1723: b_customer_name msc_x_netting_pkg.customerList;
1724: b_customer_site_name msc_x_netting_pkg.custsiteList;
1725: b_customer_item_name msc_x_netting_pkg.itemnameList;
1726: b_customer_item_desc msc_x_netting_pkg.itemdescList;
1727: b_first_supplier_name msc_x_netting_pkg.supplierList;
1720: b_supplier_site_name msc_x_netting_pkg.suppsiteList;
1721: b_supplier_item_name msc_x_netting_pkg.itemnameList;
1722: b_supplier_item_desc msc_x_netting_pkg.itemdescList;
1723: b_customer_name msc_x_netting_pkg.customerList;
1724: b_customer_site_name msc_x_netting_pkg.custsiteList;
1725: b_customer_item_name msc_x_netting_pkg.itemnameList;
1726: b_customer_item_desc msc_x_netting_pkg.itemdescList;
1727: b_first_supplier_name msc_x_netting_pkg.supplierList;
1728: b_first_supplier_site_name msc_x_netting_pkg.suppsiteList;
1721: b_supplier_item_name msc_x_netting_pkg.itemnameList;
1722: b_supplier_item_desc msc_x_netting_pkg.itemdescList;
1723: b_customer_name msc_x_netting_pkg.customerList;
1724: b_customer_site_name msc_x_netting_pkg.custsiteList;
1725: b_customer_item_name msc_x_netting_pkg.itemnameList;
1726: b_customer_item_desc msc_x_netting_pkg.itemdescList;
1727: b_first_supplier_name msc_x_netting_pkg.supplierList;
1728: b_first_supplier_site_name msc_x_netting_pkg.suppsiteList;
1729: b_first_supplier_item_name msc_x_netting_pkg.itemnameList;
1722: b_supplier_item_desc msc_x_netting_pkg.itemdescList;
1723: b_customer_name msc_x_netting_pkg.customerList;
1724: b_customer_site_name msc_x_netting_pkg.custsiteList;
1725: b_customer_item_name msc_x_netting_pkg.itemnameList;
1726: b_customer_item_desc msc_x_netting_pkg.itemdescList;
1727: b_first_supplier_name msc_x_netting_pkg.supplierList;
1728: b_first_supplier_site_name msc_x_netting_pkg.suppsiteList;
1729: b_first_supplier_item_name msc_x_netting_pkg.itemnameList;
1730: b_first_supplier_item_desc msc_x_netting_pkg.itemdescList;
1723: b_customer_name msc_x_netting_pkg.customerList;
1724: b_customer_site_name msc_x_netting_pkg.custsiteList;
1725: b_customer_item_name msc_x_netting_pkg.itemnameList;
1726: b_customer_item_desc msc_x_netting_pkg.itemdescList;
1727: b_first_supplier_name msc_x_netting_pkg.supplierList;
1728: b_first_supplier_site_name msc_x_netting_pkg.suppsiteList;
1729: b_first_supplier_item_name msc_x_netting_pkg.itemnameList;
1730: b_first_supplier_item_desc msc_x_netting_pkg.itemdescList;
1731: b_exception_type_name msc_x_netting_pkg.exceptypeList;
1724: b_customer_site_name msc_x_netting_pkg.custsiteList;
1725: b_customer_item_name msc_x_netting_pkg.itemnameList;
1726: b_customer_item_desc msc_x_netting_pkg.itemdescList;
1727: b_first_supplier_name msc_x_netting_pkg.supplierList;
1728: b_first_supplier_site_name msc_x_netting_pkg.suppsiteList;
1729: b_first_supplier_item_name msc_x_netting_pkg.itemnameList;
1730: b_first_supplier_item_desc msc_x_netting_pkg.itemdescList;
1731: b_exception_type_name msc_x_netting_pkg.exceptypeList;
1732: b_order_number msc_x_netting_pkg.ordernumberList;
1725: b_customer_item_name msc_x_netting_pkg.itemnameList;
1726: b_customer_item_desc msc_x_netting_pkg.itemdescList;
1727: b_first_supplier_name msc_x_netting_pkg.supplierList;
1728: b_first_supplier_site_name msc_x_netting_pkg.suppsiteList;
1729: b_first_supplier_item_name msc_x_netting_pkg.itemnameList;
1730: b_first_supplier_item_desc msc_x_netting_pkg.itemdescList;
1731: b_exception_type_name msc_x_netting_pkg.exceptypeList;
1732: b_order_number msc_x_netting_pkg.ordernumberList;
1733: b_release_number msc_x_netting_pkg.releasenumList;
1726: b_customer_item_desc msc_x_netting_pkg.itemdescList;
1727: b_first_supplier_name msc_x_netting_pkg.supplierList;
1728: b_first_supplier_site_name msc_x_netting_pkg.suppsiteList;
1729: b_first_supplier_item_name msc_x_netting_pkg.itemnameList;
1730: b_first_supplier_item_desc msc_x_netting_pkg.itemdescList;
1731: b_exception_type_name msc_x_netting_pkg.exceptypeList;
1732: b_order_number msc_x_netting_pkg.ordernumberList;
1733: b_release_number msc_x_netting_pkg.releasenumList;
1734: b_line_number msc_x_netting_pkg.linenumList;
1727: b_first_supplier_name msc_x_netting_pkg.supplierList;
1728: b_first_supplier_site_name msc_x_netting_pkg.suppsiteList;
1729: b_first_supplier_item_name msc_x_netting_pkg.itemnameList;
1730: b_first_supplier_item_desc msc_x_netting_pkg.itemdescList;
1731: b_exception_type_name msc_x_netting_pkg.exceptypeList;
1732: b_order_number msc_x_netting_pkg.ordernumberList;
1733: b_release_number msc_x_netting_pkg.releasenumList;
1734: b_line_number msc_x_netting_pkg.linenumList;
1735: b_end_order_number msc_x_netting_pkg.ordernumberList;
1728: b_first_supplier_site_name msc_x_netting_pkg.suppsiteList;
1729: b_first_supplier_item_name msc_x_netting_pkg.itemnameList;
1730: b_first_supplier_item_desc msc_x_netting_pkg.itemdescList;
1731: b_exception_type_name msc_x_netting_pkg.exceptypeList;
1732: b_order_number msc_x_netting_pkg.ordernumberList;
1733: b_release_number msc_x_netting_pkg.releasenumList;
1734: b_line_number msc_x_netting_pkg.linenumList;
1735: b_end_order_number msc_x_netting_pkg.ordernumberList;
1736: b_end_order_rel_number msc_x_netting_pkg.releasenumList;
1729: b_first_supplier_item_name msc_x_netting_pkg.itemnameList;
1730: b_first_supplier_item_desc msc_x_netting_pkg.itemdescList;
1731: b_exception_type_name msc_x_netting_pkg.exceptypeList;
1732: b_order_number msc_x_netting_pkg.ordernumberList;
1733: b_release_number msc_x_netting_pkg.releasenumList;
1734: b_line_number msc_x_netting_pkg.linenumList;
1735: b_end_order_number msc_x_netting_pkg.ordernumberList;
1736: b_end_order_rel_number msc_x_netting_pkg.releasenumList;
1737: b_end_order_line_number msc_x_netting_pkg.linenumList;
1730: b_first_supplier_item_desc msc_x_netting_pkg.itemdescList;
1731: b_exception_type_name msc_x_netting_pkg.exceptypeList;
1732: b_order_number msc_x_netting_pkg.ordernumberList;
1733: b_release_number msc_x_netting_pkg.releasenumList;
1734: b_line_number msc_x_netting_pkg.linenumList;
1735: b_end_order_number msc_x_netting_pkg.ordernumberList;
1736: b_end_order_rel_number msc_x_netting_pkg.releasenumList;
1737: b_end_order_line_number msc_x_netting_pkg.linenumList;
1738: b_so_order_number msc_x_netting_pkg.ordernumberList;
1731: b_exception_type_name msc_x_netting_pkg.exceptypeList;
1732: b_order_number msc_x_netting_pkg.ordernumberList;
1733: b_release_number msc_x_netting_pkg.releasenumList;
1734: b_line_number msc_x_netting_pkg.linenumList;
1735: b_end_order_number msc_x_netting_pkg.ordernumberList;
1736: b_end_order_rel_number msc_x_netting_pkg.releasenumList;
1737: b_end_order_line_number msc_x_netting_pkg.linenumList;
1738: b_so_order_number msc_x_netting_pkg.ordernumberList;
1739: b_so_release_number msc_x_netting_pkg.releasenumList;
1732: b_order_number msc_x_netting_pkg.ordernumberList;
1733: b_release_number msc_x_netting_pkg.releasenumList;
1734: b_line_number msc_x_netting_pkg.linenumList;
1735: b_end_order_number msc_x_netting_pkg.ordernumberList;
1736: b_end_order_rel_number msc_x_netting_pkg.releasenumList;
1737: b_end_order_line_number msc_x_netting_pkg.linenumList;
1738: b_so_order_number msc_x_netting_pkg.ordernumberList;
1739: b_so_release_number msc_x_netting_pkg.releasenumList;
1740: b_so_line_number msc_x_netting_pkg.linenumList;
1733: b_release_number msc_x_netting_pkg.releasenumList;
1734: b_line_number msc_x_netting_pkg.linenumList;
1735: b_end_order_number msc_x_netting_pkg.ordernumberList;
1736: b_end_order_rel_number msc_x_netting_pkg.releasenumList;
1737: b_end_order_line_number msc_x_netting_pkg.linenumList;
1738: b_so_order_number msc_x_netting_pkg.ordernumberList;
1739: b_so_release_number msc_x_netting_pkg.releasenumList;
1740: b_so_line_number msc_x_netting_pkg.linenumList;
1741:
1734: b_line_number msc_x_netting_pkg.linenumList;
1735: b_end_order_number msc_x_netting_pkg.ordernumberList;
1736: b_end_order_rel_number msc_x_netting_pkg.releasenumList;
1737: b_end_order_line_number msc_x_netting_pkg.linenumList;
1738: b_so_order_number msc_x_netting_pkg.ordernumberList;
1739: b_so_release_number msc_x_netting_pkg.releasenumList;
1740: b_so_line_number msc_x_netting_pkg.linenumList;
1741:
1742:
1735: b_end_order_number msc_x_netting_pkg.ordernumberList;
1736: b_end_order_rel_number msc_x_netting_pkg.releasenumList;
1737: b_end_order_line_number msc_x_netting_pkg.linenumList;
1738: b_so_order_number msc_x_netting_pkg.ordernumberList;
1739: b_so_release_number msc_x_netting_pkg.releasenumList;
1740: b_so_line_number msc_x_netting_pkg.linenumList;
1741:
1742:
1743: l_exception_count Number;
1736: b_end_order_rel_number msc_x_netting_pkg.releasenumList;
1737: b_end_order_line_number msc_x_netting_pkg.linenumList;
1738: b_so_order_number msc_x_netting_pkg.ordernumberList;
1739: b_so_release_number msc_x_netting_pkg.releasenumList;
1740: b_so_line_number msc_x_netting_pkg.linenumList;
1741:
1742:
1743: l_exception_count Number;
1744: l_exception_type Number;
1763: l_count Number;
1764: i number;
1765:
1766:
1767: k_so_trx_id msc_x_netting_pkg.number_arr;
1768: k_item_id msc_x_netting_pkg.number_arr;
1769: k_posting_so_qty msc_x_netting_pkg.number_arr;
1770: k_so_qty msc_x_netting_pkg.number_arr;
1771: k_tp_qty msc_x_netting_pkg.number_arr;
1764: i number;
1765:
1766:
1767: k_so_trx_id msc_x_netting_pkg.number_arr;
1768: k_item_id msc_x_netting_pkg.number_arr;
1769: k_posting_so_qty msc_x_netting_pkg.number_arr;
1770: k_so_qty msc_x_netting_pkg.number_arr;
1771: k_tp_qty msc_x_netting_pkg.number_arr;
1772: k_customer_id msc_x_netting_pkg.number_arr;
1765:
1766:
1767: k_so_trx_id msc_x_netting_pkg.number_arr;
1768: k_item_id msc_x_netting_pkg.number_arr;
1769: k_posting_so_qty msc_x_netting_pkg.number_arr;
1770: k_so_qty msc_x_netting_pkg.number_arr;
1771: k_tp_qty msc_x_netting_pkg.number_arr;
1772: k_customer_id msc_x_netting_pkg.number_arr;
1773: k_customer_site_id msc_x_netting_pkg.number_arr;
1766:
1767: k_so_trx_id msc_x_netting_pkg.number_arr;
1768: k_item_id msc_x_netting_pkg.number_arr;
1769: k_posting_so_qty msc_x_netting_pkg.number_arr;
1770: k_so_qty msc_x_netting_pkg.number_arr;
1771: k_tp_qty msc_x_netting_pkg.number_arr;
1772: k_customer_id msc_x_netting_pkg.number_arr;
1773: k_customer_site_id msc_x_netting_pkg.number_arr;
1774: k_supplier_id msc_x_netting_pkg.number_arr;
1767: k_so_trx_id msc_x_netting_pkg.number_arr;
1768: k_item_id msc_x_netting_pkg.number_arr;
1769: k_posting_so_qty msc_x_netting_pkg.number_arr;
1770: k_so_qty msc_x_netting_pkg.number_arr;
1771: k_tp_qty msc_x_netting_pkg.number_arr;
1772: k_customer_id msc_x_netting_pkg.number_arr;
1773: k_customer_site_id msc_x_netting_pkg.number_arr;
1774: k_supplier_id msc_x_netting_pkg.number_arr;
1775: k_supplier_site_id msc_x_netting_pkg.number_arr;
1768: k_item_id msc_x_netting_pkg.number_arr;
1769: k_posting_so_qty msc_x_netting_pkg.number_arr;
1770: k_so_qty msc_x_netting_pkg.number_arr;
1771: k_tp_qty msc_x_netting_pkg.number_arr;
1772: k_customer_id msc_x_netting_pkg.number_arr;
1773: k_customer_site_id msc_x_netting_pkg.number_arr;
1774: k_supplier_id msc_x_netting_pkg.number_arr;
1775: k_supplier_site_id msc_x_netting_pkg.number_arr;
1776: k_po_key_date msc_x_netting_pkg.date_arr;
1769: k_posting_so_qty msc_x_netting_pkg.number_arr;
1770: k_so_qty msc_x_netting_pkg.number_arr;
1771: k_tp_qty msc_x_netting_pkg.number_arr;
1772: k_customer_id msc_x_netting_pkg.number_arr;
1773: k_customer_site_id msc_x_netting_pkg.number_arr;
1774: k_supplier_id msc_x_netting_pkg.number_arr;
1775: k_supplier_site_id msc_x_netting_pkg.number_arr;
1776: k_po_key_date msc_x_netting_pkg.date_arr;
1777: k_so_key_date msc_x_netting_pkg.date_arr;
1770: k_so_qty msc_x_netting_pkg.number_arr;
1771: k_tp_qty msc_x_netting_pkg.number_arr;
1772: k_customer_id msc_x_netting_pkg.number_arr;
1773: k_customer_site_id msc_x_netting_pkg.number_arr;
1774: k_supplier_id msc_x_netting_pkg.number_arr;
1775: k_supplier_site_id msc_x_netting_pkg.number_arr;
1776: k_po_key_date msc_x_netting_pkg.date_arr;
1777: k_so_key_date msc_x_netting_pkg.date_arr;
1778: k_po_receipt_date msc_x_netting_pkg.date_arr;
1771: k_tp_qty msc_x_netting_pkg.number_arr;
1772: k_customer_id msc_x_netting_pkg.number_arr;
1773: k_customer_site_id msc_x_netting_pkg.number_arr;
1774: k_supplier_id msc_x_netting_pkg.number_arr;
1775: k_supplier_site_id msc_x_netting_pkg.number_arr;
1776: k_po_key_date msc_x_netting_pkg.date_arr;
1777: k_so_key_date msc_x_netting_pkg.date_arr;
1778: k_po_receipt_date msc_x_netting_pkg.date_arr;
1779: k_so_receipt_date msc_x_netting_pkg.date_arr;
1772: k_customer_id msc_x_netting_pkg.number_arr;
1773: k_customer_site_id msc_x_netting_pkg.number_arr;
1774: k_supplier_id msc_x_netting_pkg.number_arr;
1775: k_supplier_site_id msc_x_netting_pkg.number_arr;
1776: k_po_key_date msc_x_netting_pkg.date_arr;
1777: k_so_key_date msc_x_netting_pkg.date_arr;
1778: k_po_receipt_date msc_x_netting_pkg.date_arr;
1779: k_so_receipt_date msc_x_netting_pkg.date_arr;
1780: k_po_ship_date msc_x_netting_pkg.date_arr;
1773: k_customer_site_id msc_x_netting_pkg.number_arr;
1774: k_supplier_id msc_x_netting_pkg.number_arr;
1775: k_supplier_site_id msc_x_netting_pkg.number_arr;
1776: k_po_key_date msc_x_netting_pkg.date_arr;
1777: k_so_key_date msc_x_netting_pkg.date_arr;
1778: k_po_receipt_date msc_x_netting_pkg.date_arr;
1779: k_so_receipt_date msc_x_netting_pkg.date_arr;
1780: k_po_ship_date msc_x_netting_pkg.date_arr;
1781: k_so_ship_date msc_x_netting_pkg.date_arr;
1774: k_supplier_id msc_x_netting_pkg.number_arr;
1775: k_supplier_site_id msc_x_netting_pkg.number_arr;
1776: k_po_key_date msc_x_netting_pkg.date_arr;
1777: k_so_key_date msc_x_netting_pkg.date_arr;
1778: k_po_receipt_date msc_x_netting_pkg.date_arr;
1779: k_so_receipt_date msc_x_netting_pkg.date_arr;
1780: k_po_ship_date msc_x_netting_pkg.date_arr;
1781: k_so_ship_date msc_x_netting_pkg.date_arr;
1782: k_po_creation_date msc_x_netting_pkg.date_arr;
1775: k_supplier_site_id msc_x_netting_pkg.number_arr;
1776: k_po_key_date msc_x_netting_pkg.date_arr;
1777: k_so_key_date msc_x_netting_pkg.date_arr;
1778: k_po_receipt_date msc_x_netting_pkg.date_arr;
1779: k_so_receipt_date msc_x_netting_pkg.date_arr;
1780: k_po_ship_date msc_x_netting_pkg.date_arr;
1781: k_so_ship_date msc_x_netting_pkg.date_arr;
1782: k_po_creation_date msc_x_netting_pkg.date_arr;
1783: k_so_creation_date msc_x_netting_pkg.date_arr;
1776: k_po_key_date msc_x_netting_pkg.date_arr;
1777: k_so_key_date msc_x_netting_pkg.date_arr;
1778: k_po_receipt_date msc_x_netting_pkg.date_arr;
1779: k_so_receipt_date msc_x_netting_pkg.date_arr;
1780: k_po_ship_date msc_x_netting_pkg.date_arr;
1781: k_so_ship_date msc_x_netting_pkg.date_arr;
1782: k_po_creation_date msc_x_netting_pkg.date_arr;
1783: k_so_creation_date msc_x_netting_pkg.date_arr;
1784: k_item_name msc_x_netting_pkg.itemnameList;
1777: k_so_key_date msc_x_netting_pkg.date_arr;
1778: k_po_receipt_date msc_x_netting_pkg.date_arr;
1779: k_so_receipt_date msc_x_netting_pkg.date_arr;
1780: k_po_ship_date msc_x_netting_pkg.date_arr;
1781: k_so_ship_date msc_x_netting_pkg.date_arr;
1782: k_po_creation_date msc_x_netting_pkg.date_arr;
1783: k_so_creation_date msc_x_netting_pkg.date_arr;
1784: k_item_name msc_x_netting_pkg.itemnameList;
1785: k_item_desc msc_x_netting_pkg.itemdescList;
1778: k_po_receipt_date msc_x_netting_pkg.date_arr;
1779: k_so_receipt_date msc_x_netting_pkg.date_arr;
1780: k_po_ship_date msc_x_netting_pkg.date_arr;
1781: k_so_ship_date msc_x_netting_pkg.date_arr;
1782: k_po_creation_date msc_x_netting_pkg.date_arr;
1783: k_so_creation_date msc_x_netting_pkg.date_arr;
1784: k_item_name msc_x_netting_pkg.itemnameList;
1785: k_item_desc msc_x_netting_pkg.itemdescList;
1786: k_supplier_name msc_x_netting_pkg.supplierList;
1779: k_so_receipt_date msc_x_netting_pkg.date_arr;
1780: k_po_ship_date msc_x_netting_pkg.date_arr;
1781: k_so_ship_date msc_x_netting_pkg.date_arr;
1782: k_po_creation_date msc_x_netting_pkg.date_arr;
1783: k_so_creation_date msc_x_netting_pkg.date_arr;
1784: k_item_name msc_x_netting_pkg.itemnameList;
1785: k_item_desc msc_x_netting_pkg.itemdescList;
1786: k_supplier_name msc_x_netting_pkg.supplierList;
1787: k_supplier_site_name msc_x_netting_pkg.suppsiteList;
1780: k_po_ship_date msc_x_netting_pkg.date_arr;
1781: k_so_ship_date msc_x_netting_pkg.date_arr;
1782: k_po_creation_date msc_x_netting_pkg.date_arr;
1783: k_so_creation_date msc_x_netting_pkg.date_arr;
1784: k_item_name msc_x_netting_pkg.itemnameList;
1785: k_item_desc msc_x_netting_pkg.itemdescList;
1786: k_supplier_name msc_x_netting_pkg.supplierList;
1787: k_supplier_site_name msc_x_netting_pkg.suppsiteList;
1788: k_supplier_item_name msc_x_netting_pkg.itemnameList;
1781: k_so_ship_date msc_x_netting_pkg.date_arr;
1782: k_po_creation_date msc_x_netting_pkg.date_arr;
1783: k_so_creation_date msc_x_netting_pkg.date_arr;
1784: k_item_name msc_x_netting_pkg.itemnameList;
1785: k_item_desc msc_x_netting_pkg.itemdescList;
1786: k_supplier_name msc_x_netting_pkg.supplierList;
1787: k_supplier_site_name msc_x_netting_pkg.suppsiteList;
1788: k_supplier_item_name msc_x_netting_pkg.itemnameList;
1789: k_supplier_item_desc msc_x_netting_pkg.itemdescList;
1782: k_po_creation_date msc_x_netting_pkg.date_arr;
1783: k_so_creation_date msc_x_netting_pkg.date_arr;
1784: k_item_name msc_x_netting_pkg.itemnameList;
1785: k_item_desc msc_x_netting_pkg.itemdescList;
1786: k_supplier_name msc_x_netting_pkg.supplierList;
1787: k_supplier_site_name msc_x_netting_pkg.suppsiteList;
1788: k_supplier_item_name msc_x_netting_pkg.itemnameList;
1789: k_supplier_item_desc msc_x_netting_pkg.itemdescList;
1790: k_customer_name msc_x_netting_pkg.customerList;
1783: k_so_creation_date msc_x_netting_pkg.date_arr;
1784: k_item_name msc_x_netting_pkg.itemnameList;
1785: k_item_desc msc_x_netting_pkg.itemdescList;
1786: k_supplier_name msc_x_netting_pkg.supplierList;
1787: k_supplier_site_name msc_x_netting_pkg.suppsiteList;
1788: k_supplier_item_name msc_x_netting_pkg.itemnameList;
1789: k_supplier_item_desc msc_x_netting_pkg.itemdescList;
1790: k_customer_name msc_x_netting_pkg.customerList;
1791: k_customer_site_name msc_x_netting_pkg.custsiteList;
1784: k_item_name msc_x_netting_pkg.itemnameList;
1785: k_item_desc msc_x_netting_pkg.itemdescList;
1786: k_supplier_name msc_x_netting_pkg.supplierList;
1787: k_supplier_site_name msc_x_netting_pkg.suppsiteList;
1788: k_supplier_item_name msc_x_netting_pkg.itemnameList;
1789: k_supplier_item_desc msc_x_netting_pkg.itemdescList;
1790: k_customer_name msc_x_netting_pkg.customerList;
1791: k_customer_site_name msc_x_netting_pkg.custsiteList;
1792: k_customer_item_name msc_x_netting_pkg.itemnameList;
1785: k_item_desc msc_x_netting_pkg.itemdescList;
1786: k_supplier_name msc_x_netting_pkg.supplierList;
1787: k_supplier_site_name msc_x_netting_pkg.suppsiteList;
1788: k_supplier_item_name msc_x_netting_pkg.itemnameList;
1789: k_supplier_item_desc msc_x_netting_pkg.itemdescList;
1790: k_customer_name msc_x_netting_pkg.customerList;
1791: k_customer_site_name msc_x_netting_pkg.custsiteList;
1792: k_customer_item_name msc_x_netting_pkg.itemnameList;
1793: k_customer_item_desc msc_x_netting_pkg.itemdescList;
1786: k_supplier_name msc_x_netting_pkg.supplierList;
1787: k_supplier_site_name msc_x_netting_pkg.suppsiteList;
1788: k_supplier_item_name msc_x_netting_pkg.itemnameList;
1789: k_supplier_item_desc msc_x_netting_pkg.itemdescList;
1790: k_customer_name msc_x_netting_pkg.customerList;
1791: k_customer_site_name msc_x_netting_pkg.custsiteList;
1792: k_customer_item_name msc_x_netting_pkg.itemnameList;
1793: k_customer_item_desc msc_x_netting_pkg.itemdescList;
1794: k_order_number msc_x_netting_pkg.ordernumberList;
1787: k_supplier_site_name msc_x_netting_pkg.suppsiteList;
1788: k_supplier_item_name msc_x_netting_pkg.itemnameList;
1789: k_supplier_item_desc msc_x_netting_pkg.itemdescList;
1790: k_customer_name msc_x_netting_pkg.customerList;
1791: k_customer_site_name msc_x_netting_pkg.custsiteList;
1792: k_customer_item_name msc_x_netting_pkg.itemnameList;
1793: k_customer_item_desc msc_x_netting_pkg.itemdescList;
1794: k_order_number msc_x_netting_pkg.ordernumberList;
1795: k_release_number msc_x_netting_pkg.releasenumList;
1788: k_supplier_item_name msc_x_netting_pkg.itemnameList;
1789: k_supplier_item_desc msc_x_netting_pkg.itemdescList;
1790: k_customer_name msc_x_netting_pkg.customerList;
1791: k_customer_site_name msc_x_netting_pkg.custsiteList;
1792: k_customer_item_name msc_x_netting_pkg.itemnameList;
1793: k_customer_item_desc msc_x_netting_pkg.itemdescList;
1794: k_order_number msc_x_netting_pkg.ordernumberList;
1795: k_release_number msc_x_netting_pkg.releasenumList;
1796: k_line_number msc_x_netting_pkg.linenumList;
1789: k_supplier_item_desc msc_x_netting_pkg.itemdescList;
1790: k_customer_name msc_x_netting_pkg.customerList;
1791: k_customer_site_name msc_x_netting_pkg.custsiteList;
1792: k_customer_item_name msc_x_netting_pkg.itemnameList;
1793: k_customer_item_desc msc_x_netting_pkg.itemdescList;
1794: k_order_number msc_x_netting_pkg.ordernumberList;
1795: k_release_number msc_x_netting_pkg.releasenumList;
1796: k_line_number msc_x_netting_pkg.linenumList;
1797: k_end_order_number msc_x_netting_pkg.ordernumberList;
1790: k_customer_name msc_x_netting_pkg.customerList;
1791: k_customer_site_name msc_x_netting_pkg.custsiteList;
1792: k_customer_item_name msc_x_netting_pkg.itemnameList;
1793: k_customer_item_desc msc_x_netting_pkg.itemdescList;
1794: k_order_number msc_x_netting_pkg.ordernumberList;
1795: k_release_number msc_x_netting_pkg.releasenumList;
1796: k_line_number msc_x_netting_pkg.linenumList;
1797: k_end_order_number msc_x_netting_pkg.ordernumberList;
1798: k_end_order_rel_number msc_x_netting_pkg.releasenumList;
1791: k_customer_site_name msc_x_netting_pkg.custsiteList;
1792: k_customer_item_name msc_x_netting_pkg.itemnameList;
1793: k_customer_item_desc msc_x_netting_pkg.itemdescList;
1794: k_order_number msc_x_netting_pkg.ordernumberList;
1795: k_release_number msc_x_netting_pkg.releasenumList;
1796: k_line_number msc_x_netting_pkg.linenumList;
1797: k_end_order_number msc_x_netting_pkg.ordernumberList;
1798: k_end_order_rel_number msc_x_netting_pkg.releasenumList;
1799: k_end_order_line_number msc_x_netting_pkg.linenumList;
1792: k_customer_item_name msc_x_netting_pkg.itemnameList;
1793: k_customer_item_desc msc_x_netting_pkg.itemdescList;
1794: k_order_number msc_x_netting_pkg.ordernumberList;
1795: k_release_number msc_x_netting_pkg.releasenumList;
1796: k_line_number msc_x_netting_pkg.linenumList;
1797: k_end_order_number msc_x_netting_pkg.ordernumberList;
1798: k_end_order_rel_number msc_x_netting_pkg.releasenumList;
1799: k_end_order_line_number msc_x_netting_pkg.linenumList;
1800:
1793: k_customer_item_desc msc_x_netting_pkg.itemdescList;
1794: k_order_number msc_x_netting_pkg.ordernumberList;
1795: k_release_number msc_x_netting_pkg.releasenumList;
1796: k_line_number msc_x_netting_pkg.linenumList;
1797: k_end_order_number msc_x_netting_pkg.ordernumberList;
1798: k_end_order_rel_number msc_x_netting_pkg.releasenumList;
1799: k_end_order_line_number msc_x_netting_pkg.linenumList;
1800:
1801: n_ascp_first_po_trx_id msc_x_netting_pkg.number_arr;
1794: k_order_number msc_x_netting_pkg.ordernumberList;
1795: k_release_number msc_x_netting_pkg.releasenumList;
1796: k_line_number msc_x_netting_pkg.linenumList;
1797: k_end_order_number msc_x_netting_pkg.ordernumberList;
1798: k_end_order_rel_number msc_x_netting_pkg.releasenumList;
1799: k_end_order_line_number msc_x_netting_pkg.linenumList;
1800:
1801: n_ascp_first_po_trx_id msc_x_netting_pkg.number_arr;
1802:
1795: k_release_number msc_x_netting_pkg.releasenumList;
1796: k_line_number msc_x_netting_pkg.linenumList;
1797: k_end_order_number msc_x_netting_pkg.ordernumberList;
1798: k_end_order_rel_number msc_x_netting_pkg.releasenumList;
1799: k_end_order_line_number msc_x_netting_pkg.linenumList;
1800:
1801: n_ascp_first_po_trx_id msc_x_netting_pkg.number_arr;
1802:
1803: d_company_id msc_x_netting_pkg.number_arr;
1797: k_end_order_number msc_x_netting_pkg.ordernumberList;
1798: k_end_order_rel_number msc_x_netting_pkg.releasenumList;
1799: k_end_order_line_number msc_x_netting_pkg.linenumList;
1800:
1801: n_ascp_first_po_trx_id msc_x_netting_pkg.number_arr;
1802:
1803: d_company_id msc_x_netting_pkg.number_arr;
1804: d_company_site_id msc_x_netting_pkg.number_arr;
1805: d_customer_id msc_x_netting_pkg.number_arr;
1799: k_end_order_line_number msc_x_netting_pkg.linenumList;
1800:
1801: n_ascp_first_po_trx_id msc_x_netting_pkg.number_arr;
1802:
1803: d_company_id msc_x_netting_pkg.number_arr;
1804: d_company_site_id msc_x_netting_pkg.number_arr;
1805: d_customer_id msc_x_netting_pkg.number_arr;
1806: d_customer_site_id msc_x_netting_pkg.number_arr;
1807: d_supplier_id msc_x_netting_pkg.number_arr;
1800:
1801: n_ascp_first_po_trx_id msc_x_netting_pkg.number_arr;
1802:
1803: d_company_id msc_x_netting_pkg.number_arr;
1804: d_company_site_id msc_x_netting_pkg.number_arr;
1805: d_customer_id msc_x_netting_pkg.number_arr;
1806: d_customer_site_id msc_x_netting_pkg.number_arr;
1807: d_supplier_id msc_x_netting_pkg.number_arr;
1808: d_supplier_site_id msc_x_netting_pkg.number_arr;
1801: n_ascp_first_po_trx_id msc_x_netting_pkg.number_arr;
1802:
1803: d_company_id msc_x_netting_pkg.number_arr;
1804: d_company_site_id msc_x_netting_pkg.number_arr;
1805: d_customer_id msc_x_netting_pkg.number_arr;
1806: d_customer_site_id msc_x_netting_pkg.number_arr;
1807: d_supplier_id msc_x_netting_pkg.number_arr;
1808: d_supplier_site_id msc_x_netting_pkg.number_arr;
1809: d_item_id msc_x_netting_pkg.number_arr;
1802:
1803: d_company_id msc_x_netting_pkg.number_arr;
1804: d_company_site_id msc_x_netting_pkg.number_arr;
1805: d_customer_id msc_x_netting_pkg.number_arr;
1806: d_customer_site_id msc_x_netting_pkg.number_arr;
1807: d_supplier_id msc_x_netting_pkg.number_arr;
1808: d_supplier_site_id msc_x_netting_pkg.number_arr;
1809: d_item_id msc_x_netting_pkg.number_arr;
1810: d_trx_id1 msc_x_netting_pkg.number_arr;
1803: d_company_id msc_x_netting_pkg.number_arr;
1804: d_company_site_id msc_x_netting_pkg.number_arr;
1805: d_customer_id msc_x_netting_pkg.number_arr;
1806: d_customer_site_id msc_x_netting_pkg.number_arr;
1807: d_supplier_id msc_x_netting_pkg.number_arr;
1808: d_supplier_site_id msc_x_netting_pkg.number_arr;
1809: d_item_id msc_x_netting_pkg.number_arr;
1810: d_trx_id1 msc_x_netting_pkg.number_arr;
1811: d_trx_id2 msc_x_netting_pkg.number_arr;
1804: d_company_site_id msc_x_netting_pkg.number_arr;
1805: d_customer_id msc_x_netting_pkg.number_arr;
1806: d_customer_site_id msc_x_netting_pkg.number_arr;
1807: d_supplier_id msc_x_netting_pkg.number_arr;
1808: d_supplier_site_id msc_x_netting_pkg.number_arr;
1809: d_item_id msc_x_netting_pkg.number_arr;
1810: d_trx_id1 msc_x_netting_pkg.number_arr;
1811: d_trx_id2 msc_x_netting_pkg.number_arr;
1812:
1805: d_customer_id msc_x_netting_pkg.number_arr;
1806: d_customer_site_id msc_x_netting_pkg.number_arr;
1807: d_supplier_id msc_x_netting_pkg.number_arr;
1808: d_supplier_site_id msc_x_netting_pkg.number_arr;
1809: d_item_id msc_x_netting_pkg.number_arr;
1810: d_trx_id1 msc_x_netting_pkg.number_arr;
1811: d_trx_id2 msc_x_netting_pkg.number_arr;
1812:
1813: l_so_trx_id Number;
1806: d_customer_site_id msc_x_netting_pkg.number_arr;
1807: d_supplier_id msc_x_netting_pkg.number_arr;
1808: d_supplier_site_id msc_x_netting_pkg.number_arr;
1809: d_item_id msc_x_netting_pkg.number_arr;
1810: d_trx_id1 msc_x_netting_pkg.number_arr;
1811: d_trx_id2 msc_x_netting_pkg.number_arr;
1812:
1813: l_so_trx_id Number;
1814: l_po_trx_id Number;
1807: d_supplier_id msc_x_netting_pkg.number_arr;
1808: d_supplier_site_id msc_x_netting_pkg.number_arr;
1809: d_item_id msc_x_netting_pkg.number_arr;
1810: d_trx_id1 msc_x_netting_pkg.number_arr;
1811: d_trx_id2 msc_x_netting_pkg.number_arr;
1812:
1813: l_so_trx_id Number;
1814: l_po_trx_id Number;
1815: l_customer_id Number;
1955:
1956: l_exception_basis := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_SHIPPING_CONTROL',
1957: nvl(l_shipping_control,1));
1958:
1959: l_exception_type := msc_x_netting_pkg.G_EXCEP13;
1960: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
1961: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
1962: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
1963:
1956: l_exception_basis := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_SHIPPING_CONTROL',
1957: nvl(l_shipping_control,1));
1958:
1959: l_exception_type := msc_x_netting_pkg.G_EXCEP13;
1960: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
1961: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
1962: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
1963:
1964: --select the tp_viewers level-1 suppliers po
1957: nvl(l_shipping_control,1));
1958:
1959: l_exception_type := msc_x_netting_pkg.G_EXCEP13;
1960: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
1961: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
1962: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
1963:
1964: --select the tp_viewers level-1 suppliers po
1965: --that was created to fulfil tp_viewers_po
1958:
1959: l_exception_type := msc_x_netting_pkg.G_EXCEP13;
1960: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
1961: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
1962: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
1963:
1964: --select the tp_viewers level-1 suppliers po
1965: --that was created to fulfil tp_viewers_po
1966:
1989:
1990: IF (b_pegged_trx_id is not null and b_pegged_trx_id.COUNT > 0) THEN
1991: FOR l in 1..b_pegged_trx_id.COUNT
1992: LOOP
1993: IF b_order_type(l) = msc_x_netting_pkg.PURCHASE_ORDER then
1994: ---------------------------------------
1995: ---- the exception_13 cursor
1996: ----------------------------------------
1997: open exception_13 (b_last_publisher_id(l),
2030:
2031: --======================================================
2032: -- Clean up the old exception
2033: --======================================================
2034: msc_x_netting_pkg.add_to_delete_tbl(
2035: b_publisher_id(j),
2036: b_publisher_site_id(j),
2037: null,
2038: null,
2038: null,
2039: b_supplier_id(m),
2040: b_supplier_site_id(m),
2041: b_item_id(j),
2042: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,
2043: msc_x_netting_pkg.G_EXCEP13,
2044: b_source_trx_id(j),
2045: b_trx_id2(m),
2046: null,
2039: b_supplier_id(m),
2040: b_supplier_site_id(m),
2041: b_item_id(j),
2042: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,
2043: msc_x_netting_pkg.G_EXCEP13,
2044: b_source_trx_id(j),
2045: b_trx_id2(m),
2046: null,
2047: null,
2060: t_date2_list);
2061:
2062:
2063: -- bug# 2426271 to populate more info
2064: msc_x_netting_pkg.add_to_exception_tbl(b_publisher_id(j),
2065: b_publisher_name(j),
2066: b_publisher_site_id(j),
2067: b_publisher_site_name(j),
2068: b_item_id(j),
2166: END IF;
2167: END LOOP;
2168: END IF;
2169:
2170: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(13) ||
2171: ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
2172:
2173: --dbms_output.put_line('end of exception 13');
2174: --------------------------------------------------------------------
2260: IF (d_company_id is not null and d_company_id.COUNT > 0) THEN
2261: --dbms_output.put_line('Delete row count ' || d_company_id.COUNT);
2262: FOR d in 1..d_company_id.COUNT LOOP
2263: -- dbms_output.put_line('Trxid2 ' || d_trx_id2(d));
2264: msc_x_netting_pkg.add_to_delete_tbl(
2265: d_company_id(d),
2266: d_company_site_id(d),
2267: d_customer_id(d),
2268: d_customer_site_id(d),
2268: d_customer_site_id(d),
2269: d_supplier_id(d),
2270: d_supplier_site_id(d),
2271: d_item_id(d),
2272: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,
2273: msc_x_netting_pkg.G_EXCEP50,
2274: d_trx_id1(d),
2275: d_trx_id2(d),
2276: null,
2269: d_supplier_id(d),
2270: d_supplier_site_id(d),
2271: d_item_id(d),
2272: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,
2273: msc_x_netting_pkg.G_EXCEP50,
2274: d_trx_id1(d),
2275: d_trx_id2(d),
2276: null,
2277: null,
2288: t_trxid2_list,
2289: t_date1_list,
2290: t_date2_list);
2291:
2292: msc_x_netting_pkg.add_to_delete_tbl(
2293: d_company_id(d),
2294: d_company_site_id(d),
2295: d_customer_id(d),
2296: d_customer_site_id(d),
2296: d_customer_site_id(d),
2297: d_supplier_id(d),
2298: d_supplier_site_id(d),
2299: d_item_id(d),
2300: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,
2301: msc_x_netting_pkg.G_EXCEP51,
2302: d_trx_id1(d),
2303: d_trx_id2(d),
2304: null,
2297: d_supplier_id(d),
2298: d_supplier_site_id(d),
2299: d_item_id(d),
2300: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,
2301: msc_x_netting_pkg.G_EXCEP51,
2302: d_trx_id1(d),
2303: d_trx_id2(d),
2304: null,
2305: null,
2325: b_supplier_id(j-1) <> b_supplier_id(j) or
2326: b_supplier_site_id(j-1) <> b_supplier_site_id(j) or
2327: b_item_id(j-1) <> b_item_id(j) ) THEN
2328:
2329: l_threshold50 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP50,
2330: b_customer_id(j),
2331: b_customer_site_id(j),
2332: b_item_id(j),
2333: b_supplier_id(j),
2335: null,
2336: null,
2337: b_po_key_date(j));
2338:
2339: l_threshold51 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP51,
2340: b_customer_id(j),
2341: b_customer_site_id(j),
2342: b_item_id(j),
2343: b_supplier_id(j),
2415:
2416: FOR k in 1..k_so_trx_id.COUNT
2417: LOOP
2418:
2419: l_exception_type := msc_x_netting_pkg.G_EXCEP50;
2420: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
2421: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
2422: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
2423: --dbms_output.put_line('SO EXISTS IN CP WITH SO TRXID : ' || k_so_trx_id(k) || 'Supplier ' || k_supplier_id(k));
2416: FOR k in 1..k_so_trx_id.COUNT
2417: LOOP
2418:
2419: l_exception_type := msc_x_netting_pkg.G_EXCEP50;
2420: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
2421: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
2422: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
2423: --dbms_output.put_line('SO EXISTS IN CP WITH SO TRXID : ' || k_so_trx_id(k) || 'Supplier ' || k_supplier_id(k));
2424: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SO EXISTS IN CP WITH SO TRXID : ' || k_so_trx_id(k) || 'Supplier ' || k_supplier_id(k));
2417: LOOP
2418:
2419: l_exception_type := msc_x_netting_pkg.G_EXCEP50;
2420: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
2421: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
2422: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
2423: --dbms_output.put_line('SO EXISTS IN CP WITH SO TRXID : ' || k_so_trx_id(k) || 'Supplier ' || k_supplier_id(k));
2424: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SO EXISTS IN CP WITH SO TRXID : ' || k_so_trx_id(k) || 'Supplier ' || k_supplier_id(k));
2425: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Generate Sales order at risk');
2418:
2419: l_exception_type := msc_x_netting_pkg.G_EXCEP50;
2420: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
2421: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
2422: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
2423: --dbms_output.put_line('SO EXISTS IN CP WITH SO TRXID : ' || k_so_trx_id(k) || 'Supplier ' || k_supplier_id(k));
2424: FND_FILE.PUT_LINE(FND_FILE.LOG, 'SO EXISTS IN CP WITH SO TRXID : ' || k_so_trx_id(k) || 'Supplier ' || k_supplier_id(k));
2425: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Generate Sales order at risk');
2426: --Generate the exception: Sales Order at risk due to upstream lateness
2426: --Generate the exception: Sales Order at risk due to upstream lateness
2427: --======================================================
2428: -- Clean up the old exceptions
2429: --======================================================
2430: msc_x_netting_pkg.add_to_delete_tbl(
2431: k_supplier_id(k),
2432: k_supplier_site_id(k),
2433: k_customer_id(k),
2434: k_customer_site_id(k),
2434: k_customer_site_id(k),
2435: k_supplier_id(k),
2436: k_supplier_site_id(k),
2437: k_item_id(k),
2438: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,
2439: msc_x_netting_pkg.G_EXCEP50,
2440: k_so_trx_id(k),
2441: b_trx_id2(j),
2442: null,
2435: k_supplier_id(k),
2436: k_supplier_site_id(k),
2437: k_item_id(k),
2438: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,
2439: msc_x_netting_pkg.G_EXCEP50,
2440: k_so_trx_id(k),
2441: b_trx_id2(j),
2442: null,
2443: null,
2455: t_date1_list,
2456: t_date2_list);
2457:
2458:
2459: msc_x_netting_pkg.add_to_exception_tbl(k_supplier_id(k),
2460: k_supplier_name(k),
2461: k_supplier_site_id(k),
2462: k_supplier_site_name(k),
2463: k_item_id(k),
2645: -----------------------------------------------------------------*/
2646:
2647:
2648: IF (l_peg_trx_id <> n_ascp_first_po_trx_id(n) and
2649: l_peg_supply_type = msc_x_netting_pkg.ASCP_PURCHASE_ORDER) THEN
2650:
2651:
2652: BEGIN
2653: SELECT sup.order_number,
2725: AND sup.plan_id = l_plan_order_at_risk_id
2726: AND sup.sr_instance_id = l_peg_sr_instance_id
2727: AND sup.organization_id = l_peg_org_id
2728: AND sup.inventory_item_id = l_peg_item_id
2729: AND sup.order_type = msc_x_netting_pkg.ASCP_PURCHASE_ORDER
2730:
2731: -- getting the org
2732: AND t1.sr_tp_id = sup.organization_id
2733: AND t1.sr_instance_id = sup.sr_instance_id
2753: AND s2.company_site_id = m3.company_key
2754: AND s2.company_id = c2.company_id
2755:
2756: -- join to cp to get PO
2757: AND sd.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
2758: AND sd.inventory_item_id = sup.inventory_item_id
2759: AND sup.order_number = sd.order_number || sd.release_number
2760: AND nvl(sd.line_number,'-1') = nvl(purch_line_num, '-1')
2761: AND sd.publisher_id = s1.company_id
2794: IF (trunc(b_so_key_date(j)) > trunc(b_po_key_date(j)) + l_threshold51) THEN
2795: --Generate the exceptions for this PO
2796: --the purchase order at risk due to upstream lateness
2797:
2798: l_exception_type := msc_x_netting_pkg.G_EXCEP51;
2799: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
2800: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
2801: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
2802:
2795: --Generate the exceptions for this PO
2796: --the purchase order at risk due to upstream lateness
2797:
2798: l_exception_type := msc_x_netting_pkg.G_EXCEP51;
2799: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
2800: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
2801: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
2802:
2803: --======================================================
2796: --the purchase order at risk due to upstream lateness
2797:
2798: l_exception_type := msc_x_netting_pkg.G_EXCEP51;
2799: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
2800: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
2801: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
2802:
2803: --======================================================
2804: -- Clean up the old exceptions
2797:
2798: l_exception_type := msc_x_netting_pkg.G_EXCEP51;
2799: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
2800: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
2801: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
2802:
2803: --======================================================
2804: -- Clean up the old exceptions
2805: --======================================================
2802:
2803: --======================================================
2804: -- Clean up the old exceptions
2805: --======================================================
2806: msc_x_netting_pkg.add_to_delete_tbl(
2807: l_customer_id,
2808: l_customer_site_id,
2809: l_customer_id,
2810: l_customer_site_id,
2810: l_customer_site_id,
2811: l_supplier_id,
2812: l_supplier_site_id,
2813: l_item_id,
2814: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,
2815: msc_x_netting_pkg.G_EXCEP51,
2816: l_po_trx_id,
2817: b_trx_id2(j),
2818: null,
2811: l_supplier_id,
2812: l_supplier_site_id,
2813: l_item_id,
2814: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,
2815: msc_x_netting_pkg.G_EXCEP51,
2816: l_po_trx_id,
2817: b_trx_id2(j),
2818: null,
2819: null,
2834:
2835: --dbms_output.put_line('Generate excep 51');
2836:
2837: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Generate exception 51');
2838: msc_x_netting_pkg.add_to_exception_tbl(l_customer_id,
2839: l_customer_name,
2840: l_customer_site_id,
2841: l_customer_site_name,
2842: l_item_id,
3019: AND dem.plan_id = l_plan_order_at_risk_id
3020: AND dem.sr_instance_id = l_peg_sr_instance_id
3021: AND dem.organization_id = l_peg_org_id
3022: AND dem.inventory_item_id = l_peg_item_id
3023: AND dem.origination_type in (msc_x_netting_pkg.ASCP_SALES_ORDER,
3024: msc_x_netting_pkg.ASCP_SALES_ORDER_MDS)
3025: --- sbala AND dem.customer_id is not null
3026: -- getting the org
3027: AND t1.sr_tp_id = dem.organization_id
3020: AND dem.sr_instance_id = l_peg_sr_instance_id
3021: AND dem.organization_id = l_peg_org_id
3022: AND dem.inventory_item_id = l_peg_item_id
3023: AND dem.origination_type in (msc_x_netting_pkg.ASCP_SALES_ORDER,
3024: msc_x_netting_pkg.ASCP_SALES_ORDER_MDS)
3025: --- sbala AND dem.customer_id is not null
3026: -- getting the org
3027: AND t1.sr_tp_id = dem.organization_id
3028: AND t1.sr_instance_id = dem.sr_instance_id
3053: AND dem.sr_instance_id = mso.sr_instance_id
3054: AND dem.organization_id = mso.organization_id
3055: AND dem.inventory_item_id = mso.inventory_item_id
3056: AND dem.sales_order_line_id = mso.demand_source_line
3057: AND sd.publisher_order_type = msc_x_netting_pkg.SALES_ORDER
3058: AND sd.inventory_item_id = mso.inventory_item_id
3059: AND sd.order_number = mso.sales_order_number
3060: AND sd.line_number = mso.demand_source_line
3061: AND sd.publisher_id = s1.company_id
3094: --the sales order at risk due to upstream lateness
3095:
3096: IF (trunc(b_so_key_date(j)) > trunc(b_po_key_date(j)) + l_threshold50) THEN
3097: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Generate exception 50');
3098: l_exception_type := msc_x_netting_pkg.G_EXCEP50;
3099: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
3100: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
3101: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
3102: --======================================================
3095:
3096: IF (trunc(b_so_key_date(j)) > trunc(b_po_key_date(j)) + l_threshold50) THEN
3097: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Generate exception 50');
3098: l_exception_type := msc_x_netting_pkg.G_EXCEP50;
3099: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
3100: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
3101: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
3102: --======================================================
3103: -- Clean up the old exceptions
3096: IF (trunc(b_so_key_date(j)) > trunc(b_po_key_date(j)) + l_threshold50) THEN
3097: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Generate exception 50');
3098: l_exception_type := msc_x_netting_pkg.G_EXCEP50;
3099: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
3100: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
3101: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
3102: --======================================================
3103: -- Clean up the old exceptions
3104: --======================================================
3097: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Generate exception 50');
3098: l_exception_type := msc_x_netting_pkg.G_EXCEP50;
3099: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
3100: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
3101: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
3102: --======================================================
3103: -- Clean up the old exceptions
3104: --======================================================
3105: msc_x_netting_pkg.add_to_delete_tbl(
3101: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
3102: --======================================================
3103: -- Clean up the old exceptions
3104: --======================================================
3105: msc_x_netting_pkg.add_to_delete_tbl(
3106: l_supplier_id,
3107: l_supplier_site_id,
3108: l_customer_id,
3109: l_customer_site_id,
3109: l_customer_site_id,
3110: l_supplier_id,
3111: l_supplier_site_id,
3112: l_item_id,
3113: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,
3114: msc_x_netting_pkg.G_EXCEP50,
3115: l_so_trx_id,
3116: b_trx_id2(j),
3117: null,
3110: l_supplier_id,
3111: l_supplier_site_id,
3112: l_item_id,
3113: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,
3114: msc_x_netting_pkg.G_EXCEP50,
3115: l_so_trx_id,
3116: b_trx_id2(j),
3117: null,
3118: null,
3130: t_date1_list,
3131: t_date2_list);
3132:
3133:
3134: msc_x_netting_pkg.add_to_exception_tbl(l_supplier_id,
3135: l_supplier_name,
3136: l_supplier_site_id,
3137: l_supplier_site_name,
3138: l_item_id,
3237: END LOOP;
3238: END IF;
3239:
3240:
3241: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(50 ) || '-' ||
3242: msc_x_netting_pkg.get_message_type(51) ||
3243: ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3244: --------------------------------------------------------------
3245: --Need to clean up the existing exceptions before regenerate
3238: END IF;
3239:
3240:
3241: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(50 ) || '-' ||
3242: msc_x_netting_pkg.get_message_type(51) ||
3243: ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3244: --------------------------------------------------------------
3245: --Need to clean up the existing exceptions before regenerate
3246: --new exception or the criteria is already satisfied.
3296: LOOP
3297: --======================================================
3298: -- archive old exception -- Purchase order compresses lead time
3299: --=====================================================
3300: msc_x_netting_pkg.add_to_delete_tbl(
3301: b_publisher_id(j),
3302: b_publisher_site_id(j),
3303: null,
3304: null,
3304: null,
3305: b_supplier_id(j),
3306: b_supplier_site_id(j),
3307: b_item_id(j),
3308: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,
3309: msc_x_netting_pkg.G_EXCEP14,
3310: b_trx_id1(j),
3311: null,
3312: null,
3305: b_supplier_id(j),
3306: b_supplier_site_id(j),
3307: b_item_id(j),
3308: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,
3309: msc_x_netting_pkg.G_EXCEP14,
3310: b_trx_id1(j),
3311: null,
3312: null,
3313: null,
3327:
3328: --======================================================
3329: -- archive old exception --Customer purchase order compresses lead time
3330: --=====================================================
3331: msc_x_netting_pkg.add_to_delete_tbl(
3332: b_supplier_id(j),
3333: b_supplier_site_id(j),
3334: b_publisher_id(j),
3335: b_publisher_site_id(j),
3335: b_publisher_site_id(j),
3336: null,
3337: null,
3338: b_item_id(j),
3339: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,
3340: msc_x_netting_pkg.G_EXCEP15,
3341: b_trx_id1(j),
3342: null,
3343: null,
3336: null,
3337: null,
3338: b_item_id(j),
3339: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,
3340: msc_x_netting_pkg.G_EXCEP15,
3341: b_trx_id1(j),
3342: null,
3343: null,
3344: null,
3364: b_publisher_site_id(j-1) <> b_publisher_site_id(j) or
3365: b_supplier_id(j-1) <> b_supplier_id(j) or
3366: b_supplier_site_id(j-1) <> b_supplier_site_id(j) or
3367: b_item_id(j-1) <> b_item_id(j) ) THEN
3368: l_threshold := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP14,
3369: b_publisher_id(j),
3370: b_publisher_site_id(j),
3371: b_item_id(j),
3372: b_supplier_id(j),
3385:
3386: SELECT count(*)
3387: into l_count
3388: FROM msc_x_exception_details d
3389: WHERE d.exception_type = msc_x_netting_pkg.G_EXCEP4
3390: AND d.transaction_id1 = b_trx_id1(j);
3391:
3392: IF (l_count > 0) THEN
3393:
3401:
3402: l_exception_basis := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_SHIPPING_CONTROL',
3403: nvl(l_shipping_control,1));
3404:
3405: l_exception_type := msc_x_netting_pkg.G_EXCEP14; -- your PO to supplier requires lead time comp.
3406: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
3407: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
3408: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
3409: msc_x_netting_pkg.add_to_exception_tbl(b_publisher_id(j),
3402: l_exception_basis := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_SHIPPING_CONTROL',
3403: nvl(l_shipping_control,1));
3404:
3405: l_exception_type := msc_x_netting_pkg.G_EXCEP14; -- your PO to supplier requires lead time comp.
3406: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
3407: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
3408: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
3409: msc_x_netting_pkg.add_to_exception_tbl(b_publisher_id(j),
3410: b_publisher_name(j),
3403: nvl(l_shipping_control,1));
3404:
3405: l_exception_type := msc_x_netting_pkg.G_EXCEP14; -- your PO to supplier requires lead time comp.
3406: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
3407: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
3408: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
3409: msc_x_netting_pkg.add_to_exception_tbl(b_publisher_id(j),
3410: b_publisher_name(j),
3411: b_publisher_site_id(j),
3404:
3405: l_exception_type := msc_x_netting_pkg.G_EXCEP14; -- your PO to supplier requires lead time comp.
3406: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
3407: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
3408: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
3409: msc_x_netting_pkg.add_to_exception_tbl(b_publisher_id(j),
3410: b_publisher_name(j),
3411: b_publisher_site_id(j),
3412: b_publisher_site_name(j),
3405: l_exception_type := msc_x_netting_pkg.G_EXCEP14; -- your PO to supplier requires lead time comp.
3406: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
3407: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
3408: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
3409: msc_x_netting_pkg.add_to_exception_tbl(b_publisher_id(j),
3410: b_publisher_name(j),
3411: b_publisher_site_id(j),
3412: b_publisher_site_name(j),
3413: b_item_id(j),
3504:
3505: SELECT count(*)
3506: INTO l_count
3507: FROM msc_x_exception_details d
3508: WHERE d.exception_type = msc_x_netting_pkg.G_EXCEP3
3509: AND d.transaction_id1 = b_trx_id1(j);
3510:
3511: IF (l_count > 0 ) THEN
3512: l_exception_type := msc_x_netting_pkg.G_EXCEP15; -- cust po to you requires lead time comp.
3508: WHERE d.exception_type = msc_x_netting_pkg.G_EXCEP3
3509: AND d.transaction_id1 = b_trx_id1(j);
3510:
3511: IF (l_count > 0 ) THEN
3512: l_exception_type := msc_x_netting_pkg.G_EXCEP15; -- cust po to you requires lead time comp.
3513: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
3514:
3515: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
3516: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
3509: AND d.transaction_id1 = b_trx_id1(j);
3510:
3511: IF (l_count > 0 ) THEN
3512: l_exception_type := msc_x_netting_pkg.G_EXCEP15; -- cust po to you requires lead time comp.
3513: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
3514:
3515: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
3516: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
3517: msc_x_netting_pkg.add_to_exception_tbl(b_supplier_id(j),
3511: IF (l_count > 0 ) THEN
3512: l_exception_type := msc_x_netting_pkg.G_EXCEP15; -- cust po to you requires lead time comp.
3513: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
3514:
3515: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
3516: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
3517: msc_x_netting_pkg.add_to_exception_tbl(b_supplier_id(j),
3518: b_supplier_name(j),
3519: b_supplier_site_id(j),
3512: l_exception_type := msc_x_netting_pkg.G_EXCEP15; -- cust po to you requires lead time comp.
3513: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
3514:
3515: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
3516: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
3517: msc_x_netting_pkg.add_to_exception_tbl(b_supplier_id(j),
3518: b_supplier_name(j),
3519: b_supplier_site_id(j),
3520: b_supplier_site_name(j),
3513: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
3514:
3515: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
3516: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
3517: msc_x_netting_pkg.add_to_exception_tbl(b_supplier_id(j),
3518: b_supplier_name(j),
3519: b_supplier_site_id(j),
3520: b_supplier_site_name(j),
3521: b_item_id(j),
3608: END LOOP;
3609: END IF;
3610:
3611:
3612: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(14) || '-' ||
3613: msc_x_netting_pkg.get_message_type(15) ||
3614: ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3615:
3616:
3609: END IF;
3610:
3611:
3612: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(14) || '-' ||
3613: msc_x_netting_pkg.get_message_type(15) ||
3614: ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3615:
3616:
3617: -----------------------------------------------------------------------------
3664:
3665: --======================================================
3666: -- archive old exception
3667: --=====================================================
3668: msc_x_netting_pkg.add_to_delete_tbl(
3669: b_publisher_id(j),
3670: b_publisher_site_id(j),
3671: b_customer_id(j),
3672: b_customer_site_id(j),
3672: b_customer_site_id(j),
3673: null,
3674: null,
3675: b_item_id(j),
3676: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,
3677: msc_x_netting_pkg.G_EXCEP16,
3678: b_trx_id1(j),
3679: null,
3680: null,
3673: null,
3674: null,
3675: b_item_id(j),
3676: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,
3677: msc_x_netting_pkg.G_EXCEP16,
3678: b_trx_id1(j),
3679: null,
3680: null,
3681: null,
3701: b_publisher_site_id(j-1) <> b_publisher_site_id(j) or
3702: b_customer_id(j-1) <> b_customer_id(j) or
3703: b_customer_site_id(j-1) <> b_customer_site_id(j) or
3704: b_item_id(j-1) <> b_item_id(j) ) THEN
3705: l_threshold := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP16,
3706: b_publisher_id(j),
3707: b_publisher_site_id(j),
3708: b_item_id(j),
3709: null,
3727:
3728: l_exception_basis := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_SHIPPING_CONTROL',
3729: nvl(l_shipping_control,1));
3730:
3731: l_exception_type := msc_x_netting_pkg.G_EXCEP16; -- your so requires lead time comp.
3732: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
3733: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
3734: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
3735:
3728: l_exception_basis := MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_SHIPPING_CONTROL',
3729: nvl(l_shipping_control,1));
3730:
3731: l_exception_type := msc_x_netting_pkg.G_EXCEP16; -- your so requires lead time comp.
3732: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
3733: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
3734: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
3735:
3736:
3729: nvl(l_shipping_control,1));
3730:
3731: l_exception_type := msc_x_netting_pkg.G_EXCEP16; -- your so requires lead time comp.
3732: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
3733: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
3734: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
3735:
3736:
3737:
3730:
3731: l_exception_type := msc_x_netting_pkg.G_EXCEP16; -- your so requires lead time comp.
3732: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;
3733: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);
3734: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
3735:
3736:
3737:
3738: msc_x_netting_pkg.add_to_exception_tbl(b_publisher_id(j),
3734: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);
3735:
3736:
3737:
3738: msc_x_netting_pkg.add_to_exception_tbl(b_publisher_id(j),
3739: b_publisher_name(j),
3740: b_publisher_site_id(j),
3741: b_publisher_site_name(j),
3742: b_item_id(j),
3828: END IF;
3829: end loop;
3830: END IF;
3831:
3832: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(16) ||
3833: '.' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));
3834:
3835:
3836:
3834:
3835:
3836:
3837: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total exceptions inserted for the group ' ||
3838: msc_x_netting_pkg.get_message_group(msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER) || ':' || l_inserted_record);
3839:
3840: EXCEPTION
3841: when others then
3842: MSC_SCE_LOADS_PKG.LOG_MESSAGE('Error in MSC_X_NETTING3_PKG.Compute_Potential_Late_Order');