APPS.IGF_SL_CLCHSN_DTLS_PKG dependencies on IGF_SL_LOANS

Line 168: PROCEDURE update_loan_change_status(p_loan_number igf_sl_loans.loan_number%TYPE)

164: new_references.last_update_login := x_last_update_login;
165:
166: END set_column_values;
167:
168: PROCEDURE update_loan_change_status(p_loan_number igf_sl_loans.loan_number%TYPE)
169: /*
170: || Created By : bvisvana
171: || Created On : 13-Sep-2005
172: || Purpose : Bug # 4575843 - Updating the loan change status each time the disbursement is INSERTED or UPDATED

Line 181: CURSOR cur_loans(cp_loan_number igf_sl_loans.loan_number%TYPE) IS

177: || (reverse chronological order - newest change first)
178: */
179:
180: AS
181: CURSOR cur_loans(cp_loan_number igf_sl_loans.loan_number%TYPE) IS
182: SELECT igf_sl_loans.* FROM igf_sl_loans
183: WHERE NVL(external_loan_id_txt,loan_number) = cp_loan_number ;
184: loan_rec cur_loans%ROWTYPE;
185:

Line 182: SELECT igf_sl_loans.* FROM igf_sl_loans

178: */
179:
180: AS
181: CURSOR cur_loans(cp_loan_number igf_sl_loans.loan_number%TYPE) IS
182: SELECT igf_sl_loans.* FROM igf_sl_loans
183: WHERE NVL(external_loan_id_txt,loan_number) = cp_loan_number ;
184: loan_rec cur_loans%ROWTYPE;
185:
186: CURSOR cur_chng_dtls(cp_loan_number igf_sl_loans.loan_number%TYPE) IS

Line 186: CURSOR cur_chng_dtls(cp_loan_number igf_sl_loans.loan_number%TYPE) IS

182: SELECT igf_sl_loans.* FROM igf_sl_loans
183: WHERE NVL(external_loan_id_txt,loan_number) = cp_loan_number ;
184: loan_rec cur_loans%ROWTYPE;
185:
186: CURSOR cur_chng_dtls(cp_loan_number igf_sl_loans.loan_number%TYPE) IS
187: SELECT 'N' FROM igf_sl_clchsn_dtls WHERE loan_number_txt = cp_loan_number AND
188: status_code = 'N';
189: chng_dtls_rec cur_chng_dtls%ROWTYPE;
190:

Line 206: igf_sl_loans_pkg.update_row (

202: CLOSE cur_chng_dtls;
203:
204: OPEN cur_loans(cp_loan_number => p_loan_number);
205: FETCH cur_loans INTO loan_rec;
206: igf_sl_loans_pkg.update_row (
207: X_Mode => 'R',
208: x_rowid => loan_rec.row_id,
209: x_loan_id => loan_rec.loan_id,
210: x_award_id => loan_rec.award_id,

Line 259: ELSIF NOT igf_sl_loans_pkg.get_uk_for_validation (

255: IF ((old_references.loan_number_txt = new_references.loan_number_txt))
256: OR
257: ((new_references.loan_number_txt IS NULL)) THEN
258: NULL;
259: ELSIF NOT igf_sl_loans_pkg.get_uk_for_validation (
260: x_loan_number => new_references.loan_number_txt
261: ) THEN
262: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED2');
263: igs_ge_msg_stack.add;

Line 303: PROCEDURE get_ufk_igf_sl_loans (

299: END IF;
300:
301: END get_pk_for_validation;
302:
303: PROCEDURE get_ufk_igf_sl_loans (
304: x_loan_number IN VARCHAR2
305: ) AS
306: /*
307: || Created By : [email protected]

Line 335: END get_ufk_igf_sl_loans;

331: RETURN;
332: END IF;
333: CLOSE cur_rowid;
334:
335: END get_ufk_igf_sl_loans;
336:
337: PROCEDURE before_dml (
338: p_action IN VARCHAR2,
339: x_rowid IN VARCHAR2,