APPS.IGF_GR_LI_IMPORT dependencies on IGF_GR_RFMS_DISB

Line 601: FROM igf_gr_rfms_disb_all pdb

597: CURSOR c_get_pell_disb(
598: cp_origination_id igf_gr_rfms_all.origination_id%TYPE
599: ) IS
600: SELECT ROWID row_id, pdb.rfmd_id, pdb.rfmb_id
601: FROM igf_gr_rfms_disb_all pdb
602: WHERE pdb.origination_id = cp_origination_id;
603:
604: l_return_val VARCHAR2(1) := 'E';
605: l_debug_str fnd_log_messages.message_text%TYPE := 'IGFGR10B.pls Procedure delete_existing_pell_rec :: ';

Line 632: igf_gr_rfms_disb_pkg.delete_row(lc_get_pell_disb.row_id);

628: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
629: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.delete_existing_pell_rec.debug', ' Deleting Pell Disb : ' || lc_get_pell_disb.rfmd_id);
630: END IF;
631:
632: igf_gr_rfms_disb_pkg.delete_row(lc_get_pell_disb.row_id);
633: END LOOP;
634:
635: -- Delete Pell Origination Record
636: igf_gr_rfms_pkg.delete_row(lc_chk_pell_orig.row_id);

Line 765: l_rfmd_id igf_gr_rfms_disb.rfmd_id%TYPE;

761: || (reverse chronological order - newest change first)
762: */
763:
764: l_row_id ROWID;
765: l_rfmd_id igf_gr_rfms_disb.rfmd_id%TYPE;
766: l_db_cr_flag igf_gr_rfms_disb.db_cr_flag%TYPE;
767:
768: BEGIN
769:

Line 766: l_db_cr_flag igf_gr_rfms_disb.db_cr_flag%TYPE;

762: */
763:
764: l_row_id ROWID;
765: l_rfmd_id igf_gr_rfms_disb.rfmd_id%TYPE;
766: l_db_cr_flag igf_gr_rfms_disb.db_cr_flag%TYPE;
767:
768: BEGIN
769:
770: -- Set the dibursement Sign Flag based on the Disb Accepted amount

Line 781: igf_gr_rfms_disb_pkg.insert_row(

777:
778: -- Create Pell Origination Record in the production table
779: l_row_id := NULL;
780: l_rfmd_id := NULL;
781: igf_gr_rfms_disb_pkg.insert_row(
782: x_mode => 'R',
783: x_rowid => l_row_id,
784: x_rfmd_id => l_rfmd_id,
785: x_origination_id => p_pell_disb_int.origination_id_txt,

Line 1471: FROM igf_gr_rfms_all porig, igf_gr_rfms_disb_all pdisb

1467: SELECT ad.disb_num, ad.disb_date, ad.disb_accepted_amt
1468: FROM igf_aw_awd_disb_all ad
1469: WHERE ad.award_id = cp_award_id
1470: AND NOT EXISTS ( SELECT pdisb.disb_ref_num
1471: FROM igf_gr_rfms_all porig, igf_gr_rfms_disb_all pdisb
1472: WHERE porig.origination_id = pdisb.origination_id
1473: AND ad.award_id = porig.award_id
1474: AND ad.disb_num = pdisb.disb_ref_num);
1475:

Line 1481: l_db_cr_flag igf_gr_rfms_disb.db_cr_flag%TYPE;

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;
1485: l_debug_str fnd_log_messages.message_text%TYPE := 'IGFGR10B.pls Procedure import_pell_orig (1) :: ';

Line 1482: l_rfmd_id igf_gr_rfms_disb.rfmd_id%TYPE;

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;
1485: l_debug_str fnd_log_messages.message_text%TYPE := 'IGFGR10B.pls Procedure import_pell_orig (1) :: ';
1486: l_error VARCHAR2(30);

Line 2347: igf_gr_rfms_disb_pkg.insert_row(

2343:
2344: -- Create Pell Origination Record in the production table
2345: l_row_id := NULL;
2346: l_rfmd_id := NULL;
2347: igf_gr_rfms_disb_pkg.insert_row(
2348: x_mode => 'R',
2349: x_rowid => l_row_id,
2350: x_rfmd_id => l_rfmd_id,
2351: x_origination_id => p_pell_orig_int.origination_id_txt,