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_LOR_ALL

Line 54: FROM igf_sl_lor_all lor

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;
56:
57: rec_c_igf_sl_lor c_igf_sl_lor%ROWTYPE;
58:

Line 86: l_c_cl_rec_status igf_sl_lor_all.cl_rec_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;
90: l_v_message_name fnd_new_messages.message_name%TYPE;

Line 87: l_v_prc_type_code igf_sl_lor_all.prc_type_code%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;
90: l_v_message_name fnd_new_messages.message_name%TYPE;
91: l_b_return_status BOOLEAN;

Line 735: PROCEDURE create_lor_chg_rec ( p_new_lor_rec IN igf_sl_lor_all%ROWTYPE,

731:
732: END create_loan_chg_rec;
733:
734:
735: PROCEDURE create_lor_chg_rec ( p_new_lor_rec IN igf_sl_lor_all%ROWTYPE,
736: p_b_return_status OUT NOCOPY BOOLEAN,
737: p_v_message_name OUT NOCOPY VARCHAR2
738: ) AS
739: ------------------------------------------------------------------

Line 783: l_d_lor_anticip_compl_dt igf_sl_lor_all.anticip_compl_date%TYPE;

779:
780: rec_c_igf_sl_clchsn_dtls igf_sl_clchsn_dtls%ROWTYPE;
781:
782: l_d_resp_anticip_compl_dt igf_sl_cl_resp_r1_all.anticip_compl_date%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;

Line 784: l_v_resp_grade_level_cd igf_sl_lor_all.override_grade_level_code%TYPE;

780: rec_c_igf_sl_clchsn_dtls igf_sl_clchsn_dtls%ROWTYPE;
781:
782: l_d_resp_anticip_compl_dt igf_sl_cl_resp_r1_all.anticip_compl_date%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;

Line 785: l_v_ovr_grade_level_cd igf_sl_lor_all.override_grade_level_code%TYPE;

781:
782: l_d_resp_anticip_compl_dt igf_sl_cl_resp_r1_all.anticip_compl_date%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);

Line 793: l_c_cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE;

789: l_v_sqlstmt VARCHAR2(32767);
790: l_v_rowid ROWID;
791: l_v_message_name fnd_new_messages.message_name%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:

Line 794: l_v_prc_type_code igf_sl_lor_all.prc_type_code%TYPE;

790: l_v_rowid ROWID;
791: l_v_message_name fnd_new_messages.message_name%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;

Line 1468: FROM igf_sl_lor_all lor

1464: SELECT lar.loan_number
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:

Line 1503: l_c_cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE;

1499: l_v_sqlstmt VARCHAR2(32767);
1500: l_v_rowid ROWID;
1501: l_v_message_name fnd_new_messages.message_name%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;

Line 1504: l_v_prc_type_code igf_sl_lor_all.prc_type_code%TYPE;

1500: l_v_rowid ROWID;
1501: l_v_message_name fnd_new_messages.message_name%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;

Line 2865: FROM igf_sl_lor_all lor

2861: SELECT lar.loan_number
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:

Line 2900: l_c_cl_rec_status igf_sl_lor_all.cl_rec_status%TYPE;

2896: l_v_sqlstmt VARCHAR2(32767);
2897: l_v_rowid ROWID;
2898: l_v_message_name fnd_new_messages.message_name%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;

Line 2901: l_v_prc_type_code igf_sl_lor_all.prc_type_code%TYPE;

2897: l_v_rowid ROWID;
2898: l_v_message_name fnd_new_messages.message_name%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;