DBA Data[Home] [Help]

APPS.HR_UTIL_MISC_SS dependencies on FND_PROFILE

Line 39: ,p_override_currency IN VARCHAR2 default fnd_profile.value('ICX_PREFERRED_CURRENCY')

35: FUNCTION get_in_preferred_currency_num(
36: p_amount IN NUMBER
37: ,p_from_currency IN VARCHAR2
38: ,p_eff_Date IN DATE DEFAULT trunc(sysdate)
39: ,p_override_currency IN VARCHAR2 default fnd_profile.value('ICX_PREFERRED_CURRENCY')
40: ) RETURN NUMBER IS
41: l_to_currency VARCHAR2(10);
42: l_return NUMBER;
43: BEGIN

Line 82: ,p_override_currency IN VARCHAR2 default fnd_profile.value('ICX_PREFERRED_CURRENCY')

78: */
79: FUNCTION get_preferred_currency(
80: p_from_currency IN VARCHAR2
81: ,p_eff_Date IN DATE DEFAULT trunc(sysdate)
82: ,p_override_currency IN VARCHAR2 default fnd_profile.value('ICX_PREFERRED_CURRENCY')
83: ) RETURN VARCHAR2 IS
84: l_to_currency VARCHAR2(10);
85: l_return NUMBER;
86: BEGIN

Line 123: ,p_override_currency IN VARCHAR2 default fnd_profile.value('ICX_PREFERRED_CURRENCY')

119: FUNCTION get_in_preferred_currency_str(
120: p_amount IN NUMBER
121: ,p_from_currency IN VARCHAR2
122: ,p_eff_Date IN DATE DEFAULT trunc(sysdate)
123: ,p_override_currency IN VARCHAR2 default fnd_profile.value('ICX_PREFERRED_CURRENCY')
124: ) RETURN VARCHAR2 IS
125: l_to_currency VARCHAR2(10);
126: l_converted_amount NUMBER;
127: BEGIN

Line 1010: if ( nvl(fnd_profile.value('HR_SEC_INIT_AM'),'N') = 'Y')

1006: -- code calling fnd_global.apps_initialize but where the HR signon
1007: -- callback is not called - ie user/resp/sc context has not changed.
1008: --
1009:
1010: if ( nvl(fnd_profile.value('HR_SEC_INIT_AM'),'N') = 'Y')
1011: then
1012: hr_signon.session_context := hr_signon.session_context + 1;
1013: end if;
1014:

Line 1024: l_enableSecGroups := nvl(fnd_profile.value('ENABLE_SECURITY_GROUPS'),'N');

1020: defined_z BOOLEAN;
1021:
1022: BEGIN
1023:
1024: l_enableSecGroups := nvl(fnd_profile.value('ENABLE_SECURITY_GROUPS'),'N');
1025:
1026: IF (nvl(fnd_global.application_short_name,'#') <> 'PER' AND l_enableSecGroups <> 'Y') THEN
1027: fnd_profile.get_specific('ENABLE_SECURITY_GROUPS',NULL,NULL,'800',l_enableSecGroups,defined_z,NULL,NULL);
1028: IF (nvl(l_enableSecGroups,'N') <> nvl(fnd_profile.value('ENABLE_SECURITY_GROUPS'),'N')) THEN

Line 1027: fnd_profile.get_specific('ENABLE_SECURITY_GROUPS',NULL,NULL,'800',l_enableSecGroups,defined_z,NULL,NULL);

1023:
1024: l_enableSecGroups := nvl(fnd_profile.value('ENABLE_SECURITY_GROUPS'),'N');
1025:
1026: IF (nvl(fnd_global.application_short_name,'#') <> 'PER' AND l_enableSecGroups <> 'Y') THEN
1027: fnd_profile.get_specific('ENABLE_SECURITY_GROUPS',NULL,NULL,'800',l_enableSecGroups,defined_z,NULL,NULL);
1028: IF (nvl(l_enableSecGroups,'N') <> nvl(fnd_profile.value('ENABLE_SECURITY_GROUPS'),'N')) THEN
1029: fnd_profile.put('ENABLE_SECURITY_GROUPS', l_enableSecGroups);
1030: END IF;
1031: END IF;

Line 1028: IF (nvl(l_enableSecGroups,'N') <> nvl(fnd_profile.value('ENABLE_SECURITY_GROUPS'),'N')) THEN

1024: l_enableSecGroups := nvl(fnd_profile.value('ENABLE_SECURITY_GROUPS'),'N');
1025:
1026: IF (nvl(fnd_global.application_short_name,'#') <> 'PER' AND l_enableSecGroups <> 'Y') THEN
1027: fnd_profile.get_specific('ENABLE_SECURITY_GROUPS',NULL,NULL,'800',l_enableSecGroups,defined_z,NULL,NULL);
1028: IF (nvl(l_enableSecGroups,'N') <> nvl(fnd_profile.value('ENABLE_SECURITY_GROUPS'),'N')) THEN
1029: fnd_profile.put('ENABLE_SECURITY_GROUPS', l_enableSecGroups);
1030: END IF;
1031: END IF;
1032:

Line 1029: fnd_profile.put('ENABLE_SECURITY_GROUPS', l_enableSecGroups);

1025:
1026: IF (nvl(fnd_global.application_short_name,'#') <> 'PER' AND l_enableSecGroups <> 'Y') THEN
1027: fnd_profile.get_specific('ENABLE_SECURITY_GROUPS',NULL,NULL,'800',l_enableSecGroups,defined_z,NULL,NULL);
1028: IF (nvl(l_enableSecGroups,'N') <> nvl(fnd_profile.value('ENABLE_SECURITY_GROUPS'),'N')) THEN
1029: fnd_profile.put('ENABLE_SECURITY_GROUPS', l_enableSecGroups);
1030: END IF;
1031: END IF;
1032:
1033: RETURN l_enableSecGroups;