APPS.IGF_DB_DISB dependencies on IGF_GR_RFMS

Line 788: FROM igf_gr_rfms

784: -- Cursor to get RFMS Origination Details
785: CURSOR cur_grant_orig(p_award_id igf_aw_award.award_id%TYPE)
786: IS
787: SELECT origination_id, orig_action_code
788: FROM igf_gr_rfms
789: WHERE
790: award_id = p_award_id
791: FOR UPDATE OF origination_id NOWAIT;
792:

Line 796: CURSOR cur_grant_disb(p_origination_id igf_gr_rfms_all.origination_id%TYPE,

792:
793: grant_orig_rec cur_grant_orig%ROWTYPE;
794:
795: -- Cursor to get RFMS Disbursement Details
796: CURSOR cur_grant_disb(p_origination_id igf_gr_rfms_all.origination_id%TYPE,
797: p_disb_num igf_aw_awd_disb.disb_num%TYPE)
798: IS
799: SELECT disb_ack_act_status
800: FROM igf_gr_rfms_disb

Line 800: FROM igf_gr_rfms_disb

796: CURSOR cur_grant_disb(p_origination_id igf_gr_rfms_all.origination_id%TYPE,
797: p_disb_num igf_aw_awd_disb.disb_num%TYPE)
798: IS
799: SELECT disb_ack_act_status
800: FROM igf_gr_rfms_disb
801: WHERE
802: origination_id = p_origination_id AND
803: disb_ref_num = p_disb_num;
804:

Line 1071: -- should insert / update records in igf_gr_rfms_disb table

1067: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','get_adisb_rec.disb_num:'||get_adisb_rec.disb_num);
1068: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.revert_disb.debug','inserting to igf_aw_awd_disb with award_id '||get_adisb_rec.award_id);
1069: END IF;
1070: -- table handler for igf_aw_awd_disb table, in case of pell disbursements
1071: -- should insert / update records in igf_gr_rfms_disb table
1072: igf_aw_awd_disb_pkg.insert_row( x_rowid => lv_rowid ,
1073: x_award_id => get_adisb_rec.award_id ,
1074: x_disb_num => get_adisb_rec.disb_num ,
1075: x_tp_cal_type => get_adisb_rec.tp_cal_type ,

Line 2400: igf_gr_rfms

2396: IS
2397: SELECT
2398: origination_id,orig_action_code,efc
2399: FROM
2400: igf_gr_rfms
2401: WHERE
2402: award_id = p_award_id;
2403:
2404: get_pell_rec cur_get_pell%ROWTYPE;

Line 2408: CURSOR cur_get_disb (p_origination_id igf_gr_rfms_all.origination_id%TYPE,

2404: get_pell_rec cur_get_pell%ROWTYPE;
2405:
2406: -- Get the PELL disbursement status
2407:
2408: CURSOR cur_get_disb (p_origination_id igf_gr_rfms_all.origination_id%TYPE,
2409: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
2410: IS
2411: SELECT
2412: disb_ack_act_status

Line 2414: igf_gr_rfms_disb

2410: IS
2411: SELECT
2412: disb_ack_act_status
2413: FROM
2414: igf_gr_rfms_disb
2415: WHERE
2416: origination_id = p_origination_id AND
2417: disb_ref_num = p_disb_num;
2418:

Line 3083: fnd_message.set_token('ATT_TYPE',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',awd_disb_rec.base_attendance_type_code));

3079: fnd_message.set_name('IGF','IGF_GR_PELL_DISB_FAIL');
3080: fnd_message.set_token('TERM_TOTAL',term_amounts_rec.term_total);
3081: fnd_message.set_token('CALC_AMT',p_term_aid);
3082: fnd_message.set_token('LD_ALT_CODE',igf_gr_gen.get_alt_code(awd_disb_rec.ld_cal_type,awd_disb_rec.ld_sequence_number));
3083: fnd_message.set_token('ATT_TYPE',igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',awd_disb_rec.base_attendance_type_code));
3084: p_result := fnd_message.get;
3085: fnd_file.put_line(fnd_file.log,RPAD(' ',17) ||p_result);
3086:
3087: END IF;