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

Line 155: Header_Rec igf_sl_dl_record.DLHeaderType;

151: l_para_rec l_parameters;
152:
153:
154: -- REF Cursor Record Types.
155: Header_Rec igf_sl_dl_record.DLHeaderType;
156: Orig_Rec igf_sl_dl_record.DLOrigType;
157: Trailer_Rec igf_sl_dl_record.DLTrailerType;
158:
159:

Line 156: Orig_Rec igf_sl_dl_record.DLOrigType;

152:
153:
154: -- REF Cursor Record Types.
155: Header_Rec igf_sl_dl_record.DLHeaderType;
156: Orig_Rec igf_sl_dl_record.DLOrigType;
157: Trailer_Rec igf_sl_dl_record.DLTrailerType;
158:
159:
160: lv_loan_id igf_sl_loans.loan_id%TYPE;

Line 157: Trailer_Rec igf_sl_dl_record.DLTrailerType;

153:
154: -- REF Cursor Record Types.
155: Header_Rec igf_sl_dl_record.DLHeaderType;
156: Orig_Rec igf_sl_dl_record.DLOrigType;
157: Trailer_Rec igf_sl_dl_record.DLTrailerType;
158:
159:
160: lv_loan_id igf_sl_loans.loan_id%TYPE;
161: lv_bool BOOLEAN;

Line 359: -- is specified in the igf_sl_dl_record.DLHeader_cur procedure.

355:
356:
357: -- Using REF CURSORS.
358: -- Header Record specifications, for each Direct Loan Version
359: -- is specified in the igf_sl_dl_record.DLHeader_cur procedure.
360: -- By calling this procedure, the following are done
361: -- 1. Computes Batch ID
362: -- 2. Inserts the Batch ID details in igf_sl_dl_batch
363: -- 3. For the specified version, Opens a REF CURSOR, having

Line 365: igf_sl_dl_record.DLHeader_cur(lv_dl_version, p_dl_loan_catg,

361: -- 1. Computes Batch ID
362: -- 2. Inserts the Batch ID details in igf_sl_dl_batch
363: -- 3. For the specified version, Opens a REF CURSOR, having
364: -- header file Specs.
365: igf_sl_dl_record.DLHeader_cur(lv_dl_version, p_dl_loan_catg,
366: lv_cal_type, lv_cal_seq_num, 'DL_ORIG_SEND', p_school_code,
367: lv_dbth_id, lv_batch_id, lv_mesg_class, Header_Rec);
368: FETCH Header_Rec into lv_data_header_record;
369: IF Header_Rec%NOTFOUND THEN

Line 377: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_orig.dl_originate.debug','loan_number passed to igf_sl_dl_record.get_acad_cal_dtls:'|| p_loan_number);

373: END IF;
374:
375: -- FA 122 Debug log messages
376: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
377: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_orig.dl_originate.debug','loan_number passed to igf_sl_dl_record.get_acad_cal_dtls:'|| p_loan_number);
378: END IF;
379: -- Get Academic Dates for the Award Year.
380: -- masehgal # 2593215 removed begin/end dates fetching functions
381: -- used procedure get_acad_cal_dtls instead

Line 382: igf_sl_dl_record.get_acad_cal_dtls ( p_loan_number,

378: END IF;
379: -- Get Academic Dates for the Award Year.
380: -- masehgal # 2593215 removed begin/end dates fetching functions
381: -- used procedure get_acad_cal_dtls instead
382: igf_sl_dl_record.get_acad_cal_dtls ( p_loan_number,
383: lv_acad_cal_type,
384: lv_acad_seq_num,
385: lv_acad_begin_dt,
386: lv_acad_end_dt,

Line 389: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_orig.dl_originate.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);

385: lv_acad_begin_dt,
386: lv_acad_end_dt,
387: lv_message ) ;
388: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
389: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_orig.dl_originate.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);
390: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_orig.dl_originate.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_dt);
391: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_orig.dl_originate.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_end_dt);
392: END IF;
393:

Line 390: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_orig.dl_originate.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_dt);

386: lv_acad_end_dt,
387: lv_message ) ;
388: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
389: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_orig.dl_originate.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);
390: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_orig.dl_originate.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_dt);
391: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_orig.dl_originate.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_end_dt);
392: END IF;
393:
394: -- Opening REF Cursor for Transaction Record specification

Line 391: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_orig.dl_originate.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_end_dt);

387: lv_message ) ;
388: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
389: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_orig.dl_originate.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);
390: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_orig.dl_originate.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_dt);
391: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_orig.dl_originate.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_end_dt);
392: END IF;
393:
394: -- Opening REF Cursor for Transaction Record specification
395:

Line 407: igf_sl_dl_record.DLOrig_cur(lv_dl_version, p_dl_loan_catg,

403:
404: FOR loan_details_rec IN cur_loan_details(lv_cal_type,lv_cal_seq_num,l_fed_fund_1,l_fed_fund_2,'V','Y',p_loan_number)
405: LOOP
406:
407: igf_sl_dl_record.DLOrig_cur(lv_dl_version, p_dl_loan_catg,
408: lv_cal_type, lv_cal_seq_num, loan_details_rec.loan_number,
409: lv_batch_id, p_school_code, Orig_Rec);
410: LOOP
411: -- Initialise the Data Record field

Line 1095: igf_sl_dl_record.DLTrailer_cur(lv_dl_version, lv_num_of_rec, Trailer_Rec);

1091: -- Initialise the Data Record field
1092: lv_data_record := NULL;
1093: IF(lv_num_of_rec > 0)THEN
1094: -- Write the Trailer Record
1095: igf_sl_dl_record.DLTrailer_cur(lv_dl_version, lv_num_of_rec, Trailer_Rec);
1096: FETCH Trailer_Rec into lv_data_record;
1097: IF Header_Rec%NOTFOUND THEN
1098: fnd_message.set_name ('IGF', 'IGF_GE_TRL_CREATE_ERROR');
1099: igs_ge_msg_stack.add;