DBA Data[Home] [Help]

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.3.12010000.12 2008/10/31 13:57:02 vmummidi ship $ */
3: g_qual_party_id number;
4: g_qual_type varchar2(150);
5: g_emp_upt_party_id number;

Line 725: g_internal_email:=irc_utilities_pkg.is_internal_person(l_employee_id

721: fetch get_user into l_employee_id;
722: if get_user%found then
723: close get_user;
724: if l_employee_id is not null then
725: g_internal_email:=irc_utilities_pkg.is_internal_person(l_employee_id
726: ,p_eff_date);
727: end if;
728: else
729: close get_user;

Line 761: g_internal_user:=irc_utilities_pkg.is_internal_person(l_employee_id

757: fetch get_user into l_employee_id;
758: if get_user%found then
759: close get_user;
760: if l_employee_id is not null then
761: g_internal_user:=irc_utilities_pkg.is_internal_person(l_employee_id
762: ,p_eff_date);
763: end if;
764: else
765: close get_user;

Line 1090: END IRC_UTILITIES_PKG;

1086: end if;
1087: close c_AMETxnDetails;
1088: return '';
1089: end;
1090: END IRC_UTILITIES_PKG;