APPS.IGF_SL_UPLOAD_XML dependencies on IGF_AW_DB_CHG_DTLS

Line 631: FROM IGF_AW_DB_CHG_DTLS

627: cp_disb_seq_num NUMBER,
628: cp_disb_num NUMBER
629: ) IS
630: SELECT *
631: FROM IGF_AW_DB_CHG_DTLS
632: WHERE AWARD_ID = cp_awd_id
633: AND DISB_NUM = cp_disb_num
634: AND DISB_SEQ_NUM = cp_disb_seq_num;
635: l_dl_db_rec get_dl_db_rec%ROWTYPE;

Line 665: FROM IGF_AW_DB_CHG_DTLS_V

661: cp_disb_seq_num NUMBER,
662: cp_disb_num NUMBER
663: ) IS
664: SELECT *
665: FROM IGF_AW_DB_CHG_DTLS_V
666: WHERE AWARD_ID = cp_awd_id
667: AND DISB_NUM = cp_disb_num
668: AND DISB_SEQ_NUM = cp_disb_seq_num;
669: l_tbh_disb c_tbh_disb%ROWTYPE;

Line 1231: -- update the table IGF_AW_DB_COD_DTLS with DISB_STATUS = 'R' , IGF_AW_DB_CHG_DTLS DISB_STATUS = 'R'

1227: CLOSE c_tbh_disb1;
1228:
1229: update_flag := FALSE;
1230: IF p_rej_flg = TRUE OR l_dl_db_resp.RESP_CODE = 'R' THEN
1231: -- update the table IGF_AW_DB_COD_DTLS with DISB_STATUS = 'R' , IGF_AW_DB_CHG_DTLS DISB_STATUS = 'R'
1232: IF l_dl_db_resp.disb_seq_num < 66 THEN
1233: IF l_tbh_disb.disb_seq_num IS NULL THEN
1234: -- disbursement record not found in the system. Log a mesg.
1235: fnd_message.set_name('IGF','IGF_SL_COD_SKIP');

Line 1276: -- update in the table IGF_AW_DB_COD_DTLS , IGF_AW_DB_CHG_DTLS RESP_CODE,PREV_SEQ_NUM,STATUS

1272: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_DB_DT')||':' ||l_dl_db_rec.disb_date);
1273: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_DT')||':' ||l_dl_db_resp.disb_date);
1274: END IF;
1275:
1276: -- update in the table IGF_AW_DB_COD_DTLS , IGF_AW_DB_CHG_DTLS RESP_CODE,PREV_SEQ_NUM,STATUS
1277: l_tbh_disb.DISB_STATUS := l_dl_db_resp.RESP_CODE;
1278: --l_tbh_disb1.DISB_STATUS := l_dl_db_resp.RESP_CODE;
1279: --l_tbh_disb.PREV_SEQ_NUM := l_dl_db_resp.PREV_SEQ_NUM;
1280: --l_tbh_disb1.PREV_SEQ_NUM := l_dl_db_resp.PREV_SEQ_NUM;

Line 1308: igf_aw_db_chg_dtls_pkg.update_row(

1304: END IF;
1305: END IF; -- for the rejected flag check
1306:
1307: IF (update_flag) THEN
1308: igf_aw_db_chg_dtls_pkg.update_row(
1309: x_rowid => l_tbh_disb.row_id ,
1310: x_award_id => l_tbh_disb.award_id,
1311: x_disb_num => l_tbh_disb.disb_num ,
1312: x_disb_seq_num => l_tbh_disb.disb_seq_num,

Line 1403: FROM IGF_AW_DB_CHG_DTLS

1399: cp_disb_seq_num NUMBER,
1400: cp_disb_num NUMBER
1401: ) IS
1402: SELECT *
1403: FROM IGF_AW_DB_CHG_DTLS
1404: WHERE AWARD_ID = cp_awd_id
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;

Line 1422: FROM IGF_AW_DB_CHG_DTLS_V

1418: cp_disb_seq_num NUMBER,
1419: cp_disb_num NUMBER
1420: ) IS
1421: SELECT *
1422: FROM IGF_AW_DB_CHG_DTLS_V
1423: WHERE AWARD_ID = cp_awd_id
1424: AND DISB_NUM = cp_disb_num
1425: AND DISB_SEQ_NUM = cp_disb_seq_num;
1426: l_tbh_disb c_tbh_disb%ROWTYPE;

Line 1596: -- update the table IGF_AW_DB_COD_DTLS with DISB_STATUS = 'R' , IGF_AW_DB_CHG_DTLS DISB_STATUS = 'R'

1592: CLOSE c_tbh_disb1;
1593:
1594: update_flag := FALSE;
1595: IF p_rej_flg = TRUE OR l_pell_db_resp.RESP_CODE = 'R' THEN
1596: -- update the table IGF_AW_DB_COD_DTLS with DISB_STATUS = 'R' , IGF_AW_DB_CHG_DTLS DISB_STATUS = 'R'
1597: -- update the status_code = 'P' in IGF_GR_DB_RESP_DTLS
1598: IF l_pell_db_resp.disb_seq_num < 66 THEN
1599: IF l_tbh_disb.disb_seq_num IS NULL THEN
1600: -- disbursement record not found in the system. Log a mesg.

Line 1634: Update the disb_status = resp_code in table IGF_AW_DB_CHG_DTLS

1630: ELSE
1631: /* Compare the system disbursement amount and the response disbursement amount, and disbursement date,
1632: if these are different then print into the log file and insert system hold on the disbursement as per
1633: existing logic. Call the wrapper igf_gr_gen.insert_sys_holds(rec_award.award_id,rec_disb_orig.disb_ref_num,'PELL');
1634: Update the disb_status = resp_code in table IGF_AW_DB_CHG_DTLS
1635: Also print in the log file, Payment Period Start Date if present and update it in the table
1636: IGF_AW_DISB_COD_DTLS and IGF_AW_DB_CHG_DTLS.
1637: Update the status_code = 'P' in IGF_GR_DB_RESP_DTLS*/ --dont
1638:

Line 1636: IGF_AW_DISB_COD_DTLS and IGF_AW_DB_CHG_DTLS.

1632: if these are different then print into the log file and insert system hold on the disbursement as per
1633: existing logic. Call the wrapper igf_gr_gen.insert_sys_holds(rec_award.award_id,rec_disb_orig.disb_ref_num,'PELL');
1634: Update the disb_status = resp_code in table IGF_AW_DB_CHG_DTLS
1635: Also print in the log file, Payment Period Start Date if present and update it in the table
1636: IGF_AW_DISB_COD_DTLS and IGF_AW_DB_CHG_DTLS.
1637: Update the status_code = 'P' in IGF_GR_DB_RESP_DTLS*/ --dont
1638:
1639: IF l_pell_db_rec.DISB_ACCEPTED_AMT <> l_pell_db_resp.disb_amt THEN
1640: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','SYS_VAL_DB_AMT')||':' ||l_pell_db_rec.DISB_ACCEPTED_AMT);

Line 1650: -- UPDATE IN THE TABLE IGF_AW_DB_COD_DTLS , IGF_AW_DB_CHG_DTLS RESP_CODE,PYMNT_PER_START_DATE, PREV_SEQ_NUM

1646: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_DB_DT')||':' ||l_pell_db_resp.disb_date);
1647: END IF;
1648: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_SL_COD_XML_TAGS','RESP_VAL_PYMT_PER_DT')||':' ||l_pell_db_resp.PYMNT_PER_START_DATE);
1649:
1650: -- UPDATE IN THE TABLE IGF_AW_DB_COD_DTLS , IGF_AW_DB_CHG_DTLS RESP_CODE,PYMNT_PER_START_DATE, PREV_SEQ_NUM
1651: l_tbh_disb.DISB_STATUS := l_pell_db_resp.RESP_CODE;
1652: l_tbh_disb.PYMNT_PRD_START_DATE := l_pell_db_resp.PYMNT_PER_START_DATE;
1653: --l_tbh_disb.PREV_SEQ_NUM := l_pell_db_resp.PREV_SEQ_NUM;
1654: --l_tbh_disb1.DISB_STATUS := l_pell_db_resp.RESP_CODE;

Line 1681: igf_aw_db_chg_dtls_pkg.update_row(

1677: END IF;
1678: END IF; -- for the rejected flag check
1679:
1680: IF (update_flag) THEN
1681: igf_aw_db_chg_dtls_pkg.update_row(
1682: x_rowid => l_tbh_disb.row_id,
1683: x_award_id => l_tbh_disb.award_id,
1684: x_disb_num => l_tbh_disb.disb_num,
1685: x_disb_seq_num => l_tbh_disb.disb_seq_num,