DBA Data[Home] [Help]

APPS.IRC_CANDIDATE_TEST dependencies on HR_UTILITY

Line 44: hr_utility.set_location(' Entering: '||l_proc, 10);

40: l_dummy number;
41: l_candidate boolean :=false;
42: l_proc varchar2(72) := g_package||'is_person_a_candidate';
43: begin
44: hr_utility.set_location(' Entering: '||l_proc, 10);
45: open c_party;
46: fetch c_party into l_party_id;
47: close c_party;
48: if l_party_id is null then

Line 49: hr_utility.set_location(l_proc, 20);

45: open c_party;
46: fetch c_party into l_party_id;
47: close c_party;
48: if l_party_id is null then
49: hr_utility.set_location(l_proc, 20);
50: open c_person;
51: fetch c_person into l_dummy;
52: if c_person%found then
53: close c_person;

Line 59: hr_utility.set_location(l_proc, 30);

55: else
56: close c_person;
57: end if;
58: else
59: hr_utility.set_location(l_proc, 30);
60: open c_person_party;
61: fetch c_person_party into l_dummy;
62: if c_person_party%found then
63: close c_person_party;

Line 69: hr_utility.set_location(' Leaving: '||l_proc, 20);

65: else
66: close c_person_party;
67: end if;
68: end if;
69: hr_utility.set_location(' Leaving: '||l_proc, 20);
70: return l_candidate;
71: end is_person_a_candidate;
72: end irc_candidate_test;