APPS.IGF_GR_GEN dependencies on IGF_GR_RFMS_ALL

Line 1173: FUNCTION send_orig_disb ( p_orig_id igf_gr_rfms_all.origination_id%TYPE)

1169:
1170: END process_pell_ack;
1171:
1172:
1173: FUNCTION send_orig_disb ( p_orig_id igf_gr_rfms_all.origination_id%TYPE)
1174: RETURN BOOLEAN
1175: IS
1176:
1177: --

Line 1185: CURSOR cur_rfms_dat ( p_orig_id igf_gr_rfms_all.origination_id%TYPE)

1181: -- Function to determine if an Origination / Disbursement Record
1182: -- can be reported or not
1183: --
1184:
1185: CURSOR cur_rfms_dat ( p_orig_id igf_gr_rfms_all.origination_id%TYPE)
1186: IS
1187: SELECT
1188: ver_status_code
1189: FROM

Line 1226: FUNCTION get_min_pell_disb ( p_orig_id igf_gr_rfms_all.origination_id%TYPE)

1222: END send_orig_disb;
1223:
1224:
1225:
1226: FUNCTION get_min_pell_disb ( p_orig_id igf_gr_rfms_all.origination_id%TYPE)
1227: RETURN NUMBER
1228: IS
1229:
1230: --

Line 1233: CURSOR cur_pell_disb ( p_orig_id igf_gr_rfms_all.origination_id%TYPE)

1229:
1230: --
1231: --
1232: --
1233: CURSOR cur_pell_disb ( p_orig_id igf_gr_rfms_all.origination_id%TYPE)
1234: IS
1235: SELECT
1236: MIN(disb_ref_num)
1237: FROM

Line 1336: l_sec_efc_type igf_gr_rfms_all.secondary_efc_cd%TYPE;

1332: base_id = p_base_id;
1333:
1334: get_orgn_rec cur_get_orgn%ROWTYPE;
1335:
1336: l_sec_efc_type igf_gr_rfms_all.secondary_efc_cd%TYPE;
1337:
1338: BEGIN
1339:
1340: OPEN cur_get_orgn(p_base_id);

Line 1390: FUNCTION fresh_origintn ( p_orig_id igf_gr_rfms_all.origination_id%TYPE)

1386:
1387: END get_pell_efc_code;
1388:
1389:
1390: FUNCTION fresh_origintn ( p_orig_id igf_gr_rfms_all.origination_id%TYPE)
1391: RETURN BOOLEAN
1392: IS
1393:
1394: --

Line 1399: CURSOR cur_rfms_dat ( p_orig_id igf_gr_rfms_all.origination_id%TYPE)

1395: -- Function to determine if an Origination Record is being
1396: -- sent for first time or not
1397: --
1398:
1399: CURSOR cur_rfms_dat ( p_orig_id igf_gr_rfms_all.origination_id%TYPE)
1400: IS
1401: SELECT
1402: batch.rfms_ack_batch_id
1403: FROM

Line 2060: FUNCTION get_tufees_code(p_base_id IN igf_gr_rfms_all.base_id%TYPE,

2056:
2057: END ovrd_coa_exist;
2058:
2059:
2060: FUNCTION get_tufees_code(p_base_id IN igf_gr_rfms_all.base_id%TYPE,
2061: p_cal_type IN igf_gr_rfms_all.ci_cal_type%TYPE,
2062: p_sequence_number IN igf_gr_rfms_all.ci_sequence_number%TYPE)
2063: RETURN VARCHAR2
2064: IS

Line 2061: p_cal_type IN igf_gr_rfms_all.ci_cal_type%TYPE,

2057: END ovrd_coa_exist;
2058:
2059:
2060: FUNCTION get_tufees_code(p_base_id IN igf_gr_rfms_all.base_id%TYPE,
2061: p_cal_type IN igf_gr_rfms_all.ci_cal_type%TYPE,
2062: p_sequence_number IN igf_gr_rfms_all.ci_sequence_number%TYPE)
2063: RETURN VARCHAR2
2064: IS
2065:

Line 2062: p_sequence_number IN igf_gr_rfms_all.ci_sequence_number%TYPE)

2058:
2059:
2060: FUNCTION get_tufees_code(p_base_id IN igf_gr_rfms_all.base_id%TYPE,
2061: p_cal_type IN igf_gr_rfms_all.ci_cal_type%TYPE,
2062: p_sequence_number IN igf_gr_rfms_all.ci_sequence_number%TYPE)
2063: RETURN VARCHAR2
2064: IS
2065:
2066: --

Line 2072: p_base_id igf_gr_rfms_all.base_id%TYPE

2068: -- award
2069: --
2070:
2071: CURSOR cur_get_award(
2072: p_base_id igf_gr_rfms_all.base_id%TYPE
2073: ) IS
2074: SELECT alt_pell_schedule
2075: FROM igf_aw_award_all awd,
2076: igf_aw_fund_mast_all fmast,

Line 2088: CURSOR cur_get_alt (p_base_id igf_gr_rfms_all.base_id%TYPE)

2084:
2085: --
2086: -- Function to return loa tuition fees code
2087: --
2088: CURSOR cur_get_alt (p_base_id igf_gr_rfms_all.base_id%TYPE)
2089: IS
2090: SELECT
2091: pell_alt_expense
2092: FROM

Line 2100: p_cal_type igf_gr_rfms_all.ci_cal_type%TYPE,

2096:
2097: get_alt_rec cur_get_alt%ROWTYPE;
2098:
2099: CURSOR cur_tufees_code (p_exp igf_ap_fa_base_rec_all.pell_alt_expense%TYPE,
2100: p_cal_type igf_gr_rfms_all.ci_cal_type%TYPE,
2101: p_sequence_number igf_gr_rfms_all.ci_sequence_number%TYPE)
2102: IS
2103: SELECT ltfees.lt_fees_code
2104: FROM igf_gr_tuition_fee_codes ltfees,

Line 2101: p_sequence_number igf_gr_rfms_all.ci_sequence_number%TYPE)

2097: get_alt_rec cur_get_alt%ROWTYPE;
2098:
2099: CURSOR cur_tufees_code (p_exp igf_ap_fa_base_rec_all.pell_alt_expense%TYPE,
2100: p_cal_type igf_gr_rfms_all.ci_cal_type%TYPE,
2101: p_sequence_number igf_gr_rfms_all.ci_sequence_number%TYPE)
2102: IS
2103: SELECT ltfees.lt_fees_code
2104: FROM igf_gr_tuition_fee_codes ltfees,
2105: igf_ap_batch_aw_map_all batch

Line 2881: CURSOR cur_get_pell (p_award_id igf_gr_rfms_all.award_id%TYPE)

2877: -- update_pell_status
2878: -- sets pell origination status desc
2879: --
2880:
2881: CURSOR cur_get_pell (p_award_id igf_gr_rfms_all.award_id%TYPE)
2882: IS
2883: SELECT pell.orig_action_code
2884: FROM
2885: igf_gr_rfms pell