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_AW_PACKAGING dependencies on IGF_AW_AWARD_ALL

Line 327: awarded_aid igf_aw_award_all.offered_amt%TYPE

323:
324: TYPE std_aid IS RECORD(
325: base_id igf_ap_fa_base_rec_all.base_id%TYPE,
326: need_f igf_ap_fa_base_rec_all.need_f%TYPE,
327: awarded_aid igf_aw_award_all.offered_amt%TYPE
328: );
329:
330: TYPE std_aid_tab IS TABLE OF std_aid;
331:

Line 713: p_awd_proc_status_code igf_aw_award_all.awd_proc_status_code%TYPE

709:
710: PROCEDURE setAPProcStat(
711: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
712: p_award_prd_cd igf_aw_award_prd.award_prd_cd%TYPE,
713: p_awd_proc_status_code igf_aw_award_all.awd_proc_status_code%TYPE
714: ) AS
715: ------------------------------------------------------------------
716: --Created by : veramach, Oracle India
717: --Date created: 10/September/2005

Line 733: FROM igf_aw_award_all awd,

729:
730: CURSOR c_awards IS
731: SELECT awd.ROWID row_id,
732: awd.*
733: FROM igf_aw_award_all awd,
734: igf_aw_fund_mast_all fmast
735: WHERE fmast.ci_cal_type = l_ci_cal_type
736: AND fmast.ci_sequence_number = l_ci_sequence_number
737: AND awd.fund_id = fmast.fund_id

Line 1135: CURSOR c_sim_adisb ( cp_award_id igf_aw_award_all.award_id%TYPE ) IS

1131: || (reverse chronological order - newest change first)
1132: */
1133:
1134: -- Retrieves all simulated disbursement records
1135: CURSOR c_sim_adisb ( cp_award_id igf_aw_award_all.award_id%TYPE ) IS
1136: SELECT adisb.rowid row_id
1137: FROM igf_aw_awd_disb_all adisb
1138: WHERE adisb.award_id = cp_award_id;
1139:

Line 1141: CURSOR c_sim_awd ( cp_base_id igf_aw_award_all.base_id%TYPE ) IS

1137: FROM igf_aw_awd_disb_all adisb
1138: WHERE adisb.award_id = cp_award_id;
1139:
1140: -- Retrieves all simulated award records
1141: CURSOR c_sim_awd ( cp_base_id igf_aw_award_all.base_id%TYPE ) IS
1142: SELECT awd.rowid row_id,
1143: awd.award_id
1144: FROM igf_aw_award_all awd
1145: WHERE awd.base_id = cp_base_id

Line 1144: FROM igf_aw_award_all awd

1140: -- Retrieves all simulated award records
1141: CURSOR c_sim_awd ( cp_base_id igf_aw_award_all.base_id%TYPE ) IS
1142: SELECT awd.rowid row_id,
1143: awd.award_id
1144: FROM igf_aw_award_all awd
1145: WHERE awd.base_id = cp_base_id
1146: AND awd.award_status = 'SIMULATED';
1147:
1148: BEGIN

Line 1197: p_award_id igf_aw_award_all.award_id%TYPE,

1193: RETURN lv_profile_value;
1194: END get_coa_lock_prof_val;
1195:
1196: PROCEDURE update_pell_orig_stat(
1197: p_award_id igf_aw_award_all.award_id%TYPE,
1198: p_amount igf_aw_award_all.offered_amt%TYPE
1199: ) AS
1200: ------------------------------------------------------------------
1201: --Created by : veramach, Oracle India

Line 1198: p_amount igf_aw_award_all.offered_amt%TYPE

1194: END get_coa_lock_prof_val;
1195:
1196: PROCEDURE update_pell_orig_stat(
1197: p_award_id igf_aw_award_all.award_id%TYPE,
1198: p_amount igf_aw_award_all.offered_amt%TYPE
1199: ) AS
1200: ------------------------------------------------------------------
1201: --Created by : veramach, Oracle India
1202: --Date created: 05-Nov-2004

Line 1215: cp_award_id igf_aw_award_all.award_id%TYPE,

1211: -------------------------------------------------------------------
1212:
1213: -- Get pell orig
1214: CURSOR c_pell_orig(
1215: cp_award_id igf_aw_award_all.award_id%TYPE,
1216: cp_amount igf_aw_award_all.offered_amt%TYPE
1217: ) IS
1218: SELECT rfms.rowid row_id,
1219: rfms.*

Line 1216: cp_amount igf_aw_award_all.offered_amt%TYPE

1212:
1213: -- Get pell orig
1214: CURSOR c_pell_orig(
1215: cp_award_id igf_aw_award_all.award_id%TYPE,
1216: cp_amount igf_aw_award_all.offered_amt%TYPE
1217: ) IS
1218: SELECT rfms.rowid row_id,
1219: rfms.*
1220: FROM igf_gr_rfms_all rfms

Line 1296: p_award_id igf_aw_award_all.award_id%TYPE,

1292: END LOOP;
1293: END update_pell_orig_stat;
1294:
1295: PROCEDURE update_loan_stat(
1296: p_award_id igf_aw_award_all.award_id%TYPE,
1297: p_amount igf_aw_award_all.offered_amt%TYPE
1298: ) AS
1299: ------------------------------------------------------------------
1300: --Created by : veramach, Oracle India

Line 1297: p_amount igf_aw_award_all.offered_amt%TYPE

1293: END update_pell_orig_stat;
1294:
1295: PROCEDURE update_loan_stat(
1296: p_award_id igf_aw_award_all.award_id%TYPE,
1297: p_amount igf_aw_award_all.offered_amt%TYPE
1298: ) AS
1299: ------------------------------------------------------------------
1300: --Created by : veramach, Oracle India
1301: --Date created: 07-Dec-2004

Line 1313: cp_award_id igf_aw_award_all.award_id%TYPE,

1309: --Who When What
1310: -------------------------------------------------------------------
1311: -- Get loan
1312: CURSOR c_loan(
1313: cp_award_id igf_aw_award_all.award_id%TYPE,
1314: cp_amount igf_aw_award_all.offered_amt%TYPE
1315: ) IS
1316: SELECT loan.ROWID row_id,
1317: loan.*

Line 1314: cp_amount igf_aw_award_all.offered_amt%TYPE

1310: -------------------------------------------------------------------
1311: -- Get loan
1312: CURSOR c_loan(
1313: cp_award_id igf_aw_award_all.award_id%TYPE,
1314: cp_amount igf_aw_award_all.offered_amt%TYPE
1315: ) IS
1316: SELECT loan.ROWID row_id,
1317: loan.*
1318: FROM igf_sl_loans_all loan,

Line 1319: igf_aw_award_all awd

1315: ) IS
1316: SELECT loan.ROWID row_id,
1317: loan.*
1318: FROM igf_sl_loans_all loan,
1319: igf_aw_award_all awd
1320: WHERE loan.award_id = cp_award_id
1321: AND loan.award_id = awd.award_id
1322: AND awd.offered_amt <> cp_amount
1323: AND loan.loan_status <> 'S';

Line 1383: p_award_id igf_aw_award_all.award_id%TYPE

1379: END LOOP;
1380: END update_loan_stat;
1381:
1382: PROCEDURE cancel_invalid_award(
1383: p_award_id igf_aw_award_all.award_id%TYPE
1384: ) AS
1385: ------------------------------------------------------------------
1386: --Created by : veramach, Oracle India
1387: --Date created: 27-Oct-2004

Line 1408: cp_award_id igf_aw_award_all.award_id%TYPE

1404: -------------------------------------------------------------------
1405:
1406: -- Get an award
1407: CURSOR c_award(
1408: cp_award_id igf_aw_award_all.award_id%TYPE
1409: ) IS
1410: SELECT awd.rowid row_id,
1411: awd.*
1412: FROM igf_aw_award_all awd

Line 1412: FROM igf_aw_award_all awd

1408: cp_award_id igf_aw_award_all.award_id%TYPE
1409: ) IS
1410: SELECT awd.rowid row_id,
1411: awd.*
1412: FROM igf_aw_award_all awd
1413: WHERE award_id = cp_award_id
1414: AND award_status <> 'CANCELLED';
1415:
1416: -- Get disbursements for an award

Line 1418: cp_award_id igf_aw_award_all.award_id%TYPE

1414: AND award_status <> 'CANCELLED';
1415:
1416: -- Get disbursements for an award
1417: CURSOR c_disb(
1418: cp_award_id igf_aw_award_all.award_id%TYPE
1419: ) IS
1420: SELECT disb.rowid row_id,
1421: disb.*
1422: FROM igf_aw_awd_disb_all disb

Line 1435: l_amount igf_aw_award_all.offered_amt%TYPE;

1431: WHERE fund_id = cp_fund_id;
1432: l_fund_code igf_aw_fund_mast_all.fund_code%TYPE;
1433:
1434: lv_rowid ROWID;
1435: l_amount igf_aw_award_all.offered_amt%TYPE;
1436:
1437: -- Get total amount already sent to COD
1438: CURSOR c_rfms_disb(
1439: cp_award_id igf_aw_award_all.award_id%TYPE

Line 1439: cp_award_id igf_aw_award_all.award_id%TYPE

1435: l_amount igf_aw_award_all.offered_amt%TYPE;
1436:
1437: -- Get total amount already sent to COD
1438: CURSOR c_rfms_disb(
1439: cp_award_id igf_aw_award_all.award_id%TYPE
1440: ) IS
1441: SELECT SUM(disb.disb_amt)
1442: FROM igf_gr_rfms_all rfms,
1443: igf_gr_rfms_disb_all disb

Line 1450: cp_award_id igf_aw_award_all.award_id%TYPE

1446: AND disb.disb_ack_act_status IN ('S','A','D','C');
1447:
1448: -- Get last disb
1449: CURSOR c_last_disb(
1450: cp_award_id igf_aw_award_all.award_id%TYPE
1451: ) IS
1452: SELECT disb_num,
1453: tp_cal_type,
1454: tp_sequence_number,

Line 2093: || Status Date' are got at the award level (from IGF_AW_AWARD_ALL table).

2089: || Note, in repackaging when there are extra disb of the old
2090: || award they are cancelled.
2091: || museshad 02-Jun-2005 Build# FA157 - Bug# 4382371.
2092: || As per the new logic 'Award Notification Status' and 'Award Notification
2093: || Status Date' are got at the award level (from IGF_AW_AWARD_ALL table).
2094: || Previously they were got from IGF_AP_FA_BASE_REC_ALL table. Passed
2095: || NULL to these columns in the TBH call for
2096: || IGF_AP_FA_BASE_REC_ALL table.
2097: || ayedubat 12-OCT-04 Changed the TBH calls of igf_aw_awd_disb_pkg package to add a new column,

Line 2243: cp_award_id igf_aw_award_all.award_id%TYPE,

2239: l_fabase c_fabase%ROWTYPE;
2240:
2241: -- Get a specific disbursment for an award
2242: CURSOR c_disb(
2243: cp_award_id igf_aw_award_all.award_id%TYPE,
2244: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
2245: ) IS
2246: SELECT rowid row_id,
2247: disb.*

Line 2290: l_alt_pell_schedule igf_aw_award_all.alt_pell_schedule%TYPE;

2286: ln_db_act_gross_amt NUMBER(12,2) := 0;
2287: ln_db_run_accpt_amt NUMBER(12,2) := 0;
2288: ln_db_act_accpt_amt NUMBER(12,2) := 0;
2289: ln_com_perct NUMBER;
2290: l_alt_pell_schedule igf_aw_award_all.alt_pell_schedule%TYPE;
2291: lb_awards_created BOOLEAN;
2292: lv_update_notif_stat VARCHAR(2);
2293: l_attendance_type_code igf_aw_awd_disb_all.attendance_type_code%TYPE;
2294: l_base_attendance_type_code igf_aw_awd_disb_all.base_attendance_type_code%TYPE;

Line 2299: lv_app_trans_num_txt igf_aw_award_all.app_trans_num_txt%TYPE;

2295: ln_total_disb_num NUMBER;
2296: lv_awd_notif_status VARCHAR2(1);
2297: SKIP_RECORD EXCEPTION;
2298:
2299: lv_app_trans_num_txt igf_aw_award_all.app_trans_num_txt%TYPE;
2300: lv_result VARCHAR2(80);
2301: lv_method_code igf_aw_awd_dist_plans.dist_plan_method_code%TYPE;
2302:
2303: -- Get payment ISIR transaction number

Line 2320: cp_award_id igf_aw_award_all.award_id%TYPE

2316:
2317:
2318: -- Get award details
2319: CURSOR c_award_det(
2320: cp_award_id igf_aw_award_all.award_id%TYPE
2321: ) IS
2322: SELECT awd.ROWID row_id,awd.*
2323: FROM igf_aw_award_all awd
2324: WHERE award_id = cp_award_id;

Line 2323: FROM igf_aw_award_all awd

2319: CURSOR c_award_det(
2320: cp_award_id igf_aw_award_all.award_id%TYPE
2321: ) IS
2322: SELECT awd.ROWID row_id,awd.*
2323: FROM igf_aw_award_all awd
2324: WHERE award_id = cp_award_id;
2325: l_award_det c_award_det%ROWTYPE;
2326:
2327: -- Get disbursements which should be cancelled

Line 2329: cp_award_id igf_aw_award_all.award_id%TYPE,

2325: l_award_det c_award_det%ROWTYPE;
2326:
2327: -- Get disbursements which should be cancelled
2328: CURSOR c_disb_cancel(
2329: cp_award_id igf_aw_award_all.award_id%TYPE,
2330: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
2331: ) IS
2332: SELECT *
2333: FROM igf_aw_awd_disb

Line 2341: cp_award_id igf_aw_award_all.award_id%TYPE,

2337: lv_locking_success VARCHAR2(1);
2338:
2339: -- Get pell disb orig
2340: CURSOR c_pell_disb_orig(
2341: cp_award_id igf_aw_award_all.award_id%TYPE,
2342: cp_disb_num igf_aw_awd_disb_all.disb_num%TYPE
2343: ) IS
2344: SELECT rfmd.ROWID row_id,
2345: rfmd.*

Line 2359: cp_award_id igf_aw_award_all.award_id%TYPE

2355: l_orig_id igf_gr_rfms_all.origination_id%TYPE;
2356:
2357: -- Get origination id for a PELL award
2358: CURSOR c_orig_id(
2359: cp_award_id igf_aw_award_all.award_id%TYPE
2360: ) IS
2361: SELECT rfms.origination_id
2362: FROM igf_gr_rfms_all rfms
2363: WHERE rfms.award_id = cp_award_id;

Line 4324: p_award_id igf_aw_award_all.award_id%TYPE

4320:
4321: END post_award;
4322:
4323: FUNCTION actualDisbExist(
4324: p_award_id igf_aw_award_all.award_id%TYPE
4325: ) RETURN BOOLEAN AS
4326: ------------------------------------------------------------------
4327: --Created by : veramach, Oracle India
4328: --Date created: 13-Oct-2004

Line 4382: FROM igf_aw_award_all awd,

4378: -------------------------------------------------------------------
4379:
4380: CURSOR c_awd IS
4381: SELECT 'x'
4382: FROM igf_aw_award_all awd,
4383: igf_aw_awd_disb_all disb,
4384: igf_aw_awd_prd_term aprd
4385: WHERE awd.fund_id = p_fund_id
4386: AND awd.base_id = p_base_id

Line 4399: FROM igf_aw_award_all

4395: l_awd c_awd%ROWTYPE;
4396:
4397: CURSOR c_awd_pell IS
4398: SELECT 'x'
4399: FROM igf_aw_award_all
4400: WHERE fund_id = p_fund_id
4401: AND base_id = p_base_id
4402: AND award_status IN ('ACCEPTED','OFFERED','CANCELLED')
4403: AND ROWNUM = 1;

Line 4435: p_award_id igf_aw_award_all.award_id%TYPE

4431: END awardsExist;
4432:
4433: FUNCTION isOriginated(
4434: p_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
4435: p_award_id igf_aw_award_all.award_id%TYPE
4436: ) RETURN BOOLEAN AS
4437: ------------------------------------------------------------------
4438: --Created by : veramach, Oracle India
4439: --Date created: 13-Oct-2004

Line 4521: p_award_id igf_aw_award_all.award_id%TYPE,

4517:
4518: FUNCTION doesAwardSpanOutsideAP(
4519: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
4520: p_ci_sequence_number igs_ca_inst.sequence_number%TYPE,
4521: p_award_id igf_aw_award_all.award_id%TYPE,
4522: p_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
4523: ) RETURN BOOLEAN AS
4524: ------------------------------------------------------------------
4525: --Created by : veramach, Oracle India

Line 4905: FROM igf_aw_award_all awd, igf_aw_fund_mast_all fmast

4901: fmast.over_award_amt,
4902: fmast.over_award_perct,
4903: fmast.available_amt,
4904: fmast.remaining_amt
4905: FROM igf_aw_award_all awd, igf_aw_fund_mast_all fmast
4906: WHERE awd.base_id = cp_base_id
4907: AND awd.fund_id = cp_fund_id
4908: AND awd.award_status IN('OFFERED', 'ACCEPTED', 'CANCELLED')
4909: AND fmast.fund_id = awd.fund_id

Line 4913: FROM igf_aw_award_all awd,

4909: AND fmast.fund_id = awd.fund_id
4910: AND lv_fed_fund_code <> 'PELL'
4911: AND awd.award_id IN(
4912: SELECT DISTINCT awd.award_id
4913: FROM igf_aw_award_all awd,
4914: igf_aw_awd_disb_all disb,
4915: igf_aw_awd_prd_term aprd
4916: WHERE awd.fund_id = cp_fund_id
4917: AND awd.base_id = cp_base_id

Line 4938: FROM igf_aw_award_all awd, igf_aw_fund_mast_all fmast

4934: fmast.over_award_amt,
4935: fmast.over_award_perct,
4936: fmast.available_amt,
4937: fmast.remaining_amt
4938: FROM igf_aw_award_all awd, igf_aw_fund_mast_all fmast
4939: WHERE awd.base_id = cp_base_id
4940: AND awd.fund_id = cp_fund_id
4941: AND awd.award_status IN('OFFERED', 'ACCEPTED', 'CANCELLED')
4942: AND fmast.fund_id = awd.fund_id

Line 4947: cp_award_id igf_aw_award_all.award_id%TYPE

4943: AND lv_fed_fund_code = 'PELL';
4944:
4945: -- Get loan status
4946: CURSOR c_loan_status(
4947: cp_award_id igf_aw_award_all.award_id%TYPE
4948: ) IS
4949: SELECT loan_status,
4950: loan_chg_status
4951: FROM igf_sl_loans

Line 4957: cp_award_id igf_aw_award_all.award_id%TYPE

4953: l_loan_status igf_sl_loans.loan_status%TYPE;
4954: l_loan_chg_status igf_sl_loans.loan_chg_status%TYPE;
4955:
4956: CURSOR c_pell_orig_stat(
4957: cp_award_id igf_aw_award_all.award_id%TYPE
4958: ) IS
4959: SELECT orig_action_code
4960: FROM igf_gr_rfms_all
4961: WHERE award_id = cp_award_id;

Line 4968: cp_award_id igf_aw_award_all.award_id%TYPE

4964: lb_awards_locked BOOLEAN;
4965:
4966: -- Get pell disb orig status
4967: CURSOR c_pell_disb_orig_stat(
4968: cp_award_id igf_aw_award_all.award_id%TYPE
4969: ) IS
4970: SELECT disb.disb_ack_act_status
4971: FROM igf_gr_rfms_disb_all disb,
4972: igf_gr_rfms_all rfms

Line 5030: igf_aw_award_all awd

5026: ) IS
5027: SELECT SUM(DECODE(awd.award_status,'CANCELLED',1,0)) cancelled_awd,
5028: SUM(DECODE(awd.award_status,'OFFERED',1,'ACCEPTED',1,0)) off_acc_awd
5029: FROM igf_aw_award_t_all awdt,
5030: igf_aw_award_all awd
5031: WHERE awdt.fund_id = cp_fund_id
5032: AND awdt.base_id = cp_base_id
5033: AND awdt.process_id = l_process_id
5034: AND awdt.flag = 'AU'

Line 5045: igf_aw_award_all awd

5041: ) IS
5042: SELECT awdt.ROWID row_id,
5043: awdt.*
5044: FROM igf_aw_award_t_all awdt,
5045: igf_aw_award_all awd
5046: WHERE awdt.award_id = awd.award_id
5047: AND awdt.fund_id = cp_fund_id
5048: AND awdt.base_id = cp_base_id
5049: AND awdt.process_id = l_process_id

Line 5056: cp_award_id igf_aw_award_all.award_id%TYPE

5052:
5053: CURSOR c_lock_pell_awd1(
5054: cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
5055: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
5056: cp_award_id igf_aw_award_all.award_id%TYPE
5057: ) IS
5058: SELECT awdt.ROWID row_id,
5059: awdt.*
5060: FROM igf_aw_award_t_all awdt

Line 5072: igf_aw_award_all awd

5068: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
5069: ) IS
5070: SELECT awd.award_id
5071: FROM igf_aw_award_t_all awdt,
5072: igf_aw_award_all awd
5073: WHERE awdt.award_id = awd.award_id
5074: AND awdt.fund_id = cp_fund_id
5075: AND awdt.base_id = cp_base_id
5076: AND awdt.process_id = l_process_id

Line 5766: FROM igf_aw_award_all awd,

5762: SELECT DISTINCT fmast.fund_id,
5763: fmast.lock_award_flag,
5764: fmast.re_pkg_verif_flag,
5765: fmast.donot_repkg_if_code
5766: FROM igf_aw_award_all awd,
5767: igf_aw_fund_mast_all fmast,
5768: igf_aw_awd_disb_all disb,
5769: igf_aw_awd_prd_term aprd
5770: WHERE fmast.fund_id = awd.fund_id

Line 6676: FROM igf_aw_award_all awd,

6672: x_base_id igf_aw_award_t.base_id%TYPE,
6673: x_award_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
6674: ) IS
6675: SELECT COUNT(fmast.fund_code) ftotal
6676: FROM igf_aw_award_all awd,
6677: igf_aw_awd_disb_all disb,
6678: igf_aw_fund_mast_all fmast,
6679: igf_aw_awd_prd_term aprd
6680: WHERE fmast.fund_code = x_fund_code

Line 7571: FROM igf_aw_award_all awd,

7567: 'READY', 2,
7568: 'REVIEW', 3,
7569: 'DO_NOT_REPKG', 4
7570: ) status_order
7571: FROM igf_aw_award_all awd,
7572: igf_aw_fund_mast_all fmast
7573: WHERE fmast.ci_cal_type = p_ci_cal_type
7574: AND fmast.ci_sequence_number = p_ci_sequence_number
7575: AND awd.fund_id = fmast.fund_id

Line 7589: l_award_process_status igf_aw_award_all.awd_proc_status_code%TYPE;

7585: FROM igf_aw_awd_prd_term apt
7586: WHERE apt.ci_cal_type = p_ci_cal_type
7587: AND apt.ci_sequence_number = p_ci_sequence_number
7588: AND apt.award_prd_cd = p_award_prd_code));
7589: l_award_process_status igf_aw_award_all.awd_proc_status_code%TYPE;
7590:
7591: BEGIN
7592: l_award_process_status := NULL;
7593: OPEN c_award_process_status;

Line 7652: FROM igf_aw_award_all awd,

7648: fm.update_need update_need,
7649: NVL(fm.entitlement,'N') entitlement,
7650: fcat.fed_fund_code fed_fund_code,
7651: fm.fm_fc_methd fm_fc_methd
7652: FROM igf_aw_award_all awd,
7653: igf_aw_fund_mast_all fm,
7654: igf_aw_fund_cat_all fcat
7655: WHERE base_id = cp_base_id
7656: AND awd.fund_id = fm.fund_id

Line 7728: l_failed_award_id igf_aw_award_all.award_id%TYPE;

7724:
7725: lv_name igf_aw_awd_dist_plans.awd_dist_plan_cd_desc%TYPE := NULL;
7726: lv_desc igf_aw_awd_dist_plans_v.dist_plan_method_code_desc%TYPE := NULL;
7727:
7728: l_failed_award_id igf_aw_award_all.award_id%TYPE;
7729:
7730: BEGIN
7731: l_ret_status :='S';
7732: l_failed_award_id := NULL;

Line 8451: cp_fund_id igf_aw_award_all.fund_id%TYPE,

8447: -- Enhancement bug no 1818617, pmarada
8448: -- Get the Maximum Year Amount which is award to a student for a given fund
8449: -- ???? Common Terms
8450: CURSOR c_max_yr_amt(
8451: cp_fund_id igf_aw_award_all.fund_id%TYPE,
8452: cp_base_id igf_aw_award_all.base_id%TYPE
8453: ) IS
8454: SELECT SUM(disb.disb_gross_amt) yr_total
8455: FROM igf_aw_awd_disb_all disb,

Line 8452: cp_base_id igf_aw_award_all.base_id%TYPE

8448: -- Get the Maximum Year Amount which is award to a student for a given fund
8449: -- ???? Common Terms
8450: CURSOR c_max_yr_amt(
8451: cp_fund_id igf_aw_award_all.fund_id%TYPE,
8452: cp_base_id igf_aw_award_all.base_id%TYPE
8453: ) IS
8454: SELECT SUM(disb.disb_gross_amt) yr_total
8455: FROM igf_aw_awd_disb_all disb,
8456: igf_aw_award_all awd,

Line 8456: igf_aw_award_all awd,

8452: cp_base_id igf_aw_award_all.base_id%TYPE
8453: ) IS
8454: SELECT SUM(disb.disb_gross_amt) yr_total
8455: FROM igf_aw_awd_disb_all disb,
8456: igf_aw_award_all awd,
8457: igf_aw_fund_mast_all fmast
8458: WHERE disb.award_id = awd.award_id
8459: AND fmast.fund_id = awd.fund_id
8460: AND fmast.fund_id = cp_fund_id

Line 8489: igf_aw_award_all awd,

8485: NVL(SUM(NVL(disb.disb_gross_amt,0)),0) lf_total,
8486: COUNT(DISTINCT awd.award_id) lf_count
8487: FROM
8488: igf_aw_awd_disb_all disb,
8489: igf_aw_award_all awd,
8490: igf_aw_fund_mast_all fmast,
8491: igf_ap_fa_base_rec_all fabase
8492: WHERE fmast.fund_code = cp_fund_code
8493: AND disb.award_id = awd.award_id

Line 8510: FROM igf_aw_award_all awd,

8506: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
8507: IS
8508: SELECT NVL(SUM(NVL(awd.offered_amt,0)),0) lf_total,
8509: COUNT(awd.award_id) lf_count
8510: FROM igf_aw_award_all awd,
8511: igf_aw_fund_mast_all fmast,
8512: igf_ap_fa_base_rec fabase,
8513: igf_ap_batch_aw_map_all bam
8514: WHERE fmast.fund_code = cp_fund_code

Line 8595: FROM igf_aw_award_all awd

8591: AND awdt.base_id = cp_base_id
8592: AND awdt.flag = 'AW'
8593: UNION ALL
8594: SELECT NVL(SUM(awd.offered_amt),0) offered_amt
8595: FROM igf_aw_award_all awd
8596: WHERE awd.fund_id = cp_fund_id
8597: AND awd.base_id=cp_base_id
8598: AND award_status NOT IN ('DECLINED','CANCELLED','STOPPED');
8599: commented for FISAP

Line 8618: cp_base_id igf_aw_award_all.base_id%TYPE)

8614: -- This cursor is used to know if the person is having awards from the
8615: -- fund, if there are awards then do not re-package
8616: -- -- ???? Common Terms
8617: CURSOR cur_fund_awd_exist (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
8618: cp_base_id igf_aw_award_all.base_id%TYPE)
8619: IS
8620: SELECT COUNT(award_id) cnt
8621: FROM igf_aw_award_all
8622: WHERE base_id = cp_base_id

Line 8621: FROM igf_aw_award_all

8617: CURSOR cur_fund_awd_exist (cp_fund_id igf_aw_fund_mast_all.fund_id%TYPE,
8618: cp_base_id igf_aw_award_all.base_id%TYPE)
8619: IS
8620: SELECT COUNT(award_id) cnt
8621: FROM igf_aw_award_all
8622: WHERE base_id = cp_base_id
8623: AND fund_id = cp_fund_id
8624: AND award_status NOT IN ('SIMULATED','CANCELLED');
8625:

Line 8637: FROM igf_aw_award_all awd,

8633: SELECT fcat.fund_code fund_code,
8634: fed_fund_code,
8635: NVL(awd.offered_amt,0) offered_amt ,
8636: award_date
8637: FROM igf_aw_award_all awd,
8638: igf_aw_fund_mast_all fm,
8639: igf_aw_fund_cat_all fcat
8640: WHERE awd.award_status IN ('OFFERED','ACCEPTED')
8641: AND awd.base_id = cp_base_id

Line 8698: award_id igf_aw_award_all.award_id%TYPE,

8694: accepted_amt igf_aw_award_t.accepted_Amt%TYPE,
8695: total NUMBER,
8696: seq_no igf_aw_awd_frml_det.seq_no%TYPE,
8697: adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
8698: award_id igf_aw_award_all.award_id%TYPE,
8699: lock_award_flag igf_aw_award_all.lock_award_flag%TYPE
8700: );
8701:
8702: l_awd_grp awd_grp_rec;

Line 8699: lock_award_flag igf_aw_award_all.lock_award_flag%TYPE

8695: total NUMBER,
8696: seq_no igf_aw_awd_frml_det.seq_no%TYPE,
8697: adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE,
8698: award_id igf_aw_award_all.award_id%TYPE,
8699: lock_award_flag igf_aw_award_all.lock_award_flag%TYPE
8700: );
8701:
8702: l_awd_grp awd_grp_rec;
8703: TYPE awd_grp IS REF CURSOR RETURN awd_grp_rec;

Line 8762: igf_aw_award_all awd

8758: cp_process_id igf_aw_award_t.process_id%TYPE
8759: ) IS
8760: SELECT fmast.fm_fc_methd fm_fc_methd
8761: FROM igf_aw_fund_mast_all fmast,
8762: igf_aw_award_all awd
8763: WHERE awd.fund_id = fmast.fund_id
8764: AND awd.base_id=cp_base_id
8765: AND fmast.fm_fc_methd = 'FEDERAL'
8766: UNION

Line 8788: l_pell_schedule_code igf_aw_award_all.alt_pell_schedule%TYPE;

8784:
8785: l_pell_seq_id igf_gr_pell_setup_all.pell_seq_id%TYPE;
8786: lv_message fnd_new_messages.message_text%TYPE;
8787: lv_return_status VARCHAR2(10);
8788: l_pell_schedule_code igf_aw_award_all.alt_pell_schedule%TYPE;
8789:
8790: lv_called_from VARCHAR2(80);
8791: lb_coa_defined BOOLEAN;
8792:

Line 8795: cp_award_id igf_aw_award_all.award_id%TYPE

8791: lb_coa_defined BOOLEAN;
8792:
8793:
8794: CURSOR c_temp_awd(
8795: cp_award_id igf_aw_award_all.award_id%TYPE
8796: ) IS
8797: SELECT *
8798: FROM igf_aw_award_t
8799: WHERE award_id = cp_award_id

Line 8813: igf_aw_award_all awd

8809: disb.base_attendance_type_code,
8810: SUM(disb.disb_gross_amt) term_total,
8811: awd.adplans_id
8812: FROM igf_aw_awd_disb_all disb,
8813: igf_aw_award_all awd
8814: WHERE awd.award_id = disb.award_id
8815: AND awd.award_id = p_award_id
8816: GROUP BY disb.ld_cal_type,
8817: disb.ld_sequence_number,

Line 8824: cp_award_id igf_aw_award_all.award_id%TYPE,

8820: l_term_aid NUMBER;
8821:
8822: -- Get first disb date for a term
8823: CURSOR c_first_disb_dt(
8824: cp_award_id igf_aw_award_all.award_id%TYPE,
8825: cp_ld_cal_type igs_ca_inst.cal_type%TYPE,
8826: cp_ld_sequence_number igs_ca_inst.sequence_number%TYPE
8827: ) IS
8828: SELECT disb_date,

Line 11693: x_award_id igf_aw_award_all.award_id%TYPE

11689: x_fund_id igf_aw_fund_mast.fund_id%TYPE,
11690: x_process_id NUMBER,
11691: x_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
11692: x_seq_no NUMBER,
11693: x_award_id igf_aw_award_all.award_id%TYPE
11694: ) IS
11695: SELECT awdt.*
11696: FROM igf_aw_award_t awdt
11697: WHERE fund_id = x_fund_id

Line 11706: l_paid_amt igf_aw_award_all.paid_amt%TYPE;

11702: AND NVL(award_id,-1) = NVL(x_award_id,-1);
11703:
11704: l_awd_det c_awd_det%ROWTYPE;
11705:
11706: l_paid_amt igf_aw_award_all.paid_amt%TYPE;
11707: -- Get paid amt
11708: CURSOR c_paid_amt(
11709: cp_award_id igf_aw_award_all.award_id%TYPE
11710: ) IS

Line 11709: cp_award_id igf_aw_award_all.award_id%TYPE

11705:
11706: l_paid_amt igf_aw_award_all.paid_amt%TYPE;
11707: -- Get paid amt
11708: CURSOR c_paid_amt(
11709: cp_award_id igf_aw_award_all.award_id%TYPE
11710: ) IS
11711: SELECT SUM(paid_amount) paid_amount
11712: FROM igf_se_payment pay,
11713: igf_se_auth auth

Line 11721: cp_award_id igf_aw_award_all.award_id%TYPE,

11717:
11718: -- check if the award has been repackaged
11719: CURSOR c_awd_ex(
11720: cp_process_id NUMBER,
11721: cp_award_id igf_aw_award_all.award_id%TYPE,
11722: cp_seq_no NUMBER
11723: ) IS
11724: SELECT 'x'
11725: FROM igf_aw_award_t

Line 12093: cp_award_id igf_aw_award_all.award_id%TYPE

12089: lb_use_wcoa_cur BOOLEAN := FALSE;
12090:
12091: -- Get existing pell disbursments
12092: CURSOR c_pelldisb(
12093: cp_award_id igf_aw_award_all.award_id%TYPE
12094: ) IS
12095: SELECT disb.rowid row_id,
12096: disb.*
12097: FROM igf_aw_awd_disb_all disb

Line 12104: cp_award_id igf_aw_award_all.award_id%TYPE

12100: ORDER BY disb.disb_num;
12101:
12102: -- Get distribution plan for the pell award
12103: CURSOR c_pell_dp(
12104: cp_award_id igf_aw_award_all.award_id%TYPE
12105: ) IS
12106: SELECT adplans_id
12107: FROM igf_aw_award_all
12108: WHERE award_id = cp_award_id;

Line 12107: FROM igf_aw_award_all

12103: CURSOR c_pell_dp(
12104: cp_award_id igf_aw_award_all.award_id%TYPE
12105: ) IS
12106: SELECT adplans_id
12107: FROM igf_aw_award_all
12108: WHERE award_id = cp_award_id;
12109: l_pell_dp igf_aw_awd_dist_plans.adplans_id%TYPE;
12110:
12111: -- Get extra pell disbursements

Line 12113: cp_award_id igf_aw_award_all.award_id%TYPE,

12109: l_pell_dp igf_aw_awd_dist_plans.adplans_id%TYPE;
12110:
12111: -- Get extra pell disbursements
12112: CURSOR c_pell_new_disb(
12113: cp_award_id igf_aw_award_all.award_id%TYPE,
12114: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE
12115: ) IS
12116: SELECT awdt.*
12117: FROM igf_aw_award_t awdt

Line 12125: cp_award_id igf_aw_award_all.award_id%TYPE,

12121: AND flag = 'GR';
12122:
12123: CURSOR c_base_attendance(
12124: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
12125: cp_award_id igf_aw_award_all.award_id%TYPE,
12126: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
12127: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE
12128: ) IS
12129: SELECT awdt.temp_char2_txt base_attendance_type_code