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_DB_UTILS dependencies on FND_PROFILE

Line 10: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');

6: -- dsting: 0 if Clear_SD_Details_temp has been called, 0 otherwise.
7: -- used to save 1 delete in sd performance enh
8: PG_CLEAR_SD_DETAILS_TEMP NUMBER := 0;
9:
10: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
11: G_ORIG_INV_CTP NUMBER := FND_PROFILE.value('INV_CTP'); -- Bug 3295831.
12: -- Added to control summary operations.
13:
14: --5357370 private declaration

Line 11: G_ORIG_INV_CTP NUMBER := FND_PROFILE.value('INV_CTP'); -- Bug 3295831.

7: -- used to save 1 delete in sd performance enh
8: PG_CLEAR_SD_DETAILS_TEMP NUMBER := 0;
9:
10: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
11: G_ORIG_INV_CTP NUMBER := FND_PROFILE.value('INV_CTP'); -- Bug 3295831.
12: -- Added to control summary operations.
13:
14: --5357370 private declaration
15: PROCEDURE UNDO_DELETE_SUMMARY_ROW (p_identifier IN NUMBER,

Line 2296: MSC_ATP_PVT.G_ALLOCATION_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'),2);

2292: END IF;
2293: ELSE
2294: -- ATP4drp set using the original value
2295: MSC_ATP_PVT.G_ALLOCATED_ATP := MSC_ATP_PVT.G_ORIG_ALLOC_ATP;
2296: MSC_ATP_PVT.G_ALLOCATION_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'),2);
2297: END IF;
2298: -- End ATP4drp
2299: MSC_ATP_PVT.G_INV_CTP := FND_PROFILE.value('INV_CTP') ;
2300:

Line 2299: MSC_ATP_PVT.G_INV_CTP := FND_PROFILE.value('INV_CTP') ;

2295: MSC_ATP_PVT.G_ALLOCATED_ATP := MSC_ATP_PVT.G_ORIG_ALLOC_ATP;
2296: MSC_ATP_PVT.G_ALLOCATION_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'),2);
2297: END IF;
2298: -- End ATP4drp
2299: MSC_ATP_PVT.G_INV_CTP := FND_PROFILE.value('INV_CTP') ;
2300:
2301: IF PG_DEBUG in ('Y', 'C') THEN
2302: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'G_ALLOCATION_METHOD= ' || MSC_ATP_PVT.G_ALLOCATION_METHOD);
2303: msc_sch_wb.atp_debug('Remove_Invalid_SD_Rec: ' || 'G_ALLOCATED_ATP= ' || MSC_ATP_PVT.G_ALLOCATED_ATP);

Line 5967: MSC_ATP_PVT.G_ALLOCATION_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'),2);

5963:
5964: -- for ods, just need to remove the record from msc_sales_orders
5965: -- initialize API return status to success
5966: x_return_status := FND_API.G_RET_STS_SUCCESS;
5967: MSC_ATP_PVT.G_ALLOCATION_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'),2);
5968: MSC_ATP_PVT.G_ALLOCATED_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
5969: MSC_ATP_PVT.G_INV_CTP := FND_PROFILE.value('INV_CTP') ;
5970:
5971: OPEN pegging;

Line 5968: MSC_ATP_PVT.G_ALLOCATED_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');

5964: -- for ods, just need to remove the record from msc_sales_orders
5965: -- initialize API return status to success
5966: x_return_status := FND_API.G_RET_STS_SUCCESS;
5967: MSC_ATP_PVT.G_ALLOCATION_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'),2);
5968: MSC_ATP_PVT.G_ALLOCATED_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
5969: MSC_ATP_PVT.G_INV_CTP := FND_PROFILE.value('INV_CTP') ;
5970:
5971: OPEN pegging;
5972: LOOP

Line 5969: MSC_ATP_PVT.G_INV_CTP := FND_PROFILE.value('INV_CTP') ;

5965: -- initialize API return status to success
5966: x_return_status := FND_API.G_RET_STS_SUCCESS;
5967: MSC_ATP_PVT.G_ALLOCATION_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'),2);
5968: MSC_ATP_PVT.G_ALLOCATED_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
5969: MSC_ATP_PVT.G_INV_CTP := FND_PROFILE.value('INV_CTP') ;
5970:
5971: OPEN pegging;
5972: LOOP
5973:

