eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGF_SL_DL_RECORD dependencies on IGS_CA_INST

Line 43: p_cal_type igs_ca_inst.cal_type%TYPE,

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,
47: p_dbth_id IN OUT NOCOPY igf_sl_dl_batch.dbth_id%TYPE,

Line 44: p_cal_seq_num igs_ca_inst.sequence_number%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,
47: p_dbth_id IN OUT NOCOPY igf_sl_dl_batch.dbth_id%TYPE,
48: p_batch_id IN OUT NOCOPY igf_sl_dl_batch.batch_id%TYPE,

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

288: -- masehgal # 2593215 new procedure to return acad begin and end dates ...
289: -- this will replace get_Acad_begin_date and get_acad_end_date Functions ...
290:
291: PROCEDURE get_acad_cal_dtls( p_loan_number igf_sl_loans_all.loan_number%TYPE,
292: p_acad_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
293: p_acad_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
294: p_acad_begin_date IN OUT NOCOPY igs_ps_ofr_inst.ci_start_dt%TYPE,
295: p_acad_end_date IN OUT NOCOPY igs_ps_ofr_inst.ci_end_dt%TYPE ,
296: p_message OUT NOCOPY VARCHAR2 )

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

289: -- this will replace get_Acad_begin_date and get_acad_end_date Functions ...
290:
291: PROCEDURE get_acad_cal_dtls( p_loan_number igf_sl_loans_all.loan_number%TYPE,
292: p_acad_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
293: p_acad_seq_num OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
294: p_acad_begin_date IN OUT NOCOPY igs_ps_ofr_inst.ci_start_dt%TYPE,
295: p_acad_end_date IN OUT NOCOPY igs_ps_ofr_inst.ci_end_dt%TYPE ,
296: p_message OUT NOCOPY VARCHAR2 )
297: AS

Line 432: p_ci_cal_type igs_ca_inst.cal_type%TYPE,

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,
436: p_school_code IN VARCHAR2,

Line 433: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,

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,
436: p_school_code IN VARCHAR2,
437: Orig_Rec IN OUT NOCOPY igf_sl_dl_record.DLOrigType)

Line 469: lv_acad_begin_dt igs_ca_inst.start_dt%TYPE;

465: (reverse chronological order - newest change first)
466: ***************************************************************/
467:
468:
469: lv_acad_begin_dt igs_ca_inst.start_dt%TYPE;
470: lv_acad_end_dt igs_ca_inst.end_dt%TYPE;
471: l_p_phone VARCHAR2(80);
472: l_s_phone VARCHAR2(80);
473: lv_acad_cal_type igs_ca_inst.cal_type%TYPE := NULL;

Line 470: lv_acad_end_dt igs_ca_inst.end_dt%TYPE;

466: ***************************************************************/
467:
468:
469: lv_acad_begin_dt igs_ca_inst.start_dt%TYPE;
470: lv_acad_end_dt igs_ca_inst.end_dt%TYPE;
471: l_p_phone VARCHAR2(80);
472: l_s_phone VARCHAR2(80);
473: lv_acad_cal_type igs_ca_inst.cal_type%TYPE := NULL;
474: lv_acad_seq_number igs_ca_inst.sequence_number%TYPE := NULL ;

Line 473: lv_acad_cal_type igs_ca_inst.cal_type%TYPE := NULL;

469: lv_acad_begin_dt igs_ca_inst.start_dt%TYPE;
470: lv_acad_end_dt igs_ca_inst.end_dt%TYPE;
471: l_p_phone VARCHAR2(80);
472: l_s_phone VARCHAR2(80);
473: lv_acad_cal_type igs_ca_inst.cal_type%TYPE := NULL;
474: lv_acad_seq_number igs_ca_inst.sequence_number%TYPE := NULL ;
475: lv_message VARCHAR2(100) ;
476:
477: l_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;

Line 474: lv_acad_seq_number igs_ca_inst.sequence_number%TYPE := NULL ;

470: lv_acad_end_dt igs_ca_inst.end_dt%TYPE;
471: l_p_phone VARCHAR2(80);
472: l_s_phone VARCHAR2(80);
473: lv_acad_cal_type igs_ca_inst.cal_type%TYPE := NULL;
474: lv_acad_seq_number igs_ca_inst.sequence_number%TYPE := NULL ;
475: lv_message VARCHAR2(100) ;
476:
477: l_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
478: l_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;

Line 487: cp_cal_type igs_ca_inst.cal_type%TYPE,

483:
484: -- cursor to replace the columns selected from the igf_sl_lor_dtls_v FA 122 Enhancements
485:
486: CURSOR c_lor_details (
487: cp_cal_type igs_ca_inst.cal_type%TYPE,
488: cp_seq_number igs_ca_inst.sequence_number%TYPE,
489: cp_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
490: cp_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
491: cp_loan_status igf_sl_loans.loan_status%TYPE,

Line 488: cp_seq_number igs_ca_inst.sequence_number%TYPE,

484: -- cursor to replace the columns selected from the igf_sl_lor_dtls_v FA 122 Enhancements
485:
486: CURSOR c_lor_details (
487: cp_cal_type igs_ca_inst.cal_type%TYPE,
488: cp_seq_number igs_ca_inst.sequence_number%TYPE,
489: cp_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
490: cp_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
491: cp_loan_status igf_sl_loans.loan_status%TYPE,
492: cp_active igf_sl_loans.active%TYPE,