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_CDT_ATT_HIST

Line 1498: -- This modules inserts into IGS_RE_CDT_ATT_HIST when

1494: p_message_name OUT NOCOPY VARCHAR2)
1495: RETURN BOOLEAN AS
1496:
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

Line 1506: v_hist_start_dt IGS_RE_CDT_ATT_HIST.hist_start_dt%TYPE;

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;
1510:

Line 1507: v_hist_end_dt IGS_RE_CDT_ATT_HIST.hist_end_dt%TYPE;

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;
1510:
1511: l_org_id NUMBER := igs_ge_gen_003.get_org_id;

Line 1508: v_attendance_percentage_new IGS_RE_CDT_ATT_HIST.attendance_percentage%TYPE;

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;
1510:
1511: l_org_id NUMBER := igs_ge_gen_003.get_org_id;
1512:

Line 1509: v_cah_sequence_number IGS_RE_CDT_ATT_HIST.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;
1510:
1511: l_org_id NUMBER := igs_ge_gen_003.get_org_id;
1512:
1513: CURSOR c_ca IS

Line 1520: cp_ca_sequence_number IGS_RE_CDT_ATT_HIST.ca_sequence_number%TYPE) IS

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
1521: SELECT cah.hist_end_dt
1522: FROM IGS_RE_CDT_ATT_HIST cah
1523: WHERE cah.person_id = p_person_id AND
1524: cah.ca_sequence_number = cp_ca_sequence_number

Line 1522: FROM IGS_RE_CDT_ATT_HIST cah

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
1521: SELECT cah.hist_end_dt
1522: FROM IGS_RE_CDT_ATT_HIST cah
1523: WHERE cah.person_id = p_person_id AND
1524: cah.ca_sequence_number = cp_ca_sequence_number
1525: ORDER BY cah.hist_end_dt DESC;
1526: CURSOR c_cah2 (

Line 1527: cp_sequence_number IGS_RE_CDT_ATT_HIST.sequence_number%TYPE) IS

1523: WHERE cah.person_id = p_person_id AND
1524: cah.ca_sequence_number = cp_ca_sequence_number
1525: ORDER BY cah.hist_end_dt DESC;
1526: CURSOR c_cah2 (
1527: cp_sequence_number IGS_RE_CDT_ATT_HIST.sequence_number%TYPE) IS
1528: SELECT NVL(MAX(cah2.sequence_number),0)+1
1529: FROM IGS_RE_CDT_ATT_HIST cah2
1530: WHERE cah2.person_id = p_person_id AND
1531: cah2.ca_sequence_number = cp_sequence_number;

Line 1529: FROM IGS_RE_CDT_ATT_HIST cah2

1525: ORDER BY cah.hist_end_dt DESC;
1526: CURSOR c_cah2 (
1527: cp_sequence_number IGS_RE_CDT_ATT_HIST.sequence_number%TYPE) IS
1528: SELECT NVL(MAX(cah2.sequence_number),0)+1
1529: FROM IGS_RE_CDT_ATT_HIST cah2
1530: WHERE cah2.person_id = p_person_id AND
1531: cah2.ca_sequence_number = cp_sequence_number;
1532: BEGIN
1533: -- set default value

Line 1585: IGS_RE_CDT_ATT_HIST_PKG.INSERT_ROW(

1581: DECLARE
1582: l_rowid VARCHAR2(25);
1583: BEGIN
1584:
1585: IGS_RE_CDT_ATT_HIST_PKG.INSERT_ROW(
1586: x_rowid => l_rowid,
1587: x_person_id => p_person_id,
1588: x_sequence_number => v_cah_sequence_number,
1589: x_ca_sequence_number => v_sequence_number,