APPS.HR_HTL_BUS dependencies on HR_KI_HIERARCHIES

Line 98: -- Cursor to check if there is an entry in hr_ki_hierarchies

94: p_hierarchy_id in number
95: )
96: is
97:
98: -- Cursor to check if there is an entry in hr_ki_hierarchies
99:
100: CURSOR csr_htl_parent is
101: select
102: 'found'

Line 104: hr_ki_hierarchies hrc

100: CURSOR csr_htl_parent is
101: select
102: 'found'
103: From
104: hr_ki_hierarchies hrc
105: where
106: hrc.hierarchy_id = p_hierarchy_id;
107:
108: l_proc varchar2(72) := g_package||'chk_hierarchy_id';

Line 137: (p_associated_column1 => 'HR_KI_HIERARCHIES_TL.HIERARCHY_ID'

133:
134: Exception
135: when app_exception.application_exception then
136: IF hr_multi_message.exception_add
137: (p_associated_column1 => 'HR_KI_HIERARCHIES_TL.HIERARCHY_ID'
138: ) THEN
139: hr_utility.set_location(' Leaving:'|| l_proc,30);
140: raise;
141: END IF;

Line 180: -- Cursor to check if there is an entry in hr_ki_hierarchies

176: )
177: is
178: -- Declare cursors and local variables
179: --
180: -- Cursor to check if there is an entry in hr_ki_hierarchies
181:
182: CURSOR csr_htl_name is
183: select
184: 'found'

Line 186: hr_ki_hierarchies_tl htl

182: CURSOR csr_htl_name is
183: select
184: 'found'
185: From
186: hr_ki_hierarchies_tl htl
187: where
188: htl.language = p_language and
189: htl.name = p_name and
190: htl.hierarchy_id <> p_hierarchy_id;

Line 221: (p_associated_column1 => 'HR_KI_HIERARCHIES_TL.NAME'

217:
218: Exception
219: when app_exception.application_exception then
220: IF hr_multi_message.exception_add
221: (p_associated_column1 => 'HR_KI_HIERARCHIES_TL.NAME'
222: ) THEN
223: hr_utility.set_location(' Leaving:'|| l_proc,30);
224: raise;
225: END IF;