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_MATCHING_PROCESS_PKG dependencies on IGS_GE_MSG_STACK

Line 211: igs_ge_msg_stack.add;

207: END IF;
208:
209: RETURN NULL;
210: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');
211: igs_ge_msg_stack.add;
212: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
213: igs_ge_msg_stack.add;
214: app_exception.raise_exception;
215:

Line 213: igs_ge_msg_stack.add;

209: RETURN NULL;
210: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');
211: igs_ge_msg_stack.add;
212: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
213: igs_ge_msg_stack.add;
214: app_exception.raise_exception;
215:
216: END get_msg_class_from_filename;
217:

Line 252: igs_ge_msg_stack.add;

248: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.is_payment_isir.exception','The exception is : ' || SQLERRM );
249: END IF;
250:
251: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');
252: igs_ge_msg_stack.add;
253: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
254: igs_ge_msg_stack.add;
255: app_exception.raise_exception;
256: END is_payment_isir;

Line 254: igs_ge_msg_stack.add;

250:
251: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');
252: igs_ge_msg_stack.add;
253: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
254: igs_ge_msg_stack.add;
255: app_exception.raise_exception;
256: END is_payment_isir;
257:
258:

Line 392: igs_ge_msg_stack.add;

388: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.process_todo_items.exception','The exception is : ' || SQLERRM );
389: END IF;
390:
391: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');
392: igs_ge_msg_stack.add;
393: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
394: igs_ge_msg_stack.add;
395: app_exception.raise_exception;
396: END process_todo_items;

Line 394: igs_ge_msg_stack.add;

390:
391: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');
392: igs_ge_msg_stack.add;
393: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
394: igs_ge_msg_stack.add;
395: app_exception.raise_exception;
396: END process_todo_items;
397:
398:

Line 455: igs_ge_msg_stack.add;

451: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.update_isir_int_record.exception','The exception is : ' || SQLERRM );
452: END IF;
453:
454: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');
455: igs_ge_msg_stack.add;
456: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
457: igs_ge_msg_stack.add;
458: app_exception.raise_exception;
459: END update_isir_int_record;

Line 457: igs_ge_msg_stack.add;

453:
454: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');
455: igs_ge_msg_stack.add;
456: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
457: igs_ge_msg_stack.add;
458: app_exception.raise_exception;
459: END update_isir_int_record;
460:
461:

Line 624: igs_ge_msg_stack.add;

620: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.update_fa_base_rec.exception','The exception is : ' || SQLERRM );
621: END IF;
622:
623: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');
624: igs_ge_msg_stack.add;
625: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
626: igs_ge_msg_stack.add;
627: app_exception.raise_exception;
628: END update_fa_base_rec;

Line 626: igs_ge_msg_stack.add;

622:
623: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');
624: igs_ge_msg_stack.add;
625: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
626: igs_ge_msg_stack.add;
627: app_exception.raise_exception;
628: END update_fa_base_rec;
629:
630: PROCEDURE update_isir_matched_rec(p_isir_matched_record igf_ap_isir_matched%ROWTYPE,

Line 970: igs_ge_msg_stack.add;

966: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.update_isir_matched_rec(.exception','The exception is : ' || SQLERRM );
967: END IF;
968:
969: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
970: igs_ge_msg_stack.add;
971: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
972: igs_ge_msg_stack.add;
973: app_exception.raise_exception;
974: END update_isir_matched_rec;

Line 972: igs_ge_msg_stack.add;

968:
969: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
970: igs_ge_msg_stack.add;
971: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
972: igs_ge_msg_stack.add;
973: app_exception.raise_exception;
974: END update_isir_matched_rec;
975:
976: PROCEDURE make_old_isir_non_awarding(p_base_id NUMBER) AS

Line 1389: igs_ge_msg_stack.add;

1385:
1386: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1387: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.insert_isir_matched_rec');
1388: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
1389: igs_ge_msg_stack.add;
1390: app_exception.raise_exception;
1391: END insert_isir_matched_rec;
1392:
1393:

Line 1641: igs_ge_msg_stack.add;

1637:
1638: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1639: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.insert_nslds_data_rec');
1640: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
1641: igs_ge_msg_stack.add;
1642: app_exception.raise_exception;
1643: END insert_nslds_data_rec;
1644:
1645: PROCEDURE create_ssn(cp_person_id igs_pe_alt_pers_id.pe_person_id%TYPE,

Line 1909: igs_ge_msg_stack.add;

1905: END IF;
1906: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1907: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.insert_fa_base_record');
1908: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
1909: igs_ge_msg_stack.add;
1910: app_exception.raise_exception;
1911: END insert_fa_base_record;
1912:
1913:

Line 2021: igs_ge_msg_stack.add;

2017:
2018: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2019: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.update_prsn_match_rec_status');
2020: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
2021: igs_ge_msg_stack.add;
2022: app_exception.raise_exception;
2023: END update_prsn_match_rec_status;
2024:
2025:

Line 2153: igs_ge_msg_stack.add;

2149: wf_core.context('IGF_AP_PushedIsir_WF', 'PUSHEDISIR', l_seq_val, l_raise_event);
2150:
2151: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2152: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.raise_cps_pushed_isir_event');
2153: igs_ge_msg_stack.add;
2154: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);
2155: RAISE;
2156: END raise_cps_pushed_isir_event;
2157:

Line 2298: igs_ge_msg_stack.add;

2294: wf_core.context('IGF_AP_DemographicChange_WF', 'DEMOGRAPHICCHANGE', l_seq_val, l_raise_event); -- RAMMOHAN check name
2295:
2296: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2297: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.raise_demographic_chng_event');
2298: igs_ge_msg_stack.add;
2299: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);
2300: RAISE;
2301: END raise_demographic_chng_event;
2302:

Line 2440: igs_ge_msg_stack.add;

2436: fnd_file.put_line(FND_FILE.LOG ,l_msg_data||fnd_global.newline ||'STATUS:'||l_return_status);
2437: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2438: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.create_updt_email_address');
2439: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
2440: igs_ge_msg_stack.add;
2441: END create_updt_email_address;
2442:
2443: PROCEDURE update_person_info (pn_isir_id igf_ap_isir_matched.isir_id%TYPE)
2444: IS

Line 2716: igs_ge_msg_stack.add;

2712:
2713: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2714: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.update_person_info');
2715: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
2716: igs_ge_msg_stack.add;
2717: app_exception.raise_exception;
2718: END update_person_info;
2719:
2720:

Line 2949: igs_ge_msg_stack.add;

2945:
2946: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
2947: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.validate_correction_school');
2948: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
2949: igs_ge_msg_stack.add;
2950: app_exception.raise_exception;
2951: END validate_correction_school;
2952:
2953:

Line 3051: igs_ge_msg_stack.add;

3047: END IF;
3048:
3049: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3050: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.delete_person_match_rec' );
3051: igs_ge_msg_stack.add;
3052: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);
3053: app_exception.raise_exception;
3054: END delete_person_match_rec;
3055:

