eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_IMP_024 dependencies on IGS_AD_TUNDT_INT

Line 677: UPDATE igs_ad_tundt_int a

673:
674: process_term_details (p_interface_run_id, p_rule,p_enable_log);
675:
676: --Term and units are not defined as independent categoies
677: UPDATE igs_ad_tundt_int a
678: SET interface_run_id = p_interface_run_id,
679: (person_id,education_id , transcript_id, term_details_id )
680: = (SELECT person_id,education_id ,
681: transcript_id, term_details_id

Line 692: tabname => 'IGS_AD_TUNDT_INT',

688: AND status IN ('1','4'));
689:
690: -- Gather statistics of the table
691: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
692: tabname => 'IGS_AD_TUNDT_INT',
693: cascade => TRUE);
694:
695: process_term_unit_details (p_interface_run_id, p_rule,p_enable_log);
696: END prc_trscrpt;

Line 994: AND EXISTS ( SELECT 1 FROM igs_ad_tundt_int

990: , error_code = 'E708'
991: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E708', 8405)
992: WHERE interface_run_id = p_interface_run_id
993: AND status = '2'
994: AND EXISTS ( SELECT 1 FROM igs_ad_tundt_int
995: WHERE interface_term_dtls_id = term.interface_term_dtls_id
996: AND status ='2')
997: AND 1 < ( SELECT COUNT(*) FROM IGS_AD_TERM_DETAILS term_oss
998: WHERE transcript_id = term.transcript_id

Line 1150: CURSOR term_unit_cur(cp_start_int_id IGS_AD_TUNDT_INT.INTERFACE_TERM_UNITDTLS_ID%TYPE, --ARVSRINI--

1146: p_interface_run_id igs_ad_interface_all.interface_run_id%TYPE,
1147: p_rule VARCHAR2,
1148: p_enable_log VARCHAR2) AS
1149:
1150: CURSOR term_unit_cur(cp_start_int_id IGS_AD_TUNDT_INT.INTERFACE_TERM_UNITDTLS_ID%TYPE, --ARVSRINI--
1151: cp_end_int_id IGS_AD_TUNDT_INT.INTERFACE_TERM_UNITDTLS_ID%TYPE) IS --ARVSRINI-- IS
1152: SELECT cst_insert dmlmode, unit.rowid, unit.*
1153: FROM igs_ad_tundt_int unit
1154: WHERE interface_run_id = p_interface_run_id

Line 1151: cp_end_int_id IGS_AD_TUNDT_INT.INTERFACE_TERM_UNITDTLS_ID%TYPE) IS --ARVSRINI-- IS

1147: p_rule VARCHAR2,
1148: p_enable_log VARCHAR2) AS
1149:
1150: CURSOR term_unit_cur(cp_start_int_id IGS_AD_TUNDT_INT.INTERFACE_TERM_UNITDTLS_ID%TYPE, --ARVSRINI--
1151: cp_end_int_id IGS_AD_TUNDT_INT.INTERFACE_TERM_UNITDTLS_ID%TYPE) IS --ARVSRINI-- IS
1152: SELECT cst_insert dmlmode, unit.rowid, unit.*
1153: FROM igs_ad_tundt_int unit
1154: WHERE interface_run_id = p_interface_run_id
1155: AND unit.status = '2'

Line 1153: FROM igs_ad_tundt_int unit

1149:
1150: CURSOR term_unit_cur(cp_start_int_id IGS_AD_TUNDT_INT.INTERFACE_TERM_UNITDTLS_ID%TYPE, --ARVSRINI--
1151: cp_end_int_id IGS_AD_TUNDT_INT.INTERFACE_TERM_UNITDTLS_ID%TYPE) IS --ARVSRINI-- IS
1152: SELECT cst_insert dmlmode, unit.rowid, unit.*
1153: FROM igs_ad_tundt_int unit
1154: WHERE interface_run_id = p_interface_run_id
1155: AND unit.status = '2'
1156: AND INTERFACE_TERM_UNITDTLS_ID BETWEEN cp_start_int_id AND cp_end_int_id --ARVSRINI--
1157: AND (NOT EXISTS (SELECT 1 FROM igs_ad_term_unitdtls unit_oss

Line 1164: FROM igs_ad_tundt_int unit

1160: OR ( p_rule = 'R' AND unit.match_ind IN ('16', '25') )
1161: )
1162: UNION ALL
1163: SELECT cst_update dmlmode, unit.rowid, unit.*
1164: FROM igs_ad_tundt_int unit
1165: WHERE interface_run_id = p_interface_run_id
1166: AND status = '2'
1167: AND INTERFACE_TERM_UNITDTLS_ID BETWEEN cp_start_int_id AND cp_end_int_id --ARVSRINI--
1168: AND ( p_rule = 'I' OR (p_rule = 'R' AND unit.match_ind = cst_mi_val_21))

Line 1207: l_unit_details_id igs_ad_tundt_int.unit_details_id%TYPE;

1203: -- (reverse chronological order - newest change first)
1204: --------------------------------------------------------------------------
1205: l_rowid VARCHAR2(25);
1206: l_var VARCHAR2(25);
1207: l_unit_details_id igs_ad_tundt_int.unit_details_id%TYPE;
1208: l_msg_at_index NUMBER := 0;
1209: l_return_status VARCHAR2(1);
1210: l_msg_count NUMBER ;
1211: l_msg_data VARCHAR2(2000);

Line 1232: UPDATE igs_ad_tundt_int

1228: p_term_unitdtls_record.UNIT_GRADE_POINTS
1229: );
1230:
1231:
1232: UPDATE igs_ad_tundt_int
1233: SET status = cst_s_val_1,
1234: error_code = NULL,
1235: unit_details_id = l_unit_details_id
1236: WHERE interface_term_unitdtls_id = p_term_unitdtls_record.interface_term_unitdtls_id;

Line 1255: igs_ad_imp_001.logerrormessage(p_term_unitdtls_record.interface_term_dtls_id,l_msg_data,'IGS_AD_TUNDT_INT');

1251: l_error_text := l_msg_data;
1252: l_error_code := 'E322';
1253:
1254: IF p_enable_log = 'Y' THEN
1255: igs_ad_imp_001.logerrormessage(p_term_unitdtls_record.interface_term_dtls_id,l_msg_data,'IGS_AD_TUNDT_INT');
1256: END IF;
1257: ELSE
1258: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);
1259: l_error_code := 'E518';

Line 1277: UPDATE igs_ad_tundt_int

1273: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1274: END IF;
1275:
1276: END IF;
1277: UPDATE igs_ad_tundt_int
1278: SET status = cst_s_val_3,
1279: error_code = l_error_code,
1280: error_text = l_error_text,
1281: match_ind = DECODE (

Line 1324: UPDATE igs_ad_tundt_int

1320: X_GRADE => NVL(p_term_unitdtls_record.GRADE,dup_cur_rec.GRADE),
1321: X_UNIT_GRADE_POINTS => NVL(p_term_unitdtls_record.UNIT_GRADE_POINTS, dup_cur_rec.UNIT_GRADE_POINTS)
1322: );
1323:
1324: UPDATE igs_ad_tundt_int
1325: SET status =cst_s_val_1,
1326: error_code = cst_ec_val_NULL,
1327: term_details_id = dup_cur_rec.UNIT_DETAILS_ID
1328: WHERE interface_term_unitdtls_id = p_term_unitdtls_record.interface_term_unitdtls_id;

Line 1343: igs_ad_imp_001.logerrormessage( p_term_unitdtls_record.interface_term_unitdtls_id,l_msg_data,'IGS_AD_TUNDT_INT');

1339: l_error_text := l_msg_data;
1340: l_error_code := 'E014';
1341:
1342: IF p_enable_log = 'Y' THEN
1343: igs_ad_imp_001.logerrormessage( p_term_unitdtls_record.interface_term_unitdtls_id,l_msg_data,'IGS_AD_TUNDT_INT');
1344: END IF;
1345: ELSE
1346: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);
1347: l_error_code := 'E518';

Line 1365: UPDATE igs_ad_tundt_int

1361: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1362: END IF;
1363:
1364: END IF;
1365: UPDATE igs_ad_tundt_int
1366: SET status = cst_s_val_3,
1367: error_code = l_error_code,
1368: error_text = l_error_text,
1369: match_ind = DECODE (

Line 1382: UPDATE igs_ad_tundt_int unit

1378: BEGIN
1379:
1380: -- jchin Bug 4629226 Put an error in the int table if record is associated with an external transcript
1381:
1382: UPDATE igs_ad_tundt_int unit
1383: SET
1384: status = '3'
1385: , error_code = 'E334'
1386: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E334', 8405)

Line 1402: UPDATE igs_ad_tundt_int

1398: COMMIT;
1399:
1400: --1. Set STATUS to 3 for interface records with RULE = E or I and MATCH IND is not null and not '15'
1401: IF p_rule IN ('E', 'I') THEN
1402: UPDATE igs_ad_tundt_int
1403: SET
1404: status = '3'
1405: , error_code = 'E700'
1406: , error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405)

Line 1415: UPDATE igs_ad_tundt_int

1411: COMMIT;
1412:
1413: -- 2. Set STATUS to 1 for interface records with RULE = R and MATCH IND = 17,18,19,22,23,24,27
1414: IF p_rule = 'R' THEN
1415: UPDATE igs_ad_tundt_int
1416: SET
1417: status = '1', error_code = NULL
1418: WHERE interface_run_id = p_interface_run_id
1419: AND status = '2'

Line 1426: UPDATE igs_ad_tundt_int unit

1422: COMMIT;
1423:
1424: -- 5. Set STATUS to 1 and MATCH IND to 19 for interface records with RULE = E matching OSS record(s)
1425: IF p_rule = 'E' THEN
1426: UPDATE igs_ad_tundt_int unit
1427: SET
1428: status = '1'
1429: , match_ind = '19'
1430: WHERE interface_run_id = p_interface_run_id

Line 1456: FROM igs_ad_tundt_int

1452: **********************************************************************************/
1453:
1454: l_total_records_prcessed := 0;
1455: SELECT COUNT(interface_term_unitdtls_id) INTO l_count_interface_unitdtls_id
1456: FROM igs_ad_tundt_int
1457: WHERE interface_run_id = p_interface_run_id
1458: AND status =2 ;
1459:
1460: LOOP

Line 1466: FROM igs_ad_tundt_int

1462:
1463: SELECT
1464: MIN(interface_term_unitdtls_id) , MAX(interface_term_unitdtls_id)
1465: INTO l_minint , l_maxint
1466: FROM igs_ad_tundt_int
1467: WHERE interface_run_id = p_interface_run_id
1468: AND status =2
1469: AND rownum < =100;
1470:

Line 1493: UPDATE igs_ad_tundt_int unit

1489:
1490: /*Set STATUS to 1 and MATCH IND to 23 for interface records with RULE = R matching OSS record(s) in
1491: ALL updateable column values, if column nullification is not allowed then the 2 DECODE should be replaced by a single NVL*/
1492: IF p_rule = 'R' THEN
1493: UPDATE igs_ad_tundt_int unit
1494: SET
1495: status = '1'
1496: , match_ind = '23'
1497: WHERE interface_run_id = p_interface_run_id

Line 1515: UPDATE igs_ad_tundt_int unit

1511:
1512: --Set STATUS to 3 and MATCH IND = 20 for interface records with RULE = R and
1513: --MATCH IND <> 21, 25, ones failed above discrepancy check
1514: IF p_rule = 'R' THEN
1515: UPDATE igs_ad_tundt_int unit
1516: SET
1517: status = '3'
1518: , match_ind = '20'
1519: , dup_term_unitdtls_id = ( SELECT unit_details_id

Line 1537: UPDATE igs_ad_tundt_int unit

1533:
1534:
1535: --Set STATUS to 3 for interface records with RULE = R and invalid MATCH IND
1536: IF p_rule = 'R' THEN
1537: UPDATE igs_ad_tundt_int unit
1538: SET
1539: status = '3'
1540: , error_code = 'E700'
1541: , error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405)