1 PACKAGE igf_sl_dl_record AS
2 /* $Header: IGFSL11S.pls 120.0 2005/06/01 14:50:04 appldev noship $ */
3
4 /*************************************************************
5 Created By : venagara
6 Date Created On : 2000/11/13
7 Purpose :
8 Know limitations, enhancements or remarks
9 Change History
10 Who When What
11 ugummall 17-OCT-2003 Bug 3102439. FA 126 Multiple FA Offices.
12 New parameter p_school_code is added to procedures
13 DLHeader_cur and DLOrig_cur.
14 masehgal 08-Jan-2003 # 2593215 Removed functions to get begin and end of call dates
15 added procedure get_acad_cal_dtls instead
16
17 (reverse chronological order - newest change first)
18 ***************************************************************/
19
20
21 -- REF Cursor for Direct Loan Origination File : Header Record
22 TYPE DLHeaderType IS REF CURSOR;
23
24 -- REF Cursor for Direct Loan Origination File : Transaction Record
25 TYPE DLOrigType IS REF CURSOR;
26
27 -- REF Cursor for Direct Loan Origination File : Trailer Record
28 TYPE DLTrailerType IS REF CURSOR;
29
30
31 -- DLDisbDetails should not be called by external programs
32 FUNCTION DLDisbDetails(p_dl_version igf_lookups_view.lookup_code%TYPE,
33 p_award_id igf_aw_award.award_id%TYPE)
34 RETURN VARCHAR2;
35
36
37 PROCEDURE DLHeader_cur(p_dl_version igf_lookups_view.lookup_code%TYPE,
38 p_dl_loan_catg igf_lookups_view.lookup_code%TYPE,
39 p_cal_type igs_ca_inst.cal_type%TYPE,
40 p_cal_seq_num igs_ca_inst.sequence_number%TYPE,
41 p_file_type igf_sl_dl_file_type.dl_file_type%TYPE,
42 p_school_code IN VARCHAR2,
43 p_dbth_id IN OUT NOCOPY igf_sl_dl_batch.dbth_id%TYPE,
44 p_batch_id IN OUT NOCOPY igf_sl_dl_batch.batch_id%TYPE,
45 p_mesg_class IN OUT NOCOPY igf_sl_dl_batch.message_class%TYPE,
46 Header_Rec IN OUT NOCOPY igf_sl_dl_record.DLHeaderType);
47
48 PROCEDURE DLTrailer_cur(p_dl_version igf_lookups_view.lookup_code%TYPE,
49 p_num_of_rec NUMBER,
50 Trailer_Rec IN OUT NOCOPY igf_sl_dl_record.DLTrailerType);
51
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
61
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 ,
71 p_message OUT NOCOPY VARCHAR2 );
72
73 PRAGMA RESTRICT_REFERENCES (DLDisbDetails, WNDS, WNPS);
74
75 END igf_sl_dl_record;