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_ST_SPA_ALL

Line 16: -- in IGS_HE_ST_SPA_ALL table as a part of bug 2636897

12: --smvk 03-Jun-2003 Bug # 2858436.Modified the cursor c_prg_awd to select open program awards only.
13: -- smaddali (bug#2371477) 16-may-2002 modified this procedure to create the new unit
14: -- set attempt hesa details record even when the old susa hesa details record is not found
15: --Bayadav 22-OCT-2002 Included four new columns qual_aim_subj1,qual_aim_subj2,qual_aim_subj3,qual_aim_proportion
16: -- in IGS_HE_ST_SPA_ALL table as a part of bug 2636897
17: -- Bayadav 05-DEC-2002 Included the check for HESA qualaim instead of award code before copying the old units values back to the new unit
18: -- as a part of bug 2671155
19: -- smaddali modified procedure to copy new_he_entrant_cd and modified validation for fundability_cd ,bug 2730371
20: -- smaddali modified procedure to copy new_he_entrant_cd for continuous programs of study ,bug 2717755

Line 50: v_student_qual_aim igs_he_st_spa_all.student_qual_aim%TYPE;

46: -- Variables to hold final values for first record
47: v_hesa_en_susa_id igs_he_en_susa.hesa_en_susa_id%TYPE;
48: v_term_time_accom igs_he_en_susa.term_time_accom%TYPE;
49: v_study_mode igs_he_en_susa.study_mode%TYPE;
50: v_student_qual_aim igs_he_st_spa_all.student_qual_aim%TYPE;
51: v_franchising_activity igs_he_en_susa.franchising_activity%TYPE;
52: v_fte_perc_override igs_he_en_susa.fte_perc_override%TYPE;
53: v_fundability_code igs_he_en_susa.fundability_code%TYPE;
54: v_fee_band igs_he_en_susa.fee_band%TYPE;

Line 684: tables IGS_HE_ST_SPA_ALL and IGS_HE_ST_SPA_UT_ALL.

680:
681:
682: /*---------------------------------------------------------------------
683: This procedure will copy old record details to a new record for
684: tables IGS_HE_ST_SPA_ALL and IGS_HE_ST_SPA_UT_ALL.
685:
686: Output : p_message_name - Exit error message
687: p_status - Return code for the procedure.
688: 0 - Success

Line 716: v_hesa_st_spa_id igs_he_st_spa_all.hesa_st_spa_id%TYPE;

712: v_old_number_of_qual igs_he_st_spa_ut_all.number_of_qual%TYPE;
713: v_old_tariff_score igs_he_st_spa_ut_all.tariff_score%TYPE;
714:
715: -- Variables to hold final values for second record
716: v_hesa_st_spa_id igs_he_st_spa_all.hesa_st_spa_id%TYPE;
717: v_student_qual_aim igs_he_st_spa_all.student_qual_aim%TYPE;
718: v_student_inst_number igs_he_st_spa_all.student_inst_number%TYPE;
719: v_commencement_dt igs_he_st_spa_all.commencement_dt%TYPE;
720: v_fe_student_marker igs_he_st_spa_all.fe_student_marker%TYPE;

Line 717: v_student_qual_aim igs_he_st_spa_all.student_qual_aim%TYPE;

713: v_old_tariff_score igs_he_st_spa_ut_all.tariff_score%TYPE;
714:
715: -- Variables to hold final values for second record
716: v_hesa_st_spa_id igs_he_st_spa_all.hesa_st_spa_id%TYPE;
717: v_student_qual_aim igs_he_st_spa_all.student_qual_aim%TYPE;
718: v_student_inst_number igs_he_st_spa_all.student_inst_number%TYPE;
719: v_commencement_dt igs_he_st_spa_all.commencement_dt%TYPE;
720: v_fe_student_marker igs_he_st_spa_all.fe_student_marker%TYPE;
721: v_domicile_cd igs_he_st_spa_all.domicile_cd%TYPE;

Line 718: v_student_inst_number igs_he_st_spa_all.student_inst_number%TYPE;

714:
715: -- Variables to hold final values for second record
716: v_hesa_st_spa_id igs_he_st_spa_all.hesa_st_spa_id%TYPE;
717: v_student_qual_aim igs_he_st_spa_all.student_qual_aim%TYPE;
718: v_student_inst_number igs_he_st_spa_all.student_inst_number%TYPE;
719: v_commencement_dt igs_he_st_spa_all.commencement_dt%TYPE;
720: v_fe_student_marker igs_he_st_spa_all.fe_student_marker%TYPE;
721: v_domicile_cd igs_he_st_spa_all.domicile_cd%TYPE;
722: v_postcode igs_he_st_spa_all.postcode%TYPE;

Line 719: v_commencement_dt igs_he_st_spa_all.commencement_dt%TYPE;

715: -- Variables to hold final values for second record
716: v_hesa_st_spa_id igs_he_st_spa_all.hesa_st_spa_id%TYPE;
717: v_student_qual_aim igs_he_st_spa_all.student_qual_aim%TYPE;
718: v_student_inst_number igs_he_st_spa_all.student_inst_number%TYPE;
719: v_commencement_dt igs_he_st_spa_all.commencement_dt%TYPE;
720: v_fe_student_marker igs_he_st_spa_all.fe_student_marker%TYPE;
721: v_domicile_cd igs_he_st_spa_all.domicile_cd%TYPE;
722: v_postcode igs_he_st_spa_all.postcode%TYPE;
723: v_special_student igs_he_st_spa_all.special_student%TYPE;

Line 720: v_fe_student_marker igs_he_st_spa_all.fe_student_marker%TYPE;

716: v_hesa_st_spa_id igs_he_st_spa_all.hesa_st_spa_id%TYPE;
717: v_student_qual_aim igs_he_st_spa_all.student_qual_aim%TYPE;
718: v_student_inst_number igs_he_st_spa_all.student_inst_number%TYPE;
719: v_commencement_dt igs_he_st_spa_all.commencement_dt%TYPE;
720: v_fe_student_marker igs_he_st_spa_all.fe_student_marker%TYPE;
721: v_domicile_cd igs_he_st_spa_all.domicile_cd%TYPE;
722: v_postcode igs_he_st_spa_all.postcode%TYPE;
723: v_special_student igs_he_st_spa_all.special_student%TYPE;
724: v_social_class_ind igs_he_st_spa_all.social_class_ind%TYPE;

Line 721: v_domicile_cd igs_he_st_spa_all.domicile_cd%TYPE;

717: v_student_qual_aim igs_he_st_spa_all.student_qual_aim%TYPE;
718: v_student_inst_number igs_he_st_spa_all.student_inst_number%TYPE;
719: v_commencement_dt igs_he_st_spa_all.commencement_dt%TYPE;
720: v_fe_student_marker igs_he_st_spa_all.fe_student_marker%TYPE;
721: v_domicile_cd igs_he_st_spa_all.domicile_cd%TYPE;
722: v_postcode igs_he_st_spa_all.postcode%TYPE;
723: v_special_student igs_he_st_spa_all.special_student%TYPE;
724: v_social_class_ind igs_he_st_spa_all.social_class_ind%TYPE;
725: v_occupation_code igs_he_st_spa_all.occupation_code%TYPE;

Line 722: v_postcode igs_he_st_spa_all.postcode%TYPE;

718: v_student_inst_number igs_he_st_spa_all.student_inst_number%TYPE;
719: v_commencement_dt igs_he_st_spa_all.commencement_dt%TYPE;
720: v_fe_student_marker igs_he_st_spa_all.fe_student_marker%TYPE;
721: v_domicile_cd igs_he_st_spa_all.domicile_cd%TYPE;
722: v_postcode igs_he_st_spa_all.postcode%TYPE;
723: v_special_student igs_he_st_spa_all.special_student%TYPE;
724: v_social_class_ind igs_he_st_spa_all.social_class_ind%TYPE;
725: v_occupation_code igs_he_st_spa_all.occupation_code%TYPE;
726: v_occcode igs_he_st_spa_all.occcode%TYPE;

Line 723: v_special_student igs_he_st_spa_all.special_student%TYPE;

719: v_commencement_dt igs_he_st_spa_all.commencement_dt%TYPE;
720: v_fe_student_marker igs_he_st_spa_all.fe_student_marker%TYPE;
721: v_domicile_cd igs_he_st_spa_all.domicile_cd%TYPE;
722: v_postcode igs_he_st_spa_all.postcode%TYPE;
723: v_special_student igs_he_st_spa_all.special_student%TYPE;
724: v_social_class_ind igs_he_st_spa_all.social_class_ind%TYPE;
725: v_occupation_code igs_he_st_spa_all.occupation_code%TYPE;
726: v_occcode igs_he_st_spa_all.occcode%TYPE;
727: v_student_fe_qual_aim igs_he_st_spa_all.student_fe_qual_aim%TYPE;

Line 724: v_social_class_ind igs_he_st_spa_all.social_class_ind%TYPE;

720: v_fe_student_marker igs_he_st_spa_all.fe_student_marker%TYPE;
721: v_domicile_cd igs_he_st_spa_all.domicile_cd%TYPE;
722: v_postcode igs_he_st_spa_all.postcode%TYPE;
723: v_special_student igs_he_st_spa_all.special_student%TYPE;
724: v_social_class_ind igs_he_st_spa_all.social_class_ind%TYPE;
725: v_occupation_code igs_he_st_spa_all.occupation_code%TYPE;
726: v_occcode igs_he_st_spa_all.occcode%TYPE;
727: v_student_fe_qual_aim igs_he_st_spa_all.student_fe_qual_aim%TYPE;
728: v_teacher_train_prog_id igs_he_st_spa_all.teacher_train_prog_id%TYPE;

Line 725: v_occupation_code igs_he_st_spa_all.occupation_code%TYPE;

721: v_domicile_cd igs_he_st_spa_all.domicile_cd%TYPE;
722: v_postcode igs_he_st_spa_all.postcode%TYPE;
723: v_special_student igs_he_st_spa_all.special_student%TYPE;
724: v_social_class_ind igs_he_st_spa_all.social_class_ind%TYPE;
725: v_occupation_code igs_he_st_spa_all.occupation_code%TYPE;
726: v_occcode igs_he_st_spa_all.occcode%TYPE;
727: v_student_fe_qual_aim igs_he_st_spa_all.student_fe_qual_aim%TYPE;
728: v_teacher_train_prog_id igs_he_st_spa_all.teacher_train_prog_id%TYPE;
729: v_nhs_funding_source igs_he_st_spa_all.nhs_funding_source%TYPE;

Line 726: v_occcode igs_he_st_spa_all.occcode%TYPE;

722: v_postcode igs_he_st_spa_all.postcode%TYPE;
723: v_special_student igs_he_st_spa_all.special_student%TYPE;
724: v_social_class_ind igs_he_st_spa_all.social_class_ind%TYPE;
725: v_occupation_code igs_he_st_spa_all.occupation_code%TYPE;
726: v_occcode igs_he_st_spa_all.occcode%TYPE;
727: v_student_fe_qual_aim igs_he_st_spa_all.student_fe_qual_aim%TYPE;
728: v_teacher_train_prog_id igs_he_st_spa_all.teacher_train_prog_id%TYPE;
729: v_nhs_funding_source igs_he_st_spa_all.nhs_funding_source%TYPE;
730: v_qual_aim_subj1 igs_he_st_spa_all.qual_aim_subj1%TYPE;

Line 727: v_student_fe_qual_aim igs_he_st_spa_all.student_fe_qual_aim%TYPE;

723: v_special_student igs_he_st_spa_all.special_student%TYPE;
724: v_social_class_ind igs_he_st_spa_all.social_class_ind%TYPE;
725: v_occupation_code igs_he_st_spa_all.occupation_code%TYPE;
726: v_occcode igs_he_st_spa_all.occcode%TYPE;
727: v_student_fe_qual_aim igs_he_st_spa_all.student_fe_qual_aim%TYPE;
728: v_teacher_train_prog_id igs_he_st_spa_all.teacher_train_prog_id%TYPE;
729: v_nhs_funding_source igs_he_st_spa_all.nhs_funding_source%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;

Line 728: v_teacher_train_prog_id igs_he_st_spa_all.teacher_train_prog_id%TYPE;

724: v_social_class_ind igs_he_st_spa_all.social_class_ind%TYPE;
725: v_occupation_code igs_he_st_spa_all.occupation_code%TYPE;
726: v_occcode igs_he_st_spa_all.occcode%TYPE;
727: v_student_fe_qual_aim igs_he_st_spa_all.student_fe_qual_aim%TYPE;
728: v_teacher_train_prog_id igs_he_st_spa_all.teacher_train_prog_id%TYPE;
729: v_nhs_funding_source igs_he_st_spa_all.nhs_funding_source%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;

Line 729: v_nhs_funding_source igs_he_st_spa_all.nhs_funding_source%TYPE;

725: v_occupation_code igs_he_st_spa_all.occupation_code%TYPE;
726: v_occcode igs_he_st_spa_all.occcode%TYPE;
727: v_student_fe_qual_aim igs_he_st_spa_all.student_fe_qual_aim%TYPE;
728: v_teacher_train_prog_id igs_he_st_spa_all.teacher_train_prog_id%TYPE;
729: v_nhs_funding_source igs_he_st_spa_all.nhs_funding_source%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;

Line 730: v_qual_aim_subj1 igs_he_st_spa_all.qual_aim_subj1%TYPE;

726: v_occcode igs_he_st_spa_all.occcode%TYPE;
727: v_student_fe_qual_aim igs_he_st_spa_all.student_fe_qual_aim%TYPE;
728: v_teacher_train_prog_id igs_he_st_spa_all.teacher_train_prog_id%TYPE;
729: v_nhs_funding_source igs_he_st_spa_all.nhs_funding_source%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;

Line 731: v_qual_aim_subj2 igs_he_st_spa_all.qual_aim_subj2%TYPE;

727: v_student_fe_qual_aim igs_he_st_spa_all.student_fe_qual_aim%TYPE;
728: v_teacher_train_prog_id igs_he_st_spa_all.teacher_train_prog_id%TYPE;
729: v_nhs_funding_source igs_he_st_spa_all.nhs_funding_source%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;

Line 732: v_qual_aim_subj3 igs_he_st_spa_all.qual_aim_subj3%TYPE;

728: v_teacher_train_prog_id igs_he_st_spa_all.teacher_train_prog_id%TYPE;
729: v_nhs_funding_source igs_he_st_spa_all.nhs_funding_source%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;

Line 733: v_qual_aim_proportion igs_he_st_spa_all.qual_aim_proportion%TYPE;

729: v_nhs_funding_source igs_he_st_spa_all.nhs_funding_source%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);

Line 739: v_highest_qual_on_entry igs_he_st_spa_all.highest_qual_on_entry%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;
741:
742: -- Variables to hold final values for third record
743: v_hesa_st_spau_id igs_he_st_spa_ut_all.hesa_st_spau_id%TYPE;

Line 740: v_total_ucas_tariff igs_he_st_spa_all.total_ucas_tariff%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;
741:
742: -- Variables to hold final values for third record
743: v_hesa_st_spau_id igs_he_st_spa_ut_all.hesa_st_spau_id%TYPE;
744: v_qualification_level igs_he_st_spa_ut_all.qualification_level%TYPE;

Line 827: FROM igs_he_st_spa_all

823: qual_aim_subj3,
824: qual_aim_proportion ,
825: highest_qual_on_entry,
826: total_ucas_tariff
827: FROM igs_he_st_spa_all
828: WHERE person_id = p_person_id AND
829: course_cd = p_old_course_cd;
830: c_old_spa_rec c_old_spa%ROWTYPE;
831:

Line 849: CURSOR cur_std_inst_num(cp_person_id igs_he_st_spa_all.person_id%TYPE) IS

845: FROM igs_he_st_spa_ut
846: WHERE person_id = p_person_id AND
847: course_cd = p_old_course_cd;
848:
849: CURSOR cur_std_inst_num(cp_person_id igs_he_st_spa_all.person_id%TYPE) IS
850: SELECT student_inst_number
851: FROM igs_he_st_spa_all
852: WHERE person_id = cp_person_id;
853:

Line 851: FROM igs_he_st_spa_all

847: course_cd = p_old_course_cd;
848:
849: CURSOR cur_std_inst_num(cp_person_id igs_he_st_spa_all.person_id%TYPE) IS
850: SELECT student_inst_number
851: FROM igs_he_st_spa_all
852: WHERE person_id = cp_person_id;
853:
854: l_std_inst_num NUMBER;
855:

Line 962: -- new record in igs_he_st_spa_all table, added as per

958: FETCH c_old_spa INTO c_old_spa_rec;
959: IF c_old_spa%NOTFOUND THEN
960: CLOSE c_old_spa;
961: -- Derive the student instance number value and use this value while creating
962: -- new record in igs_he_st_spa_all table, added as per
963: -- HECR008-alpha numeric student instance number CR
964: l_std_inst_num := 1;
965: FOR cur_std_inst_num_rec IN cur_std_inst_num(p_person_id) LOOP
966: BEGIN

Line 980: igs_he_st_spa_all_pkg.insert_row(

976: v_student_inst_number := l_std_inst_num ;
977:
978: -- create the SPA record for the old program attempt
979: --Insert Values Into Record
980: igs_he_st_spa_all_pkg.insert_row(
981: x_rowid => v_rowid,
982: x_hesa_st_spa_id => v_hesa_st_spa_id,
983: x_org_id => v_org_id,
984: x_person_id => p_person_id,

Line 1042: -- new record in igs_he_st_spa_all table, added as per

1038: --copy value from old spa record created above to new record.
1039: v_student_inst_number := v_student_inst_number;
1040: ELSE
1041: -- Derive the student instance number value and use this value while creating
1042: -- new record in igs_he_st_spa_all table, added as per
1043: -- HECR008-alpha numeric student instance number CR
1044: l_std_inst_num := 1;
1045: FOR cur_std_inst_num_rec IN cur_std_inst_num(p_person_id) LOOP
1046: BEGIN

Line 1061: igs_he_st_spa_all_pkg.insert_row(

1057:
1058: v_rowid := NULL ;
1059: v_hesa_st_spa_id := NULL ;
1060:
1061: igs_he_st_spa_all_pkg.insert_row(
1062: x_rowid => v_rowid,
1063: x_hesa_st_spa_id => v_hesa_st_spa_id,
1064: x_org_id => v_org_id,
1065: x_person_id => p_person_id,

Line 1125: -- new record in igs_he_st_spa_all table, added as per

1121: --copy value from old record to new record.
1122: v_student_inst_number := c_old_spa_rec.student_inst_number;
1123: ELSE
1124: -- Derive the student instance number value and use this value while creating
1125: -- new record in igs_he_st_spa_all table, added as per
1126: -- HECR008-alpha numeric student instance number CR
1127: l_std_inst_num := 1;
1128: FOR cur_std_inst_num_rec IN cur_std_inst_num(p_person_id) LOOP
1129: BEGIN

Line 1194: igs_he_st_spa_all_pkg.insert_row(

1190:
1191: END IF; -- if old program's qualification aim is same as that of new program
1192:
1193: --Insert Values Into Record
1194: igs_he_st_spa_all_pkg.insert_row(
1195: x_rowid => v_rowid,
1196: x_hesa_st_spa_id => v_hesa_st_spa_id,
1197: x_org_id => v_org_id,
1198: x_person_id => p_person_id,