DBA Data[Home] [Help]

PACKAGE: APPS.IGS_EN_GEN_003

Source


1 PACKAGE IGS_EN_GEN_003 as
2 /* $Header: IGSEN03S.pls 120.1 2005/09/08 15:11:34 appldev noship $ */
3 
4 Function Enrp_Get_Dflt_Dr(
5   p_description OUT NOCOPY VARCHAR2 )
6 RETURN VARCHAR2;
7 --PRAGMA RESTRICT_REFERENCES(Enrp_Get_Dflt_Dr, WNDS);
8 
9 Function Enrp_Get_Dflt_Fs(
10   p_course_cd IN VARCHAR2 ,
11   p_version_number IN NUMBER )
12 RETURN VARCHAR2;
13 --PRAGMA RESTRICT_REFERENCES(Enrp_Get_Dflt_Fs, WNDS);
14 
15 Function Enrp_Get_Ecps_Group(
16   p_s_enrolment_step_type IN VARCHAR2 )
17 RETURN VARCHAR2;
18 PRAGMA RESTRICT_REFERENCES(Enrp_Get_Ecps_Group, WNDS,WNPS);
19 
20 Function Enrp_Get_Encmbrd_Ind(
21   p_person_id IN NUMBER )
22 RETURN VARCHAR2;
23 PRAGMA RESTRICT_REFERENCES(Enrp_Get_Encmbrd_Ind, WNDS,WNPS);
24 
25 Function Enrp_Get_Enr_Cat(
26   p_person_id                IN NUMBER ,
27   p_course_cd                IN VARCHAR2 ,
28   p_cal_type                 IN VARCHAR2 ,
29   p_ci_sequence_number       IN NUMBER ,
30   p_session_enrolment_cat    IN VARCHAR2 ,
31   p_enrol_cal_type           OUT NOCOPY VARCHAR2 ,
32   p_enrol_ci_sequence_number OUT NOCOPY NUMBER ,
33   p_commencement_type        OUT NOCOPY VARCHAR2,
34   p_enr_categories           OUT NOCOPY VARCHAR2)
35 RETURN VARCHAR2;
36 --PRAGMA RESTRICT_REFERENCES(Enrp_Get_Enr_Cat, WNDS);
37 
38 Function Enrp_Get_Enr_Ci(
39   p_adm_cal_type IN VARCHAR2 ,
40   p_adm_sequence_number IN NUMBER ,
41   p_enr_cal_type OUT NOCOPY VARCHAR2 ,
42   p_enr_sequence_number OUT NOCOPY NUMBER )
43 RETURN boolean;
44 --PRAGMA RESTRICT_REFERENCES(Enrp_Get_Enr_Ci, WNDS);
45 
46 Procedure Enrp_Get_Enr_Pp(
47   p_username IN VARCHAR2 ,
48   p_cal_type OUT NOCOPY VARCHAR2 ,
49   p_sequence_number OUT NOCOPY NUMBER ,
50   p_enrolment_cat OUT NOCOPY VARCHAR2 ,
51   p_enr_method_type OUT NOCOPY VARCHAR2 );
52 
53 Function Enrp_Get_Excld_Unit(
54   p_person_id IN NUMBER ,
55   p_course_cd IN VARCHAR2 ,
56   p_effective_dt IN DATE )
57 RETURN VARCHAR2;
58 --PRAGMA RESTRICT_REFERENCES(Enrp_Get_Excld_Unit, WNDS);
59 
60 Function Get_Student_Ind(
61   p_person_id IN NUMBER )
62 RETURN VARCHAR2;
63 PRAGMA RESTRICT_REFERENCES(Enrp_Get_Encmbrd_Ind, WNDS,WNPS);
64 
65 Function Get_Staff_Ind(
66   p_person_id IN NUMBER )
67 RETURN VARCHAR2;
68 PRAGMA RESTRICT_REFERENCES(Enrp_Get_Encmbrd_Ind, WNDS,WNPS);
69 
70  Function Stdnt_Crs_Atmpt_Stat(
71     perid NUMBER)
72 RETURN VARCHAR2 ;
73 PRAGMA RESTRICT_REFERENCES(Stdnt_Crs_Atmpt_Stat, WNDS,WNPS);
74 
75 PROCEDURE UPD_MAT_MRADM_CAT_TERMS(
76     p_person_id IN NUMBER,
77     p_program_cd IN VARCHAR2,
78     p_unit_attempt_status IN VARCHAR2,
79     p_teach_cal_type IN VARCHAR2,
80     p_teach_ci_seq_num IN NUMBER);
81 
82 
83 END IGS_EN_GEN_003;