APPS.AME_CAL_SHD dependencies on AME_CALLING_APPS

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

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

48: application_id
49: ,language
50: ,source_lang
51: ,application_name
52: from ame_calling_apps_tl
53: where application_id = p_application_id
54: and language = p_language;
55: --
56: l_fct_ret boolean;

Line 118: from ame_calling_apps_tl

114: application_id
115: ,language
116: ,source_lang
117: ,application_name
118: from ame_calling_apps_tl
119: where application_id = p_application_id
120: and language = p_language
121: for update nowait;
122: --

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

Line 181: delete from AME_CALLING_APPS_TL T

177: -- ----------------------------------------------------------------------------
178: PROCEDURE add_language IS
179: Begin
180: --
181: delete from AME_CALLING_APPS_TL T
182: where not exists
183: (select NULL
184: from AME_CALLING_APPS B
185: where B.APPLICATION_ID = T.APPLICATION_ID

Line 184: from AME_CALLING_APPS B

180: --
181: delete from AME_CALLING_APPS_TL T
182: where not exists
183: (select NULL
184: from AME_CALLING_APPS B
185: where B.APPLICATION_ID = T.APPLICATION_ID
186: );
187:
188: update AME_CALLING_APPS_TL T set (

Line 188: update AME_CALLING_APPS_TL T set (

184: from AME_CALLING_APPS B
185: where B.APPLICATION_ID = T.APPLICATION_ID
186: );
187:
188: update AME_CALLING_APPS_TL T set (
189: APPLICATION_NAME
190: ) = (select
191: B.APPLICATION_NAME
192: from AME_CALLING_APPS_TL B

Line 192: from AME_CALLING_APPS_TL B

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

Line 201: from AME_CALLING_APPS_TL SUBB, AME_CALLING_APPS_TL SUBT

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

Line 207: insert into AME_CALLING_APPS_TL (

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

Line 227: from AME_CALLING_APPS_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_CALLING_APPS_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_CALLING_APPS_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_CALLING_APPS_TL T
233: where T.APPLICATION_ID = B.APPLICATION_ID
234: and T.LANGUAGE = L.LANGUAGE_CODE);
235: --
236: End add_language;