eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_AATP_FUNC dependencies on MSC_AATP_FUNC

Line 1: PACKAGE BODY MSC_AATP_FUNC AS

1: PACKAGE BODY MSC_AATP_FUNC AS
2: /* $Header: MSCFAATB.pls 120.1.12010000.2 2008/08/25 10:40:06 sbnaik ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MSC_AATP_FUNC';
4:
5: -- INFINITE_NUMBER CONSTANT NUMBER := 1.0e+10;

Line 3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MSC_AATP_FUNC';

1: PACKAGE BODY MSC_AATP_FUNC AS
2: /* $Header: MSCFAATB.pls 120.1.12010000.2 2008/08/25 10:40:06 sbnaik ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MSC_AATP_FUNC';
4:
5: -- INFINITE_NUMBER CONSTANT NUMBER := 1.0e+10;
6:
7: -- demand type

Line 62: l_alloc_rule := MSC_AATP_FUNC.Get_DC_Alloc_Percent(p_instance_id, p_inventory_item_id, p_org_id,

58: msc_sch_wb.atp_debug('p_demand_class =' || p_demand_class);
59: msc_sch_wb.atp_debug('p_record_class =' || p_record_class);
60: END IF;
61:
62: l_alloc_rule := MSC_AATP_FUNC.Get_DC_Alloc_Percent(p_instance_id, p_inventory_item_id, p_org_id,
63: null, null, p_demand_class, p_demand_date);
64: IF PG_DEBUG in ('Y', 'C') THEN
65: msc_sch_wb.atp_debug('l_alloc_rule : '||l_alloc_rule);
66: END IF;

Line 76: l_alloc_rule := MSC_AATP_FUNC.Get_DC_Alloc_Percent(p_instance_id, p_inventory_item_id, p_org_id,

72: IF l_alloc_rule IS NULL AND
73: p_demand_date < trunc(sysdate) AND
74: p_origination_type in (DEMAND_SALES_ORDER, DEMAND_SALES_ORDER_MDS)
75: THEN
76: l_alloc_rule := MSC_AATP_FUNC.Get_DC_Alloc_Percent(p_instance_id, p_inventory_item_id, p_org_id,
77: null, null, p_demand_class,sysdate);
78: END IF;
79:
80: IF l_alloc_rule IS NULL THEN

Line 156: and MSC_AATP_FUNC.get_hierarchy_demand_class(d.customer_id, d.ship_to_site_id,d.inventory_item_id, d.organization_id, d.sr_instance_id, p_demand_date, p_level_id, null) = p_demand_class;

152: into l_alloc_percent
153: from msc_demands d
154: where d.plan_id = p_plan_id
155: and d.demand_id = p_demand_id
156: and MSC_AATP_FUNC.get_hierarchy_demand_class(d.customer_id, d.ship_to_site_id,d.inventory_item_id, d.organization_id, d.sr_instance_id, p_demand_date, p_level_id, null) = p_demand_class;
157:
158:
159: END IF; -- IF G_HIERARCHY_PROFILE = 1 THEN
160:

Line 169: l_alloc_percent := MSC_AATP_FUNC.Get_DC_Alloc_Percent(

165: -- hard reservation of 20 (irrespective of the demand class), we shall be
166: -- allocating only the balance (100 - 20 = 80) based on allocation rule of
167: -- the requested demand class.
168:
169: l_alloc_percent := MSC_AATP_FUNC.Get_DC_Alloc_Percent(
170: p_instance_id, p_assembly_item_id, p_org_id,
171: null, null, p_demand_class, p_demand_date);
172: END IF;
173:

Line 222: l_alloc_percent := MSC_AATP_FUNC.Get_DC_Alloc_Percent(

218: -- If no rule at component level, consider every demand and supply, that means
219: -- consider allocation percent to be 1 (100%), else check if there is a rule at
220: -- parent level and use that rule.
221: /*
222: l_alloc_percent := MSC_AATP_FUNC.Get_DC_Alloc_Percent(
223: p_instance_id, p_inventory_item_id, p_org_id,
224: null, null, p_demand_class, p_demand_date);
225:
226: IF PG_DEBUG in ('Y', 'C') THEN

Line 242: l_alloc_percent := NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(

238: ELSE
239: /* To support new logic for dependent demands allocation in time phased PF rule based AATP scenarios
240: As per the new logic for we don't time phased ATP allocation logic at assembly. So we always pass
241: p_assembly_item_id irrespective of whether assembly item is time phased PF enabled or not*/
242: l_alloc_percent := NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(
243: p_instance_id, p_assembly_item_id,
244: NVL(p_source_org_id, p_org_id),
245: null, null,p_demand_class, p_demand_date), l_alloc_rule);
246: END IF;

Line 619: l_alloc_rule := MSC_AATP_FUNC.Get_DC_Alloc_Percent(p_instance_id, null, p_org_id, p_dept_id,

615: END IF;
616:
617: --Check if there is any allocation rule for the resource
618:
619: l_alloc_rule := MSC_AATP_FUNC.Get_DC_Alloc_Percent(p_instance_id, null, p_org_id, p_dept_id,
620: p_res_id, p_demand_class, p_demand_date);
621:
622: IF PG_DEBUG in ('Y', 'C') THEN
623: msc_sch_wb.atp_debug('Get_Res_Demand_Alloc_Percent: ' || 'After resource DC Alloc rule :' ||to_char(l_alloc_rule));

Line 635: l_alloc_percent := NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p_instance_id, p_assembly_item_id, p_org_id,

631: l_alloc_percent := 0;
632: ELSE
633: -- this is dependent demand, we see how we alocate the parent supply,
634: -- and do the same thing for its demand
635: l_alloc_percent := NVL(MSC_AATP_FUNC.Get_DC_Alloc_Percent(p_instance_id, p_assembly_item_id, p_org_id,
636: null, null, p_demand_class, p_demand_date), l_alloc_rule);
637: IF PG_DEBUG in ('Y', 'C') THEN
638: msc_sch_wb.atp_debug('Get_Res_Demand_Alloc_Percent: ' || 'After parent item DC Alloc Percent :' ||to_char(l_alloc_percent));
639: END IF;

Line 646: l_alloc_percent := MSC_AATP_FUNC.Get_DC_Alloc_Percent(p_instance_id, null, p_org_id,

642: -- If no allocation percentage specified for any demand classes for
643: -- specified time period, get the allocation percentage for department
644: -- resource.
645: IF l_alloc_percent IS NULL THEN
646: l_alloc_percent := MSC_AATP_FUNC.Get_DC_Alloc_Percent(p_instance_id, null, p_org_id,
647: p_dept_id, p_res_id, p_demand_class, p_demand_date);
648: END IF;
649: */
650: IF PG_DEBUG in ('Y', 'C') THEN

Line 1796: END MSC_AATP_FUNC;

1792: RETURN NVL(l_hierarchy_demand_class, '-1'); -- 1680773
1793:
1794: END Get_Res_Hierarchy_Demand_Class;
1795:
1796: END MSC_AATP_FUNC;