APPS.HR_OTY_BUS dependencies on HR_KI_OPTION_TYPES

Line 106: from hr_ki_option_types

102: l_proc varchar2(72) := g_package || 'CHK_OPTION_TYPE_KEY';
103: l_key varchar2(1) ;
104: cursor csr_key is
105: select null
106: from hr_ki_option_types
107: where option_type_key = p_option_type_key;
108: --
109: Begin
110: hr_utility.set_location('Entering:'||l_proc,10);

Line 135: (p_associated_column1 => 'HR_KI_OPTION_TYPES.OPTION_TYPE_KEY'

131: hr_utility.set_location(' Leaving:'||l_proc,30);
132: exception
133: when app_exception.application_exception then
134: if hr_multi_message.exception_add
135: (p_associated_column1 => 'HR_KI_OPTION_TYPES.OPTION_TYPE_KEY'
136: )then
137: hr_utility.set_location(' Leaving:'||l_proc, 40);
138: raise;
139: end if;

Line 222: (p_associated_column1 => 'HR_KI_OPTION_TYPES.DISPLAY_TYPE'

218: hr_utility.set_location(' Leaving:'||l_proc,30);
219: exception
220: when app_exception.application_exception then
221: if hr_multi_message.exception_add
222: (p_associated_column1 => 'HR_KI_OPTION_TYPES.DISPLAY_TYPE'
223: )then
224: hr_utility.set_location(' Leaving:'||l_proc, 40);
225: raise;
226: end if;

Line 237: -- rows for a record in hr_ki_option_types. The tables that contain child

233: -- {Start Of Comments}
234: --
235: -- Description:
236: -- This procedure ensures that a delete occurs only if there are no child
237: -- rows for a record in hr_ki_option_types. The tables that contain child
238: -- rows are hr_ki_option_types_tl,hr_ki_options.
239: -- Pre Conditions:
240: -- g_rec has been populated with details of the values
241: -- from the ins or the upd procedures

Line 238: -- rows are hr_ki_option_types_tl,hr_ki_options.

234: --
235: -- Description:
236: -- This procedure ensures that a delete occurs only if there are no child
237: -- rows for a record in hr_ki_option_types. The tables that contain child
238: -- rows are hr_ki_option_types_tl,hr_ki_options.
239: -- Pre Conditions:
240: -- g_rec has been populated with details of the values
241: -- from the ins or the upd procedures
242: --

Line 276: from hr_ki_option_types_tl

272: where option_type_id = p_option_type_id ;
273:
274: cursor csr_maintenance_tl is
275: select null
276: from hr_ki_option_types_tl
277: where option_type_id = p_option_type_id ;
278:
279: --
280: begin

Line 310: (p_associated_column1 => 'HR_KI_OPTION_TYPES.option_type_id'

306: hr_utility.set_location(' Leaving:'|| l_proc, 30);
307: exception
308: when app_exception.application_exception then
309: if hr_multi_message.exception_add
310: (p_associated_column1 => 'HR_KI_OPTION_TYPES.option_type_id'
311: ) then
312: hr_utility.set_location(' Leaving:'|| l_proc, 40);
313: raise;
314: end if;