APPS.IGS_AD_ACT_ASSESSMENTS_PKG dependencies on IGS_AD_ACADHIS_INT_ALL

Line 458: l_interface_acadhis_id igs_ad_acadhis_int_all.interface_acadhis_id%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:
462: l_ACT_Exist igs_Ad_Act_Assessments.act_identifier%type;

Line 547: --> IGS_AD_ACADHIS_INT_ALL

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
550: ------------------> IGS_AD_TUNDT_INT
551: ---------------------------------------------------------------------------------------------------------*/

Line 1070: -- Enter Acad History Details into IGS_AD_ACADHIS_INT_ALL from ACT Statistics

1066: );
1067:
1068: END LOOP; --- End Inserting multiple records of Test Details for a Person
1069:
1070: -- Enter Acad History Details into IGS_AD_ACADHIS_INT_ALL from ACT Statistics
1071: IF Act_Assessment_Rec.high_school_code IS NULL THEN
1072: FND_FILE.PUT_LINE(Fnd_File.LOG,'Academic History for the follwing Records will not be imported as High School Graduation Institution Code is not defined.');
1073: FND_FILE.PUT_LINE(Fnd_File.LOG,'ACT_ID : '|| Act_Assessment_Rec.ACT_Identifier ||' REPORTING_YEAR :'|| Act_Assessment_Rec.Reporting_Year||' TEST_DATE : '||Act_Assessment_Rec.Test_Date_Txt||' TEST_TYPE : '||Act_Assessment_Rec.Test_Type);
1074: ELSE

Line 1083: INTO IGS_AD_ACADHIS_INT_ALL

1079: --debug
1080: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside IF of Acad History Details record Interface Id 5: ' || l_interface_id);
1081:
1082: INSERT
1083: INTO IGS_AD_ACADHIS_INT_ALL
1084: (
1085: INTERFACE_ACADHIS_ID ,
1086: INTERFACE_ID ,
1087: INSTITUTION_CODE ,