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_AS_VAL_ESVS dependencies on IGS_GR_VENUE

Line 12: -- Validate exam instance exists for the session and IGS_GR_VENUE.

8: -------------------------------------------------------------------------------------------
9: -- Validate if a IGS_PE_PERSON is an active student.
10:
11: --
12: -- Validate exam instance exists for the session and IGS_GR_VENUE.
13: FUNCTION ASSP_VAL_EI_VENUE(
14: p_exam_cal_type IN VARCHAR2 ,
15: p_exam_ci_sequence_number IN NUMBER ,
16: p_dt_alias IN VARCHAR2 ,

Line 25: -- at a IGS_GR_VENUE for which the supervisor is being allocated.

21: P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )
22: RETURN BOOLEAN AS
23: BEGIN -- assp_val_ei_venue
24: -- Validate there exists at least one exam instance
25: -- at a IGS_GR_VENUE for which the supervisor is being allocated.
26: DECLARE
27: v_start_time DATE;
28: v_flag VARCHAR2(1) ;
29: v_end_time DATE;

Line 72: -- Validate IGS_GR_VENUE is within the supervisor's exam IGS_AD_LOCATIONs

68: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_VAL_ESVS.assp_val_ei_venue');
69: IGS_GE_MSG_STACK.ADD;
70: END assp_val_ei_venue;
71: --
72: -- Validate IGS_GR_VENUE is within the supervisor's exam IGS_AD_LOCATIONs
73: FUNCTION ASSP_VAL_ELS_VENUE(
74: p_person_id IN NUMBER ,
75: p_venue_cd IN VARCHAR2 ,
76: P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )

Line 80: -- instance/IGS_GR_VENUE, then check that the IGS_GR_VENUE is within one of the IGS_PE_PERSONs

76: P_MESSAGE_NAME OUT NOCOPY VARCHAR2 )
77: RETURN BOOLEAN AS
78: BEGIN --assp_val_els_venue
79: --Validate if the IGS_PE_PERSON is being allocated to supervise an exam
80: -- instance/IGS_GR_VENUE, then check that the IGS_GR_VENUE is within one of the IGS_PE_PERSONs
81: -- exam_location_supvsr records
82: DECLARE
83: v_els_exists VARCHAR2(1);
84: CURSOR c_els IS

Line 87: IGS_GR_VENUE ve

83: v_els_exists VARCHAR2(1);
84: CURSOR c_els IS
85: SELECT 'X'
86: FROM IGS_AS_EXM_LOC_SPVSR els,
87: IGS_GR_VENUE ve
88: WHERE els.person_id = p_person_id AND
89: els.exam_location_cd = ve.exam_location_cd AND
90: ve.venue_cd = p_venue_cd;
91: BEGIN

Line 94: --Determine if the IGS_GR_VENUE is within a persons supervisory IGS_AD_LOCATIONs

90: ve.venue_cd = p_venue_cd;
91: BEGIN
92: --Set the default message number
93: P_MESSAGE_NAME := NULL;
94: --Determine if the IGS_GR_VENUE is within a persons supervisory IGS_AD_LOCATIONs
95: OPEN c_els;
96: FETCH c_els INTO v_els_exists;
97: IF (c_els%NOTFOUND) THEN
98: --Return a warning message indicating that the exam IGS_GR_VENUE is not within

Line 98: --Return a warning message indicating that the exam IGS_GR_VENUE is not within

94: --Determine if the IGS_GR_VENUE is within a persons supervisory IGS_AD_LOCATIONs
95: OPEN c_els;
96: FETCH c_els INTO v_els_exists;
97: IF (c_els%NOTFOUND) THEN
98: --Return a warning message indicating that the exam IGS_GR_VENUE is not within
99: --a IGS_AD_LOCATION that the IGS_PE_PERSON supervises.
100: CLOSE c_els;
101: P_MESSAGE_NAME := 'IGS_AS_VENUE_NOTWITHIN_SUPVEX';
102: RETURN FALSE;

Line 135: v_exam_location_cd IGS_GR_VENUE.exam_location_cd%TYPE;

131: -- Validate the IGS_PE_PERSON is not being allocated to sessions at two different exam
132: -- locations on the same day
133: DECLARE
134: v_dt_alias_val DATE;
135: v_exam_location_cd IGS_GR_VENUE.exam_location_cd%TYPE;
136: v_check CHAR;
137: CURSOR c_venue IS
138: SELECT exam_location_cd
139: FROM IGS_GR_VENUE

Line 139: FROM IGS_GR_VENUE

135: v_exam_location_cd IGS_GR_VENUE.exam_location_cd%TYPE;
136: v_check CHAR;
137: CURSOR c_venue IS
138: SELECT exam_location_cd
139: FROM IGS_GR_VENUE
140: WHERE venue_cd = p_venue_cd;
141: CURSOR c_eis_ve (
142: cp_dt_alias_val DATE,
143: cp_exam_location_cd IGS_GR_VENUE.exam_location_cd%TYPE) IS

Line 143: cp_exam_location_cd IGS_GR_VENUE.exam_location_cd%TYPE) IS

139: FROM IGS_GR_VENUE
140: WHERE venue_cd = p_venue_cd;
141: CURSOR c_eis_ve (
142: cp_dt_alias_val DATE,
143: cp_exam_location_cd IGS_GR_VENUE.exam_location_cd%TYPE) IS
144: SELECT 'x'
145: FROM IGS_AS_EXM_INS_SPVSR eis,
146: IGS_GR_VENUE ve
147: WHERE eis.person_id = p_person_id AND

Line 146: IGS_GR_VENUE ve

142: cp_dt_alias_val DATE,
143: cp_exam_location_cd IGS_GR_VENUE.exam_location_cd%TYPE) IS
144: SELECT 'x'
145: FROM IGS_AS_EXM_INS_SPVSR eis,
146: IGS_GR_VENUE ve
147: WHERE eis.person_id = p_person_id AND
148: IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(
149: eis.dt_alias,
150: eis.dai_sequence_number,

Line 157: cp_exam_location_cd IGS_GR_VENUE.exam_location_cd%TYPE) IS

153: eis.venue_cd = ve.venue_cd AND
154: ve.exam_location_cd <> cp_exam_location_cd;
155: CURSOR c_esvs_ve (
156: cp_dt_alias_val DATE,
157: cp_exam_location_cd IGS_GR_VENUE.exam_location_cd%TYPE) IS
158: SELECT 'x'
159: FROM IGS_AS_EXM_SES_VN_SP esvs,
160: IGS_GR_VENUE ve
161: WHERE esvs.person_id = p_person_id AND

Line 160: IGS_GR_VENUE ve

156: cp_dt_alias_val DATE,
157: cp_exam_location_cd IGS_GR_VENUE.exam_location_cd%TYPE) IS
158: SELECT 'x'
159: FROM IGS_AS_EXM_SES_VN_SP esvs,
160: IGS_GR_VENUE ve
161: WHERE esvs.person_id = p_person_id AND
162: IGS_CA_GEN_001.CALP_GET_ALIAS_VAL(
163: esvs.dt_alias,
164: esvs.dai_sequence_number,

Line 177: -- Get the exam IGS_AD_LOCATION for the IGS_GR_VENUE.

173: p_dt_alias,
174: p_dai_sequence_number,
175: p_exam_cal_type,
176: p_exam_ci_sequence_number);
177: -- Get the exam IGS_AD_LOCATION for the IGS_GR_VENUE.
178: OPEN c_venue;
179: FETCH c_venue INTO v_exam_location_cd;
180: CLOSE c_venue;
181: -- Determine if the IGS_PE_PERSON has been allocated to supervise an exam instance for

Line 195: -- Determine if the IGS_PE_PERSON has already been allocated to supervise at a IGS_GR_VENUE

191: P_MESSAGE_NAME := 'IGS_AS_PRSN_ALLOC_DIFF_EXAM';
192: RETURN FALSE;
193: END IF;
194: CLOSE c_eis_ve;
195: -- Determine if the IGS_PE_PERSON has already been allocated to supervise at a IGS_GR_VENUE
196: -- for the same day at a different exam IGS_AD_LOCATION.
197: OPEN c_esvs_ve(
198: v_dt_alias_val,
199: v_exam_location_cd);

Line 218: -- Validate if the supervisor limit exceeded for the session and IGS_GR_VENUE.

214: FND_MESSAGE.SET_TOKEN('NAME','IGS_AS_VAL_ESVS.assp_val_esu_ese_el');
215: IGS_GE_MSG_STACK.ADD;
216: END assp_val_esu_ese_el;
217: --
218: -- Validate if the supervisor limit exceeded for the session and IGS_GR_VENUE.
219: -- Supervisor cannot be allocated concurrent sessions at different IGS_GR_VENUEs
220: FUNCTION ASSP_VAL_ESU_ESE_VE(
221: p_person_id IN NUMBER ,
222: p_exam_cal_type IN VARCHAR2 ,

Line 219: -- Supervisor cannot be allocated concurrent sessions at different IGS_GR_VENUEs

215: IGS_GE_MSG_STACK.ADD;
216: END assp_val_esu_ese_el;
217: --
218: -- Validate if the supervisor limit exceeded for the session and IGS_GR_VENUE.
219: -- Supervisor cannot be allocated concurrent sessions at different IGS_GR_VENUEs
220: FUNCTION ASSP_VAL_ESU_ESE_VE(
221: p_person_id IN NUMBER ,
222: p_exam_cal_type IN VARCHAR2 ,
223: p_exam_ci_sequence_number IN NUMBER ,

Line 237: --concurrent exam sessions at different IGS_GR_VENUEs

233: gv_other_detail_1 VARCHAR2(255);
234: gv_other_detail_2 VARCHAR2(255);
235: BEGIN --assp_val_esu_ese_ve
236: --Validate the IGS_PE_PERSON cannot be allocated to supervise
237: --concurrent exam sessions at different IGS_GR_VENUEs
238: DECLARE
239: v_eis_exists VARCHAR2(1);
240: v_esvs_exists VARCHAR2(1);
241: v_dt_alias_val DATE;

Line 300: --at a different IGS_GR_VENUE for the same session.

296: RETURN FALSE;
297: END IF;
298: CLOSE c_eis;
299: --Determine if the IGS_PE_PERSON has been allocated to supervise
300: --at a different IGS_GR_VENUE for the same session.
301: OPEN c_esvs;
302: FETCH c_esvs INTO v_esvs_exists;
303: IF (c_esvs%FOUND) THEN
304: --Return an error message indicating that the IGS_PE_PERSON has been