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_VAL_BULKRULE dependencies on IGS_EN_STDNT_PS_ATT

Line 90: CURSOR c_sca (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

86: logical_delete_dt IS NULL AND
87: NVL(todo_dt,TO_DATE('01/01/1980','DD/MM/YYYY')) <= SYSDATE
88: ORDER BY person_id asc
89: FOR UPDATE NOWAIT;
90: CURSOR c_sca (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
91: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
92: SELECT course_cd
93: FROM IGS_EN_STDNT_PS_ATT
94: WHERE person_id = cp_person_id AND

Line 91: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

87: NVL(todo_dt,TO_DATE('01/01/1980','DD/MM/YYYY')) <= SYSDATE
88: ORDER BY person_id asc
89: FOR UPDATE NOWAIT;
90: CURSOR c_sca (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
91: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
92: SELECT course_cd
93: FROM IGS_EN_STDNT_PS_ATT
94: WHERE person_id = cp_person_id AND
95: (course_cd = cp_course_cd OR

Line 93: FROM IGS_EN_STDNT_PS_ATT

89: FOR UPDATE NOWAIT;
90: CURSOR c_sca (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
91: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
92: SELECT course_cd
93: FROM IGS_EN_STDNT_PS_ATT
94: WHERE person_id = cp_person_id AND
95: (course_cd = cp_course_cd OR
96: course_cd like cp_course_cd) AND
97: (cal_type = p_acad_cal_type OR

Line 234: p_person_id IN IGS_EN_STDNT_PS_ATT.person_id%TYPE,

230: -------------------------------------
231: PROCEDURE enrpl_enrolled_to_invalid (
232: p_acad_cal_type IN IGS_CA_INST.cal_type%TYPE,
233: p_acad_sequence_number IN IGS_CA_INST.sequence_number%TYPE,
234: p_person_id IN IGS_EN_STDNT_PS_ATT.person_id%TYPE,
235: p_course_cd IN IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
236: p_s_log_type IN IGS_GE_S_LOG.s_log_type%TYPE,
237: p_creation_dt IN IGS_GE_S_LOG.creation_dt%TYPE,
238: p_invalid_rule_cutoff_dt IN IGS_EN_CAL_CONF.invalid_rule_cutoff_dt_alias%TYPE,

Line 235: p_course_cd IN IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

231: PROCEDURE enrpl_enrolled_to_invalid (
232: p_acad_cal_type IN IGS_CA_INST.cal_type%TYPE,
233: p_acad_sequence_number IN IGS_CA_INST.sequence_number%TYPE,
234: p_person_id IN IGS_EN_STDNT_PS_ATT.person_id%TYPE,
235: p_course_cd IN IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
236: p_s_log_type IN IGS_GE_S_LOG.s_log_type%TYPE,
237: p_creation_dt IN IGS_GE_S_LOG.creation_dt%TYPE,
238: p_invalid_rule_cutoff_dt IN IGS_EN_CAL_CONF.invalid_rule_cutoff_dt_alias%TYPE,
239: --added for enrollment processes dld by smaddali bug#1832130

Line 256: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

252: v_do_cursor_again_ind BOOLEAN;
253: v_last_date_to_invalid IGS_CA_DA_INST_V.alias_val%TYPE;
254: v_message_text VARCHAR2(2000);
255: -- Add the following one line of code. From Callista 2.0 18-May-2000
256: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
257: -- Initialise PL/SQL table to hold UNIT attempt records which
258: -- cannot be set to INVALID.
259: TYPE r_unit_attempt_typ IS RECORD (rv_uoo_id igs_en_su_attempt.uoo_id%TYPE);
260: r_unit_attempt_rec r_unit_attempt_typ;

Line 330: FROM IGS_EN_STDNT_PS_ATT sca

326: -- Add the following five lines of code. From Callista 2.0 18-May-2000
327: --gets the course varsion number for the student program attempt
328: CURSOR c_sca IS
329: SELECT sca.version_number
330: FROM IGS_EN_STDNT_PS_ATT sca
331: WHERE sca.person_id = p_person_id AND
332: sca.course_cd = p_course_cd;
333:
334: --smaddali modified this cursor to select only one unit section attempt

Line 751: p_person_id IN IGS_EN_STDNT_PS_ATT.person_id%TYPE,

747: -----------------------------------
748: PROCEDURE enrpl_invalid_to_enrolled (
749: p_acad_cal_type IN IGS_CA_INST.cal_type%TYPE,
750: p_acad_sequence_number IN IGS_CA_INST.sequence_number%TYPE,
751: p_person_id IN IGS_EN_STDNT_PS_ATT.person_id%TYPE,
752: p_course_cd IN IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
753: p_s_log_type IN IGS_GE_S_LOG.s_log_type%TYPE,
754: p_creation_dt IN IGS_GE_S_LOG.creation_dt%TYPE,
755: p_enrolled_rule_cutoff_dt IN IGS_EN_CAL_CONF.enrolled_rule_cutoff_dt_alias%TYPE,

Line 752: p_course_cd IN IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

748: PROCEDURE enrpl_invalid_to_enrolled (
749: p_acad_cal_type IN IGS_CA_INST.cal_type%TYPE,
750: p_acad_sequence_number IN IGS_CA_INST.sequence_number%TYPE,
751: p_person_id IN IGS_EN_STDNT_PS_ATT.person_id%TYPE,
752: p_course_cd IN IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
753: p_s_log_type IN IGS_GE_S_LOG.s_log_type%TYPE,
754: p_creation_dt IN IGS_GE_S_LOG.creation_dt%TYPE,
755: p_enrolled_rule_cutoff_dt IN IGS_EN_CAL_CONF.enrolled_rule_cutoff_dt_alias%TYPE,
756: --added for enrollment processes dld by smaddali bug#1832130

Line 809: IGS_EN_STDNT_PS_ATT sca,

805: ci.alternate_code ,
806: uoo.uoo_id,
807: sua.sup_unit_cd
808: FROM IGS_EN_SU_ATTEMPT sua,
809: IGS_EN_STDNT_PS_ATT sca,
810: IGS_CA_INST ci ,
811: IGS_PS_UNIT_OFR_OPT uoo
812: WHERE sua.person_id = p_person_id
813: AND sua.course_cd = p_course_cd

Line 831: IGS_EN_STDNT_PS_ATT sca,

827: CURSOR cur_IGS_EN_SU_ATTEMPT(cp_unit_cd varchar2,
828: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
829: SELECT sua.*
830: FROM IGS_EN_SU_ATTEMPT sua,
831: IGS_EN_STDNT_PS_ATT sca,
832: IGS_CA_INST ci
833: WHERE sua.person_id = p_person_id AND
834: sua.course_cd = p_course_cd AND
835: sua.unit_attempt_status = 'INVALID' AND