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 FND_GLOBAL

Line 804: SET last_updated_by = fnd_global.user_id,

800: x_ed_use_flags => p_pell_disb_int.ed_use_flags
801: );
802:
803: UPDATE igf_aw_li_pdb_ints
804: SET last_updated_by = fnd_global.user_id,
805: last_update_date = SYSDATE,
806: last_update_login = fnd_global.login_id
807: WHERE ci_alternate_code = p_pell_disb_int.ci_alternate_code
808: AND person_number = p_pell_disb_int.person_number

Line 806: last_update_login = fnd_global.login_id

802:
803: UPDATE igf_aw_li_pdb_ints
804: SET last_updated_by = fnd_global.user_id,
805: last_update_date = SYSDATE,
806: last_update_login = fnd_global.login_id
807: WHERE ci_alternate_code = p_pell_disb_int.ci_alternate_code
808: AND person_number = p_pell_disb_int.person_number
809: AND award_number_txt = p_pell_disb_int.award_number_txt
810: AND origination_id_txt = p_pell_disb_int.origination_id_txt

Line 2575: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.main.debug', ' ---- Request ID : '||fnd_global.conc_request_id

2571: IF (FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level) THEN
2572: l_debug_str := l_debug_str || ', Cal Type : ' || g_cal_type;
2573: l_debug_str := l_debug_str || ', Sequence Num : ' || g_seq_number;
2574:
2575: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.main.debug', ' ---- Request ID : '||fnd_global.conc_request_id
2576: ||' Conc Prgm Id : '||fnd_global.conc_program_id
2577: ||' Pgm appl Id : '||fnd_global.prog_appl_id
2578: ||' ----');
2579: END IF;

Line 2576: ||' Conc Prgm Id : '||fnd_global.conc_program_id

2572: l_debug_str := l_debug_str || ', Cal Type : ' || g_cal_type;
2573: l_debug_str := l_debug_str || ', Sequence Num : ' || g_seq_number;
2574:
2575: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.main.debug', ' ---- Request ID : '||fnd_global.conc_request_id
2576: ||' Conc Prgm Id : '||fnd_global.conc_program_id
2577: ||' Pgm appl Id : '||fnd_global.prog_appl_id
2578: ||' ----');
2579: END IF;
2580:

Line 2577: ||' Pgm appl Id : '||fnd_global.prog_appl_id

2573: l_debug_str := l_debug_str || ', Sequence Num : ' || g_seq_number;
2574:
2575: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_gr_li_import.main.debug', ' ---- Request ID : '||fnd_global.conc_request_id
2576: ||' Conc Prgm Id : '||fnd_global.conc_program_id
2577: ||' Pgm appl Id : '||fnd_global.prog_appl_id
2578: ||' ----');
2579: END IF;
2580:
2581: OPEN c_get_alternate_code(g_cal_type,g_seq_number);

Line 2789: last_updated_by = fnd_global.user_id,

2785: g_tot_rec_imp_error := g_tot_rec_imp_error + 1;
2786:
2787: UPDATE igf_aw_li_pell_ints
2788: SET import_status_type = 'E',
2789: last_updated_by = fnd_global.user_id,
2790: last_update_date = SYSDATE,
2791: last_update_login = fnd_global.login_id,
2792: request_id = fnd_global.conc_request_id,
2793: program_id = fnd_global.conc_program_id,

Line 2791: last_update_login = fnd_global.login_id,

2787: UPDATE igf_aw_li_pell_ints
2788: SET import_status_type = 'E',
2789: last_updated_by = fnd_global.user_id,
2790: last_update_date = SYSDATE,
2791: last_update_login = fnd_global.login_id,
2792: request_id = fnd_global.conc_request_id,
2793: program_id = fnd_global.conc_program_id,
2794: program_application_id = fnd_global.prog_appl_id,
2795: program_update_date = SYSDATE

Line 2792: request_id = fnd_global.conc_request_id,

