APPS.IGF_SL_LOR_PKG dependencies on IGF_SL_LOANS

Line 314: CURSOR c_igf_sl_loans(cp_n_loan_id igf_sl_loans.loan_id%TYPE) IS

310: || Who When What
311: || bvisvana 02-Mar-2006 Bug# 5006583, FA161 CL4. modified condition for g_v_called_from in ('IGFSL007',' UPDATE_MODE')
312: || (reverse chronological order - newest change first)
313: --------------------------------------------------------------------*/
314: CURSOR c_igf_sl_loans(cp_n_loan_id igf_sl_loans.loan_id%TYPE) IS
315: SELECT award_id
316: FROM igf_sl_loans_all
317: WHERE loan_id = cp_n_loan_id;
318:

Line 316: FROM igf_sl_loans_all

312: || (reverse chronological order - newest change first)
313: --------------------------------------------------------------------*/
314: CURSOR c_igf_sl_loans(cp_n_loan_id igf_sl_loans.loan_id%TYPE) IS
315: SELECT award_id
316: FROM igf_sl_loans_all
317: WHERE loan_id = cp_n_loan_id;
318:
319: l_n_award_id igf_aw_award_all.award_id%TYPE;
320: l_v_fed_fund_code igf_aw_fund_cat_all.fed_fund_code%TYPE;

Line 326: OPEN c_igf_sl_loans (cp_n_loan_id => new_references.loan_id);

322: l_b_return_status BOOLEAN;
323: l_null_date_check DATE;
324: BEGIN
325: IF p_updating THEN
326: OPEN c_igf_sl_loans (cp_n_loan_id => new_references.loan_id);
327: FETCH c_igf_sl_loans INTO l_n_award_id;
328: CLOSE c_igf_sl_loans ;
329: l_v_fed_fund_code := igf_sl_gen.get_fed_fund_code (p_n_award_id => l_n_award_id,
330: p_v_message_name => l_v_message_name

Line 327: FETCH c_igf_sl_loans INTO l_n_award_id;

323: l_null_date_check DATE;
324: BEGIN
325: IF p_updating THEN
326: OPEN c_igf_sl_loans (cp_n_loan_id => new_references.loan_id);
327: FETCH c_igf_sl_loans INTO l_n_award_id;
328: CLOSE c_igf_sl_loans ;
329: l_v_fed_fund_code := igf_sl_gen.get_fed_fund_code (p_n_award_id => l_n_award_id,
330: p_v_message_name => l_v_message_name
331: );

Line 328: CLOSE c_igf_sl_loans ;

324: BEGIN
325: IF p_updating THEN
326: OPEN c_igf_sl_loans (cp_n_loan_id => new_references.loan_id);
327: FETCH c_igf_sl_loans INTO l_n_award_id;
328: CLOSE c_igf_sl_loans ;
329: l_v_fed_fund_code := igf_sl_gen.get_fed_fund_code (p_n_award_id => l_n_award_id,
330: p_v_message_name => l_v_message_name
331: );
332: IF l_v_message_name IS NOT NULL THEN

Line 418: ELSIF NOT igf_sl_loans_pkg.get_pk_for_validation (

414:
415: IF (((old_references.loan_id = new_references.loan_id)) OR
416: ((new_references.loan_id IS NULL))) THEN
417: NULL;
418: ELSIF NOT igf_sl_loans_pkg.get_pk_for_validation (
419: new_references.loan_id
420: ) THEN
421: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
422: igs_ge_msg_stack.add;

Line 581: PROCEDURE get_fk_igf_sl_loans (

577:
578: END get_fk_hz_parties;
579:
580:
581: PROCEDURE get_fk_igf_sl_loans (
582: x_loan_id IN NUMBER
583: ) AS
584: /*
585: || Created By : venagara

Line 613: END get_fk_igf_sl_loans;

609: RETURN;
610: END IF;
611: CLOSE cur_rowid;
612:
613: END get_fk_igf_sl_loans;
614:
615:
616: PROCEDURE get_fk_igf_sl_cl_recipient (
617: x_relationship_cd IN VARCHAR2