DBA Data[Home] [Help]

APPS.IGF_SL_DL_ORIG_ACK dependencies on IGF_SL_GEN

Line 216: igf_sl_gen.get_dl_batch_details(l_rec_message_class,

212: -- Check whether the File is valid/Not. (ie whether any wrong file is used)
213: -- File can be Origination Response For Stafford/PLUS OR a Credit Response.
214: -- Also, Check if the file is an OUTPUT File.
215: --
216: igf_sl_gen.get_dl_batch_details(l_rec_message_class,
217: l_rec_batch_type,
218: l_dl_version,
219: l_dl_file_type,
220: l_dl_loan_catg);

Line 1062: IF igf_sl_gen.chk_dl_stafford(lar_rec.fed_fund_code) = 'TRUE' THEN

1058: -- Set the Loan Status and Loan Status Date to existing values
1059: g_lor_loc_rec.loan_status := lar_rec.loan_status;
1060: g_lor_loc_rec.loan_status_date := lar_rec.loan_status_date;
1061:
1062: IF igf_sl_gen.chk_dl_stafford(lar_rec.fed_fund_code) = 'TRUE' THEN
1063: IF tbh_rec.orig_status_flag = 'A' THEN -- Orgination Accepted
1064: l_loan_status := 'A'; -- Loan is Accepted
1065: l_loan_status_dt := TRUNC(SYSDATE);
1066: l_update_loan := 'Y';

Line 1072: ELSIF igf_sl_gen.chk_dl_plus(lar_rec.fed_fund_code) = 'TRUE' THEN

1068: l_loan_status := 'R'; -- Loan is Rejected
1069: l_loan_status_dt := TRUNC(SYSDATE);
1070: l_update_loan := 'Y';
1071: END IF;
1072: ELSIF igf_sl_gen.chk_dl_plus(lar_rec.fed_fund_code) = 'TRUE' THEN
1073: IF tbh_rec.orig_status_flag IN ('X','C') THEN -- Origination Accepted, Credit Accepted
1074: l_loan_status := 'A'; -- Loan is Accepted
1075: ELSIF tbh_rec.orig_status_flag IN ('B','D') THEN -- Orig Rejected OR Orig Accept,Credit Denied
1076: l_loan_status := 'R'; -- Loan is Rejected