eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_SL_DL_PRINT_PNOTE dependencies on IGF_SL_GEN

Line 34: 3.the borrower info is now derived using igf_sl_gen.get_person_details procedure

30: chg_batch_id,appl_send_error_codes from igf_sl_lor
31: veramach 16-SEP-2003 FA 122 loan enhancements build
32: 1.Added update_pnote_status method
33: 2.Changed cursors c_stafford_det and c_plus_det to remove references of igf_sl_plus_borw.
34: 3.the borrower info is now derived using igf_sl_gen.get_person_details procedure
35: Bug :- 2426609 SSN Format Incorrect in Output File
36: mesriniv 25-jun-2002 Code has been added inorder to handle the if No Data is fetched by the
37: Parent Details and Student Details Cursors and skip the records.
38: Change History :

Line 71: 2.the borrower info is now derived using igf_sl_gen.get_person_details procedure

67: Change History :
68: Who When What
69: veramach 16-SEP-2003 FA 122 loan enhancements build
70: 1.Changed cursors c_stafford_det and c_plus_det to remove references of igf_sl_plus_borw.
71: 2.the borrower info is now derived using igf_sl_gen.get_person_details procedure
72: 3.changed c_dl_orig_recs cursor -added 2 where clauses on ci_cal_type and ci_sequence_number and
73: changed the signature to take lookup_type and pnote_status as arguments
74:
75: masehgal 19-Feb-2002 # 2216956 FACR007

Line 79: student_dtl_rec igf_sl_gen.person_dtl_rec;

75: masehgal 19-Feb-2002 # 2216956 FACR007
76: Added Elec_mpn_ind , Borr_sign_ind in igf_sl_lor_pkg
77: ****************************************************************/
78:
79: student_dtl_rec igf_sl_gen.person_dtl_rec;
80: student_dtl_cur igf_sl_gen.person_dtl_cur;
81:
82: parent_dtl_rec igf_sl_gen.person_dtl_rec;
83: parent_dtl_cur igf_sl_gen.person_dtl_cur;

Line 80: student_dtl_cur igf_sl_gen.person_dtl_cur;

76: Added Elec_mpn_ind , Borr_sign_ind in igf_sl_lor_pkg
77: ****************************************************************/
78:
79: student_dtl_rec igf_sl_gen.person_dtl_rec;
80: student_dtl_cur igf_sl_gen.person_dtl_cur;
81:
82: parent_dtl_rec igf_sl_gen.person_dtl_rec;
83: parent_dtl_cur igf_sl_gen.person_dtl_cur;
84:

Line 82: parent_dtl_rec igf_sl_gen.person_dtl_rec;

78:
79: student_dtl_rec igf_sl_gen.person_dtl_rec;
80: student_dtl_cur igf_sl_gen.person_dtl_cur;
81:
82: parent_dtl_rec igf_sl_gen.person_dtl_rec;
83: parent_dtl_cur igf_sl_gen.person_dtl_cur;
84:
85: l_debug_str fnd_log_messages.message_text%TYPE;
86:

Line 83: parent_dtl_cur igf_sl_gen.person_dtl_cur;

79: student_dtl_rec igf_sl_gen.person_dtl_rec;
80: student_dtl_cur igf_sl_gen.person_dtl_cur;
81:
82: parent_dtl_rec igf_sl_gen.person_dtl_rec;
83: parent_dtl_cur igf_sl_gen.person_dtl_cur;
84:
85: l_debug_str fnd_log_messages.message_text%TYPE;
86:
87: CURSOR c_pnote_check( x_ci_cal_type igf_sl_dl_setup.ci_cal_type%TYPE,

Line 515: igf_sl_gen.get_person_details(r_stafford_det.student_id,student_dtl_cur);

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);
516: FETCH student_dtl_cur INTO student_dtl_rec;
517:
518: IF student_dtl_rec.p_permt_addr1 IS NULL THEN
519:

Line 532: l_person_phone := igf_sl_gen.get_person_phone( r_stafford_det.student_id );

528:
529: END IF;
530:
531: /* Get phone details */
532: l_person_phone := igf_sl_gen.get_person_phone( r_stafford_det.student_id );
533:
534: IF l_batch_seq_num IS NULL THEN
535: SELECT igf_sl_dl_pnote_bth_s.nextval INTO l_batch_seq_num FROM dual;
536: END IF;

Line 616: igf_sl_gen.get_person_details(r_plus_det.student_id,student_dtl_cur);

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);
617: FETCH student_dtl_cur INTO student_dtl_rec;
618:
619: igf_sl_gen.get_person_details(r_plus_det.p_person_id,parent_dtl_cur);
620: FETCH parent_dtl_cur INTO parent_dtl_rec;

Line 619: igf_sl_gen.get_person_details(r_plus_det.p_person_id,parent_dtl_cur);

615: --Fetch details of student and parent
616: igf_sl_gen.get_person_details(r_plus_det.student_id,student_dtl_cur);
617: FETCH student_dtl_cur INTO student_dtl_rec;
618:
619: igf_sl_gen.get_person_details(r_plus_det.p_person_id,parent_dtl_cur);
620: FETCH parent_dtl_cur INTO parent_dtl_rec;
621:
622:
623: IF student_dtl_rec.p_permt_addr1 IS NULL OR parent_dtl_rec.p_permt_addr1 IS NULL THEN

Line 637: l_person_phone := igf_sl_gen.get_person_phone( r_plus_det.student_id ) ;

633: END IF;
634:
635:
636: /* Get phone details */
637: l_person_phone := igf_sl_gen.get_person_phone( r_plus_det.student_id ) ;
638: l_parent_phone := igf_sl_gen.get_person_phone( r_plus_det.p_person_id );
639:
640:
641: IF l_batch_seq_num IS NULL THEN

Line 638: l_parent_phone := igf_sl_gen.get_person_phone( r_plus_det.p_person_id );

634:
635:
636: /* Get phone details */
637: l_person_phone := igf_sl_gen.get_person_phone( r_plus_det.student_id ) ;
638: l_parent_phone := igf_sl_gen.get_person_phone( r_plus_det.p_person_id );
639:
640:
641: IF l_batch_seq_num IS NULL THEN
642: SELECT igf_sl_dl_pnote_bth_s.nextval INTO l_batch_seq_num FROM dual;