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.

[Home] [Help]

APPS.IGF_SL_CL_ORIG dependencies on IGF_SL_LOR_LOC

Line 69: -- chg_batch_id from igf_sl_lor_loc

65: -- chg_batch_id,appl_send_error_codes from igf_sl_lor
66: -- 2. Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
67: -- cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
68: -- p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
69: -- chg_batch_id from igf_sl_lor_loc
70: -- 3. Changed cur_recip_dts to take p_loan_status,p_active,p_lookup_type,p_enabled_flag
71: -- as parameters
72: -- 4. Changed cursor cur_loan_dtls not to select student/borrower information. This is
73: -- derived using igf_sl_gen.get_person_dtls

Line 144: lv_alien_reg_num igf_sl_lor_loc_all.s_alien_reg_num%TYPE; --pssahni 31-Jan-2005 changed %type from igf_ap_isir_matched_all to igf_sl_lor_loc_all

140: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
141: lv_p_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
142: lv_s_license_number igf_ap_isir_matched_all.driver_license_number%TYPE;
143: lv_s_license_state igf_ap_isir_matched_all.driver_license_state%TYPE;
144: lv_alien_reg_num igf_sl_lor_loc_all.s_alien_reg_num%TYPE; --pssahni 31-Jan-2005 changed %type from igf_ap_isir_matched_all to igf_sl_lor_loc_all
145: lv_s_legal_res_state igf_ap_isir_matched_all.s_state_legal_residence%TYPE;
146: lv_s_legal_res_date DATE;
147: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
148: lv_s_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;

Line 147: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;

143: lv_s_license_state igf_ap_isir_matched_all.driver_license_state%TYPE;
144: lv_alien_reg_num igf_sl_lor_loc_all.s_alien_reg_num%TYPE; --pssahni 31-Jan-2005 changed %type from igf_ap_isir_matched_all to igf_sl_lor_loc_all
145: lv_s_legal_res_state igf_ap_isir_matched_all.s_state_legal_residence%TYPE;
146: lv_s_legal_res_date DATE;
147: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
148: lv_s_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
149: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
150: l_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
151: lv_p_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;

Line 148: lv_s_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;

144: lv_alien_reg_num igf_sl_lor_loc_all.s_alien_reg_num%TYPE; --pssahni 31-Jan-2005 changed %type from igf_ap_isir_matched_all to igf_sl_lor_loc_all
145: lv_s_legal_res_state igf_ap_isir_matched_all.s_state_legal_residence%TYPE;
146: lv_s_legal_res_date DATE;
147: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
148: lv_s_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
149: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
150: l_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
151: lv_p_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
152:

Line 149: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;

145: lv_s_legal_res_state igf_ap_isir_matched_all.s_state_legal_residence%TYPE;
146: lv_s_legal_res_date DATE;
147: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
148: lv_s_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
149: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
150: l_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
151: lv_p_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
152:
153: x_return_status VARCHAR2(1);

Line 150: l_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;

146: lv_s_legal_res_date DATE;
147: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
148: lv_s_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
149: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
150: l_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
151: lv_p_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
152:
153: x_return_status VARCHAR2(1);
154: x_msg_data VARCHAR2(30);

Line 151: lv_p_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;

147: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
148: lv_s_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
149: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
150: l_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
151: lv_p_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
152:
153: x_return_status VARCHAR2(1);
154: x_msg_data VARCHAR2(30);
155: x_ope_cd igs_or_org_alt_ids.org_alternate_id%TYPE;

Line 702: Purpose : To insert transaction records into the igf_sl_lor_loc table

698:
699: /***************************************************************
700: Created By : mesriniv
701: Date Created By : 2000/11/17
702: Purpose : To insert transaction records into the igf_sl_lor_loc table
703: Known Limitations,Enhancements or Remarks
704: Change History :
705: Who When What
706: veramach 23-SEP-2003 Bug 3104228:

Line 714: chg_batch_id from igf_sl_lor_loc

710: chg_batch_id,appl_send_error_codes from igf_sl_lor
711: 2. Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
712: cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
713: p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
714: chg_batch_id from igf_sl_lor_loc
715: ***************************************************************/
716:
717: lv_row_id ROWID;
718: -- masehgal 08-Jan-2003 # 2593215 Removed redundant calls to acad

Line 742: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.insert_lor_loc_rec.debug', 'Before inserting into igf_sl_lor_loc' );

738: -- masehgal 08-Jan-2003 # 2593215 Removed redundant calls to acad
739: -- begin/end date fetching functions of SL11B.
740:
741: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
742: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.insert_lor_loc_rec.debug', 'Before inserting into igf_sl_lor_loc' );
743: END IF;
744:
745: igf_sl_lor_loc_pkg.insert_row (
746: x_mode => 'R',

Line 745: igf_sl_lor_loc_pkg.insert_row (

741: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
742: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.insert_lor_loc_rec.debug', 'Before inserting into igf_sl_lor_loc' );
743: END IF;
744:
745: igf_sl_lor_loc_pkg.insert_row (
746: x_mode => 'R',
747: x_rowid => lv_row_id,
748: x_loan_id => loan_rec.loan_id,
749: x_origination_id => loan_rec.origination_id,

Line 948: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.insert_lor_loc_rec.debug', 'Insertion into igf_sl_lor_loc succeeded' );

944:
945: );
946:
947: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
948: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.insert_lor_loc_rec.debug', 'Insertion into igf_sl_lor_loc succeeded' );
949: END IF;
950:
951: EXCEPTION
952:

Line 990: chg_batch_id from igf_sl_lor_loc

986: chg_batch_id,appl_send_error_codes from igf_sl_lor
987: 2. Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
988: cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
989: p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
990: chg_batch_id from igf_sl_lor_loc
991: masehgal 17-Feb-2002 # 2216956 , FACR007
992: Added Elec_mpn_indicator , Borrow_sign_ind
993: ***************************************************************/
994:

Line 1269: lv_s_foreign_postal_code igf_sl_lor_loc.s_foreign_postal_code%TYPE;

1265: lv_source_name igf_lookups_view.meaning%TYPE;
1266:
1267: lv_cl_version VARCHAR2(30);
1268:
1269: lv_s_foreign_postal_code igf_sl_lor_loc.s_foreign_postal_code%TYPE;
1270: lv_p_foreign_postal_code igf_sl_lor_loc.p_foreign_postal_code%TYPE;
1271: l_est_fin igf_aw_award_all.accepted_amt%TYPE;
1272: l_plus_cert_amt igf_aw_award_all.accepted_amt%TYPE;
1273: l_alt_cert_amt igf_aw_award_all.accepted_amt%TYPE;

Line 1270: lv_p_foreign_postal_code igf_sl_lor_loc.p_foreign_postal_code%TYPE;

1266:
1267: lv_cl_version VARCHAR2(30);
1268:
1269: lv_s_foreign_postal_code igf_sl_lor_loc.s_foreign_postal_code%TYPE;
1270: lv_p_foreign_postal_code igf_sl_lor_loc.p_foreign_postal_code%TYPE;
1271: l_est_fin igf_aw_award_all.accepted_amt%TYPE;
1272: l_plus_cert_amt igf_aw_award_all.accepted_amt%TYPE;
1273: l_alt_cert_amt igf_aw_award_all.accepted_amt%TYPE;
1274: l_tot_alt_debt igf_sl_alt_borw.fed_sls_debt%TYPE;

Line 2769: -- Corresponding Loan Id in IGF_SL_LOR_LOC table should be deleted

2765: -- Increment the counter for the Number of @8 records in this file
2766: lv_8_disb_count := lv_8_disb_count + 1;
2767: END IF;
2768:
2769: -- Corresponding Loan Id in IGF_SL_LOR_LOC table should be deleted
2770: DECLARE
2771: lv_row_id ROWID;
2772: CURSOR c_tbh_cur IS
2773: SELECT row_id row_id

Line 2774: FROM igf_sl_lor_loc

2770: DECLARE
2771: lv_row_id ROWID;
2772: CURSOR c_tbh_cur IS
2773: SELECT row_id row_id
2774: FROM igf_sl_lor_loc
2775: WHERE loan_id = loan_rec.loan_id FOR UPDATE OF loan_status NOWAIT;
2776: BEGIN
2777: FOR tbh_rec in c_tbh_cur LOOP
2778: igf_sl_lor_loc_pkg.delete_row (tbh_rec.row_id);

Line 2778: igf_sl_lor_loc_pkg.delete_row (tbh_rec.row_id);

2774: FROM igf_sl_lor_loc
2775: WHERE loan_id = loan_rec.loan_id FOR UPDATE OF loan_status NOWAIT;
2776: BEGIN
2777: FOR tbh_rec in c_tbh_cur LOOP
2778: igf_sl_lor_loc_pkg.delete_row (tbh_rec.row_id);
2779: END LOOP;
2780: END;
2781:
2782: -- Insert the same loan record into IGF_SL_LOR_LOC to keep track of Data Sent to External Processor

Line 2782: -- Insert the same loan record into IGF_SL_LOR_LOC to keep track of Data Sent to External Processor

2778: igf_sl_lor_loc_pkg.delete_row (tbh_rec.row_id);
2779: END LOOP;
2780: END;
2781:
2782: -- Insert the same loan record into IGF_SL_LOR_LOC to keep track of Data Sent to External Processor
2783:
2784: insert_lor_loc_rec (
2785: p_v_school_id => p_school_id ,
2786: p_n_coa => l_coa,