1: PACKAGE BODY MSC_CALENDAR AS
2: /* $Header: MSCCALDB.pls 120.4 2008/01/04 11:04:31 sbnaik ship $ */
3:
4: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
5:
6: -- Global Static variables
7: MSC_CALENDAR_RET_DATES NUMBER := 0;
8: msc_calendar_cal_code VARCHAR2(14) := '17438gdjh';
69: END IF;
70:
71: IF MSC_CALENDAR_RET_DATES = 0 THEN
72:
73: temp_Char := FND_PROFILE.VALUE('MRP_RETAIN_DATES_WTIN_CAL_BOUNDARY');
74: IF temp_Char = 'Y' THEN
75: MSC_CALENDAR_RET_DATES := 1;
76: ELSE
77: MSC_CALENDAR_RET_DATES := 2;
681: END IF;
682:
683: IF MSC_CALENDAR_RET_DATES = 0 THEN
684:
685: temp_Char := FND_PROFILE.VALUE('MRP_RETAIN_DATES_WTIN_CAL_BOUNDARY');
686: IF temp_Char = 'Y' THEN
687: MSC_CALENDAR_RET_DATES := 1;
688: ELSE
689: MSC_CALENDAR_RET_DATES := 2;