APPS.HR_TIS_BUS dependencies on HR_KI_TOPICS

Line 148: -- This procedure ensures topic_id is present in hr_ki_topics

144: -- ----------------------------------------------------------------------------
145: -- {Start Of Comments}
146: --
147: -- Description:
148: -- This procedure ensures topic_id is present in hr_ki_topics
149: -- and it is mandatory.
150: -- Pre Conditions:
151: -- g_old_rec has been populated with details of the values currently in
152: -- the database.

Line 171: l_key hr_ki_topics.topic_id%type;

167: (p_topic_id in number
168: ) IS
169: --
170: l_proc varchar2(72) := g_package || 'chk_topic_id';
171: l_key hr_ki_topics.topic_id%type;
172: cursor csr_int is
173: select topic_id
174: from hr_ki_topics
175: where topic_id = p_topic_id;

Line 174: from hr_ki_topics

170: l_proc varchar2(72) := g_package || 'chk_topic_id';
171: l_key hr_ki_topics.topic_id%type;
172: cursor csr_int is
173: select topic_id
174: from hr_ki_topics
175: where topic_id = p_topic_id;
176: --
177: Begin
178: hr_utility.set_location('Entering:'||l_proc,10);