APPS.MSC_PHUB_PKG dependencies on MSC_DEMANDS_CUM_F

Line 2024: select count(*) into l_n from msc_demands_cum_f where customer_id>0 and region_id>0 and rownum=1;

2020: update msc_demands_f set region_id=-23453 where customer_id>0;
2021: commit;
2022: end if;
2023:
2024: select count(*) into l_n from msc_demands_cum_f where customer_id>0 and region_id>0 and rownum=1;
2025: if (l_n > 0) then
2026: msc_phub_util.log('update msc_demands_cum_f set region_id=-23453 where customer_id>0');
2027: update msc_demands_cum_f set region_id=-23453 where customer_id>0;
2028: commit;

Line 2026: msc_phub_util.log('update msc_demands_cum_f set region_id=-23453 where customer_id>0');

2022: end if;
2023:
2024: select count(*) into l_n from msc_demands_cum_f where customer_id>0 and region_id>0 and rownum=1;
2025: if (l_n > 0) then
2026: msc_phub_util.log('update msc_demands_cum_f set region_id=-23453 where customer_id>0');
2027: update msc_demands_cum_f set region_id=-23453 where customer_id>0;
2028: commit;
2029: end if;
2030:

Line 2027: update msc_demands_cum_f set region_id=-23453 where customer_id>0;

2023:
2024: select count(*) into l_n from msc_demands_cum_f where customer_id>0 and region_id>0 and rownum=1;
2025: if (l_n > 0) then
2026: msc_phub_util.log('update msc_demands_cum_f set region_id=-23453 where customer_id>0');
2027: update msc_demands_cum_f set region_id=-23453 where customer_id>0;
2028: commit;
2029: end if;
2030:
2031: select count(*) into l_n from msc_demantra_f where customer_id>0 and region_id>0 and rownum=1;