[Home] [Help]
PACKAGE: APPS.IGS_AD_GEN_003
Source
1 PACKAGE IGS_AD_GEN_003 AS
2 /* $Header: IGSAD03S.pls 120.1 2005/07/21 22:37:03 appldev ship $ */
3 -------------------------------------------------------------------------------------------
4 --Change History:
5 --Who When What
6 --knag 29-Oct-02 Bug 2647482 : Created the function get_core_or_optional_unit
7 -- to return CORE_ONLY/Y/N for CORE/CORE_OPTIONAL/no
8 -- as unit enroll indicator to preenroll process
9 --anwest 22-Jul-05 IGS.M (ADTD003) Created get_apc_date for the
10 -- Submitted Applications Reusuable
11 -- Component
12 -------------------------------------------------------------------------------------------
13
14 Function Admp_Get_Acai_Aos_Id(
15 p_person_id IN NUMBER ,
16 p_admission_appl_number IN NUMBER ,
17 p_nominated_course_cd IN VARCHAR2 ,
18 p_acai_sequence_number IN NUMBER ,
19 p_date OUT NOCOPY DATE )
20 RETURN NUMBER;
21
22 Function Admp_Get_Acai_Crv(
23 p_person_id IN NUMBER ,
24 p_admission_appl_number IN NUMBER ,
25 p_nominated_course_cd IN VARCHAR2 ,
26 p_sequence_number IN NUMBER ,
27 p_course_cd OUT NOCOPY VARCHAR2 ,
28 p_crv_version_number OUT NOCOPY NUMBER )
29 RETURN VARCHAR2;
30
31 Function Admp_Get_Acai_Status(
32 p_person_id IN NUMBER ,
33 p_admission_appl_number IN NUMBER ,
34 p_nominated_course_cd IN VARCHAR2 ,
35 p_sequence_number IN NUMBER ,
36 p_adm_outcome_status OUT NOCOPY VARCHAR2 ,
37 p_adm_offer_resp_status OUT NOCOPY VARCHAR2 )
38 RETURN VARCHAR2;
39
40 Function Admp_Get_Ac_Bfa(
41 p_tac_admission_cd IN VARCHAR2 ,
42 p_admission_cd OUT NOCOPY VARCHAR2 ,
43 p_basis_for_admission_type OUT NOCOPY VARCHAR2 ,
44 p_message_name OUT NOCOPY VARCHAR2 )
45 RETURN BOOLEAN;
46
47 Function Admp_Get_Adm_Perd_Dt(
48 p_dt_alias IN VARCHAR2 ,
49 p_adm_cal_type IN VARCHAR2 ,
50 p_adm_ci_sequence_number IN NUMBER ,
51 p_admission_cat IN VARCHAR2 ,
52 p_s_admission_process_type IN VARCHAR2 ,
53 p_course_cd IN VARCHAR2 ,
54 p_version_number IN NUMBER ,
55 p_acad_cal_type IN VARCHAR2 ,
56 p_location_cd IN VARCHAR2 ,
57 p_attendance_mode IN VARCHAR2 ,
58 p_attendance_type IN VARCHAR2 )
59 RETURN DATE;
60 PRAGMA RESTRICT_REFERENCES(Admp_Get_Adm_Perd_Dt,WNDS,WNPS);
61
62 Procedure Admp_Get_Adm_Pp(
63 p_oracle_username IN VARCHAR2 ,
64 p_adm_acad_cal_type OUT NOCOPY VARCHAR2 ,
65 p_adm_acad_ci_sequence_number OUT NOCOPY NUMBER ,
66 p_adm_acad_alternate_code OUT NOCOPY VARCHAR2 ,
67 p_adm_acad_abbreviation OUT NOCOPY VARCHAR2 ,
68 p_adm_adm_cal_type OUT NOCOPY VARCHAR2 ,
69 p_adm_adm_ci_sequence_number OUT NOCOPY NUMBER ,
70 p_adm_adm_alternate_code OUT NOCOPY VARCHAR2 ,
71 p_adm_adm_abbreviation OUT NOCOPY VARCHAR2 ,
72 p_adm_admission_cat OUT NOCOPY VARCHAR2 ,
73 p_adm_s_admission_process_type OUT NOCOPY VARCHAR2 ,
74 p_adm_ac_description OUT NOCOPY VARCHAR2 );
75
76 Procedure Admp_Get_Apcs_Mndtry(
77 p_admission_cat IN VARCHAR2 ,
78 p_s_admission_process_type IN VARCHAR2 ,
79 p_mandatory_athletics OUT NOCOPY BOOLEAN,
80 p_mandatory_alternate OUT NOCOPY BOOLEAN ,
81 p_mandatory_address OUT NOCOPY BOOLEAN ,
82 p_mandatory_disability OUT NOCOPY BOOLEAN ,
83 p_mandatory_visa OUT NOCOPY BOOLEAN ,
84 p_mandatory_finance OUT NOCOPY BOOLEAN ,
85 p_mandatory_notes OUT NOCOPY BOOLEAN ,
86 p_mandatory_statistics OUT NOCOPY BOOLEAN ,
87 p_mandatory_alias OUT NOCOPY BOOLEAN ,
88 p_mandatory_tertiary OUT NOCOPY BOOLEAN ,
89 p_mandatory_aus_sec_ed OUT NOCOPY BOOLEAN ,
90 p_mandatory_os_sec_ed OUT NOCOPY BOOLEAN ,
91 p_mandatory_employment OUT NOCOPY BOOLEAN ,
92 p_mandatory_membership OUT NOCOPY BOOLEAN ,
93 p_mandatory_dob OUT NOCOPY BOOLEAN ,
94 p_mandatory_title OUT NOCOPY BOOLEAN ,
95 p_mandatory_referee OUT NOCOPY BOOLEAN ,
96 p_mandatory_scholarship OUT NOCOPY BOOLEAN ,
97 p_mandatory_lang_prof OUT NOCOPY BOOLEAN ,
98 p_mandatory_interview OUT NOCOPY BOOLEAN ,
99 p_mandatory_exchange OUT NOCOPY BOOLEAN ,
100 p_mandatory_adm_test OUT NOCOPY BOOLEAN ,
101 p_mandatory_fee_assess OUT NOCOPY BOOLEAN ,
102 p_mandatory_cor_category OUT NOCOPY BOOLEAN ,
103 p_mandatory_enr_category OUT NOCOPY BOOLEAN ,
104 p_mandatory_research OUT NOCOPY BOOLEAN ,
105 p_mandatory_rank_app OUT NOCOPY BOOLEAN ,
106 p_mandatory_completion OUT NOCOPY BOOLEAN ,
107 p_mandatory_rank_set OUT NOCOPY BOOLEAN ,
108 p_mandatory_basis_adm OUT NOCOPY BOOLEAN ,
109 p_mandatory_crs_international OUT NOCOPY BOOLEAN ,
110 p_mandatory_ass_tracking OUT NOCOPY BOOLEAN ,
111 p_mandatory_adm_code OUT NOCOPY BOOLEAN ,
112 p_mandatory_fund_source OUT NOCOPY BOOLEAN ,
113 p_mandatory_location OUT NOCOPY BOOLEAN ,
114 p_mandatory_att_mode OUT NOCOPY BOOLEAN ,
115 p_mandatory_att_type OUT NOCOPY BOOLEAN ,
116 p_mandatory_unit_set OUT NOCOPY BOOLEAN ,
117 p_mandatory_evaluation_tab OUT NOCOPY BOOLEAN,
118 p_mandatory_prog_approval OUT NOCOPY BOOLEAN,
119 p_mandatory_indices OUT NOCOPY BOOLEAN,
120 p_mandatory_tst_scores OUT NOCOPY BOOLEAN,
121 p_mandatory_outcome OUT NOCOPY BOOLEAN,
122 p_mandatory_override OUT NOCOPY BOOLEAN,
123 p_mandatory_spl_consider OUT NOCOPY BOOLEAN,
124 p_mandatory_cond_offer OUT NOCOPY BOOLEAN,
125 p_mandatory_offer_dead OUT NOCOPY BOOLEAN,
126 p_mandatory_offer_resp OUT NOCOPY BOOLEAN,
127 p_mandatory_offer_defer OUT NOCOPY BOOLEAN,
128 p_mandatory_offer_compl OUT NOCOPY BOOLEAN,
129 p_mandatory_transfer OUT NOCOPY BOOLEAN,
130 p_mandatory_other_inst OUT NOCOPY BOOLEAN,
131 p_mandatory_edu_goals OUT NOCOPY BOOLEAN,
132 p_mandatory_acad_interest OUT NOCOPY BOOLEAN,
133 p_mandatory_app_intent OUT NOCOPY BOOLEAN,
134 p_mandatory_spl_interest OUT NOCOPY BOOLEAN,
135 p_mandatory_spl_talents OUT NOCOPY BOOLEAN,
136 p_mandatory_miscell OUT NOCOPY BOOLEAN,
137 p_mandatory_fees OUT NOCOPY BOOLEAN,
138 p_mandatory_program OUT NOCOPY BOOLEAN,
139 p_mandatory_completness OUT NOCOPY BOOLEAN,
140 p_mandatory_creden OUT NOCOPY BOOLEAN,
141 p_mandatory_review_det OUT NOCOPY BOOLEAN,
142 p_mandatory_recomm_det OUT NOCOPY BOOLEAN,
143 p_mandatory_fin_aid OUT NOCOPY BOOLEAN,
144 p_mandatory_acad_honors OUT NOCOPY BOOLEAN,
145 p_mandatory_des_unitsets OUT NOCOPY BOOLEAN,
146 p_mandatory_extrcurr OUT NOCOPY BOOLEAN );
147
148 PROCEDURE get_entr_doc_apc (p_admission_cat IN IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE,
149 p_s_admission_process_type IN IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE,
150 l_adm_doc_status OUT NOCOPY IGS_AD_PS_APPL_INST_ALL.adm_doc_status%TYPE,
151 l_adm_entr_qual_status OUT NOCOPY IGS_AD_PS_APPL_INST_ALL.adm_entry_qual_status%TYPE);
152
153 FUNCTION get_core_or_optional_unit (
154 p_person_id igs_ad_appl_all.person_id%TYPE,
155 p_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE)
156 RETURN VARCHAR2; -- (Y, CORE_ONLY, N)
157
158 -- anwest 22-Jul-05 Created get_apc_step for the
159 -- Submitted Applications Reusuable
160 -- Component
161 Function get_apc_date(p_date_type IN VARCHAR2 ,
162 p_adm_cal_type IN VARCHAR2 ,
163 p_adm_ci_sequence_number IN NUMBER ,
164 p_admission_cat IN VARCHAR2 ,
165 p_s_admission_process_type IN VARCHAR2 ,
166 p_course_cd IN VARCHAR2 ,
167 p_version_number IN NUMBER ,
168 p_acad_cal_type IN VARCHAR2 ,
169 p_location_cd IN VARCHAR2 ,
170 p_attendance_mode IN VARCHAR2 ,
171 p_attendance_type IN VARCHAR2 )
172 RETURN DATE;
173
174 END IGS_AD_GEN_003;