APPS.IGF_DB_DL_DISB_ORIG dependencies on IGF_SL_DL_RECORD

Line 64: procedures igf_sl_dl_record.DLHeader_cur and Trans_Rec.

60: filter only the loans having the school id matched with parameter p_school_code.
61: ugummall 17-OCT-2003 Bug 3102439. FA 126 Multiple FA Offices.
62: 1. Added two new parameters
63: 2. p_school_code parameter is passed as extra parameter to
64: procedures igf_sl_dl_record.DLHeader_cur and Trans_Rec.
65: 3. Logic is changed so that header and trailer are written to the
66: output file only when at least one record is processed.
67: Bug :2383350 Loan Cancellation
68: Who When What

Line 90: Header_Rec igf_sl_dl_record.DLHeaderType;

86: lv_mesg_class igf_sl_dl_batch.message_class%TYPE;
87:
88: -- ## REF Cursor Record Types.
89:
90: Header_Rec igf_sl_dl_record.DLHeaderType;
91: Trailer_Rec igf_sl_dl_record.DLTrailerType;
92:
93: lv_dl_loan_catg igf_lookups_view.lookup_code%TYPE;
94: p_rec_count NUMBER := 0;

Line 91: Trailer_Rec igf_sl_dl_record.DLTrailerType;

87:
88: -- ## REF Cursor Record Types.
89:
90: Header_Rec igf_sl_dl_record.DLHeaderType;
91: Trailer_Rec igf_sl_dl_record.DLTrailerType;
92:
93: lv_dl_loan_catg igf_lookups_view.lookup_code%TYPE;
94: p_rec_count NUMBER := 0;
95:

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

190:
191: /************************************************************************
192: Using REF CURSORS.
193: Header Record specifications, for each Direct Loan Version
194: is specified in the igf_sl_dl_record.DLHeader_cur procedure.
195: By calling this procedure, the following are done
196: 1. Computes Batch ID
197: 2. Inserts the Batch ID details in igf_sl_dl_batch
198: 3. For the specified version, Opens a REF CURSOR, having

Line 215: igf_sl_dl_record.DLHeader_cur(lv_dl_version,

211: RAISE no_disb_data;
212: END IF;
213:
214: lv_dl_loan_catg := 'DL';
215: igf_sl_dl_record.DLHeader_cur(lv_dl_version,
216: lv_dl_loan_catg,
217: lv_cal_type,
218: lv_cal_seq_num,
219: 'DL_DISB_SEND',

Line 256: igf_sl_dl_record.DLTrailer_cur(lv_dl_version, p_Rec_count,Trailer_Rec);

252:
253: -- process the trailer record only if atleast one transaction record has been processed
254: IF(p_Rec_count > 0)THEN
255: -- Write the Trailer Record
256: igf_sl_dl_record.DLTrailer_cur(lv_dl_version, p_Rec_count,Trailer_Rec);
257: FETCH Trailer_Rec into lv_data_record;
258: IF Trailer_Rec%NOTFOUND THEN
259: fnd_message.set_name ('IGF', 'IGF_GE_TRL_CREATE_ERROR');
260: igs_ge_msg_stack.add;