APPS.IGS_AD_IMP_011 dependencies on IGS_AD_ACADHONOR_INT_ALL

Line 87: FROM igs_ad_acadhonor_int_all mi,igs_ad_interface_all i

83: -- dld ref 1. Pick up the records from the tables mentioned below :
84: --
85: CURSOR hnr_cur (cp_interface_run_id igs_ad_interface_all.interface_run_id%TYPE) IS
86: SELECT mi.*, i.person_id
87: FROM igs_ad_acadhonor_int_all mi,igs_ad_interface_all i
88: WHERE mi.interface_run_id = cp_interface_run_id
89: AND mi.interface_id = i.interface_id
90: AND i.interface_run_id = cp_interface_run_id
91: AND mi.status = '2';

Line 262: UPDATE igs_ad_acadhonor_int_all

258: l_rule := igs_ad_imp_001.find_source_cat_rule(p_source_type_id,'PERSON_ACAD_HONORS');
259:
260: -- If rule is E or I, then if the match_ind is not null, the combination is invalid
261: IF l_rule IN ('E','I') THEN
262: UPDATE igs_ad_acadhonor_int_all
263: SET status = cst_stat_val_3,
264: ERROR_CODE = cst_err_val_695 -- Error code depicting incorrect combination
265: WHERE match_ind IS NOT NULL
266: AND status = cst_stat_val_2

Line 272: UPDATE igs_ad_acadhonor_int_all mi

268: END IF;
269:
270: -- If rule is E and duplicate exists, update match_ind to 19 and status to 1
271: IF l_rule = 'E' THEN
272: UPDATE igs_ad_acadhonor_int_all mi
273: SET status = cst_stat_val_1,
274: match_ind = cst_mi_val_19
275: WHERE mi.interface_run_id = l_interface_run_id
276: AND mi.status = cst_stat_val_2

Line 289: UPDATE igs_ad_acadhonor_int_all

285:
286: -- If rule is R and there match_ind is 18,19,22 or 23 then the records must have been
287: -- processed in prior runs and didn't get updated .. update to status 1
288: IF l_rule = 'R' THEN
289: UPDATE igs_ad_acadhonor_int_all
290: SET status = cst_stat_val_1
291: WHERE interface_run_id = l_interface_run_id
292: AND match_ind IN (cst_mi_val_18,cst_mi_val_19,cst_mi_val_22,cst_mi_val_23)
293: AND status = cst_stat_val_2;

Line 298: UPDATE igs_ad_acadhonor_int_all

294: END IF;
295:
296: -- If rule is R and match_ind is neither 21 nor 25 then error
297: IF l_rule = 'R' THEN
298: UPDATE igs_ad_acadhonor_int_all
299: SET status = cst_stat_val_3,
300: ERROR_CODE = cst_err_val_695
301: WHERE interface_run_id = l_interface_run_id
302: AND status = cst_stat_val_2

Line 308: UPDATE igs_ad_acadhonor_int_all mi

304: END IF;
305:
306: -- If rule is R, set duplicated records with no discrepancy to status 1 and match_ind 23
307: IF l_rule = 'R' THEN
308: UPDATE igs_ad_acadhonor_int_all mi
309: SET status = cst_stat_val_1,
310: match_ind = cst_mi_val_23
311: WHERE mi.interface_run_id = l_interface_run_id
312: AND mi.match_ind IS NULL

Line 327: UPDATE igs_ad_acadhonor_int_all mi

323: END IF;
324:
325: -- If rule is R records still exist, they are duplicates and have discrepancy .. update status=3,match_ind=20
326: IF l_rule = 'R' THEN
327: UPDATE igs_ad_acadhonor_int_all mi
328: SET status = cst_stat_val_3,
329: match_ind = cst_mi_val_20,
330: DUP_ACAD_HONOR_ID = (SELECT pe.acad_honor_id
331: FROM igs_pe_acad_honors pe, igs_ad_interface_all ii

Line 509: igs_ad_acadhonor_int_all

505: --
506: -- Update the interface record with the status, error_code, match_ind
507: --
508: UPDATE
509: igs_ad_acadhonor_int_all
510: SET
511: status = l_status,
512: error_code = l_error_code,
513: match_ind = l_match_ind

Line 526: igs_ad_acadhonor_int_all

522: IF chk_dup_cur%ISOPEN THEN
523: CLOSE chk_dup_cur;
524: END IF;
525: UPDATE
526: igs_ad_acadhonor_int_all
527: SET
528: status = '3',
529: error_code = 'E518'
530: WHERE