APPS.IGF_AP_GEN dependencies on DUAL

Line 576: || Purpose : get individual family contribution for a term

572: ) RETURN NUMBER AS
573: /*
574: || Created By : rasahoo
575: || Created On : 15-10-2003
576: || Purpose : get individual family contribution for a term
577: || Known limitations, enhancements or remarks :
578: || Change History :
579: || Who When What
580: || (reverse chronological order - newest change first)

Line 592: igf_ap_gen.get_individual_coa_amt(ca.start_dt,fa.base_id) coa,

588: ) IS
589: SELECT distinct ca.alternate_code,
590: ca.start_dt ld_start_dt,
591: ca.end_dt ld_end_dt,
592: igf_ap_gen.get_individual_coa_amt(ca.start_dt,fa.base_id) coa,
593: ca.cal_type ld_cal_type, ca.sequence_number ld_sequence_number,
594: DECODE(fa.AWARD_FMLY_CONTRIBUTION_TYPE, '2',
595: DECODE ( igf_ap_efc_calc.get_efc_no_of_months(ca.end_dt, coa.base_id ),
596: 1 , SEC_ALTERNATE_MONTH_1,

Line 712: FUNCTION get_individual_coa_amt(

708: app_exception.raise_exception;
709: END get_cumulative_coa_amt ;
710:
711:
712: FUNCTION get_individual_coa_amt(
713: p_ld_start_dt IN DATE,
714: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE
715: ) RETURN NUMBER IS
716: /*

Line 719: || Purpose : get Individual COA Amount for the student based on the start date

715: ) RETURN NUMBER IS
716: /*
717: || Created By : rasahoo
718: || Created On : 27-NOV-2003
719: || Purpose : get Individual COA Amount for the student based on the start date
720: || Known limitations, enhancements or remarks :
721: || Change History :
722: || Who When What
723: || (reverse chronological order - newest change first)

Line 758: fnd_message.set_token('NAME','IGF_AP_GEN.GET_INDIVIDUAL_COA_AMT'||SQLERRM);

754:
755: EXCEPTION
756: WHEN OTHERS THEN
757: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
758: fnd_message.set_token('NAME','IGF_AP_GEN.GET_INDIVIDUAL_COA_AMT'||SQLERRM);
759: igs_ge_msg_stack.add;
760: app_exception.raise_exception;
761:
762: END get_individual_coa_amt;

Line 762: END get_individual_coa_amt;

758: fnd_message.set_token('NAME','IGF_AP_GEN.GET_INDIVIDUAL_COA_AMT'||SQLERRM);
759: igs_ge_msg_stack.add;
760: app_exception.raise_exception;
761:
762: END get_individual_coa_amt;
763:
764: PROCEDURE update_preflend_todo_status ( p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,
765: p_return_status OUT NOCOPY VARCHAR2
766: ) IS

Line 969: SELECT igs_pe_res_chg_s.nextval INTO l_seq_val FROM DUAL;

965: OPEN c_award_year(p_base_id);
966: FETCH c_award_year INTO l_alternate_code;
967: CLOSE c_award_year;
968:
969: SELECT igs_pe_res_chg_s.nextval INTO l_seq_val FROM DUAL;
970:
971: -- Initialize the wf_event_t object
972: WF_EVENT_T.Initialize(l_wf_event_t);
973: