APPS.AME_ATL_SHD dependencies on AME_ATTRIBUTES

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

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

48: attribute_id
49: ,language
50: ,source_lang
51: ,description
52: from ame_attributes_tl
53: where attribute_id = p_attribute_id
54: and language = p_language;
55: --
56: l_fct_ret boolean;

Line 118: from ame_attributes_tl

114: attribute_id
115: ,language
116: ,source_lang
117: ,description
118: from ame_attributes_tl
119: where attribute_id = p_attribute_id
120: and language = p_language
121: for update nowait;
122: --

Line 164: fnd_message.set_token('TABLE_NAME', 'ame_attributes_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_attributes_tl');
165: fnd_message.raise_error;
166: End lck;
167: --
168: -- ----------------------------------------------------------------------------

Line 180: delete from AME_ATTRIBUTES_TL T

176: --
177: -- ----------------------------------------------------------------------------
178: PROCEDURE add_language IS
179: Begin
180: delete from AME_ATTRIBUTES_TL T
181: where not exists
182: (select NULL
183: from AME_ATTRIBUTES B
184: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID

Line 183: from AME_ATTRIBUTES B

179: Begin
180: delete from AME_ATTRIBUTES_TL T
181: where not exists
182: (select NULL
183: from AME_ATTRIBUTES B
184: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
185: );
186:
187: update AME_ATTRIBUTES_TL T set (

Line 187: update AME_ATTRIBUTES_TL T set (

183: from AME_ATTRIBUTES B
184: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
185: );
186:
187: update AME_ATTRIBUTES_TL T set (
188: DESCRIPTION
189: ) = (select
190: B.DESCRIPTION
191: from AME_ATTRIBUTES_TL B

Line 191: from AME_ATTRIBUTES_TL B

187: update AME_ATTRIBUTES_TL T set (
188: DESCRIPTION
189: ) = (select
190: B.DESCRIPTION
191: from AME_ATTRIBUTES_TL B
192: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
193: and B.LANGUAGE = T.SOURCE_LANG)
194: where (
195: T.ATTRIBUTE_ID,

Line 200: from AME_ATTRIBUTES_TL SUBB, AME_ATTRIBUTES_TL SUBT

196: T.LANGUAGE
197: ) in (select
198: SUBT.ATTRIBUTE_ID,
199: SUBT.LANGUAGE
200: from AME_ATTRIBUTES_TL SUBB, AME_ATTRIBUTES_TL SUBT
201: where SUBB.ATTRIBUTE_ID = SUBT.ATTRIBUTE_ID
202: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
203: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
204: ));

Line 206: insert into AME_ATTRIBUTES_TL (

202: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
203: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
204: ));
205:
206: insert into AME_ATTRIBUTES_TL (
207: ATTRIBUTE_ID,
208: DESCRIPTION,
209: CREATED_BY,
210: CREATION_DATE,

Line 226: from AME_ATTRIBUTES_TL B, FND_LANGUAGES L

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

Line 231: from AME_ATTRIBUTES_TL T

227: where L.INSTALLED_FLAG in ('I', 'B')
228: and B.LANGUAGE = userenv('LANG')
229: and not exists
230: (select NULL
231: from AME_ATTRIBUTES_TL T
232: where T.ATTRIBUTE_ID = B.ATTRIBUTE_ID
233: and T.LANGUAGE = L.LANGUAGE_CODE);
234: End;
235: --