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_025 dependencies on IGS_PE_HEAR_DTL_INT

Line 1008: FROM igs_pe_hear_dtl_int ai,

1004:
1005: --Pick up the records for processing from the Hearing Details Interface Table
1006: CURSOR hearing_dtls_cur(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
1007: SELECT ai.*, i.person_id
1008: FROM igs_pe_hear_dtl_int ai,
1009: igs_ad_interface_all i
1010: WHERE ai.interface_id = i.interface_id
1011: AND ai.status = '2'
1012: AND ai.interface_run_id=cp_interface_run_id

Line 1025: l_status IGS_PE_HEAR_DTL_INT.status%TYPE;

1021: AND NVL(TRUNC(start_date),l_default_date)= NVL(TRUNC(hearing_dtls_rec.start_date),l_default_date);
1022: dup_chk_rec dup_chk_cur%ROWTYPE;
1023:
1024: l_rule VARCHAR2(1);
1025: l_status IGS_PE_HEAR_DTL_INT.status%TYPE;
1026: l_error_code IGS_PE_HEAR_DTL_INT.error_code%TYPE;
1027: l_processed_records NUMBER(5) := 0;
1028: l_app VARCHAR2(50) := NULL;
1029: l_message_name VARCHAR2(30) := NULL;

Line 1026: l_error_code IGS_PE_HEAR_DTL_INT.error_code%TYPE;

1022: dup_chk_rec dup_chk_cur%ROWTYPE;
1023:
1024: l_rule VARCHAR2(1);
1025: l_status IGS_PE_HEAR_DTL_INT.status%TYPE;
1026: l_error_code IGS_PE_HEAR_DTL_INT.error_code%TYPE;
1027: l_processed_records NUMBER(5) := 0;
1028: l_app VARCHAR2(50) := NULL;
1029: l_message_name VARCHAR2(30) := NULL;
1030: --

Line 1034: l_error_code IGS_PE_HEAR_DTL_INT.error_code%TYPE;

1030: --
1031: -- Start of Local Procedure validate_hearing_dtls
1032: --
1033: FUNCTION validate_hearing_dtls(p_hearing_dtls_cur hearing_dtls_cur%ROWTYPE) RETURN BOOLEAN IS
1034: l_error_code IGS_PE_HEAR_DTL_INT.error_code%TYPE;
1035: BEGIN
1036:
1037: -- disp_file_ind Validation
1038: IF p_hearing_dtls_cur.dspl_file_ind NOT IN('Y','N') THEN

Line 1064: igs_ad_imp_001.logerrormessage(p_hearing_dtls_cur.interface_hearing_dtls_id,l_error_code,'IGS_PE_HEAR_DTL_INT');

1060: RETURN TRUE;
1061: EXCEPTION
1062: WHEN NO_DATA_FOUND THEN
1063: IF l_enable_log = 'Y' THEN
1064: igs_ad_imp_001.logerrormessage(p_hearing_dtls_cur.interface_hearing_dtls_id,l_error_code,'IGS_PE_HEAR_DTL_INT');
1065: END IF;
1066:
1067: UPDATE igs_pe_hear_dtl_int
1068: SET status = '3',

Line 1067: UPDATE igs_pe_hear_dtl_int

1063: IF l_enable_log = 'Y' THEN
1064: igs_ad_imp_001.logerrormessage(p_hearing_dtls_cur.interface_hearing_dtls_id,l_error_code,'IGS_PE_HEAR_DTL_INT');
1065: END IF;
1066:
1067: UPDATE igs_pe_hear_dtl_int
1068: SET status = '3',
1069: error_code = l_error_code
1070: WHERE interface_hearing_dtls_id = p_hearing_dtls_cur.interface_hearing_dtls_id;
1071: RETURN FALSE;

Line 1150: igs_ad_imp_001.logerrormessage(p_hearing_dtls_rec.interface_hearing_dtls_id,p_error_code,'IGS_PE_HEAR_DTL_INT');

1146: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1147: END IF;
1148: END IF;
1149: IF l_enable_log = 'Y' THEN
1150: igs_ad_imp_001.logerrormessage(p_hearing_dtls_rec.interface_hearing_dtls_id,p_error_code,'IGS_PE_HEAR_DTL_INT');
1151: END IF;
1152:
1153: END crt_pe_hearing_dtls;
1154: --

Line 1189: UPDATE igs_pe_hear_dtl_int pdi

1185:
1186: -- 1. If the rule is E or I, and the match ind column is not null, update all the records to status 3 as they are invalids.
1187:
1188: IF ((l_rule='E') OR (l_rule='I')) THEN
1189: UPDATE igs_pe_hear_dtl_int pdi
1190: SET status = '3',
1191: error_code = 'E695'
1192: WHERE pdi.status = '2' AND
1193: pdi.interface_run_id = l_interface_run_id AND

Line 1200: UPDATE igs_pe_hear_dtl_int pdi

1196:
1197: -- 2 . If rule is E and the match ind is null, we update the interface table for all duplicate records with status 1 and match ind 19.
1198:
1199: IF (l_rule = 'E') THEN
1200: UPDATE igs_pe_hear_dtl_int pdi
1201: SET status = '1',
1202: match_ind = '19'
1203: WHERE pdi.status = '2' AND
1204: pdi.interface_run_id = l_interface_run_id AND

Line 1219: UPDATE igs_pe_hear_dtl_int pdi

1215:
1216: -- 3. If rule is R and the record status is 18,19,22,23 these records have been processed, but didn't get updated. Update them to 1
1217:
1218: IF (l_rule='R') THEN
1219: UPDATE igs_pe_hear_dtl_int pdi
1220: SET status = '1'
1221: WHERE pdi.status = '2' AND
1222: pdi.interface_run_id = l_interface_run_id AND
1223: pdi.match_ind IN ('18','19','22','23');

Line 1230: UPDATE igs_pe_hear_dtl_int pdi

1226:
1227: -- 4. If rule is R and the match ind is not null and is neither 21 nor 25, update it to errored record.
1228:
1229: IF (l_rule = 'R') THEN
1230: UPDATE igs_pe_hear_dtl_int pdi
1231: SET status = '3',
1232: error_code = 'E695'
1233: WHERE pdi.status = '2' AND
1234: pdi.interface_run_id = l_interface_run_id AND

Line 1241: UPDATE igs_pe_hear_dtl_int pdi

1237:
1238: -- 5. If rule = 'R' and there is no discprepency in duplicate records, update them to status 1 and match ind 23.
1239:
1240: IF (l_rule ='R') THEN
1241: UPDATE igs_pe_hear_dtl_int pdi
1242: SET status = '1',
1243: match_ind = '23'
1244: WHERE pdi.status = '2' AND
1245: pdi.interface_run_id = l_interface_run_id AND

Line 1265: UPDATE igs_pe_hear_dtl_int pdi

1261: -- 6. If rule is R and there are still some records, they are the ones for which there is some discrepency existing. Update them to status 3
1262: -- and value from the OSS table.
1263:
1264: IF (l_rule ='R') THEN
1265: UPDATE igs_pe_hear_dtl_int pdi
1266: SET status = '3',
1267: match_ind = '20',
1268: dup_hearing_details_id=(SELECT pi.hearing_details_id
1269: FROM igs_pe_hearing_dtls pi,

Line 1324: UPDATE igs_pe_hear_dtl_int

1320: x_acad_dism_ind => hearing_dtls_rec.acad_dism_ind,
1321: x_non_acad_dism_ind => hearing_dtls_rec.non_acad_dism_ind,
1322: x_mode => 'R'
1323: );
1324: UPDATE igs_pe_hear_dtl_int
1325: SET status = '1',
1326: error_code=NULL,
1327: match_ind='18'
1328: WHERE interface_hearing_dtls_id = hearing_dtls_rec.interface_hearing_dtls_id;

Line 1365: igs_ad_imp_001.logerrormessage(hearing_dtls_rec.interface_hearing_dtls_id,l_error_code,'IGS_PE_HEAR_DTL_INT');

1361: END IF;
1362: END IF;
1363:
1364: IF l_enable_log = 'Y' THEN
1365: igs_ad_imp_001.logerrormessage(hearing_dtls_rec.interface_hearing_dtls_id,l_error_code,'IGS_PE_HEAR_DTL_INT');
1366: END IF;
1367:
1368: UPDATE igs_pe_hear_dtl_int
1369: SET status = l_status,

Line 1368: UPDATE igs_pe_hear_dtl_int

1364: IF l_enable_log = 'Y' THEN
1365: igs_ad_imp_001.logerrormessage(hearing_dtls_rec.interface_hearing_dtls_id,l_error_code,'IGS_PE_HEAR_DTL_INT');
1366: END IF;
1367:
1368: UPDATE igs_pe_hear_dtl_int
1369: SET status = l_status,
1370: error_code = l_error_code
1371: WHERE interface_hearing_dtls_id = hearing_dtls_rec.interface_hearing_dtls_id;
1372: END;

Line 1389: UPDATE igs_pe_hear_dtl_int

1385: x_non_acad_dism_ind => hearing_dtls_rec.non_acad_dism_ind,
1386: x_mode => 'R'
1387: );
1388:
1389: UPDATE igs_pe_hear_dtl_int
1390: SET status = '1',
1391: match_ind = '18',
1392: error_code = NULL
1393: WHERE interface_hearing_dtls_id = hearing_dtls_rec.interface_hearing_dtls_id;

Line 1432: igs_ad_imp_001.logerrormessage(hearing_dtls_rec.interface_hearing_dtls_id,l_error_code,'IGS_PE_HEAR_DTL_INT');

1428:
1429: END IF;
1430:
1431: IF l_enable_log = 'Y' THEN
1432: igs_ad_imp_001.logerrormessage(hearing_dtls_rec.interface_hearing_dtls_id,l_error_code,'IGS_PE_HEAR_DTL_INT');
1433: END IF;
1434:
1435:
1436: UPDATE igs_pe_hear_dtl_int

Line 1436: UPDATE igs_pe_hear_dtl_int

1432: igs_ad_imp_001.logerrormessage(hearing_dtls_rec.interface_hearing_dtls_id,l_error_code,'IGS_PE_HEAR_DTL_INT');
1433: END IF;
1434:
1435:
1436: UPDATE igs_pe_hear_dtl_int
1437: SET status = l_status,
1438: error_code = l_error_code
1439: WHERE interface_hearing_dtls_id = hearing_dtls_rec.interface_hearing_dtls_id;
1440: END;

Line 1449: UPDATE igs_pe_hear_dtl_int

1445: crt_pe_hearing_dtls(
1446: p_hearing_dtls_rec => hearing_dtls_rec,
1447: p_status =>l_status,
1448: p_error_code =>l_error_code );
1449: UPDATE igs_pe_hear_dtl_int
1450: SET status = l_status,
1451: error_code = l_error_code
1452: WHERE interface_hearing_dtls_id = hearing_dtls_rec.interface_hearing_dtls_id;
1453: END IF; -- End If for Dup_cur