APPS.IGF_SL_DL_CHG_ORIG dependencies on IGF_SL_LOANS

Line 94: agairola 19-Mar-2002 Modifed the update row call of the IGF_SL_LOANS_PKG to include

90: Who When What
91: mesriniv 20-MAR-2002 Added Code to SKIP LOAN when an error occurs
92:
93: Who When What
94: agairola 19-Mar-2002 Modifed the update row call of the IGF_SL_LOANS_PKG to include
95: Borrower determination as part of Refunds DLD - 2144600
96:
97:
98: (reverse chronological order - newest change first)

Line 160: p_loan_status igf_sl_loans.loan_status%TYPE,

156: p_cal_type igs_ca_inst.cal_type%TYPE,
157: p_seq_num igs_ca_inst.sequence_number%TYPE,
158: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
159: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
160: p_loan_status igf_sl_loans.loan_status%TYPE,
161: p_loan_chg_status igf_sl_loans.loan_chg_status%TYPE,
162: p_active igf_sl_loans.active%TYPE
163: ) IS
164: SELECT

Line 161: p_loan_chg_status igf_sl_loans.loan_chg_status%TYPE,

157: p_seq_num igs_ca_inst.sequence_number%TYPE,
158: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
159: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
160: p_loan_status igf_sl_loans.loan_status%TYPE,
161: p_loan_chg_status igf_sl_loans.loan_chg_status%TYPE,
162: p_active igf_sl_loans.active%TYPE
163: ) IS
164: SELECT
165: loans.row_id,

Line 162: p_active igf_sl_loans.active%TYPE

158: p_fed_fund_1 igf_aw_fund_cat.fed_fund_code%TYPE,
159: p_fed_fund_2 igf_aw_fund_cat.fed_fund_code%TYPE,
160: p_loan_status igf_sl_loans.loan_status%TYPE,
161: p_loan_chg_status igf_sl_loans.loan_chg_status%TYPE,
162: p_active igf_sl_loans.active%TYPE
163: ) IS
164: SELECT
165: loans.row_id,
166: loans.loan_id,

Line 188: igf_sl_loans loans,

184: fabase.base_id,
185: fabase.person_id student_id,
186: awd.accepted_amt
187: FROM
188: igf_sl_loans loans,
189: igf_sl_lor lor,
190: igf_aw_award awd,
191: igf_aw_fund_mast fmast,
192: igf_aw_fund_cat fcat,

Line 209: l_loan_number igf_sl_loans.loan_number%TYPE := NULL ;

205: loans.active = p_active AND
206: substr(loans.loan_number, 13, 6) = p_school_code;
207:
208: -- masehgal # 2593215 define variables to be used in the call to get_acad_cal_dtls
209: l_loan_number igf_sl_loans.loan_number%TYPE := NULL ;
210: lv_acad_cal_type igs_ca_inst.cal_type%TYPE := NULL ;
211: lv_acad_seq_num igs_ca_inst.sequence_number%TYPE := NULL ;
212: lv_message VARCHAR2(100) := NULL ;
213:

Line 955: -- ## Update LOAN_STATUS, LOAN_STATUS_DATE to SENT, Current Date In IGF_SL_LOANS TABLE

951:
952: END LOOP;
953: END IF;
954:
955: -- ## Update LOAN_STATUS, LOAN_STATUS_DATE to SENT, Current Date In IGF_SL_LOANS TABLE
956:
957: IF lc_chg_flag='Y' or lc_disb_chg_flag='Y' THEN
958: DECLARE
959: lv_row_id VARCHAR2(25);

Line 961: SELECT igf_sl_loans.* FROM igf_sl_loans

957: IF lc_chg_flag='Y' or lc_disb_chg_flag='Y' THEN
958: DECLARE
959: lv_row_id VARCHAR2(25);
960: CURSOR c_tbh_cur IS
961: SELECT igf_sl_loans.* FROM igf_sl_loans
962: WHERE loan_id =lc_lor.loan_id;
963: BEGIN
964:
965: FOR tbh_rec in c_tbh_cur LOOP

Line 968: -- Modified the update row call of the IGF_SL_LOANS_PKG package to include Borrower

964:
965: FOR tbh_rec in c_tbh_cur LOOP
966:
967: -- ## Update the Loan Change Status as Sent and Loan Change status date as the current date
968: -- Modified the update row call of the IGF_SL_LOANS_PKG package to include Borrower
969: -- determination as part of Refunds DLD - 2144600
970: igf_sl_loans_pkg.update_row (
971: x_Mode => 'R',
972: x_rowid => tbh_rec.row_id,

Line 970: igf_sl_loans_pkg.update_row (

966:
967: -- ## Update the Loan Change Status as Sent and Loan Change status date as the current date
968: -- Modified the update row call of the IGF_SL_LOANS_PKG package to include Borrower
969: -- determination as part of Refunds DLD - 2144600
970: igf_sl_loans_pkg.update_row (
971: x_Mode => 'R',
972: x_rowid => tbh_rec.row_id,
973: x_loan_id => lc_lor.loan_id,
974: x_award_id => tbh_rec.award_id,