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.

APPS.IGF_SL_DL_RECORD dependencies on IGF_SL_LOANS

Line 291: PROCEDURE get_acad_cal_dtls( p_loan_number igf_sl_loans_all.loan_number%TYPE,

287:
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 ,

Line 317: CURSOR c_get_person_id ( cp_loan_number igf_sl_loans.loan_number%TYPE) IS

313: ***************************************************************/
314:
315: -- cursor to get person_id from loan_number
316: -- We need person id to get primary enrol prog from FA Base History
317: CURSOR c_get_person_id ( cp_loan_number igf_sl_loans.loan_number%TYPE) IS
318: SELECT fa.person_id,
319: fa.base_id
320: FROM igf_ap_fa_base_rec fa, igf_sl_loans loan , igf_aw_award awd
321: WHERE fa.base_id = awd.base_id

Line 320: FROM igf_ap_fa_base_rec fa, igf_sl_loans loan , igf_aw_award awd

316: -- We need person id to get primary enrol prog from FA Base History
317: CURSOR c_get_person_id ( cp_loan_number igf_sl_loans.loan_number%TYPE) IS
318: SELECT fa.person_id,
319: fa.base_id
320: FROM igf_ap_fa_base_rec fa, igf_sl_loans loan , igf_aw_award awd
321: WHERE fa.base_id = awd.base_id
322: AND awd.award_id = loan.award_id
323: AND loan.loan_number = cp_loan_number ;
324:

Line 327: CURSOR c_get_loan_dates ( cp_loan_number igf_sl_loans.loan_number%TYPE) IS

323: AND loan.loan_number = cp_loan_number ;
324:
325: -- cursor to get loan_dates for that loan_number
326: -- We need loan_dates to determine proper acad cal
327: CURSOR c_get_loan_dates ( cp_loan_number igf_sl_loans.loan_number%TYPE) IS
328: SELECT loan_per_begin_date , loan_per_end_date
329: FROM igf_sl_loans
330: WHERE loan_number = cp_loan_number ;
331:

Line 329: FROM igf_sl_loans

325: -- cursor to get loan_dates for that loan_number
326: -- We need loan_dates to determine proper acad cal
327: CURSOR c_get_loan_dates ( cp_loan_number igf_sl_loans.loan_number%TYPE) IS
328: SELECT loan_per_begin_date , loan_per_end_date
329: FROM igf_sl_loans
330: WHERE loan_number = cp_loan_number ;
331:
332: -- cursor to get acad_cal for that loan_number
333: CURSOR get_acad_cal ( cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE ,

Line 335: cp_start_dt igf_sl_loans_v.loan_per_begin_date%TYPE ,

331:
332: -- cursor to get acad_cal for that loan_number
333: CURSOR get_acad_cal ( cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE ,
334: cp_ver_num igs_ps_ofr_inst.version_number%TYPE ,
335: cp_start_dt igf_sl_loans_v.loan_per_begin_date%TYPE ,
336: cp_end_dt igf_sl_loans_v.loan_per_end_date%TYPE ) IS
337: SELECT cal_type, ci_sequence_number, ci_start_dt, ci_end_dt
338: FROM igs_ps_ofr_inst
339: WHERE course_cd = cp_course_cd

Line 336: cp_end_dt igf_sl_loans_v.loan_per_end_date%TYPE ) IS

332: -- cursor to get acad_cal for that loan_number
333: CURSOR get_acad_cal ( cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE ,
334: cp_ver_num igs_ps_ofr_inst.version_number%TYPE ,
335: cp_start_dt igf_sl_loans_v.loan_per_begin_date%TYPE ,
336: cp_end_dt igf_sl_loans_v.loan_per_end_date%TYPE ) IS
337: SELECT cal_type, ci_sequence_number, ci_start_dt, ci_end_dt
338: FROM igs_ps_ofr_inst
339: WHERE course_cd = cp_course_cd
340: AND version_number = cp_ver_num

Line 351: l_begin_dt igf_sl_loans.loan_per_begin_date%TYPE ;

347: l_get_acad_cal_rec get_acad_cal%ROWTYPE ;
348:
349: l_course_cd igs_ps_ofr_inst.course_cd%TYPE ;
350: l_ver_num igs_ps_ofr_inst.version_number%TYPE ;
351: l_begin_dt igf_sl_loans.loan_per_begin_date%TYPE ;
352: l_end_dt igf_sl_loans.loan_per_end_date%TYPE ;
353:
354: BEGIN
355:

Line 352: l_end_dt igf_sl_loans.loan_per_end_date%TYPE ;

348:
349: l_course_cd igs_ps_ofr_inst.course_cd%TYPE ;
350: l_ver_num igs_ps_ofr_inst.version_number%TYPE ;
351: l_begin_dt igf_sl_loans.loan_per_begin_date%TYPE ;
352: l_end_dt igf_sl_loans.loan_per_end_date%TYPE ;
353:
354: BEGIN
355:
356: -- check if loan number is null ...

Line 434: p_dl_loan_number igf_sl_loans.loan_number%TYPE,

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)
438: AS

Line 491: cp_loan_status igf_sl_loans.loan_status%TYPE,

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,
493: cp_dl_loan_number igf_sl_loans.loan_number%TYPE
494: ) IS
495: SELECT

Line 492: cp_active igf_sl_loans.active%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,
493: cp_dl_loan_number igf_sl_loans.loan_number%TYPE
494: ) IS
495: SELECT
496: loans.row_id,

Line 493: cp_dl_loan_number igf_sl_loans.loan_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,
493: cp_dl_loan_number igf_sl_loans.loan_number%TYPE
494: ) IS
495: SELECT
496: loans.row_id,
497: loans.loan_id,

Line 523: igf_sl_loans loans,

519: isr.alien_reg_number,
520: isr.citizenship_status,
521: isr.dependency_status
522: FROM
523: igf_sl_loans loans,
524: igf_sl_lor lor,
525: igf_aw_award awd,
526: igf_aw_fund_mast fmast,
527: igf_aw_fund_cat fcat,