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

APPS.MSC_AATP_PVT dependencies on MSC_AATP_PVT

Line 1: PACKAGE BODY MSC_AATP_PVT AS

1: PACKAGE BODY MSC_AATP_PVT AS
2: /* $Header: MSCAATPB.pls 120.25 2011/12/06 09:42:32 vjuluri ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MSC_AATP_PVT';
5: -- ship_rec_cal

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MSC_AATP_PVT';

1: PACKAGE BODY MSC_AATP_PVT AS
2: /* $Header: MSCAATPB.pls 120.25 2011/12/06 09:42:32 vjuluri ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MSC_AATP_PVT';
5: -- ship_rec_cal
6: G_USER_ID CONSTANT NUMBER := FND_GLOBAL.USER_ID;
7:
8: -- INFINITE_NUMBER CONSTANT NUMBER := 1.0e+10;

Line 3888: MSC_AATP_PVT.Get_DC_Info(p_instance_id, l_item_to_use, p_organization_id, null, null,

3884: -- select the priority and allocation_percent for that item/demand class.
3885: -- if no data found, check if this item has a valid allocation rule.
3886: -- otherwise return error.
3887: IF p_scenario_id <> -1 THEN
3888: MSC_AATP_PVT.Get_DC_Info(p_instance_id, l_item_to_use, p_organization_id, null, null,
3889: p_demand_class, p_request_date, l_level_id, l_priority, l_allocation_percent, l_return_status);
3890:
3891: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3892: IF PG_DEBUG in ('Y', 'C') THEN

Line 3910: called from MSC_AATP_PVT.VIEW_ALLOCATION for view total*/

3906: END IF;
3907:
3908: /* rajjain 01/29/2003 Bug 2737596
3909: We don't need to select all demand classes in case this procdure is
3910: called from MSC_AATP_PVT.VIEW_ALLOCATION for view total*/
3911: IF p_identifier <> -1 or (p_identifier = -1 and p_scenario_id <> -1) THEN
3912:
3913: IF PG_DEBUG in ('Y', 'C') THEN
3914: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'before select the high priority demand class');

Line 4637: from MSC_AATP_PVT.VIEW_ALLOCATION for view total*/

4633: END IF;
4634:
4635: /* rajjain 01/29/2003 Bug 2737596
4636: We only need to do b/w consumption, f/w consumption and accumulation in case the call is
4637: from MSC_AATP_PVT.VIEW_ALLOCATION for view total*/
4638: IF p_identifier <> -1 or (p_identifier = -1 and p_scenario_id <> -1) THEN
4639:
4640: -- do backward consumption for DCi
4641:

Line 4835: MSC_AATP_PVT.Atp_Demand_Class_Consume(l_current_atp, l_class_curr_steal_atp, p_atf_date);

4831: END IF;
4832:
4833: /* time_phased_atp
4834: pass p_atf_date to make sure we do not do demand class consumption across ATF*/
4835: MSC_AATP_PVT.Atp_Demand_Class_Consume(l_current_atp, l_class_curr_steal_atp, p_atf_date);
4836:
4837: IF PG_DEBUG in ('Y', 'C') THEN
4838: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'After consume l_class_curr_steal_atp');
4839: Print_Period_Qty('l_current_atp.atp_period:atp_qty = ',

Line 4862: MSC_AATP_PVT.Atp_Demand_Class_Consume(l_current_atp, l_partner_curr_steal_atp, p_atf_date);

4858: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'before consume l_partner_curr_steal_atp');
4859: END IF;
4860: /* time_phased_atp
4861: pass p_atf_date to make sure we do not do demand class consumption across ATF*/
4862: MSC_AATP_PVT.Atp_Demand_Class_Consume(l_current_atp, l_partner_curr_steal_atp, p_atf_date);
4863:
4864: IF PG_DEBUG in ('Y', 'C') THEN
4865: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'After consume l_partner_curr_steal_atp');
4866: Print_Period_Qty('l_current_atp.atp_period:atp_qty = ',

Line 4884: MSC_AATP_PVT.Atp_Demand_Class_Consume(l_current_atp, l_current_steal_atp, p_atf_date);

4880: END IF;
4881:
4882: /* time_phased_atp
4883: pass p_atf_date to make sure we do not do demand class consumption across ATF*/
4884: MSC_AATP_PVT.Atp_Demand_Class_Consume(l_current_atp, l_current_steal_atp, p_atf_date);
4885:
4886: IF PG_DEBUG in ('Y', 'C') THEN
4887: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'After consume l_current_steal_atp');
4888:

Line 5114: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_atp, l_next_steal_atp);

5110: l_next_steal_atp);
5111: END IF;
5112:
5113: -- we need to prepare the l_next_steal_atp for next priority
5114: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_atp, l_next_steal_atp);
5115: IF PG_DEBUG in ('Y', 'C') THEN
5116: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'after Add_to_Next_Steal_Atp');
5117: Print_Period_Qty('l_current_atp.atp_period:atp_qty = ',
5118: l_current_atp);

Line 5137: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);

5133: Print_Period_Qty('l_next_steal_atp.atp_period:atp_qty = ',
5134: l_next_steal_atp);
5135: END IF;
5136:
5137: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
5138:
5139: IF PG_DEBUG in ('Y', 'C') THEN
5140: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'after Add_to_Next_Steal_Atp');
5141:

Line 5212: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);

5208: -- add all negatives to l_current_atp and do forward consumption
5209: IF PG_DEBUG in ('Y', 'C') THEN
5210: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'l_fw_consume_tab(i) is 4');
5211: END IF;
5212: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
5213: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
5214: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
5215: l_partner_next_steal_atp);
5216: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,

Line 5213: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);

5209: IF PG_DEBUG in ('Y', 'C') THEN
5210: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'l_fw_consume_tab(i) is 4');
5211: END IF;
5212: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
5213: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
5214: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
5215: l_partner_next_steal_atp);
5216: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,
5217: l_class_next_steal_atp);

Line 5214: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,

5210: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'l_fw_consume_tab(i) is 4');
5211: END IF;
5212: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
5213: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
5214: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
5215: l_partner_next_steal_atp);
5216: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,
5217: l_class_next_steal_atp);
5218: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_class_curr_steal_atp,

Line 5216: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,

5212: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
5213: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
5214: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
5215: l_partner_next_steal_atp);
5216: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,
5217: l_class_next_steal_atp);
5218: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_class_curr_steal_atp,
5219: l_class_next_steal_atp);
5220: IF PG_DEBUG in ('Y', 'C') THEN

Line 5218: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_class_curr_steal_atp,

5214: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
5215: l_partner_next_steal_atp);
5216: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,
5217: l_class_next_steal_atp);
5218: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_class_curr_steal_atp,
5219: l_class_next_steal_atp);
5220: IF PG_DEBUG in ('Y', 'C') THEN
5221: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'before Add_to_Next_Steal_Atp');
5222:

Line 5304: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_atp, l_next_steal_atp);

5300: Print_Period_Qty('l_next_steal_atp.atp_period:atp_qty = ',
5301: l_next_steal_atp);
5302: END IF;
5303:
5304: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_atp, l_next_steal_atp);
5305:
5306: IF PG_DEBUG in ('Y', 'C') THEN
5307: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'after Add_to_Next_Steal_Atp');
5308:

Line 5327: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);

5323: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' ||
5324: 'We are at lowest priority customer at current customer class level ');
5325: END IF;
5326:
5327: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
5328: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
5329: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
5330: l_partner_next_steal_atp);
5331: IF G_ATP_FW_CONSUME_METHOD <> 1 OR l_fw_consume_tab(i) <> 3 THEN

Line 5328: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);

5324: 'We are at lowest priority customer at current customer class level ');
5325: END IF;
5326:
5327: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
5328: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
5329: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
5330: l_partner_next_steal_atp);
5331: IF G_ATP_FW_CONSUME_METHOD <> 1 OR l_fw_consume_tab(i) <> 3 THEN
5332: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,

Line 5329: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,

5325: END IF;
5326:
5327: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
5328: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
5329: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
5330: l_partner_next_steal_atp);
5331: IF G_ATP_FW_CONSUME_METHOD <> 1 OR l_fw_consume_tab(i) <> 3 THEN
5332: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,
5333: l_class_next_steal_atp);

Line 5332: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,

5328: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
5329: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
5330: l_partner_next_steal_atp);
5331: IF G_ATP_FW_CONSUME_METHOD <> 1 OR l_fw_consume_tab(i) <> 3 THEN
5332: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,
5333: l_class_next_steal_atp);
5334: END IF;
5335: IF PG_DEBUG in ('Y', 'C') THEN
5336: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'after Adding Add_to_Next_Steal_Atp');

Line 5361: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_class_curr_steal_atp,

5357: l_class_next_steal_atp);
5358: Print_Period_Qty('l_class_curr_steal_atp.atp_period:atp_qty = ',
5359: l_class_curr_steal_atp);
5360: END IF;
5361: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_class_curr_steal_atp,
5362: l_class_next_steal_atp);
5363: IF PG_DEBUG in ('Y', 'C') THEN
5364: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'after Adding Add_to_Next_Steal_Atp');
5365:

Line 5395: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);

5391: l_current_steal_atp);
5392: Print_Period_Qty('l_partner_next_steal_atp.atp_period:atp_qty = ',
5393: l_partner_next_steal_atp);
5394: END IF;
5395: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
5396:
5397: IF G_ATP_FW_CONSUME_METHOD <> 1 OR l_fw_consume_tab(i) <> 2 THEN
5398: -- if forward consumption type is 2 we wont add the negatives in l_next_steal_atp
5399: -- to l_partner_steal_atp. we will add the negatives to l_current_atp and do forward

Line 5401: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);

5397: IF G_ATP_FW_CONSUME_METHOD <> 1 OR l_fw_consume_tab(i) <> 2 THEN
5398: -- if forward consumption type is 2 we wont add the negatives in l_next_steal_atp
5399: -- to l_partner_steal_atp. we will add the negatives to l_current_atp and do forward
5400: -- consumption instead.
5401: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
5402: END IF;
5403:
5404: IF PG_DEBUG in ('Y', 'C') THEN
5405: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'after Adding Add_to_Next_Steal_Atp');

Line 5425: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,

5421: Print_Period_Qty('l_partner_next_steal_atp.atp_period:atp_qty = ',
5422: l_partner_next_steal_atp);
5423: END IF;
5424:
5425: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
5426: l_partner_next_steal_atp);
5427:
5428: IF PG_DEBUG in ('Y', 'C') THEN
5429: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'after Adding Add_to_Next_Steal_Atp');

Line 5461: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);

5457: l_current_steal_atp);
5458: Print_Period_Qty('l_next_steal_atp.atp_period:atp_qty = ',
5459: l_next_steal_atp);
5460: END IF;
5461: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
5462: IF PG_DEBUG in ('Y', 'C') THEN
5463: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'after Adding Add_to_Next_Steal_Atp');
5464:
5465: Print_Period_Qty('l_current_steal_atp.atp_period:atp_qty = ',

Line 5608: from MSC_AATP_PVT.VIEW_ALLOCATION for view total*/

5604: -- rajjain AATP Forward Consumption end
5605: ELSE --IF p_identifier <> -1 or (p_identifier = -1 and p_scenario_id <> -1) THEN
5606: /* rajjain 01/29/2003 Bug 2737596
5607: We only need to do b/w consumption, f/w consumption and accumulation in case the call is
5608: from MSC_AATP_PVT.VIEW_ALLOCATION for view total*/
5609: MSC_ATP_PROC.Atp_Consume(l_current_atp.atp_qty, l_current_atp.atp_qty.COUNT);
5610: END IF;
5611:
5612: -- 1665110

Line 5874: MSC_AATP_PVT.Get_DC_Info(p_instance_id, null, p_organization_id,

5870:
5871: -- If request is from view allocation for total ATP, assign
5872: -- l_priority = -1 and l_allocation_percent = NULL
5873: IF p_scenario_id <> -1 THEN
5874: MSC_AATP_PVT.Get_DC_Info(p_instance_id, null, p_organization_id,
5875: p_department_id, p_resource_id, p_demand_class,
5876: p_request_date, l_level_id, l_priority, l_allocation_percent, l_return_status);
5877:
5878: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 5897: -- called from MSC_AATP_PVT.VIEW_ALLOCATION as we don't need to take care

5893: IF PG_DEBUG in ('Y', 'C') THEN
5894: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'l_allocation_percent = '||l_allocation_percent);
5895: END IF;
5896: -- We don't need to select all demand classes in case this procdure is
5897: -- called from MSC_AATP_PVT.VIEW_ALLOCATION as we don't need to take care
5898: -- of any existing stealing.
5899: IF p_identifier <> -1 THEN
5900:
5901: IF PG_DEBUG in ('Y', 'C') THEN

Line 8312: MSC_AATP_PVT.Atp_Demand_Class_Consume(l_current_atp, l_class_curr_steal_atp);

8308: Print_Period_Qty('l_class_curr_steal_atp.atp_period:atp_qty = ',
8309: l_class_curr_steal_atp);
8310: END IF;
8311:
8312: MSC_AATP_PVT.Atp_Demand_Class_Consume(l_current_atp, l_class_curr_steal_atp);
8313:
8314: IF PG_DEBUG in ('Y', 'C') THEN
8315: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'After consume l_class_curr_steal_atp');
8316: Print_Period_Qty('l_current_atp.atp_period:atp_qty = ',

Line 8336: MSC_AATP_PVT.Atp_Demand_Class_Consume(l_current_atp, l_partner_curr_steal_atp);

8332:
8333: IF PG_DEBUG in ('Y', 'C') THEN
8334: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'before consume l_partner_curr_steal_atp');
8335: END IF;
8336: MSC_AATP_PVT.Atp_Demand_Class_Consume(l_current_atp, l_partner_curr_steal_atp);
8337:
8338: IF PG_DEBUG in ('Y', 'C') THEN
8339: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'After consume l_partner_curr_steal_atp');
8340: Print_Period_Qty('l_current_atp.atp_period:atp_qty = ',

Line 8358: MSC_AATP_PVT.Atp_Demand_Class_Consume(l_current_atp, l_current_steal_atp);

8354: l_current_steal_atp);
8355:
8356: END IF;
8357:
8358: MSC_AATP_PVT.Atp_Demand_Class_Consume(l_current_atp, l_current_steal_atp);
8359:
8360: IF PG_DEBUG in ('Y', 'C') THEN
8361: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'After consume l_current_steal_atp');
8362:

Line 8437: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_atp, l_next_steal_atp);

8433: ---bug 1655110
8434: IF (l_demand_class <> p_demand_class) THEN
8435: -- we need to prepare the l_next_steal_atp for next priorit
8436:
8437: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_atp, l_next_steal_atp);
8438:
8439: -- 1680719
8440: IF l_level_id IN (-1, 1) THEN
8441: IF l_demand_class_priority_tab(i)<

Line 8455: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);

8451: l_next_steal_atp);
8452:
8453: END IF;
8454:
8455: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
8456:
8457: IF PG_DEBUG in ('Y', 'C') THEN
8458: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'after Add_to_Next_Steal_Atp');
8459: Print_Period_Qty('l_next_steal_atp.atp_period:atp_qty = ',

Line 8481: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);

8477: IF PG_DEBUG in ('Y', 'C') THEN
8478: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'class changed');
8479: END IF;
8480:
8481: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
8482: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
8483: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
8484: l_partner_next_steal_atp);
8485: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,

Line 8482: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);

8478: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'class changed');
8479: END IF;
8480:
8481: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
8482: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
8483: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
8484: l_partner_next_steal_atp);
8485: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,
8486: l_class_next_steal_atp);

Line 8483: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,

8479: END IF;
8480:
8481: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
8482: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
8483: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
8484: l_partner_next_steal_atp);
8485: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,
8486: l_class_next_steal_atp);
8487:

Line 8485: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,

8481: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
8482: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
8483: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
8484: l_partner_next_steal_atp);
8485: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,
8486: l_class_next_steal_atp);
8487:
8488: IF trunc(l_demand_class_priority_tab(i), -3)<
8489: trunc(l_demand_class_priority_tab (i+1), -3) THEN

Line 8491: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_class_curr_steal_atp,

8487:
8488: IF trunc(l_demand_class_priority_tab(i), -3)<
8489: trunc(l_demand_class_priority_tab (i+1), -3) THEN
8490:
8491: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_class_curr_steal_atp,
8492: l_class_next_steal_atp);
8493:
8494: END IF;
8495:

Line 8506: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);

8502: -- customer changed
8503: IF PG_DEBUG in ('Y', 'C') THEN
8504: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'customer not the same');
8505: END IF;
8506: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
8507:
8508: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
8509:
8510: IF trunc(l_demand_class_priority_tab(i), -2)<

Line 8508: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);

8504: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'customer not the same');
8505: END IF;
8506: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
8507:
8508: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
8509:
8510: IF trunc(l_demand_class_priority_tab(i), -2)<
8511: trunc(l_demand_class_priority_tab (i+1), -2) THEN
8512: -- customer priority changed

Line 8517: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,

8513:
8514: IF PG_DEBUG in ('Y', 'C') THEN
8515: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'customer priority changed');
8516: END IF;
8517: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
8518: l_partner_next_steal_atp);
8519:
8520: END IF;
8521:

Line 8531: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);

8527: END IF;
8528: IF (l_demand_class_priority_tab(i)<>
8529: l_demand_class_priority_tab (i+1)) THEN
8530: -- site level priority changed
8531: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
8532:
8533: END IF;
8534: END IF;
8535: END IF;

