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.

APPS.IRC_PARTY_API dependencies on FND_PROFILE

Line 1004: l_business_group_id := fnd_profile.value('IRC_REGISTRATION_BG_ID');

1000: --
1001: --
1002: -- Get the business group id from profile
1003: --
1004: l_business_group_id := fnd_profile.value('IRC_REGISTRATION_BG_ID');
1005: --
1006: if l_business_group_id is null then
1007: fnd_message.set_name('PER','IRC_412155_REG_BG_NOT_SET');
1008: fnd_message.raise_error;

Line 1489: fnd_profile.put('HZ_CREATED_BY_MODULE','HR API');

1485: -- Process Logic
1486: --
1487: --
1488: -- Set profile option
1489: fnd_profile.put('HZ_CREATED_BY_MODULE','HR API');
1490: hr_utility.set_location(l_proc, 40);
1491: --
1492: -- Added for turn off key flex field validation
1493: --

Line 1934: and AGV1.AGENCY_ID = FND_PROFILE.VALUE('IRC_AGENCY_NAME')

1930: where paaf.vacancy_id = p_vacancy_id and paaf.assignment_type = 'A'
1931: and p_effective_date between PAAF.EFFECTIVE_START_DATE
1932: AND PAAF.EFFECTIVE_END_DATE
1933: and paaf.VACANCY_ID = AGV1.VACANCY_ID
1934: and AGV1.AGENCY_ID = FND_PROFILE.VALUE('IRC_AGENCY_NAME')
1935: and per1.person_id=paaf.person_id
1936: and p_effective_date between per1.effective_start_date and per1.effective_end_date
1937: and per1.party_id=prefs.party_id
1938: and prefs.agency_id=agv1.agency_id

Line 1946: and AGV.AGENCY_ID = FND_PROFILE.VALUE('IRC_AGENCY_NAME');

1942: cursor csr_application_count_limit(p_vacancy_id number) is
1943: select AGV.MAX_ALLOWED_APPLICANTS
1944: from IRC_AGENCY_VACANCIES AGV
1945: where agv.vacancy_id = p_vacancy_id
1946: and AGV.AGENCY_ID = FND_PROFILE.VALUE('IRC_AGENCY_NAME');
1947: --
1948: l_application_count_limit IRC_AGENCY_VACANCIES.MAX_ALLOWED_APPLICANTS%TYPE;
1949: l_application_count Number;
1950: l_agency_id IRC_AGENCY_VACANCIES.AGENCY_ID%TYPE;

Line 1955: if ( FND_PROFILE.VALUE('IRC_AGENCY_NAME') is not null ) then

1951: begin
1952: --
1953: -- only check if Agency profile is set
1954: --
1955: if ( FND_PROFILE.VALUE('IRC_AGENCY_NAME') is not null ) then
1956: --
1957: -- get the applicant count limit for the vacancy
1958: --
1959: open csr_application_count_limit(p_vacancy_id);

Line 1964: l_application_count_limit := FND_PROFILE.VALUE('IRC_MAX_APPLICANTS_DFT');

1960: fetch csr_application_count_limit into l_application_count_limit;
1961: --
1962: if ( csr_application_count_limit%found ) then
1963: if ( l_application_count_limit is null ) then
1964: l_application_count_limit := FND_PROFILE.VALUE('IRC_MAX_APPLICANTS_DFT');
1965: end if;
1966: end if;
1967: close csr_application_count_limit;
1968: --

