APPS.IGS_AD_IMP_011 dependencies on IGS_PE_ACAD_HONORS

Line 106: FROM igs_pe_acad_honors hi

102: -- Removed the appl_no and modified acad_honor_type_id to acad_honor_type
103: --
104: CURSOR chk_dup_cur ( acadhonor_rec hnr_cur%ROWTYPE) IS
105: SELECT rowid,hi.*
106: FROM igs_pe_acad_honors hi
107: WHERE hi.person_id = acadhonor_rec.person_id AND
108: hi.acad_honor_type = acadhonor_rec.acad_honor_type AND
109: NVL(hi.honor_date,TO_DATE('4712/12/31','YYYY/MM/DD')) = NVL(TRUNC(acadhonor_rec.honor_date),TO_DATE('4712/12/31','YYYY/MM/DD'));
110:

Line 201: igs_pe_acad_honors_pkg.insert_row (

197: END IF;
198:
199:
200:
201: igs_pe_acad_honors_pkg.insert_row (
202: x_rowid => l_rowid,
203: x_acad_honor_id => l_acad_hnr_id,
204: x_person_id => acadhonor_rec.person_id,
205: x_acad_honor_type => acadhonor_rec.acad_honor_type ,

Line 278: FROM igs_pe_acad_honors pe, igs_ad_interface_all ii

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
277: AND EXISTS ( SELECT '1'
278: FROM igs_pe_acad_honors pe, igs_ad_interface_all ii
279: WHERE ii.interface_run_id = l_interface_run_id
280: AND ii.interface_id = mi.interface_id
281: AND ii.person_id = pe.person_id
282: AND pe.acad_honor_type = UPPER(mi.acad_honor_type)

Line 315: FROM igs_pe_acad_honors pe, igs_ad_interface_all ii

311: WHERE mi.interface_run_id = l_interface_run_id
312: AND mi.match_ind IS NULL
313: AND mi.status = cst_stat_val_2
314: AND EXISTS ( SELECT '1'
315: FROM igs_pe_acad_honors pe, igs_ad_interface_all ii
316: WHERE ii.interface_run_id = l_interface_run_id
317: AND ii.interface_id = mi.interface_id
318: AND ii.person_id = pe.person_id
319: AND pe.acad_honor_type = UPPER(mi.acad_honor_type)

Line 331: FROM igs_pe_acad_honors pe, igs_ad_interface_all ii

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
332: WHERE mi.interface_run_id = l_interface_run_id
333: AND ii.interface_id = mi.interface_id
334: AND ii.person_id = pe.person_id
335: AND pe.acad_honor_type = UPPER(mi.acad_honor_type)

Line 341: FROM igs_pe_acad_honors pe, igs_ad_interface_all ii

337: WHERE mi.interface_run_id = l_interface_run_id
338: AND mi.match_ind IS NULL
339: AND mi.status = cst_stat_val_2
340: AND EXISTS (SELECT '1'
341: FROM igs_pe_acad_honors pe, igs_ad_interface_all ii
342: WHERE ii.interface_run_id = l_interface_run_id
343: AND ii.interface_id = mi.interface_id
344: AND ii.person_id = pe.person_id
345: AND pe.acad_honor_type = UPPER(mi.acad_honor_type)

Line 386: igs_pe_acad_honors_pkg.update_row (

382: --
383: -- Validation Successful
384:
385: BEGIN
386: igs_pe_acad_honors_pkg.update_row (
387: x_rowid => chk_dup_rec.rowid,
388: x_acad_honor_id => chk_dup_rec.acad_honor_id,
389: x_person_id => acadhonor_rec.person_id,
390: x_acad_honor_type => acadhonor_rec.acad_honor_type ,

Line 440: igs_pe_acad_honors_pkg.update_row (

436: ELSIF l_validate = 'Y' THEN
437: --
438: -- Validation Successful
439: BEGIN
440: igs_pe_acad_honors_pkg.update_row (
441: x_rowid => chk_dup_rec.rowid,
442: x_acad_honor_id => chk_dup_rec.acad_honor_id,
443: x_person_id =>acadhonor_rec.person_id,
444: x_acad_honor_type => acadhonor_rec.acad_honor_type,