APPS.MSC_AATP_PVT dependencies on FND_PROFILE

Line 22: G_ATP_FW_CONSUME_METHOD NUMBER := NVL(FND_PROFILE.VALUE('MSC_ATP_FORWARD_CONSUME_METHOD'), 1);

18: FORECAST CONSTANT INTEGER := 29;
19: DEMAND_SALES_ORDER CONSTANT INTEGER := 30;
20:
21: -- AATP Forward Consumption rajjain
22: G_ATP_FW_CONSUME_METHOD NUMBER := NVL(FND_PROFILE.VALUE('MSC_ATP_FORWARD_CONSUME_METHOD'), 1);
23: ----------------------------------------------------------------------
24:
25: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
26:

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

21: -- AATP Forward Consumption rajjain
22: G_ATP_FW_CONSUME_METHOD NUMBER := NVL(FND_PROFILE.VALUE('MSC_ATP_FORWARD_CONSUME_METHOD'), 1);
23: ----------------------------------------------------------------------
24:
25: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
26:
27: PROCEDURE Print_Period_Qty(
28: p_msg IN varchar2,
29: p_atp_info IN MRP_ATP_PVT.ATP_Info

Line 5562: MSO_Batch_flag := NVL(fnd_profile.value('MSO_BATCHABLE_FLAG'),'N');

5558: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'p_organization_id =' || p_organization_id);
5559: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'p_demand_class =' || p_demand_class);
5560: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'p_request_date =' || p_request_date );
5561: END IF;
5562: MSO_Batch_flag := NVL(fnd_profile.value('MSO_BATCHABLE_FLAG'),'N');
5563: IF PG_DEBUG in ('Y', 'C') THEN
5564: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'MSO_Batch_flag := ' || MSO_Batch_flag);
5565: END IF;
5566: Begin

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

5801:
5802: mm := l_demand_class_tab.Next(mm);
5803: END LOOP;
5804:
5805: l_uom_code := NVL(fnd_profile.value('MSC:HOUR_UOM_CODE'),
5806: fnd_profile.value('BOM:HOUR_UOM_CODE'));
5807:
5808: -- for performance reason, we need to get the following info and
5809: -- store in variables instead of joining it

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

5802: mm := l_demand_class_tab.Next(mm);
5803: END LOOP;
5804:
5805: l_uom_code := NVL(fnd_profile.value('MSC:HOUR_UOM_CODE'),
5806: fnd_profile.value('BOM:HOUR_UOM_CODE'));
5807:
5808: -- for performance reason, we need to get the following info and
5809: -- store in variables instead of joining it
5810:

Line 9209: --AND decode(MIHM.level_id,-1,1,2) (+) = (select decode(fnd_profile.value('XXXX'),1,1,2) from dual)

9205: --4365873
9206: cs.INVENTORY_ITEM_ID = MIHM.INVENTORY_ITEM_ID(+)
9207: AND cs.SR_INSTANCE_ID = MIHM.SR_INSTANCE_ID (+)
9208: AND cs.ORGANIZATION_ID = MIHM.ORGANIZATION_ID (+)
9209: --AND decode(MIHM.level_id,-1,1,2) (+) = (select decode(fnd_profile.value('XXXX'),1,1,2) from dual)
9210: --AND MIHM.level_id(+)=-1
9211: AND decode(MIHM.level_id (+),-1,1,2) = decode(G_HIERARCHY_PROFILE,1,1,2)
9212: AND cs.calendar_date >= MIHM.effective_date (+)
9213: AND cs.calendar_date <= MIHM.disable_date (+)

Line 9492: --AND decode(MIHM.level_id,-1,1,2) (+) = (select decode(fnd_profile.value('XXXX'),1,1,2) from dual)

9488: --4365873
9489: cs.INVENTORY_ITEM_ID = MIHM.INVENTORY_ITEM_ID(+)
9490: AND cs.SR_INSTANCE_ID = MIHM.SR_INSTANCE_ID (+)
9491: AND cs.ORGANIZATION_ID = MIHM.ORGANIZATION_ID (+)
9492: --AND decode(MIHM.level_id,-1,1,2) (+) = (select decode(fnd_profile.value('XXXX'),1,1,2) from dual)
9493: --AND MIHM.level_id(+)=-1
9494: AND decode(MIHM.level_id (+),-1,1,2) = decode(G_HIERARCHY_PROFILE,1,1,2)
9495: AND cs.calendar_date >= MIHM.effective_date (+)
9496: AND cs.calendar_date <= MIHM.disable_date (+)