APPS.AME_ITL_SHD dependencies on AME_ITEM_CLASSES_TL

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'AME_ITEM_CLASSES_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 ame_item_classes_tl

48: item_class_id
49: ,language
50: ,source_lang
51: ,user_item_class_name
52: from ame_item_classes_tl
53: where item_class_id = p_item_class_id
54: and language = p_language;
55: --
56: l_fct_ret boolean;

Line 118: from ame_item_classes_tl

114: item_class_id
115: ,language
116: ,source_lang
117: ,user_item_class_name
118: from ame_item_classes_tl
119: where item_class_id = p_item_class_id
120: and language = p_language
121: for update nowait;
122: --

Line 164: fnd_message.set_token('TABLE_NAME', 'ame_item_classes_tl');

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

Line 181: delete from AME_ITEM_CLASSES_TL T

177: -- ----------------------------------------------------------------------------
178: procedure ADD_LANGUAGE
179: is
180: begin
181: delete from AME_ITEM_CLASSES_TL T
182: where not exists
183: (select NULL
184: from AME_ITEM_CLASSES B
185: where B.ITEM_CLASS_ID = T.ITEM_CLASS_ID

Line 188: update AME_ITEM_CLASSES_TL T set (

184: from AME_ITEM_CLASSES B
185: where B.ITEM_CLASS_ID = T.ITEM_CLASS_ID
186: );
187:
188: update AME_ITEM_CLASSES_TL T set (
189: USER_ITEM_CLASS_NAME
190: ) = (select
191: B.USER_ITEM_CLASS_NAME
192: from AME_ITEM_CLASSES_TL B

Line 192: from AME_ITEM_CLASSES_TL B

188: update AME_ITEM_CLASSES_TL T set (
189: USER_ITEM_CLASS_NAME
190: ) = (select
191: B.USER_ITEM_CLASS_NAME
192: from AME_ITEM_CLASSES_TL B
193: where B.ITEM_CLASS_ID = T.ITEM_CLASS_ID
194: and B.LANGUAGE = T.SOURCE_LANG)
195: where (
196: T.ITEM_CLASS_ID,

Line 201: from AME_ITEM_CLASSES_TL SUBB, AME_ITEM_CLASSES_TL SUBT

197: T.LANGUAGE
198: ) in (select
199: SUBT.ITEM_CLASS_ID,
200: SUBT.LANGUAGE
201: from AME_ITEM_CLASSES_TL SUBB, AME_ITEM_CLASSES_TL SUBT
202: where SUBB.ITEM_CLASS_ID = SUBT.ITEM_CLASS_ID
203: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
204: and (SUBB.USER_ITEM_CLASS_NAME <> SUBT.USER_ITEM_CLASS_NAME
205: ));

Line 207: insert into AME_ITEM_CLASSES_TL (

203: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
204: and (SUBB.USER_ITEM_CLASS_NAME <> SUBT.USER_ITEM_CLASS_NAME
205: ));
206:
207: insert into AME_ITEM_CLASSES_TL (
208: ITEM_CLASS_ID,
209: USER_ITEM_CLASS_NAME,
210: CREATED_BY,
211: CREATION_DATE,

Line 227: from AME_ITEM_CLASSES_TL B, FND_LANGUAGES L

223: B.LAST_UPDATE_DATE,
224: B.LAST_UPDATE_LOGIN,
225: L.LANGUAGE_CODE,
226: B.SOURCE_LANG
227: from AME_ITEM_CLASSES_TL B, FND_LANGUAGES L
228: where L.INSTALLED_FLAG in ('I', 'B')
229: and B.LANGUAGE = userenv('LANG')
230: and not exists
231: (select NULL

Line 232: from AME_ITEM_CLASSES_TL T

228: where L.INSTALLED_FLAG in ('I', 'B')
229: and B.LANGUAGE = userenv('LANG')
230: and not exists
231: (select NULL
232: from AME_ITEM_CLASSES_TL T
233: where T.ITEM_CLASS_ID = B.ITEM_CLASS_ID
234: and T.LANGUAGE = L.LANGUAGE_CODE);
235: end ADD_LANGUAGE;
236: --