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_EN_GEN_009 dependencies on IGS_RE_CANDIDATURE

Line 1501: -- Research IGS_RE_CANDIDATURE exists.

1497: BEGIN -- enrp_ins_sca_cah
1498: -- This modules inserts into IGS_RE_CDT_ATT_HIST when
1499: -- IGS_EN_STDNT_PS_ATT.attendance_type is changed.
1500: -- The following is validated:
1501: -- Research IGS_RE_CANDIDATURE exists.
1502: -- Research IGS_RE_CANDIDATURE requires attendance history details to be retained
1503: DECLARE
1504: v_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
1505: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;

Line 1502: -- Research IGS_RE_CANDIDATURE requires attendance history details to be retained

1498: -- This modules inserts into IGS_RE_CDT_ATT_HIST when
1499: -- IGS_EN_STDNT_PS_ATT.attendance_type is changed.
1500: -- The following is validated:
1501: -- Research IGS_RE_CANDIDATURE exists.
1502: -- Research IGS_RE_CANDIDATURE requires attendance history details to be retained
1503: DECLARE
1504: v_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
1505: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
1506: v_hist_start_dt IGS_RE_CDT_ATT_HIST.hist_start_dt%TYPE;

Line 1504: v_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;

1500: -- The following is validated:
1501: -- Research IGS_RE_CANDIDATURE exists.
1502: -- Research IGS_RE_CANDIDATURE requires attendance history details to be retained
1503: DECLARE
1504: v_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
1505: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
1506: v_hist_start_dt IGS_RE_CDT_ATT_HIST.hist_start_dt%TYPE;
1507: v_hist_end_dt IGS_RE_CDT_ATT_HIST.hist_end_dt%TYPE;
1508: v_attendance_percentage_new IGS_RE_CDT_ATT_HIST.attendance_percentage%TYPE;

Line 1505: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;

1501: -- Research IGS_RE_CANDIDATURE exists.
1502: -- Research IGS_RE_CANDIDATURE requires attendance history details to be retained
1503: DECLARE
1504: v_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
1505: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
1506: v_hist_start_dt IGS_RE_CDT_ATT_HIST.hist_start_dt%TYPE;
1507: v_hist_end_dt IGS_RE_CDT_ATT_HIST.hist_end_dt%TYPE;
1508: v_attendance_percentage_new IGS_RE_CDT_ATT_HIST.attendance_percentage%TYPE;
1509: v_cah_sequence_number IGS_RE_CDT_ATT_HIST.sequence_number%TYPE;

Line 1516: FROM IGS_RE_CANDIDATURE ca

1512:
1513: CURSOR c_ca IS
1514: SELECT ca.sequence_number,
1515: ca.attendance_percentage
1516: FROM IGS_RE_CANDIDATURE ca
1517: WHERE ca.person_id = p_person_id AND
1518: ca.sca_course_cd = p_course_cd;
1519: CURSOR c_cah (
1520: cp_ca_sequence_number IGS_RE_CDT_ATT_HIST.ca_sequence_number%TYPE) IS

Line 1536: -- Determine if student IGS_PS_COURSE attempt has a research IGS_RE_CANDIDATURE

1532: BEGIN
1533: -- set default value
1534: p_message_name := NULL;
1535: IF p_student_confirmed_ind = 'Y' THEN
1536: -- Determine if student IGS_PS_COURSE attempt has a research IGS_RE_CANDIDATURE
1537: OPEN c_ca;
1538: FETCH c_ca INTO v_sequence_number,
1539: v_attendance_percentage;
1540: IF c_ca%NOTFOUND THEN