APPS.IGS_FI_GEN_002 dependencies on IGS_PS_FEE_TRG_HIST

Line 160: r_cfth IGS_PS_FEE_TRG_HIST%ROWTYPE;

156: gv_other_detail VARCHAR2(255);
157: BEGIN
158: DECLARE
159: X_ROWID VARCHAR2(25);
160: r_cfth IGS_PS_FEE_TRG_HIST%ROWTYPE;
161: v_create_history BOOLEAN := FALSE;
162: l_n_org_id IGS_PS_FEE_TRG_HIST.org_id%TYPE := igs_ge_gen_003.get_org_id;
163: BEGIN
164: -- Create a history for a IGS_PS_FEE_TRG record.

Line 162: l_n_org_id IGS_PS_FEE_TRG_HIST.org_id%TYPE := igs_ge_gen_003.get_org_id;

158: DECLARE
159: X_ROWID VARCHAR2(25);
160: r_cfth IGS_PS_FEE_TRG_HIST%ROWTYPE;
161: v_create_history BOOLEAN := FALSE;
162: l_n_org_id IGS_PS_FEE_TRG_HIST.org_id%TYPE := igs_ge_gen_003.get_org_id;
163: BEGIN
164: -- Create a history for a IGS_PS_FEE_TRG record.
165: -- Check if any of the non-primary key fields have been changed
166: -- and set the flag v_create_history to indicate so.

Line 209: IGS_PS_FEE_TRG_HIST_PKG.INSERT_ROW(

205: r_cfth.sequence_number := p_sequence_number;
206: r_cfth.hist_start_dt := p_old_last_update_date;
207: r_cfth.hist_end_dt := p_new_last_update_date;
208: r_cfth.hist_who := p_old_last_updated_by;
209: IGS_PS_FEE_TRG_HIST_PKG.INSERT_ROW(
210: X_ROWID => X_ROWID,
211: X_FEE_CAT => r_cfth.FEE_CAT,
212: X_fee_cal_type => r_cfth.fee_cal_type,
213: X_fee_ci_sequence_number => r_cfth.fee_ci_sequence_number,