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

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

Line: 23


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

Line: 41


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

Line: 43


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

Line: 61


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

Line: 68


    new_references.last_update_date := x_last_update_date;

Line: 69


    new_references.last_updated_by := x_last_updated_by;

Line: 70


    new_references.last_update_login := x_last_update_login;

Line: 80


  PROCEDURE BeforeRowInsertUpdateDelete1(
    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: 88


	IF p_inserting THEN
		IF IGS_GR_VAL_ACUS.grdp_val_crv_us(
				new_references.award_course_cd,
				new_references.award_crs_version_number,
				new_references.unit_set_cd,
				new_references.us_version_number,
				v_message_name) = FALSE THEN
			Fnd_Message.Set_Name('IGS', v_message_name);

Line: 101


	IF p_inserting OR p_updating THEN
		IF IGS_GR_VAL_GC.grdp_val_gc_iud(
				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: 113


	IF p_inserting OR p_updating THEN
		IF IGS_GR_VAL_ACUS.grdp_val_awc_closed(
				new_references.grd_cal_type,
				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,
				v_message_name) = FALSE THEN
			Fnd_Message.Set_Name('IGS', v_message_name);

Line: 128


	IF p_inserting OR p_updating THEN
		IF IGS_GR_VAL_ACUS.grdp_val_acusg_close(
				new_references.grd_cal_type,
				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.us_group_number,
				v_message_name) = FALSE THEN
			Fnd_Message.Set_Name('IGS', v_message_name);

Line: 144


	IF p_inserting THEN
  			-- Validate award ceremony us group order in award
  			IF IGS_GR_VAL_AWC.grdp_val_acusg_order(
  					NEW_REFERENCES.grd_cal_type,
  					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.us_group_number,
  					v_message_name) = FALSE THEN
  				Fnd_Message.Set_Name('IGS', v_message_name);

Line: 176


  END BeforeRowInsertUpdateDelete1;

Line: 224


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

Line: 240


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

Line: 260


      SELECT   rowid
      FROM     IGS_GR_AWD_CRM_UT_ST
      WHERE    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      us_group_number = x_us_group_number
      AND      unit_set_cd = x_unit_set_cd
      AND      us_version_number = x_us_version_number
      FOR UPDATE NOWAIT;

Line: 299


      SELECT   rowid
      FROM     IGS_GR_AWD_CRM_UT_ST
      WHERE    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      us_group_number = x_us_group_number ;

Line: 332


      SELECT   rowid
      FROM     IGS_GR_AWD_CRM_UT_ST
      WHERE    unit_set_cd = x_unit_set_cd
      AND      us_version_number = x_version_number ;

Line: 369


    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_grd_cal_type,
      x_grd_ci_sequence_number,
      x_ceremony_number,
      x_award_course_cd,
      x_award_crs_version_number,
      x_award_cd,
      x_us_group_number,
      x_unit_set_cd,
      x_us_version_number,
      x_order_in_group,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 395


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

Line: 417


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

Line: 423


ELSIF (p_action = 'DELETE') THEN
      -- Call all the procedures related to Before Delete.
      BeforeRowInsertUpdateDelete1 ( p_deleting => TRUE );

Line: 427


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,
			    NEW_REFERENCES.award_course_cd,
			    NEW_REFERENCES.award_crs_version_number,
			    NEW_REFERENCES.award_cd,
			    NEW_REFERENCES.us_group_number,
			    NEW_REFERENCES.unit_set_cd,
			    NEW_REFERENCES.us_version_number
			 ) THEN
					Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

Line: 446


ELSIF (p_action = 'VALIDATE_UPDATE') THEN
			check_constraints;

Line: 456


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_AWARD_COURSE_CD in VARCHAR2,
  X_AWARD_CRS_VERSION_NUMBER in NUMBER,
  X_AWARD_CD in VARCHAR2,
  X_US_GROUP_NUMBER in NUMBER,
  X_UNIT_SET_CD in VARCHAR2,
  X_US_VERSION_NUMBER in NUMBER,
  X_ORDER_IN_GROUP in NUMBER,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    cursor C is select ROWID from IGS_GR_AWD_CRM_UT_ST
      where 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 US_GROUP_NUMBER = X_US_GROUP_NUMBER
      and UNIT_SET_CD = X_UNIT_SET_CD
      and US_VERSION_NUMBER = X_US_VERSION_NUMBER;

Line: 480


    X_LAST_UPDATE_DATE DATE;

Line: 481


    X_LAST_UPDATED_BY NUMBER;

Line: 482


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 484


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 486


    X_LAST_UPDATED_BY := 1;

Line: 487


    X_LAST_UPDATE_LOGIN := 0;

Line: 489


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 490


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 493


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 494


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 504


     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_award_course_cd => X_AWARD_COURSE_CD,
    x_award_crs_version_number => X_AWARD_CRS_VERSION_NUMBER,
    x_award_cd => X_AWARD_CD,
    x_us_group_number => X_US_GROUP_NUMBER,
    x_unit_set_cd => X_UNIT_SET_CD,
    x_us_version_number => X_US_VERSION_NUMBER,
    x_order_in_group => X_ORDER_IN_GROUP,
    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: 523


  insert into IGS_GR_AWD_CRM_UT_ST (
    GRD_CAL_TYPE,
    GRD_CI_SEQUENCE_NUMBER,
    CEREMONY_NUMBER,
    AWARD_COURSE_CD,
    AWARD_CRS_VERSION_NUMBER,
    AWARD_CD,
    US_GROUP_NUMBER,
    UNIT_SET_CD,
    US_VERSION_NUMBER,
    ORDER_IN_GROUP,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    NEW_REFERENCES.GRD_CAL_TYPE,
    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.US_GROUP_NUMBER,
    NEW_REFERENCES.UNIT_SET_CD,
    NEW_REFERENCES.US_VERSION_NUMBER,
    NEW_REFERENCES.ORDER_IN_GROUP,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 565


end INSERT_ROW;

Line: 580


  cursor c1 is select
      ORDER_IN_GROUP
    from IGS_GR_AWD_CRM_UT_ST
    where ROWID = X_ROWID for update nowait;

Line: 591


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

Line: 607


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_AWARD_COURSE_CD in VARCHAR2,
  X_AWARD_CRS_VERSION_NUMBER in NUMBER,
  X_AWARD_CD in VARCHAR2,
  X_US_GROUP_NUMBER in NUMBER,
  X_UNIT_SET_CD in VARCHAR2,
  X_US_VERSION_NUMBER in NUMBER,
  X_ORDER_IN_GROUP in NUMBER,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 622


    X_LAST_UPDATED_BY NUMBER;

Line: 623


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 625


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 627


    X_LAST_UPDATED_BY := 1;

Line: 628


    X_LAST_UPDATE_LOGIN := 0;

Line: 630


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 631


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 634


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 635


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 645


     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_award_course_cd => X_AWARD_COURSE_CD,
    x_award_crs_version_number => X_AWARD_CRS_VERSION_NUMBER,
    x_award_cd => X_AWARD_CD,
    x_us_group_number => X_US_GROUP_NUMBER,
    x_unit_set_cd => X_UNIT_SET_CD,
    x_us_version_number => X_US_VERSION_NUMBER,
    x_order_in_group => X_ORDER_IN_GROUP,
    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: 664


  update IGS_GR_AWD_CRM_UT_ST set
    ORDER_IN_GROUP = NEW_REFERENCES.ORDER_IN_GROUP,
    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: 675


end UPDATE_ROW;

Line: 691


  cursor c1 is select rowid from IGS_GR_AWD_CRM_UT_ST
     where 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 US_GROUP_NUMBER = X_US_GROUP_NUMBER
     and UNIT_SET_CD = X_UNIT_SET_CD
     and US_VERSION_NUMBER = X_US_VERSION_NUMBER
  ;

Line: 708


    INSERT_ROW (
     X_ROWID,
     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_US_GROUP_NUMBER,
     X_UNIT_SET_CD,
     X_US_VERSION_NUMBER,
     X_ORDER_IN_GROUP,
     X_MODE);

Line: 724


  UPDATE_ROW (
   X_ROWID,
   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_US_GROUP_NUMBER,
   X_UNIT_SET_CD,
   X_US_VERSION_NUMBER,
   X_ORDER_IN_GROUP,
   X_MODE);

Line: 739


procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) AS
begin

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

Line: 749


  delete from IGS_GR_AWD_CRM_UT_ST
  where ROWID = X_ROWID;

Line: 755


end DELETE_ROW;

Line: 768


      SELECT   rowid
      FROM     IGS_GR_AWD_CRM_UT_ST
      WHERE    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      us_group_number = x_us_group_number
      AND	   order_in_group = X_order_in_group
	AND	   (l_rowid IS NULL or ROWID <> l_rowid)
      FOR UPDATE NOWAIT;