Line 2810: l_profile_check := fnd_profile.save (

2806: hr_utility.set_location(l_proc,30);
2807: --
2808: -- set the language profile option
2809: --
2810: l_profile_check := fnd_profile.save (
2811: x_name => 'ICX_LANGUAGE',
2812: x_value => p_language,
2813: x_level_name => 'USER',
2814: x_level_value => l_user_id );

Line 2835: if (fnd_profile.value('ENABLE_SECURITY_GROUPS')='Y') then

2831: hr_utility.set_location(l_proc,50);
2832: --
2833: -- look to see if we are using multiple security groups
2834: --
2835: if (fnd_profile.value('ENABLE_SECURITY_GROUPS')='Y') then
2836: hr_utility.set_location(l_proc,60);
2837: l_sec_profile_id:=fnd_profile.value_specific
2838: (name=>'PER_SECURITY_PROFILE_ID'
2839: ,user_id=>l_user_id

Line 2837: l_sec_profile_id:=fnd_profile.value_specific

2833: -- look to see if we are using multiple security groups
2834: --
2835: if (fnd_profile.value('ENABLE_SECURITY_GROUPS')='Y') then
2836: hr_utility.set_location(l_proc,60);
2837: l_sec_profile_id:=fnd_profile.value_specific
2838: (name=>'PER_SECURITY_PROFILE_ID'
2839: ,user_id=>l_user_id
2840: ,responsibility_id=>p_responsibility_id
2841: ,application_id=>p_resp_appl_id);

Line 2842: l_business_group_id:=fnd_profile.value_specific

2838: (name=>'PER_SECURITY_PROFILE_ID'
2839: ,user_id=>l_user_id
2840: ,responsibility_id=>p_responsibility_id
2841: ,application_id=>p_resp_appl_id);
2842: l_business_group_id:=fnd_profile.value_specific
2843: (name=>'PER_BUSINESS_GROUP_ID'
2844: ,user_id=>l_user_id
2845: ,responsibility_id=>p_responsibility_id
2846: ,application_id=>p_resp_appl_id);

Line 2865: l_menu_name:=fnd_profile.value_specific

2861: hr_utility.set_location(l_proc,90);
2862: --
2863: -- Assign the grant to the User
2864: --
2865: l_menu_name:=fnd_profile.value_specific
2866: (name=>'IRC_CANDIDATE_PSET'
2867: ,user_id=>l_user_id
2868: ,responsibility_id=>p_responsibility_id
2869: ,application_id=>p_resp_appl_id);

Line 2967: l_allow_access := nvl(p_allow_access,nvl(fnd_profile.value('IRC_VISIBLE_PREF_DEFAULT'),'N'));

2963: l_start_date := trunc(p_start_date);
2964: --
2965: -- default Allow Access if input value is NULL
2966: --
2967: l_allow_access := nvl(p_allow_access,nvl(fnd_profile.value('IRC_VISIBLE_PREF_DEFAULT'),'N'));
2968: --
2969: -- Call Before Process User Hook
2970: --
2971: begin

Line 3394: and per1.business_group_id = fnd_profile.value('IRC_REGISTRATION_BG_ID');

3390: select per1.person_id
3391: from per_all_people_f per1
3392: where per1.party_id=p_party_id
3393: and trunc(sysdate) between per1.effective_start_date and per1.effective_end_date
3394: and per1.business_group_id = fnd_profile.value('IRC_REGISTRATION_BG_ID');
3395:
3396: l_person_id number;
3397:
3398: cursor has_notification_prefs(p_party_id number) is

Line 3529: l_allow_access := nvl(fnd_profile.value_specific

3525: --
3526: -- default Allow Access if input value is NULL
3527: --
3528: if p_allow_access is NULL then
3529: l_allow_access := nvl(fnd_profile.value_specific
3530: (name=>'IRC_VISIBLE_PREF_DEFAULT'
3531: ,responsibility_id=>p_responsibility_id
3532: ,application_id=>p_resp_appl_id), 'N');
3533: else

Line 3742: if fnd_profile.value('SIGNON_PASSWORD_LENGTH') is not null then

3738: --
3739: -- Get the Password Length from the profile
3740: --
3741: begin
3742: if fnd_profile.value('SIGNON_PASSWORD_LENGTH') is not null then
3743: l_password_length := fnd_profile.value('SIGNON_PASSWORD_LENGTH');
3744: else
3745: l_password_length := l_min_password_length;
3746: end if;

Line 3743: l_password_length := fnd_profile.value('SIGNON_PASSWORD_LENGTH');

3739: -- Get the Password Length from the profile
3740: --
3741: begin
3742: if fnd_profile.value('SIGNON_PASSWORD_LENGTH') is not null then
3743: l_password_length := fnd_profile.value('SIGNON_PASSWORD_LENGTH');
3744: else
3745: l_password_length := l_min_password_length;
3746: end if;
3747: exception

Line 3817: l_profile_check := fnd_profile.save (

3813: end if;
3814:
3815: -- set the language prefs if required
3816: if (p_language is not null) then
3817: l_profile_check := fnd_profile.save (
3818: x_name => 'ICX_LANGUAGE',
3819: x_value => l_nls_language,
3820: x_level_name => 'USER',
3821: x_level_value => l_user_id );

Line 3851: if (fnd_profile.value('ENABLE_SECURITY_GROUPS')='Y') then

3847: hr_utility.set_location(l_proc,180);
3848: --
3849: -- look to see if we are using multiple security groups
3850: --
3851: if (fnd_profile.value('ENABLE_SECURITY_GROUPS')='Y') then
3852: hr_utility.set_location(l_proc,190);
3853: l_sec_profile_id:=fnd_profile.value_specific
3854: (name=>'PER_SECURITY_PROFILE_ID'
3855: ,user_id=>l_user_id

Line 3853: l_sec_profile_id:=fnd_profile.value_specific

3849: -- look to see if we are using multiple security groups
3850: --
3851: if (fnd_profile.value('ENABLE_SECURITY_GROUPS')='Y') then
3852: hr_utility.set_location(l_proc,190);
3853: l_sec_profile_id:=fnd_profile.value_specific
3854: (name=>'PER_SECURITY_PROFILE_ID'
3855: ,user_id=>l_user_id
3856: ,responsibility_id=>p_responsibility_id
3857: ,application_id=>p_resp_appl_id);

Line 3858: l_business_group_id2:=fnd_profile.value_specific

3854: (name=>'PER_SECURITY_PROFILE_ID'
3855: ,user_id=>l_user_id
3856: ,responsibility_id=>p_responsibility_id
3857: ,application_id=>p_resp_appl_id);
3858: l_business_group_id2:=fnd_profile.value_specific
3859: (name=>'PER_BUSINESS_GROUP_ID'
3860: ,user_id=>l_user_id
3861: ,responsibility_id=>p_responsibility_id
3862: ,application_id=>p_resp_appl_id);

Line 3925: , fnd_profile.value('IRC_WORKFLOW_ITEM_TYPE')

3921: --
3922: hr_utility.set_location(l_proc,220);
3923:
3924: l_nid:=wf_notification.send( upper(p_current_email_address)
3925: , fnd_profile.value('IRC_WORKFLOW_ITEM_TYPE')
3926: , 'IRC_TEXT_HTML_MSG'
3927: );
3928: --
3929: fnd_message.set_name('PER','IRC_EXEMP_SUBJECT');

Line 4188: l_allow_access := nvl(p_allow_access,nvl(fnd_profile.value('IRC_VISIBLE_PREF_DEFAULT'),'N'));

4184: hr_utility.set_location(l_proc, 20);
4185: --
4186: -- default Allow Access if input value is NULL
4187: --
4188: l_allow_access := nvl(p_allow_access,nvl(fnd_profile.value('IRC_VISIBLE_PREF_DEFAULT'),'N'));
4189: --
4190: open get_person_party_info;
4191: fetch get_person_party_info into l_user_id, l_person_id, l_person_party_id;
4192: close get_person_party_info;

Line 4251: l_profile_check := fnd_profile.save (

4247: ,x_employee_id => l_person_id);
4248: --
4249: hr_utility.set_location(l_proc, 60);
4250: --
4251: l_profile_check := fnd_profile.save (
4252: x_name => 'ICX_LANGUAGE',
4253: x_value => l_nls_language,
4254: x_level_name => 'USER',
4255: x_level_value => l_user_id );

Line 4356: if (fnd_profile.value('ENABLE_SECURITY_GROUPS')='Y') then

4352: hr_utility.set_location(l_proc, 100);
4353: --
4354: -- look to see if we are using multiple security groups
4355: --
4356: if (fnd_profile.value('ENABLE_SECURITY_GROUPS')='Y') then
4357: l_sec_profile_id:=fnd_profile.value_specific
4358: (name=>'PER_SECURITY_PROFILE_ID'
4359: ,user_id=>l_user_id
4360: ,responsibility_id=>p_responsibility_id

Line 4357: l_sec_profile_id:=fnd_profile.value_specific

4353: --
4354: -- look to see if we are using multiple security groups
4355: --
4356: if (fnd_profile.value('ENABLE_SECURITY_GROUPS')='Y') then
4357: l_sec_profile_id:=fnd_profile.value_specific
4358: (name=>'PER_SECURITY_PROFILE_ID'
4359: ,user_id=>l_user_id
4360: ,responsibility_id=>p_responsibility_id
4361: ,application_id=>p_resp_appl_id);

Line 4362: l_business_group_id:=fnd_profile.value_specific

4358: (name=>'PER_SECURITY_PROFILE_ID'
4359: ,user_id=>l_user_id
4360: ,responsibility_id=>p_responsibility_id
4361: ,application_id=>p_resp_appl_id);
4362: l_business_group_id:=fnd_profile.value_specific
4363: (name=>'PER_BUSINESS_GROUP_ID'
4364: ,user_id=>l_user_id
4365: ,responsibility_id=>p_responsibility_id
4366: ,application_id=>p_resp_appl_id);

Line 4400: l_function_name:=fnd_profile.value_specific

4396: -- REVISIT, what about Security Profile Assignment
4397: end if;
4398: --
4399: -- check if User has access to Candidate Homepage function
4400: l_function_name:=fnd_profile.value_specific
4401: (name=>'IRC_HOME_PAGE_FUNCTION'
4402: ,user_id=>l_user_id
4403: ,responsibility_id=>p_responsibility_id
4404: ,application_id=>p_resp_appl_id);

Line 4409: l_menu_name:=fnd_profile.value_specific

4405: l_func_check := fnd_data_security.check_function(1.0,l_function_name,
4406: 'GLOBAL',null,null,null,null,null,upper(p_user_name));
4407: -- if user doesn't have the access, create the Grant
4408: if l_func_check <> 'T' then
4409: l_menu_name:=fnd_profile.value_specific
4410: (name=>'IRC_CANDIDATE_PSET'
4411: ,user_id=>l_user_id
4412: ,responsibility_id=>p_responsibility_id
4413: ,application_id=>p_resp_appl_id);

Line 4552: l_function_name:=fnd_profile.value_specific

4548: return 'NO_PROFILE';
4549: end if;
4550: close get_user_responsibility;
4551: -- check if User has access to Candidate Homepage function
4552: l_function_name:=fnd_profile.value_specific
4553: (name=>'IRC_HOME_PAGE_FUNCTION'
4554: ,user_id=>l_user_id
4555: ,responsibility_id=>p_responsibility_id
4556: ,application_id=>p_resp_appl_id);

Line 4653: l_found := fnd_profile.save(x_name => 'APPS_SSO_LOCAL_LOGIN'

4649: );
4650: hr_utility.set_location(l_proc, 25);
4651: -- fix for bug 4765406
4652: -- set the profile to SSO
4653: l_found := fnd_profile.save(x_name => 'APPS_SSO_LOCAL_LOGIN'
4654: , x_value => 'SSO'
4655: , x_level_name => 'USER'
4656: , x_level_value => l_user_id);
4657:

Line 4754: if (fnd_profile.value('ENABLE_SECURITY_GROUPS')='Y') then

4750: hr_utility.set_location(l_proc, 100);
4751: --
4752: -- look to see if we are using multiple security groups
4753: --
4754: if (fnd_profile.value('ENABLE_SECURITY_GROUPS')='Y') then
4755: l_sec_profile_id:=fnd_profile.value_specific
4756: (name=>'PER_SECURITY_PROFILE_ID'
4757: ,user_id=>p_user_id
4758: ,responsibility_id=>p_responsibility_id

Line 4755: l_sec_profile_id:=fnd_profile.value_specific

4751: --
4752: -- look to see if we are using multiple security groups
4753: --
4754: if (fnd_profile.value('ENABLE_SECURITY_GROUPS')='Y') then
4755: l_sec_profile_id:=fnd_profile.value_specific
4756: (name=>'PER_SECURITY_PROFILE_ID'
4757: ,user_id=>p_user_id
4758: ,responsibility_id=>p_responsibility_id
4759: ,application_id=>p_resp_appl_id);

Line 4760: l_business_group_id:=fnd_profile.value_specific

4756: (name=>'PER_SECURITY_PROFILE_ID'
4757: ,user_id=>p_user_id
4758: ,responsibility_id=>p_responsibility_id
4759: ,application_id=>p_resp_appl_id);
4760: l_business_group_id:=fnd_profile.value_specific
4761: (name=>'PER_BUSINESS_GROUP_ID'
4762: ,user_id=>p_user_id
4763: ,responsibility_id=>p_responsibility_id
4764: ,application_id=>p_resp_appl_id);

Line 4870: if(fnd_profile.value('ENABLE_SECURITY_GROUPS')='Y') then

4866: hr_utility.set_location(l_proc, 100);
4867: --
4868: -- look to see if we are using multiple security groups
4869: --
4870: if(fnd_profile.value('ENABLE_SECURITY_GROUPS')='Y') then
4871: l_sec_profile_id:=fnd_profile.value_specific
4872: (name=>'PER_SECURITY_PROFILE_ID'
4873: ,user_id=>p_user_id
4874: ,responsibility_id=>p_resp_id

Line 4871: l_sec_profile_id:=fnd_profile.value_specific

4867: --
4868: -- look to see if we are using multiple security groups
4869: --
4870: if(fnd_profile.value('ENABLE_SECURITY_GROUPS')='Y') then
4871: l_sec_profile_id:=fnd_profile.value_specific
4872: (name=>'PER_SECURITY_PROFILE_ID'
4873: ,user_id=>p_user_id
4874: ,responsibility_id=>p_resp_id
4875: ,application_id=>p_resp_appl_id);

Line 4876: l_business_group_id:=fnd_profile.value_specific

4872: (name=>'PER_SECURITY_PROFILE_ID'
4873: ,user_id=>p_user_id
4874: ,responsibility_id=>p_resp_id
4875: ,application_id=>p_resp_appl_id);
4876: l_business_group_id:=fnd_profile.value_specific
4877: (name=>'PER_BUSINESS_GROUP_ID'
4878: ,user_id=>p_user_id
4879: ,responsibility_id=>p_resp_id
4880: ,application_id=>p_resp_appl_id);

Line 5012: l_profile_check := fnd_profile.save (

5008: hr_utility.set_location(l_proc,30);
5009: --
5010: -- set the language profile option
5011: --
5012: l_profile_check := fnd_profile.save (
5013: x_name => 'ICX_LANGUAGE',
5014: x_value => p_language,
5015: x_level_name => 'USER',
5016: x_level_value => l_user_id );

Line 5105: l_allow_access := nvl(p_allow_access,nvl(fnd_profile.value('IRC_VISIBLE_PREF_DEFAULT'),'N'));

5101: l_start_date := trunc(p_start_date);
5102: --
5103: -- default Allow Access if input value is NULL
5104: --
5105: l_allow_access := nvl(p_allow_access,nvl(fnd_profile.value('IRC_VISIBLE_PREF_DEFAULT'),'N'));
5106: --
5107: -- Call Before Process User Hook
5108: --
5109: begin