[Home] [Help]
265: IS
266: SELECT
267: rfms.origination_id
268: FROM
269: igf_gr_rfms rfms
270: WHERE
271: rfms.award_id = x_award_id ;
272:
273: chk_orig_rec cur_chk_orig%ROWTYPE;
278: IS
279: SELECT
280: rfmd.origination_id
281: FROM
282: igf_gr_rfms rfms,
283: igf_gr_rfms_disb rfmd
284: WHERE
285: rfms.origination_id = rfmd.origination_id AND
286: rfmd.disb_ref_num = x_disb_num AND
279: SELECT
280: rfmd.origination_id
281: FROM
282: igf_gr_rfms rfms,
283: igf_gr_rfms_disb rfmd
284: WHERE
285: rfms.origination_id = rfmd.origination_id AND
286: rfmd.disb_ref_num = x_disb_num AND
287: rfms.award_id = x_award_id ;
317:
318: get_awd_rec cur_get_awd%ROWTYPE;
319:
320: l_pell_setup igf_gr_pell_setup_all%ROWTYPE;
321: l_rfms_rec igf_gr_rfms%ROWTYPE ;
322: l_rfmsd_rec igf_gr_rfms_disb%ROWTYPE ;
323:
324: lv_row_id VARCHAR2(25);
325: lv_rfmd_id NUMBER(15);
318: get_awd_rec cur_get_awd%ROWTYPE;
319:
320: l_pell_setup igf_gr_pell_setup_all%ROWTYPE;
321: l_rfms_rec igf_gr_rfms%ROWTYPE ;
322: l_rfmsd_rec igf_gr_rfms_disb%ROWTYPE ;
323:
324: lv_row_id VARCHAR2(25);
325: lv_rfmd_id NUMBER(15);
326:
340: WHERE base_id = c_base_id
341: AND payment_isir = 'Y';
342:
343:
344: CURSOR cur_chk_duplicate_ssn(c_orig_id igf_gr_rfms.origination_id%TYPE) IS
345: SELECT 'Y'
346: FROM igf_gr_rfms
347: WHERE origination_id = c_orig_id;
348:
342:
343:
344: CURSOR cur_chk_duplicate_ssn(c_orig_id igf_gr_rfms.origination_id%TYPE) IS
345: SELECT 'Y'
346: FROM igf_gr_rfms
347: WHERE origination_id = c_orig_id;
348:
349: chk_ssn VARCHAR2(1);
350:
373: l_coa_pell igf_ap_fa_base_rec_all.coa_pell%TYPE;
374:
375: CURSOR c_get_rep_entity_id(cp_cal_type igs_ca_inst_all.cal_type%TYPE,
376: cp_seq_num igs_ca_inst_all.sequence_number%TYPE,
377: cp_atd_entity_id igf_gr_rfms_all.atd_entity_id_txt%TYPE) IS
378: SELECT rep.rep_entity_id_txt
379: FROM igf_gr_attend_pell att,
380: igf_gr_report_pell rep
381: WHERE att.rcampus_id = rep.rcampus_id
390: l_ret_status VARCHAR2(1);
391: l_msg_data VARCHAR2(30);
392: l_stu_num VARCHAR2(30);
393: l_cod_year_flag BOOLEAN;
394: l_attend_entity_id igf_gr_rfms_all.atd_entity_id_txt%TYPE ;
395: l_rep_entity_id igf_gr_rfms_all.rep_entity_id_txt%TYPE ;
396:
397:
398:
391: l_msg_data VARCHAR2(30);
392: l_stu_num VARCHAR2(30);
393: l_cod_year_flag BOOLEAN;
394: l_attend_entity_id igf_gr_rfms_all.atd_entity_id_txt%TYPE ;
395: l_rep_entity_id igf_gr_rfms_all.rep_entity_id_txt%TYPE ;
396:
397:
398:
399: -- FA 131 - COD Updates Build cursors. 20-NOV-2003 ugummall.
406: -- End FA 131.
407:
408: l_return_status VARCHAR2(1);
409: l_return_mesg_text VARCHAR2(2000);
410: l_ft_pell_amt igf_gr_rfms_all.ft_pell_amount%TYPE;
411: l_pell_amt igf_gr_rfms.pell_amount%TYPE;
412: l_program_cd igf_gr_pell_setup_all.course_cd%TYPE;
413: l_program_version igf_gr_pell_setup_all.version_number%TYPE;
414: l_attendance_type igs_en_stdnt_ps_att.attendance_type%TYPE;
407:
408: l_return_status VARCHAR2(1);
409: l_return_mesg_text VARCHAR2(2000);
410: l_ft_pell_amt igf_gr_rfms_all.ft_pell_amount%TYPE;
411: l_pell_amt igf_gr_rfms.pell_amount%TYPE;
412: l_program_cd igf_gr_pell_setup_all.course_cd%TYPE;
413: l_program_version igf_gr_pell_setup_all.version_number%TYPE;
414: l_attendance_type igs_en_stdnt_ps_att.attendance_type%TYPE;
415:
757: l_rfms_rec.pending_amount := NULL;
758:
759: lv_row_id := NULL;
760:
761: igf_gr_rfms_pkg.insert_row ( x_rowid => lv_row_id,
762: x_origination_id => l_rfms_rec.origination_id,
763: x_ci_cal_type => l_rfms_rec.ci_cal_type,
764: x_ci_sequence_number => l_rfms_rec.ci_sequence_number,
765: x_base_id => l_rfms_rec.base_id,
872: -- Insert RFMS Disb Record
873:
874: lv_row_id := NULL;
875:
876: igf_gr_rfms_disb_pkg.insert_row (x_mode => 'R',
877: x_rowid => lv_row_id,
878: x_rfmd_id => lv_rfmd_id,
879: x_origination_id => l_rfmsd_rec.origination_id,
880: x_disb_ref_num => l_rfmsd_rec.disb_ref_num,