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_ATP_PVT

Line 215: msc_sch_wb.atp_debug('Get_Item_Demand_Alloc_Percent: ' || 'G_TIME_PHASED_PF_ENABLED := ' || MSC_ATP_PVT.G_TIME_PHASED_PF_ENABLED);

211: -- and do the same thing for it's demand
212:
213: IF PG_DEBUG in ('Y', 'C') THEN
214: msc_sch_wb.atp_debug('this is dependent demand');
215: msc_sch_wb.atp_debug('Get_Item_Demand_Alloc_Percent: ' || 'G_TIME_PHASED_PF_ENABLED := ' || MSC_ATP_PVT.G_TIME_PHASED_PF_ENABLED);
216: END IF;
217: -- Check if there is an allocation rule defined at component level.
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

Line 236: IF MSC_ATP_PVT.G_TIME_PHASED_PF_ENABLED = 'Y' THEN

232:
233: /* To support new logic for dependent demands allocation in time phased PF rule based AATP scenarios
234: As per the new logic for dependent demand allocation use allocation rule for component only if
235: component is time phased PF ATP enabled*/
236: IF MSC_ATP_PVT.G_TIME_PHASED_PF_ENABLED = 'Y' THEN
237: l_alloc_percent := l_alloc_rule;
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

Line 703: IF (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') THEN

699: -- we are doing the demand class
700: -- this would happen only in case 1
701: l_hierarchy_demand_class := p_demand_class;
702:
703: IF (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') THEN
704:
705: BEGIN
706: --diag_atp
707: SELECT distinct time_phase_id, allocation_rule_name

Line 708: INTO l_time_phase_id, MSC_ATP_PVT.G_ALLOCATION_RULE_NAME

704:
705: BEGIN
706: --diag_atp
707: SELECT distinct time_phase_id, allocation_rule_name
708: INTO l_time_phase_id, MSC_ATP_PVT.G_ALLOCATION_RULE_NAME
709: FROM msc_item_hierarchy_mv
710: WHERE inventory_item_id = p_inventory_item_id
711: AND organization_id = p_organization_id
712: AND sr_instance_id = p_instance_id

Line 717: MSC_ATP_PVT.G_ALLOCATION_RULE_NAME := null;

713: AND greatest(p_request_date,trunc(sysdate)) between effective_date and disable_date; --bug3099066
714: EXCEPTION
715: WHEN NO_DATA_FOUND THEN
716: l_time_phase_id := NULL;
717: MSC_ATP_PVT.G_ALLOCATION_RULE_NAME := null;
718: END;
719:
720: IF PG_DEBUG in ('Y', 'C') THEN
721: msc_sch_wb.atp_debug('Get_Hierarchy_Demand_Class: ' || 'l_time_phase_id '||l_time_phase_id);

Line 776: INTO l_time_phase_id, MSC_ATP_PVT.G_ALLOCATION_RULE_NAME

772:
773: BEGIN
774: --diag_atp
775: SELECT distinct time_phase_id, allocation_rule_name
776: INTO l_time_phase_id, MSC_ATP_PVT.G_ALLOCATION_RULE_NAME
777: FROM msc_item_hierarchy_mv
778: WHERE inventory_item_id = p_inventory_item_id
779: AND organization_id = p_organization_id
780: AND sr_instance_id = p_instance_id

Line 786: MSC_ATP_PVT.G_ALLOCATION_RULE_NAME := null;

782: EXCEPTION
783: WHEN NO_DATA_FOUND THEN
784: l_time_phase_id := NULL;
785: --diag_atp
786: MSC_ATP_PVT.G_ALLOCATION_RULE_NAME := null;
787: --bug 2424357: trat others as -1
788: --return '@@@'; -- since there is no time phase id
789: return '-1'; -- since there is no time phase id
790: -- we won't find the dummy demand class

Line 1399: IF (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') THEN

1395: -- we are doing the demand class
1396: -- this would happen only in case 1
1397: l_hierarchy_demand_class := p_demand_class;
1398:
1399: IF (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') THEN
1400:
1401: BEGIN
1402: --diag_atp
1403: SELECT distinct time_phase_id, allocation_rule_name

Line 1404: INTO l_time_phase_id, MSC_ATP_PVT.G_ALLOCATION_RULE_NAME

1400:
1401: BEGIN
1402: --diag_atp
1403: SELECT distinct time_phase_id, allocation_rule_name
1404: INTO l_time_phase_id, MSC_ATP_PVT.G_ALLOCATION_RULE_NAME
1405: FROM msc_resource_hierarchy_mv
1406: WHERE resource_id = p_resource_id
1407: AND department_id = p_department_id
1408: AND organization_id = p_organization_id

Line 1416: MSC_ATP_PVT.G_ALLOCATION_RULE_NAME := null;

1412: WHEN NO_DATA_FOUND THEN
1413:
1414: l_time_phase_id := NULL;
1415: --diag_atp
1416: MSC_ATP_PVT.G_ALLOCATION_RULE_NAME := null;
1417: END;
1418:
1419: IF PG_DEBUG in ('Y', 'C') THEN
1420: msc_sch_wb.atp_debug('Get_Res_Hierarchy_Demand_Class: ' || 'l_time_phase_id '||l_time_phase_id);

Line 1475: INTO l_time_phase_id, MSC_ATP_PVT.G_ALLOCATION_RULE_NAME

1471:
1472: BEGIN
1473:
1474: SELECT distinct time_phase_id, allocation_rule_name
1475: INTO l_time_phase_id, MSC_ATP_PVT.G_ALLOCATION_RULE_NAME
1476: FROM msc_resource_hierarchy_mv
1477: WHERE resource_id = p_resource_id
1478: AND department_id = p_department_id
1479: AND organization_id = p_organization_id

Line 1486: MSC_ATP_PVT.G_ALLOCATION_RULE_NAME := null;

1482: EXCEPTION
1483: WHEN NO_DATA_FOUND THEN
1484: l_time_phase_id := NULL;
1485: --diag_atp
1486: MSC_ATP_PVT.G_ALLOCATION_RULE_NAME := null;
1487: --bug 2424357: trat others as -1
1488: --return '@@@'; -- since there is no time phase id
1489: return '-1'; -- since there is no time phase id
1490: -- we won't find the dummy demand class