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_SL_AWARD dependencies on IGF_AW_AWARD

Line 88: FROM igf_aw_award awd,

84: cp_award_id igf_sl_loans.award_id%TYPE
85: )
86: IS
87: SELECT fed_fund_code
88: FROM igf_aw_award awd,
89: igf_aw_fund_mast fundmast,
90: igf_aw_fund_cat fundcat
91: WHERE awd.award_id = cp_award_id
92: AND awd.fund_id = fundmast.fund_id

Line 98: p_base_id igf_aw_award_all.base_id%TYPE,

94:
95: FUNCTION get_cl_hold_rel_ind(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
96: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
97: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
98: p_base_id igf_aw_award_all.base_id%TYPE,
99: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE)
100: RETURN VARCHAR2
101: AS
102: /*************************************************************

Line 170: p_base_id igf_aw_award_all.base_id%TYPE,

166: -- Created as part of FA 122 Loans Enhancements
167: FUNCTION get_cl_auto_late_ind(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
168: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
169: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
170: p_base_id igf_aw_award_all.base_id%TYPE,
171: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE)
172: RETURN VARCHAR2
173: AS
174: /*************************************************************

Line 247: p_base_id igf_aw_award_all.base_id%TYPE,

243:
244: FUNCTION get_loan_fee1(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
245: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
246: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
247: p_base_id igf_aw_award_all.base_id%TYPE,
248: p_rel_code VARCHAR2,
249: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE)
250: RETURN NUMBER
251: AS

Line 382: p_base_id igf_aw_award_all.base_id%TYPE,

378:
379: FUNCTION get_loan_fee2(p_fed_fund_code igf_aw_fund_cat.fed_fund_code%TYPE,
380: p_ci_cal_type igs_ca_inst.cal_type%TYPE,
381: p_ci_seq_num igs_ca_inst.sequence_number%TYPE,
382: p_base_id igf_aw_award_all.base_id%TYPE,
383: p_rel_code VARCHAR2,
384: p_alt_rel_code igf_aw_fund_cat_all.alt_rel_code%TYPE)
385: RETURN NUMBER
386: AS

Line 497: CURSOR c_loans (cp_n_award_id igf_aw_award_all.award_id%TYPE,

493: || (reverse chronological order - newest change first)
494: || smadathi 14-OCT-2004 Bug 3416936.Changes as per TD
495: ------------------------------------------------------------------*/
496:
497: CURSOR c_loans (cp_n_award_id igf_aw_award_all.award_id%TYPE,
498: cp_loan_per_begin_date igf_sl_loans_all.loan_per_begin_date%TYPE,
499: cp_loan_per_end_date igf_sl_loans_all.loan_per_end_date%TYPE) IS
500: SELECT disb.award_id
501: ,disb.disb_date

Line 725: p_base_id IN igf_aw_award_all.base_id%TYPE,

721:
722: END get_loan_amts;
723:
724: PROCEDURE recalc_fees(
725: p_base_id IN igf_aw_award_all.base_id%TYPE,
726: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
727: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
728: p_rel_code IN igf_sl_cl_setup.relationship_cd%TYPE,
729: p_award_id IN igf_sl_loans.award_id%TYPE

Line 771: CURSOR c_get_alt_code (cp_award_id igf_aw_award_all.award_id%TYPE)

767: SELECT *
768: FROM igf_aw_awd_disb adisb
769: WHERE adisb.award_id = p_award_id;
770:
771: CURSOR c_get_alt_code (cp_award_id igf_aw_award_all.award_id%TYPE)
772: IS
773: select
774: fcat.alt_rel_code alt_rel_code
775: from

Line 776: igf_aw_award_all awd,

772: IS
773: select
774: fcat.alt_rel_code alt_rel_code
775: from
776: igf_aw_award_all awd,
777: igf_aw_fund_mast_all fmast,
778: igf_aw_fund_cat_all fcat
779: where
780: awd.fund_id = fmast.fund_id

Line 921: p_base_id IN igf_aw_award_all.base_id%TYPE,

917:
918: END recalc_fees;
919:
920: PROCEDURE pick_setup(
921: p_base_id IN igf_aw_award_all.base_id%TYPE,
922: p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
923: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
924: p_rel_code OUT NOCOPY igf_sl_cl_setup.relationship_cd%TYPE,
925: p_person_id OUT NOCOPY igf_sl_cl_pref_lenders.person_id%TYPE,

Line 947: cp_base_id igf_aw_award_all.base_id%TYPE

943: based on teh preferred lender setup
944: (reverse chronological order - newest change first)
945: ***************************************************************/
946: CURSOR c_get_details (
947: cp_base_id igf_aw_award_all.base_id%TYPE
948: )
949: IS
950: SELECT person_id
951: FROM igf_ap_fa_base_rec_all

Line 1220: FUNCTION chk_chg_enable (p_n_award_id igf_aw_award_all.award_id%TYPE)

1216: app_exception.raise_exception;
1217:
1218: END pick_setup;
1219:
1220: FUNCTION chk_chg_enable (p_n_award_id igf_aw_award_all.award_id%TYPE)
1221: RETURN BOOLEAN AS
1222: ------------------------------------------------------------------
1223: --Created by : Sanil Madathil, Oracle IDC
1224: --Date created: 14 October 2004

Line 1238: CURSOR c_chk_chg_enable (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS

1234: --
1235: --Change History:
1236: --Who When What
1237: ------------------------------------------------------------------
1238: CURSOR c_chk_chg_enable (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS
1239: SELECT loans.loan_number
1240: FROM igf_sl_lor_all lor
1241: ,igf_sl_loans_all loans
1242: ,igf_aw_award_all awd

Line 1242: ,igf_aw_award_all awd

1238: CURSOR c_chk_chg_enable (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS
1239: SELECT loans.loan_number
1240: FROM igf_sl_lor_all lor
1241: ,igf_sl_loans_all loans
1242: ,igf_aw_award_all awd
1243: ,igf_aw_fund_mast_all fmast
1244: ,igf_sl_cl_setup_all clset
1245: WHERE loans.loan_id = lor.loan_id
1246: AND loans.award_id = cp_n_award_id

Line 1280: FUNCTION chk_add_new_disb (p_n_award_id igf_aw_award_all.award_id%TYPE)

1276: app_exception.raise_exception;
1277: END chk_chg_enable;
1278:
1279:
1280: FUNCTION chk_add_new_disb (p_n_award_id igf_aw_award_all.award_id%TYPE)
1281: RETURN BOOLEAN AS
1282: ------------------------------------------------------------------
1283: --Created by : Sanil Madathil, Oracle IDC
1284: --Date created: 14 October 2004

Line 1298: CURSOR c_igf_sl_loans (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS

1294: --
1295: --Change History:
1296: --Who When What
1297: ------------------------------------------------------------------
1298: CURSOR c_igf_sl_loans (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS
1299: SELECT 'X'
1300: FROM igf_sl_loans_all lar
1301: WHERE lar.award_id = cp_n_award_id;
1302:

Line 1305: CURSOR c_igf_aw_awd_disb (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS

1301: WHERE lar.award_id = cp_n_award_id;
1302:
1303: rec_c_igf_sl_loans c_igf_sl_loans%ROWTYPE;
1304:
1305: CURSOR c_igf_aw_awd_disb (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS
1306: SELECT adisb.disb_num
1307: FROM igf_aw_awd_disb_all adisb
1308: WHERE adisb.award_id=cp_n_award_id
1309: AND NVL(adisb.fund_status,'N') = 'N';

Line 1312: l_n_award_id igf_aw_award_all.award_id%TYPE;

1308: WHERE adisb.award_id=cp_n_award_id
1309: AND NVL(adisb.fund_status,'N') = 'N';
1310:
1311: l_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
1312: l_n_award_id igf_aw_award_all.award_id%TYPE;
1313: l_return_val BOOLEAN;
1314: BEGIN
1315: l_n_award_id := p_n_award_id;
1316: OPEN c_igf_sl_loans(cp_n_award_id => l_n_award_id);

Line 1354: FUNCTION chk_loan_increase (p_n_award_id igf_aw_award_all.award_id%TYPE)

1350: app_exception.raise_exception;
1351: END chk_add_new_disb;
1352:
1353:
1354: FUNCTION chk_loan_increase (p_n_award_id igf_aw_award_all.award_id%TYPE)
1355: RETURN BOOLEAN AS
1356: ------------------------------------------------------------------
1357: --Created by : Sanil Madathil, Oracle IDC
1358: --Date created: 14 October 2004

Line 1372: CURSOR c_igf_sl_loans (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS

1368: --
1369: --Change History:
1370: --Who When What
1371: ------------------------------------------------------------------
1372: CURSOR c_igf_sl_loans (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS
1373: SELECT 'X'
1374: FROM igf_sl_loans_all lar
1375: WHERE lar.award_id = cp_n_award_id;
1376:

Line 1379: CURSOR c_igf_aw_awd_disb (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS

1375: WHERE lar.award_id = cp_n_award_id;
1376:
1377: rec_c_igf_sl_loans c_igf_sl_loans%ROWTYPE;
1378:
1379: CURSOR c_igf_aw_awd_disb (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS
1380: SELECT adisb.disb_num
1381: FROM igf_aw_awd_disb_all adisb
1382: WHERE adisb.award_id=cp_n_award_id
1383: AND NVL(adisb.fund_status,'N') = 'N';

Line 1385: CURSOR c_chk_chg_enable (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS

1381: FROM igf_aw_awd_disb_all adisb
1382: WHERE adisb.award_id=cp_n_award_id
1383: AND NVL(adisb.fund_status,'N') = 'N';
1384:
1385: CURSOR c_chk_chg_enable (cp_n_award_id igf_aw_award_all.award_id%TYPE) IS
1386: SELECT loans.loan_number loan_number
1387: ,clset.cl_version cl_version
1388: ,loans.loan_status loan_status
1389: FROM igf_sl_lor_all lor

Line 1391: ,igf_aw_award_all awd

1387: ,clset.cl_version cl_version
1388: ,loans.loan_status loan_status
1389: FROM igf_sl_lor_all lor
1390: ,igf_sl_loans_all loans
1391: ,igf_aw_award_all awd
1392: ,igf_aw_fund_mast_all fmast
1393: ,igf_sl_cl_setup_all clset
1394: WHERE loans.loan_id = lor.loan_id
1395: AND loans.award_id = cp_n_award_id

Line 1409: l_n_award_id igf_aw_award_all.award_id%TYPE;

1405: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
1406: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
1407: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;
1408: l_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
1409: l_n_award_id igf_aw_award_all.award_id%TYPE;
1410:
1411: BEGIN
1412: l_n_award_id := p_n_award_id;
1413: OPEN c_igf_sl_loans(cp_n_award_id => l_n_award_id);

Line 1458: FUNCTION get_loan_cl_version (p_n_award_id igf_aw_award_all.award_id%TYPE)

1454: igs_ge_msg_stack.add;
1455: app_exception.raise_exception;
1456: END chk_loan_increase;
1457:
1458: FUNCTION get_loan_cl_version (p_n_award_id igf_aw_award_all.award_id%TYPE)
1459: RETURN igf_sl_cl_setup_all.cl_version%TYPE AS
1460: ------------------------------------------------------------------
1461: --Created by : Sanil Madathil, Oracle IDC
1462: --Date created: 14 October 2004

Line 1484: CURSOR c_get_loan_details(cp_n_award_id igf_aw_award_all.award_id%TYPE)

1480: -- FFELP Setup override.
1481: ------------------------------------------------------------------
1482:
1483: /* Cursor Variable */
1484: CURSOR c_get_loan_details(cp_n_award_id igf_aw_award_all.award_id%TYPE)
1485: IS
1486: SELECT
1487: awd.award_id,
1488: awd.base_id,

Line 1495: igf_aw_award_all awd,

1491: lor.relationship_cd
1492: FROM
1493: igf_sl_lor_all lor,
1494: igf_sl_loans_all loans,
1495: igf_aw_award_all awd,
1496: igf_aw_fund_mast_all fmast
1497: WHERE
1498: loans.loan_id = lor.loan_id AND
1499: awd.award_id = loans.award_id AND

Line 1505: l_n_award_id igf_aw_award_all.award_id%TYPE;

1501: awd.award_id = cp_n_award_id;
1502:
1503: /* Local Variables */
1504: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
1505: l_n_award_id igf_aw_award_all.award_id%TYPE;
1506: l_n_base_id igf_aw_award_all.base_id%TYPE;
1507: l_v_ci_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE;
1508: l_n_ci_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE;
1509: l_v_relationship_cd igf_sl_lor_all.relationship_cd%TYPE;

Line 1506: l_n_base_id igf_aw_award_all.base_id%TYPE;

1502:
1503: /* Local Variables */
1504: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
1505: l_n_award_id igf_aw_award_all.award_id%TYPE;
1506: l_n_base_id igf_aw_award_all.base_id%TYPE;
1507: l_v_ci_cal_type igf_aw_fund_mast_all.ci_cal_type%TYPE;
1508: l_n_ci_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE;
1509: l_v_relationship_cd igf_sl_lor_all.relationship_cd%TYPE;
1510:

Line 1536: FUNCTION chk_fund_st_chg ( p_n_award_id IN igf_aw_award_all.award_id%TYPE,

1532: igs_ge_msg_stack.add;
1533: app_exception.raise_exception;
1534: END get_loan_cl_version;
1535:
1536: FUNCTION chk_fund_st_chg ( p_n_award_id IN igf_aw_award_all.award_id%TYPE,
1537: p_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE
1538: )
1539: RETURN BOOLEAN AS
1540: ------------------------------------------------------------------

Line 1556: CURSOR c_chk_fund_st_chg_1 (cp_n_award_id IN igf_aw_award_all.award_id%TYPE,

1552: --
1553: --Change History:
1554: --Who When What
1555: ------------------------------------------------------------------
1556: CURSOR c_chk_fund_st_chg_1 (cp_n_award_id IN igf_aw_award_all.award_id%TYPE,
1557: cp_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE) IS
1558: SELECT dbresp.disb_num
1559: FROM igf_db_cl_disb_resp dbresp
1560: ,igf_sl_loans_all loans

Line 1561: ,igf_aw_award_all awd

1557: cp_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE) IS
1558: SELECT dbresp.disb_num
1559: FROM igf_db_cl_disb_resp dbresp
1560: ,igf_sl_loans_all loans
1561: ,igf_aw_award_all awd
1562: WHERE dbresp.disb_num = cp_n_disb_num
1563: AND loans.loan_number = dbresp.loan_number
1564: AND awd.award_id = loans.award_id
1565: AND awd.award_id = cp_n_award_id

Line 1568: CURSOR c_chk_fund_st_chg_2 (cp_n_award_id IN igf_aw_award_all.award_id%TYPE,

1564: AND awd.award_id = loans.award_id
1565: AND awd.award_id = cp_n_award_id
1566: ORDER BY cdbr_id DESC;
1567:
1568: CURSOR c_chk_fund_st_chg_2 (cp_n_award_id IN igf_aw_award_all.award_id%TYPE,
1569: cp_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE) IS
1570: SELECT chg.disbursement_number
1571: FROM igf_sl_clchsn_dtls chg
1572: ,igf_sl_loans_all loans

Line 1573: ,igf_aw_award_all awd

1569: cp_n_disb_num IN igf_aw_awd_disb_all.disb_num%TYPE) IS
1570: SELECT chg.disbursement_number
1571: FROM igf_sl_clchsn_dtls chg
1572: ,igf_sl_loans_all loans
1573: ,igf_aw_award_all awd
1574: WHERE chg.disbursement_number = cp_n_disb_num
1575: AND chg.change_record_type_txt = '10'
1576: AND chg.status_code <> ('D')
1577: AND chg.loan_number_txt = loans.loan_number