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 dependencies on IGF_SL_LOR_LOC_ALL

Line 144: lv_alien_reg_num igf_sl_lor_loc_all.s_alien_reg_num%TYPE; --pssahni 31-Jan-2005 changed %type from igf_ap_isir_matched_all to igf_sl_lor_loc_all

140: lv_s_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
141: lv_p_citizenship_status igf_ap_isir_matched_all.citizenship_status%TYPE;
142: lv_s_license_number igf_ap_isir_matched_all.driver_license_number%TYPE;
143: lv_s_license_state igf_ap_isir_matched_all.driver_license_state%TYPE;
144: lv_alien_reg_num igf_sl_lor_loc_all.s_alien_reg_num%TYPE; --pssahni 31-Jan-2005 changed %type from igf_ap_isir_matched_all to igf_sl_lor_loc_all
145: lv_s_legal_res_state igf_ap_isir_matched_all.s_state_legal_residence%TYPE;
146: lv_s_legal_res_date DATE;
147: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
148: lv_s_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;

Line 147: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;

143: lv_s_license_state igf_ap_isir_matched_all.driver_license_state%TYPE;
144: lv_alien_reg_num igf_sl_lor_loc_all.s_alien_reg_num%TYPE; --pssahni 31-Jan-2005 changed %type from igf_ap_isir_matched_all to igf_sl_lor_loc_all
145: lv_s_legal_res_state igf_ap_isir_matched_all.s_state_legal_residence%TYPE;
146: lv_s_legal_res_date DATE;
147: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
148: lv_s_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
149: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
150: l_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
151: lv_p_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;

Line 148: lv_s_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;

144: lv_alien_reg_num igf_sl_lor_loc_all.s_alien_reg_num%TYPE; --pssahni 31-Jan-2005 changed %type from igf_ap_isir_matched_all to igf_sl_lor_loc_all
145: lv_s_legal_res_state igf_ap_isir_matched_all.s_state_legal_residence%TYPE;
146: lv_s_legal_res_date DATE;
147: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
148: lv_s_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
149: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
150: l_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
151: lv_p_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
152:

Line 149: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;

145: lv_s_legal_res_state igf_ap_isir_matched_all.s_state_legal_residence%TYPE;
146: lv_s_legal_res_date DATE;
147: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
148: lv_s_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
149: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
150: l_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
151: lv_p_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
152:
153: x_return_status VARCHAR2(1);

Line 150: l_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;

146: lv_s_legal_res_date DATE;
147: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
148: lv_s_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
149: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
150: l_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
151: lv_p_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
152:
153: x_return_status VARCHAR2(1);
154: x_msg_data VARCHAR2(30);

Line 151: lv_p_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;

147: lv_s_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
148: lv_s_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
149: lv_p_permt_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
150: l_phone igf_sl_lor_loc_all.s_permt_phone%TYPE;
151: lv_p_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
152:
153: x_return_status VARCHAR2(1);
154: x_msg_data VARCHAR2(30);
155: x_ope_cd igs_or_org_alt_ids.org_alternate_id%TYPE;