APPS.IGS_EN_TRANSFER_APIS dependencies on IGS_EN_SU_ATTEMPT

Line 1032: FROM IGS_EN_SU_ATTEMPT

1028: l_unchk_units_in_src VARCHAR2(2000);
1029:
1030: CURSOR c_get_all_enr_waitlstd_units IS
1031: SELECT unit_cd,uoo_id
1032: FROM IGS_EN_SU_ATTEMPT
1033: WHERE person_id = p_person_id AND
1034: course_cd = p_source_program_cd AND
1035: unit_attempt_status IN ('ENROLLED','WAITLISTED','INVALID');
1036: l_cindex NUMBER;

Line 1103: FROM IGS_EN_SU_ATTEMPT sua, IGS_PS_UNIT_OFR_OPT uoo

1099: l_unchk_units_in_src VARCHAR2(2000);
1100:
1101: CURSOR c_get_all_src_units IS
1102: SELECT sua.unit_cd,sua.uoo_id, uoo.sup_uoo_id
1103: FROM IGS_EN_SU_ATTEMPT sua, IGS_PS_UNIT_OFR_OPT uoo
1104: WHERE person_id = p_person_id AND
1105: course_cd = p_source_program_cd AND
1106: uoo.uoo_id = sua.uoo_id AND
1107: uoo.sup_uoo_id IS NOT NULL AND

Line 1459: FROM IGS_EN_SU_ATTEMPT sua

1455: CURSOR c_enroll_sua (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
1456: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
1457:
1458: SELECT uoo_id
1459: FROM IGS_EN_SU_ATTEMPT sua
1460: WHERE sua.person_id = cp_person_id
1461: AND sua.course_cd = cp_course_cd
1462: AND sua.unit_attempt_status IN ('ENROLLED','WAITLISTED','INVALID');
1463:

Line 1585: l_unt_att_status IGS_EN_SU_ATTEMPT.UNIT_ATTEMPT_STATUS%TYPE;

1581: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1582: l_unit_outcome IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE;
1583: l_is_val_sua_trans BOOLEAN;
1584: l_temp VARCHAR2(1);
1585: l_unt_att_status IGS_EN_SU_ATTEMPT.UNIT_ATTEMPT_STATUS%TYPE;
1586: l_proceed_aftr_res_val BOOLEAN;
1587: l_sut_status BOOLEAN;
1588: l_sua_trans_status BOOLEAN;
1589: l_return_type VARCHAR2(200);

Line 1603: CURSOR c_get_unit_dtls(c_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) Is

1599: l_message_name3 FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1600: l_error_occured BOOLEAN;
1601:
1602:
1603: CURSOR c_get_unit_dtls(c_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) Is
1604: SELECT *
1605: FROM IGS_EN_SU_ATTEMPT
1606: WHERE person_id = p_person_id AND
1607: course_cd = p_source_program_cd AND

Line 1605: FROM IGS_EN_SU_ATTEMPT

1601:
1602:
1603: CURSOR c_get_unit_dtls(c_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE) Is
1604: SELECT *
1605: FROM IGS_EN_SU_ATTEMPT
1606: WHERE person_id = p_person_id AND
1607: course_cd = p_source_program_cd AND
1608: uoo_id = c_uoo_id ;
1609:

Line 1610: CURSOR c_get_research_dtls(c_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,c_unit_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE) IS

1606: WHERE person_id = p_person_id AND
1607: course_cd = p_source_program_cd AND
1608: uoo_id = c_uoo_id ;
1609:
1610: CURSOR c_get_research_dtls(c_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,c_unit_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE) IS
1611: SELECT 'x'
1612: FROM IGS_PS_UNIT_VER uv
1613: WHERE uv.unit_cd = c_unit_cd AND
1614: uv.version_number = c_unit_version_number AND

Line 2053: CURSOR c_get_unit_dtls(cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS

2049: -- ckasu 06-MAR-2006 added new cursor c_get_enr_method_type as a part of bug#5070732
2050: -- ckasu created this procedure for bug#4063726
2051: -------------------------------------------------------------------------------------------
2052:
2053: CURSOR c_get_unit_dtls(cp_uoo_id IGS_EN_SU_ATTEMPT.UOO_ID%TYPE) IS
2054: SELECT cal_type,ci_sequence_number
2055: FROM IGS_PS_UNIT_OFR_OPT
2056: WHERE uoo_id = cp_uoo_id;
2057: