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 2245: decode(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

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

Line 2417: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

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

Line 2565: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

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

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

4761: l_sysdate := sysdate;
4762: l_user_id := FND_GLOBAL.USER_ID;
4763:
4764: -- CTO_PF_PRJ_2 Impacts
4765: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
4766: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4767: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4768: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4769:

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

4762: l_user_id := FND_GLOBAL.USER_ID;
4763:
4764: -- CTO_PF_PRJ_2 Impacts
4765: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
4766: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4767: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4768: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4769:
4770: l_offset_type := 5;

Line 4767: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

4763:
4764: -- CTO_PF_PRJ_2 Impacts
4765: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
4766: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4767: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4768: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4769:
4770: l_offset_type := 5;
4771: -- Bug 3717618 Set value of supply relief type.

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

4764: -- CTO_PF_PRJ_2 Impacts
4765: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
4766: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4767: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4768: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4769:
4770: l_offset_type := 5;
4771: -- Bug 3717618 Set value of supply relief type.
4772: l_sup_offset_type := 6;

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

4916: )
4917: VALUES (x_demand_id(i),
4918: l_demand_qty(i),
4919: --bug 3328421: Add at the end of the day
4920: trunc(l_demand_date(i)) + MSC_ATP_PVT.G_END_OF_DAY ,
4921: --l_demand_date(i),
4922: 1 , -- discrete demand
4923: 60, -- offset demand
4924: l_reference_item_id(i), -- inventory_item_id

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

4951: END IF;
4952:
4953: -- Allocated ATP Based on Planning Details
4954:
4955: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
4956: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4957: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4958: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4959:

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

4952:
4953: -- Allocated ATP Based on Planning Details
4954:
4955: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
4956: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4957: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4958: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4959:
4960: IF PG_DEBUG in ('Y', 'C') THEN

Line 4957: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

4953: -- Allocated ATP Based on Planning Details
4954:
4955: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
4956: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4957: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4958: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4959:
4960: IF PG_DEBUG in ('Y', 'C') THEN
4961: msc_sch_wb.atp_debug('Add_Offset_Demands: before insert into'||

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

4954:
4955: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
4956: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
4957: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
4958: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
4959:
4960: IF PG_DEBUG in ('Y', 'C') THEN
4961: msc_sch_wb.atp_debug('Add_Offset_Demands: before insert into'||
4962: ' msc_alloc_demands');

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

5198: END LOOP;
5199: msc_sch_wb.atp_debug('Add_Offset_Demands: Number of Family rows inserted '||
5200: 'with offset/relief_type = 7 is ' || SQL%ROWCOUNT);
5201: END IF;
5202: END IF; --IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND basically, IF ALLOC
5203:
5204: IF PG_DEBUG in ('Y', 'C') THEN
5205: msc_sch_wb.atp_debug('***** End Add_Offset_Demands *****');
5206: END IF;

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

5290: l_sysdate := sysdate;
5291: l_user_id := FND_GLOBAL.USER_ID;
5292:
5293: -- CTO_PF_PRJ_2 Changes
5294: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
5295: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
5296: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
5297: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5298:

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

5291: l_user_id := FND_GLOBAL.USER_ID;
5292:
5293: -- CTO_PF_PRJ_2 Changes
5294: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
5295: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
5296: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
5297: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5298:
5299: l_offset_type := 6;

Line 5296: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

5292:
5293: -- CTO_PF_PRJ_2 Changes
5294: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
5295: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
5296: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
5297: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5298:
5299: l_offset_type := 6;
5300: ELSE

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

5293: -- CTO_PF_PRJ_2 Changes
5294: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
5295: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
5296: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
5297: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5298:
5299: l_offset_type := 6;
5300: ELSE
5301: l_offset_type := 2;

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

5471: l_user_id,
5472: l_sysdate,
5473: l_user_id,
5474: --bug 3328421: Add at the end of the day
5475: TRUNC(l_supply_date(i)) + MSC_ATP_PVT.G_END_OF_DAY,
5476: --l_supply_date(i),
5477: 1, -- 1512366: open status.
5478: 60, -- offset sypply_type
5479: l_supply_qty(i),

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

5528: END IF;
5529: -- End Bug 3381464.
5530:
5531:
5532: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
5533: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
5534: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
5535: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5536:

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

5529: -- End Bug 3381464.
5530:
5531:
5532: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
5533: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
5534: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
5535: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5536:
5537: IF PG_DEBUG in ('Y', 'C') THEN

Line 5534: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

5530:
5531:
5532: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
5533: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
5534: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
5535: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5536:
5537: IF PG_DEBUG in ('Y', 'C') THEN
5538: msc_sch_wb.atp_debug('Add_Offset_Supplies: ' ||

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

5531:
5532: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
5533: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
5534: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
5535: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5536:
5537: IF PG_DEBUG in ('Y', 'C') THEN
5538: msc_sch_wb.atp_debug('Add_Offset_Supplies: ' ||
5539: ' before insert into' || ' msc_alloc_supplies');

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

5730:
5731: x_return_status := FND_API.G_RET_STS_SUCCESS;
5732:
5733: -- CTO_PF_PRJ_2 Changes
5734: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
5735: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
5736: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
5737: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5738:

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

5731: x_return_status := FND_API.G_RET_STS_SUCCESS;
5732:
5733: -- CTO_PF_PRJ_2 Changes
5734: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
5735: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
5736: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
5737: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5738:
5739: l_offset_type := 6;

Line 5736: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

5732:
5733: -- CTO_PF_PRJ_2 Changes
5734: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
5735: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
5736: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
5737: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5738:
5739: l_offset_type := 6;
5740: ELSE

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

5733: -- CTO_PF_PRJ_2 Changes
5734: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
5735: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
5736: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
5737: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
5738:
5739: l_offset_type := 6;
5740: ELSE
5741: l_offset_type := 2;

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

6093:
6094: x_return_status := FND_API.G_RET_STS_SUCCESS;
6095:
6096: -- CTO_PF_PRJ_2 Impacts
6097: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6098: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6099: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6100: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6101:

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

6094: x_return_status := FND_API.G_RET_STS_SUCCESS;
6095:
6096: -- CTO_PF_PRJ_2 Impacts
6097: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6098: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6099: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6100: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6101:
6102: l_offset_type := 5;

Line 6099: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

6095:
6096: -- CTO_PF_PRJ_2 Impacts
6097: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6098: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6099: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6100: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6101:
6102: l_offset_type := 5;
6103: ELSE

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

6096: -- CTO_PF_PRJ_2 Impacts
6097: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6098: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6099: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6100: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6101:
6102: l_offset_type := 5;
6103: ELSE
6104: l_offset_type := 3;

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

6137: SQL%BULK_ROWCOUNT(m)||' records');
6138: END LOOP;
6139: END IF;
6140:
6141: -- (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6142: -- Allocation Profiles check that was there before has been removed
6143: -- with the introduction of CTO_PF_PRJ_2 impacts.
6144: -- Relief_Type 7 can get created irrespective of allocation profiles.
6145:

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

6238:
6239: x_return_status := FND_API.G_RET_STS_SUCCESS;
6240:
6241: -- CTO_PF_PRJ_2 Changes Set Relief Type
6242: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6243: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6244: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6245: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6246:

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

6239: x_return_status := FND_API.G_RET_STS_SUCCESS;
6240:
6241: -- CTO_PF_PRJ_2 Changes Set Relief Type
6242: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6243: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6244: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6245: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6246:
6247: l_offset_type := 6;

Line 6244: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

6240:
6241: -- CTO_PF_PRJ_2 Changes Set Relief Type
6242: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6243: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6244: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6245: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6246:
6247: l_offset_type := 6;
6248: ELSE

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

6241: -- CTO_PF_PRJ_2 Changes Set Relief Type
6242: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6243: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6244: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6245: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6246:
6247: l_offset_type := 6;
6248: ELSE
6249: l_offset_type := 2;

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

6274: END IF;
6275: -- End Bug 3381464.
6276:
6277: -- CTO_PF_PRJ_2 Changes Set Relief Type
6278: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6279: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6280: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6281: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6282:

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

6275: -- End Bug 3381464.
6276:
6277: -- CTO_PF_PRJ_2 Changes Set Relief Type
6278: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6279: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6280: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6281: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6282:
6283: l_offset_type := 6;

Line 6280: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

6276:
6277: -- CTO_PF_PRJ_2 Changes Set Relief Type
6278: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6279: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6280: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6281: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6282:
6283: l_offset_type := 6;
6284: ELSE

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

6277: -- CTO_PF_PRJ_2 Changes Set Relief Type
6278: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6279: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6280: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6281: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6282:
6283: l_offset_type := 6;
6284: ELSE
6285: l_offset_type := 2;

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

6318: SQL%BULK_ROWCOUNT(m)||' records');
6319: END LOOP;
6320: END IF;
6321:
6322: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6323: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6324: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6325: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6326:

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

6319: END LOOP;
6320: END IF;
6321:
6322: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6323: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6324: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6325: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6326:
6327: IF PG_DEBUG in ('Y', 'C') THEN

Line 6324: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

6320: END IF;
6321:
6322: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6323: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6324: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6325: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6326:
6327: IF PG_DEBUG in ('Y', 'C') THEN
6328: msc_sch_wb.atp_debug('Remove_Offset_Supplies: before delete from ' ||

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

6321:
6322: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6323: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6324: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6325: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6326:
6327: IF PG_DEBUG in ('Y', 'C') THEN
6328: msc_sch_wb.atp_debug('Remove_Offset_Supplies: before delete from ' ||
6329: ' msc_alloc_supplies');

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

6557: END IF;
6558:
6559: x_return_status := FND_API.G_RET_STS_SUCCESS;
6560:
6561: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6562: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6563: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6564: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6565:

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

6558:
6559: x_return_status := FND_API.G_RET_STS_SUCCESS;
6560:
6561: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6562: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6563: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6564: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6565:
6566: l_dmd_offset_typ := 5;

Line 6563: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

6559: x_return_status := FND_API.G_RET_STS_SUCCESS;
6560:
6561: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6562: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6563: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6564: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6565:
6566: l_dmd_offset_typ := 5;
6567: ELSE

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

6560:
6561: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6562: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6563: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6564: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6565:
6566: l_dmd_offset_typ := 5;
6567: ELSE
6568: l_dmd_offset_typ := 3;

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

6728:
6729: x_return_status := FND_API.G_RET_STS_SUCCESS;
6730:
6731: -- CTO_PF_PRJ_2 Impacts
6732: IF (MSC_ATP_PVT.G_CTO_PF_ATP = 'Y') THEN
6733: l_insert_temp_table := 'MSC_ATP_PEG_TEMP';
6734: ELSE
6735: l_insert_temp_table := 'MSC_ATP_PEGGING';
6736: END IF;

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

6734: ELSE
6735: l_insert_temp_table := 'MSC_ATP_PEGGING';
6736: END IF;
6737:
6738: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6739: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6740: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6741: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6742:

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

6735: l_insert_temp_table := 'MSC_ATP_PEGGING';
6736: END IF;
6737:
6738: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6739: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6740: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6741: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6742:
6743: l_sup_offset_typ := 6;

Line 6740: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND

6736: END IF;
6737:
6738: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6739: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6740: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6741: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6742:
6743: l_sup_offset_typ := 6;
6744: l_dmd_offset_typ := 5;

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

6737:
6738: IF ((MSC_ATP_PVT.G_INV_CTP = 4) AND
6739: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y') AND
6740: (MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
6741: (MSC_ATP_PVT.G_ALLOCATION_METHOD = 1)) THEN
6742:
6743: l_sup_offset_typ := 6;
6744: l_dmd_offset_typ := 5;
6745: ELSE

Line 6865: MSC_ATP_PVT.ORG_DEMAND,

6861: EXECUTE IMMEDIATE l_sql_stmt_1 USING
6862: p_config_order_line_id,
6863: p_model_order_line_id,
6864: p_demand_source_type,
6865: MSC_ATP_PVT.ORG_DEMAND,
6866: MSC_ATP_PVT.ORG_DEMAND,
6867: MSC_ATP_PVT.MAKE_SUPPLY,
6868: MSC_ATP_PVT.TRANSFER_SUPPLY,
6869: MSC_ATP_PVT.BUY_SUPPLY,

Line 6866: MSC_ATP_PVT.ORG_DEMAND,

6862: p_config_order_line_id,
6863: p_model_order_line_id,
6864: p_demand_source_type,
6865: MSC_ATP_PVT.ORG_DEMAND,
6866: MSC_ATP_PVT.ORG_DEMAND,
6867: MSC_ATP_PVT.MAKE_SUPPLY,
6868: MSC_ATP_PVT.TRANSFER_SUPPLY,
6869: MSC_ATP_PVT.BUY_SUPPLY,
6870: MSC_ATP_PVT.MAKE_SUPPLY,

Line 6867: MSC_ATP_PVT.MAKE_SUPPLY,

6863: p_model_order_line_id,
6864: p_demand_source_type,
6865: MSC_ATP_PVT.ORG_DEMAND,
6866: MSC_ATP_PVT.ORG_DEMAND,
6867: MSC_ATP_PVT.MAKE_SUPPLY,
6868: MSC_ATP_PVT.TRANSFER_SUPPLY,
6869: MSC_ATP_PVT.BUY_SUPPLY,
6870: MSC_ATP_PVT.MAKE_SUPPLY,
6871: MSC_ATP_PVT.TRANSFER_SUPPLY,

Line 6868: MSC_ATP_PVT.TRANSFER_SUPPLY,

6864: p_demand_source_type,
6865: MSC_ATP_PVT.ORG_DEMAND,
6866: MSC_ATP_PVT.ORG_DEMAND,
6867: MSC_ATP_PVT.MAKE_SUPPLY,
6868: MSC_ATP_PVT.TRANSFER_SUPPLY,
6869: MSC_ATP_PVT.BUY_SUPPLY,
6870: MSC_ATP_PVT.MAKE_SUPPLY,
6871: MSC_ATP_PVT.TRANSFER_SUPPLY,
6872: MSC_ATP_PVT.BUY_SUPPLY,

Line 6869: MSC_ATP_PVT.BUY_SUPPLY,

6865: MSC_ATP_PVT.ORG_DEMAND,
6866: MSC_ATP_PVT.ORG_DEMAND,
6867: MSC_ATP_PVT.MAKE_SUPPLY,
6868: MSC_ATP_PVT.TRANSFER_SUPPLY,
6869: MSC_ATP_PVT.BUY_SUPPLY,
6870: MSC_ATP_PVT.MAKE_SUPPLY,
6871: MSC_ATP_PVT.TRANSFER_SUPPLY,
6872: MSC_ATP_PVT.BUY_SUPPLY,
6873: MSC_ATP_PVT.MAKE_SUPPLY,

Line 6870: MSC_ATP_PVT.MAKE_SUPPLY,

6866: MSC_ATP_PVT.ORG_DEMAND,
6867: MSC_ATP_PVT.MAKE_SUPPLY,
6868: MSC_ATP_PVT.TRANSFER_SUPPLY,
6869: MSC_ATP_PVT.BUY_SUPPLY,
6870: MSC_ATP_PVT.MAKE_SUPPLY,
6871: MSC_ATP_PVT.TRANSFER_SUPPLY,
6872: MSC_ATP_PVT.BUY_SUPPLY,
6873: MSC_ATP_PVT.MAKE_SUPPLY,
6874: MSC_ATP_PVT.TRANSFER_SUPPLY,

Line 6871: MSC_ATP_PVT.TRANSFER_SUPPLY,

6867: MSC_ATP_PVT.MAKE_SUPPLY,
6868: MSC_ATP_PVT.TRANSFER_SUPPLY,
6869: MSC_ATP_PVT.BUY_SUPPLY,
6870: MSC_ATP_PVT.MAKE_SUPPLY,
6871: MSC_ATP_PVT.TRANSFER_SUPPLY,
6872: MSC_ATP_PVT.BUY_SUPPLY,
6873: MSC_ATP_PVT.MAKE_SUPPLY,
6874: MSC_ATP_PVT.TRANSFER_SUPPLY,
6875: MSC_ATP_PVT.BUY_SUPPLY,

Line 6872: MSC_ATP_PVT.BUY_SUPPLY,

6868: MSC_ATP_PVT.TRANSFER_SUPPLY,
6869: MSC_ATP_PVT.BUY_SUPPLY,
6870: MSC_ATP_PVT.MAKE_SUPPLY,
6871: MSC_ATP_PVT.TRANSFER_SUPPLY,
6872: MSC_ATP_PVT.BUY_SUPPLY,
6873: MSC_ATP_PVT.MAKE_SUPPLY,
6874: MSC_ATP_PVT.TRANSFER_SUPPLY,
6875: MSC_ATP_PVT.BUY_SUPPLY,
6876: MSC_ATP_PVT.RESOURCE_DEMAND,

Line 6873: MSC_ATP_PVT.MAKE_SUPPLY,

6869: MSC_ATP_PVT.BUY_SUPPLY,
6870: MSC_ATP_PVT.MAKE_SUPPLY,
6871: MSC_ATP_PVT.TRANSFER_SUPPLY,
6872: MSC_ATP_PVT.BUY_SUPPLY,
6873: MSC_ATP_PVT.MAKE_SUPPLY,
6874: MSC_ATP_PVT.TRANSFER_SUPPLY,
6875: MSC_ATP_PVT.BUY_SUPPLY,
6876: MSC_ATP_PVT.RESOURCE_DEMAND,
6877: MSC_ATP_PVT.ORG_DEMAND,

Line 6874: MSC_ATP_PVT.TRANSFER_SUPPLY,

6870: MSC_ATP_PVT.MAKE_SUPPLY,
6871: MSC_ATP_PVT.TRANSFER_SUPPLY,
6872: MSC_ATP_PVT.BUY_SUPPLY,
6873: MSC_ATP_PVT.MAKE_SUPPLY,
6874: MSC_ATP_PVT.TRANSFER_SUPPLY,
6875: MSC_ATP_PVT.BUY_SUPPLY,
6876: MSC_ATP_PVT.RESOURCE_DEMAND,
6877: MSC_ATP_PVT.ORG_DEMAND,
6878: l_dmd_offset_typ,

Line 6875: MSC_ATP_PVT.BUY_SUPPLY,

6871: MSC_ATP_PVT.TRANSFER_SUPPLY,
6872: MSC_ATP_PVT.BUY_SUPPLY,
6873: MSC_ATP_PVT.MAKE_SUPPLY,
6874: MSC_ATP_PVT.TRANSFER_SUPPLY,
6875: MSC_ATP_PVT.BUY_SUPPLY,
6876: MSC_ATP_PVT.RESOURCE_DEMAND,
6877: MSC_ATP_PVT.ORG_DEMAND,
6878: l_dmd_offset_typ,
6879: MSC_ATP_PVT.MAKE_SUPPLY,

Line 6876: MSC_ATP_PVT.RESOURCE_DEMAND,

6872: MSC_ATP_PVT.BUY_SUPPLY,
6873: MSC_ATP_PVT.MAKE_SUPPLY,
6874: MSC_ATP_PVT.TRANSFER_SUPPLY,
6875: MSC_ATP_PVT.BUY_SUPPLY,
6876: MSC_ATP_PVT.RESOURCE_DEMAND,
6877: MSC_ATP_PVT.ORG_DEMAND,
6878: l_dmd_offset_typ,
6879: MSC_ATP_PVT.MAKE_SUPPLY,
6880: l_sup_offset_typ,

Line 6877: MSC_ATP_PVT.ORG_DEMAND,

6873: MSC_ATP_PVT.MAKE_SUPPLY,
6874: MSC_ATP_PVT.TRANSFER_SUPPLY,
6875: MSC_ATP_PVT.BUY_SUPPLY,
6876: MSC_ATP_PVT.RESOURCE_DEMAND,
6877: MSC_ATP_PVT.ORG_DEMAND,
6878: l_dmd_offset_typ,
6879: MSC_ATP_PVT.MAKE_SUPPLY,
6880: l_sup_offset_typ,
6881: MSC_ATP_PVT.TRANSFER_SUPPLY,

Line 6879: MSC_ATP_PVT.MAKE_SUPPLY,

6875: MSC_ATP_PVT.BUY_SUPPLY,
6876: MSC_ATP_PVT.RESOURCE_DEMAND,
6877: MSC_ATP_PVT.ORG_DEMAND,
6878: l_dmd_offset_typ,
6879: MSC_ATP_PVT.MAKE_SUPPLY,
6880: l_sup_offset_typ,
6881: MSC_ATP_PVT.TRANSFER_SUPPLY,
6882: l_sup_offset_typ,
6883: MSC_ATP_PVT.RESOURCE_DEMAND,

Line 6881: MSC_ATP_PVT.TRANSFER_SUPPLY,

6877: MSC_ATP_PVT.ORG_DEMAND,
6878: l_dmd_offset_typ,
6879: MSC_ATP_PVT.MAKE_SUPPLY,
6880: l_sup_offset_typ,
6881: MSC_ATP_PVT.TRANSFER_SUPPLY,
6882: l_sup_offset_typ,
6883: MSC_ATP_PVT.RESOURCE_DEMAND,
6884: MSC_ATP_PVT.BUY_SUPPLY,
6885: l_sup_offset_typ,

Line 6883: MSC_ATP_PVT.RESOURCE_DEMAND,

6879: MSC_ATP_PVT.MAKE_SUPPLY,
6880: l_sup_offset_typ,
6881: MSC_ATP_PVT.TRANSFER_SUPPLY,
6882: l_sup_offset_typ,
6883: MSC_ATP_PVT.RESOURCE_DEMAND,
6884: MSC_ATP_PVT.BUY_SUPPLY,
6885: l_sup_offset_typ,
6886: MSC_ATP_PVT.ORG_DEMAND,
6887: p_identifier,

Line 6884: MSC_ATP_PVT.BUY_SUPPLY,

6880: l_sup_offset_typ,
6881: MSC_ATP_PVT.TRANSFER_SUPPLY,
6882: l_sup_offset_typ,
6883: MSC_ATP_PVT.RESOURCE_DEMAND,
6884: MSC_ATP_PVT.BUY_SUPPLY,
6885: l_sup_offset_typ,
6886: MSC_ATP_PVT.ORG_DEMAND,
6887: p_identifier,
6888: p_instance_id,

Line 6886: MSC_ATP_PVT.ORG_DEMAND,

6882: l_sup_offset_typ,
6883: MSC_ATP_PVT.RESOURCE_DEMAND,
6884: MSC_ATP_PVT.BUY_SUPPLY,
6885: l_sup_offset_typ,
6886: MSC_ATP_PVT.ORG_DEMAND,
6887: p_identifier,
6888: p_instance_id,
6889: MSC_ATP_PVT.G_SESSION_ID;
6890: -- End CTO_PF_PRJ_2 Impacts SQL are changed to Dynamic Ones

Line 6889: MSC_ATP_PVT.G_SESSION_ID;

6885: l_sup_offset_typ,
6886: MSC_ATP_PVT.ORG_DEMAND,
6887: p_identifier,
6888: p_instance_id,
6889: MSC_ATP_PVT.G_SESSION_ID;
6890: -- End CTO_PF_PRJ_2 Impacts SQL are changed to Dynamic Ones
6891:
6892: IF PG_DEBUG in ('Y', 'C') THEN
6893: msc_sch_wb.atp_debug('Create_Atp_Pegging: Number of rows inserted-1 '||

Line 6900: DECODE (pegging_type, MSC_ATP_PVT.ORG_DEMAND,

6896:
6897: SELECT DEST_INV_ITEM_ID, identifier2,
6898: -- Bug 3334643 Track the plan_id
6899: -- CTO_PF_PRJ Get End Demand Id
6900: DECODE (pegging_type, MSC_ATP_PVT.ORG_DEMAND,
6901: identifier3, NULL) end_demand_id
6902: INTO l_reference_item_id, l_plan_id, l_end_demand_id
6903: -- End CTO_PF_PRJ Get End Demand Id
6904: -- Bug 3334643 Track the plan_id

Line 6910: AND session_id = MSC_ATP_PVT.G_SESSION_ID;

6906: WHERE pegging_id = p_identifier
6907: AND identifier1 = p_instance_id
6908: AND record_type = 3
6909: AND model_sd_flag = 1
6910: AND session_id = MSC_ATP_PVT.G_SESSION_ID;
6911:
6912: IF PG_DEBUG in ('Y', 'C') THEN
6913: msc_sch_wb.atp_debug('Create_Atp_Pegging: l_reference_item_id ' ||
6914: l_reference_item_id);

Line 7030: MSC_ATP_PVT.ORG_DEMAND,

7026: l_reference_item_id,
7027: p_config_order_line_id,
7028: p_model_order_line_id,
7029: p_demand_source_type,
7030: MSC_ATP_PVT.ORG_DEMAND,
7031: MSC_ATP_PVT.ORG_DEMAND,
7032: MSC_ATP_PVT.MAKE_SUPPLY,
7033: MSC_ATP_PVT.TRANSFER_SUPPLY,
7034: MSC_ATP_PVT.BUY_SUPPLY,

Line 7031: MSC_ATP_PVT.ORG_DEMAND,

7027: p_config_order_line_id,
7028: p_model_order_line_id,
7029: p_demand_source_type,
7030: MSC_ATP_PVT.ORG_DEMAND,
7031: MSC_ATP_PVT.ORG_DEMAND,
7032: MSC_ATP_PVT.MAKE_SUPPLY,
7033: MSC_ATP_PVT.TRANSFER_SUPPLY,
7034: MSC_ATP_PVT.BUY_SUPPLY,
7035: MSC_ATP_PVT.RESOURCE_DEMAND,

Line 7032: MSC_ATP_PVT.MAKE_SUPPLY,

7028: p_model_order_line_id,
7029: p_demand_source_type,
7030: MSC_ATP_PVT.ORG_DEMAND,
7031: MSC_ATP_PVT.ORG_DEMAND,
7032: MSC_ATP_PVT.MAKE_SUPPLY,
7033: MSC_ATP_PVT.TRANSFER_SUPPLY,
7034: MSC_ATP_PVT.BUY_SUPPLY,
7035: MSC_ATP_PVT.RESOURCE_DEMAND,
7036: MSC_ATP_PVT.MAKE_SUPPLY,

Line 7033: MSC_ATP_PVT.TRANSFER_SUPPLY,

7029: p_demand_source_type,
7030: MSC_ATP_PVT.ORG_DEMAND,
7031: MSC_ATP_PVT.ORG_DEMAND,
7032: MSC_ATP_PVT.MAKE_SUPPLY,
7033: MSC_ATP_PVT.TRANSFER_SUPPLY,
7034: MSC_ATP_PVT.BUY_SUPPLY,
7035: MSC_ATP_PVT.RESOURCE_DEMAND,
7036: MSC_ATP_PVT.MAKE_SUPPLY,
7037: MSC_ATP_PVT.TRANSFER_SUPPLY,

Line 7034: MSC_ATP_PVT.BUY_SUPPLY,

7030: MSC_ATP_PVT.ORG_DEMAND,
7031: MSC_ATP_PVT.ORG_DEMAND,
7032: MSC_ATP_PVT.MAKE_SUPPLY,
7033: MSC_ATP_PVT.TRANSFER_SUPPLY,
7034: MSC_ATP_PVT.BUY_SUPPLY,
7035: MSC_ATP_PVT.RESOURCE_DEMAND,
7036: MSC_ATP_PVT.MAKE_SUPPLY,
7037: MSC_ATP_PVT.TRANSFER_SUPPLY,
7038: MSC_ATP_PVT.BUY_SUPPLY,

Line 7035: MSC_ATP_PVT.RESOURCE_DEMAND,

7031: MSC_ATP_PVT.ORG_DEMAND,
7032: MSC_ATP_PVT.MAKE_SUPPLY,
7033: MSC_ATP_PVT.TRANSFER_SUPPLY,
7034: MSC_ATP_PVT.BUY_SUPPLY,
7035: MSC_ATP_PVT.RESOURCE_DEMAND,
7036: MSC_ATP_PVT.MAKE_SUPPLY,
7037: MSC_ATP_PVT.TRANSFER_SUPPLY,
7038: MSC_ATP_PVT.BUY_SUPPLY,
7039: MSC_ATP_PVT.MAKE_SUPPLY,

Line 7036: MSC_ATP_PVT.MAKE_SUPPLY,

7032: MSC_ATP_PVT.MAKE_SUPPLY,
7033: MSC_ATP_PVT.TRANSFER_SUPPLY,
7034: MSC_ATP_PVT.BUY_SUPPLY,
7035: MSC_ATP_PVT.RESOURCE_DEMAND,
7036: MSC_ATP_PVT.MAKE_SUPPLY,
7037: MSC_ATP_PVT.TRANSFER_SUPPLY,
7038: MSC_ATP_PVT.BUY_SUPPLY,
7039: MSC_ATP_PVT.MAKE_SUPPLY,
7040: MSC_ATP_PVT.TRANSFER_SUPPLY,

Line 7037: MSC_ATP_PVT.TRANSFER_SUPPLY,

7033: MSC_ATP_PVT.TRANSFER_SUPPLY,
7034: MSC_ATP_PVT.BUY_SUPPLY,
7035: MSC_ATP_PVT.RESOURCE_DEMAND,
7036: MSC_ATP_PVT.MAKE_SUPPLY,
7037: MSC_ATP_PVT.TRANSFER_SUPPLY,
7038: MSC_ATP_PVT.BUY_SUPPLY,
7039: MSC_ATP_PVT.MAKE_SUPPLY,
7040: MSC_ATP_PVT.TRANSFER_SUPPLY,
7041: MSC_ATP_PVT.BUY_SUPPLY,

Line 7038: MSC_ATP_PVT.BUY_SUPPLY,

7034: MSC_ATP_PVT.BUY_SUPPLY,
7035: MSC_ATP_PVT.RESOURCE_DEMAND,
7036: MSC_ATP_PVT.MAKE_SUPPLY,
7037: MSC_ATP_PVT.TRANSFER_SUPPLY,
7038: MSC_ATP_PVT.BUY_SUPPLY,
7039: MSC_ATP_PVT.MAKE_SUPPLY,
7040: MSC_ATP_PVT.TRANSFER_SUPPLY,
7041: MSC_ATP_PVT.BUY_SUPPLY,
7042: MSC_ATP_PVT.RESOURCE_DEMAND,

Line 7039: MSC_ATP_PVT.MAKE_SUPPLY,

7035: MSC_ATP_PVT.RESOURCE_DEMAND,
7036: MSC_ATP_PVT.MAKE_SUPPLY,
7037: MSC_ATP_PVT.TRANSFER_SUPPLY,
7038: MSC_ATP_PVT.BUY_SUPPLY,
7039: MSC_ATP_PVT.MAKE_SUPPLY,
7040: MSC_ATP_PVT.TRANSFER_SUPPLY,
7041: MSC_ATP_PVT.BUY_SUPPLY,
7042: MSC_ATP_PVT.RESOURCE_DEMAND,
7043: MSC_ATP_PVT.ORG_DEMAND,

Line 7040: MSC_ATP_PVT.TRANSFER_SUPPLY,

7036: MSC_ATP_PVT.MAKE_SUPPLY,
7037: MSC_ATP_PVT.TRANSFER_SUPPLY,
7038: MSC_ATP_PVT.BUY_SUPPLY,
7039: MSC_ATP_PVT.MAKE_SUPPLY,
7040: MSC_ATP_PVT.TRANSFER_SUPPLY,
7041: MSC_ATP_PVT.BUY_SUPPLY,
7042: MSC_ATP_PVT.RESOURCE_DEMAND,
7043: MSC_ATP_PVT.ORG_DEMAND,
7044: l_dmd_offset_typ,

Line 7041: MSC_ATP_PVT.BUY_SUPPLY,

7037: MSC_ATP_PVT.TRANSFER_SUPPLY,
7038: MSC_ATP_PVT.BUY_SUPPLY,
7039: MSC_ATP_PVT.MAKE_SUPPLY,
7040: MSC_ATP_PVT.TRANSFER_SUPPLY,
7041: MSC_ATP_PVT.BUY_SUPPLY,
7042: MSC_ATP_PVT.RESOURCE_DEMAND,
7043: MSC_ATP_PVT.ORG_DEMAND,
7044: l_dmd_offset_typ,
7045: MSC_ATP_PVT.MAKE_SUPPLY,

Line 7042: MSC_ATP_PVT.RESOURCE_DEMAND,

7038: MSC_ATP_PVT.BUY_SUPPLY,
7039: MSC_ATP_PVT.MAKE_SUPPLY,
7040: MSC_ATP_PVT.TRANSFER_SUPPLY,
7041: MSC_ATP_PVT.BUY_SUPPLY,
7042: MSC_ATP_PVT.RESOURCE_DEMAND,
7043: MSC_ATP_PVT.ORG_DEMAND,
7044: l_dmd_offset_typ,
7045: MSC_ATP_PVT.MAKE_SUPPLY,
7046: l_sup_offset_typ,

Line 7043: MSC_ATP_PVT.ORG_DEMAND,

7039: MSC_ATP_PVT.MAKE_SUPPLY,
7040: MSC_ATP_PVT.TRANSFER_SUPPLY,
7041: MSC_ATP_PVT.BUY_SUPPLY,
7042: MSC_ATP_PVT.RESOURCE_DEMAND,
7043: MSC_ATP_PVT.ORG_DEMAND,
7044: l_dmd_offset_typ,
7045: MSC_ATP_PVT.MAKE_SUPPLY,
7046: l_sup_offset_typ,
7047: MSC_ATP_PVT.TRANSFER_SUPPLY,

Line 7045: MSC_ATP_PVT.MAKE_SUPPLY,

7041: MSC_ATP_PVT.BUY_SUPPLY,
7042: MSC_ATP_PVT.RESOURCE_DEMAND,
7043: MSC_ATP_PVT.ORG_DEMAND,
7044: l_dmd_offset_typ,
7045: MSC_ATP_PVT.MAKE_SUPPLY,
7046: l_sup_offset_typ,
7047: MSC_ATP_PVT.TRANSFER_SUPPLY,
7048: l_sup_offset_typ,
7049: MSC_ATP_PVT.RESOURCE_DEMAND,

Line 7047: MSC_ATP_PVT.TRANSFER_SUPPLY,

7043: MSC_ATP_PVT.ORG_DEMAND,
7044: l_dmd_offset_typ,
7045: MSC_ATP_PVT.MAKE_SUPPLY,
7046: l_sup_offset_typ,
7047: MSC_ATP_PVT.TRANSFER_SUPPLY,
7048: l_sup_offset_typ,
7049: MSC_ATP_PVT.RESOURCE_DEMAND,
7050: MSC_ATP_PVT.BUY_SUPPLY,
7051: l_sup_offset_typ,

Line 7049: MSC_ATP_PVT.RESOURCE_DEMAND,

7045: MSC_ATP_PVT.MAKE_SUPPLY,
7046: l_sup_offset_typ,
7047: MSC_ATP_PVT.TRANSFER_SUPPLY,
7048: l_sup_offset_typ,
7049: MSC_ATP_PVT.RESOURCE_DEMAND,
7050: MSC_ATP_PVT.BUY_SUPPLY,
7051: l_sup_offset_typ,
7052: l_end_demand_id,
7053: p_identifier,

Line 7050: MSC_ATP_PVT.BUY_SUPPLY,

7046: l_sup_offset_typ,
7047: MSC_ATP_PVT.TRANSFER_SUPPLY,
7048: l_sup_offset_typ,
7049: MSC_ATP_PVT.RESOURCE_DEMAND,
7050: MSC_ATP_PVT.BUY_SUPPLY,
7051: l_sup_offset_typ,
7052: l_end_demand_id,
7053: p_identifier,
7054: MSC_ATP_PVT.G_SESSION_ID,

Line 7054: MSC_ATP_PVT.G_SESSION_ID,

7050: MSC_ATP_PVT.BUY_SUPPLY,
7051: l_sup_offset_typ,
7052: l_end_demand_id,
7053: p_identifier,
7054: MSC_ATP_PVT.G_SESSION_ID,
7055: p_identifier,
7056: MSC_ATP_PVT.G_SESSION_ID;
7057: -- End CTO_PF_PRJ_2 Impacts SQL are changed to Dynamic Ones
7058:

Line 7056: MSC_ATP_PVT.G_SESSION_ID;

7052: l_end_demand_id,
7053: p_identifier,
7054: MSC_ATP_PVT.G_SESSION_ID,
7055: p_identifier,
7056: MSC_ATP_PVT.G_SESSION_ID;
7057: -- End CTO_PF_PRJ_2 Impacts SQL are changed to Dynamic Ones
7058:
7059: IF PG_DEBUG in ('Y', 'C') THEN
7060: msc_sch_wb.atp_debug('Create_Atp_Pegging: Number of rows inserted '||

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

7061: SQL%ROWCOUNT);
7062: END IF;
7063:
7064: -- CTO_PF_PRJ Impacts
7065: IF (MSC_ATP_PVT.G_CTO_PF_ATP = 'Y') THEN
7066: -- Call Procedure to insert data from temp table to main table
7067: -- For PF items, PF related processing will be done.
7068: Create_PF_Atp_Pegging ( l_reference_item_id ,
7069: p_model_order_line_id ,