APPS.AME_ITEM_CLASSES_API dependencies on AME_ITEM_CLASSES_TL

Line 156: insert into AME_ITEM_CLASSES_TL

152: if not AME_SEED_UTILITY.MLS_ENABLED then
153: return;
154: end if;
155:
156: insert into AME_ITEM_CLASSES_TL
157: (ITEM_CLASS_ID
158: ,USER_ITEM_CLASS_NAME
159: ,CREATED_BY
160: ,CREATION_DATE

Line 178: from AME_ITEM_CLASSES_TL T

174: userenv('LANG')
175: from FND_LANGUAGES L
176: where L.INSTALLED_FLAG in ('I', 'B')
177: and not exists (select null
178: from AME_ITEM_CLASSES_TL T
179: where T.ITEM_CLASS_ID = X_ITEM_CLASS_ID
180: and T.LANGUAGE = L.LANGUAGE_CODE);
181: END INSERT_TL_ROW;
182:

Line 203: FROM AME_ITEM_CLASSES_TL

199: select LAST_UPDATED_BY,
200: LAST_UPDATE_DATE
201: into X_CURRENT_OWNER,
202: X_CURRENT_LAST_UPDATE_DATE
203: FROM AME_ITEM_CLASSES_TL
204: WHERE ITEM_CLASS_ID = X_ITEM_CLASS_ID
205: AND LANGUAGE = USERENV('LANG');
206:
207: if DO_UPDATE_INSERT

Line 213: update AME_ITEM_CLASSES_TL

209: ,X_CURRENT_OWNER
210: ,AME_SEED_UTILITY.DATE_AS_STRING(X_LAST_UPDATE_DATE)
211: ,AME_SEED_UTILITY.DATE_AS_STRING(X_CURRENT_LAST_UPDATE_DATE)
212: ,X_CUSTOM_MODE) then
213: update AME_ITEM_CLASSES_TL
214: set USER_ITEM_CLASS_NAME = nvl(X_USER_ITEM_CLASS_NAME,USER_ITEM_CLASS_NAME),
215: SOURCE_LANG = userenv('LANG'),
216: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
217: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 267: delete from AME_ITEM_CLASSES_TL

263: X_ITEM_CLASS_ID in NUMBER
264: ) is
265: begin
266: if AME_SEED_UTILITY.MLS_ENABLED then
267: delete from AME_ITEM_CLASSES_TL
268: where ITEM_CLASS_ID = X_ITEM_CLASS_ID;
269: end if;
270: delete from AME_ITEM_CLASSES
271: where ITEM_CLASS_ID = X_ITEM_CLASS_ID;

Line 439: from AME_ITEM_CLASSES_TL AICTL,

435: into X_CURRENT_OWNER,
436: X_CURRENT_LAST_UPDATE_DATE,
437: X_CREATED_BY,
438: L_ITEM_CLASS_ID
439: from AME_ITEM_CLASSES_TL AICTL,
440: AME_ITEM_CLASSES AIC
441: where AICTL.ITEM_CLASS_ID = AIC.ITEM_CLASS_ID
442: and AIC.NAME = X_ITEM_CLASS_NAME
443: and sysdate between AIC.START_DATE and nvl(AIC.END_DATE - (1/86400),sysdate)

Line 453: update AME_ITEM_CLASSES_TL AICTL

449: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
450: X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE,
451: X_CREATED_BY => X_CREATED_BY,
452: X_CUSTOM_MODE => X_CUSTOM_MODE) then
453: update AME_ITEM_CLASSES_TL AICTL
454: set USER_ITEM_CLASS_NAME = nvl(X_USER_ITEM_CLASS_NAME,AICTL.USER_ITEM_CLASS_NAME),
455: SOURCE_LANG = userenv('LANG'),
456: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(X_LAST_UPDATE_DATE),
457: LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),