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_RE_VAL_CAH dependencies on IGS_RE_CDT_ATT_HIST

Line 249: -- This module validates for IGS_RE_CDT_ATT_HIST for the IGS_RE_CANDIDATURE. The

245: p_validate_first_hist_ind IN VARCHAR2 ,
246: p_message_name OUT NOCOPY VARCHAR2 )
247: RETURN BOOLEAN AS
248: BEGIN -- resp_val_cah_hist_dt
249: -- This module validates for IGS_RE_CDT_ATT_HIST for the IGS_RE_CANDIDATURE. The
250: -- following is validated:
251: -- * first hist_start_dt = IGS_EN_STDNT_PS_ATT.commencement_dt
252: -- * IGS_RE_CDT_ATT_HIST do not overlap or have gaps ie. history is
253: -- continuous.

Line 252: -- * IGS_RE_CDT_ATT_HIST do not overlap or have gaps ie. history is

248: BEGIN -- resp_val_cah_hist_dt
249: -- This module validates for IGS_RE_CDT_ATT_HIST for the IGS_RE_CANDIDATURE. The
250: -- following is validated:
251: -- * first hist_start_dt = IGS_EN_STDNT_PS_ATT.commencement_dt
252: -- * IGS_RE_CDT_ATT_HIST do not overlap or have gaps ie. history is
253: -- continuous.
254: -------------------------------------------------------------------------------------------
255: --Change History:
256: --Who When What

Line 263: v_last_hist_end_dt IGS_RE_CDT_ATT_HIST.hist_end_dt%TYPE;

259: -- history start date; moved this to the IGSRE013.pld instead
260: -------------------------------------------------------------------------------------------
261: DECLARE
262: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
263: v_last_hist_end_dt IGS_RE_CDT_ATT_HIST.hist_end_dt%TYPE;
264: CURSOR c_cah IS
265: SELECT cah.person_id,
266: cah.ca_sequence_number,
267: cah.hist_start_dt,

Line 269: FROM IGS_RE_CDT_ATT_HIST cah

265: SELECT cah.person_id,
266: cah.ca_sequence_number,
267: cah.hist_start_dt,
268: cah.hist_end_dt
269: FROM IGS_RE_CDT_ATT_HIST cah
270: WHERE cah.person_id = p_person_id AND
271: cah.ca_sequence_number = p_ca_sequence_number
272: ORDER BY cah.hist_start_dt ASC;
273: CURSOR c_ca_sca(

Line 274: cp_person_id IGS_RE_CDT_ATT_HIST.person_id%TYPE,

270: WHERE cah.person_id = p_person_id AND
271: cah.ca_sequence_number = p_ca_sequence_number
272: ORDER BY cah.hist_start_dt ASC;
273: CURSOR c_ca_sca(
274: cp_person_id IGS_RE_CDT_ATT_HIST.person_id%TYPE,
275: cp_ca_sequence_number IGS_RE_CDT_ATT_HIST.ca_sequence_number%TYPE) IS
276: SELECT sca.commencement_dt
277: FROM IGS_RE_CANDIDATURE ca,
278: IGS_EN_STDNT_PS_ATT sca

Line 275: cp_ca_sequence_number IGS_RE_CDT_ATT_HIST.ca_sequence_number%TYPE) IS

271: cah.ca_sequence_number = p_ca_sequence_number
272: ORDER BY cah.hist_start_dt ASC;
273: CURSOR c_ca_sca(
274: cp_person_id IGS_RE_CDT_ATT_HIST.person_id%TYPE,
275: cp_ca_sequence_number IGS_RE_CDT_ATT_HIST.ca_sequence_number%TYPE) IS
276: SELECT sca.commencement_dt
277: FROM IGS_RE_CANDIDATURE ca,
278: IGS_EN_STDNT_PS_ATT sca
279: WHERE ca.person_id = cp_person_id AND

Line 339: -- This module validates IGS_RE_CDT_ATT_HIST insert in the context of

335: p_attendance_type OUT NOCOPY VARCHAR2 ,
336: p_message_name OUT NOCOPY VARCHAR2 )
337: RETURN BOOLEAN AS
338: BEGIN -- resp_val_cah_ca_ins
339: -- This module validates IGS_RE_CDT_ATT_HIST insert in the context of
340: -- IGS_RE_CANDIDATURE. The following is validated.
341: -- * IGS_RE_CANDIDATURE.sca_course_cd must exist.
342: -- * research IGS_RE_CANDIDATURE IGS_EN_STDNT_PS_ATT.student_confirmed_ind is
343: -- 'Y' and IGS_EN_STDNT_PS_ATT.commencement_dt exists.

Line 435: -- Description: This module validates that the first IGS_RE_CDT_ATT_HIST.

431: p_commencement_dt IN DATE ,
432: p_message_name OUT NOCOPY VARCHAR2 )
433: RETURN BOOLEAN AS
434: BEGIN -- resp_val_cah_comm
435: -- Description: This module validates that the first IGS_RE_CDT_ATT_HIST.
436: -- hist_start_dt is the same as the research IGS_RE_CANDIDATURE IGS_EN_STDNT_PS_ATT
437: -- commencement_dt.
438: -- This module currently only returns a warning.
439: DECLARE

Line 441: v_cah_hist_start_dt IGS_RE_CDT_ATT_HIST.hist_start_dt%TYPE;

437: -- commencement_dt.
438: -- This module currently only returns a warning.
439: DECLARE
440: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
441: v_cah_hist_start_dt IGS_RE_CDT_ATT_HIST.hist_start_dt%TYPE;
442: CURSOR c_ca IS
443: SELECT ca.sequence_number
444: FROM IGS_RE_CANDIDATURE ca
445: WHERE ca.person_id = p_person_id AND

Line 450: FROM IGS_RE_CDT_ATT_HIST cah

446: ca.sca_course_cd = p_sca_course_cd;
447: CURSOR c_cah(
448: cp_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE)IS
449: SELECT cah.hist_start_dt
450: FROM IGS_RE_CDT_ATT_HIST cah
451: WHERE cah.person_id = p_person_id AND
452: cah.ca_sequence_number = cp_ca_sequence_number
453: ORDER BY cah.hist_start_dt;
454: BEGIN

Line 505: -- Description: This module validates IGS_RE_CDT_ATT_HIST.hist_end_dt.

501: p_hist_end_dt IN DATE ,
502: p_message_name OUT NOCOPY VARCHAR2 )
503: RETURN BOOLEAN AS
504: BEGIN -- resp_val_cah_end_dt
505: -- Description: This module validates IGS_RE_CDT_ATT_HIST.hist_end_dt.
506: -- Validations are:
507: -- *Hist_end_dt >= hist_start_dt and < current date.
508: DECLARE
509: BEGIN