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.4.12010000.3 2008/08/25 10:22:08 sbnaik 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.4.12010000.3 2008/08/25 10:22:08 sbnaik 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 3664: MSC_AATP_PVT.Get_DC_Info(p_instance_id, l_item_to_use, p_organization_id, null, null,

3660: -- select the priority and allocation_percent for that item/demand class.
3661: -- if no data found, check if this item has a valid allocation rule.
3662: -- otherwise return error.
3663: IF p_scenario_id <> -1 THEN
3664: MSC_AATP_PVT.Get_DC_Info(p_instance_id, l_item_to_use, p_organization_id, null, null,
3665: p_demand_class, p_request_date, l_level_id, l_priority, l_allocation_percent, l_return_status);
3666:
3667: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3668: IF PG_DEBUG in ('Y', 'C') THEN

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

3682: END IF;
3683:
3684: /* rajjain 01/29/2003 Bug 2737596
3685: We don't need to select all demand classes in case this procdure is
3686: called from MSC_AATP_PVT.VIEW_ALLOCATION for view total*/
3687: IF p_identifier <> -1 or (p_identifier = -1 and p_scenario_id <> -1) THEN
3688:
3689: IF PG_DEBUG in ('Y', 'C') THEN
3690: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'before select the high priority demand class');

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

4403: END IF;
4404:
4405: /* rajjain 01/29/2003 Bug 2737596
4406: We only need to do b/w consumption, f/w consumption and accumulation in case the call is
4407: from MSC_AATP_PVT.VIEW_ALLOCATION for view total*/
4408: IF p_identifier <> -1 or (p_identifier = -1 and p_scenario_id <> -1) THEN
4409:
4410: -- do backward consumption for DCi
4411:

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

4601: END IF;
4602:
4603: /* time_phased_atp
4604: pass p_atf_date to make sure we do not do demand class consumption across ATF*/
4605: MSC_AATP_PVT.Atp_Demand_Class_Consume(l_current_atp, l_class_curr_steal_atp, p_atf_date);
4606:
4607: IF PG_DEBUG in ('Y', 'C') THEN
4608: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'After consume l_class_curr_steal_atp');
4609: Print_Period_Qty('l_current_atp.atp_period:atp_qty = ',

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

4628: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'before consume l_partner_curr_steal_atp');
4629: END IF;
4630: /* time_phased_atp
4631: pass p_atf_date to make sure we do not do demand class consumption across ATF*/
4632: MSC_AATP_PVT.Atp_Demand_Class_Consume(l_current_atp, l_partner_curr_steal_atp, p_atf_date);
4633:
4634: IF PG_DEBUG in ('Y', 'C') THEN
4635: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'After consume l_partner_curr_steal_atp');
4636: Print_Period_Qty('l_current_atp.atp_period:atp_qty = ',

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

4650: END IF;
4651:
4652: /* time_phased_atp
4653: pass p_atf_date to make sure we do not do demand class consumption across ATF*/
4654: MSC_AATP_PVT.Atp_Demand_Class_Consume(l_current_atp, l_current_steal_atp, p_atf_date);
4655:
4656: IF PG_DEBUG in ('Y', 'C') THEN
4657: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'After consume l_current_steal_atp');
4658:

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

4880: l_next_steal_atp);
4881: END IF;
4882:
4883: -- we need to prepare the l_next_steal_atp for next priority
4884: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_atp, l_next_steal_atp);
4885: IF PG_DEBUG in ('Y', 'C') THEN
4886: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'after Add_to_Next_Steal_Atp');
4887: Print_Period_Qty('l_current_atp.atp_period:atp_qty = ',
4888: l_current_atp);

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

4903: Print_Period_Qty('l_next_steal_atp.atp_period:atp_qty = ',
4904: l_next_steal_atp);
4905: END IF;
4906:
4907: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
4908:
4909: IF PG_DEBUG in ('Y', 'C') THEN
4910: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'after Add_to_Next_Steal_Atp');
4911:

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

4978: -- add all negatives to l_current_atp and do forward consumption
4979: IF PG_DEBUG in ('Y', 'C') THEN
4980: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'l_fw_consume_tab(i) is 4');
4981: END IF;
4982: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
4983: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
4984: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
4985: l_partner_next_steal_atp);
4986: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,

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

4979: IF PG_DEBUG in ('Y', 'C') THEN
4980: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'l_fw_consume_tab(i) is 4');
4981: END IF;
4982: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
4983: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
4984: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
4985: l_partner_next_steal_atp);
4986: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,
4987: l_class_next_steal_atp);

Line 4984: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,

4980: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'l_fw_consume_tab(i) is 4');
4981: END IF;
4982: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
4983: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
4984: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
4985: l_partner_next_steal_atp);
4986: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,
4987: l_class_next_steal_atp);
4988: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_class_curr_steal_atp,

Line 4986: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,

4982: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
4983: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
4984: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
4985: l_partner_next_steal_atp);
4986: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,
4987: l_class_next_steal_atp);
4988: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_class_curr_steal_atp,
4989: l_class_next_steal_atp);
4990: IF PG_DEBUG in ('Y', 'C') THEN

Line 4988: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_class_curr_steal_atp,

4984: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
4985: l_partner_next_steal_atp);
4986: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,
4987: l_class_next_steal_atp);
4988: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_class_curr_steal_atp,
4989: l_class_next_steal_atp);
4990: IF PG_DEBUG in ('Y', 'C') THEN
4991: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'before Add_to_Next_Steal_Atp');
4992:

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

5070: Print_Period_Qty('l_next_steal_atp.atp_period:atp_qty = ',
5071: l_next_steal_atp);
5072: END IF;
5073:
5074: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_atp, l_next_steal_atp);
5075:
5076: IF PG_DEBUG in ('Y', 'C') THEN
5077: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'after Add_to_Next_Steal_Atp');
5078:

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

5093: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' ||
5094: 'We are at lowest priority customer at current customer class level ');
5095: END IF;
5096:
5097: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
5098: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
5099: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
5100: l_partner_next_steal_atp);
5101: IF G_ATP_FW_CONSUME_METHOD <> 1 OR l_fw_consume_tab(i) <> 3 THEN

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

5094: 'We are at lowest priority customer at current customer class level ');
5095: END IF;
5096:
5097: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
5098: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
5099: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
5100: l_partner_next_steal_atp);
5101: IF G_ATP_FW_CONSUME_METHOD <> 1 OR l_fw_consume_tab(i) <> 3 THEN
5102: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,

Line 5099: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,

5095: END IF;
5096:
5097: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
5098: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
5099: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
5100: l_partner_next_steal_atp);
5101: IF G_ATP_FW_CONSUME_METHOD <> 1 OR l_fw_consume_tab(i) <> 3 THEN
5102: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,
5103: l_class_next_steal_atp);

Line 5102: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,

5098: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
5099: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
5100: l_partner_next_steal_atp);
5101: IF G_ATP_FW_CONSUME_METHOD <> 1 OR l_fw_consume_tab(i) <> 3 THEN
5102: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,
5103: l_class_next_steal_atp);
5104: END IF;
5105: IF PG_DEBUG in ('Y', 'C') THEN
5106: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'after Adding Add_to_Next_Steal_Atp');

Line 5131: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_class_curr_steal_atp,

5127: l_class_next_steal_atp);
5128: Print_Period_Qty('l_class_curr_steal_atp.atp_period:atp_qty = ',
5129: l_class_curr_steal_atp);
5130: END IF;
5131: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_class_curr_steal_atp,
5132: l_class_next_steal_atp);
5133: IF PG_DEBUG in ('Y', 'C') THEN
5134: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'after Adding Add_to_Next_Steal_Atp');
5135:

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

5161: l_current_steal_atp);
5162: Print_Period_Qty('l_partner_next_steal_atp.atp_period:atp_qty = ',
5163: l_partner_next_steal_atp);
5164: END IF;
5165: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
5166:
5167: IF G_ATP_FW_CONSUME_METHOD <> 1 OR l_fw_consume_tab(i) <> 2 THEN
5168: -- if forward consumption type is 2 we wont add the negatives in l_next_steal_atp
5169: -- to l_partner_steal_atp. we will add the negatives to l_current_atp and do forward

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

5167: IF G_ATP_FW_CONSUME_METHOD <> 1 OR l_fw_consume_tab(i) <> 2 THEN
5168: -- if forward consumption type is 2 we wont add the negatives in l_next_steal_atp
5169: -- to l_partner_steal_atp. we will add the negatives to l_current_atp and do forward
5170: -- consumption instead.
5171: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
5172: END IF;
5173:
5174: IF PG_DEBUG in ('Y', 'C') THEN
5175: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'after Adding Add_to_Next_Steal_Atp');

Line 5195: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,

5191: Print_Period_Qty('l_partner_next_steal_atp.atp_period:atp_qty = ',
5192: l_partner_next_steal_atp);
5193: END IF;
5194:
5195: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
5196: l_partner_next_steal_atp);
5197:
5198: IF PG_DEBUG in ('Y', 'C') THEN
5199: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'after Adding Add_to_Next_Steal_Atp');

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

5227: l_current_steal_atp);
5228: Print_Period_Qty('l_next_steal_atp.atp_period:atp_qty = ',
5229: l_next_steal_atp);
5230: END IF;
5231: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
5232: IF PG_DEBUG in ('Y', 'C') THEN
5233: msc_sch_wb.atp_debug('Item_Alloc_Cum_Atp: ' || 'after Adding Add_to_Next_Steal_Atp');
5234:
5235: Print_Period_Qty('l_current_steal_atp.atp_period:atp_qty = ',

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

5374: -- rajjain AATP Forward Consumption end
5375: ELSE --IF p_identifier <> -1 or (p_identifier = -1 and p_scenario_id <> -1) THEN
5376: /* rajjain 01/29/2003 Bug 2737596
5377: We only need to do b/w consumption, f/w consumption and accumulation in case the call is
5378: from MSC_AATP_PVT.VIEW_ALLOCATION for view total*/
5379: MSC_ATP_PROC.Atp_Consume(l_current_atp.atp_qty, l_current_atp.atp_qty.COUNT);
5380: END IF;
5381:
5382: -- 1665110

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

5640:
5641: -- If request is from view allocation for total ATP, assign
5642: -- l_priority = -1 and l_allocation_percent = NULL
5643: IF p_scenario_id <> -1 THEN
5644: MSC_AATP_PVT.Get_DC_Info(p_instance_id, null, p_organization_id,
5645: p_department_id, p_resource_id, p_demand_class,
5646: p_request_date, l_level_id, l_priority, l_allocation_percent, l_return_status);
5647:
5648: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

5663: IF PG_DEBUG in ('Y', 'C') THEN
5664: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'l_allocation_percent = '||l_allocation_percent);
5665: END IF;
5666: -- We don't need to select all demand classes in case this procdure is
5667: -- called from MSC_AATP_PVT.VIEW_ALLOCATION as we don't need to take care
5668: -- of any existing stealing.
5669: IF p_identifier <> -1 THEN
5670:
5671: IF PG_DEBUG in ('Y', 'C') THEN

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

8078: Print_Period_Qty('l_class_curr_steal_atp.atp_period:atp_qty = ',
8079: l_class_curr_steal_atp);
8080: END IF;
8081:
8082: MSC_AATP_PVT.Atp_Demand_Class_Consume(l_current_atp, l_class_curr_steal_atp);
8083:
8084: IF PG_DEBUG in ('Y', 'C') THEN
8085: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'After consume l_class_curr_steal_atp');
8086: Print_Period_Qty('l_current_atp.atp_period:atp_qty = ',

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

8102:
8103: IF PG_DEBUG in ('Y', 'C') THEN
8104: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'before consume l_partner_curr_steal_atp');
8105: END IF;
8106: MSC_AATP_PVT.Atp_Demand_Class_Consume(l_current_atp, l_partner_curr_steal_atp);
8107:
8108: IF PG_DEBUG in ('Y', 'C') THEN
8109: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'After consume l_partner_curr_steal_atp');
8110: Print_Period_Qty('l_current_atp.atp_period:atp_qty = ',

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

8124: l_current_steal_atp);
8125:
8126: END IF;
8127:
8128: MSC_AATP_PVT.Atp_Demand_Class_Consume(l_current_atp, l_current_steal_atp);
8129:
8130: IF PG_DEBUG in ('Y', 'C') THEN
8131: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'After consume l_current_steal_atp');
8132:

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

8203: ---bug 1655110
8204: IF (l_demand_class <> p_demand_class) THEN
8205: -- we need to prepare the l_next_steal_atp for next priorit
8206:
8207: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_atp, l_next_steal_atp);
8208:
8209: -- 1680719
8210: IF l_level_id IN (-1, 1) THEN
8211: IF l_demand_class_priority_tab(i)<

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

8221: l_next_steal_atp);
8222:
8223: END IF;
8224:
8225: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
8226:
8227: IF PG_DEBUG in ('Y', 'C') THEN
8228: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'after Add_to_Next_Steal_Atp');
8229: Print_Period_Qty('l_next_steal_atp.atp_period:atp_qty = ',

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

8247: IF PG_DEBUG in ('Y', 'C') THEN
8248: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'class changed');
8249: END IF;
8250:
8251: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
8252: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
8253: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
8254: l_partner_next_steal_atp);
8255: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,

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

8248: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'class changed');
8249: END IF;
8250:
8251: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
8252: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
8253: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
8254: l_partner_next_steal_atp);
8255: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,
8256: l_class_next_steal_atp);

Line 8253: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,

8249: END IF;
8250:
8251: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
8252: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
8253: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
8254: l_partner_next_steal_atp);
8255: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,
8256: l_class_next_steal_atp);
8257:

Line 8255: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,

8251: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
8252: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
8253: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
8254: l_partner_next_steal_atp);
8255: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,
8256: l_class_next_steal_atp);
8257:
8258: IF trunc(l_demand_class_priority_tab(i), -3)<
8259: trunc(l_demand_class_priority_tab (i+1), -3) THEN

Line 8261: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_class_curr_steal_atp,

8257:
8258: IF trunc(l_demand_class_priority_tab(i), -3)<
8259: trunc(l_demand_class_priority_tab (i+1), -3) THEN
8260:
8261: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_class_curr_steal_atp,
8262: l_class_next_steal_atp);
8263:
8264: END IF;
8265:

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

8272: -- customer changed
8273: IF PG_DEBUG in ('Y', 'C') THEN
8274: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'customer not the same');
8275: END IF;
8276: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
8277:
8278: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
8279:
8280: IF trunc(l_demand_class_priority_tab(i), -2)<

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

8274: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'customer not the same');
8275: END IF;
8276: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
8277:
8278: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
8279:
8280: IF trunc(l_demand_class_priority_tab(i), -2)<
8281: trunc(l_demand_class_priority_tab (i+1), -2) THEN
8282: -- customer priority changed

Line 8287: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,

8283:
8284: IF PG_DEBUG in ('Y', 'C') THEN
8285: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'customer priority changed');
8286: END IF;
8287: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
8288: l_partner_next_steal_atp);
8289:
8290: END IF;
8291:

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

8297: END IF;
8298: IF (l_demand_class_priority_tab(i)<>
8299: l_demand_class_priority_tab (i+1)) THEN
8300: -- site level priority changed
8301: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
8302:
8303: END IF;
8304: END IF;
8305: END IF;

Line 8526: --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,

8522: END IF;
8523: --e_cto_rearch
8524:
8525:
8526: --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,
8527: MSC_AATP_PVT.Get_DC_Info(l_instance_id, l_inv_item_id, p_sup_atp_info_rec.organization_id, null, null,
8528: p_sup_atp_info_rec.demand_class, p_request_date, l_level_id, l_priority, l_allocation_percent, l_return_status);
8529: -- find the demand classes that have priority higher (small number) than
8530: -- the requested demand class

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

8523: --e_cto_rearch
8524:
8525:
8526: --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,
8527: MSC_AATP_PVT.Get_DC_Info(l_instance_id, l_inv_item_id, p_sup_atp_info_rec.organization_id, null, null,
8528: p_sup_atp_info_rec.demand_class, p_request_date, l_level_id, l_priority, l_allocation_percent, l_return_status);
8529: -- find the demand classes that have priority higher (small number) than
8530: -- the requested demand class
8531:

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

9821: Print_Period_Qty('l_class_curr_steal_atp.atp_period:atp_qty = ',
9822: l_class_curr_steal_atp);
9823: END IF;
9824:
9825: MSC_AATP_PVT.Atp_demand_class_Consume(l_current_atp, l_class_curr_steal_atp);
9826:
9827: IF PG_DEBUG in ('Y', 'C') THEN
9828: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'After consume l_class_curr_steal_atp');
9829: Print_Period_Qty('l_current_atp.atp_period:atp_qty = ',

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

9845:
9846: IF PG_DEBUG in ('Y', 'C') THEN
9847: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'before consume l_partner_curr_steal_atp');
9848: END IF;
9849: MSC_AATP_PVT.Atp_demand_class_Consume(l_current_atp, l_partner_curr_steal_atp);
9850:
9851: IF PG_DEBUG in ('Y', 'C') THEN
9852: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'After consume l_partner_curr_steal_atp');
9853: Print_Period_Qty('l_current_atp.atp_period:atp_qty = ',

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

9864: Print_Period_Qty('l_current_steal_atp.atp_period:atp_qty = ',
9865: l_current_steal_atp);
9866: END IF;
9867:
9868: MSC_AATP_PVT.Atp_demand_class_Consume(l_current_atp, l_current_steal_atp);
9869:
9870: IF PG_DEBUG in ('Y', 'C') THEN
9871: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'After consume l_current_steal_atp');
9872: Print_Period_Qty('l_current_atp.atp_period:atp_qty = ',

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

9946: ---bug 1665110
9947: IF (l_demand_class <> p_sup_atp_info_rec.demand_class) THEN
9948: -- we need to prepare the l_next_steal_atp for next priorit
9949:
9950: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_atp, l_next_steal_atp);
9951:
9952: -- 1680719
9953: IF l_level_id IN (-1, 1) THEN
9954: IF l_demand_class_priority_tab(i)<

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

9963: Print_Period_Qty('l_next_steal_atp.atp_period:atp_qty = ',
9964: l_next_steal_atp);
9965: END IF;
9966:
9967: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
9968:
9969: IF PG_DEBUG in ('Y', 'C') THEN
9970: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'after Add_to_Next_Steal_Atp');
9971: Print_Period_Qty('l_next_steal_atp.atp_period:atp_qty = ',

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

9989: IF PG_DEBUG in ('Y', 'C') THEN
9990: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'class changed');
9991: END IF;
9992:
9993: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
9994: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
9995: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
9996: l_partner_next_steal_atp);
9997: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,

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

9990: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'class changed');
9991: END IF;
9992:
9993: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
9994: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
9995: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
9996: l_partner_next_steal_atp);
9997: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,
9998: l_class_next_steal_atp);

Line 9995: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,

9991: END IF;
9992:
9993: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
9994: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
9995: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
9996: l_partner_next_steal_atp);
9997: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,
9998: l_class_next_steal_atp);
9999:

Line 9997: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,

9993: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
9994: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
9995: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
9996: l_partner_next_steal_atp);
9997: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_next_steal_atp,
9998: l_class_next_steal_atp);
9999:
10000:
10001: IF trunc(l_demand_class_priority_tab(i), -3)<

