APPS.MSC_PHUB_PKG dependencies on MSC_PLAN_BUCKETS

Line 395: from msc_plan_buckets

391: null publisher
392: into l_pi
393: from msc_plans p,
394: (select plan_id, min(bkt_start_date) bkt_start_date, max(bkt_end_date) bkt_end_date
395: from msc_plan_buckets
396: where curr_flag=1
397: group by plan_id
398: ) b
399: where p.plan_id=p_plan_id

Line 1859: --populate msc_plan_buckets one row for days between sysdate and l_horizon_date

1855: into l_lcid
1856: from msc_apps_instances
1857: where instance_id=p_sr_instance_id;
1858:
1859: --populate msc_plan_buckets one row for days between sysdate and l_horizon_date
1860: msc_phub_util.log('Populating msc_plan_buckets');
1861: delete from msc_plan_buckets
1862: where plan_id=-1;
1863: commit;

Line 1860: msc_phub_util.log('Populating msc_plan_buckets');

1856: from msc_apps_instances
1857: where instance_id=p_sr_instance_id;
1858:
1859: --populate msc_plan_buckets one row for days between sysdate and l_horizon_date
1860: msc_phub_util.log('Populating msc_plan_buckets');
1861: delete from msc_plan_buckets
1862: where plan_id=-1;
1863: commit;
1864:

Line 1861: delete from msc_plan_buckets

1857: where instance_id=p_sr_instance_id;
1858:
1859: --populate msc_plan_buckets one row for days between sysdate and l_horizon_date
1860: msc_phub_util.log('Populating msc_plan_buckets');
1861: delete from msc_plan_buckets
1862: where plan_id=-1;
1863: commit;
1864:
1865: for v_counter in 1 .. l_days_back + l_days_forward + 1 loop

Line 1866: insert into msc_plan_buckets (

1862: where plan_id=-1;
1863: commit;
1864:
1865: for v_counter in 1 .. l_days_back + l_days_forward + 1 loop
1866: insert into msc_plan_buckets (
1867: plan_id,
1868: organization_id,
1869: sr_instance_id,
1870: bucket_index,