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_VAL_SUA dependencies on IGS_AD_ADM_UNIT_STAT

Line 1404: v_closed_ind IGS_AD_ADM_UNIT_STAT.closed_ind%TYPE;

1400:
1401: BEGIN
1402: DECLARE
1403: v_other_detail VARCHAR2(255);
1404: v_closed_ind IGS_AD_ADM_UNIT_STAT.closed_ind%TYPE;
1405: v_unit_attempt_status IGS_AD_ADM_UNIT_STAT.unit_attempt_status%TYPE;
1406: v_alias_val DATE;
1407: v_admin_unit_status_str VARCHAR2(2000);
1408: v_first_char NUMBER;

Line 1405: v_unit_attempt_status IGS_AD_ADM_UNIT_STAT.unit_attempt_status%TYPE;

1401: BEGIN
1402: DECLARE
1403: v_other_detail VARCHAR2(255);
1404: v_closed_ind IGS_AD_ADM_UNIT_STAT.closed_ind%TYPE;
1405: v_unit_attempt_status IGS_AD_ADM_UNIT_STAT.unit_attempt_status%TYPE;
1406: v_alias_val DATE;
1407: v_admin_unit_status_str VARCHAR2(2000);
1408: v_first_char NUMBER;
1409: v_grading_schema_cd IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE;

Line 1413: v_current_string IGS_AD_ADM_UNIT_STAT.administrative_unit_status%TYPE;

1409: v_grading_schema_cd IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE;
1410: v_version_number IGS_AS_GRD_SCHEMA.version_number%TYPE;
1411: v_message_name varchar2(30);
1412: v_string_found BOOLEAN := FALSE;
1413: v_current_string IGS_AD_ADM_UNIT_STAT.administrative_unit_status%TYPE;
1414: v_administrative_unit_status VARCHAR2(2000);
1415: v_admin_entered IGS_AD_ADM_UNIT_STAT.administrative_unit_status%TYPE;
1416: CURSOR c_aus IS
1417: SELECT closed_ind,

Line 1415: v_admin_entered IGS_AD_ADM_UNIT_STAT.administrative_unit_status%TYPE;

1411: v_message_name varchar2(30);
1412: v_string_found BOOLEAN := FALSE;
1413: v_current_string IGS_AD_ADM_UNIT_STAT.administrative_unit_status%TYPE;
1414: v_administrative_unit_status VARCHAR2(2000);
1415: v_admin_entered IGS_AD_ADM_UNIT_STAT.administrative_unit_status%TYPE;
1416: CURSOR c_aus IS
1417: SELECT closed_ind,
1418: unit_attempt_status
1419: FROM IGS_AD_ADM_UNIT_STAT

Line 1419: FROM IGS_AD_ADM_UNIT_STAT

1415: v_admin_entered IGS_AD_ADM_UNIT_STAT.administrative_unit_status%TYPE;
1416: CURSOR c_aus IS
1417: SELECT closed_ind,
1418: unit_attempt_status
1419: FROM IGS_AD_ADM_UNIT_STAT
1420: WHERE administrative_unit_status = p_administrative_unit_status;
1421: BEGIN
1422: -- This module validates the
1423: -- IGS_EN_SU_ATTEMPT.administrative_unit_status

Line 1609: FROM IGS_AD_ADM_UNIT_STAT

1605: ausg.administrative_unit_status = p_administrative_unit_status;
1606: v_grading_schema_dtls t_schema_dtls;
1607: CURSOR c_aus IS
1608: SELECT unit_attempt_status
1609: FROM IGS_AD_ADM_UNIT_STAT
1610: WHERE administrative_unit_status = p_administrative_unit_status;
1611: l_status VARCHAR2(10);
1612: BEGIN
1613: --- Set the default message number

Line 1883: v_unit_attempt_status IGS_AD_ADM_UNIT_STAT.unit_attempt_status%TYPE;

1879: RETURN BOOLEAN AS
1880: BEGIN
1881: DECLARE
1882:
1883: v_unit_attempt_status IGS_AD_ADM_UNIT_STAT.unit_attempt_status%TYPE;
1884: v_s_unit_status IGS_AD_ADM_UNIT_STAT.unit_attempt_status%TYPE;
1885: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
1886: CURSOR c_uas IS
1887: SELECT unit_attempt_status

Line 1884: v_s_unit_status IGS_AD_ADM_UNIT_STAT.unit_attempt_status%TYPE;

1880: BEGIN
1881: DECLARE
1882:
1883: v_unit_attempt_status IGS_AD_ADM_UNIT_STAT.unit_attempt_status%TYPE;
1884: v_s_unit_status IGS_AD_ADM_UNIT_STAT.unit_attempt_status%TYPE;
1885: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
1886: CURSOR c_uas IS
1887: SELECT unit_attempt_status
1888: FROM IGS_AD_ADM_UNIT_STAT

Line 1888: FROM IGS_AD_ADM_UNIT_STAT

1884: v_s_unit_status IGS_AD_ADM_UNIT_STAT.unit_attempt_status%TYPE;
1885: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
1886: CURSOR c_uas IS
1887: SELECT unit_attempt_status
1888: FROM IGS_AD_ADM_UNIT_STAT
1889: WHERE administrative_unit_status = p_administrative_unit_status;
1890: CURSOR c_uvus IS
1891: SELECT us.s_unit_status
1892: FROM IGS_PS_UNIT_VER uv,