266: CLOSE c_get_prog_frm_adm;
267: END get_key_prog_ver_frm_adm;
268:
269: PROCEDURE get_pell_setup ( cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
270: cp_course_cd IN igf_gr_pell_setup_all.course_cd%TYPE,
271: cp_version_number IN igf_gr_pell_setup_all.version_number%TYPE,
272: cp_cal_type IN igs_ca_inst.cal_type%TYPE,
273: cp_sequence_number IN igs_ca_inst.sequence_number%TYPE,
274: cp_pell_setup_rec IN OUT NOCOPY igf_gr_pell_setup_all%ROWTYPE ,
267: END get_key_prog_ver_frm_adm;
268:
269: PROCEDURE get_pell_setup ( cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
270: cp_course_cd IN igf_gr_pell_setup_all.course_cd%TYPE,
271: cp_version_number IN igf_gr_pell_setup_all.version_number%TYPE,
272: cp_cal_type IN igs_ca_inst.cal_type%TYPE,
273: cp_sequence_number IN igs_ca_inst.sequence_number%TYPE,
274: cp_pell_setup_rec IN OUT NOCOPY igf_gr_pell_setup_all%ROWTYPE ,
275: cp_message OUT NOCOPY VARCHAR2,
270: cp_course_cd IN igf_gr_pell_setup_all.course_cd%TYPE,
271: cp_version_number IN igf_gr_pell_setup_all.version_number%TYPE,
272: cp_cal_type IN igs_ca_inst.cal_type%TYPE,
273: cp_sequence_number IN igs_ca_inst.sequence_number%TYPE,
274: cp_pell_setup_rec IN OUT NOCOPY igf_gr_pell_setup_all%ROWTYPE ,
275: cp_message OUT NOCOPY VARCHAR2,
276: cp_return_status OUT NOCOPY VARCHAR2
277: )
278: IS
299:
300: CURSOR c_get_rep_pell_id(
301: l_cal_type igs_ca_inst.cal_type%TYPE,
302: l_seq_num igs_ca_inst.sequence_number%TYPE,
303: l_att_pell_id igf_gr_pell_setup_all.rep_pell_id%TYPE
304: )
305: IS
306: SELECT rep.reporting_pell_cd
307: FROM igf_gr_attend_pell gap, igf_gr_report_pell rep
318: l_version_number igf_gr_pell_setup.version_number%TYPE
319: )
320: IS
321: SELECT pell.*
322: FROM igf_gr_pell_setup_all pell
323: WHERE pell.ci_cal_type = l_ci_cal_type
324: AND pell.ci_sequence_number = l_ci_sequence_number
325: AND pell.rep_pell_id = l_reporting_pell_id
326: AND pell.course_cd = l_course_cd
332: l_reporting_pell_id igf_gr_pell_setup.rep_pell_id%TYPE
333: )
334: IS
335: SELECT pell.*
336: FROM igf_gr_pell_setup_all pell
337: WHERE pell.ci_cal_type = l_ci_cal_type
338: AND pell.ci_sequence_number = l_ci_sequence_number
339: AND pell.rep_pell_id = l_reporting_pell_id
340: AND pell.course_cd IS NULL
344: l_rep_pell_id igf_gr_attend_pell.attending_pell_cd%TYPE;
345: l_ret_status VARCHAR2(30);
346: l_msg_data VARCHAR2(30);
347: l_stu_num VARCHAR2(30);
348: l_ovrd_setup_rec igf_gr_pell_setup_all%ROWTYPE;
349:
350:
351: -- Entity ID declarations
352: CURSOR c_get_rep_entity_id_txt(
364:
365: CURSOR c_pell_def_setup_cod(
366: l_ci_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE,
367: l_ci_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE,
368: l_rep_entity_id igf_gr_pell_setup_all.rep_entity_id_txt%TYPE
369: )
370: IS
371: SELECT pell.*
372: FROM igf_gr_pell_setup_all pell
368: l_rep_entity_id igf_gr_pell_setup_all.rep_entity_id_txt%TYPE
369: )
370: IS
371: SELECT pell.*
372: FROM igf_gr_pell_setup_all pell
373: WHERE pell.ci_cal_type = l_ci_cal_type
374: AND pell.ci_sequence_number = l_ci_sequence_number
375: AND pell.rep_entity_id_txt = l_rep_entity_id
376: AND pell.course_cd IS NULL
378:
379: CURSOR c_pell_ovrd_setup_cod(
380: l_ci_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE,
381: l_ci_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE,
382: l_rep_entity_id igf_gr_pell_setup_all.rep_entity_id_txt%TYPE,
383: l_course_cd igf_gr_pell_setup_all.course_cd%TYPE,
384: l_version_number igf_gr_pell_setup_all.version_number%TYPE
385: )
386: IS
379: CURSOR c_pell_ovrd_setup_cod(
380: l_ci_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE,
381: l_ci_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE,
382: l_rep_entity_id igf_gr_pell_setup_all.rep_entity_id_txt%TYPE,
383: l_course_cd igf_gr_pell_setup_all.course_cd%TYPE,
384: l_version_number igf_gr_pell_setup_all.version_number%TYPE
385: )
386: IS
387: SELECT pell.*
380: l_ci_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE,
381: l_ci_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE,
382: l_rep_entity_id igf_gr_pell_setup_all.rep_entity_id_txt%TYPE,
383: l_course_cd igf_gr_pell_setup_all.course_cd%TYPE,
384: l_version_number igf_gr_pell_setup_all.version_number%TYPE
385: )
386: IS
387: SELECT pell.*
388: FROM igf_gr_pell_setup_all pell
384: l_version_number igf_gr_pell_setup_all.version_number%TYPE
385: )
386: IS
387: SELECT pell.*
388: FROM igf_gr_pell_setup_all pell
389: WHERE pell.ci_cal_type = l_ci_cal_type
390: AND pell.ci_sequence_number = l_ci_sequence_number
391: AND pell.rep_entity_id_txt = l_rep_entity_id
392: AND pell.course_cd = l_course_cd
680:
681:
682: PROCEDURE get_pell_coa_efc (cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
683: cp_attendance_type IN igf_ap_attend_map.attendance_type%TYPE,
684: cp_pell_setup_rec IN igf_gr_pell_setup_all%ROWTYPE ,
685: cp_coa OUT NOCOPY NUMBER,
686: cp_efc OUT NOCOPY NUMBER,
687: cp_pell_schedule_code OUT NOCOPY VARCHAR2,
688: cp_message OUT NOCOPY VARCHAR2,
802: PROCEDURE get_pell_attendance_type (
803: cp_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
804: cp_ld_cal_type IN igs_ca_inst.cal_type%TYPE,
805: cp_ld_sequence_number IN igs_ca_inst.sequence_number%TYPE,
806: cp_pell_setup_rec IN igf_gr_pell_setup_all%ROWTYPE ,
807: cp_attendance_type IN OUT NOCOPY igf_ap_attend_map.attendance_type%TYPE,
808: cp_message OUT NOCOPY VARCHAR2,
809: cp_return_status OUT NOCOPY VARCHAR2
810: )
1875: cp_pell_tab IN OUT NOCOPY pell_tab,
1876: cp_return_status IN OUT NOCOPY VARCHAR2,
1877: cp_message IN OUT NOCOPY VARCHAR2,
1878: cp_called_from IN VARCHAR2,
1879: cp_pell_seq_id OUT NOCOPY igf_gr_pell_setup_all.pell_seq_id%TYPE,
1880: cp_pell_schedule_code OUT NOCOPY VARCHAR2
1881: ) IS
1882: /*
1883: || Created By : CDCRUZ
2092: dp.adplans_id = l_plan_id;
2093:
2094: l_dp_details_rec c_dp_details%ROWTYPE;
2095:
2096: l_pell_setup_rec igf_gr_pell_setup_all%ROWTYPE;
2097: l_pell_schedule VARCHAR2(30);
2098: l_pell_attend_type VARCHAR2(30);
2099: l_message fnd_new_messages.message_text%TYPE;
2100: l_return_status VARCHAR2(30);
3252: UPPER(fmast.fund_code) = 'PELL';
3253:
3254: l_awd_round_fact_rec cur_get_awd_round_fact%ROWTYPE;
3255:
3256: l_pell_setup_rec igf_gr_pell_setup_all%ROWTYPE;
3257: l_pell_schedule VARCHAR2(30);
3258: l_message fnd_new_messages.message_text%TYPE;
3259: l_return_status VARCHAR2(30);
3260:
3539: l_ft_coa NUMBER;
3540: l_ft_aid NUMBER;
3541: l_program_cd igs_en_stdnt_ps_att.course_cd%TYPE;
3542: l_program_version igs_en_stdnt_ps_att.version_number%TYPE;
3543: l_pell_setup_rec igf_gr_pell_setup_all%ROWTYPE;
3544: l_ft_efc NUMBER;
3545: l_pell_schedule_code VARCHAR2(30);
3546:
3547: