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

Line 591: v_cah2_hist_end_dt IGS_RE_CDT_ATT_HIST.hist_end_dt%TYPE;

587: v_commencement_dt DATE;
588: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
589: v_sca_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
590: v_record_found BOOLEAN DEFAULT FALSE;
591: v_cah2_hist_end_dt IGS_RE_CDT_ATT_HIST.hist_end_dt%TYPE;
592: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
593: v_tp_days NUMBER;
594: v_effective_start_dt DATE;
595: v_effective_end_dt DATE;

Line 637: FROM IGS_RE_CDT_ATT_HIST cah

633: IS
634: SELECT cah.hist_start_dt,
635: cah.hist_end_dt,
636: cah.attendance_percentage
637: FROM IGS_RE_CDT_ATT_HIST cah
638: WHERE cah.person_id = p_person_id AND
639: cah.ca_sequence_number = v_ca_sequence_number AND
640: cah.hist_end_dt >= cp_effective_start_dt AND
641: cah.hist_start_dt <= p_effective_dt

Line 667: FROM IGS_RE_CDT_ATT_HIST cah

663: IS
664: SELECT cah.hist_start_dt,
665: cah.hist_end_dt,
666: cah.attendance_percentage
667: FROM IGS_RE_CDT_ATT_HIST cah
668: WHERE cah.person_id = p_person_id AND
669: cah.ca_sequence_number = cp_ca_sequence_number AND
670: cah.hist_start_dt <= cp_intermit_end_dt AND
671: cah.hist_start_dt <= p_effective_dt AND

Line 1133: -- This modules inserts into IGS_RE_CDT_ATT_HIST when

1129: p_old_attendance_percentage IN NUMBER ,
1130: p_message_name OUT NOCOPY VARCHAR2 )
1131: RETURN BOOLEAN AS
1132: BEGIN -- resp_ins_ca_cah
1133: -- This modules inserts into IGS_RE_CDT_ATT_HIST when
1134: -- IGS_RE_CANDIDATURE.attendance_percentage is changed. The following is validated:
1135: -- IGS_RE_CANDIDATURE requires attendance history details to be retained.
1136: DECLARE
1137: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;

Line 1140: v_hist_end_dt IGS_RE_CDT_ATT_HIST.hist_end_dt%TYPE;

1136: DECLARE
1137: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
1138: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
1139: v_message_name VARCHAR2(30);
1140: v_hist_end_dt IGS_RE_CDT_ATT_HIST.hist_end_dt%TYPE;
1141: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
1142: v_hist_start_dt IGS_RE_CDT_ATT_HIST.hist_start_dt%TYPE;
1143: v_sequence_number IGS_RE_CDT_ATT_HIST.sequence_number%TYPE;
1144:

Line 1142: v_hist_start_dt IGS_RE_CDT_ATT_HIST.hist_start_dt%TYPE;

1138: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
1139: v_message_name VARCHAR2(30);
1140: v_hist_end_dt IGS_RE_CDT_ATT_HIST.hist_end_dt%TYPE;
1141: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
1142: v_hist_start_dt IGS_RE_CDT_ATT_HIST.hist_start_dt%TYPE;
1143: v_sequence_number IGS_RE_CDT_ATT_HIST.sequence_number%TYPE;
1144:
1145: LV_ROWID VARCHAR2(25);
1146: v_org_id IGS_RE_CDT_ATT_HIST.org_id%TYPE := IGS_GE_GEN_003.Get_Org_Id;

Line 1143: v_sequence_number IGS_RE_CDT_ATT_HIST.sequence_number%TYPE;

1139: v_message_name VARCHAR2(30);
1140: v_hist_end_dt IGS_RE_CDT_ATT_HIST.hist_end_dt%TYPE;
1141: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
1142: v_hist_start_dt IGS_RE_CDT_ATT_HIST.hist_start_dt%TYPE;
1143: v_sequence_number IGS_RE_CDT_ATT_HIST.sequence_number%TYPE;
1144:
1145: LV_ROWID VARCHAR2(25);
1146: v_org_id IGS_RE_CDT_ATT_HIST.org_id%TYPE := IGS_GE_GEN_003.Get_Org_Id;
1147: CURSOR c_cah IS

Line 1146: v_org_id IGS_RE_CDT_ATT_HIST.org_id%TYPE := IGS_GE_GEN_003.Get_Org_Id;

1142: v_hist_start_dt IGS_RE_CDT_ATT_HIST.hist_start_dt%TYPE;
1143: v_sequence_number IGS_RE_CDT_ATT_HIST.sequence_number%TYPE;
1144:
1145: LV_ROWID VARCHAR2(25);
1146: v_org_id IGS_RE_CDT_ATT_HIST.org_id%TYPE := IGS_GE_GEN_003.Get_Org_Id;
1147: CURSOR c_cah IS
1148: SELECT cah.hist_end_dt
1149: FROM IGS_RE_CDT_ATT_HIST cah
1150: WHERE cah.person_id = p_person_id AND

Line 1149: FROM IGS_RE_CDT_ATT_HIST cah

1145: LV_ROWID VARCHAR2(25);
1146: v_org_id IGS_RE_CDT_ATT_HIST.org_id%TYPE := IGS_GE_GEN_003.Get_Org_Id;
1147: CURSOR c_cah IS
1148: SELECT cah.hist_end_dt
1149: FROM IGS_RE_CDT_ATT_HIST cah
1150: WHERE cah.person_id = p_person_id AND
1151: cah.ca_sequence_number = p_ca_sequence_number
1152: ORDER BY cah.hist_end_dt DESC;
1153: CURSOR c_cah2 IS

Line 1155: FROM IGS_RE_CDT_ATT_HIST cah2

1151: cah.ca_sequence_number = p_ca_sequence_number
1152: ORDER BY cah.hist_end_dt DESC;
1153: CURSOR c_cah2 IS
1154: SELECT NVL(max(cah2.sequence_number),0)+1
1155: FROM IGS_RE_CDT_ATT_HIST cah2
1156: WHERE cah2.person_id = p_person_id AND
1157: cah2.ca_sequence_number = p_ca_sequence_number;
1158: BEGIN
1159: p_message_name := NULL;

Line 1181: -- to the histury table as it is a mandatory column in IGS_RE_CDT_ATT_HIST table

1177: v_attendance_type,
1178: p_old_attendance_percentage);
1179: --By bayadav as a part of bug 2399877
1180: --First history inserted, attendance % should be set the student
1181: -- to the histury table as it is a mandatory column in IGS_RE_CDT_ATT_HIST table
1182: IF v_attendance_percentage IS NULL THEN
1183: p_message_name := 'IGS_RE_ATT_PER_NOT_EXIST';
1184: RETURN FALSE;
1185: END IF;

Line 1215: IGS_RE_CDT_ATT_HIST_PKG.INSERT_ROW( X_ROWID => LV_ROWID,

1211: OPEN c_cah2;
1212: FETCH c_cah2 INTO v_sequence_number;
1213: CLOSE c_cah2;
1214:
1215: IGS_RE_CDT_ATT_HIST_PKG.INSERT_ROW( X_ROWID => LV_ROWID,
1216: X_PERSON_ID => p_person_id,
1217: X_CA_SEQUENCE_NUMBER => p_ca_sequence_number,
1218: X_SEQUENCE_NUMBER => v_sequence_number,
1219: X_HIST_START_DT => v_hist_start_dt,

Line 1273: v_org_id igs_re_cdt_att_hist.org_id%TYPE;

1269: p_old_update_on IN DATE ,
1270: p_new_update_on IN DATE )
1271: AS
1272: LV_ROWID VARCHAR2(25);
1273: v_org_id igs_re_cdt_att_hist.org_id%TYPE;
1274: BEGIN -- resp_ins_ca_hist
1275: -- Description: Insert IGS_RE_CANDIDATURE history (IGS_RE_CDT_HIST)
1276: v_org_id := IGS_GE_GEN_003.Get_Org_Id;
1277: DECLARE

Line 1386: v_org_id igs_re_cdt_att_hist.org_id%TYPE;

1382: set only if due date is in the present or future for
1383: EN303 Milestone build Enh#3577974
1384: *******************************************************************************/
1385: LV_ROWID VARCHAR2(25);
1386: v_org_id igs_re_cdt_att_hist.org_id%TYPE;
1387: BEGIN -- resp_ins_dflt_mil
1388: -- Insert default milestones against a IGS_RE_CANDIDATURE based on their
1389: -- IGS_PS_COURSE version.
1390: v_org_id := IGS_GE_GEN_003.Get_Org_Id;