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.6 2011/11/08 12:19:38 vjuluri 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 74: l_msc_cap_allocation := NVL(FND_PROFILE.VALUE('MSC_CAP_ALLOCATION'), 'Y');

70: where read_only_flag = 'U';
71:
72:
73: -- bug 2383867 : krajan
74: l_msc_cap_allocation := NVL(FND_PROFILE.VALUE('MSC_CAP_ALLOCATION'), 'Y');
75: msc_util.msc_log('Profile Option value' || l_msc_cap_allocation);
76:
77: msc_util.msc_log('Before getting partitions name');
78: IF (l_msc_cap_allocation = 'Y') THEN