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_RU_GEN_001 dependencies on IGS_AS_SU_SETATMPT

Line 1545: v_student_confirmed_ind IGS_AS_SU_SETATMPT.student_confirmed_ind%TYPE;

1541: FUNCTION susa_attribute (
1542: p_attribute IN VARCHAR2,
1543: p_tds IN r_tds )
1544: RETURN VARCHAR2 IS
1545: v_student_confirmed_ind IGS_AS_SU_SETATMPT.student_confirmed_ind%TYPE;
1546: v_end_dt IGS_AS_SU_SETATMPT.end_dt%TYPE;
1547: v_rqrmnts_complete_ind IGS_AS_SU_SETATMPT.rqrmnts_complete_ind%TYPE;
1548: v_primary_set_ind IGS_AS_SU_SETATMPT.primary_set_ind%TYPE;
1549: BEGIN

Line 1546: v_end_dt IGS_AS_SU_SETATMPT.end_dt%TYPE;

1542: p_attribute IN VARCHAR2,
1543: p_tds IN r_tds )
1544: RETURN VARCHAR2 IS
1545: v_student_confirmed_ind IGS_AS_SU_SETATMPT.student_confirmed_ind%TYPE;
1546: v_end_dt IGS_AS_SU_SETATMPT.end_dt%TYPE;
1547: v_rqrmnts_complete_ind IGS_AS_SU_SETATMPT.rqrmnts_complete_ind%TYPE;
1548: v_primary_set_ind IGS_AS_SU_SETATMPT.primary_set_ind%TYPE;
1549: BEGIN
1550: SELECT student_confirmed_ind,

Line 1547: v_rqrmnts_complete_ind IGS_AS_SU_SETATMPT.rqrmnts_complete_ind%TYPE;

1543: p_tds IN r_tds )
1544: RETURN VARCHAR2 IS
1545: v_student_confirmed_ind IGS_AS_SU_SETATMPT.student_confirmed_ind%TYPE;
1546: v_end_dt IGS_AS_SU_SETATMPT.end_dt%TYPE;
1547: v_rqrmnts_complete_ind IGS_AS_SU_SETATMPT.rqrmnts_complete_ind%TYPE;
1548: v_primary_set_ind IGS_AS_SU_SETATMPT.primary_set_ind%TYPE;
1549: BEGIN
1550: SELECT student_confirmed_ind,
1551: end_dt,

Line 1548: v_primary_set_ind IGS_AS_SU_SETATMPT.primary_set_ind%TYPE;

1544: RETURN VARCHAR2 IS
1545: v_student_confirmed_ind IGS_AS_SU_SETATMPT.student_confirmed_ind%TYPE;
1546: v_end_dt IGS_AS_SU_SETATMPT.end_dt%TYPE;
1547: v_rqrmnts_complete_ind IGS_AS_SU_SETATMPT.rqrmnts_complete_ind%TYPE;
1548: v_primary_set_ind IGS_AS_SU_SETATMPT.primary_set_ind%TYPE;
1549: BEGIN
1550: SELECT student_confirmed_ind,
1551: end_dt,
1552: rqrmnts_complete_ind,

Line 1558: FROM IGS_AS_SU_SETATMPT

1554: INTO v_student_confirmed_ind,
1555: v_end_dt,
1556: v_rqrmnts_complete_ind,
1557: v_primary_set_ind
1558: FROM IGS_AS_SU_SETATMPT
1559: WHERE person_id = p_person_id
1560: AND course_cd = p_course_cd
1561: AND unit_set_cd = p_tds.unit_cd
1562: AND us_version_number = p_tds.unit_version

Line 2863: FROM IGS_AS_SU_SETATMPT

2859: FOR SUSA IN (
2860: SELECT unit_set_cd,
2861: us_version_number,
2862: sequence_number
2863: FROM IGS_AS_SU_SETATMPT
2864: WHERE person_id = p_person_id
2865: AND course_cd = p_course_cd
2866: ORDER BY unit_set_cd,us_version_number,sequence_number )
2867: LOOP

Line 4474: CURSOR USET_CUR IS SELECT UNIT_SET_CD FROM IGS_AS_SU_SETATMPT WHERE PERSON_ID = P_PERSON_ID AND COURSE_CD = P_COURSE_CD;

4470: G.GROUP_ID = M.GROUP_ID AND SYSDATE BETWEEN M.START_DATE AND NVL(M.END_DATE, SYSDATE+1)
4471: AND M.PERSON_ID = P_PERSON_ID ;
4472:
4473: --Cursor to get all the unit sets attempted by the student
4474: CURSOR USET_CUR IS SELECT UNIT_SET_CD FROM IGS_AS_SU_SETATMPT WHERE PERSON_ID = P_PERSON_ID AND COURSE_CD = P_COURSE_CD;
4475:
4476: --Cursor to get the ceremony rounds of the student
4477: -- nalkumar ** CURSOR CUR_GRD_RND IS select rpad(GRD_CAL_TYPE,10)||rpad(GRD_CI_SEQUENCE_NUMBER,6) GRAD_ROUND from IGS_GR_AWD_CRMN WHERE PERSON_ID = P_PERSON_ID ;
4478: CURSOR CUR_GRD_RND IS select GRD_CAL_TYPE||GRD_CI_SEQUENCE_NUMBER GRAD_ROUND from IGS_GR_AWD_CRMN WHERE PERSON_ID = P_PERSON_ID ;

Line 4484: lv_Unit_set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE;

4480:
4481: lv_Group_id IGS_PE_PERSID_GROUP.GROUP_CD%TYPE;
4482: lv_progression_status IGS_EN_STDNT_PS_ATT_ALL.PROGRESSION_STATUS%TYPE;
4483: lv_org_unit IGS_PS_VER.RESPONSIBLE_ORG_UNIT_CD%TYPE;
4484: lv_Unit_set_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE;
4485: lv_att_type VARCHAR2(30);
4486: lv_class_standing varchar2(30);
4487:
4488: