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);
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,
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,
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,
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: /*******************************************************************************
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
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,
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,
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
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,
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,
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,
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,
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,
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,
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,
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;
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:
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: /*******************************************************************************
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
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
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;
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;
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;