781: END IF;
782:
783: UPDATE igf_ap_isir_ints_all
784: SET record_status = 'UNMATCHED',
785: last_updated_by = fnd_global.user_id,
786: last_update_date = TRUNC(SYSDATE),
787: last_update_login = fnd_global.login_id
788: WHERE si_id = rec_chk_isir_in_ints.si_id;
789:
783: UPDATE igf_ap_isir_ints_all
784: SET record_status = 'UNMATCHED',
785: last_updated_by = fnd_global.user_id,
786: last_update_date = TRUNC(SYSDATE),
787: last_update_login = fnd_global.login_id
788: WHERE si_id = rec_chk_isir_in_ints.si_id;
789:
790: l_isir_data_from_mtch_tbl := TRUE;
791:
1774: cur_isir_int_rec.subsidized_loan_limit_type,
1775: cur_isir_int_rec.combined_loan_limit_type,
1776: 'UNMATCHED',
1777: SYSDATE,
1778: fnd_global.user_id,
1779: fnd_global.user_id,
1780: fnd_global.login_id,
1781: SYSDATE
1782: );
1775: cur_isir_int_rec.combined_loan_limit_type,
1776: 'UNMATCHED',
1777: SYSDATE,
1778: fnd_global.user_id,
1779: fnd_global.user_id,
1780: fnd_global.login_id,
1781: SYSDATE
1782: );
1783:
1776: 'UNMATCHED',
1777: SYSDATE,
1778: fnd_global.user_id,
1779: fnd_global.user_id,
1780: fnd_global.login_id,
1781: SYSDATE
1782: );
1783:
1784: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN