APPS.IGS_HE_UCAS_TARIFF_PKG dependencies on IGS_HE_ST_SPA_ALL

Line 44: -- jbaber 19-Jan-06 Included igs_he_st_spa_all.exclude flag for HE305

40: -- jbaber 29-NOV-04 Modified procedure, external_tariff_calc to exclude
41: -- students with no qualifications for Bug# 4035243
42: -- anwest 24-Jan-05 Bug# 4035243 Variable declaration and logging altered
43: -- for unhandled exception noted in peer review
44: -- jbaber 19-Jan-06 Included igs_he_st_spa_all.exclude flag for HE305
45: -- jchin 27-Jan-06 Bug 3484372 output full grade name instead of grade val
46: -- jchakrab 21-Feb-06 Modified for R12 performance enhs - replaced literal SQL with fnd_dsql
47: -- anwest 24-Mar-06 Bug# 5121695 - Modified for impact from R12 SWS changes.
48: -- Replaced IGS_GET_DYNAMIC_SQL(p_pid_group,l_status) with

Line 291: l_total_tariff_score Igs_he_st_spa_all.total_ucas_tariff%TYPE := 0;

287: -- because igs_uc_qual_dets.ucas_tariff%TYPE is defined as
288: -- NUMBER(3)
289: l_tariff_score igs_he_st_spa_ut_all.tariff_score%TYPE := 0;
290: l_qual_count Igs_he_st_spa_ut_all.Number_of_qual%TYPE := 0;
291: l_total_tariff_score Igs_he_st_spa_all.total_ucas_tariff%TYPE := 0;
292: l_last_update_date Igs_uc_qual_dets.Last_update_date%TYPE ;
293: l_record_inserted NUMBER := 0;
294: l_record_updated NUMBER := 0;
295: l_hesa_st_spau_id Igs_he_st_spa_ut_all.hesa_st_spau_id%TYPE := 0;

Line 631: Igs_he_st_spa_all_pkg.Update_row (

627: OPEN Cur_highest_grade (C_ST_SPA.person_id, c_st_spa.commencement_dt);
628: FETCH Cur_highest_grade INTO l_grade ;
629: CLOSE Cur_highest_grade;
630:
631: Igs_he_st_spa_all_pkg.Update_row (
632: x_mode => 'R',
633: x_rowid => c_st_spa_for_update.row_id,
634: x_hesa_st_spa_id => c_st_spa_for_update.hesa_st_spa_id,
635: x_course_cd => c_st_spa_for_update.course_cd,