APPS.IGF_SL_DL_ORIG_ACK dependencies on IGF_SL_LOANS

Line 107: PROCEDURE upd_lor_record(p_loan_number IN igf_sl_loans.loan_number%TYPE,

103: file_not_loaded EXCEPTION;
104: yr_full_participant EXCEPTION;
105:
106: -- FORWARD DECLARATION OF PRIVATE PROCEDURES
107: PROCEDURE upd_lor_record(p_loan_number IN igf_sl_loans.loan_number%TYPE,
108: p_process IN VARCHAR2,
109: p_rec_present OUT NOCOPY VARCHAR2,
110: p_rec_updated OUT NOCOPY VARCHAR2 );
111: PROCEDURE upd_lor_loc_record(p_loan_id igf_sl_lor.loan_id%TYPE, p_process VARCHAR2);

Line 778: PROCEDURE upd_lor_record(p_loan_number IN igf_sl_loans.loan_number%TYPE,

774: END dl_orig_ack;
775:
776:
777:
778: PROCEDURE upd_lor_record(p_loan_number IN igf_sl_loans.loan_number%TYPE,
779: p_process IN VARCHAR2,
780: p_rec_present OUT NOCOPY VARCHAR2,
781: p_rec_updated OUT NOCOPY VARCHAR2 )
782: AS

Line 814: agairola 15-MAR-2002 Modified the Update Row call of the IGF_SL_LOANS_PKG

810: cl_rec_status,mpn_confirm_code,appl_loan_phase_code_chg,appl_loan_phase_code,
811: p_ssn_chg_date,p_dob_chg_date,s_ssn_chg_date,s_dob_chg_date,s_local_addr_chg_date,
812: chg_batch_id from igf_sl_lor_loc
813:
814: agairola 15-MAR-2002 Modified the Update Row call of the IGF_SL_LOANS_PKG
815: added as part of the Refunds DLD - 2144600
816: rboddu 18/05/2001 uploaded pnote_id field of IGF_SL_DL_LOR_RESP table into
817: pnote_mpn_ind field of IGF_SL_LOR table.
818: If School is configured to print then the pnote_status

Line 829: WHERE loan_id = (SELECT loan_id FROM igf_sl_loans lar

825: l_print_opt igf_sl_dl_setup.pnote_print_ind%TYPE;
826:
827: CURSOR c_tbh_cur IS
828: SELECT igf_sl_lor.* FROM igf_sl_lor
829: WHERE loan_id = (SELECT loan_id FROM igf_sl_loans lar
830: WHERE loan_number = p_loan_number)
831: FOR UPDATE OF igf_sl_lor.sch_cert_date NOWAIT;
832:
833: CURSOR c_lar_cur(c_loan_id igf_sl_loans.loan_id%TYPE)

Line 833: CURSOR c_lar_cur(c_loan_id igf_sl_loans.loan_id%TYPE)

829: WHERE loan_id = (SELECT loan_id FROM igf_sl_loans lar
830: WHERE loan_number = p_loan_number)
831: FOR UPDATE OF igf_sl_lor.sch_cert_date NOWAIT;
832:
833: CURSOR c_lar_cur(c_loan_id igf_sl_loans.loan_id%TYPE)
834: IS
835: SELECT loan.rowid row_id,
836: loan.*,
837: fcat.fed_fund_code

Line 838: FROM igf_sl_loans_all loan,

834: IS
835: SELECT loan.rowid row_id,
836: loan.*,
837: fcat.fed_fund_code
838: FROM igf_sl_loans_all loan,
839: igf_aw_award_all awd,
840: igf_aw_fund_mast_all fmast,
841: igf_aw_fund_cat_all fcat
842: WHERE

Line 858: FROM igf_sl_loans loans,

854: FROM
855: igf_sl_dl_setup
856: WHERE (ci_cal_type,ci_sequence_number) = ( SELECT fmast.ci_cal_type,
857: fmast.ci_sequence_number
858: FROM igf_sl_loans loans,
859: igf_aw_award awd,
860: igf_aw_fund_mast fmast
861: WHERE loans.loan_number = p_loan_number
862: AND loans.award_id = awd.award_id

Line 1054: l_loan_status_dt igf_sl_loans.loan_status_date%TYPE;

1050: RAISE NO_DATA_FOUND;
1051: END IF;
1052: DECLARE
1053: l_update_loan VARCHAR2(30) DEFAULT 'N';
1054: l_loan_status_dt igf_sl_loans.loan_status_date%TYPE;
1055: l_loan_status igf_sl_loans.loan_status%TYPE;
1056: BEGIN
1057:
1058: -- Set the Loan Status and Loan Status Date to existing values

Line 1055: l_loan_status igf_sl_loans.loan_status%TYPE;

1051: END IF;
1052: DECLARE
1053: l_update_loan VARCHAR2(30) DEFAULT 'N';
1054: l_loan_status_dt igf_sl_loans.loan_status_date%TYPE;
1055: l_loan_status igf_sl_loans.loan_status%TYPE;
1056: BEGIN
1057:
1058: -- Set the Loan Status and Loan Status Date to existing values
1059: g_lor_loc_rec.loan_status := lar_rec.loan_status;

Line 1095: igf_sl_loans_pkg.update_row (

1091: g_lor_loc_rec.loan_status_date := l_loan_status_dt;
1092:
1093: -- Modified the Update Row call to include the Borrower Determination
1094: -- added as part of Refunds DLD - 2144600
1095: igf_sl_loans_pkg.update_row (
1096: x_mode => 'R',
1097: x_rowid => lar_rec.row_id,
1098: x_loan_id => lar_rec.loan_id,
1099: x_award_id => lar_rec.award_id,