eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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 840: l_fte_profile_value VARCHAR2(30) := fnd_profile.VALUE('PER_ANNUAL_SALARY_ON_FTE');

836: ,p_proposed_salary IN NUMBER
837: ,p_pay_annual_factor IN number
838: ,p_pay_basis in varchar2
839: ) RETURN NUMBER IS
840: l_fte_profile_value VARCHAR2(30) := fnd_profile.VALUE('PER_ANNUAL_SALARY_ON_FTE');
841: l_pay_factor number;
842: l_fte_factor NUMBER;
843: ln_annual_salary NUMBER;
844: begin

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

1210: -- code calling fnd_global.apps_initialize but where the HR signon
1211: -- callback is not called - ie user/resp/sc context has not changed.
1212: --
1213:
1214: if ( nvl(fnd_profile.value('HR_SEC_INIT_AM'),'N') = 'Y')
1215: then
1216: hr_signon.session_context := hr_signon.session_context + 1;
1217: end if;
1218:

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

1224: defined_z BOOLEAN;
1225:
1226: BEGIN
1227:
1228: l_enableSecGroups := nvl(fnd_profile.value('ENABLE_SECURITY_GROUPS'),'N');
1229:
1230: IF (nvl(fnd_global.application_short_name,'#') <> 'PER' AND l_enableSecGroups <> 'Y') THEN
1231: fnd_profile.get_specific('ENABLE_SECURITY_GROUPS',NULL,NULL,'800',l_enableSecGroups,defined_z,NULL,NULL);
1232: IF (nvl(l_enableSecGroups,'N') <> nvl(fnd_profile.value('ENABLE_SECURITY_GROUPS'),'N')) THEN

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

1227:
1228: l_enableSecGroups := nvl(fnd_profile.value('ENABLE_SECURITY_GROUPS'),'N');
1229:
1230: IF (nvl(fnd_global.application_short_name,'#') <> 'PER' AND l_enableSecGroups <> 'Y') THEN
1231: fnd_profile.get_specific('ENABLE_SECURITY_GROUPS',NULL,NULL,'800',l_enableSecGroups,defined_z,NULL,NULL);
1232: IF (nvl(l_enableSecGroups,'N') <> nvl(fnd_profile.value('ENABLE_SECURITY_GROUPS'),'N')) THEN
1233: fnd_profile.put('ENABLE_SECURITY_GROUPS', l_enableSecGroups);
1234: END IF;
1235: END IF;

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

1228: l_enableSecGroups := nvl(fnd_profile.value('ENABLE_SECURITY_GROUPS'),'N');
1229:
1230: IF (nvl(fnd_global.application_short_name,'#') <> 'PER' AND l_enableSecGroups <> 'Y') THEN
1231: fnd_profile.get_specific('ENABLE_SECURITY_GROUPS',NULL,NULL,'800',l_enableSecGroups,defined_z,NULL,NULL);
1232: IF (nvl(l_enableSecGroups,'N') <> nvl(fnd_profile.value('ENABLE_SECURITY_GROUPS'),'N')) THEN
1233: fnd_profile.put('ENABLE_SECURITY_GROUPS', l_enableSecGroups);
1234: END IF;
1235: END IF;
1236:

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

1229:
1230: IF (nvl(fnd_global.application_short_name,'#') <> 'PER' AND l_enableSecGroups <> 'Y') THEN
1231: fnd_profile.get_specific('ENABLE_SECURITY_GROUPS',NULL,NULL,'800',l_enableSecGroups,defined_z,NULL,NULL);
1232: IF (nvl(l_enableSecGroups,'N') <> nvl(fnd_profile.value('ENABLE_SECURITY_GROUPS'),'N')) THEN
1233: fnd_profile.put('ENABLE_SECURITY_GROUPS', l_enableSecGroups);
1234: END IF;
1235: END IF;
1236:
1237: RETURN l_enableSecGroups;

