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_LOOKUPS_VIEW

Line 203: FROM igf_lookups_view lkups

199:
200: -- Get the values from the lookups
201: CURSOR c_get_parameters IS
202: SELECT lkups.meaning, lkups.lookup_code
203: FROM igf_lookups_view lkups
204: WHERE lkups.lookup_type = 'IGF_GE_PARAMETERS'
205: AND lkups.lookup_code IN ('AWARD_YEAR','BATCH_NUMBER','DELETE_FLAG','PARAMETER_PASS')
206: AND lkups.enabled_flag = 'Y' ;
207:

Line 210: l_award_year_pmpt igf_lookups_view.meaning%TYPE;

206: AND lkups.enabled_flag = 'Y' ;
207:
208: parameter_rec c_get_parameters%ROWTYPE;
209:
210: l_award_year_pmpt igf_lookups_view.meaning%TYPE;
211: l_batch_number_pmpt igf_lookups_view.meaning%TYPE;
212: l_delete_flag_pmpt igf_lookups_view.meaning%TYPE;
213: l_para_pass igf_lookups_view.meaning%TYPE;
214:

Line 211: l_batch_number_pmpt igf_lookups_view.meaning%TYPE;

207:
208: parameter_rec c_get_parameters%ROWTYPE;
209:
210: l_award_year_pmpt igf_lookups_view.meaning%TYPE;
211: l_batch_number_pmpt igf_lookups_view.meaning%TYPE;
212: l_delete_flag_pmpt igf_lookups_view.meaning%TYPE;
213: l_para_pass igf_lookups_view.meaning%TYPE;
214:
215: BEGIN

Line 212: l_delete_flag_pmpt igf_lookups_view.meaning%TYPE;

208: parameter_rec c_get_parameters%ROWTYPE;
209:
210: l_award_year_pmpt igf_lookups_view.meaning%TYPE;
211: l_batch_number_pmpt igf_lookups_view.meaning%TYPE;
212: l_delete_flag_pmpt igf_lookups_view.meaning%TYPE;
213: l_para_pass igf_lookups_view.meaning%TYPE;
214:
215: BEGIN
216:

Line 213: l_para_pass igf_lookups_view.meaning%TYPE;

209:
210: l_award_year_pmpt igf_lookups_view.meaning%TYPE;
211: l_batch_number_pmpt igf_lookups_view.meaning%TYPE;
212: l_delete_flag_pmpt igf_lookups_view.meaning%TYPE;
213: l_para_pass igf_lookups_view.meaning%TYPE;
214:
215: BEGIN
216:
217: -- Set all the Prompts for the Input Parameters

Line 1483: l_disb_num_prmpt igf_lookups_view.meaning%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);
1487: l_orig_batch_id VARCHAR2(30);

Line 1484: l_processing igf_lookups_view.meaning%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);
1487: l_orig_batch_id VARCHAR2(30);
1488: l_pell_mat VARCHAR2(10);

Line 2547: l_processing igf_lookups_view.meaning%TYPE;

2543:
2544: lc_pell_orig_int c_pell_orig_int%ROWTYPE;
2545: lc_pell_disb_int c_pell_disb_int%ROWTYPE;
2546: l_prev_person_number hz_parties.party_number%TYPE;
2547: l_processing igf_lookups_view.meaning%TYPE;
2548: l_person_number igf_lookups_view.meaning%TYPE;
2549: l_award_number igf_lookups_view.meaning%TYPE;
2550: l_debug_str fnd_log_messages.message_text%TYPE := 'IGFGR10B.pls Procedure main :: ';
2551: l_pell_import_status VARCHAR2(1);

Line 2548: l_person_number igf_lookups_view.meaning%TYPE;

2544: lc_pell_orig_int c_pell_orig_int%ROWTYPE;
2545: lc_pell_disb_int c_pell_disb_int%ROWTYPE;
2546: l_prev_person_number hz_parties.party_number%TYPE;
2547: l_processing igf_lookups_view.meaning%TYPE;
2548: l_person_number igf_lookups_view.meaning%TYPE;
2549: l_award_number igf_lookups_view.meaning%TYPE;
2550: l_debug_str fnd_log_messages.message_text%TYPE := 'IGFGR10B.pls Procedure main :: ';
2551: l_pell_import_status VARCHAR2(1);
2552: l_chk_batch VARCHAR2(1);

Line 2549: l_award_number igf_lookups_view.meaning%TYPE;

2545: lc_pell_disb_int c_pell_disb_int%ROWTYPE;
2546: l_prev_person_number hz_parties.party_number%TYPE;
2547: l_processing igf_lookups_view.meaning%TYPE;
2548: l_person_number igf_lookups_view.meaning%TYPE;
2549: l_award_number igf_lookups_view.meaning%TYPE;
2550: l_debug_str fnd_log_messages.message_text%TYPE := 'IGFGR10B.pls Procedure main :: ';
2551: l_pell_import_status VARCHAR2(1);
2552: l_chk_batch VARCHAR2(1);
2553: l_chk_setups VARCHAR2(1);