eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_SAMPLES_GRP dependencies on FND_PROFILE

Line 6: --Bug 3222090, magupta removed call to FND_PROFILE.VALUE('AFLOG_ENABLED')

2: --$Header: GMDGSMPB.pls 120.29.12000000.3 2007/02/07 12:01:32 rlnagara ship $
3: -- Global variables
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_SAMPLES_GRP';
5:
6: --Bug 3222090, magupta removed call to FND_PROFILE.VALUE('AFLOG_ENABLED')
7: --forward decl.
8: FUNCTION set_debug_flag RETURN VARCHAR2;
9: --l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
10: l_debug VARCHAR2(1) := set_debug_flag;

Line 9: --l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

5:
6: --Bug 3222090, magupta removed call to FND_PROFILE.VALUE('AFLOG_ENABLED')
7: --forward decl.
8: FUNCTION set_debug_flag RETURN VARCHAR2;
9: --l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
10: l_debug VARCHAR2(1) := set_debug_flag;
11:
12: FUNCTION set_debug_flag RETURN VARCHAR2 IS
13: l_debug VARCHAR2(1):= 'N';

Line 3049: AND ( ( bh.batch_status IN (1,2) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'N') ) -- Bug # 4619570 Pending or WIP Batches Only

3045: SELECT 1
3046: FROM gme_batch_header bh
3047: WHERE bh.batch_id = p_sample.batch_id
3048: AND bh.batch_type = 0 -- Only Batches, No FPOs
3049: AND ( ( bh.batch_status IN (1,2) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'N') ) -- Bug # 4619570 Pending or WIP Batches Only
3050: OR ( bh.batch_status IN (1,2, 4 ) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'Y') ) ) -- Pending or WIP Or Closed Batches Only
3051: AND exists -- Only Batches with Spec Item in it
3052: (SELECT 1
3053: FROM gme_material_details md

Line 3050: OR ( bh.batch_status IN (1,2, 4 ) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'Y') ) ) -- Pending or WIP Or Closed Batches Only

3046: FROM gme_batch_header bh
3047: WHERE bh.batch_id = p_sample.batch_id
3048: AND bh.batch_type = 0 -- Only Batches, No FPOs
3049: AND ( ( bh.batch_status IN (1,2) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'N') ) -- Bug # 4619570 Pending or WIP Batches Only
3050: OR ( bh.batch_status IN (1,2, 4 ) and ( NVL(fnd_profile.value('GMD_SAMPLE_CLOSED_BATCHES'),'N') = 'Y') ) ) -- Pending or WIP Or Closed Batches Only
3051: AND exists -- Only Batches with Spec Item in it
3052: (SELECT 1
3053: FROM gme_material_details md
3054: WHERE md.batch_id = bh.batch_id