eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_X_NETTING3_PKG dependencies on MSC_X_NETTING_PKG

Line 39: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP11,

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,

Line 48: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP31,

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,

Line 58: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_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,

Line 59: AND sd.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER

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,

Line 60: AND msc_x_netting_pkg.does_so_exist(sd.order_number,

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,

Line 109: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP12,

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,

Line 118: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP32,

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,

Line 128: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_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,

Line 129: AND sd.publisher_order_type = msc_x_netting_pkg.SALES_ORDER

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,

Line 130: AND msc_x_netting_pkg.does_po_exist(sd.end_order_number,

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,

Line 172: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_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

Line 173: AND sd.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER

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

Line 193: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID

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

Line 195: AND sd1.publisher_order_type = msc_x_netting_pkg.SALES_ORDER --SO

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

Line 205: AND sd2.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER --PO

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)

Line 281: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP13,

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,

Line 292: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_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

Line 295: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER

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

Line 301: AND sd2.publisher_order_type = msc_x_netting_pkg.SALES_ORDER

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)

Line 309: msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP13,

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,

Line 365: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_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

Line 367: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER

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

Line 370: AND sd2.publisher_order_type = msc_x_netting_pkg.SALES_ORDER

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)

Line 420: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID

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

Line 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');

Line 425: /* sbala msc_x_netting_pkg.PURCHASE_ORDER */

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:

Line 497: AND exception_type in (msc_x_netting_pkg.G_EXCEP50,msc_x_netting_pkg.G_EXCEP51)

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

Line 519: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID

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

Line 520: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER --

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

Line 584: WHERE sd1.plan_id = msc_x_netting_pkg.G_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

Line 585: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER --

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

Line 648: WHERE sd1.plan_id = msc_x_netting_pkg.G_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

Line 649: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER --

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

Line 668: WHERE d.exception_type = msc_x_netting_pkg.G_EXCEP3

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: --------------------------------------------------------------------------------------

Line 707: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID

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)

Line 708: AND sd1.publisher_order_type = msc_x_netting_pkg.SALES_ORDER

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

Line 720: a_company_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,

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,

Line 721: a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,

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,

Line 722: a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,

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,

Line 723: a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,

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,

Line 724: a_item_id 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,

Line 725: a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,

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,

Line 726: a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,

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,

Line 727: a_exception_type 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,
731: a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,

Line 728: a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,

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,

Line 729: a_exception_group 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,

Line 730: a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,

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,

Line 731: a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,

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,

Line 732: a_trx_id2 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,

Line 733: a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,

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,

Line 734: a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,

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,

Line 735: a_customer_site_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,

Line 736: a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,

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,

Line 737: a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,

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,

Line 738: a_supplier_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,
742: a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,

Line 739: a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,

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,

Line 740: a_supplier_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,
744: a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,

Line 741: a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,

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,

Line 742: a_supplier_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,
746: a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,

Line 743: a_number1 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,

Line 744: a_number2 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,

Line 745: a_number3 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,

Line 746: a_threshold 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,

Line 747: a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,

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,

Line 748: a_item_min_qty 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,
752: a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,

Line 749: a_item_max_qty 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,
753: a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,

Line 750: a_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,

Line 751: a_release_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,

Line 752: a_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,

Line 753: a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,

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,

Line 754: a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,

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,

Line 755: a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,

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,

Line 756: a_creation_date 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,

Line 757: a_tp_creation_date 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,

Line 758: a_date1 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,

Line 759: a_date2 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

Line 760: a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,

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:

Line 761: a_date4 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:
765:

Line 762: a_date5 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:
766: CURSOR excepSummary IS

Line 763: a_exception_basis IN OUT NOCOPY msc_x_netting_pkg.exceptbasisList) 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,

Line 775: where plan_id =msc_x_netting_pkg.G_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,

Line 787: b_threshold1 msc_x_netting_pkg.number_arr;

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;

Line 788: b_threshold2 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;

Line 789: b_company_id 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;

Line 790: b_organization_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;

Line 791: b_trx_id1 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;

Line 792: b_trx_id2 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;

Line 793: b_publisher_id 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;

Line 794: b_publisher_site_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;
798: b_tp_qty msc_x_netting_pkg.number_arr;

Line 795: b_item_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;
799: b_posting_po_qty msc_x_netting_pkg.number_arr;

Line 796: b_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;

Line 797: b_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;

Line 798: b_tp_qty 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;

Line 799: b_posting_po_qty 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;

Line 800: b_posting_so_qty 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;

Line 801: b_customer_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;

Line 802: b_customer_site_id 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;

Line 803: b_supplier_id 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;
807: b_so_key_date msc_x_netting_pkg.date_arr;

Line 804: b_supplier_site_id 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;
808: b_po_ship_date msc_x_netting_pkg.date_arr;

Line 805: b_lead_time 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;
809: b_so_ship_date msc_x_netting_pkg.date_arr;

Line 806: b_po_key_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;

Line 807: b_so_key_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;

Line 808: b_po_ship_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;

Line 809: b_so_ship_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;

Line 810: b_po_receipt_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;

Line 811: b_so_receipt_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;
815: b_item_desc msc_x_netting_pkg.itemdescList;

Line 812: b_po_creation_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;
816: b_publisher_name msc_x_netting_pkg.publisherList;

Line 813: b_so_creation_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;
817: b_publisher_site_name msc_x_netting_pkg.pubsiteList;

Line 814: b_item_name msc_x_netting_pkg.itemnameList;

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;

Line 815: b_item_desc msc_x_netting_pkg.itemdescList;

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;

Line 816: b_publisher_name msc_x_netting_pkg.publisherList;

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;

Line 817: b_publisher_site_name msc_x_netting_pkg.pubsiteList;

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;

Line 818: b_supplier_name msc_x_netting_pkg.supplierList;

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;

Line 819: b_supplier_site_name msc_x_netting_pkg.suppsiteList;

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;

Line 820: b_supplier_item_name msc_x_netting_pkg.itemnameList;

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;

Line 821: b_supplier_item_desc msc_x_netting_pkg.itemdescList;

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;

Line 822: b_customer_name msc_x_netting_pkg.customerList;

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;

Line 823: b_customer_site_name msc_x_netting_pkg.custsiteList;

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;

Line 824: b_customer_item_name msc_x_netting_pkg.itemnameList;

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;

Line 825: b_customer_item_desc msc_x_netting_pkg.itemdescList;

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;

Line 826: b_order_number 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;

Line 827: b_release_number 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;

Line 828: b_line_number 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:

Line 829: b_end_order_num msc_x_netting_pkg.ordernumberList;

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;

Line 830: b_end_order_rel_num msc_x_netting_pkg.releasenumList;

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;

Line 831: b_end_order_line_num msc_x_netting_pkg.linenumList;

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;

Line 889: where plan_id = msc_x_netting_pkg.G_PLAN_ID

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

Line 894: 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
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');

Line 935: l_exception_type := msc_x_netting_pkg.G_EXCEP11;

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:

Line 936: l_exception_group := msc_x_netting_pkg.G_RESPONSE_REQUIRED;

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

Line 937: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);

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:

Line 938: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);

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:

Line 957: l_exception_detail_id1 := msc_x_netting_pkg.does_detail_excep_exist(b_supplier_id(j),

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));

Line 975: msc_x_netting_pkg.update_exceptions_summary(b_supplier_id(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);

Line 984: msc_x_netting_pkg.add_to_exception_tbl(b_supplier_id(j),

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),

Line 1082: l_exception_type := msc_x_netting_pkg.G_EXCEP31;

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);

Line 1083: l_exception_group := msc_x_netting_pkg.G_RESPONSE_REQUIRED;

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),

Line 1085: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);

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),

Line 1086: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);

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,

Line 1087: l_exception_detail_id2 := msc_x_netting_pkg.does_detail_excep_exist(b_publisher_id(j),

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));

Line 1105: msc_x_netting_pkg.update_exceptions_summary(b_publisher_id(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);

Line 1114: msc_x_netting_pkg.add_to_exception_tbl(b_publisher_id(j),

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),

Line 1210: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(11) ||

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;

Line 1211: msc_x_netting_pkg.get_message_type(31) || ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));

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;

Line 1254: l_exception_type := msc_x_netting_pkg.G_EXCEP12;

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:

Line 1255: l_exception_group := msc_x_netting_pkg.G_RESPONSE_REQUIRED;

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

Line 1256: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);

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:

Line 1257: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);

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: --------------------------------------------------------------------------

Line 1275: l_exception_detail_id1 := msc_x_netting_pkg.does_detail_excep_exist(b_publisher_id(j),

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));

Line 1294: msc_x_netting_pkg.update_exceptions_summary(b_publisher_id(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);

Line 1303: msc_x_netting_pkg.add_to_exception_tbl(b_publisher_id(j),

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),

Line 1407: l_exception_type := msc_x_netting_pkg.G_EXCEP32;

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:

Line 1408: l_exception_group := msc_x_netting_pkg.G_RESPONSE_REQUIRED;

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),

Line 1409: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);

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),

Line 1410: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);

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),

Line 1412: l_exception_detail_id2 := msc_x_netting_pkg.does_detail_excep_exist(b_customer_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));

Line 1431: msc_x_netting_pkg.update_exceptions_summary(b_customer_id(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);

Line 1440: msc_x_netting_pkg.add_to_exception_tbl(b_customer_id(j),

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),

Line 1534: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(12) ||

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 ' ||

Line 1535: msc_x_netting_pkg.get_message_type(32) || ':' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS'));

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);

Line 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

Line 1547: where plan_id = msc_x_netting_pkg.G_PLAN_ID

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;

Line 1596: msc_x_netting_pkg.delete_wf_notification(l_item_type, l_item_key);

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;

Line 1616: t_company_list IN OUT NOCOPY msc_x_netting_pkg.number_arr,

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,

Line 1617: t_company_site_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,

Line 1618: t_customer_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,

Line 1619: t_customer_site_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,

Line 1620: t_supplier_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,

Line 1621: t_supplier_site_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,

Line 1622: t_item_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,

Line 1623: t_group_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,

Line 1624: t_type_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,
1628: t_date2_list IN OUT NOCOPY msc_x_netting_pkg.date_arr,

Line 1625: t_trxid1_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,
1629: a_company_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,

Line 1626: t_trxid2_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,
1630: a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,

Line 1627: t_date1_list IN OUT NOCOPY msc_x_netting_pkg.date_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,
1631: a_company_site_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,

Line 1628: t_date2_list IN OUT NOCOPY msc_x_netting_pkg.date_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,

Line 1629: a_company_id 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,
1633: a_item_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,

Line 1630: a_company_name IN OUT NOCOPY msc_x_netting_pkg.publisherList,

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,

Line 1631: a_company_site_id 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,
1635: a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,

Line 1632: a_company_site_name IN OUT NOCOPY msc_x_netting_pkg.pubsiteList,

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,

Line 1633: a_item_id 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,

Line 1634: a_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,

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,

Line 1635: a_item_desc IN OUT NOCOPY msc_x_netting_pkg.itemdescList,

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,

Line 1636: a_exception_type 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,
1640: a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,

Line 1637: a_exception_type_name IN OUT NOCOPY msc_x_netting_pkg.exceptypeList,

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,

Line 1638: a_exception_group 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,

Line 1639: a_exception_group_name IN OUT NOCOPY msc_x_netting_pkg.excepgroupList,

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,

Line 1640: a_trx_id1 IN OUT NOCOPY msc_x_netting_pkg.number_arr,

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,

Line 1641: a_trx_id2 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,

Line 1642: a_customer_id IN OUT NOCOPY msc_x_netting_pkg.number_arr,

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,

Line 1643: a_customer_name IN OUT NOCOPY msc_x_netting_pkg.customerList,

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,

Line 1644: a_customer_site_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,

Line 1645: a_customer_site_name IN OUT NOCOPY msc_x_netting_pkg.custsiteList,

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,

Line 1646: a_customer_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,

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,

Line 1647: a_supplier_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,
1651: a_supplier_item_name IN OUT NOCOPY msc_x_netting_pkg.itemnameList,

Line 1648: a_supplier_name IN OUT NOCOPY msc_x_netting_pkg.supplierList,

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,

Line 1649: a_supplier_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,
1653: a_number2 IN OUT NOCOPY msc_x_netting_pkg.number_arr,

Line 1650: a_supplier_site_name IN OUT NOCOPY msc_x_netting_pkg.suppsiteList,

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,

Line 1651: a_supplier_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,
1655: a_threshold IN OUT NOCOPY msc_x_netting_pkg.number_arr,

Line 1652: a_number1 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,

Line 1653: a_number2 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,

Line 1654: a_number3 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,

Line 1655: a_threshold 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,

Line 1656: a_lead_time IN OUT NOCOPY msc_x_netting_pkg.number_arr,

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,

Line 1657: a_item_min_qty 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,
1661: a_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,

Line 1658: a_item_max_qty 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,
1662: a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,

Line 1659: a_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,

Line 1660: a_release_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,

Line 1661: a_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,

Line 1662: a_end_order_number IN OUT NOCOPY msc_x_netting_pkg.ordernumberList,

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,

Line 1663: a_end_order_rel_number IN OUT NOCOPY msc_x_netting_pkg.releasenumList,

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,

Line 1664: a_end_order_line_number IN OUT NOCOPY msc_x_netting_pkg.linenumList,

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,

Line 1665: a_creation_date 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,

Line 1666: a_tp_creation_date 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,

Line 1667: a_date1 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,

Line 1668: a_date2 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

Line 1669: a_date3 IN OUT NOCOPY msc_x_netting_pkg.date_arr,

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:

Line 1670: a_date4 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:
1674:

Line 1671: a_date5 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:
1675:

Line 1672: a_exception_basis IN OUT NOCOPY msc_x_netting_pkg.exceptbasisList) IS

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;

Line 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;

Line 1677: b_order_type 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;

Line 1678: b_po_trx_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;

Line 1679: b_source_trx_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;

Line 1680: b_threshold 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;

Line 1681: b_company_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;
1685: b_publisher_id msc_x_netting_pkg.number_arr;

Line 1682: b_organization_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;

Line 1683: b_trx_id1 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;

Line 1684: b_trx_id2 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;

Line 1685: b_publisher_id 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;

Line 1686: b_publisher_site_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;
1690: b_tp_po_qty msc_x_netting_pkg.number_arr;

Line 1687: b_item_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;
1691: b_tp_so_qty msc_x_netting_pkg.number_arr;

Line 1688: b_po_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;

Line 1689: b_so_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;

Line 1690: b_tp_po_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;

Line 1691: b_tp_so_qty 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;

Line 1692: b_posting_po_qty 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;

Line 1693: b_posting_so_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;
1697: b_supplier_site_id msc_x_netting_pkg.number_arr;

Line 1694: b_customer_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;

Line 1695: b_customer_site_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;

Line 1696: b_supplier_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;

Line 1697: b_supplier_site_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;

Line 1698: b_first_supplier_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;

Line 1699: b_first_supplier_site_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;
1703: b_po_key_date msc_x_netting_pkg.date_arr;

Line 1700: b_last_publisher_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;
1704: b_so_key_date msc_x_netting_pkg.date_arr;

Line 1701: b_last_publisher_site_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;
1705: b_po_receipt_date msc_x_netting_pkg.date_arr;

Line 1702: b_lead_time 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;
1706: b_so_receipt_date msc_x_netting_pkg.date_arr;

Line 1703: b_po_key_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;

Line 1704: b_so_key_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;

Line 1705: b_po_receipt_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;

Line 1706: b_so_receipt_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;

Line 1707: b_po_ship_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;

Line 1708: b_so_ship_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;

Line 1709: b_po_creation_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;

Line 1710: b_so_creation_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;

Line 1711: b_first_po_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;

Line 1712: b_first_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;
1716: b_item_desc msc_x_netting_pkg.itemdescList;

Line 1713: b_first_po_receipt_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;
1717: b_publisher_name msc_x_netting_pkg.publisherList;

Line 1714: b_key_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;
1718: b_publisher_site_name msc_x_netting_pkg.pubsiteList;

Line 1715: b_item_name msc_x_netting_pkg.itemnameList;

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;

Line 1716: b_item_desc msc_x_netting_pkg.itemdescList;

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;

Line 1717: b_publisher_name msc_x_netting_pkg.publisherList;

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;

Line 1718: b_publisher_site_name msc_x_netting_pkg.pubsiteList;

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;

Line 1719: b_supplier_name msc_x_netting_pkg.supplierList;

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;

Line 1720: b_supplier_site_name msc_x_netting_pkg.suppsiteList;

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;

Line 1721: b_supplier_item_name msc_x_netting_pkg.itemnameList;

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;

Line 1722: b_supplier_item_desc msc_x_netting_pkg.itemdescList;

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;

Line 1723: b_customer_name msc_x_netting_pkg.customerList;

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;

Line 1724: b_customer_site_name msc_x_netting_pkg.custsiteList;

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;

Line 1725: b_customer_item_name msc_x_netting_pkg.itemnameList;

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;

Line 1726: b_customer_item_desc msc_x_netting_pkg.itemdescList;

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;

Line 1727: b_first_supplier_name msc_x_netting_pkg.supplierList;

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;

Line 1728: b_first_supplier_site_name msc_x_netting_pkg.suppsiteList;

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;

Line 1729: b_first_supplier_item_name msc_x_netting_pkg.itemnameList;

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;

Line 1730: b_first_supplier_item_desc msc_x_netting_pkg.itemdescList;

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;

Line 1731: b_exception_type_name msc_x_netting_pkg.exceptypeList;

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;

Line 1732: b_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;

Line 1733: b_release_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;

Line 1734: b_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;

Line 1735: b_end_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;

Line 1736: b_end_order_rel_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;

Line 1737: b_end_order_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:

Line 1738: b_so_order_number msc_x_netting_pkg.ordernumberList;

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:

Line 1739: b_so_release_number msc_x_netting_pkg.releasenumList;

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;

Line 1740: b_so_line_number msc_x_netting_pkg.linenumList;

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;

Line 1767: k_so_trx_id msc_x_netting_pkg.number_arr;

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;

Line 1768: k_item_id 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;

Line 1769: k_posting_so_qty 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;

Line 1770: k_so_qty 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;

Line 1771: k_tp_qty 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;

Line 1772: k_customer_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;

Line 1773: k_customer_site_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;
1777: k_so_key_date msc_x_netting_pkg.date_arr;

Line 1774: k_supplier_id 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;
1778: k_po_receipt_date msc_x_netting_pkg.date_arr;

Line 1775: k_supplier_site_id 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;
1779: k_so_receipt_date msc_x_netting_pkg.date_arr;

Line 1776: k_po_key_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;

Line 1777: k_so_key_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;

Line 1778: k_po_receipt_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;

Line 1779: k_so_receipt_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;

Line 1780: k_po_ship_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;

