eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGF_AW_LI_IMPORT dependencies on IGS_FI_CREDITS

Line 2559: FROM igs_fi_credits

2555: max_disb_num cur_get_max_disb%ROWTYPE;
2556:
2557: CURSOR cur_sf_credit_num (p_credit_num igf_aw_li_dact_ints.sf_credit_num_txt%TYPE) IS
2558: SELECT credit_number, amount, credit_id
2559: FROM igs_fi_credits
2560: WHERE party_id = g_person_id
2561: AND credit_number = p_credit_num;
2562: cur_sf_credit_num_rec cur_sf_credit_num%ROWTYPE;
2563: l_trans_credit_id igs_fi_credits_all.credit_id%TYPE;

Line 2563: l_trans_credit_id igs_fi_credits_all.credit_id%TYPE;

2559: FROM igs_fi_credits
2560: WHERE party_id = g_person_id
2561: AND credit_number = p_credit_num;
2562: cur_sf_credit_num_rec cur_sf_credit_num%ROWTYPE;
2563: l_trans_credit_id igs_fi_credits_all.credit_id%TYPE;
2564: l_trans_spnsr_credit_id igs_fi_credits_all.credit_id%TYPE;
2565:
2566: CURSOR c_get_cal_typ_seq_num(p_alternate_code igs_ca_inst.alternate_code%TYPE) IS
2567: SELECT cal_type, sequence_number

Line 2564: l_trans_spnsr_credit_id igs_fi_credits_all.credit_id%TYPE;

2560: WHERE party_id = g_person_id
2561: AND credit_number = p_credit_num;
2562: cur_sf_credit_num_rec cur_sf_credit_num%ROWTYPE;
2563: l_trans_credit_id igs_fi_credits_all.credit_id%TYPE;
2564: l_trans_spnsr_credit_id igs_fi_credits_all.credit_id%TYPE;
2565:
2566: CURSOR c_get_cal_typ_seq_num(p_alternate_code igs_ca_inst.alternate_code%TYPE) IS
2567: SELECT cal_type, sequence_number
2568: FROM igs_ca_inst

Line 2812: -- Fetch the credit number from the igs_fi_credits table

2808: END IF;
2809:
2810: -- credit number validation for posted transactions only. valid for open and legacy details award years
2811: IF(cur_li_disb_act_int_rec.sf_credit_num_txt IS NOT NULL AND cur_li_disb_act_int_rec.sf_status_code = 'P')THEN
2812: -- Fetch the credit number from the igs_fi_credits table
2813: cur_sf_credit_num_rec := NULL;
2814: OPEN cur_sf_credit_num(cur_li_disb_act_int_rec.sf_credit_num_txt); FETCH cur_sf_credit_num INTO cur_sf_credit_num_rec;
2815: CLOSE cur_sf_credit_num;
2816: l_trans_credit_id := cur_sf_credit_num_rec.credit_id;

Line 2862: --Fetch the Sponsorship Credit number from the igs_fi_credits_table

2858: END IF;
2859:
2860: -- sponsor credit number validations for posted transactions only. applicable for open as well as legacy details award years
2861: IF(cur_li_disb_act_int_rec.spnsr_credit_num_txt IS NOT NULL AND cur_li_disb_act_int_rec.sf_status_code = 'P')THEN
2862: --Fetch the Sponsorship Credit number from the igs_fi_credits_table
2863: cur_sf_credit_num_rec := NULL;
2864: OPEN cur_sf_credit_num(cur_li_disb_act_int_rec.spnsr_credit_num_txt); FETCH cur_sf_credit_num INTO cur_sf_credit_num_rec;
2865: CLOSE cur_sf_credit_num;
2866: l_trans_spnsr_credit_id := cur_sf_credit_num_rec.credit_id;