72: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
73: RETURN BOOLEAN;
74:
75:
76: FUNCTION get_alt_code ( p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
77: p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)
78: RETURN VARCHAR2;
79:
80: FUNCTION get_calendar_desc ( p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
73: RETURN BOOLEAN;
74:
75:
76: FUNCTION get_alt_code ( p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
77: p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)
78: RETURN VARCHAR2;
79:
80: FUNCTION get_calendar_desc ( p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
81: p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)
76: FUNCTION get_alt_code ( p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
77: p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)
78: RETURN VARCHAR2;
79:
80: FUNCTION get_calendar_desc ( p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
81: p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)
82: RETURN VARCHAR2;
83:
84: FUNCTION get_per_num ( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE)
77: p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)
78: RETURN VARCHAR2;
79:
80: FUNCTION get_calendar_desc ( p_ci_cal_type IN igs_ca_inst_all.cal_type%TYPE,
81: p_ci_sequence_number IN igs_ca_inst_all.sequence_number%TYPE)
82: RETURN VARCHAR2;
83:
84: FUNCTION get_per_num ( p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE)
85: RETURN VARCHAR2;
217: --
218: -- Routine to fetch default award year
219: --
220:
221: PROCEDURE get_def_awd_year(p_alternate_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE,
222: p_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
223: p_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
224: p_start_date OUT NOCOPY igs_ca_inst_all.start_dt%TYPE,
225: p_end_date OUT NOCOPY igs_ca_inst_all.end_dt%TYPE,
218: -- Routine to fetch default award year
219: --
220:
221: PROCEDURE get_def_awd_year(p_alternate_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE,
222: p_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
223: p_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
224: p_start_date OUT NOCOPY igs_ca_inst_all.start_dt%TYPE,
225: p_end_date OUT NOCOPY igs_ca_inst_all.end_dt%TYPE,
226: p_err_msg OUT NOCOPY VARCHAR2
219: --
220:
221: PROCEDURE get_def_awd_year(p_alternate_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE,
222: p_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
223: p_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
224: p_start_date OUT NOCOPY igs_ca_inst_all.start_dt%TYPE,
225: p_end_date OUT NOCOPY igs_ca_inst_all.end_dt%TYPE,
226: p_err_msg OUT NOCOPY VARCHAR2
227: );
220:
221: PROCEDURE get_def_awd_year(p_alternate_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE,
222: p_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
223: p_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
224: p_start_date OUT NOCOPY igs_ca_inst_all.start_dt%TYPE,
225: p_end_date OUT NOCOPY igs_ca_inst_all.end_dt%TYPE,
226: p_err_msg OUT NOCOPY VARCHAR2
227: );
228:
221: PROCEDURE get_def_awd_year(p_alternate_code OUT NOCOPY igs_ca_inst_all.alternate_code%TYPE,
222: p_cal_type OUT NOCOPY igs_ca_inst_all.cal_type%TYPE,
223: p_sequence_number OUT NOCOPY igs_ca_inst_all.sequence_number%TYPE,
224: p_start_date OUT NOCOPY igs_ca_inst_all.start_dt%TYPE,
225: p_end_date OUT NOCOPY igs_ca_inst_all.end_dt%TYPE,
226: p_err_msg OUT NOCOPY VARCHAR2
227: );
228:
229:
352: --
353: -- Routine to fetch base id
354: --
355:
356: PROCEDURE get_base_id(p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
357: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
358: p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,
359: p_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE,
360: p_err_msg OUT NOCOPY VARCHAR2
353: -- Routine to fetch base id
354: --
355:
356: PROCEDURE get_base_id(p_cal_type IN igs_ca_inst_all.cal_type%TYPE,
357: p_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
358: p_person_id IN igf_ap_fa_base_rec_all.person_id%TYPE,
359: p_base_id OUT NOCOPY igf_ap_fa_base_rec_all.base_id%TYPE,
360: p_err_msg OUT NOCOPY VARCHAR2
361: );
384: p_transaction_num IN igf_ap_ISIR_matched.transaction_num%TYPE)
385: RETURN BOOLEAN;
386:
387:
388: FUNCTION get_rep_pell_from_ope(p_cal_type igs_ca_inst_all.cal_type%TYPE,
389: p_seq_num igs_ca_inst_all.sequence_number%TYPE,
390: p_ope_cd igf_gr_report_pell.ope_cd%TYPE)
391: RETURN VARCHAR2;
392:
385: RETURN BOOLEAN;
386:
387:
388: FUNCTION get_rep_pell_from_ope(p_cal_type igs_ca_inst_all.cal_type%TYPE,
389: p_seq_num igs_ca_inst_all.sequence_number%TYPE,
390: p_ope_cd igf_gr_report_pell.ope_cd%TYPE)
391: RETURN VARCHAR2;
392:
393: FUNCTION get_rep_pell_from_att(p_cal_type igs_ca_inst_all.cal_type%TYPE,
389: p_seq_num igs_ca_inst_all.sequence_number%TYPE,
390: p_ope_cd igf_gr_report_pell.ope_cd%TYPE)
391: RETURN VARCHAR2;
392:
393: FUNCTION get_rep_pell_from_att(p_cal_type igs_ca_inst_all.cal_type%TYPE,
394: p_seq_num igs_ca_inst_all.sequence_number%TYPE,
395: p_att_pell igf_gr_attend_pell.attending_pell_cd%TYPE)
396: RETURN VARCHAR2;
397:
390: p_ope_cd igf_gr_report_pell.ope_cd%TYPE)
391: RETURN VARCHAR2;
392:
393: FUNCTION get_rep_pell_from_att(p_cal_type igs_ca_inst_all.cal_type%TYPE,
394: p_seq_num igs_ca_inst_all.sequence_number%TYPE,
395: p_att_pell igf_gr_attend_pell.attending_pell_cd%TYPE)
396: RETURN VARCHAR2;
397:
398: FUNCTION get_rep_pell_from_base(p_cal_type igs_ca_inst_all.cal_type%TYPE,
394: p_seq_num igs_ca_inst_all.sequence_number%TYPE,
395: p_att_pell igf_gr_attend_pell.attending_pell_cd%TYPE)
396: RETURN VARCHAR2;
397:
398: FUNCTION get_rep_pell_from_base(p_cal_type igs_ca_inst_all.cal_type%TYPE,
399: p_seq_num igs_ca_inst_all.sequence_number%TYPE,
400: p_base_id NUMBER)
401: RETURN VARCHAR2;
402:
395: p_att_pell igf_gr_attend_pell.attending_pell_cd%TYPE)
396: RETURN VARCHAR2;
397:
398: FUNCTION get_rep_pell_from_base(p_cal_type igs_ca_inst_all.cal_type%TYPE,
399: p_seq_num igs_ca_inst_all.sequence_number%TYPE,
400: p_base_id NUMBER)
401: RETURN VARCHAR2;
402:
403: END igf_gr_gen;