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_HE_IMPORT_DATA dependencies on IGS_HE_CODE_MAP_VAL

Line 6: l_oss_domicile igs_he_code_map_val.map2%TYPE ;

2: /* $Header: IGSHE24B.pls 120.2 2006/02/09 17:43:04 jbaber noship $ */
3:
4: l_conc_request_id NUMBER;
5: l_org_id CONSTANT igs_ps_ver.org_id%TYPE := IGS_GE_GEN_003.GET_ORG_ID ;
6: l_oss_domicile igs_he_code_map_val.map2%TYPE ;
7: l_oss_ethnicity igs_he_code_map_val.map2%TYPE ;
8: l_oss_nation igs_he_code_map_val.map2%TYPE ;
9: l_oss_occupation igs_he_code_map_val.map2%TYPE ;
10: l_oss_gender igs_he_code_map_val.map2%TYPE ;

Line 7: l_oss_ethnicity igs_he_code_map_val.map2%TYPE ;

3:
4: l_conc_request_id NUMBER;
5: l_org_id CONSTANT igs_ps_ver.org_id%TYPE := IGS_GE_GEN_003.GET_ORG_ID ;
6: l_oss_domicile igs_he_code_map_val.map2%TYPE ;
7: l_oss_ethnicity igs_he_code_map_val.map2%TYPE ;
8: l_oss_nation igs_he_code_map_val.map2%TYPE ;
9: l_oss_occupation igs_he_code_map_val.map2%TYPE ;
10: l_oss_gender igs_he_code_map_val.map2%TYPE ;
11: l_oss_high_qual igs_he_code_map_val.map2%TYPE ;

Line 8: l_oss_nation igs_he_code_map_val.map2%TYPE ;

4: l_conc_request_id NUMBER;
5: l_org_id CONSTANT igs_ps_ver.org_id%TYPE := IGS_GE_GEN_003.GET_ORG_ID ;
6: l_oss_domicile igs_he_code_map_val.map2%TYPE ;
7: l_oss_ethnicity igs_he_code_map_val.map2%TYPE ;
8: l_oss_nation igs_he_code_map_val.map2%TYPE ;
9: l_oss_occupation igs_he_code_map_val.map2%TYPE ;
10: l_oss_gender igs_he_code_map_val.map2%TYPE ;
11: l_oss_high_qual igs_he_code_map_val.map2%TYPE ;
12: l_oss_subj1 igs_he_code_map_val.map2%TYPE ;

Line 9: l_oss_occupation igs_he_code_map_val.map2%TYPE ;

5: l_org_id CONSTANT igs_ps_ver.org_id%TYPE := IGS_GE_GEN_003.GET_ORG_ID ;
6: l_oss_domicile igs_he_code_map_val.map2%TYPE ;
7: l_oss_ethnicity igs_he_code_map_val.map2%TYPE ;
8: l_oss_nation igs_he_code_map_val.map2%TYPE ;
9: l_oss_occupation igs_he_code_map_val.map2%TYPE ;
10: l_oss_gender igs_he_code_map_val.map2%TYPE ;
11: l_oss_high_qual igs_he_code_map_val.map2%TYPE ;
12: l_oss_subj1 igs_he_code_map_val.map2%TYPE ;
13: l_oss_subj2 igs_he_code_map_val.map2%TYPE ;

Line 10: l_oss_gender igs_he_code_map_val.map2%TYPE ;

6: l_oss_domicile igs_he_code_map_val.map2%TYPE ;
7: l_oss_ethnicity igs_he_code_map_val.map2%TYPE ;
8: l_oss_nation igs_he_code_map_val.map2%TYPE ;
9: l_oss_occupation igs_he_code_map_val.map2%TYPE ;
10: l_oss_gender igs_he_code_map_val.map2%TYPE ;
11: l_oss_high_qual igs_he_code_map_val.map2%TYPE ;
12: l_oss_subj1 igs_he_code_map_val.map2%TYPE ;
13: l_oss_subj2 igs_he_code_map_val.map2%TYPE ;
14: l_oss_subj3 igs_he_code_map_val.map2%TYPE ;

Line 11: l_oss_high_qual igs_he_code_map_val.map2%TYPE ;

7: l_oss_ethnicity igs_he_code_map_val.map2%TYPE ;
8: l_oss_nation igs_he_code_map_val.map2%TYPE ;
9: l_oss_occupation igs_he_code_map_val.map2%TYPE ;
10: l_oss_gender igs_he_code_map_val.map2%TYPE ;
11: l_oss_high_qual igs_he_code_map_val.map2%TYPE ;
12: l_oss_subj1 igs_he_code_map_val.map2%TYPE ;
13: l_oss_subj2 igs_he_code_map_val.map2%TYPE ;
14: l_oss_subj3 igs_he_code_map_val.map2%TYPE ;
15: l_oss_proportion igs_he_code_map_val.map2%TYPE ;

Line 12: l_oss_subj1 igs_he_code_map_val.map2%TYPE ;

8: l_oss_nation igs_he_code_map_val.map2%TYPE ;
9: l_oss_occupation igs_he_code_map_val.map2%TYPE ;
10: l_oss_gender igs_he_code_map_val.map2%TYPE ;
11: l_oss_high_qual igs_he_code_map_val.map2%TYPE ;
12: l_oss_subj1 igs_he_code_map_val.map2%TYPE ;
13: l_oss_subj2 igs_he_code_map_val.map2%TYPE ;
14: l_oss_subj3 igs_he_code_map_val.map2%TYPE ;
15: l_oss_proportion igs_he_code_map_val.map2%TYPE ;
16: l_oss_disability igs_he_code_map_val.map2%TYPE ;

Line 13: l_oss_subj2 igs_he_code_map_val.map2%TYPE ;

9: l_oss_occupation igs_he_code_map_val.map2%TYPE ;
10: l_oss_gender igs_he_code_map_val.map2%TYPE ;
11: l_oss_high_qual igs_he_code_map_val.map2%TYPE ;
12: l_oss_subj1 igs_he_code_map_val.map2%TYPE ;
13: l_oss_subj2 igs_he_code_map_val.map2%TYPE ;
14: l_oss_subj3 igs_he_code_map_val.map2%TYPE ;
15: l_oss_proportion igs_he_code_map_val.map2%TYPE ;
16: l_oss_disability igs_he_code_map_val.map2%TYPE ;
17: l_oss_fee_elig igs_he_code_values.value%TYPE ;

Line 14: l_oss_subj3 igs_he_code_map_val.map2%TYPE ;

10: l_oss_gender igs_he_code_map_val.map2%TYPE ;
11: l_oss_high_qual igs_he_code_map_val.map2%TYPE ;
12: l_oss_subj1 igs_he_code_map_val.map2%TYPE ;
13: l_oss_subj2 igs_he_code_map_val.map2%TYPE ;
14: l_oss_subj3 igs_he_code_map_val.map2%TYPE ;
15: l_oss_proportion igs_he_code_map_val.map2%TYPE ;
16: l_oss_disability igs_he_code_map_val.map2%TYPE ;
17: l_oss_fee_elig igs_he_code_values.value%TYPE ;
18: l_oss_inst igs_or_org_alt_ids.org_structure_id%TYPE ;

Line 15: l_oss_proportion igs_he_code_map_val.map2%TYPE ;

11: l_oss_high_qual igs_he_code_map_val.map2%TYPE ;
12: l_oss_subj1 igs_he_code_map_val.map2%TYPE ;
13: l_oss_subj2 igs_he_code_map_val.map2%TYPE ;
14: l_oss_subj3 igs_he_code_map_val.map2%TYPE ;
15: l_oss_proportion igs_he_code_map_val.map2%TYPE ;
16: l_oss_disability igs_he_code_map_val.map2%TYPE ;
17: l_oss_fee_elig igs_he_code_values.value%TYPE ;
18: l_oss_inst igs_or_org_alt_ids.org_structure_id%TYPE ;
19: l_oss_social_class igs_he_code_map_val.map2%TYPE ;

Line 16: l_oss_disability igs_he_code_map_val.map2%TYPE ;

12: l_oss_subj1 igs_he_code_map_val.map2%TYPE ;
13: l_oss_subj2 igs_he_code_map_val.map2%TYPE ;
14: l_oss_subj3 igs_he_code_map_val.map2%TYPE ;
15: l_oss_proportion igs_he_code_map_val.map2%TYPE ;
16: l_oss_disability igs_he_code_map_val.map2%TYPE ;
17: l_oss_fee_elig igs_he_code_values.value%TYPE ;
18: l_oss_inst igs_or_org_alt_ids.org_structure_id%TYPE ;
19: l_oss_social_class igs_he_code_map_val.map2%TYPE ;
20: l_batch_id igs_he_ucas_imp_err.batch_id%TYPE ;

Line 19: l_oss_social_class igs_he_code_map_val.map2%TYPE ;

15: l_oss_proportion igs_he_code_map_val.map2%TYPE ;
16: l_oss_disability igs_he_code_map_val.map2%TYPE ;
17: l_oss_fee_elig igs_he_code_values.value%TYPE ;
18: l_oss_inst igs_or_org_alt_ids.org_structure_id%TYPE ;
19: l_oss_social_class igs_he_code_map_val.map2%TYPE ;
20: l_batch_id igs_he_ucas_imp_err.batch_id%TYPE ;
21: l_error_flag BOOLEAN ;
22:
23: -- Get the oss person details

Line 1205: CURSOR c_mapping ( cp_assoc_code igs_he_code_map_val.association_code%TYPE ,

1201: unit_set_cd = NVL(cp_unit_set_cd,unit_set_cd) ;
1202: l_susa VARCHAR2(1);
1203:
1204: -- get oss value from ucas oss hesa association
1205: CURSOR c_mapping ( cp_assoc_code igs_he_code_map_val.association_code%TYPE ,
1206: cp_value igs_he_code_map_val.map3%TYPE ) IS
1207: SELECT map2
1208: FROM igs_he_code_map_val
1209: WHERE association_code = cp_assoc_code AND

Line 1206: cp_value igs_he_code_map_val.map3%TYPE ) IS

1202: l_susa VARCHAR2(1);
1203:
1204: -- get oss value from ucas oss hesa association
1205: CURSOR c_mapping ( cp_assoc_code igs_he_code_map_val.association_code%TYPE ,
1206: cp_value igs_he_code_map_val.map3%TYPE ) IS
1207: SELECT map2
1208: FROM igs_he_code_map_val
1209: WHERE association_code = cp_assoc_code AND
1210: map3 = cp_value ;

Line 1208: FROM igs_he_code_map_val

1204: -- get oss value from ucas oss hesa association
1205: CURSOR c_mapping ( cp_assoc_code igs_he_code_map_val.association_code%TYPE ,
1206: cp_value igs_he_code_map_val.map3%TYPE ) IS
1207: SELECT map2
1208: FROM igs_he_code_map_val
1209: WHERE association_code = cp_assoc_code AND
1210: map3 = cp_value ;
1211:
1212: -- get oss value from oss hesa association

Line 1213: CURSOR c_mapping1 ( cp_assoc_code igs_he_code_map_val.association_code%TYPE ,

1209: WHERE association_code = cp_assoc_code AND
1210: map3 = cp_value ;
1211:
1212: -- get oss value from oss hesa association
1213: CURSOR c_mapping1 ( cp_assoc_code igs_he_code_map_val.association_code%TYPE ,
1214: cp_value igs_he_code_map_val.map1%TYPE ) IS
1215: SELECT map2
1216: FROM igs_he_code_map_val
1217: WHERE association_code = cp_assoc_code AND

Line 1214: cp_value igs_he_code_map_val.map1%TYPE ) IS

1210: map3 = cp_value ;
1211:
1212: -- get oss value from oss hesa association
1213: CURSOR c_mapping1 ( cp_assoc_code igs_he_code_map_val.association_code%TYPE ,
1214: cp_value igs_he_code_map_val.map1%TYPE ) IS
1215: SELECT map2
1216: FROM igs_he_code_map_val
1217: WHERE association_code = cp_assoc_code AND
1218: map1 = cp_value ;

Line 1216: FROM igs_he_code_map_val

1212: -- get oss value from oss hesa association
1213: CURSOR c_mapping1 ( cp_assoc_code igs_he_code_map_val.association_code%TYPE ,
1214: cp_value igs_he_code_map_val.map1%TYPE ) IS
1215: SELECT map2
1216: FROM igs_he_code_map_val
1217: WHERE association_code = cp_assoc_code AND
1218: map1 = cp_value ;
1219:
1220: -- get the oss code for highest qualification on entry field