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_GR_CRMN_PKG SQL Statements

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

Line: 24


    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_CRMN_ALL
      WHERE    rowid = x_rowid;

Line: 43


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

Line: 45


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

Line: 66


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

Line: 73


    new_references.last_update_date := x_last_update_date;

Line: 74


    new_references.last_updated_by := x_last_updated_by;

Line: 75


    new_references.last_update_login := x_last_update_login;

Line: 85


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


	-- Validate the graduation ceremony record can be updated
	IF p_updating THEN
		IF (new_references.ceremony_dt_alias <> old_references.ceremony_dt_alias OR
		    new_references.ceremony_dai_sequence_number <> old_references.ceremony_dai_sequence_number OR
		    new_references.closing_dt_alias <> old_references.closing_dt_alias OR
		    new_references.closing_dai_sequence_number <> old_references.closing_dai_sequence_number) THEN
			IF IGS_GR_VAL_GC.grdp_val_gc_upd(
					new_references.grd_cal_type,
					new_references.grd_ci_sequence_number,
					new_references.ceremony_number,
					v_message_name) = FALSE THEN
				Fnd_Message.Set_Name('IGS', v_message_name);

Line: 109


	IF p_inserting OR (p_updating AND new_references.venue_cd <> old_references.venue_cd) THEN
		-- Validate venue is related to a location with a s_location_type of grd_ctr
		IF IGS_GR_VAL_GC.grdp_val_ve_lot(
				new_references.venue_cd,
				v_message_name) = FALSE THEN
			Fnd_Message.Set_Name('IGS', v_message_name);

Line: 127


	IF p_inserting OR (p_updating AND
	(new_references.ceremony_dt_alias <> old_references.ceremony_dt_alias OR
	new_references.ceremony_dai_sequence_number <> old_references.ceremony_dai_sequence_number OR
	new_references.closing_dt_alias <> old_references.closing_dt_alias OR
	new_references.closing_dai_sequence_number <> old_references.closing_dai_sequence_number)) THEN
		-- Validate the graduation ceremony date aliases
		IF IGS_GR_VAL_GC.grdp_val_gc_dai(
				new_references.grd_cal_type,
				new_references.grd_ci_sequence_number,
				new_references.ceremony_dt_alias,
				new_references.ceremony_dai_sequence_number,
				new_references.closing_dt_alias,
				new_references.closing_dai_sequence_number,
				v_message_name) = FALSE THEN
			Fnd_Message.Set_Name('IGS', v_message_name);

Line: 148


  END BeforeRowInsertUpdate1;

Line: 156


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


	IF p_inserting OR (p_updating AND
	   (new_references.ceremony_start_time <> old_references.ceremony_start_time OR
	   new_references.ceremony_end_time <> old_references.ceremony_end_time)) THEN
  			-- validate graduation ceremony start and end times
  			IF IGS_GR_VAL_GC.grdp_val_gc_times(
  					NEW_REFERENCES.grd_cal_type,
  					NEW_REFERENCES.grd_ci_sequence_number,
  					NEW_REFERENCES.ceremony_number,
  					NEW_REFERENCES.venue_cd,
  					NEW_REFERENCES.ceremony_dt_alias,
  					NEW_REFERENCES.ceremony_dai_sequence_number,
  					NEW_REFERENCES.ceremony_start_time,
  					NEW_REFERENCES.ceremony_end_time,
  					v_message_name) = FALSE THEN
  				Fnd_Message.Set_Name('IGS', v_message_name);

Line: 185


  END AfterRowInsertUpdate2;

Line: 206


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

Line: 229


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

Line: 246


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

Line: 260


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

Line: 416


      SELECT   rowid
      FROM     IGS_GR_CRMN_ALL
      WHERE    grd_cal_type = x_grd_cal_type
      AND      grd_ci_sequence_number = x_grd_ci_sequence_number
      AND      ceremony_number = x_ceremony_number
      FOR UPDATE NOWAIT;

Line: 446


      SELECT   rowid
      FROM     IGS_GR_CRMN_ALL
      WHERE    (ceremony_dt_alias = x_dt_alias
      AND      ceremony_dai_sequence_number = x_sequence_number
      AND      grd_cal_type = x_cal_type
      AND      grd_ci_sequence_number = x_ci_sequence_number)
	OR	   (closing_dt_alias = x_dt_alias
      AND      closing_dai_sequence_number = x_sequence_number
      AND      grd_cal_type = x_cal_type
      AND      grd_ci_sequence_number = x_ci_sequence_number) ;

Line: 480


      SELECT   rowid
      FROM     IGS_GR_CRMN_ALL
      WHERE    grd_cal_type = x_grd_cal_type
      AND      grd_ci_sequence_number = x_grd_ci_sequence_number ;

Line: 507


      SELECT   rowid
      FROM     IGS_GR_CRMN_ALL
      WHERE    venue_cd = x_venue_cd ;

