APPS.AMS_APPROVERS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 3

procedure INSERT_ROW (
  X_ROWID in OUT NOCOPY VARCHAR2,
  X_APPROVER_ID in NUMBER,
  X_SEEDED_FLAG in VARCHAR2,
  X_ACTIVE_FLAG in VARCHAR2,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  --X_SECURITY_GROUP_ID in NUMBER,
  X_AMS_APPROVAL_DETAIL_ID in NUMBER,
  X_APPROVER_SEQ in NUMBER,
  X_APPROVER_TYPE in VARCHAR2,
  X_OBJECT_APPROVER_ID in NUMBER,
  X_NOTIFICATION_TYPE in VARCHAR2,
  X_NOTIFICATION_TIMEOUT in NUMBER,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  insert into AMS_APPROVERS (
    SEEDED_FLAG,
    ACTIVE_FLAG,
    START_DATE_ACTIVE,
    END_DATE_ACTIVE,
    APPROVER_ID,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_LOGIN,
    OBJECT_VERSION_NUMBER,
    --SECURITY_GROUP_ID,
    AMS_APPROVAL_DETAIL_ID,
    APPROVER_SEQ,
    APPROVER_TYPE,
    OBJECT_APPROVER_ID,
    NOTIFICATION_TYPE,
    NOTIFICATION_TIMEOUT
  ) values (
    X_SEEDED_FLAG,
    nvl(X_ACTIVE_FLAG, 'Y'),
    X_START_DATE_ACTIVE,
    X_END_DATE_ACTIVE,
    X_APPROVER_ID,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_CREATION_DATE,
    X_CREATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_OBJECT_VERSION_NUMBER,
    --X_SECURITY_GROUP_ID,
    X_AMS_APPROVAL_DETAIL_ID,
    X_APPROVER_SEQ,
    X_APPROVER_TYPE,
    X_OBJECT_APPROVER_ID,
    X_NOTIFICATION_TYPE,
    X_NOTIFICATION_TIMEOUT
    );

Line: 65

end INSERT_ROW;

Line: 82

  cursor c1 is select
      SEEDED_FLAG,
      ACTIVE_FLAG,
      START_DATE_ACTIVE,
      END_DATE_ACTIVE,
      OBJECT_VERSION_NUMBER,
      --SECURITY_GROUP_ID,
      AMS_APPROVAL_DETAIL_ID,
      APPROVER_SEQ,
      APPROVER_TYPE,
      OBJECT_APPROVER_ID,
      NOTIFICATION_TYPE,
      NOTIFICATION_TIMEOUT,
      APPROVER_ID
    from AMS_APPROVERS
    where APPROVER_ID = X_APPROVER_ID
    for update of APPROVER_ID nowait;

Line: 135

procedure UPDATE_ROW (
  X_APPROVER_ID in NUMBER,
  X_SEEDED_FLAG in VARCHAR2,
  X_ACTIVE_FLAG in VARCHAR2,
  X_START_DATE_ACTIVE in DATE,
  X_END_DATE_ACTIVE in DATE,
  X_OBJECT_VERSION_NUMBER in NUMBER,
 -- X_SECURITY_GROUP_ID in NUMBER,
  X_AMS_APPROVAL_DETAIL_ID in NUMBER,
  X_APPROVER_SEQ in NUMBER,
  X_APPROVER_TYPE in VARCHAR2,
  X_OBJECT_APPROVER_ID in NUMBER,
  X_NOTIFICATION_TYPE in VARCHAR2,
  X_NOTIFICATION_TIMEOUT in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update AMS_APPROVERS set
    SEEDED_FLAG = X_SEEDED_FLAG,
    ACTIVE_FLAG = nvl(X_ACTIVE_FLAG, 'Y'),
    START_DATE_ACTIVE = X_START_DATE_ACTIVE,
    END_DATE_ACTIVE = X_END_DATE_ACTIVE,
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    --SECURITY_GROUP_ID = X_SECURITY_GROUP_ID,
    AMS_APPROVAL_DETAIL_ID = X_AMS_APPROVAL_DETAIL_ID,
    APPROVER_SEQ = X_APPROVER_SEQ,
    APPROVER_TYPE = X_APPROVER_TYPE,
    OBJECT_APPROVER_ID = X_OBJECT_APPROVER_ID,
    NOTIFICATION_TYPE = X_NOTIFICATION_TYPE,
    NOTIFICATION_TIMEOUT = X_NOTIFICATION_TIMEOUT,
    APPROVER_ID = X_APPROVER_ID,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where APPROVER_ID = X_APPROVER_ID;

Line: 176

end UPDATE_ROW;

Line: 178

procedure DELETE_ROW (
  X_APPROVER_ID in NUMBER
) is
begin
  delete from AMS_APPROVERS
  where APPROVER_ID = X_APPROVER_ID;

Line: 189

end DELETE_ROW;

Line: 214

  select object_version_number
  from    AMS_APPROVERS
  where  approver_id =  X_APPROVER_ID;

Line: 219

  select 'x'
  from    AMS_APPROVERS
  where  approver_id =  X_APPROVER_ID;

Line: 224

  select AMS_APPROVERS_S.nextval
  from dual;

Line: 246

       AMS_APPROVERS_PKG.INSERT_ROW(
	    X_ROWID  => l_row_id,
	    X_APPROVER_ID => l_approver_id,
	    X_SEEDED_FLAG => X_SEEDED_FLAG,
	    X_ACTIVE_FLAG => X_ACTIVE_FLAG,
	    X_START_DATE_ACTIVE => X_START_DATE_ACTIVE,
	    X_END_DATE_ACTIVE => X_END_DATE_ACTIVE,
	    X_OBJECT_VERSION_NUMBER => l_obj_verno,
	    --X_SECURITY_GROUP_ID => X_SECURITY_GROUP_ID,
	    X_AMS_APPROVAL_DETAIL_ID => X_AMS_APPROVAL_DETAIL_ID,
	    X_APPROVER_SEQ => X_APPROVER_SEQ,
	    X_APPROVER_TYPE => X_APPROVER_TYPE,
	    X_OBJECT_APPROVER_ID => X_OBJECT_APPROVER_ID,
	    X_NOTIFICATION_TYPE => X_NOTIFICATION_TYPE,
	    X_NOTIFICATION_TIMEOUT => X_NOTIFICATION_TYPE,
	    X_CREATION_DATE => SYSDATE,
	    X_CREATED_BY => l_user_id,
	    X_LAST_UPDATE_DATE => SYSDATE,
	    X_LAST_UPDATED_BY => l_user_id,
	    X_LAST_UPDATE_LOGIN => 0
	    );

Line: 274

       AMS_APPROVERS_PKG.UPDATE_ROW(
	     X_APPROVER_ID => l_approver_id,
	     X_SEEDED_FLAG => X_SEEDED_FLAG,
	     X_ACTIVE_FLAG => X_ACTIVE_FLAG,
	     X_START_DATE_ACTIVE => X_START_DATE_ACTIVE,
	     X_END_DATE_ACTIVE => X_END_DATE_ACTIVE,
	     X_OBJECT_VERSION_NUMBER => X_OBJECT_VERSION_NUMBER,
	     --X_SECURITY_GROUP_ID => X_SECURITY_GROUP_ID,
	     X_AMS_APPROVAL_DETAIL_ID => X_AMS_APPROVAL_DETAIL_ID,
	     X_APPROVER_SEQ => X_APPROVER_SEQ,
	     X_APPROVER_TYPE => X_APPROVER_TYPE,
	     X_OBJECT_APPROVER_ID => X_OBJECT_APPROVER_ID,
	     X_NOTIFICATION_TYPE => X_NOTIFICATION_TYPE,
	     X_NOTIFICATION_TIMEOUT => X_NOTIFICATION_TIMEOUT,
	     X_LAST_UPDATE_DATE => SYSDATE,
	     X_LAST_UPDATED_BY => l_user_id,
	     X_LAST_UPDATE_LOGIN => 0
	   );