Line 10004: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_class_curr_steal_atp,

10000:
10001: IF trunc(l_demand_class_priority_tab(i), -3)<
10002: trunc(l_demand_class_priority_tab (i+1), -3) THEN
10003:
10004: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_class_curr_steal_atp,
10005: l_class_next_steal_atp);
10006:
10007: END IF;
10008:

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

10015: -- customer changed
10016: IF PG_DEBUG in ('Y', 'C') THEN
10017: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'customer not the same');
10018: END IF;
10019: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
10020:
10021: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
10022:
10023: IF trunc(l_demand_class_priority_tab(i), -2)<

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

10017: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'customer not the same');
10018: END IF;
10019: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
10020:
10021: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_next_steal_atp, l_partner_next_steal_atp);
10022:
10023: IF trunc(l_demand_class_priority_tab(i), -2)<
10024: trunc(l_demand_class_priority_tab (i+1), -2) THEN
10025: -- customer priority changed

Line 10030: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,

10026:
10027: IF PG_DEBUG in ('Y', 'C') THEN
10028: msc_sch_wb.atp_debug('Supplier_Alloc_Cum_Atp: ' || 'customer priority changed');
10029: END IF;
10030: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_partner_curr_steal_atp,
10031: l_partner_next_steal_atp);
10032:
10033: END IF;
10034:

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

10040: END IF;
10041: IF (l_demand_class_priority_tab(i)<>
10042: l_demand_class_priority_tab (i+1)) THEN
10043: -- site level priority changed
10044: MSC_AATP_PVT.Add_to_Next_Steal_Atp(l_current_steal_atp, l_next_steal_atp);
10045:
10046: END IF;
10047: END IF;
10048: END IF;

Line 10487: MSC_AATP_PVT.Item_Alloc_Cum_Atp(

10483: (MSC_ATP_PVT.G_ALLOCATION_METHOD <> 1))) THEN
10484:
10485: -- Original Code
10486:
10487: MSC_AATP_PVT.Item_Alloc_Cum_Atp(
10488: l_plan_id,
10489: 0, --p_level(for top level item)
10490: -1, --p_identifier
10491: -1, --p_scenario_id - For total request

Line 10602: MSC_AATP_PVT.Item_Alloc_Cum_Atp(

10598: ELSIF ((MSC_ATP_PVT.G_HIERARCHY_PROFILE <> 1) OR
10599: ((MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1) AND
10600: (MSC_ATP_PVT.G_ALLOCATION_METHOD <> 1))) THEN
10601:
10602: MSC_AATP_PVT.Item_Alloc_Cum_Atp(
10603: l_plan_id,
10604: 0, --p_level(for top level item)
10605: -1, --p_identifier
10606: 0, --p_scenario_id - Not Used

Line 10742: MSC_AATP_PVT.Res_Alloc_Cum_Atp(

10738: -- To get the total ATP, demand class is passed as NULL,
10739: -- Pass p_scenario_id = -1 to identify the call for
10740: -- toatl ATP and demand class to be null
10741:
10742: MSC_AATP_PVT.Res_Alloc_Cum_Atp(
10743: l_plan_id,
10744: 0, --p_level(for top level item)
10745: -1, --p_identifier
10746: -1, --p_scenario_id - To identify total request

Line 10768: MSC_AATP_PVT.Res_Alloc_Cum_Atp(

10764: -- don't need supply demand details in temp table.
10765:
10766: l_atp_supply_demand := l_atp_supply_demand_null;
10767: ELSE
10768: MSC_AATP_PVT.Res_Alloc_Cum_Atp(
10769: l_plan_id,
10770: 0, --p_level(for top level item)
10771: -1, --p_identifier
10772: 0, --p_scenario_id - Not Used

Line 11594: END MSC_AATP_PVT;

11590: IF PG_DEBUG in ('Y', 'C') THEN
11591: msc_sch_wb.atp_debug('********* END Stealing ************');
11592: END IF;
11593: END Stealing;
11594: END MSC_AATP_PVT;