APPS.IGS_AS_VAL_SEI dependencies on IGS_AS_STD_EXM_INSTN

Line 7: -- Validate IGS_AS_STD_EXM_INSTN teaching calendar instance

3:
4: --
5: -- Routine to clear rowids saved in a PL/SQL TABLE from a prior commit.
6: --
7: -- Validate IGS_AS_STD_EXM_INSTN teaching calendar instance
8: FUNCTION ASSP_VAL_SEI_CI(
9: p_cal_type IN VARCHAR2 ,
10: p_ci_sequence_number IN NUMBER ,
11: p_exam_cal_type IN VARCHAR2 ,

Line 18: -- Validate the teaching calendar instance of the IGS_AS_STD_EXM_INSTN record

14: RETURN boolean IS
15: gv_other_detail VARCHAR2(255);
16: BEGIN -- assp_val_sei_ci
17:
18: -- Validate the teaching calendar instance of the IGS_AS_STD_EXM_INSTN record
19: -- being created. Check for, EXIT WHEN condition_is_true ; -- To exit out NOCOPY of
20: -- loop The teaching calendar instance must be a subordinate calendar to
21: -- the specified examination calendar instance.
22: DECLARE

Line 47: -- Validate for IGS_AS_STD_EXM_INSTN duplicate within exam period

43: IGS_GE_MSG_STACK.ADD;
44: App_Exception.Raise_Exception;
45: END assp_val_sei_ci;
46: --
47: -- Validate for IGS_AS_STD_EXM_INSTN duplicate within exam period
48: FUNCTION ASSP_VAL_SEI_DPLCT(
49: p_person_id IN NUMBER ,
50: p_course_cd IN VARCHAR2 ,
51: p_unit_cd IN VARCHAR2 ,

Line 82: FROM IGS_AS_STD_EXM_INSTN

78: v_ret_val BOOLEAN DEFAULT TRUE;
79:
80: CURSOR c_sei IS
81: SELECT 'x'
82: FROM IGS_AS_STD_EXM_INSTN
83: WHERE person_id = p_person_id AND
84: course_cd = p_course_cd AND
85: -- anilk, 22-Apr-2003, Bug# 2829262
86: uoo_id = p_uoo_id AND

Line 141: v_sei_person_id IGS_AS_STD_EXM_INSTN.person_id%TYPE;

137: -- Description: This module checks that there does not exist two students
138: -- with the same seat allocation within an exam instance and IGS_GR_VENUE.
139: DECLARE
140:
141: v_sei_person_id IGS_AS_STD_EXM_INSTN.person_id%TYPE;
142: v_sei_seat_number IGS_AS_STD_EXM_INSTN.seat_number%TYPE;
143:
144: CURSOR c_sei IS
145: SELECT sei.person_id,

Line 142: v_sei_seat_number IGS_AS_STD_EXM_INSTN.seat_number%TYPE;

138: -- with the same seat allocation within an exam instance and IGS_GR_VENUE.
139: DECLARE
140:
141: v_sei_person_id IGS_AS_STD_EXM_INSTN.person_id%TYPE;
142: v_sei_seat_number IGS_AS_STD_EXM_INSTN.seat_number%TYPE;
143:
144: CURSOR c_sei IS
145: SELECT sei.person_id,
146: sei.seat_number

Line 147: FROM IGS_AS_STD_EXM_INSTN sei

143:
144: CURSOR c_sei IS
145: SELECT sei.person_id,
146: sei.seat_number
147: FROM IGS_AS_STD_EXM_INSTN sei
148: WHERE sei.ese_id = p_ese_id AND
149: sei.venue_cd = p_venue_cd AND
150: EXISTS(
151: SELECT 'x'

Line 152: FROM IGS_AS_STD_EXM_INSTN sei2

148: WHERE sei.ese_id = p_ese_id AND
149: sei.venue_cd = p_venue_cd AND
150: EXISTS(
151: SELECT 'x'
152: FROM IGS_AS_STD_EXM_INSTN sei2
153: WHERE sei2.ese_id = sei.ese_id AND
154: sei2.venue_cd = sei.venue_cd AND
155: sei2.person_id <> sei.person_id AND
156: sei2.seat_number = sei.seat_number);