APPS.IGF_GR_REPACKAGE dependencies on IGF_GR_RFMS_DISB

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 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 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 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: