APPS.IGS_GR_GRADUAND_HIST_PKG SQL Statements

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

Line: 37

    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_org_id IN NUMBER DEFAULT NULL
  ) AS

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

Line: 56

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

Line: 58

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

Line: 89

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

Line: 96

    new_references.last_update_date := x_last_update_date;

Line: 97

    new_references.last_updated_by := x_last_updated_by;

Line: 98

    new_references.last_update_login := x_last_update_login;

Line: 109

      SELECT   rowid
      FROM     IGS_GR_GRADUAND_HIST_ALL
      WHERE    person_id = x_person_id
      AND      create_dt = x_create_dt
      AND      hist_start_dt = x_hist_start_dt
      FOR UPDATE NOWAIT;

Line: 383

    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_org_id IN NUMBER DEFAULT NULL
  ) AS
  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_person_id,
      x_create_dt,
      x_hist_start_dt,
      x_hist_end_dt,
      x_hist_who,
      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_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login ,
      x_org_id
    );

Line: 426

    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
	IF GET_PK_FOR_VALIDATION(
	    NEW_REFERENCES.person_id,
	    NEW_REFERENCES.create_dt,
	    NEW_REFERENCES.hist_start_dt
		) THEN
		Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

Line: 438

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

	check_constraints;

Line: 442

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

Line: 453

    ELSIF (p_action = 'VALIDATE_UPDATE') THEN

	check_constraints;

Line: 460

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_PERSON_ID in NUMBER,
  X_CREATE_DT in DATE,
  X_HIST_START_DT in DATE,
  X_HIST_END_DT in DATE,
  X_HIST_WHO in NUMBER,
  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 default 'R',
  X_ORG_ID in NUMBER
  ) AS
    cursor C is select ROWID from IGS_GR_GRADUAND_HIST_ALL
      where PERSON_ID = X_PERSON_ID
      and CREATE_DT = X_CREATE_DT
      and HIST_START_DT = X_HIST_START_DT;

Line: 494

    X_LAST_UPDATE_DATE DATE;

Line: 495

    X_LAST_UPDATED_BY NUMBER;

Line: 496

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 498

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 500

    X_LAST_UPDATED_BY := 1;

Line: 501

    X_LAST_UPDATE_LOGIN := 0;

Line: 503

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 504

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 507

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 508

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 517

     p_action => 'INSERT',
     x_rowid => X_ROWID,
    x_person_id => X_PERSON_ID,
    x_create_dt => X_CREATE_DT,
    x_hist_start_dt => X_HIST_START_DT,
    x_hist_end_dt => X_HIST_END_DT,
    x_hist_who => X_HIST_WHO,
    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 => NVL(X_GRADUAND_STATUS, 'POTENTIAL'),
    x_graduand_appr_status => NVL(X_GRADUAND_APPR_STATUS, 'WAITING'),
    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
  );

Line: 550

  insert into IGS_GR_GRADUAND_HIST_ALL (
    PERSON_ID,
    CREATE_DT,
    HIST_START_DT,
    HIST_END_DT,
    HIST_WHO,
    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,
    ORG_ID
  ) values (
    NEW_REFERENCES.PERSON_ID,
    NEW_REFERENCES.CREATE_DT,
    NEW_REFERENCES.HIST_START_DT,
    NEW_REFERENCES.HIST_END_DT,
    NEW_REFERENCES.HIST_WHO,
    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,
    NEW_REFERENCES.ORG_ID
  );

Line: 620

end INSERT_ROW;

Line: 650

  cursor c1 is select
      HIST_END_DT,
      HIST_WHO,
      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
    from IGS_GR_GRADUAND_HIST_ALL
    where ROWID = X_ROWID for update nowait;

Line: 680

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

Line: 752

procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_PERSON_ID in NUMBER,
  X_CREATE_DT in DATE,
  X_HIST_START_DT in DATE,
  X_HIST_END_DT in DATE,
  X_HIST_WHO in NUMBER,
  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 default 'R'
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 782

    X_LAST_UPDATED_BY NUMBER;

Line: 783

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 785

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 787

    X_LAST_UPDATED_BY := 1;

Line: 788

    X_LAST_UPDATE_LOGIN := 0;

Line: 790

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 791

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 794

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 795

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 804

     p_action => 'UPDATE',
     x_rowid => X_ROWID,
    x_person_id => X_PERSON_ID,
    x_create_dt => X_CREATE_DT,
    x_hist_start_dt => X_HIST_START_DT,
    x_hist_end_dt => X_HIST_END_DT,
    x_hist_who => X_HIST_WHO,
    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
  );

Line: 836

  update IGS_GR_GRADUAND_HIST_ALL set
    HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
    HIST_WHO = NEW_REFERENCES.HIST_WHO,
    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
  where ROWID = X_ROWID
  ;

Line: 866

end UPDATE_ROW;

Line: 898

  cursor c1 is select rowid from IGS_GR_GRADUAND_HIST_ALL
     where PERSON_ID = X_PERSON_ID
     and CREATE_DT = X_CREATE_DT
     and HIST_START_DT = X_HIST_START_DT
  ;

Line: 909

    INSERT_ROW (
     X_ROWID,
     X_PERSON_ID,
     X_CREATE_DT,
     X_HIST_START_DT,
     X_HIST_END_DT,
     X_HIST_WHO,
     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
);

Line: 942

  UPDATE_ROW (
   X_ROWID,
   X_PERSON_ID,
   X_CREATE_DT,
   X_HIST_START_DT,
   X_HIST_END_DT,
   X_HIST_WHO,
   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
);

Line: 973

procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) AS
begin

  delete from IGS_GR_GRADUAND_HIST_ALL
  where ROWID = X_ROWID;

Line: 984

end DELETE_ROW;