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

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

Line: 18


    x_logical_delete_dt IN DATE DEFAULT NULL,
    x_creation_date IN DATE DEFAULT NULL,
    x_created_by IN NUMBER DEFAULT NULL,
    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_EN_UNITSETFEETRG
      WHERE    rowid = x_rowid;

Line: 39


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

Line: 41


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

Line: 57


    new_references.logical_delete_dt := x_logical_delete_dt;

Line: 58


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

Line: 65


    new_references.last_update_date := x_last_update_date;

Line: 66


    new_references.last_updated_by := x_last_updated_by;

Line: 67


    new_references.last_update_login := x_last_update_login;

Line: 77


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


	IF p_inserting THEN
		-- Validate UNIT fee trigger can be inserted
		IF IGS_EN_VAL_USFT.finp_val_usft_ins (
				new_references.fee_type,
				v_message_name) = FALSE THEN
			    Fnd_Message.Set_Name('IGS', v_message_name);

Line: 117


  END BeforeRowInsertUpdate1;

Line: 125


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


	IF (new_references.logical_delete_dt IS NULL) THEN

		IF IGS_EN_VAL_USFT.finp_val_usft_open(new_references.fee_cat,
  				new_references.fee_cal_type,
  				new_references.fee_ci_sequence_number,
  				new_references.fee_type,
  				new_references.unit_set_cd,
  				new_references.version_number,
  				new_references.create_dt,
  				new_references.fee_trigger_group_number,
  				v_message_name) = FALSE THEN
			    Fnd_Message.Set_Name('IGS', v_message_name);

Line: 155


  END AfterRowInsertUpdate2;

Line: 245


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

Line: 270


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

Line: 286


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

Line: 305


      SELECT   rowid
      FROM     IGS_EN_UNITSETFEETRG
      WHERE    fee_cat= x_fee_cat
      AND      fee_cal_type = x_fee_cal_type
      AND      fee_ci_sequence_number = x_fee_ci_sequence_number
      AND      fee_type = x_fee_type
      AND      unit_set_cd = x_unit_set_cd
      AND      version_number = x_version_number
      AND      create_dt = x_create_dt
      FOR UPDATE NOWAIT;

Line: 341


      SELECT   rowid
      FROM     IGS_EN_UNITSETFEETRG
      WHERE    fee_cat = x_fee_cat
      AND      fee_cal_type = x_fee_cal_type
      AND      fee_ci_sequence_number = x_fee_ci_sequence_number
      AND      fee_type = x_fee_type
      AND      fee_trigger_group_number = x_fee_trigger_group_number ;

Line: 372


      SELECT   rowid
      FROM     IGS_EN_UNITSETFEETRG
      WHERE    unit_set_cd = x_unit_set_cd
      AND      version_number = x_version_number ;

Line: 405


    x_logical_delete_dt IN DATE DEFAULT NULL,
    x_creation_date IN DATE DEFAULT NULL,
    x_created_by IN NUMBER DEFAULT NULL,
    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_fee_cat,
      x_fee_cal_type,
      x_fee_ci_sequence_number,
      x_fee_type,
      x_unit_set_cd,
      x_version_number,
      x_create_dt,
      x_fee_trigger_group_number,
      x_logical_delete_dt,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login
    );

Line: 433


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

Line: 451


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

Line: 456


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

Line: 459


    ELSIF (p_action = 'VALIDATE_INSERT') THEN
      If Get_PK_For_Validation(
	    new_references.fee_cat ,
	    new_references.fee_cal_type ,
	    new_references.fee_ci_sequence_number ,
	    new_references.fee_type ,
	    new_references.unit_set_cd ,
	    new_references.version_number ,
	    new_references.create_dt
         ) THEN
         FND_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

Line: 474


    ELSif (p_action = 'VALIDATE_UPDATE') THEN
      Check_constraints;

Line: 476


    ELSIF (p_action = 'VALIDATE_DELETE') THEN
      null;

Line: 490


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

Line: 494


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

Line: 498


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

Line: 505


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_FEE_CAT in VARCHAR2,
  X_FEE_CAL_TYPE in VARCHAR2,
  X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
  X_FEE_TYPE in VARCHAR2,
  X_UNIT_SET_CD in VARCHAR2,
  X_VERSION_NUMBER in NUMBER,
  X_CREATE_DT in out NOCOPY DATE,
  X_FEE_TRIGGER_GROUP_NUMBER in NUMBER,
  X_LOGICAL_DELETE_DT in DATE,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    cursor C is select ROWID from IGS_EN_UNITSETFEETRG
      where FEE_CAT = X_FEE_CAT
      and FEE_CAL_TYPE = X_FEE_CAL_TYPE
      and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
      and FEE_TYPE = X_FEE_TYPE
      and UNIT_SET_CD = X_UNIT_SET_CD
      and VERSION_NUMBER = X_VERSION_NUMBER
      and CREATE_DT = NEW_REFERENCES.CREATE_DT;

Line: 526


    X_LAST_UPDATE_DATE DATE;

Line: 527


    X_LAST_UPDATED_BY NUMBER;

Line: 528


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 530


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 532


    X_LAST_UPDATED_BY := 1;

Line: 533


    X_LAST_UPDATE_LOGIN := 0;

