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_INTS_ALL

Line 22: g_rec_status igf_ap_isir_ints_all.record_status%TYPE;

18:
19: -- added by rgangara as part of FA138 enh
20: g_batch_year igf_ap_batch_aw_map.batch_year%TYPE;
21: g_match_code igf_ap_record_match_all.match_code%TYPE;
22: g_rec_status igf_ap_isir_ints_all.record_status%TYPE;
23: g_rec_type igf_ap_isir_ints_all.processed_rec_type%TYPE;
24: g_message_Class igf_ap_isir_ints_all.data_file_name_txt%TYPE;
25: g_school_code igf_ap_isir_ints_all.first_college_cd%TYPE;
26: g_del_int VARCHAR2(1);

Line 23: g_rec_type igf_ap_isir_ints_all.processed_rec_type%TYPE;

19: -- added by rgangara as part of FA138 enh
20: g_batch_year igf_ap_batch_aw_map.batch_year%TYPE;
21: g_match_code igf_ap_record_match_all.match_code%TYPE;
22: g_rec_status igf_ap_isir_ints_all.record_status%TYPE;
23: g_rec_type igf_ap_isir_ints_all.processed_rec_type%TYPE;
24: g_message_Class igf_ap_isir_ints_all.data_file_name_txt%TYPE;
25: g_school_code igf_ap_isir_ints_all.first_college_cd%TYPE;
26: g_del_int VARCHAR2(1);
27: g_force_add VARCHAR2(1);

Line 24: g_message_Class igf_ap_isir_ints_all.data_file_name_txt%TYPE;

20: g_batch_year igf_ap_batch_aw_map.batch_year%TYPE;
21: g_match_code igf_ap_record_match_all.match_code%TYPE;
22: g_rec_status igf_ap_isir_ints_all.record_status%TYPE;
23: g_rec_type igf_ap_isir_ints_all.processed_rec_type%TYPE;
24: g_message_Class igf_ap_isir_ints_all.data_file_name_txt%TYPE;
25: g_school_code igf_ap_isir_ints_all.first_college_cd%TYPE;
26: g_del_int VARCHAR2(1);
27: g_force_add VARCHAR2(1);
28: g_create_inquiry VARCHAR2(1);

Line 25: g_school_code igf_ap_isir_ints_all.first_college_cd%TYPE;

21: g_match_code igf_ap_record_match_all.match_code%TYPE;
22: g_rec_status igf_ap_isir_ints_all.record_status%TYPE;
23: g_rec_type igf_ap_isir_ints_all.processed_rec_type%TYPE;
24: g_message_Class igf_ap_isir_ints_all.data_file_name_txt%TYPE;
25: g_school_code igf_ap_isir_ints_all.first_college_cd%TYPE;
26: g_del_int VARCHAR2(1);
27: g_force_add VARCHAR2(1);
28: g_create_inquiry VARCHAR2(1);
29: g_adm_source_type VARCHAR2(30);

Line 35: TYPE T_int_si_id IS TABLE OF igf_ap_isir_ints_all.si_id%TYPE;

31: g_where VARCHAR2(32000);
32: g_total_recs_fetched NUMBER;
33:
34: -- define a PL/SQL table
35: TYPE T_int_si_id IS TABLE OF igf_ap_isir_ints_all.si_id%TYPE;
36: TYPE T_int_batch_yr IS TABLE OF igf_ap_isir_ints_all.batch_year_num%TYPE;
37: TYPE T_int_orig_ssn IS TABLE OF igf_ap_isir_ints_all.original_ssn_txt%TYPE;
38: TYPE T_int_orig_id IS TABLE OF igf_ap_isir_ints_all.orig_name_id_txt%TYPE;
39:

Line 36: TYPE T_int_batch_yr IS TABLE OF igf_ap_isir_ints_all.batch_year_num%TYPE;

32: g_total_recs_fetched NUMBER;
33:
34: -- define a PL/SQL table
35: TYPE T_int_si_id IS TABLE OF igf_ap_isir_ints_all.si_id%TYPE;
36: TYPE T_int_batch_yr IS TABLE OF igf_ap_isir_ints_all.batch_year_num%TYPE;
37: TYPE T_int_orig_ssn IS TABLE OF igf_ap_isir_ints_all.original_ssn_txt%TYPE;
38: TYPE T_int_orig_id IS TABLE OF igf_ap_isir_ints_all.orig_name_id_txt%TYPE;
39:
40: TYPE T_int_prnt_req_id IS TABLE OF igf_ap_isir_ints_all.orig_name_id_txt%TYPE;

Line 37: TYPE T_int_orig_ssn IS TABLE OF igf_ap_isir_ints_all.original_ssn_txt%TYPE;

33:
34: -- define a PL/SQL table
35: TYPE T_int_si_id IS TABLE OF igf_ap_isir_ints_all.si_id%TYPE;
36: TYPE T_int_batch_yr IS TABLE OF igf_ap_isir_ints_all.batch_year_num%TYPE;
37: TYPE T_int_orig_ssn IS TABLE OF igf_ap_isir_ints_all.original_ssn_txt%TYPE;
38: TYPE T_int_orig_id IS TABLE OF igf_ap_isir_ints_all.orig_name_id_txt%TYPE;
39:
40: TYPE T_int_prnt_req_id IS TABLE OF igf_ap_isir_ints_all.orig_name_id_txt%TYPE;
41: TYPE T_int_sub_req_num IS TABLE OF igf_ap_isir_ints_all.orig_name_id_txt%TYPE;

Line 38: TYPE T_int_orig_id IS TABLE OF igf_ap_isir_ints_all.orig_name_id_txt%TYPE;

34: -- define a PL/SQL table
35: TYPE T_int_si_id IS TABLE OF igf_ap_isir_ints_all.si_id%TYPE;
36: TYPE T_int_batch_yr IS TABLE OF igf_ap_isir_ints_all.batch_year_num%TYPE;
37: TYPE T_int_orig_ssn IS TABLE OF igf_ap_isir_ints_all.original_ssn_txt%TYPE;
38: TYPE T_int_orig_id IS TABLE OF igf_ap_isir_ints_all.orig_name_id_txt%TYPE;
39:
40: TYPE T_int_prnt_req_id IS TABLE OF igf_ap_isir_ints_all.orig_name_id_txt%TYPE;
41: TYPE T_int_sub_req_num IS TABLE OF igf_ap_isir_ints_all.orig_name_id_txt%TYPE;
42: -- define global variables of corresp type and initialize

Line 40: TYPE T_int_prnt_req_id IS TABLE OF igf_ap_isir_ints_all.orig_name_id_txt%TYPE;

36: TYPE T_int_batch_yr IS TABLE OF igf_ap_isir_ints_all.batch_year_num%TYPE;
37: TYPE T_int_orig_ssn IS TABLE OF igf_ap_isir_ints_all.original_ssn_txt%TYPE;
38: TYPE T_int_orig_id IS TABLE OF igf_ap_isir_ints_all.orig_name_id_txt%TYPE;
39:
40: TYPE T_int_prnt_req_id IS TABLE OF igf_ap_isir_ints_all.orig_name_id_txt%TYPE;
41: TYPE T_int_sub_req_num IS TABLE OF igf_ap_isir_ints_all.orig_name_id_txt%TYPE;
42: -- define global variables of corresp type and initialize
43: g_si_id_tab T_int_si_id := T_int_si_id();
44: g_batch_year_num_tab T_int_batch_yr := T_int_batch_yr();

Line 41: TYPE T_int_sub_req_num IS TABLE OF igf_ap_isir_ints_all.orig_name_id_txt%TYPE;

37: TYPE T_int_orig_ssn IS TABLE OF igf_ap_isir_ints_all.original_ssn_txt%TYPE;
38: TYPE T_int_orig_id IS TABLE OF igf_ap_isir_ints_all.orig_name_id_txt%TYPE;
39:
40: TYPE T_int_prnt_req_id IS TABLE OF igf_ap_isir_ints_all.orig_name_id_txt%TYPE;
41: TYPE T_int_sub_req_num IS TABLE OF igf_ap_isir_ints_all.orig_name_id_txt%TYPE;
42: -- define global variables of corresp type and initialize
43: g_si_id_tab T_int_si_id := T_int_si_id();
44: g_batch_year_num_tab T_int_batch_yr := T_int_batch_yr();
45: g_original_ssn_txt_tab T_int_orig_ssn := T_int_orig_ssn();

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

857: END IF;
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