2788: SET import_status_type = 'E',
2789: last_updated_by = fnd_global.user_id,
2790: last_update_date = SYSDATE,
2791: last_update_login = fnd_global.login_id,
2792: request_id = fnd_global.conc_request_id,
2793: program_id = fnd_global.conc_program_id,
2794: program_application_id = fnd_global.prog_appl_id,
2795: program_update_date = SYSDATE
2796: WHERE batch_num = lc_pell_orig_int.batch_num

Line 2793: program_id = fnd_global.conc_program_id,

2789: last_updated_by = fnd_global.user_id,
2790: last_update_date = SYSDATE,
2791: last_update_login = fnd_global.login_id,
2792: request_id = fnd_global.conc_request_id,
2793: program_id = fnd_global.conc_program_id,
2794: program_application_id = fnd_global.prog_appl_id,
2795: program_update_date = SYSDATE
2796: WHERE batch_num = lc_pell_orig_int.batch_num
2797: AND ci_alternate_code = lc_pell_orig_int.ci_alternate_code

Line 2794: program_application_id = fnd_global.prog_appl_id,

2790: last_update_date = SYSDATE,
2791: last_update_login = fnd_global.login_id,
2792: request_id = fnd_global.conc_request_id,
2793: program_id = fnd_global.conc_program_id,
2794: program_application_id = fnd_global.prog_appl_id,
2795: program_update_date = SYSDATE
2796: WHERE batch_num = lc_pell_orig_int.batch_num
2797: AND ci_alternate_code = lc_pell_orig_int.ci_alternate_code
2798: AND person_number = lc_pell_orig_int.person_number

Line 2818: last_updated_by = fnd_global.user_id,

2814: g_tot_rec_imp_error := g_tot_rec_imp_error + 1;
2815:
2816: UPDATE igf_aw_li_pell_ints
2817: SET import_status_type = 'E',
2818: last_updated_by = fnd_global.user_id,
2819: last_update_date = SYSDATE,
2820: last_update_login = fnd_global.login_id,
2821: request_id = fnd_global.conc_request_id,
2822: program_id = fnd_global.conc_program_id,

Line 2820: last_update_login = fnd_global.login_id,

2816: UPDATE igf_aw_li_pell_ints
2817: SET import_status_type = 'E',
2818: last_updated_by = fnd_global.user_id,
2819: last_update_date = SYSDATE,
2820: last_update_login = fnd_global.login_id,
2821: request_id = fnd_global.conc_request_id,
2822: program_id = fnd_global.conc_program_id,
2823: program_application_id = fnd_global.prog_appl_id,
2824: program_update_date = SYSDATE

Line 2821: request_id = fnd_global.conc_request_id,

2817: SET import_status_type = 'E',
2818: last_updated_by = fnd_global.user_id,
2819: last_update_date = SYSDATE,
2820: last_update_login = fnd_global.login_id,
2821: request_id = fnd_global.conc_request_id,
2822: program_id = fnd_global.conc_program_id,
2823: program_application_id = fnd_global.prog_appl_id,
2824: program_update_date = SYSDATE
2825: WHERE batch_num = lc_pell_orig_int.batch_num

Line 2822: program_id = fnd_global.conc_program_id,

2818: last_updated_by = fnd_global.user_id,
2819: last_update_date = SYSDATE,
2820: last_update_login = fnd_global.login_id,
2821: request_id = fnd_global.conc_request_id,
2822: program_id = fnd_global.conc_program_id,
2823: program_application_id = fnd_global.prog_appl_id,
2824: program_update_date = SYSDATE
2825: WHERE batch_num = lc_pell_orig_int.batch_num
2826: AND ci_alternate_code = lc_pell_orig_int.ci_alternate_code

Line 2823: program_application_id = fnd_global.prog_appl_id,

2819: last_update_date = SYSDATE,
2820: last_update_login = fnd_global.login_id,
2821: request_id = fnd_global.conc_request_id,
2822: program_id = fnd_global.conc_program_id,
2823: program_application_id = fnd_global.prog_appl_id,
2824: program_update_date = SYSDATE
2825: WHERE batch_num = lc_pell_orig_int.batch_num
2826: AND ci_alternate_code = lc_pell_orig_int.ci_alternate_code
2827: AND person_number = lc_pell_orig_int.person_number

Line 2857: last_updated_by = fnd_global.user_id,

2853: fnd_file.put_line(fnd_file.log, fnd_message.get);
2854:
2855: UPDATE igf_aw_li_pell_ints
2856: SET import_status_type = 'E',
2857: last_updated_by = fnd_global.user_id,
2858: last_update_date = SYSDATE,
2859: last_update_login = fnd_global.login_id,
2860: request_id = fnd_global.conc_request_id,
2861: program_id = fnd_global.conc_program_id,

Line 2859: last_update_login = fnd_global.login_id,

2855: UPDATE igf_aw_li_pell_ints
2856: SET import_status_type = 'E',
2857: last_updated_by = fnd_global.user_id,
2858: last_update_date = SYSDATE,
2859: last_update_login = fnd_global.login_id,
2860: request_id = fnd_global.conc_request_id,
2861: program_id = fnd_global.conc_program_id,
2862: program_application_id = fnd_global.prog_appl_id,
2863: program_update_date = SYSDATE

Line 2860: request_id = fnd_global.conc_request_id,

2856: SET import_status_type = 'E',
2857: last_updated_by = fnd_global.user_id,
2858: last_update_date = SYSDATE,
2859: last_update_login = fnd_global.login_id,
2860: request_id = fnd_global.conc_request_id,
2861: program_id = fnd_global.conc_program_id,
2862: program_application_id = fnd_global.prog_appl_id,
2863: program_update_date = SYSDATE
2864: WHERE batch_num = lc_pell_orig_int.batch_num

Line 2861: program_id = fnd_global.conc_program_id,

2857: last_updated_by = fnd_global.user_id,
2858: last_update_date = SYSDATE,
2859: last_update_login = fnd_global.login_id,
2860: request_id = fnd_global.conc_request_id,
2861: program_id = fnd_global.conc_program_id,
2862: program_application_id = fnd_global.prog_appl_id,
2863: program_update_date = SYSDATE
2864: WHERE batch_num = lc_pell_orig_int.batch_num
2865: AND ci_alternate_code = lc_pell_orig_int.ci_alternate_code

Line 2862: program_application_id = fnd_global.prog_appl_id,

2858: last_update_date = SYSDATE,
2859: last_update_login = fnd_global.login_id,
2860: request_id = fnd_global.conc_request_id,
2861: program_id = fnd_global.conc_program_id,
2862: program_application_id = fnd_global.prog_appl_id,
2863: program_update_date = SYSDATE
2864: WHERE batch_num = lc_pell_orig_int.batch_num
2865: AND ci_alternate_code = lc_pell_orig_int.ci_alternate_code
2866: AND person_number = lc_pell_orig_int.person_number

Line 2894: last_updated_by = fnd_global.user_id,

2890: g_tot_rec_imp_error := g_tot_rec_imp_error + 1;
2891:
2892: UPDATE igf_aw_li_pell_ints
2893: SET import_status_type = 'E',
2894: last_updated_by = fnd_global.user_id,
2895: last_update_date = SYSDATE,
2896: last_update_login = fnd_global.login_id,
2897: request_id = fnd_global.conc_request_id,
2898: program_id = fnd_global.conc_program_id,

Line 2896: last_update_login = fnd_global.login_id,

2892: UPDATE igf_aw_li_pell_ints
2893: SET import_status_type = 'E',
2894: last_updated_by = fnd_global.user_id,
2895: last_update_date = SYSDATE,
2896: last_update_login = fnd_global.login_id,
2897: request_id = fnd_global.conc_request_id,
2898: program_id = fnd_global.conc_program_id,
2899: program_application_id = fnd_global.prog_appl_id,
2900: program_update_date = SYSDATE

Line 2897: request_id = fnd_global.conc_request_id,

2893: SET import_status_type = 'E',
2894: last_updated_by = fnd_global.user_id,
2895: last_update_date = SYSDATE,
2896: last_update_login = fnd_global.login_id,
2897: request_id = fnd_global.conc_request_id,
2898: program_id = fnd_global.conc_program_id,
2899: program_application_id = fnd_global.prog_appl_id,
2900: program_update_date = SYSDATE
2901: WHERE batch_num = lc_pell_orig_int.batch_num

Line 2898: program_id = fnd_global.conc_program_id,

2894: last_updated_by = fnd_global.user_id,
2895: last_update_date = SYSDATE,
2896: last_update_login = fnd_global.login_id,
2897: request_id = fnd_global.conc_request_id,
2898: program_id = fnd_global.conc_program_id,
2899: program_application_id = fnd_global.prog_appl_id,
2900: program_update_date = SYSDATE
2901: WHERE batch_num = lc_pell_orig_int.batch_num
2902: AND ci_alternate_code = lc_pell_orig_int.ci_alternate_code

Line 2899: program_application_id = fnd_global.prog_appl_id,

2895: last_update_date = SYSDATE,
2896: last_update_login = fnd_global.login_id,
2897: request_id = fnd_global.conc_request_id,
2898: program_id = fnd_global.conc_program_id,
2899: program_application_id = fnd_global.prog_appl_id,
2900: program_update_date = SYSDATE
2901: WHERE batch_num = lc_pell_orig_int.batch_num
2902: AND ci_alternate_code = lc_pell_orig_int.ci_alternate_code
2903: AND person_number = lc_pell_orig_int.person_number

Line 2999: last_updated_by = fnd_global.user_id,

2995: END IF;
2996:
2997: UPDATE igf_aw_li_pell_ints
2998: SET import_status_type = l_pell_import_status,
2999: last_updated_by = fnd_global.user_id,
3000: last_update_date = SYSDATE,
3001: last_update_login = fnd_global.login_id,
3002: request_id = fnd_global.conc_request_id,
3003: program_id = fnd_global.conc_program_id,

Line 3001: last_update_login = fnd_global.login_id,

2997: UPDATE igf_aw_li_pell_ints
2998: SET import_status_type = l_pell_import_status,
2999: last_updated_by = fnd_global.user_id,
3000: last_update_date = SYSDATE,
3001: last_update_login = fnd_global.login_id,
3002: request_id = fnd_global.conc_request_id,
3003: program_id = fnd_global.conc_program_id,
3004: program_application_id = fnd_global.prog_appl_id,
3005: program_update_date = SYSDATE

Line 3002: request_id = fnd_global.conc_request_id,

2998: SET import_status_type = l_pell_import_status,
2999: last_updated_by = fnd_global.user_id,
3000: last_update_date = SYSDATE,
3001: last_update_login = fnd_global.login_id,
3002: request_id = fnd_global.conc_request_id,
3003: program_id = fnd_global.conc_program_id,
3004: program_application_id = fnd_global.prog_appl_id,
3005: program_update_date = SYSDATE
3006: WHERE batch_num = lc_pell_orig_int.batch_num

Line 3003: program_id = fnd_global.conc_program_id,

2999: last_updated_by = fnd_global.user_id,
3000: last_update_date = SYSDATE,
3001: last_update_login = fnd_global.login_id,
3002: request_id = fnd_global.conc_request_id,
3003: program_id = fnd_global.conc_program_id,
3004: program_application_id = fnd_global.prog_appl_id,
3005: program_update_date = SYSDATE
3006: WHERE batch_num = lc_pell_orig_int.batch_num
3007: AND ci_alternate_code = lc_pell_orig_int.ci_alternate_code

Line 3004: program_application_id = fnd_global.prog_appl_id,

3000: last_update_date = SYSDATE,
3001: last_update_login = fnd_global.login_id,
3002: request_id = fnd_global.conc_request_id,
3003: program_id = fnd_global.conc_program_id,
3004: program_application_id = fnd_global.prog_appl_id,
3005: program_update_date = SYSDATE
3006: WHERE batch_num = lc_pell_orig_int.batch_num
3007: AND ci_alternate_code = lc_pell_orig_int.ci_alternate_code
3008: AND person_number = lc_pell_orig_int.person_number