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.

APPS.IGF_GR_REPACKAGE dependencies on IGF_GR_RFMS

Line 6: --sjadhav 06-Nov-2004 FA 149 build, do not insert into igf_gr_rfms_disb for cod year

2: /* $Header: IGFGR07B.pls 120.3 2006/08/10 15:59:33 museshad noship $ */
3: ----------------------------------------------------------------------
4: --museshad 10-Aug-2006 Bug 5337555. Build FA 163. TBH Impact.
5: ----------------------------------------------------------------------
6: --sjadhav 06-Nov-2004 FA 149 build, do not insert into igf_gr_rfms_disb for cod year
7: ----------------------------------------------------------------------
8: --ayedubat 13-OCT-04 FA 149 COD-XML Standards build bug # 3416863
9: -- Changed the TBH calls of the packages: igf_aw_awd_disb_pkg and
10: -- igf_gr_rfms_pkg

Line 10: -- igf_gr_rfms_pkg

6: --sjadhav 06-Nov-2004 FA 149 build, do not insert into igf_gr_rfms_disb for cod year
7: ----------------------------------------------------------------------
8: --ayedubat 13-OCT-04 FA 149 COD-XML Standards build bug # 3416863
9: -- Changed the TBH calls of the packages: igf_aw_awd_disb_pkg and
10: -- igf_gr_rfms_pkg
11: ----------------------------------------------------------------------
12: -- veramach July 2004 FA 151 HR integration (bug # 3709292)
13: -- Impact of obsoleting columns from igf_aw_awd_disb_pkg
14: ----------------------------------------------------------------------

Line 16: -- in call to igf_gr_rfms_pkg.update_row, changed the

12: -- veramach July 2004 FA 151 HR integration (bug # 3709292)
13: -- Impact of obsoleting columns from igf_aw_awd_disb_pkg
14: ----------------------------------------------------------------------
15: -- veramach 12-Mar-2004 Bug 3490915
16: -- in call to igf_gr_rfms_pkg.update_row, changed the
17: -- value of pell_amout to l_offered_amt
18: -- Also, ft_pell_amt is calculated and updated in
19: -- the RFMS record.
20: ----------------------------------------------------------------------

Line 358: FROM igf_gr_rfms rfms

354: CURSOR c_rfms(
355: cp_award_id igf_aw_award_all.award_id%TYPE
356: ) IS
357: SELECT rfms.*
358: FROM igf_gr_rfms rfms
359: WHERE award_id = cp_award_id;
360:
361: -- Cursor to get the RFMS Disbursement records for the RFMS Records
362: CURSOR c_rfms_disb(

Line 363: cp_origination_id igf_gr_rfms_disb_v.origination_id%TYPE

359: WHERE award_id = cp_award_id;
360:
361: -- Cursor to get the RFMS Disbursement records for the RFMS Records
362: CURSOR c_rfms_disb(
363: cp_origination_id igf_gr_rfms_disb_v.origination_id%TYPE
364: ) IS
365: SELECT row_id,
366: disb_ack_act_status
367: FROM igf_gr_rfms_disb rfmd

Line 367: FROM igf_gr_rfms_disb rfmd

363: cp_origination_id igf_gr_rfms_disb_v.origination_id%TYPE
364: ) IS
365: SELECT row_id,
366: disb_ack_act_status
367: FROM igf_gr_rfms_disb rfmd
368: WHERE origination_id = cp_origination_id;
369:
370: -- Cursor to get the awards
371: --modified in FA131 to choose adplans_id,offered_amt also

Line 420: l_pell_ft_aid igf_gr_rfms_all.pell_amount%TYPE := NULL;

416: lv_return_status VARCHAR2(1) := NULL;
417:
418: lv_message_ft fnd_new_messages.message_text%TYPE := NULL;
419: lv_return_status_ft VARCHAR2(1) := NULL;
420: l_pell_ft_aid igf_gr_rfms_all.pell_amount%TYPE := NULL;
421: l_pell_aid igf_gr_rfms_all.ft_pell_amount%TYPE := NULL;
422:
423:
424: l_log_message VARCHAR2(4000);

Line 421: l_pell_aid igf_gr_rfms_all.ft_pell_amount%TYPE := NULL;

417:
418: lv_message_ft fnd_new_messages.message_text%TYPE := NULL;
419: lv_return_status_ft VARCHAR2(1) := NULL;
420: l_pell_ft_aid igf_gr_rfms_all.pell_amount%TYPE := NULL;
421: l_pell_aid igf_gr_rfms_all.ft_pell_amount%TYPE := NULL;
422:
423:
424: l_log_message VARCHAR2(4000);
425:

Line 447: l_rfmsd_rec igf_gr_rfms_disb%ROWTYPE;

443: WHERE pell_seq_id = cp_pell_seq_id;
444: l_pell_setup c_pell_setup%ROWTYPE;
445:
446:
447: l_rfmsd_rec igf_gr_rfms_disb%ROWTYPE;
448:
449: lv_row_id VARCHAR2(25);
450: lv_rfmd_id NUMBER;
451:

Line 478: cp_origination_id igf_gr_rfms_disb_v.origination_id%TYPE,

474: l_disb_rec c_disb%ROWTYPE;
475: l_last_disb_num NUMBER;
476:
477: CURSOR c_rfmb_disb(
478: cp_origination_id igf_gr_rfms_disb_v.origination_id%TYPE,
479: cp_disb_num igf_gr_rfms_disb_all.disb_ref_num%TYPE
480: ) IS
481: SELECT rfmd.rowid row_id,
482: rfmd.*

Line 479: cp_disb_num igf_gr_rfms_disb_all.disb_ref_num%TYPE

475: l_last_disb_num NUMBER;
476:
477: CURSOR c_rfmb_disb(
478: cp_origination_id igf_gr_rfms_disb_v.origination_id%TYPE,
479: cp_disb_num igf_gr_rfms_disb_all.disb_ref_num%TYPE
480: ) IS
481: SELECT rfmd.rowid row_id,
482: rfmd.*
483: FROM igf_gr_rfms_disb_all rfmd

Line 483: FROM igf_gr_rfms_disb_all rfmd

479: cp_disb_num igf_gr_rfms_disb_all.disb_ref_num%TYPE
480: ) IS
481: SELECT rfmd.rowid row_id,
482: rfmd.*
483: FROM igf_gr_rfms_disb_all rfmd
484: WHERE
485: rfmd.origination_id = cp_origination_id AND
486: rfmd.disb_ref_num = cp_disb_num ;
487:

Line 490: cp_origination_id igf_gr_rfms_disb_v.origination_id%TYPE,

486: rfmd.disb_ref_num = cp_disb_num ;
487:
488:
489: CURSOR c_rfmd_extra(
490: cp_origination_id igf_gr_rfms_disb_v.origination_id%TYPE,
491: cp_disb_num igf_gr_rfms_disb_all.disb_ref_num%TYPE
492: ) IS
493: SELECT rfmd.rowid row_id,
494: rfmd.*

Line 491: cp_disb_num igf_gr_rfms_disb_all.disb_ref_num%TYPE

487:
488:
489: CURSOR c_rfmd_extra(
490: cp_origination_id igf_gr_rfms_disb_v.origination_id%TYPE,
491: cp_disb_num igf_gr_rfms_disb_all.disb_ref_num%TYPE
492: ) IS
493: SELECT rfmd.rowid row_id,
494: rfmd.*
495: FROM igf_gr_rfms_disb_all rfmd

Line 495: FROM igf_gr_rfms_disb_all rfmd

491: cp_disb_num igf_gr_rfms_disb_all.disb_ref_num%TYPE
492: ) IS
493: SELECT rfmd.rowid row_id,
494: rfmd.*
495: FROM igf_gr_rfms_disb_all rfmd
496: WHERE
497: rfmd.origination_id = cp_origination_id AND
498: rfmd.disb_ref_num > cp_disb_num ;
499:

