eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_GR_GEN dependencies on IGF_GR_RFMS

Line 12: -- Changed the TBH calls of the packages: igf_gr_rfms_pkg

8: -- Modified the call to igf_aw_packng_subfns.get_fed_efc()
9: -- as part of dependency.
10: ------------------------------------------------------------------------
11: --ayedubat 13-OCT-04 FA 149 COD-XML Standards build bug # 3416863
12: -- Changed the TBH calls of the packages: igf_gr_rfms_pkg
13: -- veramach 29-Jan-2004 Bug 3408092 Added 2004-2005 in g_ver_num checks
14: -----------------------------------------------------------------------------------
15: -- veramach 10-Dec-2003 FA 131 COD Updates
16: -- Removed function get_rep_pell_id

Line 113: FROM igf_gr_rfms rfms

109: CURSOR chk_ex_orig_rec (cp_base_id igf_ap_fa_base_rec.base_id%TYPE,
110: cp_transaction_num igf_ap_ISIR_matched.transaction_num%TYPE)
111: IS
112: SELECT 'X'
113: FROM igf_gr_rfms rfms
114: WHERE rfms.base_id = cp_base_id
115: AND rfms.orig_action_code in ('A','S')
116: AND rfms.transaction_num <> cp_transaction_num ;
117:

Line 133: FUNCTION get_cycle_year (p_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,

129: RETURN FALSE;
130: END IF;
131: END chk_orig_isir_exists;
132:
133: FUNCTION get_cycle_year (p_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,
134: p_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE)
135: RETURN VARCHAR2
136: IS
137: --------------------------------------------------------------------------------------------

Line 134: p_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE)

130: END IF;
131: END chk_orig_isir_exists;
132:
133: FUNCTION get_cycle_year (p_ci_cal_type igf_gr_rfms.ci_cal_type%TYPE,
134: p_ci_sequence_number igf_gr_rfms.ci_sequence_number%TYPE)
135: RETURN VARCHAR2
136: IS
137: --------------------------------------------------------------------------------------------
138: --

Line 612: p_rfmb_id OUT NOCOPY igf_gr_rfms_batch.rfmb_id%TYPE,

608: FUNCTION get_pell_header (p_ver_num IN VARCHAR2,
609: p_cycle_year IN VARCHAR2,
610: p_rep_pell_id IN igf_gr_pell_setup_all.rep_pell_id%TYPE,
611: p_batch_type IN VARCHAR2,
612: p_rfmb_id OUT NOCOPY igf_gr_rfms_batch.rfmb_id%TYPE,
613: p_batch_id OUT NOCOPY VARCHAR2,
614: p_ci_cal_type IN VARCHAR2,
615: p_ci_sequence_number IN NUMBER)
616: RETURN VARCHAR2

Line 678: -- Insert Batch ID of this batch into igf_gr_Rfms_batch table

674: -- Header Record Length=100, this is same length as that of data record
675: --
676:
677: --
678: -- Insert Batch ID of this batch into igf_gr_Rfms_batch table
679: --
680:
681:
682: l_rowid := NULL;

Line 684: igf_gr_rfms_batch_pkg.insert_row (

680:
681:
682: l_rowid := NULL;
683:
684: igf_gr_rfms_batch_pkg.insert_row (
685: x_rowid => l_rowid,
686: x_rfmb_id => p_rfmb_id,
687: x_batch_id => p_batch_id,
688: x_data_rec_length => ln_data_rec_len,

Line 839: CURSOR cur_rfms_batch ( p_batch_id igf_gr_rfms_batch_all.batch_id%TYPE)

835: file_type = p_file_type;
836:
837: trailer_rec cur_trailer%ROWTYPE;
838:
839: CURSOR cur_rfms_batch ( p_batch_id igf_gr_rfms_batch_all.batch_id%TYPE)
840: IS
841: SELECT *
842: FROM
843: igf_gr_rfms_batch

Line 843: igf_gr_rfms_batch

839: CURSOR cur_rfms_batch ( p_batch_id igf_gr_rfms_batch_all.batch_id%TYPE)
840: IS
841: SELECT *
842: FROM
843: igf_gr_rfms_batch
844: WHERE
845: batch_id = p_batch_id
846: FOR UPDATE OF rfms_ack_dt NOWAIT;
847:

Line 853: CURSOR cur_gr_rfms(p_rfmb_id igf_gr_rfms.rfmb_id%TYPE)

849:
850:
851:
852:
853: CURSOR cur_gr_rfms(p_rfmb_id igf_gr_rfms.rfmb_id%TYPE)
854: IS
855: SELECT
856: *
857: FROM

Line 858: igf_gr_rfms

854: IS
855: SELECT
856: *
857: FROM
858: igf_gr_rfms
859: WHERE
860: rfmb_id = p_rfmb_id AND
861: orig_action_code = 'S';
862:

Line 865: CURSOR cur_gr_rfms_disb(p_rfmb_id igf_gr_rfms_disb.rfmb_id%TYPE)

861: orig_action_code = 'S';
862:
863: cur_get_rfms cur_gr_rfms%ROWTYPE;
864:
865: CURSOR cur_gr_rfms_disb(p_rfmb_id igf_gr_rfms_disb.rfmb_id%TYPE)
866: IS
867: SELECT
868: *
869: FROM

Line 870: igf_gr_rfms_disb

866: IS
867: SELECT
868: *
869: FROM
870: igf_gr_rfms_disb
871: WHERE
872: rfmb_id = p_rfmb_id AND
873: disb_ack_act_status = 'S';
874:

Line 881: l_error_code igf_gr_rfms_error.edit_code%TYPE;

877: l_rfms_process_dt VARCHAR2(200);
878: l_batch_rej_reason VARCHAR2(300);
879: l_rowid VARCHAR2(25);
880: l_count NUMBER;
881: l_error_code igf_gr_rfms_error.edit_code%TYPE;
882: lb_error_cd BOOLEAN := FALSE;
883: l_rfmb_id igf_gr_rfms.rfmb_id%TYPE;
884: l_disb_rfmb_id igf_gr_rfms_disb.rfmb_id%TYPE;
885:

Line 883: l_rfmb_id igf_gr_rfms.rfmb_id%TYPE;

879: l_rowid VARCHAR2(25);
880: l_count NUMBER;
881: l_error_code igf_gr_rfms_error.edit_code%TYPE;
882: lb_error_cd BOOLEAN := FALSE;
883: l_rfmb_id igf_gr_rfms.rfmb_id%TYPE;
884: l_disb_rfmb_id igf_gr_rfms_disb.rfmb_id%TYPE;
885:
886: BEGIN
887:

Line 884: l_disb_rfmb_id igf_gr_rfms_disb.rfmb_id%TYPE;

880: l_count NUMBER;
881: l_error_code igf_gr_rfms_error.edit_code%TYPE;
882: lb_error_cd BOOLEAN := FALSE;
883: l_rfmb_id igf_gr_rfms.rfmb_id%TYPE;
884: l_disb_rfmb_id igf_gr_rfms_disb.rfmb_id%TYPE;
885:
886: BEGIN
887:
888: l_count := 1;

Line 920: -- Update the igf_gr_rfms_batch table to reflect new values

916:
917: IF LTRIM(RTRIM(l_file_name)) = 'GRANT HDR' THEN -- Remove LIKE, put =
918:
919: --
920: -- Update the igf_gr_rfms_batch table to reflect new values
921: -- This is done only for #O and #D Files
922: --
923: IF p_file_type IN ('GR_RFMS_ORIG','GR_RFMS_DISB_ORIG') THEN
924: OPEN cur_rfms_batch(p_batch_id);

Line 931: igf_gr_rfms_batch_pkg.update_row (

927: CLOSE cur_rfms_batch;
928: RAISE batch_not_in_system;
929: END IF;
930:
931: igf_gr_rfms_batch_pkg.update_row (
932: x_rowid => rfms_batch_rec.row_id,
933: x_rfmb_id => rfms_batch_rec.rfmb_id,
934: x_batch_id => rfms_batch_rec.batch_id,
935: x_data_rec_length => rfms_batch_rec.data_rec_length,

Line 1005: igf_gr_rfms_pkg.update_row(

1001: FOR cur_get_rfms IN cur_gr_rfms(l_rfmb_id)
1002: LOOP
1003: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID') ||' : ' || cur_get_rfms.origination_id);
1004:
1005: igf_gr_rfms_pkg.update_row(
1006: x_rowid => cur_get_rfms.row_id,
1007: x_origination_id => cur_get_rfms.origination_id,
1008: x_ci_cal_type => cur_get_rfms.ci_cal_type,
1009: x_ci_sequence_number => cur_get_rfms.ci_sequence_number,

Line 1077: igf_gr_rfms_disb_pkg.update_row (

1073: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID') ||' : ' || cur_get_rfms_disb.origination_id
1074: ||' , '
1075: ||igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_REF_NUM') ||' : ' || cur_get_rfms_disb.disb_ref_num);
1076:
1077: igf_gr_rfms_disb_pkg.update_row (
1078: x_rowid => cur_get_rfms_disb.row_id,
1079: x_rfmd_id => cur_get_rfms_disb.rfmd_id ,
1080: x_origination_id => cur_get_rfms_disb.origination_id,
1081: x_disb_ref_num => cur_get_rfms_disb.disb_ref_num,

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 1190: igf_gr_rfms

1186: IS
1187: SELECT
1188: ver_status_code
1189: FROM
1190: igf_gr_rfms
1191: WHERE
1192: origination_id = p_orig_id;
1193:
1194: rfms_dat_rec cur_rfms_dat%ROWTYPE;

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 1238: igf_gr_rfms_disb

1234: IS
1235: SELECT
1236: MIN(disb_ref_num)
1237: FROM
1238: igf_gr_rfms_disb
1239: WHERE
1240: origination_id = p_orig_id;
1241:
1242: ln_min_num NUMBER(10);

Line 1330: igf_gr_rfms

1326: SELECT
1327: origination_id,
1328: secondary_efc_cd
1329: FROM
1330: igf_gr_rfms
1331: WHERE
1332: base_id = p_base_id;
1333:
1334: get_orgn_rec cur_get_orgn%ROWTYPE;

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 1404: igf_gr_rfms pell,

1400: IS
1401: SELECT
1402: batch.rfms_ack_batch_id
1403: FROM
1404: igf_gr_rfms pell,
1405: igf_gr_rfms_batch batch
1406: WHERE
1407: origination_id = p_orig_id AND
1408: pell.rfmb_id = batch.rfmb_id AND

Line 1405: igf_gr_rfms_batch batch

1401: SELECT
1402: batch.rfms_ack_batch_id
1403: FROM
1404: igf_gr_rfms pell,
1405: igf_gr_rfms_batch batch
1406: WHERE
1407: origination_id = p_orig_id AND
1408: pell.rfmb_id = batch.rfmb_id AND
1409: batch.rfms_ack_batch_id IS NOT NULL;

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 2751: igf_gr_rfms pell

2747: CURSOR cur_get_pell (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE)
2748: IS
2749: SELECT pell.*
2750: FROM
2751: igf_gr_rfms pell
2752: WHERE
2753: base_id = p_base_id
2754: FOR UPDATE OF current_ssn;
2755:

Line 2774: igf_gr_rfms_pkg.update_row(

2770: get_pell_rec.current_ssn := get_ssn_digits(p_cur_ssn);
2771: get_pell_rec.rfmb_id := NULL;
2772: get_pell_rec.orig_action_code := 'R';
2773:
2774: igf_gr_rfms_pkg.update_row(
2775: x_rowid => get_pell_rec.row_id,
2776: x_origination_id => get_pell_rec.origination_id,
2777: x_ci_cal_type => get_pell_rec.ci_cal_type,
2778: x_ci_sequence_number => get_pell_rec.ci_sequence_number,

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

Line 2885: igf_gr_rfms pell

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
2886: WHERE
2887: award_id = p_award_id;
2888:
2889:

Line 2932: p_batch_id IN igf_gr_rfms_batch_all.batch_id%TYPE,

2928:
2929: END update_pell_status;
2930:
2931: PROCEDURE match_file_version (p_version IN igf_lookups_view.lookup_code%TYPE,
2932: p_batch_id IN igf_gr_rfms_batch_all.batch_id%TYPE,
2933: p_message OUT NOCOPY fnd_new_messages.message_name%TYPE)
2934: IS
2935:
2936: --