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: ,AME_APPROVAL_GROUP_MEMBERS_S.NEXTVAL

287: ,ame_util.approverOamGroupId
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

Line 293: update AME_APPROVAL_GROUP_MEMBERS

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)
297: and APPROVAL_GROUP_ID <> X_APPROVAL_GROUP_ID;