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_AD_ACT_ASSESSMENTS_PKG dependencies on IGS_AD_TEST_SEGMENTS

Line 230: FROM IGS_AD_TEST_SEGMENTS

226: SELECT
227: ADMISSION_TEST_TYPE,
228: SEGMENT_TYPE,
229: TEST_SEGMENT_NAME
230: FROM IGS_AD_TEST_SEGMENTS
231: WHERE CLOSED_IND = 'N';
232:
233:
234: BEGIN

Line 398: -- Cursor to select the Test Segnemt Id from IGS_AD_TEST_SEGMENTS

394: actas.High_School_Code,
395: actas.High_School_Graduation;
396:
397:
398: -- Cursor to select the Test Segnemt Id from IGS_AD_TEST_SEGMENTS
399: CURSOR c_test_segment_id (cp_admission_test_type IGS_AD_TEST_SEGMENTS.ADMISSION_TEST_TYPE%type,
400: cp_test_segment_name IGS_AD_TEST_SEGMENTS.TEST_SEGMENT_NAME%type,
401: cp_segment_type IGS_AD_TEST_SEGMENTS.SEGMENT_TYPE%type) IS
402: SELECT

Line 399: CURSOR c_test_segment_id (cp_admission_test_type IGS_AD_TEST_SEGMENTS.ADMISSION_TEST_TYPE%type,

395: actas.High_School_Graduation;
396:
397:
398: -- Cursor to select the Test Segnemt Id from IGS_AD_TEST_SEGMENTS
399: CURSOR c_test_segment_id (cp_admission_test_type IGS_AD_TEST_SEGMENTS.ADMISSION_TEST_TYPE%type,
400: cp_test_segment_name IGS_AD_TEST_SEGMENTS.TEST_SEGMENT_NAME%type,
401: cp_segment_type IGS_AD_TEST_SEGMENTS.SEGMENT_TYPE%type) IS
402: SELECT
403: TEST_SEGMENT_ID

Line 400: cp_test_segment_name IGS_AD_TEST_SEGMENTS.TEST_SEGMENT_NAME%type,

396:
397:
398: -- Cursor to select the Test Segnemt Id from IGS_AD_TEST_SEGMENTS
399: CURSOR c_test_segment_id (cp_admission_test_type IGS_AD_TEST_SEGMENTS.ADMISSION_TEST_TYPE%type,
400: cp_test_segment_name IGS_AD_TEST_SEGMENTS.TEST_SEGMENT_NAME%type,
401: cp_segment_type IGS_AD_TEST_SEGMENTS.SEGMENT_TYPE%type) IS
402: SELECT
403: TEST_SEGMENT_ID
404: FROM IGS_AD_TEST_SEGMENTS

Line 401: cp_segment_type IGS_AD_TEST_SEGMENTS.SEGMENT_TYPE%type) IS

397:
398: -- Cursor to select the Test Segnemt Id from IGS_AD_TEST_SEGMENTS
399: CURSOR c_test_segment_id (cp_admission_test_type IGS_AD_TEST_SEGMENTS.ADMISSION_TEST_TYPE%type,
400: cp_test_segment_name IGS_AD_TEST_SEGMENTS.TEST_SEGMENT_NAME%type,
401: cp_segment_type IGS_AD_TEST_SEGMENTS.SEGMENT_TYPE%type) IS
402: SELECT
403: TEST_SEGMENT_ID
404: FROM IGS_AD_TEST_SEGMENTS
405: WHERE ADMISSION_TEST_TYPE = cp_admission_test_type

Line 404: FROM IGS_AD_TEST_SEGMENTS

400: cp_test_segment_name IGS_AD_TEST_SEGMENTS.TEST_SEGMENT_NAME%type,
401: cp_segment_type IGS_AD_TEST_SEGMENTS.SEGMENT_TYPE%type) IS
402: SELECT
403: TEST_SEGMENT_ID
404: FROM IGS_AD_TEST_SEGMENTS
405: WHERE ADMISSION_TEST_TYPE = cp_admission_test_type
406: AND UPPER(trim(TEST_SEGMENT_NAME)) = UPPER(trim(cp_test_segment_name))
407: AND SEGMENT_TYPE = cp_segment_type;
408:

Line 911: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE

907:
908: /* -- { Case 1 }
909: -- STATISTIC_TYPE = 'Test' and STATISTIC_CATEGORY = 'Combined English/Writing'
910: -- IF ACT_STATISTIC.SCORE <> '-'
911: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
912: -- and TEST_SEGMENT_NAME = 'Combined English/Writing' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID
913:
914: -- { Case 2 }
915: -- STATISTIC_TYPE = 'Test' and STATISTIC_CATEGORY = 'Composite'

Line 912: -- and TEST_SEGMENT_NAME = 'Combined English/Writing' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID

908: /* -- { Case 1 }
909: -- STATISTIC_TYPE = 'Test' and STATISTIC_CATEGORY = 'Combined English/Writing'
910: -- IF ACT_STATISTIC.SCORE <> '-'
911: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
912: -- and TEST_SEGMENT_NAME = 'Combined English/Writing' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID
913:
914: -- { Case 2 }
915: -- STATISTIC_TYPE = 'Test' and STATISTIC_CATEGORY = 'Composite'
916: -- IF ACT_STATISTIC. SCORE <> '-'

Line 917: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE

913:
914: -- { Case 2 }
915: -- STATISTIC_TYPE = 'Test' and STATISTIC_CATEGORY = 'Composite'
916: -- IF ACT_STATISTIC. SCORE <> '-'
917: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
918: -- and TEST_SEGMENT_NAME = 'Composite' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID
919:
920: -- { Case 3 }
921: -- STATISTIC_TYPE = 'Test' and STATISTIC_CATEGORY = 'English'

Line 918: -- and TEST_SEGMENT_NAME = 'Composite' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID

914: -- { Case 2 }
915: -- STATISTIC_TYPE = 'Test' and STATISTIC_CATEGORY = 'Composite'
916: -- IF ACT_STATISTIC. SCORE <> '-'
917: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
918: -- and TEST_SEGMENT_NAME = 'Composite' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID
919:
920: -- { Case 3 }
921: -- STATISTIC_TYPE = 'Test' and STATISTIC_CATEGORY = 'English'
922: -- IF ACT_STATISTIC.SCORE <> '-'

Line 923: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE

919:
920: -- { Case 3 }
921: -- STATISTIC_TYPE = 'Test' and STATISTIC_CATEGORY = 'English'
922: -- IF ACT_STATISTIC.SCORE <> '-'
923: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
924: -- and TEST_SEGMENT_NAME = 'English' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID
925:
926:
927: -- { Case 4 }

Line 924: -- and TEST_SEGMENT_NAME = 'English' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID

920: -- { Case 3 }
921: -- STATISTIC_TYPE = 'Test' and STATISTIC_CATEGORY = 'English'
922: -- IF ACT_STATISTIC.SCORE <> '-'
923: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
924: -- and TEST_SEGMENT_NAME = 'English' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID
925:
926:
927: -- { Case 4 }
928: -- STATISTIC_TYPE = 'Test' and STATISTIC_CATEGORY = 'Mathematics'

Line 930: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE

926:
927: -- { Case 4 }
928: -- STATISTIC_TYPE = 'Test' and STATISTIC_CATEGORY = 'Mathematics'
929: -- IF ACT_STATISTIC.SCORE <> '-'
930: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
931: -- and TEST_SEGMENT_NAME = 'Mathematics' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID
932:
933: -- { Case 5 }
934: -- STATISTIC_TYPE = 'Test' and STATISTIC_CATEGORY = 'Reading'

Line 931: -- and TEST_SEGMENT_NAME = 'Mathematics' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID

927: -- { Case 4 }
928: -- STATISTIC_TYPE = 'Test' and STATISTIC_CATEGORY = 'Mathematics'
929: -- IF ACT_STATISTIC.SCORE <> '-'
930: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
931: -- and TEST_SEGMENT_NAME = 'Mathematics' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID
932:
933: -- { Case 5 }
934: -- STATISTIC_TYPE = 'Test' and STATISTIC_CATEGORY = 'Reading'
935: -- IF ACT_STATISTIC.SCORE <> '-'

Line 936: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE

932:
933: -- { Case 5 }
934: -- STATISTIC_TYPE = 'Test' and STATISTIC_CATEGORY = 'Reading'
935: -- IF ACT_STATISTIC.SCORE <> '-'
936: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
937: -- and TEST_SEGMENT_NAME = 'Reading' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID
938:
939: -- { Case 6 }
940: -- STATISTIC_TYPE = 'Test' and STATISTIC_CATEGORY = 'Science'

Line 937: -- and TEST_SEGMENT_NAME = 'Reading' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID

933: -- { Case 5 }
934: -- STATISTIC_TYPE = 'Test' and STATISTIC_CATEGORY = 'Reading'
935: -- IF ACT_STATISTIC.SCORE <> '-'
936: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
937: -- and TEST_SEGMENT_NAME = 'Reading' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID
938:
939: -- { Case 6 }
940: -- STATISTIC_TYPE = 'Test' and STATISTIC_CATEGORY = 'Science'
941: -- IF ACT_STATISTIC.SCORE <> '-'

Line 942: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE

938:
939: -- { Case 6 }
940: -- STATISTIC_TYPE = 'Test' and STATISTIC_CATEGORY = 'Science'
941: -- IF ACT_STATISTIC.SCORE <> '-'
942: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
943: -- and TEST_SEGMENT_NAME = 'Science' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID */
944:
945: IF Act_Statistic_rec.statistic_type = 'TEST' AND Act_Statistic_rec.statistic_category IN ('COMENGWRI','COMPOSITE','ENGLISH',
946: 'MATHS','READING','SCIENCE') THEN

Line 943: -- and TEST_SEGMENT_NAME = 'Science' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID */

939: -- { Case 6 }
940: -- STATISTIC_TYPE = 'Test' and STATISTIC_CATEGORY = 'Science'
941: -- IF ACT_STATISTIC.SCORE <> '-'
942: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
943: -- and TEST_SEGMENT_NAME = 'Science' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID */
944:
945: IF Act_Statistic_rec.statistic_type = 'TEST' AND Act_Statistic_rec.statistic_category IN ('COMENGWRI','COMPOSITE','ENGLISH',
946: 'MATHS','READING','SCIENCE') THEN
947: FOR test_segment_rec IN c_test_segment_id(l_admission_test_type,get_lookup_meaning(Act_Statistic_rec.statistic_category),'SCORE')

Line 961: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE

957:
958: /* -- { Case 7 }
959: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Alg/Cord Geom'
960: -- IF ACT_STATISTIC.SCORE <> '-'
961: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
962: -- and TEST_SEGMENT_NAME = 'Alg/Cord Geom' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID
963:
964: -- { Case 8 }
965: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Arts/Lit.'

Line 962: -- and TEST_SEGMENT_NAME = 'Alg/Cord Geom' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID

958: /* -- { Case 7 }
959: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Alg/Cord Geom'
960: -- IF ACT_STATISTIC.SCORE <> '-'
961: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
962: -- and TEST_SEGMENT_NAME = 'Alg/Cord Geom' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID
963:
964: -- { Case 8 }
965: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Arts/Lit.'
966: -- IF ACT_STATISTIC.SCORE <> '-'

Line 967: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE

963:
964: -- { Case 8 }
965: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Arts/Lit.'
966: -- IF ACT_STATISTIC.SCORE <> '-'
967: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
968: -- and TEST_SEGMENT_NAME = 'Arts/Lit.' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID
969:
970: -- { Case 9 }
971: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Elem Algebra.'

Line 968: -- and TEST_SEGMENT_NAME = 'Arts/Lit.' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID

964: -- { Case 8 }
965: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Arts/Lit.'
966: -- IF ACT_STATISTIC.SCORE <> '-'
967: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
968: -- and TEST_SEGMENT_NAME = 'Arts/Lit.' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID
969:
970: -- { Case 9 }
971: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Elem Algebra.'
972: -- IF ACT_STATISTIC.SCORE <> '-'

Line 973: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE

969:
970: -- { Case 9 }
971: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Elem Algebra.'
972: -- IF ACT_STATISTIC.SCORE <> '-'
973: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
974: -- and TEST_SEGMENT_NAME = 'Elem Algebra.' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID
975:
976: -- { Case 10 }
977: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Plane Geom/Trig.'

Line 974: -- and TEST_SEGMENT_NAME = 'Elem Algebra.' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID

970: -- { Case 9 }
971: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Elem Algebra.'
972: -- IF ACT_STATISTIC.SCORE <> '-'
973: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
974: -- and TEST_SEGMENT_NAME = 'Elem Algebra.' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID
975:
976: -- { Case 10 }
977: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Plane Geom/Trig.'
978: -- IF ACT_STATISTIC.SCORE <> '-'

Line 979: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE

975:
976: -- { Case 10 }
977: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Plane Geom/Trig.'
978: -- IF ACT_STATISTIC.SCORE <> '-'
979: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
980: -- and TEST_SEGMENT_NAME = 'Plane Geom/Trig' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID
981:
982: -- { Case 11 }
983: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Rhetorical Skills.'

Line 980: -- and TEST_SEGMENT_NAME = 'Plane Geom/Trig' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID

976: -- { Case 10 }
977: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Plane Geom/Trig.'
978: -- IF ACT_STATISTIC.SCORE <> '-'
979: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
980: -- and TEST_SEGMENT_NAME = 'Plane Geom/Trig' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID
981:
982: -- { Case 11 }
983: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Rhetorical Skills.'
984: -- IF ACT_STATISTIC.SCORE <> '-'

Line 985: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE

981:
982: -- { Case 11 }
983: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Rhetorical Skills.'
984: -- IF ACT_STATISTIC.SCORE <> '-'
985: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
986: -- and TEST_SEGMENT_NAME = 'Rhetorical Skills' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID
987:
988: -- { Case 12 }
989: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Soc Stud/Sci.'

Line 986: -- and TEST_SEGMENT_NAME = 'Rhetorical Skills' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID

982: -- { Case 11 }
983: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Rhetorical Skills.'
984: -- IF ACT_STATISTIC.SCORE <> '-'
985: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
986: -- and TEST_SEGMENT_NAME = 'Rhetorical Skills' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID
987:
988: -- { Case 12 }
989: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Soc Stud/Sci.'
990: -- IF ACT_STATISTIC.SCORE <> '-'

Line 991: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE

987:
988: -- { Case 12 }
989: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Soc Stud/Sci.'
990: -- IF ACT_STATISTIC.SCORE <> '-'
991: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
992: -- and TEST_SEGMENT_NAME = 'Soc Stud/Sci' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID
993:
994: -- { Case 13 }
995: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Usage/Mech.'

Line 992: -- and TEST_SEGMENT_NAME = 'Soc Stud/Sci' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID

988: -- { Case 12 }
989: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Soc Stud/Sci.'
990: -- IF ACT_STATISTIC.SCORE <> '-'
991: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
992: -- and TEST_SEGMENT_NAME = 'Soc Stud/Sci' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID
993:
994: -- { Case 13 }
995: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Usage/Mech.'
996: -- IF ACT_STATISTIC.SCORE <> '-'

Line 997: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE

993:
994: -- { Case 13 }
995: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Usage/Mech.'
996: -- IF ACT_STATISTIC.SCORE <> '-'
997: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
998: -- and TEST_SEGMENT_NAME = 'Usage/Mech' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID */
999:
1000: ELSIF Act_Statistic_rec.statistic_type = 'TEST_SUB_SCORE' AND Act_Statistic_rec.statistic_category IN ('ALGCOGEOM',
1001: 'ARTSLIT','ELEMALG','PLGEOTRIG','RHESKILLS','SOCSTSCI' ,'USAGMECH') THEN