Line 816: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','updating igf_gr_rfms with pell_amount:'||l_offered_amt);

812: END IF;
813:
814: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
815: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','Full time PELL Amount:'||l_pell_ft_aid);
816: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','updating igf_gr_rfms with pell_amount:'||l_offered_amt);
817: END IF;
818:
819: -- Update the Origination Record
820: igf_gr_rfms_pkg.update_row(

Line 820: igf_gr_rfms_pkg.update_row(

816: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','updating igf_gr_rfms with pell_amount:'||l_offered_amt);
817: END IF;
818:
819: -- Update the Origination Record
820: igf_gr_rfms_pkg.update_row(
821: x_rowid => lc_rfms.row_id,
822: x_origination_id => lc_rfms.origination_id,
823: x_ci_cal_type => lc_rfms.ci_cal_type,
824: x_ci_sequence_number => lc_rfms.ci_sequence_number,

Line 926: l_log_message := l_log_message || RPAD(igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',l_pell_tab(i).base_attendance_type_code) ,30,' ');

922:
923: l_log_message := l_log_message || RPAD(l_alternate_code.alternate_code,30,' ');
924: l_log_message := l_log_message || RPAD(TO_CHAR(l_pell_tab(i).offered_amt) ,30,' ');
925: l_log_message := l_log_message || RPAD(TO_CHAR(l_pell_tab(i).accepted_amt) ,30,' ');
926: l_log_message := l_log_message || RPAD(igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',l_pell_tab(i).base_attendance_type_code) ,30,' ');
927:
928: fnd_file.put_line(fnd_file.log, l_log_message);
929: --update the disbursement here, if it exists
930: --else insert the disbursement

Line 1090: igf_gr_rfms_disb_pkg.update_row(

1086: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','l_rfmb_disb_rec.disb_status_dt:'||l_rfmb_disb_rec.disb_status_dt);
1087: END IF;
1088:
1089:
1090: igf_gr_rfms_disb_pkg.update_row(
1091: x_mode => 'R',
1092: x_rowid => l_rfmb_disb_rec.row_id,
1093: x_rfmd_id => l_rfmb_disb_rec.rfmd_id,
1094: x_origination_id => l_rfmb_disb_rec.origination_id,

Line 1120: igf_gr_rfms_disb_pkg.insert_row(

1116:
1117: lv_row_id := NULL;
1118: lv_rfmd_id := NULL;
1119:
1120: igf_gr_rfms_disb_pkg.insert_row(
1121: x_mode => 'R',
1122: x_rowid => lv_row_id,
1123: x_rfmd_id => lv_rfmd_id,
1124: x_origination_id => lc_rfms.origination_id,

Line 1230: igf_gr_rfms_disb_pkg.delete_row(rfms_disb_rec.row_id);

1226:
1227: -- Clear Additional RFMS Entries if any.
1228:
1229: FOR rfms_disb_rec IN c_rfmd_extra(lc_rfms.origination_id,l_last_disb_num) LOOP
1230: igf_gr_rfms_disb_pkg.delete_row(rfms_disb_rec.row_id);
1231: END LOOP;
1232:
1233: END IF; -- Delete of Extra RFMS Disbursement Records
1234: