APPS.MSC_EXCHANGE_BUCKETING dependencies on MSC_PLAN_BUCKETS

Line 92: insert into msc_plan_buckets(

88: -1);
89:
90: elsif (p_plan_type = DEMAND_PLANNING) then
91:
92: insert into msc_plan_buckets(
93: plan_id,
94: organization_id,
95: sr_instance_id,
96: bucket_index,

Line 136: insert into msc_plan_buckets(

132: p_days_in_bkt IN NUMBER,
133: p_bkt_type IN NUMBER) IS
134: begin
135:
136: insert into msc_plan_buckets(
137: plan_id,
138: organization_id,
139: sr_instance_id,
140: bucket_index,

Line 326: | weekly buckets into msc_plan_buckets until |

322:
323:
324: /*------------------------------------------------+
325: | Starting with the first date keep entering |
326: | weekly buckets into msc_plan_buckets until |
327: | the weekly buckets are over. |
328: +-------------------------------------------------*/
329:
330: the_date := p_start_date;

Line 564: | into msc_plan_buckets until the daily buckets are over |

560: the_date := p_start_date;
561:
562: /*-------------------------------------------------------+
563: | Starting with the first date keep inserting buckets |
564: | into msc_plan_buckets until the daily buckets are over |
565: +--------------------------------------------------------*/
566:
567:
568: if(p_no_of_days = 0)

Line 698: --delete msc_plan_buckets

694: /*------------------------------------------------------+
695: | Delete the old buckets for the plan. |
696: +-------------------------------------------------------*/
697:
698: --delete msc_plan_buckets
699: --where plan_id = p_plan_id;
700:
701: /*------------------------------------------------------+
702: | Get today's date. This is the first date from which |

Line 1793: | Delete the previous set of data from msc_plan_buckets |

1789: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Calendar code ' || lv_calendar_code || ' for Supplier: ' || l_supplier_name || ' ' ||
1790: l_supplier_site_name || ' and Customer: ' || l_customer_name || ' ' || l_customer_site_name);
1791: */
1792: /*------------------------------------------------------+
1793: | Delete the previous set of data from msc_plan_buckets |
1794: +-------------------------------------------------------*/
1795:
1796: --delete msc_plan_buckets
1797: --where plan_id = -1;

Line 1796: --delete msc_plan_buckets

1792: /*------------------------------------------------------+
1793: | Delete the previous set of data from msc_plan_buckets |
1794: +-------------------------------------------------------*/
1795:
1796: --delete msc_plan_buckets
1797: --where plan_id = -1;
1798:
1799:
1800: /*----------------------------------------------+

Line 1873: delete msc_plan_buckets

1869: l_max_ref_supp := -1;
1870: l_max_supp := 0;
1871: END;
1872: ELSIF (p_plan_type = DEMAND_PLANNING) THEN
1873: delete msc_plan_buckets
1874: where plan_id = -1;
1875: BEGIN
1876: select nvl(max(sd.last_refresh_number), -1),
1877: max(sd.key_date),min(sd.key_date)