DBA Data[Home] [Help]

APPS.MSC_UTIL dependencies on FND_PROFILE

Line 6: G_MSC_DEBUG VARCHAR2(1) := nvl(FND_PROFILE.Value('MRP_DEBUG'),'N');

2: /* $Header: MSCUTILS.pls 120.43 2012/06/05 12:20:48 lsindhur ship $ */
3:
4: TYPE TblNmTblTyp IS TABLE OF VARCHAR2(30);
5:
6: G_MSC_DEBUG VARCHAR2(1) := nvl(FND_PROFILE.Value('MRP_DEBUG'),'N');
7:
8: /* Added for bug 12640878 */
9:
10: G_ITEMCAT_LEN NUMBER(3) := 250 ;

Line 12: -- G_CMRO_EAM_INT_ENABLED VARCHAR2(1) := nvl(FND_PROFILE.Value('MSC_ASCP_IGNORE_CMRO_EAM_WO'),'N'); /* USAF */

8: /* Added for bug 12640878 */
9:
10: G_ITEMCAT_LEN NUMBER(3) := 250 ;
11:
12: -- G_CMRO_EAM_INT_ENABLED VARCHAR2(1) := nvl(FND_PROFILE.Value('MSC_ASCP_IGNORE_CMRO_EAM_WO'),'N'); /* USAF */
13: /* The below profile G_CMRO_EAM_INT_ENABLED is specific for USAF 12.2 code.
14: G_CMRO_EAM_INT_ENABLED = 'Y', implies USAF code will take effect.
15: G_CMRO_EAM_INT_ENABLED = 'N', implies USAF code will be turned OFF.
16: We are reversing the value given in the profile as the profile name changed

Line 22: WHEN nvl(FND_PROFILE.Value('MSC_ASCP_IGNORE_CMRO_EAM_WO'),1) = 1 THEN 'N'

18: Hence changing the value internally
19: */
20:
21: G_CMRO_EAM_INT_ENABLED VARCHAR2(1) := CASE
22: WHEN nvl(FND_PROFILE.Value('MSC_ASCP_IGNORE_CMRO_EAM_WO'),1) = 1 THEN 'N'
23: ELSE 'Y'
24: END ;
25:
26: G_EAM_CMRO_SUP_VER CONSTANT NUMBER := 6; -- USAF Currently supports 12.2 and above

Line 132: G_COLLECT_SRP_DATA VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MSC_SRP_ENABLED'),'N');

128: v_msc_tp_coll_window NUMBER;
129:
130:
131: -- To collect SRP Data when this profile is set to Yes
132: G_COLLECT_SRP_DATA VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MSC_SRP_ENABLED'),'N');
133:
134: -- To collect CMRO Data when this profile is set to Yes
135: G_COLLECT_CMRO_DATA VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MSC_CMRO_WO_DEMAND_PS'),'N');
136:

Line 135: G_COLLECT_CMRO_DATA VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MSC_CMRO_WO_DEMAND_PS'),'N');

131: -- To collect SRP Data when this profile is set to Yes
132: G_COLLECT_SRP_DATA VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MSC_SRP_ENABLED'),'N');
133:
134: -- To collect CMRO Data when this profile is set to Yes
135: G_COLLECT_CMRO_DATA VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MSC_CMRO_WO_DEMAND_PS'),'N');
136:
137: /* IBUC - COLLECTION CHANGES
138: To collect Install Base under Contracts when for the number of months , set in this profile */
139:

Line 140: G_COLLECT_IBUC_DATA NUMBER := NVL(FND_PROFILE.VALUE('MSC_COLL_TIME_WINDOW_IBUC_HISTORY'),12);

136:
137: /* IBUC - COLLECTION CHANGES
138: To collect Install Base under Contracts when for the number of months , set in this profile */
139:
140: G_COLLECT_IBUC_DATA NUMBER := NVL(FND_PROFILE.VALUE('MSC_COLL_TIME_WINDOW_IBUC_HISTORY'),12);
141: G_COLLECT_SRP_PH2_ENABLE VARCHAR2(1):= NVL(FND_PROFILE.VALUE('MSC_SRP_PH2_ENABLED'),'N');
142:
143: -- SCE Additions --
144: /* SCE Change Starts */

Line 141: G_COLLECT_SRP_PH2_ENABLE VARCHAR2(1):= NVL(FND_PROFILE.VALUE('MSC_SRP_PH2_ENABLED'),'N');

137: /* IBUC - COLLECTION CHANGES
138: To collect Install Base under Contracts when for the number of months , set in this profile */
139:
140: G_COLLECT_IBUC_DATA NUMBER := NVL(FND_PROFILE.VALUE('MSC_COLL_TIME_WINDOW_IBUC_HISTORY'),12);
141: G_COLLECT_SRP_PH2_ENABLE VARCHAR2(1):= NVL(FND_PROFILE.VALUE('MSC_SRP_PH2_ENABLED'),'N');
142:
143: -- SCE Additions --
144: /* SCE Change Starts */
145: G_MSC_CONFIGURATION VARCHAR2(10) := nvl(fnd_profile.value('MSC_X_CONFIGURATION'), G_CONF_APS);

Line 145: G_MSC_CONFIGURATION VARCHAR2(10) := nvl(fnd_profile.value('MSC_X_CONFIGURATION'), G_CONF_APS);

141: G_COLLECT_SRP_PH2_ENABLE VARCHAR2(1):= NVL(FND_PROFILE.VALUE('MSC_SRP_PH2_ENABLED'),'N');
142:
143: -- SCE Additions --
144: /* SCE Change Starts */
145: G_MSC_CONFIGURATION VARCHAR2(10) := nvl(fnd_profile.value('MSC_X_CONFIGURATION'), G_CONF_APS);
146: /* SCE Change Ends */
147: -- Schemas
148: G_AHL_SCHEMA VARCHAR2(30);
149: G_INV_SCHEMA VARCHAR2(30);

Line 282: G_CL_DEBUG NUMBER := NVL(FND_PROFILE.Value('MSC_COLL_ERR_DEBUG' ), G_LVL_STATUS + G_LVL_WARNING ) --MSC:Coll Err Debug

278: G_D_PERFDBG_1 CONSTANT NUMBER := 128 ;
279: G_D_PERFDBG_2 CONSTANT NUMBER := 256 ;
280:
281: -- variable for MSC:Coll Err Debug and MSC:Coll Perf Debug profile options
282: G_CL_DEBUG NUMBER := NVL(FND_PROFILE.Value('MSC_COLL_ERR_DEBUG' ), G_LVL_STATUS + G_LVL_WARNING ) --MSC:Coll Err Debug
283: + NVL(FND_PROFILE.Value('MSC_COLL_PERF_DEBUG'), 0) --MSC:Coll Perf Debug profile
284: + G_LVL_FATAL_ERR ; --Manadtory level
285:
286: -- NGOEL 11/29/2001, type defined for use in compare_index procedure for passing list of

Line 283: + NVL(FND_PROFILE.Value('MSC_COLL_PERF_DEBUG'), 0) --MSC:Coll Perf Debug profile

279: G_D_PERFDBG_2 CONSTANT NUMBER := 256 ;
280:
281: -- variable for MSC:Coll Err Debug and MSC:Coll Perf Debug profile options
282: G_CL_DEBUG NUMBER := NVL(FND_PROFILE.Value('MSC_COLL_ERR_DEBUG' ), G_LVL_STATUS + G_LVL_WARNING ) --MSC:Coll Err Debug
283: + NVL(FND_PROFILE.Value('MSC_COLL_PERF_DEBUG'), 0) --MSC:Coll Perf Debug profile
284: + G_LVL_FATAL_ERR ; --Manadtory level
285:
286: -- NGOEL 11/29/2001, type defined for use in compare_index procedure for passing list of
287: -- columns in the specified index in the order of creation.