APPS.IGF_GR_GEN dependencies on IGF_AW_AWARD_ALL

Line 71: FUNCTION disb_has_adj ( p_award_id igf_aw_award_all.award_id%TYPE,

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)
73: RETURN BOOLEAN;
74:
75:

Line 102: PROCEDURE insert_sys_holds ( p_award_id igf_aw_award_all.award_id%TYPE,

98: FUNCTION get_per_num_oss ( p_person_id igf_ap_fa_base_rec_all.person_id%TYPE)
99: RETURN VARCHAR2;
100:
101:
102: PROCEDURE insert_sys_holds ( p_award_id igf_aw_award_all.award_id%TYPE,
103: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE DEFAULT NULL,
104: p_hold igf_db_disb_holds_all.hold%TYPE);
105:
106:

Line 107: FUNCTION get_min_awd_disb ( p_award_id igf_aw_award_all.award_id%TYPE)

103: p_disb_num igf_aw_awd_disb_all.disb_num%TYPE DEFAULT NULL,
104: p_hold igf_db_disb_holds_all.hold%TYPE);
105:
106:
107: FUNCTION get_min_awd_disb ( p_award_id igf_aw_award_all.award_id%TYPE)
108: RETURN NUMBER;
109:
110:
111: ----------------------------------------------------------------------------------------

Line 148: FUNCTION get_pell_efc ( p_base_id IN igf_aw_award_all.base_id%TYPE)

144: p_last_gldr_id OUT NOCOPY NUMBER,
145: p_batch_id OUT NOCOPY VARCHAR2);
146:
147:
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)

Line 159: FUNCTION get_pell_efc_code ( p_base_id IN igf_aw_award_all.base_id%TYPE)

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;
161:
162: FUNCTION fresh_origintn ( p_orig_id igf_gr_rfms_all.origination_id%TYPE)
163: RETURN BOOLEAN;

Line 165: FUNCTION get_fund_id ( p_award_id igf_aw_award_all.award_id%TYPE)

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;
167:
168: FUNCTION get_ssn_digits(p_ssn igs_pe_alt_pers_id.api_person_id_uf%TYPE)
169: RETURN VARCHAR2;

Line 371: PROCEDURE update_pell_status (p_award_id IN igf_aw_award_all.award_id%TYPE,

367: PROCEDURE update_current_ssn (p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
368: p_cur_ssn IN igf_ap_isir_matched_all.current_ssn%TYPE,
369: p_message OUT NOCOPY fnd_new_messages.message_name%TYPE);
370:
371: PROCEDURE update_pell_status (p_award_id IN igf_aw_award_all.award_id%TYPE,
372: p_fed_fund_code IN igf_aw_fund_cat_all.fed_fund_code%TYPE,
373: p_message OUT NOCOPY fnd_new_messages.message_name%TYPE,
374: p_status_desc OUT NOCOPY igf_lookups_view.meaning%TYPE);
375:

Line 380: FUNCTION get_min_disb_number (p_award_id igf_aw_award_all.award_id%TYPE)

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;
382: -- Added As part of FA121 Build (Verification Worksheet Enhancements)
383: FUNCTION chk_orig_isir_exists( p_base_id IN igf_ap_fa_base_rec.base_id%TYPE,
384: p_transaction_num IN igf_ap_ISIR_matched.transaction_num%TYPE)