APPS.IGS_GR_AWD_CRMN_HIST_PKG SQL Statements

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

Line: 38

    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL
  ) AS

    CURSOR cur_old_ref_values IS
      SELECT   *
      FROM     IGS_GR_AWD_CRMN_HIST
      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: 92

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

Line: 99

    new_references.last_update_date := x_last_update_date;

Line: 100

    new_references.last_updated_by := x_last_updated_by;

Line: 101

    new_references.last_update_login := x_last_update_login;

Line: 118

		FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED');

Line: 371

      SELECT   rowid
      FROM     IGS_GR_AWD_CRMN_HIST
      WHERE    GACH_ID = x_GACH_ID
      FOR UPDATE NOWAIT;

Line: 404

      SELECT   rowid
      FROM     IGS_GR_AWD_CRMN_HIST
      WHERE    person_id = x_person_id
	AND    create_dt = x_create_dt
	AND    grd_cal_type = x_grd_cal_type
	AND    grd_ci_sequence_number = x_grd_ci_sequence_number
	AND    ceremony_number = x_ceremony_number
	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    hist_start_dt = x_hist_start_dt
	AND    (l_rowid is null or rowid <> l_rowid)
      FOR UPDATE NOWAIT;

Line: 440

      SELECT   rowid
      FROM     IGS_GR_AWD_CRMN_HIST
      WHERE    person_id = x_person_id
      AND      create_dt = x_create_dt ;

Line: 493

    x_last_update_date IN DATE DEFAULT NULL,
    x_last_updated_by IN NUMBER DEFAULT NULL,
    x_last_update_login IN NUMBER DEFAULT NULL
  ) AS
  BEGIN

    Set_Column_Values (
      p_action,
      x_rowid,
      x_GACH_ID,
      x_person_id,
      x_create_dt,
      x_grd_cal_type,
      x_grd_ci_sequence_number,
      x_ceremony_number,
      x_award_course_cd,
      x_award_crs_version_number,
      x_award_cd,
      x_hist_start_dt,
      x_hist_end_dt,
      x_hist_who,
      x_us_group_number,
      x_order_in_presentation,
      x_graduand_seat_number,
      x_name_pronunciation,
      x_name_announced,
      x_academic_dress_rqrd_ind,
      x_academic_gown_size,
      x_academic_hat_size,
      x_guest_tickets_requested,
      x_guest_tickets_allocated,
      x_guest_seats,
      x_fees_paid_ind,
      x_special_requirements,
      x_comments,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 535

    IF (p_action = 'INSERT') THEN
      -- Call all the procedures related to Before Insert.
      IF Get_PK_For_Validation (
         NEW_REFERENCES.gach_id) THEN
		Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

Line: 546

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

Line: 551

    ELSIF (p_action = 'VALIDATE_INSERT') THEN
	IF GET_PK_FOR_VALIDATION(NEW_REFERENCES.GACH_ID) THEN
		Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

Line: 559

    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
	check_uniqueness;

Line: 566

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_GACH_ID in out NOCOPY NUMBER,
  X_NAME_PRONUNCIATION in VARCHAR2,
  X_NAME_ANNOUNCED in VARCHAR2,
  X_ACADEMIC_DRESS_RQRD_IND in VARCHAR2,
  X_ACADEMIC_GOWN_SIZE in VARCHAR2,
  X_ACADEMIC_HAT_SIZE in VARCHAR2,
  X_GUEST_TICKETS_REQUESTED in NUMBER,
  X_GUEST_TICKETS_ALLOCATED in NUMBER,
  X_GUEST_SEATS in VARCHAR2,
  X_FEES_PAID_IND in VARCHAR2,
  X_SPECIAL_REQUIREMENTS in VARCHAR2,
  X_COMMENTS in VARCHAR2,
  X_PERSON_ID in NUMBER,
  X_CREATE_DT in DATE,
  X_GRD_CAL_TYPE in VARCHAR2,
  X_GRADUAND_SEAT_NUMBER in VARCHAR2,
  X_HIST_WHO in NUMBER,
  X_US_GROUP_NUMBER in NUMBER,
  X_ORDER_IN_PRESENTATION in NUMBER,
  X_HIST_END_DT in DATE,
  X_GRD_CI_SEQUENCE_NUMBER in NUMBER,
  X_CEREMONY_NUMBER in NUMBER,
  X_AWARD_COURSE_CD in VARCHAR2,
  X_AWARD_CRS_VERSION_NUMBER in NUMBER,
  X_AWARD_CD in VARCHAR2,
  X_HIST_START_DT in DATE,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    cursor C is select ROWID from IGS_GR_AWD_CRMN_HIST
      where GACH_ID = X_GACH_ID;

Line: 598

    X_LAST_UPDATE_DATE DATE;

Line: 599

    X_LAST_UPDATED_BY NUMBER;

Line: 600

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 603

  SELECT IGS_GR_AWD_CRMN_HIST_GACH_ID_S.NEXTVAL INTO X_GACH_ID FROM DUAL;

Line: 605

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 607

    X_LAST_UPDATED_BY := 1;

Line: 608

    X_LAST_UPDATE_LOGIN := 0;

Line: 610

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 611

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 614

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 615

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 625

    p_action => 'INSERT',
    x_rowid => X_ROWID,
    x_GACH_ID => X_GACH_ID,
    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_ceremony_number => X_CEREMONY_NUMBER,
    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_hist_start_dt => X_HIST_START_DT,
    x_hist_end_dt => X_HIST_END_DT,
    x_hist_who => X_HIST_WHO,
    x_us_group_number => X_US_GROUP_NUMBER,
    x_order_in_presentation => X_ORDER_IN_PRESENTATION,
    x_graduand_seat_number => X_GRADUAND_SEAT_NUMBER,
    x_name_pronunciation => X_NAME_PRONUNCIATION,
    x_name_announced => X_NAME_ANNOUNCED,
    x_academic_dress_rqrd_ind => X_ACADEMIC_DRESS_RQRD_IND,
    x_academic_gown_size => X_ACADEMIC_GOWN_SIZE,
    x_academic_hat_size => X_ACADEMIC_HAT_SIZE,
    x_guest_tickets_requested => X_GUEST_TICKETS_REQUESTED,
    x_guest_tickets_allocated => X_GUEST_TICKETS_ALLOCATED,
    x_guest_seats => X_GUEST_SEATS,
    x_fees_paid_ind => X_FEES_PAID_IND,
    x_special_requirements => X_SPECIAL_REQUIREMENTS,
    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: 660

  insert into IGS_GR_AWD_CRMN_HIST (
    NAME_PRONUNCIATION,
    NAME_ANNOUNCED,
    ACADEMIC_DRESS_RQRD_IND,
    ACADEMIC_GOWN_SIZE,
    ACADEMIC_HAT_SIZE,
    GUEST_TICKETS_REQUESTED,
    GUEST_TICKETS_ALLOCATED,
    GUEST_SEATS,
    FEES_PAID_IND,
    SPECIAL_REQUIREMENTS,
    COMMENTS,
    GACH_ID,
    PERSON_ID,
    CREATE_DT,
    GRD_CAL_TYPE,
    GRADUAND_SEAT_NUMBER,
    HIST_WHO,
    US_GROUP_NUMBER,
    ORDER_IN_PRESENTATION,
    HIST_END_DT,
    GRD_CI_SEQUENCE_NUMBER,
    CEREMONY_NUMBER,
    AWARD_COURSE_CD,
    AWARD_CRS_VERSION_NUMBER,
    AWARD_CD,
    HIST_START_DT,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    NEW_REFERENCES.NAME_PRONUNCIATION,
    NEW_REFERENCES.NAME_ANNOUNCED,
    NEW_REFERENCES.ACADEMIC_DRESS_RQRD_IND,
    NEW_REFERENCES.ACADEMIC_GOWN_SIZE,
    NEW_REFERENCES.ACADEMIC_HAT_SIZE,
    NEW_REFERENCES.GUEST_TICKETS_REQUESTED,
    NEW_REFERENCES.GUEST_TICKETS_ALLOCATED,
    NEW_REFERENCES.GUEST_SEATS,
    NEW_REFERENCES.FEES_PAID_IND,
    NEW_REFERENCES.SPECIAL_REQUIREMENTS,
    NEW_REFERENCES.COMMENTS,
    NEW_REFERENCES.GACH_ID,
    NEW_REFERENCES.PERSON_ID,
    NEW_REFERENCES.CREATE_DT,
    NEW_REFERENCES.GRD_CAL_TYPE,
    NEW_REFERENCES.GRADUAND_SEAT_NUMBER,
    NEW_REFERENCES.HIST_WHO,
    NEW_REFERENCES.US_GROUP_NUMBER,
    NEW_REFERENCES.ORDER_IN_PRESENTATION,
    NEW_REFERENCES.HIST_END_DT,
    NEW_REFERENCES.GRD_CI_SEQUENCE_NUMBER,
    NEW_REFERENCES.CEREMONY_NUMBER,
    NEW_REFERENCES.AWARD_COURSE_CD,
    NEW_REFERENCES.AWARD_CRS_VERSION_NUMBER,
    NEW_REFERENCES.AWARD_CD,
    NEW_REFERENCES.HIST_START_DT,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 734

end INSERT_ROW;

Line: 765

  cursor c1 is select
      NAME_PRONUNCIATION,
      NAME_ANNOUNCED,
      ACADEMIC_DRESS_RQRD_IND,
      ACADEMIC_GOWN_SIZE,
      ACADEMIC_HAT_SIZE,
      GUEST_TICKETS_REQUESTED,
      GUEST_TICKETS_ALLOCATED,
      GUEST_SEATS,
      FEES_PAID_IND,
      SPECIAL_REQUIREMENTS,
      COMMENTS,
      PERSON_ID,
      CREATE_DT,
      GRD_CAL_TYPE,
      GRADUAND_SEAT_NUMBER,
      HIST_WHO,
      US_GROUP_NUMBER,
      ORDER_IN_PRESENTATION,
      HIST_END_DT,
      GRD_CI_SEQUENCE_NUMBER,
      CEREMONY_NUMBER,
      AWARD_COURSE_CD,
      AWARD_CRS_VERSION_NUMBER,
      AWARD_CD,
      HIST_START_DT
    from IGS_GR_AWD_CRMN_HIST
    where ROWID = X_ROWID for update nowait;

Line: 800

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

Line: 872

procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_GACH_ID in NUMBER,
  X_NAME_PRONUNCIATION in VARCHAR2,
  X_NAME_ANNOUNCED in VARCHAR2,
  X_ACADEMIC_DRESS_RQRD_IND in VARCHAR2,
  X_ACADEMIC_GOWN_SIZE in VARCHAR2,
  X_ACADEMIC_HAT_SIZE in VARCHAR2,
  X_GUEST_TICKETS_REQUESTED in NUMBER,
  X_GUEST_TICKETS_ALLOCATED in NUMBER,
  X_GUEST_SEATS in VARCHAR2,
  X_FEES_PAID_IND in VARCHAR2,
  X_SPECIAL_REQUIREMENTS in VARCHAR2,
  X_COMMENTS in VARCHAR2,
  X_PERSON_ID in NUMBER,
  X_CREATE_DT in DATE,
  X_GRD_CAL_TYPE in VARCHAR2,
  X_GRADUAND_SEAT_NUMBER in VARCHAR2,
  X_HIST_WHO in NUMBER,
  X_US_GROUP_NUMBER in NUMBER,
  X_ORDER_IN_PRESENTATION in NUMBER,
  X_HIST_END_DT in DATE,
  X_GRD_CI_SEQUENCE_NUMBER in NUMBER,
  X_CEREMONY_NUMBER in NUMBER,
  X_AWARD_COURSE_CD in VARCHAR2,
  X_AWARD_CRS_VERSION_NUMBER in NUMBER,
  X_AWARD_CD in VARCHAR2,
  X_HIST_START_DT in DATE,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 903

    X_LAST_UPDATED_BY NUMBER;

Line: 904

    X_LAST_UPDATE_LOGIN NUMBER;

Line: 906

  X_LAST_UPDATE_DATE := SYSDATE;

Line: 908

    X_LAST_UPDATED_BY := 1;

Line: 909

    X_LAST_UPDATE_LOGIN := 0;

Line: 911

    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 912

    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 915

    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 916

    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 926

    p_action => 'UPDATE',
    x_rowid => X_ROWID,
    x_GACH_ID => X_GACH_ID,
    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_ceremony_number => X_CEREMONY_NUMBER,
    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_hist_start_dt => X_HIST_START_DT,
    x_hist_end_dt => X_HIST_END_DT,
    x_hist_who => X_HIST_WHO,
    x_us_group_number => X_US_GROUP_NUMBER,
    x_order_in_presentation => X_ORDER_IN_PRESENTATION,
    x_graduand_seat_number => X_GRADUAND_SEAT_NUMBER,
    x_name_pronunciation => X_NAME_PRONUNCIATION,
    x_name_announced => X_NAME_ANNOUNCED,
    x_academic_dress_rqrd_ind => X_ACADEMIC_DRESS_RQRD_IND,
    x_academic_gown_size => X_ACADEMIC_GOWN_SIZE,
    x_academic_hat_size => X_ACADEMIC_HAT_SIZE,
    x_guest_tickets_requested => X_GUEST_TICKETS_REQUESTED,
    x_guest_tickets_allocated => X_GUEST_TICKETS_ALLOCATED,
    x_guest_seats => X_GUEST_SEATS,
    x_fees_paid_ind => X_FEES_PAID_IND,
    x_special_requirements => X_SPECIAL_REQUIREMENTS,
    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: 961

  update IGS_GR_AWD_CRMN_HIST set
    NAME_PRONUNCIATION = NEW_REFERENCES.NAME_PRONUNCIATION,
    NAME_ANNOUNCED = NEW_REFERENCES.NAME_ANNOUNCED,
    ACADEMIC_DRESS_RQRD_IND = NEW_REFERENCES.ACADEMIC_DRESS_RQRD_IND,
    ACADEMIC_GOWN_SIZE = NEW_REFERENCES.ACADEMIC_GOWN_SIZE,
    ACADEMIC_HAT_SIZE = NEW_REFERENCES.ACADEMIC_HAT_SIZE,
    GUEST_TICKETS_REQUESTED = NEW_REFERENCES.GUEST_TICKETS_REQUESTED,
    GUEST_TICKETS_ALLOCATED = NEW_REFERENCES.GUEST_TICKETS_ALLOCATED,
    GUEST_SEATS = NEW_REFERENCES.GUEST_SEATS,
    FEES_PAID_IND = NEW_REFERENCES.FEES_PAID_IND,
    SPECIAL_REQUIREMENTS = NEW_REFERENCES.SPECIAL_REQUIREMENTS,
    COMMENTS = NEW_REFERENCES.COMMENTS,
    PERSON_ID = NEW_REFERENCES.PERSON_ID,
    CREATE_DT = NEW_REFERENCES.CREATE_DT,
    GRD_CAL_TYPE = NEW_REFERENCES.GRD_CAL_TYPE,
    GRADUAND_SEAT_NUMBER = NEW_REFERENCES.GRADUAND_SEAT_NUMBER,
    HIST_WHO = NEW_REFERENCES.HIST_WHO,
    US_GROUP_NUMBER = NEW_REFERENCES.US_GROUP_NUMBER,
    ORDER_IN_PRESENTATION = NEW_REFERENCES.ORDER_IN_PRESENTATION,
    HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
    GRD_CI_SEQUENCE_NUMBER = NEW_REFERENCES.GRD_CI_SEQUENCE_NUMBER,
    CEREMONY_NUMBER = NEW_REFERENCES.CEREMONY_NUMBER,
    AWARD_COURSE_CD = NEW_REFERENCES.AWARD_COURSE_CD,
    AWARD_CRS_VERSION_NUMBER = NEW_REFERENCES.AWARD_CRS_VERSION_NUMBER,
    AWARD_CD = NEW_REFERENCES.AWARD_CD,
    HIST_START_DT = NEW_REFERENCES.HIST_START_DT,
    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: 996

end UPDATE_ROW;

Line: 1028

  cursor c1 is select rowid from IGS_GR_AWD_CRMN_HIST
     where GACH_ID = X_GACH_ID
  ;

Line: 1037

    INSERT_ROW (
     X_ROWID,
     X_GACH_ID,
     X_NAME_PRONUNCIATION,
     X_NAME_ANNOUNCED,
     X_ACADEMIC_DRESS_RQRD_IND,
     X_ACADEMIC_GOWN_SIZE,
     X_ACADEMIC_HAT_SIZE,
     X_GUEST_TICKETS_REQUESTED,
     X_GUEST_TICKETS_ALLOCATED,
     X_GUEST_SEATS,
     X_FEES_PAID_IND,
     X_SPECIAL_REQUIREMENTS,
     X_COMMENTS,
     X_PERSON_ID,
     X_CREATE_DT,
     X_GRD_CAL_TYPE,
     X_GRADUAND_SEAT_NUMBER,
     X_HIST_WHO,
     X_US_GROUP_NUMBER,
     X_ORDER_IN_PRESENTATION,
     X_HIST_END_DT,
     X_GRD_CI_SEQUENCE_NUMBER,
     X_CEREMONY_NUMBER,
     X_AWARD_COURSE_CD,
     X_AWARD_CRS_VERSION_NUMBER,
     X_AWARD_CD,
     X_HIST_START_DT,
     X_MODE);

Line: 1069

  UPDATE_ROW (
   X_ROWID,
   X_GACH_ID,
   X_NAME_PRONUNCIATION,
   X_NAME_ANNOUNCED,
   X_ACADEMIC_DRESS_RQRD_IND,
   X_ACADEMIC_GOWN_SIZE,
   X_ACADEMIC_HAT_SIZE,
   X_GUEST_TICKETS_REQUESTED,
   X_GUEST_TICKETS_ALLOCATED,
   X_GUEST_SEATS,
   X_FEES_PAID_IND,
   X_SPECIAL_REQUIREMENTS,
   X_COMMENTS,
   X_PERSON_ID,
   X_CREATE_DT,
   X_GRD_CAL_TYPE,
   X_GRADUAND_SEAT_NUMBER,
   X_HIST_WHO,
   X_US_GROUP_NUMBER,
   X_ORDER_IN_PRESENTATION,
   X_HIST_END_DT,
   X_GRD_CI_SEQUENCE_NUMBER,
   X_CEREMONY_NUMBER,
   X_AWARD_COURSE_CD,
   X_AWARD_CRS_VERSION_NUMBER,
   X_AWARD_CD,
   X_HIST_START_DT,
   X_MODE);

Line: 1100

procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) AS
begin

  delete from IGS_GR_AWD_CRMN_HIST
  where ROWID = X_ROWID;

Line: 1111

end DELETE_ROW;