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_EN_HESA_PKG dependencies on IGS_HE_POOUS

Line 12: -- corresponding to changes in IGS_HE_POOUS_ALL

8: -- relating to HESA details
9: -- 1. UK Statistics - SPA
10: -- 2. Student Unit Set Attempt HESA Details
11: --sbaliga 16-Apr-2002 Modified HESA_SUSA_ENR procedure
12: -- corresponding to changes in IGS_HE_POOUS_ALL
13: -- and IGS_HE_EN_SUSA table
14: --smaddali 14-may-2002 added new parameter p_old_sequence_number and
15: -- renamed p_sequence_number to p_new_sequence_number in procedure hesa_susa_enr for bug#2350629
16: --Bayadav 22-OCT-2002 Included four new columns qual_aim_subj1,qual_aim_subj2,qual_aim_subj3,qual_aim_proportion

Line 356: gv_old_fte_rec igs_he_poous.fte_intensity%TYPE;

352: -- smaddali 8-jan-2004 Bug#3291399 , modified logic for copying field values
353: AS
354: -- gv_old_susa_rec IGS_HE_EN_SUSA%ROWTYPE;
355: --gv_new_susa_rec IGS_HE_EN_SUSA%ROWTYPE;
356: gv_old_fte_rec igs_he_poous.fte_intensity%TYPE;
357: gv_new_fte_rec igs_he_poous.fte_intensity%TYPE;
358: gv_old_fte_rec_type igs_he_poous.fte_calc_type%TYPE;
359: gv_new_fte_rec_type igs_he_poous.fte_calc_type%TYPE;
360: gv_old_franchising_rec igs_he_poous.franchising_activity%TYPE;

Line 357: gv_new_fte_rec igs_he_poous.fte_intensity%TYPE;

353: AS
354: -- gv_old_susa_rec IGS_HE_EN_SUSA%ROWTYPE;
355: --gv_new_susa_rec IGS_HE_EN_SUSA%ROWTYPE;
356: gv_old_fte_rec igs_he_poous.fte_intensity%TYPE;
357: gv_new_fte_rec igs_he_poous.fte_intensity%TYPE;
358: gv_old_fte_rec_type igs_he_poous.fte_calc_type%TYPE;
359: gv_new_fte_rec_type igs_he_poous.fte_calc_type%TYPE;
360: gv_old_franchising_rec igs_he_poous.franchising_activity%TYPE;
361: gv_new_franchising_rec igs_he_poous.franchising_activity%TYPE;

Line 358: gv_old_fte_rec_type igs_he_poous.fte_calc_type%TYPE;

354: -- gv_old_susa_rec IGS_HE_EN_SUSA%ROWTYPE;
355: --gv_new_susa_rec IGS_HE_EN_SUSA%ROWTYPE;
356: gv_old_fte_rec igs_he_poous.fte_intensity%TYPE;
357: gv_new_fte_rec igs_he_poous.fte_intensity%TYPE;
358: gv_old_fte_rec_type igs_he_poous.fte_calc_type%TYPE;
359: gv_new_fte_rec_type igs_he_poous.fte_calc_type%TYPE;
360: gv_old_franchising_rec igs_he_poous.franchising_activity%TYPE;
361: gv_new_franchising_rec igs_he_poous.franchising_activity%TYPE;
362: gv_old_fee_rec igs_he_poous.fee_band%TYPE;

Line 359: gv_new_fte_rec_type igs_he_poous.fte_calc_type%TYPE;

355: --gv_new_susa_rec IGS_HE_EN_SUSA%ROWTYPE;
356: gv_old_fte_rec igs_he_poous.fte_intensity%TYPE;
357: gv_new_fte_rec igs_he_poous.fte_intensity%TYPE;
358: gv_old_fte_rec_type igs_he_poous.fte_calc_type%TYPE;
359: gv_new_fte_rec_type igs_he_poous.fte_calc_type%TYPE;
360: gv_old_franchising_rec igs_he_poous.franchising_activity%TYPE;
361: gv_new_franchising_rec igs_he_poous.franchising_activity%TYPE;
362: gv_old_fee_rec igs_he_poous.fee_band%TYPE;
363: gv_new_fee_rec igs_he_poous.fee_band%TYPE;

Line 360: gv_old_franchising_rec igs_he_poous.franchising_activity%TYPE;

