[Home] [Help]
146: -- {Start Of Comments}
147: --
148: -- Description:
149: -- This procedure ensures that the topic id entered is present in the
150: -- master table hr_ki_topics if not null.
151:
152: -- Pre Conditions:
153: -- g_rec has been populated with details of the values
154: -- from the ins or the upd procedures
156: -- In Arguments:
157: -- p_topic_id
158:
159: -- Post Success:
160: -- Processing continues if topic id is present in hr_ki_topics
161: --
162: -- Post Failure:
163: -- An application error is raised if topic id does not exist in
164: -- hr_ki_topics.
160: -- Processing continues if topic id is present in hr_ki_topics
161: --
162: -- Post Failure:
163: -- An application error is raised if topic id does not exist in
164: -- hr_ki_topics.
165: --
166: -- {End Of Comments}
167: -- ----------------------------------------------------------------------------
168:
175: CURSOR csr_tpc_id is
176: select
177: 'found'
178: From
179: hr_ki_topics tpc
180: where
181: tpc.topic_id = p_topic_id;
182:
183:
184: begin
185:
186: hr_utility.set_location(' Entering:' || l_proc,10);
187:
188: -- if the topic id is not null, check whether it exists in hr_ki_topics
189: if(p_topic_id is not null)
190: then
191: -- check if the id, key combination exists in the hr_ki_hierarchies
192: open csr_tpc_id;
261: begin
262:
263: hr_utility.set_location(' Entering:' || l_proc,10);
264:
265: -- if the topic id is not null, check whether it exists in hr_ki_topics
266: if(p_user_interface_id is not null)
267: then
268: -- check if the id, key combination exists in the hr_ki_hierarchies
269: open csr_itf_id;