APPS.IGS_FI_GEN_003 dependencies on IGS_FI_ELM_RANGE_RT

Line 62: -- This routine will logically delete all IGS_FI_ELM_RANGE_RT records

58: p_message_name OUT NOCOPY VARCHAR2 )
59: RETURN BOOLEAN AS
60: gv_other_detail VARCHAR2(255);
61: BEGIN -- finp_del_err
62: -- This routine will logically delete all IGS_FI_ELM_RANGE_RT records
63: -- associated with an IGS_FI_ELM_RANGE or IGS_FI_FEE_AS_RATE record which is
64: -- being logically deleted.
65: DECLARE
66: e_resource_busy_exception EXCEPTION;

Line 81: FROM IGS_FI_ELM_RANGE_RT err

77: RATE_NUMBER,
78: CREATE_DT,
79: FEE_CAT,
80: LOGICAL_DELETE_DT
81: FROM IGS_FI_ELM_RANGE_RT err
82: WHERE err.FEE_TYPE = p_fee_type AND
83: err.fee_cal_type = p_fee_cal_type AND
84: err.fee_ci_sequence_number = p_fee_ci_sequence_number AND
85: err.s_relation_type = p_s_relation_type AND

Line 108: -- Perform a logical delete of the associated IGS_FI_ELM_RANGE_RT items.

104: END IF;
105: -- 2. Issue a save point for the module so that if locks exist,
106: -- a rollback can be performed.
107: SAVEPOINT sp_save_point;
108: -- Perform a logical delete of the associated IGS_FI_ELM_RANGE_RT items.
109: -- Update the appropriate records with NOWAIT option.
110: FOR v_err_rec IN c_err LOOP
111: IGS_FI_ELM_RANGE_RT_PKG.UPDATE_ROW(
112: X_ROWID => v_err_rec.ROWID,

Line 111: IGS_FI_ELM_RANGE_RT_PKG.UPDATE_ROW(

107: SAVEPOINT sp_save_point;
108: -- Perform a logical delete of the associated IGS_FI_ELM_RANGE_RT items.
109: -- Update the appropriate records with NOWAIT option.
110: FOR v_err_rec IN c_err LOOP
111: IGS_FI_ELM_RANGE_RT_PKG.UPDATE_ROW(
112: X_ROWID => v_err_rec.ROWID,
113: X_ERR_ID => v_err_rec.ERR_ID,
114: X_FEE_TYPE => v_err_rec.FEE_TYPE,
115: X_FEE_CAL_TYPE => v_err_rec.FEE_CAL_TYPE,