APPS.EDR_PSIG_PAGE_FLOW dependencies on FND_PROFILE

Line 1712: l_wf_timeout := TO_NUMBER(FND_PROFILE.VALUE('EDR_WF_TIMEOUT'),'999999999999.999999');

1708: L_DOCUMENT_ID := nvl(GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'EDR_PSIG_DOC_ID'),
1709: TO_NUMBER(GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#ERECORD_ID'),'999999999999.999999'));
1710: --Bug 3903471 : End
1711:
1712: l_wf_timeout := TO_NUMBER(FND_PROFILE.VALUE('EDR_WF_TIMEOUT'),'999999999999.999999');
1713: l_wf_timeout_interval := TO_NUMBER(FND_PROFILE.VALUE('EDR_WF_TIMEOUT_INTERVAL'),'999999999999.999999');
1714: --Bug : 3499311 End.
1715:
1716: L_SOURCE_APPL_TYPE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SOURCE_APPLICATION_TYPE');

Line 1713: l_wf_timeout_interval := TO_NUMBER(FND_PROFILE.VALUE('EDR_WF_TIMEOUT_INTERVAL'),'999999999999.999999');

1709: TO_NUMBER(GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#ERECORD_ID'),'999999999999.999999'));
1710: --Bug 3903471 : End
1711:
1712: l_wf_timeout := TO_NUMBER(FND_PROFILE.VALUE('EDR_WF_TIMEOUT'),'999999999999.999999');
1713: l_wf_timeout_interval := TO_NUMBER(FND_PROFILE.VALUE('EDR_WF_TIMEOUT_INTERVAL'),'999999999999.999999');
1714: --Bug : 3499311 End.
1715:
1716: L_SOURCE_APPL_TYPE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SOURCE_APPLICATION_TYPE');
1717: L_DEFER_MODE_ALLOWED := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'DEFERRED');

Line 1808: SET EVENT_TIMEZONE = fnd_profile.VALUE('EDR_SERVER_TIMEZONE')

1804:
1805: /* UPDATE EDR_ERECORDS
1806: SET EVENT_TIMEZONE = fnd_timezones.GET_SERVER_TIMEZONE_CODE
1807: Replaced the profile option to EDR_SERVER_ZONE
1808: SET EVENT_TIMEZONE = fnd_profile.VALUE('EDR_SERVER_TIMEZONE')
1809: WHERE event_id = p_itemkey;*/
1810:
1811: -- Converting days into minutes
1812:

Line 2028: --l_send_individual_ntf := fnd_profile.value('EDR_INDIVIDUAL_APPROVAL_NTF');

2024: -- Bug 3315185 : Modified profile option access level to user level
2025: -- for accessing the requester's preference first.
2026:
2027: --read the profile option to find out when the requester needs the notification
2028: --l_send_individual_ntf := fnd_profile.value('EDR_INDIVIDUAL_APPROVAL_NTF');
2029:
2030: select user_id into l_requester_id from fnd_user where user_name = trim(l_requester);
2031:
2032: l_send_individual_ntf := fnd_profile.value_specific(NAME => 'EDR_INDIVIDUAL_APPROVAL_NTF',

Line 2032: l_send_individual_ntf := fnd_profile.value_specific(NAME => 'EDR_INDIVIDUAL_APPROVAL_NTF',

2028: --l_send_individual_ntf := fnd_profile.value('EDR_INDIVIDUAL_APPROVAL_NTF');
2029:
2030: select user_id into l_requester_id from fnd_user where user_name = trim(l_requester);
2031:
2032: l_send_individual_ntf := fnd_profile.value_specific(NAME => 'EDR_INDIVIDUAL_APPROVAL_NTF',
2033: USER_ID => l_requester_id );
2034:
2035:
2036: -- If the user has not set this profile option, access it at site level

Line 2038: l_send_individual_ntf := fnd_profile.value_specific( NAME => 'EDR_INDIVIDUAL_APPROVAL_NTF');

2034:
2035:
2036: -- If the user has not set this profile option, access it at site level
2037: if ( l_send_individual_ntf is null) then
2038: l_send_individual_ntf := fnd_profile.value_specific( NAME => 'EDR_INDIVIDUAL_APPROVAL_NTF');
2039: end if;
2040:
2041: -- Bug 3315185 : End
2042: