1: PACKAGE MSC_UTIL AS
2: /* $Header: MSCUTILS.pls 120.24.12010000.3 2008/09/13 16:26:25 dejoshi ship $ */
3:
4:
5: G_MSC_DEBUG VARCHAR2(1) := nvl(FND_PROFILE.Value('MRP_DEBUG'),'N');
6:
7: ----- TESTING FLAG --------------------
8: STATSQL CONSTANT BOOLEAN := FALSE; -- static SQL
9:
107: v_msc_tp_coll_window NUMBER;
108:
109:
110: -- To collect SRP Data when this profile is set to Yes
111: G_COLLECT_SRP_DATA VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MSC_SRP_ENABLED'),'N');
112:
113: -- SCE Additions --
114: /* SCE Change Starts */
115: G_MSC_CONFIGURATION VARCHAR2(10) := nvl(fnd_profile.value('MSC_X_CONFIGURATION'), G_CONF_APS);
111: G_COLLECT_SRP_DATA VARCHAR2(1) := NVL(FND_PROFILE.VALUE('MSC_SRP_ENABLED'),'N');
112:
113: -- SCE Additions --
114: /* SCE Change Starts */
115: G_MSC_CONFIGURATION VARCHAR2(10) := nvl(fnd_profile.value('MSC_X_CONFIGURATION'), G_CONF_APS);
116: /* SCE Change Ends */
117: -- Schemas
118: G_AHL_SCHEMA VARCHAR2(30);
119: G_INV_SCHEMA VARCHAR2(30);
234: G_D_PERFDBG_1 CONSTANT NUMBER := 128 ;
235: G_D_PERFDBG_2 CONSTANT NUMBER := 256 ;
236:
237: -- variable for MSC:Coll Err Debug and MSC:Coll Perf Debug profile options
238: G_CL_DEBUG NUMBER := NVL(FND_PROFILE.Value('MSC_COLL_ERR_DEBUG' ), G_LVL_STATUS + G_LVL_WARNING ) --MSC:Coll Err Debug
239: + NVL(FND_PROFILE.Value('MSC_COLL_PERF_DEBUG'), 0) --MSC:Coll Perf Debug profile
240: + G_LVL_FATAL_ERR ; --Manadtory level
241:
242: -- NGOEL 11/29/2001, type defined for use in compare_index procedure for passing list of
235: G_D_PERFDBG_2 CONSTANT NUMBER := 256 ;
236:
237: -- variable for MSC:Coll Err Debug and MSC:Coll Perf Debug profile options
238: G_CL_DEBUG NUMBER := NVL(FND_PROFILE.Value('MSC_COLL_ERR_DEBUG' ), G_LVL_STATUS + G_LVL_WARNING ) --MSC:Coll Err Debug
239: + NVL(FND_PROFILE.Value('MSC_COLL_PERF_DEBUG'), 0) --MSC:Coll Perf Debug profile
240: + G_LVL_FATAL_ERR ; --Manadtory level
241:
242: -- NGOEL 11/29/2001, type defined for use in compare_index procedure for passing list of
243: -- columns in the specified index in the order of creation.