DBA Data[Home] [Help]

APPS.PO_REQAPPROVAL_FINDAPPRV1 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 PO_REQAPPROVAL_FINDAPPRV1 AS
2: /* $Header: POXWPA3B.pls 120.5.12010000.2 2008/08/04 08:35:58 rramasam ship $ */
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:
7:
8: /*=======================================================================+
9: | FILENAME

Line 1869: AND nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N') = 'Y'

1865: WHERE poeh.position_structure_id = p_approval_path_id
1866: AND poeh.employee_id = p_empid
1867: AND cwk.person_id = poeh.superior_id
1868: AND poeh.superior_level > 0
1869: AND nvl(fnd_profile.value('HR_TREAT_CWK_AS_EMP'),'N') = 'Y'
1870: ORDER BY superior_level, full_name;
1871:
1872: l_superior_id NUMBER := NULL;
1873: l_superior_level NUMBER := NULL;