DBA Data[Home] [Help]

APPS.GMD_QMSMC dependencies on FND_PROFILE

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

1: PACKAGE BODY GMD_QMSMC AS
2: /* $Header: GMDQMSMB.pls 120.22.12010000.2 2008/11/07 18:37:11 rnalla ship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:
6: PROCEDURE VERIFY_EVENT(
7: /* procedure to verify event if the event is sample disposition or sample event disposition */
8: p_itemtype IN VARCHAR2,

Line 542: l_date_format_mask := fnd_profile.value('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS';

538: IF lot%FOUND THEN
539: l_valid_transaction:=true;
540: l_retest_indicator :='Y';
541: --RLNAGARA B4905645
542: l_date_format_mask := fnd_profile.value('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS';
543: l_expiry_date := TO_CHAR(l_expiry_date_tmp,l_date_format_mask);
544:
545: END IF;
546:

Line 575: l_date_format_mask := fnd_profile.value('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS';

571: IF lot%FOUND THEN
572: l_valid_transaction:=true;
573: l_retest_indicator :='Y';
574: --RLNAGARA B4905645
575: l_date_format_mask := fnd_profile.value('ICX_DATE_FORMAT_MASK')||' HH24:MI:SS';
576: l_retest_date := TO_CHAR(l_retest_date_tmp,l_date_format_mask);
577:
578: END IF;
579: CLOSE lot;

Line 2591: fnd_profile.initialize(l_last_update_by );

2587: fnd_global.apps_initialize( USER_ID => l_last_update_by ,
2588: resp_id =>NULL,
2589: resp_appl_id =>NULL);
2590:
2591: fnd_profile.initialize(l_last_update_by );
2592:
2593: -- Bug 4165704: GME added p_org_id to parameter list
2594: gme_api_grp.update_step_quality_status(p_batchstep_id => l_step_id
2595: , p_org_id => l_organization_id