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

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

Line: 24


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

Line: 45


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

Line: 47


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

Line: 68


    new_references.logical_delete_dt := x_logical_delete_dt;

Line: 69


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

Line: 76


    new_references.last_update_date := x_last_update_date;

Line: 77


    new_references.last_updated_by := x_last_updated_by;

Line: 78


    new_references.last_update_login := x_last_update_login;

Line: 88


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


	IF p_inserting THEN
		-- Validate trigger can be defined.
		IF IGS_FI_VAL_CFT.finp_val_cft_ins (
				new_references.fee_type,
				v_message_name) = FALSE THEN
			Fnd_Message.Set_Name('IGS',v_message_name);

Line: 105


	IF p_inserting OR p_updating THEN
		-- Validate IGS_AD_LOCATION not closed and of type CAMPUS.

		-- As part of the bug# 1956374 changed to the below call from IGS_FI_VAL_CFT.crsp_val_loc_cd
		IF IGS_PS_VAL_UOO.crsp_val_loc_cd (
				new_references.location_cd,
				v_message_name) = FALSE THEN
			Fnd_Message.Set_Name('IGS',v_message_name);

Line: 167


  END BeforeRowInsertUpdateDelete1;

Line: 175


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


	IF (new_references.logical_delete_dt IS NULL) THEN
		-- Cannot call finp_val_cft_open because trigger will be mutating.
		-- Save the rowid of the current row for after statement processing.
		v_rowid_saved := TRUE;

Line: 190


	IF (new_references.logical_delete_dt IS NULL AND
		new_references.fee_trigger_group_number IS NOT NULL) THEN
		-- Cannot call finp_val_cft_ftg because trigger will be mutating
		IF (v_rowid_saved = FALSE) THEN
		 	-- Save the rowid of the current row for after statement
			-- processing.
			v_rowid_saved := TRUE;

Line: 202


           IF (p_inserting OR p_updating) THEN
  			-- Validate for open ended IGS_PS_FEE_TRG records.
  			IF new_references.logical_delete_dt IS NULL THEN
  				IF IGS_FI_VAL_CFT.finp_val_cft_open(new_references.fee_cat,
  			    	              new_references.fee_cal_type,
  				              new_references.fee_ci_sequence_number,
  			    	              new_references.fee_type,
  			    	              new_references.course_cd,
  			    	              new_references.sequence_number,
  			    	              new_references.version_number,
  				              new_references.cal_type,
  			    	              new_references.location_cd,
  			    	              new_references.attendance_mode,
  			    	              new_references.attendance_type,
  				              new_references.create_dt,
  				              new_references.fee_trigger_group_number,
  				              v_message_name) = FALSE THEN
	  						Fnd_Message.Set_Name('IGS',v_message_name);

Line: 242


  END AfterRowInsertUpdate2;

Line: 250


  PROCEDURE AfterRowUpdate3(
    p_inserting IN BOOLEAN DEFAULT FALSE,
    p_updating IN BOOLEAN DEFAULT FALSE,
    p_deleting IN BOOLEAN DEFAULT FALSE
    ) AS
  BEGIN
	-- create a history
	IGS_FI_GEN_002.FINP_INS_CFT_HIST(old_references.fee_cat,
		old_references.fee_cal_type,
		old_references.fee_ci_sequence_number,
		old_references.fee_type,
		old_references.course_cd,
		old_references.sequence_number,
		new_references.version_number,
		old_references.version_number,
		new_references.cal_type,
		old_references.cal_type,
		new_references.location_cd,
		old_references.location_cd,
		new_references.attendance_mode,
		old_references.attendance_mode,
		new_references.attendance_type,
		old_references.attendance_type,
		new_references.create_dt,
		old_references.create_dt,
		new_references.fee_trigger_group_number,
		old_references.fee_trigger_group_number,
		new_references.last_updated_by,
		old_references.last_updated_by,
		new_references.last_update_date,
		old_references.last_update_date);

Line: 283


  END AfterRowUpdate3;

Line: 447


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

Line: 459


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

Line: 471


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

Line: 483


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

Line: 504


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

Line: 528


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

Line: 541


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

Line: 560


      SELECT   rowid
      FROM     IGS_PS_FEE_TRG
      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      course_cd = x_course_cd
      AND      sequence_number = x_sequence_number
      FOR UPDATE NOWAIT;

Line: 601


      SELECT   rowid
      FROM     IGS_PS_FEE_TRG
         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      course_cd = x_course_cd
         AND      version_number = x_version_number
         AND      cal_type = x_cal_type
         AND      location_cd = x_location_cd
         AND      attendance_mode = x_attendance_mode
         AND      attendance_type = x_attendance_type
         AND      create_dt = x_create_dt
         AND      ((l_rowid IS NULL) OR (rowid <> l_rowid))

      FOR UPDATE NOWAIT;

Line: 639


      SELECT   rowid
      FROM     IGS_PS_FEE_TRG
      WHERE    attendance_mode = x_attendance_mode ;

Line: 665


      SELECT   rowid
      FROM     IGS_PS_FEE_TRG
      WHERE    attendance_type = x_attendance_type ;

Line: 691


      SELECT   rowid
      FROM     IGS_PS_FEE_TRG
      WHERE    cal_type = x_cal_type ;

Line: 717


      SELECT   rowid
      FROM     IGS_PS_FEE_TRG
      WHERE    course_cd = x_course_cd ;

Line: 747


      SELECT   rowid
      FROM     IGS_PS_FEE_TRG
      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: 778


      SELECT   rowid
      FROM     IGS_PS_FEE_TRG
      WHERE    location_cd = x_location_cd ;

Line: 815


    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_course_cd,
      x_sequence_number,
      x_version_number,
      x_cal_type,
      x_location_cd,
      x_attendance_mode,
      x_attendance_type,
      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: 848


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

Line: 865


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

Line: 871


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

Line: 874


    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.course_cd,
      new_references.sequence_number) THEN
	    Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

Line: 888


    ELSIF (p_action = 'VALIDATE_UPDATE') THEN
	Check_Constraints;

Line: 903


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

Line: 906


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

Line: 909


      AfterRowUpdate3 ( p_updating => TRUE );

Line: 914


procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_FEE_CAT in VARCHAR2,
  X_FEE_TYPE in VARCHAR2,
  X_COURSE_CD in VARCHAR2,
  X_SEQUENCE_NUMBER in NUMBER,
  X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
  X_FEE_CAL_TYPE in VARCHAR2,
  X_VERSION_NUMBER in NUMBER,
  X_CAL_TYPE in VARCHAR2,
  X_LOCATION_CD in VARCHAR2,
  X_ATTENDANCE_MODE in VARCHAR2,
  X_ATTENDANCE_TYPE in VARCHAR2,
  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
    cursor C is select ROWID from IGS_PS_FEE_TRG
      where FEE_CAT = X_FEE_CAT
      and FEE_TYPE = X_FEE_TYPE
      and COURSE_CD = X_COURSE_CD
      and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
      and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
      and FEE_CAL_TYPE = X_FEE_CAL_TYPE;

Line: 939


    X_LAST_UPDATE_DATE DATE;

Line: 940


    X_LAST_UPDATED_BY NUMBER;

Line: 941


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 945


    X_PROGRAM_UPDATE_DATE DATE;

Line: 947


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 949


    X_LAST_UPDATED_BY := 1;

Line: 950


    X_LAST_UPDATE_LOGIN := 0;

Line: 952


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 953


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 956


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 957


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 968


       X_PROGRAM_UPDATE_DATE := NULL;

Line: 970


	 X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 980


    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_course_cd => X_COURSE_CD,
    x_sequence_number => X_SEQUENCE_NUMBER,
    x_version_number => X_VERSION_NUMBER ,
    x_cal_type => X_CAL_TYPE ,
    x_location_cd => X_LOCATION_CD ,
    x_attendance_mode => X_ATTENDANCE_MODE ,
    x_attendance_type => X_ATTENDANCE_TYPE ,
    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: 1003


  insert into IGS_PS_FEE_TRG (
    FEE_CAT,
    FEE_CAL_TYPE,
    FEE_CI_SEQUENCE_NUMBER,
    FEE_TYPE,
    COURSE_CD,
    SEQUENCE_NUMBER,
    VERSION_NUMBER,
    CAL_TYPE,
    LOCATION_CD,
    ATTENDANCE_MODE,
    ATTENDANCE_TYPE,
    CREATE_DT,
    FEE_TRIGGER_GROUP_NUMBER,
    LOGICAL_DELETE_DT,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    REQUEST_ID,
    PROGRAM_ID,
    PROGRAM_APPLICATION_ID,
    PROGRAM_UPDATE_DATE
  ) values (
    NEW_REFERENCES.FEE_CAT,
    NEW_REFERENCES.FEE_CAL_TYPE,
    NEW_REFERENCES.FEE_CI_SEQUENCE_NUMBER,
    NEW_REFERENCES.FEE_TYPE,
    NEW_REFERENCES.COURSE_CD,
    NEW_REFERENCES.SEQUENCE_NUMBER,
    NEW_REFERENCES.VERSION_NUMBER,
    NEW_REFERENCES.CAL_TYPE,
    NEW_REFERENCES.LOCATION_CD,
    NEW_REFERENCES.ATTENDANCE_MODE,
    NEW_REFERENCES.ATTENDANCE_TYPE,
    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,
    X_REQUEST_ID,
    X_PROGRAM_ID,
    X_PROGRAM_APPLICATION_ID,
    X_PROGRAM_UPDATE_DATE
  );

Line: 1060


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

Line: 1066


end INSERT_ROW;

Line: 1083


  X_LOGICAL_DELETE_DT in DATE
) AS
  cursor c1 is select
      VERSION_NUMBER,
      CAL_TYPE,
      LOCATION_CD,
      ATTENDANCE_MODE,
      ATTENDANCE_TYPE,
      CREATE_DT,
      FEE_TRIGGER_GROUP_NUMBER,
      LOGICAL_DELETE_DT
    from IGS_PS_FEE_TRG
    where ROWID = X_ROWID
    for update nowait;

Line: 1104


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

Line: 1130


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


procedure UPDATE_ROW (
  X_ROWID IN VARCHAR2,
  X_FEE_CAT in VARCHAR2,
  X_FEE_TYPE in VARCHAR2,
  X_COURSE_CD in VARCHAR2,
  X_SEQUENCE_NUMBER in NUMBER,
  X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
  X_FEE_CAL_TYPE in VARCHAR2,
  X_VERSION_NUMBER in NUMBER,
  X_CAL_TYPE in VARCHAR2,
  X_LOCATION_CD in VARCHAR2,
  X_ATTENDANCE_MODE in VARCHAR2,
  X_ATTENDANCE_TYPE in VARCHAR2,
  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: 1162


    X_LAST_UPDATED_BY NUMBER;

Line: 1163


    X_LAST_UPDATE_LOGIN NUMBER;

Line: 1167


    X_PROGRAM_UPDATE_DATE DATE;

Line: 1170


  X_LAST_UPDATE_DATE := SYSDATE;

Line: 1172


    X_LAST_UPDATED_BY := 1;

Line: 1173


    X_LAST_UPDATE_LOGIN := 0;

Line: 1175


    X_LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1176


    if X_LAST_UPDATED_BY is NULL then
      X_LAST_UPDATED_BY := -1;

Line: 1179


    X_LAST_UPDATE_LOGIN :=FND_GLOBAL.LOGIN_ID;

Line: 1180


    if X_LAST_UPDATE_LOGIN is NULL then
      X_LAST_UPDATE_LOGIN := -1;

Line: 1190


    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_course_cd => X_COURSE_CD,
    x_sequence_number => X_SEQUENCE_NUMBER,
    x_version_number => X_VERSION_NUMBER ,
    x_cal_type => X_CAL_TYPE ,
    x_location_cd => X_LOCATION_CD ,
    x_attendance_mode => X_ATTENDANCE_MODE ,
    x_attendance_type => X_ATTENDANCE_TYPE ,
    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: 1221


     X_PROGRAM_UPDATE_DATE := OLD_REFERENCES.PROGRAM_UPDATE_DATE;

Line: 1223


     X_PROGRAM_UPDATE_DATE := SYSDATE;

Line: 1227


  update IGS_PS_FEE_TRG set
    VERSION_NUMBER = NEW_REFERENCES.VERSION_NUMBER,
    CAL_TYPE = NEW_REFERENCES.CAL_TYPE,
    LOCATION_CD = NEW_REFERENCES.LOCATION_CD,
    ATTENDANCE_MODE = NEW_REFERENCES.ATTENDANCE_MODE,
    ATTENDANCE_TYPE = NEW_REFERENCES.ATTENDANCE_TYPE,
    CREATE_DT = NEW_REFERENCES.CREATE_DT,
    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,
    REQUEST_ID = X_REQUEST_ID,
    PROGRAM_ID = X_PROGRAM_ID,
    PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID,
    PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
  where ROWID = X_ROWID
  ;

Line: 1249


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

Line: 1252


end UPDATE_ROW;

Line: 1269


  X_LOGICAL_DELETE_DT in DATE,
  X_MODE in VARCHAR2 default 'R'
  ) AS
  cursor c1 is select rowid from IGS_PS_FEE_TRG
     where FEE_CAT = X_FEE_CAT
     and FEE_TYPE = X_FEE_TYPE
     and COURSE_CD = X_COURSE_CD
     and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
     and FEE_CI_SEQUENCE_NUMBER = X_FEE_CI_SEQUENCE_NUMBER
     and FEE_CAL_TYPE = X_FEE_CAL_TYPE
  ;

Line: 1285


    INSERT_ROW (
     X_ROWID,
     X_FEE_CAT,
     X_FEE_TYPE,
     X_COURSE_CD,
     X_SEQUENCE_NUMBER,
     X_FEE_CI_SEQUENCE_NUMBER,
     X_FEE_CAL_TYPE,
     X_VERSION_NUMBER,
     X_CAL_TYPE,
     X_LOCATION_CD,
     X_ATTENDANCE_MODE,
     X_ATTENDANCE_TYPE,
     X_CREATE_DT,
     X_FEE_TRIGGER_GROUP_NUMBER,
     X_LOGICAL_DELETE_DT,
     X_MODE);

Line: 1305


  UPDATE_ROW (
   X_ROWID,
   X_FEE_CAT,
   X_FEE_TYPE,
   X_COURSE_CD,
   X_SEQUENCE_NUMBER,
   X_FEE_CI_SEQUENCE_NUMBER,
   X_FEE_CAL_TYPE,
   X_VERSION_NUMBER,
   X_CAL_TYPE,
   X_LOCATION_CD,
   X_ATTENDANCE_MODE,
   X_ATTENDANCE_TYPE,
   X_CREATE_DT,
   X_FEE_TRIGGER_GROUP_NUMBER,
   X_LOGICAL_DELETE_DT,
   X_MODE);

Line: 1324


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

Line: 1332


  delete from IGS_PS_FEE_TRG
  where ROWID = X_ROWID;

Line: 1338


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

Line: 1341


end DELETE_ROW;