APPS.MSC_PHUB_PKG dependencies on MSC_EXCEPTIONS_F

Line 2052: select count(*) into l_n from msc_exceptions_f where customer_id>0 and customer_region_id>0 and rownum=1;

2048: update msc_costs_f set customer_region_id=-23453 where customer_id>0;
2049: commit;
2050: end if;
2051:
2052: select count(*) into l_n from msc_exceptions_f where customer_id>0 and customer_region_id>0 and rownum=1;
2053: if (l_n > 0) then
2054: msc_phub_util.log('update msc_exceptions_f set customer_region_id=-23453 where customer_id>0');
2055: update msc_exceptions_f set customer_region_id=-23453 where customer_id>0;
2056: commit;

Line 2054: msc_phub_util.log('update msc_exceptions_f set customer_region_id=-23453 where customer_id>0');

2050: end if;
2051:
2052: select count(*) into l_n from msc_exceptions_f where customer_id>0 and customer_region_id>0 and rownum=1;
2053: if (l_n > 0) then
2054: msc_phub_util.log('update msc_exceptions_f set customer_region_id=-23453 where customer_id>0');
2055: update msc_exceptions_f set customer_region_id=-23453 where customer_id>0;
2056: commit;
2057: end if;
2058:

Line 2055: update msc_exceptions_f set customer_region_id=-23453 where customer_id>0;

2051:
2052: select count(*) into l_n from msc_exceptions_f where customer_id>0 and customer_region_id>0 and rownum=1;
2053: if (l_n > 0) then
2054: msc_phub_util.log('update msc_exceptions_f set customer_region_id=-23453 where customer_id>0');
2055: update msc_exceptions_f set customer_region_id=-23453 where customer_id>0;
2056: commit;
2057: end if;
2058:
2059: exception