eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_DA_TRNS_IMP dependencies on IGS_AD_TERM_DETAILS

Line 444: p_transcript_id igs_ad_term_details.transcript_id%TYPE

440: AND education_id = cp_education_id
441: FOR UPDATE NOWAIT;
442:
443: CURSOR c_trans_term (
444: p_transcript_id igs_ad_term_details.transcript_id%TYPE
445: )
446: IS
447: SELECT term_oss.ROWID, term_oss.*
448: FROM igs_ad_term_details term_oss

Line 448: FROM igs_ad_term_details term_oss

444: p_transcript_id igs_ad_term_details.transcript_id%TYPE
445: )
446: IS
447: SELECT term_oss.ROWID, term_oss.*
448: FROM igs_ad_term_details term_oss
449: WHERE transcript_id = p_transcript_id
450: FOR UPDATE NOWAIT;
451:
452: CURSOR c_term_unit (

Line 520: igs_ad_term_details_pkg.delete_row (l_trans_term.ROWID);

516:
517: igs_ad_term_unitdtls_pkg.delete_row (l_term_unit.ROWID);
518: END LOOP;
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;

Line 1100: write_message ('* IGS_AD_TERM_DETAILS_PKG.INSERT_ROW *');

1096: THEN
1097: write_message ( 'got p_term_dtls_record.transcript_id '
1098: || p_term_dtls_record.transcript_id
1099: );
1100: write_message ('***** IGS_AD_TERM_DETAILS_PKG.INSERT_ROW *****');
1101: igs_ad_term_details_pkg.insert_row (l_rowid,
1102: l_term_details_id,
1103: p_term_dtls_record.transcript_id,
1104: p_term_dtls_record.term,

Line 1101: igs_ad_term_details_pkg.insert_row (l_rowid,

1097: write_message ( 'got p_term_dtls_record.transcript_id '
1098: || p_term_dtls_record.transcript_id
1099: );
1100: write_message ('***** IGS_AD_TERM_DETAILS_PKG.INSERT_ROW *****');
1101: igs_ad_term_details_pkg.insert_row (l_rowid,
1102: l_term_details_id,
1103: p_term_dtls_record.transcript_id,
1104: p_term_dtls_record.term,
1105: TRUNC (p_term_dtls_record.start_date

Line 1188: FROM igs_ad_term_details term_oss

1184:
1185: CURSOR c_dup_cur
1186: IS
1187: SELECT term_oss.ROWID, term_oss.*
1188: FROM igs_ad_term_details term_oss
1189: WHERE transcript_id = p_term_dtls_record.transcript_id
1190: AND term = p_term_dtls_record.term
1191: AND TRUNC (start_date) = TRUNC (p_term_dtls_record.start_date)
1192: AND TRUNC (end_date) = TRUNC (p_term_dtls_record.end_date);

Line 1205: igs_ad_term_details_pkg.update_row (x_rowid => dup_cur_rec.ROWID,

1201: SAVEPOINT before_update_term;
1202:
1203: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')
1204: THEN
1205: igs_ad_term_details_pkg.update_row (x_rowid => dup_cur_rec.ROWID,
1206: x_term_details_id => dup_cur_rec.term_details_id,
1207: x_transcript_id => dup_cur_rec.transcript_id,
1208: x_term => p_term_dtls_record.term,
1209: x_start_date => TRUNC (p_term_dtls_record.start_date

Line 1226: write_log ('igs_ad_term_details_pkg.update_row',

1222: );
1223: END IF;
1224:
1225: p_term_dtls_record.term_details_id := dup_cur_rec.term_details_id;
1226: write_log ('igs_ad_term_details_pkg.update_row',
1227: 'igs.plsql.igs_da_trns_imp.update_term_details'
1228: );
1229: ecx_debug.pop ('IGS_DA_TRNS_IMP.UPDATE_TERM_DETAILS');
1230: EXCEPTION

Line 1290: FROM igs_ad_term_details term_oss

1286: AS
1287: CURSOR c_dup_cur
1288: IS
1289: SELECT term_oss.ROWID, term_oss.*
1290: FROM igs_ad_term_details term_oss
1291: WHERE transcript_id = p_trans_cur_rec.transcript_id
1292: AND term = p_trans_cur_rec.term
1293: AND TRUNC (start_date) = TRUNC (p_trans_cur_rec.start_date)
1294: AND TRUNC (end_date) = TRUNC (p_trans_cur_rec.end_date);

Line 1344: p_term IN igs_ad_term_details.term%TYPE,

1340: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1341: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
1342: p_person_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE,
1343: p_term_type IN VARCHAR2,
1344: p_term IN igs_ad_term_details.term%TYPE,
1345: p_start_date IN VARCHAR2,
1346: p_end_date IN VARCHAR2,
1347: p_source_course_subject IN VARCHAR2,
1348: p_source_course_num IN VARCHAR2,

Line 1790: l_start_dt igs_ad_term_details.start_date%TYPE;

1786: FROM igs_ps_unit_ver
1787: WHERE unit_cd = cp_unit_cd AND version_number = cp_version_number;
1788:
1789: l_count NUMBER := 0;
1790: l_start_dt igs_ad_term_details.start_date%TYPE;
1791: l_end_dt igs_ad_term_details.end_date%TYPE;
1792: l_return_status VARCHAR2 (1000);
1793: BEGIN
1794: ecx_debug.push ('IGS_DA_TRNS_IMP.DERIVE_UNIT_DATA');

Line 1791: l_end_dt igs_ad_term_details.end_date%TYPE;

1787: WHERE unit_cd = cp_unit_cd AND version_number = cp_version_number;
1788:
1789: l_count NUMBER := 0;
1790: l_start_dt igs_ad_term_details.start_date%TYPE;
1791: l_end_dt igs_ad_term_details.end_date%TYPE;
1792: l_return_status VARCHAR2 (1000);
1793: BEGIN
1794: ecx_debug.push ('IGS_DA_TRNS_IMP.DERIVE_UNIT_DATA');
1795: p_s_adv_stnd_type := 'UNIT'; -- initialise