DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on FND_PROFILE

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

2: /* $Header: POXVRCWB.pls 120.91.12020000.5 2013/04/12 09:16:29 mzhussai ship $ */
3:
4:
5: -- Read the profile option that enables/disables the debug log
6: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
7: g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
8: -- Debugging
9: g_debug_stmt CONSTANT BOOLEAN := po_debug.is_debug_stmt_on;
10: g_debug_unexp CONSTANT BOOLEAN := po_debug.is_debug_unexp_on;

Line 7: g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

3:
4:
5: -- Read the profile option that enables/disables the debug log
6: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
7: g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
8: -- Debugging
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: --Bug#3497033

Line 453: l_approval_currency := FND_PROFILE.VALUE_SPECIFIC('ICX_PREFERRED_CURRENCY', l_user_id);

449: IF (g_po_wf_debug = 'Y') THEN
450: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
451: END IF;
452:
453: l_approval_currency := FND_PROFILE.VALUE_SPECIFIC('ICX_PREFERRED_CURRENCY', l_user_id);
454: end if;
455:
456: if (l_approval_currency = p_function_currency or l_approver_user_name is null
457: or l_rate_type is null or l_approval_currency is null) then

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

7564: */
7565:
7566: begin
7567: /*
7568: FND_PROFILE.GET('USER_ID', l_user_id);
7569: FND_PROFILE.GET('RESP_ID', l_responsibility_id);
7570: FND_PROFILE.GET('RESP_APPL_ID', l_application_id);
7571: fnd_global.APPS_INITIALIZE (l_user_id, l_responsibility_id, l_application_id);
7572: */

Line 7569: FND_PROFILE.GET('RESP_ID', l_responsibility_id);

7565:
7566: begin
7567: /*
7568: FND_PROFILE.GET('USER_ID', l_user_id);
7569: FND_PROFILE.GET('RESP_ID', l_responsibility_id);
7570: FND_PROFILE.GET('RESP_APPL_ID', l_application_id);
7571: fnd_global.APPS_INITIALIZE (l_user_id, l_responsibility_id, l_application_id);
7572: */
7573: po_sup_chg_request_wf_grp.KickOffPOApproval(1, p_return_status,

Line 7570: FND_PROFILE.GET('RESP_APPL_ID', l_application_id);

7566: begin
7567: /*
7568: FND_PROFILE.GET('USER_ID', l_user_id);
7569: FND_PROFILE.GET('RESP_ID', l_responsibility_id);
7570: FND_PROFILE.GET('RESP_APPL_ID', l_application_id);
7571: fnd_global.APPS_INITIALIZE (l_user_id, l_responsibility_id, l_application_id);
7572: */
7573: po_sup_chg_request_wf_grp.KickOffPOApproval(1, p_return_status,
7574: p_po_header_id, p_po_release_id, p_return_msg);

Line 11423: fnd_profile.get('USER_ID', l_user_id);

11419: itemkey => itemkey,
11420: aname => 'PO_CHANGE_REQUEST_GROUP_ID');
11421:
11422: --Bug: 14642268 Get original context value of user id, resp id and resp appl id before call to start_notifyrequesterprocess
11423: fnd_profile.get('USER_ID', l_user_id);
11424: fnd_profile.get('RESP_ID', l_responsibility_id);
11425: fnd_profile.get('RESP_APPL_ID', l_application_id);
11426:
11427: Start_NotifyRequesterProcess(l_po_change_request_group_id, itemtype, itemkey);

Line 11424: fnd_profile.get('RESP_ID', l_responsibility_id);

11420: aname => 'PO_CHANGE_REQUEST_GROUP_ID');
11421:
11422: --Bug: 14642268 Get original context value of user id, resp id and resp appl id before call to start_notifyrequesterprocess
11423: fnd_profile.get('USER_ID', l_user_id);
11424: fnd_profile.get('RESP_ID', l_responsibility_id);
11425: fnd_profile.get('RESP_APPL_ID', l_application_id);
11426:
11427: Start_NotifyRequesterProcess(l_po_change_request_group_id, itemtype, itemkey);
11428:

Line 11425: fnd_profile.get('RESP_APPL_ID', l_application_id);

11421:
11422: --Bug: 14642268 Get original context value of user id, resp id and resp appl id before call to start_notifyrequesterprocess
11423: fnd_profile.get('USER_ID', l_user_id);
11424: fnd_profile.get('RESP_ID', l_responsibility_id);
11425: fnd_profile.get('RESP_APPL_ID', l_application_id);
11426:
11427: Start_NotifyRequesterProcess(l_po_change_request_group_id, itemtype, itemkey);
11428:
11429: l_progress := 'PO_ReqChangeRequestWF_PVT.Start_Notify_Requester_Process: 04';