DBA Data[Home] [Help]

APPS.IGS_FI_GEN_002 dependencies on IGS_FI_FEE_CAT_CI_HT

Line 589: r_fccih IGS_FI_FEE_CAT_CI_HT%ROWTYPE;

585: gv_other_detail VARCHAR2(255);
586: BEGIN
587: DECLARE
588: X_ROWID VARCHAR2(25);
589: r_fccih IGS_FI_FEE_CAT_CI_HT%ROWTYPE;
590: v_create_history BOOLEAN := FALSE;
591: l_n_org_id IGS_FI_FEE_CAT_CI_HT.org_id%TYPE := igs_ge_gen_003.get_org_id;
592: BEGIN
593: -- Create a history for the IGS_FI_F_CAT_CA_INST table.

Line 591: l_n_org_id IGS_FI_FEE_CAT_CI_HT.org_id%TYPE := igs_ge_gen_003.get_org_id;

587: DECLARE
588: X_ROWID VARCHAR2(25);
589: r_fccih IGS_FI_FEE_CAT_CI_HT%ROWTYPE;
590: v_create_history BOOLEAN := FALSE;
591: l_n_org_id IGS_FI_FEE_CAT_CI_HT.org_id%TYPE := igs_ge_gen_003.get_org_id;
592: BEGIN
593: -- Create a history for the IGS_FI_F_CAT_CA_INST table.
594: -- Check if any of the non-primary key fields have been changed
595: -- and set the flag v_create_history to indicate so.

Line 633: IGS_FI_FEE_CAT_CI_HT_PKG.INSERT_ROW(

629: r_fccih.fee_ci_sequence_number := p_fee_ci_sequence_number;
630: r_fccih.hist_start_dt := p_old_last_update_date;
631: r_fccih.hist_end_dt := p_new_last_update_date;
632: r_fccih.hist_who := p_old_last_updated_by;
633: IGS_FI_FEE_CAT_CI_HT_PKG.INSERT_ROW(
634: X_ROWID => X_ROWID,
635: X_FEE_CAT => r_fccih.FEE_CAT,
636: X_fee_cal_type => r_fccih.fee_cal_type,
637: X_fee_ci_sequence_number => r_fccih.fee_ci_sequence_number,