APPS.AME_ACTION_TYPES_API dependencies on AME_ACTION_TYPES_TL

Line 151: insert into AME_ACTION_TYPES_TL

147: begin
148: if not AME_SEED_UTILITY.MLS_ENABLED then
149: return;
150: end if;
151: insert into AME_ACTION_TYPES_TL
152: (ACTION_TYPE_ID
153: ,USER_ACTION_TYPE_NAME
154: ,DESCRIPTION
155: ,CREATED_BY

Line 175: from AME_ACTION_TYPES_TL T

171: userenv('LANG')
172: from FND_LANGUAGES L
173: where L.INSTALLED_FLAG in ('I', 'B')
174: and not exists (select null
175: from AME_ACTION_TYPES_TL T
176: where T.ACTION_TYPE_ID = X_ACTION_TYPE_ID
177: and T.LANGUAGE = L.LANGUAGE_CODE);
178: END INSERT_TL_ROW;
179:

Line 200: FROM AME_ACTION_TYPES_TL

196: select LAST_UPDATED_BY,
197: LAST_UPDATE_DATE
198: into X_CURRENT_OWNER,
199: X_CURRENT_LAST_UPDATE_DATE
200: FROM AME_ACTION_TYPES_TL
201: WHERE ACTION_TYPE_ID = X_ACTION_TYPE_ID
202: AND LANGUAGE = USERENV('LANG');
203:
204: if DO_UPDATE_INSERT

Line 210: update AME_ACTION_TYPES_TL

206: ,X_CURRENT_OWNER
207: ,AME_SEED_UTILITY.DATE_AS_STRING(X_LAST_UPDATE_DATE)
208: ,AME_SEED_UTILITY.DATE_AS_STRING(X_CURRENT_LAST_UPDATE_DATE)
209: ,X_CUSTOM_MODE) then
210: update AME_ACTION_TYPES_TL
211: set USER_ACTION_TYPE_NAME = nvl(X_USER_ACTION_TYPE_NAME,USER_ACTION_TYPE_NAME),
212: DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
213: SOURCE_LANG = userenv('LANG'),
214: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 274: delete from AME_ACTION_TYPES_TL

270: X_ACTION_TYPE_ID in NUMBER
271: ) is
272: begin
273: if AME_SEED_UTILITY.MLS_ENABLED then
274: delete from AME_ACTION_TYPES_TL
275: where ACTION_TYPE_ID = X_ACTION_TYPE_ID;
276: end if;
277: delete from AME_ACTION_TYPES
278: where ACTION_TYPE_ID = X_ACTION_TYPE_ID;

Line 467: from AME_ACTION_TYPES_TL AATTL,

463: into X_CURRENT_OWNER,
464: X_CURRENT_LAST_UPDATE_DATE,
465: X_CURRENT_CREATED_BY,
466: X_ACTION_TYPE_ID
467: from AME_ACTION_TYPES_TL AATTL,
468: AME_ACTION_TYPES AAT
469: where AAT.NAME = X_ACTION_TYPE_NAME
470: and AAT.ACTION_TYPE_ID = AATTL.ACTION_TYPE_ID
471: and sysdate between AAT.START_DATE and nvl(AAT.END_DATE - (1/86400),sysdate)

Line 481: update AME_ACTION_TYPES_TL AATTL

477: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
478: X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE,
479: X_CURRENT_CREATED_BY => X_CURRENT_CREATED_BY,
480: X_CUSTOM_MODE => X_CUSTOM_MODE) then
481: update AME_ACTION_TYPES_TL AATTL
482: set USER_ACTION_TYPE_NAME = nvl(X_USER_ACTION_TYPE_NAME,USER_ACTION_TYPE_NAME),
483: DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
484: SOURCE_LANG = userenv('LANG'),
485: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(X_LAST_UPDATE_DATE),