APPS.AME_ACL_SHD dependencies on AME_ACTIONS

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

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

48: action_id
49: ,language
50: ,source_lang
51: ,description
52: from ame_actions_tl
53: where action_id = p_action_id
54: and language = p_language;
55: --
56: l_fct_ret boolean;

Line 118: from ame_actions_tl

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

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

Line 181: delete from AME_ACTIONS_TL T

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

Line 184: from AME_ACTIONS B

180: begin
181: delete from AME_ACTIONS_TL T
182: where not exists
183: (select NULL
184: from AME_ACTIONS B
185: where B.ACTION_ID = T.ACTION_ID
186: );
187:
188: update AME_ACTIONS_TL T set (

Line 188: update AME_ACTIONS_TL T set (

184: from AME_ACTIONS B
185: where B.ACTION_ID = T.ACTION_ID
186: );
187:
188: update AME_ACTIONS_TL T set (
189: DESCRIPTION
190: ) = (select
191: B.DESCRIPTION
192: from AME_ACTIONS_TL B

Line 192: from AME_ACTIONS_TL B

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

Line 201: from AME_ACTIONS_TL SUBB, AME_ACTIONS_TL SUBT

197: T.LANGUAGE
198: ) in (select
199: SUBT.ACTION_ID,
200: SUBT.LANGUAGE
201: from AME_ACTIONS_TL SUBB, AME_ACTIONS_TL SUBT
202: where SUBB.ACTION_ID = SUBT.ACTION_ID
203: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
204: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
205: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 209: insert into AME_ACTIONS_TL (

205: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
206: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
207: ));
208:
209: insert into AME_ACTIONS_TL (
210: ACTION_ID,
211: DESCRIPTION,
212: CREATED_BY,
213: CREATION_DATE,

Line 229: from AME_ACTIONS_TL B, FND_LANGUAGES L

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

Line 234: from AME_ACTIONS_TL T

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