356: gv_old_fte_rec igs_he_poous.fte_intensity%TYPE;
357: gv_new_fte_rec igs_he_poous.fte_intensity%TYPE;
358: gv_old_fte_rec_type igs_he_poous.fte_calc_type%TYPE;
359: gv_new_fte_rec_type igs_he_poous.fte_calc_type%TYPE;
360: gv_old_franchising_rec igs_he_poous.franchising_activity%TYPE;
361: gv_new_franchising_rec igs_he_poous.franchising_activity%TYPE;
362: gv_old_fee_rec igs_he_poous.fee_band%TYPE;
363: gv_new_fee_rec igs_he_poous.fee_band%TYPE;
364:

Line 361: gv_new_franchising_rec igs_he_poous.franchising_activity%TYPE;

357: gv_new_fte_rec igs_he_poous.fte_intensity%TYPE;
358: gv_old_fte_rec_type igs_he_poous.fte_calc_type%TYPE;
359: gv_new_fte_rec_type igs_he_poous.fte_calc_type%TYPE;
360: gv_old_franchising_rec igs_he_poous.franchising_activity%TYPE;
361: gv_new_franchising_rec igs_he_poous.franchising_activity%TYPE;
362: gv_old_fee_rec igs_he_poous.fee_band%TYPE;
363: gv_new_fee_rec igs_he_poous.fee_band%TYPE;
364:
365: CURSOR gc_old_susa_rec IS

Line 362: gv_old_fee_rec igs_he_poous.fee_band%TYPE;

358: gv_old_fte_rec_type igs_he_poous.fte_calc_type%TYPE;
359: gv_new_fte_rec_type igs_he_poous.fte_calc_type%TYPE;
360: gv_old_franchising_rec igs_he_poous.franchising_activity%TYPE;
361: gv_new_franchising_rec igs_he_poous.franchising_activity%TYPE;
362: gv_old_fee_rec igs_he_poous.fee_band%TYPE;
363: gv_new_fee_rec igs_he_poous.fee_band%TYPE;
364:
365: CURSOR gc_old_susa_rec IS
366: SELECT hesa_en_susa_id,

Line 363: gv_new_fee_rec igs_he_poous.fee_band%TYPE;

359: gv_new_fte_rec_type igs_he_poous.fte_calc_type%TYPE;
360: gv_old_franchising_rec igs_he_poous.franchising_activity%TYPE;
361: gv_new_franchising_rec igs_he_poous.franchising_activity%TYPE;
362: gv_old_fee_rec igs_he_poous.fee_band%TYPE;
363: gv_new_fee_rec igs_he_poous.fee_band%TYPE;
364:
365: CURSOR gc_old_susa_rec IS
366: SELECT hesa_en_susa_id,
367: person_id,

Line 474: FROM igs_he_poous a,

470: a.franchising_activity franchising_activity,
471: a.fee_band fee_band,
472: a.type_of_year,
473: a.fundability_cd
474: FROM igs_he_poous a,
475: igs_en_stdnt_ps_att b
476: WHERE a.course_cd = p_course_cd
477: AND a.crv_version_number = p_crv_version_number
478: AND a.unit_set_cd = p_old_unit_set_cd

Line 497: FROM igs_he_poous a,

493: a.franchising_activity franchising_activity,
494: a.fee_band fee_band,
495: a.type_of_year,
496: a.fundability_cd
497: FROM igs_he_poous a,
498: igs_en_stdnt_ps_att b
499: WHERE a.course_cd = p_course_cd
500: AND a.crv_version_number = p_crv_version_number
501: AND a.unit_set_cd = p_new_unit_set_cd

Line 633: v_old_franchising igs_he_poous.franchising_activity%TYPE;

629: FROM dual;
630:
631: x_rowid VARCHAR2(250);
632:
633: v_old_franchising igs_he_poous.franchising_activity%TYPE;
634: v_new_franchising igs_he_poous.franchising_activity%TYPE;
635: v_franchising igs_he_en_susa.franchising_activity%TYPE;
636:
637: v_old_fte igs_he_poous.fte_intensity%TYPE;

Line 634: v_new_franchising igs_he_poous.franchising_activity%TYPE;

630:
631: x_rowid VARCHAR2(250);
632:
633: v_old_franchising igs_he_poous.franchising_activity%TYPE;
634: v_new_franchising igs_he_poous.franchising_activity%TYPE;
635: v_franchising igs_he_en_susa.franchising_activity%TYPE;
636:
637: v_old_fte igs_he_poous.fte_intensity%TYPE;
638: v_new_fte igs_he_poous.fte_intensity%TYPE;

