200: ) RETURN VARCHAR2;
201:
202: PROCEDURE get_person_details
203: (
204: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
205: p_person_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE,
206: p_person_id OUT NOCOPY hz_parties.party_id%TYPE,
207: p_person_number OUT NOCOPY hz_parties.party_number%TYPE
208: );
201:
202: PROCEDURE get_person_details
203: (
204: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
205: p_person_id_code_type IN igs_pe_alt_pers_id.api_person_id%TYPE,
206: p_person_id OUT NOCOPY hz_parties.party_id%TYPE,
207: p_person_number OUT NOCOPY hz_parties.party_number%TYPE
208: );
209:
209:
210: PROCEDURE update_stdnts_err
211: (
212: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
213: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
214: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
215: p_report_text IN igs_da_req_stdnts.report_text%TYPE,
216: p_error_code IN igs_da_req_stdnts.error_code%TYPE,
217: x_return_status OUT NOCOPY VARCHAR2
210: PROCEDURE update_stdnts_err
211: (
212: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
213: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
214: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
215: p_report_text IN igs_da_req_stdnts.report_text%TYPE,
216: p_error_code IN igs_da_req_stdnts.error_code%TYPE,
217: x_return_status OUT NOCOPY VARCHAR2
218: ) ;
219:
220:
221: PROCEDURE update_req_students (
222: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
223: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
224: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
225: p_report_text IN igs_da_req_stdnts.report_text%TYPE,
226: p_academicsubprogram_codes IN VARCHAR2,
227: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
220:
221: PROCEDURE update_req_students (
222: p_batch_id IN igs_da_req_stdnts.batch_id%TYPE,
223: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
224: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
225: p_report_text IN igs_da_req_stdnts.report_text%TYPE,
226: p_academicsubprogram_codes IN VARCHAR2,
227: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
228: p_error_code IN igs_da_req_stdnts.error_code%TYPE,
231:
232: PROCEDURE insert_gpa
233: (
234: p_batch_id IN igs_pr_stu_acad_stat_int.batch_id%TYPE,
235: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
236: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
237: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
238: p_alternate_code IN igs_pr_stu_acad_stat_int.alternate_code%TYPE,
239: p_stat_type IN igs_pr_stu_acad_stat_int.stat_type%TYPE,
232: PROCEDURE insert_gpa
233: (
234: p_batch_id IN igs_pr_stu_acad_stat_int.batch_id%TYPE,
235: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
236: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
237: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
238: p_alternate_code IN igs_pr_stu_acad_stat_int.alternate_code%TYPE,
239: p_stat_type IN igs_pr_stu_acad_stat_int.stat_type%TYPE,
240: p_timeframe IN igs_pr_stu_acad_stat_int.timeframe%TYPE,
248:
249: PROCEDURE insert_program_completion
250: (
251: p_batch_id IN igs_pr_spa_complete_int.batch_id%TYPE,
252: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
253: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
254: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
255: p_program_complete IN VARCHAR2,
256: p_program_complete_date IN VARCHAR2,
249: PROCEDURE insert_program_completion
250: (
251: p_batch_id IN igs_pr_spa_complete_int.batch_id%TYPE,
252: p_person_id_code IN igs_pe_alt_pers_id.api_person_id%TYPE,
253: p_person_id_code_type IN igs_pe_alt_pers_id.person_id_type%TYPE,
254: p_program_code IN igs_da_req_stdnts.program_code%TYPE,
255: p_program_complete IN VARCHAR2,
256: p_program_complete_date IN VARCHAR2,
257: x_return_status OUT NOCOPY VARCHAR2