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_EN_SUSA

Line 13: -- and IGS_HE_EN_SUSA table

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
17: -- in IGS_HE_ST_SPA_ALL table as a part of bug 2636897

Line 19: -- in IGS_HE_EN_SUSA table as a part of bug 2636897 |

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
17: -- in IGS_HE_ST_SPA_ALL table as a part of bug 2636897
18: --Bayadav 22-OCT-2002 Included one new column type_of_year and corresponding validation |
19: -- in IGS_HE_EN_SUSA table as a part of bug 2636897 |
20: --knaraset 14-Nov-2002 Added the functions validate_program_aim,val_sub_qual_proportion,
21: -- val_highest_qual_entry,get_unit_set_cat,check_teach_inst,check_grading_sch_grade
22: -- as part of Build TD Legacy SPA Bug 2661533
23: --smaddali modified cursor cur_hqual_grade for bug 2730388

Line 354: -- gv_old_susa_rec IGS_HE_EN_SUSA%ROWTYPE;

350: -- smaddali 14-may-2002 added new parameter p_old_sequence_number and
351: --renamed p_sequence_number to p_new_sequence_number for bug#2350629
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;

Line 355: --gv_new_susa_rec IGS_HE_EN_SUSA%ROWTYPE;

351: --renamed p_sequence_number to p_new_sequence_number for bug#2350629
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;

Line 407: FROM igs_he_en_susa

403: last_update_date,
404: last_updated_by,
405: last_update_login ,
406: type_of_year
407: FROM igs_he_en_susa
408: WHERE person_id = p_person_id
409: AND course_cd = p_course_cd
410: AND unit_set_cd = p_old_unit_set_cd
411: AND us_version_number = p_old_us_version_number

Line 458: FROM igs_he_en_susa

454: last_update_date,
455: last_updated_by,
456: last_update_login ,
457: type_of_year
458: FROM igs_he_en_susa
459: WHERE person_id = p_person_id
460: AND course_cd = p_course_cd
461: AND unit_set_cd = p_new_unit_set_cd
462: AND us_version_number = p_new_us_version_number

Line 517: PROCEDURE cr_he_new_susa_rec(p_person_id igs_he_en_susa.person_id%TYPE,

513: gv_new_susa_rec gc_new_susa_rec%ROWTYPE;
514:
515: --Procedure to create a new record on first pre-enrolment
516: --smaddali modified p_sequence_number to p_new_sequence_number (bug#2350629)
517: PROCEDURE cr_he_new_susa_rec(p_person_id igs_he_en_susa.person_id%TYPE,
518: p_course_cd igs_he_en_susa.course_cd%TYPE,
519: p_new_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,
520: p_new_us_version_number igs_he_en_susa.us_version_number%TYPE,
521: p_new_sequence_number igs_he_en_susa.sequence_number%TYPE) IS

Line 518: p_course_cd igs_he_en_susa.course_cd%TYPE,

514:
515: --Procedure to create a new record on first pre-enrolment
516: --smaddali modified p_sequence_number to p_new_sequence_number (bug#2350629)
517: PROCEDURE cr_he_new_susa_rec(p_person_id igs_he_en_susa.person_id%TYPE,
518: p_course_cd igs_he_en_susa.course_cd%TYPE,
519: p_new_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,
520: p_new_us_version_number igs_he_en_susa.us_version_number%TYPE,
521: p_new_sequence_number igs_he_en_susa.sequence_number%TYPE) IS
522:

Line 519: p_new_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,

515: --Procedure to create a new record on first pre-enrolment
516: --smaddali modified p_sequence_number to p_new_sequence_number (bug#2350629)
517: PROCEDURE cr_he_new_susa_rec(p_person_id igs_he_en_susa.person_id%TYPE,
518: p_course_cd igs_he_en_susa.course_cd%TYPE,
519: p_new_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,
520: p_new_us_version_number igs_he_en_susa.us_version_number%TYPE,
521: p_new_sequence_number igs_he_en_susa.sequence_number%TYPE) IS
522:
523: BEGIN

Line 520: p_new_us_version_number igs_he_en_susa.us_version_number%TYPE,

516: --smaddali modified p_sequence_number to p_new_sequence_number (bug#2350629)
517: PROCEDURE cr_he_new_susa_rec(p_person_id igs_he_en_susa.person_id%TYPE,
518: p_course_cd igs_he_en_susa.course_cd%TYPE,
519: p_new_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,
520: p_new_us_version_number igs_he_en_susa.us_version_number%TYPE,
521: p_new_sequence_number igs_he_en_susa.sequence_number%TYPE) IS
522:
523: BEGIN
524:

Line 521: p_new_sequence_number igs_he_en_susa.sequence_number%TYPE) IS

517: PROCEDURE cr_he_new_susa_rec(p_person_id igs_he_en_susa.person_id%TYPE,
518: p_course_cd igs_he_en_susa.course_cd%TYPE,
519: p_new_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,
520: p_new_us_version_number igs_he_en_susa.us_version_number%TYPE,
521: p_new_sequence_number igs_he_en_susa.sequence_number%TYPE) IS
522:
523: BEGIN
524:
525: DECLARE

Line 527: v_susa_seq_num igs_he_en_susa.hesa_en_susa_id%TYPE;

523: BEGIN
524:
525: DECLARE
526:
527: v_susa_seq_num igs_he_en_susa.hesa_en_susa_id%TYPE;
528:
529: CURSOR c_susa_seq_num IS
530: SELECT igs_he_en_susa_s.NEXTVAL
531: FROM dual;

Line 530: SELECT igs_he_en_susa_s.NEXTVAL

526:
527: v_susa_seq_num igs_he_en_susa.hesa_en_susa_id%TYPE;
528:
529: CURSOR c_susa_seq_num IS
530: SELECT igs_he_en_susa_s.NEXTVAL
531: FROM dual;
532:
533: v_rowid VARCHAR2(250);
534:

Line 543: igs_he_en_susa_pkg.insert_row(

539: CLOSE c_susa_seq_num;
540:
541: v_rowid := NULL;
542:
543: igs_he_en_susa_pkg.insert_row(
544: x_rowid => v_rowid,
545: x_hesa_en_susa_id => v_susa_seq_num,
546: x_person_id => p_person_id,
547: x_course_cd => p_course_cd,

Line 613: PROCEDURE cr_he_add_susa_rec(p_person_id igs_he_en_susa.person_id%TYPE,

609:
610: END cr_he_new_susa_rec;
611:
612: --smaddali modified p_sequence_number to p_new_sequence_number (bug#2350629)
613: PROCEDURE cr_he_add_susa_rec(p_person_id igs_he_en_susa.person_id%TYPE,
614: p_course_cd igs_he_en_susa.course_cd%TYPE,
615: p_old_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,
616: p_old_us_version_number igs_he_en_susa.us_version_number%TYPE,
617: p_new_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,

Line 614: p_course_cd igs_he_en_susa.course_cd%TYPE,

610: END cr_he_new_susa_rec;
611:
612: --smaddali modified p_sequence_number to p_new_sequence_number (bug#2350629)
613: PROCEDURE cr_he_add_susa_rec(p_person_id igs_he_en_susa.person_id%TYPE,
614: p_course_cd igs_he_en_susa.course_cd%TYPE,
615: p_old_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,
616: p_old_us_version_number igs_he_en_susa.us_version_number%TYPE,
617: p_new_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,
618: p_new_us_version_number igs_he_en_susa.us_version_number%TYPE,

Line 615: p_old_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,

611:
612: --smaddali modified p_sequence_number to p_new_sequence_number (bug#2350629)
613: PROCEDURE cr_he_add_susa_rec(p_person_id igs_he_en_susa.person_id%TYPE,
614: p_course_cd igs_he_en_susa.course_cd%TYPE,
615: p_old_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,
616: p_old_us_version_number igs_he_en_susa.us_version_number%TYPE,
617: p_new_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,
618: p_new_us_version_number igs_he_en_susa.us_version_number%TYPE,
619: p_new_sequence_number igs_he_en_susa.sequence_number%TYPE) IS

Line 616: p_old_us_version_number igs_he_en_susa.us_version_number%TYPE,

612: --smaddali modified p_sequence_number to p_new_sequence_number (bug#2350629)
613: PROCEDURE cr_he_add_susa_rec(p_person_id igs_he_en_susa.person_id%TYPE,
614: p_course_cd igs_he_en_susa.course_cd%TYPE,
615: p_old_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,
616: p_old_us_version_number igs_he_en_susa.us_version_number%TYPE,
617: p_new_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,
618: p_new_us_version_number igs_he_en_susa.us_version_number%TYPE,
619: p_new_sequence_number igs_he_en_susa.sequence_number%TYPE) IS
620:

Line 617: p_new_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,

613: PROCEDURE cr_he_add_susa_rec(p_person_id igs_he_en_susa.person_id%TYPE,
614: p_course_cd igs_he_en_susa.course_cd%TYPE,
615: p_old_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,
616: p_old_us_version_number igs_he_en_susa.us_version_number%TYPE,
617: p_new_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,
618: p_new_us_version_number igs_he_en_susa.us_version_number%TYPE,
619: p_new_sequence_number igs_he_en_susa.sequence_number%TYPE) IS
620:
621: BEGIN

Line 618: p_new_us_version_number igs_he_en_susa.us_version_number%TYPE,

614: p_course_cd igs_he_en_susa.course_cd%TYPE,
615: p_old_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,
616: p_old_us_version_number igs_he_en_susa.us_version_number%TYPE,
617: p_new_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,
618: p_new_us_version_number igs_he_en_susa.us_version_number%TYPE,
619: p_new_sequence_number igs_he_en_susa.sequence_number%TYPE) IS
620:
621: BEGIN
622:

Line 619: p_new_sequence_number igs_he_en_susa.sequence_number%TYPE) IS

615: p_old_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,
616: p_old_us_version_number igs_he_en_susa.us_version_number%TYPE,
617: p_new_unit_set_cd igs_he_en_susa.unit_set_cd%TYPE,
618: p_new_us_version_number igs_he_en_susa.us_version_number%TYPE,
619: p_new_sequence_number igs_he_en_susa.sequence_number%TYPE) IS
620:
621: BEGIN
622:
623: DECLARE

Line 625: v_susa_seq_num igs_he_en_susa.hesa_en_susa_id%TYPE;

621: BEGIN
622:
623: DECLARE
624:
625: v_susa_seq_num igs_he_en_susa.hesa_en_susa_id%TYPE;
626:
627: CURSOR c_susa_seq_num IS
628: SELECT igs_he_en_susa_s.NEXTVAL
629: FROM dual;

Line 628: SELECT igs_he_en_susa_s.NEXTVAL

624:
625: v_susa_seq_num igs_he_en_susa.hesa_en_susa_id%TYPE;
626:
627: CURSOR c_susa_seq_num IS
628: SELECT igs_he_en_susa_s.NEXTVAL
629: FROM dual;
630:
631: x_rowid VARCHAR2(250);
632:

Line 635: v_franchising igs_he_en_susa.franchising_activity%TYPE;

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;
639: v_fte igs_he_en_susa.fte_intensity%TYPE;

Line 639: v_fte igs_he_en_susa.fte_intensity%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;
643: v_fee_band igs_he_en_susa.fee_band%TYPE;

Line 643: v_fee_band igs_he_en_susa.fee_band%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;
647: v_fte_type igs_he_en_susa.fte_calc_type%TYPE;

Line 647: v_fte_type igs_he_en_susa.fte_calc_type%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 ;
651: BEGIN

Line 649: l_fundability_code igs_he_en_susa.fundability_code%TYPE;

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 ;
651: BEGIN
652:
653: OPEN c_susa_seq_num;

Line 650: l_type_of_year igs_he_en_susa.type_of_year%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 ;
651: BEGIN
652:
653: OPEN c_susa_seq_num;
654: FETCH c_susa_seq_num INTO v_susa_seq_num;

Line 713: igs_he_en_susa_pkg.insert_row(

709: x_rowid := NULL;
710: -- smaddali removed copying of x_credit_level_achieved1,x_credit_level_achieved2,
711: -- x_credit_pt_achieved1 and x_credit_pt_achieved2,fundability_code,calculated_fte
712: -- copying fundability_code and type_of_year conditionally for bug#3291399
713: igs_he_en_susa_pkg.insert_row(
714: x_rowid => x_rowid,
715: x_hesa_en_susa_id => v_susa_seq_num,
716: x_person_id => p_person_id,
717: x_course_cd => p_course_cd,