APPS.IGS_AD_IMP_024 dependencies on IGS_AD_TERM_UNITDTLS

Line 1157: AND (NOT EXISTS (SELECT 1 FROM igs_ad_term_unitdtls unit_oss

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
1158: WHERE term_details_id = unit.term_details_id
1159: AND unit = unit.unit )
1160: OR ( p_rule = 'R' AND unit.match_ind IN ('16', '25') )
1161: )

Line 1169: AND EXISTS (SELECT 1 FROM igs_ad_term_unitdtls unit_oss

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))
1169: AND EXISTS (SELECT 1 FROM igs_ad_term_unitdtls unit_oss
1170: WHERE term_details_id = unit.term_details_id
1171: AND unit = unit.unit
1172: );
1173:

Line 1178: igs_ad_term_unitdtls unit_oss

1174: CURSOR c_dup_cur(term_unit_rec term_unit_cur%ROWTYPE) IS
1175: SELECT
1176: unit_oss.rowid, unit_oss.*
1177: FROM
1178: igs_ad_term_unitdtls unit_oss
1179: WHERE term_details_id = term_unit_rec.term_details_id
1180: AND unit = term_unit_rec.unit ;
1181:
1182:

Line 1218: igs_ad_term_unitdtls_pkg.insert_row(

1214: l_error_text VARCHAR2(2000):= NULL;
1215: BEGIN
1216: l_msg_at_index := igs_ge_msg_stack.count_msg;
1217: SAVEPOINT before_create_unit;
1218: igs_ad_term_unitdtls_pkg.insert_row(
1219: l_rowid ,
1220: l_unit_details_id ,
1221: p_term_unitdtls_record.term_details_id ,
1222: p_term_unitdtls_record.UNIT,

Line 1311: igs_ad_term_unitdtls_pkg.update_row(

1307: l_error_text VARCHAR2(2000):= NULL;
1308: BEGIN
1309: l_msg_at_index := igs_ge_msg_stack.count_msg;
1310: SAVEPOINT before_update_unit;
1311: igs_ad_term_unitdtls_pkg.update_row(
1312: X_ROWID => dup_cur_rec.rowid ,
1313: X_UNIT_DETAILS_ID => dup_cur_rec.UNIT_DETAILS_ID ,
1314: X_TERM_DETAILS_ID => p_term_unitdtls_record.TERM_DETAILS_ID ,
1315: X_UNIT => p_term_unitdtls_record.UNIT ,

Line 1432: AND EXISTS ( SELECT 1 FROM igs_ad_term_unitdtls unit_oss

1428: status = '1'
1429: , match_ind = '19'
1430: WHERE interface_run_id = p_interface_run_id
1431: AND status = '2'
1432: AND EXISTS ( SELECT 1 FROM igs_ad_term_unitdtls unit_oss
1433: WHERE term_details_id = unit.term_details_id
1434: AND unit = unit.unit
1435: );
1436: END IF;

Line 1500: AND EXISTS ( SELECT 1 FROM igs_ad_term_unitdtls

1496: , match_ind = '23'
1497: WHERE interface_run_id = p_interface_run_id
1498: AND status = '2'
1499: AND NVL (match_ind, '15') = '15'
1500: AND EXISTS ( SELECT 1 FROM igs_ad_term_unitdtls
1501: WHERE NVL(UNIT,'X') = NVL(unit.UNIT,'X') AND
1502: NVL(UNIT_DIFFICULTY,-1) = NVL(unit.UNIT_DIFFICULTY,-1) AND
1503: NVL(UNIT_NAME,'X') = NVL(unit.UNIT_NAME,'X') AND
1504: NVL(CP_ATTEMPTED,-1) = NVL(unit.CP_ATTEMPTED,-1) AND

Line 1520: FROM igs_ad_term_unitdtls unit_oss

1516: SET
1517: status = '3'
1518: , match_ind = '20'
1519: , dup_term_unitdtls_id = ( SELECT unit_details_id
1520: FROM igs_ad_term_unitdtls unit_oss
1521: WHERE term_details_id = unit.term_details_id
1522: AND unit = unit.unit )
1523: WHERE interface_run_id = p_interface_run_id
1524: AND status = '2'

Line 1527: FROM igs_ad_term_unitdtls unit_oss

1523: WHERE interface_run_id = p_interface_run_id
1524: AND status = '2'
1525: AND NVL (match_ind, '15') = '15'
1526: AND EXISTS (SELECT 1
1527: FROM igs_ad_term_unitdtls unit_oss
1528: WHERE term_details_id = unit.term_details_id
1529: AND unit = unit.unit );
1530:
1531: END IF;