APPS.IGS_DA_TRNS_IMP dependencies on IGS_AD_TRANSCRIPT

Line 430: CURSOR c_trans (cp_education_id igs_ad_transcript.education_id%TYPE)

426: SELECT education_id
427: FROM hz_education
428: WHERE party_id = p_person_id;
429:
430: CURSOR c_trans (cp_education_id igs_ad_transcript.education_id%TYPE)
431: IS
432: SELECT trans_oss.ROWID, trans_oss.*
433: FROM igs_ad_transcript trans_oss
434: WHERE transcript_source IN (

Line 433: FROM igs_ad_transcript trans_oss

429:
430: CURSOR c_trans (cp_education_id igs_ad_transcript.education_id%TYPE)
431: IS
432: SELECT trans_oss.ROWID, trans_oss.*
433: FROM igs_ad_transcript trans_oss
434: WHERE transcript_source IN (
435: SELECT code_id
436: FROM igs_ad_code_classes
437: WHERE CLASS = 'TRANSCRIPT_SOURCE'

Line 523: igs_ad_transcript_pkg.delete_row (l_trans.ROWID);

519:
520: igs_ad_term_details_pkg.delete_row (l_trans_term.ROWID);
521: END LOOP;
522:
523: igs_ad_transcript_pkg.delete_row (l_trans.ROWID);
524: END LOOP;
525: END LOOP;
526:
527: -- delete records from igs_av_adv_standing_all

Line 595: write_message ('***** IGS_AD_TRANSCRIPT_PKG.INSERT_ROW *****');

591: THEN
592: OPEN c_source;
593: FETCH c_source INTO l_transcript_source;
594: CLOSE c_source;
595: write_message ('***** IGS_AD_TRANSCRIPT_PKG.INSERT_ROW *****');
596: igs_ad_transcript_pkg.insert_row (x_rowid => l_rowid,
597: x_quintile_rank => NULL,
598: x_percentile_rank => NULL,
599: x_transcript_id => l_transcript_id,

Line 596: igs_ad_transcript_pkg.insert_row (x_rowid => l_rowid,

592: OPEN c_source;
593: FETCH c_source INTO l_transcript_source;
594: CLOSE c_source;
595: write_message ('***** IGS_AD_TRANSCRIPT_PKG.INSERT_ROW *****');
596: igs_ad_transcript_pkg.insert_row (x_rowid => l_rowid,
597: x_quintile_rank => NULL,
598: x_percentile_rank => NULL,
599: x_transcript_id => l_transcript_id,
600: x_education_id => p_trans_record.education_id,

Line 631: write_log ('igs_ad_transcript_pkg.insert_row',

627: );
628: END IF;
629:
630: p_trans_record.transcript_id := l_transcript_id;
631: write_log ('igs_ad_transcript_pkg.insert_row',
632: 'igs.plsql.igs_da_trns_imp.create_new_transcript_details'
633: );
634: igs_ad_wf_001.transcript_entrd_event (p_trans_record.person_id,
635: p_trans_record.education_id,

Line 701: FROM igs_ad_transcript trans_oss

697:
698: CURSOR c_dup_cur
699: IS
700: SELECT trans_oss.ROWID row_id, trans_oss.*
701: FROM igs_ad_transcript trans_oss
702: WHERE ( transcript_id = p_trans_record.transcript_id
703: AND p_trans_record.transcript_id IS NOT NULL
704: )
705: OR ( p_trans_record.transcript_id IS NULL

Line 733: igs_ad_transcript_pkg.update_row (x_rowid => dup_cur_rec.row_id,

729: THEN
730: OPEN c_source;
731: FETCH c_source INTO l_source;
732: CLOSE c_source;
733: igs_ad_transcript_pkg.update_row (x_rowid => dup_cur_rec.row_id,
734: x_quintile_rank => dup_cur_rec.quintile_rank,
735: x_percentile_rank => dup_cur_rec.percentile_rank,
736: x_transcript_id => dup_cur_rec.transcript_id,
737: x_education_id => dup_cur_rec.education_id,

Line 1366: FROM igs_ad_transcript trans_oss

1362:
1363: CURSOR c_dup_cur
1364: IS
1365: SELECT trans_oss.ROWID, trans_oss.*
1366: FROM igs_ad_transcript trans_oss
1367: WHERE trans_oss.term_type = l_trans_cur_rec.term_type
1368: AND ( ( transcript_id = l_trans_cur_rec.transcript_id
1369: AND l_trans_cur_rec.transcript_id IS NOT NULL
1370: )

Line 1392: FROM igs_ad_transcript

1388:
1389: CURSOR c_transcript_id
1390: IS
1391: SELECT transcript_id
1392: FROM igs_ad_transcript
1393: WHERE education_id = l_trans_cur_rec.education_id
1394: AND transcript_status = 'FINAL'
1395: AND transcript_source IN (
1396: SELECT code_id