241: and organization_id = G_GROUP8
242: and sr_instance_id = G_SR_INSTANCE_ID;
243: --dbms_output.put_line('Max refresh_number : ' || l_changed_order_refnum);
244:
245: msc_x_netting4_pkg.compute_changed_order(l_changed_order_refnum,
246: t_company_list,
247: t_company_site_list,
248: t_customer_list,
249: t_customer_site_list,
791: and organization_id = G_GROUP9
792: and sr_instance_id = G_SR_INSTANCE_ID;
793: --dbms_output.put_line('Max refresh_number : ' || l_forecast_accuracy_refnum);
794:
795: msc_x_netting4_pkg.compute_forecast_accuracy(
796: a_company_id,
797: a_company_name,
798: a_company_site_id,
799: a_company_site_name,
855: and organization_id = G_GROUP10
856: and sr_instance_id = G_SR_INSTANCE_ID;
857: --dbms_output.put_line('Max refresh_number : ' || l_performance_refnum);
858:
859: msc_x_netting4_pkg.compute_performance(
860: a_company_id,
861: a_company_name,
862: a_company_site_id,
863: a_company_site_name,
910: and sr_instance_id = G_SR_INSTANCE_ID;
911:
912: END IF;
913: IF (p_custom_exception in (to_char(1),'Y')) THEN
914: msc_x_netting4_pkg.compute_custom_exception;
915: END IF;
916:
917:
918: --================================================