APPS.GMDQSPEC_APPROVAL_WF_PKG dependencies on FND_PROFILE

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

1: PACKAGE BODY GMDQSPEC_APPROVAL_WF_PKG AS
2: /* $Header: GMDQSAPB.pls 120.6 2011/03/18 19:38:24 plowe ship $ */
3:
4:
5: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
6:
7: APPLICATION_ERROR EXCEPTION;
8: -- Following function accepts FND userId and returns
9: -- User name

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

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