[Home] [Help]
63: batch_not_in_system EXCEPTION;
64: corrupt_data_file EXCEPTION;
65: skip_this_record EXCEPTION;
66:
67: FUNCTION get_cycle_year (p_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,
68: p_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE)
69: RETURN VARCHAR2;
70:
71: FUNCTION disb_has_adj ( p_award_id igf_aw_award_all.award_id%TYPE,
64: corrupt_data_file EXCEPTION;
65: skip_this_record EXCEPTION;
66:
67: FUNCTION get_cycle_year (p_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,
68: p_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE)
69: RETURN VARCHAR2;
70:
71: FUNCTION disb_has_adj ( p_award_id igf_aw_award_all.award_id%TYPE,
72: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE)
119: FUNCTION get_pell_header ( p_ver_num IN VARCHAR2,
120: p_cycle_year IN VARCHAR2,
121: p_rep_pell_id IN igf_gr_pell_setup_all.rep_pell_id%TYPE,
122: p_batch_type IN VARCHAR2,
123: p_rfmb_id OUT NOCOPY igf_gr_rfms_batch.rfmb_id%TYPE,
124: p_batch_id OUT NOCOPY VARCHAR2,
125: p_ci_cal_type IN VARCHAR2,
126: p_ci_sequence_number IN NUMBER)
127: RETURN VARCHAR2;
148: FUNCTION get_pell_efc ( p_base_id IN igf_aw_award_all.base_id%TYPE)
149: RETURN NUMBER;
150:
151:
152: FUNCTION send_orig_disb ( p_orig_id igf_gr_rfms_all.origination_id%TYPE)
153: RETURN BOOLEAN;
154:
155:
156: FUNCTION get_min_pell_disb ( p_orig_id igf_gr_rfms_all.origination_id%TYPE)
152: FUNCTION send_orig_disb ( p_orig_id igf_gr_rfms_all.origination_id%TYPE)
153: RETURN BOOLEAN;
154:
155:
156: FUNCTION get_min_pell_disb ( p_orig_id igf_gr_rfms_all.origination_id%TYPE)
157: RETURN NUMBER;
158:
159: FUNCTION get_pell_efc_code ( p_base_id IN igf_aw_award_all.base_id%TYPE)
160: RETURN VARCHAR2;
158:
159: FUNCTION get_pell_efc_code ( p_base_id IN igf_aw_award_all.base_id%TYPE)
160: RETURN VARCHAR2;
161:
162: FUNCTION fresh_origintn ( p_orig_id igf_gr_rfms_all.origination_id%TYPE)
163: RETURN BOOLEAN;
164:
165: FUNCTION get_fund_id ( p_award_id igf_aw_award_all.award_id%TYPE)
166: RETURN NUMBER;
234: --
235: -- Routine to fetch Low Tution and Fees Code
236: --
237:
238: FUNCTION get_tufees_code(p_base_id IN igf_gr_rfms_all.base_id%TYPE,
239: p_cal_type IN igf_gr_rfms_all.ci_cal_type%TYPE,
240: p_sequence_number IN igf_gr_rfms_all.ci_sequence_number%TYPE)
241: RETURN VARCHAR2;
242:
235: -- Routine to fetch Low Tution and Fees Code
236: --
237:
238: FUNCTION get_tufees_code(p_base_id IN igf_gr_rfms_all.base_id%TYPE,
239: p_cal_type IN igf_gr_rfms_all.ci_cal_type%TYPE,
240: p_sequence_number IN igf_gr_rfms_all.ci_sequence_number%TYPE)
241: RETURN VARCHAR2;
242:
243: --
236: --
237:
238: FUNCTION get_tufees_code(p_base_id IN igf_gr_rfms_all.base_id%TYPE,
239: p_cal_type IN igf_gr_rfms_all.ci_cal_type%TYPE,
240: p_sequence_number IN igf_gr_rfms_all.ci_sequence_number%TYPE)
241: RETURN VARCHAR2;
242:
243: --
244: -- Bug 2606001
373: p_message OUT NOCOPY fnd_new_messages.message_name%TYPE,
374: p_status_desc OUT NOCOPY igf_lookups_view.meaning%TYPE);
375:
376: PROCEDURE match_file_version (p_version IN igf_lookups_view.lookup_code%TYPE,
377: p_batch_id IN igf_gr_rfms_batch_all.batch_id%TYPE,
378: p_message OUT NOCOPY fnd_new_messages.message_name%TYPE);
379:
380: FUNCTION get_min_disb_number (p_award_id igf_aw_award_all.award_id%TYPE)
381: RETURN NUMBER;