APPS.OTA_CATALOG_UTIL dependencies on HR_UTILITY

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

38: l_proc Varchar2(72) := g_package||'Get_Forum_Topic_Count';
39: --
40: Begin
41: --
42: hr_utility.set_location('Entering:'|| l_proc, 10);
43: --
44: Open cur_forum_topics;
45: Fetch cur_forum_topics into l_thread_count;
46: Close cur_forum_topics;

Line 48: hr_utility.set_location('Returning:'|| l_proc, 20);

44: Open cur_forum_topics;
45: Fetch cur_forum_topics into l_thread_count;
46: Close cur_forum_topics;
47: --
48: hr_utility.set_location('Returning:'|| l_proc, 20);
49: --
50: return l_thread_count;
51: --
52: End Get_Forum_Topic_Count;

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

97: l_proc Varchar2(72) := g_package||'Get_Forum_Message_Count';
98: --
99: Begin
100: --
101: hr_utility.set_location('Entering:'|| l_proc, 10);
102: --
103: Open cur_forum_messages;
104: Fetch cur_forum_messages into l_message_count;
105: Close cur_forum_messages;

Line 107: hr_utility.set_location('Returning:'|| l_proc, 20);

103: Open cur_forum_messages;
104: Fetch cur_forum_messages into l_message_count;
105: Close cur_forum_messages;
106: --
107: hr_utility.set_location('Returning:'|| l_proc, 20);
108: --
109: Return l_message_count;
110: --
111: End Get_Forum_Message_Count;

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

135: l_proc Varchar2(72) := g_package||'Get_Forum_Last_Post_Date';
136: --
137: Begin
138: --
139: hr_utility.set_location('Entering:'|| l_proc, 10);
140: --
141: Open cur_forum_last_post_date;
142: Fetch cur_forum_last_post_date into l_message_last_post_date;
143: Close cur_forum_last_post_date;

Line 145: hr_utility.set_location('Returning:'|| l_proc, 20);

141: Open cur_forum_last_post_date;
142: Fetch cur_forum_last_post_date into l_message_last_post_date;
143: Close cur_forum_last_post_date;
144: --
145: hr_utility.set_location('Returning:'|| l_proc, 20);
146: --
147: Return l_message_last_post_date;
148: --
149: End Get_Forum_Last_Post_Date;