APPS.IGF_SL_DL_RECORD dependencies on IGF_LOOKUPS_VIEW

Line 32: FUNCTION DLDisbDetails(p_dl_version igf_lookups_view.lookup_code%TYPE,

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:

Line 37: PROCEDURE DLHeader_cur(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,

Line 38: p_dl_loan_catg igf_lookups_view.lookup_code%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,

Line 48: PROCEDURE DLTrailer_cur(p_dl_version igf_lookups_view.lookup_code%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,

Line 52: PROCEDURE DLOrig_cur(p_dl_version igf_lookups_view.lookup_code%TYPE,

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,

Line 53: p_dl_loan_catg 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,