APPS.IGF_SL_LOANS_PKG dependencies on IGF_SL_CLCHSN_DTLS

Line 176: || igf_sl_clchsn_dtls_pkg.get_ufk_igf_sl_loans.

172: || Change History :
173: || Who When What
174: || (reverse chronological order - newest change first)
175: || smadathi 14-OCT-2004 Enh. Bug 3416936. Added call to
176: || igf_sl_clchsn_dtls_pkg.get_ufk_igf_sl_loans.
177: || agairola 15-Mar-2002 Added the code for the new column
178: || for the Borrower Determination
179: */
180: BEGIN

Line 192: igf_sl_clchsn_dtls_pkg.get_ufk_igf_sl_loans(x_loan_number => old_references.loan_number);

188: igf_sl_dl_pnote_s_p_pkg.get_fk_igf_sl_loans ( old_references.loan_id );
189:
190: igf_sl_lor_pkg.get_fk_igf_sl_loans ( old_references.loan_id );
191:
192: igf_sl_clchsn_dtls_pkg.get_ufk_igf_sl_loans(x_loan_number => old_references.loan_number);
193:
194: END check_child_existance;
195:
196:

Line 368: CURSOR cur_loan_chg_records(cp_award_id igf_sl_clchsn_dtls.award_id%TYPE) IS

364: WHERE dbchgdtls.award_id = cp_award_id
365: AND dbchgdtls.disb_status = 'S';
366:
367: -- bvisvana - FA 161 - Bug 5091652..Cursor to pick all the change records for the loan
368: CURSOR cur_loan_chg_records(cp_award_id igf_sl_clchsn_dtls.award_id%TYPE) IS
369: SELECT loan_chg_dtls.ROWID, loan_chg_dtls.*
370: FROM igf_sl_clchsn_dtls loan_chg_dtls
371: WHERE loan_chg_dtls.award_id = cp_award_id;
372:

Line 370: FROM igf_sl_clchsn_dtls loan_chg_dtls

366:
367: -- bvisvana - FA 161 - Bug 5091652..Cursor to pick all the change records for the loan
368: CURSOR cur_loan_chg_records(cp_award_id igf_sl_clchsn_dtls.award_id%TYPE) IS
369: SELECT loan_chg_dtls.ROWID, loan_chg_dtls.*
370: FROM igf_sl_clchsn_dtls loan_chg_dtls
371: WHERE loan_chg_dtls.award_id = cp_award_id;
372:
373: l_v_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;
374: l_v_message_name fnd_new_messages.message_name%TYPE;

Line 393: -- invoke the procedure to create change record in igf_sl_clchsn_dtls table

389: IF g_v_called_from IN ('IGFSL005','UPDATE_MODE') THEN
390: IF ((new_references.loan_per_begin_date <> old_references.loan_per_begin_date) OR
391: (new_references.loan_per_end_date <> old_references.loan_per_end_date))
392: THEN
393: -- invoke the procedure to create change record in igf_sl_clchsn_dtls table
394: igf_sl_cl_create_chg.create_loan_chg_rec
395: (
396: p_new_loan_rec => new_references,
397: p_b_return_status => l_b_return_status,

Line 460: FOR rec_c_igf_sl_clchsn_dtls IN cur_loan_chg_records(new_references.award_id) LOOP

456: -- bvisvana - Bug 5091652
457: -- If either loan status or loan change status CHANGED to "Ready to Send"
458: -- then update all change change records in "Sent" status to "Ready to Send".Change records apply only for FFELP
459: IF (l_v_fed_fund_code IN ('FLS','FLU','FLP','ALT','GPLUSFL') AND g_v_called_from IN ('IGFSL005','UPDATE_MODE')) THEN
460: FOR rec_c_igf_sl_clchsn_dtls IN cur_loan_chg_records(new_references.award_id) LOOP
461: igf_sl_clchsn_dtls_pkg.update_row (
462: x_rowid => rec_c_igf_sl_clchsn_dtls.ROWID ,
463: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
464: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

Line 461: igf_sl_clchsn_dtls_pkg.update_row (

457: -- If either loan status or loan change status CHANGED to "Ready to Send"
458: -- then update all change change records in "Sent" status to "Ready to Send".Change records apply only for FFELP
459: IF (l_v_fed_fund_code IN ('FLS','FLU','FLP','ALT','GPLUSFL') AND g_v_called_from IN ('IGFSL005','UPDATE_MODE')) THEN
460: FOR rec_c_igf_sl_clchsn_dtls IN cur_loan_chg_records(new_references.award_id) LOOP
461: igf_sl_clchsn_dtls_pkg.update_row (
462: x_rowid => rec_c_igf_sl_clchsn_dtls.ROWID ,
463: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
464: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,
465: x_loan_number_txt => rec_c_igf_sl_clchsn_dtls.loan_number_txt ,

Line 462: x_rowid => rec_c_igf_sl_clchsn_dtls.ROWID ,

458: -- then update all change change records in "Sent" status to "Ready to Send".Change records apply only for FFELP
459: IF (l_v_fed_fund_code IN ('FLS','FLU','FLP','ALT','GPLUSFL') AND g_v_called_from IN ('IGFSL005','UPDATE_MODE')) THEN
460: FOR rec_c_igf_sl_clchsn_dtls IN cur_loan_chg_records(new_references.award_id) LOOP
461: igf_sl_clchsn_dtls_pkg.update_row (
462: x_rowid => rec_c_igf_sl_clchsn_dtls.ROWID ,
463: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
464: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,
465: x_loan_number_txt => rec_c_igf_sl_clchsn_dtls.loan_number_txt ,
466: x_cl_version_code => rec_c_igf_sl_clchsn_dtls.cl_version_code ,

Line 463: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,

459: IF (l_v_fed_fund_code IN ('FLS','FLU','FLP','ALT','GPLUSFL') AND g_v_called_from IN ('IGFSL005','UPDATE_MODE')) THEN
460: FOR rec_c_igf_sl_clchsn_dtls IN cur_loan_chg_records(new_references.award_id) LOOP
461: igf_sl_clchsn_dtls_pkg.update_row (
462: x_rowid => rec_c_igf_sl_clchsn_dtls.ROWID ,
463: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
464: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,
465: x_loan_number_txt => rec_c_igf_sl_clchsn_dtls.loan_number_txt ,
466: x_cl_version_code => rec_c_igf_sl_clchsn_dtls.cl_version_code ,
467: x_change_field_code => rec_c_igf_sl_clchsn_dtls.change_field_code ,

Line 464: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,

460: FOR rec_c_igf_sl_clchsn_dtls IN cur_loan_chg_records(new_references.award_id) LOOP
461: igf_sl_clchsn_dtls_pkg.update_row (
462: x_rowid => rec_c_igf_sl_clchsn_dtls.ROWID ,
463: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
464: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,
465: x_loan_number_txt => rec_c_igf_sl_clchsn_dtls.loan_number_txt ,
466: x_cl_version_code => rec_c_igf_sl_clchsn_dtls.cl_version_code ,
467: x_change_field_code => rec_c_igf_sl_clchsn_dtls.change_field_code ,
468: x_change_record_type_txt => rec_c_igf_sl_clchsn_dtls.change_record_type_txt ,

Line 465: x_loan_number_txt => rec_c_igf_sl_clchsn_dtls.loan_number_txt ,

461: igf_sl_clchsn_dtls_pkg.update_row (
462: x_rowid => rec_c_igf_sl_clchsn_dtls.ROWID ,
463: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
464: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,
465: x_loan_number_txt => rec_c_igf_sl_clchsn_dtls.loan_number_txt ,
466: x_cl_version_code => rec_c_igf_sl_clchsn_dtls.cl_version_code ,
467: x_change_field_code => rec_c_igf_sl_clchsn_dtls.change_field_code ,
468: x_change_record_type_txt => rec_c_igf_sl_clchsn_dtls.change_record_type_txt ,
469: x_change_code_txt => rec_c_igf_sl_clchsn_dtls.change_code_txt ,

Line 466: x_cl_version_code => rec_c_igf_sl_clchsn_dtls.cl_version_code ,

462: x_rowid => rec_c_igf_sl_clchsn_dtls.ROWID ,
463: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
464: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,
465: x_loan_number_txt => rec_c_igf_sl_clchsn_dtls.loan_number_txt ,
466: x_cl_version_code => rec_c_igf_sl_clchsn_dtls.cl_version_code ,
467: x_change_field_code => rec_c_igf_sl_clchsn_dtls.change_field_code ,
468: x_change_record_type_txt => rec_c_igf_sl_clchsn_dtls.change_record_type_txt ,
469: x_change_code_txt => rec_c_igf_sl_clchsn_dtls.change_code_txt ,
470: x_status_code => 'R' ,

Line 467: x_change_field_code => rec_c_igf_sl_clchsn_dtls.change_field_code ,

463: x_clchgsnd_id => rec_c_igf_sl_clchsn_dtls.clchgsnd_id ,
464: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,
465: x_loan_number_txt => rec_c_igf_sl_clchsn_dtls.loan_number_txt ,
466: x_cl_version_code => rec_c_igf_sl_clchsn_dtls.cl_version_code ,
467: x_change_field_code => rec_c_igf_sl_clchsn_dtls.change_field_code ,
468: x_change_record_type_txt => rec_c_igf_sl_clchsn_dtls.change_record_type_txt ,
469: x_change_code_txt => rec_c_igf_sl_clchsn_dtls.change_code_txt ,
470: x_status_code => 'R' ,
471: x_status_date => rec_c_igf_sl_clchsn_dtls.status_date ,

Line 468: x_change_record_type_txt => rec_c_igf_sl_clchsn_dtls.change_record_type_txt ,

464: x_award_id => rec_c_igf_sl_clchsn_dtls.award_id ,
465: x_loan_number_txt => rec_c_igf_sl_clchsn_dtls.loan_number_txt ,
466: x_cl_version_code => rec_c_igf_sl_clchsn_dtls.cl_version_code ,
467: x_change_field_code => rec_c_igf_sl_clchsn_dtls.change_field_code ,
468: x_change_record_type_txt => rec_c_igf_sl_clchsn_dtls.change_record_type_txt ,
469: x_change_code_txt => rec_c_igf_sl_clchsn_dtls.change_code_txt ,
470: x_status_code => 'R' ,
471: x_status_date => rec_c_igf_sl_clchsn_dtls.status_date ,
472: x_response_status_code => rec_c_igf_sl_clchsn_dtls.response_status_code ,

Line 469: x_change_code_txt => rec_c_igf_sl_clchsn_dtls.change_code_txt ,

465: x_loan_number_txt => rec_c_igf_sl_clchsn_dtls.loan_number_txt ,
466: x_cl_version_code => rec_c_igf_sl_clchsn_dtls.cl_version_code ,
467: x_change_field_code => rec_c_igf_sl_clchsn_dtls.change_field_code ,
468: x_change_record_type_txt => rec_c_igf_sl_clchsn_dtls.change_record_type_txt ,
469: x_change_code_txt => rec_c_igf_sl_clchsn_dtls.change_code_txt ,
470: x_status_code => 'R' ,
471: x_status_date => rec_c_igf_sl_clchsn_dtls.status_date ,
472: x_response_status_code => rec_c_igf_sl_clchsn_dtls.response_status_code ,
473: x_old_value_txt => rec_c_igf_sl_clchsn_dtls.old_value_txt ,

Line 471: x_status_date => rec_c_igf_sl_clchsn_dtls.status_date ,

467: x_change_field_code => rec_c_igf_sl_clchsn_dtls.change_field_code ,
468: x_change_record_type_txt => rec_c_igf_sl_clchsn_dtls.change_record_type_txt ,
469: x_change_code_txt => rec_c_igf_sl_clchsn_dtls.change_code_txt ,
470: x_status_code => 'R' ,
471: x_status_date => rec_c_igf_sl_clchsn_dtls.status_date ,
472: x_response_status_code => rec_c_igf_sl_clchsn_dtls.response_status_code ,
473: x_old_value_txt => rec_c_igf_sl_clchsn_dtls.old_value_txt ,
474: x_new_value_txt => rec_c_igf_sl_clchsn_dtls.new_value_txt ,
475: x_old_date => rec_c_igf_sl_clchsn_dtls.old_date ,

Line 472: x_response_status_code => rec_c_igf_sl_clchsn_dtls.response_status_code ,

468: x_change_record_type_txt => rec_c_igf_sl_clchsn_dtls.change_record_type_txt ,
469: x_change_code_txt => rec_c_igf_sl_clchsn_dtls.change_code_txt ,
470: x_status_code => 'R' ,
471: x_status_date => rec_c_igf_sl_clchsn_dtls.status_date ,
472: x_response_status_code => rec_c_igf_sl_clchsn_dtls.response_status_code ,
473: x_old_value_txt => rec_c_igf_sl_clchsn_dtls.old_value_txt ,
474: x_new_value_txt => rec_c_igf_sl_clchsn_dtls.new_value_txt ,
475: x_old_date => rec_c_igf_sl_clchsn_dtls.old_date ,
476: x_new_date => rec_c_igf_sl_clchsn_dtls.new_date ,

Line 473: x_old_value_txt => rec_c_igf_sl_clchsn_dtls.old_value_txt ,

469: x_change_code_txt => rec_c_igf_sl_clchsn_dtls.change_code_txt ,
470: x_status_code => 'R' ,
471: x_status_date => rec_c_igf_sl_clchsn_dtls.status_date ,
472: x_response_status_code => rec_c_igf_sl_clchsn_dtls.response_status_code ,
473: x_old_value_txt => rec_c_igf_sl_clchsn_dtls.old_value_txt ,
474: x_new_value_txt => rec_c_igf_sl_clchsn_dtls.new_value_txt ,
475: x_old_date => rec_c_igf_sl_clchsn_dtls.old_date ,
476: x_new_date => rec_c_igf_sl_clchsn_dtls.new_date ,
477: x_old_amt => rec_c_igf_sl_clchsn_dtls.old_amt ,

Line 474: x_new_value_txt => rec_c_igf_sl_clchsn_dtls.new_value_txt ,

470: x_status_code => 'R' ,
471: x_status_date => rec_c_igf_sl_clchsn_dtls.status_date ,
472: x_response_status_code => rec_c_igf_sl_clchsn_dtls.response_status_code ,
473: x_old_value_txt => rec_c_igf_sl_clchsn_dtls.old_value_txt ,
474: x_new_value_txt => rec_c_igf_sl_clchsn_dtls.new_value_txt ,
475: x_old_date => rec_c_igf_sl_clchsn_dtls.old_date ,
476: x_new_date => rec_c_igf_sl_clchsn_dtls.new_date ,
477: x_old_amt => rec_c_igf_sl_clchsn_dtls.old_amt ,
478: x_new_amt => rec_c_igf_sl_clchsn_dtls.new_amt ,

Line 475: x_old_date => rec_c_igf_sl_clchsn_dtls.old_date ,

471: x_status_date => rec_c_igf_sl_clchsn_dtls.status_date ,
472: x_response_status_code => rec_c_igf_sl_clchsn_dtls.response_status_code ,
473: x_old_value_txt => rec_c_igf_sl_clchsn_dtls.old_value_txt ,
474: x_new_value_txt => rec_c_igf_sl_clchsn_dtls.new_value_txt ,
475: x_old_date => rec_c_igf_sl_clchsn_dtls.old_date ,
476: x_new_date => rec_c_igf_sl_clchsn_dtls.new_date ,
477: x_old_amt => rec_c_igf_sl_clchsn_dtls.old_amt ,
478: x_new_amt => rec_c_igf_sl_clchsn_dtls.new_amt ,
479: x_disbursement_number => rec_c_igf_sl_clchsn_dtls.disbursement_number ,

Line 476: x_new_date => rec_c_igf_sl_clchsn_dtls.new_date ,

472: x_response_status_code => rec_c_igf_sl_clchsn_dtls.response_status_code ,
473: x_old_value_txt => rec_c_igf_sl_clchsn_dtls.old_value_txt ,
474: x_new_value_txt => rec_c_igf_sl_clchsn_dtls.new_value_txt ,
475: x_old_date => rec_c_igf_sl_clchsn_dtls.old_date ,
476: x_new_date => rec_c_igf_sl_clchsn_dtls.new_date ,
477: x_old_amt => rec_c_igf_sl_clchsn_dtls.old_amt ,
478: x_new_amt => rec_c_igf_sl_clchsn_dtls.new_amt ,
479: x_disbursement_number => rec_c_igf_sl_clchsn_dtls.disbursement_number ,
480: x_disbursement_date => rec_c_igf_sl_clchsn_dtls.disbursement_date ,

Line 477: x_old_amt => rec_c_igf_sl_clchsn_dtls.old_amt ,

473: x_old_value_txt => rec_c_igf_sl_clchsn_dtls.old_value_txt ,
474: x_new_value_txt => rec_c_igf_sl_clchsn_dtls.new_value_txt ,
475: x_old_date => rec_c_igf_sl_clchsn_dtls.old_date ,
476: x_new_date => rec_c_igf_sl_clchsn_dtls.new_date ,
477: x_old_amt => rec_c_igf_sl_clchsn_dtls.old_amt ,
478: x_new_amt => rec_c_igf_sl_clchsn_dtls.new_amt ,
479: x_disbursement_number => rec_c_igf_sl_clchsn_dtls.disbursement_number ,
480: x_disbursement_date => rec_c_igf_sl_clchsn_dtls.disbursement_date ,
481: x_change_issue_code => rec_c_igf_sl_clchsn_dtls.change_issue_code ,

Line 478: x_new_amt => rec_c_igf_sl_clchsn_dtls.new_amt ,

474: x_new_value_txt => rec_c_igf_sl_clchsn_dtls.new_value_txt ,
475: x_old_date => rec_c_igf_sl_clchsn_dtls.old_date ,
476: x_new_date => rec_c_igf_sl_clchsn_dtls.new_date ,
477: x_old_amt => rec_c_igf_sl_clchsn_dtls.old_amt ,
478: x_new_amt => rec_c_igf_sl_clchsn_dtls.new_amt ,
479: x_disbursement_number => rec_c_igf_sl_clchsn_dtls.disbursement_number ,
480: x_disbursement_date => rec_c_igf_sl_clchsn_dtls.disbursement_date ,
481: x_change_issue_code => rec_c_igf_sl_clchsn_dtls.change_issue_code ,
482: x_disbursement_cancel_date => rec_c_igf_sl_clchsn_dtls.disbursement_cancel_date ,

Line 479: x_disbursement_number => rec_c_igf_sl_clchsn_dtls.disbursement_number ,

475: x_old_date => rec_c_igf_sl_clchsn_dtls.old_date ,
476: x_new_date => rec_c_igf_sl_clchsn_dtls.new_date ,
477: x_old_amt => rec_c_igf_sl_clchsn_dtls.old_amt ,
478: x_new_amt => rec_c_igf_sl_clchsn_dtls.new_amt ,
479: x_disbursement_number => rec_c_igf_sl_clchsn_dtls.disbursement_number ,
480: x_disbursement_date => rec_c_igf_sl_clchsn_dtls.disbursement_date ,
481: x_change_issue_code => rec_c_igf_sl_clchsn_dtls.change_issue_code ,
482: x_disbursement_cancel_date => rec_c_igf_sl_clchsn_dtls.disbursement_cancel_date ,
483: x_disbursement_cancel_amt => rec_c_igf_sl_clchsn_dtls.disbursement_cancel_amt ,

Line 480: x_disbursement_date => rec_c_igf_sl_clchsn_dtls.disbursement_date ,

476: x_new_date => rec_c_igf_sl_clchsn_dtls.new_date ,
477: x_old_amt => rec_c_igf_sl_clchsn_dtls.old_amt ,
478: x_new_amt => rec_c_igf_sl_clchsn_dtls.new_amt ,
479: x_disbursement_number => rec_c_igf_sl_clchsn_dtls.disbursement_number ,
480: x_disbursement_date => rec_c_igf_sl_clchsn_dtls.disbursement_date ,
481: x_change_issue_code => rec_c_igf_sl_clchsn_dtls.change_issue_code ,
482: x_disbursement_cancel_date => rec_c_igf_sl_clchsn_dtls.disbursement_cancel_date ,
483: x_disbursement_cancel_amt => rec_c_igf_sl_clchsn_dtls.disbursement_cancel_amt ,
484: x_disbursement_revised_amt => rec_c_igf_sl_clchsn_dtls.disbursement_revised_amt ,

Line 481: x_change_issue_code => rec_c_igf_sl_clchsn_dtls.change_issue_code ,

477: x_old_amt => rec_c_igf_sl_clchsn_dtls.old_amt ,
478: x_new_amt => rec_c_igf_sl_clchsn_dtls.new_amt ,
479: x_disbursement_number => rec_c_igf_sl_clchsn_dtls.disbursement_number ,
480: x_disbursement_date => rec_c_igf_sl_clchsn_dtls.disbursement_date ,
481: x_change_issue_code => rec_c_igf_sl_clchsn_dtls.change_issue_code ,
482: x_disbursement_cancel_date => rec_c_igf_sl_clchsn_dtls.disbursement_cancel_date ,
483: x_disbursement_cancel_amt => rec_c_igf_sl_clchsn_dtls.disbursement_cancel_amt ,
484: x_disbursement_revised_amt => rec_c_igf_sl_clchsn_dtls.disbursement_revised_amt ,
485: x_disbursement_revised_date => rec_c_igf_sl_clchsn_dtls.disbursement_revised_date ,

Line 482: x_disbursement_cancel_date => rec_c_igf_sl_clchsn_dtls.disbursement_cancel_date ,

478: x_new_amt => rec_c_igf_sl_clchsn_dtls.new_amt ,
479: x_disbursement_number => rec_c_igf_sl_clchsn_dtls.disbursement_number ,
480: x_disbursement_date => rec_c_igf_sl_clchsn_dtls.disbursement_date ,
481: x_change_issue_code => rec_c_igf_sl_clchsn_dtls.change_issue_code ,
482: x_disbursement_cancel_date => rec_c_igf_sl_clchsn_dtls.disbursement_cancel_date ,
483: x_disbursement_cancel_amt => rec_c_igf_sl_clchsn_dtls.disbursement_cancel_amt ,
484: x_disbursement_revised_amt => rec_c_igf_sl_clchsn_dtls.disbursement_revised_amt ,
485: x_disbursement_revised_date => rec_c_igf_sl_clchsn_dtls.disbursement_revised_date ,
486: x_disbursement_reissue_code => rec_c_igf_sl_clchsn_dtls.disbursement_reissue_code ,

Line 483: x_disbursement_cancel_amt => rec_c_igf_sl_clchsn_dtls.disbursement_cancel_amt ,

479: x_disbursement_number => rec_c_igf_sl_clchsn_dtls.disbursement_number ,
480: x_disbursement_date => rec_c_igf_sl_clchsn_dtls.disbursement_date ,
481: x_change_issue_code => rec_c_igf_sl_clchsn_dtls.change_issue_code ,
482: x_disbursement_cancel_date => rec_c_igf_sl_clchsn_dtls.disbursement_cancel_date ,
483: x_disbursement_cancel_amt => rec_c_igf_sl_clchsn_dtls.disbursement_cancel_amt ,
484: x_disbursement_revised_amt => rec_c_igf_sl_clchsn_dtls.disbursement_revised_amt ,
485: x_disbursement_revised_date => rec_c_igf_sl_clchsn_dtls.disbursement_revised_date ,
486: x_disbursement_reissue_code => rec_c_igf_sl_clchsn_dtls.disbursement_reissue_code ,
487: x_disbursement_reinst_code => rec_c_igf_sl_clchsn_dtls.disbursement_reinst_code ,

Line 484: x_disbursement_revised_amt => rec_c_igf_sl_clchsn_dtls.disbursement_revised_amt ,

480: x_disbursement_date => rec_c_igf_sl_clchsn_dtls.disbursement_date ,
481: x_change_issue_code => rec_c_igf_sl_clchsn_dtls.change_issue_code ,
482: x_disbursement_cancel_date => rec_c_igf_sl_clchsn_dtls.disbursement_cancel_date ,
483: x_disbursement_cancel_amt => rec_c_igf_sl_clchsn_dtls.disbursement_cancel_amt ,
484: x_disbursement_revised_amt => rec_c_igf_sl_clchsn_dtls.disbursement_revised_amt ,
485: x_disbursement_revised_date => rec_c_igf_sl_clchsn_dtls.disbursement_revised_date ,
486: x_disbursement_reissue_code => rec_c_igf_sl_clchsn_dtls.disbursement_reissue_code ,
487: x_disbursement_reinst_code => rec_c_igf_sl_clchsn_dtls.disbursement_reinst_code ,
488: x_disbursement_return_amt => rec_c_igf_sl_clchsn_dtls.disbursement_return_amt ,

Line 485: x_disbursement_revised_date => rec_c_igf_sl_clchsn_dtls.disbursement_revised_date ,

481: x_change_issue_code => rec_c_igf_sl_clchsn_dtls.change_issue_code ,
482: x_disbursement_cancel_date => rec_c_igf_sl_clchsn_dtls.disbursement_cancel_date ,
483: x_disbursement_cancel_amt => rec_c_igf_sl_clchsn_dtls.disbursement_cancel_amt ,
484: x_disbursement_revised_amt => rec_c_igf_sl_clchsn_dtls.disbursement_revised_amt ,
485: x_disbursement_revised_date => rec_c_igf_sl_clchsn_dtls.disbursement_revised_date ,
486: x_disbursement_reissue_code => rec_c_igf_sl_clchsn_dtls.disbursement_reissue_code ,
487: x_disbursement_reinst_code => rec_c_igf_sl_clchsn_dtls.disbursement_reinst_code ,
488: x_disbursement_return_amt => rec_c_igf_sl_clchsn_dtls.disbursement_return_amt ,
489: x_disbursement_return_date => rec_c_igf_sl_clchsn_dtls.disbursement_return_date ,

Line 486: x_disbursement_reissue_code => rec_c_igf_sl_clchsn_dtls.disbursement_reissue_code ,

482: x_disbursement_cancel_date => rec_c_igf_sl_clchsn_dtls.disbursement_cancel_date ,
483: x_disbursement_cancel_amt => rec_c_igf_sl_clchsn_dtls.disbursement_cancel_amt ,
484: x_disbursement_revised_amt => rec_c_igf_sl_clchsn_dtls.disbursement_revised_amt ,
485: x_disbursement_revised_date => rec_c_igf_sl_clchsn_dtls.disbursement_revised_date ,
486: x_disbursement_reissue_code => rec_c_igf_sl_clchsn_dtls.disbursement_reissue_code ,
487: x_disbursement_reinst_code => rec_c_igf_sl_clchsn_dtls.disbursement_reinst_code ,
488: x_disbursement_return_amt => rec_c_igf_sl_clchsn_dtls.disbursement_return_amt ,
489: x_disbursement_return_date => rec_c_igf_sl_clchsn_dtls.disbursement_return_date ,
490: x_disbursement_return_code => rec_c_igf_sl_clchsn_dtls.disbursement_return_code ,

Line 487: x_disbursement_reinst_code => rec_c_igf_sl_clchsn_dtls.disbursement_reinst_code ,

483: x_disbursement_cancel_amt => rec_c_igf_sl_clchsn_dtls.disbursement_cancel_amt ,
484: x_disbursement_revised_amt => rec_c_igf_sl_clchsn_dtls.disbursement_revised_amt ,
485: x_disbursement_revised_date => rec_c_igf_sl_clchsn_dtls.disbursement_revised_date ,
486: x_disbursement_reissue_code => rec_c_igf_sl_clchsn_dtls.disbursement_reissue_code ,
487: x_disbursement_reinst_code => rec_c_igf_sl_clchsn_dtls.disbursement_reinst_code ,
488: x_disbursement_return_amt => rec_c_igf_sl_clchsn_dtls.disbursement_return_amt ,
489: x_disbursement_return_date => rec_c_igf_sl_clchsn_dtls.disbursement_return_date ,
490: x_disbursement_return_code => rec_c_igf_sl_clchsn_dtls.disbursement_return_code ,
491: x_post_with_disb_return_amt => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_amt ,

Line 488: x_disbursement_return_amt => rec_c_igf_sl_clchsn_dtls.disbursement_return_amt ,

484: x_disbursement_revised_amt => rec_c_igf_sl_clchsn_dtls.disbursement_revised_amt ,
485: x_disbursement_revised_date => rec_c_igf_sl_clchsn_dtls.disbursement_revised_date ,
486: x_disbursement_reissue_code => rec_c_igf_sl_clchsn_dtls.disbursement_reissue_code ,
487: x_disbursement_reinst_code => rec_c_igf_sl_clchsn_dtls.disbursement_reinst_code ,
488: x_disbursement_return_amt => rec_c_igf_sl_clchsn_dtls.disbursement_return_amt ,
489: x_disbursement_return_date => rec_c_igf_sl_clchsn_dtls.disbursement_return_date ,
490: x_disbursement_return_code => rec_c_igf_sl_clchsn_dtls.disbursement_return_code ,
491: x_post_with_disb_return_amt => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_amt ,
492: x_post_with_disb_return_date => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_date ,

Line 489: x_disbursement_return_date => rec_c_igf_sl_clchsn_dtls.disbursement_return_date ,

485: x_disbursement_revised_date => rec_c_igf_sl_clchsn_dtls.disbursement_revised_date ,
486: x_disbursement_reissue_code => rec_c_igf_sl_clchsn_dtls.disbursement_reissue_code ,
487: x_disbursement_reinst_code => rec_c_igf_sl_clchsn_dtls.disbursement_reinst_code ,
488: x_disbursement_return_amt => rec_c_igf_sl_clchsn_dtls.disbursement_return_amt ,
489: x_disbursement_return_date => rec_c_igf_sl_clchsn_dtls.disbursement_return_date ,
490: x_disbursement_return_code => rec_c_igf_sl_clchsn_dtls.disbursement_return_code ,
491: x_post_with_disb_return_amt => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_amt ,
492: x_post_with_disb_return_date => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_date ,
493: x_post_with_disb_return_code => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_code ,

Line 490: x_disbursement_return_code => rec_c_igf_sl_clchsn_dtls.disbursement_return_code ,

486: x_disbursement_reissue_code => rec_c_igf_sl_clchsn_dtls.disbursement_reissue_code ,
487: x_disbursement_reinst_code => rec_c_igf_sl_clchsn_dtls.disbursement_reinst_code ,
488: x_disbursement_return_amt => rec_c_igf_sl_clchsn_dtls.disbursement_return_amt ,
489: x_disbursement_return_date => rec_c_igf_sl_clchsn_dtls.disbursement_return_date ,
490: x_disbursement_return_code => rec_c_igf_sl_clchsn_dtls.disbursement_return_code ,
491: x_post_with_disb_return_amt => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_amt ,
492: x_post_with_disb_return_date => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_date ,
493: x_post_with_disb_return_code => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_code ,
494: x_prev_with_disb_return_amt => rec_c_igf_sl_clchsn_dtls.prev_with_disb_return_amt ,

Line 491: x_post_with_disb_return_amt => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_amt ,

487: x_disbursement_reinst_code => rec_c_igf_sl_clchsn_dtls.disbursement_reinst_code ,
488: x_disbursement_return_amt => rec_c_igf_sl_clchsn_dtls.disbursement_return_amt ,
489: x_disbursement_return_date => rec_c_igf_sl_clchsn_dtls.disbursement_return_date ,
490: x_disbursement_return_code => rec_c_igf_sl_clchsn_dtls.disbursement_return_code ,
491: x_post_with_disb_return_amt => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_amt ,
492: x_post_with_disb_return_date => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_date ,
493: x_post_with_disb_return_code => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_code ,
494: x_prev_with_disb_return_amt => rec_c_igf_sl_clchsn_dtls.prev_with_disb_return_amt ,
495: x_prev_with_disb_return_date => rec_c_igf_sl_clchsn_dtls.prev_with_disb_return_date ,

Line 492: x_post_with_disb_return_date => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_date ,

488: x_disbursement_return_amt => rec_c_igf_sl_clchsn_dtls.disbursement_return_amt ,
489: x_disbursement_return_date => rec_c_igf_sl_clchsn_dtls.disbursement_return_date ,
490: x_disbursement_return_code => rec_c_igf_sl_clchsn_dtls.disbursement_return_code ,
491: x_post_with_disb_return_amt => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_amt ,
492: x_post_with_disb_return_date => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_date ,
493: x_post_with_disb_return_code => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_code ,
494: x_prev_with_disb_return_amt => rec_c_igf_sl_clchsn_dtls.prev_with_disb_return_amt ,
495: x_prev_with_disb_return_date => rec_c_igf_sl_clchsn_dtls.prev_with_disb_return_date ,
496: x_school_use_txt => rec_c_igf_sl_clchsn_dtls.school_use_txt ,

Line 493: x_post_with_disb_return_code => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_code ,

489: x_disbursement_return_date => rec_c_igf_sl_clchsn_dtls.disbursement_return_date ,
490: x_disbursement_return_code => rec_c_igf_sl_clchsn_dtls.disbursement_return_code ,
491: x_post_with_disb_return_amt => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_amt ,
492: x_post_with_disb_return_date => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_date ,
493: x_post_with_disb_return_code => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_code ,
494: x_prev_with_disb_return_amt => rec_c_igf_sl_clchsn_dtls.prev_with_disb_return_amt ,
495: x_prev_with_disb_return_date => rec_c_igf_sl_clchsn_dtls.prev_with_disb_return_date ,
496: x_school_use_txt => rec_c_igf_sl_clchsn_dtls.school_use_txt ,
497: x_lender_use_txt => rec_c_igf_sl_clchsn_dtls.lender_use_txt ,

Line 494: x_prev_with_disb_return_amt => rec_c_igf_sl_clchsn_dtls.prev_with_disb_return_amt ,

490: x_disbursement_return_code => rec_c_igf_sl_clchsn_dtls.disbursement_return_code ,
491: x_post_with_disb_return_amt => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_amt ,
492: x_post_with_disb_return_date => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_date ,
493: x_post_with_disb_return_code => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_code ,
494: x_prev_with_disb_return_amt => rec_c_igf_sl_clchsn_dtls.prev_with_disb_return_amt ,
495: x_prev_with_disb_return_date => rec_c_igf_sl_clchsn_dtls.prev_with_disb_return_date ,
496: x_school_use_txt => rec_c_igf_sl_clchsn_dtls.school_use_txt ,
497: x_lender_use_txt => rec_c_igf_sl_clchsn_dtls.lender_use_txt ,
498: x_guarantor_use_txt => rec_c_igf_sl_clchsn_dtls.guarantor_use_txt ,

Line 495: x_prev_with_disb_return_date => rec_c_igf_sl_clchsn_dtls.prev_with_disb_return_date ,

491: x_post_with_disb_return_amt => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_amt ,
492: x_post_with_disb_return_date => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_date ,
493: x_post_with_disb_return_code => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_code ,
494: x_prev_with_disb_return_amt => rec_c_igf_sl_clchsn_dtls.prev_with_disb_return_amt ,
495: x_prev_with_disb_return_date => rec_c_igf_sl_clchsn_dtls.prev_with_disb_return_date ,
496: x_school_use_txt => rec_c_igf_sl_clchsn_dtls.school_use_txt ,
497: x_lender_use_txt => rec_c_igf_sl_clchsn_dtls.lender_use_txt ,
498: x_guarantor_use_txt => rec_c_igf_sl_clchsn_dtls.guarantor_use_txt ,
499: x_validation_edit_txt => NULL ,

Line 496: x_school_use_txt => rec_c_igf_sl_clchsn_dtls.school_use_txt ,

492: x_post_with_disb_return_date => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_date ,
493: x_post_with_disb_return_code => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_code ,
494: x_prev_with_disb_return_amt => rec_c_igf_sl_clchsn_dtls.prev_with_disb_return_amt ,
495: x_prev_with_disb_return_date => rec_c_igf_sl_clchsn_dtls.prev_with_disb_return_date ,
496: x_school_use_txt => rec_c_igf_sl_clchsn_dtls.school_use_txt ,
497: x_lender_use_txt => rec_c_igf_sl_clchsn_dtls.lender_use_txt ,
498: x_guarantor_use_txt => rec_c_igf_sl_clchsn_dtls.guarantor_use_txt ,
499: x_validation_edit_txt => NULL ,
500: x_send_record_txt => rec_c_igf_sl_clchsn_dtls.send_record_txt ,

Line 497: x_lender_use_txt => rec_c_igf_sl_clchsn_dtls.lender_use_txt ,

493: x_post_with_disb_return_code => rec_c_igf_sl_clchsn_dtls.post_with_disb_return_code ,
494: x_prev_with_disb_return_amt => rec_c_igf_sl_clchsn_dtls.prev_with_disb_return_amt ,
495: x_prev_with_disb_return_date => rec_c_igf_sl_clchsn_dtls.prev_with_disb_return_date ,
496: x_school_use_txt => rec_c_igf_sl_clchsn_dtls.school_use_txt ,
497: x_lender_use_txt => rec_c_igf_sl_clchsn_dtls.lender_use_txt ,
498: x_guarantor_use_txt => rec_c_igf_sl_clchsn_dtls.guarantor_use_txt ,
499: x_validation_edit_txt => NULL ,
500: x_send_record_txt => rec_c_igf_sl_clchsn_dtls.send_record_txt ,
501: x_mode => 'R'

Line 498: x_guarantor_use_txt => rec_c_igf_sl_clchsn_dtls.guarantor_use_txt ,

494: x_prev_with_disb_return_amt => rec_c_igf_sl_clchsn_dtls.prev_with_disb_return_amt ,
495: x_prev_with_disb_return_date => rec_c_igf_sl_clchsn_dtls.prev_with_disb_return_date ,
496: x_school_use_txt => rec_c_igf_sl_clchsn_dtls.school_use_txt ,
497: x_lender_use_txt => rec_c_igf_sl_clchsn_dtls.lender_use_txt ,
498: x_guarantor_use_txt => rec_c_igf_sl_clchsn_dtls.guarantor_use_txt ,
499: x_validation_edit_txt => NULL ,
500: x_send_record_txt => rec_c_igf_sl_clchsn_dtls.send_record_txt ,
501: x_mode => 'R'
502: );

Line 500: x_send_record_txt => rec_c_igf_sl_clchsn_dtls.send_record_txt ,

496: x_school_use_txt => rec_c_igf_sl_clchsn_dtls.school_use_txt ,
497: x_lender_use_txt => rec_c_igf_sl_clchsn_dtls.lender_use_txt ,
498: x_guarantor_use_txt => rec_c_igf_sl_clchsn_dtls.guarantor_use_txt ,
499: x_validation_edit_txt => NULL ,
500: x_send_record_txt => rec_c_igf_sl_clchsn_dtls.send_record_txt ,
501: x_mode => 'R'
502: );
503: END LOOP; -- end of "FOR rec_c_igf_sl_clchsn_dtls" ....
504: END IF; -- end of "IF (l_v_fed_fund_code IN" ....

Line 503: END LOOP; -- end of "FOR rec_c_igf_sl_clchsn_dtls" ....

499: x_validation_edit_txt => NULL ,
500: x_send_record_txt => rec_c_igf_sl_clchsn_dtls.send_record_txt ,
501: x_mode => 'R'
502: );
503: END LOOP; -- end of "FOR rec_c_igf_sl_clchsn_dtls" ....
504: END IF; -- end of "IF (l_v_fed_fund_code IN" ....
505: END IF;
506: END IF; -- IF DLP OR DLU or DLS OR FLS or FLP ......
507: END IF; -- IF p_updating