APPS.IGS_AD_ACT_ASSESSMENTS_PKG dependencies on IGS_AD_TRMDT_INT

Line 460: l_interface_term_dtls_id igs_ad_trmdt_int.interface_term_dtls_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;
463: l_rec_count NUMBER;
464: l_rec_fail_count NUMBER;

Line 549: ------------> IGS_AD_TRMDT_INT

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: ---------------------------------------------------------------------------------------------------------*/
552:
553: -- flag to check if Latest Person Details is already inserted into Interface table or Not

Line 1122: --------------> IGS_AD_TRMDT_INT

1118: -- Insert data into detail tables
1119: -- in following Hierarchy
1120: -- Setup the Transcript Source User Defined Transcript Source of System Type 'ACT'
1121: --------> IGS_AD_TXCPT_INT_ALL
1122: --------------> IGS_AD_TRMDT_INT
1123: --------------------> IGS_AD_TUNDT_INT
1124:
1125: -- Enter Test Details into IGS_AD_TXCPT_INT from ACT Statistics
1126:

Line 1169: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside IF of Acad History Details: IGS_AD_TRMDT_INT record Interface Id 5: ' || l_interface_id);

1165: to_date( Act_Assessment_rec.TEST_DATE_TXT||'01','YYYYMMDD')
1166: ) returning INTERFACE_TRANSCRIPT_ID into l_Interface_Transcript_Id ;
1167:
1168: --debug
1169: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside IF of Acad History Details: IGS_AD_TRMDT_INT record Interface Id 5: ' || l_interface_id);
1170:
1171: INSERT
1172: INTO IGS_AD_TRMDT_INT
1173: (

Line 1172: INTO IGS_AD_TRMDT_INT

1168: --debug
1169: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside IF of Acad History Details: IGS_AD_TRMDT_INT record Interface Id 5: ' || l_interface_id);
1170:
1171: INSERT
1172: INTO IGS_AD_TRMDT_INT
1173: (
1174: INTERFACE_TERM_DTLS_ID ,
1175: INTERFACE_TRANSCRIPT_ID ,
1176: START_DATE ,

Line 1188: igs_ad_trmdt_int_s.NEXTVAL,

1184: LAST_UPDATE_LOGIN
1185: )
1186: VALUES
1187: (
1188: igs_ad_trmdt_int_s.NEXTVAL,
1189: l_Interface_Transcript_Id,
1190: to_date( Act_Assessment_rec.TEST_DATE_TXT||'01','YYYYMMDD'),
1191: to_date( Act_Assessment_rec.TEST_DATE_TXT||'02','YYYYMMDD'),
1192: 'ACT - '||to_char(to_date( Act_Assessment_rec.TEST_DATE_TXT||'01','YYYYMMDD'),'Mon DD, YYYY'), -- 'ACT Test Date - '||to_char(to_date( Act_Assessment_rec.TEST_DATE_TXT||'01','YYYYMMDD'),'Month DD, YYYY'),