APPS.AME_APPROVAL_GROUPS_LOAD_API dependencies on AME_APPROVAL_GROUPS_TL

Line 85: insert into AME_APPROVAL_GROUPS_TL

81: if not AME_SEED_UTILITY.MLS_ENABLED then
82: return;
83: end if;
84:
85: insert into AME_APPROVAL_GROUPS_TL
86: (APPROVAL_GROUP_ID
87: ,USER_APPROVAL_GROUP_NAME
88: ,DESCRIPTION
89: ,CREATED_BY

Line 109: from AME_APPROVAL_GROUPS_TL T

105: userenv('LANG')
106: from FND_LANGUAGES L
107: where L.INSTALLED_FLAG in ('I', 'B')
108: and not exists (select null
109: from AME_APPROVAL_GROUPS_TL T
110: where T.APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID
111: and T.LANGUAGE = L.LANGUAGE_CODE);
112: END INSERT_TL_ROW;
113:

Line 390: FROM AME_APPROVAL_GROUPS_TL

386: select LAST_UPDATED_BY,
387: LAST_UPDATE_DATE
388: into X_CURRENT_OWNER,
389: X_CURRENT_LAST_UPDATE_DATE
390: FROM AME_APPROVAL_GROUPS_TL
391: WHERE APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID
392: AND LANGUAGE = USERENV('LANG');
393:
394: if DO_UPDATE_INSERT

Line 400: update AME_APPROVAL_GROUPS_TL

396: ,X_CURRENT_OWNER
397: ,AME_SEED_UTILITY.DATE_AS_STRING(X_LAST_UPDATE_DATE)
398: ,AME_SEED_UTILITY.DATE_AS_STRING(X_CURRENT_LAST_UPDATE_DATE)
399: ,X_CUSTOM_MODE) then
400: update AME_APPROVAL_GROUPS_TL
401: set USER_APPROVAL_GROUP_NAME = nvl(X_USER_APPROVAL_GROUP_NAME,USER_APPROVAL_GROUP_NAME),
402: DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
403: SOURCE_LANG = userenv('LANG'),
404: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 589: delete from AME_APPROVAL_GROUPS_TL

585: procedure DELETE_ROW (X_APPROVAL_GROUP_ID in NUMBER
586: ) is
587: begin
588: if AME_SEED_UTILITY.MLS_ENABLED then
589: delete from AME_APPROVAL_GROUPS_TL
590: where APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID;
591: end if;
592: delete from AME_APPROVAL_GROUPS
593: where APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID;

Line 624: from AME_APPROVAL_GROUPS_TL AAGTL,

620: into X_CURRENT_OWNER,
621: X_CURRENT_LAST_UPDATE_DATE,
622: X_CREATED_BY,
623: X_APPROVAL_GROUP_ID
624: from AME_APPROVAL_GROUPS_TL AAGTL,
625: AME_APPROVAL_GROUPS AAG
626: where AAG.NAME = X_APPROVAL_GROUP_NAME
627: and sysdate between AAG.START_DATE and nvl(AAG.END_DATE - (1/86400),sysdate)
628: and AAGTL.APPROVAL_GROUP_ID = AAG.APPROVAL_GROUP_ID

Line 637: update AME_APPROVAL_GROUPS_TL AAGTL

633: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
634: X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE,
635: X_CREATED_BY => X_CREATED_BY,
636: X_CUSTOM_MODE => X_CUSTOM_MODE) then
637: update AME_APPROVAL_GROUPS_TL AAGTL
638: set USER_APPROVAL_GROUP_NAME = nvl(X_USER_APPROVAL_GROUP_NAME,USER_APPROVAL_GROUP_NAME),
639: DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
640: SOURCE_LANG = userenv('LANG'),
641: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(X_LAST_UPDATE_DATE),