DBA Data[Home] [Help]

APPS.AME_APPROVAL_GROUPS_LOAD_API dependencies on AME_APPROVAL_GROUP_MEMBERS

Line 276: delete from AME_APPROVAL_GROUP_MEMBERS

272: ,X_QUERY_STRING in VARCHAR2
273: )
274: is
275: begin
276: delete from AME_APPROVAL_GROUP_MEMBERS
277: where APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID;
278: insert into AME_APPROVAL_GROUP_MEMBERS
279: (APPROVAL_GROUP_ID
280: ,PARAMETER_NAME

Line 278: insert into AME_APPROVAL_GROUP_MEMBERS

274: is
275: begin
276: delete from AME_APPROVAL_GROUP_MEMBERS
277: where APPROVAL_GROUP_ID = X_APPROVAL_GROUP_ID;
278: insert into AME_APPROVAL_GROUP_MEMBERS
279: (APPROVAL_GROUP_ID
280: ,PARAMETER_NAME
281: ,PARAMETER
282: ,QUERY_STRING

Line 291: update AME_APPROVAL_GROUP_MEMBERS

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