Line 637: v_old_fte igs_he_poous.fte_intensity%TYPE;

633: v_old_franchising igs_he_poous.franchising_activity%TYPE;
634: v_new_franchising igs_he_poous.franchising_activity%TYPE;
635: v_franchising igs_he_en_susa.franchising_activity%TYPE;
636:
637: v_old_fte igs_he_poous.fte_intensity%TYPE;
638: v_new_fte igs_he_poous.fte_intensity%TYPE;
639: v_fte igs_he_en_susa.fte_intensity%TYPE;
640:
641: v_old_fee_band igs_he_poous.fee_band%TYPE;

Line 638: v_new_fte igs_he_poous.fte_intensity%TYPE;

634: v_new_franchising igs_he_poous.franchising_activity%TYPE;
635: v_franchising igs_he_en_susa.franchising_activity%TYPE;
636:
637: v_old_fte igs_he_poous.fte_intensity%TYPE;
638: v_new_fte igs_he_poous.fte_intensity%TYPE;
639: v_fte igs_he_en_susa.fte_intensity%TYPE;
640:
641: v_old_fee_band igs_he_poous.fee_band%TYPE;
642: v_new_fee_band igs_he_poous.fee_band%TYPE;

Line 641: v_old_fee_band igs_he_poous.fee_band%TYPE;

637: v_old_fte igs_he_poous.fte_intensity%TYPE;
638: v_new_fte igs_he_poous.fte_intensity%TYPE;
639: v_fte igs_he_en_susa.fte_intensity%TYPE;
640:
641: v_old_fee_band igs_he_poous.fee_band%TYPE;
642: v_new_fee_band igs_he_poous.fee_band%TYPE;
643: v_fee_band igs_he_en_susa.fee_band%TYPE;
644:
645: v_old_fte_type igs_he_poous.fte_calc_type%TYPE;

Line 642: v_new_fee_band igs_he_poous.fee_band%TYPE;

638: v_new_fte igs_he_poous.fte_intensity%TYPE;
639: v_fte igs_he_en_susa.fte_intensity%TYPE;
640:
641: v_old_fee_band igs_he_poous.fee_band%TYPE;
642: v_new_fee_band igs_he_poous.fee_band%TYPE;
643: v_fee_band igs_he_en_susa.fee_band%TYPE;
644:
645: v_old_fte_type igs_he_poous.fte_calc_type%TYPE;
646: v_new_fte_type igs_he_poous.fte_calc_type%TYPE;

Line 645: v_old_fte_type igs_he_poous.fte_calc_type%TYPE;

641: v_old_fee_band igs_he_poous.fee_band%TYPE;
642: v_new_fee_band igs_he_poous.fee_band%TYPE;
643: v_fee_band igs_he_en_susa.fee_band%TYPE;
644:
645: v_old_fte_type igs_he_poous.fte_calc_type%TYPE;
646: v_new_fte_type igs_he_poous.fte_calc_type%TYPE;
647: v_fte_type igs_he_en_susa.fte_calc_type%TYPE;
648: -- smaddali added variables for bug#
649: l_fundability_code igs_he_en_susa.fundability_code%TYPE;

Line 646: v_new_fte_type igs_he_poous.fte_calc_type%TYPE;

642: v_new_fee_band igs_he_poous.fee_band%TYPE;
643: v_fee_band igs_he_en_susa.fee_band%TYPE;
644:
645: v_old_fte_type igs_he_poous.fte_calc_type%TYPE;
646: v_new_fte_type igs_he_poous.fte_calc_type%TYPE;
647: v_fte_type igs_he_en_susa.fte_calc_type%TYPE;
648: -- smaddali added variables for bug#
649: l_fundability_code igs_he_en_susa.fundability_code%TYPE;
650: l_type_of_year igs_he_en_susa.type_of_year%TYPE ;

Line 1109: igs_he_poous_all poous,

1105: -- cursor to check whether the given grade is exists against the grading schema defined in Unit set statistics.
1106: CURSOR cur_grd_sch_grade IS
1107: SELECT 'x'
1108: FROM igs_as_grd_sch_grade gsg,
1109: igs_he_poous_all poous,
1110: igs_en_stdnt_ps_att sca,
1111: igs_as_su_setatmpt susa
1112: WHERE gsg.grading_schema_cd = poous.grading_schema_cd AND
1113: gsg.version_number = poous.gs_version_number AND