96: p_admission_appl_number IN NUMBER)
97: RETURN VARCHAR2;
98:
99: PROCEDURE check_adm_appl_inst_stat(
100: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
101: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
102: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
103: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
104: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
97: RETURN VARCHAR2;
98:
99: PROCEDURE check_adm_appl_inst_stat(
100: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
101: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
102: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
103: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
104: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
105: );
98:
99: PROCEDURE check_adm_appl_inst_stat(
100: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
101: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
102: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
103: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
104: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
105: );
106:
99: PROCEDURE check_adm_appl_inst_stat(
100: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
101: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
102: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
103: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
104: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
105: );
106:
107:
121: )
122: RETURN VARCHAR2;
123:
124: PROCEDURE Admp_resub_inst(
125: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
126: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
127: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
128: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
129: p_do_commit VARCHAR2 DEFAULT NULL,
122: RETURN VARCHAR2;
123:
124: PROCEDURE Admp_resub_inst(
125: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
126: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
127: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
128: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
129: p_do_commit VARCHAR2 DEFAULT NULL,
130: x_return_status OUT NOCOPY VARCHAR2,
123:
124: PROCEDURE Admp_resub_inst(
125: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
126: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
127: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
128: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
129: p_do_commit VARCHAR2 DEFAULT NULL,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
124: PROCEDURE Admp_resub_inst(
125: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
126: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
127: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
128: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
129: p_do_commit VARCHAR2 DEFAULT NULL,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2
149: p_sequence_number IN NUMBER
150: )
151: RETURN VARCHAR2;
152:
153: PROCEDURE Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
154: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
155: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
156: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
157: p_success out nocopy VARCHAR2,
150: )
151: RETURN VARCHAR2;
152:
153: PROCEDURE Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
154: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
155: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
156: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
157: p_success out nocopy VARCHAR2,
158: p_message_name out nocopy VARCHAR2
151: RETURN VARCHAR2;
152:
153: PROCEDURE Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
154: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
155: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
156: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
157: p_success out nocopy VARCHAR2,
158: p_message_name out nocopy VARCHAR2
159: );
152:
153: PROCEDURE Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
154: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
155: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
156: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
157: p_success out nocopy VARCHAR2,
158: p_message_name out nocopy VARCHAR2
159: );
160: FUNCTION Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
156: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
157: p_success out nocopy VARCHAR2,
158: p_message_name out nocopy VARCHAR2
159: );
160: FUNCTION Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
161: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
162: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
163: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
164: )
157: p_success out nocopy VARCHAR2,
158: p_message_name out nocopy VARCHAR2
159: );
160: FUNCTION Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
161: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
162: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
163: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
164: )
165: RETURN VARCHAR2;
158: p_message_name out nocopy VARCHAR2
159: );
160: FUNCTION Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
161: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
162: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
163: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
164: )
165: RETURN VARCHAR2;
166:
159: );
160: FUNCTION Is_inst_recon_allowed ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
161: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
162: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
163: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE
164: )
165: RETURN VARCHAR2;
166:
167:
165: RETURN VARCHAR2;
166:
167:
168: PROCEDURE Reconsider_Appl_Inst (
169: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
170: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
171: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
172: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
173: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
166:
167:
168: PROCEDURE Reconsider_Appl_Inst (
169: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
170: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
171: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
172: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
173: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
174: ) ;
167:
168: PROCEDURE Reconsider_Appl_Inst (
169: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
170: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
171: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
172: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
173: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
174: ) ;
175:
168: PROCEDURE Reconsider_Appl_Inst (
169: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
170: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
171: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
172: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
173: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
174: ) ;
175:
176:
174: ) ;
175:
176:
177: PROCEDURE Recon_Appl_inst (
178: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
179: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
180: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
181: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
182: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
175:
176:
177: PROCEDURE Recon_Appl_inst (
178: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
179: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
180: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
181: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
182: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
183: ); --- this procedure would be invoked from
176:
177: PROCEDURE Recon_Appl_inst (
178: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
179: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
180: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
181: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
182: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
183: ); --- this procedure would be invoked from
184:
177: PROCEDURE Recon_Appl_inst (
178: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
179: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
180: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
181: p_acai_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
182: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
183: ); --- this procedure would be invoked from
184:
185: FUNCTION check_adm_appl_inst_stat( -- An overloaded function - would be invoked in Self Service
182: p_interface VARCHAR2 -- Interface which has raised reconsideration ( Forms,Self service, Import process)
183: ); --- this procedure would be invoked from
184:
185: FUNCTION check_adm_appl_inst_stat( -- An overloaded function - would be invoked in Self Service
186: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
187: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
188: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
189: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
190: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
183: ); --- this procedure would be invoked from
184:
185: FUNCTION check_adm_appl_inst_stat( -- An overloaded function - would be invoked in Self Service
186: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
187: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
188: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
189: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
190: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
191: )
184:
185: FUNCTION check_adm_appl_inst_stat( -- An overloaded function - would be invoked in Self Service
186: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
187: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
188: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
189: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
190: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
191: )
192: RETURN VARCHAR2;
185: FUNCTION check_adm_appl_inst_stat( -- An overloaded function - would be invoked in Self Service
186: p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
187: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
188: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE DEFAULT NULL,
189: p_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE DEFAULT NULL,
190: p_updateable VARCHAR2 DEFAULT 'N' -- apadegal - TD001 - IGS.M.
191: )
192: RETURN VARCHAR2;
193:
191: )
192: RETURN VARCHAR2;
193:
194:
195: PROCEDURE ins_dummy_pend_hist_rec ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
196: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
197: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE
198: ) ;
199:
192: RETURN VARCHAR2;
193:
194:
195: PROCEDURE ins_dummy_pend_hist_rec ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
196: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
197: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE
198: ) ;
199:
200: --End apadegal TD001 IGS.m
193:
194:
195: PROCEDURE ins_dummy_pend_hist_rec ( p_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
196: p_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
197: p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE
198: ) ;
199:
200: --End apadegal TD001 IGS.m
201: