DBA Data[Home] [Help]

APPS.IGS_FI_GEN_002 dependencies on IGS_FI_FEE_AS_RT_HT

Line 59: r_cfarh IGS_FI_FEE_AS_RT_HT%ROWTYPE;

55: gv_other_detail VARCHAR2(255);
56: BEGIN
57: DECLARE
58: X_ROWID VARCHAR2(25);
59: r_cfarh IGS_FI_FEE_AS_RT_HT%ROWTYPE;
60: v_create_history BOOLEAN := FALSE;
61: l_n_org_id IGS_FI_FEE_AS_RT_HT.org_id%TYPE := igs_ge_gen_003.get_org_id;
62: BEGIN
63: -- Create a history for a IGS_FI_FEE_AS_RT record.

Line 61: l_n_org_id IGS_FI_FEE_AS_RT_HT.org_id%TYPE := igs_ge_gen_003.get_org_id;

57: DECLARE
58: X_ROWID VARCHAR2(25);
59: r_cfarh IGS_FI_FEE_AS_RT_HT%ROWTYPE;
60: v_create_history BOOLEAN := FALSE;
61: l_n_org_id IGS_FI_FEE_AS_RT_HT.org_id%TYPE := igs_ge_gen_003.get_org_id;
62: BEGIN
63: -- Create a history for a IGS_FI_FEE_AS_RT record.
64: -- Check if any of the non-primary key fields have been changed
65: -- and set the flag v_create_history to indicate so.

Line 102: IGS_FI_FEE_AS_RT_HT_PKG.INSERT_ROW(

98: r_cfarh.start_dt := p_start_dt;
99: r_cfarh.hist_start_dt := p_old_last_update_date;
100: r_cfarh.hist_end_dt := p_new_last_update_date;
101: r_cfarh.hist_who := p_old_last_updated_by;
102: IGS_FI_FEE_AS_RT_HT_PKG.INSERT_ROW(
103: X_ROWID => X_ROWID,
104: X_person_id => r_cfarh.person_id,
105: X_course_cd => r_cfarh.course_cd,
106: X_FEE_TYPE => r_cfarh.FEE_TYPE,