Line 1781: k_so_ship_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;
1785: k_item_desc msc_x_netting_pkg.itemdescList;

Line 1782: k_po_creation_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;
1786: k_supplier_name msc_x_netting_pkg.supplierList;

Line 1783: k_so_creation_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;
1787: k_supplier_site_name msc_x_netting_pkg.suppsiteList;

Line 1784: k_item_name msc_x_netting_pkg.itemnameList;

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;

Line 1785: k_item_desc msc_x_netting_pkg.itemdescList;

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;

Line 1786: k_supplier_name msc_x_netting_pkg.supplierList;

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;

Line 1787: k_supplier_site_name msc_x_netting_pkg.suppsiteList;

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;

Line 1788: k_supplier_item_name msc_x_netting_pkg.itemnameList;

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;

Line 1789: k_supplier_item_desc msc_x_netting_pkg.itemdescList;

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;

Line 1790: k_customer_name msc_x_netting_pkg.customerList;

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;

Line 1791: k_customer_site_name msc_x_netting_pkg.custsiteList;

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;

Line 1792: k_customer_item_name msc_x_netting_pkg.itemnameList;

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;

Line 1793: k_customer_item_desc msc_x_netting_pkg.itemdescList;

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;

Line 1794: k_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;

Line 1795: k_release_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;

Line 1796: k_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:

Line 1797: k_end_order_number msc_x_netting_pkg.ordernumberList;

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;

Line 1798: k_end_order_rel_number msc_x_netting_pkg.releasenumList;

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:

Line 1799: k_end_order_line_number msc_x_netting_pkg.linenumList;

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;

Line 1801: n_ascp_first_po_trx_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;

Line 1803: d_company_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;

Line 1804: d_company_site_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;

Line 1805: d_customer_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;

Line 1806: d_customer_site_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;

Line 1807: d_supplier_id 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;

Line 1808: d_supplier_site_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;
1812:

Line 1809: d_item_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:
1813: l_so_trx_id Number;

Line 1810: d_trx_id1 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;
1814: l_po_trx_id Number;

Line 1811: d_trx_id2 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;
1815: l_customer_id Number;

Line 1959: l_exception_type := msc_x_netting_pkg.G_EXCEP13;

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:

Line 1960: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;

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

Line 1961: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);

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

Line 1962: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);

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:

Line 1993: IF b_order_type(l) = msc_x_netting_pkg.PURCHASE_ORDER then

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),

Line 2034: msc_x_netting_pkg.add_to_delete_tbl(

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,

Line 2042: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,

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,

Line 2043: msc_x_netting_pkg.G_EXCEP13,

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,

Line 2064: msc_x_netting_pkg.add_to_exception_tbl(b_publisher_id(j),

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),

Line 2170: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(13) ||

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: --------------------------------------------------------------------

Line 2264: msc_x_netting_pkg.add_to_delete_tbl(

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),

Line 2272: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,

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,

Line 2273: msc_x_netting_pkg.G_EXCEP50,

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,

Line 2292: msc_x_netting_pkg.add_to_delete_tbl(

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),

Line 2300: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,

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,

Line 2301: msc_x_netting_pkg.G_EXCEP51,

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,

Line 2329: l_threshold50 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP50,

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),

Line 2339: l_threshold51 := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP51,

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),

Line 2419: l_exception_type := msc_x_netting_pkg.G_EXCEP50;

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));

Line 2420: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;

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));

Line 2421: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);

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');

Line 2422: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);

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

Line 2430: msc_x_netting_pkg.add_to_delete_tbl(

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),

Line 2438: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,

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,

Line 2439: msc_x_netting_pkg.G_EXCEP50,

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,

Line 2459: msc_x_netting_pkg.add_to_exception_tbl(k_supplier_id(k),

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),

Line 2649: l_peg_supply_type = msc_x_netting_pkg.ASCP_PURCHASE_ORDER) THEN

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,

