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_AW_AWARD_ALL

Line 151: p_award_id igf_aw_award_all.award_id%TYPE

147: app_exception.raise_exception;
148: END log_parameters;
149:
150: PROCEDURE cancel_invalid_award(
151: p_award_id igf_aw_award_all.award_id%TYPE
152: ) AS
153: ------------------------------------------------------------------
154: --Created by : veramach, Oracle India
155: --Date created: 01-DEC-2003

Line 168: cp_award_id igf_aw_award_all.award_id%TYPE

164: -------------------------------------------------------------------
165:
166: -- Get an award
167: CURSOR c_award(
168: cp_award_id igf_aw_award_all.award_id%TYPE
169: ) IS
170: SELECT awd.rowid row_id,
171: awd.*
172: FROM igf_aw_award_all awd

Line 172: FROM igf_aw_award_all awd

168: cp_award_id igf_aw_award_all.award_id%TYPE
169: ) IS
170: SELECT awd.rowid row_id,
171: awd.*
172: FROM igf_aw_award_all awd
173: WHERE award_id = cp_award_id;
174:
175: -- Get disbursements for an award
176: CURSOR c_disb(

Line 177: cp_award_id igf_aw_award_all.award_id%TYPE

173: WHERE award_id = cp_award_id;
174:
175: -- Get disbursements for an award
176: CURSOR c_disb(
177: cp_award_id igf_aw_award_all.award_id%TYPE
178: ) IS
179: SELECT disb.rowid row_id,
180: disb.*
181: FROM igf_aw_awd_disb_all disb

Line 346: igf_aw_award_all awd

342: awd.award_status,
343: fmast.fund_code
344: FROM igf_aw_fund_cat_all fcat,
345: igf_aw_fund_mast_all fmast,
346: igf_aw_award_all awd
347: WHERE fcat.fed_fund_code = 'PELL'
348: AND fcat.fund_code = fmast.fund_code
349: AND fmast.fund_id = awd.fund_id
350: AND awd.base_id = cp_base_id

Line 355: cp_award_id igf_aw_award_all.award_id%TYPE

351: AND NVL(awd.lock_award_flag,'N') = 'N';
352:
353: -- Cursor to get the RFMS records for the particular award id
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;

Line 373: cp_award_id igf_aw_award_all.award_id%TYPE

369:
370: -- Cursor to get the awards
371: --modified in FA131 to choose adplans_id,offered_amt also
372: CURSOR c_award(
373: cp_award_id igf_aw_award_all.award_id%TYPE
374: ) IS
375: SELECT awd.rowid row_id,
376: awd.*
377: FROM igf_aw_award_all awd

Line 377: FROM igf_aw_award_all awd

373: cp_award_id igf_aw_award_all.award_id%TYPE
374: ) IS
375: SELECT awd.rowid row_id,
376: awd.*
377: FROM igf_aw_award_all awd
378: WHERE awd.award_id = cp_award_id
379: AND awd.award_status IN ('OFFERED','ACCEPTED');
380:
381: lc_stud_det c_stud_det%ROWTYPE;

Line 454: cp_award_id igf_aw_award_all.award_id%TYPE,

450: lv_rfmd_id NUMBER;
451:
452: -- Get disbursements which should be cancelled
453: CURSOR c_disb_cancel(
454: cp_award_id igf_aw_award_all.award_id%TYPE,
455: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
456: ) IS
457: SELECT *
458: FROM igf_aw_awd_disb

Line 464: cp_award_id igf_aw_award_all.award_id%TYPE,

460: AND disb_num > cp_disb_num;
461:
462: -- Get context disbursement record
463: CURSOR c_disb(
464: cp_award_id igf_aw_award_all.award_id%TYPE,
465: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
466: ) IS
467: SELECT disb.rowid row_id,
468: disb.*

Line 507: l_pell_schedule_code igf_aw_award_all.alt_pell_schedule%TYPE;

503:
504: l_pell_disb_cnt NUMBER;
505: lv_rowid VARCHAR2(25);
506: l_pell_seq_id igf_gr_pell_setup_all.pell_seq_id%TYPE;
507: l_pell_schedule_code igf_aw_award_all.alt_pell_schedule%TYPE;
508:
509: -- Get person number
510: CURSOR c_person_number(
511: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE

Line 1322: p_org_id IN igf_aw_award_all.org_id%TYPE,

1318: errbuf OUT NOCOPY VARCHAR2,
1319: retcode OUT NOCOPY NUMBER,
1320: p_award_year IN VARCHAR2,
1321: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1322: p_org_id IN igf_aw_award_all.org_id%TYPE,
1323: p_persid_grp IN igs_pe_persid_group_all.group_id%TYPE,
1324: p_test_run IN VARCHAR2,
1325: p_cancel_invalid_awds IN VARCHAR2
1326: ) AS

Line 1351: FROM igf_aw_award_all awd,

1347: cp_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
1348: cp_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE
1349: ) IS
1350: SELECT awd.base_id
1351: FROM igf_aw_award_all awd,
1352: igf_aw_fund_mast_all fmast,
1353: igf_aw_fund_cat_all fcat
1354: WHERE fmast.ci_sequence_number = cp_seq_number
1355: AND fmast.ci_cal_type = cp_cal_type