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_LI_IMPORT dependencies on IGF_GR_RFMS_BATCH_ALL

Line 680: cp_batch_id igf_gr_rfms_batch_all.batch_id%TYPE

676: */
677:
678: -- Get the details of duplicate batch id
679: CURSOR c_chk_dup_batch_dtls(
680: cp_batch_id igf_gr_rfms_batch_all.batch_id%TYPE
681: ) IS
682: SELECT pb.rfmb_id
683: FROM igf_gr_rfms_batch_all pb
684: WHERE pb.batch_id = cp_batch_id;

Line 683: FROM igf_gr_rfms_batch_all pb

679: CURSOR c_chk_dup_batch_dtls(
680: cp_batch_id igf_gr_rfms_batch_all.batch_id%TYPE
681: ) IS
682: SELECT pb.rfmb_id
683: FROM igf_gr_rfms_batch_all pb
684: WHERE pb.batch_id = cp_batch_id;
685:
686: lc_chk_dup_batch_dtls c_chk_dup_batch_dtls%ROWTYPE;
687:

Line 689: l_rfmb_id igf_gr_rfms_batch_all.rfmb_id%TYPE;

685:
686: lc_chk_dup_batch_dtls c_chk_dup_batch_dtls%ROWTYPE;
687:
688: l_row_id ROWID;
689: l_rfmb_id igf_gr_rfms_batch_all.rfmb_id%TYPE;
690: l_batch_id igf_gr_rfms_batch_all.batch_id%TYPE;
691: l_rfms_ack_batch_id igf_gr_rfms_batch_all.rfms_ack_batch_id%TYPE;
692: l_data_rec_length igf_gr_rfms_batch_all.data_rec_length%TYPE;
693:

Line 690: l_batch_id igf_gr_rfms_batch_all.batch_id%TYPE;

686: lc_chk_dup_batch_dtls c_chk_dup_batch_dtls%ROWTYPE;
687:
688: l_row_id ROWID;
689: l_rfmb_id igf_gr_rfms_batch_all.rfmb_id%TYPE;
690: l_batch_id igf_gr_rfms_batch_all.batch_id%TYPE;
691: l_rfms_ack_batch_id igf_gr_rfms_batch_all.rfms_ack_batch_id%TYPE;
692: l_data_rec_length igf_gr_rfms_batch_all.data_rec_length%TYPE;
693:
694: BEGIN

Line 691: l_rfms_ack_batch_id igf_gr_rfms_batch_all.rfms_ack_batch_id%TYPE;

687:
688: l_row_id ROWID;
689: l_rfmb_id igf_gr_rfms_batch_all.rfmb_id%TYPE;
690: l_batch_id igf_gr_rfms_batch_all.batch_id%TYPE;
691: l_rfms_ack_batch_id igf_gr_rfms_batch_all.rfms_ack_batch_id%TYPE;
692: l_data_rec_length igf_gr_rfms_batch_all.data_rec_length%TYPE;
693:
694: BEGIN
695:

Line 692: l_data_rec_length igf_gr_rfms_batch_all.data_rec_length%TYPE;

688: l_row_id ROWID;
689: l_rfmb_id igf_gr_rfms_batch_all.rfmb_id%TYPE;
690: l_batch_id igf_gr_rfms_batch_all.batch_id%TYPE;
691: l_rfms_ack_batch_id igf_gr_rfms_batch_all.rfms_ack_batch_id%TYPE;
692: l_data_rec_length igf_gr_rfms_batch_all.data_rec_length%TYPE;
693:
694: BEGIN
695:
696: -- Check if duplicate batch records exists in the system, if present then return the existing batch id

Line 750: p_rfmb_id igf_gr_rfms_batch_all.rfmb_id%TYPE,

746:
747:
748: FUNCTION create_pell_disb(
749: p_pell_disb_int c_pell_disb_int%ROWTYPE,
750: p_rfmb_id igf_gr_rfms_batch_all.rfmb_id%TYPE,
751: p_disb_date igf_aw_awd_disb_all.disb_date%TYPE,
752: p_disb_amt igf_aw_awd_disb_all.disb_net_amt%TYPE
753: ) RETURN BOOLEAN AS
754: /*

Line 855: l_rfmb_id igf_gr_rfms_batch_all.rfmb_id%TYPE;

851: AND disb.trans_type = 'A';
852:
853: lc_awd_disb c_awd_disb%ROWTYPE;
854:
855: l_rfmb_id igf_gr_rfms_batch_all.rfmb_id%TYPE;
856: l_debug_str fnd_log_messages.message_text%TYPE := 'IGFGR10B.pls Function import_pell_disb :: ';
857: l_disb_import_status VARCHAR2(1) := 'I';
858: l_disb_batch_id VARCHAR2(30);
859:

Line 1215: cp_batch_id igf_gr_rfms_batch_all.batch_id%TYPE

1211: */
1212:
1213: -- Get the details of duplicate batch id
1214: CURSOR c_chk_dup_batch_dtls(
1215: cp_batch_id igf_gr_rfms_batch_all.batch_id%TYPE
1216: ) IS
1217: SELECT pb.rfmb_id
1218: FROM igf_gr_rfms_batch_all pb
1219: WHERE pb.batch_id = cp_batch_id;

Line 1218: FROM igf_gr_rfms_batch_all pb

1214: CURSOR c_chk_dup_batch_dtls(
1215: cp_batch_id igf_gr_rfms_batch_all.batch_id%TYPE
1216: ) IS
1217: SELECT pb.rfmb_id
1218: FROM igf_gr_rfms_batch_all pb
1219: WHERE pb.batch_id = cp_batch_id;
1220:
1221: lc_chk_dup_batch_dtls c_chk_dup_batch_dtls%ROWTYPE;
1222:

Line 1224: l_rfmb_id igf_gr_rfms_batch_all.rfmb_id%TYPE;

1220:
1221: lc_chk_dup_batch_dtls c_chk_dup_batch_dtls%ROWTYPE;
1222:
1223: l_row_id ROWID;
1224: l_rfmb_id igf_gr_rfms_batch_all.rfmb_id%TYPE;
1225: l_batch_id igf_gr_rfms_batch_all.batch_id%TYPE;
1226: l_rfms_ack_batch_id igf_gr_rfms_batch_all.rfms_ack_batch_id%TYPE;
1227: l_data_rec_length igf_gr_rfms_batch_all.data_rec_length%TYPE;
1228:

Line 1225: l_batch_id igf_gr_rfms_batch_all.batch_id%TYPE;

1221: lc_chk_dup_batch_dtls c_chk_dup_batch_dtls%ROWTYPE;
1222:
1223: l_row_id ROWID;
1224: l_rfmb_id igf_gr_rfms_batch_all.rfmb_id%TYPE;
1225: l_batch_id igf_gr_rfms_batch_all.batch_id%TYPE;
1226: l_rfms_ack_batch_id igf_gr_rfms_batch_all.rfms_ack_batch_id%TYPE;
1227: l_data_rec_length igf_gr_rfms_batch_all.data_rec_length%TYPE;
1228:
1229: BEGIN

Line 1226: l_rfms_ack_batch_id igf_gr_rfms_batch_all.rfms_ack_batch_id%TYPE;

1222:
1223: l_row_id ROWID;
1224: l_rfmb_id igf_gr_rfms_batch_all.rfmb_id%TYPE;
1225: l_batch_id igf_gr_rfms_batch_all.batch_id%TYPE;
1226: l_rfms_ack_batch_id igf_gr_rfms_batch_all.rfms_ack_batch_id%TYPE;
1227: l_data_rec_length igf_gr_rfms_batch_all.data_rec_length%TYPE;
1228:
1229: BEGIN
1230:

Line 1227: l_data_rec_length igf_gr_rfms_batch_all.data_rec_length%TYPE;

1223: l_row_id ROWID;
1224: l_rfmb_id igf_gr_rfms_batch_all.rfmb_id%TYPE;
1225: l_batch_id igf_gr_rfms_batch_all.batch_id%TYPE;
1226: l_rfms_ack_batch_id igf_gr_rfms_batch_all.rfms_ack_batch_id%TYPE;
1227: l_data_rec_length igf_gr_rfms_batch_all.data_rec_length%TYPE;
1228:
1229: BEGIN
1230:
1231: -- Check if duplicate batch records exists in the system, if present then return the existing batch id

Line 1284: p_rfmb_id igf_gr_rfms_batch_all.rfmb_id%TYPE

1280:
1281: FUNCTION create_pell_orig(
1282: p_pell_orig_int c_pell_orig_int%ROWTYPE,
1283: p_isir_details c_isir_details%ROWTYPE,
1284: p_rfmb_id igf_gr_rfms_batch_all.rfmb_id%TYPE
1285: ) RETURN BOOLEAN AS
1286: /*
1287: || Created By : brajendr
1288: || Created On : 19-Jun-2003

Line 1480: l_rfmb_id igf_gr_rfms_batch_all.rfmb_id%TYPE;

1476: lc_isir_details c_isir_details%ROWTYPE;
1477: l_pell_import_status igf_aw_li_pell_ints.import_status_type%TYPE := 'I';
1478: l_enrl_status igs_en_stdnt_ps_att_all.derived_att_type%TYPE;
1479: l_origination_id igf_aw_li_pell_ints.origination_id_txt%TYPE;
1480: l_rfmb_id igf_gr_rfms_batch_all.rfmb_id%TYPE;
1481: l_db_cr_flag igf_gr_rfms_disb.db_cr_flag%TYPE;
1482: l_rfmd_id igf_gr_rfms_disb.rfmd_id%TYPE;
1483: l_disb_num_prmpt igf_lookups_view.meaning%TYPE;
1484: l_processing igf_lookups_view.meaning%TYPE;