APPS.IGS_FI_GET_SUAEH dependencies on IGS_EN_SU_ATTEMPT

Line 23: FROM IGS_EN_SU_ATTEMPT sua

19: DECLARE
20: -- cursor to get the current student IGS_PS_UNIT attempt status
21: CURSOR c_sua IS
22: SELECT *
23: FROM IGS_EN_SU_ATTEMPT sua
24: WHERE sua.person_id = p_person_id AND
25: (p_course_cd IS NULL OR
26: sua.course_cd = p_course_cd) AND
27: (p_unit_cd IS NULL OR

Line 69: FROM IGS_EN_SU_ATTEMPT_H suah

65: LAST_UPDATE_LOGIN ,
66: DCNT_REASON_CD ,
67: ORG_ID ,
68: UOO_ID
69: FROM IGS_EN_SU_ATTEMPT_H suah
70: WHERE suah.person_id = p_person_id AND
71: suah.course_cd = cp_course_cd AND
72: suah.unit_cd = cp_unit_cd AND
73: cp_effective_dt BETWEEN suah.hist_start_dt AND

Line 75: r_sua IGS_EN_SU_ATTEMPT%ROWTYPE;

71: suah.course_cd = cp_course_cd AND
72: suah.unit_cd = cp_unit_cd AND
73: cp_effective_dt BETWEEN suah.hist_start_dt AND
74: suah.hist_end_dt;
75: r_sua IGS_EN_SU_ATTEMPT%ROWTYPE;
76: r_suah r_t_suaeh_dtl;-- record type
77: v_suah_found BOOLEAN;
78: -------------------------------------------------------------------------------
79: PROCEDURE finpl_ins_sua_rec(

Line 80: p_hist_start_dt IGS_EN_SU_ATTEMPT_H.hist_start_dt%TYPE,

76: r_suah r_t_suaeh_dtl;-- record type
77: v_suah_found BOOLEAN;
78: -------------------------------------------------------------------------------
79: PROCEDURE finpl_ins_sua_rec(
80: p_hist_start_dt IGS_EN_SU_ATTEMPT_H.hist_start_dt%TYPE,
81: p_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE,
82: p_sua_rec IGS_EN_SU_ATTEMPT%ROWTYPE)
83: AS
84: BEGIN

Line 81: p_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE,

77: v_suah_found BOOLEAN;
78: -------------------------------------------------------------------------------
79: PROCEDURE finpl_ins_sua_rec(
80: p_hist_start_dt IGS_EN_SU_ATTEMPT_H.hist_start_dt%TYPE,
81: p_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE,
82: p_sua_rec IGS_EN_SU_ATTEMPT%ROWTYPE)
83: AS
84: BEGIN
85: DECLARE

Line 82: p_sua_rec IGS_EN_SU_ATTEMPT%ROWTYPE)

78: -------------------------------------------------------------------------------
79: PROCEDURE finpl_ins_sua_rec(
80: p_hist_start_dt IGS_EN_SU_ATTEMPT_H.hist_start_dt%TYPE,
81: p_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE,
82: p_sua_rec IGS_EN_SU_ATTEMPT%ROWTYPE)
83: AS
84: BEGIN
85: DECLARE
86: v_suah_rec r_t_suaeh_dtl;

Line 142: p_sua_rec IGS_EN_SU_ATTEMPT%ROWTYPE)

138: END finpl_ins_sua_rec;
139: -------------------------------------------------------------------------------
140: PROCEDURE finpl_ins_suah_rec (
141: p_suah_rec r_t_suaeh_dtl,
142: p_sua_rec IGS_EN_SU_ATTEMPT%ROWTYPE)
143: AS
144: BEGIN
145: DECLARE
146: v_suah_rec r_t_suaeh_dtl;

Line 326: p_hist_start_dt IGS_EN_SU_ATTEMPT_H.hist_start_dt%TYPE,

322: end if;
323: END finpl_ins_suah_rec;
324: -------------------------------------------------------------------------------
325: PROCEDURE finpl_ins_suahv_rec (
326: p_hist_start_dt IGS_EN_SU_ATTEMPT_H.hist_start_dt%TYPE,
327: p_suahv_rec IGS_AS_SUA_H_V%ROWTYPE)
328: AS
329: BEGIN
330: DECLARE

Line 389: p_sua_rec IN OUT NOCOPY IGS_EN_SU_ATTEMPT%ROWTYPE)

385: end if;
386: END finpl_ins_suahv_rec;
387: -------------------------------------------------------------------------------
388: PROCEDURE finpl_prc_sua_enrhist(
389: p_sua_rec IN OUT NOCOPY IGS_EN_SU_ATTEMPT%ROWTYPE)
390: AS
391: BEGIN
392: DECLARE
393: CURSOR c_suahv_last_enr (