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_HE_FTE_CALC_PKG dependencies on IGS_HE_ST_SPA

Line 644: student_inst_number igs_he_st_spa_all.student_inst_number%TYPE);

640: discontinued_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE,
641: course_rqrmnts_complete_dt igs_en_stdnt_ps_att_all.course_rqrmnts_complete_dt%TYPE,
642: commencement_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE,
643: course_rqrmnt_complete_ind igs_en_stdnt_ps_att_all.course_rqrmnt_complete_ind%TYPE,
644: student_inst_number igs_he_st_spa_all.student_inst_number%TYPE);
645: c_sca_rec spa_type;
646:
647: TYPE ref_spa IS REF CURSOR;
648: c_ref_spa ref_spa;

Line 950: l_old_person_id igs_he_st_spa_all.person_id%TYPE ;

946: sequence_number = cp_sequence_number ;
947: c_cal_inst_rec c_cal_inst%ROWTYPE ;
948:
949: -- smaddali added these variables and cursor for bug#3171373
950: l_old_person_id igs_he_st_spa_all.person_id%TYPE ;
951: l_old_stin igs_he_st_spa_all.student_inst_number%TYPE;
952: l_trn_commencement_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE ;
953:
954: -- Get the min commencement dt of the person with passed student instance number

Line 951: l_old_stin igs_he_st_spa_all.student_inst_number%TYPE;

947: c_cal_inst_rec c_cal_inst%ROWTYPE ;
948:
949: -- smaddali added these variables and cursor for bug#3171373
950: l_old_person_id igs_he_st_spa_all.person_id%TYPE ;
951: l_old_stin igs_he_st_spa_all.student_inst_number%TYPE;
952: l_trn_commencement_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE ;
953:
954: -- Get the min commencement dt of the person with passed student instance number
955: CURSOR c_trn_commencement( cp_person_id igs_he_st_spa_all.person_id%TYPE ,

Line 955: CURSOR c_trn_commencement( cp_person_id igs_he_st_spa_all.person_id%TYPE ,

951: l_old_stin igs_he_st_spa_all.student_inst_number%TYPE;
952: l_trn_commencement_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE ;
953:
954: -- Get the min commencement dt of the person with passed student instance number
955: CURSOR c_trn_commencement( cp_person_id igs_he_st_spa_all.person_id%TYPE ,
956: cp_stin igs_he_st_spa_all.student_inst_number%TYPE) IS
957: SELECT MIN(sca.commencement_dt) trn_commencement_dt
958: FROM igs_en_stdnt_ps_att sca,
959: igs_he_st_spa hspa

Line 956: cp_stin igs_he_st_spa_all.student_inst_number%TYPE) IS

952: l_trn_commencement_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE ;
953:
954: -- Get the min commencement dt of the person with passed student instance number
955: CURSOR c_trn_commencement( cp_person_id igs_he_st_spa_all.person_id%TYPE ,
956: cp_stin igs_he_st_spa_all.student_inst_number%TYPE) IS
957: SELECT MIN(sca.commencement_dt) trn_commencement_dt
958: FROM igs_en_stdnt_ps_att sca,
959: igs_he_st_spa hspa
960: WHERE hspa.person_id = cp_person_id

Line 959: igs_he_st_spa hspa

955: CURSOR c_trn_commencement( cp_person_id igs_he_st_spa_all.person_id%TYPE ,
956: cp_stin igs_he_st_spa_all.student_inst_number%TYPE) IS
957: SELECT MIN(sca.commencement_dt) trn_commencement_dt
958: FROM igs_en_stdnt_ps_att sca,
959: igs_he_st_spa hspa
960: WHERE hspa.person_id = cp_person_id
961: AND hspa.student_inst_number = cp_stin
962: AND sca.person_id = hspa.person_id
963: AND sca.course_cd = hspa.course_cd;

Line 1085: fnd_dsql.add_text(' FROM igs_en_stdnt_ps_att_all spa, igs_he_st_spa_all hspa, igs_pe_person_base_v pe ');

1081: fnd_dsql.add_text('SELECT pe.person_number,spa.person_id, spa.course_cd ,spa.version_number,spa.coo_id,');
1082: fnd_dsql.add_text(' spa.course_attempt_status, spa.discontinued_dt,');
1083: fnd_dsql.add_text(' spa.course_rqrmnts_complete_dt, spa.commencement_dt,');
1084: fnd_dsql.add_text(' spa.course_rqrmnt_complete_ind, hspa.student_inst_number');
1085: fnd_dsql.add_text(' FROM igs_en_stdnt_ps_att_all spa, igs_he_st_spa_all hspa, igs_pe_person_base_v pe ');
1086: fnd_dsql.add_text(' WHERE hspa.person_id = spa.person_id ');
1087: fnd_dsql.add_text(' AND hspa.course_cd = spa.course_cd ');
1088: fnd_dsql.add_text(' AND pe.person_id = spa.person_id ');
1089: