DBA Data[Home] [Help]

APPS.MSC_ATP_REQ dependencies on FND_PROFILE

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

1: PACKAGE BODY MSC_ATP_REQ AS
2: /* $Header: MSCRATPB.pls 120.29.12010000.2 2008/08/25 10:43:20 sbnaik ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MSC_ATP_REQ';
4:
5: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
6:
7: -- The resource functions will perform atp_consume and add the infinite time
8: -- fence and populate all the output tables correctly
9: -- The material functions will only execute the sqls. atp_consume and

Line 5736: l_uom_code := NVL(fnd_profile.value('MSC:HOUR_UOM_CODE'),

5732: msc_sch_wb.atp_debug('***** Begin Get_Res_Requirements Procedure *****');
5733: END IF;
5734: -- initialize API return status to success
5735: x_return_status := FND_API.G_RET_STS_SUCCESS;
5736: l_uom_code := NVL(fnd_profile.value('MSC:HOUR_UOM_CODE'),
5737: fnd_profile.value('BOM:HOUR_UOM_CODE'));
5738: l_MSO_Batch_flag := NVL(fnd_profile.value('MSO_BATCHABLE_FLAG'),'N');
5739: IF PG_DEBUG in ('Y', 'C') THEN
5740: msc_sch_wb.atp_debug('Get_Res_Requirements: ' || 'mso batchable flag := ' || l_MSO_Batch_flag );

Line 5737: fnd_profile.value('BOM:HOUR_UOM_CODE'));

5733: END IF;
5734: -- initialize API return status to success
5735: x_return_status := FND_API.G_RET_STS_SUCCESS;
5736: l_uom_code := NVL(fnd_profile.value('MSC:HOUR_UOM_CODE'),
5737: fnd_profile.value('BOM:HOUR_UOM_CODE'));
5738: l_MSO_Batch_flag := NVL(fnd_profile.value('MSO_BATCHABLE_FLAG'),'N');
5739: IF PG_DEBUG in ('Y', 'C') THEN
5740: msc_sch_wb.atp_debug('Get_Res_Requirements: ' || 'mso batchable flag := ' || l_MSO_Batch_flag );
5741: END IF;

Line 5738: l_MSO_Batch_flag := NVL(fnd_profile.value('MSO_BATCHABLE_FLAG'),'N');

5734: -- initialize API return status to success
5735: x_return_status := FND_API.G_RET_STS_SUCCESS;
5736: l_uom_code := NVL(fnd_profile.value('MSC:HOUR_UOM_CODE'),
5737: fnd_profile.value('BOM:HOUR_UOM_CODE'));
5738: l_MSO_Batch_flag := NVL(fnd_profile.value('MSO_BATCHABLE_FLAG'),'N');
5739: IF PG_DEBUG in ('Y', 'C') THEN
5740: msc_sch_wb.atp_debug('Get_Res_Requirements: ' || 'mso batchable flag := ' || l_MSO_Batch_flag );
5741: END IF;
5742:

Line 7845: l_msc_cap_allocation := NVL(FND_PROFILE.VALUE('MSC_CAP_ALLOCATION'), 'Y');

7841: END IF;
7842:
7843: -- we need to have a branch here for allocated atp
7844: -- Bug 2372577 . Check value of profile option : krajan
7845: l_msc_cap_allocation := NVL(FND_PROFILE.VALUE('MSC_CAP_ALLOCATION'), 'Y');
7846:
7847: IF (MSC_ATP_PVT.G_ALLOCATED_ATP = 'N') OR
7848: (MSC_ATP_PVT.G_ALLOCATED_ATP = 'Y' AND MSC_ATP_PVT.G_HIERARCHY_PROFILE = 1 AND
7849: MSC_ATP_PVT.G_ALLOCATION_METHOD = 1) OR

Line 11211: MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE := NVL(FND_PROFILE.VALUE('MSC_PO_DOCK_DATE_CALC_PREF'), 2);

11207:
11208: l_requested_date := trunc(p_sup_atp_info_rec.requested_date);
11209:
11210: ---profile option for including purchase order
11211: MSC_ATP_REQ.G_PURCHASE_ORDER_PREFERENCE := NVL(FND_PROFILE.VALUE('MSC_PO_DOCK_DATE_CALC_PREF'), 2);
11212:
11213: -- Instead re-assigned local values using global variable
11214: l_uom_code := MSC_ATP_PVT.G_ITEM_INFO_REC.uom_code;
11215: l_postprocessing_lead_time := MSC_ATP_PVT.G_ITEM_INFO_REC.pre_pro_lt;