Line 998: -- and TEST_SEGMENT_NAME = 'Usage/Mech' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID */

994: -- { Case 13 }
995: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Usage/Mech.'
996: -- IF ACT_STATISTIC.SCORE <> '-'
997: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
998: -- and TEST_SEGMENT_NAME = 'Usage/Mech' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID */
999:
1000: ELSIF Act_Statistic_rec.statistic_type = 'TEST_SUB_SCORE' AND Act_Statistic_rec.statistic_category IN ('ALGCOGEOM',
1001: 'ARTSLIT','ELEMALG','PLGEOTRIG','RHESKILLS','SOCSTSCI' ,'USAGMECH') THEN
1002: FOR test_segment_rec IN c_test_segment_id(l_admission_test_type,get_lookup_meaning(Act_Statistic_rec.statistic_category),'SUB SCORE')

Line 1015: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE

1011:
1012: -- { Case 14 }
1013: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Writing.'
1014: -- IF ACT_STATISTIC.SCORE <> '-'
1015: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
1016: -- and TEST_SEGMENT_NAME = 'Writing' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID
1017:
1018: ELSIF Act_Statistic_rec.statistic_type = 'TEST_SUB_SCORE' AND Act_Statistic_rec.statistic_category = 'WRITING' THEN
1019: for test_segment_rec IN c_test_segment_id(l_admission_test_type,get_lookup_meaning('WRITING'),'SUB SCORE')

Line 1016: -- and TEST_SEGMENT_NAME = 'Writing' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID

1012: -- { Case 14 }
1013: -- STATISTIC_TYPE = 'TEST_SUB_SCORE' and STATISTIC_CATEGORY = 'Writing.'
1014: -- IF ACT_STATISTIC.SCORE <> '-'
1015: -- Select TEST_SEGMENT_ID From IGS_AD_TEST_SEGMENTS Where ADMISSION_TEST_TYPE = IGS_AD_TEST_INT. ADMISSION_TEST_TYPE
1016: -- and TEST_SEGMENT_NAME = 'Writing' Set to IGS_AD_TEST_SEGMENTS. TEST_SEGMENT_ID
1017:
1018: ELSIF Act_Statistic_rec.statistic_type = 'TEST_SUB_SCORE' AND Act_Statistic_rec.statistic_category = 'WRITING' THEN
1019: for test_segment_rec IN c_test_segment_id(l_admission_test_type,get_lookup_meaning('WRITING'),'SUB SCORE')
1020: LOOP