DBA Data[Home] [Help]

APPS.PO_SIGNATURE_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 PO_SIGNATURE_PVT AS
2: /* $Header: POXVSIGB.pls 120.42.12020000.3 2013/02/10 22:53:23 vegajula 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: c_log_head CONSTANT VARCHAR2(30) := 'po.plsql.PO_SIGNATURE_PVT.';
8: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_SIGNATURE_PVT'; --
9: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;

Line 13: g_default_promise_date VARCHAR2(1) := NVL(FND_PROFILE.VALUE('POS_DEFAULT_PROMISE_DATE_ACK'),'N');

9: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
10: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
11:
12: -- Read the profile option that determines whether the promise date will be defaulted with need-by date or not
13: g_default_promise_date VARCHAR2(1) := NVL(FND_PROFILE.VALUE('POS_DEFAULT_PROMISE_DATE_ACK'),'N');
14:
15:
16: --Cursor to select the PO details to be used in the notification message bodies
17: -- SQL What:selects the PO details and the vendor details from

Line 4550: --l_ko_sign_required := NVL(FND_PROFILE.VALUE('PO_CLM_KO_SIGNATURE_REQD'),'N');

4546: if (funcmode <> WF_ENGINE.eng_run) then
4547: resultout := WF_ENGINE.eng_null;
4548: return;
4549: END if;
4550: --l_ko_sign_required := NVL(FND_PROFILE.VALUE('PO_CLM_KO_SIGNATURE_REQD'),'N');
4551: l_ko_sign_required := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
4552: itemkey => itemkey,
4553: aname => 'KO_SIGNATURE_PROFILE');
4554: l_ko_response := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,