PACKAGE: APPS.IGS_FI_GET_SCAEH

Source

1 PACKAGE IGS_FI_GET_SCAEH AUTHID CURRENT_USER AS
2 /* $Header: IGSFI06S.pls 115.5 2002/11/29 00:15:26 nsidana ship $ */
3   --
4   TYPE r_scaeh_dtl IS RECORD
5   (
6   r_scah IGS_AS_SC_ATTEMPT_H_ALL%ROWTYPE);
7   --
8   --
9   gr_scaeh r_scaeh_dtl;
10   --
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   --
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 ;
28 END IGS_FI_GET_SCAEH;