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

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 745: UPDATE igf_ap_isir_ints

741: -- At this point Final Recs to be processed for the current sub request have been included.
742: ----------------------------------------------------------------------------
743: -- Now update the interface table for the identified recs with the sub request no.
744: FORALL k IN l_from_rec..l_to_rec -- No. of recs to process from the current rec pointer.
745: UPDATE igf_ap_isir_ints
746: SET parent_req_id = g_parent_req_number,
747: sub_req_num = i
748: WHERE si_id = g_si_id_tab(k);
749:

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

Line 898: l_sql := 'SELECT si_id, batch_year_num, original_ssn_txt, orig_name_id_txt FROM igf_ap_isir_ints WHERE batch_year_num = ' || g_batch_year ;

894: g_batch_year := l_batch.batch_year;
895:
896:
897: -- Initialize the variable with Basic SQL statement to which the dynamic where clause can be appended later.
898: l_sql := 'SELECT si_id, batch_year_num, original_ssn_txt, orig_name_id_txt FROM igf_ap_isir_ints WHERE batch_year_num = ' || g_batch_year ;
899:
900: IF LTRIM(RTRIM(p_create_inquiry)) = 'Y' AND LTRIM(RTRIM(p_adm_source_type)) IS NULL THEN
901: fnd_message.set_name('IGF', 'IGF_AP_SOURCE_TYPE_REQ');
902: errbuf := fnd_message.get;

Line 943: UPDATE igf_ap_isir_ints

939: ELSE
940: log_debug_message('Processing as a Single Request.');
941: -- Single request hence update the identified recs with the sub request no.
942: FORALL k IN 1..g_total_recs_fetched
943: UPDATE igf_ap_isir_ints
944: SET parent_req_id = g_parent_req_number,
945: sub_req_num = 1
946: WHERE si_id = g_si_id_tab(k);
947: