2: /* $Header: MSCAPEGB.pls 120.13 2011/12/06 09:45:39 vjuluri ship $ */
3:
4: MAXVALUE CONSTANT NUMBER := 999999;
5:
6: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('MSC_ATP_DEBUG'), 'N');
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MSC_ATP_PEG';
8:
9: -- Bug 3344102 Allocation related global variables.
10: G_ALLOC_ATP VARCHAR2(1);
4562:
4563: RETCODE := G_SUCCESS;
4564:
4565:
4566: l_share_partition := fnd_profile.value('MSC_SHARE_PARTITIONS');
4567:
4568: msc_util.msc_log('l_share_partition := ' || l_share_partition);
4569:
4570: SELECT NVL(summary_flag,1), compile_designator
4583: RETURN;
4584: END IF;
4585:
4586: -- Bug 3344102 Set Alloc Related Global Variables.
4587: G_ALLOC_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
4588: G_CLASS_HRCHY := NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
4589: G_ALLOC_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'), 2);
4590:
4591: msc_util.msc_log('G_ALLOC_ATP := ' || G_ALLOC_ATP);
4584: END IF;
4585:
4586: -- Bug 3344102 Set Alloc Related Global Variables.
4587: G_ALLOC_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
4588: G_CLASS_HRCHY := NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
4589: G_ALLOC_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'), 2);
4590:
4591: msc_util.msc_log('G_ALLOC_ATP := ' || G_ALLOC_ATP);
4592: msc_util.msc_log('G_CLASS_HRCHY := ' || G_CLASS_HRCHY);
4585:
4586: -- Bug 3344102 Set Alloc Related Global Variables.
4587: G_ALLOC_ATP := NVL(FND_PROFILE.value('MSC_ALLOCATED_ATP'),'N');
4588: G_CLASS_HRCHY := NVL(FND_PROFILE.VALUE('MSC_CLASS_HIERARCHY'), 2);
4589: G_ALLOC_METHOD := NVL(FND_PROFILE.VALUE('MSC_ALLOCATION_METHOD'), 2);
4590:
4591: msc_util.msc_log('G_ALLOC_ATP := ' || G_ALLOC_ATP);
4592: msc_util.msc_log('G_CLASS_HRCHY := ' || G_CLASS_HRCHY);
4593: msc_util.msc_log('G_ALLOC_METHOD := ' || G_ALLOC_METHOD);