[Home] [Help]
14: DECLARE
15: -- cursor to get the current student IGS_PS_COURSE attempt status
16: CURSOR c_sca IS
17: SELECT *
18: FROM IGS_EN_STDNT_PS_ATT sca
19: WHERE sca.person_id = p_person_id AND
20: sca.course_cd = p_course_cd AND
21: sca.logical_delete_dt IS NULL;
22: CURSOR c_scah (cp_effective_dt DATE) IS
25: WHERE scah.person_id = p_person_id AND
26: scah.course_cd = p_course_cd AND
27: cp_effective_dt BETWEEN scah.hist_start_dt AND
28: scah.hist_end_dt;
29: r_sca IGS_EN_STDNT_PS_ATT%ROWTYPE;
30: r_scah IGS_AS_SC_ATTEMPT_H%ROWTYPE;
31: v_scah_found BOOLEAN;
32: -------------------------------------------------------------------------------
33: PROCEDURE finpl_ins_sca_rec(
32: -------------------------------------------------------------------------------
33: PROCEDURE finpl_ins_sca_rec(
34: p_hist_start_dt IGS_AS_SC_ATTEMPT_H.hist_start_dt%TYPE,
35: p_hist_end_dt IGS_AS_SC_ATTEMPT_H.hist_end_dt%TYPE,
36: p_sca_rec IGS_EN_STDNT_PS_ATT%ROWTYPE)
37: AS
38: BEGIN
39: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('IN finpl_ins_sca_rec');
40: gr_scaeh.r_scah.person_id := p_sca_rec.person_id;
99: END finpl_ins_sca_rec;
100: -------------------------------------------------------------------------------
101: PROCEDURE finpl_ins_scah_rec (
102: p_scah_rec IGS_AS_SC_ATTEMPT_H%ROWTYPE,
103: p_sca_rec IGS_EN_STDNT_PS_ATT%ROWTYPE)
104: AS
105: BEGIN
106: --commented by syam to avoid adchkdrv errors -dbms_output.put_line('IN finpl_ins_scah_rec');
107: gr_scaeh.r_scah.person_id := p_scah_rec.person_id;
517: APP_EXCEPTION.RAISE_EXCEPTION;
518: END finpl_ins_scahv_rec;
519: -------------------------------------------------------------------------------
520: PROCEDURE finpl_prc_sca_enrhist(
521: p_sca_rec IN OUT NOCOPY IGS_EN_STDNT_PS_ATT%ROWTYPE)
522: AS
523: BEGIN
524: DECLARE
525: CURSOR c_scahv_last_enr (cp_effective_dt DATE) IS