21: END log_to_fnd;
22:
23: PROCEDURE raise_wavtrandtlstofa_event( p_n_person_id IN hz_parties.party_id%TYPE,
24: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
25: p_c_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
26: p_n_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
27: p_n_waiver_amount IN igs_fi_inv_int_all.invoice_amount%TYPE) AS
28: /******************************************************************
29: Created By : Umesh Udayaprakash
22:
23: PROCEDURE raise_wavtrandtlstofa_event( p_n_person_id IN hz_parties.party_id%TYPE,
24: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
25: p_c_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
26: p_n_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
27: p_n_waiver_amount IN igs_fi_inv_int_all.invoice_amount%TYPE) AS
28: /******************************************************************
29: Created By : Umesh Udayaprakash
30: Date Created By : 8/5/2005
174: */
175:
176: PROCEDURE raise_stdntwavassign_event(p_n_person_id IN hz_parties.party_id%TYPE,
177: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
178: p_c_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
179: p_n_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) AS
180:
181: CURSOR cur_person_details(c_n_person_id IN hz_parties.party_id%TYPE) IS
182: SELECT person_number, full_name
175:
176: PROCEDURE raise_stdntwavassign_event(p_n_person_id IN hz_parties.party_id%TYPE,
177: p_v_waiver_name IN igs_fi_waiver_pgms.waiver_name%TYPE,
178: p_c_fee_cal_type IN igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
179: p_n_fee_ci_seq_number IN igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE) AS
180:
181: CURSOR cur_person_details(c_n_person_id IN hz_parties.party_id%TYPE) IS
182: SELECT person_number, full_name
183: FROM IGS_PE_PERSON_BASE_V