Line: 545


    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_grd_cal_type,
      x_grd_ci_sequence_number,
      x_ceremony_number,
      x_venue_cd,
      x_ceremony_dt_alias,
      x_ceremony_dai_sequence_number,
      x_closing_dt_alias,
      x_closing_dai_sequence_number,
      x_ceremony_start_time,
      x_ceremony_end_time,
      x_ceremony_fee,
      x_number_of_guests,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login ,
      x_org_id
    );

Line: 575


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

Line: 590


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

Line: 596


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

Line: 599


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
	IF GET_PK_FOR_VALIDATION(
	    NEW_REFERENCES.grd_cal_type,
	    NEW_REFERENCES.grd_ci_sequence_number,
	    NEW_REFERENCES.ceremony_number
		) THEN
		Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');

Line: 611


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN

	check_constraints;

Line: 614


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
	check_child_existance;

Line: 628


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

Line: 631


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

Line: 638


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_GRD_CAL_TYPE in VARCHAR2,
  X_GRD_CI_SEQUENCE_NUMBER in NUMBER,
  X_CEREMONY_NUMBER in NUMBER,
  X_VENUE_CD in VARCHAR2,
  X_CEREMONY_DT_ALIAS in VARCHAR2,
  X_CEREMONY_DAI_SEQUENCE_NUMBER in NUMBER,
  X_CLOSING_DT_ALIAS in VARCHAR2,
  X_CLOSING_DAI_SEQUENCE_NUMBER in NUMBER,
  X_CEREMONY_START_TIME in DATE,
  X_CEREMONY_END_TIME in DATE,
  X_CEREMONY_FEE in NUMBER,
  X_NUMBER_OF_GUESTS in NUMBER,
  X_MODE in VARCHAR2 default 'R',
  X_ORG_ID in NUMBER
  ) AS
    cursor C is select ROWID from IGS_GR_CRMN_ALL
      where GRD_CAL_TYPE = X_GRD_CAL_TYPE
      and GRD_CI_SEQUENCE_NUMBER = X_GRD_CI_SEQUENCE_NUMBER
      and CEREMONY_NUMBER = X_CEREMONY_NUMBER;

Line: 659


    X_LAST_UPDATE_DATE DATE;

Line: 660


    X_LAST_UPDATED_BY NUMBER;

Line: 661


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 663


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 665


    X_LAST_UPDATED_BY := 1;

Line: 666


    X_LAST_UPDATE_LOGIN := 0;

Line: 668


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 669


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 672


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 673


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 683


     p_action => 'INSERT',
     x_rowid => X_ROWID,
    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_venue_cd => X_VENUE_CD,
    x_ceremony_dt_alias => X_CEREMONY_DT_ALIAS,
    x_ceremony_dai_sequence_number => X_CEREMONY_DAI_SEQUENCE_NUMBER,
    x_closing_dt_alias => X_CLOSING_DT_ALIAS,
    x_closing_dai_sequence_number => X_CLOSING_DAI_SEQUENCE_NUMBER,
    x_ceremony_start_time => X_CEREMONY_START_TIME,
    x_ceremony_end_time => X_CEREMONY_END_TIME,
    x_ceremony_fee => X_CEREMONY_FEE,
    x_number_of_guests => X_NUMBER_OF_GUESTS,
    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: 705


  insert into IGS_GR_CRMN_ALL (
    GRD_CAL_TYPE,
    GRD_CI_SEQUENCE_NUMBER,
    CEREMONY_NUMBER,
    VENUE_CD,
    CEREMONY_DT_ALIAS,
    CEREMONY_DAI_SEQUENCE_NUMBER,
    CLOSING_DT_ALIAS,
    CLOSING_DAI_SEQUENCE_NUMBER,
    CEREMONY_START_TIME,
    CEREMONY_END_TIME,
    CEREMONY_FEE,
    NUMBER_OF_GUESTS,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    ORG_ID
  ) values (
    NEW_REFERENCES.GRD_CAL_TYPE,
    NEW_REFERENCES.GRD_CI_SEQUENCE_NUMBER,
    NEW_REFERENCES.CEREMONY_NUMBER,
    NEW_REFERENCES.VENUE_CD,
    NEW_REFERENCES.CEREMONY_DT_ALIAS,
    NEW_REFERENCES.CEREMONY_DAI_SEQUENCE_NUMBER,
    NEW_REFERENCES.CLOSING_DT_ALIAS,
    NEW_REFERENCES.CLOSING_DAI_SEQUENCE_NUMBER,
    NEW_REFERENCES.CEREMONY_START_TIME,
    NEW_REFERENCES.CEREMONY_END_TIME,
    NEW_REFERENCES.CEREMONY_FEE,
    NEW_REFERENCES.NUMBER_OF_GUESTS,
    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: 754


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

Line: 758


end INSERT_ROW;

Line: 775


  cursor c1 is select
      VENUE_CD,
      CEREMONY_DT_ALIAS,
      CEREMONY_DAI_SEQUENCE_NUMBER,
      CLOSING_DT_ALIAS,
      CLOSING_DAI_SEQUENCE_NUMBER,
      CEREMONY_START_TIME,
      CEREMONY_END_TIME,
      CEREMONY_FEE,
      NUMBER_OF_GUESTS
    from IGS_GR_CRMN_ALL
    where ROWID = X_ROWID for update nowait;

Line: 794


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

Line: 823


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_GRD_CAL_TYPE in VARCHAR2,
  X_GRD_CI_SEQUENCE_NUMBER in NUMBER,
  X_CEREMONY_NUMBER in NUMBER,
  X_VENUE_CD in VARCHAR2,
  X_CEREMONY_DT_ALIAS in VARCHAR2,
  X_CEREMONY_DAI_SEQUENCE_NUMBER in NUMBER,
  X_CLOSING_DT_ALIAS in VARCHAR2,
  X_CLOSING_DAI_SEQUENCE_NUMBER in NUMBER,
  X_CEREMONY_START_TIME in DATE,
  X_CEREMONY_END_TIME in DATE,
  X_CEREMONY_FEE in NUMBER,
  X_NUMBER_OF_GUESTS in NUMBER,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 840


    X_LAST_UPDATED_BY NUMBER;

Line: 841


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 843


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 845


    X_LAST_UPDATED_BY := 1;

Line: 846


    X_LAST_UPDATE_LOGIN := 0;

Line: 848


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 849


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 852


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 853


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 863


     p_action => 'UPDATE',
     x_rowid => X_ROWID,
    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_venue_cd => X_VENUE_CD,
    x_ceremony_dt_alias => X_CEREMONY_DT_ALIAS,
    x_ceremony_dai_sequence_number => X_CEREMONY_DAI_SEQUENCE_NUMBER,
    x_closing_dt_alias => X_CLOSING_DT_ALIAS,
    x_closing_dai_sequence_number => X_CLOSING_DAI_SEQUENCE_NUMBER,
    x_ceremony_start_time => X_CEREMONY_START_TIME,
    x_ceremony_end_time => X_CEREMONY_END_TIME,
    x_ceremony_fee => X_CEREMONY_FEE,
    x_number_of_guests => X_NUMBER_OF_GUESTS,
    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: 884


  update IGS_GR_CRMN_ALL set
    VENUE_CD = NEW_REFERENCES.VENUE_CD,
    CEREMONY_DT_ALIAS = NEW_REFERENCES.CEREMONY_DT_ALIAS,
    CEREMONY_DAI_SEQUENCE_NUMBER = NEW_REFERENCES.CEREMONY_DAI_SEQUENCE_NUMBER,
    CLOSING_DT_ALIAS = NEW_REFERENCES.CLOSING_DT_ALIAS,
    CLOSING_DAI_SEQUENCE_NUMBER = NEW_REFERENCES.CLOSING_DAI_SEQUENCE_NUMBER,
    CEREMONY_START_TIME = NEW_REFERENCES.CEREMONY_START_TIME,
    CEREMONY_END_TIME = NEW_REFERENCES.CEREMONY_END_TIME,
    CEREMONY_FEE = NEW_REFERENCES.CEREMONY_FEE,
    NUMBER_OF_GUESTS = NEW_REFERENCES.NUMBER_OF_GUESTS,
    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: 904


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

Line: 908


end UPDATE_ROW;

Line: 927


  cursor c1 is select rowid from IGS_GR_CRMN_ALL
     where GRD_CAL_TYPE = X_GRD_CAL_TYPE
     and GRD_CI_SEQUENCE_NUMBER = X_GRD_CI_SEQUENCE_NUMBER
     and CEREMONY_NUMBER = X_CEREMONY_NUMBER
  ;

Line: 938


    INSERT_ROW (
     X_ROWID,
     X_GRD_CAL_TYPE,
     X_GRD_CI_SEQUENCE_NUMBER,
     X_CEREMONY_NUMBER,
     X_VENUE_CD,
     X_CEREMONY_DT_ALIAS,
     X_CEREMONY_DAI_SEQUENCE_NUMBER,
     X_CLOSING_DT_ALIAS,
     X_CLOSING_DAI_SEQUENCE_NUMBER,
     X_CEREMONY_START_TIME,
     X_CEREMONY_END_TIME,
     X_CEREMONY_FEE,
     X_NUMBER_OF_GUESTS,
     X_MODE,
     x_org_id
);

Line: 958


  UPDATE_ROW (
   X_ROWID,
   X_GRD_CAL_TYPE,
   X_GRD_CI_SEQUENCE_NUMBER,
   X_CEREMONY_NUMBER,
   X_VENUE_CD,
   X_CEREMONY_DT_ALIAS,
   X_CEREMONY_DAI_SEQUENCE_NUMBER,
   X_CLOSING_DT_ALIAS,
   X_CLOSING_DAI_SEQUENCE_NUMBER,
   X_CEREMONY_START_TIME,
   X_CEREMONY_END_TIME,
   X_CEREMONY_FEE,
   X_NUMBER_OF_GUESTS,
   X_MODE
);

Line: 976


procedure DELETE_ROW (
   X_ROWID in VARCHAR2
) AS
begin

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

Line: 986


  delete from IGS_GR_CRMN_ALL
  where ROWID = X_ROWID;

Line: 992


end DELETE_ROW;