[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;