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

Line 2400: CURSOR c_get_dest_unitset_att (c_person_id IN IGS_AS_SU_SETATMPT.person_id%TYPE,

2396: l_status BOOLEAN;
2397: l_status1 BOOLEAN;
2398: l_status2 BOOLEAN;
2399: l_error_occured BOOLEAN;
2400: CURSOR c_get_dest_unitset_att (c_person_id IN IGS_AS_SU_SETATMPT.person_id%TYPE,
2401: c_course_cd IN IGS_AS_SU_SETATMPT.course_cd%TYPE,
2402: c_unit_set_cd IN IGS_AS_SU_SETATMPT.unit_set_cd%TYPE) IS
2403: SELECT *
2404: FROM IGS_AS_SU_SETATMPT

Line 2401: c_course_cd IN IGS_AS_SU_SETATMPT.course_cd%TYPE,

2397: l_status1 BOOLEAN;
2398: l_status2 BOOLEAN;
2399: l_error_occured BOOLEAN;
2400: CURSOR c_get_dest_unitset_att (c_person_id IN IGS_AS_SU_SETATMPT.person_id%TYPE,
2401: c_course_cd IN IGS_AS_SU_SETATMPT.course_cd%TYPE,
2402: c_unit_set_cd IN IGS_AS_SU_SETATMPT.unit_set_cd%TYPE) IS
2403: SELECT *
2404: FROM IGS_AS_SU_SETATMPT
2405: WHERE person_id = c_person_id AND

Line 2402: c_unit_set_cd IN IGS_AS_SU_SETATMPT.unit_set_cd%TYPE) IS

2398: l_status2 BOOLEAN;
2399: l_error_occured BOOLEAN;
2400: CURSOR c_get_dest_unitset_att (c_person_id IN IGS_AS_SU_SETATMPT.person_id%TYPE,
2401: c_course_cd IN IGS_AS_SU_SETATMPT.course_cd%TYPE,
2402: c_unit_set_cd IN IGS_AS_SU_SETATMPT.unit_set_cd%TYPE) IS
2403: SELECT *
2404: FROM IGS_AS_SU_SETATMPT
2405: WHERE person_id = c_person_id AND
2406: course_cd = c_course_cd AND

Line 2404: FROM IGS_AS_SU_SETATMPT

2400: CURSOR c_get_dest_unitset_att (c_person_id IN IGS_AS_SU_SETATMPT.person_id%TYPE,
2401: c_course_cd IN IGS_AS_SU_SETATMPT.course_cd%TYPE,
2402: c_unit_set_cd IN IGS_AS_SU_SETATMPT.unit_set_cd%TYPE) IS
2403: SELECT *
2404: FROM IGS_AS_SU_SETATMPT
2405: WHERE person_id = c_person_id AND
2406: course_cd = c_course_cd AND
2407: unit_set_cd = c_unit_set_cd;
2408: CURSOR c_get_unitset_att ( c_person_id IN IGS_AS_SU_SETATMPT.person_id%TYPE,

Line 2408: CURSOR c_get_unitset_att ( c_person_id IN IGS_AS_SU_SETATMPT.person_id%TYPE,

2404: FROM IGS_AS_SU_SETATMPT
2405: WHERE person_id = c_person_id AND
2406: course_cd = c_course_cd AND
2407: unit_set_cd = c_unit_set_cd;
2408: CURSOR c_get_unitset_att ( c_person_id IN IGS_AS_SU_SETATMPT.person_id%TYPE,
2409: c_course_cd IN IGS_AS_SU_SETATMPT.course_cd%TYPE,
2410: c_unit_set_cd IN IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
2411: c_sequence_number IN IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS
2412: SELECT *

Line 2409: c_course_cd IN IGS_AS_SU_SETATMPT.course_cd%TYPE,

2405: WHERE person_id = c_person_id AND
2406: course_cd = c_course_cd AND
2407: unit_set_cd = c_unit_set_cd;
2408: CURSOR c_get_unitset_att ( c_person_id IN IGS_AS_SU_SETATMPT.person_id%TYPE,
2409: c_course_cd IN IGS_AS_SU_SETATMPT.course_cd%TYPE,
2410: c_unit_set_cd IN IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
2411: c_sequence_number IN IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS
2412: SELECT *
2413: FROM IGS_AS_SU_SETATMPT

Line 2410: c_unit_set_cd IN IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,

2406: course_cd = c_course_cd AND
2407: unit_set_cd = c_unit_set_cd;
2408: CURSOR c_get_unitset_att ( c_person_id IN IGS_AS_SU_SETATMPT.person_id%TYPE,
2409: c_course_cd IN IGS_AS_SU_SETATMPT.course_cd%TYPE,
2410: c_unit_set_cd IN IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
2411: c_sequence_number IN IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS
2412: SELECT *
2413: FROM IGS_AS_SU_SETATMPT
2414: WHERE person_id = c_person_id AND

Line 2411: c_sequence_number IN IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS

2407: unit_set_cd = c_unit_set_cd;
2408: CURSOR c_get_unitset_att ( c_person_id IN IGS_AS_SU_SETATMPT.person_id%TYPE,
2409: c_course_cd IN IGS_AS_SU_SETATMPT.course_cd%TYPE,
2410: c_unit_set_cd IN IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
2411: c_sequence_number IN IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS
2412: SELECT *
2413: FROM IGS_AS_SU_SETATMPT
2414: WHERE person_id = c_person_id AND
2415: course_cd = c_course_cd AND

Line 2413: FROM IGS_AS_SU_SETATMPT

2409: c_course_cd IN IGS_AS_SU_SETATMPT.course_cd%TYPE,
2410: c_unit_set_cd IN IGS_AS_SU_SETATMPT.unit_set_cd%TYPE,
2411: c_sequence_number IN IGS_AS_SU_SETATMPT.sequence_number%TYPE) IS
2412: SELECT *
2413: FROM IGS_AS_SU_SETATMPT
2414: WHERE person_id = c_person_id AND
2415: course_cd = c_course_cd AND
2416: unit_set_cd = c_unit_set_cd AND
2417: sequence_number = c_sequence_number ;

Line 3720: c_unitset_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE,

3716: -------------------------------------------------------------------------------------------
3717:
3718: CURSOR c_parent_exist (c_person_id IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE,
3719: c_program_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE,
3720: c_unitset_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE,
3721: c_seq_no IGS_AS_SU_SETATMPT.SEQUENCE_NUMBER%TYPE)
3722: IS
3723: SELECT 'x' FROM igs_as_su_setatmpt
3724: WHERE person_id = c_person_id

Line 3721: c_seq_no IGS_AS_SU_SETATMPT.SEQUENCE_NUMBER%TYPE)

3717:
3718: CURSOR c_parent_exist (c_person_id IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE,
3719: c_program_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE,
3720: c_unitset_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE,
3721: c_seq_no IGS_AS_SU_SETATMPT.SEQUENCE_NUMBER%TYPE)
3722: IS
3723: SELECT 'x' FROM igs_as_su_setatmpt
3724: WHERE person_id = c_person_id
3725: AND COURSE_CD = c_program_cd

Line 3723: SELECT 'x' FROM igs_as_su_setatmpt

3719: c_program_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE,
3720: c_unitset_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE,
3721: c_seq_no IGS_AS_SU_SETATMPT.SEQUENCE_NUMBER%TYPE)
3722: IS
3723: SELECT 'x' FROM igs_as_su_setatmpt
3724: WHERE person_id = c_person_id
3725: AND COURSE_CD = c_program_cd
3726: AND UNIT_SET_CD = c_unitset_cd
3727: AND SEQUENCE_NUMBER= c_seq_no

Line 3732: c_unitset_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE,

3728: AND PARENT_UNIT_SET_CD IS NOT NULL;
3729:
3730: CURSOR c_get_child (c_person_id IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE,
3731: c_program_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE,
3732: c_unitset_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE,
3733: c_seq_no IGS_AS_SU_SETATMPT.SEQUENCE_NUMBER%TYPE)
3734: IS
3735: select susa.unit_set_cd || ',' || susa.sequence_number AS unitcd_seqno
3736: from igs_as_su_setatmpt susa

Line 3733: c_seq_no IGS_AS_SU_SETATMPT.SEQUENCE_NUMBER%TYPE)

3729:
3730: CURSOR c_get_child (c_person_id IGS_EN_STDNT_PS_ATT.PERSON_ID%TYPE,
3731: c_program_cd IGS_EN_STDNT_PS_ATT.COURSE_CD%TYPE,
3732: c_unitset_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE,
3733: c_seq_no IGS_AS_SU_SETATMPT.SEQUENCE_NUMBER%TYPE)
3734: IS
3735: select susa.unit_set_cd || ',' || susa.sequence_number AS unitcd_seqno
3736: from igs_as_su_setatmpt susa
3737: where susa.person_id = c_person_id

Line 3736: from igs_as_su_setatmpt susa

3732: c_unitset_cd IGS_AS_SU_SETATMPT.UNIT_SET_CD%TYPE,
3733: c_seq_no IGS_AS_SU_SETATMPT.SEQUENCE_NUMBER%TYPE)
3734: IS
3735: select susa.unit_set_cd || ',' || susa.sequence_number AS unitcd_seqno
3736: from igs_as_su_setatmpt susa
3737: where susa.person_id = c_person_id
3738: AND SUSA.COURSE_CD= c_program_cd
3739: AND level >= 2
3740: START WITH