APPS.PO_WF_PO_NOTIFICATION dependencies on FND_PROFILE

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

1: PACKAGE BODY PO_WF_PO_NOTIFICATION AS
2: /* $Header: POXWPA7B.pls 120.9.12010000.2 2008/08/04 08:36:10 rramasam ship $ */
3:
4: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
5: g_pkg_name VARCHAR2(30) := 'PO_WF_PO_NOTIFICATION'; --
6:
7: PROCEDURE get_po_approve_msg ( document_id in varchar2,
8: display_type in varchar2,

Line 471: -- max_lines_dsp:= to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));

467: ** number of PO lines to be displayed in Approval notification.
468: ** The same profile is also used for Requisitions.
469: */
470: --
471: -- max_lines_dsp:= to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));
472:
473: -- if max_lines_dsp is NULL then
474: -- max_lines_dsp := 20;
475: -- end if;

Line 523: max_lines_dsp:= to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));

519: END IF;
520: --
521: --
522:
523: max_lines_dsp:= to_number(fnd_profile.value('PO_NOTIF_LINES_LIMIT'));
524:
525: IF max_lines_dsp IS NULL THEN
526:
527: max_lines_dsp := l_line_count;

Line 1390: --Fnd_Profile.Get('USER_ID',l_session_user_id);

1386: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1387: END IF;
1388: --
1389: --Bug 5389914
1390: --Fnd_Profile.Get('USER_ID',l_session_user_id);
1391: --Fnd_Profile.Get('RESP_ID',l_session_resp_id);
1392: --Fnd_Profile.Get('RESP_APPL_ID',l_session_appl_id);
1393: l_session_user_id := fnd_global.user_id;
1394: l_session_resp_id := fnd_global.resp_id;

Line 1391: --Fnd_Profile.Get('RESP_ID',l_session_resp_id);

1387: END IF;
1388: --
1389: --Bug 5389914
1390: --Fnd_Profile.Get('USER_ID',l_session_user_id);
1391: --Fnd_Profile.Get('RESP_ID',l_session_resp_id);
1392: --Fnd_Profile.Get('RESP_APPL_ID',l_session_appl_id);
1393: l_session_user_id := fnd_global.user_id;
1394: l_session_resp_id := fnd_global.resp_id;
1395: l_session_appl_id := fnd_global.resp_appl_id;

Line 1392: --Fnd_Profile.Get('RESP_APPL_ID',l_session_appl_id);

1388: --
1389: --Bug 5389914
1390: --Fnd_Profile.Get('USER_ID',l_session_user_id);
1391: --Fnd_Profile.Get('RESP_ID',l_session_resp_id);
1392: --Fnd_Profile.Get('RESP_APPL_ID',l_session_appl_id);
1393: l_session_user_id := fnd_global.user_id;
1394: l_session_resp_id := fnd_global.resp_id;
1395: l_session_appl_id := fnd_global.resp_appl_id;
1396: