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_EN_SPA_LGCY_PUB dependencies on IGS_EN_STDNT_PS_ATT_ALL

Line 578: p_course_att_status IN igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,

574: END IF;
575: END validate_sca_db_cons;
576:
577: FUNCTION validate_sca(p_person_id IN igs_pe_person.person_id%TYPE,
578: p_course_att_status IN igs_en_stdnt_ps_att_all.course_attempt_status%TYPE,
579: p_course_type IN igs_ps_ver_all.course_type%TYPE,
580: p_career_flag IN VARCHAR2,
581: p_sca_re_rec IN SCA_RE_REC_TYPE)
582: RETURN BOOLEAN AS

Line 902: l_course_att_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE;

898: l_career_flag VARCHAR2(1);
899: l_person_id igs_pe_person.person_id%TYPE;
900: l_course_type igs_ps_ver_all.course_type%TYPE;
901: l_coo_id igs_ps_ofr_opt_all.coo_id%TYPE;
902: l_course_att_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE;
903: l_igs_pr_class_std_id igs_en_stdnt_ps_att_all.igs_pr_class_std_id%TYPE;
904: l_catalog_cal_type igs_en_stdnt_ps_att_all.catalog_cal_type%TYPE;
905: l_catalog_seq_num igs_en_stdnt_ps_att_all.catalog_seq_num%TYPE;
906: l_dropped_by igs_en_stdnt_ps_att_all.dropped_by%TYPE;

Line 903: l_igs_pr_class_std_id igs_en_stdnt_ps_att_all.igs_pr_class_std_id%TYPE;

899: l_person_id igs_pe_person.person_id%TYPE;
900: l_course_type igs_ps_ver_all.course_type%TYPE;
901: l_coo_id igs_ps_ofr_opt_all.coo_id%TYPE;
902: l_course_att_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE;
903: l_igs_pr_class_std_id igs_en_stdnt_ps_att_all.igs_pr_class_std_id%TYPE;
904: l_catalog_cal_type igs_en_stdnt_ps_att_all.catalog_cal_type%TYPE;
905: l_catalog_seq_num igs_en_stdnt_ps_att_all.catalog_seq_num%TYPE;
906: l_dropped_by igs_en_stdnt_ps_att_all.dropped_by%TYPE;
907: l_catalog_start_dt DATE;

Line 904: l_catalog_cal_type igs_en_stdnt_ps_att_all.catalog_cal_type%TYPE;

900: l_course_type igs_ps_ver_all.course_type%TYPE;
901: l_coo_id igs_ps_ofr_opt_all.coo_id%TYPE;
902: l_course_att_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE;
903: l_igs_pr_class_std_id igs_en_stdnt_ps_att_all.igs_pr_class_std_id%TYPE;
904: l_catalog_cal_type igs_en_stdnt_ps_att_all.catalog_cal_type%TYPE;
905: l_catalog_seq_num igs_en_stdnt_ps_att_all.catalog_seq_num%TYPE;
906: l_dropped_by igs_en_stdnt_ps_att_all.dropped_by%TYPE;
907: l_catalog_start_dt DATE;
908: l_catalog_end_dt DATE;

Line 905: l_catalog_seq_num igs_en_stdnt_ps_att_all.catalog_seq_num%TYPE;

901: l_coo_id igs_ps_ofr_opt_all.coo_id%TYPE;
902: l_course_att_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE;
903: l_igs_pr_class_std_id igs_en_stdnt_ps_att_all.igs_pr_class_std_id%TYPE;
904: l_catalog_cal_type igs_en_stdnt_ps_att_all.catalog_cal_type%TYPE;
905: l_catalog_seq_num igs_en_stdnt_ps_att_all.catalog_seq_num%TYPE;
906: l_dropped_by igs_en_stdnt_ps_att_all.dropped_by%TYPE;
907: l_catalog_start_dt DATE;
908: l_catalog_end_dt DATE;
909: l_sequence_number igs_re_candidature_all.sequence_number%TYPE;

Line 906: l_dropped_by igs_en_stdnt_ps_att_all.dropped_by%TYPE;

