DBA Data[Home] [Help]

APPS.GMDQSVRS_APPROVAL_WF_PKG dependencies on FND_PROFILE

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

1: PACKAGE BODY GMDQSVRS_APPROVAL_WF_PKG AS
2: /* $Header: GMDQSVRB.pls 120.3 2006/05/15 04:50:03 rkrishan noship $ */
3:
4:
5: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
6:
7:
8: APPLICATION_ERROR EXCEPTION;
9: -- Following function accepts FND userId and returns

Line 49: l_wf_timeout NUMBER := TO_NUMBER(FND_PROFILE.VALUE ('GMD_WF_TIMEOUT'));

45: l_Owner FND_USER.USER_NAME%TYPE;
46: lSpecVRId number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'SPEC_VR_ID');
47: lStartStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'START_STATUS');
48: lTargetStatus Number := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'TARGET_STATUS');
49: l_wf_timeout NUMBER := TO_NUMBER(FND_PROFILE.VALUE ('GMD_WF_TIMEOUT'));
50: lStartStatus_DESC VARCHAR2(240);
51: lTargetStatus_DESC VARCHAR2(240);
52: api_ret_status VARCHAR2(1);
53: api_err_mesg VARCHAR2(240);