APPS.AME_CALLING_APPS_API dependencies on AME_CALLING_APPS_TL

Line 341: insert into AME_CALLING_APPS_TL

337: if not AME_SEED_UTILITY.MLS_ENABLED then
338: return;
339: end if;
340:
341: insert into AME_CALLING_APPS_TL
342: (APPLICATION_ID
343: ,APPLICATION_NAME
344: ,CREATED_BY
345: ,CREATION_DATE

Line 363: from AME_CALLING_APPS_TL T

359: userenv('LANG')
360: from FND_LANGUAGES L
361: where L.INSTALLED_FLAG in ('I', 'B')
362: and not exists (select null
363: from AME_CALLING_APPS_TL T
364: where T.APPLICATION_ID = X_APPLICATION_ID
365: and T.LANGUAGE = L.LANGUAGE_CODE);
366: END insert_tl_row;
367:

Line 388: FROM AME_CALLING_APPS_TL

384: select LAST_UPDATED_BY,
385: LAST_UPDATE_DATE
386: into X_CURRENT_OWNER,
387: X_CURRENT_LAST_UPDATE_DATE
388: FROM AME_CALLING_APPS_TL
389: WHERE APPLICATION_ID = X_APPLICATION_ID
390: AND LANGUAGE = USERENV('LANG');
391:
392: if DO_UPDATE_INSERT

Line 398: update AME_CALLING_APPS_TL

394: ,X_CURRENT_OWNER
395: ,AME_SEED_UTILITY.DATE_AS_STRING(X_LAST_UPDATE_DATE)
396: ,AME_SEED_UTILITY.DATE_AS_STRING(X_CURRENT_LAST_UPDATE_DATE)
397: ,X_CUSTOM_MODE) then
398: update AME_CALLING_APPS_TL
399: set APPLICATION_NAME = nvl(X_APPLICATION_NAME,APPLICATION_NAME),
400: SOURCE_LANG = userenv('LANG'),
401: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
402: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 442: delete from AME_CALLING_APPS_TL

438: X_APPLICATION_ID in NUMBER
439: ) is
440: begin
441: if AME_SEED_UTILITY.MLS_ENABLED then
442: delete from AME_CALLING_APPS_TL
443: where APPLICATION_ID in (select APPLICATION_ID
444: from AME_CALLING_APPS
445: where FND_APPLICATION_ID = X_FND_APPLICATION_ID
446: and nvl(TRANSACTION_TYPE_ID,'NULL') = nvl(X_TRANSACTION_TYPE_ID,'NULL'));

Line 1071: from AME_CALLING_APPS_TL ACATL,

1067: into X_CURRENT_OWNER,
1068: X_CURRENT_LAST_UPDATE_DATE,
1069: X_CREATED_BY,
1070: X_APPLICATION_ID
1071: from AME_CALLING_APPS_TL ACATL,
1072: AME_CALLING_APPS ACA,
1073: FND_APPLICATION_VL FAV
1074: where FAV.APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
1075: and FAV.APPLICATION_ID = ACA.FND_APPLICATION_ID

Line 1088: update AME_CALLING_APPS_TL ACATL

1084: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
1085: X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE,
1086: X_CREATED_BY => X_CREATED_BY,
1087: X_CUSTOM_MODE => X_CUSTOM_MODE) then
1088: update AME_CALLING_APPS_TL ACATL
1089: set APPLICATION_NAME = nvl(X_APPLICATION_NAME,APPLICATION_NAME),
1090: SOURCE_LANG = userenv('LANG'),
1091: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(X_LAST_UPDATE_DATE),
1092: LAST_UPDATED_BY = AME_SEED_UTILITY.OWNER_AS_INTEGER(X_OWNER),