APPS.IGF_SL_DL_CHG_ORIG dependencies on IGF_SL_DL_BATCH

Line 62: p_dl_dbth_id igf_sl_dl_batch.dbth_id%TYPE,

58: --
59: -- ## Forward Declaration of Trans_rec Procedure
60:
61: PROCEDURE Trans_Rec( p_dl_version igf_lookups_view.lookup_code%TYPE,
62: p_dl_dbth_id igf_sl_dl_batch.dbth_id%TYPE,
63: p_dl_batch_id igf_sl_dl_batch.batch_id%TYPE,
64: p_tot_rec_count IN OUT NOCOPY NUMBER);
65:
66: PROCEDURE chg_originate(errbuf OUT NOCOPY VARCHAR2,

Line 63: p_dl_batch_id igf_sl_dl_batch.batch_id%TYPE,

59: -- ## Forward Declaration of Trans_rec Procedure
60:
61: PROCEDURE Trans_Rec( p_dl_version igf_lookups_view.lookup_code%TYPE,
62: p_dl_dbth_id igf_sl_dl_batch.dbth_id%TYPE,
63: p_dl_batch_id igf_sl_dl_batch.batch_id%TYPE,
64: p_tot_rec_count IN OUT NOCOPY NUMBER);
65:
66: PROCEDURE chg_originate(errbuf OUT NOCOPY VARCHAR2,
67: retcode OUT NOCOPY NUMBER,

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

100:
101: lv_cal_type igs_ca_inst.cal_type%TYPE; -- ## Used for the award year ##
102: lv_cal_seq_num igs_ca_inst.sequence_number%TYPE; -- ## Both cal_seq_num and cal_type forms the award year ##
103: lv_dl_version igf_lookups_view.lookup_code%TYPE; -- ## Variable for the storing the version number ##
104: lv_batch_id igf_sl_dl_batch.batch_id%TYPE; -- ## Variable to have the batch ID ##
105: lv_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
106: lv_mesg_class igf_sl_dl_batch.message_class%TYPE;
107: lv_begin_date igf_sl_lor_loc.acad_yr_begin_date %TYPE; -- ## Variable to have the academic begin date ##
108: lv_end_date igf_sl_lor_loc.acad_yr_end_date%TYPE; -- ## Variable to have the academic end date ##

Line 105: lv_dbth_id igf_sl_dl_batch.dbth_id%TYPE;

101: lv_cal_type igs_ca_inst.cal_type%TYPE; -- ## Used for the award year ##
102: lv_cal_seq_num igs_ca_inst.sequence_number%TYPE; -- ## Both cal_seq_num and cal_type forms the award year ##
103: lv_dl_version igf_lookups_view.lookup_code%TYPE; -- ## Variable for the storing the version number ##
104: lv_batch_id igf_sl_dl_batch.batch_id%TYPE; -- ## Variable to have the batch ID ##
105: lv_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
106: lv_mesg_class igf_sl_dl_batch.message_class%TYPE;
107: lv_begin_date igf_sl_lor_loc.acad_yr_begin_date %TYPE; -- ## Variable to have the academic begin date ##
108: lv_end_date igf_sl_lor_loc.acad_yr_end_date%TYPE; -- ## Variable to have the academic end date ##
109:

Line 106: lv_mesg_class igf_sl_dl_batch.message_class%TYPE;

102: lv_cal_seq_num igs_ca_inst.sequence_number%TYPE; -- ## Both cal_seq_num and cal_type forms the award year ##
103: lv_dl_version igf_lookups_view.lookup_code%TYPE; -- ## Variable for the storing the version number ##
104: lv_batch_id igf_sl_dl_batch.batch_id%TYPE; -- ## Variable to have the batch ID ##
105: lv_dbth_id igf_sl_dl_batch.dbth_id%TYPE;
106: lv_mesg_class igf_sl_dl_batch.message_class%TYPE;
107: lv_begin_date igf_sl_lor_loc.acad_yr_begin_date %TYPE; -- ## Variable to have the academic begin date ##
108: lv_end_date igf_sl_lor_loc.acad_yr_end_date%TYPE; -- ## Variable to have the academic end date ##
109:
110: --Bug No:2332668

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

437: Header Record specifications, for each Direct Loan Version
438: is specified in the igf_sl_dl_record.DLHeader_cur procedure.
439: By calling this procedure, the following are done
440: 1. Computes Batch ID
441: 2. Inserts the Batch ID details in igf_sl_dl_batch
442: 3. For the specified version, Opens a REF CURSOR, having
443: header file Specs.
444: Since the Batch-Type and File-Specifications are same for STAFFORD
445: and PLUS, we are passing Loan_catg='DL' and File-Type='DL_CHG_SEND'

Line 1050: -- We need to do a rollback as we would have inserted into IGF_SL_DL_BATCH

1046: -- Write the Trailer Record into the Output file.
1047: fnd_file.put_line(FND_FILE.OUTPUT, lv_data_record);
1048:
1049: ELSE
1050: -- We need to do a rollback as we would have inserted into IGF_SL_DL_BATCH
1051: -- table while calling igf_sl_dl_record.DLHeader_cur.
1052: ROLLBACK;
1053: END IF;
1054:

Line 1098: p_dl_dbth_id igf_sl_dl_batch.dbth_id%TYPE,

1094:
1095:
1096:
1097: PROCEDURE Trans_Rec( p_dl_version igf_lookups_view.lookup_code%TYPE,
1098: p_dl_dbth_id igf_sl_dl_batch.dbth_id%TYPE,
1099: p_dl_batch_id igf_sl_dl_batch.batch_id%TYPE,
1100: p_tot_rec_count IN OUT NOCOPY NUMBER)
1101: AS
1102: /*************************************************************

Line 1099: p_dl_batch_id igf_sl_dl_batch.batch_id%TYPE,

1095:
1096:
1097: PROCEDURE Trans_Rec( p_dl_version igf_lookups_view.lookup_code%TYPE,
1098: p_dl_dbth_id igf_sl_dl_batch.dbth_id%TYPE,
1099: p_dl_batch_id igf_sl_dl_batch.batch_id%TYPE,
1100: p_tot_rec_count IN OUT NOCOPY NUMBER)
1101: AS
1102: /*************************************************************
1103: Created By : prchandr