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_SL_CL_ORIG_ACK dependencies on IGF_AP_ISIR_INTS_ALL

Line 273: p_v_ssn IN igf_ap_isir_ints_all.current_ssn_txt%TYPE,

269: p_d_ci_start_dt IN igs_ca_inst_all.start_dt%TYPE,
270: p_d_ci_end_dt IN igs_ca_inst_all.end_dt%TYPE,
271: p_v_person_number IN hz_parties.party_number%TYPE,
272: p_v_person_name IN hz_parties.party_name%TYPE,
273: p_v_ssn IN igf_ap_isir_ints_all.current_ssn_txt%TYPE,
274: p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE,
275: p_d_loan_per_begin_date IN igf_sl_loans_all.loan_per_begin_date%TYPE,
276: p_d_loan_per_end_date IN igf_sl_loans_all.loan_per_end_date%TYPE,
277: p_v_loan_type IN igf_aw_fund_cat_all.fed_fund_code%TYPE,

Line 4867: l_v_ssn igf_ap_isir_ints_all.current_ssn_txt%TYPE;

4863: v_tab_personid_typ tab_personid_typ ;
4864: v_tab_personnum_typ tab_personnum_typ;
4865: v_tab_rec_typ tab_rec_typ ;
4866:
4867: l_v_ssn igf_ap_isir_ints_all.current_ssn_txt%TYPE;
4868: l_c_per_oss_exists BOOLEAN;
4869: l_n_cnt NUMBER;
4870: BEGIN
4871: log_to_fnd(p_v_module => ' Entered Procedure perform_ssn_match. The input parameters are',

Line 5015: l_v_ssn igf_ap_isir_ints_all.current_ssn_txt%TYPE;

5011: l_v_person_number hz_parties.party_number%TYPE;
5012: l_v_person_id_type igs_pe_person_id_typ.person_id_type%TYPE;
5013: l_n_location_ovn hz_locations.object_version_number%TYPE;
5014: l_rec_resp_r1 igf_sl_cl_resp_r1_all%ROWTYPE;
5015: l_v_ssn igf_ap_isir_ints_all.current_ssn_txt%TYPE;
5016: l_v_person_first_name hz_parties.person_first_name%TYPE;
5017: l_v_person_last_name hz_parties.person_last_name%TYPE;
5018: l_v_person_middle_name hz_parties.person_middle_name%TYPE;
5019: l_d_date_of_birth igs_pe_person.birth_dt%TYPE;

Line 6367: p_v_ssn IN igf_ap_isir_ints_all.current_ssn_txt%TYPE,

6363: p_d_ci_start_dt IN igs_ca_inst_all.start_dt%TYPE,
6364: p_d_ci_end_dt IN igs_ca_inst_all.end_dt%TYPE,
6365: p_v_person_number IN hz_parties.party_number%TYPE,
6366: p_v_person_name IN hz_parties.party_name%TYPE,
6367: p_v_ssn IN igf_ap_isir_ints_all.current_ssn_txt%TYPE,
6368: p_v_loan_number IN igf_sl_loans_all.loan_number%TYPE,
6369: p_d_loan_per_begin_date IN igf_sl_loans_all.loan_per_begin_date%TYPE,
6370: p_d_loan_per_end_date IN igf_sl_loans_all.loan_per_end_date%TYPE,
6371: p_v_loan_type IN igf_aw_fund_cat_all.fed_fund_code%TYPE,