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_REFERRAL_INFO_API dependencies on IRC_REFERRAL_INFO

Line 1: PACKAGE BODY IRC_REFERRAL_INFO_API as

1: PACKAGE BODY IRC_REFERRAL_INFO_API as
2: /* $Header: irirfapi.pkb 120.0.12010000.2 2010/05/19 05:57:45 vmummidi ship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' IRC_REFERRAL_INFO_API.';

2: /* $Header: irirfapi.pkb 120.0.12010000.2 2010/05/19 05:57:45 vmummidi ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' IRC_REFERRAL_INFO_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-------------------------< create_referral_info >--------------------|
10: -- ----------------------------------------------------------------------------

Line 78: irc_referral_info_bk1.create_referral_info_b

74: --
75: -- Call Before Process User Hook
76: --
77: begin
78: irc_referral_info_bk1.create_referral_info_b
79: (p_object_id => p_object_id
80: ,p_object_type => p_object_type
81: ,p_source_type => p_source_type
82: ,p_source_name => p_source_name

Line 182: irc_referral_info_bk1.create_referral_info_a

178: );
179: -- Call After Process User Hook
180: --
181: begin
182: irc_referral_info_bk1.create_referral_info_a
183: (p_referral_info_id => l_referral_info_id
184: ,p_object_id => p_object_id
185: ,p_object_type => p_object_type
186: ,p_source_type => p_source_type

Line 351: irc_referral_info_bk2.update_referral_info_b

347: --
348: -- Call Before Process User Hook
349: --
350: begin
351: irc_referral_info_bk2.update_referral_info_b
352: (p_referral_info_id => p_referral_info_id
353: ,p_source_type => p_source_type
354: ,p_source_name => p_source_name
355: ,p_source_criteria1 => p_source_criteria1

Line 458: irc_referral_info_bk2.update_referral_info_a

454: --
455: -- Call After Process User Hook
456: --
457: begin
458: irc_referral_info_bk2.update_referral_info_a
459: (p_referral_info_id => p_referral_info_id
460: ,p_source_type => p_source_type
461: ,p_source_name => p_source_name
462: ,p_source_criteria1 => p_source_criteria1

Line 564: l_referral_info_id irc_referral_info.referral_info_id%type;

560: -- Declare cursors and local variables
561: --
562: l_proc varchar2(72) := g_package||'copy_referral_details';
563: --
564: l_referral_info_id irc_referral_info.referral_info_id%type;
565: --
566: cursor csr_referral_info is
567: select *
568: from irc_referral_info

Line 568: from irc_referral_info

564: l_referral_info_id irc_referral_info.referral_info_id%type;
565: --
566: cursor csr_referral_info is
567: select *
568: from irc_referral_info
569: where object_id = p_source_assignment_id;
570: --
571: Cursor C_Sel1 is select irc_referral_info_s.nextval from sys.dual;
572: --

Line 571: Cursor C_Sel1 is select irc_referral_info_s.nextval from sys.dual;

567: select *
568: from irc_referral_info
569: where object_id = p_source_assignment_id;
570: --
571: Cursor C_Sel1 is select irc_referral_info_s.nextval from sys.dual;
572: --
573: begin
574: hr_utility.set_location('Entering:'|| l_proc, 10);
575: --

Line 591: insert into irc_referral_info

587: --
588: FOR l_ref_rec in csr_referral_info
589: LOOP
590: --
591: insert into irc_referral_info
592: (referral_info_id
593: ,object_id
594: ,object_type
595: ,start_date

Line 707: end IRC_REFERRAL_INFO_API;

703: hr_utility.set_location(' Leaving:'||l_proc, 40);
704: raise;
705: end copy_referral_details;
706: --
707: end IRC_REFERRAL_INFO_API;