APPS.IGS_HE_UCAS_TARIFF_PKG dependencies on IGS_HE_ST_SPA_UT

Line 211: FROM Igs_he_st_spa_ut

207: -- get the rowid for Student attempt
208: CURSOR Cur_st_spa_ut (l_person_id igs_he_st_spa.person_id%TYPE,
209: l_course_cd igs_he_st_spa.course_cd%TYPE ) IS
210: SELECT rowid
211: FROM Igs_he_st_spa_ut
212: WHERE Person_id = l_person_id
213: AND course_cd = l_course_cd;
214:
215: --get the Highest qualification on entry as the highest ranked qualification

Line 289: l_tariff_score igs_he_st_spa_ut_all.tariff_score%TYPE := 0;

285: -- l_tariff_score igs_uc_qual_dets.ucas_tariff%TYPE := 0;
286: -- was causing an Unhandled Exception when value > 999
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;

Line 290: l_qual_count Igs_he_st_spa_ut_all.Number_of_qual%TYPE := 0;

286: -- was causing an Unhandled Exception when value > 999
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;

Line 295: l_hesa_st_spau_id Igs_he_st_spa_ut_all.hesa_st_spau_id%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;
296: l_Qual_aim igs_he_code_map_val.map1%TYPE ;
297: l_rowid VARCHAR2(26) ;
298: C_st_spa_for_update cur_st_spa_for_update%ROWTYPE;
299: l_grade cur_highest_grade%ROWTYPE;

Line 520: Igs_he_st_spa_ut_all_pkg.delete_row(x_rowid => Cur_st_spa_ut_rec.rowid );

516: -- UCAS tariff is calculated only for qualification aim between 19-52 or 61 or 97
517:
518: -- Before calculating the ucas scoress, Delete the all ucas tariff scores for the student attempt
519: FOR Cur_st_spa_ut_rec IN Cur_st_spa_ut(c_st_spa.person_id, c_st_spa.course_cd) LOOP
520: Igs_he_st_spa_ut_all_pkg.delete_row(x_rowid => Cur_st_spa_ut_rec.rowid );
521: END LOOP;
522:
523: IF ((l_qual_aim BETWEEN 18 AND 52) OR (l_qual_aim = 61 OR l_qual_aim = 97)) THEN
524:

Line 590: Igs_he_st_spa_ut_all_pkg.Insert_row (

586:
587: -- Insert the Tariff scores for each Exam level of an applicant and
588: -- the number of subject of each Exam level
589:
590: Igs_he_st_spa_ut_all_pkg.Insert_row (
591: x_mode => 'R',
592: x_rowid => l_rowid,
593: x_hesa_st_spau_id => l_hesa_st_spau_id,
594: x_Person_id => c_st_spa.person_id,

Line 1350: ucas tariff score details. so removed the Igs_he_st_spa_ut_all_pkg update row call

1346: smvk 03-Jun-2003 Bug # 2858436.Modified the cursor c_prgawd to select open program awards only.
1347: rbezawad 13-Feb-03 Modified w.r.t. HEFD202.1 build, Bug 2717744.
1348: Introduced logic to aviod double counting of qualifications
1349: pmarada 24-jul-2003 Before creating the ucas tariff scores for a student deleting old
1350: ucas tariff score details. so removed the Igs_he_st_spa_ut_all_pkg update row call
1351: and added delete row call. as per the bug 3064689
1352: rgangara 29-Aug-03 Added 4 new parameters and created this as a separate procedure
1353: for ease of understanding and maintenance
1354: ayedubat 16-MAR-04 Added a new parameter, p_report_all_hierarchy_flag to the internal and