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_CHG_ORIG dependencies on IGF_SL_DL_RECORD

Line 132: Header_Rec igf_sl_dl_record.DLHeaderType;

128: lv_loan_number igf_sl_dl_chg_send.loan_number%TYPE;
129:
130: -- ## REF Cursor Record Types.
131:
132: Header_Rec igf_sl_dl_record.DLHeaderType;
133: Trailer_Rec igf_sl_dl_record.DLTrailerType;
134:
135: lv_bool BOOLEAN;
136: l_disb BOOLEAN := TRUE; -- ## Variable for disbursement calculations

Line 133: Trailer_Rec igf_sl_dl_record.DLTrailerType;

129:
130: -- ## REF Cursor Record Types.
131:
132: Header_Rec igf_sl_dl_record.DLHeaderType;
133: Trailer_Rec igf_sl_dl_record.DLTrailerType;
134:
135: lv_bool BOOLEAN;
136: l_disb BOOLEAN := TRUE; -- ## Variable for disbursement calculations
137: l_disb_loc BOOLEAN := FALSE; -- ## Variable for disbursement calculations

Line 438: is specified in the igf_sl_dl_record.DLHeader_cur procedure.

434:
435: /************************************************************************
436: Using REF CURSORS.
437: Header Record specifications, for each Direct Loan Version
438: is specified in the igf_sl_dl_record.DLHeader_cur procedure.
439: By calling this procedure, the following are done
440: 1. Computes Batch ID
441: 2. Inserts the Batch ID details in igf_sl_dl_batch
442: 3. For the specified version, Opens a REF CURSOR, having

Line 449: igf_sl_dl_record.DLHeader_cur(lv_dl_version, 'DL',

445: and PLUS, we are passing Loan_catg='DL' and File-Type='DL_CHG_SEND'
446: to DLHeader_Cur(). (Maintaining only 1 record in igf_sl_dl_file_type Seed table)
447: *************************************************************************/
448:
449: igf_sl_dl_record.DLHeader_cur(lv_dl_version, 'DL',
450: lv_cal_type, lv_cal_seq_num, 'DL_CHG_SEND', p_school_code,
451: lv_dbth_id, lv_batch_id, lv_mesg_class, Header_Rec);
452: FETCH Header_Rec into lv_data_record;
453:

Line 527: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_chg_orig.chg_originate.debug','loan_number passed to igf_sl_dl_record.get_acad_cal_dtls:'|| lc_lor.loan_number);

523:
524: -- PUT THE DEBUGGING LOG MESSAGES
525:
526: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
527: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_chg_orig.chg_originate.debug','loan_number passed to igf_sl_dl_record.get_acad_cal_dtls:'|| lc_lor.loan_number);
528: END IF;
529: l_loan_number := lc_lor.loan_number ;
530: -- To get the academic begin and end dates.
531: -- masehgal # 2593215 removed begin/end dates fetching functions

Line 533: igf_sl_dl_record.get_acad_cal_dtls ( l_loan_number,

529: l_loan_number := lc_lor.loan_number ;
530: -- To get the academic begin and end dates.
531: -- masehgal # 2593215 removed begin/end dates fetching functions
532: -- used procedure get_acad_cal_dtls instead
533: igf_sl_dl_record.get_acad_cal_dtls ( l_loan_number,
534: lv_acad_cal_type,
535: lv_acad_seq_num,
536: lv_begin_date,
537: lv_end_date,

Line 542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_chg_orig.chg_originate.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);

538: lv_message ) ;
539:
540:
541: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_chg_orig.chg_originate.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);
543: END IF;
544: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
545: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_chg_orig.chg_originate.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_begin_date);
546: END IF;

Line 545: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_chg_orig.chg_originate.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_begin_date);

541: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_chg_orig.chg_originate.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);
543: END IF;
544: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
545: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_chg_orig.chg_originate.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_begin_date);
546: END IF;
547: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
548: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_chg_orig.chg_originate.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_end_date);
549: END IF;

Line 548: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_chg_orig.chg_originate.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_end_date);

544: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
545: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_chg_orig.chg_originate.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_begin_date);
546: END IF;
547: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
548: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_chg_orig.chg_originate.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_end_date);
549: END IF;
550: -- ## The If conditions checks if it is Plus records and else the Stafford records
551:
552: lc_chg_flag := 'N';

Line 1038: igf_sl_dl_record.DLTrailer_cur(lv_dl_version, p_tot_rec_count, Trailer_Rec);

1034: -- Initialise the Data Record field
1035: lv_data_record := NULL;
1036:
1037: -- Write the Trailer Record
1038: igf_sl_dl_record.DLTrailer_cur(lv_dl_version, p_tot_rec_count, Trailer_Rec);
1039: FETCH Trailer_Rec into lv_data_record;
1040: IF Trailer_Rec%NOTFOUND THEN
1041: fnd_message.set_name ('IGF', 'IGF_GE_TRL_CREATE_ERROR');
1042: igs_ge_msg_stack.add;

Line 1051: -- table while calling igf_sl_dl_record.DLHeader_cur.

1047: fnd_file.put_line(FND_FILE.OUTPUT, lv_data_record);
1048:
1049: ELSE
1050: -- We need to do a rollback as we would have inserted into IGF_SL_DL_BATCH
1051: -- table while calling igf_sl_dl_record.DLHeader_cur.
1052: ROLLBACK;
1053: END IF;
1054:
1055: --Display a message if No Loan Change Origination