330: t_date4 date_arr;
331: t_date5 date_arr;
332: t_order_date1 date_arr;
333: t_order_date2 date_arr;
334: t_company_name msc_x_netting_pkg.publisherList;
335: t_company_site_name msc_x_netting_pkg.pubsiteList;
336: t_item_name msc_x_netting_pkg.itemnameList;
337: t_item_desc msc_x_netting_pkg.itemdescList;
338: t_excep_group msc_x_netting_pkg.excepgroupList;
331: t_date5 date_arr;
332: t_order_date1 date_arr;
333: t_order_date2 date_arr;
334: t_company_name msc_x_netting_pkg.publisherList;
335: t_company_site_name msc_x_netting_pkg.pubsiteList;
336: t_item_name msc_x_netting_pkg.itemnameList;
337: t_item_desc msc_x_netting_pkg.itemdescList;
338: t_excep_group msc_x_netting_pkg.excepgroupList;
339: t_excep_type msc_x_netting_pkg.number_arr;
332: t_order_date1 date_arr;
333: t_order_date2 date_arr;
334: t_company_name msc_x_netting_pkg.publisherList;
335: t_company_site_name msc_x_netting_pkg.pubsiteList;
336: t_item_name msc_x_netting_pkg.itemnameList;
337: t_item_desc msc_x_netting_pkg.itemdescList;
338: t_excep_group msc_x_netting_pkg.excepgroupList;
339: t_excep_type msc_x_netting_pkg.number_arr;
340: t_excep_type_name msc_x_netting_pkg.exceptypeList;
333: t_order_date2 date_arr;
334: t_company_name msc_x_netting_pkg.publisherList;
335: t_company_site_name msc_x_netting_pkg.pubsiteList;
336: t_item_name msc_x_netting_pkg.itemnameList;
337: t_item_desc msc_x_netting_pkg.itemdescList;
338: t_excep_group msc_x_netting_pkg.excepgroupList;
339: t_excep_type msc_x_netting_pkg.number_arr;
340: t_excep_type_name msc_x_netting_pkg.exceptypeList;
341: t_supplier_name msc_x_netting_pkg.supplierList;
334: t_company_name msc_x_netting_pkg.publisherList;
335: t_company_site_name msc_x_netting_pkg.pubsiteList;
336: t_item_name msc_x_netting_pkg.itemnameList;
337: t_item_desc msc_x_netting_pkg.itemdescList;
338: t_excep_group msc_x_netting_pkg.excepgroupList;
339: t_excep_type msc_x_netting_pkg.number_arr;
340: t_excep_type_name msc_x_netting_pkg.exceptypeList;
341: t_supplier_name msc_x_netting_pkg.supplierList;
342: t_supplier_site_name msc_x_netting_pkg.suppsiteList;
335: t_company_site_name msc_x_netting_pkg.pubsiteList;
336: t_item_name msc_x_netting_pkg.itemnameList;
337: t_item_desc msc_x_netting_pkg.itemdescList;
338: t_excep_group msc_x_netting_pkg.excepgroupList;
339: t_excep_type msc_x_netting_pkg.number_arr;
340: t_excep_type_name msc_x_netting_pkg.exceptypeList;
341: t_supplier_name msc_x_netting_pkg.supplierList;
342: t_supplier_site_name msc_x_netting_pkg.suppsiteList;
343: t_supplier_item_name msc_x_netting_pkg.tpitemnameList;
336: t_item_name msc_x_netting_pkg.itemnameList;
337: t_item_desc msc_x_netting_pkg.itemdescList;
338: t_excep_group msc_x_netting_pkg.excepgroupList;
339: t_excep_type msc_x_netting_pkg.number_arr;
340: t_excep_type_name msc_x_netting_pkg.exceptypeList;
341: t_supplier_name msc_x_netting_pkg.supplierList;
342: t_supplier_site_name msc_x_netting_pkg.suppsiteList;
343: t_supplier_item_name msc_x_netting_pkg.tpitemnameList;
344: t_customer_name msc_x_netting_pkg.customerList;
337: t_item_desc msc_x_netting_pkg.itemdescList;
338: t_excep_group msc_x_netting_pkg.excepgroupList;
339: t_excep_type msc_x_netting_pkg.number_arr;
340: t_excep_type_name msc_x_netting_pkg.exceptypeList;
341: t_supplier_name msc_x_netting_pkg.supplierList;
342: t_supplier_site_name msc_x_netting_pkg.suppsiteList;
343: t_supplier_item_name msc_x_netting_pkg.tpitemnameList;
344: t_customer_name msc_x_netting_pkg.customerList;
345: t_customer_site_name msc_x_netting_pkg.custsiteList;
338: t_excep_group msc_x_netting_pkg.excepgroupList;
339: t_excep_type msc_x_netting_pkg.number_arr;
340: t_excep_type_name msc_x_netting_pkg.exceptypeList;
341: t_supplier_name msc_x_netting_pkg.supplierList;
342: t_supplier_site_name msc_x_netting_pkg.suppsiteList;
343: t_supplier_item_name msc_x_netting_pkg.tpitemnameList;
344: t_customer_name msc_x_netting_pkg.customerList;
345: t_customer_site_name msc_x_netting_pkg.custsiteList;
346: t_customer_item_name msc_x_netting_pkg.tpitemnameList;
339: t_excep_type msc_x_netting_pkg.number_arr;
340: t_excep_type_name msc_x_netting_pkg.exceptypeList;
341: t_supplier_name msc_x_netting_pkg.supplierList;
342: t_supplier_site_name msc_x_netting_pkg.suppsiteList;
343: t_supplier_item_name msc_x_netting_pkg.tpitemnameList;
344: t_customer_name msc_x_netting_pkg.customerList;
345: t_customer_site_name msc_x_netting_pkg.custsiteList;
346: t_customer_item_name msc_x_netting_pkg.tpitemnameList;
347: t_order_number msc_x_netting_pkg.ordernumberList;
340: t_excep_type_name msc_x_netting_pkg.exceptypeList;
341: t_supplier_name msc_x_netting_pkg.supplierList;
342: t_supplier_site_name msc_x_netting_pkg.suppsiteList;
343: t_supplier_item_name msc_x_netting_pkg.tpitemnameList;
344: t_customer_name msc_x_netting_pkg.customerList;
345: t_customer_site_name msc_x_netting_pkg.custsiteList;
346: t_customer_item_name msc_x_netting_pkg.tpitemnameList;
347: t_order_number msc_x_netting_pkg.ordernumberList;
348: t_release_number msc_x_netting_pkg.releasenumList;
341: t_supplier_name msc_x_netting_pkg.supplierList;
342: t_supplier_site_name msc_x_netting_pkg.suppsiteList;
343: t_supplier_item_name msc_x_netting_pkg.tpitemnameList;
344: t_customer_name msc_x_netting_pkg.customerList;
345: t_customer_site_name msc_x_netting_pkg.custsiteList;
346: t_customer_item_name msc_x_netting_pkg.tpitemnameList;
347: t_order_number msc_x_netting_pkg.ordernumberList;
348: t_release_number msc_x_netting_pkg.releasenumList;
349: t_line_number msc_x_netting_pkg.linenumList;
342: t_supplier_site_name msc_x_netting_pkg.suppsiteList;
343: t_supplier_item_name msc_x_netting_pkg.tpitemnameList;
344: t_customer_name msc_x_netting_pkg.customerList;
345: t_customer_site_name msc_x_netting_pkg.custsiteList;
346: t_customer_item_name msc_x_netting_pkg.tpitemnameList;
347: t_order_number msc_x_netting_pkg.ordernumberList;
348: t_release_number msc_x_netting_pkg.releasenumList;
349: t_line_number msc_x_netting_pkg.linenumList;
350: t_end_order_num msc_x_netting_pkg.ordernumberList;
343: t_supplier_item_name msc_x_netting_pkg.tpitemnameList;
344: t_customer_name msc_x_netting_pkg.customerList;
345: t_customer_site_name msc_x_netting_pkg.custsiteList;
346: t_customer_item_name msc_x_netting_pkg.tpitemnameList;
347: t_order_number msc_x_netting_pkg.ordernumberList;
348: t_release_number msc_x_netting_pkg.releasenumList;
349: t_line_number msc_x_netting_pkg.linenumList;
350: t_end_order_num msc_x_netting_pkg.ordernumberList;
351: t_end_order_rel_num msc_x_netting_pkg.releasenumList;
344: t_customer_name msc_x_netting_pkg.customerList;
345: t_customer_site_name msc_x_netting_pkg.custsiteList;
346: t_customer_item_name msc_x_netting_pkg.tpitemnameList;
347: t_order_number msc_x_netting_pkg.ordernumberList;
348: t_release_number msc_x_netting_pkg.releasenumList;
349: t_line_number msc_x_netting_pkg.linenumList;
350: t_end_order_num msc_x_netting_pkg.ordernumberList;
351: t_end_order_rel_num msc_x_netting_pkg.releasenumList;
352: t_end_order_line_num msc_x_netting_pkg.linenumList;
345: t_customer_site_name msc_x_netting_pkg.custsiteList;
346: t_customer_item_name msc_x_netting_pkg.tpitemnameList;
347: t_order_number msc_x_netting_pkg.ordernumberList;
348: t_release_number msc_x_netting_pkg.releasenumList;
349: t_line_number msc_x_netting_pkg.linenumList;
350: t_end_order_num msc_x_netting_pkg.ordernumberList;
351: t_end_order_rel_num msc_x_netting_pkg.releasenumList;
352: t_end_order_line_num msc_x_netting_pkg.linenumList;
353: t_exception_basis msc_x_netting_pkg.exceptbasisList;
346: t_customer_item_name msc_x_netting_pkg.tpitemnameList;
347: t_order_number msc_x_netting_pkg.ordernumberList;
348: t_release_number msc_x_netting_pkg.releasenumList;
349: t_line_number msc_x_netting_pkg.linenumList;
350: t_end_order_num msc_x_netting_pkg.ordernumberList;
351: t_end_order_rel_num msc_x_netting_pkg.releasenumList;
352: t_end_order_line_num msc_x_netting_pkg.linenumList;
353: t_exception_basis msc_x_netting_pkg.exceptbasisList;
354:
347: t_order_number msc_x_netting_pkg.ordernumberList;
348: t_release_number msc_x_netting_pkg.releasenumList;
349: t_line_number msc_x_netting_pkg.linenumList;
350: t_end_order_num msc_x_netting_pkg.ordernumberList;
351: t_end_order_rel_num msc_x_netting_pkg.releasenumList;
352: t_end_order_line_num msc_x_netting_pkg.linenumList;
353: t_exception_basis msc_x_netting_pkg.exceptbasisList;
354:
355: l_inserted_record number;
348: t_release_number msc_x_netting_pkg.releasenumList;
349: t_line_number msc_x_netting_pkg.linenumList;
350: t_end_order_num msc_x_netting_pkg.ordernumberList;
351: t_end_order_rel_num msc_x_netting_pkg.releasenumList;
352: t_end_order_line_num msc_x_netting_pkg.linenumList;
353: t_exception_basis msc_x_netting_pkg.exceptbasisList;
354:
355: l_inserted_record number;
356: l_oem_site_id number;
349: t_line_number msc_x_netting_pkg.linenumList;
350: t_end_order_num msc_x_netting_pkg.ordernumberList;
351: t_end_order_rel_num msc_x_netting_pkg.releasenumList;
352: t_end_order_line_num msc_x_netting_pkg.linenumList;
353: t_exception_basis msc_x_netting_pkg.exceptbasisList;
354:
355: l_inserted_record number;
356: l_oem_site_id number;
357: l_oem_id number; -- Bug #6242828
1642: t_supplier_site_id number_arr;
1643: t_customer_id number_arr;
1644: t_customer_site_id number_arr;
1645:
1646: t_company_name msc_x_netting_pkg.publisherList;
1647: t_company_site_name msc_x_netting_pkg.pubsiteList;
1648: t_item_name msc_x_netting_pkg.itemnameList;
1649: t_item_desc msc_x_netting_pkg.itemdescList;
1650: t_supplier_name msc_x_netting_pkg.publisherList;
1643: t_customer_id number_arr;
1644: t_customer_site_id number_arr;
1645:
1646: t_company_name msc_x_netting_pkg.publisherList;
1647: t_company_site_name msc_x_netting_pkg.pubsiteList;
1648: t_item_name msc_x_netting_pkg.itemnameList;
1649: t_item_desc msc_x_netting_pkg.itemdescList;
1650: t_supplier_name msc_x_netting_pkg.publisherList;
1651: t_supplier_site_name msc_x_netting_pkg.pubsiteList;
1644: t_customer_site_id number_arr;
1645:
1646: t_company_name msc_x_netting_pkg.publisherList;
1647: t_company_site_name msc_x_netting_pkg.pubsiteList;
1648: t_item_name msc_x_netting_pkg.itemnameList;
1649: t_item_desc msc_x_netting_pkg.itemdescList;
1650: t_supplier_name msc_x_netting_pkg.publisherList;
1651: t_supplier_site_name msc_x_netting_pkg.pubsiteList;
1652: t_customer_name msc_x_netting_pkg.publisherList;
1645:
1646: t_company_name msc_x_netting_pkg.publisherList;
1647: t_company_site_name msc_x_netting_pkg.pubsiteList;
1648: t_item_name msc_x_netting_pkg.itemnameList;
1649: t_item_desc msc_x_netting_pkg.itemdescList;
1650: t_supplier_name msc_x_netting_pkg.publisherList;
1651: t_supplier_site_name msc_x_netting_pkg.pubsiteList;
1652: t_customer_name msc_x_netting_pkg.publisherList;
1653: t_customer_site_name msc_x_netting_pkg.pubsiteList;
1646: t_company_name msc_x_netting_pkg.publisherList;
1647: t_company_site_name msc_x_netting_pkg.pubsiteList;
1648: t_item_name msc_x_netting_pkg.itemnameList;
1649: t_item_desc msc_x_netting_pkg.itemdescList;
1650: t_supplier_name msc_x_netting_pkg.publisherList;
1651: t_supplier_site_name msc_x_netting_pkg.pubsiteList;
1652: t_customer_name msc_x_netting_pkg.publisherList;
1653: t_customer_site_name msc_x_netting_pkg.pubsiteList;
1654: t_version number_arr;
1647: t_company_site_name msc_x_netting_pkg.pubsiteList;
1648: t_item_name msc_x_netting_pkg.itemnameList;
1649: t_item_desc msc_x_netting_pkg.itemdescList;
1650: t_supplier_name msc_x_netting_pkg.publisherList;
1651: t_supplier_site_name msc_x_netting_pkg.pubsiteList;
1652: t_customer_name msc_x_netting_pkg.publisherList;
1653: t_customer_site_name msc_x_netting_pkg.pubsiteList;
1654: t_version number_arr;
1655: t_designator designatorList;
1648: t_item_name msc_x_netting_pkg.itemnameList;
1649: t_item_desc msc_x_netting_pkg.itemdescList;
1650: t_supplier_name msc_x_netting_pkg.publisherList;
1651: t_supplier_site_name msc_x_netting_pkg.pubsiteList;
1652: t_customer_name msc_x_netting_pkg.publisherList;
1653: t_customer_site_name msc_x_netting_pkg.pubsiteList;
1654: t_version number_arr;
1655: t_designator designatorList;
1656:
1649: t_item_desc msc_x_netting_pkg.itemdescList;
1650: t_supplier_name msc_x_netting_pkg.publisherList;
1651: t_supplier_site_name msc_x_netting_pkg.pubsiteList;
1652: t_customer_name msc_x_netting_pkg.publisherList;
1653: t_customer_site_name msc_x_netting_pkg.pubsiteList;
1654: t_version number_arr;
1655: t_designator designatorList;
1656:
1657: