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

Line 39: v_old_hesa_qual_map1 igs_he_code_map_val.map1%TYPE;

35:
36:
37: -- Variables to hold old and new values from other tables for record.
38: v_old_prg_funding_source igs_fi_fnd_src_rstn.funding_source%TYPE;
39: v_old_hesa_qual_map1 igs_he_code_map_val.map1%TYPE;
40: v_old_prg_fundability_cd igs_he_poous_all.fundability_cd%TYPE;
41:
42: v_new_hesa_qual_map1 igs_he_code_map_val.map1%TYPE;
43: v_new_prg_funding_source igs_fi_fnd_src_rstn.funding_source%TYPE;

Line 42: v_new_hesa_qual_map1 igs_he_code_map_val.map1%TYPE;

38: v_old_prg_funding_source igs_fi_fnd_src_rstn.funding_source%TYPE;
39: v_old_hesa_qual_map1 igs_he_code_map_val.map1%TYPE;
40: v_old_prg_fundability_cd igs_he_poous_all.fundability_cd%TYPE;
41:
42: v_new_hesa_qual_map1 igs_he_code_map_val.map1%TYPE;
43: v_new_prg_funding_source igs_fi_fnd_src_rstn.funding_source%TYPE;
44: v_new_prg_fundability_cd igs_he_poous_all.fundability_cd%TYPE;
45:
46: -- Variables to hold final values for first record

Line 63: v_term_time_map1 igs_he_code_map_val.map1%TYPE;

59: v_mark igs_he_en_susa.mark%TYPE;
60: v_type_of_year igs_he_en_susa.TYPE_OF_YEAR%TYPE;
61: v_fte_intensity igs_he_en_susa.fte_intensity%TYPE;
62: v_fte_calc_type igs_he_en_susa.fte_calc_type%TYPE;
63: v_term_time_map1 igs_he_code_map_val.map1%TYPE;
64: v_rowid VARCHAR2(25);
65: v_new_he_entrant_cd igs_he_en_susa.new_he_entrant_cd%TYPE;
66:
67: --Variables to hold old record unique key values

Line 184: FROM igs_ps_award, igs_he_code_map_val

180: -- that will be validated.
181: CURSOR c_prg_awd( cp_course_cd igs_he_st_prog_all.course_cd%TYPE,
182: cp_version_number igs_he_st_prog_all.version_number%TYPE) IS
183: SELECT map1
184: FROM igs_ps_award, igs_he_code_map_val
185: WHERE course_cd = cp_course_cd AND
186: version_number = cp_version_number AND
187: closed_ind = 'N' AND
188: map2 = award_cd AND

Line 232: FROM igs_he_code_map_val

228:
229: -- Required for validation against field in first record.
230: CURSOR term_map IS
231: SELECT map1
232: FROM igs_he_code_map_val
233: WHERE association_code = 'OSS_HESA_TTA_ASSOC' AND
234: map2 = (select term_time_accom
235: from igs_he_en_susa
236: where person_id = p_person_id AND

Line 734: v_teach_map1 igs_he_code_map_val.map1%TYPE;

730: v_qual_aim_subj1 igs_he_st_spa_all.qual_aim_subj1%TYPE;
731: v_qual_aim_subj2 igs_he_st_spa_all.qual_aim_subj2%TYPE;
732: v_qual_aim_subj3 igs_he_st_spa_all.qual_aim_subj3%TYPE;
733: v_qual_aim_proportion igs_he_st_spa_all.qual_aim_proportion%TYPE;
734: v_teach_map1 igs_he_code_map_val.map1%TYPE;
735: v_new_hesa_qual_map1 igs_he_code_map_val.map1%TYPE;
736: v_old_hesa_qual_map1 igs_he_code_map_val.map1%TYPE;
737: v_rowid VARCHAR2(25);
738: v_org_id NUMBER := igs_ge_gen_003.get_org_id;

Line 735: v_new_hesa_qual_map1 igs_he_code_map_val.map1%TYPE;

731: v_qual_aim_subj2 igs_he_st_spa_all.qual_aim_subj2%TYPE;
732: v_qual_aim_subj3 igs_he_st_spa_all.qual_aim_subj3%TYPE;
733: v_qual_aim_proportion igs_he_st_spa_all.qual_aim_proportion%TYPE;
734: v_teach_map1 igs_he_code_map_val.map1%TYPE;
735: v_new_hesa_qual_map1 igs_he_code_map_val.map1%TYPE;
736: v_old_hesa_qual_map1 igs_he_code_map_val.map1%TYPE;
737: v_rowid VARCHAR2(25);
738: v_org_id NUMBER := igs_ge_gen_003.get_org_id;
739: v_highest_qual_on_entry igs_he_st_spa_all.highest_qual_on_entry%TYPE;

Line 736: v_old_hesa_qual_map1 igs_he_code_map_val.map1%TYPE;

732: v_qual_aim_subj3 igs_he_st_spa_all.qual_aim_subj3%TYPE;
733: v_qual_aim_proportion igs_he_st_spa_all.qual_aim_proportion%TYPE;
734: v_teach_map1 igs_he_code_map_val.map1%TYPE;
735: v_new_hesa_qual_map1 igs_he_code_map_val.map1%TYPE;
736: v_old_hesa_qual_map1 igs_he_code_map_val.map1%TYPE;
737: v_rowid VARCHAR2(25);
738: v_org_id NUMBER := igs_ge_gen_003.get_org_id;
739: v_highest_qual_on_entry igs_he_st_spa_all.highest_qual_on_entry%TYPE;
740: v_total_ucas_tariff igs_he_st_spa_all.total_ucas_tariff%TYPE;

Line 778: FROM igs_ps_award , igs_he_code_map_val

774: -- Cursor to retrieve record values for award code from IGS_PS_AWARD
775: CURSOR c_awardcode (cp_course_cd igs_ps_award.course_cd%TYPE ,
776: cp_version_number igs_ps_award.version_number%TYPE) IS
777: SELECT map1
778: FROM igs_ps_award , igs_he_code_map_val
779: WHERE course_cd = cp_course_cd AND
780: version_number = cp_version_number AND
781: closed_ind = 'N' AND
782: map2 = award_cd AND

Line 834: CURSOR teach_map(cp_teacher_train_prog_id igs_he_code_map_val.map2%TYPE) IS

830: c_old_spa_rec c_old_spa%ROWTYPE;
831:
832: -- Cursor required for validation against field in second record.
833: -- get the hesa code mapped to the oss tacher code
834: CURSOR teach_map(cp_teacher_train_prog_id igs_he_code_map_val.map2%TYPE) IS
835: SELECT map1
836: FROM igs_he_code_map_val
837: WHERE association_code = 'OSS_HESA_TTCID_ASSOC' AND
838: map2 = cp_teacher_train_prog_id;

Line 836: FROM igs_he_code_map_val

832: -- Cursor required for validation against field in second record.
833: -- get the hesa code mapped to the oss tacher code
834: CURSOR teach_map(cp_teacher_train_prog_id igs_he_code_map_val.map2%TYPE) IS
835: SELECT map1
836: FROM igs_he_code_map_val
837: WHERE association_code = 'OSS_HESA_TTCID_ASSOC' AND
838: map2 = cp_teacher_train_prog_id;
839:
840: -- Cursor to retrieve values required for ucas tariff record.