902: l_course_att_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE;
903: l_igs_pr_class_std_id igs_en_stdnt_ps_att_all.igs_pr_class_std_id%TYPE;
904: l_catalog_cal_type igs_en_stdnt_ps_att_all.catalog_cal_type%TYPE;
905: l_catalog_seq_num igs_en_stdnt_ps_att_all.catalog_seq_num%TYPE;
906: l_dropped_by igs_en_stdnt_ps_att_all.dropped_by%TYPE;
907: l_catalog_start_dt DATE;
908: l_catalog_end_dt DATE;
909: l_sequence_number igs_re_candidature_all.sequence_number%TYPE;
910: l_status VARCHAR2(20);

Line 912: l_request_id igs_en_stdnt_ps_att_all.request_id%TYPE;

908: l_catalog_end_dt DATE;
909: l_sequence_number igs_re_candidature_all.sequence_number%TYPE;
910: l_status VARCHAR2(20);
911: l_sca_re_rec SCA_RE_REC_TYPE;
912: l_request_id igs_en_stdnt_ps_att_all.request_id%TYPE;
913: l_program_id igs_en_stdnt_ps_att_all.program_id%TYPE;
914: l_program_application_id igs_en_stdnt_ps_att_all.program_application_id%TYPE;
915: l_program_update_date igs_en_stdnt_ps_att_all.program_update_date%TYPE;
916: l_research_type_ind igs_ps_type.research_type_ind%TYPE;

Line 913: l_program_id igs_en_stdnt_ps_att_all.program_id%TYPE;

909: l_sequence_number igs_re_candidature_all.sequence_number%TYPE;
910: l_status VARCHAR2(20);
911: l_sca_re_rec SCA_RE_REC_TYPE;
912: l_request_id igs_en_stdnt_ps_att_all.request_id%TYPE;
913: l_program_id igs_en_stdnt_ps_att_all.program_id%TYPE;
914: l_program_application_id igs_en_stdnt_ps_att_all.program_application_id%TYPE;
915: l_program_update_date igs_en_stdnt_ps_att_all.program_update_date%TYPE;
916: l_research_type_ind igs_ps_type.research_type_ind%TYPE;
917:

Line 914: l_program_application_id igs_en_stdnt_ps_att_all.program_application_id%TYPE;

910: l_status VARCHAR2(20);
911: l_sca_re_rec SCA_RE_REC_TYPE;
912: l_request_id igs_en_stdnt_ps_att_all.request_id%TYPE;
913: l_program_id igs_en_stdnt_ps_att_all.program_id%TYPE;
914: l_program_application_id igs_en_stdnt_ps_att_all.program_application_id%TYPE;
915: l_program_update_date igs_en_stdnt_ps_att_all.program_update_date%TYPE;
916: l_research_type_ind igs_ps_type.research_type_ind%TYPE;
917:
918: BEGIN --Begin of create_spa

Line 915: l_program_update_date igs_en_stdnt_ps_att_all.program_update_date%TYPE;

911: l_sca_re_rec SCA_RE_REC_TYPE;
912: l_request_id igs_en_stdnt_ps_att_all.request_id%TYPE;
913: l_program_id igs_en_stdnt_ps_att_all.program_id%TYPE;
914: l_program_application_id igs_en_stdnt_ps_att_all.program_application_id%TYPE;
915: l_program_update_date igs_en_stdnt_ps_att_all.program_update_date%TYPE;
916: l_research_type_ind igs_ps_type.research_type_ind%TYPE;
917:
918: BEGIN --Begin of create_spa
919:

Line 1109: INSERT INTO igs_en_stdnt_ps_att_all(

1105: --Note:Following columns are not populating as they are obsoleted in the data model
1106: -- derived_att_mode, derived_att_type, logical_delete_dt, derived_completion_yr,
1107: -- derived_completiod_perd, override_time_limitation
1108: -- progression_status and last_date_of_attendance column would be derived while improting the unit atttempt details.
1109: INSERT INTO igs_en_stdnt_ps_att_all(
1110: person_id,
1111: course_cd,
1112: version_number,
1113: cal_type,