eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGF_GR_GEN_XML dependencies on IGF_AW_DB_CHG_DTLS

Line 592: -- Cursor to get disbursement data from IGF_AW_DB_CHG_DTLS table.

588: Who When What
589: (reverse chronological order - newest change first)
590: ***************************************************************/
591:
592: -- Cursor to get disbursement data from IGF_AW_DB_CHG_DTLS table.
593: CURSOR cur_disb_chg_dtls ( cp_award_id igf_aw_db_chg_dtls.award_id%TYPE) IS
594: SELECT award_id,
595: disb_num,
596: disb_seq_num,

Line 593: CURSOR cur_disb_chg_dtls ( cp_award_id igf_aw_db_chg_dtls.award_id%TYPE) IS

589: (reverse chronological order - newest change first)
590: ***************************************************************/
591:
592: -- Cursor to get disbursement data from IGF_AW_DB_CHG_DTLS table.
593: CURSOR cur_disb_chg_dtls ( cp_award_id igf_aw_db_chg_dtls.award_id%TYPE) IS
594: SELECT award_id,
595: disb_num,
596: disb_seq_num,
597: disb_accepted_amt,

Line 599: FROM IGF_AW_DB_CHG_DTLS dbchgdtls

595: disb_num,
596: disb_seq_num,
597: disb_accepted_amt,
598: disb_date
599: FROM IGF_AW_DB_CHG_DTLS dbchgdtls
600: WHERE dbchgdtls.award_id = cp_award_id;
601: rec_disb_chg_dtls cur_disb_chg_dtls%ROWTYPE;
602:
603:

Line 606: l_award_id igf_aw_db_chg_dtls.award_id%TYPE;

602:
603:
604: student_dtl_cur igf_sl_gen.person_dtl_cur;
605: lv_complete BOOLEAN := TRUE;
606: l_award_id igf_aw_db_chg_dtls.award_id%TYPE;
607:
608: --akomurav
609:
610: CURSOR cur_isir_info (p_base_id NUMBER) IS

Line 837: -- validating disbursement data from the IGF_AW_DB_CHG_DTLS table

833: fnd_message.set_token('FIELD_VALUE',p_rfms_rec.pell_amount);
834: fnd_file.put_line(fnd_file.log, fnd_message.get);
835: END IF;
836:
837: -- validating disbursement data from the IGF_AW_DB_CHG_DTLS table
838: l_award_id := p_rfms_rec.award_id;
839: FOR rec_disb_chg_dtls IN cur_disb_chg_dtls(l_award_id) LOOP
840: -- validating disbursement accepted amount
841: IF ( rec_disb_chg_dtls.disb_accepted_amt >= 999999999.99) THEN

Line 919: -- Cursor to get disbursement data from IGF_AW_DB_CHG_DTLS table.

915: Who When What
916: (reverse chronological order - newest change first)
917: ***************************************************************/
918:
919: -- Cursor to get disbursement data from IGF_AW_DB_CHG_DTLS table.
920: CURSOR cur_disb_chg_dtls ( cp_award_id igf_aw_db_chg_dtls.award_id%TYPE) IS
921: SELECT award_id,
922: disb_num,
923: disb_seq_num,

Line 920: CURSOR cur_disb_chg_dtls ( cp_award_id igf_aw_db_chg_dtls.award_id%TYPE) IS

916: (reverse chronological order - newest change first)
917: ***************************************************************/
918:
919: -- Cursor to get disbursement data from IGF_AW_DB_CHG_DTLS table.
920: CURSOR cur_disb_chg_dtls ( cp_award_id igf_aw_db_chg_dtls.award_id%TYPE) IS
921: SELECT award_id,
922: disb_num,
923: disb_seq_num,
924: disb_accepted_amt,

Line 926: FROM IGF_AW_DB_CHG_DTLS dbchgdtls

922: disb_num,
923: disb_seq_num,
924: disb_accepted_amt,
925: disb_date
926: FROM IGF_AW_DB_CHG_DTLS dbchgdtls
927: WHERE dbchgdtls.award_id = cp_award_id;
928: rec_disb_chg_dtls cur_disb_chg_dtls%ROWTYPE;
929:
930: -- Cursor to get ssn, last_name, dob from IGF_GR_COD_DTLS table

Line 940: FROM igf_aw_db_chg_dtls chg

936:
937: -- Cursor to get disbursement data.
938: CURSOR cur_disb_rec (cp_award_id NUMBER) IS
939: SELECT chg.*
940: FROM igf_aw_db_chg_dtls chg
941: WHERE award_id = cp_award_id
942: AND disb_status = 'G'; -- Ready to Send (introduced this predicate again bcz of bug #4390096)
943:
944: student_dtl_cur igf_sl_gen.person_dtl_cur;

Line 1158: CURSOR cur_disb_amt_tot ( cp_award_id igf_aw_db_chg_dtls.award_id%TYPE) IS

1154: AND isir.payment_isir = 'Y'
1155: AND isir.system_record_type = 'ORIGINAL';
1156: cur_pymnt_isir_rec cur_pymnt_isir%rowtype;
1157:
1158: CURSOR cur_disb_amt_tot ( cp_award_id igf_aw_db_chg_dtls.award_id%TYPE) IS
1159: SELECT sum(a.disb_accepted_amt) disb_amt_tot
1160: FROM IGF_AW_DB_CHG_DTLS a
1161: WHERE a.award_id = cp_award_id
1162: AND NVL(a.disb_activity, 'x') <> 'Q'

Line 1160: FROM IGF_AW_DB_CHG_DTLS a

1156: cur_pymnt_isir_rec cur_pymnt_isir%rowtype;
1157:
1158: CURSOR cur_disb_amt_tot ( cp_award_id igf_aw_db_chg_dtls.award_id%TYPE) IS
1159: SELECT sum(a.disb_accepted_amt) disb_amt_tot
1160: FROM IGF_AW_DB_CHG_DTLS a
1161: WHERE a.award_id = cp_award_id
1162: AND NVL(a.disb_activity, 'x') <> 'Q'
1163: AND a.disb_seq_num = ( SELECT max(b.disb_seq_num)
1164: FROM IGF_AW_DB_CHG_DTLS b

Line 1164: FROM IGF_AW_DB_CHG_DTLS b

1160: FROM IGF_AW_DB_CHG_DTLS a
1161: WHERE a.award_id = cp_award_id
1162: AND NVL(a.disb_activity, 'x') <> 'Q'
1163: AND a.disb_seq_num = ( SELECT max(b.disb_seq_num)
1164: FROM IGF_AW_DB_CHG_DTLS b
1165: WHERE b.award_id = cp_award_id
1166: AND NVL(b.disb_activity, 'x') <> 'Q'
1167: AND b.disb_num = a.disb_num);
1168: rec_disb_amt_tot cur_disb_amt_tot%ROWTYPE;

Line 1836: FROM IGF_AW_DB_CHG_DTLS disb

1832: WHERE rfms.origination_id = cp_origination_id;
1833:
1834: CURSOR cur_sys_disb ( cp_award_id NUMBER, cp_disb_num NUMBER, cp_disb_seq NUMBER) IS
1835: SELECT disb.rowid row_id,disb.*
1836: FROM IGF_AW_DB_CHG_DTLS disb
1837: WHERE disb.award_id = cp_award_id
1838: AND disb.disb_num = cp_disb_num
1839: AND disb.disb_seq_num = cp_disb_seq;
1840:

Line 1926: igf_aw_db_chg_dtls_pkg.update_row ( x_rowid => sys_rec.row_id,

1922: LOOP
1923: sys_rec.disb_status := 'S';
1924: sys_rec.disb_status_date := TRUNC(SYSDATE);
1925:
1926: igf_aw_db_chg_dtls_pkg.update_row ( x_rowid => sys_rec.row_id,
1927: x_award_id => sys_rec.award_id,
1928: x_disb_num => sys_rec.disb_num,
1929: x_disb_seq_num => sys_rec.disb_seq_num,
1930: x_disb_accepted_amt => sys_rec.disb_accepted_amt,

Line 2047: -- update IGF_AW_DB_CHG_DTLS.DISB_STATUS to sent

2043: x_full_resp_code => NULL,
2044: x_mode => 'R');
2045: --
2046: -- update IGF_GR_RFMS_ALL.ORIG_ACTION_CODE to sent
2047: -- update IGF_AW_DB_CHG_DTLS.DISB_STATUS to sent
2048: update_status(p_document_id);
2049:
2050: -- print out xml outfile
2051: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN