APPS.IGF_DB_DL_DISB_ORIG dependencies on IGF_SL_DL_BATCH

Line 37: p_dl_batch_id igf_sl_dl_batch.batch_id%TYPE,

33:
34: lv_data_record VARCHAR2(4000); -- ## Variable to store the concatenated value to be stored in file ##
35:
36: PROCEDURE Trans_Rec( p_dl_version igf_lookups_view.lookup_code%TYPE,
37: p_dl_batch_id igf_sl_dl_batch.batch_id%TYPE,
38: p_Rec_count IN OUT NOCOPY NUMBER,
39: p_ci_cal_type igf_sl_dl_setup.ci_cal_type%TYPE,
40: p_ci_sequence_number igf_sl_dl_setup.ci_sequence_number%TYPE,
41: p_school_code IN VARCHAR2

Line 84: lv_batch_id igf_sl_dl_batch.batch_id%TYPE; -- ## Variable to have the batch ID ##

80: l_cod_year_flag BOOLEAN;
81: lv_cal_type igs_ca_inst.cal_type%TYPE; -- ## Used for the award year ##
82: lv_cal_seq_num igs_ca_inst.sequence_number%TYPE; -- ## Both cal_seq_num and cal_type forms the award year ##
83: lv_dl_version igf_lookups_view.lookup_code%TYPE; -- ## Variable for the storing the version number ##
84: lv_batch_id igf_sl_dl_batch.batch_id%TYPE; -- ## Variable to have the batch ID ##
85: lv_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
86: lv_mesg_class igf_sl_dl_batch.message_class%TYPE;
87:
88: -- ## REF Cursor Record Types.

Line 85: lv_dbth_id igf_sl_dl_batch.dbth_id%TYPE;

81: lv_cal_type igs_ca_inst.cal_type%TYPE; -- ## Used for the award year ##
82: lv_cal_seq_num igs_ca_inst.sequence_number%TYPE; -- ## Both cal_seq_num and cal_type forms the award year ##
83: lv_dl_version igf_lookups_view.lookup_code%TYPE; -- ## Variable for the storing the version number ##
84: lv_batch_id igf_sl_dl_batch.batch_id%TYPE; -- ## Variable to have the batch ID ##
85: lv_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
86: lv_mesg_class igf_sl_dl_batch.message_class%TYPE;
87:
88: -- ## REF Cursor Record Types.
89:

Line 86: lv_mesg_class igf_sl_dl_batch.message_class%TYPE;

82: lv_cal_seq_num igs_ca_inst.sequence_number%TYPE; -- ## Both cal_seq_num and cal_type forms the award year ##
83: lv_dl_version igf_lookups_view.lookup_code%TYPE; -- ## Variable for the storing the version number ##
84: lv_batch_id igf_sl_dl_batch.batch_id%TYPE; -- ## Variable to have the batch ID ##
85: lv_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
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;

Line 197: 2. Inserts the Batch ID details in igf_sl_dl_batch

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
199: header file Specs.
200: *************************************************************************/
201:

Line 298: p_dl_batch_id igf_sl_dl_batch.batch_id%TYPE,

294: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
295: END disb_originate;
296:
297: PROCEDURE trans_rec( p_dl_version igf_lookups_view.lookup_code%TYPE,
298: p_dl_batch_id igf_sl_dl_batch.batch_id%TYPE,
299: p_rec_count IN OUT NOCOPY NUMBER,
300: p_ci_cal_type igf_sl_dl_setup.ci_cal_type%TYPE,
301: p_ci_sequence_number igf_sl_dl_setup.ci_sequence_number%TYPE,
302: p_school_code IN VARCHAR2 )