APPS.IGF_DB_DISB dependencies on IGF_AW_FUND_TP_ALL

Line 2021: lv_old_ld_c igf_aw_fund_tp_all.tp_cal_type%TYPE;

2017: -- checks are not repeated for each disbursement belonging to the same fund/award/term
2018:
2019: ln_old_fund igf_aw_fund_mast_all.fund_id%TYPE;
2020: ln_new_fund igf_aw_fund_mast_all.fund_id%TYPE;
2021: lv_old_ld_c igf_aw_fund_tp_all.tp_cal_type%TYPE;
2022: ln_old_ld_n igf_aw_fund_tp_all.tp_sequence_number%TYPE;
2023: lv_new_ld_c igf_aw_fund_tp_all.tp_cal_type%TYPE;
2024: ln_new_ld_n igf_aw_fund_tp_all.tp_sequence_number%TYPE;
2025: BEGIN

Line 2022: ln_old_ld_n igf_aw_fund_tp_all.tp_sequence_number%TYPE;

2018:
2019: ln_old_fund igf_aw_fund_mast_all.fund_id%TYPE;
2020: ln_new_fund igf_aw_fund_mast_all.fund_id%TYPE;
2021: lv_old_ld_c igf_aw_fund_tp_all.tp_cal_type%TYPE;
2022: ln_old_ld_n igf_aw_fund_tp_all.tp_sequence_number%TYPE;
2023: lv_new_ld_c igf_aw_fund_tp_all.tp_cal_type%TYPE;
2024: ln_new_ld_n igf_aw_fund_tp_all.tp_sequence_number%TYPE;
2025: BEGIN
2026:

Line 2023: lv_new_ld_c igf_aw_fund_tp_all.tp_cal_type%TYPE;

2019: ln_old_fund igf_aw_fund_mast_all.fund_id%TYPE;
2020: ln_new_fund igf_aw_fund_mast_all.fund_id%TYPE;
2021: lv_old_ld_c igf_aw_fund_tp_all.tp_cal_type%TYPE;
2022: ln_old_ld_n igf_aw_fund_tp_all.tp_sequence_number%TYPE;
2023: lv_new_ld_c igf_aw_fund_tp_all.tp_cal_type%TYPE;
2024: ln_new_ld_n igf_aw_fund_tp_all.tp_sequence_number%TYPE;
2025: BEGIN
2026:
2027: ln_old_fund := -1 ;

Line 2024: ln_new_ld_n igf_aw_fund_tp_all.tp_sequence_number%TYPE;

2020: ln_new_fund igf_aw_fund_mast_all.fund_id%TYPE;
2021: lv_old_ld_c igf_aw_fund_tp_all.tp_cal_type%TYPE;
2022: ln_old_ld_n igf_aw_fund_tp_all.tp_sequence_number%TYPE;
2023: lv_new_ld_c igf_aw_fund_tp_all.tp_cal_type%TYPE;
2024: ln_new_ld_n igf_aw_fund_tp_all.tp_sequence_number%TYPE;
2025: BEGIN
2026:
2027: ln_old_fund := -1 ;
2028: ln_new_fund := 0;

Line 2490: lv_old_ld_c igf_aw_fund_tp_all.tp_cal_type%TYPE;

2486:
2487: ln_old_awd igf_aw_award_all.award_id%TYPE;
2488: ln_new_awd igf_aw_award_all.award_id%TYPE;
2489:
2490: lv_old_ld_c igf_aw_fund_tp_all.tp_cal_type%TYPE;
2491: ln_old_ld_n igf_aw_fund_tp_all.tp_sequence_number%TYPE;
2492: lv_new_ld_c igf_aw_fund_tp_all.tp_cal_type%TYPE;
2493: ln_new_ld_n igf_aw_fund_tp_all.tp_sequence_number%TYPE;
2494:

Line 2491: ln_old_ld_n igf_aw_fund_tp_all.tp_sequence_number%TYPE;

2487: ln_old_awd igf_aw_award_all.award_id%TYPE;
2488: ln_new_awd igf_aw_award_all.award_id%TYPE;
2489:
2490: lv_old_ld_c igf_aw_fund_tp_all.tp_cal_type%TYPE;
2491: ln_old_ld_n igf_aw_fund_tp_all.tp_sequence_number%TYPE;
2492: lv_new_ld_c igf_aw_fund_tp_all.tp_cal_type%TYPE;
2493: ln_new_ld_n igf_aw_fund_tp_all.tp_sequence_number%TYPE;
2494:
2495: lv_pell_mat VARCHAR2(10);

Line 2492: lv_new_ld_c igf_aw_fund_tp_all.tp_cal_type%TYPE;

2488: ln_new_awd igf_aw_award_all.award_id%TYPE;
2489:
2490: lv_old_ld_c igf_aw_fund_tp_all.tp_cal_type%TYPE;
2491: ln_old_ld_n igf_aw_fund_tp_all.tp_sequence_number%TYPE;
2492: lv_new_ld_c igf_aw_fund_tp_all.tp_cal_type%TYPE;
2493: ln_new_ld_n igf_aw_fund_tp_all.tp_sequence_number%TYPE;
2494:
2495: lv_pell_mat VARCHAR2(10);
2496: ln_ft_pell_amt NUMBER;

Line 2493: ln_new_ld_n igf_aw_fund_tp_all.tp_sequence_number%TYPE;

2489:
2490: lv_old_ld_c igf_aw_fund_tp_all.tp_cal_type%TYPE;
2491: ln_old_ld_n igf_aw_fund_tp_all.tp_sequence_number%TYPE;
2492: lv_new_ld_c igf_aw_fund_tp_all.tp_cal_type%TYPE;
2493: ln_new_ld_n igf_aw_fund_tp_all.tp_sequence_number%TYPE;
2494:
2495: lv_pell_mat VARCHAR2(10);
2496: ln_ft_pell_amt NUMBER;
2497: lv_call_from VARCHAR2(10);