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

Line 65: -- chg_batch_id,appl_send_error_codes from igf_sl_lor

61: -----------------------------------------------------------------------------------------------------------------------------
62: -- veramach 23-SEP-2003 Bug 3104228: 1. Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
63: -- cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
64: -- p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
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

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 211: p_relationship_cd igf_sl_lor_all.relationship_cd%TYPE,

207: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
208: p_loan_number igf_sl_loans.loan_number%TYPE,
209: p_loan_status igf_sl_loans.loan_status%TYPE,
210: p_active igf_sl_loans.active%TYPE,
211: p_relationship_cd igf_sl_lor_all.relationship_cd%TYPE,
212: p_base_id VARCHAR2,
213: p_school_id VARCHAR2
214: ) IS
215: SELECT loans.ROWID row_id,

Line 339: igf_sl_lor_all lor,

335: recip.relationship_cd,
336: lor.b_alien_reg_num_txt, -- fa 161 - bug # 5006583
337: lor.esign_src_typ_cd
338: FROM igf_sl_loans_all loans,
339: igf_sl_lor_all lor,
340: igf_aw_award_all awd,
341: igf_aw_fund_mast_all fmast,
342: igf_aw_fund_cat_all fcat,
343: igf_ap_fa_base_rec_all fabase,

Line 426: igf_sl_lor lor,

422: ) IS
423: SELECT DISTINCT lor.relationship_cd
424: FROM igf_ap_fa_base_rec fabase,
425: igf_sl_loans lar,
426: igf_sl_lor lor,
427: igf_aw_award awd,
428: igf_aw_fund_mast fund,
429: igf_aw_fund_cat fcat,
430: igf_sl_cl_recipient recip

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 710: chg_batch_id,appl_send_error_codes from igf_sl_lor

706: veramach 23-SEP-2003 Bug 3104228:
707: 1. Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
708: cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
709: p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
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

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 972: PROCEDURE update_orig_batch_id(p_origination_id igf_sl_lor.origination_id%TYPE,

968:
969: END insert_lor_loc_rec;
970:
971:
972: PROCEDURE update_orig_batch_id(p_origination_id igf_sl_lor.origination_id%TYPE,
973: p_batch_id igf_sl_lor.orig_batch_id%TYPE)
974: IS
975: /***************************************************************
976: Created By : mesriniv

Line 973: p_batch_id igf_sl_lor.orig_batch_id%TYPE)

969: END insert_lor_loc_rec;
970:
971:
972: PROCEDURE update_orig_batch_id(p_origination_id igf_sl_lor.origination_id%TYPE,
973: p_batch_id igf_sl_lor.orig_batch_id%TYPE)
974: IS
975: /***************************************************************
976: Created By : mesriniv
977: Date Created By : 2000/11/17

Line 978: Purpose : To update igf_sl_lor table with origination batch id

974: IS
975: /***************************************************************
976: Created By : mesriniv
977: Date Created By : 2000/11/17
978: Purpose : To update igf_sl_lor table with origination batch id
979: Known Limitations,Enhancements or Remarks
980: Change History :
981: Who When What
982: veramach 23-SEP-2003 Bug 3104228:

Line 986: chg_batch_id,appl_send_error_codes from igf_sl_lor

982: veramach 23-SEP-2003 Bug 3104228:
983: 1. Obsoleted lend_apprv_denied_code,lend_apprv_denied_date,cl_rec_status_last_update,
984: cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
985: p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
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

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 999: SELECT igf_sl_lor.*

995: lv_row_id ROWID;
996: l_sch_date DATE;
997:
998: CURSOR c_tbh_cur IS
999: SELECT igf_sl_lor.*
1000: FROM igf_sl_lor
1001: WHERE origination_id = p_origination_id FOR UPDATE OF sch_cert_date NOWAIT;
1002:
1003: CURSOR c_sl_loans (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS

Line 1000: FROM igf_sl_lor

996: l_sch_date DATE;
997:
998: CURSOR c_tbh_cur IS
999: SELECT igf_sl_lor.*
1000: FROM igf_sl_lor
1001: WHERE origination_id = p_origination_id FOR UPDATE OF sch_cert_date NOWAIT;
1002:
1003: CURSOR c_sl_loans (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS
1004: SELECT external_loan_id_txt

Line 1034: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.update_batch_orig_id.debug', 'Before inserting into igf_sl_lor, loan_id:'||tbh_rec.loan_id);

1030: l_sch_date:=TRUNC(SYSDATE);
1031: END IF;
1032:
1033: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1034: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.update_batch_orig_id.debug', 'Before inserting into igf_sl_lor, loan_id:'||tbh_rec.loan_id);
1035: END IF;
1036: OPEN c_sl_loans (cp_n_loan_id => tbh_rec.loan_id);
1037: FETCH c_sl_loans INTO l_v_ext_loan_id_txt ;
1038: CLOSE c_sl_loans ;

Line 1040: igf_sl_lor_pkg.update_row (

1036: OPEN c_sl_loans (cp_n_loan_id => tbh_rec.loan_id);
1037: FETCH c_sl_loans INTO l_v_ext_loan_id_txt ;
1038: CLOSE c_sl_loans ;
1039:
1040: igf_sl_lor_pkg.update_row (
1041: x_Mode => 'R',
1042: x_rowid => tbh_rec.row_id,
1043: x_origination_id => tbh_rec.origination_id,
1044: x_loan_id => tbh_rec.loan_id,

Line 1171: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.update_orig_batch_id.debug', 'Insertion into igf_sl_lor succeeded, loan_id:'||tbh_rec.loan_id);

1167:
1168: );
1169:
1170: IF (fnd_log.level_statement >= g_debug_runtime_level) THEN
1171: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_orig.update_orig_batch_id.debug', 'Insertion into igf_sl_lor succeeded, loan_id:'||tbh_rec.loan_id);
1172: END IF;
1173:
1174: END LOOP;
1175:

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 1307: lv_stud_sign_ind igf_sl_lor.stud_sign_ind%TYPE;

1303: ln_num_of_disb NUMBER;
1304: lv_indi VARCHAR2(1);
1305: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
1306: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
1307: lv_stud_sign_ind igf_sl_lor.stud_sign_ind%TYPE;
1308: lv_borw_interest_ind igf_sl_lor.borw_interest_ind%TYPE;
1309: lv_borr_sign_ind igf_sl_lor.borr_sign_ind%TYPE;
1310: lv_rel_code VARCHAR2(30);
1311: lv_person_id NUMBER;

Line 1308: lv_borw_interest_ind igf_sl_lor.borw_interest_ind%TYPE;

1304: lv_indi VARCHAR2(1);
1305: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
1306: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
1307: lv_stud_sign_ind igf_sl_lor.stud_sign_ind%TYPE;
1308: lv_borw_interest_ind igf_sl_lor.borw_interest_ind%TYPE;
1309: lv_borr_sign_ind igf_sl_lor.borr_sign_ind%TYPE;
1310: lv_rel_code VARCHAR2(30);
1311: lv_person_id NUMBER;
1312: lv_party_id NUMBER;

Line 1309: lv_borr_sign_ind igf_sl_lor.borr_sign_ind%TYPE;

1305: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE;
1306: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE;
1307: lv_stud_sign_ind igf_sl_lor.stud_sign_ind%TYPE;
1308: lv_borw_interest_ind igf_sl_lor.borw_interest_ind%TYPE;
1309: lv_borr_sign_ind igf_sl_lor.borr_sign_ind%TYPE;
1310: lv_rel_code VARCHAR2(30);
1311: lv_person_id NUMBER;
1312: lv_party_id NUMBER;
1313: l_n_send2_rec_cnt NUMBER;

Line 1431: FROM igf_sl_lor_all lor

1427:
1428:
1429: CURSOR c_sl_lor (cp_n_loan_id igf_sl_loans_all.loan_id%TYPE) IS
1430: SELECT lor.*
1431: FROM igf_sl_lor_all lor
1432: WHERE loan_id = cp_n_loan_id;
1433:
1434: rec_c_sl_lor c_sl_lor%ROWTYPE;
1435:

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,