APPS.IGF_AW_PACKNG_SUBFNS dependencies on IGF_AW_AWD_PRD_TERM

Line 43: l_awd_period IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL,

39: l_adplans_id IN NUMBER,
40: l_aid IN OUT NOCOPY NUMBER,
41: l_std_loan_tab IN std_loan_tab DEFAULT NULL,
42: p_msg_name OUT NOCOPY VARCHAR2,
43: l_awd_period IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL,
44: l_called_from IN VARCHAR2 DEFAULT 'NON-PACKAGING',
45: p_chk_aggr_limit IN VARCHAR2 DEFAULT 'Y'
46: ) IS
47: /*

Line 619: l_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE,

615: END check_loan_limits;
616:
617: PROCEDURE get_fed_efc(
618: l_base_id IN NUMBER,
619: l_awd_prd_code IN igf_aw_awd_prd_term.award_prd_cd%TYPE,
620: l_efc_f OUT NOCOPY NUMBER,
621: l_pell_efc OUT NOCOPY NUMBER,
622: l_efc_ay OUT NOCOPY NUMBER
623: ) IS

Line 812: p_awd_period IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL,

808: p_person_id IN igf_ap_fa_base_rec.person_id%TYPE,
809: p_adplans_id IN NUMBER,
810: p_award_id IN igf_aw_award_all.award_id%TYPE,
811: p_course_type OUT NOCOPY igs_ps_ver_all.course_type%TYPE,
812: p_awd_period IN igf_aw_awd_prd_term.award_prd_cd%TYPE DEFAULT NULL,
813: p_called_from IN VARCHAR2 DEFAULT 'NON-PACKAGING'
814: ) RETURN CHAR IS
815:
816: /*

Line 966: cp_awd_per igf_aw_awd_prd_term.award_prd_cd%TYPE

962: -- class standing data is taken into consideration. The ROWNUM predicate is
963: -- added to avoid scanning other terms in the awarding period.
964: CURSOR c_get_ant_class_stnd(
965: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
966: cp_awd_per igf_aw_awd_prd_term.award_prd_cd%TYPE
967: )
968: IS
969: SELECT ant_data.class_standing class_standing,
970: ant_data.ld_cal_type load_cal_type,

Line 973: igf_aw_awd_prd_term awd_per,

969: SELECT ant_data.class_standing class_standing,
970: ant_data.ld_cal_type load_cal_type,
971: ant_data.ld_sequence_number load_seq_num
972: FROM
973: igf_aw_awd_prd_term awd_per,
974: igs_ca_inst_all cal_inst,
975: igf_ap_fa_ant_data ant_data,
976: igf_ap_fa_base_rec_all fabase
977: WHERE

Line 999: cp_awd_per igf_aw_awd_prd_term.award_prd_cd%TYPE

995: -- Prog type data is taken into consideration. The ROWNUM predicate is
996: -- added to avoid scanning other terms in the awarding period.
997: CURSOR c_get_ant_prog_type(
998: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
999: cp_awd_per igf_aw_awd_prd_term.award_prd_cd%TYPE
1000: )
1001: IS
1002: SELECT ant_data.program_type prog_type,
1003: ant_data.ld_cal_type load_cal_type,

Line 1006: igf_aw_awd_prd_term awd_per,

1002: SELECT ant_data.program_type prog_type,
1003: ant_data.ld_cal_type load_cal_type,
1004: ant_data.ld_sequence_number load_seq_num
1005: FROM
1006: igf_aw_awd_prd_term awd_per,
1007: igs_ca_inst_all cal_inst,
1008: igf_ap_fa_ant_data ant_data,
1009: igf_ap_fa_base_rec_all fabase
1010: WHERE

Line 1271: p_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE

1267:
1268: FUNCTION is_over_award_occured(
1269: p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1270: p_mthd_type VARCHAR2 ,
1271: p_awd_prd_code igf_aw_awd_prd_term.award_prd_cd%TYPE
1272: ) RETURN BOOLEAN AS
1273: ------------------------------------------------------------------
1274: --Created by : veramach, Oracle India
1275: --Date created: 07-OCT-2003