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 5792: MSO_Batch_flag := NVL(fnd_profile.value('MSO_BATCHABLE_FLAG'),'N');

5788: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'p_organization_id =' || p_organization_id);
5789: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'p_demand_class =' || p_demand_class);
5790: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'p_request_date =' || p_request_date );
5791: END IF;
5792: MSO_Batch_flag := NVL(fnd_profile.value('MSO_BATCHABLE_FLAG'),'N');
5793: IF PG_DEBUG in ('Y', 'C') THEN
5794: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'MSO_Batch_flag := ' || MSO_Batch_flag);
5795: END IF;
5796: Begin

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

6031:
6032: mm := l_demand_class_tab.Next(mm);
6033: END LOOP;
6034:
6035: l_uom_code := NVL(fnd_profile.value('MSC:HOUR_UOM_CODE'),
6036: fnd_profile.value('BOM:HOUR_UOM_CODE'));
6037:
6038: -- for performance reason, we need to get the following info and
6039: -- store in variables instead of joining it

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

6032: mm := l_demand_class_tab.Next(mm);
6033: END LOOP;
6034:
6035: l_uom_code := NVL(fnd_profile.value('MSC:HOUR_UOM_CODE'),
6036: fnd_profile.value('BOM:HOUR_UOM_CODE'));
6037:
6038: -- for performance reason, we need to get the following info and
6039: -- store in variables instead of joining it
6040:

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

9436: --4365873
9437: cs.INVENTORY_ITEM_ID = MIHM.INVENTORY_ITEM_ID(+)
9438: AND cs.SR_INSTANCE_ID = MIHM.SR_INSTANCE_ID (+)
9439: AND cs.ORGANIZATION_ID = MIHM.ORGANIZATION_ID (+)
9440: --AND decode(MIHM.level_id,-1,1,2) (+) = (select decode(fnd_profile.value('XXXX'),1,1,2) from dual)
9441: --AND MIHM.level_id(+)=-1
9442: AND decode(MIHM.level_id (+),-1,1,2) = decode(G_HIERARCHY_PROFILE,1,1,2)
9443: AND cs.calendar_date >= MIHM.effective_date (+)
9444: AND cs.calendar_date <= MIHM.disable_date (+)

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

9719: --4365873
9720: cs.INVENTORY_ITEM_ID = MIHM.INVENTORY_ITEM_ID(+)
9721: AND cs.SR_INSTANCE_ID = MIHM.SR_INSTANCE_ID (+)
9722: AND cs.ORGANIZATION_ID = MIHM.ORGANIZATION_ID (+)
9723: --AND decode(MIHM.level_id,-1,1,2) (+) = (select decode(fnd_profile.value('XXXX'),1,1,2) from dual)
9724: --AND MIHM.level_id(+)=-1
9725: AND decode(MIHM.level_id (+),-1,1,2) = decode(G_HIERARCHY_PROFILE,1,1,2)
9726: AND cs.calendar_date >= MIHM.effective_date (+)
9727: AND cs.calendar_date <= MIHM.disable_date (+)