DBA Data[Home] [Help]

APPS.MSC_EXCEPTION_PKG dependencies on MSC_HUB_CALENDAR

Line 177: -1, msc_hub_calendar.get_item_org(p_plan_id, med.inventory_item_id,

173: 19, decode(med.number4,null,nvl(ms.task_id,-23453),med.number1),
174: nvl(md.task_id, nvl(ms.task_id,-23453)) ) task_id,
175:
176: decode(sign(nvl(med.organization_id, -23453)),
177: -1, msc_hub_calendar.get_item_org(p_plan_id, med.inventory_item_id,
178: decode(sign(nvl(med.sr_instance_id, -23453)),
179: -1, mp.sr_instance_id, med.sr_instance_id)),
180: med.organization_id) owning_org_id,
181:

Line 447: -1, msc_hub_calendar.get_item_org(p_plan_id, med.inventory_item_id,

443: 19, decode(med.number4,null,nvl(ms.task_id,-23453),med.number1),
444: nvl(md.task_id, nvl(ms.task_id,-23453)) ),
445:
446: decode(sign(nvl(med.organization_id, -23453)),
447: -1, msc_hub_calendar.get_item_org(p_plan_id, med.inventory_item_id,
448: decode(sign(nvl(med.sr_instance_id, -23453)),
449: -1, mp.sr_instance_id, med.sr_instance_id)),
450: med.organization_id),
451:

Line 545: -1, msc_hub_calendar.get_item_org(p_plan_id, med.inventory_item_id,

541: nvl(med.customer_site_id, -23453) customer_site_id,
542: nvl(med.zone_id, -23453) customer_region_id,
543:
544: decode(sign(nvl(med.organization_id, -23453)),
545: -1, msc_hub_calendar.get_item_org(p_plan_id, med.inventory_item_id,
546: decode(sign(nvl(med.sr_instance_id, -23453)),
547: -1, mp.sr_instance_id, med.sr_instance_id)),
548: med.organization_id) owning_org_id,
549: