DBA Data[Home] [Help]

PACKAGE: APPS.IGS_EN_GEN_006

Source


1 PACKAGE IGS_EN_GEN_006 AS
2 /* $Header: IGSEN06S.pls 120.1 2006/02/19 22:37:30 ctyagi noship $ */
3 
4 Function Enrp_Get_Sca_Acad(
5   p_person_id IN NUMBER ,
6   p_course_cd IN VARCHAR2 ,
7   p_cal_type IN VARCHAR2 ,
8   p_ci_sequence_number OUT NOCOPY NUMBER ,
9   p_enrolment_cat OUT NOCOPY VARCHAR2 ,
10   p_message_name out NOCOPY Varchar2 )
11 RETURN BOOLEAN;
12 -- PRAGMA RESTRICT_REFERENCES(Enrp_Get_Sca_Acad, WNDS);
13 
14 Function Enrp_Get_Sca_Am(
15   p_person_id IN NUMBER ,
16   p_course_cd IN VARCHAR2 ,
17   p_load_cal_type IN VARCHAR2 ,
18   p_load_sequence_number IN NUMBER )
19 RETURN VARCHAR2;
20 -- PRAGMA RESTRICT_REFERENCES(Enrp_Get_Sca_Am, WNDS);
21 
22 Function Enrp_Get_Sca_Att(
23   p_person_id IN NUMBER ,
24   p_course_cd IN VARCHAR2 ,
25   p_effective_dt IN DATE )
26 RETURN VARCHAR2;
27 -- PRAGMA RESTRICT_REFERENCES(Enrp_Get_Sca_Att, WNDS);
28 
29 Function Enrp_Get_Sca_Comm(
30   p_person_id IN NUMBER ,
31   p_course_cd IN VARCHAR2 ,
32   p_student_confirmed_ind IN VARCHAR2 DEFAULT 'N',
33   p_effective_date IN DATE )
34 RETURN boolean;
35  PRAGMA RESTRICT_REFERENCES(Enrp_Get_Sca_Comm, WNDS, WNPS);
36 
37 Function Enrp_Get_Sca_Elgbl(
38   p_person_id IN NUMBER ,
39   p_course_cd IN VARCHAR2 ,
40   p_student_comm_type IN VARCHAR2 ,
41   p_acad_cal_type IN VARCHAR2 ,
42   p_acad_ci_sequence_number IN NUMBER ,
43   p_dflt_confirmed_course_ind IN VARCHAR2 DEFAULT 'N',
44   p_message_name out NOCOPY Varchar2 )
45 RETURN boolean;
46  --PRAGMA RESTRICT_REFERENCES(Enrp_Get_Sca_Elgbl, WNDS, WNPS);
47 
48 
49 Function Enrp_Get_Sca_Latt(
50   p_person_id IN NUMBER ,
51   p_course_cd IN VARCHAR2 ,
52   p_load_cal_type IN VARCHAR2 ,
53   p_load_sequence_number IN NUMBER )
54 RETURN VARCHAR2;
55   PRAGMA RESTRICT_REFERENCES(Enrp_Get_Sca_Latt, WNDS, WNPS);
56 
57 
58 Function Enrp_Get_Sca_Perd(
59   p_person_id IN NUMBER ,
60   p_course_cd IN VARCHAR2 )
61 RETURN VARCHAR2;
62 -- PRAGMA RESTRICT_REFERENCES(Enrp_Get_Sca_Perd, WNDS);
63 
64 Function Enrp_Get_Sca_Status(
65   p_person_id IN NUMBER ,
66   p_course_cd IN VARCHAR2 ,
67   p_course_attempt_status IN VARCHAR2 ,
68   p_student_confirmed_ind IN VARCHAR2 DEFAULT 'N',
69   p_discontinued_dt IN DATE ,
70   p_lapsed_dt IN DATE ,
71   p_course_rqrmnt_complete_ind IN VARCHAR2 DEFAULT 'N',
72   p_logical_delete_dt IN DATE )
73 RETURN VARCHAR2;
74 -- PRAGMA RESTRICT_REFERENCES(Enrp_Get_Sca_Status, WNDS);
75 
76 Function Enrp_Get_Sca_Trnsfr(
77   p_person_id IN NUMBER ,
78   p_course_cd IN VARCHAR2 ,
79   p_message_name out NOCOPY Varchar2 )
80 RETURN BOOLEAN;
81  PRAGMA RESTRICT_REFERENCES(Enrp_Get_Sca_Trnsfr, WNDS, WNPS);
82 
83 END IGS_EN_GEN_006;