Line: 535


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 536


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 539


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 540


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 549


    p_action => 'INSERT',
    x_rowid => X_ROWID,
    x_fee_cat => X_FEE_CAT,
    x_fee_cal_type => X_FEE_CAL_TYPE,
    x_fee_ci_sequence_number => X_FEE_CI_SEQUENCE_NUMBER,
    x_fee_type => X_FEE_TYPE,
    x_unit_set_cd => X_UNIT_SET_CD,
    x_version_number => X_VERSION_NUMBER,
    x_create_dt => NVL(X_CREATE_DT,SYSDATE),
    x_fee_trigger_group_number => X_FEE_TRIGGER_GROUP_NUMBER,
    x_logical_delete_dt => X_LOGICAL_DELETE_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: 566


  insert into IGS_EN_UNITSETFEETRG (
    FEE_CAT,
    FEE_CAL_TYPE,
    FEE_CI_SEQUENCE_NUMBER,
    FEE_TYPE,
    UNIT_SET_CD,
    VERSION_NUMBER,
    CREATE_DT,
    FEE_TRIGGER_GROUP_NUMBER,
    LOGICAL_DELETE_DT,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN
  ) values (
    NEW_REFERENCES.FEE_CAT,
    NEW_REFERENCES.FEE_CAL_TYPE,
    NEW_REFERENCES.FEE_CI_SEQUENCE_NUMBER,
    NEW_REFERENCES.FEE_TYPE,
    NEW_REFERENCES.UNIT_SET_CD,
    NEW_REFERENCES.VERSION_NUMBER,
    NEW_REFERENCES.CREATE_DT,
    NEW_REFERENCES.FEE_TRIGGER_GROUP_NUMBER,
    NEW_REFERENCES.LOGICAL_DELETE_DT,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN
  );

Line: 606


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

Line: 609


end INSERT_ROW;

Line: 621


  X_LOGICAL_DELETE_DT in DATE
) AS
  cursor c1 is select
      FEE_TRIGGER_GROUP_NUMBER,
      LOGICAL_DELETE_DT
    from IGS_EN_UNITSETFEETRG
   where ROWID = X_ROWID
    for update nowait;

Line: 636


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

Line: 646


      AND ((tlinfo.LOGICAL_DELETE_DT = X_LOGICAL_DELETE_DT)
           OR ((tlinfo.LOGICAL_DELETE_DT is null)
               AND (X_LOGICAL_DELETE_DT is null)))
  ) then
    null;

Line: 659


procedure UPDATE_ROW (
  X_ROWID in VARCHAR2,
  X_FEE_CAT in VARCHAR2,
  X_FEE_CAL_TYPE in VARCHAR2,
  X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
  X_FEE_TYPE in VARCHAR2,
  X_UNIT_SET_CD in VARCHAR2,
  X_VERSION_NUMBER in NUMBER,
  X_CREATE_DT in DATE,
  X_FEE_TRIGGER_GROUP_NUMBER in NUMBER,
  X_LOGICAL_DELETE_DT in DATE,
  X_MODE in VARCHAR2 default 'R'
  ) AS
    X_LAST_UPDATE_DATE DATE;

Line: 673


    X_LAST_UPDATED_BY NUMBER;

Line: 674


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 676


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 678


    X_LAST_UPDATED_BY := 1;

Line: 679


    X_LAST_UPDATE_LOGIN := 0;

Line: 681


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 682


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 685


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 686


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 695


    p_action => 'UPDATE',
    x_rowid => X_ROWID,
    x_fee_cat => X_FEE_CAT,
    x_fee_cal_type => X_FEE_CAL_TYPE,
    x_fee_ci_sequence_number => X_FEE_CI_SEQUENCE_NUMBER,
    x_fee_type => X_FEE_TYPE,
    x_unit_set_cd => X_UNIT_SET_CD,
    x_version_number => X_VERSION_NUMBER,
    x_create_dt => X_CREATE_DT,
    x_fee_trigger_group_number => X_FEE_TRIGGER_GROUP_NUMBER,
    x_logical_delete_dt => X_LOGICAL_DELETE_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: 712


  update IGS_EN_UNITSETFEETRG set
    FEE_TRIGGER_GROUP_NUMBER = NEW_REFERENCES.FEE_TRIGGER_GROUP_NUMBER,
    LOGICAL_DELETE_DT = NEW_REFERENCES.LOGICAL_DELETE_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: 724


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

Line: 727


end UPDATE_ROW;

Line: 739


  X_LOGICAL_DELETE_DT in DATE,
  X_MODE in VARCHAR2 default 'R'
  ) AS
  cursor c1 is select rowid from IGS_EN_UNITSETFEETRG
     where FEE_CAT = X_FEE_CAT
     and FEE_CAL_TYPE = X_FEE_CAL_TYPE
     and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
     and FEE_TYPE = X_FEE_TYPE
     and UNIT_SET_CD = X_UNIT_SET_CD
     and VERSION_NUMBER = X_VERSION_NUMBER
     and CREATE_DT = nvl(X_CREATE_DT,SYSDATE)
  ;

Line: 756


    INSERT_ROW (
     X_ROWID,
     X_FEE_CAT,
     X_FEE_CAL_TYPE,
     X_FEE_CI_SEQUENCE_NUMBER,
     X_FEE_TYPE,
     X_UNIT_SET_CD,
     X_VERSION_NUMBER,
     X_CREATE_DT,
     X_FEE_TRIGGER_GROUP_NUMBER,
     X_LOGICAL_DELETE_DT,
     X_MODE);

Line: 771


  UPDATE_ROW (
   X_ROWID,
   X_FEE_CAT,
   X_FEE_CAL_TYPE,
   X_FEE_CI_SEQUENCE_NUMBER,
   X_FEE_TYPE,
   X_UNIT_SET_CD,
   X_VERSION_NUMBER,
   X_CREATE_DT,
   X_FEE_TRIGGER_GROUP_NUMBER,
   X_LOGICAL_DELETE_DT,
   X_MODE);

Line: 785


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

Line: 793


  delete from IGS_EN_UNITSETFEETRG
  where ROWID = X_ROWID;

Line: 799


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

Line: 802


end DELETE_ROW;