APPS.IGS_FI_GEN_002 dependencies on IGS_FI_ELM_RANGE_H

Line 266: r_erh IGS_FI_ELM_RANGE_H%ROWTYPE;

262: gv_other_detail VARCHAR2(255);
263: BEGIN
264: DECLARE
265: X_ROWID VARCHAR2(25);
266: r_erh IGS_FI_ELM_RANGE_H%ROWTYPE;
267: v_create_history BOOLEAN := FALSE;
268: l_n_org_id IGS_FI_ELM_RANGE_H.org_id%TYPE := igs_ge_gen_003.get_org_id;
269: BEGIN
270: -- Create a history for a IGS_FI_ELM_RANGE record.

Line 268: l_n_org_id IGS_FI_ELM_RANGE_H.org_id%TYPE := igs_ge_gen_003.get_org_id;

264: DECLARE
265: X_ROWID VARCHAR2(25);
266: r_erh IGS_FI_ELM_RANGE_H%ROWTYPE;
267: v_create_history BOOLEAN := FALSE;
268: l_n_org_id IGS_FI_ELM_RANGE_H.org_id%TYPE := igs_ge_gen_003.get_org_id;
269: BEGIN
270: -- Create a history for a IGS_FI_ELM_RANGE record.
271: -- Check if any of the non-primary key fields have been changed
272: -- and set the flag v_create_history to indicate so.

Line 300: IGS_FI_ELM_RANGE_H_PKG.INSERT_ROW(

296: r_erh.range_number := p_range_number;
297: r_erh.hist_start_dt := p_old_last_update_date;
298: r_erh.hist_end_dt := p_new_last_update_date;
299: r_erh.hist_who := p_old_last_updated_by;
300: IGS_FI_ELM_RANGE_H_PKG.INSERT_ROW(
301: X_ROWID => X_ROWID,
302: X_FEE_TYPE => r_erh.FEE_TYPE,
303: X_fee_cal_type => r_erh.fee_cal_type,
304: X_fee_ci_sequence_number => r_erh.fee_ci_sequence_number,