1 PACKAGE igs_ad_ss_appl_upd_page AUTHID CURRENT_USER AS
2 /* $Header: IGSADC5S.pls 115.2 2003/06/20 07:52:41 nsinha noship $ */
3
4 PROCEDURE create_perstat_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_appl_perstat_id IN OUT NOCOPY NUMBER,
7 x_person_id IN NUMBER,
8 x_admission_appl_number IN NUMBER,
9 x_persl_stat_type IN VARCHAR2,
10 x_date_received IN DATE,
11 x_mode IN VARCHAR2 DEFAULT 'R'
12 );
13
14 PROCEDURE check_adm_due_date_isvalid (
15 p_adm_cal_type IN VARCHAR2 ,
16 p_adm_ci_sequence_number IN NUMBER ,
17 p_adm_cat IN VARCHAR2 ,
18 p_s_adm_prc_type IN VARCHAR2 ,
19 p_acad_cal_type IN VARCHAR2 ,
20 l_msg_count OUT NOCOPY NUMBER,
21 l_msg_data OUT NOCOPY VARCHAR2 ,
22 l_return_status OUT NOCOPY VARCHAR2);
23
24 PROCEDURE validate_due_final_dt(
25 p_adm_cal_type IN VARCHAR2,
26 p_adm_ci_sequence_number IN NUMBER,
27 p_adm_cat IN VARCHAR2,
28 p_s_adm_prc_type IN VARCHAR2,
29 p_course_cd IN VARCHAR2,
30 p_crv_version_number IN NUMBER,
31 p_acad_cal_type IN VARCHAR2,
32 p_location_cd IN VARCHAR2,
33 p_attendance_mode IN VARCHAR2,
34 p_attendance_type IN VARCHAR2,
35 l_msg_count OUT NOCOPY NUMBER,
36 l_msg_data OUT NOCOPY VARCHAR2,
37 l_return_status OUT NOCOPY VARCHAR2);
38
39 PROCEDURE validate_pref_unique(
40 p_person_id IN IGS_AD_PS_APPL_INST.person_id%TYPE,
41 p_adm_appl_no IN IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
42 p_course_cd IN IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
43 p_seq_number IN IGS_AD_PS_APPL_INST.sequence_number%TYPE,
44 p_pref_number IN NUMBER,
45 l_msg_count OUT NOCOPY NUMBER,
46 l_msg_data OUT NOCOPY VARCHAR2,
47 l_return_status OUT NOCOPY VARCHAR2);
48
49 FUNCTION admp_val_chg_of_pref(
50 p_adm_cal_type IN VARCHAR2 ,
51 p_adm_ci_sequence_number IN NUMBER ,
52 p_admission_cat IN VARCHAR2 ,
53 p_s_admission_process_type IN VARCHAR2 ,
54 p_course_cd IN VARCHAR2 ,
55 p_crv_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 l_message_name OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
61
62 FUNCTION admp_val_acai_update(
63 p_adm_appl_status IN VARCHAR2 ,
64 p_person_id IN NUMBER ,
65 p_admission_appl_number IN NUMBER ,
66 p_nominated_course_cd IN VARCHAR2 ,
67 p_acai_sequence_number IN NUMBER ,
68 p_message_name OUT NOCOPY VARCHAR2,
69 p_update_non_enrol_detail_ind OUT NOCOPY VARCHAR2 )RETURN VARCHAR2;
70
71 FUNCTION admp_val_acai_pref(
72 p_preference_number IN NUMBER ,
73 p_pref_allowed IN VARCHAR2 DEFAULT 'N',
74 p_pref_limit IN NUMBER ,
75 p_s_admission_process_type IN VARCHAR2 ,
76 p_message_name OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
77
78 FUNCTION admp_val_acai_opt(
79 p_course_cd IN VARCHAR2 ,
80 p_version_number IN NUMBER ,
81 p_acad_cal_type IN VARCHAR2 ,
82 p_acad_ci_sequence_number IN NUMBER ,
83 p_location_cd IN VARCHAR2 ,
84 p_attendance_mode IN VARCHAR2 ,
85 p_attendance_type IN VARCHAR2 ,
86 p_adm_cal_type IN VARCHAR2 ,
87 p_adm_ci_sequence_number IN NUMBER ,
88 p_admission_cat IN VARCHAR2 ,
89 p_s_admission_process_type IN VARCHAR2 ,
90 p_offer_ind IN VARCHAR2 DEFAULT 'N',
91 p_appl_dt IN DATE ,
92 p_late_appl_allowed IN VARCHAR2 DEFAULT 'N',
93 p_message_name OUT NOCOPY VARCHAR2)RETURN VARCHAR2;
94
95
96 FUNCTION admp_val_acai_us(
97 p_unit_set_cd IN VARCHAR2 ,
98 p_us_version_number IN NUMBER ,
99 p_course_cd IN VARCHAR2 ,
100 p_crv_version_number IN NUMBER ,
101 p_acad_cal_type IN VARCHAR2 ,
102 p_location_cd IN VARCHAR2 ,
103 p_attendance_mode IN VARCHAR2 ,
104 p_attendance_type IN VARCHAR2 ,
105 p_admission_cat IN VARCHAR2 ,
106 p_offer_ind IN VARCHAR2 DEFAULT 'N',
107 p_unit_set_appl IN VARCHAR2 DEFAULT 'N',
108 p_message_name OUT NOCOPY VARCHAR2,
109 p_return_type OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2;
110
111 FUNCTION admp_val_aa_update(
112 p_adm_appl_status IN VARCHAR2 ,
113 p_message_name OUT NOCOPY VARCHAR2 )RETURN VARCHAR2;
114
115 PROCEDURE final_scrn_intw_event(
116 p_person_id IN NUMBER,
117 p_admission_appl_number IN NUMBER,
118 p_nominated_course_cd IN VARCHAR2,
119 p_sequence_number IN NUMBER,
120 p_final_screening_decision IN VARCHAR2,
121 p_final_screening_date IN DATE,
122 p_panel_code IN VARCHAR2,
123 p_raised_for IN VARCHAR2
124 );
125 END igs_ad_ss_appl_upd_page;