[Home] [Help]
52: PROCEDURE DLOrig_cur(p_dl_version igf_lookups_view.lookup_code%TYPE,
53: p_dl_loan_catg igf_lookups_view.lookup_code%TYPE,
54: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
55: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
56: p_dl_loan_number igf_sl_loans.loan_number%TYPE,
57: p_dl_batch_id igf_sl_dl_batch.batch_id%TYPE,
58: p_school_code IN VARCHAR2,
59: Orig_Rec IN OUT NOCOPY igf_sl_dl_record.DLOrigType);
60:
62:
63:
64: -- masehgal new procedure to get acad cal dates
65: -- This would replace the get_acad_begin_date and get_acad_end_date
66: PROCEDURE get_acad_cal_dtls( p_loan_number igf_sl_loans_all.loan_number%TYPE,
67: p_acad_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
68: p_acad_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
69: p_acad_begin_date IN OUT NOCOPY igs_ps_ofr_inst.ci_start_dt%TYPE,
70: p_acad_end_date IN OUT NOCOPY igs_ps_ofr_inst.ci_end_dt%TYPE ,