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_CL_CREATE_CHG dependencies on IGF_SL_LOANS_ALL

Line 28: PROCEDURE create_loan_chg_rec(p_new_loan_rec IN igf_sl_loans_all%ROWTYPE,

24: );
25: -- function to return the change send details
26: FUNCTION get_sl_clchsn_dtls ( p_rowid ROWID) RETURN igf_sl_clchsn_dtls%ROWTYPE;
27:
28: PROCEDURE create_loan_chg_rec(p_new_loan_rec IN igf_sl_loans_all%ROWTYPE,
29: p_b_return_status OUT NOCOPY BOOLEAN,
30: p_v_message_name OUT NOCOPY VARCHAR2
31: ) AS
32: ------------------------------------------------------------------

Line 51: CURSOR c_igf_sl_lor (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS

47: --Change History:
48: --Who When What
49: ------------------------------------------------------------------
50:
51: CURSOR c_igf_sl_lor (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS
52: SELECT lor.prc_type_code
53: ,lor.cl_rec_status
54: FROM igf_sl_lor_all lor
55: WHERE loan_id = cp_n_loan_id;

Line 59: CURSOR c_igf_sl_cl_resp_r1(cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS

55: WHERE loan_id = cp_n_loan_id;
56:
57: rec_c_igf_sl_lor c_igf_sl_lor%ROWTYPE;
58:
59: CURSOR c_igf_sl_cl_resp_r1(cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS
60: SELECT resp.loan_per_begin_date
61: ,resp.loan_per_end_date
62: FROM igf_sl_cl_resp_r1_all resp
63: WHERE resp.loan_number = cp_v_loan_number

Line 81: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;

77: l_d_loan_per_end_date igf_sl_cl_resp_r1_all.loan_per_end_date%TYPE;
78: l_d_res_loan_per_begin_dt igf_sl_cl_resp_r1_all.loan_per_begin_date%TYPE;
79: l_d_res_loan_per_end_dt igf_sl_cl_resp_r1_all.loan_per_end_date%TYPE;
80: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
81: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;
82: l_n_clchgsnd_id igf_sl_clchsn_dtls.clchgsnd_id%TYPE;
83: l_n_award_id igf_aw_award_all.award_id%TYPE;
84: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
85: l_n_loan_id igf_sl_loans_all.loan_id%TYPE;

Line 84: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;

80: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
81: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;
82: l_n_clchgsnd_id igf_sl_clchsn_dtls.clchgsnd_id%TYPE;
83: l_n_award_id igf_aw_award_all.award_id%TYPE;
84: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
85: l_n_loan_id igf_sl_loans_all.loan_id%TYPE;
86: l_c_cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE;
87: l_v_prc_type_code igf_sl_lor_all.prc_type_code%TYPE;
88: l_v_sqlstmt VARCHAR2(32767);

Line 85: l_n_loan_id igf_sl_loans_all.loan_id%TYPE;

81: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;
82: l_n_clchgsnd_id igf_sl_clchsn_dtls.clchgsnd_id%TYPE;
83: l_n_award_id igf_aw_award_all.award_id%TYPE;
84: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
85: l_n_loan_id igf_sl_loans_all.loan_id%TYPE;
86: l_c_cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE;
87: l_v_prc_type_code igf_sl_lor_all.prc_type_code%TYPE;
88: l_v_sqlstmt VARCHAR2(32767);
89: l_v_rowid ROWID;

Line 758: CURSOR c_igf_sl_loans (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS

754: --Change History:
755: --Who When What
756: ------------------------------------------------------------------
757:
758: CURSOR c_igf_sl_loans (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS
759: SELECT lar.loan_number
760: ,lar.loan_status
761: ,lar.award_id
762: FROM igf_sl_loans_all lar

Line 762: FROM igf_sl_loans_all lar

758: CURSOR c_igf_sl_loans (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS
759: SELECT lar.loan_number
760: ,lar.loan_status
761: ,lar.award_id
762: FROM igf_sl_loans_all lar
763: WHERE loan_id = cp_n_loan_id;
764:
765: rec_c_igf_sl_loans c_igf_sl_loans%ROWTYPE;
766:

Line 767: CURSOR c_igf_sl_cl_resp_r1(cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS

763: WHERE loan_id = cp_n_loan_id;
764:
765: rec_c_igf_sl_loans c_igf_sl_loans%ROWTYPE;
766:
767: CURSOR c_igf_sl_cl_resp_r1(cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS
768: SELECT resp.anticip_compl_date
769: ,resp.grade_level_code
770: FROM igf_sl_cl_resp_r1_all resp
771: WHERE resp.loan_number = cp_v_loan_number

Line 787: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;

783: l_d_lor_anticip_compl_dt igf_sl_lor_all.anticip_compl_date%TYPE;
784: l_v_resp_grade_level_cd igf_sl_lor_all.override_grade_level_code%TYPE;
785: l_v_ovr_grade_level_cd igf_sl_lor_all.override_grade_level_code%TYPE;
786: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
787: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;
788: l_n_clchgsnd_id igf_sl_clchsn_dtls.clchgsnd_id%TYPE;
789: l_v_sqlstmt VARCHAR2(32767);
790: l_v_rowid ROWID;
791: l_v_message_name fnd_new_messages.message_name%TYPE;

Line 796: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;

792: l_b_return_status BOOLEAN;
793: l_c_cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE;
794: l_v_prc_type_code igf_sl_lor_all.prc_type_code%TYPE;
795: l_n_award_id igf_aw_award_all.award_id%TYPE;
796: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
797:
798: e_valid_edits EXCEPTION;
799: e_resource_busy EXCEPTION;
800: l_d_message_tokens igf_sl_cl_chg_prc.token_tab%TYPE;

Line 1469: ,igf_sl_loans_all lar

1465: ,lar.loan_status
1466: ,lor.prc_type_code
1467: ,lor.cl_rec_status
1468: FROM igf_sl_lor_all lor
1469: ,igf_sl_loans_all lar
1470: WHERE lor.loan_id = lar.loan_id
1471: AND lar.award_id = cp_n_award_id;
1472:
1473: rec_c_igf_sl_lorlar c_igf_sl_lorlar%ROWTYPE;

Line 1481: CURSOR c_igf_sl_cl_resp_r1(cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS

1477: FROM igf_aw_awd_disb_all adisb
1478: WHERE adisb.award_id = cp_n_award_id
1479: AND NVL(adisb.fund_status,'N') = 'Y';
1480:
1481: CURSOR c_igf_sl_cl_resp_r1(cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS
1482: SELECT resp.guarantee_amt
1483: FROM igf_sl_cl_resp_r1_all resp
1484: WHERE resp.loan_number = cp_v_loan_number
1485: AND resp.cl_rec_status IN ('B','G')

Line 1497: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;

1493:
1494: rec_c_igf_sl_clchsn_dtls igf_sl_clchsn_dtls%ROWTYPE;
1495:
1496: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
1497: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;
1498: l_n_clchgsnd_id igf_sl_clchsn_dtls.clchgsnd_id%TYPE;
1499: l_v_sqlstmt VARCHAR2(32767);
1500: l_v_rowid ROWID;
1501: l_v_message_name fnd_new_messages.message_name%TYPE;

Line 1506: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;

1502: l_b_return_status BOOLEAN;
1503: l_c_cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE;
1504: l_v_prc_type_code igf_sl_lor_all.prc_type_code%TYPE;
1505: l_n_award_id igf_aw_award_all.award_id%TYPE;
1506: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
1507: l_n_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
1508: l_n_resp_guarantee_amt igf_sl_cl_resp_r1_all.guarantee_amt%TYPE;
1509: l_v_response_status_code igf_sl_clchsn_dtls.response_status_code%TYPE;
1510: l_v_status_code igf_sl_clchsn_dtls.status_code%TYPE;

Line 2866: ,igf_sl_loans_all lar

2862: ,lar.loan_status
2863: ,lor.prc_type_code
2864: ,lor.cl_rec_status
2865: FROM igf_sl_lor_all lor
2866: ,igf_sl_loans_all lar
2867: WHERE lor.loan_id = lar.loan_id
2868: AND lar.award_id = cp_n_award_id;
2869:
2870: rec_c_igf_sl_lorlar c_igf_sl_lorlar%ROWTYPE;

Line 2872: CURSOR c_resp_r1_r8 (cp_v_loan_number igf_sl_loans_all.loan_number%TYPE,

2868: AND lar.award_id = cp_n_award_id;
2869:
2870: rec_c_igf_sl_lorlar c_igf_sl_lorlar%ROWTYPE;
2871:
2872: CURSOR c_resp_r1_r8 (cp_v_loan_number igf_sl_loans_all.loan_number%TYPE,
2873: cp_n_disb_num igf_aw_awd_disb_all.disb_num%TYPE
2874: ) IS
2875: SELECT resp_r8.disb_date
2876: ,resp_r8.disb_gross_amt

Line 2894: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;

2890:
2891: rec_c_igf_sl_clchsn_dtls igf_sl_clchsn_dtls%ROWTYPE;
2892:
2893: l_n_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
2894: l_v_loan_status igf_sl_loans_all.loan_status%TYPE;
2895: l_n_clchgsnd_id igf_sl_clchsn_dtls.clchgsnd_id%TYPE;
2896: l_v_sqlstmt VARCHAR2(32767);
2897: l_v_rowid ROWID;
2898: l_v_message_name fnd_new_messages.message_name%TYPE;

Line 2903: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;

2899: l_b_return_status BOOLEAN;
2900: l_c_cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE;
2901: l_v_prc_type_code igf_sl_lor_all.prc_type_code%TYPE;
2902: l_n_award_id igf_aw_award_all.award_id%TYPE;
2903: l_v_loan_number igf_sl_loans_all.loan_number%TYPE;
2904: l_n_disb_num igf_aw_awd_disb_all.disb_num%TYPE;
2905: l_v_old_fund_status igf_aw_awd_disb_all.fund_status%TYPE;
2906: l_n_resp_disb_gross_amt igf_aw_awd_disb_all.disb_gross_amt%TYPE;
2907: l_d_resp_disb_date igf_aw_awd_disb_all.disb_date%TYPE;