APPS.AME_ACTIONS_API dependencies on AME_ACTIONS_TL

Line 203: insert into AME_ACTIONS_TL

199: begin
200: if not AME_SEED_UTILITY.MLS_ENABLED then
201: return;
202: end if;
203: insert into AME_ACTIONS_TL
204: (ACTION_ID
205: ,DESCRIPTION
206: ,CREATED_BY
207: ,CREATION_DATE

Line 225: from AME_ACTIONS_TL T

221: userenv('LANG')
222: from FND_LANGUAGES L
223: where L.INSTALLED_FLAG in ('I', 'B')
224: and not exists (select null
225: from AME_ACTIONS_TL T
226: where T.ACTION_ID = X_ACTION_ID
227: and T.LANGUAGE = L.LANGUAGE_CODE);
228: END insert_tl_row;
229:

Line 250: FROM AME_ACTIONS_TL

246: select LAST_UPDATED_BY,
247: LAST_UPDATE_DATE
248: into X_CURRENT_OWNER,
249: X_CURRENT_LAST_UPDATE_DATE
250: FROM AME_ACTIONS_TL
251: WHERE ACTION_ID = X_ACTION_ID
252: AND LANGUAGE = USERENV('LANG');
253:
254: if DO_UPDATE_INSERT

Line 260: update AME_ACTIONS_TL

256: ,X_CURRENT_OWNER
257: ,AME_SEED_UTILITY.DATE_AS_STRING(X_LAST_UPDATE_DATE)
258: ,AME_SEED_UTILITY.DATE_AS_STRING(X_CURRENT_LAST_UPDATE_DATE)
259: ,X_CUSTOM_MODE) then
260: update AME_ACTIONS_TL
261: set DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
262: SOURCE_LANG = userenv('LANG'),
263: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
264: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 315: delete from AME_ACTIONS_TL

311: X_ACTION_ID in NUMBER
312: ) is
313: begin
314: if AME_SEED_UTILITY.MLS_ENABLED then
315: delete from AME_ACTIONS_TL
316: where ACTION_ID = X_ACTION_ID;
317: end if;
318: delete from AME_ACTIONS
319: where ACTION_ID = X_ACTION_ID;

Line 532: from AME_ACTIONS_TL ACTTL,

528: into X_CURRENT_OWNER,
529: X_CURRENT_LAST_UPDATE_DATE,
530: X_CREATED_BY,
531: X_ACTION_ID
532: from AME_ACTIONS_TL ACTTL,
533: AME_ACTIONS ACT,
534: AME_ACTION_TYPES AAT
535: where AAT.NAME = X_ACTION_TYPE_NAME
536: and AAT.ACTION_TYPE_ID = ACT.ACTION_TYPE_ID

Line 564: update AME_ACTIONS_TL ACTTL

560: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
561: X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE,
562: X_CREATED_BY => X_CREATED_BY,
563: X_CUSTOM_MODE => X_CUSTOM_MODE) then
564: update AME_ACTIONS_TL ACTTL
565: set DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
566: SOURCE_LANG = userenv('LANG'),
567: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(X_LAST_UPDATE_DATE),
568: LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),