DBA Data[Home] [Help]

APPS.PO_REQAPPROVAL_INIT1 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_INIT1 AS
2: /* $Header: POXWPA1B.pls 120.56.12010000.7 2009/01/20 05:50:56 lgoyal 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: -- Read the profile option that determines whether the promise date will be defaulted with need-by date or not
7: g_default_promise_date VARCHAR2(1) := NVL(FND_PROFILE.VALUE('POS_DEFAULT_PROMISE_DATE_ACK'),'N');
8:
9: g_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;

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

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: -- Read the profile option that determines whether the promise date will be defaulted with need-by date or not
7: g_default_promise_date VARCHAR2(1) := NVL(FND_PROFILE.VALUE('POS_DEFAULT_PROMISE_DATE_ACK'),'N');
8:
9: g_document_subtype PO_HEADERS_ALL.TYPE_LOOKUP_CODE%TYPE;
10:
11: --Bug#3497033

Line 808: FND_PROFILE.GET('PO_SECONDRY_EMAIL_ADD', EmailAddProfile);

804: -- Initialize workflow item attributes
805: --
806: /* get the profile option value for the second Email Address */
807:
808: FND_PROFILE.GET('PO_SECONDRY_EMAIL_ADD', EmailAddProfile);
809:
810: if NVL(ActionOriginatedFrom, 'Approval') = 'POS_DATE_CHG' then
811:
812: wf_engine.SetItemAttrText ( itemtype => l_itemtype,

Line 1573: x_progress := 'PO_REQAPPROVAL_INIT1.Start_WF_Process: Before call to FND_PROFILE';

1569: ELSIF DocumentTypeCode = 'RELEASE' THEN
1570: PO_CHORD_WF6.Set_Wf_Release_Tol(l_itemtype, l_itemkey , DocumentSubtype);
1571: END IF;
1572:
1573: x_progress := 'PO_REQAPPROVAL_INIT1.Start_WF_Process: Before call to FND_PROFILE';
1574: IF (g_po_wf_debug = 'Y') THEN
1575: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,x_progress);
1576: END IF;
1577:

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

1580: ** the Document Manager.
1581: */
1582:
1583: if (x_wf_created = 0) then
1584: --FND_PROFILE.GET('USER_ID', l_user_id);
1585: --FND_PROFILE.GET('RESP_ID', l_responsibility_id);
1586: --FND_PROFILE.GET('RESP_APPL_ID', l_application_id);
1587:
1588:

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

1581: */
1582:
1583: if (x_wf_created = 0) then
1584: --FND_PROFILE.GET('USER_ID', l_user_id);
1585: --FND_PROFILE.GET('RESP_ID', l_responsibility_id);
1586: --FND_PROFILE.GET('RESP_APPL_ID', l_application_id);
1587:
1588:
1589: l_user_id := fnd_global.user_id;

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

1582:
1583: if (x_wf_created = 0) then
1584: --FND_PROFILE.GET('USER_ID', l_user_id);
1585: --FND_PROFILE.GET('RESP_ID', l_responsibility_id);
1586: --FND_PROFILE.GET('RESP_APPL_ID', l_application_id);
1587:
1588:
1589: l_user_id := fnd_global.user_id;
1590: l_responsibility_id := fnd_global.resp_id;

Line 1845: l_printer := fnd_profile.value('PRINTER');

1841: owner => x_username); -- Bug 2148872 }
1842:
1843: -- Context Setting revamp (begin)
1844:
1845: l_printer := fnd_profile.value('PRINTER');
1846: l_conc_copies := to_number(fnd_profile.value('CONC_COPIES'));
1847: l_conc_save_output := fnd_profile.value('CONC_SAVE_OUTPUT');
1848:
1849:

Line 1846: l_conc_copies := to_number(fnd_profile.value('CONC_COPIES'));

1842:
1843: -- Context Setting revamp (begin)
1844:
1845: l_printer := fnd_profile.value('PRINTER');
1846: l_conc_copies := to_number(fnd_profile.value('CONC_COPIES'));
1847: l_conc_save_output := fnd_profile.value('CONC_SAVE_OUTPUT');
1848:
1849:
1850: /* changed the call from wf_engine.setiteattrtext to

Line 1847: l_conc_save_output := fnd_profile.value('CONC_SAVE_OUTPUT');

1843: -- Context Setting revamp (begin)
1844:
1845: l_printer := fnd_profile.value('PRINTER');
1846: l_conc_copies := to_number(fnd_profile.value('CONC_COPIES'));
1847: l_conc_save_output := fnd_profile.value('CONC_SAVE_OUTPUT');
1848:
1849:
1850: /* changed the call from wf_engine.setiteattrtext to
1851: po_wf_util_pkg.setitemattrtext because the later handles

Line 2121: IF (fnd_profile.value('POR_SSP4_INSTALLED') = 'Y' AND

2117: */
2118:
2119: -- The support for icx 3.0 is removed.
2120:
2121: IF (fnd_profile.value('POR_SSP4_INSTALLED') = 'Y' AND
2122: l_document_type = 'REQUISITION' and
2123: po_core_s.get_product_install_status('ICX') = 'I') THEN
2124:
2125: --Bug#3147435

