[Home] [Help]
220: Who When What
221: **************************************************************/
222: BEGIN
223: --Display message Promissory Note Processed for Person Number:-
224: l_ret:=igf_gr_gen.get_per_num(p_stud_id,l_current_per_num);
225:
226: fnd_file.new_line(fnd_file.log,1);
227: fnd_message.set_name('IGF','IGF_SL_PROC_PROM');
228: fnd_message.set_token('P_STUD',l_current_per_num);
428:
429: l_ci_cal_type := LTRIM(RTRIM(SUBSTR( p_award_year,1,10)));
430: l_ci_sequence_number := TO_NUMBER(SUBSTR( p_award_year,11));
431:
432: l_alternate_code :=igf_gr_gen.get_alt_code(l_ci_cal_type,l_ci_sequence_number);
433: l_heading :=igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS','LOAN_NUMBER');
434:
435: --Display all Headings
436:
446:
447: --Display the Person Number for the Base ID
448: l_person_num :=NULL;
449: IF p_base_id IS NOT NULL THEN
450: l_person_num:=igf_gr_gen.get_per_num(p_base_id);
451: END IF;
452:
453:
454: l_log_mesg := RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','PERSON_NUMBER'),80,' ')||':'||RPAD(' ',4,' ')||l_person_num ;
507: FETCH cur_get_loans INTO l_loan_rec;
508: CLOSE cur_get_loans;
509:
510: IF l_loan_rec.student_id IS NOT NULL THEN
511: l_ret:=igf_gr_gen.get_per_num(l_loan_rec.student_id,l_stud_number);
512: END IF;
513:
514: --Fetch details of student
515: igf_sl_gen.get_person_details(r_stafford_det.student_id,student_dtl_cur);
603: l_parent_number:=NULL;
604:
605: --Get Student Person Number
606: IF l_loan_rec.student_id IS NOT NULL THEN
607: l_ret:=igf_gr_gen.get_per_num(l_loan_rec.student_id,l_stud_number);
608: END IF;
609:
610: --Get Parent Person Number
611: IF l_loan_rec.p_person_id IS NOT NULL THEN
608: END IF;
609:
610: --Get Parent Person Number
611: IF l_loan_rec.p_person_id IS NOT NULL THEN
612: l_ret:=igf_gr_gen.get_per_num(l_loan_rec.p_person_id,l_parent_number);
613: END IF;
614:
615: --Fetch details of student and parent
616: igf_sl_gen.get_person_details(r_plus_det.student_id,student_dtl_cur);