APPS.IGF_SL_DL_RECORD dependencies on IGF_LOOKUPS_VIEW

Line 41: PROCEDURE DLHeader_cur(p_dl_version igf_lookups_view.lookup_code%TYPE,

37: */
38:
39: p_rec_length igf_sl_dl_file_type.rec_length%TYPE;
40:
41: PROCEDURE DLHeader_cur(p_dl_version igf_lookups_view.lookup_code%TYPE,
42: p_dl_loan_catg igf_lookups_view.lookup_code%TYPE,
43: p_cal_type igs_ca_inst.cal_type%TYPE,
44: p_cal_seq_num igs_ca_inst.sequence_number%TYPE,
45: p_file_type igf_sl_dl_file_type.dl_file_type%TYPE,

Line 42: p_dl_loan_catg igf_lookups_view.lookup_code%TYPE,

38:
39: p_rec_length igf_sl_dl_file_type.rec_length%TYPE;
40:
41: PROCEDURE DLHeader_cur(p_dl_version igf_lookups_view.lookup_code%TYPE,
42: p_dl_loan_catg igf_lookups_view.lookup_code%TYPE,
43: p_cal_type igs_ca_inst.cal_type%TYPE,
44: p_cal_seq_num igs_ca_inst.sequence_number%TYPE,
45: p_file_type igf_sl_dl_file_type.dl_file_type%TYPE,
46: p_school_code IN VARCHAR2,

Line 183: PROCEDURE DLTrailer_cur(p_dl_version igf_lookups_view.lookup_code%TYPE,

179: app_exception.raise_exception;
180: END DLHeader_cur;
181:
182:
183: PROCEDURE DLTrailer_cur(p_dl_version igf_lookups_view.lookup_code%TYPE,
184: p_num_of_rec NUMBER,
185: Trailer_Rec IN OUT NOCOPY igf_sl_dl_record.DLTrailerType)
186: AS
187: /*************************************************************

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

225: app_exception.raise_exception;
226: END DLTrailer_cur;
227:
228:
229: FUNCTION DLDisbDetails(p_dl_version igf_lookups_view.lookup_code%TYPE,
230: p_award_id igf_aw_award.award_id%TYPE)
231: RETURN VARCHAR2
232: AS
233: /*************************************************************

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

426: END get_acad_cal_dtls ;
427:
428:
429:
430: PROCEDURE DLOrig_cur(p_dl_version igf_lookups_view.lookup_code%TYPE,
431: p_dl_loan_catg igf_lookups_view.lookup_code%TYPE,
432: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
433: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
434: p_dl_loan_number igf_sl_loans.loan_number%TYPE,

Line 431: p_dl_loan_catg igf_lookups_view.lookup_code%TYPE,

427:
428:
429:
430: PROCEDURE DLOrig_cur(p_dl_version igf_lookups_view.lookup_code%TYPE,
431: p_dl_loan_catg igf_lookups_view.lookup_code%TYPE,
432: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
433: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
434: p_dl_loan_number igf_sl_loans.loan_number%TYPE,
435: p_dl_batch_id igf_sl_dl_batch.batch_id%TYPE,