APPS.MSC_ATP_REFRESH_MVIEW dependencies on FND_PROFILE

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

1: PACKAGE BODY MSC_ATP_REFRESH_MVIEW AS
2: /* $Header: MSCATMVB.pls 120.2 2007/12/12 10:20:47 sbnaik ship $ */
3:
4: -- rajjain 12/20/2002
5: PG_DEBUG VARCHAR2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
6:
7: PROCEDURE REFRESH_MVIEW(
8: ERRBUF OUT NoCopy VARCHAR2,
9: RETCODE OUT NoCopy NUMBER)

Line 67: l_msc_cap_allocation := NVL(FND_PROFILE.VALUE('MSC_CAP_ALLOCATION'), 'Y');

63: AND b.application_id = 724;
64:
65:
66: -- bug 2383867 : krajan
67: l_msc_cap_allocation := NVL(FND_PROFILE.VALUE('MSC_CAP_ALLOCATION'), 'Y');
68: msc_util.msc_log('Profile Option value' || l_msc_cap_allocation);
69:
70: msc_util.msc_log('Before getting partitions name');
71: IF (l_msc_cap_allocation = 'Y') THEN