Line 3300: igs_ge_msg_stack.add;

3296:
3297: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3298: fnd_message.set_token('NAME','IGF_AP_MATCHING_PROCESS_PKG.create_admission_rec');
3299: fnd_file.put_line(fnd_file.log,fnd_message.get );
3300: igs_ge_msg_stack.add;
3301: END create_admission_rec;
3302:
3303:
3304: PROCEDURE create_person_record(

Line 3641: igs_ge_msg_stack.add;

3637: fnd_file.put_line(FND_FILE.LOG ,lv_msg_data||fnd_global.newline ||'STATUS:'||lv_return_status);
3638: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3639: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.create_person_addr_record');
3640: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3641: igs_ge_msg_stack.add;
3642: END create_person_addr_record;
3643:
3644:
3645:

Line 3815: igs_ge_msg_stack.add;

3811:
3812: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3813: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.auto_fa_rec');
3814: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3815: igs_ge_msg_stack.add;
3816: app_exception.raise_exception;
3817: END auto_fa_rec;
3818:
3819:

Line 3864: igs_ge_msg_stack.add;

3860:
3861: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
3862: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.rvw_fa_rec');
3863: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3864: igs_ge_msg_stack.add;
3865: app_exception.raise_exception;
3866: END rvw_fa_rec ;
3867:
3868:

Line 4025: igs_ge_msg_stack.add;

4021:
4022: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4023: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.unmatched_rec');
4024: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
4025: igs_ge_msg_stack.add;
4026: app_exception.raise_exception;
4027: END unmatched_rec ;
4028:
4029:

Line 4372: igs_ge_msg_stack.add;

4368: END IF;
4369:
4370: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4371: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.calculate_match_score' );
4372: igs_ge_msg_stack.add;
4373: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);
4374: app_exception.raise_exception;
4375: END calculate_match_score;
4376:

Line 4650: igs_ge_msg_stack.add;

4646: END IF;
4647:
4648: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4649: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.perform_record_matching' );
4650: igs_ge_msg_stack.add;
4651: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);
4652: app_exception.raise_exception;
4653: END perform_record_matching ;
4654:

Line 4893: igs_ge_msg_stack.add;

4889: END IF;
4890:
4891: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
4892: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.process_unidentified_isir_rec');
4893: igs_ge_msg_stack.add;
4894: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);
4895: app_exception.raise_exception;
4896: END process_unidentified_isir_rec;
4897:

Line 6644: igs_ge_msg_stack.add;

6640: END IF;
6641: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
6642: fnd_message.set_token('NAME','PROCESS_ISIR_RECEIPT.PROCESS_CORRECTIONS');
6643: fnd_file.put_line(fnd_file.log,fnd_message.get);
6644: igs_ge_msg_stack.add;
6645:
6646: lv_param_values := TO_CHAR(g_Base_Id)||','|| TO_CHAR(p_new_isir_id);
6647:
6648: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');

Line 6651: igs_ge_msg_stack.add;

