3285:
3286: IF(p_operation = 'U')THEN
3287: UPDATE igf_aw_li_awd_ints
3288: SET import_status_type = p_status,
3289: last_updated_by = fnd_global.user_id,
3290: last_update_date = SYSDATE,
3291: last_update_login = fnd_global.login_id,
3292: request_id = fnd_global.conc_request_id,
3293: program_id = fnd_global.conc_program_id,
3287: UPDATE igf_aw_li_awd_ints
3288: SET import_status_type = p_status,
3289: last_updated_by = fnd_global.user_id,
3290: last_update_date = SYSDATE,
3291: last_update_login = fnd_global.login_id,
3292: request_id = fnd_global.conc_request_id,
3293: program_id = fnd_global.conc_program_id,
3294: program_application_id = fnd_global.prog_appl_id,
3295: program_update_date = SYSDATE
3288: SET import_status_type = p_status,
3289: last_updated_by = fnd_global.user_id,
3290: last_update_date = SYSDATE,
3291: last_update_login = fnd_global.login_id,
3292: request_id = fnd_global.conc_request_id,
3293: program_id = fnd_global.conc_program_id,
3294: program_application_id = fnd_global.prog_appl_id,
3295: program_update_date = SYSDATE
3296: WHERE ci_alternate_code = ctx_li_awd_rec.ci_alternate_code
3289: last_updated_by = fnd_global.user_id,
3290: last_update_date = SYSDATE,
3291: last_update_login = fnd_global.login_id,
3292: request_id = fnd_global.conc_request_id,
3293: program_id = fnd_global.conc_program_id,
3294: program_application_id = fnd_global.prog_appl_id,
3295: program_update_date = SYSDATE
3296: WHERE ci_alternate_code = ctx_li_awd_rec.ci_alternate_code
3297: AND person_number = ctx_li_awd_rec.person_number
3290: last_update_date = SYSDATE,
3291: last_update_login = fnd_global.login_id,
3292: request_id = fnd_global.conc_request_id,
3293: program_id = fnd_global.conc_program_id,
3294: program_application_id = fnd_global.prog_appl_id,
3295: program_update_date = SYSDATE
3296: WHERE ci_alternate_code = ctx_li_awd_rec.ci_alternate_code
3297: AND person_number = ctx_li_awd_rec.person_number
3298: AND award_number_txt = ctx_li_awd_rec.award_number_txt
3340: l_cal_type := TRIM(SUBSTR(p_award_year,1,10));
3341: l_seq_number := TO_NUMBER(SUBSTR(p_award_year,11));
3342:
3343: IF(FND_LOG.LEVEL_STATEMENT >= g_debug_runtime_level)THEN
3344: g_debug_string := 'REQUEST ID: '||fnd_global.conc_request_id;
3345: END IF;
3346:
3347: -- copy the values into global variables for further processing
3348: g_ci_cal_type := l_cal_type; g_ci_sequence_number := l_seq_number;