APPS.HR_TPC_BUS dependencies on HR_KI_TOPICS

Line 111: hr_ki_topics tpc

107: CURSOR csr_tpc_key is
108: select
109: distinct 'found'
110: From
111: hr_ki_topics tpc
112: where
113: tpc.topic_key = p_topic_key;
114:
115: -- Variables for API Boolean parameters

Line 146: (p_associated_column1 => 'HR_KI_TOPICS.TOPIC_KEY'

142: hr_utility.set_location(' Leaving:' || l_proc,30);
143: Exception
144: when app_exception.application_exception then
145: IF hr_multi_message.exception_add
146: (p_associated_column1 => 'HR_KI_TOPICS.TOPIC_KEY'
147: ) THEN
148: hr_utility.set_location(' Leaving:'|| l_proc,40);
149: raise;
150: END IF;

Line 195: (p_associated_column1 => 'HR_KI_TOPICS.HANDLER'

191:
192: Exception
193: when app_exception.application_exception then
194: IF hr_multi_message.exception_add
195: (p_associated_column1 => 'HR_KI_TOPICS.HANDLER'
196: ) THEN
197: hr_utility.set_location(' Leaving:'|| l_proc,30);
198: raise;
199: END IF;

Line 213: -- rows for a record in hr_ki_topics. The tables that contain child rows are

209: -- {Start Of Comments}
210: --
211: -- Description:
212: -- This procedure ensures that a delete occurs only if there are no child
213: -- rows for a record in hr_ki_topics. The tables that contain child rows are
214: -- hr_ki_hierarchy_node_maps,hr_ki_topic_integrations,hr_ki_topics_tl.
215:
216: -- Pre Conditions:
217: -- g_rec has been populated with details of the values

Line 214: -- hr_ki_hierarchy_node_maps,hr_ki_topic_integrations,hr_ki_topics_tl.

210: --
211: -- Description:
212: -- This procedure ensures that a delete occurs only if there are no child
213: -- rows for a record in hr_ki_topics. The tables that contain child rows are
214: -- hr_ki_hierarchy_node_maps,hr_ki_topic_integrations,hr_ki_topics_tl.
215:
216: -- Pre Conditions:
217: -- g_rec has been populated with details of the values
218: -- from the ins or the upd procedures

Line 256: hr_ki_topics_tl ttl

252: CURSOR csr_ttl_id is
253: select
254: distinct 'found'
255: From
256: hr_ki_topics_tl ttl
257: where
258: ttl.topic_id = p_topic_id;
259:
260: l_found varchar2(30);

Line 305: (p_associated_column1 => 'HR_KI_TOPICS.TOPIC_ID'

301:
302: Exception
303: when app_exception.application_exception then
304: IF hr_multi_message.exception_add
305: (p_associated_column1 => 'HR_KI_TOPICS.TOPIC_ID'
306: )THEN
307: hr_utility.set_location(' Leaving:'|| l_proc,30);
308: raise;
309: END IF;