Line 1417: select decode(fnd_profile.value('ENABLE_SECURITY_GROUPS'), 'Y' , p_bg_id,

1413:
1414: -- This logic for SSHR Manager Self-Service fucntion and for Appraisal Manager Fucntion
1415: IF (l_func_name <> l_param_name) OR (l_appr_index > 0 ) OR (l_ghr_index > 0)THEN
1416: begin
1417: select decode(fnd_profile.value('ENABLE_SECURITY_GROUPS'), 'Y' , p_bg_id,
1418: decode(fnd_global.employee_id,p_person_id,
1419: nvl(
1420: decode( FND_PROFILE.VALUE_SPECIFIC('PER_BUSINESS_GROUP_ID',null,fnd_global.resp_id)
1421: ,null,fnd_profile.value('PER_BUSINESS_GROUP_ID'),

Line 1420: decode( FND_PROFILE.VALUE_SPECIFIC('PER_BUSINESS_GROUP_ID',null,fnd_global.resp_id)

1416: begin
1417: select decode(fnd_profile.value('ENABLE_SECURITY_GROUPS'), 'Y' , p_bg_id,
1418: decode(fnd_global.employee_id,p_person_id,
1419: nvl(
1420: decode( FND_PROFILE.VALUE_SPECIFIC('PER_BUSINESS_GROUP_ID',null,fnd_global.resp_id)
1421: ,null,fnd_profile.value('PER_BUSINESS_GROUP_ID'),
1422: FND_PROFILE.VALUE_SPECIFIC('PER_BUSINESS_GROUP_ID',null,fnd_global.resp_id)
1423: )
1424: ,p_bg_id

Line 1421: ,null,fnd_profile.value('PER_BUSINESS_GROUP_ID'),

1417: select decode(fnd_profile.value('ENABLE_SECURITY_GROUPS'), 'Y' , p_bg_id,
1418: decode(fnd_global.employee_id,p_person_id,
1419: nvl(
1420: decode( FND_PROFILE.VALUE_SPECIFIC('PER_BUSINESS_GROUP_ID',null,fnd_global.resp_id)
1421: ,null,fnd_profile.value('PER_BUSINESS_GROUP_ID'),
1422: FND_PROFILE.VALUE_SPECIFIC('PER_BUSINESS_GROUP_ID',null,fnd_global.resp_id)
1423: )
1424: ,p_bg_id
1425: ),p_bg_id)) into l_bg_id from dual;

Line 1422: FND_PROFILE.VALUE_SPECIFIC('PER_BUSINESS_GROUP_ID',null,fnd_global.resp_id)

1418: decode(fnd_global.employee_id,p_person_id,
1419: nvl(
1420: decode( FND_PROFILE.VALUE_SPECIFIC('PER_BUSINESS_GROUP_ID',null,fnd_global.resp_id)
1421: ,null,fnd_profile.value('PER_BUSINESS_GROUP_ID'),
1422: FND_PROFILE.VALUE_SPECIFIC('PER_BUSINESS_GROUP_ID',null,fnd_global.resp_id)
1423: )
1424: ,p_bg_id
1425: ),p_bg_id)) into l_bg_id from dual;
1426: end;

Line 1723: and fnd_profile.value('PER_UPLOAD_IREC_DOC') = 'Y'

1719: hr_utility.set_location('l_person_id: '||l_person_id, 10);
1720: hr_utility.set_location('l_irc_doc_id: '||l_irc_doc_id, 10);
1721:
1722: IF l_person_id = p_dest_pk1_value
1723: and fnd_profile.value('PER_UPLOAD_IREC_DOC') = 'Y'
1724: THEN
1725: hr_utility.set_location('Entering: IF l_person_id <> null ', 10);
1726: IF(per_fnd_attachment_pkg.is_iRec_doc_exist (l_person_id , l_irc_doc_id ))
1727: THEN

Line 2010: and fnd_profile.value('PER_UPLOAD_IREC_DOC') = 'Y'

2006: ,p_return_status => l_return_status);
2007:
2008: /* Added the following code as a part of ER#9879782 Starts*/
2009: IF l_api_name = 'HR_PROCESS_PERSON_SS.PROCESS_API'
2010: and fnd_profile.value('PER_UPLOAD_IREC_DOC') = 'Y'
2011: THEN
2012: BEGIN
2013: SELECT COUNT(1)
2014: INTO l_apl_flag

Line 2566: l_profile_value varchar2(10) := fnd_profile.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT');

2562: function getManagerName (p_rptg_grp_id in number,p_plan_id in
2563: number,p_assignment_id in number, p_bg_id in number)
2564: return varchar2
2565: is
2566: l_profile_value varchar2(10) := fnd_profile.VALUE('HR_LOCAL_OR_GLOBAL_NAME_FORMAT');
2567: l_manager_id number(10);
2568: l_manager_global_name varchar2(100) := null;
2569: l_manager_local_name varchar2(100) := null;
2570: begin