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_ORIG_ACK dependencies on IGF_SL_CLCHSN_DTLS

Line 6767: --cp_v_send_record_txt igf_sl_clchsn_dtls.send_record_txt%TYPE)

6763: --Change History:
6764: --Who When What
6765: ------------------------------------------------------------------
6766: CURSOR c_sl_clchsn_dtls (cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS
6767: --cp_v_send_record_txt igf_sl_clchsn_dtls.send_record_txt%TYPE)
6768: SELECT chdt.*, chdt.ROWID row_id
6769: FROM igf_sl_clchsn_dtls chdt
6770: WHERE loan_number_txt = cp_v_loan_number
6771: AND chdt.status_code = 'S';

Line 6769: FROM igf_sl_clchsn_dtls chdt

6765: ------------------------------------------------------------------
6766: CURSOR c_sl_clchsn_dtls (cp_v_loan_number igf_sl_loans_all.loan_number%TYPE) IS
6767: --cp_v_send_record_txt igf_sl_clchsn_dtls.send_record_txt%TYPE)
6768: SELECT chdt.*, chdt.ROWID row_id
6769: FROM igf_sl_clchsn_dtls chdt
6770: WHERE loan_number_txt = cp_v_loan_number
6771: AND chdt.status_code = 'S';
6772:
6773: rec_c_sl_clchsn_dtls c_sl_clchsn_dtls%ROWTYPE;

Line 6785: l_v_response_status_code igf_sl_clchsn_dtls.response_status_code%TYPE;

6781:
6782: rec_c_sl_clchrs_dtls c_sl_clchrs_dtls%ROWTYPE;
6783:
6784: l_n_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE;
6785: l_v_response_status_code igf_sl_clchsn_dtls.response_status_code%TYPE;
6786: l_v_status_code igf_sl_clchsn_dtls.status_code%TYPE;
6787: e_skip_change_rec EXCEPTION;
6788: BEGIN
6789: log_to_fnd(p_v_module => 'process_change_records',

Line 6786: l_v_status_code igf_sl_clchsn_dtls.status_code%TYPE;

6782: rec_c_sl_clchrs_dtls c_sl_clchrs_dtls%ROWTYPE;
6783:
6784: l_n_clrp1_id igf_sl_cl_resp_r1_all.clrp1_id%TYPE;
6785: l_v_response_status_code igf_sl_clchsn_dtls.response_status_code%TYPE;
6786: l_v_status_code igf_sl_clchsn_dtls.status_code%TYPE;
6787: e_skip_change_rec EXCEPTION;
6788: BEGIN
6789: log_to_fnd(p_v_module => 'process_change_records',
6790: p_v_string => '|p_n_clrp1_id = ' || p_n_clrp1_id ||

Line 6843: p_v_string => 'invoking igf_sl_clchsn_dtls_pkg.update_row for change send id ='||rec_c_sl_clchsn_dtls.clchgsnd_id

6839: log_parameters ( p_v_param_typ => RPAD(igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','CHG_RESP_STATUS'),40),
6840: p_v_param_val => igf_aw_gen.lookup_desc('IGF_SL_CL_CHG_RESP_STATUS',l_v_response_status_code)
6841: );
6842: log_to_fnd(p_v_module => 'process_change_records',
6843: p_v_string => 'invoking igf_sl_clchsn_dtls_pkg.update_row for change send id ='||rec_c_sl_clchsn_dtls.clchgsnd_id
6844: );
6845: igf_sl_clchsn_dtls_pkg.update_row (
6846: x_rowid => rec_c_sl_clchsn_dtls.row_id ,
6847: x_clchgsnd_id => rec_c_sl_clchsn_dtls.clchgsnd_id ,

Line 6845: igf_sl_clchsn_dtls_pkg.update_row (

6841: );
6842: log_to_fnd(p_v_module => 'process_change_records',
6843: p_v_string => 'invoking igf_sl_clchsn_dtls_pkg.update_row for change send id ='||rec_c_sl_clchsn_dtls.clchgsnd_id
6844: );
6845: igf_sl_clchsn_dtls_pkg.update_row (
6846: x_rowid => rec_c_sl_clchsn_dtls.row_id ,
6847: x_clchgsnd_id => rec_c_sl_clchsn_dtls.clchgsnd_id ,
6848: x_award_id => rec_c_sl_clchsn_dtls.award_id ,
6849: x_loan_number_txt => rec_c_sl_clchsn_dtls.loan_number_txt ,