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_ALLOC dependencies on DUAL

Line 96: PROCEDURE Compute_Cum_Individual(

92: p_end_index IN number,
93: p_steal_atp IN MRP_ATP_PVT.ATP_Info,
94: x_return_status OUT NOCOPY VARCHAR2);
95:
96: PROCEDURE Compute_Cum_Individual(
97: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
98: p_start_index IN NUMBER,
99: p_end_index IN NUMBER,
100: x_return_status OUT NOCOPY VARCHAR2);

Line 167: FROM dual;

163:
164: -- Get next working day from sysdate required for compute_allocation_details.
165: SELECT MSC_CALENDAR.NEXT_WORK_DAY(p_organization_id, p_instance_id, 1, TRUNC(sysdate))
166: INTO l_request_date
167: FROM dual;
168:
169: IF (l_request_date = NULL) THEN
170: IF PG_DEBUG in ('Y', 'C') THEN
171: msc_sch_wb.atp_debug('View_Allocation_Details: ' || 'There is no matching calander date');

Line 1039: 2. Forward consumtion logic is such that individual stealing acts cannot be recorded,

1035:
1036: /*
1037: 1. Copy the supply demand records from msc_supplies and msc_demands
1038: into mrp_atp_details_temp. Perform allocation in the process.
1039: 2. Forward consumtion logic is such that individual stealing acts cannot be recorded,
1040: therefore, we do not select from_demand_class.
1041: 3. MSC_ALLOC_TEMP here stores allocation demand classes. We make a cartesian to split the supplies/demands
1042: 4. Finally we put only those records where allocated_quantity <> 0
1043: */

Line 2022: 2. Forward consumtion logic is such that individual stealing acts cannot be recorded,

2018:
2019: /*
2020: 1. Copy the supply demand records from msc_supplies and msc_demands
2021: into mrp_atp_details_temp in case of Customer Class Allocated ATP.
2022: 2. Forward consumtion logic is such that individual stealing acts cannot be recorded,
2023: therefore, we do not select from_demand_class.
2024: But we select partner_id and partner_site_id, class and demand_class.
2025: 3. Finally we put only those records where allocated_quantity <> 0
2026: */

Line 4868: PROCEDURE Compute_Cum_Individual(

4864:
4865: /*--Compute_Cum------------------------------------------------------------
4866: | o Does accumulation for a specific demand class.
4867: +-------------------------------------------------------------------------*/
4868: PROCEDURE Compute_Cum_Individual(
4869: p_atp_period IN OUT NOCOPY MRP_ATP_PUB.ATP_Period_Typ,
4870: p_start_index IN NUMBER,
4871: p_end_index IN NUMBER,
4872: x_return_status OUT NOCOPY VARCHAR2)

Line 4879: msc_sch_wb.atp_debug('Compute_Cum_Individual: ' || 'Begin Compute_Cum_Individual Procedure**');

4875: l_cumm NUMBER;
4876: BEGIN
4877:
4878: IF PG_DEBUG in ('Y', 'C') THEN
4879: msc_sch_wb.atp_debug('Compute_Cum_Individual: ' || '**********Begin Compute_Cum_Individual Procedure************');
4880: msc_sch_wb.atp_debug('Compute_Cum_Individual: ' || 'p_start_index : ' || p_start_index);
4881: msc_sch_wb.atp_debug('Compute_Cum_Individual: ' || 'p_end_index : ' || p_end_index);
4882: END IF;
4883:

Line 4880: msc_sch_wb.atp_debug('Compute_Cum_Individual: ' || 'p_start_index : ' || p_start_index);

4876: BEGIN
4877:
4878: IF PG_DEBUG in ('Y', 'C') THEN
4879: msc_sch_wb.atp_debug('Compute_Cum_Individual: ' || '**********Begin Compute_Cum_Individual Procedure************');
4880: msc_sch_wb.atp_debug('Compute_Cum_Individual: ' || 'p_start_index : ' || p_start_index);
4881: msc_sch_wb.atp_debug('Compute_Cum_Individual: ' || 'p_end_index : ' || p_end_index);
4882: END IF;
4883:
4884: -- Initializing API return code

Line 4881: msc_sch_wb.atp_debug('Compute_Cum_Individual: ' || 'p_end_index : ' || p_end_index);

4877:
4878: IF PG_DEBUG in ('Y', 'C') THEN
4879: msc_sch_wb.atp_debug('Compute_Cum_Individual: ' || '**********Begin Compute_Cum_Individual Procedure************');
4880: msc_sch_wb.atp_debug('Compute_Cum_Individual: ' || 'p_start_index : ' || p_start_index);
4881: msc_sch_wb.atp_debug('Compute_Cum_Individual: ' || 'p_end_index : ' || p_end_index);
4882: END IF;
4883:
4884: -- Initializing API return code
4885: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4899: msc_sch_wb.atp_debug('Compute_Cum_Individual: ' || 'cum date:qty - '||

4895:
4896: IF PG_DEBUG in ('Y', 'C') THEN
4897: i := p_start_index;
4898: WHILE (i is not null) AND (i <= p_end_index) LOOP
4899: msc_sch_wb.atp_debug('Compute_Cum_Individual: ' || 'cum date:qty - '||
4900: p_atp_period.Period_Start_Date(i) ||' : '|| p_atp_period.cumulative_quantity(i) );
4901: i := p_atp_period.Period_Start_Date.Next(i);
4902: END LOOP;
4903: msc_sch_wb.atp_debug('Compute_Cum_Individual: ' || '**********End Compute_Cum_Individual Procedure************');

Line 4903: msc_sch_wb.atp_debug('Compute_Cum_Individual: ' || 'End Compute_Cum_Individual Procedure**');

4899: msc_sch_wb.atp_debug('Compute_Cum_Individual: ' || 'cum date:qty - '||
4900: p_atp_period.Period_Start_Date(i) ||' : '|| p_atp_period.cumulative_quantity(i) );
4901: i := p_atp_period.Period_Start_Date.Next(i);
4902: END LOOP;
4903: msc_sch_wb.atp_debug('Compute_Cum_Individual: ' || '**********End Compute_Cum_Individual Procedure************');
4904: END IF;
4905: EXCEPTION
4906: WHEN OTHERS THEN
4907: IF PG_DEBUG in ('Y', 'C') THEN

Line 4908: msc_sch_wb.atp_debug('Compute_Cum_Individual: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);

4904: END IF;
4905: EXCEPTION
4906: WHEN OTHERS THEN
4907: IF PG_DEBUG in ('Y', 'C') THEN
4908: msc_sch_wb.atp_debug('Compute_Cum_Individual: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
4909: END IF;
4910: x_return_status := FND_API.G_RET_STS_ERROR;
4911: Set_Error(MSC_ATP_PVT.ATP_PROCESSING_ERROR);
4912: END Compute_Cum_Individual;

Line 4912: END Compute_Cum_Individual;

4908: msc_sch_wb.atp_debug('Compute_Cum_Individual: ' || 'Error occurred: ' || to_char(sqlcode) || ':' || SQLERRM);
4909: END IF;
4910: x_return_status := FND_API.G_RET_STS_ERROR;
4911: Set_Error(MSC_ATP_PVT.ATP_PROCESSING_ERROR);
4912: END Compute_Cum_Individual;
4913:
4914:
4915:
4916: /*--Adjust_Allocation_Details----------------------------------------------

Line 5020: * Call to Compute_Cum_Individual procedure is not required in Method1

5016: return;
5017: END IF;
5018:
5019: /* rajjain 02/12/2003
5020: * Call to Compute_Cum_Individual procedure is not required in Method1
5021: * as Unallocated Cum will be calculated as part of Compute_Cum procedure*/
5022: IF G_ATP_FW_CONSUME_METHOD = 2 THEN
5023: Compute_Cum_Individual(p_atp_period, l_start_index, l_end_index, l_return_status);
5024: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 5023: Compute_Cum_Individual(p_atp_period, l_start_index, l_end_index, l_return_status);

5019: /* rajjain 02/12/2003
5020: * Call to Compute_Cum_Individual procedure is not required in Method1
5021: * as Unallocated Cum will be calculated as part of Compute_Cum procedure*/
5022: IF G_ATP_FW_CONSUME_METHOD = 2 THEN
5023: Compute_Cum_Individual(p_atp_period, l_start_index, l_end_index, l_return_status);
5024: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5025: IF PG_DEBUG in ('Y', 'C') THEN
5026: msc_sch_wb.atp_debug('Adjust_Allocation_Details: ' || 'Error occured in procedure Compute_Cum_Individual');
5027: END IF;

Line 5026: msc_sch_wb.atp_debug('Adjust_Allocation_Details: ' || 'Error occured in procedure Compute_Cum_Individual');

5022: IF G_ATP_FW_CONSUME_METHOD = 2 THEN
5023: Compute_Cum_Individual(p_atp_period, l_start_index, l_end_index, l_return_status);
5024: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5025: IF PG_DEBUG in ('Y', 'C') THEN
5026: msc_sch_wb.atp_debug('Adjust_Allocation_Details: ' || 'Error occured in procedure Compute_Cum_Individual');
5027: END IF;
5028: x_return_status := FND_API.G_RET_STS_ERROR;
5029: return;
5030: END IF;

Line 5173: Compute_Cum_Individual(p_atp_period, l_start_index, l_end_index, l_return_status);

5169: END LOOP;
5170: END IF;
5171:
5172: IF G_ATP_FW_CONSUME_METHOD = 2 THEN
5173: Compute_Cum_Individual(p_atp_period, l_start_index, l_end_index, l_return_status);
5174: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5175: IF PG_DEBUG in ('Y', 'C') THEN
5176: msc_sch_wb.atp_debug('Adjust_Allocation_Details: ' || 'Error occured in procedure Compute_Cum_Individual');
5177: END IF;

Line 5176: msc_sch_wb.atp_debug('Adjust_Allocation_Details: ' || 'Error occured in procedure Compute_Cum_Individual');

5172: IF G_ATP_FW_CONSUME_METHOD = 2 THEN
5173: Compute_Cum_Individual(p_atp_period, l_start_index, l_end_index, l_return_status);
5174: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5175: IF PG_DEBUG in ('Y', 'C') THEN
5176: msc_sch_wb.atp_debug('Adjust_Allocation_Details: ' || 'Error occured in procedure Compute_Cum_Individual');
5177: END IF;
5178: x_return_status := FND_API.G_RET_STS_ERROR;
5179: return;
5180: END IF;

Line 5592: Compute_Cum_Individual(p_atp_period, l_start_index, l_end_index, l_return_status);

5588: return;
5589: END IF;
5590: END IF;
5591:
5592: Compute_Cum_Individual(p_atp_period, l_start_index, l_end_index, l_return_status);
5593: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5594: IF PG_DEBUG in ('Y', 'C') THEN
5595: msc_sch_wb.atp_debug('Adjust_Allocation_Details: ' || 'Error occured in procedure Compute_Cum_Individual');
5596: END IF;

Line 5595: msc_sch_wb.atp_debug('Adjust_Allocation_Details: ' || 'Error occured in procedure Compute_Cum_Individual');

5591:
5592: Compute_Cum_Individual(p_atp_period, l_start_index, l_end_index, l_return_status);
5593: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5594: IF PG_DEBUG in ('Y', 'C') THEN
5595: msc_sch_wb.atp_debug('Adjust_Allocation_Details: ' || 'Error occured in procedure Compute_Cum_Individual');
5596: END IF;
5597: x_return_status := FND_API.G_RET_STS_ERROR;
5598: return;
5599: END IF;