APPS.IGF_SL_CL_LI_IMP_PKG dependencies on IGF_SL_LOANS

Line 3510: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','igf_sl_loans ROWID ' || p_rowid);

3506:
3507: END IF;
3508:
3509: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3510: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','igf_sl_loans ROWID ' || p_rowid);
3511: END IF;
3512: igf_sl_loans_pkg.delete_row(p_rowid);
3513:
3514: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 3512: igf_sl_loans_pkg.delete_row(p_rowid);

3508:
3509: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3510: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','igf_sl_loans ROWID ' || p_rowid);
3511: END IF;
3512: igf_sl_loans_pkg.delete_row(p_rowid);
3513:
3514: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3515: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.delete_record.debug','Deletion Complete');
3516: END IF;

Line 3607: ln_loan_id igf_sl_loans.loan_id%TYPE;

3603: l_b_default_status VARCHAR2(30);
3604: l_b_license_state VARCHAR2(30);
3605: l_b_license_number VARCHAR2(30);
3606:
3607: ln_loan_id igf_sl_loans.loan_id%TYPE;
3608: ln_albw_id igf_sl_alt_borw_all.albw_id%TYPE;
3609: ln_origination_id igf_sl_lor_all.origination_id%TYPE;
3610:
3611: -- FA 122 Loans Enhancements

Line 3651: FROM igf_sl_loans loans,

3647: lor.lend_non_ed_brc_id,
3648: lor.recip_non_ed_brc_id,
3649: lor.recipient_type,
3650: fabase.person_id student_id
3651: FROM igf_sl_loans loans,
3652: igf_sl_lor_v lor,
3653: igf_aw_award awd,
3654: igf_ap_fa_base_rec fabase
3655: WHERE fabase.base_id = awd.base_id

Line 3736: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_record.debug','Before insert into loans IGF_SL_LOANS_ALL');

3732:
3733: BEGIN
3734:
3735: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3736: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_record.debug','Before insert into loans IGF_SL_LOANS_ALL');
3737: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg..debug','Values :' ||
3738: ' Award ID ' ||
3739: p_award_id ||
3740: ' Loan Seq Number ' ||

Line 3758: igf_sl_loans_pkg.insert_row (

3754:
3755: ln_loan_id := NULL;
3756: ln_rowid := NULL;
3757:
3758: igf_sl_loans_pkg.insert_row (
3759: x_mode => 'R',
3760: x_rowid => ln_rowid,
3761: x_loan_id => ln_loan_id,
3762: x_award_id => p_award_id,

Line 3780: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After Insert into IGF_SL_LOANS LOAN_ID ' || ln_loan_id);

3776:
3777: );
3778:
3779: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3780: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.debug','After Insert into IGF_SL_LOANS LOAN_ID ' || ln_loan_id);
3781: END IF;
3782:
3783:
3784: IF p_fed_fund = 'FLU' THEN

Line 5145: igf_sl_loans_all

5141: award_id,
5142: loan_number,
5143: legacy_record_flag
5144: FROM
5145: igf_sl_loans_all
5146: WHERE
5147: award_id = cp_award_id;
5148:
5149: l_chk_loan_exist c_chk_loan_exist%ROWTYPE;

Line 5160: igf_sl_loans_all

5156: award_id,
5157: loan_number,
5158: legacy_record_flag
5159: FROM
5160: igf_sl_loans_all
5161: WHERE
5162: loan_number = cp_loan_number;
5163:
5164: l_chk_loan_number c_chk_loan_number%ROWTYPE;