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.IGS_UC_EXP_APPLICANT_DTLS dependencies on IGS_HE_CODE_MAP_VAL

Line 143: CURSOR cur_hesa_map (cp_assoc IGS_HE_CODE_MAP_VAL.association_code%TYPE,

139: WHERE ucn.app_no = cp_app_no;
140: cur_app_name_rec cur_upd_app_name%ROWTYPE;
141:
142: -- Fetch the HESA Mapping value
143: CURSOR cur_hesa_map (cp_assoc IGS_HE_CODE_MAP_VAL.association_code%TYPE,
144: cp_map1 IGS_HE_CODE_MAP_VAL.map2%TYPE ) IS
145: SELECT map2
146: FROM IGS_HE_CODE_MAP_VAL
147: WHERE association_code = cp_assoc

Line 144: cp_map1 IGS_HE_CODE_MAP_VAL.map2%TYPE ) IS

140: cur_app_name_rec cur_upd_app_name%ROWTYPE;
141:
142: -- Fetch the HESA Mapping value
143: CURSOR cur_hesa_map (cp_assoc IGS_HE_CODE_MAP_VAL.association_code%TYPE,
144: cp_map1 IGS_HE_CODE_MAP_VAL.map2%TYPE ) IS
145: SELECT map2
146: FROM IGS_HE_CODE_MAP_VAL
147: WHERE association_code = cp_assoc
148: AND map1 = cp_map1;

Line 146: FROM IGS_HE_CODE_MAP_VAL

142: -- Fetch the HESA Mapping value
143: CURSOR cur_hesa_map (cp_assoc IGS_HE_CODE_MAP_VAL.association_code%TYPE,
144: cp_map1 IGS_HE_CODE_MAP_VAL.map2%TYPE ) IS
145: SELECT map2
146: FROM IGS_HE_CODE_MAP_VAL
147: WHERE association_code = cp_assoc
148: AND map1 = cp_map1;
149: l_oss_val IGS_HE_CODE_MAP_VAL.map2%TYPE;
150:

Line 149: l_oss_val IGS_HE_CODE_MAP_VAL.map2%TYPE;

145: SELECT map2
146: FROM IGS_HE_CODE_MAP_VAL
147: WHERE association_code = cp_assoc
148: AND map1 = cp_map1;
149: l_oss_val IGS_HE_CODE_MAP_VAL.map2%TYPE;
150:
151: /* Cursors used to Process the Admission Interface Tables data */
152:
153: CURSOR cur_proc_applicants(cp_batch_id IGS_AD_INTERFACE_ALL.batch_id%TYPE) IS

Line 273: l_oss_country_code igs_he_code_map_val.map2%TYPE;

269: l_app_valid_status BOOLEAN;
270: l_adm_imp_status BOOLEAN;
271: l_adm_error_encountered BOOLEAN;
272: l_dummy VARCHAR2(1);
273: l_oss_country_code igs_he_code_map_val.map2%TYPE;
274:
275: l_rep_request_id NUMBER;
276: l_sent_to_oss_flag IGS_UC_APP_NAMES.sent_to_oss_flag%TYPE;
277: l_dom_text_value IGS_UC_REF_APR.dom_text%TYPE;

Line 2070: CURSOR cur_hesa_map (cp_assoc IGS_HE_CODE_MAP_VAL.association_code%TYPE,

2066: START_DT
2067: ***************************************************************** */
2068:
2069: -- Fetch the HESA Mapping value
2070: CURSOR cur_hesa_map (cp_assoc IGS_HE_CODE_MAP_VAL.association_code%TYPE,
2071: cp_map1 IGS_HE_CODE_MAP_VAL.map2%TYPE ) IS
2072: SELECT map2
2073: FROM IGS_HE_CODE_MAP_VAL
2074: WHERE association_code = cp_assoc

Line 2071: cp_map1 IGS_HE_CODE_MAP_VAL.map2%TYPE ) IS

2067: ***************************************************************** */
2068:
2069: -- Fetch the HESA Mapping value
2070: CURSOR cur_hesa_map (cp_assoc IGS_HE_CODE_MAP_VAL.association_code%TYPE,
2071: cp_map1 IGS_HE_CODE_MAP_VAL.map2%TYPE ) IS
2072: SELECT map2
2073: FROM IGS_HE_CODE_MAP_VAL
2074: WHERE association_code = cp_assoc
2075: AND map1 = cp_map1;

Line 2073: FROM IGS_HE_CODE_MAP_VAL

2069: -- Fetch the HESA Mapping value
2070: CURSOR cur_hesa_map (cp_assoc IGS_HE_CODE_MAP_VAL.association_code%TYPE,
2071: cp_map1 IGS_HE_CODE_MAP_VAL.map2%TYPE ) IS
2072: SELECT map2
2073: FROM IGS_HE_CODE_MAP_VAL
2074: WHERE association_code = cp_assoc
2075: AND map1 = cp_map1;
2076: l_oss_val IGS_HE_CODE_MAP_VAL.map2%TYPE;
2077:

Line 2076: l_oss_val IGS_HE_CODE_MAP_VAL.map2%TYPE;

2072: SELECT map2
2073: FROM IGS_HE_CODE_MAP_VAL
2074: WHERE association_code = cp_assoc
2075: AND map1 = cp_map1;
2076: l_oss_val IGS_HE_CODE_MAP_VAL.map2%TYPE;
2077:
2078: l_residency_status_cd IGS_PE_RES_DTLS.residency_status_cd%TYPE;
2079:
2080: -- Cursor to fetch the person number based on person id. Bug No. 2980137.

Line 2179: CURSOR cur_ucas_oss_map (cp_assoc IGS_HE_CODE_MAP_VAL.association_code%TYPE,

2175: jchin 24-Feb-2006 Modified for R12 perf bugs 4950293
2176: ***************************************************************** */
2177:
2178: -- UCAS Association mapping
2179: CURSOR cur_ucas_oss_map (cp_assoc IGS_HE_CODE_MAP_VAL.association_code%TYPE,
2180: cp_map1 IGS_HE_CODE_MAP_VAL.map2%TYPE ) IS
2181: SELECT map2
2182: FROM IGS_HE_CODE_MAP_VAL
2183: WHERE association_code = cp_assoc

Line 2180: cp_map1 IGS_HE_CODE_MAP_VAL.map2%TYPE ) IS

2176: ***************************************************************** */
2177:
2178: -- UCAS Association mapping
2179: CURSOR cur_ucas_oss_map (cp_assoc IGS_HE_CODE_MAP_VAL.association_code%TYPE,
2180: cp_map1 IGS_HE_CODE_MAP_VAL.map2%TYPE ) IS
2181: SELECT map2
2182: FROM IGS_HE_CODE_MAP_VAL
2183: WHERE association_code = cp_assoc
2184: AND map1 = cp_map1;

Line 2182: FROM IGS_HE_CODE_MAP_VAL

2178: -- UCAS Association mapping
2179: CURSOR cur_ucas_oss_map (cp_assoc IGS_HE_CODE_MAP_VAL.association_code%TYPE,
2180: cp_map1 IGS_HE_CODE_MAP_VAL.map2%TYPE ) IS
2181: SELECT map2
2182: FROM IGS_HE_CODE_MAP_VAL
2183: WHERE association_code = cp_assoc
2184: AND map1 = cp_map1;
2185:
2186: -- get the Academic history record for the student

Line 2195: l_oss_inst igs_he_code_map_val.map2%TYPE;

2191: FROM igs_ad_acad_history_v a
2192: WHERE a.person_id = cp_person_id
2193: AND a.institution_code = cp_inst_cd ;
2194:
2195: l_oss_inst igs_he_code_map_val.map2%TYPE;
2196: l_acad_hist_rec cur_get_hist_details%ROWTYPE;
2197: l_mapping_failed VARCHAR2(1) ;
2198:
2199: BEGIN

Line 2299: CURSOR cur_hesa_map (cp_assoc IGS_HE_CODE_MAP_VAL.association_code%TYPE,

2295:
2296: ***************************************************************** */
2297:
2298: -- Fetch the HESA Mapping value
2299: CURSOR cur_hesa_map (cp_assoc IGS_HE_CODE_MAP_VAL.association_code%TYPE,
2300: cp_map1 IGS_HE_CODE_MAP_VAL.map2%TYPE ) IS
2301: SELECT map2
2302: FROM IGS_HE_CODE_MAP_VAL
2303: WHERE association_code = cp_assoc

Line 2300: cp_map1 IGS_HE_CODE_MAP_VAL.map2%TYPE ) IS

2296: ***************************************************************** */
2297:
2298: -- Fetch the HESA Mapping value
2299: CURSOR cur_hesa_map (cp_assoc IGS_HE_CODE_MAP_VAL.association_code%TYPE,
2300: cp_map1 IGS_HE_CODE_MAP_VAL.map2%TYPE ) IS
2301: SELECT map2
2302: FROM IGS_HE_CODE_MAP_VAL
2303: WHERE association_code = cp_assoc
2304: AND map1 = cp_map1;

Line 2302: FROM IGS_HE_CODE_MAP_VAL

2298: -- Fetch the HESA Mapping value
2299: CURSOR cur_hesa_map (cp_assoc IGS_HE_CODE_MAP_VAL.association_code%TYPE,
2300: cp_map1 IGS_HE_CODE_MAP_VAL.map2%TYPE ) IS
2301: SELECT map2
2302: FROM IGS_HE_CODE_MAP_VAL
2303: WHERE association_code = cp_assoc
2304: AND map1 = cp_map1;
2305: l_oss_val IGS_HE_CODE_MAP_VAL.map2%TYPE;
2306:

Line 2305: l_oss_val IGS_HE_CODE_MAP_VAL.map2%TYPE;

2301: SELECT map2
2302: FROM IGS_HE_CODE_MAP_VAL
2303: WHERE association_code = cp_assoc
2304: AND map1 = cp_map1;
2305: l_oss_val IGS_HE_CODE_MAP_VAL.map2%TYPE;
2306:
2307: CURSOR cur_citizen_exist (cp_person_id IGS_PE_CITIZENSHIP_V.party_id%TYPE,
2308: cp_country_code IGS_PE_CITIZENSHIP_V.country_code%TYPE) IS
2309: SELECT 'X'

Line 2456: CURSOR cur_hesa_map (cp_assoc IGS_HE_CODE_MAP_VAL.association_code%TYPE,

2452: with new 2-way mapping UCAS_OSS_DISABILITY_ASSOC
2453: ***************************************************************** */
2454:
2455: -- Fetch the HESA Mapping value
2456: CURSOR cur_hesa_map (cp_assoc IGS_HE_CODE_MAP_VAL.association_code%TYPE,
2457: cp_map1 IGS_HE_CODE_MAP_VAL.map2%TYPE ) IS
2458: SELECT map2
2459: FROM IGS_HE_CODE_MAP_VAL
2460: WHERE association_code = cp_assoc

Line 2457: cp_map1 IGS_HE_CODE_MAP_VAL.map2%TYPE ) IS

2453: ***************************************************************** */
2454:
2455: -- Fetch the HESA Mapping value
2456: CURSOR cur_hesa_map (cp_assoc IGS_HE_CODE_MAP_VAL.association_code%TYPE,
2457: cp_map1 IGS_HE_CODE_MAP_VAL.map2%TYPE ) IS
2458: SELECT map2
2459: FROM IGS_HE_CODE_MAP_VAL
2460: WHERE association_code = cp_assoc
2461: AND map1 = cp_map1;

Line 2459: FROM IGS_HE_CODE_MAP_VAL

2455: -- Fetch the HESA Mapping value
2456: CURSOR cur_hesa_map (cp_assoc IGS_HE_CODE_MAP_VAL.association_code%TYPE,
2457: cp_map1 IGS_HE_CODE_MAP_VAL.map2%TYPE ) IS
2458: SELECT map2
2459: FROM IGS_HE_CODE_MAP_VAL
2460: WHERE association_code = cp_assoc
2461: AND map1 = cp_map1;
2462: l_oss_val IGS_HE_CODE_MAP_VAL.map2%TYPE;
2463:

Line 2462: l_oss_val IGS_HE_CODE_MAP_VAL.map2%TYPE;

2458: SELECT map2
2459: FROM IGS_HE_CODE_MAP_VAL
2460: WHERE association_code = cp_assoc
2461: AND map1 = cp_map1;
2462: l_oss_val IGS_HE_CODE_MAP_VAL.map2%TYPE;
2463:
2464: CURSOR cur_disablty_dtls ( cp_person_id IGS_PE_PERS_DISABLTY_V.person_id%TYPE,
2465: cp_disability_type IGS_PE_PERS_DISABLTY_V.disability_type%TYPE) IS
2466: SELECT start_date, end_date

Line 2801: CURSOR cur_map (p_assoc igs_he_code_map_val.association_code%TYPE,

2797: WHERE territory_short_name = p_short_name ;
2798: cur_short_name_rec cur_short_name%ROWTYPE ;
2799:
2800: -- Fetch the OSS Nationality Code mapped to Domicile APR
2801: CURSOR cur_map (p_assoc igs_he_code_map_val.association_code%TYPE,
2802: p_map1 igs_he_code_map_val.map2%TYPE ) IS
2803: SELECT map2
2804: FROM IGS_HE_CODE_MAP_VAL
2805: WHERE association_code = p_assoc

Line 2802: p_map1 igs_he_code_map_val.map2%TYPE ) IS

2798: cur_short_name_rec cur_short_name%ROWTYPE ;
2799:
2800: -- Fetch the OSS Nationality Code mapped to Domicile APR
2801: CURSOR cur_map (p_assoc igs_he_code_map_val.association_code%TYPE,
2802: p_map1 igs_he_code_map_val.map2%TYPE ) IS
2803: SELECT map2
2804: FROM IGS_HE_CODE_MAP_VAL
2805: WHERE association_code = p_assoc
2806: AND map1 = p_map1;

Line 2804: FROM IGS_HE_CODE_MAP_VAL

2800: -- Fetch the OSS Nationality Code mapped to Domicile APR
2801: CURSOR cur_map (p_assoc igs_he_code_map_val.association_code%TYPE,
2802: p_map1 igs_he_code_map_val.map2%TYPE ) IS
2803: SELECT map2
2804: FROM IGS_HE_CODE_MAP_VAL
2805: WHERE association_code = p_assoc
2806: AND map1 = p_map1;
2807:
2808: l_country_code IGS_AD_ADDR_INT_ALL.country%TYPE;