1 PACKAGE igs_ad_gen_004 AUTHID CURRENT_USER AS
2 /* $Header: IGSAD04S.pls 115.5 2002/11/28 21:23:20 nsidana ship $ */
3 /******************************************************************
4 Created By:
5 Date Created By:
6 Purpose:
7 Known limitations,enhancements,remarks:
8 Change History
9 Who When What
10 rrengara 2-APR-2002 Added parameter P_error_message_research in procedure Admp_Get_Crs_Exists for the bug 2285677
11 rboddu 28-OCT-2002 Added the parameters p_attendance_mode and p_location_cd to the procedure Admp_Get_Crv_Comp_Dt. Bug: 2647482
12 -------------------------------------------------------------------*/
13
14 PROCEDURE Admp_Get_Apcs_Val(
15 p_admission_cat IN VARCHAR2 ,
16 p_s_admission_process_type IN VARCHAR2 ,
17 p_apcs_pref_limit_ind OUT NOCOPY VARCHAR2 ,
18 p_apcs_app_fee_ind OUT NOCOPY VARCHAR2 ,
19 p_apcs_late_app_ind OUT NOCOPY VARCHAR2 ,
20 p_apcs_late_fee_ind OUT NOCOPY VARCHAR2 ,
21 p_apcs_chkpencumb_ind OUT NOCOPY VARCHAR2 ,
22 p_apcs_fee_assess_ind OUT NOCOPY VARCHAR2 ,
23 p_apcs_corcategry_ind OUT NOCOPY VARCHAR2 ,
24 p_apcs_enrcategry_ind OUT NOCOPY VARCHAR2 ,
25 p_apcs_chkcencumb_ind OUT NOCOPY VARCHAR2 ,
26 p_apcs_unit_set_ind OUT NOCOPY VARCHAR2 ,
27 p_apcs_un_crs_us_ind OUT NOCOPY VARCHAR2 ,
28 p_apcs_chkuencumb_ind OUT NOCOPY VARCHAR2 ,
29 p_apcs_unit_restr_ind OUT NOCOPY VARCHAR2 ,
30 p_apcs_unit_restriction_num OUT NOCOPY NUMBER ,
31 p_apcs_un_dob_ind OUT NOCOPY VARCHAR2 ,
32 p_apcs_un_title_ind OUT NOCOPY VARCHAR2 ,
33 p_apcs_asses_cond_ind OUT NOCOPY VARCHAR2 ,
34 p_apcs_fee_cond_ind OUT NOCOPY VARCHAR2 ,
35 p_apcs_doc_cond_ind OUT NOCOPY VARCHAR2 ,
36 p_apcs_multi_off_ind OUT NOCOPY VARCHAR2 ,
37 p_apcs_multi_off_restrict_num OUT NOCOPY NUMBER ,
38 p_apcs_set_otcome_ind OUT NOCOPY VARCHAR2 ,
39 p_apcs_override_o_ind OUT NOCOPY VARCHAR2 ,
40 p_apcs_defer_ind OUT NOCOPY VARCHAR2 ,
41 p_apcs_ack_app_ind OUT NOCOPY VARCHAR2 ,
42 p_apcs_outcome_lt_ind OUT NOCOPY VARCHAR2 ,
43 p_apcs_pre_enrol_ind OUT NOCOPY VARCHAR2 );
44
45 FUNCTION Admp_Get_Archive_Ind(
46 p_person_id IN NUMBER )
47 RETURN VARCHAR2;
48
49
50 FUNCTION Admp_Get_Chg_Pref_Dt(
51 p_person_id IN NUMBER ,
52 p_admission_appl_number IN NUMBER ,
53 p_nominated_course_cd IN VARCHAR2 ,
54 p_acai_sequence_number IN NUMBER )
55 RETURN VARCHAR2;
56
57
58 FUNCTION Admp_Get_Comm_Perd(
59 p_person_id IN NUMBER ,
60 p_admission_appl_number IN NUMBER ,
61 p_nominated_course_cd IN VARCHAR2 ,
62 p_acai_sequence_number IN NUMBER )
63 RETURN VARCHAR2;
64
65
66 FUNCTION Admp_Get_Course_Det(
67 p_person_id IN NUMBER ,
68 p_admission_appl_number IN NUMBER ,
69 p_s_letter_parameter_type IN VARCHAR2 ,
70 p_record_number IN NUMBER ,
71 p_extra_context OUT NOCOPY VARCHAR2 )
72 RETURN VARCHAR2;
73
74
75 FUNCTION Admp_Get_Cricos_Cd(
76 p_person_id IN NUMBER ,
77 p_admission_appl_number IN NUMBER ,
78 p_nominated_course_cd IN VARCHAR2 ,
79 p_acai_sequence_number IN NUMBER )
80 RETURN VARCHAR2;
81
82
83 PROCEDURE Admp_Get_Crs_Exists(
84 p_person_id IN NUMBER ,
85 p_admission_appl_number IN NUMBER ,
86 p_nominated_course_cd IN VARCHAR2 ,
87 p_acai_sequence_number IN NUMBER ,
88 p_course_cd IN VARCHAR2 ,
89 p_effective_dt IN DATE ,
90 p_s_admission_process_type IN VARCHAR2 ,
91 p_check_referee IN BOOLEAN ,
92 p_check_scholarship IN BOOLEAN ,
93 p_check_lang_prof IN BOOLEAN ,
94 p_check_interview IN BOOLEAN ,
95 p_check_exchange IN BOOLEAN ,
96 p_check_adm_test IN BOOLEAN ,
97 p_check_research IN BOOLEAN ,
98 p_referee_exists OUT NOCOPY BOOLEAN ,
99 p_scholarship_exists OUT NOCOPY BOOLEAN ,
100 p_lang_prof_exists OUT NOCOPY BOOLEAN ,
101 p_interview_exists OUT NOCOPY BOOLEAN ,
102 p_exchange_exists OUT NOCOPY BOOLEAN ,
103 p_adm_test_exists OUT NOCOPY BOOLEAN ,
104 p_research_exists OUT NOCOPY BOOLEAN,
105 p_error_message_research OUT NOCOPY VARCHAR2);
106
107 PROCEDURE Admp_Get_Crv_Comp_Dt(
108 p_course_cd IN VARCHAR2 ,
109 p_crv_version_number IN NUMBER ,
110 p_cal_type IN VARCHAR2 ,
111 p_attendance_type IN VARCHAR2 ,
112 p_start_dt IN DATE ,
113 p_expected_completion_yr IN OUT NOCOPY NUMBER ,
114 p_expected_completion_perd IN OUT NOCOPY VARCHAR2 ,
115 p_completion_dt OUT NOCOPY DATE,
116 p_attendance_mode IN VARCHAR2 DEFAULT NULL,
117 p_location_cd IN VARCHAR2 DEFAULT NULL);
118
119 END igs_ad_gen_004;