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

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

Line: 15


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

Line: 29


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

Line: 31


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

Line: 42


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

Line: 49


    new_references.last_update_date := x_last_update_date;

Line: 50


    new_references.last_updated_by := x_last_updated_by;

Line: 51


    new_references.last_update_login := x_last_update_login;

Line: 57


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


	IF p_inserting OR p_updating THEN
		IF new_references.end_dt IS NOT NULL THEN
			IF IGS_ST_VAL_GDHC.stap_val_gdhc_end_dt(
						new_references.start_dt,
						new_references.end_dt,
						v_message_name) = FALSE THEN
				Fnd_Message.Set_Name('IGS',v_message_name);

Line: 84


  END BeforeRowInsertUpdate1;

Line: 88


  PROCEDURE AfterStmtInsertUpdate3(
    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: 96


  	IF p_inserting OR p_updating THEN
  		IF IGS_ST_VAL_GDHC.stap_val_gdhc_ovrlp (
  			              new_references.govt_discipline_group_cd,
  		    	              new_references.start_dt,
  			              new_references.end_dt,
  			              v_message_name) = FALSE THEN
			Fnd_Message.Set_Name('IGS',v_message_name);

Line: 117


  END AfterStmtInsertUpdate3;

Line: 156


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

Line: 168


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

Line: 180


      SELECT   rowid
      FROM     IGS_FI_GV_DSP_HEC_CN
      WHERE    govt_discipline_group_cd = x_govt_discipline_group_cd
      AND      govt_hecs_cntrbtn_band = x_govt_hecs_cntrbtn_band
      AND      start_dt = x_start_dt
      FOR UPDATE NOWAIT;

Line: 203


      SELECT   rowid
      FROM     IGS_FI_GV_DSP_HEC_CN
      WHERE    govt_discipline_group_cd = x_govt_discipline_group_cd
      AND      start_dt = x_start_dt
      AND      ((l_rowid IS NULL) OR (rowid <> l_rowid))
      FOR UPDATE NOWAIT;

Line: 225


      SELECT   rowid
      FROM     IGS_FI_GV_DSP_HEC_CN
      WHERE    govt_discipline_group_cd = x_govt_discipline_group_cd ;

Line: 245


      SELECT   rowid
      FROM     IGS_FI_GV_DSP_HEC_CN
      WHERE    govt_hecs_cntrbtn_band = x_govt_hecs_cntrbtn_band ;

Line: 270


    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_govt_discipline_group_cd,
      x_govt_hecs_cntrbtn_band,
      x_start_dt,
      x_end_dt,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 288


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

Line: 303


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

Line: 309


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

Line: 312


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
      IF (Get_PK_For_Validation (
            new_references.govt_discipline_group_cd,
            new_references.govt_hecs_cntrbtn_band,
            new_references.start_dt
          )) THEN
        Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

Line: 324


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
      Check_Uniqueness;

Line: 335


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

Line: 338


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

Line: 343


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_GOVT_DISCIPLINE_GROUP_CD in VARCHAR2,
  X_GOVT_HECS_CNTRBTN_BAND in NUMBER,
  X_START_DT in DATE,
  X_END_DT in DATE,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    cursor C is select ROWID from IGS_FI_GV_DSP_HEC_CN
      where GOVT_DISCIPLINE_GROUP_CD = X_GOVT_DISCIPLINE_GROUP_CD
      and GOVT_HECS_CNTRBTN_BAND = X_GOVT_HECS_CNTRBTN_BAND
      and START_DT = X_START_DT;

Line: 355


    X_LAST_UPDATE_DATE DATE;

Line: 356


    X_LAST_UPDATED_BY NUMBER;

Line: 357


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 359


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 361


    X_LAST_UPDATED_BY := 1;

Line: 362


    X_LAST_UPDATE_LOGIN := 0;

Line: 364


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 365


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 368


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 369


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 378


 p_action=>'INSERT',
 x_rowid=>X_ROWID,
 x_end_dt=>X_END_DT,
 x_govt_discipline_group_cd=>X_GOVT_DISCIPLINE_GROUP_CD,
 x_govt_hecs_cntrbtn_band=>X_GOVT_HECS_CNTRBTN_BAND,
 x_start_dt=>X_START_DT,
 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: 390


  insert into IGS_FI_GV_DSP_HEC_CN (
    GOVT_DISCIPLINE_GROUP_CD,
    GOVT_HECS_CNTRBTN_BAND,
    START_DT,
    END_DT,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    NEW_REFERENCES.GOVT_DISCIPLINE_GROUP_CD,
    NEW_REFERENCES.GOVT_HECS_CNTRBTN_BAND,
    NEW_REFERENCES.START_DT,
    NEW_REFERENCES.END_DT,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 419


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

Line: 422


end INSERT_ROW;

Line: 430


  cursor c1 is select
      END_DT
    from IGS_FI_GV_DSP_HEC_CN
    where ROWID=X_ROWID
    for update nowait;

Line: 441


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

Line: 459


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_GOVT_DISCIPLINE_GROUP_CD in VARCHAR2,
  X_GOVT_HECS_CNTRBTN_BAND in NUMBER,
  X_START_DT in DATE,
  X_END_DT in DATE,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 468


    X_LAST_UPDATED_BY NUMBER;

Line: 469


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 471


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 473


    X_LAST_UPDATED_BY := 1;

Line: 474


    X_LAST_UPDATE_LOGIN := 0;

Line: 476


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 477


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 480


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 481


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 490


 p_action=>'UPDATE',
 x_rowid=>X_ROWID,
 x_end_dt=>X_END_DT,
 x_govt_discipline_group_cd=>X_GOVT_DISCIPLINE_GROUP_CD,
 x_govt_hecs_cntrbtn_band=>X_GOVT_HECS_CNTRBTN_BAND,
 x_start_dt=>X_START_DT,
 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: 502


  update IGS_FI_GV_DSP_HEC_CN set
    END_DT = NEW_REFERENCES.END_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: 513


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

Line: 516


end UPDATE_ROW;

Line: 525


  cursor c1 is select rowid from IGS_FI_GV_DSP_HEC_CN
     where GOVT_DISCIPLINE_GROUP_CD = X_GOVT_DISCIPLINE_GROUP_CD
     and GOVT_HECS_CNTRBTN_BAND = X_GOVT_HECS_CNTRBTN_BAND
     and START_DT = X_START_DT
  ;

Line: 535


    INSERT_ROW (
     X_ROWID,
     X_GOVT_DISCIPLINE_GROUP_CD,
     X_GOVT_HECS_CNTRBTN_BAND,
     X_START_DT,
     X_END_DT,
     X_MODE);

Line: 545


  UPDATE_ROW (
   X_ROWID,
   X_GOVT_DISCIPLINE_GROUP_CD,
   X_GOVT_HECS_CNTRBTN_BAND,
   X_START_DT,
   X_END_DT,
   X_MODE);

Line: 553


procedure DELETE_ROW (
  X_ROWID in VARCHAR2
) AS
begin
BEFORE_DML (
 p_action => 'DELETE',
 x_rowid => X_ROWID
);

Line: 561


  delete from IGS_FI_GV_DSP_HEC_CN
  where ROWID=X_ROWID;

Line: 566


end DELETE_ROW;