1 PACKAGE IGS_AD_DEF_APPL_PKG AS
2 /* $Header: IGSADC1S.pls 120.1 2005/10/25 23:39:32 appldev ship $ */
3 /*******************************************************************************
4 Created by : Ramesh Rengarajan
5 Date created: 13 SEP 2002
6
7 Purpose:
8 To create deferred term application
9
10 Known limitations/enhancements and/or remarks:
11
12 Change History: (who, when, what: )
13 Who When What
14 *******************************************************************************/
15 PROCEDURE admp_val_offer_defer_term( errbuf out NOCOPY varchar2,
16 retcode out NOCOPY number ,
17 p_person_id hz_parties.party_id%TYPE,
18 p_group_id igs_pe_persid_group.group_id%TYPE,
19 p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
20 p_prev_acad_adm_cal VARCHAR2,
21 p_def_acad_adm_cal VARCHAR2,
22 p_offer_dt VARCHAR2,
23 p_offer_response_dt VARCHAR2);
24
25 /*******************************************************************************
26 Created by : Ramesh Rengarajan
27 Date created: 06 AUG 2002
28
29 Purpose:
30 To Create deferred term application , copy child records, copy entry and completness status , give offer with validation
31
32 Known limitations/enhancements and/or remarks:
33
34 Change History: (who, when, what: )
35 Who When What
36 *******************************************************************************/
37 PROCEDURE cmn_handle_application
38 (
39 p_person_id hz_parties.party_id%TYPE,
40 p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
41 p_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
42 p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ,
43 p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE ,
44 p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
45 p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
46 p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
47 p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
48 p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE
49 );
50
51 /*******************************************************************************
52 Created by : Ramesh Rengarajan
53 Date created: 06 AUG 2002
54
55 Purpose:
56 To create deferred term application , this is getting called from admp_val_offer_defer_tem
57
58 Known limitations/enhancements and/or remarks:
59
60 Change History: (who, when, what: )
61 Who When What
62 *******************************************************************************/
63 FUNCTION handle_application( p_person_id hz_parties.party_id%TYPE,
64 p_admission_appl_number igs_ad_appl.admission_appl_number%TYPE,
65 p_nominated_course_cd igs_ad_ps_appl.nominated_course_cd%TYPE,
66 p_sequence_number igs_ad_ps_appl_inst.sequence_number%TYPE,
67 p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
68 p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
69 p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
70 p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
71 p_new_admission_appl_number OUT NOCOPY igs_ad_appl.admission_appl_number%TYPE,
72 p_new_sequence_number OUT NOCOPY igs_ad_ps_appl_inst.sequence_number%TYPE)
73 RETURN BOOLEAN;
74 /*******************************************************************************
75 Created by : Ramesh Rengarajan
76 Date created: 06 AUG 2002
77
78 Purpose:
79 To validate offer and update the same for the application
80
81 Known limitations/enhancements and/or remarks:
82
83 Change History: (who, when, what: )
84 Who When What
85 *******************************************************************************/
86
87 FUNCTION validate_offer_validations( p_person_id HZ_PARTIES.PARTY_ID%TYPE,
88 p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
89 p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
90 p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
91 p_old_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
92 p_old_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
93 p_offer_dt igs_ad_ps_appl_inst.offer_dt%TYPE,
94 p_offer_response_dt igs_ad_ps_appl_inst.offer_response_dt%TYPE,
95 p_def_acad_cal_type igs_ad_appl.acad_cal_type%TYPE,
96 p_def_acad_cal_seq_no igs_ad_appl.acad_ci_sequence_number%TYPE,
97 p_def_adm_cal_type igs_ad_appl.adm_cal_type%TYPE,
98 p_def_adm_cal_seq_no igs_ad_appl.adm_ci_sequence_number%TYPE,
99 p_start_dt DATE) RETURN BOOLEAN;
100 /*******************************************************************************
101 Created by : Ramesh Rengarajan
102 Date created: 06 AUG 2002
103
104 Purpose:
105 To validate entry qual status and completness status for the old application and copy the same to new application
106 Known limitations/enhancements and/or remarks:
107
108 Change History: (who, when, what: )
109 Who When What
110 *******************************************************************************/
111
112 FUNCTION copy_entrycomp_qual_status( p_person_id HZ_PARTIES.PARTY_ID%TYPE,
113 p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
114 p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
115 p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE,
116 p_new_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
117 p_new_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) RETURN BOOLEAN;
118
119 /*******************************************************************************
120 Created by : hreddych
121 Date created: 16 OCT 2002
122
123 Purpose:
124 To update the Offer response status of the new application to 'ACCEPTED'
125 if the offer deferment status of the old application is 'CONFIRM'
126
127 Change History: (who, when, what: )
128 Who When What
129 apadegal 06-Oct-2005 Changed it to a Function to handle exceptions in pre-enrolment.
130 *******************************************************************************/
131
132 FUNCTION Update_offer_response_accepted (p_person_id HZ_PARTIES.party_id%TYPE,
133 p_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
134 p_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
135 p_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) RETURN BOOLEAN;
136 END IGS_AD_DEF_APPL_PKG;