APPS.IRC_UTILITIES_PKG dependencies on IRC_UTILITIES_PKG

Line 1: PACKAGE BODY IRC_UTILITIES_PKG AS

1: PACKAGE BODY IRC_UTILITIES_PKG AS
2: /* $Header: irutil.pkb 120.59.12020000.5 2013/02/20 05:40:26 pshreera ship $ */
3: g_qual_party_id number;
4: g_qual_type varchar2(150);
5: g_emp_upt_party_id number;

Line 740: g_internal_email:=irc_utilities_pkg.is_internal_person(l_employee_id

736: fetch get_user into l_employee_id;
737: if get_user%found then
738: close get_user;
739: if l_employee_id is not null then
740: g_internal_email:=irc_utilities_pkg.is_internal_person(l_employee_id
741: ,p_eff_date);
742: end if;
743: else
744: close get_user;

Line 776: g_internal_user:=irc_utilities_pkg.is_internal_person(l_employee_id

772: fetch get_user into l_employee_id;
773: if get_user%found then
774: close get_user;
775: if l_employee_id is not null then
776: g_internal_user:=irc_utilities_pkg.is_internal_person(l_employee_id
777: ,p_eff_date);
778: end if;
779: else
780: close get_user;

Line 1123: l_proc varchar2(72) := 'irc_utilities_pkg.copy_candidate_address';

1119: l_addr_id number;
1120: l_party_id number;
1121: l_object_version_number number;
1122: l_return_status varchar2(30);
1123: l_proc varchar2(72) := 'irc_utilities_pkg.copy_candidate_address';
1124: l_addr_found boolean := false;
1125: --
1126: Cursor C_Assignment_details is
1127: select person_id

Line 1288: l_proc varchar2(72) := 'irc_utilities_pkg.copy_candidate_address';

1284: -- ----------------------------------------------------------------------------
1285: --
1286: procedure copy_candidate_details
1287: (p_assignment_id in number) is
1288: l_proc varchar2(72) := 'irc_utilities_pkg.copy_candidate_address';
1289: begin
1290: hr_utility.set_location('Entering: '||l_proc, 5);
1291: copy_candidate_address(p_assignment_id);
1292: hr_utility.set_location('Leaving: '||l_proc, 5);

Line 1392: l_proc varchar2(72) := 'irc_utilities_pkg.get_fte_factor';

1388: l_organization_id NUMBER;
1389: l_business_group_id NUMBER;
1390: l_effective_date DATE;
1391: l_fte_factor NUMBER := NULL;
1392: l_proc varchar2(72) := 'irc_utilities_pkg.get_fte_factor';
1393: BEGIN
1394: hr_utility.set_location('Entering: '||l_proc, 5);
1395: If(NVL(p_assignment_id,0) <> 0 ) then
1396: open csr_orgdetails;

Line 1561: irc_utilities_pkg.getVacancyRunFunctionUrl('|| l_funcId||',

1557: query:='SELECT PAV.NAME title ,
1558: fnd_message.get_string(''PER'',''IRC_412594_RSS_JOB_TITLE'')||'' ''||IPC.JOB_TITLE ||''
''|| fnd_message.get_string(''PER'',''IRC_412595_RSS_ORGANIZATION'')||'' ''||IPC.ORG_NAME||
1559: ''
''|| fnd_message.get_string(''PER'',''IRC_412596_RSS_DESCRIPTION'')||'' ''||IPC.BRIEF_DESCRIPTION description ,
1560: to_char( trunc(pra.date_start),''Dy, DD Mon YYYY'') pubDate,
1561: irc_utilities_pkg.getVacancyRunFunctionUrl('|| l_funcId||',
1562: pav.vacancy_id,
1563: pav.primary_posting_id,
1564: 1) rlink
1565: FROM HR_LOOKUPS HRL,

Line 2500: END IRC_UTILITIES_PKG;

2496:
2497: return l_doc_name;
2498: end get_Appl_Doc_Name;
2499:
2500: END IRC_UTILITIES_PKG;