1 PACKAGE IGS_EN_GEN_004 AS
2 /* $Header: IGSEN04S.pls 120.0 2005/06/01 22:06:00 appldev noship $ */
3 /* HISTORY
4 WHO WHEN WHAT
5 ayedubat 30-MAY-2002 Added the out NOCOPY parameter,p_message_name in the Function,Enrp_Get_Rec_Window
6 as part of bug fix:2337161
7 */
8 --Updated by Sudhir.
9 --Update Date: 28-Feb-2002.
10 --Added a new parameter p_admin_unit_sta to the procedure enrp_dropall_unit
11
12 -- Enhancement Bug # 1832130
13 -- Added new procedure Enrp_Dropall_Unit .Added a new parameter p_uoo_id in the function Enrp_Get_Rec_Window.
14 -- Created By : jbegum
15 -- Creation date : 17/7/2001
16
17 Function Enrp_Get_Pa_Gap(
18 p_person_id IN NUMBER ,
19 p_start_dt IN DATE ,
20 p_end_dt IN DATE )
21 RETURN VARCHAR2;
22 PRAGMA RESTRICT_REFERENCES(Enrp_Get_Pa_Gap, WNDS, WNPS);
23
24 Function Enrp_Get_Pei_Dt(
25 p_person_id IN NUMBER )
26 RETURN DATE;
27 --PRAGMA RESTRICT_REFERENCES(Enrp_Get_Pei_Dt, WNDS);
28
29 Procedure Enrp_Get_Pe_Exists(
30 p_person_id IN NUMBER ,
31 p_effective_dt IN DATE ,
32 p_check_alternate IN boolean ,
33 p_check_address IN boolean ,
34 p_check_disability IN boolean ,
35 p_check_visa IN boolean ,
36 p_check_finance IN boolean ,
37 p_check_notes IN boolean ,
38 p_check_statistics IN boolean ,
39 p_check_alias IN boolean ,
40 p_alternate_exists OUT NOCOPY boolean ,
41 p_address_exists OUT NOCOPY boolean ,
42 p_disability_exists OUT NOCOPY boolean ,
43 p_visa_exists OUT NOCOPY boolean ,
44 p_finance_exists OUT NOCOPY boolean ,
45 p_notes_exists OUT NOCOPY boolean ,
46 p_statistics_exists OUT NOCOPY boolean ,
47 p_alias_exists OUT NOCOPY boolean );
48
49 Function Enrp_Get_Rule_Cutoff(
50 p_cal_type IN VARCHAR2 ,
51 p_ci_sequence_number IN NUMBER ,
52 p_date_type IN VARCHAR2 )
53 RETURN DATE;
54 PRAGMA RESTRICT_REFERENCES(Enrp_Get_Rule_Cutoff, WNDS);
55
56 Function Enrp_Get_Scah_Col(
57 p_column_name IN VARCHAR2 ,
58 p_person_id IN IGS_AS_SC_ATTEMPT_H_ALL.person_id%TYPE ,
59 p_course_cd IN IGS_AS_SC_ATTEMPT_H_ALL.course_cd%TYPE ,
60 p_hist_end_dt IN IGS_AS_SC_ATTEMPT_H_ALL.hist_end_dt%TYPE )
61 RETURN VARCHAR2;
62 PRAGMA RESTRICT_REFERENCES(Enrp_Get_Scah_Col, WNDS);
63
64 Function Enrp_Get_Scae_Due(
65 p_person_id IN NUMBER ,
66 p_course_cd IN VARCHAR2 ,
67 p_cal_type IN VARCHAR2 ,
68 p_ci_sequence_number IN NUMBER ,
69 p_passing_due_date_ind IN VARCHAR2 ,
70 p_enr_form_due_dt IN DATE )
71 RETURN DATE;
72 PRAGMA RESTRICT_REFERENCES(Enrp_Get_Scae_Due, WNDS, WNPS);
73
74 Function Enrp_Get_Rec_Window(
75 p_cal_type IN VARCHAR2 ,
76 p_ci_sequence_number IN NUMBER ,
77 p_effective_date IN DATE ,
78 p_uoo_id IN NUMBER DEFAULT NULL,
79 p_message_name OUT NOCOPY VARCHAR2)
80 RETURN BOOLEAN;
81 --PRAGMA RESTRICT_REFERENCES(Enrp_Get_Rec_Window, WNDS);
82
83 Function Enrp_Get_Perd_Num(
84 p_person_id IN NUMBER ,
85 p_course_cd IN VARCHAR2 ,
86 p_acad_cal_type IN VARCHAR2 ,
87 p_acad_sequence_number IN NUMBER ,
88 p_acad_start_dt IN DATE )
89 RETURN NUMBER;
90 --PRAGMA RESTRICT_REFERENCES(Enrp_Get_Perd_Num, WNDS);
91
92 Procedure Enrp_Dropall_Unit(
93 p_person_id IN NUMBER ,
94 p_cal_type IN VARCHAR2 ,
95 p_ci_sequence_number IN NUMBER ,
96 p_dcnt_reason_cd IN VARCHAR2 ,
97 p_admin_unit_sta IN VARCHAR2 DEFAULT NULL,
98 p_effective_date IN DATE DEFAULT SYSDATE,
99 p_program_cd IN VARCHAR2,
100 p_uoo_id IN NUMBER DEFAULT NULL,
101 p_sub_unit IN VARCHAR2 DEFAULT 'N'
102 );
103
104 END IGS_EN_GEN_004;
[Home] [Help]