Line 6144: MSC_ATP_PVT.G_ALLOCATION_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'),2);

6140: msc_sch_wb.atp_debug('***** Begin Delete_SD_Rec Procedure *****');
6141: END IF;
6142:
6143: x_return_status := FND_API.G_RET_STS_SUCCESS;
6144: MSC_ATP_PVT.G_ALLOCATION_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'),2);
6145: MSC_ATP_PVT.G_ALLOCATED_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
6146: MSC_ATP_PVT.G_INV_CTP := FND_PROFILE.value('INV_CTP') ;
6147:
6148: FOR i IN p_pegging_tab.FIRST..p_pegging_tab.COUNT LOOP

Line 6145: MSC_ATP_PVT.G_ALLOCATED_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');

6141: END IF;
6142:
6143: x_return_status := FND_API.G_RET_STS_SUCCESS;
6144: MSC_ATP_PVT.G_ALLOCATION_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'),2);
6145: MSC_ATP_PVT.G_ALLOCATED_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
6146: MSC_ATP_PVT.G_INV_CTP := FND_PROFILE.value('INV_CTP') ;
6147:
6148: FOR i IN p_pegging_tab.FIRST..p_pegging_tab.COUNT LOOP
6149: IF PG_DEBUG in ('Y', 'C') THEN

Line 6146: MSC_ATP_PVT.G_INV_CTP := FND_PROFILE.value('INV_CTP') ;

6142:
6143: x_return_status := FND_API.G_RET_STS_SUCCESS;
6144: MSC_ATP_PVT.G_ALLOCATION_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'),2);
6145: MSC_ATP_PVT.G_ALLOCATED_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
6146: MSC_ATP_PVT.G_INV_CTP := FND_PROFILE.value('INV_CTP') ;
6147:
6148: FOR i IN p_pegging_tab.FIRST..p_pegging_tab.COUNT LOOP
6149: IF PG_DEBUG in ('Y', 'C') THEN
6150: msc_sch_wb.atp_debug('Delete_SD_Rec: ' || 'p_pegging_tab(i) = ' || p_pegging_tab(i));

Line 6312: MSC_ATP_PVT.G_ALLOCATION_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'),2);

6308:
6309: -- for ods, just need to remove the record from msc_sales_orders
6310: -- initialize API return status to success
6311: x_return_status := FND_API.G_RET_STS_SUCCESS;
6312: MSC_ATP_PVT.G_ALLOCATION_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'),2);
6313: MSC_ATP_PVT.G_ALLOCATED_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
6314: MSC_ATP_PVT.G_INV_CTP := FND_PROFILE.value('INV_CTP') ;
6315:
6316: FOR i IN p_pegging_tab.FIRST..p_pegging_tab.COUNT LOOP

Line 6313: MSC_ATP_PVT.G_ALLOCATED_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');

6309: -- for ods, just need to remove the record from msc_sales_orders
6310: -- initialize API return status to success
6311: x_return_status := FND_API.G_RET_STS_SUCCESS;
6312: MSC_ATP_PVT.G_ALLOCATION_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'),2);
6313: MSC_ATP_PVT.G_ALLOCATED_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
6314: MSC_ATP_PVT.G_INV_CTP := FND_PROFILE.value('INV_CTP') ;
6315:
6316: FOR i IN p_pegging_tab.FIRST..p_pegging_tab.COUNT LOOP
6317: IF PG_DEBUG in ('Y', 'C') THEN

Line 6314: MSC_ATP_PVT.G_INV_CTP := FND_PROFILE.value('INV_CTP') ;

6310: -- initialize API return status to success
6311: x_return_status := FND_API.G_RET_STS_SUCCESS;
6312: MSC_ATP_PVT.G_ALLOCATION_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'),2);
6313: MSC_ATP_PVT.G_ALLOCATED_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
6314: MSC_ATP_PVT.G_INV_CTP := FND_PROFILE.value('INV_CTP') ;
6315:
6316: FOR i IN p_pegging_tab.FIRST..p_pegging_tab.COUNT LOOP
6317: IF PG_DEBUG in ('Y', 'C') THEN
6318: msc_sch_wb.atp_debug('Delete_SD_Rec: ' || 'p_pegging_tab(i) = ' || p_pegging_tab(i));