APPS.HR_TTL_BUS dependencies on HR_KI_TOPICS

Line 102: -- Cursor to check if there is an entry in hr_ki_topics

98: )
99: is
100: -- Declare cursors and local variables
101: --
102: -- Cursor to check if there is an entry in hr_ki_topics
103:
104: CURSOR csr_ttl_parent is
105: select
106: 'found'

Line 108: hr_ki_topics tpc

104: CURSOR csr_ttl_parent is
105: select
106: 'found'
107: From
108: hr_ki_topics tpc
109: where
110: tpc.topic_id = p_topic_id;
111:
112: l_proc varchar2(72) := g_package||'chk_topic_id';

Line 141: (p_associated_column1 => 'HR_KI_TOPICS_TL.TOPIC_ID'

137:
138: Exception
139: when app_exception.application_exception then
140: IF hr_multi_message.exception_add
141: (p_associated_column1 => 'HR_KI_TOPICS_TL.TOPIC_ID'
142: ) THEN
143: hr_utility.set_location(' Leaving:'|| l_proc,30);
144: raise;
145: END IF;

Line 192: hr_ki_topics_tl ttl

188: CURSOR csr_ttl_name is
189: select
190: 'found'
191: From
192: hr_ki_topics_tl ttl
193: where
194: ttl.language = p_language and
195: ttl.name = p_name and
196: ttl.topic_id <> p_topic_id;

Line 227: (p_associated_column1 => 'HR_KI_TOPICS_TL.NAME'

223:
224: Exception
225: when app_exception.application_exception then
226: IF hr_multi_message.exception_add
227: (p_associated_column1 => 'HR_KI_TOPICS_TL.NAME'
228: ) THEN
229: hr_utility.set_location(' Leaving:'|| l_proc,30);
230: raise;
231: END IF;