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.

APPS.IGS_AS_GRD_SCH_GRADE_PKG SQL Statements

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

Line: 56


    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL,
    x_closed_ind        IN VARCHAR2 DEFAULT 'N'
  ) AS

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

Line: 77


    IF (cur_old_ref_values%NOTFOUND) AND (p_action  NOT IN ('INSERT','VALIDATE_INSERT')) THEN

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

Line: 135


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

Line: 142


    new_references.last_update_date := x_last_update_date;

Line: 143


    new_references.last_updated_by := x_last_updated_by;

Line: 144


    new_references.last_update_login := x_last_update_login;

Line: 147


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: 170


        IF  p_inserting OR p_updating THEN
                -- Validate if grade's grading schema is current or future
                IF p_inserting OR p_updating THEN
                        IF  IGS_AS_VAL_GSG.assp_val_gs_cur_fut (
                                                        new_references.grading_schema_cd,
                                                        new_references.version_number,
                                                        v_message_name) = FALSE THEN
                                FND_MESSAGE.SET_NAME('IGS',v_message_name);

Line: 183


                IF p_inserting OR p_updating THEN
                        IF  IGS_AS_VAL_GSG.assp_val_gsg_mrk_rng (
                                                        new_references.lower_mark_range,
                                                        new_references.upper_mark_range,
                                                        v_message_name) = FALSE THEN
                                FND_MESSAGE.SET_NAME('IGS',v_message_name);

Line: 194


                IF p_inserting OR p_updating THEN
                        IF  IGS_AS_VAL_GSG.assp_val_gsg_min_max (
                                                        new_references.min_percentage,
                                                        new_references.max_percentage,
                                                        v_message_name) = FALSE THEN
                                FND_MESSAGE.SET_NAME('IGS',v_message_name);

Line: 213


                IF (p_inserting OR p_updating)   AND
                   new_references.s_result_type  <> old_references.s_result_type
                THEN

                        IF  IGS_AS_VAL_GSG.assp_val_gsg_gsgt (
                                                        new_references.grading_schema_cd,
                                                        new_references.version_number,
                                                        new_references.grade,
                                                        v_message_name) = FALSE THEN
                                FND_MESSAGE.SET_NAME('IGS',v_message_name);

Line: 239


  END BeforeRowInsertUpdate1;

Line: 240


PROCEDURE AfterRowInsertUpdate2(
    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: 247


        IF  p_inserting OR p_updating THEN
            IF IGS_AS_VAL_GSG.assp_val_gsg_m_ovrlp (
                                        new_references.grading_schema_cd,
                                        new_references.version_number,
                                        new_references.grade,
                                        new_references.lower_mark_range,
                                        new_references.upper_mark_range,
                                        v_message_name) = FALSE THEN
                        FND_MESSAGE.SET_NAME('IGS',v_message_name);

Line: 272


  END AfterRowInsertUpdate2;

Line: 478


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

Line: 493


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

Line: 567


      SELECT   rowid
      FROM     IGS_AS_GRD_SCH_GRADE
      WHERE    grading_schema_cd = x_grading_schema_cd
      AND      version_number = x_version_number
      AND      grade = x_grade;

Line: 592


      SELECT   rowid
      FROM     IGS_AS_GRD_SCH_GRADE
      WHERE    grading_schema_cd = x_grading_schema_cd
      AND      version_number = x_version_number ;

Line: 614


      SELECT   rowid
      FROM     IGS_AS_GRD_SCH_GRADE
      WHERE    s_result_type = x_s_result_type ;

Line: 681


    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL,
    x_closed_ind IN VARCHAR2 DEFAULT NULL
  ) AS
  BEGIN
    Set_Column_Values (
      p_action,
      x_rowid,
      x_dflt_outstanding_ind,
      x_external_grade,
      x_lower_mark_range,
      x_upper_mark_range,
      x_min_percentage,
      x_max_percentage,
      x_gpa_val,
      x_rank,
      x_s_special_grade_type,
      x_grading_schema_cd,
      x_version_number,
      x_grade,
      x_full_grade_name,
      x_s_result_type,
      x_show_on_noticeboard_ind,
      x_show_on_official_ntfctn_ind,
      x_show_in_newspaper_ind,
      x_show_internally_ind,
      x_system_only_ind,
      x_show_in_earned_crdt_ind,
      x_incl_in_repeat_process_ind,
      x_admin_only_ind,
      x_grading_period_cd,
      x_repeat_grade,
      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,
      x_closed_ind
    );

Line: 742


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

Line: 759


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

Line: 764


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

      Check_Child_Existance;

Line: 768


   ELSIF (p_action = 'VALIDATE_INSERT') THEN
      		IF  Get_PK_For_Validation (
				 new_references.grading_schema_cd,
   			 	 new_references.version_number,
            	 	 new_references.grade
				 ) THEN
		          Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

Line: 779


 	ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      	  Check_Constraints;

Line: 781


	ELSIF (p_action = 'VALIDATE_DELETE') THEN
              Check_Child_Existance;

Line: 792


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

Line: 795


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

Line: 801


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_GRADING_SCHEMA_CD in VARCHAR2,
  X_VERSION_NUMBER in NUMBER,
  X_GRADE in VARCHAR2,
  X_FULL_GRADE_NAME in VARCHAR2,
  X_S_RESULT_TYPE in VARCHAR2,
  X_SHOW_ON_NOTICEBOARD_IND in VARCHAR2,
  X_SHOW_ON_OFFICIAL_NTFCTN_IND in VARCHAR2,
  X_S_SPECIAL_GRADE_TYPE in VARCHAR2,
  X_SHOW_IN_NEWSPAPER_IND in VARCHAR2,
  X_SHOW_INTERNALLY_IND in VARCHAR2,
  X_SYSTEM_ONLY_IND in VARCHAR2,
  X_DFLT_OUTSTANDING_IND in VARCHAR2,
  X_EXTERNAL_GRADE in VARCHAR2,
  X_LOWER_MARK_RANGE in NUMBER,
  X_UPPER_MARK_RANGE in NUMBER,
  X_MIN_PERCENTAGE in NUMBER,
  X_MAX_PERCENTAGE in NUMBER,
  X_GPA_VAL in NUMBER,
  X_RANK in NUMBER,
  X_SHOW_IN_EARNED_CRDT_IND in VARCHAR2,
  X_INCL_IN_REPEAT_PROCESS_IND in VARCHAR2,
  X_ADMIN_ONLY_IND in VARCHAR2,
  X_GRADING_PERIOD_CD in VARCHAR2,
  X_REPEAT_GRADE 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',
  x_closed_ind IN VARCHAR2 default 'N'
  ) AS
    cursor C is select ROWID from IGS_AS_GRD_SCH_GRADE
      where GRADING_SCHEMA_CD = X_GRADING_SCHEMA_CD
      and VERSION_NUMBER = X_VERSION_NUMBER
      and GRADE = X_GRADE;

Line: 855


    X_LAST_UPDATE_DATE DATE;

Line: 856


    X_LAST_UPDATED_BY NUMBER;

Line: 857


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 859


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 861


    X_LAST_UPDATED_BY := 1;

Line: 862


    X_LAST_UPDATE_LOGIN := 0;

Line: 864


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 865


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 868


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 869


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 878


 p_action=>'INSERT',
 x_rowid=>X_ROWID,
 x_dflt_outstanding_ind=> NVL(X_DFLT_OUTSTANDING_IND,'N'),
 x_external_grade=>X_EXTERNAL_GRADE,
 x_full_grade_name=>X_FULL_GRADE_NAME,
 x_gpa_val=>X_GPA_VAL,
 x_grade=>X_GRADE,
 x_grading_schema_cd=>X_GRADING_SCHEMA_CD,
 x_lower_mark_range=>X_LOWER_MARK_RANGE,
 x_max_percentage=>X_MAX_PERCENTAGE,
 x_min_percentage=>X_MIN_PERCENTAGE,
 x_rank=>X_RANK,
 x_s_result_type=>X_S_RESULT_TYPE,
 x_s_special_grade_type=>X_S_SPECIAL_GRADE_TYPE,
 x_show_in_newspaper_ind=> NVL(X_SHOW_IN_NEWSPAPER_IND,'Y'),
 x_show_internally_ind=> NVL(X_SHOW_INTERNALLY_IND,'Y'),
 x_show_on_noticeboard_ind=> NVL(X_SHOW_ON_NOTICEBOARD_IND,'Y'),
 x_show_on_official_ntfctn_ind=> NVL(X_SHOW_ON_OFFICIAL_NTFCTN_IND,'Y'),
 x_system_only_ind=> NVL(X_SYSTEM_ONLY_IND,'N'),
 x_upper_mark_range=>X_UPPER_MARK_RANGE,
 x_version_number=>X_VERSION_NUMBER,
  x_show_in_earned_crdt_ind => X_SHOW_IN_EARNED_CRDT_IND ,
  x_incl_in_repeat_process_ind => X_SHOW_IN_EARNED_CRDT_IND ,
  x_admin_only_ind => X_ADMIN_ONLY_IND ,
  x_grading_period_cd => X_GRADING_PERIOD_CD ,
  x_repeat_grade => X_REPEAT_GRADE ,
      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,
 x_closed_ind => x_closed_ind
);

Line: 932


  insert into IGS_AS_GRD_SCH_GRADE (
    GRADING_SCHEMA_CD,
    VERSION_NUMBER,
    GRADE,
    FULL_GRADE_NAME,
    S_RESULT_TYPE,
    SHOW_ON_NOTICEBOARD_IND,
    SHOW_ON_OFFICIAL_NTFCTN_IND,
    S_SPECIAL_GRADE_TYPE,
    SHOW_IN_NEWSPAPER_IND,
    SHOW_INTERNALLY_IND,
    SYSTEM_ONLY_IND,
    DFLT_OUTSTANDING_IND,
    EXTERNAL_GRADE,
    LOWER_MARK_RANGE,
    UPPER_MARK_RANGE,
    MIN_PERCENTAGE,
    MAX_PERCENTAGE,
    GPA_VAL,
    RANK,
    SHOW_IN_EARNED_CRDT_IND,
    INCL_IN_REPEAT_PROCESS_IND,
    ADMIN_ONLY_IND,
    GRADING_PERIOD_CD,
    REPEAT_GRADE,
    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,
    CLOSED_IND
  ) values (
    NEW_REFERENCES.GRADING_SCHEMA_CD,
    NEW_REFERENCES.VERSION_NUMBER,
    NEW_REFERENCES.GRADE,
    NEW_REFERENCES.FULL_GRADE_NAME,
    NEW_REFERENCES.S_RESULT_TYPE,
    NEW_REFERENCES.SHOW_ON_NOTICEBOARD_IND,
    NEW_REFERENCES.SHOW_ON_OFFICIAL_NTFCTN_IND,
    NEW_REFERENCES.S_SPECIAL_GRADE_TYPE,
    NEW_REFERENCES.SHOW_IN_NEWSPAPER_IND,
    NEW_REFERENCES.SHOW_INTERNALLY_IND,
    NEW_REFERENCES.SYSTEM_ONLY_IND,
    NEW_REFERENCES.DFLT_OUTSTANDING_IND,
    NEW_REFERENCES.EXTERNAL_GRADE,
    NEW_REFERENCES.LOWER_MARK_RANGE,
    NEW_REFERENCES.UPPER_MARK_RANGE,
    NEW_REFERENCES.MIN_PERCENTAGE,
    NEW_REFERENCES.MAX_PERCENTAGE,
    NEW_REFERENCES.GPA_VAL,
    NEW_REFERENCES.RANK,
    NEW_REFERENCES.SHOW_IN_EARNED_CRDT_IND,
    NEW_REFERENCES.INCL_IN_REPEAT_PROCESS_IND,
    NEW_REFERENCES.ADMIN_ONLY_IND,
    NEW_REFERENCES.GRADING_PERIOD_CD,
    NEW_REFERENCES.REPEAT_GRADE,
    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,
    new_references.closed_ind
  );

Line: 1045


  p_action => 'INSERT',
  x_rowid => X_ROWID
  );

Line: 1048


end INSERT_ROW;

Line: 1098


  cursor c1 is select
      FULL_GRADE_NAME,
      S_RESULT_TYPE,
      SHOW_ON_NOTICEBOARD_IND,
      SHOW_ON_OFFICIAL_NTFCTN_IND,
      S_SPECIAL_GRADE_TYPE,
      SHOW_IN_NEWSPAPER_IND,
      SHOW_INTERNALLY_IND,
      SYSTEM_ONLY_IND,
      DFLT_OUTSTANDING_IND,
      EXTERNAL_GRADE,
      LOWER_MARK_RANGE,
      UPPER_MARK_RANGE,
      MIN_PERCENTAGE,
      MAX_PERCENTAGE,
      GPA_VAL,
      RANK,
      SHOW_IN_EARNED_CRDT_IND,
      INCL_IN_REPEAT_PROCESS_IND,
      ADMIN_ONLY_IND,
      GRADING_PERIOD_CD,
      REPEAT_GRADE,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      attribute16,
      attribute17,
      attribute18,
      attribute19,
      attribute20,
      closed_ind
    from IGS_AS_GRD_SCH_GRADE
    where ROWID = X_ROWID  for update  nowait;

Line: 1149


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

Line: 1207


procedure UPDATE_ROW (
  X_ROWID in  VARCHAR2,
  X_GRADING_SCHEMA_CD in VARCHAR2,
  X_VERSION_NUMBER in NUMBER,
  X_GRADE in VARCHAR2,
  X_FULL_GRADE_NAME in VARCHAR2,
  X_S_RESULT_TYPE in VARCHAR2,
  X_SHOW_ON_NOTICEBOARD_IND in VARCHAR2,
  X_SHOW_ON_OFFICIAL_NTFCTN_IND in VARCHAR2,
  X_S_SPECIAL_GRADE_TYPE in VARCHAR2,
  X_SHOW_IN_NEWSPAPER_IND in VARCHAR2,
  X_SHOW_INTERNALLY_IND in VARCHAR2,
  X_SYSTEM_ONLY_IND in VARCHAR2,
  X_DFLT_OUTSTANDING_IND in VARCHAR2,
  X_EXTERNAL_GRADE in VARCHAR2,
  X_LOWER_MARK_RANGE in NUMBER,
  X_UPPER_MARK_RANGE in NUMBER,
  X_MIN_PERCENTAGE in NUMBER,
  X_MAX_PERCENTAGE in NUMBER,
  X_GPA_VAL in NUMBER,
  X_RANK in NUMBER,
  X_SHOW_IN_EARNED_CRDT_IND in VARCHAR2,
  X_INCL_IN_REPEAT_PROCESS_IND in VARCHAR2,
  X_ADMIN_ONLY_IND in VARCHAR2,
  X_GRADING_PERIOD_CD in VARCHAR2,
  X_REPEAT_GRADE 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',
  x_closed_ind In VARCHAR2 default 'N'
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 1258


    X_LAST_UPDATED_BY NUMBER;

Line: 1259


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 1261


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 1263


    X_LAST_UPDATED_BY := 1;

Line: 1264


    X_LAST_UPDATE_LOGIN := 0;

Line: 1266


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1267


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 1270


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 1271


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 1280


 p_action=>'UPDATE',
 x_rowid=>X_ROWID,
 x_dflt_outstanding_ind=>X_DFLT_OUTSTANDING_IND,
 x_external_grade=>X_EXTERNAL_GRADE,
 x_full_grade_name=>X_FULL_GRADE_NAME,
 x_gpa_val=>X_GPA_VAL,
 x_grade=>X_GRADE,
 x_grading_schema_cd=>X_GRADING_SCHEMA_CD,
 x_lower_mark_range=>X_LOWER_MARK_RANGE,
 x_max_percentage=>X_MAX_PERCENTAGE,
 x_min_percentage=>X_MIN_PERCENTAGE,
 x_rank=>X_RANK,
 x_s_result_type=>X_S_RESULT_TYPE,
 x_s_special_grade_type=>X_S_SPECIAL_GRADE_TYPE,
 x_show_in_newspaper_ind=>X_SHOW_IN_NEWSPAPER_IND,
 x_show_internally_ind=>X_SHOW_INTERNALLY_IND,
 x_show_on_noticeboard_ind=>X_SHOW_ON_NOTICEBOARD_IND,
 x_show_on_official_ntfctn_ind=>X_SHOW_ON_OFFICIAL_NTFCTN_IND,
 x_system_only_ind=>X_SYSTEM_ONLY_IND,
 x_upper_mark_range=>X_UPPER_MARK_RANGE,
 x_version_number=>X_VERSION_NUMBER,
 x_show_in_earned_crdt_ind => X_SHOW_IN_EARNED_CRDT_IND,
 x_incl_in_repeat_process_ind => X_INCL_IN_REPEAT_PROCESS_IND,
 x_admin_only_ind => X_ADMIN_ONLY_IND,
 x_grading_period_cd => X_GRADING_PERIOD_CD,
 x_repeat_grade => X_REPEAT_GRADE ,
 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,
 x_closed_ind =>  x_closed_ind
 );

Line: 1334


  update IGS_AS_GRD_SCH_GRADE set
    FULL_GRADE_NAME = NEW_REFERENCES.FULL_GRADE_NAME,
    S_RESULT_TYPE = NEW_REFERENCES.S_RESULT_TYPE,
    SHOW_ON_NOTICEBOARD_IND = NEW_REFERENCES.SHOW_ON_NOTICEBOARD_IND,
    SHOW_ON_OFFICIAL_NTFCTN_IND = NEW_REFERENCES.SHOW_ON_OFFICIAL_NTFCTN_IND,
    S_SPECIAL_GRADE_TYPE = NEW_REFERENCES.S_SPECIAL_GRADE_TYPE,
    SHOW_IN_NEWSPAPER_IND = NEW_REFERENCES.SHOW_IN_NEWSPAPER_IND,
    SHOW_INTERNALLY_IND = NEW_REFERENCES.SHOW_INTERNALLY_IND,
    SYSTEM_ONLY_IND = NEW_REFERENCES.SYSTEM_ONLY_IND,
    DFLT_OUTSTANDING_IND = NEW_REFERENCES.DFLT_OUTSTANDING_IND,
    EXTERNAL_GRADE = NEW_REFERENCES.EXTERNAL_GRADE,
    LOWER_MARK_RANGE = NEW_REFERENCES.LOWER_MARK_RANGE,
    UPPER_MARK_RANGE = NEW_REFERENCES.UPPER_MARK_RANGE,
    MIN_PERCENTAGE = NEW_REFERENCES.MIN_PERCENTAGE,
    MAX_PERCENTAGE = NEW_REFERENCES.MAX_PERCENTAGE,
    GPA_VAL = NEW_REFERENCES.GPA_VAL,
    RANK = NEW_REFERENCES.RANK,
    SHOW_IN_EARNED_CRDT_IND = NEW_REFERENCES.SHOW_IN_EARNED_CRDT_IND,
    INCL_IN_REPEAT_PROCESS_IND = NEW_REFERENCES.INCL_IN_REPEAT_PROCESS_IND,
    ADMIN_ONLY_IND = NEW_REFERENCES.ADMIN_ONLY_IND,
    GRADING_PERIOD_CD = NEW_REFERENCES.GRADING_PERIOD_CD,
    REPEAT_GRADE = NEW_REFERENCES.REPEAT_GRADE,
    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,
    closed_ind = x_closed_ind
  where ROWID = X_ROWID;

Line: 1386


  p_action => 'UPDATE',
  x_rowid => X_ROWID
  );

Line: 1389


end UPDATE_ROW;

Line: 1440


  cursor c1 is select rowid from IGS_AS_GRD_SCH_GRADE
     where GRADING_SCHEMA_CD = X_GRADING_SCHEMA_CD
     and VERSION_NUMBER = X_VERSION_NUMBER
     and GRADE = X_GRADE
  ;

Line: 1450


    INSERT_ROW (
     X_ROWID,
     X_GRADING_SCHEMA_CD,
     X_VERSION_NUMBER,
     X_GRADE,
     X_FULL_GRADE_NAME,
     X_S_RESULT_TYPE,
     X_SHOW_ON_NOTICEBOARD_IND,
     X_SHOW_ON_OFFICIAL_NTFCTN_IND,
     X_S_SPECIAL_GRADE_TYPE,
     X_SHOW_IN_NEWSPAPER_IND,
     X_SHOW_INTERNALLY_IND,
     X_SYSTEM_ONLY_IND,
     X_DFLT_OUTSTANDING_IND,
     X_EXTERNAL_GRADE,
     X_LOWER_MARK_RANGE,
     X_UPPER_MARK_RANGE,
     X_MIN_PERCENTAGE,
     X_MAX_PERCENTAGE,
     X_GPA_VAL,
     X_RANK,
     X_SHOW_IN_EARNED_CRDT_IND,
     X_INCL_IN_REPEAT_PROCESS_IND,
     X_ADMIN_ONLY_IND,
     X_GRADING_PERIOD_CD,
     X_REPEAT_GRADE,
     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,
     x_closed_ind);

Line: 1502


  UPDATE_ROW (
   X_ROWID,
   X_GRADING_SCHEMA_CD,
   X_VERSION_NUMBER,
   X_GRADE,
   X_FULL_GRADE_NAME,
   X_S_RESULT_TYPE,
   X_SHOW_ON_NOTICEBOARD_IND,
   X_SHOW_ON_OFFICIAL_NTFCTN_IND,
   X_S_SPECIAL_GRADE_TYPE,
   X_SHOW_IN_NEWSPAPER_IND,
   X_SHOW_INTERNALLY_IND,
   X_SYSTEM_ONLY_IND,
   X_DFLT_OUTSTANDING_IND,
   X_EXTERNAL_GRADE,
   X_LOWER_MARK_RANGE,
   X_UPPER_MARK_RANGE,
   X_MIN_PERCENTAGE,
   X_MAX_PERCENTAGE,
   X_GPA_VAL,
   X_RANK,
   X_SHOW_IN_EARNED_CRDT_IND ,
   X_INCL_IN_REPEAT_PROCESS_IND ,
   X_ADMIN_ONLY_IND ,
   X_GRADING_PERIOD_CD,
   X_REPEAT_GRADE ,
   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,
   x_closed_ind);