1 PACKAGE IGS_AD_GEN_013 AUTHID CURRENT_USER AS
2 /* $Header: IGSAD13S.pls 115.4 2003/06/20 04:11:37 nsinha ship $ */
3
4 Function Adms_Get_Acai_Coo(
5 p_course_cd IN VARCHAR2 ,
6 p_version_number IN NUMBER ,
7 p_location_cd IN VARCHAR2 ,
8 p_attendance_mode IN VARCHAR2 ,
9 p_attendance_type IN VARCHAR2 ,
10 p_acad_cal_type IN VARCHAR2 ,
11 p_acad_ci_sequence_number IN NUMBER ,
12 p_adm_cal_type IN VARCHAR2 ,
13 p_adm_ci_sequence_number IN NUMBER ,
14 p_admission_cat IN VARCHAR2 ,
15 p_s_admission_process_type IN VARCHAR2 ,
16 p_offer_ind IN VARCHAR2 DEFAULT 'N',
17 p_appl_dt IN DATE ,
18 p_late_appl_allowed IN VARCHAR2 DEFAULT 'N',
19 p_deferred_appl IN VARCHAR2 DEFAULT 'N')
20 RETURN VARCHAR2;
21 PRAGMA RESTRICT_REFERENCES (Adms_Get_Acai_Coo,WNDS,WNPS);
22 Function Adms_Get_Acai_Course(
23 p_course_cd IN VARCHAR2 ,
24 p_version_number IN NUMBER ,
25 p_admission_cat IN VARCHAR2 ,
26 p_s_admission_process_type IN VARCHAR2 ,
27 p_acad_cal_type IN VARCHAR2 ,
28 p_acad_ci_sequence_number IN NUMBER ,
29 p_adm_cal_type IN VARCHAR2 ,
30 p_adm_ci_sequence_number IN NUMBER ,
31 p_appl_dt IN DATE ,
32 p_late_appl_allowed IN VARCHAR2 DEFAULT 'N',
33 p_offer_ind IN VARCHAR2 DEFAULT 'N')
34 RETURN VARCHAR2;
35
36 Function Adms_Get_Acai_Us(
37 p_unit_set_cd IN VARCHAR2 ,
38 p_us_version_number IN NUMBER ,
39 p_course_cd IN VARCHAR2 ,
40 p_crv_version_number IN NUMBER ,
41 p_acad_cal_type IN VARCHAR2 ,
42 p_location_cd IN VARCHAR2 ,
43 p_attendance_mode IN VARCHAR2 ,
44 p_attendance_type IN VARCHAR2 ,
45 p_admission_cat IN VARCHAR2 ,
46 p_offer_ind IN VARCHAR2 DEFAULT 'N',
47 p_unit_set_appl IN VARCHAR2 DEFAULT 'N')
48 RETURN VARCHAR2;
49
50 Function Adms_Get_Ads_Item(
51 p_adm_doc_status IN VARCHAR2 ,
52 p_s_admission_process_type IN VARCHAR2 )
53 RETURN VARCHAR2;
54 PRAGMA RESTRICT_REFERENCES (Adms_Get_Ads_Item,WNDS,WNPS);
55
56 Function Adms_Get_Aeqs_Item(
57 p_adm_entry_qual_status IN VARCHAR2 ,
58 p_s_admission_process_type IN VARCHAR2 )
59 RETURN VARCHAR2;
60 PRAGMA RESTRICT_REFERENCES (Adms_Get_Aeqs_Item,WNDS,WNPS);
61
62 Function Adms_Get_Coo_Admperd(
63 p_adm_cal_type IN VARCHAR2 ,
64 p_adm_ci_sequence_number IN NUMBER ,
65 p_admission_cat IN VARCHAR2 ,
66 p_s_admission_process_type IN VARCHAR2 ,
67 p_course_cd IN VARCHAR2 ,
68 p_version_number IN NUMBER ,
69 p_acad_cal_type IN VARCHAR2 ,
70 p_location_cd IN VARCHAR2 ,
71 p_attendance_mode IN VARCHAR2 ,
72 p_attendance_type IN VARCHAR2 )
73 RETURN VARCHAR2;
74 PRAGMA RESTRICT_REFERENCES (Adms_Get_Coo_Admperd,WNPS,WNDS);
75
76
77 -- Place the following declaration in the package specification adm_gen_013.
78 Function Adms_Get_Coo_Adm_Cat(
79 p_course_cd IN VARCHAR2 ,
80 p_version_number IN NUMBER ,
81 p_cal_type IN VARCHAR2 ,
82 p_location_cd IN VARCHAR2 ,
83 p_attendance_mode IN VARCHAR2 ,
84 p_attendance_type IN VARCHAR2 ,
85 p_admission_cat IN VARCHAR2 )
86 RETURN VARCHAR2;
87 PRAGMA RESTRICT_REFERENCES (Adms_Get_Coo_Adm_Cat,WNPS,WNDS);
88
89 Function Adms_Get_Coo_Crv(
90 p_course_cd IN VARCHAR2 ,
91 p_version_number IN NUMBER ,
92 p_s_admission_process_type IN VARCHAR2 ,
93 p_offer_ind IN VARCHAR2 DEFAULT 'N')
94 RETURN VARCHAR2;
95 PRAGMA RESTRICT_REFERENCES (Adms_Get_Coo_Crv,WNDS,WNPS);
96
97 FUNCTION check_apc_step(
98 p_admission_cat VARCHAR2,
99 p_s_admission_process_type VARCHAR2,
100 p_s_adm_step_group_type VARCHAR2,
101 p_s_admission_step_type VARCHAR2) RETURN BOOLEAN;
102 PRAGMA RESTRICT_REFERENCES (check_apc_step,WNDS,WNPS);
103
104 FUNCTION get_sys_code_status (p_name IN VARCHAR2,
105 p_class IN VARCHAR2)
106 RETURN VARCHAR2;
107 PRAGMA RESTRICT_REFERENCES (get_sys_code_status,WNDS,WNPS);
108
109 END IGS_AD_GEN_013;