[Home] [Help]
452: l_Batch_Id igs_ad_imp_batch_det.batch_id%type;
453: l_Batch_Desc igs_ad_imp_batch_det.batch_desc%type;
454: l_interface_id igs_ad_interface_all.interface_id%type;
455: l_interface_addr_id igs_ad_addr_int_all.interface_addr_id%type;
456: l_interface_test_id igs_ad_test_int.interface_test_id%type;
457: l_admission_test_type igs_ad_test_int.admission_test_type%type;
458: l_interface_acadhis_id igs_ad_acadhis_int_all.interface_acadhis_id%type;
459: l_Interface_Transcript_Id igs_ad_txcpt_int.interface_transcript_id%type;
460: l_interface_term_dtls_id igs_ad_trmdt_int.interface_term_dtls_id%type;
453: l_Batch_Desc igs_ad_imp_batch_det.batch_desc%type;
454: l_interface_id igs_ad_interface_all.interface_id%type;
455: l_interface_addr_id igs_ad_addr_int_all.interface_addr_id%type;
456: l_interface_test_id igs_ad_test_int.interface_test_id%type;
457: l_admission_test_type igs_ad_test_int.admission_test_type%type;
458: l_interface_acadhis_id igs_ad_acadhis_int_all.interface_acadhis_id%type;
459: l_Interface_Transcript_Id igs_ad_txcpt_int.interface_transcript_id%type;
460: l_interface_term_dtls_id igs_ad_trmdt_int.interface_term_dtls_id%type;
461:
541: --> IGS_AD_ADDR_INT_ALL
542: ------> IGS_AD_ADDRUSAGE_INT_ALL -- akadam Bug# 4352471
543: --> IGS_AD_CONTACTS_INT_ALL
544: --> IGS_AD_API_INT_ALL
545: --> IGS_AD_TEST_INT
546: ------> IGS_AD_TEST_SEGS_INT
547: --> IGS_AD_ACADHIS_INT_ALL
548: ------> IGS_AD_TXCPT_INT_ALL
549: ------------> IGS_AD_TRMDT_INT
841: -- For each Test Type :
842: --debug
843: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Interface Id 3: ' || l_interface_id);
844: INSERT
845: INTO IGS_AD_TEST_INT
846: (
847: INTERFACE_TEST_ID ,
848: INTERFACE_ID ,
849: ADMISSION_TEST_TYPE ,
861: ACTIVE_IND
862: )
863: VALUES
864: (
865: IGS_AD_TEST_INT_S.NEXTVAL,
866: l_interface_id,
867: Decode (Act_Assessment_rec.test_type,'D','ACT-DANTES','F','ACT-INTERNATIONAL','I',
868: 'ACT-INSTITUTION','R','ACT-RESIDUAL','S','ACT-STATE','Z','ACT-ARRANGED','N','ACT-NATIONAL'),
869: to_date( Act_Assessment_rec.test_date_txt||'01','YYYYMMDD'),
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'
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'
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 }
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'
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'
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
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.'
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.'
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.'
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.'
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.'
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.'
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
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')