DBA Data[Home] [Help]

APPS.POR_CANCEL_NOTIF_PVT dependencies on FND_PROFILE

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

1: PACKAGE BODY por_cancel_notif_pvt AS
2: /* $Header: PORCNNTB.pls 115.3 2004/05/08 00:23:58 mahmad noship $ */
3:
4: -- Read the profile option that enables/disables the debug log
5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
6: g_pkg_name CONSTANT VARCHAR2(50) := 'POR_CANCEL_NOTIF_PVT';
7: g_module_prefix CONSTANT VARCHAR2(50) := 'por.plsql.' || g_pkg_name || '.';
8:
9: /*==========================================================================*

Line 179: FND_PROFILE.GET('USER_ID', l_user_id);

175: l_user_id varchar2(100) := '';
176:
177: BEGIN
178:
179: FND_PROFILE.GET('USER_ID', l_user_id);
180:
181: select user_name
182: into l_user_name
183: from fnd_user