[Home] [Help]
11: --
12: gv_person_id igs_pe_person.person_id%type;
13: --
14: --
15: gv_course_cd IGS_PS_COURSE.COURSE_CD%TYPE;
16: --
17: --
18: gv_effective_dt DATE;
19: --
19: --
20: -- Routine to save SCA effective history data in a PL/SQL RECORD.
21: PROCEDURE FINP_GET_SCAEH(
22: p_person_id IN NUMBER ,
23: p_course_cd IN IGS_PS_COURSE.course_cd%TYPE,
24: p_effective_dt IN DATE ,
25: p_data_found OUT NOCOPY BOOLEAN ,
26: p_scaeh_dtl IN OUT NOCOPY IGS_AS_SC_ATTEMPT_H_ALL%ROWTYPE )
27: ;