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.

[Home] [Help]

APPS.IGS_DA_TRNS_IMP dependencies on IGS_AD_TERM_UNITDTLS

Line 453: p_term_details_id igs_ad_term_unitdtls.term_details_id%TYPE

449: WHERE transcript_id = p_transcript_id
450: FOR UPDATE NOWAIT;
451:
452: CURSOR c_term_unit (
453: p_term_details_id igs_ad_term_unitdtls.term_details_id%TYPE
454: )
455: IS
456: SELECT unit_oss.ROWID, unit_oss.*
457: FROM igs_ad_term_unitdtls unit_oss

Line 457: FROM igs_ad_term_unitdtls unit_oss

453: p_term_details_id igs_ad_term_unitdtls.term_details_id%TYPE
454: )
455: IS
456: SELECT unit_oss.ROWID, unit_oss.*
457: FROM igs_ad_term_unitdtls unit_oss
458: WHERE term_details_id = p_term_details_id
459: FOR UPDATE NOWAIT;
460:
461: CURSOR c_adv_stnd_unt (

Line 462: p_unit_details_id igs_ad_term_unitdtls.unit_details_id%TYPE

458: WHERE term_details_id = p_term_details_id
459: FOR UPDATE NOWAIT;
460:
461: CURSOR c_adv_stnd_unt (
462: p_unit_details_id igs_ad_term_unitdtls.unit_details_id%TYPE
463: )
464: IS
465: SELECT unt.ROWID, unt.*
466: FROM igs_av_stnd_unit_all unt

Line 517: igs_ad_term_unitdtls_pkg.delete_row (l_term_unit.ROWID);

513: -- delete advanced standing information
514: igs_av_stnd_unit_pkg.delete_row (l_adv_stnd_unt.ROWID);
515: END LOOP;
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;

Line 827: FROM igs_ad_term_unitdtls unit_oss

823:
824: CURSOR c_dup_cur
825: IS
826: SELECT unit_oss.ROWID, unit_oss.*
827: FROM igs_ad_term_unitdtls unit_oss
828: WHERE term_details_id = p_term_unitdtls_record.term_details_id
829: AND unit = p_term_unitdtls_record.unit;
830:
831: dup_cur_rec c_dup_cur%ROWTYPE;

Line 842: igs_ad_term_unitdtls_pkg.update_row (x_rowid => dup_cur_rec.ROWID,

838: SAVEPOINT before_update_unit;
839:
840: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')
841: THEN
842: igs_ad_term_unitdtls_pkg.update_row (x_rowid => dup_cur_rec.ROWID,
843: x_unit_details_id => dup_cur_rec.unit_details_id,
844: x_term_details_id => dup_cur_rec.term_details_id,
845: x_unit => p_term_unitdtls_record.unit,
846: x_unit_difficulty => dup_cur_rec.unit_difficulty,

Line 856: write_log ( 'igs_ad_term_unitdtls_pkg.update_row unit_details_id='

852: );
853: END IF;
854:
855: p_term_unitdtls_record.unit_details_id := dup_cur_rec.unit_details_id;
856: write_log ( 'igs_ad_term_unitdtls_pkg.update_row unit_details_id='
857: || p_term_unitdtls_record.unit_details_id,
858: 'igs.plsql.igs_da_trns_imp.update_term_unit_details'
859: );
860: ecx_debug.pop ('IGS_DA_TRNS_IMP.UPDATE_TERM_UNIT_DETAILS');

Line 909: RETURN igs_ad_term_unitdtls.unit_details_id%TYPE

905:
906: FUNCTION create_term_unit_details (
907: p_term_unitdtls_record IN OUT NOCOPY trans_cur_rec
908: )
909: RETURN igs_ad_term_unitdtls.unit_details_id%TYPE
910: AS
911: CURSOR c_unit_difficulty
912: IS
913: SELECT code_id

Line 919: l_unit_details_id igs_ad_term_unitdtls.unit_details_id%TYPE;

915: WHERE CLASS = 'UNIT_DIFFICULTY' AND NAME = 'STANDARD';
916:
917: l_rowid VARCHAR2 (25);
918: l_var VARCHAR2 (25);
919: l_unit_details_id igs_ad_term_unitdtls.unit_details_id%TYPE;
920: l_msg_at_index NUMBER := 0;
921: l_return_status VARCHAR2 (1);
922: l_msg_count NUMBER;
923: l_msg_data VARCHAR2 (2000);

Line 935: write_log ('Before igs_ad_term_unitdtls_pkg.insert_row',

931: SAVEPOINT before_create_unit;
932:
933: IF (NVL (fnd_profile.VALUE ('IGS_AV_STND_SOURCE'), 'X') = 'EXTERNAL')
934: THEN
935: write_log ('Before igs_ad_term_unitdtls_pkg.insert_row',
936: 'igs.plsql.igs_da_trns_imp.create_term_unit_details'
937: );
938: OPEN c_unit_difficulty;
939: FETCH c_unit_difficulty INTO l_unit_difficulty;

Line 941: write_message ('* IGS_AD_TERM_UNITDTLS_PKG.INSERT_ROW *');

937: );
938: OPEN c_unit_difficulty;
939: FETCH c_unit_difficulty INTO l_unit_difficulty;
940: CLOSE c_unit_difficulty;
941: write_message ('***** IGS_AD_TERM_UNITDTLS_PKG.INSERT_ROW *****');
942: igs_ad_term_unitdtls_pkg.insert_row (l_rowid,
943: l_unit_details_id,
944: p_term_unitdtls_record.term_details_id,
945: p_term_unitdtls_record.unit,

Line 942: igs_ad_term_unitdtls_pkg.insert_row (l_rowid,

938: OPEN c_unit_difficulty;
939: FETCH c_unit_difficulty INTO l_unit_difficulty;
940: CLOSE c_unit_difficulty;
941: write_message ('***** IGS_AD_TERM_UNITDTLS_PKG.INSERT_ROW *****');
942: igs_ad_term_unitdtls_pkg.insert_row (l_rowid,
943: l_unit_details_id,
944: p_term_unitdtls_record.term_details_id,
945: p_term_unitdtls_record.unit,
946: l_unit_difficulty,

Line 955: write_log ( 'After igs_ad_term_unitdtls_pkg.insert_row l_unit_details_id='

951: p_term_unitdtls_record.unit_grade_points
952: );
953: END IF;
954:
955: write_log ( 'After igs_ad_term_unitdtls_pkg.insert_row l_unit_details_id='
956: || l_unit_details_id,
957: 'igs.plsql.igs_da_trns_imp.create_term_unit_details'
958: );
959: p_term_unitdtls_record.unit_details_id := l_unit_details_id;

Line 1013: RETURN igs_ad_term_unitdtls.unit_details_id%TYPE

1009: p_person_id IN hz_parties.party_id%TYPE,
1010: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
1011: p_trans_cur_rec IN OUT NOCOPY trans_cur_rec
1012: )
1013: RETURN igs_ad_term_unitdtls.unit_details_id%TYPE
1014: AS
1015: l_unit_details_id igs_ad_term_unitdtls.unit_details_id%TYPE;
1016:
1017: CURSOR c_dup_cur

Line 1015: l_unit_details_id igs_ad_term_unitdtls.unit_details_id%TYPE;

1011: p_trans_cur_rec IN OUT NOCOPY trans_cur_rec
1012: )
1013: RETURN igs_ad_term_unitdtls.unit_details_id%TYPE
1014: AS
1015: l_unit_details_id igs_ad_term_unitdtls.unit_details_id%TYPE;
1016:
1017: CURSOR c_dup_cur
1018: IS
1019: SELECT unit_oss.ROWID, unit_oss.*

Line 1020: FROM igs_ad_term_unitdtls unit_oss

1016:
1017: CURSOR c_dup_cur
1018: IS
1019: SELECT unit_oss.ROWID, unit_oss.*
1020: FROM igs_ad_term_unitdtls unit_oss
1021: WHERE term_details_id = p_trans_cur_rec.term_details_id
1022: AND unit = p_trans_cur_rec.unit
1023: AND unit_name = p_trans_cur_rec.unit_name;
1024:

Line 1349: p_unit_name IN igs_ad_term_unitdtls.unit_name%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,
1349: p_unit_name IN igs_ad_term_unitdtls.unit_name%TYPE,
1350: p_inst_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
1351: p_inst_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE,
1352: p_cp_attempted IN igs_ad_term_unitdtls.cp_attempted%TYPE,
1353: p_cp_earned IN igs_ad_term_unitdtls.cp_earned%TYPE,

Line 1352: p_cp_attempted IN igs_ad_term_unitdtls.cp_attempted%TYPE,

1348: p_source_course_num IN VARCHAR2,
1349: p_unit_name IN igs_ad_term_unitdtls.unit_name%TYPE,
1350: p_inst_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
1351: p_inst_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE,
1352: p_cp_attempted IN igs_ad_term_unitdtls.cp_attempted%TYPE,
1353: p_cp_earned IN igs_ad_term_unitdtls.cp_earned%TYPE,
1354: p_grade IN igs_ad_term_unitdtls.grade%TYPE,
1355: p_unit_grade_points IN igs_ad_term_unitdtls.unit_grade_points%TYPE,
1356: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%TYPE

Line 1353: p_cp_earned IN igs_ad_term_unitdtls.cp_earned%TYPE,

1349: p_unit_name IN igs_ad_term_unitdtls.unit_name%TYPE,
1350: p_inst_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
1351: p_inst_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE,
1352: p_cp_attempted IN igs_ad_term_unitdtls.cp_attempted%TYPE,
1353: p_cp_earned IN igs_ad_term_unitdtls.cp_earned%TYPE,
1354: p_grade IN igs_ad_term_unitdtls.grade%TYPE,
1355: p_unit_grade_points IN igs_ad_term_unitdtls.unit_grade_points%TYPE,
1356: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%TYPE
1357: )

Line 1354: p_grade IN igs_ad_term_unitdtls.grade%TYPE,

1350: p_inst_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
1351: p_inst_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE,
1352: p_cp_attempted IN igs_ad_term_unitdtls.cp_attempted%TYPE,
1353: p_cp_earned IN igs_ad_term_unitdtls.cp_earned%TYPE,
1354: p_grade IN igs_ad_term_unitdtls.grade%TYPE,
1355: p_unit_grade_points IN igs_ad_term_unitdtls.unit_grade_points%TYPE,
1356: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%TYPE
1357: )
1358: AS

Line 1355: p_unit_grade_points IN igs_ad_term_unitdtls.unit_grade_points%TYPE,

1351: p_inst_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE,
1352: p_cp_attempted IN igs_ad_term_unitdtls.cp_attempted%TYPE,
1353: p_cp_earned IN igs_ad_term_unitdtls.cp_earned%TYPE,
1354: p_grade IN igs_ad_term_unitdtls.grade%TYPE,
1355: p_unit_grade_points IN igs_ad_term_unitdtls.unit_grade_points%TYPE,
1356: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%TYPE
1357: )
1358: AS
1359: l_return_status VARCHAR2 (1);

Line 1356: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%TYPE

1352: p_cp_attempted IN igs_ad_term_unitdtls.cp_attempted%TYPE,
1353: p_cp_earned IN igs_ad_term_unitdtls.cp_earned%TYPE,
1354: p_grade IN igs_ad_term_unitdtls.grade%TYPE,
1355: p_unit_grade_points IN igs_ad_term_unitdtls.unit_grade_points%TYPE,
1356: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%TYPE
1357: )
1358: AS
1359: l_return_status VARCHAR2 (1);
1360: l_trans_cur_rec trans_cur_rec;

Line 1361: l_unit igs_ad_term_unitdtls.unit%TYPE;

1357: )
1358: AS
1359: l_return_status VARCHAR2 (1);
1360: l_trans_cur_rec trans_cur_rec;
1361: l_unit igs_ad_term_unitdtls.unit%TYPE;
1362:
1363: CURSOR c_dup_cur
1364: IS
1365: SELECT trans_oss.ROWID, trans_oss.*

Line 2189: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%TYPE,

2185: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE,
2186: p_institution_cd IN igs_av_lgcy_unt_int.institution_cd%TYPE,
2187: p_person_id IN igs_pe_person.person_id%TYPE,
2188: p_auth_pers_id IN igs_pe_person.person_id%TYPE,
2189: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%TYPE,
2190: p_as_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
2191: p_prev_institution_code IN igs_ad_acad_history_v.institution_code%TYPE
2192: )
2193: RETURN BOOLEAN

Line 2322: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%TYPE,

2318: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE,
2319: p_achievable_credit_points IN igs_av_lgcy_unt_int.achievable_credit_points%TYPE,
2320: p_person_id IN igs_pe_person.person_id%TYPE,
2321: p_auth_pers_id IN igs_pe_person.person_id%TYPE,
2322: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%TYPE,
2323: p_as_version_number IN igs_en_stdnt_ps_att.version_number%TYPE,
2324: p_batch_id IN igs_da_rqst.batch_id%TYPE,
2325: p_prev_institution_code IN igs_ad_acad_history_v.institution_code%TYPE
2326: )

Line 2505: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%TYPE,

2501:
2502: FUNCTION create_post_unit (
2503: p_person_id IN igs_pe_person.person_id%TYPE,
2504: p_course_version IN igs_ps_ver.version_number%TYPE,
2505: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%TYPE,
2506: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
2507: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit
2508: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE,
2509: p_batch_id igs_da_rqst.batch_id%TYPE,

Line 2614: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%TYPE,

2610: END create_post_unit;
2611:
2612: PROCEDURE create_adv_stnd_unit (
2613: p_batch_id IN igs_da_rqst.batch_id%TYPE,
2614: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%TYPE,
2615: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
2616: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
2617: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
2618: p_load_cal_alt_code IN igs_av_lgcy_unt_int.load_cal_alt_code%TYPE,