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_ATP_PEG dependencies on MSC_ATP_PVT

Line 805: * (1 + MSC_ATP_PVT.G_MSO_LEAD_TIME_FACTOR));

801: (x_atp_peg_tab.variable_lt(j)
802: * ABS(x_atp_peg_tab.relief_quantity(j)) ))
803: -- Ensure Processing Lead Time calculation is
804: -- consistent for both +ve and -ve reliefs
805: * (1 + MSC_ATP_PVT.G_MSO_LEAD_TIME_FACTOR));
806:
807: IF PG_DEBUG in ('Y', 'C') THEN
808: msc_util.msc_log (' Calculate_Relief_Quantities Before calc. '
809: || 'Transaction Date for Item: ' || x_atp_peg_tab.transaction_date(j));

Line 821: || 'l_mso_lead_time_factor := ' || MSC_ATP_PVT.G_MSO_LEAD_TIME_FACTOR);

817: -1 * l_process_lt); -- negative offset
818:
819: IF PG_DEBUG in ('Y', 'C') THEN
820: msc_util.msc_log('Calculate_Relief_Quantities: '
821: || 'l_mso_lead_time_factor := ' || MSC_ATP_PVT.G_MSO_LEAD_TIME_FACTOR);
822: msc_util.msc_log('Calculate_Relief_Quantities: '
823: || 'Inventory Item Id := ' || x_atp_peg_tab.inventory_item_id(j));
824: msc_util.msc_log('Calculate_Relief_Quantities: '
825: || 'fixed_lt : = ' || x_atp_peg_tab.fixed_lt(j));

Line 2247: decode(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

2243: ) =
2244: -- Bug 3550296 and 3574164. IMPLEMENT_DATE AND DMD_SATISFIED_DATE are changed to
2245: -- IMPLEMENT_SHIP_DATE and PLANNED_SHIP_DATE resp.
2246: ( SELECT d.demand_id,
2247: decode(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2248: 2, NVL(D.PLANNED_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
2249: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)) demand_date,
2250: -- plan by request date
2251: decode(d.origination_type, 4, d.daily_demand_rate,

Line 2419: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

2415: DECODE(
2416: d1.RECORD_SOURCE,
2417: 2,
2418: NVL(d1.SCHEDULE_SHIP_DATE,d1.USING_ASSEMBLY_DEMAND_DATE),
2419: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2420: 2,
2421: (NVL(d1.IMPLEMENT_SHIP_DATE,NVL(d1.FIRM_DATE,NVL(d1.PLANNED_SHIP_DATE,d1.USING_ASSEMBLY_DEMAND_DATE)))),
2422: NVL(d1.SCHEDULE_SHIP_DATE,d1.USING_ASSEMBLY_DEMAND_DATE))), --plan by request Date, Promise Date Scheduled Date
2423: decode(d1.origination_type, 4, d1.daily_demand_rate,

Line 2567: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

2563: DECODE(
2564: d1.RECORD_SOURCE,
2565: 2,
2566: NVL(d1.SCHEDULE_SHIP_DATE,d1.USING_ASSEMBLY_DEMAND_DATE),
2567: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
2568: 2,
2569: (NVL(d1.IMPLEMENT_SHIP_DATE,NVL(d1.FIRM_DATE,NVL(d1.PLANNED_SHIP_DATE,d1.USING_ASSEMBLY_DEMAND_DATE)))),
2570: NVL(d1.SCHEDULE_SHIP_DATE,d1.USING_ASSEMBLY_DEMAND_DATE))), --plan by request Date, Promise Date Scheduled Date
2571: decode(d1.origination_type, 4, d1.daily_demand_rate,

Line 4779: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND

4775: l_sysdate := sysdate;
4776: l_user_id := FND_GLOBAL.USER_ID;
4777:
4778: -- CTO_PF_PRJ_2 Impacts
4779: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
4780: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4781: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4782: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4783:

Line 4780: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND

4776: l_user_id := FND_GLOBAL.USER_ID;
4777:
4778: -- CTO_PF_PRJ_2 Impacts
4779: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
4780: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4781: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4782: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4783:
4784: l_offset_type := 5;

Line 4781: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

4777:
4778: -- CTO_PF_PRJ_2 Impacts
4779: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
4780: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4781: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4782: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4783:
4784: l_offset_type := 5;
4785: -- Bug 3717618 Set value of supply relief type.

Line 4782: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN

4778: -- CTO_PF_PRJ_2 Impacts
4779: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
4780: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4781: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4782: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4783:
4784: l_offset_type := 5;
4785: -- Bug 3717618 Set value of supply relief type.
4786: l_sup_offset_type := 6;

Line 4934: trunc(l_demand_date(i)) + MSC_ATP_PVT.G_END_OF_DAY ,

4930: )
4931: VALUES (x_demand_id(i),
4932: l_demand_qty(i),
4933: --bug 3328421: Add at the end of the day
4934: trunc(l_demand_date(i)) + MSC_ATP_PVT.G_END_OF_DAY ,
4935: --l_demand_date(i),
4936: 1 , -- discrete demand
4937: 60, -- offset demand
4938: l_reference_item_id(i), -- inventory_item_id

Line 4969: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND

4965: END IF;
4966:
4967: -- Allocated ATP Based on Planning Details
4968:
4969: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
4970: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4971: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4972: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4973:

Line 4970: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND

4966:
4967: -- Allocated ATP Based on Planning Details
4968:
4969: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
4970: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4971: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4972: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4973:
4974: IF PG_DEBUG in ('Y', 'C') THEN

Line 4971: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

4967: -- Allocated ATP Based on Planning Details
4968:
4969: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
4970: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4971: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4972: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4973:
4974: IF PG_DEBUG in ('Y', 'C') THEN
4975: msc_sch_wb.atp_debug('Add_Offset_Demands: before insert into'||

Line 4972: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN

4968:
4969: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
4970: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4971: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4972: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4973:
4974: IF PG_DEBUG in ('Y', 'C') THEN
4975: msc_sch_wb.atp_debug('Add_Offset_Demands: before insert into'||
4976: ' msc_alloc_demands');

Line 5216: END IF; --IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND basically, IF ALLOC

5212: END LOOP;
5213: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of Family rows inserted '||
5214: 'with offset/relief_type = 7 is ' || SQL%ROWCOUNT);
5215: END IF;
5216: END IF; --IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND basically, IF ALLOC
5217:
5218: IF PG_DEBUG in ('Y', 'C') THEN
5219: msc_sch_wb.atp_debug('***** End Add_Offset_Demands *****');
5220: END IF;

Line 5308: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND

5304: l_sysdate := sysdate;
5305: l_user_id := FND_GLOBAL.USER_ID;
5306:
5307: -- CTO_PF_PRJ_2 Changes
5308: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
5309: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
5310: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
5311: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5312:

Line 5309: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND

5305: l_user_id := FND_GLOBAL.USER_ID;
5306:
5307: -- CTO_PF_PRJ_2 Changes
5308: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
5309: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
5310: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
5311: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5312:
5313: l_offset_type := 6;

Line 5310: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

5306:
5307: -- CTO_PF_PRJ_2 Changes
5308: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
5309: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
5310: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
5311: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5312:
5313: l_offset_type := 6;
5314: ELSE

Line 5311: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN

5307: -- CTO_PF_PRJ_2 Changes
5308: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
5309: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
5310: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
5311: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5312:
5313: l_offset_type := 6;
5314: ELSE
5315: l_offset_type := 2;

Line 5489: TRUNC(l_supply_date(i)) + MSC_ATP_PVT.G_END_OF_DAY,

5485: l_user_id,
5486: l_sysdate,
5487: l_user_id,
5488: --bug 3328421: Add at the end of the day
5489: TRUNC(l_supply_date(i)) + MSC_ATP_PVT.G_END_OF_DAY,
5490: --l_supply_date(i),
5491: 1, -- 1512366: open status.
5492: 60, -- offset sypply_type
5493: l_supply_qty(i),

Line 5546: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND

5542: END IF;
5543: -- End Bug 3381464.
5544:
5545:
5546: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
5547: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
5548: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
5549: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5550:

Line 5547: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND

5543: -- End Bug 3381464.
5544:
5545:
5546: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
5547: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
5548: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
5549: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5550:
5551: IF PG_DEBUG in ('Y', 'C') THEN

Line 5548: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

5544:
5545:
5546: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
5547: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
5548: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
5549: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5550:
5551: IF PG_DEBUG in ('Y', 'C') THEN
5552: msc_sch_wb.atp_debug('Add_Offset_Supplies: ' ||

Line 5549: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN

5545:
5546: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
5547: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
5548: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
5549: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5550:
5551: IF PG_DEBUG in ('Y', 'C') THEN
5552: msc_sch_wb.atp_debug('Add_Offset_Supplies: ' ||
5553: ' before insert into' || ' msc_alloc_supplies');

Line 5748: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND

5744:
5745: x_return_status := FND_API.G_RET_STS_SUCCESS;
5746:
5747: -- CTO_PF_PRJ_2 Changes
5748: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
5749: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
5750: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
5751: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5752:

Line 5749: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND

5745: x_return_status := FND_API.G_RET_STS_SUCCESS;
5746:
5747: -- CTO_PF_PRJ_2 Changes
5748: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
5749: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
5750: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
5751: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5752:
5753: l_offset_type := 6;

Line 5750: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

5746:
5747: -- CTO_PF_PRJ_2 Changes
5748: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
5749: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
5750: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
5751: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5752:
5753: l_offset_type := 6;
5754: ELSE

Line 5751: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN

5747: -- CTO_PF_PRJ_2 Changes
5748: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
5749: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
5750: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
5751: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5752:
5753: l_offset_type := 6;
5754: ELSE
5755: l_offset_type := 2;

Line 6111: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND

6107:
6108: x_return_status := FND_API.G_RET_STS_SUCCESS;
6109:
6110: -- CTO_PF_PRJ_2 Impacts
6111: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6112: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6113: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6114: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6115:

Line 6112: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND

6108: x_return_status := FND_API.G_RET_STS_SUCCESS;
6109:
6110: -- CTO_PF_PRJ_2 Impacts
6111: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6112: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6113: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6114: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6115:
6116: l_offset_type := 5;

Line 6113: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

6109:
6110: -- CTO_PF_PRJ_2 Impacts
6111: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6112: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6113: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6114: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6115:
6116: l_offset_type := 5;
6117: ELSE

Line 6114: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN

6110: -- CTO_PF_PRJ_2 Impacts
6111: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6112: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6113: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6114: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6115:
6116: l_offset_type := 5;
6117: ELSE
6118: l_offset_type := 3;

Line 6155: -- (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN

6151: SQL%BULK_ROWCOUNT(m)||' records');
6152: END LOOP;
6153: END IF;
6154:
6155: -- (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6156: -- Allocation Profiles check that was there before has been removed
6157: -- with the introduction of CTO_PF_PRJ_2 impacts.
6158: -- Relief_Type 7 can get created irrespective of allocation profiles.
6159:

Line 6256: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND

6252:
6253: x_return_status := FND_API.G_RET_STS_SUCCESS;
6254:
6255: -- CTO_PF_PRJ_2 Changes Set Relief Type
6256: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6257: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6258: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6259: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6260:

Line 6257: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND

6253: x_return_status := FND_API.G_RET_STS_SUCCESS;
6254:
6255: -- CTO_PF_PRJ_2 Changes Set Relief Type
6256: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6257: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6258: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6259: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6260:
6261: l_offset_type := 6;

Line 6258: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

6254:
6255: -- CTO_PF_PRJ_2 Changes Set Relief Type
6256: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6257: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6258: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6259: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6260:
6261: l_offset_type := 6;
6262: ELSE

Line 6259: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN

6255: -- CTO_PF_PRJ_2 Changes Set Relief Type
6256: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6257: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6258: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6259: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6260:
6261: l_offset_type := 6;
6262: ELSE
6263: l_offset_type := 2;

Line 6292: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND

6288: END IF;
6289: -- End Bug 3381464.
6290:
6291: -- CTO_PF_PRJ_2 Changes Set Relief Type
6292: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6293: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6294: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6295: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6296:

Line 6293: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND

6289: -- End Bug 3381464.
6290:
6291: -- CTO_PF_PRJ_2 Changes Set Relief Type
6292: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6293: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6294: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6295: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6296:
6297: l_offset_type := 6;

Line 6294: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

6290:
6291: -- CTO_PF_PRJ_2 Changes Set Relief Type
6292: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6293: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6294: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6295: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6296:
6297: l_offset_type := 6;
6298: ELSE

Line 6295: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN

6291: -- CTO_PF_PRJ_2 Changes Set Relief Type
6292: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6293: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6294: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6295: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6296:
6297: l_offset_type := 6;
6298: ELSE
6299: l_offset_type := 2;

Line 6336: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND

6332: SQL%BULK_ROWCOUNT(m)||' records');
6333: END LOOP;
6334: END IF;
6335:
6336: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6337: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6338: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6339: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6340:

Line 6337: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND

6333: END LOOP;
6334: END IF;
6335:
6336: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6337: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6338: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6339: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6340:
6341: IF PG_DEBUG in ('Y', 'C') THEN

Line 6338: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

6334: END IF;
6335:
6336: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6337: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6338: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6339: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6340:
6341: IF PG_DEBUG in ('Y', 'C') THEN
6342: msc_sch_wb.atp_debug('Remove_Offset_Supplies: before delete from ' ||

Line 6339: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN

6335:
6336: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6337: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6338: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6339: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6340:
6341: IF PG_DEBUG in ('Y', 'C') THEN
6342: msc_sch_wb.atp_debug('Remove_Offset_Supplies: before delete from ' ||
6343: ' msc_alloc_supplies');

Line 6571: msc_sch_wb.atp_debug('MSC_ATP_PVT.G_HYBRID_ALLOC_ATP : ' || MSC_ATP_PVT.G_HYBRID_ALLOC_ATP);

6567: msc_sch_wb.atp_debug('Config. Line Id p_config_order_line_id : ' || p_config_order_line_id);
6568: msc_sch_wb.atp_debug('Demand Source Type : ' || p_demand_source_type);
6569: msc_sch_wb.atp_debug('SO End Demand Id : ' || p_end_demand_id);
6570: msc_sch_wb.atp_debug('Plan Id : ' || p_plan_id);
6571: msc_sch_wb.atp_debug('MSC_ATP_PVT.G_HYBRID_ALLOC_ATP : ' || MSC_ATP_PVT.G_HYBRID_ALLOC_ATP);
6572: END IF;
6573:
6574: x_return_status := FND_API.G_RET_STS_SUCCESS;
6575:

Line 6576: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND

6572: END IF;
6573:
6574: x_return_status := FND_API.G_RET_STS_SUCCESS;
6575:
6576: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6577: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6578: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6579: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6580:

Line 6577: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND

6573:
6574: x_return_status := FND_API.G_RET_STS_SUCCESS;
6575:
6576: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6577: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6578: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6579: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6580:
6581: l_dmd_offset_typ := 5;

Line 6578: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

6574: x_return_status := FND_API.G_RET_STS_SUCCESS;
6575:
6576: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6577: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6578: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6579: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6580:
6581: l_dmd_offset_typ := 5;
6582: ELSE

Line 6579: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN

6575:
6576: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6577: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6578: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6579: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6580:
6581: l_dmd_offset_typ := 5;
6582: ELSE
6583: l_dmd_offset_typ := 3;

Line 6587: IF (MSC_ATP_PVT.G_HYBRID_ALLOC_ATP = 'Y' ) THEN

6583: l_dmd_offset_typ := 3;
6584: END IF;
6585: -- First create the demand records for component members and component family items.
6586:
6587: IF (MSC_ATP_PVT.G_HYBRID_ALLOC_ATP = 'Y' ) THEN
6588:
6589: INSERT INTO msc_atp_pegging
6590: (reference_item_id, inventory_item_id, plan_id, sr_instance_id,
6591: organization_id, sales_order_line_id, demand_source_type, bom_item_type, --cmro

Line 6613: alocd.customer_id, alocd.ship_to_site_id, DECODE(MSC_ATP_PVT.G_HIERARCHY_PROFILE, 2, 2,

6609: alocd.allocated_quantity/NVL(mapt.allocated_quantity,alocd.allocated_quantity) daily_relief_qty,
6610: mapt.pegging_id, mapt.prev_pegging_id, mapt.end_pegging_id, mapt.end_demand_id,
6611: mapt.created_by, mapt.creation_date, mapt.last_updated_by, mapt.last_update_date,
6612: mapt.inventory_item_id, mapt.transaction_date,
6613: alocd.customer_id, alocd.ship_to_site_id, DECODE(MSC_ATP_PVT.G_HIERARCHY_PROFILE, 2, 2,
6614: DECODE(MSC_ATP_PVT.G_ALLOCATION_METHOD, 2, 2,
6615: decode(alloc.inventory_item_id, null, 2 , 1)
6616: )
6617: ) offset_type

Line 6614: DECODE(MSC_ATP_PVT.G_ALLOCATION_METHOD, 2, 2,

6610: mapt.pegging_id, mapt.prev_pegging_id, mapt.end_pegging_id, mapt.end_demand_id,
6611: mapt.created_by, mapt.creation_date, mapt.last_updated_by, mapt.last_update_date,
6612: mapt.inventory_item_id, mapt.transaction_date,
6613: alocd.customer_id, alocd.ship_to_site_id, DECODE(MSC_ATP_PVT.G_HIERARCHY_PROFILE, 2, 2,
6614: DECODE(MSC_ATP_PVT.G_ALLOCATION_METHOD, 2, 2,
6615: decode(alloc.inventory_item_id, null, 2 , 1)
6616: )
6617: ) offset_type
6618: FROM msc_atp_peg_temp mapt, msc_alloc_demands alocd,

Line 6625: AND mapt.relief_type = DECODE(MSC_ATP_PVT.G_HIERARCHY_PROFILE, 2, 3,

6621: AND mapt.plan_id = p_plan_id
6622: AND mapt.sales_order_line_id = NVL(p_config_order_line_id, p_model_order_line_id)
6623: --AND mapt.demand_source_type = p_demand_source_type
6624: AND mapt.end_demand_id = p_end_demand_id
6625: AND mapt.relief_type = DECODE(MSC_ATP_PVT.G_HIERARCHY_PROFILE, 2, 3,
6626: DECODE(MSC_ATP_PVT.G_ALLOCATION_METHOD, 2, 3,
6627: decode(alloc.inventory_item_id, null, 2 , 5)
6628: )
6629: ) --l_dmd_offset_typ

Line 6626: DECODE(MSC_ATP_PVT.G_ALLOCATION_METHOD, 2, 3,

6622: AND mapt.sales_order_line_id = NVL(p_config_order_line_id, p_model_order_line_id)
6623: --AND mapt.demand_source_type = p_demand_source_type
6624: AND mapt.end_demand_id = p_end_demand_id
6625: AND mapt.relief_type = DECODE(MSC_ATP_PVT.G_HIERARCHY_PROFILE, 2, 3,
6626: DECODE(MSC_ATP_PVT.G_ALLOCATION_METHOD, 2, 3,
6627: decode(alloc.inventory_item_id, null, 2 , 5)
6628: )
6629: ) --l_dmd_offset_typ
6630: AND alocd.plan_id = mapt.plan_id

Line 6802: msc_sch_wb.atp_debug('MSC_ATP_PVT.G_HYBRID_ALLOC_ATP : ' || MSC_ATP_PVT.G_HYBRID_ALLOC_ATP);

6798: msc_sch_wb.atp_debug('Old Plan Id : ' || p_old_plan_id);
6799: msc_sch_wb.atp_debug('Model Line Id p_model_order_line_id : ' || p_model_order_line_id);
6800: msc_sch_wb.atp_debug('Config. Line Id p_config_order_line_id : ' || p_config_order_line_id);
6801: msc_sch_wb.atp_debug('Demand. Source Type p_demand_source_type : ' || p_demand_source_type);
6802: msc_sch_wb.atp_debug('MSC_ATP_PVT.G_HYBRID_ALLOC_ATP : ' || MSC_ATP_PVT.G_HYBRID_ALLOC_ATP);
6803: END IF;
6804:
6805: x_return_status := FND_API.G_RET_STS_SUCCESS;
6806:

Line 6808: IF (MSC_ATP_PVT.G_CTO_PF_ATP = 'Y') THEN

6804:
6805: x_return_status := FND_API.G_RET_STS_SUCCESS;
6806:
6807: -- CTO_PF_PRJ_2 Impacts
6808: IF (MSC_ATP_PVT.G_CTO_PF_ATP = 'Y') THEN
6809: l_insert_temp_table := 'MSC_ATP_PEG_TEMP';
6810: ELSE
6811: l_insert_temp_table := 'MSC_ATP_PEGGING';
6812: END IF;

Line 6814: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND

6810: ELSE
6811: l_insert_temp_table := 'MSC_ATP_PEGGING';
6812: END IF;
6813:
6814: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6815: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6816: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6817: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6818:

Line 6815: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND

6811: l_insert_temp_table := 'MSC_ATP_PEGGING';
6812: END IF;
6813:
6814: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6815: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6816: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6817: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6818:
6819: l_sup_offset_typ := 6;

Line 6816: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

6812: END IF;
6813:
6814: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6815: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6816: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6817: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6818:
6819: l_sup_offset_typ := 6;
6820: l_dmd_offset_typ := 5;

Line 6817: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN

6813:
6814: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6815: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6816: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6817: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6818:
6819: l_sup_offset_typ := 6;
6820: l_dmd_offset_typ := 5;
6821: ELSE

Line 6855: IF (MSC_ATP_PVT.G_HYBRID_ALLOC_ATP = 'N' ) THEN

6851: msc_sch_wb.atp_debug('Create_Atp_Pegging: l_insert_temp_table = '|| l_insert_temp_table);
6852: -- CTO_PF_PRJ_2 Impacts SQL are changed to Dynamic Ones
6853: -- first insert the sales order line to the ATP simplified pegging.
6854: -- ALLOC ATP CHANGES
6855: IF (MSC_ATP_PVT.G_HYBRID_ALLOC_ATP = 'N' ) THEN
6856: l_sql_stmt_1 := 'INSERT INTO ' || l_insert_temp_table ||
6857: '(reference_item_id, inventory_item_id, plan_id, sr_instance_id,
6858: organization_id, sales_order_line_id,demand_source_type, bom_item_type, --cmro
6859: transaction_date, demand_id, demand_quantity,

Line 6944: MSC_ATP_PVT.ORG_DEMAND,

6940: EXECUTE IMMEDIATE l_sql_stmt_1 USING
6941: p_config_order_line_id,
6942: p_model_order_line_id,
6943: p_demand_source_type,
6944: MSC_ATP_PVT.ORG_DEMAND,
6945: MSC_ATP_PVT.ORG_DEMAND,
6946: MSC_ATP_PVT.MAKE_SUPPLY,
6947: MSC_ATP_PVT.TRANSFER_SUPPLY,
6948: MSC_ATP_PVT.BUY_SUPPLY,

Line 6945: MSC_ATP_PVT.ORG_DEMAND,

6941: p_config_order_line_id,
6942: p_model_order_line_id,
6943: p_demand_source_type,
6944: MSC_ATP_PVT.ORG_DEMAND,
6945: MSC_ATP_PVT.ORG_DEMAND,
6946: MSC_ATP_PVT.MAKE_SUPPLY,
6947: MSC_ATP_PVT.TRANSFER_SUPPLY,
6948: MSC_ATP_PVT.BUY_SUPPLY,
6949: MSC_ATP_PVT.MAKE_SUPPLY,

Line 6946: MSC_ATP_PVT.MAKE_SUPPLY,

6942: p_model_order_line_id,
6943: p_demand_source_type,
6944: MSC_ATP_PVT.ORG_DEMAND,
6945: MSC_ATP_PVT.ORG_DEMAND,
6946: MSC_ATP_PVT.MAKE_SUPPLY,
6947: MSC_ATP_PVT.TRANSFER_SUPPLY,
6948: MSC_ATP_PVT.BUY_SUPPLY,
6949: MSC_ATP_PVT.MAKE_SUPPLY,
6950: MSC_ATP_PVT.TRANSFER_SUPPLY,

Line 6947: MSC_ATP_PVT.TRANSFER_SUPPLY,

6943: p_demand_source_type,
6944: MSC_ATP_PVT.ORG_DEMAND,
6945: MSC_ATP_PVT.ORG_DEMAND,
6946: MSC_ATP_PVT.MAKE_SUPPLY,
6947: MSC_ATP_PVT.TRANSFER_SUPPLY,
6948: MSC_ATP_PVT.BUY_SUPPLY,
6949: MSC_ATP_PVT.MAKE_SUPPLY,
6950: MSC_ATP_PVT.TRANSFER_SUPPLY,
6951: MSC_ATP_PVT.BUY_SUPPLY,

Line 6948: MSC_ATP_PVT.BUY_SUPPLY,

6944: MSC_ATP_PVT.ORG_DEMAND,
6945: MSC_ATP_PVT.ORG_DEMAND,
6946: MSC_ATP_PVT.MAKE_SUPPLY,
6947: MSC_ATP_PVT.TRANSFER_SUPPLY,
6948: MSC_ATP_PVT.BUY_SUPPLY,
6949: MSC_ATP_PVT.MAKE_SUPPLY,
6950: MSC_ATP_PVT.TRANSFER_SUPPLY,
6951: MSC_ATP_PVT.BUY_SUPPLY,
6952: MSC_ATP_PVT.MAKE_SUPPLY,

Line 6949: MSC_ATP_PVT.MAKE_SUPPLY,

6945: MSC_ATP_PVT.ORG_DEMAND,
6946: MSC_ATP_PVT.MAKE_SUPPLY,
6947: MSC_ATP_PVT.TRANSFER_SUPPLY,
6948: MSC_ATP_PVT.BUY_SUPPLY,
6949: MSC_ATP_PVT.MAKE_SUPPLY,
6950: MSC_ATP_PVT.TRANSFER_SUPPLY,
6951: MSC_ATP_PVT.BUY_SUPPLY,
6952: MSC_ATP_PVT.MAKE_SUPPLY,
6953: MSC_ATP_PVT.TRANSFER_SUPPLY,

Line 6950: MSC_ATP_PVT.TRANSFER_SUPPLY,

6946: MSC_ATP_PVT.MAKE_SUPPLY,
6947: MSC_ATP_PVT.TRANSFER_SUPPLY,
6948: MSC_ATP_PVT.BUY_SUPPLY,
6949: MSC_ATP_PVT.MAKE_SUPPLY,
6950: MSC_ATP_PVT.TRANSFER_SUPPLY,
6951: MSC_ATP_PVT.BUY_SUPPLY,
6952: MSC_ATP_PVT.MAKE_SUPPLY,
6953: MSC_ATP_PVT.TRANSFER_SUPPLY,
6954: MSC_ATP_PVT.BUY_SUPPLY,

Line 6951: MSC_ATP_PVT.BUY_SUPPLY,

6947: MSC_ATP_PVT.TRANSFER_SUPPLY,
6948: MSC_ATP_PVT.BUY_SUPPLY,
6949: MSC_ATP_PVT.MAKE_SUPPLY,
6950: MSC_ATP_PVT.TRANSFER_SUPPLY,
6951: MSC_ATP_PVT.BUY_SUPPLY,
6952: MSC_ATP_PVT.MAKE_SUPPLY,
6953: MSC_ATP_PVT.TRANSFER_SUPPLY,
6954: MSC_ATP_PVT.BUY_SUPPLY,
6955: MSC_ATP_PVT.RESOURCE_DEMAND,

Line 6952: MSC_ATP_PVT.MAKE_SUPPLY,

6948: MSC_ATP_PVT.BUY_SUPPLY,
6949: MSC_ATP_PVT.MAKE_SUPPLY,
6950: MSC_ATP_PVT.TRANSFER_SUPPLY,
6951: MSC_ATP_PVT.BUY_SUPPLY,
6952: MSC_ATP_PVT.MAKE_SUPPLY,
6953: MSC_ATP_PVT.TRANSFER_SUPPLY,
6954: MSC_ATP_PVT.BUY_SUPPLY,
6955: MSC_ATP_PVT.RESOURCE_DEMAND,
6956: MSC_ATP_PVT.ORG_DEMAND,

Line 6953: MSC_ATP_PVT.TRANSFER_SUPPLY,

6949: MSC_ATP_PVT.MAKE_SUPPLY,
6950: MSC_ATP_PVT.TRANSFER_SUPPLY,
6951: MSC_ATP_PVT.BUY_SUPPLY,
6952: MSC_ATP_PVT.MAKE_SUPPLY,
6953: MSC_ATP_PVT.TRANSFER_SUPPLY,
6954: MSC_ATP_PVT.BUY_SUPPLY,
6955: MSC_ATP_PVT.RESOURCE_DEMAND,
6956: MSC_ATP_PVT.ORG_DEMAND,
6957: l_dmd_offset_typ,

Line 6954: MSC_ATP_PVT.BUY_SUPPLY,

6950: MSC_ATP_PVT.TRANSFER_SUPPLY,
6951: MSC_ATP_PVT.BUY_SUPPLY,
6952: MSC_ATP_PVT.MAKE_SUPPLY,
6953: MSC_ATP_PVT.TRANSFER_SUPPLY,
6954: MSC_ATP_PVT.BUY_SUPPLY,
6955: MSC_ATP_PVT.RESOURCE_DEMAND,
6956: MSC_ATP_PVT.ORG_DEMAND,
6957: l_dmd_offset_typ,
6958: MSC_ATP_PVT.MAKE_SUPPLY,

Line 6955: MSC_ATP_PVT.RESOURCE_DEMAND,

6951: MSC_ATP_PVT.BUY_SUPPLY,
6952: MSC_ATP_PVT.MAKE_SUPPLY,
6953: MSC_ATP_PVT.TRANSFER_SUPPLY,
6954: MSC_ATP_PVT.BUY_SUPPLY,
6955: MSC_ATP_PVT.RESOURCE_DEMAND,
6956: MSC_ATP_PVT.ORG_DEMAND,
6957: l_dmd_offset_typ,
6958: MSC_ATP_PVT.MAKE_SUPPLY,
6959: l_sup_offset_typ,

Line 6956: MSC_ATP_PVT.ORG_DEMAND,

6952: MSC_ATP_PVT.MAKE_SUPPLY,
6953: MSC_ATP_PVT.TRANSFER_SUPPLY,
6954: MSC_ATP_PVT.BUY_SUPPLY,
6955: MSC_ATP_PVT.RESOURCE_DEMAND,
6956: MSC_ATP_PVT.ORG_DEMAND,
6957: l_dmd_offset_typ,
6958: MSC_ATP_PVT.MAKE_SUPPLY,
6959: l_sup_offset_typ,
6960: MSC_ATP_PVT.TRANSFER_SUPPLY,

Line 6958: MSC_ATP_PVT.MAKE_SUPPLY,

6954: MSC_ATP_PVT.BUY_SUPPLY,
6955: MSC_ATP_PVT.RESOURCE_DEMAND,
6956: MSC_ATP_PVT.ORG_DEMAND,
6957: l_dmd_offset_typ,
6958: MSC_ATP_PVT.MAKE_SUPPLY,
6959: l_sup_offset_typ,
6960: MSC_ATP_PVT.TRANSFER_SUPPLY,
6961: l_sup_offset_typ,
6962: MSC_ATP_PVT.RESOURCE_DEMAND,

Line 6960: MSC_ATP_PVT.TRANSFER_SUPPLY,

6956: MSC_ATP_PVT.ORG_DEMAND,
6957: l_dmd_offset_typ,
6958: MSC_ATP_PVT.MAKE_SUPPLY,
6959: l_sup_offset_typ,
6960: MSC_ATP_PVT.TRANSFER_SUPPLY,
6961: l_sup_offset_typ,
6962: MSC_ATP_PVT.RESOURCE_DEMAND,
6963: MSC_ATP_PVT.BUY_SUPPLY,
6964: l_sup_offset_typ,

Line 6962: MSC_ATP_PVT.RESOURCE_DEMAND,

6958: MSC_ATP_PVT.MAKE_SUPPLY,
6959: l_sup_offset_typ,
6960: MSC_ATP_PVT.TRANSFER_SUPPLY,
6961: l_sup_offset_typ,
6962: MSC_ATP_PVT.RESOURCE_DEMAND,
6963: MSC_ATP_PVT.BUY_SUPPLY,
6964: l_sup_offset_typ,
6965: MSC_ATP_PVT.ORG_DEMAND,
6966: p_identifier,

Line 6963: MSC_ATP_PVT.BUY_SUPPLY,

6959: l_sup_offset_typ,
6960: MSC_ATP_PVT.TRANSFER_SUPPLY,
6961: l_sup_offset_typ,
6962: MSC_ATP_PVT.RESOURCE_DEMAND,
6963: MSC_ATP_PVT.BUY_SUPPLY,
6964: l_sup_offset_typ,
6965: MSC_ATP_PVT.ORG_DEMAND,
6966: p_identifier,
6967: p_instance_id,

Line 6965: MSC_ATP_PVT.ORG_DEMAND,

6961: l_sup_offset_typ,
6962: MSC_ATP_PVT.RESOURCE_DEMAND,
6963: MSC_ATP_PVT.BUY_SUPPLY,
6964: l_sup_offset_typ,
6965: MSC_ATP_PVT.ORG_DEMAND,
6966: p_identifier,
6967: p_instance_id,
6968: MSC_ATP_PVT.G_SESSION_ID;
6969:

Line 6968: MSC_ATP_PVT.G_SESSION_ID;

6964: l_sup_offset_typ,
6965: MSC_ATP_PVT.ORG_DEMAND,
6966: p_identifier,
6967: p_instance_id,
6968: MSC_ATP_PVT.G_SESSION_ID;
6969:
6970: ELSE
6971:
6972: l_sql_stmt_1 := 'INSERT INTO ' || l_insert_temp_table ||

Line 7090: MSC_ATP_PVT.ORG_DEMAND,

7086: EXECUTE IMMEDIATE l_sql_stmt_1 USING
7087: p_config_order_line_id,
7088: p_model_order_line_id,
7089: p_demand_source_type,
7090: MSC_ATP_PVT.ORG_DEMAND,
7091: MSC_ATP_PVT.ORG_DEMAND,
7092: MSC_ATP_PVT.MAKE_SUPPLY,
7093: MSC_ATP_PVT.TRANSFER_SUPPLY,
7094: MSC_ATP_PVT.BUY_SUPPLY,

Line 7091: MSC_ATP_PVT.ORG_DEMAND,

7087: p_config_order_line_id,
7088: p_model_order_line_id,
7089: p_demand_source_type,
7090: MSC_ATP_PVT.ORG_DEMAND,
7091: MSC_ATP_PVT.ORG_DEMAND,
7092: MSC_ATP_PVT.MAKE_SUPPLY,
7093: MSC_ATP_PVT.TRANSFER_SUPPLY,
7094: MSC_ATP_PVT.BUY_SUPPLY,
7095: MSC_ATP_PVT.MAKE_SUPPLY,

Line 7092: MSC_ATP_PVT.MAKE_SUPPLY,

7088: p_model_order_line_id,
7089: p_demand_source_type,
7090: MSC_ATP_PVT.ORG_DEMAND,
7091: MSC_ATP_PVT.ORG_DEMAND,
7092: MSC_ATP_PVT.MAKE_SUPPLY,
7093: MSC_ATP_PVT.TRANSFER_SUPPLY,
7094: MSC_ATP_PVT.BUY_SUPPLY,
7095: MSC_ATP_PVT.MAKE_SUPPLY,
7096: MSC_ATP_PVT.TRANSFER_SUPPLY,

Line 7093: MSC_ATP_PVT.TRANSFER_SUPPLY,

7089: p_demand_source_type,
7090: MSC_ATP_PVT.ORG_DEMAND,
7091: MSC_ATP_PVT.ORG_DEMAND,
7092: MSC_ATP_PVT.MAKE_SUPPLY,
7093: MSC_ATP_PVT.TRANSFER_SUPPLY,
7094: MSC_ATP_PVT.BUY_SUPPLY,
7095: MSC_ATP_PVT.MAKE_SUPPLY,
7096: MSC_ATP_PVT.TRANSFER_SUPPLY,
7097: MSC_ATP_PVT.BUY_SUPPLY,

Line 7094: MSC_ATP_PVT.BUY_SUPPLY,

7090: MSC_ATP_PVT.ORG_DEMAND,
7091: MSC_ATP_PVT.ORG_DEMAND,
7092: MSC_ATP_PVT.MAKE_SUPPLY,
7093: MSC_ATP_PVT.TRANSFER_SUPPLY,
7094: MSC_ATP_PVT.BUY_SUPPLY,
7095: MSC_ATP_PVT.MAKE_SUPPLY,
7096: MSC_ATP_PVT.TRANSFER_SUPPLY,
7097: MSC_ATP_PVT.BUY_SUPPLY,
7098: MSC_ATP_PVT.MAKE_SUPPLY,

Line 7095: MSC_ATP_PVT.MAKE_SUPPLY,

7091: MSC_ATP_PVT.ORG_DEMAND,
7092: MSC_ATP_PVT.MAKE_SUPPLY,
7093: MSC_ATP_PVT.TRANSFER_SUPPLY,
7094: MSC_ATP_PVT.BUY_SUPPLY,
7095: MSC_ATP_PVT.MAKE_SUPPLY,
7096: MSC_ATP_PVT.TRANSFER_SUPPLY,
7097: MSC_ATP_PVT.BUY_SUPPLY,
7098: MSC_ATP_PVT.MAKE_SUPPLY,
7099: MSC_ATP_PVT.TRANSFER_SUPPLY,

Line 7096: MSC_ATP_PVT.TRANSFER_SUPPLY,

7092: MSC_ATP_PVT.MAKE_SUPPLY,
7093: MSC_ATP_PVT.TRANSFER_SUPPLY,
7094: MSC_ATP_PVT.BUY_SUPPLY,
7095: MSC_ATP_PVT.MAKE_SUPPLY,
7096: MSC_ATP_PVT.TRANSFER_SUPPLY,
7097: MSC_ATP_PVT.BUY_SUPPLY,
7098: MSC_ATP_PVT.MAKE_SUPPLY,
7099: MSC_ATP_PVT.TRANSFER_SUPPLY,
7100: MSC_ATP_PVT.BUY_SUPPLY,

Line 7097: MSC_ATP_PVT.BUY_SUPPLY,

7093: MSC_ATP_PVT.TRANSFER_SUPPLY,
7094: MSC_ATP_PVT.BUY_SUPPLY,
7095: MSC_ATP_PVT.MAKE_SUPPLY,
7096: MSC_ATP_PVT.TRANSFER_SUPPLY,
7097: MSC_ATP_PVT.BUY_SUPPLY,
7098: MSC_ATP_PVT.MAKE_SUPPLY,
7099: MSC_ATP_PVT.TRANSFER_SUPPLY,
7100: MSC_ATP_PVT.BUY_SUPPLY,
7101: MSC_ATP_PVT.RESOURCE_DEMAND,

Line 7098: MSC_ATP_PVT.MAKE_SUPPLY,

7094: MSC_ATP_PVT.BUY_SUPPLY,
7095: MSC_ATP_PVT.MAKE_SUPPLY,
7096: MSC_ATP_PVT.TRANSFER_SUPPLY,
7097: MSC_ATP_PVT.BUY_SUPPLY,
7098: MSC_ATP_PVT.MAKE_SUPPLY,
7099: MSC_ATP_PVT.TRANSFER_SUPPLY,
7100: MSC_ATP_PVT.BUY_SUPPLY,
7101: MSC_ATP_PVT.RESOURCE_DEMAND,
7102: MSC_ATP_PVT.ORG_DEMAND,

Line 7099: MSC_ATP_PVT.TRANSFER_SUPPLY,

7095: MSC_ATP_PVT.MAKE_SUPPLY,
7096: MSC_ATP_PVT.TRANSFER_SUPPLY,
7097: MSC_ATP_PVT.BUY_SUPPLY,
7098: MSC_ATP_PVT.MAKE_SUPPLY,
7099: MSC_ATP_PVT.TRANSFER_SUPPLY,
7100: MSC_ATP_PVT.BUY_SUPPLY,
7101: MSC_ATP_PVT.RESOURCE_DEMAND,
7102: MSC_ATP_PVT.ORG_DEMAND,
7103: --l_dmd_offset_typ,

Line 7100: MSC_ATP_PVT.BUY_SUPPLY,

7096: MSC_ATP_PVT.TRANSFER_SUPPLY,
7097: MSC_ATP_PVT.BUY_SUPPLY,
7098: MSC_ATP_PVT.MAKE_SUPPLY,
7099: MSC_ATP_PVT.TRANSFER_SUPPLY,
7100: MSC_ATP_PVT.BUY_SUPPLY,
7101: MSC_ATP_PVT.RESOURCE_DEMAND,
7102: MSC_ATP_PVT.ORG_DEMAND,
7103: --l_dmd_offset_typ,
7104: MSC_ATP_PVT.G_HIERARCHY_PROFILE,

Line 7101: MSC_ATP_PVT.RESOURCE_DEMAND,

7097: MSC_ATP_PVT.BUY_SUPPLY,
7098: MSC_ATP_PVT.MAKE_SUPPLY,
7099: MSC_ATP_PVT.TRANSFER_SUPPLY,
7100: MSC_ATP_PVT.BUY_SUPPLY,
7101: MSC_ATP_PVT.RESOURCE_DEMAND,
7102: MSC_ATP_PVT.ORG_DEMAND,
7103: --l_dmd_offset_typ,
7104: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7105: MSC_ATP_PVT.G_ALLOCATION_METHOD,

Line 7102: MSC_ATP_PVT.ORG_DEMAND,

7098: MSC_ATP_PVT.MAKE_SUPPLY,
7099: MSC_ATP_PVT.TRANSFER_SUPPLY,
7100: MSC_ATP_PVT.BUY_SUPPLY,
7101: MSC_ATP_PVT.RESOURCE_DEMAND,
7102: MSC_ATP_PVT.ORG_DEMAND,
7103: --l_dmd_offset_typ,
7104: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7105: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7106: MSC_ATP_PVT.MAKE_SUPPLY,

Line 7104: MSC_ATP_PVT.G_HIERARCHY_PROFILE,

7100: MSC_ATP_PVT.BUY_SUPPLY,
7101: MSC_ATP_PVT.RESOURCE_DEMAND,
7102: MSC_ATP_PVT.ORG_DEMAND,
7103: --l_dmd_offset_typ,
7104: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7105: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7106: MSC_ATP_PVT.MAKE_SUPPLY,
7107: --l_sup_offset_typ,
7108: MSC_ATP_PVT.G_HIERARCHY_PROFILE,

Line 7105: MSC_ATP_PVT.G_ALLOCATION_METHOD,

7101: MSC_ATP_PVT.RESOURCE_DEMAND,
7102: MSC_ATP_PVT.ORG_DEMAND,
7103: --l_dmd_offset_typ,
7104: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7105: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7106: MSC_ATP_PVT.MAKE_SUPPLY,
7107: --l_sup_offset_typ,
7108: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7109: MSC_ATP_PVT.G_ALLOCATION_METHOD,

Line 7106: MSC_ATP_PVT.MAKE_SUPPLY,

7102: MSC_ATP_PVT.ORG_DEMAND,
7103: --l_dmd_offset_typ,
7104: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7105: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7106: MSC_ATP_PVT.MAKE_SUPPLY,
7107: --l_sup_offset_typ,
7108: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7109: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7110: MSC_ATP_PVT.TRANSFER_SUPPLY,

Line 7108: MSC_ATP_PVT.G_HIERARCHY_PROFILE,

7104: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7105: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7106: MSC_ATP_PVT.MAKE_SUPPLY,
7107: --l_sup_offset_typ,
7108: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7109: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7110: MSC_ATP_PVT.TRANSFER_SUPPLY,
7111: --l_sup_offset_typ,
7112: MSC_ATP_PVT.G_HIERARCHY_PROFILE,

Line 7109: MSC_ATP_PVT.G_ALLOCATION_METHOD,

7105: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7106: MSC_ATP_PVT.MAKE_SUPPLY,
7107: --l_sup_offset_typ,
7108: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7109: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7110: MSC_ATP_PVT.TRANSFER_SUPPLY,
7111: --l_sup_offset_typ,
7112: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7113: MSC_ATP_PVT.G_ALLOCATION_METHOD,

Line 7110: MSC_ATP_PVT.TRANSFER_SUPPLY,

7106: MSC_ATP_PVT.MAKE_SUPPLY,
7107: --l_sup_offset_typ,
7108: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7109: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7110: MSC_ATP_PVT.TRANSFER_SUPPLY,
7111: --l_sup_offset_typ,
7112: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7113: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7114: MSC_ATP_PVT.RESOURCE_DEMAND,

Line 7112: MSC_ATP_PVT.G_HIERARCHY_PROFILE,

7108: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7109: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7110: MSC_ATP_PVT.TRANSFER_SUPPLY,
7111: --l_sup_offset_typ,
7112: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7113: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7114: MSC_ATP_PVT.RESOURCE_DEMAND,
7115: MSC_ATP_PVT.BUY_SUPPLY,
7116: --l_sup_offset_typ,

Line 7113: MSC_ATP_PVT.G_ALLOCATION_METHOD,

7109: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7110: MSC_ATP_PVT.TRANSFER_SUPPLY,
7111: --l_sup_offset_typ,
7112: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7113: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7114: MSC_ATP_PVT.RESOURCE_DEMAND,
7115: MSC_ATP_PVT.BUY_SUPPLY,
7116: --l_sup_offset_typ,
7117: MSC_ATP_PVT.G_HIERARCHY_PROFILE,

Line 7114: MSC_ATP_PVT.RESOURCE_DEMAND,

7110: MSC_ATP_PVT.TRANSFER_SUPPLY,
7111: --l_sup_offset_typ,
7112: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7113: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7114: MSC_ATP_PVT.RESOURCE_DEMAND,
7115: MSC_ATP_PVT.BUY_SUPPLY,
7116: --l_sup_offset_typ,
7117: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7118: MSC_ATP_PVT.G_ALLOCATION_METHOD,

Line 7115: MSC_ATP_PVT.BUY_SUPPLY,

7111: --l_sup_offset_typ,
7112: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7113: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7114: MSC_ATP_PVT.RESOURCE_DEMAND,
7115: MSC_ATP_PVT.BUY_SUPPLY,
7116: --l_sup_offset_typ,
7117: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7118: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7119: MSC_ATP_PVT.ORG_DEMAND,

Line 7117: MSC_ATP_PVT.G_HIERARCHY_PROFILE,

7113: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7114: MSC_ATP_PVT.RESOURCE_DEMAND,
7115: MSC_ATP_PVT.BUY_SUPPLY,
7116: --l_sup_offset_typ,
7117: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7118: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7119: MSC_ATP_PVT.ORG_DEMAND,
7120: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7121: MSC_ATP_PVT.G_ALLOCATION_METHOD,

Line 7118: MSC_ATP_PVT.G_ALLOCATION_METHOD,

7114: MSC_ATP_PVT.RESOURCE_DEMAND,
7115: MSC_ATP_PVT.BUY_SUPPLY,
7116: --l_sup_offset_typ,
7117: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7118: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7119: MSC_ATP_PVT.ORG_DEMAND,
7120: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7121: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7122: p_identifier,

Line 7119: MSC_ATP_PVT.ORG_DEMAND,

7115: MSC_ATP_PVT.BUY_SUPPLY,
7116: --l_sup_offset_typ,
7117: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7118: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7119: MSC_ATP_PVT.ORG_DEMAND,
7120: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7121: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7122: p_identifier,
7123: p_instance_id,

Line 7120: MSC_ATP_PVT.G_HIERARCHY_PROFILE,

7116: --l_sup_offset_typ,
7117: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7118: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7119: MSC_ATP_PVT.ORG_DEMAND,
7120: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7121: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7122: p_identifier,
7123: p_instance_id,
7124: MSC_ATP_PVT.G_SESSION_ID;

Line 7121: MSC_ATP_PVT.G_ALLOCATION_METHOD,

7117: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7118: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7119: MSC_ATP_PVT.ORG_DEMAND,
7120: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7121: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7122: p_identifier,
7123: p_instance_id,
7124: MSC_ATP_PVT.G_SESSION_ID;
7125: -- End CTO_PF_PRJ_2 Impacts SQL are changed to Dynamic Ones

Line 7124: MSC_ATP_PVT.G_SESSION_ID;

7120: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7121: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7122: p_identifier,
7123: p_instance_id,
7124: MSC_ATP_PVT.G_SESSION_ID;
7125: -- End CTO_PF_PRJ_2 Impacts SQL are changed to Dynamic Ones
7126: END IF;
7127:
7128: -- End CTO_PF_PRJ_2 Impacts SQL are changed to Dynamic Ones

Line 7138: DECODE (pegging_type, MSC_ATP_PVT.ORG_DEMAND,

7134:
7135: SELECT DEST_INV_ITEM_ID, identifier2,
7136: -- Bug 3334643 Track the plan_id
7137: -- CTO_PF_PRJ Get End Demand Id
7138: DECODE (pegging_type, MSC_ATP_PVT.ORG_DEMAND,
7139: identifier3, NULL) end_demand_id
7140: INTO l_reference_item_id, l_plan_id, l_end_demand_id
7141: -- End CTO_PF_PRJ Get End Demand Id
7142: -- Bug 3334643 Track the plan_id

Line 7148: AND session_id = MSC_ATP_PVT.G_SESSION_ID;

7144: WHERE pegging_id = p_identifier
7145: AND identifier1 = p_instance_id
7146: AND record_type = 3
7147: AND model_sd_flag = 1
7148: AND session_id = MSC_ATP_PVT.G_SESSION_ID;
7149:
7150: IF PG_DEBUG in ('Y', 'C') THEN
7151: msc_sch_wb.atp_debug('Create_Atp_Pegging: l_reference_item_id ' ||
7152: l_reference_item_id);

Line 7176: IF (MSC_ATP_PVT.G_HYBRID_ALLOC_ATP = 'N' ) THEN

7172: -- CTO_PF_PRJ_2 Impacts SQL are changed to Dynamic Ones
7173: -- Then Add all other lines in the pegging.
7174: -- ALLOC ATP CHANGES
7175:
7176: IF (MSC_ATP_PVT.G_HYBRID_ALLOC_ATP = 'N' ) THEN
7177: l_sql_stmt_1 := 'INSERT INTO ' || l_insert_temp_table ||
7178: '(reference_item_id, inventory_item_id, plan_id, sr_instance_id,
7179: organization_id, sales_order_line_id,demand_source_type,bom_item_type, --cmro
7180: transaction_date, demand_id, demand_quantity,

Line 7271: MSC_ATP_PVT.ORG_DEMAND,

7267: l_reference_item_id,
7268: p_config_order_line_id,
7269: p_model_order_line_id,
7270: p_demand_source_type,
7271: MSC_ATP_PVT.ORG_DEMAND,
7272: MSC_ATP_PVT.ORG_DEMAND,
7273: MSC_ATP_PVT.MAKE_SUPPLY,
7274: MSC_ATP_PVT.TRANSFER_SUPPLY,
7275: MSC_ATP_PVT.BUY_SUPPLY,

Line 7272: MSC_ATP_PVT.ORG_DEMAND,

7268: p_config_order_line_id,
7269: p_model_order_line_id,
7270: p_demand_source_type,
7271: MSC_ATP_PVT.ORG_DEMAND,
7272: MSC_ATP_PVT.ORG_DEMAND,
7273: MSC_ATP_PVT.MAKE_SUPPLY,
7274: MSC_ATP_PVT.TRANSFER_SUPPLY,
7275: MSC_ATP_PVT.BUY_SUPPLY,
7276: MSC_ATP_PVT.RESOURCE_DEMAND,

Line 7273: MSC_ATP_PVT.MAKE_SUPPLY,

7269: p_model_order_line_id,
7270: p_demand_source_type,
7271: MSC_ATP_PVT.ORG_DEMAND,
7272: MSC_ATP_PVT.ORG_DEMAND,
7273: MSC_ATP_PVT.MAKE_SUPPLY,
7274: MSC_ATP_PVT.TRANSFER_SUPPLY,
7275: MSC_ATP_PVT.BUY_SUPPLY,
7276: MSC_ATP_PVT.RESOURCE_DEMAND,
7277: MSC_ATP_PVT.MAKE_SUPPLY,

Line 7274: MSC_ATP_PVT.TRANSFER_SUPPLY,

7270: p_demand_source_type,
7271: MSC_ATP_PVT.ORG_DEMAND,
7272: MSC_ATP_PVT.ORG_DEMAND,
7273: MSC_ATP_PVT.MAKE_SUPPLY,
7274: MSC_ATP_PVT.TRANSFER_SUPPLY,
7275: MSC_ATP_PVT.BUY_SUPPLY,
7276: MSC_ATP_PVT.RESOURCE_DEMAND,
7277: MSC_ATP_PVT.MAKE_SUPPLY,
7278: MSC_ATP_PVT.TRANSFER_SUPPLY,

Line 7275: MSC_ATP_PVT.BUY_SUPPLY,

7271: MSC_ATP_PVT.ORG_DEMAND,
7272: MSC_ATP_PVT.ORG_DEMAND,
7273: MSC_ATP_PVT.MAKE_SUPPLY,
7274: MSC_ATP_PVT.TRANSFER_SUPPLY,
7275: MSC_ATP_PVT.BUY_SUPPLY,
7276: MSC_ATP_PVT.RESOURCE_DEMAND,
7277: MSC_ATP_PVT.MAKE_SUPPLY,
7278: MSC_ATP_PVT.TRANSFER_SUPPLY,
7279: MSC_ATP_PVT.BUY_SUPPLY,

Line 7276: MSC_ATP_PVT.RESOURCE_DEMAND,

7272: MSC_ATP_PVT.ORG_DEMAND,
7273: MSC_ATP_PVT.MAKE_SUPPLY,
7274: MSC_ATP_PVT.TRANSFER_SUPPLY,
7275: MSC_ATP_PVT.BUY_SUPPLY,
7276: MSC_ATP_PVT.RESOURCE_DEMAND,
7277: MSC_ATP_PVT.MAKE_SUPPLY,
7278: MSC_ATP_PVT.TRANSFER_SUPPLY,
7279: MSC_ATP_PVT.BUY_SUPPLY,
7280: MSC_ATP_PVT.MAKE_SUPPLY,

Line 7277: MSC_ATP_PVT.MAKE_SUPPLY,

7273: MSC_ATP_PVT.MAKE_SUPPLY,
7274: MSC_ATP_PVT.TRANSFER_SUPPLY,
7275: MSC_ATP_PVT.BUY_SUPPLY,
7276: MSC_ATP_PVT.RESOURCE_DEMAND,
7277: MSC_ATP_PVT.MAKE_SUPPLY,
7278: MSC_ATP_PVT.TRANSFER_SUPPLY,
7279: MSC_ATP_PVT.BUY_SUPPLY,
7280: MSC_ATP_PVT.MAKE_SUPPLY,
7281: MSC_ATP_PVT.TRANSFER_SUPPLY,

Line 7278: MSC_ATP_PVT.TRANSFER_SUPPLY,

7274: MSC_ATP_PVT.TRANSFER_SUPPLY,
7275: MSC_ATP_PVT.BUY_SUPPLY,
7276: MSC_ATP_PVT.RESOURCE_DEMAND,
7277: MSC_ATP_PVT.MAKE_SUPPLY,
7278: MSC_ATP_PVT.TRANSFER_SUPPLY,
7279: MSC_ATP_PVT.BUY_SUPPLY,
7280: MSC_ATP_PVT.MAKE_SUPPLY,
7281: MSC_ATP_PVT.TRANSFER_SUPPLY,
7282: MSC_ATP_PVT.BUY_SUPPLY,

Line 7279: MSC_ATP_PVT.BUY_SUPPLY,

7275: MSC_ATP_PVT.BUY_SUPPLY,
7276: MSC_ATP_PVT.RESOURCE_DEMAND,
7277: MSC_ATP_PVT.MAKE_SUPPLY,
7278: MSC_ATP_PVT.TRANSFER_SUPPLY,
7279: MSC_ATP_PVT.BUY_SUPPLY,
7280: MSC_ATP_PVT.MAKE_SUPPLY,
7281: MSC_ATP_PVT.TRANSFER_SUPPLY,
7282: MSC_ATP_PVT.BUY_SUPPLY,
7283: MSC_ATP_PVT.RESOURCE_DEMAND,

Line 7280: MSC_ATP_PVT.MAKE_SUPPLY,

7276: MSC_ATP_PVT.RESOURCE_DEMAND,
7277: MSC_ATP_PVT.MAKE_SUPPLY,
7278: MSC_ATP_PVT.TRANSFER_SUPPLY,
7279: MSC_ATP_PVT.BUY_SUPPLY,
7280: MSC_ATP_PVT.MAKE_SUPPLY,
7281: MSC_ATP_PVT.TRANSFER_SUPPLY,
7282: MSC_ATP_PVT.BUY_SUPPLY,
7283: MSC_ATP_PVT.RESOURCE_DEMAND,
7284: MSC_ATP_PVT.ORG_DEMAND,

Line 7281: MSC_ATP_PVT.TRANSFER_SUPPLY,

7277: MSC_ATP_PVT.MAKE_SUPPLY,
7278: MSC_ATP_PVT.TRANSFER_SUPPLY,
7279: MSC_ATP_PVT.BUY_SUPPLY,
7280: MSC_ATP_PVT.MAKE_SUPPLY,
7281: MSC_ATP_PVT.TRANSFER_SUPPLY,
7282: MSC_ATP_PVT.BUY_SUPPLY,
7283: MSC_ATP_PVT.RESOURCE_DEMAND,
7284: MSC_ATP_PVT.ORG_DEMAND,
7285: l_dmd_offset_typ,

Line 7282: MSC_ATP_PVT.BUY_SUPPLY,

7278: MSC_ATP_PVT.TRANSFER_SUPPLY,
7279: MSC_ATP_PVT.BUY_SUPPLY,
7280: MSC_ATP_PVT.MAKE_SUPPLY,
7281: MSC_ATP_PVT.TRANSFER_SUPPLY,
7282: MSC_ATP_PVT.BUY_SUPPLY,
7283: MSC_ATP_PVT.RESOURCE_DEMAND,
7284: MSC_ATP_PVT.ORG_DEMAND,
7285: l_dmd_offset_typ,
7286: MSC_ATP_PVT.MAKE_SUPPLY,

Line 7283: MSC_ATP_PVT.RESOURCE_DEMAND,

7279: MSC_ATP_PVT.BUY_SUPPLY,
7280: MSC_ATP_PVT.MAKE_SUPPLY,
7281: MSC_ATP_PVT.TRANSFER_SUPPLY,
7282: MSC_ATP_PVT.BUY_SUPPLY,
7283: MSC_ATP_PVT.RESOURCE_DEMAND,
7284: MSC_ATP_PVT.ORG_DEMAND,
7285: l_dmd_offset_typ,
7286: MSC_ATP_PVT.MAKE_SUPPLY,
7287: l_sup_offset_typ,

Line 7284: MSC_ATP_PVT.ORG_DEMAND,

7280: MSC_ATP_PVT.MAKE_SUPPLY,
7281: MSC_ATP_PVT.TRANSFER_SUPPLY,
7282: MSC_ATP_PVT.BUY_SUPPLY,
7283: MSC_ATP_PVT.RESOURCE_DEMAND,
7284: MSC_ATP_PVT.ORG_DEMAND,
7285: l_dmd_offset_typ,
7286: MSC_ATP_PVT.MAKE_SUPPLY,
7287: l_sup_offset_typ,
7288: MSC_ATP_PVT.TRANSFER_SUPPLY,

Line 7286: MSC_ATP_PVT.MAKE_SUPPLY,

7282: MSC_ATP_PVT.BUY_SUPPLY,
7283: MSC_ATP_PVT.RESOURCE_DEMAND,
7284: MSC_ATP_PVT.ORG_DEMAND,
7285: l_dmd_offset_typ,
7286: MSC_ATP_PVT.MAKE_SUPPLY,
7287: l_sup_offset_typ,
7288: MSC_ATP_PVT.TRANSFER_SUPPLY,
7289: l_sup_offset_typ,
7290: MSC_ATP_PVT.RESOURCE_DEMAND,

Line 7288: MSC_ATP_PVT.TRANSFER_SUPPLY,

7284: MSC_ATP_PVT.ORG_DEMAND,
7285: l_dmd_offset_typ,
7286: MSC_ATP_PVT.MAKE_SUPPLY,
7287: l_sup_offset_typ,
7288: MSC_ATP_PVT.TRANSFER_SUPPLY,
7289: l_sup_offset_typ,
7290: MSC_ATP_PVT.RESOURCE_DEMAND,
7291: MSC_ATP_PVT.BUY_SUPPLY,
7292: l_sup_offset_typ,

Line 7290: MSC_ATP_PVT.RESOURCE_DEMAND,

7286: MSC_ATP_PVT.MAKE_SUPPLY,
7287: l_sup_offset_typ,
7288: MSC_ATP_PVT.TRANSFER_SUPPLY,
7289: l_sup_offset_typ,
7290: MSC_ATP_PVT.RESOURCE_DEMAND,
7291: MSC_ATP_PVT.BUY_SUPPLY,
7292: l_sup_offset_typ,
7293: l_end_demand_id,
7294: p_identifier,

Line 7291: MSC_ATP_PVT.BUY_SUPPLY,

7287: l_sup_offset_typ,
7288: MSC_ATP_PVT.TRANSFER_SUPPLY,
7289: l_sup_offset_typ,
7290: MSC_ATP_PVT.RESOURCE_DEMAND,
7291: MSC_ATP_PVT.BUY_SUPPLY,
7292: l_sup_offset_typ,
7293: l_end_demand_id,
7294: p_identifier,
7295: MSC_ATP_PVT.G_SESSION_ID,

Line 7295: MSC_ATP_PVT.G_SESSION_ID,

7291: MSC_ATP_PVT.BUY_SUPPLY,
7292: l_sup_offset_typ,
7293: l_end_demand_id,
7294: p_identifier,
7295: MSC_ATP_PVT.G_SESSION_ID,
7296: p_identifier,
7297: MSC_ATP_PVT.G_SESSION_ID;
7298:
7299: ELSE -- HYBRID ALLOC ATP

Line 7297: MSC_ATP_PVT.G_SESSION_ID;

7293: l_end_demand_id,
7294: p_identifier,
7295: MSC_ATP_PVT.G_SESSION_ID,
7296: p_identifier,
7297: MSC_ATP_PVT.G_SESSION_ID;
7298:
7299: ELSE -- HYBRID ALLOC ATP
7300: l_sql_stmt_1 := 'INSERT INTO ' || l_insert_temp_table ||
7301: '(reference_item_id, inventory_item_id, plan_id, sr_instance_id,

Line 7424: MSC_ATP_PVT.ORG_DEMAND,

7420: l_reference_item_id,
7421: p_config_order_line_id,
7422: p_model_order_line_id,
7423: p_demand_source_type,
7424: MSC_ATP_PVT.ORG_DEMAND,
7425: MSC_ATP_PVT.ORG_DEMAND,
7426: MSC_ATP_PVT.MAKE_SUPPLY,
7427: MSC_ATP_PVT.TRANSFER_SUPPLY,
7428: MSC_ATP_PVT.BUY_SUPPLY,

Line 7425: MSC_ATP_PVT.ORG_DEMAND,

7421: p_config_order_line_id,
7422: p_model_order_line_id,
7423: p_demand_source_type,
7424: MSC_ATP_PVT.ORG_DEMAND,
7425: MSC_ATP_PVT.ORG_DEMAND,
7426: MSC_ATP_PVT.MAKE_SUPPLY,
7427: MSC_ATP_PVT.TRANSFER_SUPPLY,
7428: MSC_ATP_PVT.BUY_SUPPLY,
7429: MSC_ATP_PVT.RESOURCE_DEMAND,

Line 7426: MSC_ATP_PVT.MAKE_SUPPLY,

7422: p_model_order_line_id,
7423: p_demand_source_type,
7424: MSC_ATP_PVT.ORG_DEMAND,
7425: MSC_ATP_PVT.ORG_DEMAND,
7426: MSC_ATP_PVT.MAKE_SUPPLY,
7427: MSC_ATP_PVT.TRANSFER_SUPPLY,
7428: MSC_ATP_PVT.BUY_SUPPLY,
7429: MSC_ATP_PVT.RESOURCE_DEMAND,
7430: MSC_ATP_PVT.MAKE_SUPPLY,

Line 7427: MSC_ATP_PVT.TRANSFER_SUPPLY,

7423: p_demand_source_type,
7424: MSC_ATP_PVT.ORG_DEMAND,
7425: MSC_ATP_PVT.ORG_DEMAND,
7426: MSC_ATP_PVT.MAKE_SUPPLY,
7427: MSC_ATP_PVT.TRANSFER_SUPPLY,
7428: MSC_ATP_PVT.BUY_SUPPLY,
7429: MSC_ATP_PVT.RESOURCE_DEMAND,
7430: MSC_ATP_PVT.MAKE_SUPPLY,
7431: MSC_ATP_PVT.TRANSFER_SUPPLY,

Line 7428: MSC_ATP_PVT.BUY_SUPPLY,

7424: MSC_ATP_PVT.ORG_DEMAND,
7425: MSC_ATP_PVT.ORG_DEMAND,
7426: MSC_ATP_PVT.MAKE_SUPPLY,
7427: MSC_ATP_PVT.TRANSFER_SUPPLY,
7428: MSC_ATP_PVT.BUY_SUPPLY,
7429: MSC_ATP_PVT.RESOURCE_DEMAND,
7430: MSC_ATP_PVT.MAKE_SUPPLY,
7431: MSC_ATP_PVT.TRANSFER_SUPPLY,
7432: MSC_ATP_PVT.BUY_SUPPLY,

Line 7429: MSC_ATP_PVT.RESOURCE_DEMAND,

7425: MSC_ATP_PVT.ORG_DEMAND,
7426: MSC_ATP_PVT.MAKE_SUPPLY,
7427: MSC_ATP_PVT.TRANSFER_SUPPLY,
7428: MSC_ATP_PVT.BUY_SUPPLY,
7429: MSC_ATP_PVT.RESOURCE_DEMAND,
7430: MSC_ATP_PVT.MAKE_SUPPLY,
7431: MSC_ATP_PVT.TRANSFER_SUPPLY,
7432: MSC_ATP_PVT.BUY_SUPPLY,
7433: MSC_ATP_PVT.MAKE_SUPPLY,

Line 7430: MSC_ATP_PVT.MAKE_SUPPLY,

7426: MSC_ATP_PVT.MAKE_SUPPLY,
7427: MSC_ATP_PVT.TRANSFER_SUPPLY,
7428: MSC_ATP_PVT.BUY_SUPPLY,
7429: MSC_ATP_PVT.RESOURCE_DEMAND,
7430: MSC_ATP_PVT.MAKE_SUPPLY,
7431: MSC_ATP_PVT.TRANSFER_SUPPLY,
7432: MSC_ATP_PVT.BUY_SUPPLY,
7433: MSC_ATP_PVT.MAKE_SUPPLY,
7434: MSC_ATP_PVT.TRANSFER_SUPPLY,

Line 7431: MSC_ATP_PVT.TRANSFER_SUPPLY,

7427: MSC_ATP_PVT.TRANSFER_SUPPLY,
7428: MSC_ATP_PVT.BUY_SUPPLY,
7429: MSC_ATP_PVT.RESOURCE_DEMAND,
7430: MSC_ATP_PVT.MAKE_SUPPLY,
7431: MSC_ATP_PVT.TRANSFER_SUPPLY,
7432: MSC_ATP_PVT.BUY_SUPPLY,
7433: MSC_ATP_PVT.MAKE_SUPPLY,
7434: MSC_ATP_PVT.TRANSFER_SUPPLY,
7435: MSC_ATP_PVT.BUY_SUPPLY,

Line 7432: MSC_ATP_PVT.BUY_SUPPLY,

7428: MSC_ATP_PVT.BUY_SUPPLY,
7429: MSC_ATP_PVT.RESOURCE_DEMAND,
7430: MSC_ATP_PVT.MAKE_SUPPLY,
7431: MSC_ATP_PVT.TRANSFER_SUPPLY,
7432: MSC_ATP_PVT.BUY_SUPPLY,
7433: MSC_ATP_PVT.MAKE_SUPPLY,
7434: MSC_ATP_PVT.TRANSFER_SUPPLY,
7435: MSC_ATP_PVT.BUY_SUPPLY,
7436: MSC_ATP_PVT.RESOURCE_DEMAND,

Line 7433: MSC_ATP_PVT.MAKE_SUPPLY,

7429: MSC_ATP_PVT.RESOURCE_DEMAND,
7430: MSC_ATP_PVT.MAKE_SUPPLY,
7431: MSC_ATP_PVT.TRANSFER_SUPPLY,
7432: MSC_ATP_PVT.BUY_SUPPLY,
7433: MSC_ATP_PVT.MAKE_SUPPLY,
7434: MSC_ATP_PVT.TRANSFER_SUPPLY,
7435: MSC_ATP_PVT.BUY_SUPPLY,
7436: MSC_ATP_PVT.RESOURCE_DEMAND,
7437: MSC_ATP_PVT.ORG_DEMAND,

Line 7434: MSC_ATP_PVT.TRANSFER_SUPPLY,

7430: MSC_ATP_PVT.MAKE_SUPPLY,
7431: MSC_ATP_PVT.TRANSFER_SUPPLY,
7432: MSC_ATP_PVT.BUY_SUPPLY,
7433: MSC_ATP_PVT.MAKE_SUPPLY,
7434: MSC_ATP_PVT.TRANSFER_SUPPLY,
7435: MSC_ATP_PVT.BUY_SUPPLY,
7436: MSC_ATP_PVT.RESOURCE_DEMAND,
7437: MSC_ATP_PVT.ORG_DEMAND,
7438: --l_dmd_offset_typ,

Line 7435: MSC_ATP_PVT.BUY_SUPPLY,

7431: MSC_ATP_PVT.TRANSFER_SUPPLY,
7432: MSC_ATP_PVT.BUY_SUPPLY,
7433: MSC_ATP_PVT.MAKE_SUPPLY,
7434: MSC_ATP_PVT.TRANSFER_SUPPLY,
7435: MSC_ATP_PVT.BUY_SUPPLY,
7436: MSC_ATP_PVT.RESOURCE_DEMAND,
7437: MSC_ATP_PVT.ORG_DEMAND,
7438: --l_dmd_offset_typ,
7439: MSC_ATP_PVT.G_HIERARCHY_PROFILE,

Line 7436: MSC_ATP_PVT.RESOURCE_DEMAND,

7432: MSC_ATP_PVT.BUY_SUPPLY,
7433: MSC_ATP_PVT.MAKE_SUPPLY,
7434: MSC_ATP_PVT.TRANSFER_SUPPLY,
7435: MSC_ATP_PVT.BUY_SUPPLY,
7436: MSC_ATP_PVT.RESOURCE_DEMAND,
7437: MSC_ATP_PVT.ORG_DEMAND,
7438: --l_dmd_offset_typ,
7439: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7440: MSC_ATP_PVT.G_ALLOCATION_METHOD,

Line 7437: MSC_ATP_PVT.ORG_DEMAND,

7433: MSC_ATP_PVT.MAKE_SUPPLY,
7434: MSC_ATP_PVT.TRANSFER_SUPPLY,
7435: MSC_ATP_PVT.BUY_SUPPLY,
7436: MSC_ATP_PVT.RESOURCE_DEMAND,
7437: MSC_ATP_PVT.ORG_DEMAND,
7438: --l_dmd_offset_typ,
7439: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7440: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7441: MSC_ATP_PVT.MAKE_SUPPLY,

Line 7439: MSC_ATP_PVT.G_HIERARCHY_PROFILE,

7435: MSC_ATP_PVT.BUY_SUPPLY,
7436: MSC_ATP_PVT.RESOURCE_DEMAND,
7437: MSC_ATP_PVT.ORG_DEMAND,
7438: --l_dmd_offset_typ,
7439: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7440: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7441: MSC_ATP_PVT.MAKE_SUPPLY,
7442: --l_sup_offset_typ,
7443: MSC_ATP_PVT.G_HIERARCHY_PROFILE,

Line 7440: MSC_ATP_PVT.G_ALLOCATION_METHOD,

7436: MSC_ATP_PVT.RESOURCE_DEMAND,
7437: MSC_ATP_PVT.ORG_DEMAND,
7438: --l_dmd_offset_typ,
7439: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7440: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7441: MSC_ATP_PVT.MAKE_SUPPLY,
7442: --l_sup_offset_typ,
7443: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7444: MSC_ATP_PVT.G_ALLOCATION_METHOD,

Line 7441: MSC_ATP_PVT.MAKE_SUPPLY,

7437: MSC_ATP_PVT.ORG_DEMAND,
7438: --l_dmd_offset_typ,
7439: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7440: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7441: MSC_ATP_PVT.MAKE_SUPPLY,
7442: --l_sup_offset_typ,
7443: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7444: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7445: MSC_ATP_PVT.TRANSFER_SUPPLY,

Line 7443: MSC_ATP_PVT.G_HIERARCHY_PROFILE,

7439: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7440: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7441: MSC_ATP_PVT.MAKE_SUPPLY,
7442: --l_sup_offset_typ,
7443: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7444: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7445: MSC_ATP_PVT.TRANSFER_SUPPLY,
7446: --l_sup_offset_typ,
7447: MSC_ATP_PVT.G_HIERARCHY_PROFILE,

Line 7444: MSC_ATP_PVT.G_ALLOCATION_METHOD,

7440: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7441: MSC_ATP_PVT.MAKE_SUPPLY,
7442: --l_sup_offset_typ,
7443: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7444: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7445: MSC_ATP_PVT.TRANSFER_SUPPLY,
7446: --l_sup_offset_typ,
7447: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7448: MSC_ATP_PVT.G_ALLOCATION_METHOD,

Line 7445: MSC_ATP_PVT.TRANSFER_SUPPLY,

7441: MSC_ATP_PVT.MAKE_SUPPLY,
7442: --l_sup_offset_typ,
7443: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7444: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7445: MSC_ATP_PVT.TRANSFER_SUPPLY,
7446: --l_sup_offset_typ,
7447: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7448: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7449: MSC_ATP_PVT.RESOURCE_DEMAND,

Line 7447: MSC_ATP_PVT.G_HIERARCHY_PROFILE,

7443: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7444: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7445: MSC_ATP_PVT.TRANSFER_SUPPLY,
7446: --l_sup_offset_typ,
7447: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7448: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7449: MSC_ATP_PVT.RESOURCE_DEMAND,
7450: MSC_ATP_PVT.BUY_SUPPLY,
7451: --l_sup_offset_typ,

Line 7448: MSC_ATP_PVT.G_ALLOCATION_METHOD,

7444: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7445: MSC_ATP_PVT.TRANSFER_SUPPLY,
7446: --l_sup_offset_typ,
7447: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7448: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7449: MSC_ATP_PVT.RESOURCE_DEMAND,
7450: MSC_ATP_PVT.BUY_SUPPLY,
7451: --l_sup_offset_typ,
7452: MSC_ATP_PVT.G_HIERARCHY_PROFILE,

Line 7449: MSC_ATP_PVT.RESOURCE_DEMAND,

7445: MSC_ATP_PVT.TRANSFER_SUPPLY,
7446: --l_sup_offset_typ,
7447: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7448: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7449: MSC_ATP_PVT.RESOURCE_DEMAND,
7450: MSC_ATP_PVT.BUY_SUPPLY,
7451: --l_sup_offset_typ,
7452: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7453: MSC_ATP_PVT.G_ALLOCATION_METHOD,

Line 7450: MSC_ATP_PVT.BUY_SUPPLY,

7446: --l_sup_offset_typ,
7447: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7448: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7449: MSC_ATP_PVT.RESOURCE_DEMAND,
7450: MSC_ATP_PVT.BUY_SUPPLY,
7451: --l_sup_offset_typ,
7452: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7453: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7454: l_end_demand_id,

Line 7452: MSC_ATP_PVT.G_HIERARCHY_PROFILE,

7448: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7449: MSC_ATP_PVT.RESOURCE_DEMAND,
7450: MSC_ATP_PVT.BUY_SUPPLY,
7451: --l_sup_offset_typ,
7452: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7453: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7454: l_end_demand_id,
7455: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7456: MSC_ATP_PVT.G_ALLOCATION_METHOD,

Line 7453: MSC_ATP_PVT.G_ALLOCATION_METHOD,

7449: MSC_ATP_PVT.RESOURCE_DEMAND,
7450: MSC_ATP_PVT.BUY_SUPPLY,
7451: --l_sup_offset_typ,
7452: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7453: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7454: l_end_demand_id,
7455: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7456: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7457: p_identifier,

Line 7455: MSC_ATP_PVT.G_HIERARCHY_PROFILE,

7451: --l_sup_offset_typ,
7452: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7453: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7454: l_end_demand_id,
7455: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7456: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7457: p_identifier,
7458: MSC_ATP_PVT.G_SESSION_ID,
7459: p_identifier,

Line 7456: MSC_ATP_PVT.G_ALLOCATION_METHOD,

7452: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7453: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7454: l_end_demand_id,
7455: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7456: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7457: p_identifier,
7458: MSC_ATP_PVT.G_SESSION_ID,
7459: p_identifier,
7460: MSC_ATP_PVT.G_SESSION_ID;

Line 7458: MSC_ATP_PVT.G_SESSION_ID,

7454: l_end_demand_id,
7455: MSC_ATP_PVT.G_HIERARCHY_PROFILE,
7456: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7457: p_identifier,
7458: MSC_ATP_PVT.G_SESSION_ID,
7459: p_identifier,
7460: MSC_ATP_PVT.G_SESSION_ID;
7461: END IF;
7462:

Line 7460: MSC_ATP_PVT.G_SESSION_ID;

7456: MSC_ATP_PVT.G_ALLOCATION_METHOD,
7457: p_identifier,
7458: MSC_ATP_PVT.G_SESSION_ID,
7459: p_identifier,
7460: MSC_ATP_PVT.G_SESSION_ID;
7461: END IF;
7462:
7463: -- End CTO_PF_PRJ_2 Impacts SQL are changed to Dynamic Ones
7464:

Line 7471: IF (MSC_ATP_PVT.G_CTO_PF_ATP = 'Y') THEN

7467: SQL%ROWCOUNT);
7468: END IF;
7469:
7470: -- CTO_PF_PRJ Impacts
7471: IF (MSC_ATP_PVT.G_CTO_PF_ATP = 'Y') THEN
7472: -- Call Procedure to insert data from temp table to main table
7473: -- For PF items, PF related processing will be done.
7474: Create_PF_Atp_Pegging ( l_reference_item_id ,
7475: p_model_order_line_id ,