DBA Data[Home] [Help]

APPS.AME_APPROVAL_GROUPS_LOAD_API dependencies on DUAL

Line 33: from sys.dual;

29: begin
30: if (X_APPROVAL_GROUP_ID is null) then
31: select ame_approval_groups_s.nextval
32: into X_APPROVAL_GROUP_ID
33: from sys.dual;
34: end if;
35: insert into AME_APPROVAL_GROUPS
36: (APPROVAL_GROUP_ID
37: ,NAME

Line 63: from sys.dual

59: ,X_START_DATE
60: ,AME_SEED_UTILITY.GET_DEFAULT_END_DATE
61: ,X_DESCRIPTION
62: ,X_OBJECT_VERSION_NUMBER
63: from sys.dual
64: where not exists (select NULL
65: from AME_APPROVAL_GROUPS
66: where NAME = X_NAME
67: and sysdate between START_DATE

Line 292: from sys.dual;

288: ,X_APPROVAL_GROUP_ID
289: ,X_QUERY_STRING
290: ,1
291: ,AME_APPROVAL_GROUP_MEMBERS_S.NEXTVAL
292: from sys.dual;
293: update AME_APPROVAL_GROUP_MEMBERS
294: set QUERY_STRING = X_QUERY_STRING
295: where PARAMETER_NAME = ame_util.approverOamGroupId
296: and PARAMETER = to_char(X_APPROVAL_GROUP_ID)

Line 366: from sys.dual;

362: ,X_LAST_UPDATE_LOGIN
363: ,X_START_DATE
364: ,null
365: ,1
366: from sys.dual;
367: end loop;
368: end if;
369: end CREATE_APPROVAL_CONFIG;
370: