APPS.IGF_SL_DL_RECORD dependencies on IGS_CA_INST

Line 39: p_cal_type igs_ca_inst.cal_type%TYPE,

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,

Line 40: p_cal_seq_num igs_ca_inst.sequence_number%TYPE,

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,

Line 54: p_ci_cal_type igs_ca_inst.cal_type%TYPE,

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,

Line 55: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,

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);

Line 67: p_acad_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,

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 );

Line 68: p_acad_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,

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: