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_SL_LOANS

Line 84: cp_award_id igf_sl_loans.award_id%TYPE

80: WHERE ci_cal_type = p_ci_cal_type
81: AND ci_sequence_number = p_ci_seq_num;
82:
83: CURSOR c_get_fed_fund_code (
84: cp_award_id igf_sl_loans.award_id%TYPE
85: )
86: IS
87: SELECT fed_fund_code
88: FROM igf_aw_award awd,

Line 481: FUNCTION chk_disb_date(p_award_id igf_sl_loans.award_id%TYPE,

477: app_exception.raise_exception;
478: END get_loan_fee2;
479:
480:
481: FUNCTION chk_disb_date(p_award_id igf_sl_loans.award_id%TYPE,
482: p_loan_per_begin_date igf_sl_loans_all.loan_per_begin_date%TYPE,
483: p_loan_per_end_date igf_sl_loans_all.loan_per_end_date%TYPE
484: )
485: RETURN VARCHAR2 AS

Line 482: p_loan_per_begin_date igf_sl_loans_all.loan_per_begin_date%TYPE,

478: END get_loan_fee2;
479:
480:
481: FUNCTION chk_disb_date(p_award_id igf_sl_loans.award_id%TYPE,
482: p_loan_per_begin_date igf_sl_loans_all.loan_per_begin_date%TYPE,
483: p_loan_per_end_date igf_sl_loans_all.loan_per_end_date%TYPE
484: )
485: RETURN VARCHAR2 AS
486: /* -------------------------------------------------------------

Line 483: p_loan_per_end_date igf_sl_loans_all.loan_per_end_date%TYPE

479:
480:
481: FUNCTION chk_disb_date(p_award_id igf_sl_loans.award_id%TYPE,
482: p_loan_per_begin_date igf_sl_loans_all.loan_per_begin_date%TYPE,
483: p_loan_per_end_date igf_sl_loans_all.loan_per_end_date%TYPE
484: )
485: RETURN VARCHAR2 AS
486: /* -------------------------------------------------------------
487: || Created By :

Line 498: cp_loan_per_begin_date igf_sl_loans_all.loan_per_begin_date%TYPE,

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
502: ,disb.disb_num

Line 499: cp_loan_per_end_date igf_sl_loans_all.loan_per_end_date%TYPE) IS

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
502: ,disb.disb_num
503: FROM igf_aw_awd_disb_all disb

Line 504: ,igf_sl_loans_all loans

500: SELECT disb.award_id
501: ,disb.disb_date
502: ,disb.disb_num
503: FROM igf_aw_awd_disb_all disb
504: ,igf_sl_loans_all loans
505: WHERE loans.award_id=disb.award_id
506: AND loans.award_id = cp_n_award_id
507: AND ( disb.disb_date < NVL(cp_loan_per_begin_date, loans.loan_per_begin_date)
508: OR disb.disb_date > NVL(cp_loan_per_end_date, loans.loan_per_end_date));

Line 568: FUNCTION chk_loan_upd_lock(p_award_id igf_sl_loans.award_id%TYPE)

564: app_exception.raise_exception;
565:
566: END get_alt_rel_code;
567:
568: FUNCTION chk_loan_upd_lock(p_award_id igf_sl_loans.award_id%TYPE)
569: RETURN VARCHAR2
570: AS
571: /* -------------------------------------------------------------
572: || Created By :

Line 581: l_loan_id igf_sl_loans.loan_id%TYPE;

577: || Who When What
578: || (reverse chronological order - newest change first)
579: || smadathi 14-OCT-2004 Bug 3416936.Changes as per TD
580: ------------------------------------------------------------------*/
581: l_loan_id igf_sl_loans.loan_id%TYPE;
582: l_loan_status igf_sl_loans.loan_status%TYPE;
583: l_loan_chg_status igf_sl_loans.loan_chg_status%TYPE;
584:
585: l_get_fed_fund_code c_get_fed_fund_code%ROWTYPE;

Line 582: l_loan_status igf_sl_loans.loan_status%TYPE;

578: || (reverse chronological order - newest change first)
579: || smadathi 14-OCT-2004 Bug 3416936.Changes as per TD
580: ------------------------------------------------------------------*/
581: l_loan_id igf_sl_loans.loan_id%TYPE;
582: l_loan_status igf_sl_loans.loan_status%TYPE;
583: l_loan_chg_status igf_sl_loans.loan_chg_status%TYPE;
584:
585: l_get_fed_fund_code c_get_fed_fund_code%ROWTYPE;
586:

Line 583: l_loan_chg_status igf_sl_loans.loan_chg_status%TYPE;

579: || smadathi 14-OCT-2004 Bug 3416936.Changes as per TD
580: ------------------------------------------------------------------*/
581: l_loan_id igf_sl_loans.loan_id%TYPE;
582: l_loan_status igf_sl_loans.loan_status%TYPE;
583: l_loan_chg_status igf_sl_loans.loan_chg_status%TYPE;
584:
585: l_get_fed_fund_code c_get_fed_fund_code%ROWTYPE;
586:
587: CURSOR c_loans (p_award_id NUMBER)IS

Line 591: FROM igf_sl_loans

587: CURSOR c_loans (p_award_id NUMBER)IS
588: SELECT loan_id
589: ,loan_status
590: ,loan_chg_status
591: FROM igf_sl_loans
592: WHERE award_id = p_award_id;
593:
594: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
595:

Line 729: p_award_id IN igf_sl_loans.award_id%TYPE

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
730: )
731: IS
732: /*************************************************************
733: Created By : bkkumar

Line 765: CURSOR cur_get_adisb (cp_award_id igf_sl_loans.award_id%TYPE)

761: l_rel_code igf_sl_cl_setup.relationship_cd%TYPE;
762: l_party_id igf_sl_cl_setup.party_id%TYPE;
763: l_person_id igf_sl_cl_pref_lenders.person_id%TYPE;
764:
765: CURSOR cur_get_adisb (cp_award_id igf_sl_loans.award_id%TYPE)
766: IS
767: SELECT *
768: FROM igf_aw_awd_disb adisb
769: WHERE adisb.award_id = p_award_id;

Line 1241: ,igf_sl_loans_all loans

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
1243: ,igf_aw_fund_mast_all fmast
1244: ,igf_sl_cl_setup_all clset
1245: WHERE loans.loan_id = lor.loan_id

Line 1258: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;

1254: AND fmast.ci_sequence_number = clset.ci_sequence_number
1255: AND lor.relationship_cd = clset.relationship_cd
1256: AND clset.cl_version = 'RELEASE-4';
1257:
1258: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
1259: BEGIN
1260: OPEN c_chk_chg_enable (cp_n_award_id => p_n_award_id);
1261: FETCH c_chk_chg_enable INTO l_v_loan_number;
1262: IF c_chk_chg_enable%NOTFOUND THEN

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 1300: FROM igf_sl_loans_all lar

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:
1303: rec_c_igf_sl_loans c_igf_sl_loans%ROWTYPE;
1304:

Line 1303: rec_c_igf_sl_loans c_igf_sl_loans%ROWTYPE;

1299: SELECT 'X'
1300: FROM igf_sl_loans_all lar
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

Line 1316: OPEN c_igf_sl_loans(cp_n_award_id => l_n_award_id);

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);
1317: FETCH c_igf_sl_loans INTO rec_c_igf_sl_loans;
1318: -- check if loan record is created or not
1319: IF c_igf_sl_loans%NOTFOUND THEN
1320: CLOSE c_igf_sl_loans;

Line 1317: FETCH c_igf_sl_loans INTO rec_c_igf_sl_loans;

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);
1317: FETCH c_igf_sl_loans INTO rec_c_igf_sl_loans;
1318: -- check if loan record is created or not
1319: IF c_igf_sl_loans%NOTFOUND THEN
1320: CLOSE c_igf_sl_loans;
1321: RETURN TRUE;

Line 1319: IF c_igf_sl_loans%NOTFOUND THEN

1315: l_n_award_id := p_n_award_id;
1316: OPEN c_igf_sl_loans(cp_n_award_id => l_n_award_id);
1317: FETCH c_igf_sl_loans INTO rec_c_igf_sl_loans;
1318: -- check if loan record is created or not
1319: IF c_igf_sl_loans%NOTFOUND THEN
1320: CLOSE c_igf_sl_loans;
1321: RETURN TRUE;
1322: END IF;
1323: CLOSE c_igf_sl_loans;

Line 1320: CLOSE c_igf_sl_loans;

1316: OPEN c_igf_sl_loans(cp_n_award_id => l_n_award_id);
1317: FETCH c_igf_sl_loans INTO rec_c_igf_sl_loans;
1318: -- check if loan record is created or not
1319: IF c_igf_sl_loans%NOTFOUND THEN
1320: CLOSE c_igf_sl_loans;
1321: RETURN TRUE;
1322: END IF;
1323: CLOSE c_igf_sl_loans;
1324: --if loan records exists, check if new disbursement can be added or not

Line 1323: CLOSE c_igf_sl_loans;

1319: IF c_igf_sl_loans%NOTFOUND THEN
1320: CLOSE c_igf_sl_loans;
1321: RETURN TRUE;
1322: END IF;
1323: CLOSE c_igf_sl_loans;
1324: --if loan records exists, check if new disbursement can be added or not
1325: OPEN c_igf_aw_awd_disb(cp_n_award_id => l_n_award_id);
1326: FETCH c_igf_aw_awd_disb INTO l_disb_num;
1327: CLOSE c_igf_aw_awd_disb ;

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 1374: FROM igf_sl_loans_all lar

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:
1377: rec_c_igf_sl_loans c_igf_sl_loans%ROWTYPE;
1378:

Line 1377: rec_c_igf_sl_loans c_igf_sl_loans%ROWTYPE;

1373: SELECT 'X'
1374: FROM igf_sl_loans_all lar
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

Line 1390: ,igf_sl_loans_all loans

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

Line 1405: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;

1401: AND fmast.ci_cal_type = clset.ci_cal_type
1402: AND fmast.ci_sequence_number = clset.ci_sequence_number
1403: AND lor.relationship_cd = clset.relationship_cd ;
1404:
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;

Line 1407: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;

1403: AND lor.relationship_cd = clset.relationship_cd ;
1404:
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

Line 1413: OPEN c_igf_sl_loans(cp_n_award_id => l_n_award_id);

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);
1414: FETCH c_igf_sl_loans INTO rec_c_igf_sl_loans;
1415: -- check if loan record is created or not
1416: IF c_igf_sl_loans%NOTFOUND THEN
1417: CLOSE c_igf_sl_loans;

Line 1414: FETCH c_igf_sl_loans INTO rec_c_igf_sl_loans;

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);
1414: FETCH c_igf_sl_loans INTO rec_c_igf_sl_loans;
1415: -- check if loan record is created or not
1416: IF c_igf_sl_loans%NOTFOUND THEN
1417: CLOSE c_igf_sl_loans;
1418: RETURN TRUE;

Line 1416: IF c_igf_sl_loans%NOTFOUND THEN

1412: l_n_award_id := p_n_award_id;
1413: OPEN c_igf_sl_loans(cp_n_award_id => l_n_award_id);
1414: FETCH c_igf_sl_loans INTO rec_c_igf_sl_loans;
1415: -- check if loan record is created or not
1416: IF c_igf_sl_loans%NOTFOUND THEN
1417: CLOSE c_igf_sl_loans;
1418: RETURN TRUE;
1419: END IF;
1420: CLOSE c_igf_sl_loans;

Line 1417: CLOSE c_igf_sl_loans;

1413: OPEN c_igf_sl_loans(cp_n_award_id => l_n_award_id);
1414: FETCH c_igf_sl_loans INTO rec_c_igf_sl_loans;
1415: -- check if loan record is created or not
1416: IF c_igf_sl_loans%NOTFOUND THEN
1417: CLOSE c_igf_sl_loans;
1418: RETURN TRUE;
1419: END IF;
1420: CLOSE c_igf_sl_loans;
1421: --if loan records exists, check if new disbursement can be added or not

Line 1420: CLOSE c_igf_sl_loans;

1416: IF c_igf_sl_loans%NOTFOUND THEN
1417: CLOSE c_igf_sl_loans;
1418: RETURN TRUE;
1419: END IF;
1420: CLOSE c_igf_sl_loans;
1421: --if loan records exists, check if new disbursement can be added or not
1422: OPEN c_igf_aw_awd_disb(cp_n_award_id => l_n_award_id);
1423: FETCH c_igf_aw_awd_disb INTO l_disb_num;
1424: CLOSE c_igf_aw_awd_disb ;

Line 1494: igf_sl_loans_all loans,

1490: fmast.ci_sequence_number,
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

Line 1560: ,igf_sl_loans_all loans

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

Line 1572: ,igf_sl_loans_all loans

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
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')