APPS.HR_OTT_BUS dependencies on HR_KI_OPTION_TYPES

Line 104: hr_ki_option_types_tl

100: CURSOR csr_name IS
101: select
102: null
103: from
104: hr_ki_option_types_tl
105: where
106: option_type_id <> p_option_type_id
107: and option_name =p_option_name
108: and language=p_language;

Line 143: (p_associated_column1 => 'HR_KI_OPTION_TYPES_TL.OPTION_NAME'

139:
140: exception
141: when app_exception.application_exception then
142: if hr_multi_message.exception_add
143: (p_associated_column1 => 'HR_KI_OPTION_TYPES_TL.OPTION_NAME'
144: )then
145: hr_utility.set_location(' Leaving:'||l_proc, 50);
146: raise;
147: end if;

Line 169: -- Processing continues if option type id exist in hr_ki_option_types table

165: -- In Arguments:
166: -- p_option_type_id
167: --
168: -- Post Success:
169: -- Processing continues if option type id exist in hr_ki_option_types table
170: --
171: -- Post Failure:
172: -- An application error is raised if id does not exist in hr_ki_option_types
173: --

Line 172: -- An application error is raised if id does not exist in hr_ki_option_types

168: -- Post Success:
169: -- Processing continues if option type id exist in hr_ki_option_types table
170: --
171: -- Post Failure:
172: -- An application error is raised if id does not exist in hr_ki_option_types
173: --
174: -- {End Of Comments}
175: -- ----------------------------------------------------------------------------
176:

Line 194: hr_ki_option_types

190: CURSOR csr_id is
191: select
192: null
193: From
194: hr_ki_option_types
195: where
196: option_type_id = p_option_type_id;
197:
198: Begin

Line 218: (p_associated_column1 => 'HR_KI_OPTION_TYPES_TL.OPTION_TYPE_ID'

214:
215: Exception
216: when app_exception.application_exception then
217: IF hr_multi_message.exception_add
218: (p_associated_column1 => 'HR_KI_OPTION_TYPES_TL.OPTION_TYPE_ID'
219: ) THEN
220: hr_utility.set_location(' Leaving:'|| l_proc,30);
221: raise;
222: END IF;