1: PACKAGE MRP_CL_REFRESH_SNAPSHOT AUTHID CURRENT_USER AS
2: /* $Header: MRPCLEAS.pls 120.10.12020000.2 2012/11/01 08:18:10 zzhen ship $ */
3:
4: TYPE SnapTblTyp IS TABLE OF VARCHAR2(30);
5: G_MSC_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.Value('MRP_DEBUG'),'N');
6: v_explode_ato VARCHAR2(1) := NVL(FND_PROFILE.Value('MRP_EXPLODE_ATO'),'Y');
7: ----- CONSTANTS --------------------------------------------------------
8:
9: SYS_YES CONSTANT NUMBER := 1;
2: /* $Header: MRPCLEAS.pls 120.10.12020000.2 2012/11/01 08:18:10 zzhen ship $ */
3:
4: TYPE SnapTblTyp IS TABLE OF VARCHAR2(30);
5: G_MSC_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.Value('MRP_DEBUG'),'N');
6: v_explode_ato VARCHAR2(1) := NVL(FND_PROFILE.Value('MRP_EXPLODE_ATO'),'Y');
7: ----- CONSTANTS --------------------------------------------------------
8:
9: SYS_YES CONSTANT NUMBER := 1;
10: SYS_NO CONSTANT NUMBER := 2;