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_EN_STDNT_PS_ATT

Line 635: person_id igs_en_stdnt_ps_att_all.person_id%TYPE,

631: l_fte_calc_sql VARCHAR2(32767);
632:
633: TYPE spa_type IS RECORD
634: (person_number hz_parties.party_number%TYPE,
635: person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
636: course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
637: version_number igs_en_stdnt_ps_att_all.version_number%TYPE,
638: coo_id igs_en_stdnt_ps_att_all.coo_id%TYPE,
639: course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,

Line 636: course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,

632:
633: TYPE spa_type IS RECORD
634: (person_number hz_parties.party_number%TYPE,
635: person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
636: course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
637: version_number igs_en_stdnt_ps_att_all.version_number%TYPE,
638: coo_id igs_en_stdnt_ps_att_all.coo_id%TYPE,
639: course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
640: discontinued_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE,

Line 637: version_number igs_en_stdnt_ps_att_all.version_number%TYPE,

633: TYPE spa_type IS RECORD
634: (person_number hz_parties.party_number%TYPE,
635: person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
636: course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
637: version_number igs_en_stdnt_ps_att_all.version_number%TYPE,
638: coo_id igs_en_stdnt_ps_att_all.coo_id%TYPE,
639: course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%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,

Line 638: coo_id igs_en_stdnt_ps_att_all.coo_id%TYPE,

634: (person_number hz_parties.party_number%TYPE,
635: person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
636: course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
637: version_number igs_en_stdnt_ps_att_all.version_number%TYPE,
638: coo_id igs_en_stdnt_ps_att_all.coo_id%TYPE,
639: course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%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,

Line 639: course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,

635: person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
636: course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
637: version_number igs_en_stdnt_ps_att_all.version_number%TYPE,
638: coo_id igs_en_stdnt_ps_att_all.coo_id%TYPE,
639: course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%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,

Line 640: discontinued_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE,

636: course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE,
637: version_number igs_en_stdnt_ps_att_all.version_number%TYPE,
638: coo_id igs_en_stdnt_ps_att_all.coo_id%TYPE,
639: course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%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);

Line 641: course_rqrmnts_complete_dt igs_en_stdnt_ps_att_all.course_rqrmnts_complete_dt%TYPE,

637: version_number igs_en_stdnt_ps_att_all.version_number%TYPE,
638: coo_id igs_en_stdnt_ps_att_all.coo_id%TYPE,
639: course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%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;

Line 642: commencement_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE,

638: coo_id igs_en_stdnt_ps_att_all.coo_id%TYPE,
639: course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%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:

Line 643: course_rqrmnt_complete_ind igs_en_stdnt_ps_att_all.course_rqrmnt_complete_ind%TYPE,

639: course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%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;

Line 802: igs_en_stdnt_ps_att_all sca,

798: SELECT ci.cal_type, ci.sequence_number, ci.start_dt, ci.end_dt
799: FROM igs_ca_inst ci,
800: igs_ca_type cat,
801: igs_ca_stat cs,
802: igs_en_stdnt_ps_att_all sca,
803: igs_as_su_setatmpt susa
804: WHERE sca.person_id = susa.person_id
805: AND sca.course_cd = susa.course_cd
806: AND sca.cal_type = ci.cal_type

Line 952: l_trn_commencement_dt igs_en_stdnt_ps_att_all.commencement_dt%TYPE ;

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 ,
956: cp_stin igs_he_st_spa_all.student_inst_number%TYPE) IS

Line 958: FROM igs_en_stdnt_ps_att sca,

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
961: AND hspa.student_inst_number = cp_stin
962: AND sca.person_id = hspa.person_id

Line 1007: l_lev_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE ;

1003: tr.program_cd = cp_course_cd AND
1004: ca.start_dt BETWEEN p_fte_start_dt AND p_fte_end_dt
1005: ORDER BY ca.start_dt DESC;
1006: c_term_con_rec c_term_con%ROWTYPE ;
1007: l_lev_dt igs_en_stdnt_ps_att_all.discontinued_dt%TYPE ;
1008:
1009: -- Check if the passed course version belongs to the course category parameter
1010: CURSOR c_prg_cat ( cp_course_cd igs_ps_ver_all.course_cd%TYPE,
1011: cp_version_number igs_ps_ver_all.version_number%TYPE ) IS

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: