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_GEN dependencies on IGF_SL_LOANS

Line 685: FUNCTION get_disb_date(p_loan_id IN igf_sl_loans.loan_id%TYPE,

681:
682: END get_cl_batch_details;
683:
684: -- Function to return the Disbursement Date
685: FUNCTION get_disb_date(p_loan_id IN igf_sl_loans.loan_id%TYPE,
686: p_disb_num IN igf_aw_awd_disb.disb_num%TYPE)
687: RETURN DATE
688: AS
689: /*************************************************************

Line 702: FROM igf_sl_loans isl, igf_aw_awd_disb iaad

698: ***************************************************************/
699: /* Declared the CURSOR to select the disbursement date for the particular loan ID and Disbursement Number */
700: CURSOR c_disb_date IS
701: SELECT iaad.disb_date
702: FROM igf_sl_loans isl, igf_aw_awd_disb iaad
703: WHERE isl.loan_id = p_loan_id
704: AND iaad.disb_num = p_disb_num
705: AND isl.award_id = iaad.award_id;
706:

Line 1695: ,igf_sl_loans_all loans

1691: cp_n_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE
1692: ) IS
1693: SELECT loans.loan_number
1694: FROM igf_sl_lor_all lor
1695: ,igf_sl_loans_all loans
1696: ,igf_aw_award_all awd
1697: ,igf_aw_fund_mast_all fmast
1698: WHERE lor.relationship_cd = cp_v_relationship_cd
1699: AND loans.loan_id = lor.loan_id

Line 1706: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;

1702: AND fmast.fund_id = awd.fund_id
1703: AND fmast.ci_cal_type = cp_v_cal_type
1704: AND fmast.ci_sequence_number = cp_n_sequence_number;
1705:
1706: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
1707: BEGIN
1708:
1709: OPEN c_loan_num ( cp_v_relationship_cd => p_v_relationship_cd,
1710: cp_v_cal_type => p_v_cal_type,

Line 1762: ,igf_sl_loans_all loans

1758: cp_n_sequence_number igf_aw_fund_mast_all.ci_sequence_number%TYPE
1759: ) IS
1760: SELECT loans.loan_number
1761: FROM igf_sl_lor_all lor
1762: ,igf_sl_loans_all loans
1763: ,igf_aw_award_all awd
1764: ,igf_aw_fund_mast_all fmast
1765: WHERE lor.relationship_cd = cp_v_relationship_cd
1766: AND loans.loan_id = lor.loan_id

Line 1772: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;

1768: AND fmast.fund_id = awd.fund_id
1769: AND fmast.ci_cal_type = cp_v_cal_type
1770: AND fmast.ci_sequence_number = cp_n_sequence_number;
1771:
1772: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
1773:
1774: BEGIN
1775: OPEN c_loan_num ( cp_v_relationship_cd => p_v_relationship_cd,
1776: cp_v_cal_type => p_v_cal_type,

Line 1799: PROCEDURE update_cl_chg_status(p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE) IS

1795: igs_ge_msg_stack.add;
1796: app_exception.raise_exception;
1797: END check_prc_chgm;
1798:
1799: PROCEDURE update_cl_chg_status(p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE) IS
1800: ------------------------------------------------------------------
1801: --Created by : svuppala, Oracle IDC
1802: --Date created: 20-Oct-2004
1803: --

Line 1816: --l_loan_chg_status igf_sl_loans_all.loan_chg_status%TYPE;

1812: --Change History:
1813: --Who When What
1814: ------------------------------------------------------------------
1815:
1816: --l_loan_chg_status igf_sl_loans_all.loan_chg_status%TYPE;
1817: -- ROWID row_id
1818:
1819: CURSOR c_sl_loans (cp_loan_number_txt igf_sl_loans_all.loan_number%TYPE) IS
1820: SELECT igfsla.* ,igfsla.ROWID ROW_ID

Line 1819: CURSOR c_sl_loans (cp_loan_number_txt igf_sl_loans_all.loan_number%TYPE) IS

1815:
1816: --l_loan_chg_status igf_sl_loans_all.loan_chg_status%TYPE;
1817: -- ROWID row_id
1818:
1819: CURSOR c_sl_loans (cp_loan_number_txt igf_sl_loans_all.loan_number%TYPE) IS
1820: SELECT igfsla.* ,igfsla.ROWID ROW_ID
1821: FROM igf_sl_loans_all igfsla
1822: WHERE loan_number = cp_loan_number_txt;
1823:

Line 1821: FROM igf_sl_loans_all igfsla

1817: -- ROWID row_id
1818:
1819: CURSOR c_sl_loans (cp_loan_number_txt igf_sl_loans_all.loan_number%TYPE) IS
1820: SELECT igfsla.* ,igfsla.ROWID ROW_ID
1821: FROM igf_sl_loans_all igfsla
1822: WHERE loan_number = cp_loan_number_txt;
1823:
1824: rec_c_sl_loans c_sl_loans%ROWTYPE;
1825:

Line 1826: CURSOR c_clchsn (cp_loan_number_txt igf_sl_loans_all.loan_number%TYPE) IS

1822: WHERE loan_number = cp_loan_number_txt;
1823:
1824: rec_c_sl_loans c_sl_loans%ROWTYPE;
1825:
1826: CURSOR c_clchsn (cp_loan_number_txt igf_sl_loans_all.loan_number%TYPE) IS
1827: SELECT 'x'
1828: FROM igf_sl_clchsn_dtls
1829: WHERE loan_number_txt = cp_loan_number_txt
1830: AND status_code = 'S';

Line 1834: CURSOR c_clchsn2 (cp_loan_number_txt igf_sl_loans_all.loan_number%TYPE) IS

1830: AND status_code = 'S';
1831:
1832: rec_c_clchsn c_clchsn%ROWTYPE;
1833:
1834: CURSOR c_clchsn2 (cp_loan_number_txt igf_sl_loans_all.loan_number%TYPE) IS
1835: SELECT 'x'
1836: FROM igf_sl_clchsn_dtls
1837: WHERE loan_number_txt = cp_loan_number_txt
1838: AND status_code = 'A'

Line 1844: CURSOR c_clchsn3 (cp_loan_number_txt igf_sl_loans_all.loan_number%TYPE) IS

1840:
1841: rec_c_clchsn2 c_clchsn2%ROWTYPE;
1842:
1843:
1844: CURSOR c_clchsn3 (cp_loan_number_txt igf_sl_loans_all.loan_number%TYPE) IS
1845: SELECT 'x'
1846: FROM igf_sl_clchsn_dtls
1847: WHERE loan_number_txt = cp_loan_number_txt
1848: AND status_code = 'A'

Line 1853: CURSOR c_get_clchsn_accept (cp_loan_number_txt igf_sl_loans_all.loan_number%TYPE) IS

1849: AND (response_status_code = 'F' OR response_status_code = 'P') ;
1850:
1851: rec_c_clchsn3 c_clchsn2%ROWTYPE;
1852:
1853: CURSOR c_get_clchsn_accept (cp_loan_number_txt igf_sl_loans_all.loan_number%TYPE) IS
1854: SELECT 'x'
1855: FROM igf_sl_clchsn_dtls
1856: WHERE loan_number_txt = cp_loan_number_txt
1857: AND status_code = 'A'

Line 1862: CURSOR c_clchsn4 (cp_loan_number_txt igf_sl_loans_all.loan_number%TYPE) IS

1858: AND response_status_code = 'A';
1859:
1860: rec_c_get_clchsn_accept c_get_clchsn_accept%ROWTYPE;
1861:
1862: CURSOR c_clchsn4 (cp_loan_number_txt igf_sl_loans_all.loan_number%TYPE) IS
1863: SELECT 'x'
1864: FROM igf_sl_clchsn_dtls
1865: WHERE loan_number_txt = cp_loan_number_txt
1866: AND status_code = 'R';

Line 1937: igf_sl_loans_pkg.update_row(

1933: OPEN c_sl_loans(p_v_loan_number);
1934: FETCH c_sl_loans INTO rec_c_sl_loans;
1935: CLOSE c_sl_loans;
1936:
1937: igf_sl_loans_pkg.update_row(
1938: x_rowid => rec_c_sl_loans.row_id,
1939: x_loan_id => rec_c_sl_loans.loan_id,
1940: x_award_id => rec_c_sl_loans.award_id,
1941: x_seq_num => rec_c_sl_loans.seq_num,