APPS.IGF_DB_DL_DISB_ORIG dependencies on IGF_LOOKUPS_VIEW

Line 36: PROCEDURE Trans_Rec( p_dl_version igf_lookups_view.lookup_code%TYPE,

32: -- ## Forward Declaration of Trans_rec Procedure
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,

Line 83: lv_dl_version igf_lookups_view.lookup_code%TYPE; -- ## Variable for the storing the version number ##

79:
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:

Line 93: lv_dl_loan_catg igf_lookups_view.lookup_code%TYPE;

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:
96: no_disb_data EXCEPTION; -- ## User Define Exception to check if any records to Originate.
97:

Line 297: PROCEDURE trans_rec( p_dl_version igf_lookups_view.lookup_code%TYPE,

293: fnd_file.put_line(fnd_file.log,SQLERRM);
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,