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 392: FROM AME_APPROVAL_GROUPS_TL

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

Line 402: update AME_APPROVAL_GROUPS_TL

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

Line 597: delete from AME_APPROVAL_GROUPS_TL

593: procedure DELETE_ROW (X_APPROVAL_GROUP_ID in NUMBER
594: ) is
595: begin
596: if AME_SEED_UTILITY.MLS_ENABLED then
597: delete from AME_APPROVAL_GROUPS_TL
598: where APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID;
599: end if;
600: delete from AME_APPROVAL_GROUPS
601: where APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID;

Line 632: from AME_APPROVAL_GROUPS_TL AAGTL,

628: into X_CURRENT_OWNER,
629: X_CURRENT_LAST_UPDATE_DATE,
630: X_CREATED_BY,
631: X_APPROVAL_GROUP_ID
632: from AME_APPROVAL_GROUPS_TL AAGTL,
633: AME_APPROVAL_GROUPS AAG
634: where AAG.NAME = X_APPROVAL_GROUP_NAME
635: and sysdate between AAG.START_DATE and nvl(AAG.END_DATE - (1/86400),sysdate)
636: and AAGTL.APPROVAL_GROUP_ID = AAG.APPROVAL_GROUP_ID

Line 645: update AME_APPROVAL_GROUPS_TL AAGTL

641: X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE,
642: X_CURRENT_LAST_UPDATE_DATE => X_CURRENT_LAST_UPDATE_DATE,
643: X_CREATED_BY => X_CREATED_BY,
644: X_CUSTOM_MODE => X_CUSTOM_MODE) then
645: update AME_APPROVAL_GROUPS_TL AAGTL
646: set USER_APPROVAL_GROUP_NAME = nvl(X_USER_APPROVAL_GROUP_NAME,USER_APPROVAL_GROUP_NAME),
647: DESCRIPTION = nvl(X_DESCRIPTION,DESCRIPTION),
648: SOURCE_LANG = userenv('LANG'),
649: LAST_UPDATE_DATE = AME_SEED_UTILITY.DATE_AS_DATE(X_LAST_UPDATE_DATE),