Line 8757: --MSC_AATP_PVT.Get_DC_Info(l_instance_id, p_sup_atp_info_rec.inventory_item_id, p_sup_atp_info_rec.organization_id, null, null,

8753: END IF;
8754: --e_cto_rearch
8755:
8756:
8757: --MSC_AATP_PVT.Get_DC_Info(l_instance_id, p_sup_atp_info_rec.inventory_item_id, p_sup_atp_info_rec.organization_id, null, null,
8758: MSC_AATP_PVT.Get_DC_Info(l_instance_id, l_inv_item_id, p_sup_atp_info_rec.organization_id, null, null,
8759: p_sup_atp_info_rec.demand_class, p_request_date, l_level_id, l_priority, l_allocation_percent, l_return_status);
8760: -- find the demand classes that have priority higher (small number) than
8761: -- the requested demand class

Line 8758: MSC_AATP_PVT.Get_DC_Info(l_instance_id, l_inv_item_id, p_sup_atp_info_rec.organization_id, null, null,

8754: --e_cto_rearch
8755:
8756:
8757: --MSC_AATP_PVT.Get_DC_Info(l_instance_id, p_sup_atp_info_rec.inventory_item_id, p_sup_atp_info_rec.organization_id, null, null,
8758: MSC_AATP_PVT.Get_DC_Info(l_instance_id, l_inv_item_id, p_sup_atp_info_rec.organization_id, null, null,
8759: p_sup_atp_info_rec.demand_class, p_request_date, l_level_id, l_priority, l_allocation_percent, l_return_status);
8760: -- find the demand classes that have priority higher (small number) than
8761: -- the requested demand class
8762:

Line 10056: MSC_AATP_PVT.Atp_demand_class_Consume(l_current_atp, l_class_curr_steal_atp);

10052: Print_Period_Qty('l_class_curr_steal_atp.atp_period:atp_qty = ',
10053: l_class_curr_steal_atp);
10054: END IF;
10055:
10056: MSC_AATP_PVT.Atp_demand_class_Consume(l_current_atp, l_class_curr_steal_atp);
10057:
10058: IF PG_DEBUG in ('Y', 'C') THEN
10059: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'After consume l_class_curr_steal_atp');
10060: Print_Period_Qty('l_current_atp.atp_period:atp_qty = ',

Line 10080: MSC_AATP_PVT.Atp_demand_class_Consume(l_current_atp, l_partner_curr_steal_atp);

10076:
10077: IF PG_DEBUG in ('Y', 'C') THEN
10078: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'before consume l_partner_curr_steal_atp');
10079: END IF;
10080: MSC_AATP_PVT.Atp_demand_class_Consume(l_current_atp, l_partner_curr_steal_atp);
10081:
10082: IF PG_DEBUG in ('Y', 'C') THEN
10083: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'After consume l_partner_curr_steal_atp');
10084: Print_Period_Qty('l_current_atp.atp_period:atp_qty = ',

Line 10099: MSC_AATP_PVT.Atp_demand_class_Consume(l_current_atp, l_current_steal_atp);

10095: Print_Period_Qty('l_current_steal_atp.atp_period:atp_qty = ',
10096: l_current_steal_atp);
10097: END IF;
10098:
10099: MSC_AATP_PVT.Atp_demand_class_Consume(l_current_atp, l_current_steal_atp);
10100:
10101: IF PG_DEBUG in ('Y', 'C') THEN
10102: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'After consume l_current_steal_atp');
10103: Print_Period_Qty('l_current_atp.atp_period:atp_qty = ',

Line 10181: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_atp, l_next_steal_atp);

10177: ---bug 1665110
10178: IF (l_demand_class <> p_sup_atp_info_rec.demand_class) THEN
10179: -- we need to prepare the l_next_steal_atp for next priorit
10180:
10181: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_atp, l_next_steal_atp);
10182:
10183: -- 1680719
10184: IF l_level_id IN (-1, 1) THEN
10185: IF l_demand_class_priority_tab(i)<

Line 10198: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);

10194: Print_Period_Qty('l_next_steal_atp.atp_period:atp_qty = ',
10195: l_next_steal_atp);
10196: END IF;
10197:
10198: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
10199:
10200: IF PG_DEBUG in ('Y', 'C') THEN
10201: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'after Add_to_Next_Steal_Atp');
10202: Print_Period_Qty('l_next_steal_atp.atp_period:atp_qty = ',

Line 10224: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);

10220: IF PG_DEBUG in ('Y', 'C') THEN
10221: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'class changed');
10222: END IF;
10223:
10224: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
10225: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
10226: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
10227: l_partner_next_steal_atp);
10228: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,

Line 10225: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);

10221: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'class changed');
10222: END IF;
10223:
10224: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
10225: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
10226: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
10227: l_partner_next_steal_atp);
10228: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,
10229: l_class_next_steal_atp);

Line 10226: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,

10222: END IF;
10223:
10224: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
10225: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
10226: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
10227: l_partner_next_steal_atp);
10228: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,
10229: l_class_next_steal_atp);
10230:

Line 10228: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,

10224: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
10225: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
10226: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
10227: l_partner_next_steal_atp);
10228: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,
10229: l_class_next_steal_atp);
10230:
10231:
10232: IF trunc(l_demand_class_priority_tab(i), -3)<

Line 10235: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_class_curr_steal_atp,

10231:
10232: IF trunc(l_demand_class_priority_tab(i), -3)<
10233: trunc(l_demand_class_priority_tab (i+1), -3) THEN
10234:
10235: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_class_curr_steal_atp,
10236: l_class_next_steal_atp);
10237:
10238: END IF;
10239:

Line 10250: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);

10246: -- customer changed
10247: IF PG_DEBUG in ('Y', 'C') THEN
10248: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'customer not the same');
10249: END IF;
10250: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
10251:
10252: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
10253:
10254: IF trunc(l_demand_class_priority_tab(i), -2)<

Line 10252: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);

10248: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'customer not the same');
10249: END IF;
10250: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
10251:
10252: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
10253:
10254: IF trunc(l_demand_class_priority_tab(i), -2)<
10255: trunc(l_demand_class_priority_tab (i+1), -2) THEN
10256: -- customer priority changed

Line 10261: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,

10257:
10258: IF PG_DEBUG in ('Y', 'C') THEN
10259: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'customer priority changed');
10260: END IF;
10261: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
10262: l_partner_next_steal_atp);
10263:
10264: END IF;
10265:

Line 10275: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);

10271: END IF;
10272: IF (l_demand_class_priority_tab(i)<>
10273: l_demand_class_priority_tab (i+1)) THEN
10274: -- site level priority changed
10275: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
10276:
10277: END IF;
10278: END IF;
10279: END IF;

Line 10718: MSC_AATP_PVT.Item_Alloc_Cum_Atp(

10714: (MSC_ATP_PVT.G_ALLOCATION_METHOD <> 1))) THEN
10715:
10716: -- Original Code
10717:
10718: MSC_AATP_PVT.Item_Alloc_Cum_Atp(
10719: l_plan_id,
10720: 0, --p_level(for top level item)
10721: -1, --p_identifier
10722: -1, --p_scenario_id - For total request

Line 10833: MSC_AATP_PVT.Item_Alloc_Cum_Atp(

10829: ELSIF ((MSC_ATP_PVT.G_HIERARCHY_PROFILE <> 1) OR
10830: ((MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
10831: (MSC_ATP_PVT.G_ALLOCATION_METHOD <> 1))) THEN
10832:
10833: MSC_AATP_PVT.Item_Alloc_Cum_Atp(
10834: l_plan_id,
10835: 0, --p_level(for top level item)
10836: -1, --p_identifier
10837: 0, --p_scenario_id - Not Used

Line 10973: MSC_AATP_PVT.Res_Alloc_Cum_Atp(

10969: -- To get the total ATP, demand class is passed as NULL,
10970: -- Pass p_scenario_id = -1 to identify the call for
10971: -- toatl ATP and demand class to be null
10972:
10973: MSC_AATP_PVT.Res_Alloc_Cum_Atp(
10974: l_plan_id,
10975: 0, --p_level(for top level item)
10976: -1, --p_identifier
10977: -1, --p_scenario_id - To identify total request

Line 10999: MSC_AATP_PVT.Res_Alloc_Cum_Atp(

10995: -- don't need supply demand details in temp table.
10996:
10997: l_atp_supply_demand := l_atp_supply_demand_null;
10998: ELSE
10999: MSC_AATP_PVT.Res_Alloc_Cum_Atp(
11000: l_plan_id,
11001: 0, --p_level(for top level item)
11002: -1, --p_identifier
11003: 0, --p_scenario_id - Not Used

Line 11834: END MSC_AATP_PVT;

11830: IF PG_DEBUG in ('Y', 'C') THEN
11831: msc_sch_wb.atp_debug('********* END Stealing ************');
11832: END IF;
11833: END Stealing;
11834: END MSC_AATP_PVT;