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.

[Home] [Help]

APPS.IGS_ST_GEN_001 dependencies on IGS_EN_SU_ATTEMPT

Line 437: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

433: App_Exception.Raise_Exception;
434: END stapl_check_prev_prior_gse;
435:
436: FUNCTION stapl_check_prev_crs_enrolled(
437: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
438: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE)
439: RETURN BOOLEAN AS
440: BEGIN
441: DECLARE

Line 438: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE)

434: END stapl_check_prev_prior_gse;
435:
436: FUNCTION stapl_check_prev_crs_enrolled(
437: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
438: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE)
439: RETURN BOOLEAN AS
440: BEGIN
441: DECLARE
442: CURSOR c_sua IS

Line 444: FROM IGS_EN_SU_ATTEMPT sua

440: BEGIN
441: DECLARE
442: CURSOR c_sua IS
443: SELECT 'x'
444: FROM IGS_EN_SU_ATTEMPT sua
445: WHERE sua.person_id = p_person_id AND
446: sua.course_cd = p_course_cd AND
447: sua.unit_attempt_status IN (
448: 'ENROLLED',

Line 627: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

623: App_Exception.Raise_Exception;
624: END stapl_check_combined;
625:
626: FUNCTION stapl_check_comp_req(
627: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
628: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE)
629: RETURN BOOLEAN AS
630: -------------------------------------------------------------------------------------------
631: --Change History:

Line 628: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE)

624: END stapl_check_combined;
625:
626: FUNCTION stapl_check_comp_req(
627: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
628: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE)
629: RETURN BOOLEAN AS
630: -------------------------------------------------------------------------------------------
631: --Change History:
632: --Who When What

Line 647: FROM IGS_EN_SU_ATTEMPT sua

643: sua.cal_type,
644: sua.ci_sequence_number,
645: sua.unit_attempt_status,
646: sua.uoo_id
647: FROM IGS_EN_SU_ATTEMPT sua
648: WHERE sua.person_id = p_person_id AND
649: sua.course_cd = p_course_cd AND
650: sua.unit_attempt_status = 'COMPLETED';
651: BEGIN

Line 688: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

684: App_Exception.Raise_Exception;
685: END stapl_check_comp_req;
686:
687: FUNCTION stapl_check_course_transfer(
688: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
689: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
690: p_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE,
691: p_transfer_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
692: p_trnsfr_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE)

Line 689: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,

685: END stapl_check_comp_req;
686:
687: FUNCTION stapl_check_course_transfer(
688: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
689: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
690: p_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE,
691: p_transfer_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
692: p_trnsfr_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE)
693: RETURN BOOLEAN

Line 690: p_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE,

686:
687: FUNCTION stapl_check_course_transfer(
688: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
689: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
690: p_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE,
691: p_transfer_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
692: p_trnsfr_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE)
693: RETURN BOOLEAN
694: AS

Line 691: p_transfer_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,

687: FUNCTION stapl_check_course_transfer(
688: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
689: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
690: p_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE,
691: p_transfer_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
692: p_trnsfr_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE)
693: RETURN BOOLEAN
694: AS
695: BEGIN

Line 692: p_trnsfr_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE)

688: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
689: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
690: p_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE,
691: p_transfer_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
692: p_trnsfr_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE)
693: RETURN BOOLEAN
694: AS
695: BEGIN
696: DECLARE

Line 763: p_prev_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,

759: IGS_GE_MSG_STACK.ADD;
760: App_Exception.Raise_Exception;
761: END stapl_check_course_transfer;
762: FUNCTION stapl_get_comm_dt(
763: p_prev_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
764: p_prev_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE,
765: p_prev_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE)
766: RETURN DATE
767: AS

Line 764: p_prev_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE,

760: App_Exception.Raise_Exception;
761: END stapl_check_course_transfer;
762: FUNCTION stapl_get_comm_dt(
763: p_prev_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
764: p_prev_version_number IGS_EN_SU_ATTEMPT.version_number%TYPE,
765: p_prev_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE)
766: RETURN DATE
767: AS
768: BEGIN