DBA Data[Home] [Help]

APPS.IGS_GR_GRADUAND_PKG SQL Statements

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

Line: 33

    x_last_update_date IN DATE ,
    x_last_updated_by IN NUMBER ,
    x_last_update_login IN NUMBER  ,
    x_org_id IN NUMBER ,
    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
  ) AS

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_GR_GRADUAND_ALL
      WHERE    rowid = x_rowid;
Line: 73

    IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
      Close cur_old_ref_values;
Line: 75

      Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED1');
Line: 125

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

    new_references.last_update_date := x_last_update_date;
Line: 133

    new_references.last_updated_by := x_last_updated_by;
Line: 134

    new_references.last_update_login := x_last_update_login;
Line: 144

  PROCEDURE BeforeRowInsertUpdate1(
    p_inserting IN BOOLEAN ,
    p_updating IN BOOLEAN ,
    p_deleting IN BOOLEAN
    ) AS
	v_message_name	VARCHAR2(30);
Line: 151

	IF p_inserting OR p_updating THEN
		-- Validate the graduand record has the required details
		IF IGS_GR_VAL_GR.grdp_val_gr_rqrd(
		                 p_course_cd                   =>   new_references.course_cd,
                                 p_graduand_status             =>   new_references.graduand_status,
                                 p_s_graduand_type             =>   new_references.s_graduand_type,
                                 p_award_course_cd             =>   new_references.award_course_cd,
                                 p_award_crs_version_number    =>   new_references.award_crs_version_number,
                                 p_award_cd                    =>   new_references.award_cd,
                                 p_sur_for_course_cd           =>   new_references.sur_for_course_cd,
                                 p_sur_for_crs_version_number  =>   new_references.sur_for_crs_version_number,
                                 p_sur_for_award_cd            =>   new_references.sur_for_award_cd,
                                 p_message_name                =>   v_message_name) = FALSE THEN
			Fnd_Message.Set_Name('IGS', v_message_name);
Line: 180

	IF p_inserting OR (p_updating AND
			NVL(new_references.grd_cal_type, 'NULL') <> NVL(old_references.grd_cal_type, 'NULL') OR
			NVL(new_references.grd_ci_sequence_number, 0) <>
			NVL(old_references.grd_ci_sequence_number, 0)) THEN
		-- validate the ceremony round calendar instance
		IF IGS_GR_VAL_GR.grdp_val_gr_crd_ci(
						new_references.grd_cal_type,
  						new_references.grd_ci_sequence_number,
  						v_message_name) = FALSE THEN
				Fnd_Message.Set_Name('IGS', v_message_name);
Line: 194

	IF p_inserting OR (p_updating AND
			new_references.graduand_status <> old_references.graduand_status) THEN
		-- Validate graduand status is not closed
		IF IGS_GR_VAL_GR.grdp_val_gst_closed(
				new_references.graduand_status,
				v_message_name) = FALSE THEN
			Fnd_Message.Set_Name('IGS', v_message_name);
Line: 222

	IF p_inserting OR (p_updating AND
			new_references.graduand_appr_status <> old_references.graduand_appr_status) THEN
		-- Validate graduand approval status is not closed
		IF IGS_GR_VAL_GR.grdp_val_gas_closed(
				new_references.graduand_appr_status,
				v_message_name) = FALSE THEN
			Fnd_Message.Set_Name('IGS', v_message_name);
Line: 245

	IF p_inserting OR (p_updating AND
			NVL(new_references.course_cd,'NULL') <> NVL(old_references.course_cd,'NULL')) THEN
		IF new_references.course_cd IS NOT NULL THEN
			-- Validate the student course attempt course version graduates students
			IF IGS_GR_VAL_GR.grdp_val_gr_sca(
						new_references.person_id,
						new_references.course_cd,
						v_message_name) = FALSE THEN
				Fnd_Message.Set_Name('IGS', v_message_name);
Line: 259

	IF p_inserting OR (p_updating AND
			(new_references.award_cd <> old_references.award_cd OR
			NVL(new_references.course_cd,'NULL') <> NVL(old_references.course_cd,'NULL'))) THEN
		IF new_references.course_cd IS NOT NULL THEN
			-- COURSE award
			-- Validate the award type
			IF  IGS_GR_VAL_AWC.GRDP_VAL_AWARD_TYPE(
						new_references.award_cd,
						'COURSE',
						v_message_name) = FALSE THEN
				Fnd_Message.Set_Name('IGS', v_message_name);
Line: 306

	IF p_inserting OR (p_updating AND
			new_references.s_graduand_type <> old_references.s_graduand_type) THEN
		-- Validate the system graduand type
		IF IGS_GR_VAL_GR.grdp_val_gr_type(
				new_references.person_id,
				new_references.create_dt,
				new_references.course_cd,
				new_references.graduand_status,
				new_references.s_graduand_type,
				old_references.s_graduand_type,
				v_message_name) = FALSE THEN
			Fnd_Message.Set_Name('IGS', v_message_name);
Line: 322

	IF p_inserting OR (p_updating AND
			(new_references.person_id <> old_references.person_id OR
			NVL(new_references.course_cd,'NULL') <> NVL(old_references.course_cd,'NULL') OR
			NVL(new_references.sur_for_course_cd,'NULL') <> NVL(old_references.sur_for_course_cd,'NULL') OR
			NVL(new_references.sur_for_crs_version_number,0) <>
				NVL(old_references.sur_for_crs_version_number,0) OR
			NVL(new_references.sur_for_award_cd,'NULL') <> NVL(old_references.sur_for_award_cd,'NULL'))) THEN
		-- Validate the surrender for details
		IF IGS_GR_VAL_GR.grdp_val_gr_sur_caw(
				new_references.person_id,
				new_references.course_cd,
				new_references.graduand_status,
				new_references.sur_for_course_cd,
				new_references.sur_for_crs_version_number,
				new_references.sur_for_award_cd,
				v_message_name) = FALSE THEN
			Fnd_Message.Set_Name('IGS', v_message_name);
Line: 345

  END BeforeRowInsertUpdate1;
Line: 353

  PROCEDURE AfterRowInsertUpdate2(
    p_inserting IN BOOLEAN ,
    p_updating IN BOOLEAN ,
    p_deleting IN BOOLEAN
    ) AS
	v_message_name	VARCHAR2(30);
Line: 361

	IF p_inserting OR p_updating THEN
		-- validate graduand award uniqueness
		-- Save the rowid of the current row.
		-- Cannot call grdp_val_gr_unique because trigger
		-- will be mutating.
  			-- validate graduand award uniqueness
  			IF IGS_GR_VAL_GR.grdp_val_gr_unique(
  						new_references.person_id,
  						new_references.create_dt,
  						new_references.grd_cal_type,
  						new_references.grd_ci_sequence_number,
  						new_references.award_course_cd,
  						new_references.award_crs_version_number,
  						new_references.award_cd,
  						v_message_name) = FALSE THEN
 				Fnd_Message.Set_Name('IGS', v_message_name);
Line: 382

  END AfterRowInsertUpdate2;
Line: 390

  PROCEDURE AfterRowUpdate3(
    p_inserting IN BOOLEAN ,
    p_updating IN BOOLEAN ,
    p_deleting IN BOOLEAN
    ) AS
  BEGIN
	-- create a history
	IGS_GR_GEN_002.GRDP_INS_GR_HIST(
                            p_person_id                             =>  old_references.person_id,
                            p_create_dt                             =>  old_references.create_dt,
                            p_old_grd_cal_type                      =>  old_references.grd_cal_type,
                            p_new_grd_cal_type                      =>  new_references.grd_cal_type,
                            p_old_grd_ci_sequence_number            =>  old_references.grd_ci_sequence_number,
                            p_new_grd_ci_sequence_number            =>  new_references.grd_ci_sequence_number,
                            p_old_course_cd                         =>  old_references.course_cd,
                            p_new_course_cd                         =>  new_references.course_cd,
                            p_old_award_course_cd                   =>  old_references.award_course_cd,
                            p_new_award_course_cd                   =>  new_references.award_course_cd,
                            p_old_award_crs_version_number          =>  old_references.award_crs_version_number,
                            p_new_award_crs_version_number          =>  new_references.award_crs_version_number,
                            p_old_award_cd                          =>  old_references.award_cd,
                            p_new_award_cd                          =>  new_references.award_cd,
                            p_old_graduand_status                   =>  old_references.graduand_status,
                            p_new_graduand_status                   =>  new_references.graduand_status,
                            p_old_graduand_appr_status              =>  old_references.graduand_appr_status,
                            p_new_graduand_appr_status              =>  new_references.graduand_appr_status,
                            p_old_s_graduand_type                   =>  old_references.s_graduand_type,
                            p_new_s_graduand_type                   =>  new_references.s_graduand_type,
                            p_old_graduation_name                   =>  old_references.graduation_name,
                            p_new_graduation_name                   =>  new_references.graduation_name,
                            p_old_proxy_award_ind                   =>  old_references.proxy_award_ind,
                            p_new_proxy_award_ind                   =>  new_references.proxy_award_ind,
                            p_old_proxy_award_person_id             =>  old_references.proxy_award_person_id,
                            p_new_proxy_award_person_id             =>  new_references.proxy_award_person_id,
                            p_old_previous_qualifications           =>  old_references.previous_qualifications,
                            p_new_previous_qualifications           =>  new_references.previous_qualifications,
                            p_old_convocation_memb_ind              =>  old_references.convocation_membership_ind,
                            p_new_convocation_memb_ind              =>  new_references.convocation_membership_ind,
                            p_old_sur_for_course_cd                 =>  old_references.sur_for_course_cd,
                            p_new_sur_for_course_cd                 =>  new_references.sur_for_course_cd,
                            p_old_sur_for_crs_version_numb          =>  old_references.sur_for_crs_version_number,
                            p_new_sur_for_crs_version_numb          =>  new_references.sur_for_crs_version_number,
                            p_old_sur_for_award_cd                  =>  old_references.sur_for_award_cd,
                            p_new_sur_for_award_cd                  =>  new_references.sur_for_award_cd,
                            p_old_update_who                        =>  old_references.last_updated_by,
                            p_new_update_who                        =>  new_references.last_updated_by,
                            p_old_update_on                         =>  old_references.last_update_date,
                            p_new_update_on                         =>  new_references.last_update_date,
                            p_old_comments                          =>  old_references.comments,
                            p_new_comments                          =>  new_references.comments);
Line: 442

  END AfterRowUpdate3;
Line: 444

  PROCEDURE before_insert_update(p_inserting IN BOOLEAN DEFAULT FALSE,
                                 p_updating  IN BOOLEAN DEFAULT FALSE ) AS
    CURSOR c_closed_ind (cp_c_award_cd IN IGS_PS_AWARD.AWARD_CD%TYPE,
                         cp_c_course_cd IN IGS_PS_AWARD.COURSE_CD%TYPE,
                         cp_n_version_num IN IGS_PS_AWARD.VERSION_NUMBER%TYPE) IS
      SELECT CLOSED_IND
      FROM IGS_PS_AWARD
      WHERE AWARD_CD = cp_c_award_cd
      AND   COURSE_CD = cp_c_course_cd
      AND   VERSION_NUMBER = cp_n_version_num;
Line: 458

      IF p_inserting OR ( p_updating AND new_references.award_cd <> old_references.award_cd ) THEN
         OPEN c_closed_ind(new_references.award_cd,new_references.award_course_cd, new_references.award_crs_version_number);
Line: 469

      IF p_inserting OR ( p_updating AND new_references.sur_for_award_cd <> old_references.sur_for_award_cd ) THEN
         OPEN c_closed_ind(new_references.sur_for_award_cd, new_references.sur_for_course_cd, new_references.sur_for_crs_version_number);
Line: 479

  END before_insert_update;
Line: 491

		FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED2');
Line: 510

		FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED3');
Line: 526

		FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED4');
Line: 538

		FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED5');
Line: 551

		FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED6');
Line: 565

		FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED7');
Line: 578

		FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED8');
Line: 594

		FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED9');
Line: 613

		FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED0');
Line: 827

      SELECT   rowid
      FROM     IGS_GR_GRADUAND_ALL
      WHERE    person_id = x_person_id
      AND      create_dt = x_create_dt
      FOR UPDATE NOWAIT;
Line: 858

      SELECT   rowid
      FROM     IGS_GR_GRADUAND_ALL
      WHERE    person_id = x_person_id
      AND      create_dt = x_create_dt
	AND	   award_course_cd = x_award_course_cd
	AND	   award_crs_version_number = x_award_crs_version_number
	AND	   award_cd = x_award_cd
	AND (l_rowid is null or rowid <> l_rowid )
      FOR UPDATE NOWAIT;
Line: 891

      SELECT   rowid
      FROM     IGS_GR_GRADUAND_ALL
      WHERE    grd_cal_type = x_grd_cal_type
      AND      grd_ci_sequence_number = x_grd_ci_sequence_number ;
Line: 918

      SELECT   rowid
      FROM     IGS_GR_GRADUAND_ALL
      WHERE    graduand_appr_status = x_graduand_appr_status ;
Line: 944

      SELECT   rowid
      FROM     IGS_GR_GRADUAND_ALL
      WHERE    graduand_status = x_graduand_status ;
Line: 977

      SELECT   rowid
      FROM     IGS_GR_GRADUAND_ALL
      WHERE    (person_id = x_person_id)
	OR	   (proxy_award_person_id = x_person_id);
Line: 1005

      SELECT   rowid
      FROM     IGS_GR_GRADUAND_ALL
      WHERE    person_id = x_person_id
      AND      course_cd = x_course_cd ;
Line: 1034

      SELECT   rowid
      FROM     IGS_GR_GRADUAND_ALL
      WHERE    person_id = x_person_id
      AND      course_cd = x_course_cd
      AND      award_cd  = x_award_cd;
Line: 1084

    x_last_update_date IN DATE ,
    x_last_updated_by IN NUMBER ,
    x_last_update_login IN NUMBER ,
    x_org_id IN NUMBER ,
    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
  ) AS
  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_person_id,
      x_create_dt,
      x_grd_cal_type,
      x_grd_ci_sequence_number,
      x_course_cd,
      x_award_course_cd,
      x_award_crs_version_number,
      x_award_cd,
      x_graduand_status,
      x_graduand_appr_status,
      x_s_graduand_type,
      x_graduation_name,
      x_proxy_award_ind,
      x_proxy_award_person_id,
      x_previous_qualifications,
      x_convocation_membership_ind,
      x_sur_for_course_cd,
      x_sur_for_crs_version_number,
      x_sur_for_award_cd,
      x_comments,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login ,
      x_org_id,
      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
    );
Line: 1164

    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
      BeforeRowInsertUpdate1 ( p_inserting => TRUE,
      p_updating => FALSE,
      p_deleting => FALSE );
Line: 1169

      before_insert_update( p_inserting => TRUE, p_updating => FALSE);
Line: 1181

    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to Before Update.
      BeforeRowInsertUpdate1 ( p_updating => TRUE ,
      p_inserting => FALSE,
    p_deleting => FALSE);
Line: 1186

      before_insert_update( p_inserting => FALSE, p_updating => TRUE);
Line: 1191

    ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to Before Delete.
      Check_Child_Existance;
Line: 1194

    ELSIF (p_action = 'VALIDATE_INSERT') THEN
	IF GET_PK_FOR_VALIDATION(
		    NEW_REFERENCES.person_id,
		    NEW_REFERENCES.create_dt
		) THEN
		Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
Line: 1205

    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
	check_uniqueness;
Line: 1209

    ELSIF (p_action = 'VALIDATE_DELETE') THEN
	check_child_existance;
Line: 1223

    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to After Insert.
      AfterRowInsertUpdate2 ( p_inserting => TRUE ,
      p_updating => FALSE ,
     p_deleting=>FALSE);
Line: 1228

    ELSIF (p_action = 'UPDATE') THEN
      -- Call all the procedures related to After Update.
      AfterRowInsertUpdate2 ( p_updating => TRUE ,
      p_inserting => FALSE ,
      p_deleting =>FALSE );
Line: 1233

      AfterRowUpdate3 ( p_updating => TRUE,
      p_inserting =>FALSE,
      p_deleting =>FALSE );
