DBA Data[Home] [Help]

APPS.IGF_SL_DL_ORIG dependencies on IGF_SL_DL_BATCH

Line 128: lv_dbth_id igf_sl_dl_batch.dbth_id%TYPE;

124: --
125: lv_cal_type igs_ca_inst.cal_type%TYPE;
126: lv_cal_seq_num igs_ca_inst.sequence_number%TYPE;
127: lv_dl_version igf_lookups_view.lookup_code%TYPE;
128: lv_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
129: lv_batch_id igf_sl_dl_batch.batch_id%TYPE;
130: lv_mesg_class igf_sl_dl_batch.message_class%TYPE;
131:
132: lv_data_record VARCHAR2(4000);

Line 129: lv_batch_id igf_sl_dl_batch.batch_id%TYPE;

125: lv_cal_type igs_ca_inst.cal_type%TYPE;
126: lv_cal_seq_num igs_ca_inst.sequence_number%TYPE;
127: lv_dl_version igf_lookups_view.lookup_code%TYPE;
128: lv_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
129: lv_batch_id igf_sl_dl_batch.batch_id%TYPE;
130: lv_mesg_class igf_sl_dl_batch.message_class%TYPE;
131:
132: lv_data_record VARCHAR2(4000);
133: lv_data_header_record VARCHAR2(4000);

Line 130: lv_mesg_class igf_sl_dl_batch.message_class%TYPE;

126: lv_cal_seq_num igs_ca_inst.sequence_number%TYPE;
127: lv_dl_version igf_lookups_view.lookup_code%TYPE;
128: lv_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
129: lv_batch_id igf_sl_dl_batch.batch_id%TYPE;
130: lv_mesg_class igf_sl_dl_batch.message_class%TYPE;
131:
132: lv_data_record VARCHAR2(4000);
133: lv_data_header_record VARCHAR2(4000);
134:

Line 362: -- 2. Inserts the Batch ID details in igf_sl_dl_batch

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
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,