[Home] [Help]
725:
726: BEGIN
727: SELECT distinct demand_class
728: INTO l_hierarchy_demand_class
729: FROM msc_allocations
730: WHERE demand_class = p_demand_class
731: AND time_phase_id = l_time_phase_id
732: --AND level_id = 1 -- demand_class hence no level_id
733: --AND class = '-1' -- demand_class hence no customer_class
808:
809: BEGIN
810: SELECT distinct demand_class
811: INTO l_hierarchy_demand_class
812: FROM msc_allocations
813: WHERE level_id = 3
814: AND time_phase_id = l_time_phase_id
815: AND class = l_class_code
816: AND partner_id = p_partner_id
839:
840: BEGIN
841: SELECT distinct demand_class
842: INTO l_hierarchy_demand_class
843: FROM msc_allocations
844: WHERE level_id = 3
845: AND time_phase_id = l_time_phase_id
846: AND class = l_class_code
847: AND partner_id = p_partner_id
880: ---bug 2424357: Since we have will always have 'OTHERS' we wouldn't need
881: --- to check the following condition
882: /*SELECT count(*)
883: INTO l_temp
884: FROM msc_allocations
885: WHERE level_id =3
886: AND time_phase_id = l_time_phase_id
887: AND class = l_class_code
888: AND partner_id = p_partner_id;
896: msc_sch_wb.atp_debug('Get_Hierarchy_Demand_Class: ' || 'l_class_code = '||l_class_code);
897: END IF;
898: SELECT distinct demand_class
899: INTO l_hierarchy_demand_class
900: FROM msc_allocations
901: WHERE level_id = 3
902: AND time_phase_id = l_time_phase_id
903: AND class = l_class_code
904: AND partner_id = -1
951: END IF;
952:
953: /*SELECT count(*)
954: INTO l_temp
955: FROM msc_allocations
956: WHERE level_id =3
957: AND time_phase_id = l_time_phase_id
958: AND class = l_class_code;
959:
962:
963: BEGIN
964: SELECT distinct demand_class
965: INTO l_hierarchy_demand_class
966: FROM msc_allocations
967: WHERE level_id = 3
968: AND time_phase_id = l_time_phase_id
969: AND class = '-1'
970: AND partner_id = -1
1001: -- that class_code+partner_id
1002: BEGIN
1003: SELECT distinct demand_class
1004: INTO l_hierarchy_demand_class
1005: FROM msc_allocations
1006: WHERE level_id = 2
1007: AND time_phase_id = l_time_phase_id
1008: AND class = l_class_code
1009: AND partner_id = p_partner_id;
1031:
1032: BEGIN
1033: SELECT distinct demand_class
1034: INTO l_hierarchy_demand_class
1035: FROM msc_allocations
1036: WHERE level_id = 2
1037: AND time_phase_id = l_time_phase_id
1038: AND class = l_class_code
1039: AND partner_id = -1;
1064: END IF;
1065: /*
1066: SELECT count(*)
1067: INTO l_temp
1068: FROM msc_allocations
1069: WHERE level_id =2
1070: AND time_phase_id = l_time_phase_id
1071: AND class = l_class_code;
1072:
1074: */
1075: BEGIN
1076: SELECT distinct demand_class
1077: INTO l_hierarchy_demand_class
1078: FROM msc_allocations
1079: WHERE level_id =2
1080: AND time_phase_id = l_time_phase_id
1081: AND class = '-1'
1082: AND partner_id = -1;
1119: IF p_level_id = 1 THEN
1120: BEGIN
1121: SELECT distinct demand_class
1122: INTO l_hierarchy_demand_class
1123: FROM msc_allocations
1124: WHERE level_id = 1
1125: AND time_phase_id = l_time_phase_id
1126: AND class = l_class_code;
1127: EXCEPTION
1140:
1141: BEGIN
1142: SELECT distinct demand_class
1143: INTO l_hierarchy_demand_class
1144: FROM msc_allocations
1145: WHERE level_id = 1
1146: AND time_phase_id = l_time_phase_id
1147: AND class = '-1';
1148: EXCEPTION
1424:
1425: BEGIN
1426: SELECT distinct demand_class
1427: INTO l_hierarchy_demand_class
1428: FROM msc_allocations
1429: WHERE demand_class = p_demand_class
1430: AND time_phase_id = l_time_phase_id
1431: --AND level_id = 1 -- demand_class hence no level_id
1432: --AND class = '-1' -- demand_class hence no customer_class
1508:
1509: BEGIN
1510: SELECT distinct demand_class
1511: INTO l_hierarchy_demand_class
1512: FROM msc_allocations
1513: WHERE level_id = 3
1514: AND time_phase_id = l_time_phase_id
1515: AND class = l_class_code
1516: AND partner_id = p_partner_id
1539:
1540: BEGIN
1541: SELECT distinct demand_class
1542: INTO l_hierarchy_demand_class
1543: FROM msc_allocations
1544: WHERE level_id = 3
1545: AND time_phase_id = l_time_phase_id
1546: AND class = l_class_code
1547: AND partner_id = p_partner_id
1576: msc_sch_wb.atp_debug('Get_Res_Hierarchy_Demand_Class: ' || 'l_class_code = '||l_class_code);
1577: END IF;
1578: SELECT distinct demand_class
1579: INTO l_hierarchy_demand_class
1580: FROM msc_allocations
1581: WHERE level_id = 3
1582: AND time_phase_id = l_time_phase_id
1583: AND class = l_class_code
1584: AND partner_id = -1
1619:
1620: BEGIN
1621: SELECT distinct demand_class
1622: INTO l_hierarchy_demand_class
1623: FROM msc_allocations
1624: WHERE level_id = 3
1625: AND time_phase_id = l_time_phase_id
1626: AND class = '-1'
1627: AND partner_id = -1
1650: -- that class_code+partner_id
1651: BEGIN
1652: SELECT distinct demand_class
1653: INTO l_hierarchy_demand_class
1654: FROM msc_allocations
1655: WHERE level_id = 2
1656: AND time_phase_id = l_time_phase_id
1657: AND class = l_class_code
1658: AND partner_id = p_partner_id;
1680:
1681: BEGIN
1682: SELECT distinct demand_class
1683: INTO l_hierarchy_demand_class
1684: FROM msc_allocations
1685: WHERE level_id = 2
1686: AND time_phase_id = l_time_phase_id
1687: AND class = l_class_code
1688: AND partner_id = -1;
1708:
1709: BEGIN
1710: SELECT distinct demand_class
1711: INTO l_hierarchy_demand_class
1712: FROM msc_allocations
1713: WHERE level_id =2
1714: AND time_phase_id = l_time_phase_id
1715: AND class = '-1'
1716: AND partner_id = -1;
1742: IF p_level_id = 1 THEN
1743: BEGIN
1744: SELECT distinct demand_class
1745: INTO l_hierarchy_demand_class
1746: FROM msc_allocations
1747: WHERE level_id = 1
1748: AND time_phase_id = l_time_phase_id
1749: AND class = l_class_code;
1750: EXCEPTION
1763:
1764: BEGIN
1765: SELECT distinct demand_class
1766: INTO l_hierarchy_demand_class
1767: FROM msc_allocations
1768: WHERE level_id = 1
1769: AND time_phase_id = l_time_phase_id
1770: AND class = '-1';
1771: EXCEPTION