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_VERIFY_RETURN_PKG dependencies on IGS_HE_VERIFY_DATA_T

Line 146: INSERT INTO IGS_HE_VERIFY_DATA_T (association_code, fields_affected, display_title, oss_value, creation_date, created_by, last_update_date, last_updated_by)

142:
143: -- Insert each unmapped value into temp table
144: LOOP
145:
146: INSERT INTO IGS_HE_VERIFY_DATA_T (association_code, fields_affected, display_title, oss_value, creation_date, created_by, last_update_date, last_updated_by)
147: VALUES (l_assoc.association_code, l_affected_fields, l_assoc_type.display_title, l_unmapped_value, sysdate, -1, sysdate, -1);
148:
149: --Increment Counter
150: l_count := l_count + 1;

Line 407: l_verify_data igs_he_verify_data_t%ROWTYPE := NULL;

403: l_awd_conf_end_dt igs_he_submsn_awd.award_end_date%TYPE;
404: l_prev_person_id NUMBER := -1;
405: l_prev_student_inst_number VARCHAR2(100) := '-1';
406: l_valid BOOLEAN;
407: l_verify_data igs_he_verify_data_t%ROWTYPE := NULL;
408: l_count NUMBER;
409:
410:
411:

Line 608: INSERT INTO IGS_HE_VERIFY_DATA_T(person_id, creation_date, created_by, last_update_date, last_updated_by)

604: -- If this is a module return this is as far as we need to go for the students.
605: -- We assume all these students *could* be in the return so we insert them into temp table
606: IF SUBSTR(g_he_submsn_return.record_id,4,2) = '13' THEN
607:
608: INSERT INTO IGS_HE_VERIFY_DATA_T(person_id, creation_date, created_by, last_update_date, last_updated_by)
609: VALUES (l_std_inst.person_id, sysdate, 1, sysdate, 1);
610:
611: ELSE
612:

Line 642: INSERT INTO IGS_HE_VERIFY_DATA_T

638: FETCH c_get_prog INTO l_verify_data.prog_flag;
639: CLOSE c_get_prog;
640:
641: -- Insert complete record into temp table
642: INSERT INTO IGS_HE_VERIFY_DATA_T
643: (person_id,
644: course_cd,
645: crv_version_number,
646: cal_type,

Line 707: INSERT INTO IGS_HE_VERIFY_DATA_T

703: -- Insert all units started or completed within the enrolment period
704: -- by the students identified above. This is *similar* to the query used in
705: -- IGSHE9CB, however the student_inst_number is NOT used so query may select
706: -- more units than will appear in the return.
707: INSERT INTO IGS_HE_VERIFY_DATA_T
708: (unit_cd, u_version_number, unit_flag, creation_date, created_by, last_update_date, last_updated_by)
709: (SELECT DISTINCT
710: ua.unit_cd,
711: ua.version_number,

Line 714: igs_he_verify_data_t t,

710: ua.unit_cd,
711: ua.version_number,
712: DECODE(hunt.hesa_st_unt_vs_id, NULL, 'N', 'Y') unit_flag, sysdate, 1, sysdate, 1
713: FROM igs_en_su_attempt_all ua,
714: igs_he_verify_data_t t,
715: igs_he_st_unt_vs_all hunt
716: WHERE t.person_id = ua.person_id
717: AND ua.unit_cd = hunt.unit_cd (+)
718: AND ua.version_number = hunt.version_number(+)

Line 728: igs_he_verify_data_t t,

724: ua.unit_cd,
725: ua.version_number,
726: DECODE(hunt.hesa_st_unt_vs_id, NULL, 'N', 'Y') unit_flag, sysdate, 1, sysdate, 1
727: FROM igs_en_su_attempt_all ua,
728: igs_he_verify_data_t t,
729: igs_he_st_unt_vs_all hunt,
730: igs_as_su_stmptout_all uao
731: WHERE t.person_id = ua.person_id
732: AND ua.unit_cd = hunt.unit_cd (+)

Line 744: DELETE FROM IGS_HE_VERIFY_DATA_T

740: AND hunt.hesa_st_unt_vs_id IS NULL -- only get modules with no HESA details
741: );
742:
743: -- Delete the temporarily stored student records
744: DELETE FROM IGS_HE_VERIFY_DATA_T
745: WHERE person_id IS NOT NULL;
746:
747: END IF; -- Module Return
748:

Line 756: FROM igs_he_verify_data_t

752:
753: -- Get count of missing Unit HESA Records
754: SELECT COUNT(DISTINCT unit_cd || u_version_number)
755: INTO l_count
756: FROM igs_he_verify_data_t
757: WHERE unit_flag = 'N';
758:
759: -- Log Summary of Module Results
760: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_UNIT');

Line 770: FROM igs_he_verify_data_t

766:
767: -- Get count of missing Program HESA Records
768: SELECT COUNT(DISTINCT course_cd || crv_version_number)
769: INTO l_count
770: FROM igs_he_verify_data_t
771: WHERE prog_flag = 'N';
772:
773: -- Log Summary of Program Results
774: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_PROG');

Line 781: FROM igs_he_verify_data_t

777:
778: -- Get count of missing POOUS HESA Records
779: SELECT COUNT(DISTINCT course_cd || crv_version_number || cal_type || location_cd || attendance_mode || attendance_type || unit_set_cd || us_version_number)
780: INTO l_count
781: FROM igs_he_verify_data_t
782: WHERE poous_flag = 'N';
783:
784: -- Log Summary of POOUS Results
785: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_POOUS');

Line 792: FROM igs_he_verify_data_t

788:
789: -- Get count of missing or incomplete SPA HESA Records
790: SELECT COUNT(DISTINCT person_id || course_cd)
791: INTO l_count
792: FROM igs_he_verify_data_t
793: WHERE spa_flag = 'N' OR qualaim_flag = 'N' OR sin_flag = 'N';
794:
795: -- Log Summary of POOUS Results
796: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_SPA');

Line 803: FROM igs_he_verify_data_t

799:
800: -- Get count of missing or incomplete SPA HESA Records
801: SELECT COUNT(DISTINCT person_id || course_cd || unit_set_cd || us_version_number)
802: INTO l_count
803: FROM igs_he_verify_data_t
804: WHERE susa_flag = 'N';
805:
806: -- Log Summary of POOUS Results
807: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_SUSA');

Line 925: DELETE FROM IGS_HE_VERIFY_DATA_T;

921: fnd_file.put_line(fnd_file.log,fnd_message.get());
922:
923:
924: -- Delete Temp Table
925: DELETE FROM IGS_HE_VERIFY_DATA_T;
926:
927: -- Check HESA details of COMBINED/STUDENT or MODULE return
928: IF p_check_HESA_details = 'Y'
929: AND SUBSTR(g_he_submsn_return.record_id,4,2) <> '18' THEN