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_PR_VAL_SPO dependencies on IGS_EN_STDNT_PS_ATT

Line 375: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

371: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
372: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
373: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
374: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
375: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
376: v_outcome_check_type VARCHAR2(10);
377: CURSOR c_sca IS
378: SELECT sca.version_number
379: FROM IGS_EN_STDNT_PS_ATT sca

Line 379: FROM IGS_EN_STDNT_PS_ATT sca

375: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
376: v_outcome_check_type VARCHAR2(10);
377: CURSOR c_sca IS
378: SELECT sca.version_number
379: FROM IGS_EN_STDNT_PS_ATT sca
380: WHERE sca.person_id = p_person_id AND
381: sca.course_cd = p_course_cd;
382: BEGIN
383: p_message_name := null;

Line 503: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

499: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
500: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
501: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
502: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
503: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
504: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
505: v_outcome_check_type VARCHAR2(10);
506: CURSOR c_sca IS
507: SELECT sca.version_number

Line 508: FROM IGS_EN_STDNT_PS_ATT sca

504: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
505: v_outcome_check_type VARCHAR2(10);
506: CURSOR c_sca IS
507: SELECT sca.version_number
508: FROM IGS_EN_STDNT_PS_ATT sca
509: WHERE sca.person_id = p_person_id AND
510: sca.course_cd = p_course_cd;
511: CURSOR c_daiv
512: (cp_shw_cse_ctoff_dt_alias IGS_PR_S_PRG_CONF.show_cause_cutoff_dt_alias%TYPE) IS

Line 702: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

698: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
699: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
700: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
701: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
702: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
703: v_outcome_check_type VARCHAR2(10);
704: CURSOR c_sca IS
705: SELECT sca.version_number
706: FROM IGS_EN_STDNT_PS_ATT sca

Line 706: FROM IGS_EN_STDNT_PS_ATT sca

702: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
703: v_outcome_check_type VARCHAR2(10);
704: CURSOR c_sca IS
705: SELECT sca.version_number
706: FROM IGS_EN_STDNT_PS_ATT sca
707: WHERE sca.person_id = p_person_id AND
708: sca.course_cd = p_course_cd;
709: BEGIN
710: p_message_name := null;

Line 824: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

820: v_count_sus_in_time_ind IGS_PR_S_PRG_CONF.count_sus_in_time_ind%TYPE;
821: v_count_exc_in_time_ind IGS_PR_S_PRG_CONF.count_exc_in_time_ind%TYPE;
822: v_calculate_wam_ind IGS_PR_S_PRG_CONF.calculate_wam_ind%TYPE;
823: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
824: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
825: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
826: v_outcome_check_type VARCHAR2(10);
827: CURSOR c_sca IS
828: SELECT sca.version_number

Line 829: FROM IGS_EN_STDNT_PS_ATT sca

825: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;
826: v_outcome_check_type VARCHAR2(10);
827: CURSOR c_sca IS
828: SELECT sca.version_number
829: FROM IGS_EN_STDNT_PS_ATT sca
830: WHERE sca.person_id = p_person_id AND
831: sca.course_cd = p_course_cd;
832: CURSOR c_daiv (cp_apl_ctoff_dt_alias IGS_PR_S_PRG_CONF.appeal_cutoff_dt_alias%TYPE) IS
833: SELECT MAX(daiv.alias_val)

Line 1189: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

1185: cst_lapsed CONSTANT VARCHAR2(10) := 'LAPSED';
1186: cst_discontin CONSTANT VARCHAR2(10) := 'DISCONTIN';
1187: v_s_progression_outcome_type
1188: IGS_PR_OU_TYPE.s_progression_outcome_type%TYPE;
1189: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
1190: v_passed_ind IGS_PR_SDT_PR_RU_CK.passed_ind%TYPE;
1191: v_dummy VARCHAR2(1);
1192: CURSOR c_sca IS
1193: SELECT course_attempt_status

Line 1194: FROM IGS_EN_STDNT_PS_ATT sca

1190: v_passed_ind IGS_PR_SDT_PR_RU_CK.passed_ind%TYPE;
1191: v_dummy VARCHAR2(1);
1192: CURSOR c_sca IS
1193: SELECT course_attempt_status
1194: FROM IGS_EN_STDNT_PS_ATT sca
1195: WHERE person_id = p_person_id AND
1196: course_cd = p_course_cd;
1197: CURSOR c_spra1 IS
1198: SELECT passed_ind

Line 1742: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

1738: v_dummy VARCHAR2(1);
1739: v_expiry_dt IGS_PR_STDNT_PR_OU.expiry_dt%TYPE;
1740: v_exit BOOLEAN DEFAULT FALSE;
1741: v_apply_automatically_ind VARCHAR2(1);
1742: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
1743: CURSOR c_sca IS
1744: SELECT course_attempt_status
1745: FROM IGS_EN_STDNT_PS_ATT
1746: WHERE person_id = p_person_id AND

Line 1745: FROM IGS_EN_STDNT_PS_ATT

1741: v_apply_automatically_ind VARCHAR2(1);
1742: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
1743: CURSOR c_sca IS
1744: SELECT course_attempt_status
1745: FROM IGS_EN_STDNT_PS_ATT
1746: WHERE person_id = p_person_id AND
1747: course_cd = p_course_cd;
1748: CURSOR c_pot_etde IS
1749: SELECT etde.s_encmb_effect_type

Line 2008: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

2004: DECLARE
2005: cst_cancelled CONSTANT VARCHAR2(10) := 'CANCELLED';
2006: cst_removed CONSTANT VARCHAR2(10) := 'REMOVED';
2007: cst_approved CONSTANT VARCHAR2(10) := 'APPROVED';
2008: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
2009: v_apply_start_dt_alias IGS_PR_S_PRG_CONF.apply_start_dt_alias%TYPE;
2010: v_apply_end_dt_alias IGS_PR_S_PRG_CONF.apply_end_dt_alias%TYPE;
2011: v_end_benefit_dt_alias IGS_PR_S_PRG_CONF.end_benefit_dt_alias%TYPE;
2012: v_end_penalty_dt_alias IGS_PR_S_PRG_CONF.end_penalty_dt_alias%TYPE;

Line 2026: FROM IGS_EN_STDNT_PS_ATT sca

2022: v_calculate_gpa_ind IGS_PR_S_PRG_CONF.calculate_gpa_ind%TYPE;
2023: v_outcome_check_type VARCHAR2(10);
2024: CURSOR c_sca IS
2025: SELECT sca.version_number
2026: FROM IGS_EN_STDNT_PS_ATT sca
2027: WHERE sca.person_id = p_person_id AND
2028: sca.course_cd = p_course_cd;
2029: BEGIN
2030: -- Set the default message number

Line 2144: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

2140: -- Validate the IGS_PR_STDNT_PR_OU show cause details.
2141: -- If show cause not allowed then show_cause_expiry_dt, show_cause_dt,
2142: -- show_cause_outcome_dt and show_cause_outcome_type cannot be set.
2143: DECLARE
2144: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
2145: CURSOR c_sca IS
2146: SELECT sca.version_number
2147: FROM IGS_EN_STDNT_PS_ATT sca
2148: WHERE sca.person_id = p_person_id AND

Line 2147: FROM IGS_EN_STDNT_PS_ATT sca

2143: DECLARE
2144: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
2145: CURSOR c_sca IS
2146: SELECT sca.version_number
2147: FROM IGS_EN_STDNT_PS_ATT sca
2148: WHERE sca.person_id = p_person_id AND
2149: sca.course_cd = p_course_cd;
2150: BEGIN
2151: p_message_name := null;

Line 2209: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

2205: -- Validate the IGS_PR_STDNT_PR_OU appeal details.
2206: -- If appeal not allowed then appeal_expiry_dt, appeal_dt,
2207: -- appeal_outcome_dt and appeal_outcome_type cannot be set.
2208: DECLARE
2209: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
2210: CURSOR c_sca IS
2211: SELECT sca.version_number
2212: FROM IGS_EN_STDNT_PS_ATT sca
2213: WHERE sca.person_id = p_person_id AND

Line 2212: FROM IGS_EN_STDNT_PS_ATT sca

2208: DECLARE
2209: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
2210: CURSOR c_sca IS
2211: SELECT sca.version_number
2212: FROM IGS_EN_STDNT_PS_ATT sca
2213: WHERE sca.person_id = p_person_id AND
2214: sca.course_cd = p_course_cd;
2215: BEGIN
2216: p_message_name := null;