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_UT

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 711: v_old_qualification_level igs_he_st_spa_ut_all.qualification_level%TYPE;

707: p_status OUT NOCOPY VARCHAR2,
708: p_message_name OUT NOCOPY VARCHAR2) IS
709:
710: -- Variables to hold old values for third record.
711: v_old_qualification_level igs_he_st_spa_ut_all.qualification_level%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

Line 712: v_old_number_of_qual igs_he_st_spa_ut_all.number_of_qual%TYPE;

708: p_message_name OUT NOCOPY VARCHAR2) IS
709:
710: -- Variables to hold old values for third record.
711: v_old_qualification_level igs_he_st_spa_ut_all.qualification_level%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;

Line 713: v_old_tariff_score igs_he_st_spa_ut_all.tariff_score%TYPE;

709:
710: -- Variables to hold old values for third record.
711: v_old_qualification_level igs_he_st_spa_ut_all.qualification_level%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;

Line 743: v_hesa_st_spau_id igs_he_st_spa_ut_all.hesa_st_spau_id%TYPE;

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;
745: v_number_of_qual igs_he_st_spa_ut_all.number_of_qual%TYPE;
746: v_tariff_score igs_he_st_spa_ut_all.tariff_score%TYPE;
747: v_ut_rowid VARCHAR2(25);

Line 744: v_qualification_level igs_he_st_spa_ut_all.qualification_level%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;
745: v_number_of_qual igs_he_st_spa_ut_all.number_of_qual%TYPE;
746: v_tariff_score igs_he_st_spa_ut_all.tariff_score%TYPE;
747: v_ut_rowid VARCHAR2(25);
748:

Line 745: v_number_of_qual igs_he_st_spa_ut_all.number_of_qual%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;
745: v_number_of_qual igs_he_st_spa_ut_all.number_of_qual%TYPE;
746: v_tariff_score igs_he_st_spa_ut_all.tariff_score%TYPE;
747: v_ut_rowid VARCHAR2(25);
748:
749: -- Variables to hold old and new values from other tables for record.

Line 746: v_tariff_score igs_he_st_spa_ut_all.tariff_score%TYPE;

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;
745: v_number_of_qual igs_he_st_spa_ut_all.number_of_qual%TYPE;
746: v_tariff_score igs_he_st_spa_ut_all.tariff_score%TYPE;
747: v_ut_rowid VARCHAR2(25);
748:
749: -- Variables to hold old and new values from other tables for record.
750: v_old_tmp_prgfldstudy igs_ps_field_study.field_of_study%TYPE;

Line 845: FROM igs_he_st_spa_ut

841: CURSOR ucas_tariff IS
842: SELECT qualification_level,
843: number_of_qual,
844: tariff_score
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

Line 1259: igs_he_st_spa_ut_all_pkg.insert_row(

1255: v_tariff_score;
1256: EXIT WHEN ucas_tariff%NOTFOUND;
1257:
1258: --Insert Values into Record
1259: igs_he_st_spa_ut_all_pkg.insert_row(
1260: x_rowid => v_ut_rowid,
1261: x_hesa_st_spau_id => v_hesa_st_spau_id,
1262: x_org_id => v_org_id,
1263: x_person_id => p_person_id,