APPS.IGW_PROP_SPECIAL_REVIEWS_PKG SQL Statements

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

Line: 3

procedure INSERT_ROW (
  X_ROWID in out VARCHAR2,
  X_PROPOSAL_ID in NUMBER,
  X_SPECIAL_REVIEW_CODE in VARCHAR2,
  X_SPECIAL_REVIEW_TYPE in VARCHAR2,
  X_APPROVAL_TYPE_CODE in VARCHAR2,
  X_PROTOCOL_NUMBER in VARCHAR2,
  X_APPLICATION_DATE in DATE,
  X_APPROVAL_DATE in DATE,
  X_COMMENTS in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) is
    cursor C is select ROWID from IGW_PROP_SPECIAL_REVIEWS
      where PROPOSAL_ID = X_PROPOSAL_ID
      AND   SPECIAL_REVIEW_CODE = X_SPECIAL_REVIEW_CODE;

Line: 19

    X_LAST_UPDATE_DATE DATE;

Line: 20

    X_LAST_UPDATED_BY NUMBER;

Line: 21

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 23

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 25

    X_LAST_UPDATED_BY := 1;

Line: 26

    X_LAST_UPDATE_LOGIN := 0;

Line: 28

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 29

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 32

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 33

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 40

  insert into IGW_PROP_SPECIAL_REVIEWS (
    PROPOSAL_ID,
    SPECIAL_REVIEW_CODE,
    SPECIAL_REVIEW_TYPE,
    APPROVAL_TYPE_CODE,
    PROTOCOL_NUMBER,
    APPLICATION_DATE,
    APPROVAL_DATE,
    COMMENTS,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    X_PROPOSAL_ID,
    X_SPECIAL_REVIEW_CODE,
    X_SPECIAL_REVIEW_TYPE,
    X_APPROVAL_TYPE_CODE,
    X_PROTOCOL_NUMBER,
    X_APPLICATION_DATE,
    X_APPROVAL_DATE,
    X_COMMENTS,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 78

end INSERT_ROW;

Line: 91

  cursor c1 is select
      SPECIAL_REVIEW_CODE,
      SPECIAL_REVIEW_TYPE,
      APPROVAL_TYPE_CODE,
      PROTOCOL_NUMBER,
      APPLICATION_DATE,
      APPROVAL_DATE,
      COMMENTS
    from IGW_PROP_SPECIAL_REVIEWS
    where ROWID = X_ROWID
    for update of PROPOSAL_ID nowait;

Line: 141

procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_PROPOSAL_ID in NUMBER,
  X_SPECIAL_REVIEW_CODE in VARCHAR2,
  X_SPECIAL_REVIEW_TYPE in VARCHAR2,
  X_APPROVAL_TYPE_CODE in VARCHAR2,
  X_PROTOCOL_NUMBER in VARCHAR2,
  X_APPLICATION_DATE in DATE,
  X_APPROVAL_DATE in DATE,
  X_COMMENTS in VARCHAR2,
  X_MODE in VARCHAR2 default 'R'
  ) is
    X_LAST_UPDATE_DATE DATE;

Line: 154

    X_LAST_UPDATED_BY NUMBER;

Line: 155

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 157

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 159

    X_LAST_UPDATED_BY := 1;

Line: 160

    X_LAST_UPDATE_LOGIN := 0;

Line: 162

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 163

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 166

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 167

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 174

  update IGW_PROP_SPECIAL_REVIEWS set
    SPECIAL_REVIEW_CODE = X_SPECIAL_REVIEW_CODE,
    SPECIAL_REVIEW_TYPE = X_SPECIAL_REVIEW_TYPE,
    APPROVAL_TYPE_CODE = X_APPROVAL_TYPE_CODE,
    PROTOCOL_NUMBER = X_PROTOCOL_NUMBER,
    APPLICATION_DATE = X_APPLICATION_DATE,
    APPROVAL_DATE = X_APPROVAL_DATE,
    COMMENTS = X_COMMENTS,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
    where ROWID = X_ROWID
  ;

Line: 190

end UPDATE_ROW;

Line: 204

  cursor c1 is select rowid from IGW_PROP_SPECIAL_REVIEWS
     where PROPOSAL_ID = X_PROPOSAL_ID
     and   SPECIAL_REVIEW_CODE = X_SPECIAL_REVIEW_CODE
  ;

Line: 214

    INSERT_ROW (
     X_ROWID,
     X_PROPOSAL_ID,
     X_SPECIAL_REVIEW_CODE,
     X_SPECIAL_REVIEW_TYPE,
     X_APPROVAL_TYPE_CODE,
     X_PROTOCOL_NUMBER,
     X_APPLICATION_DATE,
     X_APPROVAL_DATE,
     X_COMMENTS,
     X_MODE);

Line: 228

  UPDATE_ROW (
   X_ROWID,
   X_PROPOSAL_ID,
   X_SPECIAL_REVIEW_CODE,
   X_SPECIAL_REVIEW_TYPE,
   X_APPROVAL_TYPE_CODE,
   X_PROTOCOL_NUMBER,
   X_APPLICATION_DATE,
   X_APPROVAL_DATE,
   X_COMMENTS,
   X_MODE);

Line: 241

procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) is
begin
  delete from IGW_PROP_SPECIAL_REVIEWS
  where ROWID = X_ROWID;

Line: 250

end DELETE_ROW;