APPS.IGS_AD_ACT_ASSESSMENTS_PKG dependencies on IGS_AD_TUNDT_INT

Line 550: ------------------> IGS_AD_TUNDT_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
554: l_interface_addr_id := NULL;

Line 1123: --------------------> IGS_AD_TUNDT_INT

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:
1127: --debug

Line 1216: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside FOR of History Details: IGS_AD_TUNDT_INT record Interface Id 5: ' || l_interface_id);

1212: FETCH c_Statistic_Category_desc INTO l_Statistic_Category_desc;
1213: CLOSE c_Statistic_Category_desc;
1214:
1215: --debug
1216: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Inside FOR of History Details: IGS_AD_TUNDT_INT record Interface Id 5: ' || l_interface_id);
1217:
1218:
1219: IF Act_Statistic_HS_Rec.statistic_category IN ('ENGLISH','MATHS','NATSCI','SOCSCI') THEN
1220: -- If Numeric Grade is 'NN' not NULL not '--'

Line 1224: INTO IGS_AD_TUNDT_INT

1220: -- If Numeric Grade is 'NN' not NULL not '--'
1221: IF ((Act_Statistic_HS_Rec.Numeric_Grade IS NOT NULL) AND (INSTR(Act_Statistic_HS_Rec.Numeric_Grade,'-')=0)) THEN
1222: l_grade := SUBSTR(Act_Statistic_HS_Rec.Numeric_Grade,1,1)||'.'||SUBSTR(Act_Statistic_HS_Rec.Numeric_Grade,2);
1223: INSERT
1224: INTO IGS_AD_TUNDT_INT
1225: (
1226: INTERFACE_TERM_UNITDTLS_ID ,
1227: INTERFACE_TERM_DTLS_ID ,
1228: UNIT ,

Line 1241: IGS_AD_TUNDT_INT_S.NEXTVAL,

1237: LAST_UPDATE_LOGIN
1238: )
1239: VALUES
1240: (
1241: IGS_AD_TUNDT_INT_S.NEXTVAL,
1242: l_interface_term_dtls_id,
1243: Act_Statistic_HS_Rec.statistic_category ,
1244: G_Unit_Difficulty,
1245: l_Statistic_Category_desc,

Line 1263: INTO IGS_AD_TUNDT_INT

1259: l_grade :='T';
1260: END IF;
1261:
1262: INSERT
1263: INTO IGS_AD_TUNDT_INT
1264: (
1265: INTERFACE_TERM_UNITDTLS_ID ,
1266: INTERFACE_TERM_DTLS_ID ,
1267: UNIT ,

Line 1280: IGS_AD_TUNDT_INT_S.NEXTVAL,

1276: LAST_UPDATE_LOGIN
1277: )
1278: VALUES
1279: (
1280: IGS_AD_TUNDT_INT_S.NEXTVAL,
1281: l_interface_term_dtls_id,
1282: Act_Statistic_HS_Rec.statistic_category ,
1283: G_Unit_Difficulty,
1284: l_Statistic_Category_desc,