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_XML dependencies on IGF_GR_RFMS

Line 347: cp_report_entity_id igf_gr_rfms.rep_entity_id_txt%TYPE ) IS

343:
344: -- To check pell origination records exists or not with given report entity id.
345: CURSOR cur_rep_entity ( cp_cal_type igs_ca_inst.cal_type%TYPE,
346: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
347: cp_report_entity_id igf_gr_rfms.rep_entity_id_txt%TYPE ) IS
348: SELECT rfms.origination_id
349: FROM IGF_GR_RFMS rfms
350: WHERE rfms.ci_cal_type = cp_cal_type
351: AND rfms.ci_sequence_number = cp_sequence_number

Line 349: FROM IGF_GR_RFMS rfms

345: CURSOR cur_rep_entity ( cp_cal_type igs_ca_inst.cal_type%TYPE,
346: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
347: cp_report_entity_id igf_gr_rfms.rep_entity_id_txt%TYPE ) IS
348: SELECT rfms.origination_id
349: FROM IGF_GR_RFMS rfms
350: WHERE rfms.ci_cal_type = cp_cal_type
351: AND rfms.ci_sequence_number = cp_sequence_number
352: AND rfms.rep_entity_id_txt = cp_report_entity_id;
353:

Line 357: cp_report_entity_id igf_gr_rfms.rep_entity_id_txt%TYPE,

353:
354: -- To check pell origination records exists or not with given report and attend entity ids.
355: CURSOR cur_attd_entity ( cp_cal_type igs_ca_inst.cal_type%TYPE,
356: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
357: cp_report_entity_id igf_gr_rfms.rep_entity_id_txt%TYPE,
358: cp_attend_entity_id igf_gr_rfms.atd_entity_id_txt%TYPE ) IS
359: SELECT rfms.origination_id
360: FROM IGF_GR_RFMS rfms
361: WHERE rfms.ci_cal_type = cp_cal_type

Line 358: cp_attend_entity_id igf_gr_rfms.atd_entity_id_txt%TYPE ) IS

354: -- To check pell origination records exists or not with given report and attend entity ids.
355: CURSOR cur_attd_entity ( cp_cal_type igs_ca_inst.cal_type%TYPE,
356: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
357: cp_report_entity_id igf_gr_rfms.rep_entity_id_txt%TYPE,
358: cp_attend_entity_id igf_gr_rfms.atd_entity_id_txt%TYPE ) IS
359: SELECT rfms.origination_id
360: FROM IGF_GR_RFMS rfms
361: WHERE rfms.ci_cal_type = cp_cal_type
362: AND rfms.ci_sequence_number = cp_sequence_number

Line 360: FROM IGF_GR_RFMS rfms

356: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
357: cp_report_entity_id igf_gr_rfms.rep_entity_id_txt%TYPE,
358: cp_attend_entity_id igf_gr_rfms.atd_entity_id_txt%TYPE ) IS
359: SELECT rfms.origination_id
360: FROM IGF_GR_RFMS rfms
361: WHERE rfms.ci_cal_type = cp_cal_type
362: AND rfms.ci_sequence_number = cp_sequence_number
363: AND rfms.rep_entity_id_txt = cp_report_entity_id
364: AND rfms.atd_entity_id_txt = cp_attend_entity_id;

Line 377: FROM IGF_GR_RFMS rfms

373: CURSOR cur_person_number ( cp_cal_type igs_ca_inst.cal_type%TYPE,
374: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
375: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE ) IS
376: SELECT 'x'
377: FROM IGF_GR_RFMS rfms
378: WHERE rfms.ci_cal_type = cp_cal_type
379: AND rfms.ci_sequence_number = cp_sequence_number
380: AND rfms.base_id = cp_base_id;
381:

Line 1150: CURSOR cur_pymnt_isir ( cp_base_id igf_gr_rfms.base_id%TYPE ) IS

1146: AND rep.rep_entity_id_txt = cp_rep_entity_id_txt
1147: AND atd.atd_entity_id_txt = cp_atd_entity_id_txt;
1148: rec_attending_entity cur_attending_entity%ROWTYPE;
1149:
1150: CURSOR cur_pymnt_isir ( cp_base_id igf_gr_rfms.base_id%TYPE ) IS
1151: SELECT isir.transaction_num
1152: FROM IGF_AP_ISIR_MATCHED_ALL isir
1153: WHERE isir.base_id = cp_base_id
1154: AND isir.payment_isir = 'Y'

Line 1180: l_pell_amt igf_gr_rfms.pell_amount%TYPE;

1176: ln_num_disb_with_relflag_true NUMBER(3);
1177:
1178: l_isir_present BOOLEAN;
1179: lb_spoint_est BOOLEAN;
1180: l_pell_amt igf_gr_rfms.pell_amount%TYPE;
1181: l_ft_pell_amt igf_gr_rfms_all.ft_pell_amount%TYPE;
1182: l_return_status VARCHAR2(1);
1183: l_return_mesg_text VARCHAR2(2000);
1184:

Line 1181: l_ft_pell_amt igf_gr_rfms_all.ft_pell_amount%TYPE;

1177:
1178: l_isir_present BOOLEAN;
1179: lb_spoint_est BOOLEAN;
1180: l_pell_amt igf_gr_rfms.pell_amount%TYPE;
1181: l_ft_pell_amt igf_gr_rfms_all.ft_pell_amount%TYPE;
1182: l_return_status VARCHAR2(1);
1183: l_return_mesg_text VARCHAR2(2000);
1184:
1185: BEGIN

Line 1428: p_base_id IN IGF_GR_RFMS_ALL.BASE_ID%TYPE,

1424: p_report_entity_id IN VARCHAR2,
1425: p_rep_dummy IN VARCHAR2,
1426: p_attend_entity_id IN VARCHAR2,
1427: p_atd_dummy IN VARCHAR2,
1428: p_base_id IN IGF_GR_RFMS_ALL.BASE_ID%TYPE,
1429: p_per_dummy IN NUMBER,
1430: p_persid_grp IN NUMBER
1431: )
1432: IS

Line 1831: FROM IGF_GR_RFMS rfms

1827: WHERE disb.document_id_txt = cp_document_id_txt;
1828:
1829: CURSOR cur_rfms_orig ( cp_origination_id VARCHAR2) IS
1830: SELECT rfms.*
1831: FROM IGF_GR_RFMS rfms
1832: WHERE rfms.origination_id = cp_origination_id;
1833:
1834: CURSOR cur_sys_disb ( cp_award_id NUMBER, cp_disb_num NUMBER, cp_disb_seq NUMBER) IS
1835: SELECT disb.rowid row_id,disb.*

Line 1841: l_pell_amt igf_gr_rfms.pell_amount%TYPE;

1837: WHERE disb.award_id = cp_award_id
1838: AND disb.disb_num = cp_disb_num
1839: AND disb.disb_seq_num = cp_disb_seq;
1840:
1841: l_pell_amt igf_gr_rfms.pell_amount%TYPE;
1842: l_ft_pell_amt igf_gr_rfms_all.ft_pell_amount%TYPE;
1843: l_return_status VARCHAR2(1);
1844: l_return_mesg_text VARCHAR2(2000);
1845:

Line 1842: l_ft_pell_amt igf_gr_rfms_all.ft_pell_amount%TYPE;

1838: AND disb.disb_num = cp_disb_num
1839: AND disb.disb_seq_num = cp_disb_seq;
1840:
1841: l_pell_amt igf_gr_rfms.pell_amount%TYPE;
1842: l_ft_pell_amt igf_gr_rfms_all.ft_pell_amount%TYPE;
1843: l_return_status VARCHAR2(1);
1844: l_return_mesg_text VARCHAR2(2000);
1845:
1846: BEGIN

Line 1860: igf_gr_rfms_pkg.update_row ( x_rowid => rfms_rec.row_id,

1856: IF NVL(rfms_rec.orig_action_code,'*') = 'R' THEN
1857: rfms_rec.orig_action_code := 'S';
1858: END IF;
1859:
1860: igf_gr_rfms_pkg.update_row ( x_rowid => rfms_rec.row_id,
1861: x_origination_id => rfms_rec.origination_id,
1862: x_ci_cal_type => rfms_rec.ci_cal_type,
1863: x_ci_sequence_number => rfms_rec.ci_sequence_number,
1864: x_base_id => rfms_rec.base_id,

Line 2046: -- update IGF_GR_RFMS_ALL.ORIG_ACTION_CODE to sent

2042: x_doc_type => 'PELL',
2043: x_full_resp_code => NULL,
2044: x_mode => 'R');
2045: --
2046: -- update IGF_GR_RFMS_ALL.ORIG_ACTION_CODE to sent
2047: -- update IGF_AW_DB_CHG_DTLS.DISB_STATUS to sent
2048: update_status(p_document_id);
2049:
2050: -- print out xml outfile