APPS.IGF_SL_UPLOAD_XML dependencies on IGF_GR_RFMS

Line 1409: CURSOR c_tbh_pell ( orig_id IGF_GR_RFMS.ORIGINATION_ID%TYPE) IS

1405: AND DISB_NUM = cp_disb_num
1406: AND DISB_SEQ_NUM = cp_disb_seq_num;
1407: l_pell_db_rec get_pell_db_rec%ROWTYPE;
1408:
1409: CURSOR c_tbh_pell ( orig_id IGF_GR_RFMS.ORIGINATION_ID%TYPE) IS
1410: SELECT *
1411: FROM IGF_GR_RFMS
1412: WHERE ORIGINATION_ID = orig_id
1413: FOR UPDATE;

Line 1411: FROM IGF_GR_RFMS

1407: l_pell_db_rec get_pell_db_rec%ROWTYPE;
1408:
1409: CURSOR c_tbh_pell ( orig_id IGF_GR_RFMS.ORIGINATION_ID%TYPE) IS
1410: SELECT *
1411: FROM IGF_GR_RFMS
1412: WHERE ORIGINATION_ID = orig_id
1413: FOR UPDATE;
1414: l_tbh_pell c_tbh_pell%ROWTYPE;
1415:

Line 1505: Also update the fields YTD_DISB_AMT, TOT_ELIG_USED, PENDING_AMOUNT,ORIG_aCTION_CODE in the table IGF_GR_RFMS_ALL

1501: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','NEG_PEND_AMT')||':' ||l_pell_resp.NEG_PEND_AMT);
1502:
1503: /*SELECT THE COLUMNS YTD_DISB_AMT, TOT_ELIG_USED, SCHD_PELL_AMT, NEG_PEND_AMT, FSA_CODE_1,FSA_CODE_2,FSA_CODE_3,PELL_STATUS
1504: CPS_VERIF_FLAG, HIGH_CPS_TRANS_NUM FROM IGF_GR_RESP_DTLS
1505: Also update the fields YTD_DISB_AMT, TOT_ELIG_USED, PENDING_AMOUNT,ORIG_aCTION_CODE in the table IGF_GR_RFMS_ALL
1506: */--dont
1507: l_tbh_pell.ORIG_ACTION_CODE := l_pell_resp.RESP_CODE;
1508: END IF;
1509:

Line 1510: igf_gr_rfms_pkg.update_row(

1506: */--dont
1507: l_tbh_pell.ORIG_ACTION_CODE := l_pell_resp.RESP_CODE;
1508: END IF;
1509:
1510: igf_gr_rfms_pkg.update_row(
1511: x_rowid => l_tbh_pell.row_id,
1512: x_origination_id => l_tbh_pell.origination_id,
1513: x_ci_cal_type => l_tbh_pell.ci_cal_type ,
1514: x_ci_sequence_number => l_tbh_pell.ci_sequence_number ,