Line: 1242

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_PERSON_ID in NUMBER,
  X_CREATE_DT in out NOCOPY DATE,
  X_GRD_CAL_TYPE in VARCHAR2,
  X_GRD_CI_SEQUENCE_NUMBER in NUMBER,
  X_COURSE_CD in VARCHAR2,
  X_AWARD_COURSE_CD in VARCHAR2,
  X_AWARD_CRS_VERSION_NUMBER in NUMBER,
  X_AWARD_CD in VARCHAR2,
  X_HONOURS_LEVEL in VARCHAR2 DEFAULT NULL,
  X_CONFERRAL_DT in DATE DEFAULT NULL,
  X_GRADUAND_STATUS in VARCHAR2,
  X_GRADUAND_APPR_STATUS in VARCHAR2,
  X_S_GRADUAND_TYPE in VARCHAR2,
  X_GRADUATION_NAME in VARCHAR2,
  X_PROXY_AWARD_IND in VARCHAR2,
  X_PROXY_AWARD_PERSON_ID in NUMBER,
  X_PREVIOUS_QUALIFICATIONS in VARCHAR2,
  X_CONVOCATION_MEMBERSHIP_IND in VARCHAR2,
  X_SUR_FOR_COURSE_CD in VARCHAR2,
  X_SUR_FOR_CRS_VERSION_NUMBER in NUMBER,
  X_SUR_FOR_AWARD_CD in VARCHAR2,
  X_COMMENTS in VARCHAR2,
  X_MODE in VARCHAR2 ,
  X_ORG_ID in NUMBER,
  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
  ) AS
    cursor C is select ROWID from IGS_GR_GRADUAND_ALL
      where PERSON_ID = X_PERSON_ID
      and CREATE_DT = NEW_REFERENCES.CREATE_DT;
Line: 1293

    X_LAST_UPDATE_DATE DATE;
Line: 1294

    X_LAST_UPDATED_BY NUMBER;
Line: 1295

    X_LAST_UPDATE_LOGIN NUMBER;
Line: 1299

    X_PROGRAM_UPDATE_DATE DATE;
Line: 1301

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 1303

    X_LAST_UPDATED_BY := 1;
Line: 1304

    X_LAST_UPDATE_LOGIN := 0;
Line: 1306

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1307

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;
Line: 1310

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 1311

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;
Line: 1321

    	X_PROGRAM_UPDATE_DATE := NULL;
Line: 1323

    	X_PROGRAM_UPDATE_DATE := SYSDATE;
Line: 1332

     p_action => 'INSERT',
     x_rowid => X_ROWID,
    x_person_id => X_PERSON_ID,
    x_create_dt => NVL(X_CREATE_DT, SYSDATE),
    x_grd_cal_type => X_GRD_CAL_TYPE,
    x_grd_ci_sequence_number => X_GRD_CI_SEQUENCE_NUMBER,
    x_course_cd => X_COURSE_CD,
    x_award_course_cd => X_AWARD_COURSE_CD,
    x_award_crs_version_number => X_AWARD_CRS_VERSION_NUMBER,
    x_award_cd => X_AWARD_CD,
    x_graduand_status => X_GRADUAND_STATUS,
    x_graduand_appr_status => X_GRADUAND_APPR_STATUS,
    x_s_graduand_type => NVL(X_S_GRADUAND_TYPE, 'UNKNOWN'),
    x_graduation_name => X_GRADUATION_NAME,
    x_proxy_award_ind => NVL(X_PROXY_AWARD_IND, 'N'),
    x_proxy_award_person_id => X_PROXY_AWARD_PERSON_ID,
    x_previous_qualifications => X_PREVIOUS_QUALIFICATIONS,
    x_convocation_membership_ind => NVL(X_CONVOCATION_MEMBERSHIP_IND, 'N'),
    x_sur_for_course_cd => X_SUR_FOR_COURSE_CD,
    x_sur_for_crs_version_number => X_SUR_FOR_CRS_VERSION_NUMBER,
    x_sur_for_award_cd => X_SUR_FOR_AWARD_CD,
    x_comments => X_COMMENTS,
    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_org_id => igs_ge_gen_003.get_org_id,
     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
  );
Line: 1383

  insert into IGS_GR_GRADUAND_ALL (
    PERSON_ID,
    CREATE_DT,
    GRD_CAL_TYPE,
    GRD_CI_SEQUENCE_NUMBER,
    COURSE_CD,
    AWARD_COURSE_CD,
    AWARD_CRS_VERSION_NUMBER,
    AWARD_CD,
    GRADUAND_STATUS,
    GRADUAND_APPR_STATUS,
    S_GRADUAND_TYPE,
    GRADUATION_NAME,
    PROXY_AWARD_IND,
    PROXY_AWARD_PERSON_ID,
    PREVIOUS_QUALIFICATIONS,
    CONVOCATION_MEMBERSHIP_IND,
    SUR_FOR_COURSE_CD,
    SUR_FOR_CRS_VERSION_NUMBER,
    SUR_FOR_AWARD_CD,
    COMMENTS,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    REQUEST_ID,
    PROGRAM_ID,
    PROGRAM_APPLICATION_ID,
    PROGRAM_UPDATE_DATE,
    ORG_ID,
    ATTRIBUTE_CATEGORY,
    ATTRIBUTE1,
    ATTRIBUTE2,
    ATTRIBUTE3,
    ATTRIBUTE4,
    ATTRIBUTE5,
    ATTRIBUTE6,
    ATTRIBUTE7,
    ATTRIBUTE8,
    ATTRIBUTE9,
    ATTRIBUTE10,
    ATTRIBUTE11,
    ATTRIBUTE12,
    ATTRIBUTE13,
    ATTRIBUTE14,
    ATTRIBUTE15,
    ATTRIBUTE16,
    ATTRIBUTE17,
    ATTRIBUTE18,
    ATTRIBUTE19,
    ATTRIBUTE20
  ) values (
    NEW_REFERENCES.PERSON_ID,
    NEW_REFERENCES.CREATE_DT,
    NEW_REFERENCES.GRD_CAL_TYPE,
    NEW_REFERENCES.GRD_CI_SEQUENCE_NUMBER,
    NEW_REFERENCES.COURSE_CD,
    NEW_REFERENCES.AWARD_COURSE_CD,
    NEW_REFERENCES.AWARD_CRS_VERSION_NUMBER,
    NEW_REFERENCES.AWARD_CD,
    NEW_REFERENCES.GRADUAND_STATUS,
    NEW_REFERENCES.GRADUAND_APPR_STATUS,
    NEW_REFERENCES.S_GRADUAND_TYPE,
    NEW_REFERENCES.GRADUATION_NAME,
    NEW_REFERENCES.PROXY_AWARD_IND,
    NEW_REFERENCES.PROXY_AWARD_PERSON_ID,
    NEW_REFERENCES.PREVIOUS_QUALIFICATIONS,
    NEW_REFERENCES.CONVOCATION_MEMBERSHIP_IND,
    NEW_REFERENCES.SUR_FOR_COURSE_CD,
    NEW_REFERENCES.SUR_FOR_CRS_VERSION_NUMBER,
    NEW_REFERENCES.SUR_FOR_AWARD_CD,
    NEW_REFERENCES.COMMENTS,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_REQUEST_ID,
    X_PROGRAM_ID,
    X_PROGRAM_APPLICATION_ID,
    X_PROGRAM_UPDATE_DATE,
    NEW_REFERENCES.ORG_ID,
    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
  );
Line: 1498

     p_action => 'INSERT',
     x_rowid => X_ROWID
    );
Line: 1502

end INSERT_ROW;
Line: 1550

  cursor c1 is select
      GRD_CAL_TYPE,
      GRD_CI_SEQUENCE_NUMBER,
      COURSE_CD,
      AWARD_COURSE_CD,
      AWARD_CRS_VERSION_NUMBER,
      AWARD_CD,
      GRADUAND_STATUS,
      GRADUAND_APPR_STATUS,
      S_GRADUAND_TYPE,
      GRADUATION_NAME,
      PROXY_AWARD_IND,
      PROXY_AWARD_PERSON_ID,
      PREVIOUS_QUALIFICATIONS,
      CONVOCATION_MEMBERSHIP_IND,
      SUR_FOR_COURSE_CD,
      SUR_FOR_CRS_VERSION_NUMBER,
      SUR_FOR_AWARD_CD,
      COMMENTS,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15,
      ATTRIBUTE16,
      ATTRIBUTE17,
      ATTRIBUTE18,
      ATTRIBUTE19,
      ATTRIBUTE20
    from IGS_GR_GRADUAND_ALL
    where ROWID = X_ROWID for update nowait;
Line: 1599

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED11');
Line: 1713

procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_PERSON_ID in NUMBER,
  X_CREATE_DT in DATE,
  X_GRD_CAL_TYPE in VARCHAR2,
  X_GRD_CI_SEQUENCE_NUMBER in NUMBER,
  X_COURSE_CD in VARCHAR2,
  X_AWARD_COURSE_CD in VARCHAR2,
  X_AWARD_CRS_VERSION_NUMBER in NUMBER,
  X_AWARD_CD in VARCHAR2,
  X_HONOURS_LEVEL in VARCHAR2 DEFAULT NULL,
  X_CONFERRAL_DT in DATE DEFAULT NULL,
  X_GRADUAND_STATUS in VARCHAR2,
  X_GRADUAND_APPR_STATUS in VARCHAR2,
  X_S_GRADUAND_TYPE in VARCHAR2,
  X_GRADUATION_NAME in VARCHAR2,
  X_PROXY_AWARD_IND in VARCHAR2,
  X_PROXY_AWARD_PERSON_ID in NUMBER,
  X_PREVIOUS_QUALIFICATIONS in VARCHAR2,
  X_CONVOCATION_MEMBERSHIP_IND in VARCHAR2,
  X_SUR_FOR_COURSE_CD in VARCHAR2,
  X_SUR_FOR_CRS_VERSION_NUMBER in NUMBER,
  X_SUR_FOR_AWARD_CD in VARCHAR2,
  X_COMMENTS in VARCHAR2,
  X_MODE 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
  ) AS
    X_LAST_UPDATE_DATE DATE;
Line: 1761

    X_LAST_UPDATED_BY NUMBER;
Line: 1762

    X_LAST_UPDATE_LOGIN NUMBER;
Line: 1766

    X_PROGRAM_UPDATE_DATE DATE;
Line: 1768

  X_LAST_UPDATE_DATE := SYSDATE;
Line: 1770

    X_LAST_UPDATED_BY := 1;
Line: 1771

    X_LAST_UPDATE_LOGIN := 0;
Line: 1773

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1774

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;
Line: 1777

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;
Line: 1778

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;
Line: 1788

     p_action => 'UPDATE',
     x_rowid => X_ROWID,
    x_person_id => X_PERSON_ID,
    x_create_dt => X_CREATE_DT,
    x_grd_cal_type => X_GRD_CAL_TYPE,
    x_grd_ci_sequence_number => X_GRD_CI_SEQUENCE_NUMBER,
    x_course_cd => X_COURSE_CD,
    x_award_course_cd => X_AWARD_COURSE_CD,
    x_award_crs_version_number => X_AWARD_CRS_VERSION_NUMBER,
    x_award_cd => X_AWARD_CD,
    x_graduand_status => X_GRADUAND_STATUS,
    x_graduand_appr_status => X_GRADUAND_APPR_STATUS,
    x_s_graduand_type => X_S_GRADUAND_TYPE,
    x_graduation_name => X_GRADUATION_NAME,
    x_proxy_award_ind => X_PROXY_AWARD_IND,
    x_proxy_award_person_id => X_PROXY_AWARD_PERSON_ID,
    x_previous_qualifications => X_PREVIOUS_QUALIFICATIONS,
    x_convocation_membership_ind => X_CONVOCATION_MEMBERSHIP_IND,
    x_sur_for_course_cd => X_SUR_FOR_COURSE_CD,
    x_sur_for_crs_version_number => X_SUR_FOR_CRS_VERSION_NUMBER,
    x_sur_for_award_cd => X_SUR_FOR_AWARD_CD,
    x_comments => X_COMMENTS,
    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_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
     );
Line: 1846

    	X_PROGRAM_UPDATE_DATE := OLD_REFERENCES.PROGRAM_UPDATE_DATE;
Line: 1848

    	X_PROGRAM_UPDATE_DATE := SYSDATE;
Line: 1851

  update IGS_GR_GRADUAND_ALL set
    GRD_CAL_TYPE = NEW_REFERENCES.GRD_CAL_TYPE,
    GRD_CI_SEQUENCE_NUMBER = NEW_REFERENCES.GRD_CI_SEQUENCE_NUMBER,
    COURSE_CD = NEW_REFERENCES.COURSE_CD,
    AWARD_COURSE_CD = NEW_REFERENCES.AWARD_COURSE_CD,
    AWARD_CRS_VERSION_NUMBER = NEW_REFERENCES.AWARD_CRS_VERSION_NUMBER,
    AWARD_CD = NEW_REFERENCES.AWARD_CD,
    GRADUAND_STATUS = NEW_REFERENCES.GRADUAND_STATUS,
    GRADUAND_APPR_STATUS = NEW_REFERENCES.GRADUAND_APPR_STATUS,
    S_GRADUAND_TYPE = NEW_REFERENCES.S_GRADUAND_TYPE,
    GRADUATION_NAME = NEW_REFERENCES.GRADUATION_NAME,
    PROXY_AWARD_IND = NEW_REFERENCES.PROXY_AWARD_IND,
    PROXY_AWARD_PERSON_ID = NEW_REFERENCES.PROXY_AWARD_PERSON_ID,
    PREVIOUS_QUALIFICATIONS = NEW_REFERENCES.PREVIOUS_QUALIFICATIONS,
    CONVOCATION_MEMBERSHIP_IND = NEW_REFERENCES.CONVOCATION_MEMBERSHIP_IND,
    SUR_FOR_COURSE_CD = NEW_REFERENCES.SUR_FOR_COURSE_CD,
    SUR_FOR_CRS_VERSION_NUMBER = NEW_REFERENCES.SUR_FOR_CRS_VERSION_NUMBER,
    SUR_FOR_AWARD_CD = NEW_REFERENCES.SUR_FOR_AWARD_CD,
    COMMENTS = NEW_REFERENCES.COMMENTS,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
    REQUEST_ID = X_REQUEST_ID,
    PROGRAM_ID = X_PROGRAM_ID,
    PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,
    PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE,
    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
  where ROWID = X_ROWID;
Line: 1904

     p_action => 'UPDATE',
     x_rowid => X_ROWID
    );
Line: 1908

end UPDATE_ROW;
Line: 1958

  cursor c1 is select rowid from IGS_GR_GRADUAND_ALL
     where PERSON_ID = X_PERSON_ID
     and CREATE_DT = NVL(X_CREATE_DT, SYSDATE)
  ;
Line: 1968

    INSERT_ROW (
     X_ROWID,
     X_PERSON_ID,
     X_CREATE_DT,
     X_GRD_CAL_TYPE,
     X_GRD_CI_SEQUENCE_NUMBER,
     X_COURSE_CD,
     X_AWARD_COURSE_CD,
     X_AWARD_CRS_VERSION_NUMBER,
     X_AWARD_CD,
     null,
     null,
     X_GRADUAND_STATUS,
     X_GRADUAND_APPR_STATUS,
     X_S_GRADUAND_TYPE,
     X_GRADUATION_NAME,
     X_PROXY_AWARD_IND,
     X_PROXY_AWARD_PERSON_ID,
     X_PREVIOUS_QUALIFICATIONS,
     X_CONVOCATION_MEMBERSHIP_IND,
     X_SUR_FOR_COURSE_CD,
     X_SUR_FOR_CRS_VERSION_NUMBER,
     X_SUR_FOR_AWARD_CD,
     X_COMMENTS,
     X_MODE,
     x_org_id,
     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
);
Line: 2019

  UPDATE_ROW (
   X_ROWID,
   X_PERSON_ID,
   X_CREATE_DT,
   X_GRD_CAL_TYPE,
   X_GRD_CI_SEQUENCE_NUMBER,
   X_COURSE_CD,
   X_AWARD_COURSE_CD,
   X_AWARD_CRS_VERSION_NUMBER,
   X_AWARD_CD,
   null,
   null,
   X_GRADUAND_STATUS,
   X_GRADUAND_APPR_STATUS,
   X_S_GRADUAND_TYPE,
   X_GRADUATION_NAME,
   X_PROXY_AWARD_IND,
   X_PROXY_AWARD_PERSON_ID,
   X_PREVIOUS_QUALIFICATIONS,
   X_CONVOCATION_MEMBERSHIP_IND,
   X_SUR_FOR_COURSE_CD,
   X_SUR_FOR_CRS_VERSION_NUMBER,
   X_SUR_FOR_AWARD_CD,
   X_COMMENTS,
   X_MODE,
   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
);
Line: 2068

procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) AS
begin

 Before_DML (
     p_action => 'DELETE',
     x_rowid => X_ROWID
  );
Line: 2078

  delete from IGS_GR_GRADUAND_ALL
  where ROWID = X_ROWID;
Line: 2084

end DELETE_ROW;