Line 2729: AND sup.order_type = msc_x_netting_pkg.ASCP_PURCHASE_ORDER

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

Line 2757: AND sd.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER

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

Line 2798: l_exception_type := msc_x_netting_pkg.G_EXCEP51;

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:

Line 2799: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;

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: --======================================================

Line 2800: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);

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

Line 2801: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);

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: --======================================================

Line 2806: msc_x_netting_pkg.add_to_delete_tbl(

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,

Line 2814: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,

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,

Line 2815: msc_x_netting_pkg.G_EXCEP51,

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,

Line 2838: msc_x_netting_pkg.add_to_exception_tbl(l_customer_id,

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,

Line 3023: AND dem.origination_type in (msc_x_netting_pkg.ASCP_SALES_ORDER,

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

Line 3024: msc_x_netting_pkg.ASCP_SALES_ORDER_MDS)

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

Line 3057: AND sd.publisher_order_type = msc_x_netting_pkg.SALES_ORDER

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

Line 3098: l_exception_type := msc_x_netting_pkg.G_EXCEP50;

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: --======================================================

Line 3099: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;

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

Line 3100: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);

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: --======================================================

Line 3101: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);

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(

Line 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,

Line 3113: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,

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,

Line 3114: msc_x_netting_pkg.G_EXCEP50,

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,

Line 3134: msc_x_netting_pkg.add_to_exception_tbl(l_supplier_id,

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,

Line 3241: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(50 ) || '-' ||

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

Line 3242: msc_x_netting_pkg.get_message_type(51) ||

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.

Line 3300: msc_x_netting_pkg.add_to_delete_tbl(

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,

Line 3308: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,

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,

Line 3309: msc_x_netting_pkg.G_EXCEP14,

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,

Line 3331: msc_x_netting_pkg.add_to_delete_tbl(

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),

Line 3339: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,

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,

Line 3340: msc_x_netting_pkg.G_EXCEP15,

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,

Line 3368: l_threshold := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP14,

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),

Line 3389: WHERE d.exception_type = msc_x_netting_pkg.G_EXCEP4

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:

Line 3405: l_exception_type := msc_x_netting_pkg.G_EXCEP14; -- your PO to supplier requires lead time comp.

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),

Line 3406: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;

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),

Line 3407: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);

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),

Line 3408: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);

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),

Line 3409: msc_x_netting_pkg.add_to_exception_tbl(b_publisher_id(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),

Line 3508: WHERE d.exception_type = msc_x_netting_pkg.G_EXCEP3

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.

Line 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);

Line 3513: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;

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),

Line 3515: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);

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),

Line 3516: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);

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),

Line 3517: msc_x_netting_pkg.add_to_exception_tbl(b_supplier_id(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),

Line 3612: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(14) || '-' ||

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:

Line 3613: msc_x_netting_pkg.get_message_type(15) ||

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: -----------------------------------------------------------------------------

Line 3668: msc_x_netting_pkg.add_to_delete_tbl(

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),

Line 3676: msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER,

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,

Line 3677: msc_x_netting_pkg.G_EXCEP16,

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,

Line 3705: l_threshold := msc_pmf_pkg.get_threshold(msc_x_netting_pkg.G_EXCEP16,

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,

Line 3731: l_exception_type := msc_x_netting_pkg.G_EXCEP16; -- your so requires lead time comp.

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:

Line 3732: l_exception_group := msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER;

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:

Line 3733: l_exception_type_name := msc_x_netting_pkg.get_message_type (l_exception_type);

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:

Line 3734: l_exception_group_name := msc_x_netting_pkg.get_message_group (l_exception_group);

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),

Line 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),

Line 3832: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Done: ' ||msc_x_netting_pkg.get_message_type(16) ||

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:

Line 3838: msc_x_netting_pkg.get_message_group(msc_x_netting_pkg.G_POTENTIAL_LATE_ORDER) || ':' || l_inserted_record);

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');