230: ) ;
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,
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,
241: p_attempted_credit_points IN igs_pr_stu_acad_stat_int.attempted_credit_points%TYPE,
242: p_earned_credit_points IN igs_pr_stu_acad_stat_int.earned_credit_points%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,
241: p_attempted_credit_points IN igs_pr_stu_acad_stat_int.attempted_credit_points%TYPE,
242: p_earned_credit_points IN igs_pr_stu_acad_stat_int.earned_credit_points%TYPE,
243: p_gpa IN igs_pr_stu_acad_stat_int.gpa%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,
241: p_attempted_credit_points IN igs_pr_stu_acad_stat_int.attempted_credit_points%TYPE,
242: p_earned_credit_points IN igs_pr_stu_acad_stat_int.earned_credit_points%TYPE,
243: p_gpa IN igs_pr_stu_acad_stat_int.gpa%TYPE,
244: p_gpa_credit_points IN igs_pr_stu_acad_stat_int.gpa_credit_points%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,
241: p_attempted_credit_points IN igs_pr_stu_acad_stat_int.attempted_credit_points%TYPE,
242: p_earned_credit_points IN igs_pr_stu_acad_stat_int.earned_credit_points%TYPE,
243: p_gpa IN igs_pr_stu_acad_stat_int.gpa%TYPE,
244: p_gpa_credit_points IN igs_pr_stu_acad_stat_int.gpa_credit_points%TYPE,
245: p_gpa_quality_points IN igs_pr_stu_acad_stat_int.gpa_quality_points%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,
241: p_attempted_credit_points IN igs_pr_stu_acad_stat_int.attempted_credit_points%TYPE,
242: p_earned_credit_points IN igs_pr_stu_acad_stat_int.earned_credit_points%TYPE,
243: p_gpa IN igs_pr_stu_acad_stat_int.gpa%TYPE,
244: p_gpa_credit_points IN igs_pr_stu_acad_stat_int.gpa_credit_points%TYPE,
245: p_gpa_quality_points IN igs_pr_stu_acad_stat_int.gpa_quality_points%TYPE,
246: x_return_status OUT NOCOPY VARCHAR2
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,
241: p_attempted_credit_points IN igs_pr_stu_acad_stat_int.attempted_credit_points%TYPE,
242: p_earned_credit_points IN igs_pr_stu_acad_stat_int.earned_credit_points%TYPE,
243: p_gpa IN igs_pr_stu_acad_stat_int.gpa%TYPE,
244: p_gpa_credit_points IN igs_pr_stu_acad_stat_int.gpa_credit_points%TYPE,
245: p_gpa_quality_points IN igs_pr_stu_acad_stat_int.gpa_quality_points%TYPE,
246: x_return_status OUT NOCOPY VARCHAR2
247: );
240: p_timeframe IN igs_pr_stu_acad_stat_int.timeframe%TYPE,
241: p_attempted_credit_points IN igs_pr_stu_acad_stat_int.attempted_credit_points%TYPE,
242: p_earned_credit_points IN igs_pr_stu_acad_stat_int.earned_credit_points%TYPE,
243: p_gpa IN igs_pr_stu_acad_stat_int.gpa%TYPE,
244: p_gpa_credit_points IN igs_pr_stu_acad_stat_int.gpa_credit_points%TYPE,
245: p_gpa_quality_points IN igs_pr_stu_acad_stat_int.gpa_quality_points%TYPE,
246: x_return_status OUT NOCOPY VARCHAR2
247: );
248:
241: p_attempted_credit_points IN igs_pr_stu_acad_stat_int.attempted_credit_points%TYPE,
242: p_earned_credit_points IN igs_pr_stu_acad_stat_int.earned_credit_points%TYPE,
243: p_gpa IN igs_pr_stu_acad_stat_int.gpa%TYPE,
244: p_gpa_credit_points IN igs_pr_stu_acad_stat_int.gpa_credit_points%TYPE,
245: p_gpa_quality_points IN igs_pr_stu_acad_stat_int.gpa_quality_points%TYPE,
246: x_return_status OUT NOCOPY VARCHAR2
247: );
248:
249: PROCEDURE insert_program_completion