APPS.IGF_SP_AWARD dependencies on IGF_SP_GEN_001

Line 583: igf_sp_gen_001.get_sponsor_amts(p_n_person_id => rec_stdnt_rel.person_id,

579: -- If p_chk_elig is 'Y' (Actual), then the New Sponsor amount will be the lesser of
580: -- Eligible Sponsor Amount and the Total Sponsor Amount.
581:
582: -- Fetch the sponsor amounts
583: igf_sp_gen_001.get_sponsor_amts(p_n_person_id => rec_stdnt_rel.person_id,
584: p_v_fee_cal_type => l_v_fee_cal_type,
585: p_n_fee_seq_number => l_n_fee_ci_seq_num,
586: p_v_fund_code => rec_stdnt_rel.fund_code,
587: p_v_ld_cal_type => rec_stdnt_rel.ld_cal_type,

Line 641: IF igf_sp_gen_001.check_unit_attempt(p_person_id => rec_stdnt_rel.person_id,

637: LOOP
638: FETCH c_std_unit INTO rec_std_unit;
639: EXIT WHEN c_std_unit%NOTFOUND ;
640: IF p_chk_elig = 'Y' THEN
641: IF igf_sp_gen_001.check_unit_attempt(p_person_id => rec_stdnt_rel.person_id,
642: p_ld_cal_type => rec_stdnt_rel.ld_cal_type,
643: p_ld_ci_sequence_number => rec_stdnt_rel.ld_sequence_number,
644: p_course_cd => rec_std_prg.course_cd,
645: p_course_version_number => rec_std_prg.version_number,

Line 653: igf_sp_gen_001.get_sponsor_amts(p_n_person_id => rec_stdnt_rel.person_id,

649: p_msg_data => l_msg_data) THEN
650: -- If p_chk_elig is Y (Actual), then the Eligible Amount needs to be taken into account
651: -- before awarding.
652: -- Fetch the sponsor amounts
653: igf_sp_gen_001.get_sponsor_amts(p_n_person_id => rec_stdnt_rel.person_id,
654: p_v_fee_cal_type => l_v_fee_cal_type,
655: p_n_fee_seq_number => l_n_fee_ci_seq_num,
656: p_v_fund_code => rec_stdnt_rel.fund_code,
657: p_v_ld_cal_type => rec_stdnt_rel.ld_cal_type,

Line 699: igf_sp_gen_001.get_sponsor_amts(p_n_person_id => rec_stdnt_rel.person_id,

695: IF (p_chk_elig = 'N') THEN
696: l_tot_spnsr_amount := NVL(l_tot_spnsr_amount,0) + rec_std_prg.max_amount;
697: ELSE
698: -- Fetch the Sponsor Amounts
699: igf_sp_gen_001.get_sponsor_amts(p_n_person_id => rec_stdnt_rel.person_id,
700: p_v_fee_cal_type => l_v_fee_cal_type,
701: p_n_fee_seq_number => l_n_fee_ci_seq_num,
702: p_v_fund_code => rec_stdnt_rel.fund_code,
703: p_v_ld_cal_type => rec_stdnt_rel.ld_cal_type,

Line 735: igf_sp_gen_001.get_sponsor_amts(p_n_person_id => rec_stdnt_rel.person_id,

731: l_tot_spnsr_amount := NVL(l_tot_spnsr_amount,0) + NVL(l_n_spns_amount,0);
732: END IF;
733: ELSIF rec_std_prg.fee_percent IS NOT NULL AND rec_std_prg.max_amount IS NULL THEN
734: -- Fetch the Sponsor Amounts
735: igf_sp_gen_001.get_sponsor_amts(p_n_person_id => rec_stdnt_rel.person_id,
736: p_v_fee_cal_type => l_v_fee_cal_type,
737: p_n_fee_seq_number => l_n_fee_ci_seq_num,
738: p_v_fund_code => rec_stdnt_rel.fund_code,
739: p_v_ld_cal_type => rec_stdnt_rel.ld_cal_type,

Line 765: igf_sp_gen_001.get_sponsor_amts(p_n_person_id => rec_stdnt_rel.person_id,

761: l_tot_spnsr_amount := NVL(l_tot_spnsr_amount,0) + NVL(l_n_spns_amount,0);
762:
763: ELSIF rec_std_prg.fee_percent IS NOT NULL AND rec_std_prg.max_amount IS NOT NULL THEN
764: -- Fetch the Sponsor Amounts
765: igf_sp_gen_001.get_sponsor_amts(p_n_person_id => rec_stdnt_rel.person_id,
766: p_v_fee_cal_type => l_v_fee_cal_type,
767: p_n_fee_seq_number => l_n_fee_ci_seq_num,
768: p_v_fund_code => rec_stdnt_rel.fund_code,
769: p_v_ld_cal_type => rec_stdnt_rel.ld_cal_type,

Line 811: igf_sp_gen_001.get_sponsor_amts(p_n_person_id => rec_stdnt_rel.person_id,

807: IF (p_chk_elig = 'N') THEN
808: l_tot_spnsr_amount := NVL(l_tot_spnsr_amount,0) + rec_std_fc.max_amount;
809: ELSE
810: -- Fetch the Sponsor Amounts
811: igf_sp_gen_001.get_sponsor_amts(p_n_person_id => rec_stdnt_rel.person_id,
812: p_v_fee_cal_type => l_v_fee_cal_type,
813: p_n_fee_seq_number => l_n_fee_ci_seq_num,
814: p_v_fund_code => rec_stdnt_rel.fund_code,
815: p_v_ld_cal_type => rec_stdnt_rel.ld_cal_type,

Line 848: igf_sp_gen_001.get_sponsor_amts(p_n_person_id => rec_stdnt_rel.person_id,

844:
845: END IF;
846: ELSIF rec_std_fc.fee_percent IS NOT NULL AND rec_std_fc.max_amount IS NULL THEN
847: -- Fetch the Sponsor Amounts
848: igf_sp_gen_001.get_sponsor_amts(p_n_person_id => rec_stdnt_rel.person_id,
849: p_v_fee_cal_type => l_v_fee_cal_type,
850: p_n_fee_seq_number => l_n_fee_ci_seq_num,
851: p_v_fund_code => rec_stdnt_rel.fund_code,
852: p_v_ld_cal_type => rec_stdnt_rel.ld_cal_type,

Line 878: igf_sp_gen_001.get_sponsor_amts(p_n_person_id => rec_stdnt_rel.person_id,

874: l_tot_spnsr_amount := NVL(l_tot_spnsr_amount,0) + NVL(l_n_spns_amount,0);
875:
876: ELSIF rec_std_fc.fee_percent IS NOT NULL AND rec_std_fc.max_amount IS NOT NULL THEN
877: -- Fetch the Sponsor Amounts
878: igf_sp_gen_001.get_sponsor_amts(p_n_person_id => rec_stdnt_rel.person_id,
879: p_v_fee_cal_type => l_v_fee_cal_type,
880: p_n_fee_seq_number => l_n_fee_ci_seq_num,
881: p_v_fund_code => rec_stdnt_rel.fund_code,
882: p_v_ld_cal_type => rec_stdnt_rel.ld_cal_type,