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_AP_ISIR_IMPORT_PKG dependencies on IGF_AP_ISIR_MATCHED

Line 4: g_ISIR_rec igf_ap_ISIR_matched%ROWTYPE;

1: PACKAGE BODY IGF_AP_ISIR_IMPORT_PKG AS
2: /* $Header: IGFAP01B.pls 120.2 2006/02/10 02:47:08 bvisvana noship $ */
3:
4: g_ISIR_rec igf_ap_ISIR_matched%ROWTYPE;
5: g_base_rec igf_ap_fa_base_rec%ROWTYPE;
6: g_paid_efc igf_ap_fa_base_rec.efc_f%TYPE;
7: g_pell_grant_elig_flag igf_ap_fa_base_rec_all.pell_eligible%TYPE;
8: g_nslds_match_flag igf_ap_fa_base_rec.nslds_eligible%TYPE;

Line 9: g_verification_flag igf_ap_ISIR_matched.verification_flag%TYPE;

5: g_base_rec igf_ap_fa_base_rec%ROWTYPE;
6: g_paid_efc igf_ap_fa_base_rec.efc_f%TYPE;
7: g_pell_grant_elig_flag igf_ap_fa_base_rec_all.pell_eligible%TYPE;
8: g_nslds_match_flag igf_ap_fa_base_rec.nslds_eligible%TYPE;
9: g_verification_flag igf_ap_ISIR_matched.verification_flag%TYPE;
10: g_ISIR_id igf_ap_ISIR_matched.ISIR_id%TYPE;
11: g_base_id igf_ap_fa_base_rec.base_id%TYPE;
12: g_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE;
13: g_msg_body VARCHAR2(4000) := NULL;

Line 10: g_ISIR_id igf_ap_ISIR_matched.ISIR_id%TYPE;

6: g_paid_efc igf_ap_fa_base_rec.efc_f%TYPE;
7: g_pell_grant_elig_flag igf_ap_fa_base_rec_all.pell_eligible%TYPE;
8: g_nslds_match_flag igf_ap_fa_base_rec.nslds_eligible%TYPE;
9: g_verification_flag igf_ap_ISIR_matched.verification_flag%TYPE;
10: g_ISIR_id igf_ap_ISIR_matched.ISIR_id%TYPE;
11: g_base_id igf_ap_fa_base_rec.base_id%TYPE;
12: g_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE;
13: g_msg_body VARCHAR2(4000) := NULL;
14: g_transaction_num CHAR(13);

Line 127: FROM igf_ap_isir_matched

123: third_college,
124: fourth_college,
125: fifth_college,
126: sixth_college
127: FROM igf_ap_isir_matched
128: WHERE isir_id = p_ISIR_id;
129: l_get_base_id_rec cur_get_base_id%ROWTYPE;
130:
131: x_fed_sch_cd igs_or_org_alt_ids.org_alternate_id%TYPE;

Line 862: fnd_stats.gather_table_stats(ownname => 'IGF', tabname => 'IGF_AP_ISIR_MATCHED_ALL' , cascade => TRUE);

858:
859: -- gather Statistics RAMMOHAN commented for testing
860: log_debug_message(' Starting to gather statistics. ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
861: fnd_stats.gather_table_stats(ownname => 'IGF', tabname => 'IGF_AP_ISIR_INTS_ALL' , cascade => TRUE);
862: fnd_stats.gather_table_stats(ownname => 'IGF', tabname => 'IGF_AP_ISIR_MATCHED_ALL' , cascade => TRUE);
863: log_debug_message(' End of Statistics gathering. ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
864:
865: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
866: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_isir_import_pkg.main_import_process.debug','After gathering Statistics: ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));

Line 973: PROCEDURE update_matched_ISIR (p_ISIR_id igf_ap_ISIR_matched_all.ISIR_id%TYPE,

969: igs_ge_msg_stack.conc_exception_hndl;
970: END main_import_process;
971:
972:
973: PROCEDURE update_matched_ISIR (p_ISIR_id igf_ap_ISIR_matched_all.ISIR_id%TYPE,
974: p_system_record_type igf_ap_ISIR_matched_all.system_record_type%TYPE,
975: p_payment_ISIR igf_ap_ISIR_matched_all.payment_ISIR%TYPE,
976: p_active_ISIR igf_ap_ISIR_matched_all.active_ISIR%TYPE)
977: IS

Line 974: p_system_record_type igf_ap_ISIR_matched_all.system_record_type%TYPE,

970: END main_import_process;
971:
972:
973: PROCEDURE update_matched_ISIR (p_ISIR_id igf_ap_ISIR_matched_all.ISIR_id%TYPE,
974: p_system_record_type igf_ap_ISIR_matched_all.system_record_type%TYPE,
975: p_payment_ISIR igf_ap_ISIR_matched_all.payment_ISIR%TYPE,
976: p_active_ISIR igf_ap_ISIR_matched_all.active_ISIR%TYPE)
977: IS
978: /*

Line 975: p_payment_ISIR igf_ap_ISIR_matched_all.payment_ISIR%TYPE,

971:
972:
973: PROCEDURE update_matched_ISIR (p_ISIR_id igf_ap_ISIR_matched_all.ISIR_id%TYPE,
974: p_system_record_type igf_ap_ISIR_matched_all.system_record_type%TYPE,
975: p_payment_ISIR igf_ap_ISIR_matched_all.payment_ISIR%TYPE,
976: p_active_ISIR igf_ap_ISIR_matched_all.active_ISIR%TYPE)
977: IS
978: /*
979: || Created By : brajendr

Line 976: p_active_ISIR igf_ap_ISIR_matched_all.active_ISIR%TYPE)

972:
973: PROCEDURE update_matched_ISIR (p_ISIR_id igf_ap_ISIR_matched_all.ISIR_id%TYPE,
974: p_system_record_type igf_ap_ISIR_matched_all.system_record_type%TYPE,
975: p_payment_ISIR igf_ap_ISIR_matched_all.payment_ISIR%TYPE,
976: p_active_ISIR igf_ap_ISIR_matched_all.active_ISIR%TYPE)
977: IS
978: /*
979: || Created By : brajendr
980: || Created On : 08-NOV-2000

Line 993: FROM igf_ap_ISIR_matched ism

989: */
990:
991: CURSOR cur_upd_ISIR IS
992: SELECT ism.*
993: FROM igf_ap_ISIR_matched ism
994: WHERE ism.ISIR_id = p_ISIR_id;
995:
996:
997: cur_ISIR_rec cur_upd_ISIR%ROWTYPE;

Line 999: l_msg_class igf_ap_isir_matched.message_class_txt%TYPE;

995:
996:
997: cur_ISIR_rec cur_upd_ISIR%ROWTYPE;
998: p_c_message VARCHAR2(30);
999: l_msg_class igf_ap_isir_matched.message_class_txt%TYPE;
1000:
1001: BEGIN
1002: IF p_system_record_type = 'ORIGINAL' THEN
1003: FOR cur_ISIR_rec IN cur_upd_ISIR LOOP

Line 1008: igf_ap_ISIR_matched_pkg.update_row (x_Mode => 'R',

1004:
1005: -- get message class from data file name
1006: l_msg_class := igf_ap_matching_process_pkg.get_msg_class_from_filename(cur_ISIR_rec.data_file_name_txt);
1007:
1008: igf_ap_ISIR_matched_pkg.update_row (x_Mode => 'R',
1009: x_rowid => cur_ISIR_rec.row_id,
1010: x_ISIR_id => cur_ISIR_rec.ISIR_id,
1011: x_base_id => cur_ISIR_rec.base_id,
1012: x_batch_year => cur_ISIR_rec.batch_year,

Line 1554: p_ISIR_id igf_ap_ISIR_matched.ISIR_id%TYPE)

1550: app_exception.raise_exception;
1551: END update_ISIR_corr;
1552:
1553: PROCEDURE validate_corrections (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
1554: p_ISIR_id igf_ap_ISIR_matched.ISIR_id%TYPE)
1555: IS
1556:
1557: CURSOR cur_ISIR (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS
1558: SELECT ISIR_id

Line 1559: FROM igf_ap_ISIR_matched

1555: IS
1556:
1557: CURSOR cur_ISIR (p_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS
1558: SELECT ISIR_id
1559: FROM igf_ap_ISIR_matched
1560: WHERE base_id = p_base_id;
1561:
1562: CURSOR cur_isir_corr (cp_base_id igf_ap_fa_base_rec.base_id%TYPE ,
1563: l_isir_id igf_ap_isir_matched.isir_id%TYPE,

Line 1563: l_isir_id igf_ap_isir_matched.isir_id%TYPE,

1559: FROM igf_ap_ISIR_matched
1560: WHERE base_id = p_base_id;
1561:
1562: CURSOR cur_isir_corr (cp_base_id igf_ap_fa_base_rec.base_id%TYPE ,
1563: l_isir_id igf_ap_isir_matched.isir_id%TYPE,
1564: cp_corr_stat VARCHAR2,
1565: cp_lkup_type VARCHAR2 ) IS
1566: SELECT corr.ISIR_id,
1567: corr.ISIRc_id,

Line 1598: ln_isir_id igf_ap_isir_matched.isir_id%TYPE;

1594: lv_column_name VARCHAR2(30);
1595: lv_column_meaning igf_lookups_view.meaning%TYPE ;
1596: ln_count_corr NUMBER := 99999;
1597: l_corr_stat VARCHAR2(30) ;
1598: ln_isir_id igf_ap_isir_matched.isir_id%TYPE;
1599: l_lkup_type VARCHAR2(60);
1600:
1601: BEGIN
1602:

Line 1618: lv_stmt := 'SELECT '||lv_column_name ||' FROM igf_ap_ISIR_matched where ISIR_id = :l_isir_id ' ;

1614: lv_column_meaning := rec_ISIR_corr.meaning;
1615: ln_isir_id := TO_CHAR (p_isir_id) ;
1616:
1617: lv_cur := DBMS_SQL.OPEN_CURSOR;
1618: lv_stmt := 'SELECT '||lv_column_name ||' FROM igf_ap_ISIR_matched where ISIR_id = :l_isir_id ' ;
1619: DBMS_SQL.PARSE(lv_cur,lv_stmt,6);
1620: DBMS_SQL.BIND_VARIABLE(lv_cur, 'l_isir_id', ln_isir_id);
1621:
1622: DBMS_SQL.DEFINE_COLUMN(lv_cur,1,lv_retval,30);