APPS.MSC_DEMAND_PKG dependencies on MSC_HUB_CALENDAR

Line 268: msc_hub_calendar.last_work_date(p_plan_id,l_curr_start_date),

264: demand_tbl.owning_inst_id,
265: ----- we an not just put it in curr_start_date
266: ----- need to put it in last working day of the bucket where plan start date in
267: decode(sign(to_number(demand_tbl.order_date-l_curr_start_date)),-1,
268: msc_hub_calendar.last_work_date(p_plan_id,l_curr_start_date),
269: demand_tbl.order_date),
270: to_number(0) aggr_type,
271: to_number(-23453) category_set_id,
272: to_number(-23453) sr_category_id,

Line 330: decode(md.organization_id,-1, msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,

326:
327: nvl(md.zone_id, -23453) region_id,
328: nvl(md.demand_class, -23453) demand_class,
329:
330: decode(md.organization_id,-1, msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,
331: decode(md.sr_instance_id,-1, mp.sr_instance_id, md.sr_instance_id)),
332: md.organization_id) owning_org_id,
333:
334: --- we assume that the item must exist in plan's owning inst

Line 713: msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,

709: where md.plan_id = p_plan_id
710: and msi.plan_id = md.plan_id
711: and msi.sr_instance_id = decode(md.sr_instance_id, -1, mp.sr_instance_id, md.sr_instance_id)
712: and msi.organization_id = decode(md.organization_id,-1,
713: msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,
714: decode(md.sr_instance_id, -1, mp.sr_instance_id, md.sr_instance_id)),
715: md.organization_id)
716:
717: and msi.inventory_item_id = md.inventory_item_id

Line 733: decode(md.organization_id, -1, msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,

729: nvl(md.customer_site_id, -23453),
730: nvl(md.zone_id, -23453),
731: nvl(md.demand_class, -23453),
732:
733: decode(md.organization_id, -1, msc_hub_calendar.get_item_org(p_plan_id, md.inventory_item_id,
734: decode(md.sr_instance_id, -1, mp.sr_instance_id, md.sr_instance_id)),
735: md.organization_id),
736:
737: decode(md.sr_instance_id, -1, mp.sr_instance_id, md.sr_instance_id),

Line 975: msc_hub_calendar.last_work_date(p_plan_id,l_curr_start_date),

971: demand_tbl.demand_class,
972: demand_tbl.owning_org_id,
973: demand_tbl.owning_inst_id,
974: decode(sign(to_number(demand_tbl.order_date-l_curr_start_date)),-1,
975: msc_hub_calendar.last_work_date(p_plan_id,l_curr_start_date),
976: demand_tbl.order_date),
977: demand_tbl.order_type,
978: demand_tbl.vmi_flag;
979: