APPS.HR_OTT_SHD dependencies on HR_KI_OPTION_TYPES

Line 21: If (p_constraint_name = 'HR_KI_OPTION_TYPES_TL_PK') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'HR_KI_OPTION_TYPES_TL_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;

Line 52: from hr_ki_option_types_tl

48: option_type_id
49: ,option_name
50: ,language
51: ,source_lang
52: from hr_ki_option_types_tl
53: where
54: option_type_id = p_option_type_id
55: and language = p_language;
56: --

Line 119: from hr_ki_option_types_tl

115: option_type_id
116: ,option_name
117: ,language
118: ,source_lang
119: from hr_ki_option_types_tl
120: where
121: option_type_id = p_option_type_id and language = p_language
122: for update nowait;
123: --

Line 165: fnd_message.set_token('TABLE_NAME', 'hr_ki_option_types_tl');

161: -- The object is locked therefore we need to supply a meaningful
162: -- error message.
163: --
164: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
165: fnd_message.set_token('TABLE_NAME', 'hr_ki_option_types_tl');
166: fnd_message.raise_error;
167: End lck;
168: --
169: -- ----------------------------------------------------------------------------

Line 177: delete from HR_KI_OPTION_TYPES_TL T

173:
174: procedure ADD_LANGUAGE
175: is
176: begin
177: delete from HR_KI_OPTION_TYPES_TL T
178: where not exists
179: (select NULL
180: from HR_KI_OPTION_TYPES B
181: where B.OPTION_TYPE_ID = T.OPTION_TYPE_ID

Line 180: from HR_KI_OPTION_TYPES B

176: begin
177: delete from HR_KI_OPTION_TYPES_TL T
178: where not exists
179: (select NULL
180: from HR_KI_OPTION_TYPES B
181: where B.OPTION_TYPE_ID = T.OPTION_TYPE_ID
182: );
183:
184: update HR_KI_OPTION_TYPES_TL T set (

Line 184: update HR_KI_OPTION_TYPES_TL T set (

180: from HR_KI_OPTION_TYPES B
181: where B.OPTION_TYPE_ID = T.OPTION_TYPE_ID
182: );
183:
184: update HR_KI_OPTION_TYPES_TL T set (
185: OPTION_NAME
186: ) = (select
187: B.OPTION_NAME
188: from HR_KI_OPTION_TYPES_TL B

Line 188: from HR_KI_OPTION_TYPES_TL B

184: update HR_KI_OPTION_TYPES_TL T set (
185: OPTION_NAME
186: ) = (select
187: B.OPTION_NAME
188: from HR_KI_OPTION_TYPES_TL B
189: where B.OPTION_TYPE_ID = T.OPTION_TYPE_ID
190: and B.LANGUAGE = T.SOURCE_LANG)
191: where (
192: T.OPTION_TYPE_ID,

Line 197: from HR_KI_OPTION_TYPES_TL SUBB, HR_KI_OPTION_TYPES_TL SUBT

193: T.LANGUAGE
194: ) in (select
195: SUBT.OPTION_TYPE_ID,
196: SUBT.LANGUAGE
197: from HR_KI_OPTION_TYPES_TL SUBB, HR_KI_OPTION_TYPES_TL SUBT
198: where SUBB.OPTION_TYPE_ID = SUBT.OPTION_TYPE_ID
199: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
200: and (SUBB.OPTION_NAME <> SUBT.OPTION_NAME
201: ));

Line 203: insert into HR_KI_OPTION_TYPES_TL (

199: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
200: and (SUBB.OPTION_NAME <> SUBT.OPTION_NAME
201: ));
202:
203: insert into HR_KI_OPTION_TYPES_TL (
204: OPTION_TYPE_ID,
205: OPTION_NAME,
206: LAST_UPDATE_DATE,
207: LAST_UPDATED_BY,

Line 223: from HR_KI_OPTION_TYPES_TL B, FND_LANGUAGES L

219: B.CREATED_BY,
220: B.CREATION_DATE,
221: L.LANGUAGE_CODE,
222: B.SOURCE_LANG
223: from HR_KI_OPTION_TYPES_TL B, FND_LANGUAGES L
224: where L.INSTALLED_FLAG in ('I', 'B')
225: and B.LANGUAGE = userenv('LANG')
226: and not exists
227: (select NULL

Line 228: from HR_KI_OPTION_TYPES_TL T

224: where L.INSTALLED_FLAG in ('I', 'B')
225: and B.LANGUAGE = userenv('LANG')
226: and not exists
227: (select NULL
228: from HR_KI_OPTION_TYPES_TL T
229: where T.OPTION_TYPE_ID = B.OPTION_TYPE_ID
230: and T.LANGUAGE = L.LANGUAGE_CODE);
231: end ADD_LANGUAGE;
232: