APPS.IGS_AD_IMP_006 dependencies on IGS_AD_EXCURR_INT

Line 946: l_dup_person_interest_id IGS_AD_EXCURR_INT.DUP_PERSON_INTEREST_ID%TYPE;

942: P_SOURCE_TYPE_ID IN NUMBER,
943: P_BATCH_ID IN VARCHAR2
944: ) AS
945:
946: l_dup_person_interest_id IGS_AD_EXCURR_INT.DUP_PERSON_INTEREST_ID%TYPE;
947: l_last_update_date IGS_AD_EXTRACURR_ACT_V.LAST_UPDATE_DATE%TYPE;
948: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
949: CURSOR extracurr(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
950: SELECT hii.*, i.person_id

Line 951: FROM igs_ad_excurr_int_all hii, igs_ad_interface_all i

947: l_last_update_date IGS_AD_EXTRACURR_ACT_V.LAST_UPDATE_DATE%TYPE;
948: l_interface_run_id igs_ad_interface_all.interface_run_id%TYPE;
949: CURSOR extracurr(cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
950: SELECT hii.*, i.person_id
951: FROM igs_ad_excurr_int_all hii, igs_ad_interface_all i
952: WHERE hii.interface_run_id = cp_interface_run_id
953: AND i.interface_id = hii.interface_id
954: AND i.interface_run_id = cp_interface_run_id
955: AND hii.status = '2';

Line 1129: UPDATE igs_ad_excurr_int_all

1125:
1126:
1127: --Validation successful
1128: p_error_code := NULL;
1129: UPDATE igs_ad_excurr_int_all
1130: SET STATUS = '1'
1131: WHERE INTERFACE_EXCURR_ID = EXTRACURR_REC.INTERFACE_EXCURR_ID;
1132: EXCEPTION
1133: WHEN NO_DATA_FOUND THEN

Line 1135: UPDATE igs_ad_excurr_int_all

1131: WHERE INTERFACE_EXCURR_ID = EXTRACURR_REC.INTERFACE_EXCURR_ID;
1132: EXCEPTION
1133: WHEN NO_DATA_FOUND THEN
1134: -- Validation Unsuccessful
1135: UPDATE igs_ad_excurr_int_all
1136: SET STATUS = '3',
1137: ERROR_CODE = p_error_code
1138: WHERE INTERFACE_EXCURR_ID = EXTRACURR_REC.INTERFACE_EXCURR_ID;
1139:

Line 1218: igs_ad_excurr_int_all

1214: x_mode => 'R');
1215:
1216: IF l_return_Status IN ('E','U') THEN
1217: UPDATE
1218: igs_ad_excurr_int_all
1219: SET
1220: ERROR_CODE = 'E322',
1221: STATUS = '3'
1222: WHERE

Line 1250: igs_ad_excurr_int_all

1246: END IF;
1247:
1248: ELSE
1249: UPDATE
1250: igs_ad_excurr_int_all
1251: SET
1252: STATUS = '1'
1253: WHERE
1254: INTERFACE_EXCURR_ID = extracurr_rec.INTERFACE_EXCURR_ID;

Line 1260: UPDATE igs_ad_excurr_int_all

1256: END IF;
1257: EXCEPTION
1258: WHEN OTHERS THEN
1259: -- Validation Unsuccessful
1260: UPDATE igs_ad_excurr_int_all
1261: SET STATUS = '3',
1262: ERROR_CODE = 'E322'
1263: WHERE INTERFACE_EXCURR_ID = EXTRACURR_REC.INTERFACE_EXCURR_ID;
1264: