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_PS_OFR_INST

Line 294: p_acad_begin_date IN OUT NOCOPY igs_ps_ofr_inst.ci_start_dt%TYPE,

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
298: /*************************************************************

Line 295: p_acad_end_date IN OUT NOCOPY igs_ps_ofr_inst.ci_end_dt%TYPE ,

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
298: /*************************************************************
299: Created By : masehgal

Line 334: cp_ver_num igs_ps_ofr_inst.version_number%TYPE ,

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

Line 338: FROM igs_ps_ofr_inst

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
341: AND ci_start_dt <= cp_start_dt
342: AND ci_end_dt >= cp_end_dt ;

Line 349: l_course_cd igs_ps_ofr_inst.course_cd%TYPE ;

345: l_base_id igf_ap_fa_base_rec.base_id%TYPE;
346: l_get_loan_dates_rec c_get_loan_dates%ROWTYPE ;
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:

Line 350: l_ver_num igs_ps_ofr_inst.version_number%TYPE ;

346: l_get_loan_dates_rec c_get_loan_dates%ROWTYPE ;
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