APPS.IGS_FI_GET_SCAEH dependencies on IGS_AS_SC_ATTEMPT_H

Line 10: p_scaeh_dtl IN OUT NOCOPY IGS_AS_SC_ATTEMPT_H_ALL%ROWTYPE )

6: p_person_id IN NUMBER ,
7: p_course_cd IN IGS_PS_COURSE.course_cd%TYPE ,
8: p_effective_dt IN DATE ,
9: p_data_found OUT NOCOPY BOOLEAN ,
10: p_scaeh_dtl IN OUT NOCOPY IGS_AS_SC_ATTEMPT_H_ALL%ROWTYPE )
11: AS
12: gv_other_detail VARCHAR2(255);
13: BEGIN
14: DECLARE

Line 24: FROM IGS_AS_SC_ATTEMPT_H scah

20: sca.course_cd = p_course_cd AND
21: sca.logical_delete_dt IS NULL;
22: CURSOR c_scah (cp_effective_dt DATE) IS
23: SELECT *
24: FROM IGS_AS_SC_ATTEMPT_H scah
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;

Line 30: r_scah IGS_AS_SC_ATTEMPT_H%ROWTYPE;

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(
34: p_hist_start_dt IGS_AS_SC_ATTEMPT_H.hist_start_dt%TYPE,

Line 34: p_hist_start_dt IGS_AS_SC_ATTEMPT_H.hist_start_dt%TYPE,

30: r_scah IGS_AS_SC_ATTEMPT_H%ROWTYPE;
31: v_scah_found BOOLEAN;
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

Line 35: p_hist_end_dt IGS_AS_SC_ATTEMPT_H.hist_end_dt%TYPE,

31: v_scah_found BOOLEAN;
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');

Line 102: p_scah_rec IGS_AS_SC_ATTEMPT_H%ROWTYPE,

98: APP_EXCEPTION.RAISE_EXCEPTION;
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');

Line 451: p_hist_start_dt IGS_AS_SC_ATTEMPT_H.hist_start_dt%TYPE,

447: APP_EXCEPTION.RAISE_EXCEPTION;
448: END finpl_ins_scah_rec;
449: -------------------------------------------------------------------------------
450: PROCEDURE finpl_ins_scahv_rec (
451: p_hist_start_dt IGS_AS_SC_ATTEMPT_H.hist_start_dt%TYPE,
452: p_scahv_rec IGS_AS_SCA_H_V%ROWTYPE)
453: AS
454: BEGIN
455: gr_scaeh.r_scah.person_id := p_scahv_rec.person_id;