APPS.IGS_AD_ACT_ASSESSMENTS_PKG dependencies on IGS_AD_TXCPT_INT

Line 459: l_Interface_Transcript_Id igs_ad_txcpt_int.interface_transcript_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;
463: l_rec_count NUMBER;

Line 548: ------> IGS_AD_TXCPT_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: ---------------------------------------------------------------------------------------------------------*/
552:

Line 1121: --------> IGS_AD_TXCPT_INT_ALL

1117: l_Interface_Id_exist := l_interface_id;
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

Line 1125: -- Enter Test Details into IGS_AD_TXCPT_INT from ACT Statistics

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:
1127: --debug
1128: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside IF of Acad History Details: IGS_AD_TXCPT_INT record Interface Id 5: ' || l_interface_id);
1129:

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

1124:
1125: -- Enter Test Details into IGS_AD_TXCPT_INT from ACT Statistics
1126:
1127: --debug
1128: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside IF of Acad History Details: IGS_AD_TXCPT_INT record Interface Id 5: ' || l_interface_id);
1129:
1130: INSERT
1131: INTO IGS_AD_TXCPT_INT
1132: (

Line 1131: INTO IGS_AD_TXCPT_INT

1127: --debug
1128: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside IF of Acad History Details: IGS_AD_TXCPT_INT record Interface Id 5: ' || l_interface_id);
1129:
1130: INSERT
1131: INTO IGS_AD_TXCPT_INT
1132: (
1133: INTERFACE_TRANSCRIPT_ID ,
1134: TRANSCRIPT_STATUS ,
1135: TRANSCRIPT_TYPE ,

Line 1151: IGS_AD_TXCPT_INT_S.NEXTVAL,

1147: DATE_OF_ISSUE
1148: )
1149: VALUES
1150: (
1151: IGS_AD_TXCPT_INT_S.NEXTVAL,
1152: 'FINAL', -- Lookup code for lookup_type = TRANSCRIPT_STATUS
1153: 'OFFICIAL', -- Lookup code for lookup_type = TRANSCRIPT_TYPE
1154: G_Transcript_Source, --User Defined 'ACT' Transcript Info Code Class 'Transcript Source'
1155: l_interface_acadhis_id,