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
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
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;