eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_AS_ASSESSMNT_ITM_PKG SQL Statements

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

Line: 52


    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL,
    -- anilk, bug#2784198
    x_closed_ind IN VARCHAR2 DEFAULT NULL
  ) as

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_AS_ASSESSMNT_ITM_ALL
      WHERE    rowid = x_rowid;

Line: 72


    IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
      Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line: 121


    IF (p_action = 'UPDATE') THEN
      new_references.creation_date := old_references.creation_date;

Line: 128


    new_references.last_update_date := x_last_update_date;

Line: 129


    new_references.last_updated_by := x_last_updated_by;

Line: 130


    new_references.last_update_login := x_last_update_login;

Line: 143


  PROCEDURE BeforeRowInsertUpdate1(
    p_inserting IN BOOLEAN DEFAULT FALSE,
    p_updating IN BOOLEAN DEFAULT FALSE,
    p_deleting IN BOOLEAN DEFAULT FALSE
    ) as
  v_message_name  varchar2(30);

Line: 151


  IF  p_inserting THEN
      -- 
      -- Validate assessment type closed indicator
      IF  IGS_AS_VAL_AI.assp_val_atyp_closed(new_references.assessment_type,
             v_message_name) = FALSE THEN
                     Fnd_Message.Set_Name('IGS', v_message_name);

Line: 162


  IF  p_inserting OR p_updating THEN
      -- 
      -- Validate the approp. ass item details set and are not set for the
      -- respective assessment type examinable indicator setting
      IF  IGS_AS_VAL_AI.assp_val_ai_details(new_references.assessment_type,
            new_references.exam_scheduled_ind,
            new_references.exam_working_time,
            new_references.exam_announcements,
            new_references.exam_short_paper_name,
            new_references.exam_paper_name,
            new_references.exam_perusal_time,
            new_references.exam_supervisor_instrctn,
            new_references.exam_allowable_instrctn,
            new_references.exam_non_allowed_instrctn,
            new_references.exam_supplied_instrctn,
            new_references.question_or_title,
            new_references.ass_length_or_duration,
            v_message_name) = FALSE THEN
                     Fnd_Message.Set_Name('IGS', v_message_name);

Line: 197


  END BeforeRowInsertUpdate1;

Line: 205


  PROCEDURE AfterRowUpdate2(
    p_inserting IN BOOLEAN DEFAULT FALSE,
    p_updating IN BOOLEAN DEFAULT FALSE,
    p_deleting IN BOOLEAN DEFAULT FALSE
    ) as

  v_message_name  varchar2(30);

Line: 233


  END AfterRowUpdate2;

Line: 252


     Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line: 339


      SELECT   rowid
      FROM     IGS_AS_ASSESSMNT_ITM_ALL
      WHERE    ass_id = x_ass_id;

Line: 364


      SELECT   rowid
      FROM     IGS_AS_ASSESSMNT_ITM_ALL
      WHERE    assessment_type = x_assessment_type ;

Line: 429


    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL,
    -- anilk, bug#2784198
    x_closed_ind IN VARCHAR2 DEFAULT NULL

  ) as
  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_org_id,
      x_ass_id,
      x_assessment_type,
      x_description,
      x_exam_scheduled_ind,
      x_exam_working_time,
      x_exam_announcements,
      x_exam_short_paper_name,
      x_exam_paper_name,
      x_exam_perusal_time,
      x_exam_supervisor_instrctn,
      x_exam_allowable_instrctn,
      x_exam_non_allowed_instrctn,
      x_exam_supplied_instrctn,
      x_question_or_title,
      x_ass_length_or_duration,
      x_comments,
      x_exam_constraints,
      x_attribute_category,
      x_attribute1,
      x_attribute2,
      x_attribute3,
      x_attribute4,
      x_attribute5,
      x_attribute6,
      x_attribute7,
      x_attribute8,
      x_attribute9,
      x_attribute10,
      x_attribute11,
      x_attribute12,
      x_attribute13,
      x_attribute14,
      x_attribute15,
      x_attribute16,
      x_attribute17,
      x_attribute18,
      x_attribute19,
      x_attribute20,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      -- anilk, bug#2784198
      x_closed_ind

    );

Line: 490


    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
      BeforeRowInsertUpdate1 ( p_inserting => TRUE );

Line: 503


    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to Before Update.
      BeforeRowInsertUpdate1 ( p_updating => TRUE );

Line: 508


    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to Before Delete.
      Null;

Line: 512


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
IF  Get_PK_For_Validation (
             new_references.ass_id
       ) THEN
Fnd_Message.Set_Name ('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');

Line: 521


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
          Check_Constraints;

Line: 523


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
              Check_Child_Existance;

Line: 531


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_ORG_ID in NUMBER,
  X_ASS_ID in NUMBER,
  X_ASSESSMENT_TYPE in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_EXAM_SHORT_PAPER_NAME in VARCHAR2,
  X_EXAM_PAPER_NAME in VARCHAR2,
  X_EXAM_WORKING_TIME in DATE,
  X_EXAM_PERUSAL_TIME in DATE,
  X_EXAM_SCHEDULED_IND in VARCHAR2,
  X_EXAM_SUPERVISOR_INSTRCTN in VARCHAR2,
  X_EXAM_ANNOUNCEMENTS in VARCHAR2,
  X_EXAM_ALLOWABLE_INSTRCTN in VARCHAR2,
  X_EXAM_NON_ALLOWED_INSTRCTN in VARCHAR2,
  X_EXAM_SUPPLIED_INSTRCTN in VARCHAR2,
  X_EXAM_CONSTRAINTS in VARCHAR2,
  X_QUESTION_OR_TITLE in VARCHAR2,
  X_ASS_LENGTH_OR_DURATION in VARCHAR2,
  X_COMMENTS in VARCHAR2,
  x_attribute_category IN VARCHAR2,
  x_attribute1 IN VARCHAR2,
  x_attribute2 IN VARCHAR2,
  x_attribute3 IN VARCHAR2,
  x_attribute4 IN VARCHAR2,
  x_attribute5 IN VARCHAR2,
  x_attribute6 IN VARCHAR2,
  x_attribute7 IN VARCHAR2,
  x_attribute8 IN VARCHAR2,
  x_attribute9 IN VARCHAR2,
  x_attribute10 IN VARCHAR2,
  x_attribute11 IN VARCHAR2,
  x_attribute12 IN VARCHAR2,
  x_attribute13 IN VARCHAR2,
  x_attribute14 IN VARCHAR2,
  x_attribute15 IN VARCHAR2,
  x_attribute16 IN VARCHAR2,
  x_attribute17 IN VARCHAR2,
  x_attribute18 IN VARCHAR2,
  x_attribute19 IN VARCHAR2,
  x_attribute20 IN VARCHAR2,
  X_MODE in VARCHAR2 default 'R',
  -- anilk, bug#2784198
  x_closed_ind IN VARCHAR2
  ) as
    cursor C is select ROWID from IGS_AS_ASSESSMNT_ITM_all
      where ASS_ID = X_ASS_ID;

Line: 578


    X_LAST_UPDATE_DATE DATE;

Line: 579


    X_LAST_UPDATED_BY NUMBER;

Line: 580


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 582


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 584


    X_LAST_UPDATED_BY := 1;

Line: 585


    X_LAST_UPDATE_LOGIN := 0;

Line: 587


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 588


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 591


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 592


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 601


 p_action=>'INSERT',
 x_rowid=>X_ROWID,
 x_org_id => igs_ge_gen_003.get_org_id,
 x_ass_id=>X_ASS_ID,
 x_ass_length_or_duration=>X_ASS_LENGTH_OR_DURATION,
 x_assessment_type=>X_ASSESSMENT_TYPE,
 x_comments=>X_COMMENTS,
 x_description=>X_DESCRIPTION,
 x_exam_allowable_instrctn=>X_EXAM_ALLOWABLE_INSTRCTN,
 x_exam_announcements=>X_EXAM_ANNOUNCEMENTS,
 x_exam_constraints=>X_EXAM_CONSTRAINTS,
 x_exam_non_allowed_instrctn=>X_EXAM_NON_ALLOWED_INSTRCTN,
 x_exam_paper_name=>X_EXAM_PAPER_NAME,
 x_exam_perusal_time=>X_EXAM_PERUSAL_TIME,
 x_exam_scheduled_ind=>X_EXAM_SCHEDULED_IND,
 x_exam_short_paper_name=>X_EXAM_SHORT_PAPER_NAME,
 x_exam_supervisor_instrctn=>X_EXAM_SUPERVISOR_INSTRCTN,
 x_exam_supplied_instrctn=>X_EXAM_SUPPLIED_INSTRCTN,
 x_exam_working_time=>X_EXAM_WORKING_TIME,
 x_question_or_title=>X_QUESTION_OR_TITLE,
 x_attribute_category=>x_attribute_category,
 x_attribute1=>x_attribute1,
 x_attribute2=>x_attribute2,
 x_attribute3=>x_attribute3,
 x_attribute4=>x_attribute4,
 x_attribute5=>x_attribute5,
 x_attribute6=>x_attribute6,
 x_attribute7=>x_attribute7,
 x_attribute8=>x_attribute8,
 x_attribute9=>x_attribute9,
 x_attribute10=>x_attribute10,
 x_attribute11=>x_attribute11,
 x_attribute12=>x_attribute12,
 x_attribute13=>x_attribute13,
 x_attribute14=>x_attribute14,
 x_attribute15=>x_attribute15,
 x_attribute16=>x_attribute16,
 x_attribute17=>x_attribute17,
 x_attribute18=>x_attribute18,
 x_attribute19=>x_attribute19,
 x_attribute20=>x_attribute20,
 x_creation_date=>X_LAST_UPDATE_DATE,
 x_created_by=>X_LAST_UPDATED_BY,
 x_last_update_date=>X_LAST_UPDATE_DATE,
 x_last_updated_by=>X_LAST_UPDATED_BY,
 x_last_update_login=>X_LAST_UPDATE_LOGIN,
 -- anilk, bug#2784198
 x_closed_ind => x_closed_ind

 );

Line: 651


  insert into IGS_AS_ASSESSMNT_ITM_ALL (
     ORG_ID,
    ASS_ID,
    ASSESSMENT_TYPE,
    DESCRIPTION,
    EXAM_SHORT_PAPER_NAME,
    EXAM_PAPER_NAME,
    EXAM_WORKING_TIME,
    EXAM_PERUSAL_TIME,
    EXAM_SCHEDULED_IND,
    EXAM_SUPERVISOR_INSTRCTN,
    EXAM_ANNOUNCEMENTS,
    EXAM_ALLOWABLE_INSTRCTN,
    EXAM_NON_ALLOWED_INSTRCTN,
    EXAM_SUPPLIED_INSTRCTN,
    EXAM_CONSTRAINTS,
    QUESTION_OR_TITLE,
    ASS_LENGTH_OR_DURATION,
    COMMENTS,
    attribute_category,
    attribute1,
    attribute2,
    attribute3,
    attribute4,
    attribute5,
    attribute6,
    attribute7,
    attribute8,
    attribute9,
    attribute10,
    attribute11,
    attribute12,
    attribute13,
    attribute14,
    attribute15,
    attribute16,
    attribute17,
    attribute18,
    attribute19,
    attribute20,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    -- anilk, bug#2784198
    closed_ind
  ) values (
     NEW_REFERENCES.ORG_ID,
    NEW_REFERENCES.ASS_ID,
    NEW_REFERENCES.ASSESSMENT_TYPE,
    NEW_REFERENCES.DESCRIPTION,
    NEW_REFERENCES.EXAM_SHORT_PAPER_NAME,
    NEW_REFERENCES.EXAM_PAPER_NAME,
    NEW_REFERENCES.EXAM_WORKING_TIME,
    NEW_REFERENCES.EXAM_PERUSAL_TIME,
    NEW_REFERENCES.EXAM_SCHEDULED_IND,
    NEW_REFERENCES.EXAM_SUPERVISOR_INSTRCTN,
    NEW_REFERENCES.EXAM_ANNOUNCEMENTS,
    NEW_REFERENCES.EXAM_ALLOWABLE_INSTRCTN,
    NEW_REFERENCES.EXAM_NON_ALLOWED_INSTRCTN,
    NEW_REFERENCES.EXAM_SUPPLIED_INSTRCTN,
    NEW_REFERENCES.EXAM_CONSTRAINTS,
    NEW_REFERENCES.QUESTION_OR_TITLE,
    NEW_REFERENCES.ASS_LENGTH_OR_DURATION,
    NEW_REFERENCES.COMMENTS,
    new_references.attribute_category,
    new_references.attribute1,
    new_references.attribute2,
    new_references.attribute3,
    new_references.attribute4,
    new_references.attribute5,
    new_references.attribute6,
    new_references.attribute7,
    new_references.attribute8,
    new_references.attribute9,
    new_references.attribute10,
    new_references.attribute11,
    new_references.attribute12,
    new_references.attribute13,
    new_references.attribute14,
    new_references.attribute15,
    new_references.attribute16,
    new_references.attribute17,
    new_references.attribute18,
    new_references.attribute19,
    new_references.attribute20,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    -- anilk, bug#2784198
    new_references.closed_ind
  );

Line: 756


end INSERT_ROW;

Line: 801


  cursor c1 is select
      ASSESSMENT_TYPE,
      DESCRIPTION,
      EXAM_SHORT_PAPER_NAME,
      EXAM_PAPER_NAME,
      EXAM_WORKING_TIME,
      EXAM_PERUSAL_TIME,
      EXAM_SCHEDULED_IND,
      EXAM_SUPERVISOR_INSTRCTN,
      EXAM_ANNOUNCEMENTS,
      EXAM_ALLOWABLE_INSTRCTN,
      EXAM_NON_ALLOWED_INSTRCTN,
      EXAM_SUPPLIED_INSTRCTN,
      EXAM_CONSTRAINTS,
      QUESTION_OR_TITLE,
      ASS_LENGTH_OR_DURATION,
      COMMENTS,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      attribute16,
      attribute17,
      attribute18,
      attribute19,
      attribute20,
      -- anilk, bug#2784198
      closed_ind
    from IGS_AS_ASSESSMNT_ITM_ALL

    where ROWID = X_ROWID  for update  nowait;

Line: 850


    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 937


procedure UPDATE_ROW (
  X_ROWID in  VARCHAR2,
  X_ASS_ID in NUMBER,
  X_ASSESSMENT_TYPE in VARCHAR2,
  X_DESCRIPTION in VARCHAR2,
  X_EXAM_SHORT_PAPER_NAME in VARCHAR2,
  X_EXAM_PAPER_NAME in VARCHAR2,
  X_EXAM_WORKING_TIME in DATE,
  X_EXAM_PERUSAL_TIME in DATE,
  X_EXAM_SCHEDULED_IND in VARCHAR2,
  X_EXAM_SUPERVISOR_INSTRCTN in VARCHAR2,
  X_EXAM_ANNOUNCEMENTS in VARCHAR2,
  X_EXAM_ALLOWABLE_INSTRCTN in VARCHAR2,
  X_EXAM_NON_ALLOWED_INSTRCTN in VARCHAR2,
  X_EXAM_SUPPLIED_INSTRCTN in VARCHAR2,
  X_EXAM_CONSTRAINTS in VARCHAR2,
  X_QUESTION_OR_TITLE in VARCHAR2,
  X_ASS_LENGTH_OR_DURATION in VARCHAR2,
  X_COMMENTS in VARCHAR2,
  x_attribute_category IN VARCHAR2,
  x_attribute1 IN VARCHAR2,
  x_attribute2 IN VARCHAR2,
  x_attribute3 IN VARCHAR2,
  x_attribute4 IN VARCHAR2,
  x_attribute5 IN VARCHAR2,
  x_attribute6 IN VARCHAR2,
  x_attribute7 IN VARCHAR2,
  x_attribute8 IN VARCHAR2,
  x_attribute9 IN VARCHAR2,
  x_attribute10 IN VARCHAR2,
  x_attribute11 IN VARCHAR2,
  x_attribute12 IN VARCHAR2,
  x_attribute13 IN VARCHAR2,
  x_attribute14 IN VARCHAR2,
  x_attribute15 IN VARCHAR2,
  x_attribute16 IN VARCHAR2,
  x_attribute17 IN VARCHAR2,
  x_attribute18 IN VARCHAR2,
  x_attribute19 IN VARCHAR2,
  x_attribute20 IN VARCHAR2,
  X_MODE in VARCHAR2 default 'R',
  -- anilk, bug#2784198
  x_closed_ind IN VARCHAR2
  ) as
    X_LAST_UPDATE_DATE DATE;

Line: 982


    X_LAST_UPDATED_BY NUMBER;

Line: 983


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 985


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 987


    X_LAST_UPDATED_BY := 1;

Line: 988


    X_LAST_UPDATE_LOGIN := 0;

Line: 990


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 991


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 994


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 995


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 1004


 p_action=>'UPDATE',
 x_rowid=>X_ROWID,
 x_ass_id=>X_ASS_ID,
 x_ass_length_or_duration=>X_ASS_LENGTH_OR_DURATION,
 x_assessment_type=>X_ASSESSMENT_TYPE,
 x_comments=>X_COMMENTS,
 x_description=>X_DESCRIPTION,
 x_exam_allowable_instrctn=>X_EXAM_ALLOWABLE_INSTRCTN,
 x_exam_announcements=>X_EXAM_ANNOUNCEMENTS,
 x_exam_constraints=>X_EXAM_CONSTRAINTS,
 x_exam_non_allowed_instrctn=>X_EXAM_NON_ALLOWED_INSTRCTN,
 x_exam_paper_name=>X_EXAM_PAPER_NAME,
 x_exam_perusal_time=>X_EXAM_PERUSAL_TIME,
 x_exam_scheduled_ind=>X_EXAM_SCHEDULED_IND,
 x_exam_short_paper_name=>X_EXAM_SHORT_PAPER_NAME,
 x_exam_supervisor_instrctn=>X_EXAM_SUPERVISOR_INSTRCTN,
 x_exam_supplied_instrctn=>X_EXAM_SUPPLIED_INSTRCTN,
 x_exam_working_time=>X_EXAM_WORKING_TIME,
  x_attribute_category=>x_attribute_category,
 x_attribute1=>x_attribute1,
 x_attribute2=>x_attribute2,
 x_attribute3=>x_attribute3,
 x_attribute4=>x_attribute4,
 x_attribute5=>x_attribute5,
 x_attribute6=>x_attribute6,
 x_attribute7=>x_attribute7,
 x_attribute8=>x_attribute8,
 x_attribute9=>x_attribute9,
 x_attribute10=>x_attribute10,
 x_attribute11=>x_attribute11,
 x_attribute12=>x_attribute12,
 x_attribute13=>x_attribute13,
 x_attribute14=>x_attribute14,
 x_attribute15=>x_attribute15,
 x_attribute16=>x_attribute16,
 x_attribute17=>x_attribute17,
 x_attribute18=>x_attribute18,
 x_attribute19=>x_attribute19,
 x_attribute20=>x_attribute20,
 x_question_or_title=>X_QUESTION_OR_TITLE,
 x_creation_date=>X_LAST_UPDATE_DATE,
 x_created_by=>X_LAST_UPDATED_BY,
 x_last_update_date=>X_LAST_UPDATE_DATE,
 x_last_updated_by=>X_LAST_UPDATED_BY,
 x_last_update_login=>X_LAST_UPDATE_LOGIN,
 -- anilk, bug#2784198
 x_closed_ind => x_closed_ind
 );

Line: 1053


  update IGS_AS_ASSESSMNT_ITM_ALL set
    ASSESSMENT_TYPE = NEW_REFERENCES.ASSESSMENT_TYPE,
    DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
    EXAM_SHORT_PAPER_NAME = NEW_REFERENCES.EXAM_SHORT_PAPER_NAME,
    EXAM_PAPER_NAME = NEW_REFERENCES.EXAM_PAPER_NAME,
    EXAM_WORKING_TIME = NEW_REFERENCES.EXAM_WORKING_TIME,
    EXAM_PERUSAL_TIME = NEW_REFERENCES.EXAM_PERUSAL_TIME,
    EXAM_SCHEDULED_IND = NEW_REFERENCES.EXAM_SCHEDULED_IND,
    EXAM_SUPERVISOR_INSTRCTN = NEW_REFERENCES.EXAM_SUPERVISOR_INSTRCTN,
    EXAM_ANNOUNCEMENTS = NEW_REFERENCES.EXAM_ANNOUNCEMENTS,
    EXAM_ALLOWABLE_INSTRCTN = NEW_REFERENCES.EXAM_ALLOWABLE_INSTRCTN,
    EXAM_NON_ALLOWED_INSTRCTN = NEW_REFERENCES.EXAM_NON_ALLOWED_INSTRCTN,
    EXAM_SUPPLIED_INSTRCTN = NEW_REFERENCES.EXAM_SUPPLIED_INSTRCTN,
    EXAM_CONSTRAINTS = NEW_REFERENCES.EXAM_CONSTRAINTS,
    QUESTION_OR_TITLE = NEW_REFERENCES.QUESTION_OR_TITLE,
    ASS_LENGTH_OR_DURATION = NEW_REFERENCES.ASS_LENGTH_OR_DURATION,
    COMMENTS = NEW_REFERENCES.COMMENTS,
    attribute_category =  new_references.attribute_category,
    attribute1 =  new_references.attribute1,
    attribute2 =  new_references.attribute2,
    attribute3 =  new_references.attribute3,
    attribute4 =  new_references.attribute4,
    attribute5 =  new_references.attribute5,
    attribute6 =  new_references.attribute6,
    attribute7 =  new_references.attribute7,
    attribute8 =  new_references.attribute8,
    attribute9 =  new_references.attribute9,
    attribute10 =  new_references.attribute10,
    attribute11 =  new_references.attribute11,
    attribute12 =  new_references.attribute12,
    attribute13 =  new_references.attribute13,
    attribute14 =  new_references.attribute14,
    attribute15 =  new_references.attribute15,
    attribute16 =  new_references.attribute16,
    attribute17 =  new_references.attribute17,
    attribute18 =  new_references.attribute18,
    attribute19 =  new_references.attribute19,
    attribute20 =  new_references.attribute20,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    -- anilk, bug#2784198
    closed_ind = new_references.closed_ind
  where ROWID = X_ROWID;

Line: 1101


end UPDATE_ROW;

Line: 1148


  cursor c1 is select rowid from IGS_AS_ASSESSMNT_ITM_ALL
     where ASS_ID = X_ASS_ID
  ;

Line: 1156


    INSERT_ROW (
     X_ROWID,
     X_ORG_ID,
     X_ASS_ID,
     X_ASSESSMENT_TYPE,
     X_DESCRIPTION,
     X_EXAM_SHORT_PAPER_NAME,
     X_EXAM_PAPER_NAME,
     X_EXAM_WORKING_TIME,
     X_EXAM_PERUSAL_TIME,
     X_EXAM_SCHEDULED_IND,
     X_EXAM_SUPERVISOR_INSTRCTN,
     X_EXAM_ANNOUNCEMENTS,
     X_EXAM_ALLOWABLE_INSTRCTN,
     X_EXAM_NON_ALLOWED_INSTRCTN,
     X_EXAM_SUPPLIED_INSTRCTN,
     X_EXAM_CONSTRAINTS,
     X_QUESTION_OR_TITLE,
     X_ASS_LENGTH_OR_DURATION,
     X_COMMENTS,
     x_attribute_category,
     x_attribute1,
     x_attribute2,
     x_attribute3,
     x_attribute4,
     x_attribute5,
     x_attribute6,
     x_attribute7,
     x_attribute8,
     x_attribute9,
     x_attribute10,
     x_attribute11,
     x_attribute12,
     x_attribute13,
     x_attribute14,
     x_attribute15,
     x_attribute16,
     x_attribute17,
     x_attribute18,
     x_attribute19,
     x_attribute20,
     X_MODE,
     -- anilk, bug#2784198
     x_closed_ind
     );

Line: 1204


  UPDATE_ROW (
   X_ROWID,
   X_ASS_ID,
   X_ASSESSMENT_TYPE,
   X_DESCRIPTION,
   X_EXAM_SHORT_PAPER_NAME,
   X_EXAM_PAPER_NAME,
   X_EXAM_WORKING_TIME,
   X_EXAM_PERUSAL_TIME,
   X_EXAM_SCHEDULED_IND,
   X_EXAM_SUPERVISOR_INSTRCTN,
   X_EXAM_ANNOUNCEMENTS,
   X_EXAM_ALLOWABLE_INSTRCTN,
   X_EXAM_NON_ALLOWED_INSTRCTN,
   X_EXAM_SUPPLIED_INSTRCTN,
   X_EXAM_CONSTRAINTS,
   X_QUESTION_OR_TITLE,
   X_ASS_LENGTH_OR_DURATION,
   X_COMMENTS,
   x_attribute_category,
   x_attribute1,
   x_attribute2,
   x_attribute3,
   x_attribute4,
   x_attribute5,
   x_attribute6,
   x_attribute7,
   x_attribute8,
   x_attribute9,
   x_attribute10,
   x_attribute11,
   x_attribute12,
   x_attribute13,
   x_attribute14,
   x_attribute15,
   x_attribute16,
   x_attribute17,
   x_attribute18,
   x_attribute19,
   x_attribute20,
   X_MODE,
   -- anilk, bug#2784198
   x_closed_ind
   );