APPS.EDR_PSIG_PAGE_FLOW dependencies on FND_PROFILE

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

1731: L_DOCUMENT_ID := nvl(GET_WF_ITEM_ATTRIBUTE_NUMBER(p_itemtype, p_itemkey,'EDR_PSIG_DOC_ID'),
1732: TO_NUMBER(GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#ERECORD_ID'),'999999999999.999999'));
1733: --Bug 3903471 : End
1734:
1735: l_wf_timeout := TO_NUMBER(FND_PROFILE.VALUE('EDR_WF_TIMEOUT'),'999999999999.999999');
1736: l_wf_timeout_interval := TO_NUMBER(FND_PROFILE.VALUE('EDR_WF_TIMEOUT_INTERVAL'),'999999999999.999999');
1737: --Bug : 3499311 End.
1738:
1739: L_SOURCE_APPL_TYPE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SOURCE_APPLICATION_TYPE');

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

1732: TO_NUMBER(GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#ERECORD_ID'),'999999999999.999999'));
1733: --Bug 3903471 : End
1734:
1735: l_wf_timeout := TO_NUMBER(FND_PROFILE.VALUE('EDR_WF_TIMEOUT'),'999999999999.999999');
1736: l_wf_timeout_interval := TO_NUMBER(FND_PROFILE.VALUE('EDR_WF_TIMEOUT_INTERVAL'),'999999999999.999999');
1737: --Bug : 3499311 End.
1738:
1739: L_SOURCE_APPL_TYPE := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'#WF_SOURCE_APPLICATION_TYPE');
1740: L_DEFER_MODE_ALLOWED := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,'DEFERRED');

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

1827:
1828: /* UPDATE EDR_ERECORDS
1829: SET EVENT_TIMEZONE = fnd_timezones.GET_SERVER_TIMEZONE_CODE
1830: Replaced the profile option to EDR_SERVER_ZONE
1831: SET EVENT_TIMEZONE = fnd_profile.VALUE('EDR_SERVER_TIMEZONE')
1832: WHERE event_id = p_itemkey;*/
1833:
1834: -- Converting days into minutes
1835:

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

2049: -- Bug 3315185 : Modified profile option access level to user level
2050: -- for accessing the requester's preference first.
2051:
2052: --read the profile option to find out when the requester needs the notification
2053: --l_send_individual_ntf := fnd_profile.value('EDR_INDIVIDUAL_APPROVAL_NTF');
2054:
2055: select user_id into l_requester_id from fnd_user where user_name = trim(l_requester);
2056:
2057: l_send_individual_ntf := fnd_profile.value_specific(NAME => 'EDR_INDIVIDUAL_APPROVAL_NTF',

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

2053: --l_send_individual_ntf := fnd_profile.value('EDR_INDIVIDUAL_APPROVAL_NTF');
2054:
2055: select user_id into l_requester_id from fnd_user where user_name = trim(l_requester);
2056:
2057: l_send_individual_ntf := fnd_profile.value_specific(NAME => 'EDR_INDIVIDUAL_APPROVAL_NTF',
2058: USER_ID => l_requester_id );
2059:
2060:
2061: -- If the user has not set this profile option, access it at site level

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

2059:
2060:
2061: -- If the user has not set this profile option, access it at site level
2062: if ( l_send_individual_ntf is null) then
2063: l_send_individual_ntf := fnd_profile.value_specific( NAME => 'EDR_INDIVIDUAL_APPROVAL_NTF');
2064: end if;
2065:
2066: -- Bug 3315185 : End
2067: