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_UCAS_TARIFF_PKG dependencies on IGS_HE_ST_SPA

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 71: CURSOR Cur_qual_aim (cp_student_qual_aim Igs_he_st_spa.Student_qual_aim%TYPE) IS

67: AND version_number = cp_version
68: AND course_group_cd = p_program_group;
69:
70: -- get the HESA code for oss qualification aim
71: CURSOR Cur_qual_aim (cp_student_qual_aim Igs_he_st_spa.Student_qual_aim%TYPE) IS
72: SELECT map1
73: FROM igs_he_code_map_val
74: WHERE Association_code ='OSS_HESA_AWD_ASSOC'
75: AND Map2 = cp_Student_qual_aim ;

Line 142: CURSOR Cur_st_spa_for_update (l_person_id igs_he_st_spa.person_id%TYPE,

138:
139:
140: -- get the spa record to be updated for fields highest_qual_on_entry , date_qual_on_entry_calc,
141: -- total_ucas_tariff
142: CURSOR Cur_st_spa_for_update (l_person_id igs_he_st_spa.person_id%TYPE,
143: l_course_cd igs_he_st_spa.course_cd%TYPE) IS
144: SELECT ihss.row_id row_id,
145: ihss.hesa_st_spa_id hesa_st_spa_id,
146: ihss.course_cd course_cd,

Line 143: l_course_cd igs_he_st_spa.course_cd%TYPE) IS

139:
140: -- get the spa record to be updated for fields highest_qual_on_entry , date_qual_on_entry_calc,
141: -- total_ucas_tariff
142: CURSOR Cur_st_spa_for_update (l_person_id igs_he_st_spa.person_id%TYPE,
143: l_course_cd igs_he_st_spa.course_cd%TYPE) IS
144: SELECT ihss.row_id row_id,
145: ihss.hesa_st_spa_id hesa_st_spa_id,
146: ihss.course_cd course_cd,
147: ihss.version_number version_number,

Line 203: FROM igs_he_st_spa ihss

199: ihss.employer_role_cd,
200: ihss.disadv_uplift_factor,
201: ihss.enh_fund_elig_cd,
202: ihss.exclude_flag
203: FROM igs_he_st_spa ihss
204: WHERE ihss.person_id = l_person_id
205: AND ihss.course_cd = l_course_cd;
206:
207: -- get the rowid for Student attempt

Line 208: CURSOR Cur_st_spa_ut (l_person_id igs_he_st_spa.person_id%TYPE,

204: WHERE ihss.person_id = l_person_id
205: AND ihss.course_cd = l_course_cd;
206:
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

Line 209: l_course_cd igs_he_st_spa.course_cd%TYPE ) IS

205: AND ihss.course_cd = l_course_cd;
206:
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;

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 219: CURSOR Cur_highest_grade (l_person_id igs_he_st_spa.person_id%TYPE ,

215: --get the Highest qualification on entry as the highest ranked qualification
216: --smaddali modified cursor to select only open code_values from igs_he_code_values ,bug 2730388
217: --Correct the comparision done in this cursor to compare Iagsta.grading_schema_cd with the Iuqd.grading_schema_cd
218: --Not with the Exam Level as mentioned in bug 2782618
219: CURSOR Cur_highest_grade (l_person_id igs_he_st_spa.person_id%TYPE ,
220: p_commencement_dt igs_he_st_spa.commencement_dt%TYPE) IS
221: SELECT Iagsta.grade,
222: Iagsta.To_grading_schema_cd,
223: Iagsta.to_version_number,

Line 220: p_commencement_dt igs_he_st_spa.commencement_dt%TYPE) IS

216: --smaddali modified cursor to select only open code_values from igs_he_code_values ,bug 2730388
217: --Correct the comparision done in this cursor to compare Iagsta.grading_schema_cd with the Iuqd.grading_schema_cd
218: --Not with the Exam Level as mentioned in bug 2782618
219: CURSOR Cur_highest_grade (l_person_id igs_he_st_spa.person_id%TYPE ,
220: p_commencement_dt igs_he_st_spa.commencement_dt%TYPE) IS
221: SELECT Iagsta.grade,
222: Iagsta.To_grading_schema_cd,
223: Iagsta.to_version_number,
224: Iagsta.to_grade,

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 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 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 320: student_qual_aim igs_he_st_spa.student_qual_aim%TYPE

316: -- anwest added for Bug #5121695
317: l_group_type VARCHAR2(10);
318:
319: TYPE st_spa_rec is record (
320: student_qual_aim igs_he_st_spa.student_qual_aim%TYPE
321: ,commencement_dt igs_en_stdnt_ps_att.commencement_dt%TYPE
322: ,date_qual_on_entry_calc igs_he_st_spa.date_qual_on_entry_calc%TYPE
323: ,person_id igs_he_st_spa.person_id%TYPE
324: ,course_cd igs_he_st_spa.course_cd%TYPE

Line 322: ,date_qual_on_entry_calc igs_he_st_spa.date_qual_on_entry_calc%TYPE

318:
319: TYPE st_spa_rec is record (
320: student_qual_aim igs_he_st_spa.student_qual_aim%TYPE
321: ,commencement_dt igs_en_stdnt_ps_att.commencement_dt%TYPE
322: ,date_qual_on_entry_calc igs_he_st_spa.date_qual_on_entry_calc%TYPE
323: ,person_id igs_he_st_spa.person_id%TYPE
324: ,course_cd igs_he_st_spa.course_cd%TYPE
325: ,version_number igs_he_st_spa.version_number%TYPE);
326:

Line 323: ,person_id igs_he_st_spa.person_id%TYPE

319: TYPE st_spa_rec is record (
320: student_qual_aim igs_he_st_spa.student_qual_aim%TYPE
321: ,commencement_dt igs_en_stdnt_ps_att.commencement_dt%TYPE
322: ,date_qual_on_entry_calc igs_he_st_spa.date_qual_on_entry_calc%TYPE
323: ,person_id igs_he_st_spa.person_id%TYPE
324: ,course_cd igs_he_st_spa.course_cd%TYPE
325: ,version_number igs_he_st_spa.version_number%TYPE);
326:
327: c_st_spa st_spa_rec;

Line 324: ,course_cd igs_he_st_spa.course_cd%TYPE

320: student_qual_aim igs_he_st_spa.student_qual_aim%TYPE
321: ,commencement_dt igs_en_stdnt_ps_att.commencement_dt%TYPE
322: ,date_qual_on_entry_calc igs_he_st_spa.date_qual_on_entry_calc%TYPE
323: ,person_id igs_he_st_spa.person_id%TYPE
324: ,course_cd igs_he_st_spa.course_cd%TYPE
325: ,version_number igs_he_st_spa.version_number%TYPE);
326:
327: c_st_spa st_spa_rec;
328:

Line 325: ,version_number igs_he_st_spa.version_number%TYPE);

321: ,commencement_dt igs_en_stdnt_ps_att.commencement_dt%TYPE
322: ,date_qual_on_entry_calc igs_he_st_spa.date_qual_on_entry_calc%TYPE
323: ,person_id igs_he_st_spa.person_id%TYPE
324: ,course_cd igs_he_st_spa.course_cd%TYPE
325: ,version_number igs_he_st_spa.version_number%TYPE);
326:
327: c_st_spa st_spa_rec;
328:
329: BEGIN

Line 347: fnd_dsql.add_text('FROM igs_he_st_spa ihss, igs_en_stdnt_ps_att iespa ');

343: -- basic SQL statement for selecting records to be processed
344: -- modified for bug 4035243
345: fnd_dsql.add_text('SELECT ihss.student_qual_aim , iespa.commencement_dt, ihss.date_qual_on_entry_calc,');
346: fnd_dsql.add_text('ihss.person_id, ihss.course_cd, ihss.version_number ');
347: fnd_dsql.add_text('FROM igs_he_st_spa ihss, igs_en_stdnt_ps_att iespa ');
348: fnd_dsql.add_text('WHERE ihss.person_id = iespa.person_id AND ihss.course_cd = iespa.course_cd ');
349: fnd_dsql.add_text('AND hesa_return_id IS NULL AND hesa_submission_name IS NULL AND hesa_return_name IS NULL ');
350: fnd_dsql.add_text('AND EXISTS (SELECT person_id from igs_uc_qual_dets where person_id = ihss.person_id) ');
351:

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 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,

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