DBA Data[Home] [Help]

APPS.MSC_AATP_FUNC dependencies on FND_PROFILE

Line 18: G_HIERARCHY_PROFILE NUMBER := NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);

14: DEMND_MPS_COMPILE CONSTANT INTEGER := 12;
15: FORECAST CONSTANT INTEGER := 29;
16: DEMAND_SALES_ORDER CONSTANT INTEGER := 30;
17:
18: G_HIERARCHY_PROFILE NUMBER := NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
19:
20:
21: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
22:

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

17:
18: G_HIERARCHY_PROFILE NUMBER := NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
19:
20:
21: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
22:
23: FUNCTION Get_Item_Demand_Alloc_Percent(
24: p_plan_id IN NUMBER,
25: p_demand_id IN NUMBER,

Line 696: G_HIERARCHY_PROFILE := NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);

692: -- G_Hierarchy_Profile is 1 .
693: --
694: -- CASE 2: to find the hierarchy demand class at a particular level
695: -- p_level_id is not null
696: G_HIERARCHY_PROFILE := NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
697:
698: IF (G_HIERARCHY_PROFILE = 1) THEN
699: -- we are doing the demand class
700: -- this would happen only in case 1

Line 1392: G_HIERARCHY_PROFILE := NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);

1388: -- G_Hierarchy_Profile is 1 .
1389: --
1390: -- CASE 2: to find the hierarchy demand class at a particular level
1391: -- p_level_id is not null
1392: G_HIERARCHY_PROFILE := NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
1393:
1394: IF (G_HIERARCHY_PROFILE = 1) THEN
1395: -- we are doing the demand class
1396: -- this would happen only in case 1