Line 2392: l_external_url := fnd_profile.value('POS_EXTERNAL_URL');

2388:
2389: end if;
2390:
2391: --Bug 6164753
2392: l_external_url := fnd_profile.value('POS_EXTERNAL_URL');
2393:
2394: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => itemtype,
2395: itemkey => itemkey,
2396: aname => '#WFM_HTMLAGENT',

Line 5169: fnd_profile.get('PO_WORKFLOW_APPROVAL_MODE', l_approval_mode);

5165: return;
5166:
5167: end if;
5168:
5169: fnd_profile.get('PO_WORKFLOW_APPROVAL_MODE', l_approval_mode);
5170:
5171: /* Bug 678291 by dkfchan
5172: ** if the approval mode is background, set the result to 'BACKGROUD'
5173: ** Removed the original method which set the WF_ENGINE.THRESHOLD to -1.

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

5354: IF (g_po_wf_debug = 'Y') THEN
5355: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
5356: END IF;
5357:
5358: l_approval_currency := FND_PROFILE.VALUE_SPECIFIC('ICX_PREFERRED_CURRENCY', l_user_id);
5359: end if;
5360:
5361: if (l_approval_currency = p_function_currency or l_approver_user_name is null
5362: or l_rate_type is null or l_approval_currency is null) then

Line 6648: fnd_profile.get('REPORT_QUANTITY_PRECISION', l_qty_precision);

6644: END IF;
6645:
6646: -- Get the profile option report_quantity_precision
6647:
6648: fnd_profile.get('REPORT_QUANTITY_PRECISION', l_qty_precision);
6649:
6650: /* Bug 2012896: the profile option REPORT_QUANTITY_PRECISION could be
6651: NULL. Even at site level! And in that case the printing of report
6652: results into the inappropriate printing of quantities.

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

6661:
6662: -- Get the user id for the current user. This information
6663: -- is used when sending concurrent request.
6664:
6665: FND_PROFILE.GET('USER_ID', l_user_id);
6666:
6667: -- Send the concurrent request to print document.
6668:
6669: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 6841: fnd_profile.get('REPORT_QUANTITY_PRECISION', l_qty_precision);

6837: END IF;
6838:
6839: -- Get the profile option report_quantity_precision
6840:
6841: fnd_profile.get('REPORT_QUANTITY_PRECISION', l_qty_precision);
6842:
6843: -- Get the user id for the current user. This information
6844: -- is used when sending concurrent request.
6845:

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

6842:
6843: -- Get the user id for the current user. This information
6844: -- is used when sending concurrent request.
6845:
6846: FND_PROFILE.GET('USER_ID', l_user_id);
6847:
6848: -- Send the concurrent request to fax document.
6849:
6850: l_document_type := wf_engine.GetItemAttrText (itemtype => itemtype,

Line 8963: --Fnd_Profile.Get('USER_ID',X_User_Id);

8959:
8960: BEGIN
8961:
8962: -- Bug 4290541 Start
8963: --Fnd_Profile.Get('USER_ID',X_User_Id);
8964: --Fnd_Profile.Get('RESP_ID',X_Responsibility_Id);
8965: --Fnd_Profile.Get('RESP_APPL_ID',X_Application_Id);
8966: -- Bug 4290541 End
8967: -- Context Setting Revamp

Line 8964: --Fnd_Profile.Get('RESP_ID',X_Responsibility_Id);

8960: BEGIN
8961:
8962: -- Bug 4290541 Start
8963: --Fnd_Profile.Get('USER_ID',X_User_Id);
8964: --Fnd_Profile.Get('RESP_ID',X_Responsibility_Id);
8965: --Fnd_Profile.Get('RESP_APPL_ID',X_Application_Id);
8966: -- Bug 4290541 End
8967: -- Context Setting Revamp
8968: X_User_Id := fnd_global.user_id;

Line 8965: --Fnd_Profile.Get('RESP_APPL_ID',X_Application_Id);

8961:
8962: -- Bug 4290541 Start
8963: --Fnd_Profile.Get('USER_ID',X_User_Id);
8964: --Fnd_Profile.Get('RESP_ID',X_Responsibility_Id);
8965: --Fnd_Profile.Get('RESP_APPL_ID',X_Application_Id);
8966: -- Bug 4290541 End
8967: -- Context Setting Revamp
8968: X_User_Id := fnd_global.user_id;
8969: X_Responsibility_Id := fnd_global.resp_id;