APPS.IGS_HE_UCAS_TARIFF_PKG dependencies on IGS_HE_ST_SPA_UT_ALL_PKG

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