6647:
6648: fnd_message.set_name('IGS','IGS_GE_PARAMETERS');
6649: fnd_message.set_token('VALUE',lv_param_values);
6650: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
6651: igs_ge_msg_stack.add;
6652: app_exception.raise_exception;
6653: END process_corrections;
6654:
6655: PROCEDURE process_non_payment_isir

Line 6731: igs_ge_msg_stack.add;

6727: END IF;
6728:
6729: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
6730: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.process_non_payment_isir');
6731: igs_ge_msg_stack.add;
6732: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);
6733: app_exception.raise_exception;
6734: END process_non_payment_isir;
6735:

Line 6959: igs_ge_msg_stack.add;

6955: END IF;
6956:
6957: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
6958: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.process_new_isir_rec');
6959: igs_ge_msg_stack.add;
6960: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);
6961: app_exception.raise_exception;
6962: END process_new_isir_rec;
6963:

Line 7052: igs_ge_msg_stack.add;

7048: END IF;
7049:
7050: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7051: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.pell_match_type_rec_processing');
7052: igs_ge_msg_stack.add;
7053: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);
7054: app_exception.raise_exception;
7055: END pell_match_type_rec_processing;
7056:

Line 7095: igs_ge_msg_stack.add;

7091:
7092: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7093: fnd_message.set_token('NAME','IGF_AP_MATCHING_PROCESS_PKG.process_correction_isir');
7094: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
7095: igs_ge_msg_stack.add;
7096: app_exception.raise_exception;
7097: END process_correction_isir;
7098:
7099:

Line 7362: igs_ge_msg_stack.add;

7358: g_bad_rec := g_bad_rec + 1; -- update bad rec count
7359:
7360: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7361: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.process_int_record');
7362: igs_ge_msg_stack.add;
7363: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);
7364: log_debug_message('EXCEPTION : ' || SQLERRM);
7365: RETURN;
7366: END process_int_record;

Line 7638: igs_ge_msg_stack.add;

7634:
7635: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7636: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.main');
7637: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
7638: igs_ge_msg_stack.add;
7639: igs_ge_msg_stack.conc_exception_hndl;
7640: END main;
7641:
7642:

Line 7639: igs_ge_msg_stack.conc_exception_hndl;

7635: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7636: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.main');
7637: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
7638: igs_ge_msg_stack.add;
7639: igs_ge_msg_stack.conc_exception_hndl;
7640: END main;
7641:
7642:
7643: FUNCTION format_SSN ( l_ssn VARCHAR2 )

Line 7701: igs_ge_msg_stack.add;

7697: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.format_SSN.exception','The exception is : ' || SQLERRM );
7698: END IF;
7699:
7700: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');
7701: igs_ge_msg_stack.add;
7702: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
7703: RETURN NULL;
7704:
7705: END format_SSN ;

Line 7837: igs_ge_msg_stack.add;

7833: END IF;
7834: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7835: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.is_fa_base_record_present');
7836: fnd_file.put_line(fnd_file.log,fnd_message.get);
7837: igs_ge_msg_stack.add;
7838: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
7839: RETURN FALSE;
7840: END is_fa_base_record_present;
7841:

Line 7929: igs_ge_msg_stack.add;

7925: END IF;
7926: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7927: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.convert_negative_char');
7928: fnd_file.put_line(fnd_file.log,fnd_message.get);
7929: igs_ge_msg_stack.add;
7930: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
7931: app_exception.raise_exception;
7932:
7933: END convert_negative_char;

Line 7998: igs_ge_msg_stack.add;

7994:
7995: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
7996: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.load_isir_matched');
7997: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
7998: igs_ge_msg_stack.add;
7999: app_exception.raise_exception;
8000: END load_matched_isir;
8001:
8002:

Line 8054: igs_ge_msg_stack.add;

8050:
8051: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
8052: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.create_isir_matched');
8053: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
8054: igs_ge_msg_stack.add;
8055: app_exception.raise_exception;
8056:
8057: END create_isir_matched;
8058:

Line 8109: igs_ge_msg_stack.add;

8105:
8106: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
8107: fnd_message.set_token('NAME','IGF_AP_MATCHING_PROCESS_PKG.UPDATE_ISIR_INTRFACE');
8108: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
8109: igs_ge_msg_stack.add;
8110: app_exception.raise_exception;
8111: END update_isir_intrface;
8112:
8113:

Line 8181: igs_ge_msg_stack.add;

8177: END IF;
8178: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
8179: fnd_message.set_token('NAME','igf_ap_matching_process_pkg.create_nslds_data');
8180: fnd_file.put_line(fnd_file.log,fnd_message.get);
8181: igs_ge_msg_stack.add;
8182: END create_nslds_data;
8183:
8184:
8185:

Line 8230: igs_ge_msg_stack.add;

8226: END IF;
8227:
8228: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
8229: fnd_message.set_token('NAME','igf_ap_matching_process.check_ptyp_code');
8230: igs_ge_msg_stack.add;
8231:
8232: END check_ptyp_code;
8233:
8234: PROCEDURE wrpr_refresh_matches(p_si_id IN igf_ap_isir_ints_all.si_id%TYPE,