PACKAGE: APPS.IGS_AD_GEN_007

Source

1 PACKAGE IGS_AD_GEN_007 AUTHID CURRENT_USER AS
2 /* $Header: IGSAD07S.pls 115.5 2002/11/28 21:23:53 nsidana ship $ */
3 Function Admp_Get_Match_Prsn(
4   p_surname IN VARCHAR2 ,
5   p_birth_dt IN VARCHAR2 ,
6   p_sex IN VARCHAR2 ,
7   p_initial IN VARCHAR2 ,
8   p_message_name OUT NOCOPY VARCHAR2 )
9 RETURN NUMBER;
10 
11 function Admp_Get_Ovrd_Comm(
12   p_person_id IN NUMBER ,
13   p_admission_appl_number IN NUMBER ,
14   p_nominated_course_cd IN VARCHAR ,
15   p_sequence_number IN NUMBER )
16 RETURN VARCHAR2;
17 PRAGMA RESTRICT_REFERENCES (Admp_Get_Ovrd_Comm,WNDS);
18 
19 Procedure Admp_Get_Pe_Exists(
20   p_person_id IN NUMBER ,
21   p_effective_dt IN DATE ,
22   p_check_athletics IN BOOLEAN ,
23   p_check_alternate IN BOOLEAN ,
24   p_check_address IN BOOLEAN ,
25   p_check_disability IN BOOLEAN ,
26   p_check_visa IN BOOLEAN ,
27   p_check_finance IN BOOLEAN ,
28   p_check_notes IN BOOLEAN ,
29   p_check_statistics IN BOOLEAN ,
30   p_check_alias IN BOOLEAN ,
31   p_check_tertiary IN BOOLEAN ,
32   p_check_aus_sec_ed IN BOOLEAN ,
33   p_check_os_sec_ed IN BOOLEAN ,
34   p_check_employment IN BOOLEAN ,
35   p_check_membership IN BOOLEAN ,
36   p_check_excurr IN BOOLEAN DEFAULT FALSE,
37   p_athletics_exists OUT NOCOPY BOOLEAN ,
38   p_alternate_exists OUT NOCOPY BOOLEAN ,
39   p_address_exists OUT NOCOPY BOOLEAN ,
40   p_disability_exists OUT NOCOPY BOOLEAN ,
41   p_visa_exists OUT NOCOPY BOOLEAN ,
42   p_finance_exists OUT NOCOPY BOOLEAN ,
43   p_notes_exists OUT NOCOPY BOOLEAN ,
44   p_statistics_exists OUT NOCOPY BOOLEAN ,
45   p_alias_exists OUT NOCOPY BOOLEAN ,
46   p_tertiary_exists OUT NOCOPY BOOLEAN ,
47   p_aus_sec_ed_exists OUT NOCOPY BOOLEAN ,
48   p_os_sec_ed_exists OUT NOCOPY BOOLEAN ,
49   p_employment_exists OUT NOCOPY BOOLEAN ,
50   p_membership_exists OUT NOCOPY BOOLEAN,
51   p_excurr_exists OUT NOCOPY BOOLEAN);
52 
53 Function Admp_Get_Resp_Dt(
54   p_course_cd IN VARCHAR2 ,
55   p_version_number IN NUMBER ,
56   p_acad_cal_type IN VARCHAR2 ,
57   p_location_cd IN VARCHAR2 ,
58   p_attendance_mode IN VARCHAR2 ,
59   p_attendance_type IN VARCHAR2 ,
60   p_admission_cat IN VARCHAR2 ,
61   p_admission_process_type IN VARCHAR2 ,
62   p_adm_cal_type IN VARCHAR2 ,
63   p_adm_ci_sequence_number IN NUMBER ,
64   p_offer_dt IN DATE )
65 RETURN DATE;
66 
67 Function Admp_Get_Saas(
68   p_adm_appl_status IN VARCHAR2 )
69 RETURN VARCHAR2;
70 
71 Function Admp_Get_Sacos(
72   p_adm_cndtnl_offer_status IN VARCHAR2 )
73 RETURN VARCHAR2;
74 
75 PRAGMA RESTRICT_REFERENCES (Admp_Get_Sacos,WNDS,WNPS);
76 
77 Function Admp_Get_Sads(
78   p_adm_doc_status IN VARCHAR2 )
79 RETURN VARCHAR2;
80 PRAGMA RESTRICT_REFERENCES (Admp_Get_Sads,WNDS,WNPS);
81 
82 Function Admp_Get_Saeqs(
83   p_adm_entry_qual_status IN VARCHAR2 )
84 RETURN VARCHAR2;
85 PRAGMA RESTRICT_REFERENCES (Admp_Get_Saeqs,WNDS,WNPS);
86 
87 END IGS_AD_GEN_007;